SUMMARY

• Around 8 years of Business Discovery, Data Discovery & Analysis, Data Modeling, ETL Design, Development, Testing, Implementation and Troubleshooting in the field of Data warehousing and Application Development.
• 6 Years of strong Datawarehousing experience specializing in RDBMS, ETL Concepts, Strategy, Design & Architecting, Informatica Administration, Development & Testing.
• Around 2 Years of experience in OLAP concepts and Report development, RDBMS
• An expert in the ETL Tool Informatica which includes components like PowerCenter, PowerMart, PowerConnect, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Administration Console, PowerExchange CDC,Teradata, IDE - Informatica Data Explorer, IDQ - Informatica Data Quality, Informatica Visio Data Stencil. Have had extensive experience in working with various PowerCenter Transformations using Designer Tool. Have handled various Data Sources like DB2, Oracle, SQL Server, MS Access, MS Excel including MF COBOL EBCDIC Files, Flat Files and XML Files.
• Have had extensive experience working with databases like IBM UDB DB2, Oracle and MS SQL Server,mainframe IMS and mainframe VSAM
• Was involved in the complete life cycle of quite a few Datawarehouse implementations which include System Architecture, Functional/Technical Design, Development - Coding and Testing (Unit Testing, System Integration Testing and User Acceptance Testing) and Implementation.
• Good experience in Unix Shell Scripting and ETL Process Automation using Shell Programming and Informatica. Also have had quite good experience in Performance Tuning at both Database Level and Informatica.
• Good experience in physical/logical data modelling using Erwin
• Good experience in various Industry verticals like Retail, Manufacturing, Pharmacy - Health Care, Finance, Insurance, Mortgage, Telecommunication and Automobile with appropriate DW/ETL Implementations.
• Strong Logical and Analytical Reasoning Skills, Excellent Communication with good Listening, Presentation and Intrapersonal Skills.
• Strong Team building and mentoring skills and excellent Team leadership capability.
• Very good knowledge in working with Windows and UNIX operating systems.
• Experience in ORACLE/Informatica performance tuning techniques.
• Designing multi dimensional modeling for data warehouse applications.
• Proficiency in Oracle PL/SQL. Expert in creation of stored procedures and custom SQL to define ETL processes
• Played various roles like configuration manager, Defect prevention Representative, Software quality Analyst and Team lead.
• Played various roles on Projects that required Datawarehouse Consulting which include Datawarehouse ETL Architect, Program Technical Lead, and Project/Team Lead and Managerial roles with a maximum project team size of 10 Consultants.

AWARDS/ ACHIEVEMENTS

• Cleared Informatica Powercenter Version 8 Mapping designer certification exam
• Received Valuable Contribution Award for Q3, 2008 at Genworth.
• Got Pat on Back award for Q3, 2009 at Metlife.

SKILLS

RDBMS: Oracle 10g/9.x/8i/7.x, SQL Server 6.5/7.0, MS Access 7.0, DB2 8.0 ,
ETL Tools: Informatica Power Center/Power Mart 8.5/8.1/7.x/6.2/5.1 Power Exchange
OLAP: Business Objects (Designer, Reporter, Supervisor ) , Cognos Report studio
Operating System: MS-DOS, Linux, UNIX, Windows XP/ NT/2000/ME,
Data Modeling: Erwin 3.5.2/4.0
Languages/Utilities: C, C++, Java
GUI Tools: Developer 2000 (Oracle Forms & Reports 6i, 9i)
Other Software: TOAD, Crystal Reports 8.0/6.0/4.6

EDUCATION

• B.Tech Electrical and Electronics

PROFESSIONAL PROFILE

Confidential
ETL Technical Lead/Architect Mar 2009 - Till Date

The customer,Confidential, is in the business of Insurance.

Confidential, is in the process of building an Enterprise Data Warehouse for Individual Business. The Individual Business Data Warehouse will integrate the information from various data sources into one central repository providing the organization a cross-enterprise consolidated view of the information. The Individual Business Data Warehouse will serve as the primary source for the data marts. The purpose of this project is to get the information loaded into the Individual Business Data Warehouse required to support the Compliance Events component of the Compliance Data Mart.

Project Environment: Informatica 8.6, DB2 UDB version 7, UNIX shell scripts, Maestro scheduler, Powerexchange 8.6, Mercury Quality Center,mainframe VSAM and SQL Server 2008,Erwin

Roles & Responsibilities:

As a Architect/Lead:

• Played the role of a Program Technical Lead/ETL Architect and was responsible for designing the ETL Strategy & Architecture of the Project.
• Was responsible in managing tasks and deadlines for the ETL teams both Onsite and Offshore.
• Was the point person on the ETL team for other teams such as Reporting, Testing, QA and Project Management for updates on Project Status and issues.
• To get the Functional Requirement Specifications from customer and understand the same.
• Understand the Insurance domain functionality.
• Break up the work into task list and estimate based on simple, medium and complex methodology
• Interaction with business users and requirement gathering.
• High level & low-level ETL flow design
• Involved in detailed technical design
• Give functional KT to the QA team.
• Was involved in conducting the review of Informatica Code, Unit Test Cases & Results with the Developers.
• Organize daily technical discussions with the Onsite team also including the individual offshore workstream leads and set expectations for Offshore delivery.

• Create mappings employing various transformations, filters, joiners, lookup, SQL overrides etc to load data from multiple databases into Warehouses
• Creation of Sessions and Workflows to schedule these mappings.
• Creation of Unit Test cases and Integration test cases
• Perform unit testing of these Workflows from source to staging and staging to Warehouse of data warehouse
• Reconciliation and evidence creation.
• Analysis & fix on QA defects made by QA team.
• Involved in Unit testing and UAT defect fixing.
• Was involved in Informatica Power exchange to import Mainframe DB2 sources.
• Was involved in Informatica Power exchange to test the data at mainframe .dat files.
• Involved in sessions partitioning and mappings performance tuning.
• QA & Prodution deployment.
• Creation of stored procedures.

Confidential
ETL Technical Lead /Architect Jan 2009 - Feb 2009

Confidential, is an American, multinational, Fortune 100 telecommunications company based in Schaumburg, Illinois. It is a manufacturer of numerous products for use of the government, public safety officials, business installments, and the general public. These products include cell phones, laptops, computer processors, and radio communication devices.
Enterprise Data Warehouse project has been started by Motorola to capture transactional data from all the ERPs spread globally so that reporting is consistent for all regions from a common source system. This will help in improving accuracy of reports, reduce ambiguity and improve the quality of decisions. The project implementation requires thorough understanding of ERP systems, Data warehousing concepts and tools (ETL/Backend) along with the functional and business knowledge.

Project Environment:Informatica 8.1.1, Microsoft Visio 2000

Responsibilities:

• Was responsible in managing tasks and deadlines for the ETL teams both Onsite and Offshore.
• Requirement gathering and requirement Analysis
• Interacting with the client on various forums to discuss the status of the project
• Giving the inputs & sharing the knowledge with other team members.

Confidential
ETL Technical Lead/Architect Aug 2008 - Dec 2008

The Approval Chain application has been designed to Generate Approval Chain for Supervisors and to identify the association of an employee to a particular chain of approvers.

The Necho Expense application has been designed to support capturing, approval and submission of business related expenses. As a part of these User Import feed will be created, which will keep track of New Users, Deactivation of Users, Change of Sub-Business, Function, Cost Center and Company of users and addition of new credit cards to the user profile.

There are various elements viz., Organization, Subbusiness, Function, Expense Group, Cost Center, Company, Client and Project and Expense Type are stored in the system and these elements have relationships in between. First time load requires to identify all active elements in the system, relationships between different elements and compare them with the elements and relationships generated from different source files. The final data generated will be provided to users.

Project Environment:Informatica 8.1.1, Microsoft Visio 2000, ANSI SQL, IDE, IDQ, Informatica PowerExchange, Informatica Visio Data Stencil, Teradata, Crystal Reports

Roles & Responsibilities:

• High level and low level ETL design.
• Was involved in training the customer on some of the Informatica related technologies such as IDE, IDQ and Informatica PowerExchange.
• Had used IDE - Informatica Data Explorer to profile Customer & Claim information for faster data analysis.
• Was responsible for the Configuration Management and Code Migration between various environments using Informatica with Release Management and Versioning.
• Was involved in coordinating with the Networking & Business Firewall teams in resolving connectivity issues with the Source Systems.
• Had implemented Unique Person Identifier - UPI logic to uniquely identify people and be able to obtain a 360 degree view of every person in the organization.
• Was involved in conducting the review of Informatica Code, Unit Test Cases & Results with the Developers.
• Was involved in loading data to Tera data by using informatica external load.
• Utilize the Teradata utilities (Mload, Fload and Tpump) and BTEQ.
• Create reports.

Confidential
ETL Technical Lead/Architect/Co-ordinator Jan 2008 - Jul 2008

The Unified Oracle GL Process has been designed to generate the General Ledger Records for different countries. At the end of the Unified Oracle GL Process different files will be generated based on Set of book country value on the GL line. Each file includes header, detail, summary and footer records. The final files will be generated by the Unified Oracle GL Process and FTP\'d to the specified location. The process involves generating GL Files, FTP of the final Files, archiving of the final data files and sending e-mail notification.

There was a requirement to process weekend\'s approved reports on Monday along with current day\'s Approved report. Process should run only from Mon-Fri irrespective of US Holidays. Reports, which are out of balance (If sum of ER02 lines is not matching with corresponding ER01 amount) or expense lines on report having Blank/Invalid Legal Entity, will not be processed and will be logged into an error file. For this an email is to be sent to the predefined business user group notifying them of the error. Such error lines will be stored in a database table, which can be corrected by Business users. The following day any transaction marked as corrected should be included in the GL file. Also Summarization of the approved report by SOB country will be provided in E-mail to the predefined user group.

Project Environment:Informatica 7.1, Teradata V2R5, Netezza 3.1, Solaris UNIX, Microsoft Visio 2000, ANSI SQL

Roles & Responsibilities:

• Had played the role of an offshore ETL Technical Lead/Architect on this Project and was responsible for creating Technical Specs & Low Level Design for Offshore development.
• Was completely responsible for offshore delivery and the creation of WBS - Work Breakdown Structure for the offshore team.
• Played the role of a Project coordinator between various work streams within the project and create Unit Test and Integration Test Plans.
• Organize daily technical discussions with the Onsite team also including the individual offshore work stream leads and set expectations for offshore delivery.
• Provide Daily and Weekly Status Updates to the Project Manager and the Engagement Manager.
• Was responsible in performing Integrating Migrated code and performing Integration Tests from Offshore and publish Test results to the onsite team.
• Was involved in the creation of SQL scripts for balancing financial data between Teradata and Netezza systems with Parallel testing procedures.
• Was involved in creating BTEQ scripts
• Was involved in loading data to Tera data by using informatica external load.
• Utilize the Teradata utilities (Mload, Fload and Tpump) and BTEQ.

Confidential
ETL Technical Lead Oct 2007 - Dec 2007

Genworth uses an externally hosted travel Expense Management system (hosted by Cybershift Inc) to manage the process of Travel Expense submission and approval by Genworth employees provided by NECHO.

After an expense report is approved, it will be available in the Necho extract the following day.
Expenses in the expense report are validated for various details like Bank account information for US and CAD reimbursements, Valid Company, Valid reimbursement currency and organization, Valid Cost center and payroll information. Expense reports which fall under Error category explained above would not be processed till the correct data is received. Till that time report will be in Backlog File. Every Day expense reports approved on previous day and reports in Backlog are processed to reimburse the valid expenses. Only US and CAD reimbursements are sent to Banks, others are routed to respective country\'s payroll.

If the reimbursements, which are sent to the bank have incomplete information then they are sent back for processing. Whenever required information is available reimbursement with the correct details will be sent to respective bank for processing. This module gives the summary of expense reports processed from backlog, approved on previous day, entered in backlog file due to errors, returns processed. It also has check on total expense reports approved on previous day against total expense reports processed and total expense reports backlogged.

Project Environment:Informatica 7.1, Oracle 9i, Microsoft Visio 2000
Roles & Responsibilities:

As a Lead:

• Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.
• Giving the inputs & sharing the knowledge with other team members.

As a Configuration Manager:

• Maintain the updated version of all the software, which is used for the project.
• Update all the project related documents in VSS, the project-tracking tool.
• Maintain the traceability of the project workflow using Trace DB tool.

As a Defect Prevention Representative:

• Have a constant follow-up whether the defects for each task is been logged on to the defect tracking system.
• Take out the defect metrics using the Defect Pareto methodology.
• Conduct Defect Prevention meeting in a periodic basis and note down the minutes and action items.
• Implement the action items and do a constant follow-up whether the said items are thoroughly followed or not.

Confidential
ETL Technical Lead Mar 2007 - Sep 2007

Confidential, automation Project is designed to replace the current manual process, which
Segregates the Europe approved reports, Identify the payroll country and send the reimbursement to the respective payrolls.Europe payroll process uses override logic to override a legal entity for some employees. Also payroll country is decided based on Legal entity. Override and Legal entity to country mapping is stored in Database tables.

Oracle forms are provided to users to maintain these details. For the first time existing files will be loaded in the Database tables. Going forward users will Add/update/Delete the data in this table through Oracle form.

As a Lead:

• Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.
• Giving the inputs & sharing the knowledge with other team members.
• Create and assign task entries in EPMS (Web based timesheet management) for other team members
• Discuss the project status with the managers on a weekly basis.

Confidential
ETL Technical Developer Dec 2006 - Feb 2007

The goal of this project is to automate the entire head count module. Headcount reporting is used by to track and report GNW employees. The UO data controller will process the headcount interface. The interface will enter statistical data to the GL. The data is not financial data. It does not require a balanced transaction. This document details the interface between the Oracle Human Resource and Unified Oracle General Ledger.

Confidential
ETL Technical Developer Oct 2006 - Nov 2006

Confidential, uses CWT (Carlson Wagonlit Travel) portal for the travel information. Currently this portal is maintained manually where in data is entered through front-end screen.

Confidential, uses an externally hosted travel Expense Management system (hosted by Cybershift Inc) to manage the process of Travel Expense submission and approval by Genworth employees provided by NECHO.

As an analyst:

• To design the whole informatica workflow that is derived from four PLSQL packages that are running currently.
• To prepare the detailed design document for the whole project execution

• Requirement gathering and requirement Analysis
• Create PowerCenter Code creation
• Code testing
• Code migration to the production.
• Conduct reviews
• Create Oracle forms & Reports for business users.
• Create Crystal reports according to the requirements.
• Create Unix shell scripts in automating the complex tasks.
• Providing level 1 support and resolving the failures as per SLA.

Confidential
ETL Programmer Jan2006 - Aug 2006

PlatformInformatica 8.1.0, Business Objects 6.1(b)

Through this initiative Guardian aims to consolidate agency expense, production and management data in a centralized database for reporting and analysis. The project aims to exploit the power of data warehousing tool Business Objects (BO). Set of New ETL Processes will be created to load the data from mainframe flat files into data warehouse tables and Business Objects Universe will use this data for generating reports. BO shall be used to generate 4 standard reports that shall be scheduled at a specific frequency. In addition to this, the Universe developed shall help business users, who will be located at single location (NY), to generate ad-hoc reports on their own.

As a developer:

• Requirement Analysis - Understanding the existing system.
• Interacting with the client on various forums to clarify any queries regarding the functionality and appropriate access required etc.
• Involved in designing the database model.
• Logical and Technical Documentation.
• Create ETL Folder structure at the UNIX server & Client repository set up.
• Installed client software\'s like Oracle 9x, Informatica Power Center 8.1.1,TOAD, PUTTY.
• Extracted COBOL source definitions.
• Validated user ID\'s for both FTP & UNIX in all 3 environments and created appropriate folders. Ftpped source files into appropriate folder.
• Develop mappings for source to staging database and staging to Target database.
• Creation of Informatica sessions and workflows.
• Created Archive script for the source Files and analyzed scheduling methods
• Report design and development (Business Objects 6.5).
• Modifying reports as per the client requirements.

As a Tester:

• Prepared the required ETL unit test cases for assigned modules.
• Self Review of Unit test cases, Integration test cases of all the assigned modules.
• Do the detailed unit/integration testing.
• Data Validation at report level with the database.

Confidential
ETL Programmer/ Admin Jan 2005 - Dec 2005

PlatformInformatica 6.1.2, 6.2.2, 5.1.2, UNIX

With nearly 6,000 employees and almost 2,400 financial representatives in 119 general agencies, Guardian is the fourth largest mutual life insurance company in the United States. Founded in 1860, Guardian and its subsidiaries today provide almost three million people with life and disability income insurance, retirement services, and investment products such as mutual funds, securities, variable life insurance, and variable annuities.

Responsibilities:

• Providing level 1 support and resolving the tickets as per the SLA
• Monitoring daily, weekly, monthly Informatica workflows in Production
• Resolving workflows in case of failures.
• Escalating to on-call person incase of unresolved errors using trouble ticketing system.
• Making appropriate changes to schedules when some jobs are delayed.
• Proactively sending advanced notifications to users in case of known delays.
• Maintaining crontab jobs used in scheduling.
• Attending MOM on a daily basis.
• End of day reporting, monthly reporting to customer manager.
• Involved in upgrade testing of workflows from version 6.2.2 to 8.1.0
• Documenting the workflows and creating flow diagrams for the same.
• Informatica User Administration.
• Install powercenter version 8 on UNIX platform.

Confidential
ETL Programmer Sep 2004 - Dec 2004

PlatformInformatica 6.1.2, PL-SQL

Berkshire introduced a new product line, Long Term Care (LTC) in September 2004. The LTC product is administered by an outside vendor, LCA. LCA sends updates to Berkshire who in turn sends files to the Guardian FTP server.
Currently, these data files are first loaded into the GDW database on a nightly basis. A nightly view refresh process then runs to update the final UCVMART views which are accessed by the Client Manager application The original implementation of the LTC to GDW mapping did not correctly handle change records as documented. Additionally, later project to incorporate additional Individual products into GDW were cancelled. Therefore, the team has determined that the best approach for correcting the implementation problem is to load LTC data directly to the UCVMART tables. This is consistent with the Berkshire DI, Guardian DI and Equity load.

Responsibilities:

• Involved in creation of mapping from Source to Staging.
• Involved in writing SQL-scripts from Staging to Data mart.
• Created sessions and workflows with the appropriate connection variables.
• Interacting with onsite team members on various forums to discuss the status of the project.

Confidential
Developer Feb 2004 - Aug 2004

PlatformBusiness Objects 6.1(b), PL-SQL, UNIX

Guardian has brought a new system called Navisys - A third party policy management tool for Policy Management Activities. Navisys system will merge all the different Policy Admin Systems currently being used by Guardian into a Single System. As a part of this initiative, Guardian is first planning to migrate Cyberlife, one of the policy Admin systems, into Navisys.
This project is to automate the process of generating Accounting, Disability, Billing, Compliance, Inforce Maintenance, Management, Quality Assurance and Reconciliation reports with Navisys as the source system. These reports were first being generated from Cyberlife on demand basis. In addition to this automation, monthly, previous day and daily snapshot of data will be taken for facilitating adhoc reporting on data elements of canned reports and certain data elements

• Manually restarting the UNIX script.
• Creating and modifying UNIX scripts.
• Testing of data for summary and detailed queries.
• Fix database errors while running PLSQL scripts.
• Prepare PLSQL scripts for data loading into warehouse and mart
• Create/modify BO reports
• Prepare complex SQL queries to use in BO freehand SQL

Confidential
Team Member May 2003 - Jan 2004

PlatformBusiness Objects 6.1(b), PL-SQL

This project deals with the enhancement for the existing Equity Universe requiring modifications to 60 objects and creation of 320 new objects. For creating new objects in the Equity Universe they need to be present in the Equity data mart.
So the data is extracted from the Transcend source tables to the data mart tables. Currently the data is extracted using PL-SQL scripts.
For extraction of data the existing PL-SQL scripts were modified and new scripts were created. Once the data was in the Equity data mart the objects were created in the Equity Universe.

Responsibilities:

• Analyzing, creating and testing of reports.
• Logical and Technical Documentation.
• Creating Universe database for end user reports by using Business objects.
• Creating classes and objects according to the business requirements and generating the reports.
• Create Procedures
• Run PLSQL scripts and debug errors
• Fix sql errors within the deadline.

Confidential
Software Trainee Nov 2002 - Apr 2003

The Promotion History data is currently loaded into the CCDM as part of the semimonthly database build. The purpose and objective of the current project is to address two issues related to Guardian Scheduled Direct Mail Campaigns and Re-mail Campaigns: Since Campaign schedules do not correspond to the semi-monthly build schedule, there is often a lag time between when a campaign is dropped and when that data is available on the CCDM; Since Choicepoint Precision Marketing (CPPM) is no longer involved in applying campaign suppressions or auditing of campaign files, Guardian Corporate Marketing and Guardian Oracle Database Administrators will assume the responsibility for loading the promotion history of Scheduled Campaigns into the CCDM.

• Analysis & Requirement Gathering
• Logical & Technical documentation

Confidential
Software Trainee Apr 2002 - Oct 2002

The Project Management Office (PMO) is responsible for reviewing and reporting the health of the IT projects undertaken for the benefit of its internal business customers. The client has an in-house project management system that records the project status. Every night data is extracted from the source database to a reporting data mart. Business Objects is used for generating the reports.

• Analysis & Requirement Gathering
• Logical & Technical documentation