Professional Summary

• Overall 9 years of IT experience in Data warehousing and Data Migration projects, primarily as specialist in performing Analysis, Design, Development, Testing, Implementation , Migration, Deployment, Enhancement and Maintenance of Informatica ETL solutions in Production and Non-Production Environments.
• Extensive experience with Informatica Power Center 9.x, 8.x, 7.x, hosted on UNIX, Linux, and Windows platforms.
• Worked extensively with Data migration, Data Cleansing, ETL Processes and Web reporting.
• Extensive knowledge on the SDLC development life cycle. Involved in different phases starting from Requirement Gathering to Production Deployments and warranty Support.
• Informatica Powercenter Administration for Development, Test regions Production Environment
• Consistently recognized for technical troubleshooting skills used to rapidly and cost-effectively resolve challenging technical issues.
• Handling environmental issues and resolving them by coordinating with Informatica Support
• Have good knowledge setting up the environment on the Citrix servers
• Maintaining 100 availability of Informatica environment for Project teams
• Migrating Applications/Code as a part of the Project Implementation
• Established process to streamline changes and approval mechanisms to ensure SOX compliance
• Providing solutions at the Data Warehouse Architect level
• Defined, documented and implemented development standards, best practices, Configuration and change management mechanisms.
• Gathering functional specifications and business requirements and performing source system analysis, Data profiling.
• Proficient in converting business requirements to technical specifications and creating design documents and mapping documents.
• Strong experience in designing and developing complex ETL extract, transform, and load mappings, reusable components and performing power center administrative tasks.
• Extensive experience in implementing error handling, auditing and reconciliation and balancing mechanisms in ETL process
• Experience in defining testing strategies, creating test cases for unit, functional and integration testing, documenting test results.
• Expertise in defining and documenting ETL Process flow, job execution sequence, parameter file requirements, Job scheduling and alerting mechanisms using command line utilities.
• Proven experience working with various source systems Oracle, Teradata, SQL Server, Microsoft Access, XML, Flat Files in Informatica
• Expertise in trouble-shooting production issues by root cause analysis to identify the problem, impact analysis to determine the dependencies and providing the resolution.
• Experience in identifying performance bottle necks and fine tuning informatica jobs.
• Experience in writing Unix Shell scripting.
• Experience in mentoring development team, conducting code reviews and design reviews.
• Committed individual with excellent interpersonal, analytical and communication skills
• Ability to work simultaneously on multiple projects, work independently as well as a team member and as a team lead.
• Own the responsibility to deliver quality deliverables within the project timelines
• Involved in Review meetings during Design Development to identify, reduce/mitigate risk at every stage.
• Supervised the Offshore activities.
• Educated Developers on the use of Informatica's 'Best Practices', which were employed across the life cycle of the project.
• Created Standard migration checklist promotional checklist document template
• Designed and Developed ETL Extract, Transformation Load strategy to populate the Data Warehouse from the various source systems feeds using Informatica PowerCenter Server.
• Imported Sources and Targets, Created Mappings and developed Transformations using Informatica PowerCenter designer.
• Used Transformations like Source Qualifier, Lookup, Expression, Router, Aggregator, Joiner and Sequence generator.
• Used Type 2 SCD Mapping to insert new Dimensions and update Dimensions in the Target and maintain the history.
• Developed sessions using Power Center, Workflow Manager for loading the data into target database.
• Responsible for developing PL/SQL Stored Procedures, Functions, Packages, triggers and other database objects.
• Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks.
• Documentation of mappings, sessions, sources and Targets involved in the ETL process.
• Wrote UNIX and PL/SQL scripts for pre post session processes and to automate daily loads.
• Experience in using third party tools like Toad, PL/SQL developer.
• Experience creating Partition for informatica and DB level.
• Experience in replicating data from different sources to different targets Oracle, SQL Server.
• Experience in reconciling the data.

Professional Experience

CNOFIDENTIAL

Project details and Accomplishments

• Build Consolidated EOD Stock Record FISS, GOS, BPSA, IMPACT Loanet to provide global view of Positions Available, Depot, Firm/Client
• Data Knowledge
• Gain detailed business knowledge of settlement and reference data
• Establish normalization and data transformation rules across systems.
• Data Quality
• Define Data Exception Types
• Define proper data controls and daily checks.
• Expose Data Quality Exceptions to Operations
• Establish exception management process with IT and Operations.
• Build New Back-Office IT Infrastructure
• Establish Application Development Framework Event Channel
• Begin to Build Common User Interface/Portal
• Consolidated / Shared Data Environments ODS DWH
• Move future development to be incremental off our new development foundation

Role Responsibilities:

• Working closely with the application developers, infrastructure, team leads, and customers to ensure all data services work assignments are completed on time and with the highest level of quality.
• Responsible for Effort Estimation, Tracking work progress, coordination with various teams, Clients, Users, Onsite team and offshore team.
• Prepared Work status report WSR , System design doc, High-level designs doc and Implementation plan and Migration doc.
• Involved in analyzing source data, code data and matching with control total.
• Developed scripts and stored procedures, functions, triggers and indexes as per business requirement using Shell, SQL, and PL/SQL.
• Prepared and reviewed ETL design doc complex mapping, test case and involve in User acceptance testing.
• Developed informatica mapping, mapplet, workflow, worklet, session and business transformation.
• Developed Unit test case for Informatica sessions and workflows.
• Bug fixes and Requirements gathering, Analysis, Design, Development and testing for the identified enhancements
• Performance tuning at ETL and database level.
• Integration testing of the developed applications.
• Support Functional, UAT Production.

Environment: Informatica PowerCenter 9.1, Oracle 10G, SQL, PL/SQL, TOAD 9.7.2.5, Putty SSH Client, Autosys, Perforce, Shell Scripts, UNIX, Windows XP.

CNOFIDENTIAL

• The iDWH application is single source of consolidated data aims at providing an enterprise-wide view of the business at the Credit Suisse's PB sites. It is main source of information for reporting and analyzing Data Marts DM , including all departments, lines of business and business functions.
• The monthly loading is integrated process comprising of Global Informatica Jobs, T24 Informatica Jobs, Patch script, check script and hard coded script.
• Except the Informatica Jobs, all the scripts are run manually using Oracle SQL or command window.
• Production support team prepares the monthly loading plan and they execute the jobs/scripts in the sequence mentioned in the loading plan. Due to human interventions, there are high possibilities of committing the human error in ME loading. This project aims to automate the ME loading process. Existing scripts were converted to procedures and were triggered by Control-M scheduling tool .

Role Responsibilities:

• Involved in Requirement gathering, design, development, testing, migration and production support.
• Enhancement in Informatica mappings oracle procedures, function and jobs for loading data into data warehouse
• Performance tuning at ETL and database level.
• Bug fixes and Requirements gathering, Analysis, Design, Development and testing for the identified enhancements
• Integration testing of the developed applications.
• Support Functional and UAT.
• Developed informatica mapping, mapplet, workflow, worklet, session and business transformation.
• Developed Unit test case for Informatica sessions and workflows.
• Providing L2/L3 level support for the Informatica project
• ETL design provided for error detection, reusable worklets to capture the workflow run time and intimate the user in case of any delay in the run
• Documenting the process for various Informatica tasks like recovering workflows, Informatica installation, review-checklist document, naming standards, migration document etc.

Environment: Informatica Power Exchange, Oracle 10G, SQL, PL/SQL, Putty SSH Client, Control M, Perforce, Shell Scripts, UNIX, Windows XP.

CNOFIDENTIAL

• Description: Project involves migration of Project and related information from 5 source systems Project Tracking System, Facilities Direct, New Build Database, Project Planner and Archinet on SQL Server platform to a single target system Skire, also on SQL Server. The migrated data will be used as source for display on Unifier the Graphical User Interface of Skire.
• Confidential is a system for managing the flow of information in projects or shells, providing a seamlessly automated and integrated environment across the lifecycle of a company's facilities, from planning, design, procurement, construction and operations and maintenance. It provides real-time visibility across multiple projects or shells to help a company make fast, accurate decisions.
• Audience of this document is all stake-holders involved in the implementation of Skire.

Role Responsibilities

• Co-ordinate with Onsite team for requirement gathering issue resolution.
• Developing Informatica mappings procedures, Function and jobs for loading data into staging and Warehouse
• Involved in creating the mappings in order to extract the data from source to target using Informatica tool.
• Monitoring Supporting and tracking of deliverables
• Provide ETL solutions as well as Business Solutions
• Integration testing of the developed applications
• Co-ordinate for production rollout in conjunction with the release team

Environment: Informatica Power Center 8.6, SQL Server 2008, SQL, TSQL, UNIX, Windows XP, XML, XSD

CNOFIDENTIAL

Description: First Next Generation Enterprise Data Warehouse released, establishing a complete infrastructure and foundation for Cisco's Data Warehouse Platform on Teradata. The Cisco's existing Data Warehouse is a 7 Terabyte Oracle Database, which stores the historical and operational data of all the measures like bookings, revenue, expense of Cisco Systems, Inc. but as the data increases the performance of the data warehouse decreases. So, now Cisco decides to change the database from Oracle to Teradata which has the capability to handle large amount of data. The architecture of the project mainly comprises of 3 Layers Stage, Work and 3NF layer. Time variant scenarios come into picture in work layer and in 3NF layer history as well as current data resides. From 3NF layer views are created for reporting purpose. The project also implemented advanced features that Informatica and Teradata are offering such as Push down Optimization, Fast Load, TPUMP and other Teradata utilities.

Role Responsibilities:

• Track and report project metrics, measurements based on the SLA and deliver on committed dates.
• Co-ordinate with Onsite team for requirement gathering /issue resolution.
• Developed the knowledge base within the project for a quick reference.
• Involved in creating the mappings in order to extract the data from source to target using Informatica designer
• Designed and developed Informatica Mappings and Sessions based on requirements and business rules to load data from Oracle to Teradata target tables.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations using Informatica Designer.
• Involved in validations of mappings and compared the mappings in development folders and system test folders
• Encountered different ETL issues like scheduling the job with U.
• Worked with different teradata utilities like FLoad, Mload Tpump, Bteq
• Performance tuning at teradata database level implemented collected stats on table

Environment: Informatica PowerCenter 8.6, Informatica KP Kintana Package , Teradata Ver 12, Dollar Universe, Teradata SQL Assistant, PVCS, Shell, UNIX, Windows XP

CNOFIDENTIAL

Description:

• The primary objective of Heart Suite CVIS is to provide the full spectrum of information management needs - clinical, financial and administrative, for Heart Centers. It provides a single point of access to obtain information relating to the patient's current status and historical cardiac care events and results. The patient demographics and status, diagnosis, medications and a list of all cardiac events and procedures is provided in a single view with access to detailed clinical data and reports.
• CVIS provides reports and ability to query the database for clinical and procedural information. CVIS is completely web based. There is nothing that needs to be installed or downloaded to the client. This allows the application to be used from anywhere in the hospital or sites external to the hospital network using VPN.
• Cardio IMS provides the following functionality:
• Patient Demographics
• Cardiac Patient Summary
• Encounter Registration
• Inpatient Census
• Scheduling
• Reporting

Role Responsibilities:

• Performance tuning at database level.
• Worked on Stored Procedure, Package in Oracle.
• Tuning the SQL queries for improving performance.
• Release it in to production and test server for client.
• Encounter database related issue BUG .
• Estimation and Impact Analysis. Changes PL/SQL code according to improve performance of database.
• Leading and Development of CVIS.
• Changes in SP and packages according to CVIS 3.1.2

Environment: Oracle 9i, PL/SQL, ORBIT 5.1 VSS, UNIX, Windows XP

CNOFIDENTIAL

Description: Web based solution for IFA and its clients to do activities like bulk order booking, online/offline transactions, use financial planning tools, calculators, BI reporting, practice management and utility services To develop back office Intranet application for Fidelity business community and back-office fidelity staff to act on various workflows, view MIS reports. To implement internet/intranet application based on Fidelity technical standards Build a system which is scalable, extensible and easy to maintain and which is in compliance with Fidelity's performance, quality and security requirements. To provide higher visibility to Fidelity management via MIS reports and dashboards to take business decision. Financial Planning Tools will allow an IFA to quantify the financial goals of his client s and create alternative scenarios in the form of financial plans to achieve these goals. This module will also provide for some standalone investment calculators which can be used by any one visiting the IFNW website.

Role Responsibilities:

• Business intelligence requirement study and analysis and implemented in EDW Database.
• Database designing and Implementation.
• Create and maintains stored procedures, package, function, trigger, cursor, oracle scripts.
• Implement batching process for informatica
• Data Warehouse Analysis.
• Estimation and Impact Analysis.
• Involved DBA activity like take daily back up and run script for source environment.
• Change Request Management, Functionality analysis
• Client interactions.
• LEAD ELTP team assigns and review task for them
• Provided Production support

Environment: Informatica 8.1, Oracle 10G, TOAD, PL/SQL, SQL, TOAD, Control-M, Shell, UNIX, Windows XP

CNOFIDENTIAL

Description: Dedupe System is the process to verify whether the customer is an existing customer, customer in the negative list or black list category. A numbers of factor are taken into consideration while running Dedupe on a customer. Dedupe system will be ensure that the customer is a genuine one .The system will check the details against the already existing database of past customer to determine any cases that match any information in the application form. Any possible matches will be displayed on the screen or printed.

Role Responsibilities:

• Understanding the system and the data flow within the system
• Used SQL and stored procedures, functions, triggers and indexes.
• Bug fixes and Requirements gathering, Analysis, Design, Development and testing for the identified enhancements
• Implementation of the business rules at the backend using

Environment: Oracle 9i, SQL, PL/SQL, TOAD, Windows-XP Professional

CNOFIDENTIAL

Description: This project is developed for water purifier company. For this project various branch information are maintained and administrator can seen all the records of there agent. Agents are responsible for sales of product and product demonstration.

Role Responsibilities:

• Understanding the system and the data flow within the system
• Used SQL and stored procedures, functions, triggers and indexes.
• Requirements gathering, Analysis, Design, Development and testing for the identified enhancements
• Implementation of the business rules at the backend using

Environment: Oracle 9i, SQL, PL/SQL, TOAD, Windows-XP Professional