Objective:

Supporting the making decision for clients on business rules using Business Intelligence tools, getting requirements and coordinating projects using AGILE methodology and story boards from customers on Business Intelligence solutions and generating dashboards and reports from Data Warehouse and ERP. Designing multi - dimensional data bases and on line analytical processes.

SUMMARY:

• Confidential has more than 14 years of experience in the IT Industry; he has worked as Business Intelligence Consultant, DWH technical leader, data modeler and ETL Administrator.
• I have strong experience working with standard methodologies on life cycle systems, I have coordinated DWH projects using methodologies Oracle DWH fast track, ISO NORM, PMI and Agile on insurance and financial, telecommunications and beverage and food companies providing solution for on line analytical processes creating dashboards and reports for financial, sales, supply chain, human resources, cash flow, order management and accountable business areas for Pepsi Bottling Group, Gates Corp., Honeywell, Citi Group, Confidential , Confidential and Confidential . I worked ag the Customer Relationship Management 9
• I have worked doing the forecasting for Confidential Company in Data Mining department using statistical analysis on sales and making predictions on financial for stock holders; see please more detailed information at his professional project thesis: ‘investment options using Markov chains’.
• Getting the requirements and being in touch with the client was a challenge for the Data Warehouse project.
• Validation reports were part of my daily job and documenting the quality assurance documents for ISO Norm methodology.
• As Data Warehouse Architect I was responsible for designing logical and physical models for Multidimensional Data Base for KPI projects using CASE tools Erwin 7.3 and Embarcadero DA 10.0 for Hewlett Packard on sales, financial and CORE business areas.
• Coaching my team members and coordinating tasks. I had to interact with ETL Team and Tech Leaders at my daily job.
• As DWH Technical Leader I was responsible for getting requirements, designing and testing case on ETL processes for CITI Group and Banamex on several projects using AGILE methodology, I was responsible for some projects in Banamex and Citi Group using AB INITIO to the Data Warehouse on Teradata; the fundamental analysis on financial is mandatory in order to get a solution and doing analysis and design for some ETL process. Some familiar tasks are persuading and making proposals for several issues and processes and migrate transactional and operational processes to on line analytical processes.
• I was performing the role of SCRUM master by some time.
• As Data Integrator administrator I have designed, tuned, monitored, administered production ETL servers for operational and online analytical processes for IBM, Gates Co., and Confidential Bank which involves unix background monitoring and operational admin tools, my average is 120 service requests per month working with the onsite team in San Antonio, Texas and near shore team in Guadalajara, Jal. for Confidential Bank in the Data Integration Team.
• As ETL consultant I had designed, developed, tested and administered ETL processes in Data Stage and Informatica Power Center Team and finding several issues on the ETL processes on SIT and production environments for IBM Blue Harmony project using testing case and regression test and solved issues for sales in DWH Gates reports which requires doing analysis on the data base information and logical DB models and validating the ETL processes in order to solve the issues.
• I have created logical and physically model for Data Mart Confidential Bank for trading cash using Data Stage, Erwin for modeling logical DB and Data Stage for loading the physical Oracle 10g DB and designed the reports and dashboards using Business Objects.
• Working for IBM supporting the ETL and SAP processes on finance business area and monitoring and testing ETL processes on the DB2 DB and linux platform were using Data Stage 8.1, 8.5, SAP CRM / BI.
• Interaction with business analyst, functional analysts, developers, tech leaders, testers and project managers during my daily job at the meeting call and chats which requires persuasion and leading conversations in order to solve issues by speaking, listening and writing with people from USA
• I recently joined at Confidential Technologies as Tech Leader of near shore BI Team assigned to Confidential BANK account coordinating, designing, testing and implementing ETL Processes on Data Stage 9.1 with control-M and dashboards and reports using Business Objects on Oracle 11G, Netezza and DB2 Data bases, Agile and story boards methodologies.

TECHNICAL SKILLS:

• Proficient In: Industries Sales / Insurance / Financial / Tele Communications
• Project Domain PMI, AGILE and ITIL methodologies.
• Platform linux, sun solaris, UNIX IBMLanguages PL/SQL, SQL ANSI, VISUAL BASIC 6.0, COBOL
• RDBMS ORACLE 11G, DB2, SQL SERVER, INFORMIX, VERTICA, SQL Server
• CASE TOOLS Data Stage 9.1/ 11 .5, Informatica Power Center 8.6.1, AB INITIO 3.6.2, MS SSIS 2012
• Executive Information tools SAP BO 4.2, Cognos Power play, OBI 7.5, Crystal Reports, Micro Strategy
• Statistical Analysis SAS INSIGHT, SPSS IBM, MATLAB.
• Applications Oracle SQL Developer, Rapid SQL, ERWIN, ER Studio Data Architect, Oracle Data Modeler, Business Objects UDT, MS

PROFESSIONAL EXPERIENCE:

Confidential

BI Consultant senior

Responsibilities:

• AGILE methodology
• using Data Stage 11.5 on linux platform on Oracle DB 11G and Netezza DB. MS Excel. SAP Business Objects 4.2
• SAP BO UDT/IDT
• Control-M

Confidential

DWH Architect / Systems Analyst

Responsibilities:

• AGILE Methodology
• MS VISIO
• ERWIN 7.3
• ER DA Embarcadero 10.0
• Toad 3.6.1
• SQL Server System Integration Services.

Confidential

Technical leader

Responsibilities:

• MS PROJECT
• Xmind / Mind manager
• AGILE Methodology
• AB Initio and Teradata DB
• autosys
• MS VISIO
• COBOL.

Confidential

 Data Stage Team

Responsibilities:

• Info sphere Data Stage 8.5 / 8.7 and SAP CRM / SAP ERP / SAP BWH on AIX platform
• Quest tools
• Rational Manager
• Tivoli Work Schedule
• DB2 data base
• IBM life cycle system methodologies and generating Quality documents

Confidential

Administrator

Responsibilities:

• Control M
• putty
• DB2 sql
• Oracle Pl/sql Developer
• Informatica Powercenter 8.6.1 /9.5
• Data Stage 8.5
• Unix Operating systems.
• Sharepoint.

Confidential

Business Intelligence Consultant

Responsibilities:

• OBIEE 11
• Oracle 10G
• Oracle PL/SQL Developer
• OBI Applications 7.5
• Informatica Powercenter 7.0

Business Intelligence

Responsibilities:

• OBIEE 11
• Oracle 11G
• Oracle PL/SQL Developer
• OBI Applications 7.5
• Share point
• Informatica Powercenter 7.0

Confidential

Software Engineering

Responsibilities:

• Data Stage Director
• Designer
• Administrator 7.5 on Linux platform and PL/SQL Oracle 9i. Erwin 4.0
• Business Objects 6.2

Confidential

Quality Assurance Analyst

Responsibilities:

• Supporting decision making designing reports on Business Objects on different business areas.
• Modeling OLAP Processes of business areas and PL/SQL Oracle 10G for clients’ decision support. Analysis, design and implement ETL processes for the Warehouse using Data Stage Designer and Director 7.5. Analysis and design of ETL processes on CDRS.
• Generating reports for Manager Transmission Data and statistical analysis using SAS INSIGHT and SPSS 11.0. Validating dashboards and reports with SQL and Oracle 10g. Designing reports with Micro Strategy
• Key technologies: Rapid SQL, ORACLE PL/SQL 10G. Business Objects 6.2. Data Stage 7.5, SAS Insight SPSS 11.0, Micro Strategy

Confidential

Systems Analyst

Responsibilities:

• Visual Basic 6.0 on Oracle 9i
• Excel and Crystal Reports and PLS/SQL Oracle
• ERP JDE