Data Developer

Top of Form

Radhika Marri

Informatica Sr.Developer 919-***-****

**********@*****.***

Experience Summary

8+ years of experience in Information Technology industry in helping the clients to build integrated enterprise Data warehouses.

8+ years of strong working experience in using tools like Informatica Power Center, IBM Data Stage for designing, developing ETL Business Intelligence Solutions in Data Warehousing / Decision Support Systems.

Strong working knowledge in Healthcare and Supply chain domains.

Strong working knowledge on Dimension modeling concepts; working knowledge on star schema, snowflake schema, SCD, Surrogate keys.

Informatica Certified Developer.

Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Teradata, WSDL, XML files, IBM DB2, and Worked on integrating data from flat files like fixed width and delimited.

Strong experience in activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center.

Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.

Extensive knowledge on complete Software Development Life Cycle that includes Analysis, Design, Development, Testing and Implementation in Data warehousing.

Hands on experience with databases like Teradata,Oracle and SQL Server.

Worked extensively with complex mappings using different transformations like Source Qualifier, Expression, Filter, Joiner, Router, Union, Unconnected / Connected Lookups and Aggregator.

Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.

Good at CRM knowledge of vanilla functionality in Oracle On Demand CRM. Understands the basic components of CRM system like Account, Contact, Users, Book, and Product etc.

Good at WSDL interactions with Oracle On Demand CRM system to push and pull data via ETL Informatica Tool.

Experience in identifying Bottlenecks in ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.

Experience in using the Informatica command line utilities like Pmcmd to execute workflows in non-windows environments.

Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.

Strong experience in Performance Tuning of sources, targets, transformations and sessions.

Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.

Experience in UNIX shell scripting, FTP and file management in various UNIX environments.

Excellent analytical and problem solving abilities.

Working experience on onshore/offshore model.

Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member

Technical Experience Summary

Technology

Tools

ETL

Informatica Power Center 8.*

CRM Application

Oracle On Demand

Databases

Oracle 10g/9i/8i, SQL Server, Teradata, MySQL, MS- Access

Programming Skills

Shell Scripting, C, C++, SQL, PL/SQL

Scheduling Tools

Tivoli

Applications:

MS Word, Excel, Outlook, PowerPoint

Certifications

Informatica Certified Designer

Educational Profile

Qualification

Bachelor of Technology (Computer Science Engineering)

from Kakatiya Institute of Technology & Sciences(KITS), Andhra Pradesh, India

Year of Passing

2007

Grade

First class with Distinction (75%)

Key Projects

Client : Hewlett-Packard, GA April 2013 to present

Role : Sr ETL Developer

Process: The client is implementing enhancements into the existing Enterprise Data Warehouse. These new cubes that are added will enable the client to identify loyal customers and serve them better. It will also help them to analyze and implement strategies to expand their customer base and provide better deals to the existing ones. The data will also be funneled to various calculation engines and data-marts needed for internal reporting.

Technical Environment: Erwin, Informatica PowerCenter 9.0.1, Informatica Power Exchange, SQL server 2008, Seaquest, Yotta (HP Internal tools), Windows Vista

Responsibilities:

Experience in Data Warehouse/Data Mart design, System analysis, Database design, ETL design and development, SQL, PL/SQL programming.

Created mapping between the databases and identified the possibilities of incorporating the new business rules with the existing design.

Created prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.

Prepared High level design (HLD), LLD, Project functional Specification Document and Business Requirement documentation (BRD).

Participated in Design team brainstorm and user requirement gathering meetings.

Played the lead role in Designing and implementing Pricing Analytics, Best Customer and Finance Master Data Alignment Services Data marts.

Involved in managing the delivery of data extracts from the data sources to the warehouse and downstream applications.

Involved in requirement gathering and database design and implementation of star-schema, snowflake schema/dimensional data warehouse using Erwin.

Played the role of a Data warehouse architect in the Business Intelligence Enterprise Architecture group for providing data architectural strategies.

Involved in Architecture and design of Data extraction, transformation, cleaning and loading.

Involved in Requirement gathering and source data analysis for the Data warehousing projects.

Involved in the Logical and Physical design and creation of the ODS and data marts.

Converted the Business rules into Technical Specifications for ETL process.

Involved in all phases of SDLC from requirement, design, development, testing, pilot, training and rollout to the field users and support for production environment.

Implemented mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.

Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica PowerCenter.

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

Worked on Informatica Power center 9.0.1 Tool – Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.

Wrote scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.

Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.

Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.

The design document was finalized through conduct of design walkthroughs, and independent review by the user. Prepared Technical Specifications for all the utilities, as per the company's standards.

Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings.

Prepared Technical documents for all the modules developed by our team.

GSK DAL

Client : GlaxoSmithKline

Environment : Informatica Power Center 8.6, Oracle on Demand (CRM), Oracle 10g/11g, TOAD, SQL,

PL/SQL, XML, Windows XP, UNIX.

Duration : Aug2012 to April 2013

Role : Sr ETL Developer

Team Size : 4

Description:

GlaxoSmithKline is a global pharmaceutical, biologics, vaccines and consumer healthcare company headquartered in London, United Kingdom. It is the world's third largest pharmaceutical company measured by revenues. DAL (Data Access Layer) is an application developed to provide data to the downstream systems like “Oracle on Demand” CRM system and other applications

Key Components and Contributions:

Involved in full life cycle design and development of Data warehouse.

Interacted with business analysts, data architects and application developer to develop a data model.

Prepared the required application design documents based on functionality required.

Extensively worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer & Transformation Developer.

Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator, Sequence Generator, Web services Consumer and XML Generator Transformations.

Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.

Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.

Optimized the existing applications at the mapping level, session level and database level for a better performance.

Developed PL/SQL procedures, functions to facilitate specific requirement.

Optimized and Tuned SQL queries

Involved in migration of mappings and sessions from development repository to production repository.

Developed and maintained technical documentation regarding the extract, transformation and load process.

Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Involved in production support working with various mitigation tickets created while the users working to retrieve the database.

Investigated and fixed problems encountered in the production environment on a day to day basis.

Co-ordinate between different teams across circle and organization to resolve release related issues.

GSK 360

Client : GlaxoSmithKline

Environment : Informatica Power Center 8.6, Oracle on Demand (CRM), Oracle 10g/11g, TOAD, SQL,

PL/SQL, XML, Windows XP, UNIX.

Duration : Jan 2011 to Aug2012

Role : Sr. ETL Developer

Team Size : 6

Description:

GlaxoSmithKline is a global pharmaceutical, biologics, vaccines and consumer healthcare company headquartered in London, United Kingdom. It is the world's third largest pharmaceutical company measured by revenues. The project involves integration of “Master Data Management” MDM system with “Oracle On Demand” CRM system. The source data interactions consisted of database fetches. The data was then processed and massaged according to the business rules using ETL Informatica Tool. Finally, the prepared data was pushed to “Oracle On Demand” CRM via WSDL calls. The Informatica Tool acted as an integration hub and tool for Oracle On Demand from different source systems of CRM like Product, Territory, User, Account, Contact etc. Informatica DT/DX was also used to generate data exacts of different formats to feed various internal and external systems. The files will be sent to different vendors using MFT component.

Key Components and Contributions:

Involved in full life cycle design and development of Data warehouse.

Interacted with business analysts, data architects and application developer to develop a data model.

Prepared the required application design documents based on functionality required.

Extensively worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer & Transformation Developer.

Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator,Sequence Generator, Web services Consumer and XML Generator Transformations.

Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.

Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.

Optimized the existing applications at the mapping level, session level and database level for a better performance.

Developed PL/SQL procedures, functions to facilitate specific requirement.

Optimized and Tuned SQL queries.

Analyzed WSDL interactions with Oracle On Demand to push as well as pull data via Informatica.

Conversant in WSDL requests and responses for data manipulation in Oracle On Demand CRM system.

Import of WSDLs in Informatica using Web Service Consumer transformations.

Customized WSDLs as per the Business and project requirements.

Accustomed to the user interface of Oracle On Demand to search and use CRM application.

Involved in migration of mappings and sessions from development repository to production repository.

Developed and maintained technical documentation regarding the extract, transformation and load process.

Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Involved in production support working with various mitigation tickets created while the users working to retrieve the database.

Investigated and fixed problems encountered in the production environment on a day to day basis.

Co-ordinate between different teams across circle and organization to resolve release related issues.

.

Pharmaceutical Distribution and Provider Services

Client : Cardinal health Inc

Environment : Informatica Power Center 8.*, HP-UX, Teradata V2R6, Oracle9i, DB2, IBM Datastage.

Duration : May 2009 to Jan 2011

Role : Sr. ETL Developer

Team Size : 6

Description:

Cardinal Health, a major pharmaceutical distributor, have developed and maintained its EDW (Enterprise Data Warehouse) in Teradata DB. EDW is being loaded by ETL (Informatica) through scheduled loads.

Key operational data subject areas within this application include orders, invoices, inventory and brokerage.

This project involves development and maintenance activities of DWH ETL applications for Cardinal Health’s business segment Pharmaceutical Distributional and Provider Services (PDPS).This project includes development and maintenance of jobs which load operational and transactional data which is generated by day to day business activities such as accepting and fulfilling orders, from various sources systems such as SAP R/3, AS400, Oracle, and Flat Files into EDW.

Key Components and Contributions:

Extensive usage of different transformations in Informatica like Source qualifier transformation, Joiner Transformation, Aggregator Transformation, Sequence generator Transformation, Update Strategy Transformation, Filter Transformation, Router Transformation

Usage of advanced transformations such as Normalizer Transformation, Union Transformation, Joiner Transformation

Usage of Internal scheduler in Informatica to schedule jobs.

Develop scripts to kickoff Informatica ETL jobs; to schedule ETL jobs from external schedulers like Unicenter.

Extensive usage of Look-up transformations, connected & un-connected, Static& Dynamic.

Extensive development of workflows, worklets, sessions, command tasks.

Usage of various stages in Datastage to develop job as per requirements.

Usage of bulk loaders like MLoad to load large amounts of data into Data Warehouse

Analysis, design, programming, testing, and documentation as required for supporting the maintenance and enhancement of the data warehouse.

Close interaction with the client and vendors to capture the Functional requirements,

Defining the ETL Design for all the interfaces including generic error handling and audit routines.

Co-ordination between Offshore and Onsite Team.

Responsible for directing and monitoring the work of team members.

Coding, testing, modifying, debugging, documenting and implementation of ETL jobs using tools Informatica and Datastage.

Performance tuning of ETL Interfaces and Database queries.

Development of Unix Shell Scripts to format and FTP the data files.

Creation of new users, folders, repositories in Informatica

Customer/Vendor Data Feed

Title : Customer/Vendor Data Feed

Client : Cardinal health Inc

Environment : Informatica Power Center 7.1.3, HP-UX, Teradata V2R5, Oracle9i, DB2

Duration : October 2007 to Apr 2009

Role : ETL Developer

Team Size : 4

Description :

Cardinal Health has developed and maintained its EDW in Teradata DB. EDW is being loaded by ETL (Informatica) through scheduled loads. Cardinal Health will be supplying its customers/vendors with various data feeds on sales and purchases. This project is to develop and deploy Data feed jobs in Informatica for extraction from EDW based on business requirements. These jobs will be scheduled to run according to the customer requirements.

Key Components and Contributions:

Close interaction with the Business users and vendors to capture the functional requirements.

Preparation of Technical Specifications, Test cases, Design Documents, etc

Design, Develop and Deploy mappings and workflows in Informatica for the data feeds as per requirements.

Performance tuning of ETL jobs and Database queries.

Development of Unix Shell Scripts to format and FTP the data files.

Extensive usage of different transformations in Informatica like Source qualifier transformation, Joiner Transformation, Aggregator Transformation, Sequence generator Transformation, Update Strategy Transformation, Filter Transformation, Router Transformation

Extensive usage of Look-up transformations, connected & un-connected lookup, Static& Dynamic lookup.

Contact this candidate