Summary:

5+ years of Information Technology experience participating in system study, requirement gathering, prototyping, analysis, detailed design, process modeling, Database design, development, documentation, testing, bug fixing and maintenance of complex business intelligence solutions in Data Warehousing using Informatica Power Center, Oracle, MS SQL Server.

• Extensive knowledge of full life cycle development in Data warehousing projects with data analysis, data extraction, conversion, cleaning and loading.
• Excellent knowledge in Extraction, Transformation and Loading (ETL) of data into the Data Warehouse using Informatica Power Mart / Power Center and possess knowledge of Informatica tools such as Power Exchange, Power Analyzer, Power Connect, Data Mart, OLAP and OLTP.
• Well versed with Dimensional modeling to Design and develop Star/Snowflake schemas, Fact and Dimension tables, Physical & logical data modeling using ERWIN data modeling tool.
• Good understanding of creating Informatica mappings, transformations, sessions and workflows to extract data from various sources and load into targets and proficient in creating re-usable transformations, workflows and mappings.
• Proficient and sound in performance tuning of mappings, sessions and workflows including partitioning, Index optimization & maintaining and enhancing ETL code.
• Expertise in Relational data base systems like Oracle, SQL Server, design and database development using SQL, PL/SQL, SQL Plus, TOAD, SQL-Loader.
• Highly proficient in writing and managing PL/SQL, Stored Procedures, Functions, Packages, Triggers, Cursors in Oracle and SQL Server databases.
• Excellent analytical, logical and programming skills to achieve the targets within the deadlines
• Good decision making skills as and when required.
• Proficient in understanding business needs and requirements and good in co-coordinating with end users.
• Ability to handle multiple projects and work in teams or Individually
• Possess excellent verbal, written and interpersonal communication skills, presentation, and problem solving and conflict resolution skills.
• Highly capable to rapidly learn new technologies and adapt to new environments.

Languages : C, C++, PL/SQL, T-SQL, Shell Programming
ETL Tools : Informatica Power Center 7.x/8.1.1/8.6.1/9.0.1, SSIS 2005/2008,SSRS 
Power Mart, Power Connect, Informatica Metadata Manager 
Data warehousing : Datamarts, OLTP, OLAP, Normalization, Dimensional Modeling, Facts, 
Dimensions, Star schema, Snowflake schema, slowly changing
dimensions 
DB utilities : SQL Loader, SQL Developer, SQL*Plus, SQL Server Management Studio, 
Toad, Benthic 
Modeling Tools : Erwin 7.3, Visio
Scripting : UNIX Shell scripting, Windows Batch Scripting, Java Script
BIS Reporting Tools : Cognos 8.4.1/8.0
Databases : Oracle 11g/10g/9i, MS-SQL Server 2008/2005, MS Access
Operating Systems : Windows XP, Windows 2003/2000 Server, UNIX

• Bachelor of Engineering - Computer Science & Information Technology

Confidential, San Antonio, TX Aug 2009 – dec 2011

Confidential, is a fully integrated financial services company dedicated to the financial well-being of the members of the military and their families. The company provides financial security to its members, associates and their families through provision of a full range of highly competitive financial products and services in Insurance, Banking and Investments areas.

Responsibilities:

• Involved in development of several projects for USAA- EDW team.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Developed several jobs to load SCD’s, Fact and Summary Tables.
• Involved in creating Marketing and Sales Data Mart.
• Developed several generic Informatica jobs which can be reused for several processes.
• Involved in creating Dashboards and drill through metrics for Customer Exposures and Responses.
• Designed and developed complex mappings that involved Slowly Changing Dimensions, Error handling, Business logic implementation
• Created sessions, worklets, workflows for the mapping to run daily, biweekly and monthly based on the business requirements.
• Participated in Data Warehouse and Data Mart design and data modeling using Erwin 7.3.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various tables in Data Marts.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy, Sequence generator, Java, Rank, Aggregator, SQL, Xml, Stored procedure and Normalizer.
• Created Sessions and partitioned using different partition types like key range partitioning.
• Used Parameter files to manage the control dates for the incremental load times.
• Tuned SQL Queries in Source qualifier Transformation for better performance
• Developed Stored Procedures for data mappings to implement complex business logics.
• Worked on Informatica Data profiling to analyze the quality of incoming data.
• Worked with ETL Migration Team and Migrated Informatica folders from Dev to Test repository and from Test to Prod Repository.
• Used reusable look-up transformations, Shortcuts to sources, targets across the folders.
• Created reusable mapplets using Mapplet Designer which involved date conversions.
• Created Windows Batch scripts to automate the process of renaming the Flat files with a timestamp extension, Compressing, Archiving, and FTP to the desired locations as required by the user.
• Supported the migration phases of the Informatica upgrades from versions 8.1.1, 8.6.1 to 9.0.1.
• Performed Informatica Folder/Object Level Migration using Repository Manager.
• Performed Code review of mappings of various applications.

Environment: Informatica PowerCenter 9.0.1/8.6.1/8.1.1, Unix, Oracle10g/11g, SQL Server 2005/2008, Data Transformation Studio, XML, Flat Files, Batch script, Windows XP/NT, TSQL,PL/SQL, Benthic, Erwin 7.3, Cognos8.

Confidential,Madison, WI Nov 2007 - July 2009 
American Family Insurance (AmFam) is one of the leaders in providing Personal, Property and Casualty insurance policies. AdvanceProgram is a major corporate initiative to replace a number of operational systems including the policy administration and billing systems.Project ADVANCE is a multi-year reinvention strategy designed to transform the company and be more forward-looking, customer-focused due to changes in the industry and customers’ expectations. Advance encompasses new personal lines products, more sophisticated pricing for personal and commercial lines, and new service options and systems across the company.

Responsibilities:

• Involved in developing common routines for infrastructure tables to get populated.
• Involved in data analysis and assisted business users in UAT.
• Involved in understanding requirements, analysis of functional specification, and preparation of Technical specification.
• Data Warehouse and Data Mart design and data modeling using Erwin.
• Architecting and design of data warehouse ETL processes.
• Developed Informatica Mappings/Mapplets to extract data from multiple sources, transform data, and then loaded to the Sales Force databases using Informatica Power Connect.
• Used transformations like Aggregator, Joiner, Source Qualifier, Normalizer, Lookup, Expression, Router, Filter, etc to develop Mappings/Mapplets using Informatica Power Center Designer.
• Worked with B2B Data Transformation Studio and created mapping to process XML files.
• Participated in integration of subsystems with data warehouse.
• Loading data into Relational and Dimensional tables from heterogeneous sources.
• Involved in creating sessions using Informatica Workflow Manager.
• Closely worked with Data Architect to resolve the data related issues.
• Work directly with non-IT business analysts throughout the development cycle, and provide production support for ETL.
• Involved in Analysis, Review, and development of Informatica mappings, its corresponding sessions and Workflows
• Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.
• Performance tuning of Mappings, Stored procedures, Functions using execution plans and Index tuning, CTEs, Profiler and Server Side tracing.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.
• Documented all the Database and Migration Activities like Data flows, Process flows, Standards, LDM, PDM, Data Dictionaries.
• Involved in migration and conversion between Oracle 9i/10g, MYSQL and SQL Server 2008 Databases using SSMA and PowerCenter mappings.

Environment: Informatica PowerCenter 8.6.1/8.1.1, Oracle 9i/10g,SQL Server 2005/2008, MS Visual Source Safe, PL/SQL, TSQL, MS-Office, Unix, Windows XP/NT, Benthic, Erwin 7.3, Cognos8.

Confidential,Cypress, CA Aug 2006 – Sep 2007

Confidential,Systems serves more than 3 million health plan members and approximately 10 million specialties plan members nationwide with annual revenues of more than $12 billion. PacifiCare Health Systems is one of the nation\'s largest consumer health organizations. PacifiCare offers individuals, employers 
and Medicare beneficiaries a variety of consumer-driven health care and life insurance products. Purpose of this project was to load Rx Claims data into Operational Data Store (ODS) and General Ledger by tagging appropriate accounting attributes based on business driven configurations, target for this project was Oracle Applications (General Ledger, Accounts Receivables and Accounts Payable). Sources were provided in different formats from different database extracts, multi-level files and sequential files. Data was integrated 
from several systems like Claims, Premiums, Capitation, Billing, etc. MAPD Project to load MAPD PARTD data into MAPD-ODS data store for Analytical Reporting and Analysis.

Responsibilities:

• Gathered and analyzed business requirements from users to prepare BRD
• Worked in capacity as a functional person, manage client requirements, issues & communications throughout project life-cycle and rollout.
• Worked alongside Data Architects, Data Modelers and other functional teams to understand and analyze the requirements.
• Worked in conjunction with analysts and other developers to develop solutions that are consistent with client and enterprise-wide data standards.
• Prepared mapping documents, conceptual design, and Technical design documents for loading extracts to ODS (Operational Data Store).
• Involved in translating business requirements to integrate into existing data mart design.
• Created complex mappings to read multiple sources and write to multiple targets.
• Created Mappings with parsers, mappers and serializers to convert the data from the source to the required format.
• Worked on Stored Procedures in fixing the bugs, modifying the PL/SQL code for Small Enhancements.
• Performed unit testing and code review on complex data exchange mappings.
• Responsible for creating and maintaining Informatics processes, managing data warehouse schemas, assisting with SQL tuning techniques, creating views, tables, snapshots to assist report teams.
• Migrated mappings, workflows from one environment to another environment.
• Extensively used the transformations Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Joiner, Normalizer.
• Experience in working on change requests which includes creating changes (Data Repair, Low Impact, Major and Minor Change requests), implementing the Changes.
• Extensively used Informatica to load data from SQL Server and flat files into staging area.
• Responsible for the Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Designed and developed various mappings for extracting data from various sources like Oracle, SQL Server and Flat files.
• Worked in Scheduling daily, weekly and Monthly jobs using Control M to extract information from multiple data sources and provide Target Files to Business Users.
• As part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions.
• Involved in development of complex mappings.
• Actively involved in performance tuning, error handling and product support.

Environment: Informatica Power Center 8.5/7.1 Power Center Change Data Capture, Oracle 10g, MS SQL Server 2005/2000, Data Modeling, SSIS/DTS, CA Scheduler.