SUMMARY

PROFESSIONAL EXPERIENCE

Confidential

Role: Sr. Informatica ETL Developer

Project Description:

The Confidential develops and manages the Confidential. While the individual licensing boards grant the license to practice medicine, all medical boards in the US accept a passing score on the Confidential as evidence that an applicant demonstrates the core competencies to practice medicine. As a result, healthcare consumers throughout the nation enjoy a high degree of confidence that their doctors have met a common standard. The NBME and the Federation of State Medical Boards co- sponsor the USMLE, and the Educational Commission for Foreign Medical Graduates is the third collaborator in the USMLE program.

Responsibilities:

• 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.
• Interact with BusinessAnalyst to assist him in understanding the Source and Target System.
• Responsible to pull the data from XMLfiles, Flatfiles Fixed width Delimited and COBOL files by using complex transformations like Normalizer, XMLSourceQualifieretc.
• Extracted and transformed data from various sources like Teradataand relational databases Oracle, SQLServer .
• Involved in generating MLOADand TPUMPscripts to load the data into Teradata tables.
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like SourceQualifier, Expression, Lookup Connected and Unconnected , Aggregator, UpdateStrategy, Joiner, Filter, and Sorter transformations.
• Developed complex mappings using transformations such as Aggregator, Connected and UnconnectedLookup, Filter, Joiner, Expression, Filter, Sorter, Router, Normalizer, SourceQualifier and UpdateStrategy.
• Worked extensively to create views using Composite queries and publish them as web link.
• Sourced data using WEBSERVICES transformation.
• Extensively worked on MappingVariables, MappingParameters, WorkflowVariables and SessionParameters.
• Worked on different tasks in Workflows like sessions, eventsraise, eventwait, decisionmail, command, Worklets, assignment, timer and scheduling of the workflow.
• Worked on Power Center Designer tools like SourceAnalyzer, TargetDesigner, MappingDesigner, MappletDesigner and TransformationDeveloper.
• Used Debuggerwithin the Mapping Designer to test the data flow between source and target and to troubleshoot the invalidmappings.
• Designed and developed UNIXShellscripts to report job failurealerts.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential, parallel initial Incremental Load.
• Worked on SQL tools like TOADand SQLDeveloperto run SQLQueries and validate the data.
• Scheduled Informatica Jobs through Autosysscheduling tool.
• Assisted QA team to fix and findsolutions for the productionissues
• Prepared all documents necessary for knowledge transfer such as ETL strategy, ETL development standards, ETL processes, etc.

Environment: Informatica Power Center 9.1, PowerExchange 9.1, Oracle 11g, Teradata, Erwin, UNIX, PL/SQL, Autosys, MS-SQL Server 2008, Toad, MS-Visio, Windows XP, OBIEE 10.1.3.4.1.

Confidential

Role: Data Warehouse/ Business Intelligence Developer

Project Description:

Confidential is a leader in a large, growing market, Aramark proudly serves its blue chip client base through high quality service and innovation to meet their evolving needs. With safety, quality and service excellence as core values that define the company, Aramark is also committed to responsibly addressing issues that matter to our clients, customers, employees, shareholders and communities by focusing on employee advocacy, environmental stewardship, health and wellness, and community involvement.

Responsibilities:

• Participated in the full development life cyclefrom developing business intelligence requirements to QA and production deployment.
• Analyzed, designed and developed Business Intelligence technical solutions leveraging off the shelf technologies such as OBIEE and Informatica.
• 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 spreadsheet 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 11g 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 PowerCenter 9.1/8.6, PowerExchange 9.1/8.6, OBIEE 11g, Oracle 11g, PL/SQL, Autosys, Toad, Windows 7

Confidential

Position: ETL Developer

Project Description:

Confidential is one of the leading service providers for Medicaid and Medicare plans and provides its services in 13 states. Confidential manages and maintains all the healthcare claims in these states. It gets its claims data from all these states and validates them to HIPAA 5010 EDI standards and sends back the accepted records and acknowledgements to those particular states. I have worked as ETL developer in Kansas state healthcare project.

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
• 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

Position: ETL Developer

Project Description:

Confidential Credit Suisse occupies a leading position in the Swiss market. It provides a wide range of banking services for private and corporate clients in Switzerland. In addition, it offers online banking services, Advice and solutions for banks and financial institutions all around the world.

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.
• Designed and developed online data processing from OLTP to OLAP system using CDC Informatica PowerExchange.
• Worked on DataMap, registration, restart token and recovery of real-time Informatica code.
• 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, InformaticaPowerCenter 8.1.1, PLSQL developer, Oracle SQL, PL/SQL and Oracle10g/9i, SQL Server, DB2 8.0, SOA 10g, Sun Solaris, Remedy, Informatica PowerExchange 8.1.

Confidential

Role: Informatica Developer

Project Description:

Confidential CT is a private company categorized under Fire, Marine, and Casualty Insurance. This project aimed at making a data warehousing system of customers for CSD Claims System Department to consolidate their P C Legal data existing in multiple databases across the country. In developing warehouse for CSD, we used Informatica Power Center 8.1 version to implement ETL process in three layers, ODS, Data Warehouse and Data Mart.

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 and 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

Position: Jr. ETL Informatica Developer

Project Description:

In this project we have developed a warehouse called CBS-Fiserv to raise the levels of functionality, efficiency, accuracy, customer satisfaction, etc., to a new standard. With CBS conversion, bank is now able to offer more, and better, products including both personal and business accounts. Using different ad-hoc analysis, Warehouse is supposed to assist in defining strategy for each customer category. Also developed many downstream projects like IAL, CRM and worked on HR Works project.

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 8.1, Linux, Erwin, SQL Server 7.0, Oracle 10g.

Confidential

Position: PL/SQL Developer

Project Description:

Confidential state-owned telecommunications company that is the largest communication service provider in Confidential. The project involved handling of the Oracle database, inserting and updating the information in the database, performing queries for several business requirements and other relevant tasks.

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.
• Running the SQL scripts from TOAD and creating Oracle Objects like tables, Views, Indexes, sequences and Users. SQL coding for problem resolution and performance optimization.
• Analyzed, enhanced and maintained Data Warehouse systems using RDBMS database and Informatica tools.
• Developed various stored procedures, packages, and cursors in PL/SQL.
• Creation of database objects like Tables, Views, Procedures, Functionsand 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.