PROFESSIONAL OVERVIEW

• Over 14 years of rich experience in IT and have demonstrated results in delivering custom application migration, analyzing information system needs, evaluating end-user requirement, custom designing solutions, troubleshooting for complex information systems management in data warehousing using ETL.
• Strong problem solving and technical skills coupled with confident decision making for enabling effective solution leading to high customer satisfaction as well as low operational cost.
• Experienced in full Software development lifecycle from requirements gathering, architectural design, writing Business Specification Document, ETL development, QA and implementation of data warehousing applications and support for Retail, Finance, Insurance Industries in various RDBMS like Oracle, Teradata environments.
• Ability to interact with IT teams to gather source system knowledge and works with the customer to arrive at the overall architecture
• Customer Interaction Review Meetings participation/ Deliverables
• Builds High Level Technical design HLD and LLD of ETL processes
• Good understanding of Data quality/Data Modeling
• Proficient in C/C .
• Established my ability to identify, analyze and solve technology problems that enhance business.
• Strong relationship, good communications skills, and good in customer interaction.
• Experience with On-Site and On-Site/Off-Shore Model of project delivery.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Role: - Informatica Tech Lead/ Designer

Responsibilities:

• Perform a gap analysis and document all additional data elements needed
• Produce a mapping of finalized data elements against redesigned GDW tables for party, customer and site to store TCA data
• Review existing ETL jobs based on analysis from BA for post-GoTC implementation and document all required changes.
• Review new requirements for post-GoTC implementation and document all NEW required ETL jobs
• Prepare all Source to Target mapping specifications and Gap analysis from post-GoTC implementation perspective
• Design and document all ETL mappings, sessions and workflows

Technical Environment: Informatica 9.6, Oracle 11g, UNIX

Confidential

Role: - Informatica Tech Lead

Responsibilities:

• Delivers a high quality technical solution for a project with data movement
• Supports the DL Delivery Lead in identifying detailed tasks and effort estimates for the work plan.
• Identifies and communicates technical issues.
• Coordinates between DL, testing team and developers.
• Ensure functional requirements are understood by developers and testers.
• Builds High Level Technical design and LLD of ETL processes
• Works with Development Manager to identify and secure development resources.
• Provides DL with a technical project plan to supplement the overall project plan.
• Proactively identifies environmental needs, set-up, user access requests, etc.
• Reviews all code before it is submitted for migration and submits all migration requests.
• Provides initial level of performance tuning guidance.

Technical Environment: Informatica 9.5, Power Exchange 9.x, Oracle 10g, Linux, Tivoli scheduling tool

Confidential

Role: - Informatica Tech Lead

Responsibilities:

• Interaction with client and offshore team, Analysis, Design - FS, TD and Unit test cases etc, Documentation, SIT Planning and Review Deliverables.
• Customer Interaction Review Meetings participation

Technical Environment: Informatica 8.6, Oracle 1og, Linux, Control-M scheduling tool

Confidential

Role: - Informatica Tech Lead

Responsibilities:

• Interacting with client, Analysis, Design and Development, Documentation, Testing, Review Deliverables.
• Involved in Customer hub, Property hub, Reservation and Product hub inventories of the project - designing and developing from end to end.

Technical Environment: Informatica 9.01, IDQ 9.0.1, MDM 9.0.1, Oracle 11g

Confidential

Role: - Module Leader

Responsibilities:

• Architecture, Analysis, Design and Development, Application support and Maintenance
• The three files that send data from People Soft to local payroll systems are the EWAD Employee Workforce Admin Data , ECD Employee Compensation Data and Bonus Plan. However, these files specs do not comply with ADP's standard file specs for importing this employee data into ADP's payroll system. As such we will require a 'Formatter' program s be developed to take the three files and reformat these into an ADP standard file format.

Technical Environment: Informatica 8.6, Oracle 10g

Confidential

Role: - Module Leader

Responsibilities:

• Interacting with business users Architecture, Requirement gathering Analysis ,Design and Development, Documentation

Technical Environment: Informatica 8.6, Oracle 10g, Control-M Scheduling Server

Confidential

Role: Module Leader

Responsibilities:

• Production Support, Analysis, Enhancement, Testing, Interaction with client, Onsite-offshore co-ordination,
• Informatica plays an important role in AZL.The system is categorized into environments like Production, QA/Test, CBO, Staging and development. Most of the applications are very critical in the environments.ASM project deals with Extraction, Transformation and Loading of data from different sources using Informatica. The data is stored in mainly in SQL server2005 and oracle. ASM project involves Informatica application support and maintenance 24x7.
• Carried out the following activities ,
• Creating and managing user, managing ETL server and its services in case of failure.
• Production support 24x7 Also giving permanent solution to fix the problem .
• Enhancement and code fixed based on requirement, deployment.
• Regular activities involved monitoring of alerts and scheduled jobs,
• Proper daily handshake with offshore on the status.
• Troubleshoot complex problems on new and/or existing products.
• Manage support process
• Ensure all project documentation is completed and follows required Standards.

Technical Environment: Informatica 8.1, SQL SERVER 2005, Oracle 10gi, Espresso Scheduler, HPOV

Confidential

Role: Sr. Developer

Responsibilities:

• Analysis, Development, Testing, Production Support, Interaction with client,
• The SPOT is the Enterprise Data Warehousing production monitoring, support, maintenance enhancement project. The SPOT will be supporting the Chrysler Financial CF , Mercedes Benz Financial MBF and DC Truck Financial Truck , retail and lease business areas at DaimlerChrysler Financial Services Americas LLC DCFS in US, Canada, and Mexico with a Single Point Of Truth for company data.
• SPOT has been engaged with Teradata Professional Services in the foundational build of the Data Warehouse environment as well as the planning, designing and building of the first iteration of the project which focuses on the Dealer Credit systems. The second iteration focusing on Credit Risk. The goal of the project is to improve both the quality and availability of data needed to drive decision making for the whole organization.
• Troubleshoot complex problems on new and/or existing products.
• Ensure all project documentation is completed and follows required Standards.

Technical Environment: Informatica 7.1.3, Teradata 7.1

Confidential

Role: Module Leader

Responsibilities:

• Analysis, Development, Documentation, Testing, Interaction with client, Onsite-offshore co-ordination.
• Working with DCX Shared Services B.I. team. DCX Enterprise Data warehouse provides a central, integrated repository for all management reporting requirements. Data from various operational sources are extracted and populated in data marts such as MyPersonnel which stores information about HR of DCX. Other data marts are FLEET, VMMD and IPATS etc. These data marts are formed to separate analysis workload from transactional database and to enable a business consolidate data from several source.
• These data marts constitute Enterprise Data warehouse for DCX. This is intended to provide a central database for decision support throughout the enterprise.
• Troubleshoot complex problems on new and/or existing products.
• Manage support process
• Unix shell script
• Ensure all project documentation is completed and follows required Standards.

Technical Environment: Data Stage 7.5.1, DB2, Microsoft Visual SourceSafe

Confidential

Role: Sr. Developer and Team lead for Testing

Responsibilities:

• Analysis, Development, Documentation and
• Team Lead for Testing,Onsite-Offshore interaction
• This project involves the conceptualization, design analysis, development and implementation of an Enterprise-wide data warehouse for Honeywell International Inc. to help in the availability and management of Functional Aerospace data across various departments. In order to get a complete overview of their business and facilitate informed decision making Honeywell has embarked on FAIR program.
• Enable the aerospace with an Enterprise Data Warehouse EDW that sources data from different legacy systems
• Project involves maintaining Enterprise Wide Data Warehouse that contains the data from SAP Rapid Mart and various legacy systems. In addition to this reporting capability to monitor and control different business parameters

Technical Environment: Informatica 7.1.2, BODI 6.5, Oracle 8i, PL/SQL Developer, Microsoft Visual

Confidential

Role: Developer

Responsibilities:

• Analysis, Development and Testing, Onsite-offshore co-ordination
• Carried out the following activities:
• Analysis, coding and implementation of Change Request using Informatica
• Report generation using MicroStrategy.
• Developed ETL mapping using Informatica PowerCenter 7.1.1 to load data from flat files, oracle to staging Oracle and from staging to Teradata
• Created sessions from Workflow Manager for mappings.
• Developed Shell Scripts to run sessions.
• Designing test cases and obtaining results

Technical Environment: Informatica 7.1 , Oracle 8i, Teradata, Toad.

Confidential

Role: Sr. Developer

Responsibilities:

• The abstraction ensures that, an application that wishes to use the services of the SST does not need to know the intricacies of a specific peripheral device. Service Providers SPs form an integral part of the XFS compliant architecture. Currently the SPs are only qualified on Win NT and Win 2000 platforms. The objective of this project is to qualify the SPs on Windows XP platform.
• Carried out the following activities:
• Study of Security Policies of Tata Infotech Ltd
• Prepared Tata Infotech Ltd and Diebold Security Policy Quiz.
• Involved in Security Audit Issues.