PROFESSIONAL SUMMARY:

• Overall 7+ years of Software Life Cycle experience in System Analysis, Design, Development, and Implementation, Maintenance, and Production support of Data Warehouse Applications.
• Extensive experience with Informatica Power Center 9.x, 8.x, 7.x IDQ 9.6.1/9.0.1/8.6 , MDM,B2B, and, Teradata, SQL server,oracle databases
• Worked on various domains including Healthcare, Insurance, Finance domains
• Expertise in working with Informatica, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Mappings, Workflows, Sessions, Re - usable Transformations, Shortcuts, Import and Export utilities.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, Teradata, SQL Server and Worked on integrating data from flat files like fixed width, delimited, CSV, HL7 (health level) and EPIC EXT Files
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, Data Vault, Oracle Designer and modeling tools like Erwin and Visio, SCD,Surrogate keys, Normalization/De normalization.
• Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Extensive Knowledge in designing functional and detailed design documents for data warehouse development
• Worked on IDQ tools for data profiling, data enrichment and standardization.
• Experience in development of mappings in IDQ to load the cleansed data into the target table using various IDQ transformations. Experience in data profiling and analyzing the scorecards to design the data model
• Experience in the integration of various data sources such as Oracle, SQL Server, Sybase, Teradata, DB2, XML Files and Flat files.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2008/2012).
• Two B2B Projects - DT/DX (Data Transformation Studio), Data Transformation Accelerator, Data Format Transformation Library, Data Transformation Engine and full integration with Power center
• Extensive hands on experience using Teradata utilities (SQL, BTEQ, Fast Load, Multi Load, Fast Export, TPT), UNIX in developing tools and system applications, as well as B2B Data Transformation,
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Data Transformation Services etc
• Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2) loads.
• .Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle and have a good knowledge in Sybase.
• Knowledge in designing Dimensional models for Data Mart and Staging database.
• Expertise in Data Warehousing, Data Migration, Data Integration using Business Intelligence (BI) tools such as Informatica Power Center, Power Exchange CDC, B2B Data Transformation, Informatica Data Quality.
• Expertise in defining and documenting ETL Process Flow, Job Execution Sequence, Job Scheduling and Alerting Mechanisms using command line utilities.
• Extensive experience in implementing Error Handling, Auditing and Reconciliation and Balancing Mechanisms in ETL process.
• Skilled in developing Test Plans, Creating and Executing Test Cases.
• Worked with Waterfall, Agile for SDLC project lifecycle.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x./8.x/7.x (Admin Console, Repository Manager, Designer, Workflow Manger, Workflow Monitor), Informatica B2B data exchange, IDQ,MDM, Data Validation Option(DVO)

Star Schema and Snow: Flake Modeling, Enterprise Data Vault, FACT and Dimensions Tables, Physical and Logical Data Modeling, ER Studio, Erwin 4.5/4.2/3.5/3. x

DBMS: Oracle 11g/10g/9i, MS SQL Server 2008/2005, Microsoft Access, Teradata, ODBC

Programming Languages: SQL, PL/SQL, Unix Shell scripting

Operating Systems: Windows XP/ 2008/2003/2000 , UNIX

VISIO, TOAD,CONTROL: M, CITRIX, Autosys (Batch Scheduling)

Educational Qualifications:: Master s in Science from University of California, US (2010)

PROFESSIONAL EXPERIENCE:

Informatica consultant/UPMC Sr. Informatica Data warehouse Developer/ B2B Data Exchange specialist

Confidential, Dallas,Tx

Responsibilities:

• Involved in the complete end-to-end flow of SDLC.
• Working closely with business analysts and data analysts to understand and analyze the requirement to come up with robust design and solutions.
• Working on IHAA (Informatica Healthcare Analytics Accelerator).
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like EPIC, Cerner,Medipac and loading into Staging and Enterprise Data Vault
• Worked on extracting data from the heterogeneous source systems like MS SQL Server, Oracle, HL7 Files and loading into Landing Layer and then to Data Warehouse
• Involved in standardization of Data like of changing a reference data set to a new standard.
• Data if validated from third party before providing to the internal transformations should be checked for its accuracy (DQ).
• Filtered XML claims files by using filter conditions on D9 segment and converted back the filtered claims xml files to EDI format using serializer in B2B data transformation.
• Led B2B structured and unstructured transformations that included: resolving end user problems, training on B2B transformations and resolving system failures.
• Created Audit, Control and batch tables to monitor load process on user requests.
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Created profiles and score cards for the users using IDQ.
• Created Technical Specification Documents and Solution Design Documents to outline the implementation plans for the requirements.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Involved in massive data cleansing prior to data staging from flat files.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.6 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
• Implemented slowly changing dimensions Type 2 using ETL Informatica tool.
• Created Informatica components required to operate Data Quality (Power Center required)
• Designed best practices on Process Sequence, Dictionaries, Data Quality Lifecycles, Naming Convention, and Version Control.
• Created Use-Case Documents to explain and outline data behavior.
• Developed scripts for creating tables, views, synonyms and materialized views in the data mart.
• Involved in designing and developing logical and physical data models to best suit the requirements.
• Working with Informatica Developer (IDQ) tool to ensure data quality to the consumers.
• Used Address validator transformation for validating various customers address from various countries by using SOAP interface
• Converted business requirements into highly efficient, reusable and scalable Informatica ETL processes.
• Created mapping documents to outline source-to-target mappings and explain business-driven transformation rules.
• Designed mappings to read data from various relational and file source systems such as SQL Server, flat files and XML files.

Environment: Informatica Power Center 9.6.1, IDQ, B2B, DT/DX T-SQL, PLSQL, TOAD, AIX, Windows NT/XP, XML file sources, ERWIN 4, MS Visio, Remedy.

Confidential, Dallas,Tx

Sr.ETL Developer

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Extracted data from various sources like Oracle, flat files and DB2
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Migrated mappings from Dev to Test and Test to Production repositories.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Utilized dimensional and star-schema modeling to come up with new structures to support drill down.
• Refreshed reports using Scheduler.
• Preparation of UTP (Unit Test Plan) with all required validations and test cases.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in production support.

Environment: Informatica Power Center 9.5, DB2, Windows 2000, Remedy

Confidential

IDQ Developer

Responsibilities:

• Worked as an Expert Designer and developer in Informatica Power Center ETL, IDQ Data Quality Tool and mentored the Team with the development modules.
• Used MDM (Master data Management) to analyze data for decision support system.
• Used Informatica Metadata manager(IMM) to document all the SDLC process as a part of knowledge transfer.
• Worked as an DBA creating schemas, granting permission, allocating space, collecting stats.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Did Application tuning and Disk I/O tuning to enhance the performance of the system.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, Std Deviation in the Aggregator Transformation

Environment: Informatica Data Quality 9.1, Power Center 9.1,MDM, IMM, Autosys, SOAP, Toad, Oracle 10g

Confidential, SFO, CA

Informatica Developer

Responsibilities:

• Designed the ETL processes to migrate the existing ETL process from ODI (Oracle Data Integrator) to Informatica power center 9.1 and to load data from Oracle, Teradata sources, flat files to the Enterprise Data Warehouse.
• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Created source and Target Definitions, Reusable transformations, mapplets and worklets.
• Created Mappings and extensively used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Expression, Router, Joiner, Normalizer, Aggregator and Sequence Generator, Web services Consumer.
• Developed Source to Staging and Staging to Dimension mappings.
• Developed Source to Staging and Staging to Fact mappings
• Developed number of complex Informatica mappings, Mapplets, reusable transformations to implement the business logic and to load the data from DW to Responses feeds engine(RFE).
• Created data quality indicators for the bad source rows/records and assigned different numbers to track down each source.

Environment: Informatica Power Center 8.1, ODI, Erwin, UNIX, Oracle, Teradata, Autosys.