Professional summary

Information Technology:

• 8 years of strong IT experience.
• 7 years of strong experience in Requirement Analysis, Functional Analysis, Architecture, Design, Development, Testing, Implementation, Debugging, Production Support Maintenance of EDW systems.
• Knowledge in full life cycle implementation of Data Warehouses pertaining to Financial, Insurance, Healthcare Networking, Pharmaceutical verticals.

ETL:

• Strong Data Warehousing ETL experience using Informatica Power Center 9.x/8.x/7.x/6.x Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplets Designer, Mapping Designer, Informatica Server, Repository Manager .
• Experience in developing strategies for Extraction, Transformation and Loading ETL mechanism using Informatica.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Developed Slowly Changing Dimension Mappings of type I, II and type III version, flag and time stamp
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions. Knowledge of Partitioning Data and session partitions.
• Knowledge on Informatica MDM, IDQ and web services.
• Data Modeling experience using ERWIN 4.5/4.0/3.x, in OLTP OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multi dimensional modeling.
• Hands on experience with SQL server2000/2003/2008 and also good knowledge on CHANGE DATA CAPTURE CDC
• Hands on experience using databases UDB IBM DB2 8.0, Teradata V2R4, Oracle 11g/ 10g/9i/8i, Sybase IQ 12.7.
• Experience and good knowledge on FastExport, TPUMP, TPT Teradata Parallel Transporter , OLELOAD.

Business Intelligence:

• Experience in Data warehousing Reporting tool, Business Objects XI R2 reporter, Designer, Web Intelligence and Info View and COGNOS for developing different types of reports according to client's requirements.
• Worked on Analysis features In Business Objects like Scope of analysis, Slice Dice Drill Mode, created charts and used local variables and functions, Group values.

Testing:

Expertise in designing, developing and executing Tests Cases and Test Scripts based on business requirements.

Proficient in both Manual and Automated testing and good understanding and experience of Quality Assurance Life Cycle QALC , QA Methodology and QA Strategy including Software Development Life Cycle SDLC .

.

Personal Skills:

• Have Strong technical, communication, time management and interpersonal skills.
• Managed and delivered large and complex assignments within time/cost and service level parameters.

TECHNICAL SKILLS:

EXPERIENCE:

Kaiser Permanente, Pleasanton, CA Apr 2012 to Current

ETL DEVELOPER

Description:

EDW project involved building an Enterprise Data warehouse and Data marts for different Business areas like Helath Plan, Claims and Operations and data loads into these layers using Informatica. The layer is named as BAL Business Analytic layer .

Responsibilities:

• Worked with Business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Created Logical and Physical models for the Data mart using Erwin 4.0
• Developed mappings with transformations and Mapplets confirming to the business rules.
• Created the ER Entity Relationship diagrams maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Research Sources and identify necessary Business Components for Analysis.
• Created IDQ data profile and score cards for the research users to analyze the patient trends.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design Star Schema and maintenance.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target tables using Informatica Workflow Manager
• Processed session data using various tasks session, command etc. and managed database connections and scheduled workflows.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Created snapshot for the transactional tables in distributed databases and also created Triggers, Procedures and Functions for the backend Development.
• Used UNIX to Import parameter files into workflow manager
• Created UNIX shell script utilities for parsing or reformatting user data and compiling user information reports for various support purpose.
• Created UNIX shell scripts for data migration batch processing.
• Extracted data from source systems to a staging database running on Oracle database.
• UDB IBM DB2 was used as OLTP Source.
• Worked on issues with migration from development to testing.
• Carried out ETL Testing using Informatica and PL/SQL.
• Used BO XIR2 to generate monthly, quarterly reports.
• Working with Ultra Edit, Putty, SQL Assistant, PVCS, SharePoint Server, RDC, and Citrix.

Environment: Informatica Power Center 9.1.0 Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplets Designer, Transformations , IDQ 9.5.1, BO XIR2, Oracle 11g, SQL, PL/SQL, DB2 8.0, Erwin 4.0, Unix Shell Scripting, Windows, UNIX/LINUX.

Ingenix Health Group, Rocky hill, CT May 2011 to Apr 2012

INFORMATICA DEVELOPER

Description:

Ingenix is a wholly-owned subsidiary of UnitedHealth Group, founded in 1996 to develop, acquire and integrate the world's best-in-class health care information and technology capabilities. Ingenix's health insurance pays for medical expenses. It is sometimes used more broadly to include insurance covering disability, long-term nursing or custodial care needs. It may be provided through a government-sponsored social insurance program or from private insurance companies

Responsibilities:

• Worked as Informatica Developer in Corporate Audit Technology team.
• Analyzing the source data coming from different sources and working with business users and developers to develop the Model.
• Interacted with Business Analysts and Business Users to gather the Business Requirements.
• Involved in design and development of the Data Mart for ATM Automated Test Management using Erwin.
• Written Functional Design Document and Technical Design Documents
• Jobs were run on demand basis and some were scheduled to load the data into tables on daily basis.
• Auditors request the Audits from a web based front end, which run the mappings in the background and send results in a .csv format to auditors.
• Used loading techniques like Slowly Changing Dimensions and Incremental Loading using parameter files and mapping variables
• Used the Power Center client tools Designer, Workflow Manager, and Workflow Monitor
• Worked with various Active transformation like Filter, Sorter, Aggregator, Router, and Joiner transformations
• Performed Data cleansing prior to Transformation and Loading for heterogeneous sources.
• Data from different sources was written to Oracle tables and these tables were used to query for the Auditors request.
• Worked on OLAP database and mappings were written to query OLAP and sent out the Audit reports.
• Worked using Global repository and used the OLAP sources to write mappings.
• Sources include Mainframe, SQL Server, Oracle, and Flat Files.
• Followed complete cycle of SDLC, coding, testing including test case scenarios, tested the data in QA and fixed any errors.
• Automated the Mappings, Sessions, and Workflows using Automated Test Management.
• Integrated the Mappings to a web front end so that the auditors can use the website and run the testing through it and the results will be delivered to them in a csv format.
• Prepared Documentation so that Auditors can easily understand the whole process, and run desired Audits through Automated test Management
• Evaluated the Business requirements and depending on the requirement, the Auditors were given an option to select a sample load or full load for Auditing.
• Different campaigns were conducted from time to time, and the National Do Not call Match list was compared so that customers who opt out of Telemarketing will not receive any calls.
• Implemented different Performance tuning methods such as filtering the data right at the Source Qualifier, implemented Partitioning.
• Used different Mapping and Session parameters as the variables, which were in turn used as required or optional values that has to be entered by the Auditors in the Front end while they run the Audit.

Environment: Informatica Power Center 8.6.1, PowerExchange,DB Artesian, Oracle 9i,SQL Server,DB2, Teradata, Shell Scripting, SQL, PL/SQL, SQL Loader, Autosys, Toad, Unix, Sun Solaris 2.6, Windows 2000 Server, Terminal Services Client.

JPMorgan Chase, Dallas, TX Jan 2010 to May 2011

ETL Developer

Description:

JPMorgan Chase is an American multinational banking and financial services holding company. It is the largest bank in the United States, with total assets of US 2.515 trillion. It is a major provider of financial services. Activities are organized, for management reporting purposes, into five business segments. It's corporate investment bank, card services and consumer lending, commercial banking personal and business banking, home lending, asset management, corporate including private equity One Equity Partners and treasury and corporate functions.

Responsibilities:

• Requirement gathering and Business Analysis and documentation for business data flow from source to mart Business To Business .
• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica Power Center
• Interfaced with various members of the technical and business team to translate the business reporting and data maintenance requirements into functional ETL code.
• Created reusable transformations to be re-used in the Informatica mappings.
• Creating Relational connections, Entity and attribute definitions and created physical data model.
• Understanding the business process between Juniper and Teleplan, and designing the model according to the end users requirements.
• Created Test Cases for Unit and Integration Testing to ensure successful execution of data loading process.
• Hands on experience in writing Unix scripts for various purposes SFTP, Creating Parameter Files, Automation, For running Informatica workflows
• Created UNIX shell script for processing data files, for archiving and running the workflows.
• Designed Design deliverables like High Level and Low Level Design documents.
• Created session tasks and managed database connections and scheduled workflows.
• Created Packages, Stored Procedures Functions, Triggers and Views to perform Error Handling Validation on source stage.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Move the mappings and scripts between various environments like the Dev, QA and production.
• Interacting with Unix, Informatica and Data base administrators If any issues/concerns occurred
• Sending emails to users and administrators through Informatica session on success or failure and sending email through UNIX SFTP script to the team if the file transfer fails.
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Worked with SSRS reporting team and involved in generating reports.
• Provided data to the reporting team for their daily, weekly and monthly reports.

Environment: Informatica Power Center 8.1, Power Exchange, Erwin 4.0, Oracle 9i/8i, PL/SQL, SSIS, DB2, Flat files, Trillium 7.6 SSRS 2005, SQL Loader, OS/390, JCL, HP-UX 11.11, Visual Basic, UNIX scripting, Windows NT

FirstGroup America, Cincinnati, OH May 2008 to Jan 2010

Informatica Developer

Description:

The client is into the Health and Medical care vertical. The prime responsibility of the team is to develop a Patient Care Data Warehouse PCDW .This data warehouse is used to access easily the detailed clinical data on a platform and also to facilitate the enterprise-wide data analysis within the health care environment.

Responsibilities:

• Gathered business requirements, established functional specifications, translated them to design specifications.
• Data conversions from different legacy systems in accordance with the business rules into the Oracle Application system.
• Worked closely with SME's to convert the legacy data for assigned modules.
• Worked independently and in a team to convert Item Costs, Price Lists, Quantity On-Hand and Sourcing rules and Assignment sets from various systems into the Oracle EBS interface tables.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations.
• Written Complex SQL overrides for source qualifier and Lookups in mappings.
• Designed and developed validation scripts based on business rules to check the Quality of data loaded into EBS.
• Written ETL specifications for all the development tasks, to better evolve the ETL design.
• Worked with various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Involved in Data Quality Analysis to determine cleansing requirements.
• Helped the team in analyzing the data to be able to identify the data quality issues.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Done caching optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Performance tuning to ensure optimal session performance.
• Extensively used Informatica debugger to validate Mappings and to gain troubleshooting information about data and error conditions.
• Used Erwin for data modeling and Dimensional Data Modeling.
• Designed and created logical physical data models to support strategic business decisions.
• Designed, Developed, Reengineered and fine-tuned SQL queries and Oracle Stored Procedures and triggers.
• Involved in Designing data models for Data warehouse supporting data from multiple sources on real time.
• Designed and developed Informatica mappings for data loads.

Environment: Informatica Power Center 6.2, ERWIN 3.5, BO 6.0, TeraData V2R3, Oracle 8i, SQL, PL/SQL, DB2 7.0, SQL Server 2000, UNIX Shell Scripting, Windows.

University of FL, Gainesville, FL October 2007 to April 2008

Informatica Developer

Description:

UFL is one of the leading nonprofit schools in the United States. Working as part of ESDM Enterprise Systems and Data Management to build EDW projects to integrate data from different source systems. EDW aim is to integrate student's data from all branches under UPMC onto one platform. There are various staging layers to validate, clean the data and finally load into the dimensional layer. Process includes loading the source system data into Source landing and validating through error process and loading into dimensional tables.

Responsibilities:

• Coordinated with the client and gathering the user requirements.
• Created Technical design specification documents based on the functional design documents and the physical data model.
• Developed Informatica Mappings and Reusable Transformations for Daily, Weekly and Monthly Loading of Data.
• Worked on developing mappings and mapplets to extract and load the data from Oracle, Flat files and COBOL files.
• Created tasks like Session, Decision, Email, Command, Event Wait, Event Raise and Control tasks in preparing the Workflow.
• Used Type 1 SCD discard previous versions of dimensions in the target table and Type 2 SCD maintain history mapping to update Slowly Changing Dimension Tables Scheduling the workflows comprising of different sessions for their respective mappings in order to load data into Oracle database.
• Wrote complete PL/SQL procedures and SQL queries using Toad 7.6.
• Handled creation, modification and documentation of Packages, Procedures, Functions and Indexes.
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Maintained warehouse metadata, naming standards and data warehouse standards for future application development
• Involved in different Team review meetings, prepared project documentation, Program Specifications, Test Cases and Participated in the complete SDLC.

Environment: Informatica Power Center 7.1/6.4, Informatica Power Exchange, Toad 7.6,DB2 9.1,Teradata, Autosys, PL/SQL, SQL Plus, SQL Loader, XML, Windows NT 4.0, Cobol, DB2, Sun Solaris Unix 2.6, Unix Shell Scripting putty .

Maximaa Systems Ltd., Mumbai, India Jan 2006 to Sept 2007

ETL DEVELOPER,

Description:

MaxiMaa Systems Ltd is a pioneer and market leader in storage system and furniture since the inception of the company.Basedpn the client's requirement providing suitable solutions within the budget range. Our concept is unique, total consultancy right from the designing till the installation is provided.

Responsibilities:

• Responsible for the development and maintenance of the Inventory control and the client contract modules.
• Interacted with the business users on a regular basis to collect business requirements and specifications.
• Tested new enhancements and bug fixes before deployment into production environment.
• Used advanced data types of collections.
• Worked as part of a team to launch new application releases under strict time deadlines.
• Coded database Triggers, Packages, Functions and Procedures using PL/SQL and maintained the scripts for various data feeds.
• Optimized and Tuned PL/SQL to reduce the loading process. Utilized SQL Loader to perform bulk data loads into database tables from external data files.
• Responsible for designing and maintaining fully integrated and multiple help systems for the modules.
• Prepared functional specifications, release notes, training materials and other documentation.

Environment: Oracle RDBMS 9i, PL/SQL, JAVA, SQL Plus Reports, SQL Loader, XML, Toad

Education: Bachelor's degree.