EXECUTIVE SUMMARY:

• 6 years of experience in ETL Development using ETL tool Informatica Power Center 9.6 and 10.2, Teradata RDBMS with performance tuning for maintaining an Enterprise data warehouse
• 1 year 8 months of coordination experience with offshore and onshore model as a Team lead between client and offshore team for requirement gathering, analysts and enhancement along with impact analysis with Agile methodology
• Performed Peer reviews, Unit Testing, Test Cases for end - to-end delivery, environment setup and planning of projects deliverables for successful delivery.
• Performed Ad-hoc requirements and POC’s for any new initiative, I did POC in new tool like ETL Informatica power center 9.6/10.2, deployment tools(uDeploy, Artifactory, GIT), new platform setup, Migration project oracle to Teradata and new structure design for Linux ETL server. Also I work as SPOC of my project, for help other application; I worked to help in setup IBM Infosphere data lineage web based tool for other application
• Performed Informatica tuning for mappings and sessions for optimum performance along with PDO, Teradata load utilities fast load, multiload, fast export and tpump for data conversion, Reusable transformations and Mapplets are built wherever redundancy is needed.
• Performed Teradata database tuning with help of Teradata Data Mover, Stats collections, join index, Primary and Secondary indexes, multi value compression at DDL level, Staging to main table data processing.
• Performed restructured Linux/Unix scripts for greater directory management for Enterprise Datawarehouse where we generating thousands of files frequently at serer, created generic scripts and files that will reduced work for different environment like DEV,SIT UDV and PROD
• Knowledge of Data warehousing, Data Modeling and Business Intelligence
• Coordination experience with offshore and onshore model as Team lead
• Teradata SQL, UNIX Basic commands and scripts, Basics of PL/SQL, Teradata Data Mover (TDM)
• Experienced in code migration tool IBM Urban Code Deploy, CA Harvest version control an tool, Artifactory.
• Ability to meet tight deadlines with my Quick learning, Status Reporting, Cooperativeness and Hardworking strength

TECHNICAL PROFICIENCY:

Development Tool: Informatica Power center 9.5/9.6, Teradata Studio, Toad, CA Workload Automation CA7 Edition, MS Office, Autosys scheduler, HP ALM/Quality Center, Web Client, Putty and WinScp

Code Deployment Tool: IBM urban uDeploy, Artifactory and CA Harvest Software Change Manager

Database: Teradata, Teradata Data Mover and Basics of Oracle

Analysis Tool: Teradata View Point, IGC Lineage Tool

Programming Languages: SQL, Basics of PL/SQL, Basics of java

Scripting Languages: Basics of UNIX/LINUX, Shell Scripting and Commands

PROJECT EXPERIENCE:

Confidential

Responsibilities:

• Requirement gathering and analysis for new source system and change in existing with Data Analyst and Data modular
• Attending Daily weekly and Bi-weekly status meeting on development with Project Lead, Project Manager and Client.
• Daily and weekly status meeting with offshore/onshore team, Data Analyst, Data Modular and Testing team for project status and delivery for requirement .
• Resolving issues relating to technical and functional components and escalating matters requiring immediate attention to the immediate supervisors.
• Estimation analysis of Code design development and deliverables.
• Code review of all the ETLs, Unit test case documents, Design, IQA, EQA documents, completed by team with proper review check list. Also do development for same.
• Defect prevention and causal analysis activities. System and business knowledge build.
• Development and enrichment of Compliance documentation for existing and new application components.
• Knowledge transfer of existing application to team members.
• Performance tuning of long running queries of existing applications.
• Proof of concept(POC) for Ad-hoc clients requirements
• Production implementation activities before production deployment with all scheduling, deliverables components and documents. Production support turnover meeting and CAB representation for changes with release.
• Provide assistance to Support Team for any Production issue/incident

Confidential

Responsibilities:

• Attending Daily weekly and Bi-weekly status meeting with Project Lead, Project Manager and Client for ongoing release and activity
• Team meeting with team member and assign task for development activity
• Code review of all the ETLs, Unit test case documents, Design, IQA, EQA documents, completed by team with proper review check list. Also do development for same.
• Defect prevention and causal analysis activities. System and business knowledge build.
• Development and enrichment of Compliance documentation for existing and new application components.
• Knowledge transfer of existing application to team members.
• Performance tuning of long running queries of existing applications.
• Proof of concept(POC) for Ad-hoc clients requirements like GFB migration and setup
• Setup activity for Informatica and Linux server with create firewall rules, Teradata, oracle wallet, connectors and folder as per new GFB guideline in all environment UAT,QA and PROD
• End-to-end testing and validation in all environment for new setup and connections
• Developed new ETL code and scripts for validation and testing of new setup connection and Linux directories
• Created new configuration files and re-created all Linux directories for easy access in production by Support team
• Created and setup new repositories for multiple parallel requirements

Confidential

Responsibilities:

• Attend daily meeting with my team and perform daily activity
• Provide daily status to my team lead for daily activity
• ETL code development, Unit Testing of ETL code, Defect Fixing and deliver ETL code to Testing Team for validation. Create Unit test case, IQA, EQA documents
• ETL/Linux/DDL code deployment into higher environment for IST and UDV data loads for regression testing

Confidential

Team Member

Responsibilities:

• Worked as Team member and Developer in a Team of 6 Associates.
• Training has been provided in different stages comprising of:Basic HTML/CSS/Basics of Java Oracle SQL Datawarehousing Concepts Use Informatica Power Center ETL tool for Datawarehousing Use of BO tool for reporting