SUMMARY:

• Over 12 Years of IT extensive experience in Informatica, SAS Technology under UNIX, Windows environments.
• Over 8 years in analysis, design, development, of software applications in Data warehousing solutions using Informatica, building Data Marts and data warehouse.
• Experience in administration of applications and Informatica tool.
• Currently Working on ETL tool Informatica Power Center Vs 10
• Solid experience in Informatica Power Center (versions 8.5/ 9.1/9.5/9.6/10.2 ) including Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console.
• Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Have experience with weblogic server monitoring for any stuck thread issues and scheduled maintenance.
• Optimizing the SQL to improve performance.
• Optimizing Informatica Mappings and Sessions to improve the performance.
• Experience in performance tuning of sources, transformations, targets, mappings, worklets, workflows, and sessions.
• Involved in the estimation for time it takes to complete the tasks and distributing the work to the team members and assigning the peer reviewers for the developed work.
• Proven Experience in complete life cycle of Design, Development, Documentation and Maintenance of the Datamarts and Data warehouse.
• Strong knowledge in Dimensional Data Modeling Technique, E - R modeling, Multi-Dimensional Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables), and handling SCD’s.
• Strong experience with UNIX Shell Scripting, SQL, PL/SQL Coding.
• Having hands-on sales, pharma and Health Care domain knowledge.
• Have also worked in an Onsite - Offshore model have carried out the different phases of the projects effectively by excellent co-ordination activities.
• Excellent problem-solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Knowledge in Informatica Data Quality (IDQ).
• Experience in SAS/BASE, SAS/MACROS, SAS/STAT, SAS/ANALYST, SAS/GRAPH, SAS/SQL, Oracle SQL /PLSQL, MS SQL.
• Experience in Clinical Data Analysis, Producing Reports, Listings, Tables, Summaries and Graphs from clinical trial data of all the four phases of Clinical Trials.
• Modification of existing SAS programs and creation of new programs using SAS Macros to improve ease and speed of modification as well as consistency of results.
• Experienced in producing RTF, HTML and PDF formatted files using SAS /ODS to produce adhoc reports for Analysis Reports. Cleaning the dataset’s by using Base SAS Procedures and Data steps.

TECHNICAL SKILLS:

ETL and data analysis Tools: Informatica PowerCenter 8.1/8.5/9.5/9.6/10.2 and SAS

Data Quality Tools: Informatica Data Quality 9.6.1

OLAP Tools: Basics in Tableau

Databases: MS Access, Oracle8i/9i/10g/12c, Db2 and PostgreSQL

Scripting Languages: TOAD, SQL*PLUS, Unix Shell scripts, IBM Connect Direct

Scheduling Tools: Autosys (JIL)

Data Modeling Tool: Dimensional Data Modeling, Star/Snow flake Schema Modeling (2NF, 3NF), Erwin 8/7

Supporting Tools: Toad, PL/SQL Developer, SQL Developer, SVN, JIRA, Service Now and VSS

Web Tools: HTML, XML

MS: Office.

Operating Systems: Sun Solaris 8.x/9.x, IBM AIX, Unix, Linux, Windows XP/2000/NT

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Lead ETL / Informatica Developer

Responsibilities:

• Creating prototypes/ETL specifications based on requirements and analysis of data.
• Designing and developing ETL mappings and workflows/sessions using Informatica Power Center 10.2 to load data to Stage, ods and datamart tables.
• Worked on developing ETL mappings to process data into DW while identfying the change Confidential source side and pulling the delta data after the previous run.
• Worked on Informatica Developer 10.2 for designing a POC on data integration with Hadoop/Hive systems.
• Worked on Oracle Sql to generate data reports for business users.
• Worked on design, develop, test and implement Unix process to transfer files between the application servers and external system.
• Worked on designing and developing the scripts using IBM Connect Direct (NDM protocol) to transfer files securely between various systems that connect to Wells Fargo Auto.
• Worked on writing unix scripts to automate process and archival of consumed files.
• Worked on migrating the Informatica objects from Development to other environments
• Implemented unit tests and initial QA tests with test data.
• Worked with system admins during all maintenance activities to restart informatica services and restart informatica jobs and servers as part of oncall activity.
• Worked on resolving the informatica workflow failures by analyzing the errors and providing recommendations for the developers.
• Created change controls and coordinates approvals for implementation.
• Work with source system owners to resolve source data issues and refine transformation rules and support all on-call production duties

Environment: Informatica Power Center 10.2, Informatica Developer 10.2, Oracle 12c, IBM Connect Direct, Unix, Informatica DVO, Autosys

Confidential, TX

Lead/Sr. Informatica Developer

Responsibilities:

• Understanding the requirements for the compliance and fraud data analysis for loading the data related to suspicious activity reports from CRM.
• Designed the Mapping Technical Specifications on the basis of Functional Requirements.
• Created ETL mappings using Informatica Power Center to load data into Stage, ODS and datawarehouse tables.
• Worked on Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems
• Extensively worked on Informatica client tools like Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Created Tasks, Workflows, worklets to move the data Confidential specific intervals on demand using Workflow Manager and Workflow Monitor.
• Created complex mappings using Aggregator, Expression, Joiner, XML transformations, Union Transformation, SQL Transformation, complex lookups, Stored Procedures, Update Strategy and others.
• Used Informatica as a Data Cleansing tool to correct the data before loading into the staging area.
• Developed scenarios for Unit, System Integration testing to ensure that all the components work correctly when integrated.
• Developed UNIX shell scripts to manipulate the data.
• Solving day-to-day problems, giving support to the Business Users.
• Working closely with Business QA team during the testing phase and fixed bugs that were reported.
• Working with offshore team on a daily basis to help them understand the requirements and development.

Environment: Informatica Power Center 9.6.1, CRM, Oracle 11g, SQL and UNIX

Confidential, Bothell, WA

Systems/Support Analyst

Responsibilities:

• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
• Providing support 24/7 whenever required to guide team members for successful resolution of the issue .
• Deploying ETL components using Informatica Power center Repository, Workflow manager and workflow designer
• Monitoring weblogic servers as to avoid any issues, which leads to application outage if any of the servers was stuck due to stuck threads or any other issue.
• Responsible to make sure proper documentation is prepared for all the processes/jobs and stored in a share point. Maintaining job aids for any failures resolutions
• Deploying java applications using weblogic server.
• Involved in writing UNIX Shell scripts to run informatica workflows.
• Writing scripts for providing the Adhoc reports for the business requests
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
• Monitored transformation processes using Informatica Workflow monitor.
• Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables.
• Prepared test scripts and Unit test the mappings and checked for data validation and data integration.
• Responsible for raising the Migration requests and cross checking the migrated code in Production with read only access to confirm the successful migration of all objects.

Environment: Informatica Power Center 9.1/9.6.1, Oracle 10g, SQL and UNIX.

Confidential, Cary, NC

Informatica Developer

Responsibilities:

• Created mappings for populating the data into the dimension, facts, and lookup and history tables from sources systems.
• Deployed Informatica Objects from TCA to TCB and TCC.
• Implemented change data capture (CDC) logic for some of the dimensions using informatica power center.
• Monitoring, Tuning and Troubleshooting the Databases.
• Extensively worked in the performance tuning of programs, ETL procedures and processes. Error checking and testing of the ETL procedures and programs using Informatica session log.
• Data migration from one environment to another environment using ETL Informatica tool.
• Created mappings to implement change data capture (CDC) logic for some of the dimensions using informatica power center.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines Sequence generator etc transformations in the mappings.
• Worked extensively on Oracle database 10g and flat files as data sources.
• Developed and fine-tuned SQL to increase the performance.
• Developed UNIX shell scripts to automate applications, Schedule jobs, develop interfaces.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets

Environment: Informatica PC 9.1, Oracle 11g, SQL and UNIX

Confidential

SAS Programmer

Responsibilities:

• Performed data analysis on the source data coming from legacy systems.
• Involved in understanding the Protocol, Statistical Analysis Plan (SAP) and Annotated CRF.
• Extracting the data from Oracle Clinical using SAS Web Tools.
• Involved in Preparing Table of Contents (TOC) and Mock Shell Tables.
• Writing SQL queries based on the requirement.
• Creating Value Added Datasets (VAD) based on Primary and Secondary Endpoints from Statistical Analysis Plan (SAP).
• Generating Descriptive Statistics by SAS/ BASE procedures like Proc Tabulate, Proc Means etc.,
• Cleaning the dataset’s by using Base SAS Procedures and DataSteps.
• For getting required output format by using Proc Transpose, Proc Sort, Proc tabulate …etc.
• Creating final report by using Proc Report.

Environment: Informatica PowerCenter8.1, SAS 8.1, SAS/Base, SAS/STAT, SAS/GRAPH, Unix

Confidential

SAS Programmer

Responsibilities:

• Involved in understanding the protocol and Statistical Analysis Plan (SAP)
• Generating safety, efficacy and figures using SAS programming.
• Writing QC codes and doing quality checks of generated tables
• Coordinating with the Sr. Associate.

Environment: SAS 8.1, SAS/Base, SAS/STAT, Windows XP

Confidential

Programmer

Responsibilities:

• Understanding the Statistical Analysis Plan (SAP) and Annotated CRF.
• Generating Tables, Listings and Graphs using SAS Programming
• Doing quality checks of generated tables.
• Coordinating with the Team Leader and the Senior Statistician.

Environment: SAS 8.1, SAS/Base, SAS/STAT, Windows XP