09/06/2022 updated

**** ******** ****
100 % available

Business Analyst, BI & Analytics Consultant

Zapopan, Mexico
Mexico
BS Computer Science and Admnistration
Zapopan, Mexico
Mexico
BS Computer Science and Admnistration

Profile attachments

Updated resume

ETL (Etract Transform Load)BI AnalystCloudAgile and Waterfall MethodologyConsultingBusiness AnalystAnalyticsLead DeveloperData MiningRequirementsPrototypesData EngineeringData Analystdata visualization (dataviz)Data Warehousing
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

Languages

EnglishFluentSpanishNative speaker

Project history

BI & Analytics Consultant

DBM Global

Architecture & Civil Engineering

500-1000 team member

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.

Business Analyst - Solution Design

Wipro Technologies

Internet & IT

500-1000 team member

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.

BI Specialist

IBM

Internet & IT

1000-5000 team member

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.

BI Consultant

TCS

Internet & IT

1000-5000 team member

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.

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.

BI Consultant

Faktos

Internet & IT

50-250 team member

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.

BI Developer

Close-Up International

Pharmaceuticals & Medical Technology

500-1000 team member

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.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in