BI & Analytics Consultant
DBM Global
(Architecture and civil engineering, 500-1000 employees)
Keywords
Skills
SQL, MDX, PL/SQL, Python, C#, REST API (in progress), ERP, CRM, Oracle, SQL Server, DB2*, MySQL, Netezza, Paradox, Teradata, ETL, AB Initio, BO Data Integrator, DataGateway, DataStage*, DTS, Microsoft SSIS, IBM Cognos, MicroStrategy, Microsoft SSAS, Microsoft SSRS, Tableau, Power BI, OS, AIX, Linux, Windows, Project Management, Waterfall, Incremental, Agile, Scrum, Kanban, Analytics, DBM, ServiceNow, SAP, SSIS, Azure, DB2, DataStage, Mainframe, Cobol, IBM, Cognos, Hyperion, data warehouse, SSRS, SSAS, Datamart
Project history
10/2019
-
07/2020
Projects. ServiceNow; KanbanZone, SAP Concur, Deerwalk Health Management;
Technologies. SSIS, SQL Server, Power BI, Tableau, Azure.
- Architecting BI solutions by offering the best approach to deliver a better Reporting service under the current best practices.
- Identifying root causes and corrective actions to meet short and long-term business goals.
- Requirement analysis, KPI definition and project management.
Technologies. SSIS, SQL Server, Power BI, Tableau, Azure.
- Architecting BI solutions by offering the best approach to deliver a better Reporting service under the current best practices.
- Identifying root causes and corrective actions to meet short and long-term business goals.
- Requirement analysis, KPI definition and project management.
01/2014
-
09/2019
Business Analyst - Solution Design
Wipro Technologies
(Internet and Information Technology, 500-1000 employees)
Projects. Genesis at Citi Bank; Unique ID at CitiBanamex; KYC at CitiBanamex; AML at CitiBanamex.
Technologies. DB2, Teradata, DataStage, Ab Initio, Mainframe, Cobol.
- Analyzed financial data to identify relationship between operations and banking product trends.
- Became a Subject Matter Expert of AML (Anti-Money Laundering) and KYC (Know Your Customer) processes.
- Generated various business opportunities for the company by participating in and managing proposals for Citi Bank.
- Worked closely with the project management team to analyze and consolidate request requirements to improve the decision
planning process and meeting project deadlines.
- Negotiated and liaised between business teams, technology teams, and support teams in order to unblock development.
- Managed projects through status meetings, weekly reports, identifying risks, and tracking issues
- Leaded a multicultural team (+20) among India, USA, Argentina and Mexico.
- The Single Point Of Contact between business and technical team.
Technologies. DB2, Teradata, DataStage, Ab Initio, Mainframe, Cobol.
- Analyzed financial data to identify relationship between operations and banking product trends.
- Became a Subject Matter Expert of AML (Anti-Money Laundering) and KYC (Know Your Customer) processes.
- Generated various business opportunities for the company by participating in and managing proposals for Citi Bank.
- Worked closely with the project management team to analyze and consolidate request requirements to improve the decision
planning process and meeting project deadlines.
- Negotiated and liaised between business teams, technology teams, and support teams in order to unblock development.
- Managed projects through status meetings, weekly reports, identifying risks, and tracking issues
- Leaded a multicultural team (+20) among India, USA, Argentina and Mexico.
- The Single Point Of Contact between business and technical team.
12/2011
-
01/2014
BI Specialist
IBM
(Internet and Information Technology, 1000-5000 employees)
Projects. O2C Blue Harmony Data Transformation; Solution Revenue Automation (SRA).
Technologies. Db2, Netezza, DataStage, Cognos.
- Generated various business opportunities for the company by participating in and managing proposals.
- Created and delivered presentations to various business teams regarding the current status and key decisions regarding their
business issues.
- Successfully implemented Blue Harmony in Mexico, Brazil and USA by customizing the original solution from Germany.
IBM's major transformation program that radically simplified the design and operation of three Global Integrated Support
Processes - Finance, Opportunity To Order, and Order To Cash.
- Managed and communicated projects and leaded a multicultural team (+20) among Germany, Romania, India and Mexico.
Technologies. Db2, Netezza, DataStage, Cognos.
- Generated various business opportunities for the company by participating in and managing proposals.
- Created and delivered presentations to various business teams regarding the current status and key decisions regarding their
business issues.
- Successfully implemented Blue Harmony in Mexico, Brazil and USA by customizing the original solution from Germany.
IBM's major transformation program that radically simplified the design and operation of three Global Integrated Support
Processes - Finance, Opportunity To Order, and Order To Cash.
- Managed and communicated projects and leaded a multicultural team (+20) among Germany, Romania, India and Mexico.
07/2011
-
11/2011
BI Consultant
TCS
(Internet and Information Technology, 1000-5000 employees)
Projects. Debt Structure at GE Capital; Delinquency Analytics at GE Capital.
Technologies. Db2, Oracle, Cognos.
- Leaded an offshore team (India) up to 10 developers.
- Was a facilitator between business and technical team.
- Built automation framework for several reports by reducing processing time.
- Created testing plans and scripts based on requirements.
Technologies. Db2, Oracle, Cognos.
- Leaded an offshore team (India) up to 10 developers.
- Was a facilitator between business and technical team.
- Built automation framework for several reports by reducing processing time.
- Created testing plans and scripts based on requirements.
05/2010
-
06/2011
BI Specialist
IBM
Projects. XIV Reporting, Application Development and Management Reporting, Financial Management Control Reporting
Technologies. Db2, Hyperion, DataStage, Cognos.
Leaded the BI ADM team in Guadalajara plant.
- On charge of training colleagues on BI from installing, configuring and tuning tools.
- Promoted BI services within IBM Guadalajara to enhance Order Management, Inventory to be reflected on a better Order to
Cash processes mainly.
- Documented all projects according with internal mandatory artifacts as a result of analysis sessions.
- Responsible of designing the whole solution from data warehouse and/or data marts, ETL and Reporting aspects.
- Achieved the IBM Cognos Expert and DataStage Certifications.
Technologies. Db2, Hyperion, DataStage, Cognos.
Leaded the BI ADM team in Guadalajara plant.
- On charge of training colleagues on BI from installing, configuring and tuning tools.
- Promoted BI services within IBM Guadalajara to enhance Order Management, Inventory to be reflected on a better Order to
Cash processes mainly.
- Documented all projects according with internal mandatory artifacts as a result of analysis sessions.
- Responsible of designing the whole solution from data warehouse and/or data marts, ETL and Reporting aspects.
- Achieved the IBM Cognos Expert and DataStage Certifications.
03/2007
-
03/2010
BI Consultant
Faktos
(Internet and Information Technology, 50-250 employees)
Project Demos. PEMEX (Mexican oil), Devlyn (Health industry) and Bimbo (Food Industry)
As a part of the pre-sales team I was responsible of develop demos by setting up a proper environment ad hoc to each
prospect. It involved a high-level analysis of main expected requirements.
Projects. Lindt Reporting at Lindt; Clarity at American Express Co. (Phoenix, AZ); Innoval BI at Innoval Döehler; DSS at
Danone de México; Corporate Sales Reporting at Bimbo.
Technologies. Db2, Paradox, Oracle, MySQL, SQL Server, DTS, SSIS, SSRS, SSAS, DataStage, Cognos.
- Managed up to 10 BI developers in a multicultural environment. Conducted follow up meetings to ensure development meet
requirements.
- Responsible of designing the whole solution from data warehouse and/or data marts, ETL and Reporting aspects.
- Challenges included technology migration, multi company standardization and KPI definition reflected as complex
multidimensional measures.
- Software set up were also a part of my experience by following best practices and ad hoc architecture.
- Achieved Microsoft BI Certification.
As a part of the pre-sales team I was responsible of develop demos by setting up a proper environment ad hoc to each
prospect. It involved a high-level analysis of main expected requirements.
Projects. Lindt Reporting at Lindt; Clarity at American Express Co. (Phoenix, AZ); Innoval BI at Innoval Döehler; DSS at
Danone de México; Corporate Sales Reporting at Bimbo.
Technologies. Db2, Paradox, Oracle, MySQL, SQL Server, DTS, SSIS, SSRS, SSAS, DataStage, Cognos.
- Managed up to 10 BI developers in a multicultural environment. Conducted follow up meetings to ensure development meet
requirements.
- Responsible of designing the whole solution from data warehouse and/or data marts, ETL and Reporting aspects.
- Challenges included technology migration, multi company standardization and KPI definition reflected as complex
multidimensional measures.
- Software set up were also a part of my experience by following best practices and ad hoc architecture.
- Achieved Microsoft BI Certification.
03/2006
-
03/2007
BI Developer
Close-Up International
(Pharmaceuticals and medical technology, 500-1000 employees)
Projects. Datamart at Farmacias del Ahorro
Technologies. DataGateway, SQL Server, Microstrategy.
- Designed and implemented the data warehouse and reports for Marketing and Sales areas.
- Responsible of ETL processes and BI Support.
Technologies. DataGateway, SQL Server, Microstrategy.
- Designed and implemented the data warehouse and reports for Marketing and Sales areas.
- Responsible of ETL processes and BI Support.
Local Availability
Only available in these countries:
Mexico
Mexico and USA
Other
https://www.youracclaim.com/users/gerardo-trejo
