We provide IT Staff Augmentation Services!

Lead Etl Developer Resume

SUMMARY:

  • 18 years of professional experience in the field of Software System Design and Development.
  • 12 years in Data Warehousing, ETL/SQL Projects in the Data Warehouse/Business Intelligence space - Analysis, Design, Data Modeling, Data Migration/Conversion and Development. Experience in dual-shore team environment.
  • As DW consultant my role was to contribute to the end-to-end Data warehouse project life cycle to ensure development of high performance, easily maintainable ETL/Data warehouse/BI solutions.
  • Experience with Data Modeling, Dimensional Modeling, OLAP design-Universe and creation of ad-hoc/canned reports in Business Objects 5.x, 6.x, XI r2/3.1/4.2; ETL using Informatica Power Center 6.x, 7.x, 8.x.9.x
  • Overall Data Warehouse and BI project domains were in Bookings, Demand planning, Forecast, Sales, Healthcare, Dental Insurance and others.

TECHNICAL SKILLS:

Operating Systems: MS DOS, WINDOWS, XP, UNIX

Programming: SQL, PL/SQL, C/C++, Visual Basic, Java/JSDK

Databases: Oracle 7-11, SQLServer 7.x/2000, Sybase SQLServer/Adaptive Anywhere, Teradata 12.0, MySQL 5.2

BI & DW Technologies: SAP Data Services/BODS 4.2, Informatica PowerCenter 6.x, 7.x, 8.x; Informatica PowerExchange, MS DTS, BOBJ 5.x, 6.x, XI R2, 3.1; DecisionPoint Warehouse Admin 10.5.1, UMT, MDM Siperian

Web Technologies: JSP, Java Servlets, ASP, ColdFusion, HTML, JavaScript

Tools: Microsoft Tools - MS Project, MS Excel, MS PowerPoint, MS Visio; HP Tools - Kintana, QualityCenter; PVCS; Toad, Erwin, Job Scheduling - $U, Tidal; Confidential - Apex Explorer, Apex Data Loader, DataFlux 8.1, Jira, Tortoise SVN, Citrix.

PROFESSIONAL EXPERIENCE:

Confidential

Lead ETL Developer

Responsibilities:

  • Requirement gathering discussions with Business Analyst for Billing subject area
  • Identify mapping between source Advantech and the target MetaVance
  • Translating the requirements into source to target mapping and ETL design
  • Handled resource changes, took charge of deliverable, met the committed timelines
  • Won the trust of stakeholders by meeting timelines by handling unexpected changes
  • ETL Code Development, unit testing
  • Cross-functional team coordination across multiple time-zones from EST, PST, IST.
  • Business/Data Analysis for the reported tickets/defects
  • Tuning the SQL queries to improve the performance
  • Data fixes in Business Objects Report
  • Deployment checklist and deployment to QA and Production environment
  • Working in the Onsite/Offshore team model for the deliverable

Confidential, San Francisco, CA

Environment: SAP BOXI 4.2, Oracle 10g, Jira, Tortoise SVN, SAP Data Services/BODS 4.2, Citrix

ETL Lead Developer

Responsibilities:

  • Business Discussions and Requirement Analysis
  • Design and mapping Discussions
  • ETL Code Development using Informatica
  • Coordination with onsite/offshore team
  • Unit Testing and Data Validation
  • Preparation for UAT and Business data verification
  • Production deployment and process improvement

Confidential, Sunnyvale, CA

Environment: Informatica 9.5, Oracle 10g.

ETL Architect

Responsibilities:

  • System, Data Analysis, Design for Serial Number project
  • Coordination with cross functional teams, onsite/offshore team
  • Process Improvement
  • Coordination and assessment of Informatica Cloud POC against SSIS Modern Platform (MDP)

Confidential

Environment: MS-SSIS 2014, NetSuite, Informatica Cloud, QlikView, Azure

ETL Consultant

Responsibilities:

  • Business Discussions and requirement gathering
  • System and Data Analysis
  • Data Modeling for PJV (Finance Team)
  • Development, Unit Testing, QA, UAT and Deployment in various subject areas
  • Coordination with cross functional, onsite/offshore team and release teams
  • Training on Wave Platform
  • Data loads for Finance on Wave Platform

Confidential

Environment: Informatica 9.5, Oracle 10g, 11i, Tidal Scheduler, BO-DI, BOBJ XI R3.1, Salesforce Workbench

Functional Analyst

Responsibilities:

  • Understanding the reporting requirements
  • Development, Testing, Standard template verification
  • Delivering the solution with the help of offshore development team
  • Training users on the new reports

Confidential

Environment: SAP BusinessObjects WebIntelligence XI R3.1.

Data Modeler

Responsibilities:

  • Business Discussions and requirement gathering
  • Understanding the Operational System
  • Building the efficient Data Model/Data Mart for BI Analytics through Pentaho

Confidential

Environment: MySQL 5.2, Pentaho 4.1

Performance Consultant

Responsibilities:

  • Estimate and tune the performance bottlenecks in SQL/Business Objects reporting.

Confidential

Environment: Oracle 10g, Informatica 8.1.6

ETL Consultant

Responsibilities:

  • ETL Development, Unit Testing

Confidential

Environment: Oracle 10g, Informatica 8.1

ETL Consultant and Data Analyst

Responsibilities:

  • Translate requirements into ETL system
  • Revise Product Hierarchy

Confidential

Environment: Oracle 10g, Informatica 8.6.1

Data Analyst

Responsibilities:

  • Understanding the data from 3 sources CIC (TD), BI Café (TD), SOM (Oracle) for SSODM (Oracle) and putting together SDR for the LDM modeling.

Confidential

Environment: Oracle 10g, Teradata 12.0

BI/Data Analyst

Responsibilities:

  • Source System Analysis, Participation in Logical and Physical Data Modeling, ETL System Design

Confidential

Environment: Teradata 12.0, Oracle 10g, Informatica 8.6.1

Data Analyst

Responsibilities:

  • To compare, validate and certify the data quality in Teradata environment.

Confidential

Environment: Teradata 12.0, Oracle 10g, DataFlux 8.1

ETL Consultant

Responsibilities:

  • ETL Design, ETL Development using Informatica, Unit Testing

Customer

Confidential

Environment: Informatica PowerCenter 8.1.1, Oracle 9i, Force.com ( Confidential )

BOBJ Support

Confidential

BI Analyst

Confidential

BI Analyst and Transition Lead

Responsibilities:

  • Dimensional Modeling, ETL Design, ETL using Informatica, Unit Testing, BOBJ Universe and Reporting, Enhancement/Change Impact Analysis, Implementation & deployment.
  • Coordination with cross-functional and ERMO teams.

Hire Now