Profile:

• 8+ Years of Total IT Experience
• 6+ Years of DW ETL Informatica Experience
• 3+ Years of DW ETL Informatica Analysis Experience
• 2+ Years of Data Modeling Experience
• 2+ Years of Business Intelligence Experience
• 7+ Years of Databases Experience

Summary

• SDLC: 8+ years of total IT experience in the Business Requirements Analysis, Application Design, Data Modeling, Development, Testing, Implementation and Support for Data Warehousing and Client/Server applications for Financial, Pharmaceuticals, Telecommunication, Insurance and Technology Industries.
• DW ETL Informatica: 6+ years of strong Data Warehousing and ETL experience using Informatica PowerCenter, Informatica PowerMart, Source Analyzer, Repository Manager, Server manager, Mapping, Mapplet, Transformations, Warehouse Designers, Workflow Manager, Informatica Orchestration Server, Informatica Orchestration Client, Business Process Modeling Notation (BPMN), Business Process Modeling (BPM) diagram, Solid understanding of Data Warehousing, OLTP and OLAP concepts.
• Data Modeling: 2+ years of Data Modeling experience using Dimensional Data Modeling, Star Join Schema/Snowflake Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling, ERWIN, Oracle Designer, and Sybase Power Designer.
• Business Intelligence: 2+ years of Business Intelligence Experience in Business Objects, BO Designer, BO Developer Suite (Broadcast Agent, Supervisor, Designer), Universe Developer, Supervisor, Web Intelligence (WEBI), Cognos.
• Databases: 7+ Years of database experience using Oracle, DB2, MS SQL Server, Sybase, Teradata, MS Access, Erwin, SQL, PL/SQL, SQL*Plus, SQL*Loader
• Operating Systems: 7+ Years of experience in Sun Solaris 2.7, HP-Unix, Linux, Win NT 4.0, Win 3.x/95/98/NT/2000.

Education

• Bachelors in Engineering, India
• Diploma in Advanced Computing, C-DAC India

Technical Skills

Informatica 8.6/8.5/8.1/8.0/7.x/6.x/5.x(PowerCenter, PowerMart, PowerAnalyzer, PowerConnect for DB2, Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer, ETL, Data Mining, Datamart, OLAP, OLTP, Autosys, SAP R/3, SQL, PL/SQL, SQL*Plus, SQL*Loader, Informatica Orchestration Server, Informatica Orchestration Client, BPMN, BPM diagrams

Dimensional Data Modeling

Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin

Business Intelligence

Business Objects (BO Designer – Thick client/WEBI, Supervisor, BroadCast Agent), Cognos7.0/6.0/5.x (Impromptu, IWR, PowerPlay, Transformer), MS Access Reports

Data Bases

Oracle, MS SQL Server, DB2 UDB, MS Access, Sybase

Languages

SQL, PL/SQL, Java, HTML, XML, Unix Shell Scripting

Operating Systems

Win NT/2000/98/95, Sun Solaris, HP-UX, MS DOS

Professional Experience

Confidential, CA 
DW ETL Informatica Analyst Sep’ 09 – Till Date
Confidential is a leading designer, developer and marketer of innovative, technology-based educational products for kids, and the related proprietary content. It sells multiple products individually, as well as in a packaged or bundled form. I was involved with building of a datamart that would provide a bill-of-materials (BOM, in dollar terms) for all products in exploded or un-bundled form, by product/GIN number, product territory, customer, and the building of subsequent Cognos reports. 
Responsibilities

• Participated in system design discussions
• Participated in requirement analysis for financial data mart. Requirement analysis for data mart and BI cube comprised of user meets and working closely with the Oracle finance analyst. Defining the granularities for the different cubes.
• Designed the explosion logic to provide BOM at component level (individual/un-bundled form), at product, territory and customer levels, by the way of PowerCenter Mappings.
• Used PowerCenter transformations like Source, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filter, Lookup, Sequence Generator, Router, Update Strategy, Target (Table and Flat File)
• Performed data integration from different sources. Compared the sales data for integrity of the load.
• Ensured the ETL loads are smooth and the cubes are refreshed daily.
• Created automated scripts to generate the parameter files and the paging services for ETL failures.
• Coordinated with the users for the new requirements for the reporting purposes.
• Performed performance tuning of Informatica Mappings, sessions for Informatica 8.x workflows, transformations and cache optimization for loading, creating the batches and running and optimizing batches to load the data to production.
• Depicted the flow of data within and between technology systems and business functions/operations using Microsoft Visio.
• Worked with managers and users to develop business requirements and to analyze /model current and proposed business process flows.
• Involved with troubleshooting the Mappings for various developers and performance enhancements or change implementation.

Environment: Informatica PowerCenter 8.x, UNIX, Oracle10g, PL/SQL, Toad, Microsoft Visio 2000, Cognos 8, Erwin.

Confidential, Minneapolis, MN 
DW ETL Informatica Analyst Mar’ 09 – Sep’ 09
Confidential provides fixed and variable annuities, life insurance policies, and long term care insurance products in the United States. I am involved in three projects at Allianz - Sasquatch, involving multiple follow-on releases, and Solvency and Onbase, involving initial and follow-on releases.
Responsibilities

• Participated in system design and feasibility analysis discussions
• Interacted with Data Modeler, Business Analyst and Business Users to clarify the change requirements
• Analyzed Data Specification Documents(DSDs) and implemented their logic in the form of Informatica mapping design
• Used PowerCenter transformations like Source, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filter, Lookup, Sequence Generator, Router, Update Strategy, Stored Procedure, Transaction Control, Target (Table and Flat File), Input and Output during mapping design
• Implemented complex logic to change different parameter values to be used, depending upon the source data values. This was done using parameters and flags
• Designed multiple reusable transformations, mapplets and user defined functions (UDFs)
• Built intelligence into PowerCenter Workflows by use of session, command, decision, email and timer tasks
• Wrote multiple PL/SQL code pieces to perform complex matrix multiplications needed per business rules and updated multiple target tables
• Performance tuned multiple PowerCenter Mappings and MS SQL Server Stored Procedures leading to better system performance
• Recommended and created multiple DB objects like Tables, Views, Synonyms, Indexes, Stored Procedures, Temp or Staging Tables towards better system performance. Managed DB security for DEV and TEST environments
• Performed Unit and Integration testing for PowerCenter Mappings and Workflows
• Investigated and fixed System testing defects
• Designed production reports using Impromptu
• Created and maintained technical (mapping design and unit test case) documents
• Coordinated PowerCenter design and testing tasks with off-shore team, and across multiple new and on-going projects
• Performed PowerCenter User Administration, Folder creation and User access control
• Performed Code Migration across various environments like DEV, TEST, STG, PROD
• Performed root-cause analysis for production issues across multiple projects, and implemented code fixes (if needed) for same

Environment: Informatica 8.6.1, MS SQL Server 2005, Query Analyzer, SQL Server Management Studio, MS FoxPro, UltraEdit, Expresso, Cognos, Erwin, MS Office

Confidential, Des Moines, IA 
Informatica Developer Oct’08 – Jan’09
Confidential is a leading global financial company offering businesses, individuals and institutional clients a wide range of financial products and services. The range of products and services includes retirement solutions, life and health insurance, wellness programs, and investment and banking products through our diverse family of financial services companies and national network of financial professionals. The goal of the project was to build a CRM-PRA (Customer Relationship Management - Personal Retirement Account) Datamart which would enable taking informed campaign decisions. This will act as one of the source systems for the planned datamarts like Sales Datamart and Marketing Datamart. 
Responsibilities

• Analyzed source system data and implemented the transformation rules per ETL mapping specifications into PowerCenter Mappings
• Designed workflows to populate the Dimension tables like Member, Affiliate, Contract, Geographic Location, Time, Representative, Representative Manager, and the related Fact tables per appropriate Target Load Order plan. Also incorporated the Referential Integrity logic among various ODS and OM tables via a combination of sequential and simultaneous session run order in a workflow
• Used multiple PowerCenter Transformations like Lookup, Joiner, Expression, Router, Update Strategy, Source Qualifier, Aggregator, SQL, Filter, Sequence Generator to accomplish the mapping design process. Designed and developed about 25+ new mappings and related workflows to load source system data based out of DB2 (EDW) and Mainframe Files into ODS DB tables. This was later replicated over to the Opermart (OM) tables in DB2
• Wrote multiple complex SQL scripts for the delta-detection process, thereby facilitating the identification of the new/updated source records since the last successful run of the load process.
• Implemented complex backdating logic towards error-handling
• Cross-checked existing mappings according to the business rules and suggested alternate designs to make the mapping design more robust and error-free
• Performed peer-reviews for PowerCenter Mapping and Workflow design for the various ODS and OM mappings and workflows
• Involved in performance tuning of existing PowerCenter Mappings. Was able to significantly lower the run time for the delta-detection process by avoiding multiple function calls to the database tables
• Involved in developing test plans, writing test scripts, creating test data, testing and result analysis
• Performed Unit and Integration Testing of the PowerCenter Mappings and Workflows designed
• Migrated PowerCenter Objects for Test to Pilot environments
• Created and Maintained Migration Object List spreadsheet to facilitate easy migration process
• Created and maintained PowerCenter 8.6.1 Design & Development, and Unit Test Case documents

Environment: Informatica PowerCenter 8.6.1, WinSQL, Business Objects, Oracle 10G, Quest for DB2, DB2, SQL, UNIX, Windows XP, MS Office

Confidential, Saint Louis, MO 
DW ETL Informatica Developer-Data Modeler Mar’08 – Sep’08
Confidential is one of the leading Financial Companies in Mid-West USA. This Project is to Design and Construct a Customer Enterprise Data Warehouse (EDW) for US Bank. The objective is to achieve single point of reference to get the customer data from the various databases. Distributed data residing in heterogeneous data sources is consolidated onto target Enterprise Data Warehouse (EDW) database. During my tenure at US Bank, I also got an opportunity to make significant contributions towards developing a legacy system for use by Business Analysts to facilitate the process of requirements gathering. 
Responsibilities

• Responsible for the Data Analysis of the Source systems constituted of Mainframe files, MS SQL Server database and Flat-files (CSV or Tab-Delimited files)
• Created multiple PowerCenter Mappings (20+) and PowerCenter Workflows to accomplish data transformation and load process
• Used various complex PowerCenter Transformations like Lookup, Joiner, Expression, Router, Update Strategy, Source Qualifier, Aggregator, SQL, Filter, Sequence Generator, XML Generator, Normalizer and Java to accomplish the mapping design
• Created a detailed data flow diagram using MS Visio, representing the hierarchy of various DB table being loaded by respective PowerCenter Workflow objects, and the complex inter-dependencies of the load process
• Coordinated the task of scheduling the various Daily, Weekly and Monthly PowerCenter Workflows by the way of AutoSys jobs, and worked the complex inter-dependencies between various jobs
• Migrated Mappings, Sessions and Common Objects from DEV to IT and PROD environments
• Re-designed multiple existing PowerCenter mappings to implement change requests (CR) representing the updated business logic
• Created User Defined Functions (UDFs) and reusable Mapplets and Transformations to simplify maintenance process and improve the productivity
• Developed various shell scripts for different purposes. For example, starting workflow, reset sequence generators, purge database tables.
• Performed Unit Testing and Integration Testing of Mappings and Workflows
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects
• Validated and fine-tuned the ETL logic coded into existing PowerCenter Mappings, leading to improved performance
• Validated the Informatica mappings against the pre-defined ETL design standards observed at US Bank Corporation
• Extensively worked towards development of a custom application for use by Business Analysts. My contribution was as an ETL analyst and Data Modeler
• Designed data model for the custom application for use by Business Analysts, using ERWin 4.5
• Wrote multiple DB Sequences and Triggers in Oracle towards the custom application
• Created PowerCenter mappings using WebServices Source and Target objects in PowerCenter 8.5, with extensive use of SQL, XML Generator, XML Parser and Java transformations.
• Created Business Process Modeling (BPM) diagrams using standard Business Process Modeling Notations (BPMN) in Informatica Orchestration Orchestration Client.
• Modeled a BPM diagram to represent a new data request from source system, and orchestrated the process of data fetching from source to staging database.
• Designed Human and Application process workflows using Orchestration Server and Client components.
• Maintained technical documentation

Environment: Informatica PowerCenter 8.5/8.1/8.0, PowerCenter PowerAnalyzer, DB2, AutoSys, WebFocus, Erwin 4.0, Oracle 9i/8i, UNIX Shell Scripting, SQL, PL/SQL, SQL * Loader, TOAD for Oracle and DB2, MS SQL Server 2000, Sun Solaris 2.6 UNIX, Windows XP/NT/2000, UltraEdit, Informatica Orchestration Server, Informatica Orchestration Client, MS Visio.

Confidential, Warrenville, IL 
DW ETL Informatica Developer, Support Analyst Jul’06-Mar’08
Confidential is of one of the world\'s largest energy companies with well-established operations in the UK and the rest of Europe, North and South America, Asia, Australasia, Africa and Russia. Enterprise Data Warehouse (EDW) was intended to be global data warehouse system to enable Exposure and Risk estimations by downstream systems like Strategic Credit Risk (SCR), Gross Margin Reporting (GMR), Inventory Planning and Management (IPM) and other future systems. Due to multiple feasibility issues on data integration front, the original project was split into multiple implementation phases, and rolled-out. During my tenure at BP, I also dueled as a Support Analyst due to my familiarity with the overall business process and the various lingos used.

Responsibilities

• Participated in complete SDLC – requirements gathering, feasibility analysis, physical and logical data modeling, mapping design, unit and integration testing, production support and related documentation. Classified requests as either New Data or Changed Data requests
• Analyzed data from multiple legacy source systems like NextGen Deal Entry, NextGen RefData, MOFT, US Exposure, SAP to understand data dependency for EDW
• Designed multiple Informatica Mappings (50+) and data quality verification programs using Informatica and PL/SQL to extract, transform and load source data based out of Oracle, Sybase, MS SQL Server, SAP (Inventory Data), MS Access and Text files into SCR, GMR and IP M DataMarts
• Debugged multiple PowerCenter Mappings to analyze if Data Quality and Standardization requirements were being met
• Created and documented Test Plans
• Performed Unit and Integration testing for PowerCenter Mappings and Workflows, and documented the findings
• Designed Reusable Transformations, Mapplets, Tasks and Worklets during Mapping and Workflow design process. Used most of the PowerCenter Transformations like Source Qualifier, Joiner, Router, Update Strategy, Lookup, Rank, Expression, Aggregator, Filter and Sequence Generator for loading the data into Oracle database
• Configured the mappings to handle the updates to preserve the existing records using Router and Update Strategy Transformation, per business logic
• Performed Mapping, Workflow, SQL and Database tuning to improve system performance
• Created and maintained Mappinng Design and Testing documentation
• Provided production support by monitoring the processes running daily. Also assumed the role of an L1/L2/L3 support analyst for multiple Informatica and Kalido DIW based ETL systems, Documentum Webtop Client, Desktop Client and Administrator (DA) and Business Objects (BO thick client/WEBI, Supervisor, Broadcast Agent)
• Participated in End-User training, and New Release or Change Implementation Meetings
• Investigated, debugged and fixed problems with end-user BO report generation, Documentum Jobs, Documentum Workflows and Objects
• Created custom Business Objects reports using thick client/WEBI, published and maintained them at Broadcast Agent (BCA). Automated the report generation process at specified schedule, for specific reports
• Performed unit and integration testing in User Acceptance Test (UAT), Operational Acceptance Test (OAT), Production Support Environment (PSE) and Production environments

Environment: Informatica Power Center 7.1, Business Objects 5.1.7/6.0/6.1/WEBI, Oracle 9i, Sybase 11.x, MS SQL Server 2000, PL/SQL, MS Access, Documentum 5.3.x, Webtop Client, Desktop Client, Documentum Administrator (DA) Erwin 3.5, UNIX shell scripts

Confidential, Birmingham, AL 
DW ETL Informatica Developer Jan’06–Jun ’06
Confidential is a leader among regional banks in the Southeast. The project name was MIS build phase II. Marketing Information systems (MIS) datamart was intended to be the core foundation for future phases of the MIS datamart. Other groups would use this core foundation as the basis of down stream marts. These down-stream Datamarts would include deposits, private banking and business banking. Datamart was made up of data extracted from the EDW and the House-holding databases. The data was extracted from the EDW on a monthly basis; merged with the house-holding process database; and loaded into the MIS datamart. My deputation for the project started as a substitute for an existing resource. Since most development worked has already been accomplished, I was primarily responsible for design validation, testing, change request implementation, code-fix implementation, and support.
Responsibilities

• Involved in the analysis, design and development of all the interface’s using Informatica Power center tools in interface team and interfaced with all the other tracks for business related issues
• Used PowerCenter Designer, Workflow Manager, Workflow Monitor and PowerConnect to mobilize data movement from Mainframe DB2 and flat-file into Oracle Staging and Warehouse Database tables
• Used multiple transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator during mapping design process. Involved in design 5+ new mappings
• Involved in validation of existing mapping design processes as regards adherence to design best practices and specified business, edit and error rules implementation. Extensively used Debugger to identify mappings design violations
• Create and ran unit test scripts for base datamart ETL process. Involved in Unit testing and related code-fixes, testing, object migration and documentation process
• Involved in change request design and implementation, and related testing, migration and documentation process. Translated the business process specification into Informatica mappings design for building the datamart
• Migrated and deployed Informatica mappings and workflows from Test to Model and Production environments
• Worked on SQL tools like TOAD to run SQL Queries to validate the data quality
• Involved in Production Support activities
• Created, updated and maintained ETL technical documentation

Environment: Informatica PowerCenter 7.1.2, MS SQL server2000, Oracle9i, PL/SQL, UNIX Scripts, Erwin 4.5, Windows XP, AIX, Microsoft Visio, SQL Plus, Mainframe DB2, Detail- power connect and TOAD.

Confidential, New Brunswick, NJ 
Informatica Developer Jun‘04–Dec‘05
Confidential is one of the leading Pharmaceutical and related healthcare products company in US. The project dealt with consolidation the pharma sales data collected from different regions. The data was consolidated into the datamarts like Inventory, Product, Sales and Marketing, and used towards multiple business activities like Inventory Planning and Control, Sales Planning and Commission, Product Planning, Product Performance Analysis by region, among others, to better manage the product demand and supply and sales performance estimation tasks.
Responsibilities

• Participated in complete SDLC – requirements gathering, feasibility study, analysis of system design specifications, technical design – data model and ETL process, testing – unit and integration, implementation and maintenance
• Documented PowerCenter Mapping Design Specifications into MS Excel Spreadsheets, and got them verified
• Verified the Fact and Dimension table design (Star Schema) per design specifications for the Inventory, Product, Sales and Marketing datamarts
• Involved in end-to-end ETL process design using various Informatica tools – Source Analyzer, Mapping, Designer, Transformation Designer, Workflow Manager, Workflow Monitor. Designed 60+ mappings and workflows
• Developed ETL processes using different Transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Expression, Stored Procedure transformation and Sequence generator for loading the data into target Data Mart
• Implemented complex referential integrity logic using multiple PowerCenter Mappings, Workflows, Sessions or Tasks, since the base datamart tables did not have these implemented
• Designed Testing Plans, Scripts and Test Cases to perform Unit and Integration Testing
• Performed Unit and Integration testing for ETL process
• Tested PowerCenter Mappings and Workflows against specified data quality requirements. Ran different sessions and batches in workflow manager and studied log to modify mappings to obtain the correct results from transformation
• Verified implementation of complex business rules. For example, handling a of change in Sales Rep Manager identity by the way of using active and non-active record identifier column
• Populated Target Datamart tables in Oracle using Workflow Manager - Scheduled and Ran the Extraction, Transformation and Load (ETL) processes, and monitored respective sessions by using Workflow monitor
• Populated of the Data Warehouse tables using a combination of SQL*Loader and Informatica
• Created and Scheduled Sessions and Batch Process based on demand, run on time, run only once using WorkflowManager
• Created Repository and User groups Using Repository Manager
• Created technical documents like Reusability Summary Document, Unit Test Template Document, System Test Script Document, Transfer Objects Document, and uploaded at file-share location
• Developed SQL and PL/SQL as needed. Designed complex SQL script, Stored Procedures, Triggers, Functions and Packages used for the system
• Extensively created various UNIX scripts
• Provided technical support for existing, new and changed ETL process. Participated in Change Implementation process, and coordinated change implementation tasks

Environment: Data Warehousing, Informatica PowerCenter 7.1/6.2, Business Objects 5.x, MS SQL server2000, Oracle 9i, PL/SQL, Erwin, HP-Unix, SQL*Loader, Windows NT, SQL Plus, and TOAD.

Confidential, Allen Town, PA 
Data Warehouse ETL Informatica Developer May’03–Apr\'04
Confidential is the main Data center for all of Lucent Technologies and their customers. 
Responsibilities

• Used Repository manager to create Repository, User groups, Users and managed users by setting up their privileges and profile
• Involved in developing Data Warehouse for SALES and MARKETING Systems using various PowerCenter tools
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system using ERWIN
• Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy, Normalizer, Sequence Generator transformations during mapping design process. Customized data by adding calculations, summaries and functions using various Informatica transformations
• Used the Workflow manager to create workflows and tasks, and also created worklets
• Used the Workflow monitor to monitor the job submission and progress
• Designed test cases for unit testing for ETL design process
• Used debugger to test the mapping and fixed the bugs
• Documented Testing results and fixes implemented. And, coordinated the code-fix implementation in production environment
• Created List Reports and Cross Tab Reports and Drill Through reports to estimate Sales Forecast, Gross Sales, Net Sales, Sales Rep Performance by Product, Region, Sales Commission Estimation
• Created Standard and Ad-hoc reports using Cognos Impromptu tool to estimate ETL process load statics
• Queried (SQL script) data from different database tables as per the requirement, to validate ETL design process
• Provided Training and End User Support with my report and also knowledge transfer
• Created and maintained Technical Documentation – Mapping Specification, Mapping Design, Testing, change Implementation and Release

Environment: Informatica Power Center 5.1, Cognos Series, Cognos Impromptu, Transformer, IWR, Unix Shell Scripting, MS Access, Oracle 8i, PL/SQL, Sun Solaris.

Confidential 
SQL Developer Apr‘02–Nov’02
Confidential has 15 centers all over the country and having the central office at Mumbai. 
Responsibilities

• Operate daily eligibility process, which involves running stored Pl/SQL procedures.
• Modify stored procedures as per end user requirements.
• Design, develop and implement database application.
• Populate database tables using oracle tools and SQL.
• Prepared design specs, modified forms and reports based on end user requirements.

Environment:Oracle 7.3.4, MS SQL Server 6.5, Developer 2k, PL/SQL, UNIX, Windows NT/98

Confidential 
Oracle Developer Oct’01–Mar’02
This project was to develop a monitoring system for assisting the Project Financing and Recovery operations of financial institution. 
Responsibilities

• System Study and database design using Oracle 7.3
• Created all interfaces Developer 2000 and wrote PL/SQL stored procedures
• Involved in Testing of the application and development of the User manual and other development documents.

Environment : Oracle 7.3, Developer 2000, SQL, PL/SQL, Windows NT/98