SUMMARY

• 12 years of IT experience in Data warehousing and Business intelligence with emphasis on Project Planning Management, Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Healthcare, Financial, Retail, and Insurance industries.
• Involvement in all phases of SDLC from project proposal, planning, analysis, development, testing, deployment and support.
• Strong experience in Data warehousing concepts, Star Schema and Snowflakes Schema methodologies used in relational, dimensional modeling, Data Profiling and Data cleansing.
• 12 years of design and development of ETL Extract, Transform and Loading data methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x and Data Stage 8.x/7.x .
• 12 years of experience with relational databases such as DB2 UDB, Oracle 8i/9i/10g/11g, Netezza, SQL SERVER 2000/2005/2008, Teradata V2R5/V2R6.
• 8 years of experience in OLTP Modeling 2NF,3NF and OLAP Dimensional modeling Star and Snow Flake using ERwin conceptual, logical and physical data models and Sybase PowerDesigner.
• 8 years of experience in UNIX Shell Scripting IBM AIX, Sun Solaris KSH - Korn Shell Scripting .
• 5 years of Experience in BI reporting tools like SAP Business Objects XI Cognos 8 BI 8, 8.2, and 8.3 . Framework Manager, Report Studio, Query Studio, Event Studio, Metric Studio, Analysis Studio, Cognos connection .
• 3 years of experience in OBIEE/Siebel Analytics 10.x/9.x/8.x/7.x, OBI Application EBS Adaptor Financial Analytics, Order Management, Supply Chain .
• Strong skills in SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in oracle database.
• Experience with Database SQL tuning and query optimization tools like Explain Plan.
• Experience in moving the Program Files FTP to the server by using the Tools like FileZilla, WINSCP, Putty and Telnet.
• Strong Data cleansing / Data Migration experience using ETL Informatica and Data Stage.
• Experience in POWEREXCHANGE to connect and import source data from external systems like DB2, COBOL VSAM, Mainframes, and AS/400.
• Experience in identifying and resolving ETL production root cause issues. Expertise in maintenance, enhancements, performance tuning of ETL code.
• Knowledge of Informatica administration in windows environment.
• Developed test cases for business and user requirements to perform System / Integration / User Acceptance testing.
• Provided off-hour and weekend production support on a rotational, on-call basis.
• Carried out training sessions for end-users Business users .
• Strong analytical and problem solving skills.
• Sound experience in Onsite-Offshore model project execution

• Excellent Organizational and Interpersonal skills both as a Team Leader and as an Independent Player. Excellent written and oral communication skills.

DWBI: Data Modeling, Data Warehousing/Data marts, Business Intelligence, ETL Informatica, Informatica with Teradata, Data Stage, OBIEE/Siebel Analytics 10.x/9.x/8.x/7.x, Cognos 8.x BI Reporting, Netezza, DB2 UDB, Microsoft SQL Server 2008, Oracle PL/SQL, Stored Procedure/Triggers/Functions and UNIX.

Confidential

Role: Senior Data Warehousing Consultant

Confidential is a major provider of kidney dialysis services and renal care products. It provides products, dialysis care services, education and support for Chronic Kidney Disease CKD , including treatment options for later stage CKD. Its dialysis care services includes hemodialysis, peritoneal dialysis, education tools and transplant support services, in-center, at home, or in a hospital, to fit its patients' needs. It manufactures and distributes a variety of dialysis products and equipment, including dialysis machines, dialyzers and other dialysis-related supplies.

Environment: UNIX, Windows XP Professional, Informatica 9.0.1, Business Objects XI 3.1, DB2 UDB, Toad for DB2 v4.7, CA Erwin Data Modeler v7.3, MS Project Professional 2002, DB2 Load utility, Ipswitch WS FTP Professional, Kitty, Putty

Confidential

Role: Informatica ETL Architect/Lead

Confidential in order to integrate case management information from individual trial courts into a single statewide system. The AOC indicates that one of the primary goals of CCMS is to increase electronic access to court records, statistics, and information across the state and reduce the work associated with paper-driven filings. The project is also intended to allow the courts to electronically interface with other criminal justice systems such as local law enforcement to ensure that the court-related data is shared quickly and efficiently.

Environment: UNIX, Windows vista/7, Informatica 9.0.1, Data Stage 8.x, MS SQL Server 2008, Teradata, OBIEE 10.x, TOAD, Oracle11g, DB2 UDB, Sybase PowerDesigner

Confidential

Role: Informatica ETL Architect/Lead

Confidential makes the use of prescription drugs safer and more affordable for tens of millions of consumers through thousands of employers, government, union and health plans. The primary goal of the project is to provide visibility of the performance of contractual obligations to enable Business Optimization i.e. what ESI is performing well on and where things need to be adjusted.

Responsibilities:

• Duties during Application Functional Design Approach: The core of the Data Warehouse design process was an iterative Joint Application Design JAD and involved close interactions with business and IT Subject Matter Experts SME on a daily basis.
• Discuss and gather feedback on application details, mapping business processes to UI elements, overall application navigation and UI flow, high level rules and validations and high level integration needs using Business Objects XIR3. Worked with Data modeler to build conceptual and physical data model using

• Technical Design Overview phase had following duties: The functional specification was translated into a technical design to support configuration and build of the application.
• Upon completion of design, major responsibility involved handing over and communicating the complete design to offshore team to develop the code and resolve any technical and design issues faced by the team.
• Responsibilities included designing architecture and developing complex Informatica mappings and Data Stage jobs including Type-II slowly changing dimensions.

• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Created pre-session and post-session shell scripts and mail-notifications.
• Performed bulk data load from flat files to Teradata DB using Fastload and Multiload.
• Used Requirements Traceability Tool RTT that ensures effective testing by following the life of a requirement.
• Installation and configuration of the OBIEE platform as well as the scheduling weekly sales summary by creating ibots.
• Created two business models in the .rpd Subject Area's one for upper management - scorecard, and other for regular business users weekly sales.
• Installed and configured the OBIEE/Siebel Analytics Server.
• Mapped Dashboard field requirements to Siebel OLTP/OLAP Physical/Business Model.
• Performed Dimensional modeling, Identify Fact tables Measures, Identify Dimension Tables to store business attributes, Identify Aggregate tables their definitions.
• Proposed/Recommended design alternatives to confirm to the business requirements, Interact with Business Owners/end-users.
• Created materialized views to fasten slower queries with complex joins in them.
• Designed OBIEE/Siebel Dashboards and performed custom formatting with html tags in Dashboard.
• Established access rights for pages in the Dashboard for different user groups Object Level Security .
• Understood Metadata Reporting/Dashboard requirements and created new Dashboard templates/mockups for GUI finalization from Business users and helped in BRD creation.
• Designed and customized OBIEE/Siebel Answers Views, charts and created Filters.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Use CVS for version control across common source code used by developers.
• Added disparate sources to business model objects and modeling aggregate tables to speed processing.
• Proficient in using the time-series functions to support historical time comparison analysis.
• Experience in using OBI answers to run queries to test and validate the repository.
• Experience in creating requests, adding filters, creating prompts, and creating pivot tables using OBI.
• Experience in Sales, Financial, Order Management and Fulfillment Analytics.

Environment: Informatica 8.6.1, Data Stage 7.x/8.x, MS SQL Server 2008, Teradata V2R6, Cognos 8.3, Oracle 10g, DB2, COBOL VSAM, UNIX, Korn Shell Scripting KSH , OBIEE/Siebel Analytics 7.7.1, Windows XP, SQL, PL/SQL, WINSCP, PUTTY, ERwin, TOAD, Sybase PowerDesigner

Confidential

Role: Informatica ETL Architect/Lead

Confidential is a faith-based, not-for-profit membership organization and it is nearly 2.6 million members strong. It's a Fortune 500 financial services organization with the strength of more than 67 billion in assets under management. Client is executing the Transform Our Product Systems TOPS program, a multi-year program to implement a new product administration platform and convert policies from six legacy systems onto a new platform, CSC's wmA. Project involved developing a plan and approach for addressing resource constraints and accelerating plan file related work.

Environment: UNIX, Windows XP, Informatica 8.x, Data Stage 7.x, Siebel Analytics eBusiness 7.x, Teradata, Cognos 8.3, TOAD, Oracle9i, MS SQL Server, DB2 UDB

Confidential

Role: ETL Lead

Confidential for Lutherans is a Fortune 500 financial services organization with dual corporate headquarters based in Minneapolis, Minnesota and Appleton, Wisconsin. Main objective of the project was to merge the two systems OASIS Accredited and OASIS Data Warehouse as access to Accredited was very restricted and there were huge number of duplicate records available in the accredited systems and OASIS Data Warehouse.

Responsibilities:

• Interacted with Business Analyst Line of Business to understand requirements and translated them into the appropriate technical solution.
• Created data modeling for staging area as well as Data warehouse Star Schema database.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Extensively used ETL to load data from wide range of sources such as flat files CSV, fixed-width or delimited .
• Performance tune ETL mappings, Maintenance and enhancements of ETL code.
• Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Taken part of Informatica administration. Migrated development mappings as well as hot fixes them in production environment.
• Experience with Database SQL tuning and query optimization tools like Explain Plan.
• Developing PL/SQL Packages, procedures, Functions, Triggers, Cursors as per the business requirements.
• Validated report results with the source data and sanctioned the reports to production environment.
• Created Reports in Report studio comprising of list reports, cross-tab reports and chart reports, Maps, Repeater tables using underlying multiple query structure by using filters, calculations, complex expressions, conditional formatting, and prompts including cascading prompts.
• Carried out training sessions for users to learn how to execute Cognos reports in Cognos connection.
• Responsible for preparing test cases and technical unit testing for the developed reports.
• Responsible for to analyze and apply new requirements to existing reports.
• Continuously monitor the accuracy of the data and the content of the delivered reports.
• Involved in Onsite Offshore coordination.
• Responsible for to provide production support and resolve issues.

Environment: Informatica PowerCenter 6.x/7.x, Cognos, Erwin 4.x, Oracle, PL/SQL, SQL Server 2005, Teradata, Windows 2003, IBM AIX5.3, Korn Shell Scripting KSH .

Confidential

Role: Senior ETL Developer

Confidential is the world's fifth-largest insurance group and the largest insurance services provider in the Confidential. Its main Business comprises Long Term Savings, Pensions Investments and Health Insurance. Main objective of this project is to transform complex interfaces between source policy / actuarial data hubs , complex and inflexible systems and architecture - data insufficiently structured to allow visibility at policy level and multiple contract engines. It aimed to provide simple, reliable systems and processes, together with a strong, cohesive professional community, to meet the challenges of modern financial management.

Responsibilities:

• Co-ordination with client side source system IT Team OLTP and business users to define agree and document incoming data mapping specifications.
• Involved in Requirement gathering.
• Creating the Technical design specifications based on Client functional specifications.
• Created data modeling using Erwin for staging area as well as Campaign Analysis Promotion and Coupon Data mart Snowflake Schema .
• My roles also include, Coordination with offshore in development activities.
• Provided project estimations to client and upon agreement with client, executed the project as per plan.
• Extensively used ETL to load data from wide range of sources such as flat files CSV, fixed-width or delimited .
• Developing PL/SQL Packages, procedures, Functions, Triggers, Cursors as per the business requirements.
• Experience with Database SQL tuning and query optimization tools like Explain Plan.
• Designed mappings which identify duplicate customer records. Match and merged records based on business rules. Created customer master reference data management MDM .
• Worked extensively on different types of transformations like Joiner, Aggregator, Router, and Expression, Normalizer, connected / unconnected Lookups, Data Masking transformation and Update strategies.
• Worked with Informatica Power Center to move data from multiple sources into a common target area such as Data Marts and Data Warehouse.
• Used POWEREXCHANGE for SAP R/3 to connect and import source data. Responsible for the Power Center development of international Data Warehouse IDWH .
• Created OLTP source metadata reports using Informatica Data Explorer IDE .
• Performance tune ETL mappings, Maintenance, enhancements and deployment of ETL code.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Exposed the columns in the Presentation layer in the proper Presentation catalog.
• Responsible for creating additional Users and maintaining Visibility Privileges using Analytics Administration on Repository side aswell as front end to display reports based on the business user for that particular area.
• Created reports for analyzing the Duration open of the Activity for each organization by the Sales Person and for analyzing the Revenue generated and the Amount expected from each organization.
• Generated reports for analyzing the revenue generated by various consultants in different departments.
• Developed Role-Based Dashboards for Executives, Account Managers and Account Supervisors.
• Performed QA and Code review for my code and other developer's code.
• Experience in creating and writing Unix Shell Scripts Korn Shell Scripting - KSH .
• Worked with QA and System Testing team to migrate the code in other environment, analyzed and resolved open defects.

Environment: Informatica Power Center 8.6.1, PowerExchange, Siebel Analytics 7.7.1, Oracle, PL/SQL, SQL Server 2005,DB2,SAP R/3,SAP BW, Teradata V2R6, Erwin Data Modeler r7.3, AutoSys, Toad, RHE Linux 4.0, Korn Shell Scripting KSH .

Confidential

Role: ETL Developer

Confidential is a marketing name for Massachusetts Mutual Life Insurance Company MassMutual and its affiliated companies and sales representatives. MassMutual and its subsidiaries have more than 505 billion in assets under management at year-end 2007. Main objective of this project was to automate the generation of letters related to various policies which initially used to have outdated technologies involving significant manual intervention.

Responsibilities:

• Requirement gathering, analysis and understanding of the project.
• Transferred data from excel files to Oracle database using SQL Loader tool.
• Developing ETL mappings, sessions, maplets and worklets with performance tuning using Informatica, DB2, and Oracle.
• Develop ETL codes using Informatica complete end to end testing using HP Quality Centre.
• Used expression, router, union, filter, sorter, aggregator, lookup, joiner, update strategy transformations effectively.
• Generating various BI reports using BI tool MicroStrategy.
• Used balancing methodology for source and target tables and also created and balanced XML files.
• Performed various unit testing and bug fixing as per the requirement.
• Responsible for ensuring that the project documentation is maintained as per the Project Life Cycle and all documents were version controlled and maintained as per QA requirements.

Environment: Informatica 5.x/6.x, DB2, UNIX, XML, SQL Loader, MicroStrategy.

Confidential

Role: Customer Support Engineer

Confidential is the largest state-owned power generating company Confidential. Forbes Global 2000 for 2009 ranked it 317th in the world. NTPC's IT Department is responsible for managing the corporate data effectively and providing and generating various user reports.

Responsibilities:

• Maintaining and updating company database through various ETL jobs using Informatica and Oracle.
• Change Requests Handling and Defect Resolution.
• Generating various IT and sales reports using Business Objects.
• Problem diagnosis resolution for a variety of hardware and software related issues.
• Co-ordination for raising Backup/Restore requests.
• Infrastructure related trouble shooting and follow-up with Infrastructure team if required.
• Taken care of to test DSNs provided by client using Easy Soft ODBC-ODBC Bridge for entire EUR Region. Remote ODBC access to databases when an ODBC driver is not available for client platform.
• Provided 24/7 on-call production support for Global ETL.

Environment: Informatica, Oracle