Objective

To work with an organization that provides advancement opportunity and where I can utilize my specialty as an Informatica Consultant.

Summary

• 8 years of IT experience in System design, development and maintenance.
• 5+ years of technical and functional experience in Decision Support System, Data Warehousing, ETL Development.
• Hands-on expertise using Informatica 8.x/7.x/6.x withstrong business understanding of Healthcare, Insurance, Retail and Banking sectors.
• Informatica 8.x Certified Designer.
• Oracle 9i Certified Professional (OCA) in SQL.
• Exposure to ERWIN pigmentation modeling tool.
• Proficient in databases including Oracle, SQL server, Sybase and DB2.
• Immense experience in Oracle database development using PL/SQL, Stored Procedures, Triggers, Functions and Packages.
• Experience with TOAD as an interface to databases, to analyze, view and alter data.
• Involved in upgrading from Informatica 7.1 to Informatica 8.0
• Followed the best practices for mapping design, performance tuning and error handling.
• Exposure to SQL * Loader for bulk loading on oracle database.
• Experience in Unix shell scripts for automation of ETL and data transfer needs.
• Experience in Client/Server application development.
• Experience in Software Development Life Cycle (SDLC) including requirement gathering, designing, implementing and testing.

Education/Certifications

Informatica Certified in Mapping Design PowerCenter 8.
Informatica Certified in Advanced Mapping Design PowerCenter 8.
Informatica Certified in Architecture and Administration PowerCenter 8.
Oracle 9i Certified Professional (OCP) (IZ-007)
Master of Computer Management
Bachelor of Science

ETL Tools:

Informatica 8.x/7.x/6.x

Languages:

C, C++, Visual Basic, Perl/Shell Scripting, SQL, PL/SQL.

Databases:

Oracle 10g/9i/8i, SQL Server 2000/2005, Sybase 11.5, DB2, TeraData

Operating System:

UNIX/LINUX, Windows XP/2000/NT/9x

RDBMS Load Tools:

SQL *Loader

Data Modeling Tools:

Erwin 4.x/3.x

Scheduling Tools:

TIDAL, JCL, Crontab

Office Applications:

MS-Office XP/2003/2007, Open Office Suites.

Other Tools:

Toad 8.x, SQL Plus, Crystal Report XI, Business Object, MicroStrategy

Web Technology:

HTML

Confidential, San Francisco, SF Sept 09 - Present

Position:SeniorETL Consultant/ Development Lead
Blue Shield of California (BSC), an independent member of the Blue Shield Association, is a not-for-profit health plan dedicated to providing Californians with access to high-quality health care at a reasonable price.
The shields Advance is primary responsible to integrated the data among the business partner and the BSC and will generate the reports for the output management.
The interface projects will transfer and process Billing, Claim, Commission, Enrollment, Finance and Provider related data.
Responsibilities:

• Worked with System Analysts Lead and created System Design (SD) document, UTC document, TIDAL batch job document, Test data request forms.
• Worked with business users and analyzed the Facets 4.6 (Oracle 10g), Web Service, MMS batch file, Flat File source data and loaded it into the Oracle 10g database.
• Coordinated with Data Molder to create Staging table using Erwin.
• Coordinate with the off-shore team and implemented interface project.
• Worked extensivelyon fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions and Target Data.
• Created Source to Target Mapping document and developed Data Mappings between source systems and warehouse components
• Developed Shell Scripts which take care of truncate table, Archival the source and the target files and Clean up the log files.
• Captured the changed data using PowerCenter.
• Profiled the data using SQL.
• Worked extensively on SQL, PL/SQL and tunethe SQL queries.
• Worked on removing bottlenecks for the optimum usage of sources, transformations and targets.
• Captured error records into the CDM, refined the logic and loaded into target system.
• Implemented efficient and effective performance tuning procedures using Pushdown Optimization, Database Partitioning and Pipeline Partitioning.
• Performed Unit Testing and was involved in IntegrationTesting using Mercury Quality Center (MQC).
• Used TIDAL to run the workflows, SFTP the files and triggering an email from the CDM application.

Environment:Informatica PowerCenter 8.1, Erwin 4.0, XML, Oracle 10g, Flat File, TOAD 9.5.4, UNIX, TIDAL, MQC, Visio.

Confidential, Washington, DC Oct 08 - Aug 09

Position:ETL Consultant
CareFirst is the largest health care insurer in the mid Atlantic region. The Data and Informatics team is charged with creating a consolidated Operational Data Store (ODS) that contains data from all major source systems.
The ODS Claims Flow project will capture the end-to-end Medical claims processing data which flows through RealMed (Trading Partner), CCA (non legacy claims), TIBCO HIPAA Gateway, and Facets.
National Dental Solution Project: The primary purpose of the (DNoA) project is to import DNoA providers and re-pricing out-of-service-area dental claims.
Responsibilities:

• Involved with Business Analysts in requirements gathering and created Solution Architecture Package (SAP3), Capacity Planning and Production support documents.
• Worked with business users and analyzed the Facets 4.3/4.5 (Oracle 9i/10g), XML and DNoA (Flat Files) source data and loaded it into the Oracle 10g database.
• Coordinated with Data Molder to create Star Schema data model design using Erwin.
• Developed the transformation logic; identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• Worked extensivelyon fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions and Target Data.
• Developed ETL procedures to ensure conformity, compliance with CareFirst standards.
• Created and used reusable transformations, sessions and mapplets and using Informatica PowerCenter.
• Captured the changed data using PowerCenter.
• Profiled the data using SQL.
• Worked extensively on SQL, PL/SQL and Shell Scripts.
• Captured data error records, refined the logic and loaded into target system.
• Refined performance tuning procedures using Pushdown Optimization.
• Performed Unit Testing and was involved in IntegrationTesting using Mercury Quality Center (MQC).
• Used Job Control Language (JCL) to run the workflows and CA7 to schedule.
• Used Micro Strategy to generate ad hoc reports.
• Provided Production Support to end users.

Environment:Informatica PowerCenter 8.1, Erwin 4.0, Micro Strategy, XML, Oracle 10g/9i, Flat File, TOAD 9.5.4, UNIX, JCL, MQC, Visio.

Confidential, Nashville, TN Jul 07 - Sep 08

Position:Data warehouse/ETL Consultant
American Healthways, world's largest disease management and Care Enhancement Company, is based in Nashville; TN. Project involved developing new mappings as well as tuning existing mappings to accommodate monthly production run. Mappings were based off of previously written Stored Procedures. System consisted of COBOL, DB2 and Oracle sources, which were transformed and loaded into an Oracle database, which served as the source to generate various reports through Crystal Reports.
Responsibilities:

• Involved with Business Analysts in requirements gathering, business analysis testing and project coordination.
• Involved in Dimensional modeling to design and develop STAR Schema, using Erwin to design Fact and Dimension Tables.
• Analyzed the source data coming from different sources (Oracle,DB2 and COBOL) and worked with business users and developers to design the Model.
• Developed the transformation logic, identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• Actively involved in upgrading Informatica PowerCenter from version 7.1 to version 8.1.1.
• Extensively used Informatica 8.1 versions for various ETL purposes.
• Captured the changed data using PowerExchange.
• Used IDQ to validate the Patient information data.
• Worked extensively on SQL, PL/SQL and Shell Scripts.
• Worked on removing bottlenecks for the optimum usage of sources, transformations and targets.
• Implemented efficient and effective performance tuning procedures using Pushdown Optimization and Pipeline Partitioning.
• Used pmcmd command mode to schedule and run workflows.
• Generated reports using Crystal Reports XI.
• Provided End User training and support.

Environment:Informatica PowerCenter 8.0/7.1, PowerExchange, IDQ, Erwin 4.0, Crystal Reports XI, Oracle 9i, DB2, COBOL, SQL Loader, UNIX, Win 2000, TOAD 8.0.

Confidential, Des Moines, IA Nov 06 - Jun 07

Confidential, is one of the nation\'s oldest insurance carriers. It has been providing quality insurance coverage to the customer for home, auto, farm or business. The main objective of the project is to design and develop the PLR Analytical Tool, which provides the necessary policy characteristics that will be analyzed by the state managers in decision making.
Responsibilities:

• Involved in upgrading Informatica version 6.0 to 7.1.2
• Collected End users business requirements and analyzed system requirements.
• Extracted source data from Oracle, SQL Server and flat files using Informatica and loaded into Oracle or Flat files.
• Tuned the sessions by collecting performance details on the Informatica server.
• Used Target Load Order with multiple source qualifier groups in mappings.
• Extensively used SQL and PL/SQL scripts for transformations.
• Used Pipeline partitioning and External Loader to improve Session performance.
• Identify the source, target, mapping bottlenecks.
• Scheduled loads using Crontab jobs
• Used SQL * Loader for bulk loading the data into the target.
• Performed Unit Testing.

Environment: ETL-Informatica 7.1.2, MS SQL Server 2005, Oracle 9i, flat files, PL/SQL, Win 2000/NT, UNIX.

Confidential, Goodlettsville, TN Jan 06 - Oct 06

Dollar General is one of the fastest growing discount stores in United States. The project was to streamline their retail sales and warehouse management through an integrated data warehouse that would enable the management to take decisions on pricing and promotion. I was involved in the design and development of the Sales Data Mart using Informatica. The sources included Oracle databases, MS-SQL Server 2003 and Flat Files. The Data Mart was built over Oracle platform on Solaris servers. Frequency of data loading was on a daily and monthly basis.
Responsibilities:

• Analyzed and studied various Schemas for Implementation.
• Modeled the Data marts using Star Schema.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Extracted data form flat files and oracle database and loaded them in the central oracle database.
• Developed complex mappings & mapplets in Informatica to load the data using different transformations.
• Extensively used various Performance TuningTechniques to improve the session performance (Partitioning etc).
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.

Environment: Informatica (PowerCenter 7.1.2/6.0), Oracle 9i/8i, MS-SQL Server 2003, PL/SQL, Windows NT/2000, UNIX.

Confidential, Cranbury, NJ Jan 05 - Nov 05

Position: Informatica Developer
In the Fixed Income division of the 1st Constitution Bank, a large number of institutional and wealthy individual investors invest through a variety of fixed income instruments. The P & L department serves as the books and records of the division by holding an Oracle data warehouse of all Fixed Income trade activity. Trades from different financial trade capture systems and financial databases are extracted, converted and loaded into GMRS (Global Management Reporting System), which acts as a trade repository for all financial, trade analysis and reporting.
Responsibilities:

• Understanding of the business requirements and enhancing the existing data warehouse architectural design for a better performance.
• Performance tuning of databases, creating indexes, using stored procedures, caching data for aggregate transformations.
• Developed new Mapplets and data transformation functions using Informatica PowerCenter to transform and populate data into data warehouse target tables from Oracle source tables as well as flat file system.
• Set up sessions to extract data through FTP from remote data source files.
• Configured Informatica server sessions to generate control and data file to load data into target tables using SQL Loader utility.
• Developed post and pre-session shell scripts and scheduled event based sessions at the Informatica server manager.
• Worked on mapping to improving performance by identifying bottlenecks.
• Extensively used various performance tuning techniques like pipeline partitioning to improve the session performance.

Environment: Informatica PowerCenter 6.2, Erwin 3.5, PL/SQL, Oracle 9i, Sybase11.5, SQL Server 2000, UNIX, Windows NT/2000.

Confidential, Duluth, GA Nov 03 - Dec 04

This Project was developed for Wegener to build a data mart and OLAP reports for order management, strategic testing and tactical call center/customer relationship Management. Managed data warehouse through a multi-year business growth cycle. This data mart stores historical information about Private Network, Linear Television, Radio, and Video over IP. This system extracts data from order management system database (OLTP). An order management toolkit was developed to process orders.
Responsibilities:

• Analyzed and studied various Schemas for Implementation.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Extracted data form flat files and oracle database and loaded them in the central oracle database.
• Developed complex mappings & mapplets in Informatica to load the data using different transformations.
• Created and Monitored Sessions using Workflow Manager.
• Extensively used various Performance TuningTechniques to improve the session performance (Partitioning etc).
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.

Environment: ETL-Informatica 6.2, Oracle 9i, flat files, PL/SQL, Win 2000/NT, UNIX.

Position: Database Developer/Informatica Analyst
Confidential, is a leading bank in retail banking having its branch across India and other countries. Project was on Retail Banking for their sales and marketing division. ICICI is a diversified financial service company that provides a broad range of banking, asset management, wealth management, and corporate and investment banking products and services. The data warehouse was primarily designed to provide Marketing Managers with the complete understanding of customer pattern (market based analysis) and their preference (Trend Analysis). This data warehouse was later extended to cater the needs of Sales, Marketing and CRM

• Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates
• Integrated various sources in to the Staging area in Data Warehouse to Integrate and for Cleansing data.
• Involved in building of the Data Warehouse which includes the design of Data mart using Star Schema
• Created the Source and Target Definitions in Informatica PowerCenter Designer
• Created Reusable Transformations and Mapplets to use in Multiple Mappings
• Created Sessions and Batches using Server Manager for data movement through Mappings.
• Developed and updated documentation of processes and system.

Environment: Informatica 5.1, SQL Server 2000, Flat Files, SQL, PL/SQL, Windows 2000.

Confidential, India Aug 00 - Jan 03

Position: Programmer/Analyst
As a Programmer/Analyst/SQL Developer, I was responsible for design, development and analysis of ERP system. The system assists in the decision making about sale and purchase of the goods. It also does aging analysis of the goods lying in the purchase department and finished goods department. It also calculates weighted average purchase rates, calculates profitability of each product and entire activity and further assists in making selling rate policy, which covers all major activities of the diagnostics company.

• Gathered the requirement from the users and translated the business details into Technical design.
• Optimize SQL queries for better performance.
• Creation of PL/SQL Functions, Cursors, Packages, Stored procedures. Database triggers.
• Used Database trigger for making history of insertion, updating, deletion.
• Preparing Implementation Documentation and user support documents.
• User training and technical support.

Environment: Oracle 8i, MS Access, Visual Basic 6.0, Windows 2000