SUMMARY

• Over 8 years of experience in Information Technology with a strong background in Database development and Data warehousing and ETL process using Informatica Power Center 9.x/8.x/ 7.1.3/7.1.1/6.2. Repository Manager, Repository Server, Workflow Manager & Workflow Monitor..
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Knowledge ofIDQ9.6..1 standards, guidelines and best practices
• Worked withInformaticaData Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion,exception handling, and reporting and monitoring capabilities of IDQ 8.6.1
• Strong understanding of OLAP and OLTP Concepts.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Proficient in Oracle Tools and Utilities such as TOAD and SQL*Loader.
• Extensive knowledge working with Metadata.
• WritingTeradata sql queriesto join or any modifications in the table
• Developed complex mapping using Informatica Power Center Cloud. UsedTeradata utilities fastload, multiload, tpumpto load data
• WritingTeradata BTEQ scriptsto implement the business logic
• Creation of customized Mload scripts on UNIX platform for Teradataloads
• Experience with AGILE Methodologies.
• Experienced in the use of agile approaches, including Extreme Programming, Test - Driven Development and Scrum.
• Experience in various stages of System Development Life Cycle(SDLC) and its approaches likeAgile,and Prototyping Model
• Experience in SQL performance tuning.
• Experience in maintaining Data Concurrency, Replication of data.
• Good knowledge on BI tools like SQLBI and OBI.
• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle database.
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool.
• Design, Architect BizTalk EDI Interfaces and HIPAA EDI Frame-work components
• Implemented Encryption and Secure Transfer of 834 EDI Enrollment Transactions using BizTalk Adapter
• Experience in using SQL developer, SQL*Plus, Procedures/Functions and Performance tuning..
• Expertise in RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, Cursors, Stored Procedures, Functions and Triggers.
• Experience in working with Perl Scripts for handling data coming in Flat files.
• Experience working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Strong with relational database design concepts.
• Expertise in design and development of the three layers(Physical/Business Model and Mapping/ Presentation)ofan OBIEE Metadata Repository(.rpd) using Oracle
• Extracted data from various heterogeneous sources like OracleandSAP.
• Experienced in configuring and set up ofOBIEE Security using LDAP and External Database Tablesand configuring object level and database level security.
• Expertise in Building Executive Dashboards using Dashboard Manager for Siebel Analytics Web / Oracle Presentation Services for Siebel Analytics / OBIEE.
• Performed data validation by Unit testing, integration testing and System Testing.
• Extensive experience in managing teams/On Shore-Off Shore Coordination/Requirement Analysis/Code reviews/Implementing Standards.
• Good experience with Informatica Performance Tuning.
• Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, slowly changing Dimensions(SCD) using Erwin.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs..
• Experience in Informatica PowerCenter and implementation experience in B2B Data Transformation (DT) and B2B Data Exchange (DX)
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Able to work independently and collaborate proactively & cross functionally within a team.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.5/9.1, 8.6.1/8.5/8.1.1, Power Exchange 9.6/9.5/9.1/8.6, Informatica IDQ.

Databases: Oracle 12g/11g/10g, MS SQL Server 2008/2012, MS Access, DB2, Teradata 14/13/12/V2R6, V2R5, Sybase, Greenplum

Operating Systems: UNIX, Linux, Windows 2003/2000/NT, Windows 7/8, AIX, Sun Solaris

Languages: C, C++, SQL, PL/SQL, HTML, PHP, JAVA, UNIX Scripting

Reporting Tools: Business Objects XIR2, SAP BI 7.0, OBIEE 12g/11g

Other tools: Toad, Harvest, SCM, Putty, Tidal, Autosys, ESP, Informatica MDM Hub Console, Informatica Hierarchy Manager (HM).

PROFESSIONAL EXPERIENCE

Confidential, CA

ETL/Informatica lead/Production Support

Environment: Informatica Power Center 9.6.1, Oracle 11g, Linux, Autosys, Toad, Greenplum, Wherescape Red, Powerexchange.

Responsibilities:

• Involved in client meetings on daily basis for understanding and analyzing the business requirements.
• Coordinating with client and offshore to complete work on time.
• Regular touch base with infa admins, Gp admins, autosys team
• Attending weekly meetings with UDW L3 team, EDH L3 team and with offshore.
• Attending KT sessions for new deployments to prod
• Working on Queries raised by Offshore and helping them to solve the issues to maintain smooth execution of batch process
• Working on creating new approaches for enhancing the regular process
• Attending adhoc meetings
• Responding to adhoc queries raised by upstream/downstream/application teams.
• Helping offshore team in testing code changes and reviewing them
• Deploying the changes tested to prod by raising CM.
• Preparing the technical documents (like design documents, HLD’s, LLD’s) from business requirement documents.
• Prepare test strategies and execution plan. Monitoring progress of work.
• Extensively developed informatica mappings, mapplets and workflows.
• Used informatica Workflow manager to develop, schedule sessions and send pre and post session emails to communicate success or failure of session execution.
• Extensively used Greenplum SQL
• Maintenance existing GL application.

Confidential, LA

ETL/Informatica lead

Environment: Informatica Power Center 9.6.1, Oracle 11g, Linux, Autosys, Toad, Greenplum

Responsibilities:

• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings.
• Extracted the data from various data source systems into the Landing Zone area by creating the Informatica mappings using the Teradata fast Loader Connections.
• Designed Mappings using B2B Data Transformation Studio.
• Good experience with IDQ analyst tool and Developer tool.
• Good experience in Glossary and Rule specifications.
• Good experience in creating connections in IDQ tool like standardizer, Labeller, Match and Merge.
• Good experience in creating mapplets for Powercenter in IDQ tool.
• Configured Address doctor content on both PC and IDQ servers and helped users in building scenarios
• Extensively used Informatica Client tools - Power Center Designer Cloud, Work flow Manager, Work flow Monitor and Repository Manager
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Experience in converting SAS scripts to Informatica.
• Worked on utilities like FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.
• Developed complex mapping using Informatica Power Center Cloud.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Responsible for Configuration and administration of Meta data Manager.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA).v
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, XML,XSD’s,Flat Files, Teradata.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Confidential, CA

ETL/Informatica Developer

Environment: Informatica Power center 9.6.1/9.5/8.6.1, Oracle 12/11g, SQL server 2008, LINUX, LSF (Job scheduling), UNIX shell scripting, SAS Enterprise guide and MS Visual studio (TFS) for version control, IDQ, DIH, Toad, RDBMS.

Responsibilities:

• Expertise in UNIX shell scripting, FTP, SFTP and file management in various UNIX environments.
• Used Informatica Power Center 9.5 for Extraction, Transformation and Loading data from heterogeneous source systems into the target data base.
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum
• Extensive experience with Healthcare, Energy and Media domains.
• Experience with the healthcare data inHIPPA ANSI X12, 4010, 5010formats including NDC, DRG, CPT, NCPDP, NSF code,ICD 10,ICD 9, 997,837,834,835,277,271,270
• Extensive knowledge on theInboundandOutbound HIPAA transaction setswith both 4010A and 5010A HIPAA versions.
• Expertise in working with direct submitters, clearing houses and providers in regards to all the issues with EDI setup, claim submissions, eligibility transactions and ERA’s.
• Researched the existing client processes and guided the Vendors in aligning theHIPAA complianceoutput with the client systems.
• Worked on Claims database for claims processing.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• WroteTeradata Macrosand used various Teradataanalytic functions.
• Involved in migration projects tomigrate datafrom data warehouses on Oracle/DB2 and migrated those toTeradata
• Worked on patient ally applications for claim processing..
• Testing web services API publication and subscription
• Highly motivated and goal-oriented individual with a strong background inSDLC ProjectManagement and Resource Planning using AGILE methodologies.
• Experience working with Business users and architects to understand the requirements and to pace up the process in meeting the milestone..
• WroteTeradata Macrosand used various Teradataanalytic functions.
• Involved in migration projects tomigrate datafrom data warehouses on Oracle/DB2 and migrated those toTeradata.
• Performance tuned and optimized various complex SQL queries.
• Created Pre/Post Session and SQL commands in sessions and mappings on the target instance.
• Responsible for Performance tuning at various levels during the development.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Used stored procedures to create a standard Time dimension, drop and create indexes before and after loading data into the targets for better performance.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Responsible for migrating the workflows from development to production environment.
• Worked using Parameter Files, Mapping Variables, and Mapping Parameters for Incremental loading.
• Managed post production issues and delivered all assignments/projects within specified time lines.

Confidential, Richmond VA

Informatica Developer

Responsibilities:

• Gathered requirements from the end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Involved in the Data Warehouse Data modeling based on the client requirement.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle.
• Responsible for creating system design and detail design documents based on the requirement document provided by the business users.
• Provides strategic thinking, leadership pertaining to new ways of leveraging information to improve business processes.
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
• Worked with Stored Procedure Transformation for time zone conversions.
• Created UNIX scripts to automate the activities like start, stop, and abort the Informatica workflows by using PMCMD command in it.
• Provided production support including error handling and validation of mappings.
• Addressed and track requests for system enhancements, improvements from end users/customer and also resolved production issues.
• Extensively used Debugger Process to modify data and applying Break Points while Session is running.
• Used various Informatica Error handling techniques to debug failed session.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.

Confidential

Application ETL Developer

Responsibilities:

• Responsible for design and development of Sales Data Warehouse.
• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Extracted data from heterogeneous sources like Oracle, SQL Server
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Conducted a series of discussions with team members to convert Business rules into Informatica mappings.
• Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
• Worked with SAP and Oracle sources to process the data.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Implemented pipeline partitioning concepts like Round-Robin, Key-Range and Pass Through techniques in mapping transformations.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Worked on the data masking activities for cloning the GDW for several buyers

Confidential

ETL Developer

Environment: Informatica PowerCenter8.1, SQL server 2005, DB2, PL/SQL, Toad, Business Objects 6.0, Windows NT, UNIX Shell Scripts.

Responsibilities:

• Interacted with Business Analysts for Requirement gathering, understanding the Requirements, Explanation of technical probabilities and Application flow.
• Developed ETL mappings, transformations using Informatica Power Center 8.6.1
• Extracted data from flat files, DB2 and loaded the data into Oracle staging using Informatica Power Center.
• Created various transformations such as Union, Aggregator, Lookup, Update Strategy, Joiner, Filter and Router Transformations.
• Involved in Performance tuning. Identified and eliminated bottlenecks (source, target, and mapping).
• Designed various tasks using Informatica workflow manager like session, command, email, event raise, event wait and so on.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the data load processes to target.
• Developed Mappings that extract data form ODS to Data mart and Monitored the Daily, Weekly and Monthly Loads.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database