SUMMARY:

• Information Technology professional with 9+ years of overall experience and experienced in Informatica 9.5 / Oracle / Denodo / Teradata / J2EEHands - on, results-oriented professional with a pioneering career reflecting strong leadership skills coupled with Data ware Housing application and web application development and production Support, back end application development. Proven record in delivering simultaneous large-scale, mission critical Projects on time.Areas of expertise include:
• Production Support / Team leadership /Software development / ReleaseManagement / Process Improvement
• Over 9+ years of total IT experience on Informatica Power Center 9.5,Data Virtualization tool: Denodo 5.5, Web-based applications on J2EE, Oracle 9i, Teradata 13.1, Unix.
• 4+ years of experience in Data Warehousing and ETL using Informatica Power Center 9.5(Workflow Designer, Workflow Manager, Workflow Monitor,Repository Manager, Informatica Metadata manager - IMM), Unix, Oracle, Teradata, Appworx.
• 3+ years of experience in J2EE (Casper, Struts, Spring and Hibernate Frameworks) & Oracle.
• Experience in working on different phases like Requirement Gathering, Development, Analysis, Documentation, Testing, Migration Project, Production and Post Production support.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports.
• Worked closely with Clients, Business Analysts, Data architects, Database Administrators, Developers and BI Reporting teams to ensure the ETL solution meets business requirement.
• Experience in developing and maintaining software applications in Domain areas of Confidential Manufacturing, Energy, capital & Treasury.
• Expertise in Data Warehousing, ETL design and development process using Informatica Power Center (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations).
• Having knowledge on Dimension modeling Star/Snowflake schemas, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling, SCD.
• Experience with Data Extraction, Transformation and Loading (ETL) from different data sources like Oracle, MS SQL, Teradata, File System(Text Files,XML files, .csv) into a common analytical data model using InformaticaPower Center 9.5.
• Experience in handling Performance improvement. Well versed with database partitioning and Informatica mappings performance improvement using partitioning. Processed large volumes of data and large files.
• Expertise in error handling, debugging and problem fixing in Informatica.

COMPUTER SKILLS:

Programming languages: C, C++, Java 5.

Web Technologies: XML, XSLT, JSP, Java Script, Servlets, HTML, Spring and Hibernate.

Scripting Language: Unix Shell Scripting and Perl

Database - RDBMS: Oracle 10g,TERADATA 13, Greenplum.

Development Tools&Utilities: Informatica 9.5, Teradata SQL Assistant, Toad,PGAdmin, SQL Developer, MS Office,WinSCP,Putty, Support Central( Confidential Product), MES, Kronos, MS Office 2010, Jenkins, Tortoise SVN

Scheduling Tools: Appworx, Unix Cron Jobs

Business Support Process Management: ITIL Process Incident, Problem, Change Request, Requests(HewlettPackard Service Desk 2.0(HPSD), HP QC, Confidential Service Now, Rally)

Operating Systems: Unix, Linux, Windows NT/2010/XP/98/2000

Trainings Attended: DB2, Informix, Salesforce.com, OBIEE, Denodo 5

PROFESSIONAL EXPERIENCE:

Confidential, Stamford, CT

Sr. ETL Informatica Developer/Analyst - Onsite

Responsibilities:

• Interacting with the Clients on a regular basis to discuss day-to-day issues.
• Providing support for 800+ Informatica workflows/Mappings (developed using Informatica 9X) which are running into Production environment at client Location.
• Resolving the Incidents/Request/Problemwith ITIL standards.
• Involved in code & data analysis and handling the ad hoc requests by interacting with Business Analysts, Clients and Customers and resolve the issues as part of production support.
• Reviewing Project tasks with offshore team and ensuring they complete on time.
• Providing On-call support as this is 24X7 application.

Confidential, Norwalk, CT

ETL Informatica Developer/Lead - Offshore

Responsibilities:

• Understanding the Business Requirement Document’s as well as technical aspects of the Project.
• Involved in the low level designing of Commercial Finance EDW.
• Involved in clarification calls on requirements with Business Analysts/Client and freeze the requirement for every sprint.
• Involved in Scheduling calls, tracking and control.
• Modifying the Teradata BTEQ scripts as per the requirement.
• Creating and modifying the mappings and workflows as per the requirement.
• Creating and modifying the chain in Appworx scheduler tool.
• Preparing the test case documents for moving to Production environment.
• Understanding the existing BTEQ scripts and Mappings.

Confidential, Atlanta, Georgia

ETL Informatica Developer/Java Developer/ Release Lead

Responsibilities:

• Collecting the requirements from the Clientand understanding the Business Requirement and Functional Document’s as well as technical aspects of the Project.
• Creating Low level and High level and technical design documents in Informatica.
• Worked on Informatica Power Center Designer - Source analyzer, Mapping Designer and Transformation developer.
• Used various Informatica transformations to load data in the data warehouse
• Used Lookup, Sequence generator, Router and Update Strategy transformations to insert, delete, and update the records for Slowly Changing Dimension tables
• Extensively used Mapplet’s and Reusable Transformations to prevent redundancy of transformation usage and maintainability
• Created database objects like tables, views, indexes, sequences and performing DML operations using insert, update and delete statements.
• Involved in different phase of testing like User Acceptance Testing, Unit testing.

Confidential, Atlanta, Georgia

ETL Informatica Developer - Offshore

Responsibilities:

• Understanding the requirements as per the specification document.
• Repointing the Source connections to new application.
• Helping the dependent teams(WebMethods) to point their integrations to Venture application.
• Creating the new Mappings for taking data from BTP instead of SSP5.
• Loading the Legacy Confidential Data to Venture application.
• Creating the workflows and scheduling them as per business requirement.
• Used trigger based mechanism to handle dependencies.
• Troubleshoot the errors during load.

Confidential

ETL Informatica Developer - Offshore

Responsibilities:

• Analysis of the specifications provided by the clients
• Design to approach to integrate the Applications with IPS
• Development - Creating Informatica Mappings to support the integration requirement.
• Testing - unit testing & integration testing
• Interacting with the client on a daily basis to update the project status.
• Migration to QA and conduct UAT.
• Production migration & Post Production Support for 15 days.

Confidential, Atlanta

Java Developer/Production Support - Offshore

Responsibilities:

• Providing access to see the turbine information etc. using SAM tool to view in the CMF tool.
• Also looking into Parts Edge application Production issues.
• Making code changes at JSP/Java/Configuration files.
• Making required DB level changes in case any back end logic or query needs to be changed.
• Raising a Change Requests to Deployment team.
• Migrating the code from Dev to QA.

Confidential, Atlanta

Java Developer/Production Support - Offshore

Responsibilities:

• Requirement gathering for the new Modules.
• Creating Workflows, Mappings in Informatica to load the data from one database to Confidential DB tables.
• Making code changes at JSP/Java/Configuration files.
• Making required DB level changes in case any back end logic or query needs to be changed.
• Raising a Change Requests to Deployment team.

Confidential, Atlanta

Support central developer - Offshore

Responsibilities:

• Going through the existing design of the UI built on Visual basic.
• Attending the calls with the Client
• Undergone the training on Support central.
• Developed the Data Form and Workflows in Support central.