PROFESSIONAL SUMMARY:

• Around 8+ years of experience in Information Technology with a strong back ground in Analyzing, Designing, Developing, Testing, and Implementing of Data Warehouse development in various domains such as Banking, Health Care and Automobile.
• Around 8 years of Data Warehousing experience using ETL - Informatica Power center 9.x/8.x/7.x/6.x, Informatica Power Mart 7.x/6.x.
• Strong working knowledge on Oracle SQL and PL/SQL, Teradata v12, SQLServer 2008 ch as BTEQ scripts, Fastload, Multiload
• Expertise in Database development skills using Oracle 11g/10g/9i/8i, SQL, PL/SQL procedures, Functions, Packages, Triggers, Cursors, Programming and using TOAD, SQL Developer.
• Hands on experience Oracle Warehouse Builder.
• Experienced in complete life cycle Implementation of data warehouse.
• Good exposure to development, testing, debugging, implementation, documentation
• Hands on experience in ETL Informatica Production support activities.
• Knowledge on Oracle-DAC tool.
• Good theoretical knowledge on Java programming.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling tool ERWIN and Dimensional modeling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Extensively worked on various Data warehouse projects using Informatica Client Tools- Source Analyzer, Transformation Developer, Workflow Manager, Workflow Monitor, Mapping Designer, Mapplet Designer and Target Designer.
• Expert knowledge in Trouble shooting and performance tuning at various levels such as source, mappings and target.
• Experience in the concepts of building Fact Tables, Dimension Tables, handling Slowly Changing Dimensions and Surrogate Keys.
• Expertise in designing and Developing complex Mappings using Informatica Power Center Transformations - Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator and Rank.
• Working experience in using Informatica Workflow Manager to create Sessions, worklets and schedule workflow, Developing complex Mapplets, Worklets, Re-usable Tasks, Re-usable Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings & Workflows, Backup & Recovery.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Data loading using UNIX Shell scripts, SQL*Loader.
• Experience in dealing with various databases like Oracle 11x/10g/9i/8x/7x, SQL Server 2005/2003/2000 , MSSQL (SQL-Server), Excel sheets, Flat Files and XML files.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Good working knowledge in developing reports using Cognos 6.
• Experience in handling initial and incremental loads in target database using mapping variables.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectation.
• Excellent written, communication skills and possessed analytic problem skills in evaluating business and technical processes and issues, develops and implements system enhancements to facilitate overall operations.

Technical Skills:

Data Warehousing: Informatica Power Center 9.5/8.6/8.1/7.1/6.2 , Informatica Power Mart 7.x/6.x, Informatica Power Exchange 8.x/7.x, Repository Admin console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor. OWB (Oracle Warehouse Builder) 10g

Data Modeling: Ralph-Kimball Methodology, Bill-Inmon Methodology, Star schema, Snowflake schema, Dimensional data modeling, Snowflake modelingFact Tables, Dimension Tables.

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008/2005, Teradata v12

DB Utilities: Oracle SQL Developer, SQL * Plus. Teradata BTEQ, Fastload, Multiload

Operating Systems: Windows 7/vista/NT/2000/XP, UNIX

Reporting Tools: Cognos report .net

Modeling Tools: Erwin 4.1/4.0, TOAD 9.x/8.x/7.x, SQL Loader 11g/10g, ER-Studio.

Scheduling Tools: Informatica Scheduler, Control-M, Cisco - TIDAL

Office Tools: MS PowerPoint, MS Word, MS Excel, Visio

Programming: SQL, PL/SQL

Scripting: UNIX Shell Scripting, Korn Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Sr. Analyst Programmer

Environment: Informatica 9.1.0,CISCO Tidal Scheduler, Oracle 10g/9i,TOAD,VSS,MS Office and JIRA.

Responsibilities:

• Worked on Trial management data and Clinical reporting data for Inform trials.
• Responsible for developing Integration projects in ETL tool - Informatica and reports in Cognos environment
• Worked on CISCO Tidal Scheduler to schedule the informatica jobs.
• Responsible to load the raw clinical data from different applications into Inform databases. Mainly worked on integrating lab data into the database.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Worked on developing PL/SQL procedures and views to populate data into reports.
• Experience in analyzing clinical database structures, and create programming for data extraction and transfers, analysis, and reporting.
• Experience programming with relational databases, data repositories or warehouses, especially development of tables, views, procedures, and functions.
• Worked on building different types of reports related to clinical trials as below.
• Query reports provide information about query aging, status, and cycle time.
• Case Report Form (CRF) reports provide information about the progress of data entry and query activity on started case books.
• Item reports provide information about the progress of item source verification, as well as listings of items on forms.
• Subject reports provide information on the progress of casebook completion for individual subjects. These reports also provide subject enrollment and dropout counts, as well as subject enrollment status.
• Audit trail reports provide auditing and operational information such as audit trail information and log in history.

Confidential, Richmond,VA

Sr. Informatica Developer

Environment: Informatica Power center 9.1(Source Analyzer, warehouse designer, Mapping Designer, Mapplet, Transformations, Repository Manager, Work Flow Manager, Workflow Monitor), Teradata, Fastload, Multiload, BTEQ scripts, Oracle, SQLServer2010, Flat Files, Windows 7, LinuxDescription:

Responsibilities:

• Developed complex ETL mappings and workflows in an optimized manner for better performance.
• Prepare Teradata BTEQ scripts and configure Informatica with Fastload, Multiload
• Extensively used Informatica 9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Create and run complex SQL scripts
• Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the translation process.
• Configure informatica to user Fastload and MLoad

Confidential, Pittsburgh, PA

Sr. Informatica Developer

Environment: Informatica Power center 9.1(Source Analyzer, warehouse designer, Mapping Designer, Mapplet, Transformations, Repository Manager, Work Flow Manager, Workflow Monitor), Oracle, SQLServer2010, Flat Files, Windows 7, Linux, SAS Enterprise Guide 4.3

Responsibilities:

• Extensively used Informatica 9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Prepare and execute complex SQL scripts
• Prepare PL/SQL programs such as Functions, Procedures and Packages
• Preparation of DDL scripts such as Tables, Views, Indexes
• Create PL/SQL Blocks to update tables using explicit cursors
• Create procedures to drop and recreate indexes
• Developed complex ETL mappings in an optimized manner.
• Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the translation process.
• Finding the Informatica mappings bottlenecks and optimizing the mappings to get the best performance and tuning the SQL queries as well.
• Involved in loading the data from Source Tables to Stage standalone tables using Transformation and Cleansing Logic using Informatica.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Developed mapplets and worklets for reusability.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Confidential, Cleveland, Ohio

Sr. Informatica Developer

Environment: Informatica Power center 8.6(Source Analyzer, warehouse designer, Mapping Designer, Mapplet, Transformations, Repository Manager, Work Flow Manager, Workflow Monitor),OWB 10g, oracle 10g, TOAD 9 for oracle, PL/SQL, Flat Files, Windows 7, Linux, Cognos 8.4.

Responsibilities:

• Involved in Designing specifications and Documentation of Data Warehouse using ETL (Extraction, Transformation and Load) tool Informatica.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Create and execute complex SQL scripts
• Create PL/SQL programs such as Functions, Procedures and Packages
• Preparation of DDL scripts such as Tables, Views, Indexes
• Create PL/SQL Blocks to update tables using explicit cursors
• Extensively used Informatica 8.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the Data warehouse.
• Finding the Informatica mappings bottlenecks and optimizing the mappings to get the best performance and tuning the SQL queries as well.
• Implemented partitioning and bulk loads for loading large volume of data.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Developed mapplets and worklets for reusability.
• Implemented weekly error tracking and correction process using Informatica.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Developed Informatica SCD type-I, Type-II and Type III mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Created Stored Procedures, Packages in PL/SQL with Oracle in order to create, update several tables like Order processing Information table and Audit Log tables.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL scripts to automate the process
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.
• Deployment and production support activities.
• Production job monitoring and reporting.

Confidential, Omaha, NE

Sr. Informatica Developer

Environment: Informatica Power Center 8.6, Oracle 9i, PL/SQL, UNIX shell scripts, Flat files, Toad, ODBC.

Responsibilities:

• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Create and execute complex SQL scripts
• Create PL/SQL programs such as Functions, Procedures and Packages
• Preparation of DDL scripts such as Tables, Views, Indexes
• Create PL/SQL Blocks to update tables using explicit cursors
• Used workflow manager for session management, database connection management and scheduled the jobs to run in the batch process.
• Developed Slowly Changing Dimensions for Type 2 SCD.
• Troubleshoot the issues by checking sessions and workflow logs.
• Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Involved in the performance tuning process by identifying and optimizing source, target, mapping and session bottlenecks.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc.
• Deployment and production support activities.
• Production job monitoring and production job reporting.

Confidential, Kansas City, MO.

Sr. ETL Informatica Developer

Environment: Informatica Power Center 8 (Designer, Workflow Manager, Workflow Monitor), Oracle 9i, Teradata, Fastload, Multiload, BTEQ, UNIX Shell Scripting, TOAD, Windows 2000 Professional, Linux

Responsibilities:

• Performed Project Requirements Gathering, Requirements Analysis, Design, Development, Testing for the ETL, Data warehousing and Reporting modules of the project.
• Create and execute complex SQL scripts
• Create PL/SQL programs such as Functions, Procedures and Packages
• Preparation of DDL scripts such as Tables, Views, Indexes
• Create PL/SQL Blocks to update tables using explicit cursors
• Developed Mappings and Transformations (using Filter, Joiner, Lookup, Update Strategy, Expression and Aggregator) on the extracted data as per the Business requirements.
• Used Teradata TPump for highly parallel utility designed to continuously move data from data sources into Teradata tables without locking the affected table.
• Designed, developed, tested and attuned Informatica mappings. Analyzed and modified existing ETL objects in order to in corporate new changes in them according to the project requirements.
• Comprehended and converted critical business requirements into technical functionalities for the ETL and Reporting teams.
• Developed UNIX scripts, to perform multifarious data processing tasks and automation function.

Confidential, PA

Informatica Developer

Environment: Informatica Power center 7, oracle 9i, XML, Flat Files, Linux.

Responsibilities:

• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Create and execute complex SQL scripts
• Create PL/SQL programs such as Functions, Procedures and Packages
• Preparation of DDL scripts such as Tables, Views, Indexes
• Create PL/SQL Blocks to update tables using explicit cursors
• Created different transformations using Informatica power center 6 for loading the data into targets using various transformations like Source Qualifier, Java Transformation, SQL transformation, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Used Workflow Manager to create Worklets and workflows and Workflow Monitor to monitor the workflows.
• Used Workflow Manager to create connections, sessions, tasks, workflows and created Event Wait, Event Raise, Timer and Control Events in a single master workflow according to the business requirements.
• Applied performance tuning on targets, sources, mappings and sessions to improve system performance.
• Writing Oracle Stored Procedures, SQL scripts and calling them by using Bourne shell scripts at post session.
• Developed PL/SQL stored procedures for pre and post session commands and used indicator files to run tasks in workflows.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Created Breakpoints for debugging the mappings using Debugger.
• Extensive use of Persistent cache to reduce session processing time.
• Created partitions for concurrent loading and processing of data.
• Preparing deployment documents, user guides, coding standards, and other technical documents.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Confidential

Informatica Developer

Environment: Informatica PowerCenter 6.1/7.1.1, XML, Oracle, SQL, PL/SQL, UNIX, SQL Server 2005, Windows XP, TOAD

Responsibilities:

• Involved in analysis of three different source systems and prepared technical specifications for the ETL
• Create and execute complex SQL scripts
• Create PL/SQL programs such as Functions, Procedures
• Create PL/SQL programs to truncate tables
• Developed Error/Exception handling mechanism to enhance the data quality loaded to EDW
• Involved in enhancing the data model for new additions of dimension and reference tables
• Responsible for data migration in order to achieve an automated migration.
• Involved in all stages of data migration.
• Created mappings and Mapplets using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Sequence Generator, Update Strategy
• Extensively worked with Power Connect to import sources from external systems like ERP.
• Used Workflow Manager for creating workflows, Worklets, email and command tasks
• Involved in tuning Informatica Mappings and Sessions by implementing parallelism, partitioning and caching
• Developed Unix scripts to automate different tasks involved as part of loading process and scheduling
• Infomatica workflow scheduler (IWS) was used as part of scheduling
• Performed Unit Testing and Integration Testing on the mappings