PROFESSIONAL SUMMARY:

• Over 8+ years of total IT experience and technical proficiency in building Data Warehouses, Data Marts, Data Integration, Operational Data Stores and ETL processes for clients in Financial (Annuities, Insurance, Actuaries, Equities, Futures, Options, Commodities, SPOT’s, Swaps, Bonds, Credit Risk, Market Risk, Operational Risk), HealthCare (Providers, Customers, Organizations, Plans, Claims, and Extracts), and Utility domains.
• Strong experience in working with large scale Data Warehouse implementations using Informatica PowerCenter 9.x/8.x/7.x/6.x, PowerExchange 9.x, Oracle, SQL Server PDW, and SQL Server.
• Strong knowledge in OLAP systems, Kimball, and Inmon methodology & models, Dimensional modeling using Star and Snowflake schema.
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica PowerCenter tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Administration Console) and PowerExchange.
• Expertise in implementing complex business rules by creating robust Mappings, Mapplets, Sessions and Workflows using Informatica PowerCenter.
• Experience in performance tuning of Informatica mappings, sessions, and workflows to improve performance of the large volume projects.
• Experience in Migration, Configuration and Administration of Informatica PowerCenter.
• Experience in integration of various data sources like Oracle, PDW, SQL Server, Flat Files, Mainframes, XML files into Data Warehouse and also experienced in Data Cleansing and Analysis.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages, Cursors, Triggers, Views, and Indexes in distributed environment.
• Excellent expertise with different types of data load strategies and scenarios like Historical Dimensions, Surrogate keys, Summary facts etc.,
• Worked extensively in all stages of SDLC, from gathering requirements to testing, implementation and support.
• Experience in preparing documentation such as High level design, System requirement document, and Technical Specification document etc.,
• Strong experience in writing Batch scripts, Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes. Experience in using Tivoli, UC4, Autosys, and Control - M scheduling tools to organize and schedule jobs.
• Good knowledge on generating various complex reports using Business Objects, OBIEE, and MicroStrategy.
• Experience in using TFS, IBM Clear Quest, and JIRA to track defects and document test cases.
• Good knowledge on TIBCO Rendezvous and IBM MQSeries.
• Worked with cross-functional teams such as QA, DBA and Environment teams to deploy code from development to QA and Production server.
• Experience in project management, estimations, and resource management activities.
• Excellent analytical, problem solving skills with strong technical background and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: Unix, Linux, Windows

Databases: Oracle 11g/10g/9i, PDW AU3, SQL Server 2008/2005, MS Access

Database Tools: TOAD, SQL Navigator, Visual Studio

Load Utilities: SQL Loader, PDW loader

ETL Tool: Informatica PowerCenter 9.5/9.1/ 8.6.1/8.5.1 /8.1.1/7. x/6.x

BI Reporting Tools: Business Objects, OBIEE, MicroStrategy 8.2

Programming Languages: C, C++, HTML, XML, COBOL, PL/ SQL, Java, J2EE, JSP

Scripting Languages: Shell Scripting, Perl Scripting

Tools: UC4, Cron, Control-M, Autosys

Application Servers: Web Logic 10.x/9.x, Tomcat

Middleware: TIBCO Rendezvous, IBM MQ Series

Test Management Tools: IBM Clear Quest, Quality Center, JIRA, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Informatica Consultant

Responsibilities:

• Developed remediation documents for tracking, designing and implementation of project changes.
• Developed various Informatica mapplets, mappings (with shared objects) using various transformations, tasks, sessions, and workflows.
• Developed and maintained databases on Microsoft Analytics Platform System (APS PDW). Handled backup and restore of PDW databases as per project needs.
• Migrated and modified Informatica code from SQL Server 2012 to PDW AU3 for efficient use of PDW and tuned workflows for better performance.
• Defined jobs and views on Autosys and integrated the whole flow with Informatica for various business scenarios.
• Tested various reports on Business Objects XI and helped stakeholders in resolving issues and executing test cases.
• Developed and maintained manual entry database on PDW for lookup tables and store project metadata.
• Implemented parameterization techniques to simplify the process of handling code when migrating between environments.
• Discussed with the team and implemented non-functionality techniques for auditing purpose and database statistics and index maintenance.

Environment: Informatica PowerCenter 9.5, PDW AU3, SQL Server 2012, Business Objects XI, Autosys, Windows, SQL, Batch Scripting, TFS, Visual Studio.

Confidential, Minneapolis, MN

Sr. Informatica Consultant

Responsibilities:

• Interacting with business owners to gather both functional and technical requirements.
• Developing technical specifications and other helpful ETL documents following Ameriprise standards.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes, and functions; implement best practices to maintain optimal performance.
• Design, develop, and test Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
• Load historical data into Oracle data warehouse to enable business analysts to better understand, monitor, and analyze liquidity generating performance of Ameriprise Financials.
• Transferring the data from various sources like Mainframe and flat files into Oracle data warehouse.
• Identifying bottlenecks/issues and fine tuning them for optimal performance.
• Responsible for capturing, reporting, and correcting error data.
• Work with DBA’s and systems support personnel in elevating and automating successful code to production. Used Tivoli for job scheduling, workload automation and for generating reports.
• Developed MFT scripts to transfer files and to automate ETL jobs.
• Provide on-call support to production system to resolve any issues.
• Conducting code walkthroughs and review peer code and documentation.

Environment: Informatica Power Center 9.1, Power Exchange 9.1, Oracle 11g/10g, Mainframe, Tivoli, RHEL 5.4, Windows XP, SQL, PL/SQL, Shell/Perl Scripting, Quality Center 10, SQL Developer, TOAD 9.0.

Confidential, Chicago, IL

Informatica Consultant

Responsibilities:

• Interacting with business owners to gather both functional and technical requirements.
• Documenting the business requirements and framing the business logic for the ETL process.
• Developing technical specifications and other helpful ETL documents following CME Group’s standards.
• Use Agile methodology for SDLC and utilize scrum meetings for creative and productive work.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes, and functions; implement best practices to maintain optimal performance.
• Design, develop, and test Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
• Load historical and intraday trades, settlements, positions, and product data into Oracle data warehouse to enable business analysts to better understand, monitor, and analyze liquidity generating performance of Market Maker firms trading CME Group’s products.
• Migrating historical data from DB2 to the Oracle data warehouse.
• Transferring the data from various sources like XML, flat files, DB2 into Oracle data warehouse.
• Extensively worked on SCD type 2 using Look up transformation.
• Identifying bottlenecks/issues and fine tuning them for optimal performance.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Upgraded Informatica objects to 8.6.1 within the timeframe.
• Responsible for capturing, reporting, and correcting error data.
• Used Business Objects XI R2 to programmatically generate reports and gather necessary information about report instances.
• Performed/automated many ETL related tasks including data cleansing, conversion, and transformations to load Oracle 10G based Data Warehouse.
• Work with DBA’s and systems support personnel in elevating and automating successful code to production. Used UC4 for job scheduling, workload automation and for generating reports.
• Developer Shell/Perl scripts to transfer files using FTP, SFTP, and to automate ETL jobs.
• Provide on-call support to production system to resolve any issues.

Environment: Informatica Power Center 8.6.1/8.5.1 , Oracle 11g/10g RAC, DB2 v8.01, UC4, RHEL 5.4, Windows XP, SQL, PL/SQL, Shell/Perl Scripting, BO XI, ERwin, TIBCO, Web Logic 10.3.4, IBM Clear Case & Clear Quest 7.0.1, SQL Developer, TOAD 9.0.

Confidential, Wilmington, DE

Informatica Consultant

Responsibilities:

• Interacted with Business Users to gather business requirements and designed user friendly templates to communicate any further enhancements needs to be implemented.
• Coordinated with Data Modelers for designing the dimensional model.
• Extensively worked in Credit Cards billing and payments subject area.
• Involved in documenting Functional Specifications, Design Specifications documents and created ETL Specifications documents and updated them as and when needed.
• Created System Interface Agreement (SIA) between source system and target systems, which has the escalation procedures in case of issues and SLA.
• Designed ETL specifications with transformation rules using ETL best practices for good performance, maintainability of the code and efficient restart ability.
• Designed reusable objects like mapplets & re-usable transformations in Informatica.
• Experienced in developing mappings using transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence Generator, Expression, Router, Update Strategy, Rank, XML SQ/Parser/Generator, Normalizer etc., to load data from different sources like Oracle, Flat Files, Excel Spread Sheets, XML, COBOL files to the target Data Warehouse.
• Experience in implementing Type II changes in Slowly Changing Dimension Tables.
• Performed data validation in the target tables using complex SQLs to make sure all the modules are integrated properly.
• Tested and tuned the SQL queries for better performance. Identified the bottlenecks in mapping logic and resolved performance issues.
• Worked closely with Business Intelligence (BI) team and assisted them to develop reports using Business Objects reporting tool.
• Conducted code reviews to make sure the business requirements are met and the coding standards are followed.
• Experience in working with different 3rd party data cleansing tools like Trillium.
• Coordinated with System support team to setup the system test environment for code migration and code execution process in QA environment.

Environment: Informatica Power Center 8.1/7.1, Erwin, BO XI, SQL Server 2008/2005, PL/SQL, Shell Scripting, COBOL, IBM MQSeries, Erwin, Trillium, Autosys, Tomcat, TOAD, Sun Solaris 2.7, Windows XP.