Summary:

Over 11 years of diversified experience in the field of Information Technology with emphasis on Data Integration, Data Warehousing with diverse background in technology consulting covering multiple industries including Mortgage, Financial, Audit, Educational, Pharmaceutical and Hospitals. Expertise includes strong hands-on technical skills with Informatica PowerCenter on both Windows/UNIX environments following the Best Practices/Methodologies. Highly skilled in database development, data modeling Ralph Kimball/Bill Inmon/Dan Linstedt Enterprise Data Vault and has proven knowledge of working on the BI Tools like Cognos, Business Objects and Micro strategy. Had donned various roles such as Senior Developer/Consultant, Lead, ETL Architect and support both onshore and off-shore Projects.

Confidential

Integration Architect

• Design and implement the Overall ETL Framework for MBUS project.
• Responsible for all phases of the project including designing, developing, testing, roll-out and production support.
• Played an active, leading role in shaping and enhancing the overall ETL/Informatica Architecture.
• Design ETL Architecture/Processes to move data across systems bases on business user requirements.

Environment: Informatica PowerCenter 9.5.1, B2B, DX, MSMQ, SQL Server 2012, Oracle 11g.

Confidential

• Estimation and planning of the data integration solution.
• Interviewed client and conducted research to assess current state, gather requirements, and design future solution.
• Preparing the Macro design document outlining the end to end data integration solution.
• Prepared use cases, test cases, and load specifications for new processes.
• Analyze physical model and business specification documents to facilitate effective technical specifications

Environment: Informatica PowerCenter 9.5.1, Oracle, OHADI, Teradata, Netezza, UNIX, B2B, Hl7.

Confidential

HR Analytics: ETL Architect/Lead

The HR Analytics Project's main goal is to consolidate the different work streams that Honeywell is maintaining as of now and make sure there is one Centralized Data warehouse going forward.

• Manage a cross-functional team responsible for gathering requirements, pre-processing data, transforming and loading data into EDW
• Work closely with business users for gathering business requirements and constraints
• Deliver and document prototype within planned timelines to enable global usage across environments
• Responsible for the Informatica ETL design to extract data from multiple sources including PeopleSoft and merge the out of box ETL with custom development.
• Work with testing team in Planning and execution of SIT / UAT loads and facilitate defect triage meetings.
• Coordinated with the offshore team in assigning the work and monitoring the day-day activities.

Environment: Informatica PowerCenter 9.1, Erwin 7.x, PeopleSoft 8.3/9.1, DAC 10.x, OBIEE 11.x, UNIX, Autosys.

Confidential

SHEW: ETL Team Lead/Developer

Confidential is a non-profit health system in Northern California with more than 48000 employees. The main objective of the SHEW project is to consolidate the Sutter's Physician's information and create the Master Record information for the doctors.

• Conduct business requirements gathering sessions with lead business users and executives for the MDM Project.
• Architected the solution and ensure that it fits into the overall ETL/Informatica architecture at Sutter Health and Lead the resolution of technical issues of high complexity.
• Coordinated all aspects of the project with other teams, such as Data Architecture, Reporting, Quality Assurance, Support, Infrastructure as well as business owners and management.
• Identify, recommend and implemented process and architecture improvements.
• Managed the build phase and quality assure peer review the code to ensure that it meets the requirements and adheres to the ETL architecture.

Environment: Informatica PowerCenter 8.x/9.5.1, B2B,IDQ, HL72.3, SQL Server 2008/2012,EDV, IBM Initiate, Embarcadero.

Confidential

ETL Architect

• Worked with the Client Management team on the Master Plan for the given financial Year, planning, prioritizing and estimating new projects.
• Develop SDLC project plans to implement the ETL solution, including identifying resource requirements.
• Worked with BHCS Team on defining Informatica standards, Design guidelines, code checklist, delivery checklist and best practices and also continuously update it.
• Lead the team by creating/validating Standards for Informatica ETL Development.

Environment: Informatica PowerCenter 9.1, Oracle Exadata, SQL Server 2008, IBM AIX, COGNOS 10.x, Tivoli.

Confidential

ADM: ETL Team Lead/Architect

The Application Data Management ADM project's goal was to create a centralized repository of AHMSI focused on LPS Data. ADM will extend that providing the source of data for several downstream applications SAF,M5 by brining data from several applications Investor Contract Administration Repository ICAR , Automated Investor Reporting System AIRS , DAISY, Investor Reporting Operations Center IROC , CPI, SLDB, Daily Cash Recovery in addition to the BDE data.

• Lead data integration project from build to run for enabling tactical and strategic reporting for end users
• Design ETL architecture/processes to move data across systems based on business user requirements
• Establish best practices and standards for data integration transformations, mappings and workflows
• Prototyped and established Onshore/Offshore communication model, Project Methodology and Development standards for use with offshore team.
• Performed LPS -mortgage servicing applications BDE Bulk Data Extract conversions on COBOL files.
• Worked and validated the design of the solution and the production of all design phase deliverables.
• Coordinated with the offshore team in assigning the work and monitoring the day-day activities.

Environment: Informatica PowerCenter 9.1, 8.6, Informatica Power Exchange, Oracle Exadata, SQL Server 2008, JIRA, MS Project.

Confidential

Team Lead/Architect

• Manage data extraction, transformation, loading, cleansing and updating processes into the data warehouse
• Made sure all the scheduled jobs are working fine by creating the respective Jils for Autosys jobs.
• Tested the jobs with the respective Vendors FEDEX, ADMS to make sure the files were delivered in the respective format and at the right place.
• Review existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input and output requirements, and storage
• Standardize and automate processes by creating data collection templates and stored procedures
• Worked as an Informatica Administrator providing support in code deployments, managing users/groups among other day to day activities.

Environment: Informatica PowerCenter 9.x,8.6/8.5.1/7.1.3, Oracle 10g, Siebel 8.1.1, SQL Server 2008, UNIX, Linux.

Confidential

ETL Designer

The Purpose of the Project is to create a DataMart which will improve the process of Credit risk identification and mitigation as well as establish a loan performance reporting system which provides reporting capability across all SF sourced loans including the loans sourced thru Flow, Bulk and Alternate Collateral deals lines of business. It should also cover Real Estate owned by Freddie Mac.

• Designed and Developed ETL procedures mappings to ensure conformity, compliance with standards and lack of redundancy, translated business rules and functionally requirements into ETL procedures.
• Review existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input and output requirements, and storage
• Used Autosys to automate the jobs as well schedule the jobs by checking the dependencies of the ETL process.
• Created a set of automated control reports based on the requirements.

Environment: Informatica PowerCenter 8.6, Oracle 10g, Microsoft Visio, ERWIN 7.1.2,DB2,Linux, Micro strategy, Autosys, Clear Case/Clear Quest, MS Project.

Confidential

Lead/ Sr Data Warehouse Consultant

The objective of this project is to allow Inspections-Risk Analysis to deliver critical information so that Inspectors can implement a risk based approach to the selection of audit firms and other issuer clients for inspection. This also includes the risk the audit firm takes by associating with riskier issues. The reports generated based on this information provide potential areas for accounting irregularities at the issuer level which becomes the focus of the Field Inspections

• Performed impact assessment and scoped the size of the effort based on the requirements.
• Managed the development plans and schedules. Balance team workload and issue resolution.
• Designed load strategies and sequencing for the sessions based on the business requirements and dependencies. Managed Data Quality, Integration and Consolidation using DataFlux.
• Managed the Metadata associated with the ETL process used to populate the Data Warehouse.
• Developed and implemented Error Handling Strategies for ETL Mechanism.
• Identified Performance issues in existing sources, targets and mappings by analyzing the data by evaluating transformations and tuned accordingly for better performance.

ORA Upgrade:

• Installed and configured Informatica PowerCenter and Client tools.
• Installed the 8.5.1 version of Informatica on the server and configured the User Accounts as well as the Repositories.
• Upgraded all the mappings and created new workflows from Informatica 7.1.3 to 8.5.1 according to the rules/ conventions of 8.5.1.

Environment: Informatica PowerCenter 8.5.1/7.1/7.1.1,IDE/IDQ, Oracle 9i, Microsoft Visio, ERWIN 7.1.2, SQL Server 2005, DataFlux 8.0, MicroStrategy 7.x/8.x.

Confidential

Sr Data Warehouse Consultant

This is a Data Warehousing Solution for the Satellite Radio Company that mainly deals with Consumer Products specially related to Radio. The package provides methods to analyze sales revenue, products/Packages flow, time based analysis of products movement, customers choices based on product categories, fast moving products/Packages, slow moving products, capital blocked on slow moving products, etc. Different types of promotional schemes and their effect on the overall sales, grouping of products Market-Basket Analysis are the special features covered by the package.

• Review and approve technical ETL specifications, maps and customized workflows/sessions.
• Interacted with users, gather requirements and converted into specifications functional and technical .
• Involved in Logical and Physical design of Data warehouse/Staging Schema. Created Entity Relationship diagrams etc., using ERWIN.

Environment: Informatica PowerCenter 8.1.1/7.1.1 , SIEBEL7.8, Hyperion, Oracle 9i/10g, PL/SQL, Shell Scripts, SUN Solaris, Autosys, Toad 7.4, Erwin 7.1.2.

Confidential

MAP: Sr Data Warehouse Consultant

The Transactions Data mart is designed for consolidating the USD Investment Transactions. The Data Mart represents the percentage of Cash Flow and AUM represented in the existing FOSS/Picasso Environment. The Data Mart also represents the Information about the Ordered Transactions as well as the Investment Account Dimensions.

• Developed dimensional data model for Registration and Scoring phase. Use materialized views wherever needed. Identified all the confirmed dimensions to be included in the target marts design and confirmed the granularity of the facts in the fact tables.
• Developed Technical specification guidelines from business requirements.
• Implemented the Source file Auditing process which validates the number of Source Records received and processed versus any check-values provided in separate records ENVESTNET, DST Feeds .
• Created Workflows in the Workflow designer and Executed Tasks such as Sessions, Commands, etc. using Informatica 7.1 Workflow manager. Developed Mappings involving a Data Cleansing tool FirtLogicx to provide a clean data to end Users.

Environment: Informatica Power Center 8.1.1/7.1/7.1.3 on NT server, Data Profiling, FirstLogic, Erwin 4.x, SQL Server 2000, Cognos 7.x, VSS.

Confidential

NSAT: Sr Software Developer

The Confidential Data Warehousing project was developed to track and keep the history data of the people who are taking the NSAT Examination and generating the Data Mart accordingly to create the reports as per the requirements of the College Board.

• Identified the Source Systems flat file, support center from different business Environments and Database tables
• Developed Shell Scripts to automate the Data Load processes, move the acknowledgement files created to the respective location.
• Wrote SQL, PL/SQL, Stored Procedures, Triggers and Cursors for implementing business rules and Transformations and Data Validation process.
• Developed Unit Test Cases, Design Documents and Effective Test Data for Vendor Reporting System to ensure successful execution of the data loading processes.
• Assisted in Developing Reports based on client requirements using Crystal Reports.

Environment: Informatica Power Center 7.1.1, Oracle, XML, XMLSPY, ERWIN 4.1.4, LINUX, Shell Scripts, Rational Clear Case, Requisite Pro, Crystal Reports 8.5

Confidential

Sr Data warehouse Analyst/Developer

The project consists of creating the Financial Data Marts for Decision Support Solutions. Implemented a centralized Data mart which is an ongoing effort that collects, organizes and stores data from different operational systems to provide a single source of integrated and historical data for the purpose of the end user reporting, analysis and decision support and to improve the client services by preventing errors, providing real-time data and updating records as transactions are completed.

• Created the Data Marts for Budgets, Profit and Loss Accounts ration Analysis.
• Involved in Logical and physical design of data warehouse/staging schema. Created Entity Relationship Diagrams using ERWIN using the Star Schema Methodology.
• Created Informatica mappings to migrate data from various OLTP servers/databases.
• Developed PL/SQL pipeline table functions to be used in conjunction with Informatica to speed up the load process.
• Created Test Cases and completed Unit, Integration and System tests for Financial Data Mart System.

Environment: Oracle, PeopleSoft, Microsoft SQL Server, Informatica PowerCenter 6.2, Erwin 4.0, Control-M.