SUMMARY:

• An accomplished Big Data Hadoop Developer, Python programmer and a senior ETL Designer with multiple implementation experience in Data Warehouse and Data Analytics projects.
• Currently working on Customer Evaluation Analytics(CEA), a product of ClickFox. An Informatica Corporation certified Developer, with high proficiency in Oracle SQL and PL/SQL Programming and Unix shell scripting and Python programming.
• An exceptional problem solver with keen ability to resolve technology issues, successfully provided for system enhancements, business processes improvement, and have designed, developed and implemented highly successful automated solutions.

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect

Platform: Hadoop, ClickFox CEA, Python, UNIX

Responsibilities:

• Work closely with Information Architects and Business Analysts to understand Customer Data and the business use cases
• Providing expert knowledge and solutions on Customer Journey Analytics
• Prepare detailed Blueprint for each phase of SDLC
• Convert Blueprint to code & perform code reviews
• Worked on Python code for data transformation for different journey layers.
• Run Map Reduce Jobs to load customer data into Hadoop and to build different layers of customer data for journey analytics
• Analyze journey layers to find meaningful insights and actionable items for the customer
• Provide reviews of deliverables and identifies gaps/areas of improvement

Confidential

Project Lead/Onsite Coordinator

Platform: Hadoop,Impala, Sqoop, Informatica 9.6, Oracle 11g, HP Vertica, UNIX, Autosys

Responsibilities:

• Analysis of Functional Specification documents to assess the impact of the requirement.
• Preparation of estimation plan for the requirement.
• Preparing the Application Design and Component Design documents.
• Leading the development team from Off - shore.
• Loading data into Hadoop environment using Sqoop.
• Loading data into Impala database for faster query processing.
• Implementing performance tuning in the code to remove the potential bottlenecks.
• Performing code-reviews.
• Preparing all the code deliverables and supporting docs like Migration Doc and Run Books during prod release.
• Analyzing the root cause and resolving production issues, on timely manner to minimize its impact and escalations.

Confidential

Team Lead

Platform: Informatica 8.6, Oracle 10g, UNIX, Rational ClearCase

Responsibilities:

• Analysis of Functional Specification documents to assess the impact of the requirement.
• Preparation of estimation plan for the requirement.
• Preparing the Application Design and Component Design documents.
• Leading the development team from Off-shore.
• Designing the mappings, mapplets, worklets and DB Objects to implement the business logic.
• Implementing performance tuning in the code to remove the potential bottlenecks.
• Performing code-reviews and preparing Unit Test Plan and executing the Plan.
• Preparing all the deliverables and supporting docs like Migration Doc and Run Books during project delivery.

Confidential

Team Lead Confidential of Scotland.

Platform: Informatica 8.6, Oracle 10g, UNIX, Rational ClearCase

Responsibilities:

• Understanding the requirements and interacting with the BAs for preparation of FSD.
• Assessing the impact of the requirement and preparing the estimation plan.
• Preparing the Application Design and Component Design documents.
• Preparing the Data Model using Erwin.
• Designing and Developing all the Batch related UNIX scripts to automate the whole Batch Process.
• Preparing the Batch Schedule and file movement plans.
• Running the Batch in different environments (Dev, Testing, and Pre-prod).
• Designing the mappings, mapplets to implement the business logic.
• Implementing performance tuning in the code to remove the potential bottlenecks.
• Performing code-reviews and preparing Unit Test Plan.
• Configuration management of the code in Rational Clearcase.
• Managing the team in terms of work allocation.

Confidential

Developer

Platform: Informatica 8.6, Oracle 10g, UNIX, Rational ClearCase

Responsibilities:

• Assessing the impact of the requirement and preparing the estimation plan.
• Preparing the Application Design and Component Design document.
• Designing mappings and mapplets to implement the business logic.
• Developing UNIX scripts to run ad hoc Jobs both automatically and manually.
• Implementing performance tuning in the code to remove the potential bottlenecks.
• Reviewing code developed by the team.
• Configuration management of the code in Rational Clearcase
• Supporting the UAT Batch, fixing the issues and delivering the Patch
• Assisting team members in resolving technical issues encountered.

Confidential

Developer

Platform: Informatica 8.6, Oracle 10g, UNIX, Rational ClearCase

Responsibilities:

• Preparation of Component Design Document and Batch Schedule Document.
• Preparation of Low level design Document.
• ETL development using Informatica, Oracle and Unix.
• Preparation of Unit Test Plan and execution of Unit Test Plan.
• Preparation of CIT Test Plan and UAT Test Plan.
• Peer code review process

Developer

Confidential

Platform: Informatica 8.1, SQL Server 2005, UNIX, VSS

Responsibilities:

• Involved in ETL development using Informatica, SQL Server and Unix
• Preparation of Unit Test cases and execution of Unit Test cases.
• Involved in preparing Technical Specification Document.
• Review of the code of the team members.
• Involved in code deployment in Test, UAT and Production environment.
• Configuration management of code in VSS.

Confidential

Developer

Platform: Informatica 8.1, DB2, UNIX

Responsibilities:

• Involved in ETL development using Informatica, DB2 and Unix
• Preparation of Unit Test cases and execution of Unit Test cases.
• Involved in Peer code review process.
• Analysis of Prod issues and Bug fixing

Confidential

Developer

Platform: Informatica 7.1, Oracle 8i

Responsibilities:

• Involved in ETL Development using Informatica
• Preparation of Unit Test cases and execution of Unit Test cases.
• Involved in the Component Integration testing

Confidential

Developer

Platform: Informatica 7.1, Oracle 8i

Responsibilities:

• Involved in ETL Development using Informatica
• Preparation of Unit Test cases and execution of Unit Test cases.
• Involved in Peer code review processes

Confidential, Texas

Developer

Platform: Informatica 7.1, Oracle 8i

Responsibilities:

• Involved in ETL Development using Informatica
• Preparation of Unit Test cases and execution of Unit Test cases.