SUMMARY:

• Total of 7+ years of experience in System Analysis, Design, Development, Implementation, and Testing and implementation of business applications with RDBMS, Data Warehouse/Data Mart, ETL, OLAP, Client/Server environment applications for Financial, Pharmacy and Insurance Verticals.
• Solid experience in Data Warehousing Concepts like Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling using Erwin 4.0
• Directly responsible for teh Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
• Created mappings using different transformations like Expression, Aggregator, Lookup, Router, Update strategy, Filter and Stored Procedure transformations to extract and integrate teh data from different databases and files
• Implementation and Maintenance in Client/Server architecture, Informatica Power Mart/Power Center.
• Good experience in documenting teh ETL process flow for better maintenance and analyzing teh process flow
• Expert in troubleshooting/debugging and improving performance at different stages like, workflows, mappings
• Delivered optimum benefits and has full life cycle implementation exposure: Business Requirements Definition, Modeling, Mapping, Data Conversion, and Validation.
• Quick learner and adaptive to new and challenging technological environments
• Excellent Interpersonal Skills with teh ability to work independently and with teh team.

TECHNICAL SKILLS:

Data Warehousing: PowerCenter 9.5/9.1/8.6/8.1/8.0/7.1.4/7.1.3/7.1.2/7.1.1/7.0,Repository Admin Console, Power Exchange Navigator, Information Lifecycle Management (ILM)

ETL: Repository, Informatica Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Star Schema, Snowflake Schema, Data Warehouse, Data Mart, FACT tables, Dimension tables.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow - Flake, FACT, Dimensions), Entities, Attributes, OLAP, OLTP, Cardinality, ER Diagrams, Erwin 4.2/4.0/3.5.5/3.5.2)

Tools: Toad, Erwin 4.1/7.3, Rational Rose, MS Project, Test Director, MS Visio, VMware View Client

Environment: UNIX (Sun Solaris, HP, Linux), Windows 2003/2000/XP/98

Others: Microsoft Word, Microsoft Excel, Outlook

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

Sr. DW Informatica Developer

Responsibilities:

• Gathered Business requirements from teh end users and reporting team.
• Participated in teh entire life cycle of teh project, which involved understanding scope of teh project, functionality, Data modeling, technical Architecture document, technical design and complete development.
• Extensively used ERWIN to design Logical/Physical Data Models, forward/reverse engineering, publishing data model to acrobat files.
• Involved in teh documentation of HIPAA 5010 changes toEDI 837, 834, 835, 276, 277 Transactions.
• Designed and developed Operational Data Store, Slowly Changing Dimension, Staging areas etc.
• DesignedInformaticaArchitecture for development, integration and system test environments.
• Involved in extraction of data from various sources like flat files, Oracle and SQL Server.
• Associated with design and development of around 40+ mappings.
• Used debugger to test teh mapping and fixed teh bugs. Created and used Debugger sessions to debug sessions and created breakpoints for better analysis of mappings.
• Created mapping variables and parameters and used them appropriately in mappings.
• Implemented Slowly Changing dimension methodology (type 2) for accessing teh full history of accounts and transaction information.
• Analyzed teh session logs, bad files and error tables for troubleshooting mappings and sessions.
• Designed and Developed pre-session, post-session routines for Informatica sessions to drop and recreate indexes and key constraints for Bulk Loading.
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
• Co-ordinate with teh off-shore teams and mentored junior developers.
• involved running teh various types of Pipelines and running teh Truecomp Data Mart etl's.
• involved in teh automation of Truecomp activites through unix shellscripts.
• Created Indexes and sequences for faster retrieval of teh member information and enhance teh database performance.

Environment: Informatica Power Center 9.5/9.1/v 8.6.1, IBM Data Stage7.5.1, Power Exchange, IBM Rational Data Architect v7.0.5, HP 3000, XML/XSD, Qwest Center, MS SQL Server, Teradata.

Confidential, Nashville, TN

Sr. DW Informatica Developer

Responsibilities:

• Interacting with clients and Business Stake Holders, Business Analysts to analysing teh requirements.
• Worked extensively on teh Informatica PowerCenter 9.1/9.5 on Designer, Workflow Monitor, WorkFlow Manger, and Repository Manager.
• Developing mappings to suite according to teh source and target requirements and implemented various transformations such as Source Qualifier, Expression, Sorter, Aggregator, Router, Filter, Lookup, Sequence generator, Update strategy.
• Worked on lookups on target to implement inserts and update flows.
• Developed mappings to transform data from various sources (.csv, .xls, .txt, .xml files) to various targets.
• Created workflows and worklets and defined target load order to load teh data into targets accordingly.
• Created email tasks to notify teh success and failure of a work flow.
• Created command task to trigger files from source locations whenever teh work flow gets execute.
• Generated pre sql and post sql scripts at Informatica level.
• Used SQL Overrides in Lookups, Source filter in Source Qualifier
• Used parameter files to initialize teh sessions and session variables.
• Analysed teh data to determine teh data cleansing requirements. Performed unit testing and involved in regression and integration testing phases.
• Developed SCD’s to maintain full history.

Environment: Informatica PowerCenter 8.6/8.1 (Repository Manager, PowerCenter Designer, Workflow Manager, Workflow Monitor), Oracle 10g, sqlserver 2008, MS-Access, PeopleSoft, SSRS/SSIS, Unix, Window 7, JIRA, Active Batch, Informatica Power Exchanger, MS-Visio, Microsoft tools, Putty.

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

• Extensively used various transformations like Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for teh capturing delta loads
• Worked with various tasks like Session, E-Mail, Workflows, Worklets, and Command
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in teh Aggregator Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in teh Joiner Transformation.
• Extensively worked with various re-usable tasks, workflows, worklets, Mapplets, and re-usable transformations
• Implemented various new components like increasing teh DTM Buffer Size, Database Estimation, Incremental Loading, Incremental aggregation, Validation Techniques, and load efficiency
• Worked with Session logs, Informatica Debugger and Performance logs for error handling workflows and session fails

Environment: Informatica Power Center 8.0/7.1.4(Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 9i, SQL Server, CA Autosys, Teradata (T-Pump, Fast Load, Multi Load)

Confidential, Minnesota

Informatica Developer

Responsibilities:

• Used Informatica as ETL Tool. Worked in all phases of Data Integration from heterogeneous sources, legacy systems to Target Database.
• Worked on Informatica Power Center toolSource Analyser, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager, Informatica Workflow Manager and Workflow Monitor
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in teh Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Implemented Slowly Changing Dimensions - Type I II in different mappings as per teh requirements.
• Strong experience in using Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache. .
• Responsible for migrate teh code using export and Import utilities across various Instances
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Responsible for Unit Testing of Mappings and Workflows.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
• Maintained effective communication with non-technical client personal and handled teh change requests. Provided Production Support.

Environment: Informatica Powercenter 7.1.3, Repository Manager, Designer, XML Files, CSV files, PL SQL(Stored Procedure, Trigger, Packages), QlikView 9.0 8.5, Windows 2003 2007, UNIX AIX 5.3, UNIX

Confidential, SFO

ETL Developer

Roles Responsibilities:

• Provide periodic updates to teh Business and Analysts on showstoppers to ensure appropriate actions are taken.
• Interacting with Business unit to understand teh business requirements and provide teh possible solutions.
• Develop design specifications for data integrate & to populate Data warehouse databases and data analysis.
• Design, develop, test, deploy and manage teh data integration BI systems.
• Experience in complex transformations like Transaction control, Java transformation, Unconnected Stored Procedures, SQL, Normalizer, Lookup, Expression, aggregator, update strategy, and execution of test plans for loading teh data successfully into teh target table definition.
• Address performance issues requiring in ETL system and SQL tuning.
• Proficiency in Teradata utilities like BTEQ, tbuild mload, fast export and tpump.
• Designed and developed data marts to support reporting requirements and external applications that are fed from teh DW.

Environment: Informatica Power Center 7.1, Power Designer, SQL, PL SQL, Oracle 10g, Flat Files, Business Objects 6.5 and Windows 2003, Redhat Linux AS 4.0

Confidential, Paramus, New Jersey

Informatica Developer

Job Responsibilities:

• Worked on Informatica tools, Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Used Lookup Transformation to access data from tables, which are not teh source for mapping.
• Responsible for teh daily loads and handling teh reject data.
• Changed some stored procedures in Oracle 9i as per teh Business Requirements.
• Extensively worked with flat files and excel sheet data sources. Wrote batch scripts to automate flat file transportation local to Informatica server.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Worklets, Assignment, Timer and scheduling of teh workflow.
• Developed mapping parameters and variables to support SQL override.
• Created physical data models and procedures for DB2 and Oracle.
• Used Informatica Data Explorer and Informatica Data Quality for Data Quality Management and Data profiling purposes.
• Used Informatica Data Quality to formulate data conversion and data cleansing rules.
• Generated Perl scripts for data validation, data collection and data importing.
• Used techniques like source query tuning, single pass reading and caching lookups to achieve optimized performance.
• Used Teradata SQL Assistant to run teh SQL queries and validate teh data.
• Associated with Production support team in various performances related issues.

Environment:InformaticaPower Center 7.0, Oracle8i, IDQ, Perl Scripting, Cognos, PL/SQL, SQL Navigator, DB2, ERWIN, Teradata SQL Assistant, Teradata BTEQ