SUMMARY

• Over 8 years of IT Experience in Analysis, Design, Development, Implementation and Support of Relational Database(OLTP), Data Warehousing Systems(OLAP) and Data Marts in Insurance, Financial, medical and Pharmaceutical domains.
• 6+ years of Data Warehousing in Extraction, Transformation, and Loading (ETL) using Informatica Power Center 9.X/8.X/7.X.
• Good understanding in Data Warehousing Methodologies using Ralph Kimball and Bill Inmon to solve the business problems.
• Well versed with Relational and Dimensional Modelling techniques like Star Schema, Snowflake Schema, Fact and Dimensional Tables
• Data modeling experience in RDBMS Concepts, Normalization, surrogate keys.
• Extensive experience in integration of various heterogeneous data sources definitions like SQL Server, Oracle, Teradata, Flat Files, Excel and XML files loaded data in to Data ware house and Data marts using Power center.
• Knowledge of Master Data Management (MDM), Change Data Capture (CDC) and Informatica Data Quality (IDQ) concept.
• Worked extensively in creating complex Mappings using various transformations like Unconnected and Connected lookups, Source Qualifier, Joiner, Rank, Sorter, Router, Filter, Expression, Aggregator, Joiner and Update Strategy, Normalizer etc.
• Strong skills in SQL and PL/SQL, backend programming, creating database objects like Stored Procedures, Functions, Cursors, Triggers, and Packages.
• Well versed in developing various database objects like packages, stored procedures, functions, triggers, tables, indexes, constraints, views in Oracle 11g/10g
• Worked on Performance tuning, Indexing and Partitioning techniques on Sources, Targets, Mappings, and session levels in Informatica.
• Identified bugs in existing mappings by analyzing the data flow and evaluating transformations using Informatica Debugger.
• Good working knowledge of Claims processing and Worked onFACETS - a product for Healthcare Insurance sector.
• Experienced in Code Migration, Version control, scheduling tools, Auditing, shared folders, and Data Cleansing.
• Profound knowledge in coding the BTEQ Scripts, MLoad, Fast Load, TPUMP to perform data load in Teradata warehouse.
• Good communication and interpersonal skills, ability to learn quickly, with good analytical reasoning and adaptive to new and challenging technological environment.
• Strong Team working spirit, relationship management and presentation skills.

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 9.5/9.1/8.6 (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet, Transformations), Metadata, DataMart, OLAP, OLTP, SQL*Plus, Business objects XI.

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Databases: Oracle 11g/10g/9i, MS SQL Server 2005/07and MS Access

Design Software: Adobe In Design CSS 3,4,5, Adobe Illustrator, design software, Fireworks, NetBeans.

Programming Languages: SQL, PL/SQ, SQL*Plus, Visual Basic 6.0, HTML, DHTML, C, C++, Unix Shell Scripting, XML, JavaScript, UML, PHP

Tools: TOAD, SQL Developer, SQL *Loader, SQL *Plus, Oracle reports developer 9i/10g, Oracle forms 9i/10g, Informatica 9.x/8.x, version control (SVN).

Web Technologies: HTML, Microsoft Internet Information Server (IIS), VB Script, Java Script, CSS, DHTML, XML, Ruby on Rails, PHP 5.0,Ajax, JQueryMethodology Ralph Kimball, Inmon, Agile, Iterative, Rapid Application Development (RAD), Waterfall model, IEEE network protocols, Six Sigma, CMM, Test Script Language (TSL), Unit Testing, Integration Testing, Functional Testing, SQA Basic.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr. Informatica Developer

Responsibilities:

• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code
• Developed Design Document and Data Discovery according to clients’ requirement closely worked with DBA’s for performance related issues.
• Used Mapping, Session, and Workflow level parameters.
• Created Worklets in order to implement reusable logic composed of multiple sessions.
• Developed Mapplets to implement reusable transformational logic.
• Perform analysis on quality and source of data to determine accuracy of information being reported and analyze data relationships between systems.
• Extensively worked on Data Masking as well as performance tuning.
• Used ILM tool for Creation of Mapping for Data Masking, Created Rules for ILM.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Actively involved in Performance Tuning.
• Worked on Implementation &Production Support using FACETS
• Provided detailed analysis using Microsoft Access queries, troubleshooting and correcting issues utilizing Microsoft Access, SQL and Excel. Reporting and updatingFACETSdata to ensure proper configuration process.
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
• Partitioned Sessions for concurrent loading of data into the target tables.
• Created script to execute the workflow using pm cmd command in UNIX.
• Used Debugger to test the data flow and fix the mappings.
• Implemented daily and weekly audit process for the Claims subject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.
• Involved in writing SQL scripts, stored procedures, and functions and debugging them.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Actively involved in production support Implemented fixes/solutions to issues/tickets raised by user community.
• Created step by step enduser manual forend users .

Environment: Informatica PowerCenter 9.5, SQL Server 2012, Erwin 4.1, Windows XP, UNIX, Oracle 11g, Visio,FACETS

Confidential, Denver, CO

ETL Informatica Developer/Support

Responsibilities:

• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Hands on experience in data modeling (logical and physical) for designing and developing the Data Marts and data ware housing using multi-dimensional models like such as snow flake schema or star schema for different insurances.
• Extensive experience in extraction of data from various sources like relational databases Oracle, SQL Server, Flat Files, MS Access & XML Files and DB2.
• Involved in business analysis and technical design sessions with business and technical staff in ETL architecture and its design to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Created mappings using transformations like source qualifier, joiner transformation, filter, update strategy, lookup transformation, rank transformations, expressions, aggregator, and sequence generator to load the data from source to Data Staging Area, Data marts and to DW in oracle.
• Developed Mapplets and Worklets for reusability and to improve performance.
• Experience in versioning the whole process and retiring the old records using the built-in's DD UPDATE, DD DELETE, and DD INSERT.
• Extensively worked on Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Performed triggers, stored procedures for Complex mappings, and cursors for data extraction and to carry out updates of new fields.
• Designed seed mapping for extracting data from source tables and loading into master tables.
• Tested the model in Development environment and successfully moved into the Test and STP environment.
• Designed and developed the logic for handling slowly changing dimension tables load by flagging the record using update strategy for populating the desired.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations, and target loads.
• Worked extensively on SQL, PL/SQL using TOAD and UNIX Shell Scripts
• Accepted inbound transactions from multiple sources using FACETS
• Imported integrated EDI batch processing and real- time EDI using FACETS
• Extensively worked in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Handled creation, modifications, and documentation of Oracle Packages, Procedures, Functions, and Indexes.
• Actively involved in the production support.

Environment: Informatica PowerCenter v9.1, 8.6, Oracle 11g, IMS Database (DB1), DB2, Teradata, SQL, Flat Files,Erwin,FACETS, Putty, Windows-XP (Client), Mainframe, Unix, AS/400, TOAD 9.0, MS Visio, ILM, Informatica servers on Unix and PowerExchange.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Involved in design and development of business requirements in liaison to business users and technical teams Analyzed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Participated actively in end user meetings and collected requirements.
• Used Informatica Power Center 8.1 for extraction, transformation and loading (ETL) of data in the Data Warehouse.
• Designed, developed, and documented several mappings to extract the data from Flat files and Relational sources.
• Developed Mappings including transformations: Aggregator, Joiner, Lookup (Connected & Un-connected), Filter, Update Strategy, Stored Procedure, Router, Expression, SQ and Sorter. Developed re-usable transformations, mappings and Mapplets confirming to the business rules
• Created workflows and tested mappings and workflows in development and production environment.
• Used Debugger to test the mappings and fix the bugs.
• Defined Functional Test Cases, documented, Executed test script in FACETSsystem.
• Actively involved in performance improvements of mapping and sessions and fine-tuned all transformations.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Performed Informatica code migration from development/ QA/ production and fixed and solved mapping and workflow problems.
• Performance tuning of existing stored procedures, functions, views, & SQL Queries.

Environment: Informatica 8.6, UNIX Scripting, Toad, Oracle 10g, FACETS,Business Objects 6.5, Control-M, Data Analyzer

Confidential, Herndon, VA

Informatica/ETL Developer

Responsibilities:

• Extensively used Informatica PowerCenter for extracting, transforming, and loading databases from sources including Oracle, DB2, and Flat files. Collaborated with EDW team in, High Level design documents for extract, transform, validate, and load ETL process data dictionaries, Metadata descriptions, file layouts, and flow diagrams.
• Participated in User meetings, gathering requirements, discussing the issues to be resolved.
• Worked with business analysts, application developers, production teams and across.
• Translating user inputs into ETL design docs.
• Participate in Design Reviews of Data model and Informatica mapping design.
• Functional units to identify business needs and discuss solution options.
• Worked on dimensional modeling to Design and develop STAR Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Integrated data from diverse source systems including Sales force, Siebel, MS SQL Server, and flat files using Informatica Power Center.
• Accessed to native database APIs using SQL in power exchange to provide high performance extraction, conversion and filtering of data without intermediate staging and programming.
• Performed match/merge and ran match rules to check the effectiveness on data.
• Created mappings using various Transformations like Aggregator, Expression, Filter, Router, Joiner, Lookup, Update strategy, Source Qualifier, Sequence generator, Stored Procedure and Normalizer.
• Extensively used debugger for troubleshooting issues and checking session stats and errorLogs.
• Performed validation and testing of Informatica mapping against the pre-defined ETL design standards
• Implemented Performance tuning at database level and at Informatica level. Reduce load time by using partitions and concurrent sessions running at a time
• Involved in writing SQL, PL/SQL, Stored Procedures, Triggers and Packages in DataWarehouse environments that employ Oracle.
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load, update Processesand Batch processes Scheduled Sessions and Batches in Server.
• Writing shell scripts to automate the export data into flat files for backup and delete data
• From staging tables for the given time period.
• Extensive experience in performance tuning, identifying bottlenecks and resolving to improv
• Performance at database level, Informatica mappings and session level.
• Involved in the optimization of SQL queries which resulted in substantial performanceImprovement for the conversion processes.
• Worked on Performance Testing, Works within an Oracle environment performing PL/SQLCode development, building high performing Oracle queries, and tuning existing queries
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluatingTransformations.
• Involved in migration of objects in all phases (DEV, INT and PRD) of project and trained
• Developers to maintain system when in production

Environment: Informatica Power Center 8.1.1, MS SQL Server 2012, Flat files, Erwin, UNIX Shell Scripting, Toad, Autosys, Windows 2003 Server.

Confidential

ETL Developer/Tester

Responsibilities:

• Worked with team to design, develop, test, and implement system.
• Created database objects like Tables, Views and Triggers, Procedures, Packages using Oracle tools like SQL Plus and Toad.
• Created PL/SQL Triggers to monitor the database activities and to implement some database constraints.
• Involved in Data Loading and Data Migration.
• Used SQL*Loader to load data from flat/Excel file into the temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Created web based Forms and Reports.
• Modified existing codesand developedPL/SQL packages to perform Certain Specialized functions/enhancements.
• Involved in problem analysis, resolution, troubleshooting,andPerformance Tuning.
• Used Export and Import utilities to transport data from production to testing and to other databases.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL, PL SQL, SQL*Loader, TOAD

Confidential

Jr Pl/SQL Server Developer

Responsibilities:

• Developing packages, procedures, functions, and triggers for the application.
• Using UNIX environment for performing the testing
• Performing the tests on the newly coded procedures and documenting the same.
• Writing technical documents using the functional specifications.
• Writing PL/SQL code using the technical and functional specifications.
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Automated sqlldr using shell scripting.
• Automated data fetch using UNIX shell script.
• Optimized the queries to improve the performance of the application.

Environment: Oracle 8.3, SQL * Plus, TOAD, SQL*Loader, Forms 4.5 & Reports3.0 and Windows 2000 professional, UNIX shell scripting.