ETL Architect Resume

SUMMARY:

Part of a team of 53 technologists. Responsible for end to end technology.
Experience in designing, developing, implementing, documenting and executing various projects through complete SDLC.
Worked on a number of projects of different domain ex: Banking, retail, Telecom, Health care.
Worked extensively on a number of Agile driven development projects.
Worked as BI consultant, with responsibility of end to end delivery.
Worked as ETL Architect in Technical Consulting role.
Playing a role of SME of pentaho. Knowledge of Various Databases ( Oracle,MySQL, Postgress ). proficient in Analytical skill, Query writing.
Basic knowledge of BigData Stack Hadoop mapreduce (Pentaho and java), pig,Hive
Consistently acknowledged for analytical skills and trouble - shooting/problem solving skills.
Acknowledged for solutions to business problems.
Client Interaction, Requirement Analysis, development and unit testing.
Experience of building enterprise data warehouse.
Experience in Data Modeling, ETL, reporting, Cube designs.
Successfully delivered multiple projects end to end.
Consistently ranked amongst the top X% of employees in terms of performance across all firms.

TECHNICAL SKILLS:

Technologies: Data warehouse, Pentaho, Informatica

Languages: SQL, PL/SQL,BTEQ, Basic Core Java( Learner)

Srcipts: SQL,PL/SQL,BTEQ, Basic unix

Databases: Oracle, Teradata, mysql, sql server, postgres

Operating Systems: Windows, Unix

Domains: Data Warehousing, Banking, Retail, Health care.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

Product development for Reconciliation - Responsibility includes product architecture and Development (ETL side).Database related development, testing, helping others, Bug fixing, Deployment.
This product is parsing different types of Ledger and Statement files (fixed length, swift messages, manual) and generating data to reconcile.
Team is seating along with operations to gain the business need and provide the solution.
We are following Agile methodology with daily scrum and requirement through JIRA.
TDD approach is used for development of all the features.
Closely working with Operations partner to achieve the required goal.
Product is running in Virtual cloud (same server multiple instances) to handle load. > Better processing time and accuracy compared to existing market leading product.

Confidential

Responsibilities:

It was Migration project, Client wanted to move their business from Datastage to Pentaho.
Given fail over strategy. Given feature of restart ability from the last failure point rather from initial job.

Confidential

Responsibilities:

Worked and Architect and Bi consultant on 4 different projects. Noaandra: This project was for federal government US, for estimating the environmental effect due to oil spill in gulf of Mexico by British petroleum and collect the penalty.I worked and ETL Architect in Orlando Florida along with one dashboard designer.
Cengage Opera: it was for client Cengage, they are online provider and wanted to slice and dice data, created various jobs and transformations along with loads of validations before data processing and automation. Stream: they are Call center and have big data mart, it was a migration project from Informatica to Pentaho, worked as lead developer. Cwb: Compensation Workbench is a module that decides the Employees who all are eligible for the Compensation in previous month. The Employee Informations I was getting from Oracle HRMS and based on various criteria I calculated the Employees of organization who all are eligible for Bonus. Worked alone as technical and functional lead and delivered.

Confidential

Responsibilities:

It provides clear idea to Companies analysts about their system’s LOG files and the log messages generated. NII: It was a Informatica project developed through Oracle vanilla repository, client wanted to use Siebel as base of their business. Informatica setup to run the business on the Unix box was given by me.
Mainly engaged with Data warehouse projects as developer initially then as a lead. Worked on Tearadata BTEQ’s for loading data in EDW. sDone ETL testing and documentation.