SUMMARY:

• Over 7+ years of experience in Information Technology including Data Warehouse/Data Mart development usingETL/Informatica Power Center, and Power Exchange.
• Worked on various domains including Healthcare, and Pharmaceutical.
• Experience inETLtools like power center 9.x/8.x/7.x/integration with process server databases like, Oracle, SQL Server, DB2.
• Good understanding of Data Warehousing concepts with emphasis onETLand Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Good Knowledge in working with Informatica B2B Data Transformation to handle the mainframe data, XML and Flat Files.
• Experience in Informatica B2B Data Exchange using Unstructured, Structured Data sets.
• Experience in B2B DX is essentially an envelope on top of Power Center and B2B DT, facilitating the interchange of electronic information between different entities inside or outside an organization firewall.
• Experience with Inbound and Outbound HIPAA transactions 834, 835, 837, 270/271.
• Expertise in testing EDI 834 format for Beneficiary and Enrollment process.
• Extensively worked with the files in HIPAA format and have good knowledge with serializes and parsers.
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Clear Knowledge on OLTP and OLAP Systems, developing database schema (Dimension and Facts), E - R Modeling-Logical and Physical Modeling Concepts.
• Worked in various Heterogeneous Source Systems like Oracle, DB2 UDB, Teradata, MS SQL Server, Flat files and Legacy systems.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good understanding of views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors and Ref Cursors.
• Expertise in creating very detailed design documents and performing Proof of Concepts (POC).
• Extensively created mapplets, common functions, reusable transformations, look-ups for better usability.
• Sound experience in Performance tuning ofETLprocess. Reduced the execution time for huge volumes of data for a company merger projects.
• Extensive experience in Tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk load.
• Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Great Expertise in using Exception Handling strategies to capture errors and referential integrity constraints of records during loading processes to notify the exception records to the source team.
• Highly motivated and goal-oriented individual with a strong background in SDLC Project Management and Resource Planning using AGILE methodologies
• Effectively communicate with business, project manager and team members.
• Strong ability to work within a demanding and aggressive project schedules and environments.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1(Designer, Work flow Manager, Work Flow Monitor, Repository Manager and Informatica server), SSIS(SQL Server Integration Services)

Job Scheduler: Control-M, Crontab, Autosys, Informatica Workflow Scheduler

Data modeling tool: Erwin

Databases: Oracle 11g/10g/9i, MS SQL Server 2005/2000, DB2, Teradata and MS Access 2007

Languages: C, C++, SQL, PL/SQL, UNIX, Shell Programming, XML

Operating Systems: Windows 2000/XP/NT/, HP Unix

Scheduling Tools: CNTRL M, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Sr. ETL /InformaticaDeveloper

Responsibilities:

• Analyzed and systematically documented the process of Inbound and Outbound with HIPAA 834.
• Used Structured and Unstructured Data like PDF files, spreadsheets, Word documents, legacy formats, and print streams option to get normalized data using B2B Data Exchange of Informatica.
• Developed mappings to extract data from various source systems like SQL Server, Flat files, XML and load into Data warehouse.
• Developed strategies for Incremental data extractions as well data migration to load into the Teradata.
• Used Source Analyser and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Medicaid/Medicare records were processed across the Development, designed and Unit tested in UAT.
• Involved in performance and integration testing ofETLjobs and prepared documentation.
• Extracted data from different sources such as Oracle, Fixed width and Delimited Flat files to load into Operational Data Store.
• Extended the functionalities of existingETLprocess of Medicaid for Medicare.
• Extensively worked on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.
• Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
• Informatica DT/DX is required to create the flat files. Apart from that some information need to be entered into the DB2 databases.
• Deployment of HIPAA 5010 Library components like Library parsers, Library Serializers.
• Migrating Informatica Power Center and DT objects between environments.
• Worked extensively by pushing the Xml's to MQ according to their requirement.
• Followed HIPAA implementation guides for preparing the EDI 834 file.
• We processed the ORPHAN records which converts the Pipe delimited file into the EDI 834 format.
• We involved in performs validation to avoid processing of duplicate 834 files received from exchanges via gateway.
• Involved in Effectuation and enrichment process to modify the existing records and Termination records.
• SFTP the files from different environments.
• Wrote PL/SQL stored procedures & triggers, cursors for implementing business rules and transformations.
• Carried out changes into Design of Oracle Schemas for OLAP and OLTP systems.
• Extensively used the concepts ofETLtool to load data from Oracle database and flat files to Oracle database.
• Worked with the team members to identify and resolve various issues relating to Informatica and issues related to the database.
• Involved in the entire SDLC process that includes Implementation, Testing, Deployment and Maintenance.
• Coordinated in daily team meetings, technical code review meetings and interacted with business people for better technical solutions and proposedETLstrategy based on Agile Methodologies.
• Supported 24/7 for the Active renewals and Passive renewals application.

Environment: Informatica Power Center 9.x, Informatica B2B Data Exchange, Informatica Data Transformation Studio, HIPAA, OLAP, Oracle 11g/10g (SQL, PL/SQL), DB2, SQL Server, Windows NT.

Confidential, Franklin Lakes, NJ

ETL /InformaticaDeveloper

Responsibilities:

• Closely worked with Business Analysis team and technical Analysts to build-out and support data warehouse and business intelligence applications using Informatica, Oracle, DB2 and BI tools
• Extensive use of B2B Data Transformation for handling vendor data, where it is in EDI, Unstructured data and Complex structured data (XML Schemas).
• Extensively worked with structured and unstructured data.
• Worked on Informatica PowerCenter tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets, Workflow Manager, Workflow Monitor, Data Analyzer, Metadata Manager and Reusable Transformations.
• Worked on Oracle Warehouse Builder for already existing workflows to get the final source files for use.
• Worked with HIPAA 5010 for reduces risk and provides flexibility and complete bidirectional transaction crosswalk transactions.
• Involved in analysis, requirement gathering, and documenting functional and technical specifications.
• Involved in the preparation of the mapping document for 5010 by identifying the minor changes from 4010.
• Involved in the installation of B2B plug-ins in the machine.
• Designed the inbound mappings to load data from HIPAA 5010 834, 270, 271 and 271U files into Database to healthcare industry standards.
• Created the outbound mappings to generate HIPAA 5010 834, 271 and 270 files from the data in the data bases.
• Upgraded Informatica power center 8.1 to version 8.6 on servers.
• Configure the session so that power center server sends the e-mail when the session fails.
• Extensive use of flat files as sources and targets depending on the inbound and outbound processes.
• Deal with data files with lot of data (almost up to 6 million members in one file).
• Involved in the performance tuning of the maps to reduce the runtime for the big files.
• Extensively worked in the performance tuning of the programs, PL/SQL Procedures and processes.
• Cleansing data using Trillium, RTRIM and LTRIM.
• Development of an automated process for loading the data into the base tables in EDW (forETL) using FastLoad, MultiLoad, utilities of Teradata.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Run the mappings using Tidal 3rd party tool and implemented the concurrent running of the workflow for different files at the same time.
• Fixed the minor issues in the parser and serializers (built in java codes).
• Build XML parser and serializer transformations with the xsd files.
• Worked with production team to resolve issues in Production database of OLAP and OLTP systems.
• Involved in system end to end testing (Unit and System Integration Testing) as part of the SDLC process and performance tuning at the mapping level, session level, source level, and the target level.
• Followed Agile Methodology and participated in daily standup meetings.
• Passed the parameters to work flow from the tool Tidal directly to run the map.

Environment: Informatica Power Center 9.1/8.6, Data Transformation Studio, Clearquest, HIPAA, OLAP, Oracle 10g, SQL Server 2005, Tidal, SQL, T-SQL, PL/SQL.

Confidential, Washington DC

ETL/Informatica Developer

Responsibilities:

• Involved in analysis, design, development, test data preparation, unit and integration testing, Preparation of Test cases and Test Results.
• Coordinating with client, Business andETLteam on development.
• Involved in Up-gradation of HIPAA X12 4010 transactions to HIPAA X12 5010 and ICD-9 to ICD-10.
• Developed Batch jobs using extraction programs using COBOL, JCL, VSAM, Easytrieve, Datasets, FTP etc to Load Informatica tables.
• Designed theETLprocesses using Informatica tools to load data from Flat files to target database.
• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse from SQL Server and DB2.
• ImplementETLProcesses using Informatica tools-Source Analyser, Target Designer, Mapping Designer, Mapplet Designer and workflow Manager.
• Performed data manipulations using various Informatica Transformations like source qualifier, Sequence Gen, Sorter, Joiner, Expressions, Lookup, Aggregate, Filter, Router, Update, Strategy etc.
• Created Reusable Transformations and Mapplets and used them in various mappings to reduce redundant work.
• Worked on creating HIPAA files from SQL Server database.
• Data base development using mainly UDB, SQL server, and oracle and mainframe database. UNIX shell scripting, SQL and PL/SQL coding.
• Involved in Archival of Claims and Membership data which is older than 6 years.
• Created sessions and workflows for designed mappings.
• Used workflow manager for creating, validating, Testing and running sequential and concurrent batches and sessions and scheduled them to run at specified time with required frequency.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Involved in production support and done knowledge transfer to team members.
• Actively involved in Daily check in meetings to discuss on the production issues and resolved.
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
• Authored and executed Test cases for Claims and Customer Service Workflow by manually.
• UAT testing for HIPAA 4010 and 5010 projects including legacy testing and HIPAA requirements and compliance mandates.
• Involved in data analysis, data mining, cleansing and mapping documents, technical documentation, test cases and SDLCs and business analysis methodologies.
• Involved in designing theETLtesting strategies for functional, integration and system testing for Data warehouse implementation.
• Working in Agile methodologies and participating daily scrum meetings for providing status reports to team regarding project status, task and issues.

Environment: Informatica Power Center 8.1 (Source Analyzer, Data Warehousing Designer, Debugger, Mapping Designer, Mapplet, Transformations), HIPAA, OLAP, Oracle 9i, Toad, MS SQL Server 2005.

Confidential, Minneapolis, MN

ETL/Informatica Developer

Responsibilities:

• Interacted with business users in the analysis, development and requirement gathering phase.
• Extracted data from various sources like Flat files, relational tables and loading into staging tables and then into data mart.
• Worked on Informatica Power Center -Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer, Mapplets and TransformationDeveloperto map the sources to the target.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data. Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• In the first phase getting the data from OLTP and pulling into Operational Data Source (ODS or Staging Area), in the second phase pulling the data from ODS to Dimensional Modeling according to the user requirement. From the first and second phase, reports will be build using OLAP tools.
• Used various transformations like connected and unconnected lookups, update strategy, filter, SQL, joiner and aggregator transformations to implement complex business logic.
• Created and configured workflows and reusable sessions to load data from external sources into Oracle data warehouse using Informatica Workflow Manager.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement theETLjobs using Informatica.
• Used Autosys scheduling tool for scheduling UNIX shell script & Informatica jobs.
• Written SQL queries, stored procedures on different databases (Oracle, IBM DB2,) for SQL overrides, Extractions, Updates
• Created Stored Procedures and SSIS (DTS) packages for theETLprocess.
• Performance monitoring and tuning of Informatica mappings.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts and Expected Results.
• Modified existing mappings for enhancements of new business requirements.
• Used debugger to test the mappings and fixed the bugs.

Environment: Informatica Power Center 8.0/7.x, Workflow Manager, Workflow Monitor, PL/SQL, OLAP, Oracle 9i, Erwin, Autosys, UNIX.

Confidential

Jr. Informatica Developer

Responsibilities:

• Extracted data from various source systems and loading into data warehouse.
• Analyzed, identified, fixed bad data and imported data fromSalesforce - CRM to Oracle.
• Used Informatica PowerCenter to create mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, and router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing.
• Created Stored Procedures and SSIS (DTS) packages for theETLprocess.
• Developed UNIX shell scripts to get data from external systems flat files to EDW stage area, and to schedule various workflows to load the data into target system.
• Familiar with Data Warehouse Architecture, design methodologies and Best practices.
• Experience with server log files, editing UNIX scripts, FTP files and checking space on server.
• Implemented performance tuning techniques on Targets, Sources, Mappings and Sessions.
• Scheduled Informatica sessions and workflows using Informatica Scheduler.
• Documented Informatica mappings in Excel spread sheet.
• Created and Configured Workflows and Sessions to transport the data to target warehouse.
• Created Users, user groups, database connections and managed user privileges using supervisor.
• Responsible for writing unit test cases and performing the unit test.
• Documented theETLprocess and also issues encountered during UAT and production support for ease of future maintenance.

Environment: Informatica Power center 7.1, Oracle 9i, SQL, PL/SQL, UNIX.