
Edward De Guzman
- Business Intelligence/ BI Analyst
- New York City, NY
- Member Since Mar 17, 2023
Edward De Guzman
Completing Master of Science in Data Analytics at National University.
Analytics, Machine-Learning, Internet of Things, & Artificial Intelligence enthusiast.
Data Warehouse & Business Intelligence and Software Design & Development by craft.
Business & Data Analysis, Applications Implementations, and Management of Information Systems Specialist.
Countries Worked: USA, Canada, Philippines, Singapore, Australia, Japan, and Thailand
Companies:
I.T. Applications Manager
Developed and manages highly competitive teams of both technical and business resources (combined In-House Resources and Delivery Partners). Oversees Organization-Level Software Development projects including Support and Maintenance using Agile & I.T.I.L. Methodologies. Responsible for building and implementing “Enterprise Data Warehouse” and “Business Intelligence” for the organization. Currently implementing Big Data (for near-real time information) and Analytics (including Self-Service BI). Designed cloud architecture of Data Lake and Business Intelligence integration including data ingestions and preparation from On-Premise & 3rd-party apps using API to Data Lake for data visualization and exploration. Manages Enterprise Applications, Data Feed and Electronic Data Interchange to various business partners, and other business and technology innovations of the company. Delivered methods, tools, and technology stack for business needs and processes.
Business Intelligence Analyst
Developed numerous Business Intelligence solutions to TELUS’ clients both in US and Canada using IBM Cognos and other leading BI Solutions. Supported and maintained several applications (Technical and Business level) such as EPICOR and other in-house developed applications by TELUS’ clients. Designed and developed multiple ETL processes for data mart/warehouse Online Analytical Processing (Star-Schema & Denormalization processes).
Special Projects, Quality, R&D Software Manager
Developed and managed 3 major departments that are critical to the success of each software development teams as well as the entire organization. Created and implemented SDLC Methodology adopting Michelin’s Global Business Standards and Processes. Ensured that all software/applications developed and produced by the company for all regional customers are above quality, within budget, & delivered on time including validation and verification of Industrialization Process (Michelin internal process of ensuring that software & applications will function on multiple languages – localization & internationalization).
ERP/Applications Consultant
Implemented and supported multiple ERP Applications (BPCS, MOVEX, SCALA) to large and global organizations and multiple industries such as manufacturing, pharmaceutical, automotive, apparel, and food industries. Conducted Business Process Implementation, Software Analysis & Design including Development, User Trainings, Project Management, and Post-Implementation Support. Provided process improvement strategies to these organizations.
Educations
M.S. in Data Analytics 2016 – expected completion in 2018
National University (http://www.nu.edu/)
B.S. in Computer Science 1991 – 1995
AMA Computer University (http://www.ama.edu.ph)
Certifications
Scrum Master & Scrum Product Owner 2016
International Scrum Institute (http://www.scrum-institute.org)
Scrum Master Certificate ID: 58689659130759
Scrum Product Owner Certificate ID: 8689659130759
Skills
Methodologies & Management
Scrum Framework, System Development Life Cycle, Project Management, Enterprise Application / Software Design and Development, Data Warehouse and Business Intelligence, Database Design (OLTP & OLAP), Analytics, Big Data, Mobile Applications UX Design, ERP Applications Management, Software Quality Assurance, I.T.I.L. (Infrastructure Technology Infrastructure Library), CMMi, and Data Mining Techniques.
Technical
DATA: Teradata, MS SQL Server, Oracle, Hadoop - Hortonworks, SQL Server Integration Services
BI/Analytics: SAS (Linear and Logistics Regression), SAP Business Objects & Crystal Report, Microsoft SQL Server Analytical Services, Microstrategy, IBM Cognos, Microsoft SQL Server Reporting Services,
ETL: Microsoft SQL Server Integration Services, Advanced SQL Server Programming
Applications Development:
Mobile Applications: Swift Programming, Android Studio
Front/Back End Applications: PHP, Perl, SQL Server Analysis Services, SQL Script/Programming, Visual Studio C#, Python, Web Services & API designs, Data Integration, and Web & Client-Server design
Platforms: Windows, MAC OS, Linux, On-Premise and Cloud (AWS) Infrastructure