SUMMARY:

• 9 years of IT experience in development of various projects using Data Warehousing tools like Informatica, Data Modeling Tools like Erwin and Databases like Oracle, MS SQL Server,DB2. 2 Years of IT experience in QA Life Cycle, which includes Designing, Developing and Execution of the entire QA Process and Documentation of Test Plans, Test Cases, Test Procedures and Test Scripts for testing Database, GUI and Client/Server applications.
• Extensive experience in Integrated Informatica environment which comprises of Power Center, IDQ, Metadata Manager, Analyst (IDD), B2B Dx and B2B DT and Informatica Cloud.
• Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Support, Testing and Documentation.
• Data Warehouse experience using Informatica Power Center (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, and Transformation Designer) as ETL tool on Oracle, SQL server Databases.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACTs and Dimensions tables.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Experience in integration of data sources like Oracle, DB2, COBOL, SQL Server, XML, CSV and Flat Files.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions.
• Knowledge of Data warehousing ETL and OLAP reporting tools, methodologies, 3NF & Dimensional modeling.
• Extensive experience in ETL processes in extracting data from Operational and Legacy Systems to Data Warehouse using Informatica.
• Created Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2, and Type 3) mappings.
• Experience in using Informtica DQ (IDQ) tool for creating Profiles and Data Quality Rules and Reference tables.
• Knowledge in IDQ 9.3 standards, guidelines, best practices, Scorecards.
• Experience in Data Profiling with Informatica Data Quality.
• Experience in creating and configuring custom models and using custom metadata configurator in Informatica Metadata Manager.
• Experience in debugging mappings in both Powercenter and Developer tool, by analyzing the data flow, evaluating transformations and sessions.
• Extensive development, support and maintenance experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data warehousing and Business Intelligence.
• Experience in Modeling Transactional Databases and Data Warehouses.
• Experience in Data Architecture and Data modeling in Dimension Data Modeling, Erwin Modeling (CA Erwin 4.5/4.0/3.5.5/3.5.2), Star Schema Modeling, Snowflake modeling, FACT and Dimensions tables, Physical and logical data modeling, Oracle Designer.
• Knowledge in using Teradata Database.
• Experience in Autosys Job scheduling.
• Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6,9.1,8.6,7.3, IDQ 9.6.1, Informtica Analyst (IDD) 9.6.1, Informatica MetaData Manager 9.6.1, Informatica B2B Data Transformation

DBMS: Oracle 11g; Oracle 9i; Oracle 8, SQL Server 2005, 2012

BI Tools: Cognos, QlickView, JasperSoft

Languages/ Scripting: PL/ SQL, TOAD, UNIX, LINUX, PowerShell

Programming Languages: Visual Basic 6.0, Java

Utilities: MS Word and MS Excel

Project Design Tools: Visual Source Safe, MS Visio, MS PowerPoint and MS Project

Operating Systems: Windows 2000 Server, Windows NT, Windows XP, Windows 95, 2012 HP - UX (HP UNIX), LINUX

Version Control Tools: VSS, Perforce, Documentum, Sharepoint

SFTP Client and SSH Client: WinSCP, PuTTY

Others: CA Erwin 4.5/4.0, Amazon Web Services

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr. Informatica developer

Responsibilities:

• Re-designed and modified some of the old mappings to improve the performance.
• Modified certain mappings from SCD Type2 to SCD Type1 as per the new requirements.
• Developed UNIX Shell scripts for calling the Informatica mappings and running the tasks on a daily basis.
• Created & automated UNIX scripts to run sessions on desired date & time for imports.
• Responsible to monitor workflows daily and fix if there is any failure.
• Migrated mappings from development to testing and then to Production environments.
• Developed shell scripts for scheduling the sessions in Informatica.

Environment: Informatica Power Center 9.6.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), TOAD 12.x, Oracle 12g, SQL Server 2016, Flat files, LINUX, Windows XP, WinSCP 4.9.1.

Confidential

Sr. Informatica developer

Responsibilities:

• Collaborated with Application/System owner teams (Customer and other IT teams) and other Stakeholders to accurately define the current data flows.
• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 9.6.1 to extract the data from multiple source systems such as Salesforce, flat files, and databases like Oracle 10g, SQL Server 7.2 to the Staging Data base and then to the Data Marts.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Salesforce Lookup, Router, Rank, Sorter, Transaction Control, Filter, Expression, Aggregator, Joiner, Sequence Generator, Union, Update Strategy, SQL Transformation, Stored Procedure, UDT(Unstructured Data Transformation) and more.
• Created reusable components like mapplets, worklets.
• Extensively worked with Slowly Changing Dimension (SCD) Type-I, Type-II and Type-IIIdimensions and data warehousingChange Data Capture (CDC).
• Used Informatica Data Transformation Studio to transform unstructured to structured forms.
• Used Parser component in Data Transformation Studio for conversion of PDF data files to XML files and then used Unstructured Data Transformation in PowerCenter to load the data into DB tables.
• Involved in fixing the data parsing issues while processing the PDFs.
• Involved in maintaining the processing of XML files using Informatica B2B Dx and Informatica PowerCenter.
• Developed mapplets, mappings, workflows and applications using Informatica IDQ to validate Data Quality Rules set in Informatica MetaData Manager.
• Developed Human Task objects to populate the Exception Tasks in Informatica Analyst tool.
• Involved in fixing the issues of exception tasks population, Human Tasks in the Informatica Analyst tool.
• Experience in deploying the Applications created/updated in IDQ to the Data Integration Service (DIS).
• Configure the current data flows / lineage in theInformaticaMetadata Manager using available connectors or as custom resources
• Experience in creating custom models and Custom resources in Informatica Meta Data Manager.
• Experience in associating custom Objects with the custom models created within Informatica Metadata Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Developed and maintained Database Views and procedures in SQL Server 2012 which are used in Jaspersoft (Business Intelligence Tool).
• Performed Unit and Integration Testing.
• Created the Deployment Plan and Involved in code migration from Dev to UAT and from UAT to Production environments.
• Reviewed the technical design specification documents and provided feedback for Informatica PWC and IDQ mappings, mapplets, and sessions.
• Participated in providing the project estimates of the development team efforts.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.

Environment: Informatica Power Center 9.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task developer, Worklet Designer), Informatica Data Quality (IDQ), Informatica MetaData Manager, Informatica Data Transformation (DT) Studio, Informatica B2B, Informatica Analyst Tool, SQL Server 2012, JasperSoft, Amazon Web Services (AWS), Flat files, XML Files, SQL/PLSQL, Windows XP, WinSCP 4.9.1

Confidential, Waukegan, IL

Sr. Systems Analyst (Informatica developer)

Responsibilities:

• Converted business requirements into technical documents and created Source to Target mappings as needed.
• Extracted data from sources like Oracle, XML files, and Flat files.
• Worked with Power Center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Extensively used Informatica transformations like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, XML, Normalizer, Sorter etc., and related transformation properties.
• Extensively used SCD’s to handle the Incremental Loading of Dimension and Fact tables.
• Worked on Performance Tuning to optimize the Session performance by utilizing Push down optimization, Index Cache, Data Cache, incremental aggregation, Target load plan, constraint base loading and partitioning.
• Worked on Debugging and Troubleshooting and utilized Informatica debugger.
• Developed UNIX shell scripts to automate manual job runs.
• Modified existing shell script to suite the existing business logic and developed the utility script to archive, move and copy files and also to automate the batch jobs.
• Worked with DBA and infrastructure team to implement the DDLs, refresh data, create DB links, setup environment and delete the log files from the UNIX boxes.
• Created and scheduled Data Synchronization tasks to separate Dev Jobs, Test Jobs, and Production jobs.
• Created different views for Activity Logs such as Failed Tasks, Warning Tasks, and Successful Tasks.
• Extensively used both Connected and Unconnected Lookup Transformations.
• Responsible in writing SQL queries for Unit Test scenarios.
• Helped the QA team in developing their protocols for validation activities.
• Involved / Engaged in Tier 1 Production Support.
• Automated the Daily Job runs using AutoSys tool.
• Responsible to provide the code migration plan/scripts to the System Admins.

Environment: Informatica Power Center 9.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task developer, Worklet Designer), TOAD 11.0, QlikView, Erwin 4.2, Oracle 11i, SQL Server, Flat files, XML Files, SQL/PLSQL, LINUX, Windows XP, WinSCP 4.9.1, AutoSys, PTC Integrity tool.

Confidential, Temecula, CA

IT Analyst / Systems Analyst

Responsibilities:

• Extracted data from various heterogeneous sources like Oracle, SQL Server, MS Access and Flat files.
• Worked with Power Center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Extensively used Informatica transformations like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc., and all transformation properties.
• Hands-on experience with Java transformations and integrating Informatica with Java.
• Extensively used both connected and unconnected Lookup transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Worked with Session logs and Work flow logs for Error handling and troubleshooting in development environment.
• Used Debugger wizard to troubleshoot data and error conditions.
• Involved in designing and implementing Change Data Capture techniques like Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2, and Type3).
• Worked extensively with session parameters, mapping parameters, mapping variables and parameter files for incremental loading.
• Worked with workflow System variables like SYSDATE and WORKFLOWSTARTTIME.
• Used Various Data Cleansing and Data Conversion Functions in various transformations.
• Involved in data quality operations using IDQ (Informatica Analyst and Developer tool).
• Complex quality rule and index design, development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception, notification and reporting with ETL and Real-Time consideration.
• Worked with Shortcuts across shared and non-shared folders.
• Created shortcuts for source and target and also created Reusable transformations in Shared folder.
• Developed PL/SQL procedures, functions, and packages.
• Developed materialized views for aggregate data information.
• Worked on SQL tuning, and also used Explain plan.
• Responsible in writing UNIX shell scripting as needed.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Involved in code migration activities using Perforce.

Environment: Informatica Power Center 9.1/8.6 (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task developer, Worklet Designer), IDQ 8.6, TOAD 11.0, 11.5, Erwin 4.2, Oracle 11i, 10g, SQL Server, Flat files, SQL/PLSQL, Java/J2EE, UNIX, Windows XP, Perforce.

Clinicals DW

Clinical Trial System

Responsibilities:

• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Requirement analysis in support of Data Warehousing efforts.
• Involved in creation of Logical and Physical models for Warehouses using Erwin.
• Developed overall data transformation and extract design and strategy.
• Worked on Power Mart Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Creation of Transformations like Sequence Generator, Lookup, Joiner, Update strategy and Source Qualifier and Java transformations in Informatica Designer.
• Created Complex mappings using Unconnected Lookup, Aggregator and Router transformations for populating target table in efficient manner.
• Created Mapplets and used them in different mappings for maintaining the standards.
• Created events and tasks in the Workflows using Workflow Manager.
• Developed Informatica mappings and also tuned them for better performance.
• Created PL/SQL packages and procedures to build business rules to load data.
• Transformed the existing PL/SQL scripts into stored procedures to be used by Informatica Mappings with the help of Stored Procedure Transformations.
• Designed strategy and coded procedures to extract daily incremental data.
• Created UNIX shell scripting for file handing and archival and also to run the workflows for Informatica mappings.
• Involved in Performance Tuning of Informatica mappings, SQL Query, views etc.
• Involved in developing the technical documents from functional specifications.
• Provided assistance and support to MIS team in understanding of data and designing Cognos reports.

Environment: Informatica Power Center 8.6, Oracle 9i/10g, PL/SQL, TOAD, UNIX & Autosys

Confidential, Temecula, CA

IT Validation Analyst

Responsibilities:

• Wrote new Test Plans and enhanced existing Test Plans to incorporate and capture new business rules or specifications.
• Reviewed and analyzed system requirements, to understand the customizations design and implement Testing strategies.
• Involved in writing and execution of Test cases.
• Reviewed the Test cases, Procedures to Check their Compliance with 21 CFR Part 11 rules set by FDA
• Involved in preparing the Initial Test Plan Suite for Maintaining the Test Cases in Test Manager.
• Used Test Manager for Writing, Developing And Maintaining the Test Cases.
• Responsible for preparation of TestCase Development Matrix.
• Identified candidates for automation (Regression set).
• Created the Global Object Repository for the Application before starting the recording and recorded the Test scripts using both Normal and Low Level Recording.
• Involved in Test team meetings to define the Automation Framework ( to maintain consistency between each script developed by each QA Analyst- From How to record a Script to Where to Store the Results for easy traceability).
• Reviewed and make comments on the final Automation Frame work documents.
• Involved in recording the Test scripts, executing the scripts, modifying the scripts using QUICK TEST PRO (QTP 8.2) Automation test tool.
• Extensively used Parameterization, Synchronization Concepts.
• Involved in the Programming of QTP to enhance the Test scripts for Customization
• nserted Checkpoints and Output values as Necessary.
• Used the Function Libraries while developing the scripts for common actions of the application.
• Implemented the Batch run in QTP (by kicking off the scripts overnight and Review/ analyze the results next day morning).
• Involved in the conversion of all the automation scripts from 8.2 to 9.x Environment
• Used Documentum for Document Control.
• Updated regression scripts as necessary for functionality changes on various Releases
• Extensively used SQL scripts and queries for data verification at the backend.
• Interacted with the developers and the users to analyze functional/ technical specifications.
• Performed System, Regression, Integration White Box and Black box testing at various phases of the development and test cycles.
• Performed execution of test scripts and exploratory testing based on the product and business knowledge.
• Identify and setup test data in source systems and incorporate this data in repeatable test scenarios.
• Tested the Application on various baselined machines.
• Tested the application by executing the regression test cases for software upgrades.
• Actively participated in design and code walk through, peer reviews and status meetings.
• Heavily used Action Remedy System for bug tracking, reporting and logging of defects and follow up until resolution.
• Involved in testing of emergency release fixes.

Environment: Windows 2000, Windows XP, Java, asp.net, xml, Oracle9i, Quick Test Pro, Remedy Defect