Manager Data

Sreenivasa 717-***-****

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

Professional Summary

Over 12 years of experience working in IT industry with 11 years of experience in Data warehouse, data marts and ETL development, maintenance, testing, business requirements analysis, administration and documentation. Good experience in data ware house development in areas of health care, financial industry and Telecommunication.

Experience in Informatica 9.1/8.6/7.1/6.2 client tools - Designer, Repository Manager and Workflow Manager. Developed more than 200 mappings so far.

Extensive experience working with large scale OLAP & OLTP applications

Worked with the clients, users, business analysts and technical staff to design, develop and enhance Data Warehouse models, Business Intelligence solutions, scripts, Procedures and Metadata for relational databases.

Expertise in using various Active/Passive transformations like Joiner, Expression, Lookup, Aggregate, Filter, Router, Update Strategy, Sequence Generator, Source Qualifier and Stored Procedure transformations etc.

Extensive experience with Oracle/DB2/SQL Server SQL queries, PL/SQL procedures, functions, triggers and Packages etc.

Expertise in implementing complex business rules by creating re-usable transformations and Mappings/Mapplets.

Expertise in Unit Testing and Integration Testing Of the Application.

Experience in debugging and performance tuning of sources, targets, mappings and sessions.

Experience in integration of various data sources like Oracle, Flat Files, Excel, VSAM Files, Access, DB2 and XML files.

Strong experience with Star and Snowflake schema, dimensional data modeling, fact and dimensional tables & slowly changing dimensions.

Involved in Requirement Gathering, Analysis and Implementation by considering various business requirements/issues such as technical, security and performance.

Expertise in Folder/Mapping/Session/Workflow migrations and Repository administration.

Expertise in writing various Korn/Perl Scripts for ETL process in UNIX.

Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Technical Summary

Data Warehousing

Informatica Power Center 9.1/8.1/7.1/6.2, Power Mart 6.2/5.1.1/5.0 (Source Analyzer, Data Warehouse Designer, Repository Manager, Workflow monitor, Mapping Designer, Mapplet, Transformation Developer),Power Connect 7.x, OLAP, OLTP, SQL*Plus, SQL*Loader

Databases

Oracle 10g/9i/8.x/7.x, SQL Server 7.0,DB2, MS Access, Informix and Teradata V2R6

Reporting Tools

Cognos 8.5/8.4, Crystal Reports, Developer 2000 (Forms 4.5, Reports 2.5)

Data Modeling

Star-Schema Modeling, Snowflakes Modeling, FACT and dimension Tables, Erwin

Query Tools

Toad, SQL Navigator, SQL Assistant, Bentic

Languages

SQL, PL/SQL, XML, C, C++, Java.

Scripting languages

Unix-Shell Scripting, Perl, java Script, and VB Script

Operating Systems

Unix, SOLARIS, Windows XP/NT/2000/98/95

Networks

Windows NT, Windows 2000,Novell Netware

Internet Tools

HTML,DHTML,CSS, XML, ODBC

Packages

MS Office (MS Access, MS Excel, MS Visio, MS PowerPoint, MS Word)

GUI

Developer 2000, Visual Basic 4.5/5.0

Bug Tracking Tools

Bugzilla, Clear Quest.

Version Control Systems

VSS, CVS, Clear Case.

Application Servers

Web Logic 7.0/8.1, Web Sphere 5.1

Other

AutoSys, Control-M SAP B/W R3, LDAP, Opcon_ Scheduler, ATS

Professional Experience

Independent Health, Buffalo NY June ’2010 – Till Date

Informatica ETL Consultant / Informatica Production Support consultant

Independent Health Insurance Headquartered in Buffalo, New York, they are a not-for-profit health plan that continually aims to provide their community with innovative health-related products and services, which enable affordable access to quality health care.

Working as a core member of the Application Management Services team responsible for fixing the production related issues and also involved in the continuous improvements of the existing applications.

AMS team is responsible for all the production environment related issues involving the data analysis, root cause analysis, fixing the production issues and coordinating with different departments and business users in fixing and managing the production applications. Along with supporting production applications, 50% of work involves new developments and enhancements of Informatica ETLs.

Working as a senior ETL developer which involves creating Informatica ETLs using Informatica PowerCenter client tools

Responsible for creating the business requirement documents, high level & low level design documents, creating ETL specifications, test cases documents for all the new mappings developed for production applications in compliance with SDLC processes

Working as on call person for Informatica and Kalido DIW production issues on rotation basis

Responsible for fixing around 1500 production related issues which includes very complex data issues

Working as the primary person from AMS team related to transition of the new EDW implemented using Kalido DIW and MDM to AMS team

Responsible for interacting with and business analysts, business users, SMEs & technical architects whenever there is a need for the redesign of the existing ETLs and process improvements

Responsible for mentoring the new resources brought into the team

Responsible for review the code developed by other developers.

Developed SQL overrides in source qualifiers and lookup transformations according to business requirements

Implemented the application to move the obsolete Informatica objects from main folders to obsolete folder using the UNIX shell scripts

Implemented 50 new Informatica mappings as a part of automation of the existing monthly manual and new processes

Identified issues existed in Informatica mappings and worked on implementing the required changes in them

Worked closely with Cognos reporting team whenever there is an issue with data feeds to build Cognos cubes and reports.

Environment: Informatica PowerCenter 9.1/8.6, Oracle 11g/10g, IBM DB2, AIX UNIX 5.3, OS/400, DB2/400, Windows XP, Quest TOAD 9.0, Oracle SQL Developer, Visio 2003, Microsoft Project 2003, Microsoft Visual SourceSafe and SVN Version Control 1.6 and Cognos 8.0, Rational Clear Quest 7.0

Department of Public Welfare (DPW), Camp Hill, PA October 2008 – May 2010

Informatica ETL Consultant

The project is a state government project of PA – DPW. The project is a web based application. It's an application that provides the case workers to determine the benefits for applicants. All the information of state and federal agencies provide information on daily, weekly monthly and quarterly basis pertaining to income, health, eligibility, criminal justice etc to the IEVS systems (Income Eligibility Verification Systems) that has business logic that determines the eligibility.

When a new case or renewal is received, the case workers use information from external state and federal agencies to determine the benefit amounts for applicants. The web based data exchanges subsystem will provide the functions and capabilities for workers to manage their workload of exchange hits and dispositions.

Based on the functional requirements created technical design specification documents for ETL Process.

Responsible in building maps by uses various transformations like Source Qualifier, Expression, Aggregator, Rank, Joiner, Lookup, Update Strategy, Stored procedure Transformations based on the requirement from the end users.

Used Error handling strategy for trapping errors by using the error function in the mapping level and sending errors to an error table.

Responsible for creating, handling and taking care of Parameter File Modifications in new releases and enhancement.

Created Mapplets and reusable Transformations using Mapplet Designer, Transformation Developer for the Standardization of data as per the business requirements.

Wrote the PL/SQL procedures for data fixes.

Involved in Performance tuning at various levels including Target, Source, Mapping, Session level.

Involved in creation and running sessions, Workflows using Workflow Manager to load data into the Enterprise Data Warehouse( EDW)

Involved in developing and documenting data mappings, Transformations and Informatica Sessions.

Involved in monitoring the sessions, workflows and worklets using Workflow Monitor to ensure the data is properly loaded into the Enterprise Data Warehouse.

Involved in the error checking and testing of ETL Procedures using Informatica Session log and workflow logs.

Responsible for creation of reports and logs for the various jobs across the batch.

Used UNIX, Shell scripting to create scripts, monitor the target data files, log files.

Responsible for scheduling the workflows and monitoring them as per the requirement.

Responsible for code migration from DEV - SAT – TFP – PRD environments using information repository manager.

Responsible for extracting data from heterogeneous sources like Flat Files, COBOL, oracle, db2 and loading the same into Oracle and Teradata.

Developed Unix Shell scripts for data extraction and file transfers and also used PMCMD command to start the workflows.

Extensively used TOAD to test, debug SQL and PL/SQL Scripts, packages, procedures, triggers, and functions

Involved in creating the test cases and test plans for user acceptance testing and system testing based on functional Specifications.

Environment: Informatica Power Center 8.1/7.1.3,Oracle10g/9i,Unix,Mainframes, COBOL, Bentic, Toad, VSS, Teradata, DB2, SQL Server, Opcon Scheduler, XML Spy, Edit plus, PL/SQL, SQL, Shell Scripts.

Nationwide Insurance Co, Iowa January 2007 – September 2008

Data Warehouse Consultant/ETL Developer

Nationwide is one of the largest insurance and financial services companies in the world. This company offers a full range of insurance products and financial services for home, car, family and financial security. The Customer Policy Data Warehouse project was developed & designed in an effort to streamline the process of Auto Insurance and to keep track of various financials on a daily, weekly, monthly basis.

Responsible in building maps by uses various transformations like Normalizer, Source Qualifier, Expression, Aggregator, Rank, Joiner, Lookup, Update Strategy, Stored procedure Transformations based on the requirement from the end users.

Created Mapplets and reusable Transformations using Mapplet Designer, Transformation Developer for the Standardization of data as per the business requirements.

Wrote the PL/SQL procedures for data extraction, transformation and loading

Involved in fine tuning SQL overrides for performance Enhancements.

Involved in creation and running sessions, Workflows using Workflow Manager to load data into the Enterprise Data Warehouse( EDW)

Involved in developing and documenting data mappings, Transformations and Informatica Sessions.

Responsible for developing the mappings and workflows for claims and billing department for their day to day report activities.

Responsible for developing mappings that evaluate claims to ensure the applicants qualified for re-insurance benefits.

Responsible for developing mappings that confirms to business rules for claims to confirm coverage and to determine liability, compensability and to damages.

Responsible for developing mappings and workflows to Evaluate claims for potential fraud and makes referrals to the Special Investigations Unit as appropriate by generating emails to authorized personal.

Involved in building Oracle views and stored procedures using Toad.

Responsible for developing mappings to determine the business rule that determines if claims would qualify for the reinsurance coverage and its terms.

Involved in monitoring the sessions, workflows and worklets using Workflow Monitor to ensure the data is properly loaded into the Enterprise Data Warehouse.

Used UNIX, Shell scripting to create scripts in loading data from flat files to target files, monitor the target data files, log files.

Involved in manual testing, functional testing and Integration testing.

Responsible documenting the bugs during testing and reporting the same to leads and co-workers/peers.

Responsible for performing root cause analysis and reporting.

Environment: Informatica Power Center 7.1.3, Business objects 5.1, Oracle 8i, SQL Server, DB2, Erwin 4.0, UNIX Shell Scripts, PL/SQL, SQL, and WinNT4.0/2000.

Wells Fargo Bank, Chicago, IL July 2005 – December 2006

ETL Developer

Wells Fargo Bank is one of the largest financial companies in America, which offer a variety of financial products and services. The project was aimed at building a data mart for sales analysis and for making a data warehousing system to track the performance of the sales personnel of various Departments to assist them in their business Analysis.

Analyzed business requirements and co-coordinated with the business analysts to develop ETL procedures that confirm to the enterprise standards while maintaining consistency across all applications and systems

Involved in the extraction, transformation and loading of the data from various sources into the dimensions and the fact tables in the data warehouse

Involved in creating logical and physical data models using Erwin based on business requirements

Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer

Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy and Stored Procedure

Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.

Used Informatica scheduler to schedule Informatica jobs and checked Sessions/error logs in the Workflow Monitor.

Involved in performance tuning for Informatica sessions using partitions and SQL over ride in Source Qualifier

Used Informatica Version Control to check all versions of the objects used in creating the mappings, workflows and to track the changes in the development and test environments

Developed Unix Shell scripts for data extraction and file transfers and also used PMCMD command to start the workflows

Extensively used TOAD to test, debug SQL and PL/SQL Scripts, packages, procedures, triggers, and functions

Environment: Informatica Power Center 7.1, Erwin 3.5.2, PL/SQL, Oracle 8i, Windows NT 4.0, Toad, DB2, Shell Scripting.

Sprint, Kansas January 2004 – June 2005

Informatica ETL Developer

Sprint is one of the top Telecommunications Company with presence all over the United States. The main objective of the project was to build an enterprise data warehouse for the sales department. Informatica Power Center was used as an ETL Tool for implementing the extraction, transformation and loading of data into target warehouse databases.

Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.

Worked with source databases like Oracle, SQL Server and Flat Files.

Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer. Extensively worked with various Active and Passive transformations.

Used Sorter and Aggregator transformations in combination for performance tuning of aggregations used in the mappings.

Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks. Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.

Extensively worked with performance tuning at mappings level like implementing active transformation like filter as early as possible in the mapping. Worked extensively with update strategy transformation for implementing inserts and updates.

Performed error handling of sessions by using terse, normal, verbose initialization and verbose data tracing levels. Performed error handing using session logs.

Environment: Informatica Power Center 6.1 (Designer, Work Flow Manager, Work Flow Monitor, Repository Manager), Business Objects 5.1, Erwin 4.0, Oracle 8.x, Flat Files, UNIX Shell Scripting, UNIX, Windows 2000/NT.

TATA Insurance, India January 2003 – December 2003

Oracle Developer

This project was developed for TATA Insurance Company INDIA to serve their customers, agents and underwriters. The modules involved in this application are Submission of Proposals, Renewals, Negotiations, and Printing Documents for Insurance products Motor, Personal Accident, Tour Care, Home Care, Fire Accident, General Accident, and Family Care. Apart from this administration TATA Intranet users can control module.

Analyzed, designed & built business software application using Oracle RDBMS & GUI tools. Created entity relationship diagrams and tables using integrity constraints and Normalization. Prepared menu in Power Builder 4.0.

Designed program specifications & developed reports using Power Builder 4.

Wrote test plans and executed unit testing. Developed data models.

Implemented applications and prepared user documentation.

Provided technical support for the applications.

Environment: Oracle 7.1, Power Builder 4.0.

Education

Bachelor of Engineering – Computer Technology, Nagpur University, India, June 1995

Contact this candidate