Raghavendar N

Ph: 571-***-****

Email: acucih@r.postjobfree.com

Professional Summary:

SDLC: 9+ years of IT experience in Data Analysis, Design, coding and testing of Data Warehousing implementations across Retail, Financial, Pharmaceutical, Health care and Insurance Industries.

Informatica: 5 years of Data Warehousing experience using Informatica Power Center 9.6.1/8.6.1/8.1.1/8.0/7.1.3, Power Mart 6.1/5.1.1/5.x/4.7, Warehouse Designer, ETL, Data mart Siebel 7.0/2000/5.5, Siebel Warehouse 6.3, Siebel EIM, OLAP, OLTP, Autosys, Control M, Sybase. Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files (fixed width, delimited), XML, RDBMS tables, legacy system files.

Extensively worked on Informatica SAP BAPI/IDOCs transformations, Web services transformations and security/certificates/mutual authentication configuration using Informatica 8.6, Siebel reports (Answers & Dashboards).

3+ years of full cycle SAP R/3 & SCM (Rockwell Scheduler, i2) application software implementation experience as SAP ABAP consultant, Integration of SAP (PP, MM and SD Modules) with SCM application Rockwell Scheduler using SAP JCO connector, Web Methods, BAPI and RFC. RFID Integration with SAP 4.7D for Asset tracking project. Integration of SAP R/3 software with MES software (Flex Net 7.2- Apriso) using ALE& IDOCS.

Data Analysis: 4 years of strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis

Methodologies: Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.

Databases: 5 years of experience using Oracle 11g/10g/9i/8i, DB2 8.0/7.0/6.0, MS SQL Server 2005/2000/7.0, Teradata V2R6/V2R5, Sybase 12.x/11.x, SAP R/3,MS Access 7.0/2000, PL/SQL, SQL*Plus, SQL*Loader and SQL Developer.

Experienced with coordinating cross-functional teams.

Excellent analytical, problem solving, and communication skills with ability to interact with individuals at all levels.

Technical Skills:

Data Warehousing

Informatica Power Center 9.6.1/8.6.1/8.1.1/8.0/7.1.3, Power Mart 6.2/5x/4.7, Informatica Power Analyzer, Informatica Power Connect, Informatica Power Plug, Informatica Designer, Workflow Manager, Workflow Monitor, ETL, ETI, Data mart, OLAP, OLTP, Mapplet, Transformations, Control M, SQL*Plus, SQL*Loader.

Dimensional Data Modeling

Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 7.1/4.0/3.5.2

Databases

Oracle 10g/9i/8i, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005, Teradata V2R6/V2R5, SAP R/3, Sybase 12.x/11.x, MS Access.

Programming GUI

SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Synopsis, Java, J2EE, HTML, DHTML, C, C++, Unix Shell Scripting, Kernel Programming, PERL scripting

Environment

Sun Solaris, HP-UX, IBM AIX, MS DOS, Novell NetWare, Win NT, Red Hat Linux.

Education:

Master of Computer Applications from Osmania University, Hyderabad, India.

Professional Experience:

Schlumberger Houston TX Oct ’15 – tilldate

Sr ETL Informatica Developer

Responsibilities:

Worked on ETL Design& functional specifications and converted them into technical specifications.

Extensively used ETL and Informatica to load data from Oracle, Excel spreadsheet, flat files, XML and Mainframe/COBOL to the target Teradata database.

Experience in Informatica providing Data warehouse solutions using Power Center and data modeling with ERWIN tool.

Responsible for Power Center and Power Exchange installations, configuring Power Center domain, nodes and integration services.

Designed ETL Process Design Documents.

Designed Source to Target Mapping specification Documents.

Extensively involved in Data Extraction from Mainframe source (VSAM), Oracle using Power Exchange when there was change in the source data sets.

Created repository services and repository contents. Restored the repository contents from the backups using Admin console.

Extensive experience working with repository manager. Was responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders etc.

Used SQL overrides in source qualifiers with appropriate schema names for extracting only the required rows for optimal performance. Implemented complex expressions in expression transformations. Tested the queries thoroughly for integrity and identifying data errors.

Extensively worked on Informatica power center tools –Designer, Workflow Manager, and Workflow Monitor & Repository Manager.

Extensively worked on Informatica Designer Components – Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.

Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively

Extensively worked on the performance tuning of the Mappings as well as the tuning of the sessions.

Developed a script which automated the loading process to the Oracle database

Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.

Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.

Lead the Performance Tuning of Informatica Mappings, Sessions and workflow. Developed unit test cases and did unit testing for all the developed mappings.

Lead the development team during the development process, this include provide help with the tasks and transfer knowledge of Informatica.

Provided production support by monitoring the processes running daily.

Environment: Informatica Power Center 9.1/9.6.1, Oracle 10g/11g,PL/SQL Erwin 5.1, Business Objects xi, TOAD 9.6.1, Autosys, UNIX version 5.1, Windows XP Professional/2002, UNIX, Windows XP/2000.

Tiffany&Co, Parsipanny,NJ Mar ’14 – Sep’15

Sr ETL Informatica Developer

Responsibilities:

Worked on Informatica tool –Source Analyzer, Target designer, Mapping Designer & Mapplet and Transformations.

Involved in all phases of software development life cycle (SDLC) in Agile.

Fine-tuned existing Informatica maps for performance optimization.

Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.

Tuned sources, targets, mappings and sessions to improve the performance of data load.

Developing Reusable Transformations, Aggregations and created Target Mappings that contain business rules.

Extensively worked in the performance tuning of mappings, ETL procedures and processes.

Perform unit testing at various levels of the ETL.

Designed the mapplets and reusable transformations using Transformation Developer.

Created complex mappings using mapping designer and reusable mapplet using mapplet designer.

Wrote stored PL/SQL procedures for certain Business Requirements.

Used various Oracle Index techniques like B*tree, bitmap index to improve the query performance.

Created Materialized views for summary tables for better query performance.

Loading of data from different source systems into Oracle Target database.

Setup the batches, configured the sessions and scheduled the loads as per requirement.

Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.

UNIX shell scripts and Autosys are used for scheduling to automate the load process.

Used UNIX to run FTP scripts, which transferred data from the UNIX server to the Windows NT server.

Worked with many existing Informatica Mappings to produce correct output.

Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.

Lead the Performance Tuning of Informatica Mappings, Sessions and workflow. Developed unit test cases and did unit testing for all the developed mappings.

Lead the development team during the development process, this include provide help with the tasks and transfer knowledge of Informatica.

Provided production support by monitoring the processes running daily.

Environment: Informatica Power Center 9.1/9.6.1, Oracle 10g/11g,PL/SQL Erwin 5.1, Business Objects xi, TOAD 9.6.1, Autosys, UNIX version 5.1, Windows XP Professional/2002, UNIX, Windows XP/2000.

CEB Arlington(Corporate Executive Boad), Arlington,VA Oct’12– Feb’14

ETL – Informatica Developer

Description: CEB is a leading member-based advisory company. It offers comprehensive data analysis, research and advisory services that align to executive leadership roles and empower clients to focus efforts, move quickly, and address emerging and recurring business challenges with confidence

The aim of this project is to design the data warehouse and populate the data using Informatica Power Centre from Oracle database and Data from file, and making report in Business Objects.

Responsibilities:

Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.

Extensively used Informatica Power Center 8.1.1 to extract data from various sources and load in to staging database.

Interacted with business representatives for Need Analysis and to define Business and Functional Specifications. Participated in the Design team and user requirement gathering.

Used Power Exchange interface to get the data from mainframe files.

Performed source data analysis .Primary data sources were from Oracle & SQL server 2005.

Involved in using Erwin for physical and logical data modeling.

Developed various Mappings with the collection of all Sources, Targets, and Transformations.

Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.

Extensively used ETL to load data from multiple sources to Staging area (Oracle 10g) using Informatica Power Center 8.1.1

Created Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.

Tuned sources, targets, mappings and sessions to improve the performance of data load.

Implemented Slowly Changing Dimension methodology for accessing the full history.

Created Several Informatica Mappings to populate the data into dimensions and fact tables.

Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.

Designing mapping templates to specify high level approach.

Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.

Involved in Unit testing and documentation.

Environment: Informatica 9.6.1, Oracle 10g, PL/SQL, TOAD 8.6.1, Flat File, Sybase, SQL Server 2005, Business Objects, Windows NT, UNIX Shell Scripting.

Appirio Inc, Sanfrancisco CA, US.

Client: UHC Mar’11 – Sep ’12

ETL – Informatica Developer

Description: UHC is a total health care management system, which manages the total patient information maintained in three different modules. Patient Information, Accounts Information, Monitoring. The Patient information module contains the patient details, up to date health information. In the Accounts Information module day-to-day bill settlements will be entered in to the online system. In Monitoring, it monitors from the day one to discharge date of the patient and Case Sheet will be maintained which is confidential.

Responsibilities:

Involved in system study, analyze the requirements by meeting the client and designing the complete system.

Involved in designing technical specifications for building Data Warehouse.

Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy & Dimensional modeling. Backup & recovery.

Creation of shortcuts for source, targets and created transformations according to business logic.

Worked in Development, Testing, Pre-production and Production Servers.

Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer.

Created complex reusable transformations and mapplets using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively.

Created reusable Sessions and Commands in the Workflow Manager.

Created and implemented variables and parameters in the Mapping Designer.

Created reusable Worklets in Worklet Designer and set up Workflows in the Workflow

Used unconnected lookup for populating date-time entered field in the target tables.

Developed mapplets, mappings and configured sessions.

Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.

Worked closely with reporting team and generated reports using Business Objects 6.2.

Analyzed system requirement specifications, coding the routines, developed test plans, test cases to cover overall quality assurance testing.

Designed and developed unit test cases for system integration testing.

Involved with the users in the creation of test scripts for the user acceptance testing.

Environment: Informatica 8.1.1, Oracle 10g, PL/SQL, Toad 9.4, ERWIN, Web Services, XML, Java, Windows NT, UNIX Shell Scripting.

Client: IAB Solution, Universal Bank, California. April ’09 – Feb’11

Data warehouse Developer (ETL / Informatica)

Pune India

Description: Universal Bank is one of the biggest banking corporations in California, USA and providing

Services throughout USA and having lot of branches throughout CA (West Covina, Rosemead,

Monterey Park, Arcadia, Los Angeles, and Orange). The main aim of this project is to develop a Data

Warehouse for Universal Bank in order to maintain the customer details throughout USA and also to

Maintain some financial services (Universal Finance, Universal Millionaire) that are running by the

Universal Bank. We are extracting the data monthly from Universal Bank branches throughout CA by using Universal Bank Acquisition Gateway; transform the data by using transformations and loading into data warehouse.

Responsibilities:

Designed Logical and Physical Modeling using Erwin Data Modeler tool.

Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.

Implementing Extraction process of flat files into target database

Migrated Mappings from Development to Testing and Testing to Production.

Used Parameter Files for multiple DB connections for the sources and defining variable values.

Developing the documentation and plan for transformation and loading the Warehouse.

Analyzing the data from various sources for data quality issues.

Participated in all facets of the software development cycle including providing input on requirement specifications, high level design documents, and user’s guides.

Worked with Web services.

Writing Oracle Stored Procedures, SQL scripts and calling at pre and post session.

Created Concurrent Tasks in the workflows using workflow manager monitor jobs in Workflow Monitor.

Designing mapping templates to specify high level approach.

Involved in Unit testing and documentation.

Environment: Informatica 8.6.1, Oracle 10g, PL/SQL, Toad 9.4, ERWIN, Web Services, PVCS, Windows NT, UNIX Shell Scripting.

Client: LEAD Communications, UK Nov ‘08 –March ‘09

ETL – Informatica Developer

Description: Lead Communications is the largest Telecomm leader with over 20 Million subscriber customer’s base in India with different products of CDMA Mobile Services, Broad Band serviceetc.India’s leading CDMA Technology Service provider. Reliance is engaged in providing different types of Telecomm Business. The project entailed defining the Data Warehouse strategy, design, and planning effective communications with decision-making, Business Intelligence development processes, data modeling and ETL processes.

Responsibilities:

Engaged with Call Center, Customer & Marketing data mart with different types of active and passive transformation.

Identified and created different source definitions to extract data from input sources

and load into relational tables using Informatica Power Center.

Extensively used ETL to load data from Oracle, flat files to Oracle.

Develop Mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, Sequence Generator, Joiner, Aggregator transformations and expression.

Implement Source and Target definitions in Informatica Designer.

End-to-end ETL development of the Data Mart. Data Quality Analysis to determine cleansing requirements. Designed and developed Informatica Mappings for data loads

Extensively used ETL and I Informatica to load data from MS SQL Server, Excel spreadsheet, flat files into the target Oracle 9i database.

implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter,

Update Strategy, Stored Procedures, and Router etc.

Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & mapplet Designer and transformation Designer. Development of Informatica mappings and also in tuning of mappings for better performance.

Loading the Data from the tables into the OLAP application and further aggregate to higher levels for analysis.

Created and run workflows and Worklets using Workflow Manager to load the data

into the Target Database.

Environment: Informatica 8.6.1/6.2,, OLAP, Teradata V2R5, Oracle 9i, MS SQL Server 7.0/2000, Sybase, Flat files, PL/SQL,SQL, SQL*Loader, Erwin 3.5, Windows 2000, HP-UX, UNIX Shell Scripting

Life insurance data warehouse, Reliance Mumbai Apr ’07 – Oct 08

Data warehouse Developer (ETL / Informatica)

Description:

Disability Claim Analysis, customer Profile Analysis, Customer Service Analysis, Financial Analysis, Reliance Life Insurance is one of the world’s respected players in Health Care Insurance industry in India. This conceptual enterprise Data Warehouse model provides Enterprise wide solution, which deals with several treads of the business like Audit& IT Analysis, Billing & Payment Analysis n Resource Analysis, Marketing Analysis and Sales Channel Analysis. It also supports the Operational Reporting Strategies Development from which it is extracting the data through Flat Files, Oracle then Transforming, and Loading into Oracle target database. We first constructed the Data Marts according to the identified subject areas and then integrated them into Data Warehouse.

Responsibilities:

Identified and created different source definitions to extract data from input sources and load into relational tables using Informatica Power Center.

Extensively used ETL to load data from Oracle, flat files to Oracle.

Extensively used aggregator, expression, lookup, and update strategy, transformation

Understanding the ETL Specification Documents for Mappings requirements.

Extract Data from multiple sources like Flat files, Oracle into staging database.

Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse

Designer, Transformation Designer, Mapplet Designer and Mapping Designer to design,

Develop and Mapplets to load data from external flat files and RDBMS.

Created Mappings using the transformations such as the Source qualifier, Aggregator,

Expression, lookup, Router, Filter, Joiner, Union, Sequence Generator, and Update

Strategy.

All errors encountered were documented using an Issue Log. Interacted with team

Members to resolve the errors encountered.

Performed Unit tests on all the Mappings developed and documented the test cases and

Test results.

Environment: Informatica 7.1.1, Oracle 8i, PL/SQL, Toad 9.4, ERWIN, Web Services, PVCS, Windows NT, UNIX Shell Scripting

Contact this candidate