We provide IT Staff Augmentation Services!

Senior Etl/bi Consultant Resume

Atlanta, GA

SUMMARY:

Experienced Hands - On Technology Professional specializing in ETL (Informatica and ODI) and Business Intelligence/ Data Warehouse. Expertise in Informatica mapping development, SQL queries and oracle database. Sound Knowledge of data integration, data movement, reporting and implementing Oracle Business Intelligence Applications (OBIA and OBIEE). Good understanding of source systems such as Oracle Applications (Finance/Order Management), PeopleSoft (Financials and Procurement/Spend) and dimensional model (star schema, snow flake). Effective at gathering business requirements, communicating with users, making recommendations and project managers at regular project status meetings. Familiar with other data visualization tools such as Tableau, Hyperion FDMEE and Spotfire and exposure to Teradata. Exhibit good team work and mentoring skills. Certified OBIA Implementation Consultant and Teradata Master

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Senior ETL/BI consultant

Responsibilities:

  • Perform the role of Lead Business Intelligence consultant, provide ETL development services, Development and maintenance of Informatica ETL code (source to target mapping)
  • Assistance with development of and enhancements to the ETL processes supporting data integrations for OBIEE from multiple source systems such as PeopleSoft and Oracle
  • Development and delivery of extensions to the out-of-the-box ETL OBIA to accommodate custom data requirements provided by the business using Oracle recommended practices
  • Assistance in working with business and technical teams to gather BI/DW and data integration related requirements create functional and technical requirements documents
  • Perform Business analysis, analyze source data, translate business requirements and manage data models.
  • Mapping development using Informatica PowerCenter
  • Create and Use SQL scripts for data profiling and data quality
  • Strong consultative skills to assess user needs, analyses business processes, and communicate technology solutions.
  • Maintain cooperative working relationships with various individuals to ensure a cohesive working environment.
  • Promote collaboration and customer service culture. Document plans, roadmaps and communicate to IT and Functional groups.

Confidential, San Jose

Senior ETL/BI consultant

Responsibilities:

  • Assist clients of Confidential in data Health check assessments and provide recommendations
  • Coach and Mentor junior consultants in the use of Informatica and OBIA
  • Take the lead role in ETL development and the maintenance of Informatica ETL code (source to target mapping)
  • Assistance with development of and enhancements to the ETL processes
  • Development and delivery of extensions to the out-of-the-box ETL OBIA to accommodate custom data requirements provided by the business using Oracle recommended practices
  • Assistance in working with business and technical teams to gather BI/DW and data integration related requirements create functional and technical requirements documents
  • Strong Mapping development experience using Informatica PowerCenter
  • Assistance with architecture build and solution design for the ETL environment using Informatica and ODI.
  • Troubleshooting and debugging of defects and production issues in the areas of Informatica, DAC and OBIEE.
  • Ensuring timely delivery of Project deliverables
  • Administration and support of the OBIA applications platform including system configuration, enhancements, break-fix, and deployments
  • Working knowledge of Quality assurance and quality control methodologies in order to comply with established standards.

Confidential, San Jose

Senior Manager

Responsibilities:

  • Build Strong Teamwork skills and attitude. Partner with Infrastructure Team (both Linux & Windows platforms) to enable and support capacity planning, performance tuning, systems support & troubleshooting.
  • Manage developers and provide hands-on technical support for ETL using Informatica
  • Work in tandem with the Infrastructure Manager, Lead Systems Engineer manager and technical team in the installation, configuration and analysis of OBIA/ODI/OBIEE platform solutions
  • Lead role in configuring Informatica and OBIEE for reports
  • Analyze information requirements specified in the Functional Requirements documents and by end-user to design the data structures to support these requirements.
  • Work closely with business analysts, developers and database administrators to plan, design, develop and implement applications, scripts, procedures and metadata for relational databases.
  • Develop, prepare and conduct periodic training in the use of Business Intelligence tools for the functional user community
  • Provide expert advise on Informatica usage, mapping development and code

Confidential, Redwood City

Senior Principal Consultant

Responsibilities:

  • Assist in developing the data models for Oracle Business Intelligence Applications Finance, Procurement and order Management modules
  • Apply standard dimensional modeling techniques
  • Assist in Beta testing, running ETL loads and Monitoring
  • Actively apply bug fixes to the product
  • Give client technical support

Hire Now