PROFESSIONAL SUMMARY

• Around 9 years of extensive experience in Design, Development and Implementation of Data Warehouses Data marts by using Informatica, Teradata and Oracle.
• Expertise in interacting with business users for requirement analysis and to define business and functional specifications
• Experience in Data Modeling, Star Schema, Snowflake Schema, Slowly Changing Dimensions, Fact tables, Dimension tables, Normal forms, OLAP and OLTP systems
• Experience in Informatica PowerCenter Tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Experience in designing Mappings, Mapplets, Reusable Transformations, Transformations, Tasks, Worklets and Workflows.
• Strong experience in designing and developing complex mappings by using transformations like Unconnected and Connected Lookups, Source Qualifier, Expression, Router, Filter, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Rank, Sorter, Normalizer, Stored Procedure, Transaction Control, External Procedure etc
• Experience in Informatica Partitioning and performance tuning.
• Experience in using Teradata BTEQ, FastExport, Fastload, Multiload and Tpump utilities
• Experience in Teradata Performance Tuning, Indexing, Collecting Statistics, CPU and I/O Optimization.
• Experience in SQL, PL/SQL, Oracle Schemas, Tables, Views, Clusters, Indexes, Users, Roles, Cursors, Triggers, Stored Procedures, Functions, Packages, Ref Cursors and implementing Materialized Views.
• Experienced in Oracle SQL performance tuning by using indexing, collecting statistics and query optimization methods
• Experience in writing shell scripts
• Experience with various databases like Teradata, Oracle, SQL Server
• Team player and self-starter with good communication skills and ability to work independently and as part of a team

TECHNICAL SKILLS

PROFESSIONAL WORK EXPERIENCE

Confidential

Sr ETL Informatica Developer

Description:

Confidential is initiative to replace the existing Cash application in Federal Reserve System. The current Cash application Standard Cash Applications SCA is an office specific application which doesn't has capability to interact with the other offices SCA applications. New FCC system is a centralize application for all the offices of Federal Reserve. Objective of Data Migration project is to integrate and migrate the history data from individual legacy SCA databases SQL Server to FCC central database Oracle .

Responsibilities:

• Worked closely with business analysts and gathered functional requirements.
• Developed mappings for loading the staging tables from text files using different transformations.
• Involved in building the ETL architecture for Source to Target mapping to generate the target files.
• Developed Mappings, Mapplets, Transformations and Reusable transformations by using PowerCenter Designer
• Developed several mappings in Informatica by using the transformations like Unconnected and Connected lookups, Source Qualifier, Expression, Router, Filter, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Rank, Sorter, Normalizer, Transaction Control etc
• Developed Workflows, Worklets and Tasks by using PowerCenter Workflow Designer.
• Optimized Sources, Targets, Mappings, Transformations and Sessions to increase session performance
• Extensively used mapping parameters, variables, parameter files, user defined functions in Informatica
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor
• Created indexes on database tables and tuned the queries to improve the performance
• Performed Unit Testing and documented the results.

Environment: Informatica Power Center 9.5.1 Repository Manager, Designer, Workflow Manager, Workflow Monitor , Data Validation Option DVO , Control-M,SQL Server, Oracle 11g, SQL server 2008.

Confidential

Sr.ETL Developer

Description:

This project includes developing ETL applications to load data into a centralized Teradata Data Warehouse by extracting the data from source systems, transform the data according to business logic and load the transformed data into relational targets. Prepared ETL Design documents and developed ETL mappings in Informatica to build several dimension tables with slowly changing dimensions. Developed ETL logic to load the data into Teradata Data Warehouse.

Responsibilities:

• Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process
• Developed mappings for loading all the tables using different transformations.
• Involved in building the ETL architecture for Source to Target mapping to load data into Data warehouse.
• Developed Mappings, Mapplets, Transformations and Reusable transformations by using PowerCenter Designer
• Developed several mappings in Informatica by using the transformations like Unconnected and Connected lookups, Source Qualifier, Expression, Router, Filter, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Rank, Sorter, Normalizer, Stored Procedure, Transaction Control, External Procedure etc
• Developed Workflows, Worklets and Tasks by using PowerCenter Workflow Designer
• Optimized Sources, Targets, Mappings, Transformations and Sessions to increase session performance
• Extensively used mapping parameters, variables, user defined functions in Informatica
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor
• Developed and tested Informatica mappings and update processes
• Responsible for tuning ETL procedures to optimize load and query Performance
• Worked on Round-Robin and Pass Through partitioning types to improve the performance.
• Generated optimized plans to execute the complex data fixes with less impact on production systems.
• Tuned several Teradata SQLs to increase the performance and optimize the CPU and I/O usage.
• Coordinated with source system owners, monitored day-to-day ETL progress.
• Performed Unit Testing and documented the results.
• Prepared code migration document and worked with release team in migrating the code from development to SIT System Integration Testing , UAT User Acceptance Testing and production servers
• Worked closely with production support team to provide application support

Environment: Informatica PowerCenter9.1, UNIX, Teradata 12, Teradata SQL Assistant 12.0

Confidential

Sr. Informatica Developer

Description:

This project deals with the Pharma Research Data and Sales Marketing Data collected from different tests conducted on the subjects. The data is then consolidated into the Data mart .

Responsibilities

• Analyzing the source data coming from different sources and working with business users and developers to develop the Model.
• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mappings and complex transformations Aggregator, Joiner, Lookup Connected Unconnected , Source Qualifier, Filter, Update Strategy, Stored Procedure, Router, and Expression .
• Developed number of complex Informatica Mappings, Mapplets and Reusable Transformations for different types of tests in Customer information, Monthly and Yearly Loading of Data.
• Using Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Extracted data from various sources like Flat Files, SQl server and Oracle.
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool.
• Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Monitored the sessions using Workflow Monitor.
• Data Quality Analysis to determine cleansing requirements.
• Used stored procedures to create a standard Time dimension, drop and create indexes before and after loading data into the targets.
• Removed bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Captured data error records corrected and loaded into target system.
• Created Mappings, Mapplets and Transformations, which remove any duplicate records in source.
• Implemented efficient and effective performance tuning procedures, Performed benchmarking, and these sessions were used to set a baseline to measure improvements against.
• Tuned Source System and Target System based on performance details, when source and target were optimized, sessions were run again to determine the impact of changes.

Environment: Informatica Power Center 8.5, MS SQL Server 2008, DB2,Oracle 10g,Teradata 13, Unix Shell Scripts, Toad.

Confidential

ETL Developer

Description:

This project was to implement an Enterprise data warehouse EDW by means of integrating data from different feeder systems situated across various locations into a central repository of business information. The EDW provides quick access to data to enable a more informative decision making process.

Responsibilities

• Responsible for analysis, design and development of Enterprise Data Warehouse.
• Responsible for the Design of the Target Data Warehouse Entity for Oracle using Power Center.
• Developed complex Informatica mappings tuned them for better performance.
• Performed Source partitioning to improve session performance.
• Extensively used connected and unconnected lookup transformations.
• Designed and developed Target Warehouse Entity for Oracle using Power Center.
• Extensive use of SQL overrides, and substituted them in the place of multiple transformations.
• Used ODBC to connect to the target Oracle database.
• Did Extensive fine-tuning on Oracle Stored Procedures for improving performance.
• Created Oracle stored procedures, functions and triggers using SQL PL/SQL.
• Was responsible for Optimization of the Query Performance and Session Performance.
• Optimized Query Performance, Session Performance and Reliability.
• Written complex stored procedures and triggers and optimized for maximum performance.
• Worked on Data Conversion and Data Analysis to meet EDW requirements.
• Scheduled and monitored automated weekly jobs under UNIX environment.
• Used parameters and variables to facilitate smooth transition between the development and production environments.
• Unit testing of individual modules and their integration testing.
• Debugged and sorted out the errors and problems encountered in the production environment.

Confidential

Ab initio Developer

Description:

The project was aimed at building Claims Confidential as a part of Insurance Data Warehouse IDW . IDW provides the information about Policy Transactions, Premium and Claims Transactions data to the business users, This Claims Data Mart was primarily built for the purpose of claims Transaction and for analysis and report generation, which was used by the end users for Decision-making on Claims processing and approval. The source data contained information about customers, Policies, premiums, etc., required for Claims processing.

Responsibilities

• Worked in the Data Management Team on Data Extraction, Fictionalization, Subset, Data Cleansing and Data Validation.
• Facilitated the effective communication between the Development team and the Analysis/Design team working at client site and scheduled a weekly status meeting for any critical issue and any dependency between design and development team.
• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Partition by round robin, Reformat, Rollup, Join, Scan, Normalize, Gather, Merge etc.
• Handled and Supported Continuous flow Component.
• Extensively used the Ab Initio tool's feature of Component, Data and Pipeline parallelism.
• Used AIR commands to do dependency analysis for all ABI objects
• Moved data feeds from the mainframe MVS system to the Data Developing Environment Ab Initio .
• Developed shell scripts for Archiving, Data Loading procedures and Validation.
• Tested and tuned the Ab Initio graphs and Teradata SQL's for better performance
• Extensively used the Teradata utilities like Fastload, Multiload, TPump, DDL Commands and DML Commands SQL .
• Took part in quality assurance activities, design and code reviews, unit testing, defect fixes and operational readiness.
• Worked in Scrum Agile Methodology Environment.
• Conducted Joint Application Development JAD sessions with stakeholders throughout SDLC to resolve open issues.
• Automated the entire Data Mart process using UNIX Shell scripts and scheduled the process using Control - M after dependency analysis.

Environment:ab initio 3.0.1, Oracle 11g, SQL server 2008, Teradata12.

Confidential

Data Warehouse Developer

Lucent have developed a central data warehouse for sales. The Data Warehouse development significantly enhanced Lucent Flexibility, Proprietary Competitive Advantage and improved service levels in serving the critical needs of the sales team. Project involved in developing Enterprise Subject Data warehouse to implement a centralized database that collects and organizes and stores data from different operational data sources to provide a single source of integrated and historical data.

Responsibilities:

• Developed and supported the Extraction, Transformation, and load process ETL for data migration using Informatica power center.
• Responsible for developing Source to Target Mappings.
• Extensively used Informatica Client tools- Source Analyzer, Warehouse Designer, Mapping Designer.
• Developed Informatica mappings for data extraction and loading worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
• Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
• Developed mappings, sessions for relation and flat source and targets.
• Imported data from various source Oracle, Flat file and transformed and loaded into targets using Informatica.
• Created and scheduled Session, jobs based on demand, run on time
• Monitored Workflows and Sessions
• Identified the facts and dimensions and designed the relevant dimension and fact tables.

Environment: Informatica 8.6, Oracle 8i, Erwin 4.0, SQL, PL/SQL, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Modified, maintained and developed the SQL codes to develop new enhancements.
• Develop and maintain the documentation to support the team and business.
• Responsible for the fixation of the errors in data by utilizing the GUI interface of application and SQL scripting.
• Performed unit testing for the scripts.