Manager Data

SUREN REDDY ********.*******@*****.***

Mobile: 240-***-****

Professional Summary:

A dynamic professional with 5 years of IT experience in System Analysis, Business Analysis, Database Design,

DW Development, Testing, Implementation and Integration of various Data Warehouse Systems and Business

Intelligence Applications on Client-Server, SOA and Mainframe environments.

DWH: Have strong experience in Design and Implementation of Data warehouse Methodologies like Ralph

Kimball and Inmon in Implementation of ODS, EDW and Metadata Repositories.

Informatica: 5 years of Data Warehousing experience using Informatica Power Center 9.0.1/8.6.1/8.1./5.1,

Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse

Developer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet

Developer, and Workflow Designer. OLAP, OLTP, Autosys, Control M, Strong experience in designing and

developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, and

legacy system files.

Data Modeling: Strong Dimensional Data Modeling experience worked on Erwin 4.5 for designing the

Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT &

Dimensions tables, Physical & Logical data modeling.

Databases: Extensively worked on Oracle 10g/9i/8i/7.0 DB2 8.0/7.0/6.0, MS SQL Server 2005, Teradata V13.

Experienced in integrating data from various Heterogeneous sources (Relational database, SIEBEL, Flat Files,

XML Files, COBOL Files, Excel) into Data Warehouse and Data Mart.

Worked on operating systems UNIX, Linux and Windows. And have experience in Informatica and Business

Objects Administration and strong experience in installing in windows, Unix environment.

Unix: Have very good experience in Writing Shell Scripts. Strong testing experience on UNIX based

applications.

Production Support – Done extensive 24x7 production support and issue resolutions.

Offshore Team Co-ordination – Onsite-offshore co-ordination experience and well versed with off-shore teams

ensuring timely and quality results.

Have an excellent quality of adapting to latest technology with Analytical, Logical and Innovative knowledge to

provide accurate software solutions.

Excellent in Documentation, End-User Training, Knowledge Transfer and Production Support .

Certifications:

• Certified Informatica Developer.

• Certified in IBM Business Intelligence Solutions V8.1.

Education:

• Master of Computer Application from SV University.

• Master of Business Administration from Alagappa University.

• Bachelor of Science (Computer Science) from SV University.

Technical Skills:

Informatica Powercenter 9.0/8.6/8.1 (Repository Manager,

ETL Tools

Designer, Work Flow Manager, Work Flow Monitor) Informatica

Data Quality, DataStage 7.5 (Manager, Designer, Director),

Oracle 10g/9i, MS SQL Server 2000/2005/2008, IBM DB2 UDB

Databases

7.0, Teradata, TOAD

Job Scheduling/BI BMC Control M, Cognos8, Business Object XIR2

Tools

Data Analysis Requirement Analysis, Business Analysis, detail design, data flow diagrams,

data definition table, Business Rules, data modeling, Data Warehousing,

system integration.

Programming UNIX Shell Scripting, C, C++, SQL, PL/SQL, XML.

Skills

Environment Sun Solaris 2.8/8.0, HP-UX 10.20/9.0, IBM AIX 4.2/4.3,Linux, MS DOS 6.22

Project Profiles:

Lincoln Financial Group Sep ’11 to till date

Sr.ETL Developer

Lincoln Financial Group is a diversified financial services organization with a strong focus on four core business areas -

life insurance, annuities, defined contribution, and group protection;

Role:

• Involved in gathering requirements and source system analysis and involved in data modeling.

• Designing & documenting the functional specs and preparing the technical design.

• Prepared low level design documents establishing mappings between sources and targets.

• Involved in Design Specifications and technical Sessions.

• Extracted data from DB2, flat file, VSAM files and load into the Oracle data base and used Java transformation to

load into SOLR web services.

• Developed ETL Mappings, Sessions, and Workflows using various transformations like Update strategy, Lookup,

Filter, Router, Joiner, Java etc.,

• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting

existing ETL bugs.

• Developing several complex mappings in Informatica.

• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get

best performance by decreasing the run time of workflows.

• Prepared test cases and involved in unit testing of mappings, system testing and user acceptance testing.

• Involved in Initial loads, Incremental loads; Daily loads to ensure that the data is loaded in the tables in a timely and

appropriate manner.

• Created the Data flow Diagrams for the full run and the reprocess partial run for the workflows to be created in

Informatica taking into point the dependencies using Microsoft Visio.

• Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions .

• Written documentation to describe program development, logic, coding, testing, changes and corrections.

• Performed Unit testing, Integration testing and System testing of Informatica mappings.

• Extensively worked on the AUTOSYS scheduling tool and created JIL files.

• Involved in production support to make sure all issues are fixed in the respective turn-around times.

Environment: Informatica Power Center 9.1, Oracle11, DB2, Erwin. UNIX, Autosys, SOLR

Polo Ralph Lauren July ‘10 to Aug ‘11

Senior Informatica Consultant

Polo Ralph Lauren is a leader in the design, marketing and distribution of premium lifestyle products in four categories:

apparel, home, accessories and fragrances.

Responsibilities

• Informatica migration from version 5.1 to 8.6

• Migrated mappings from 5.1 to 8.6 and created workflows in 8.6

• Redesigned informatica mappings after importing into 8.6, based on the change request.

• Used Expression, Router, Lookup, Update strategy, joiner transformation based on the change requests.

• Involved in regression testing and did data validations.

• Prepared test cases and involved in unit testing of mappings, system testing and user acceptance testing.

• Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist

and Program Specifications or Technical Specifications.

• Created solution documents for developed mappings.

• Documented all the migrated mappings and newly created mappings.

• Developed Unix shell scripts.

• Performed Unit testing, Integration testing and System testing of Informatica mappings.

• Worked as onsite co-coordinator for the offshore team.

Environment Informatica 8.6.2/5.1, Oracle10g, Teradata V12, Control-M, IBM AIX, Suse Linux

Bank of America - Merrill Lynch, Hopewell, NJ Aug ‘09 to June ‘10

ETL Developer

HFDMG – Worked for Hedgefund domain data management group in their implementation of ETL for Loading various

feeds from various places.

Data Processing is developed in two components involving data load feeds i.e. File Preprocessor and Informatica

feeds. File Preprocessor monitors the Source dictionary to check if any file is dropped for data load which is further

moved to Informatica UNIX server through FTP. Informatica workflow then processes this file and loads the data in the

database.

Role:

• Gathering of user requirements and source system analysis and establishing mappings between sources and

targets.

• Involved in Informatica product suit installation.

• Extensively worked with Informatica – Source Analyzer, Warehouse Designer, Transformation developer, Mapplet

Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and

Informatica server to load data from flat files, legacy data.

• Implementation of Informatica Best Practices including naming standards for mappings, workflows, and

transformations.

• Developed ETL Mappings, Sessions, and Workflows using various transformations like Update Transformation,

Lookups, Filters, Routers, and Joiners, web services, XML etc.

• Involved in product installation, product code migration, testing defect resolution, and initial data loads.

• Created different source definitions to extract data from flat files, XML and relational databases.

• Configured the mappings to handle the updates to preserve the existing records using Update Strategy

Transformation.

• Extensively used various transformations like Filter, Router, Sequence Generator, Look Ups, Update Strategy,

Joiner, Source Qualifier, Expression, Sorter and Aggregator.

• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads

• Performance tuning of the process at the mapping level, session level, source level, and the target level.

• Involved in Code Review, UAT and migrated mappings from dev environment to production.

• Creating solution documents for developed mappings.

• Involved in regression testing, Smoke testing, SIT.

• Involved in Design Specifications and technical Sessions.

• Involved in preparing product profile and system structure documents.

• Schell Scripts are developed and implemented for Running Various components for the system

• Optimizing / Tuning mappings for better performance and efficiency

• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.

• Migrated Informatica mappings, sessions and workflow from development to QA and QA to Production

• Monitor production loads daily, monthly and quarterly

• Monitoring the Informatica feeds every business day at 5:00PM EST in production.

Environment: Informatica Power Center 8.6 (Repository Manager, Designer, Workflow Manager, and Workflow

Monitor), Informatica Data Quality 8.6, MS .Net 2.0, Sql Server 2005, UDB DB2.

Aug ‘08 to April

du, Emirates integrated telecommunication company, UAE ‘09

ETL Application support analyst

du, Emirates integrated telecom service provider in the UAE, launched mobile telecommunication services on 11

February 2007 across the UAE in addition to internet and pay TV services in some of the free zones of Dubai. It is

growing at an impressive rate, which in three years increased to 2.5 million subscribers. du business offers include

Closed Business User Group and preferred International Destinations. du was recognized as the ‘Best Brand’ for its

innovative branding and outstanding success at the Telecom World Awards Middle East 2007.

The scope of the project is to develop Enterprise Data Warehouse for du. The source systems are BSCS, Billing

Mediation (HP IUM), IN platform (eserv), ERP, SIEBEL CRM and PGWay. The extraction processes are Hourly, Daily,

Weekly and Monthly as well. ICS is used to manage and control the data integration environment for day-to-day

activities.

Responsibilities:

• Analyses of the Requirements laid down by the users and thus assisting in development of the warehouse.

• Data Analysis for the existing data warehouse to ensure that no data loss or rejections have occurred impacting

the Business during the daily load process.

• Supporting the daily warehouse load process and troubleshooting the issues identified in 24*7 processes.

• Carrying out Impact Analysis for any new changes being pushed to Production.

• Oracle, Flat files are used as sources, Target-Oracle.

• Prepared run book with daily load errors and their solutions for the future correspondence in order to reduce the

frequent failures.

• Worked in partnership with Project Manager, developers, and other database engineers to design and deploy

new data warehouse products & solutions.

• Worked with session logs, Informatica Debugger, and Performance logs for error handling when we had

workflows and session fails.

• Migrating developed maps to Test and Production environment.

• Worked with source systems like SIEBEL and BSCS (Postpaid Billing application) applications .

• Looking for areas for improvement in the warehouse with respect to Performance on the Application side.

• Participated in product release process, determine impact to existing DW and OLTP systems and complete

code rollout by working with other operation support / Development team.

• Involved in preparing the daily load reports and technical issues.

• Worked with DBA team for database related performance tuning, database tuning and capacity planning.

• Liaise with other Source System teams for issues related to Data Quality, Metadata changes or any other

changes impacting the DWH.

• Involved in System Integration Testing.

• Application tuning and performance monitoring, Setup and maintain documentation and standards, Planning

growth and changes.

• Migrated data from legacy systems.

• Prepared daily load error report and solutions.

• Solving the tickets raised by call center people.

• Managing Users on Business Objects.

Environment: Informatica Power Center 8.5.1 (Repository Manager, Designer, Workflow Manager, and Workflow

Monitor), Oracle 10g, HP UNIX,HP Openview, Teradata V2R5, SAP, Windows 2003 Server.

Jun ‘07 to Oct ‘08

Compass Bank, Alabama, USA

ETL Developer

Compass Bank is a Sunbelt-based financial institution which operates 420 full-service banking centers including 166 in

Texas, 90 in Alabama, 76 in Arizona, 44 in Florida, 33 in Colorado and 11 in New Mexico. Compass Bank is a subsidiary

of Compass Bancshares, Inc., a wholly-owned subsidiary of BBVA. In this project we have thirteen sources like SBA,

DFP, LEA, AFS, LEM, RM etc. For each source we developed mapplets and mappings.

The main objective of the project is to successfully integrate customer information from 13 data sources (coming

from different countries throughout the world) of Compass’s external foreign data sources into the developed data hub

and to utilize this data and produce data sets which will be delivered to a scanning server World Check, which maintains

a database of high risk individuals and entities.

Responsibilities:

• Used Informatica Power Center 8.1.1 for extraction, loading and transformation (ETL) of data in the data

warehouse.

• Extensively used various transformations like Filter, Router, Sequence Generator, Look Ups, Update Strategy,

Joiner, Source Qualifier, Expression, Sorter, and Aggregator.

• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads

• Worked with slowly changing dimension Type1, Type2, and Type3.

• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded

in the mappings.

• Created reusable transformations and mapplets and used them in mappings.

• Extracted data from flat file, RDMS, Legacy AS400, and VSAM files.

• Implemented Informatica recommendations, methodologies and best practices

• Created sessions, workflows and worklets using workflow manager.

• Worked on Informatica Designer to modify mappings to update the existing code resulting from review

comments.

• Used Expression, Normalizer, Update strategy transformations.

• Worked on Lookup, Router, Unoin, Joiner Transformations.

• Involved in Unit testing, and running workflows.

• Written documentation to describe program development, logic, coding, testing, changes and corrections.

• Worked extensively with the business intelligence team to incorporate any changes that they need in the

delivered files.

Environment: Informatica 8.1.1, (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle

10g, Windows XP, Sun solaries UNIX, DB2.

Training and Seminars:

• Trained on Teradata.

• Trained on Cognos 8.0.

• Participated in National Level conferences on different computer technologies.

0

Contact this candidate