SUMMARY:

Professional with 8 years 9 months of technical experience in solution analysis, design, development, testing and implementation of ETL and Data warehousing. Have good team leadership skills and invariably meets client expectations. I have a strong hold on technologies like data warehousing, data migration, ETL, Oracle and scripting languages.

COMPETENCIES:

Technologies: Informatica Powercenter 10.2,9.6,8.5, Confidential Data Stage, Confidential websphere transformation extender

Domains / Programming Skills: Data warehousing, Data Migration, ETL, Shell scripting, Perl scripting, Core java Verticals

Banking and Finance, Telecom: Settlement, Foreign Exchange, Cheque clearing system, Wires, Swift

Databases: Oracle 9i/10G/11G, PL/SQL, DB2 9.7/10.1 SQL SERVER 2005/2008/2012

Software Tools: Toad, SQL developerSVN, Bugzilla, Quality CenterFile Transfer SFTP,Connect Direct, Data Router.

Operating Systems: Windows, Red Hat Linux, AIX

PROFESSIONAL EXPERIENCE:

Confidential, Plano

Technologies: Informatica, Data warehousing, Shell scripting, Sql/plsql

Developer

Responsibilities:

• Checking feasibility of application migration to Confidential & Confidential private cloud environment which is RedHat Linux.
• Migrating applications from UNIX platforms such as Solaris, AIX, HP - UX to Linux hosted on virtual/cloud environment.
• Analyze and understand migration requirements
• Analyze migration issues and dependencies
• Communicating with different teams to keep the deliverables on track.
• Worked on various automations like file transfer functions, Informatica functionalities like relational connection creation, folder creation and access management, Informatica health check.
• Informatica server installation and grid configuration.
• Informatica upgrades.
• Informatica administration.
• Performance improvements of existing solution to cope up with the increasing data by architectural changes, Informatica parallelism, query tuning, redundancy removal.
• End user documentation and operational procedures on wiki pages so that all the developers and end users can refer the functionality.

Confidential

Technologies: Informatica, Data warehousing, Shell scripting, Sql/plsql

Developer

Responsibilities:

• Owning the design of Informatica workflows and mapping as per the data model.
• Populating the data into data warehouse from the transactional systems as per the data warehouse design.
• Working on different Informatica Components to develop and maintain complex mappings, sessions, workflows using all types of transformations to process huge volume of data in time critical window.
• Unit testing and system integration testing of the developed code.
• Performance improvements of existing solution to cope up with the increasing data by architectural changes, Informatica parallelism, query tuning, redundancy removal.
• Providing fixes to the issues identified in testing phase.
• Providing production support for the deployed project.
• End user documentation and operational procedures on wiki pages so that all the developers and end users can refer the functionality.

Confidential

Technologies: Informatica, Data warehousing, DB2, SQL Server 2008

Developer

Responsibilities:

• Analyzing the business requirements and helping business analysts to gather the information from the end users and reviewing mapping documents from development perspective and suggesting corrections if any.
• Working on different Informatica Components to develop and maintain complex mappings, Sessions, Workflows using all types of transformations to process huge volume of data in time critical window for a data migration process.
• Working on Plsql stored procedures as a part of simulation of forex settlement engine.
• Integrating the code from different modules and conducting integration testing.
• Writing, updating and maintaining shell scripts to automate the integration testing process and publishing the results to the management so as to deploy the code on time.
• Unit testing and system integration testing of the developed code conducting peer review of the code.
• Providing fixes to the issues identified by QA team in testing phase and logging them in quality control tool.
• Providing production support for the deployed project and implementing change requests made by the end users.
• Performance improvements of existing solution to cope up with the increasing data by architectural changes, Informatica parallelism, query tuning, redundancy removal.
• End user documentation of operational procedures.

Confidential, Charlotte, NC

Technologies: Websphere Transformation Extender, XSD, XML

Developer

Responsibilities:

• Analysis of the business requirement and helping BA’s to gather the information. Unit testing and system integration testing of the developed code.
• Designing the architecture of the mappers.
• Owner of Design, Development and CR implementation for development activity.
• Reporting and troubleshooting the WTX tool issues with WTX product architects
• Attending daily client calls and discussing solutions and issues.
• Performance Tuning of existing maps.
• Ramping up the new joiners on WTX.

Confidential, CA

Technologies - Informatica, Data Migration, Oracle, Shell scripting, SQL Server 2005

Developer

Responsibilities:

• Analyzing the business requirements and helping business analysts to gather the information from the end users and reviewing mapping documents from development perspective and suggesting corrections if any.
• Working on different Informatica Components to develop and maintain complex mappings, Sessions, Workflows using all types of transformations to process huge volume of data in time critical window for a data migration process.
• Integrating the code from different modules and conducting integration testing.
• Writing, updating and maintaining shell scripts to automate the integration testing process and publishing the results to the management so as to deploy the code on time.
• Unit testing and system integration testing of the developed code conducting peer review of the code.
• Providing fixes to issues identified by QA team and logging them in quality control tool.
• Performance improvements of existing solution to cope up with the increasing data by architectural changes, Informatica parallelism, query tuning, redundancy removal.
• End user documentation of operational procedures.