SUMMARY

• Seven plus years of experience in the Software Development Life Cycle (SDLC) that includes expertise in the Analysis, Design, Development, Implementation, Modeling, Testing and Support for Data Warehouse applications
• Six years of experience in Data Warehousing using the tool Informatica PowerCenter 9.0.1/8.6/7.1 (Designer, Repository Manager, Workflow Manager, Workflow Monitor and PowerCenter Administration Console)
• Three years of experience in using Business Intelligence applications such as OBIEE 11X, Business Objects, SSAS, SSRS and SSIS
• Experienced in working for clients from Healthcare, Pharmaceutical, Banking and Retail Sector
• Extensively used applications in the Informatica PowerCenter Designer such as Source Analyzer, Transformation Developer, Target Designer, Mapping Designer, Mapplet Designer and Schedulers
• Developed complex mappings using transformations such as Aggregator, Connected and Unconnected Lookup, Filter, Joiner, Expression, Filter, Sorter, Router, Normalizer, Source Qualifier and Update Strategy
• Experience working with various heterogeneous source systems such as Oracle, DB2, MS SQL server, XML files, flat files, Teradata, Netezza and MySQL server
• Performed ETL performance tuning of the sources, targets, transformations, mappings, workflows and sessions to resolve or remove the bottlenecks
• Expert in using debugger in the Informatica PowerCenter Designer to test and fix errors in the mappings
• Strong background in Data Warehousing concepts and implementing Dimensional modeling concepts (Star and Snowflake schema, type 2 and type 3 SCD’s)
• Experience in using SQL tools such as TOAD/ SQL Developer/ SQL Plus/ SQL Loader to run SQL queries and validate the data
• Extensively used PL/SQL to write Stored Procedures, Functions and Triggers and involved in DB partitioning for improving performance of SQL queries
• Used the Semantic Layer concept to guarantee correct results, improve database performance and improving user understanding and acceptance
• Knowledge about SOA 10g and 11g components (BPEL, Mediator, Human Task, Business rules)
• Experience in Unix shell scripting and Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, SQL Assistant)
• Experience working on the Netezza Twinfin 24 server and knowledge about the Netezza architecture
• Experience in Unix/Solaris OS commands and in scheduling tools like Autosys
• Knowledge of Erwin and FACT for Data Modeling
• Effective skills in communication and writing along with a professional attitude and strong work ethic

TECHNICAL SKILLS

Data Warehousing/ETL: Informatica Power Center 9.5/9.1/8.6/7.1

Data Modeling: Dimensional Data Modeling - Star and Snowflake Schema, Fact and Dimension Tables, Physical and Logical Data Modeling; Erwin 7.1.3

Databases: Oracle 11g/10g/9i, MS SQL Server 7.0/2008/2005 , Teradata, Neteza.

Languages: PL/SQL, T-SQL, C, C#/.Net

Operating System: Unix/Linux, Sun Solaris, Windows NT/2000/2008

Other Tools and Utilities: SQL Plus, TOAD,SQL Developer, BO 6.5, Cognos, SharePoint, CVS

PROFESSIONAL EXPERIENCE

Confidential, Framingham, MA

Sr. Informatica ETL Developer

Responsibilities:

• Interact with Business Analyst to assist him in Understanding the Source and Target System.
• Modified existing / developed new complex Informatica Power Center Mappings to extract and pull the data according to the guidelines provided by the business users and populate the data into Target Systems.
• Responsible to pull the data from XML files, Flat files (Fixed width & Delimited) and COBOL files by using complex transformations like Normalizer, XML Source Qualifier etc.
• Extracted and transformed data from various sources like Teradata and relational databases (Oracle, SQL Server).
• Involved in generating Mload and Tpump scripts to load the data into Teradata tables.
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Worked extensively to create views using Composite s/w and publish them as web link.
• Sourced data using WEB SERVICES transformation.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision mail, command, worklets, assignment, timer and scheduling of the workflow.
• Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
• Designed and developed UNIX Shell scripts to report job failure alerts.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential, parallel, and initial and Incremental Load.
• Worked on SQL tools like TOAD and SQL Developer to run SQL Queries and validate the data.
• Scheduled Informatica Jobs through UC4 scheduling tool.
• Assisted QA team to fix and find solutions for the production issues
• Prepared all documents necessary for knowledge transfer such as ETL strategy, ETL development standards, ETL processes, etc.

Environment: Informatica Power Center 9.0.1, Oracle 11g, Teradata, Netezza, Erwin, PL/SQL, UC4/Autosys, MS-SQL Server 2008, Toad, MS-Visio, Windows XP, SSIS, OBIEE 10.1.3.4.1.

Confidential, Exchange Pl, NJ

Data Warehouse/ Business Intelligence Developer

Responsibilities:

• Analyzed, designed and developed Business Intelligence technical solutions leveraging off the shelf technologies such as OBIEE and Informatica.
• Participated in the full development life-cycle from developing business intelligence requirements to QA and production deployment.
• Adhered to best Data Warehousing practices when modeling Business Intelligence solutions
• Designed STAR Schema Data Warehouse Models using Facts and Dimensions
• Enhancing the existing mappings to implement SCD Type 2.
• Involved in extracting source data from spread sheet and flat files both Direct and Indirect.
• Communicated both functional and technical designs and changes to all appropriate agents
• Collaborated with and mentored current development staff in the use of Business Intelligence (OBIEE), Informatica and Oracle coding language based on numerous prior development activities in these environments.
• Utilized prior knowledge of related tools and obtained knowledge of other technologies in support of the organization projects.
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Created several EBS subject areas such as Post Award Management, Award Management Installments, Grants Snapshot, Human Resources, Purchase Order Distribution, etc.
• Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
• Worked on OBIEE 11 g and Discoverer 11 g to create reports in different subject areas.
• Worked on SQL tools like TOAD and SQL Developer to run SQL Queries and validate the data.
• Scheduled Informatica Jobs through Autosys scheduling tool.

Environment: Informatica Power Center 9.1, OBIEE 11g, Oracle 11g, Discoverer 11g, PL/SQL, Autosys, Toad, Windows 7.

Confidential, Kansas city, KS

ETL Developer

Responsibilities:

• Involved in designing the mapping document according to HIPAA 5010 and ICD10 standards
• Created views on all required claims tables and got required data into the staging area
• Created 837 outbound tables in the database and populated all the data in it from staging area using Informatica Power Center
• Created mappings using unstructured data transformation and calling HIPAA library functions like parser and serializer in it
• Converted 837 claims table data into EDI format using data transformation
• Developed different mappings for healthcare institutional and professional data
• Converted EDI X12 format files claims to XML files using parser in B2B data transformation
• Filtered the xml claims files by using filter conditions on D9 segment and converted back the filtered xml claim files to EDI format using serializer in B2B data transformation
• Used B2B Data Exchange for end-to-end data visibility through event monitoring and to provide a universal data transformation supporting numerous formats, documents and files
• Populated the Acknowledged information about the claims in the data base tables
• Developed Technical Specifications of the ETL process flow.
• Extensively used ETL to load data from Flat files, XML files SQL server, and Oracle sources to SQL server target.
• Created mappings using different transformations like Expression, Unstructured Data transformations, Stored Procedure, Filter, Joiner, Lookup and Update Strategy.
• Created Triggers to update the data in the 837 outbound tables
• Used Tidal for scheduling.
• Involved in Integration, system, and performance testing levels.

Environment: Informatica Power Center 9.1.0, SQL Server 2008, Oracle 11g, Toad 8.0, B2B Data Transformation, FACT, T-SQL, Windows7.

Confidential, Hartford, CT

ETL Developer

Responsibilities:

• Extraction, Transformation and Loading of the data using Informatica.
• Designed the target load process based on the requirements documents.
• Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance
• Created sessions and batches to move data at specific intervals & on demand using Server Manager
• Responsibilities include creating the sessions and scheduling the sessions
• Recovering the failed Sessions and Batches.
• Involving in extracting the data from Direct Flat files and Indirect Flat files.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue
• Preparing the documents for test data loading.

Environment: Oracle SQL * Plus, TOAD, Informatica Power center 8.1.1, PLSQL developer, Oracle SQL, PL/SQL and Oracle10g/9i, SQL Server, DB2 8.0, SOA 10g, Business Objects 6.5.

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Involved in gathering business requirements by direct interaction with users.
• Extensively used ETL to transfer data from different source system and load the data into the target database.
• Extracted the data from the flat files and other RDBMS databases like Oracle, Teradata, DB2, and CSV files, into staging area and populated onto Data Warehouse in Oracle.
• Developed number of complex Informatica mappings, mapplets, reusable transformations to implement the business logic and load the data incrementally.
• Worked on different transformations like Source Qualifier, Joiner, Filter, Update Strategy, Lookup, Rank, Expression, Aggregator and Sequence Generator to load data into target database.
• Responsible for Data Staging Development and Deployment.
• Handled Slowly Changing Dimensions of Type1/ Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Used Debugger to track the path of the source data and also to check the errors in mapping.
• Created session tasks, worklets and workflows to execute the mappings.
• Involved in monitoring the workflows and in optimizing the load times.
• Involved in Performance Tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Involved in creating the runbook and migration document (from Development to Production).
• Document the process for further maintenance and support.
• Worked on developing test cases for ETL mappings.

Environment: Informatica Power Center 8.1, Teradata, Unix Shell Scripting, Oracle, PL/SQL, DB2, C#/.NET, Flat files.

Confidential

Jr. ETL Informatica Developer

Responsibilities:

• Worked closely with various Application and Business teams to develop Data Model and ETL procedures in designing Data Warehouse with respect to business requirements.
• Worked Extensively on Informatica tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Designed and developed Mapplets for faster development, standardization and reusability purposes.
• Designed and developed new mappings in Mapping designer and sessions and workflows in Workflow manager and modified existing ones to extract data from SQL Server, Excel, and Flat files and load to Oracle database as per business requirements.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Performed unit testing to validate mappings and populate the database.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Documented the process for further maintenance and production support.

Environment: Informatica Power Center 7.0, Erwin, SQL Server 7.0, Oracle 10g.

Confidential

PL/SQL Developer

Responsibilities:

• Responsibilities included development of various PL/SQL stored Procedures and Functions.
• Wrote various SQL* Loader scripts to load data into oracle database and experience in using SQL scripts to validate the integrity of data.
• Developed various stored procedures, packages, and cursors in PL/SQL.
• Creation of database objects like Tables, Views, Procedures, Functions and Triggers.
• Optimized the queries to improve the performance of the application.
• Created Batch Jobs and UNIX Scripts to automate the process.

Environment: SQL Plus, SQL Developer, SQL Server 2005, Oracle 9i, SQL Loader, Windows NT Server/XP, UNIX.