Informatica/ETL/BusinessIntelligence/DataWarehousing

Appalaraju Vetsa (Raja)

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

862-***-****(cell)

862-***-****(home)

AREAS OF EXPERTISE:

Data Warehousing

Data Integration

Data Migration

ETL Architecture

Informatica Administration/Development

Data Modeling

Business Intelligence

Business Objects Development

Database Development

Oracle PL/SQL

UNIX Shell Scripting

SUMMARY:

? Certified Informatica and Oracle PL/SLQ professional with over 10 years experience in IT Industry with emphasis on design & development of Business Intelligence, Data Warehousing, Data Integration, System Integration, Data Migration/Conversion and Client-Server applications

? Experience in various Business Domains like Finance, Banking, Insurance, Investment Banking, Energy, Pharmaceutical, Healthcare, Telecommunications and Manufacturing

? Extensive experience and solid understanding of Data Warehousing, Data Marts, Dimensional Modeling, Star Schema, Snow Flake Schema Modeling, Data modeling, Entity-Relationship Modeling, OLTP and OLAP concepts

? Hands on experience in ETL/BI Architecture and Customized Design Strategies for client specific environments.

? Experience in leading ETL/BI Teams consisting offshore and Onsite Models.

? Experience in ETL/BI Effort Estimates for Development Life Cycle Management.

? Extensive experience in creating technical specifications, development, unit, assembly & system integration testing, production support.

? Experience in the installation, administration, upgrades, applying patches of Informatica Power Center environment versions 6.x/ 7.x / 8.1x/8.5.x/8.6; Experience in configuring the Domain, Node, Repository service, Integration service and Data Analyzer services on Dev, QA and prod environment; Experience in developing custom code promotion strategies and programs from Dev to QA to Prod environment

? Experience in Informatica Power Center in design, development, implementation, administration and support of ETL processes for large-scale data warehouse and integration projects

? Experience in production support, resolving on-going maintenance issues and bug fixes; monitoring Informatica processes, as well as performance tuning of mappings and sessions

? Experience in working with sources, targets, transformations, mapplets, mappings, sessions, workflows

? Experience working with Admin console, Repository manager, Designer, Workflow manager, Workflow monitor

? Experienced in UNIX shell scripting

? Extensive experience in working with SQL Queries and database programming using PL/SQL (writing Functions, Stored Procedures, Packages and Triggers etc)

? Worked closely with business users to define reporting requirements and documenting the requirements in order to design, develop and maintain Business Objects, Web Intelligence, OLAP Intelligence and Crystal reports.

? Extensive experience in Business intelligence Tools using Business Objects 5x/6x/XI R2/XI R3 Administration (Supervisor /CMC), Universe Design (Designer), Report development (Reporter /Desk I Web I), Import Wizard, Info View, Performance Manager, Dashboard Manager, OLAP Intelligence

? Design and develop Universes in Business Objects; resolve loops, chasm traps, fan traps; develop canned and adhoc reports as per business user requests; develop reports using free hand sql

? Experience in using various Data Providers like Universes, Free Hand SQL, Stored Procedures, XML Data Provider and Personal Data Files for retrieving data and creating Simple and Complex Reports

? Generated Sub Reports, On Demand Reports, Linked Reports, Cross Tab Reports and Graph Reports.

? Hands on experience in Migration from 5.x to 6.x and BO 6.x to BO XIR1, XIR2.

? Highly skilled, motivated team player, outstanding organizational skills and excellent communication and Inter-personal skills

SKILLS

ETL Tools: Informatica PowerCenter 8.6/8.5.x/8.1.x/7.x/6.x/5.x

EIM: Callidus 3.7.3

Databases: Oracle 11g/10g/9i/8i/7.x, Sybase 12.x/15.x, SQL Server 2000/2005, DB2, MS Access.

Reporting: Business Objects 5.x/6.x/ XI R1/XI R2, Cognos

Programming Languages: PL/SQL, T-SQL, Developer 2000, UNIX Shell Scripting, C, C++, Java

Operating Systems: UNIX, Windows 2000/NT/XP, MS-DOS

Data Modeling: ERwin

WORK EXPERIENCE:

Affiliated Computer Services, Little Falls, NJ

Data Management Group

Systems Development Supervisor

(ETL/BI Architect, ETL/BI Lead, ETL/BI Developer)

(May 2006 – Present)

Working on Census, Pension, Payroll, HIPPA. Pharmaceutical, HealthCare processes for various clients viz., Cigna, United HealthCare, ITT, Boehringer, GlaxoSmithKline, Exxon, Delta, Aetna, Safeway, Amgen, Lockheed Martin, Conegra, Corning, Bank of America, Sempra, Medco, Delta Dental, ATI, Morgan Stanley, Discover Financial Services, Safeway, Verizon etc.

Responsibilities:

? Review existing architecture, provide design solutions to complex business requirements, oversee architecutre and manage architecture changes and coordinate with data management technology team

? Manage installation, administration, upgrades, applying patches of Informatica Power Center environment versions 6.x/ 7.x / 8.1x/8.5.x/8.6

? Responsible for the development, implementation and support of the databases

? Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages

? Design and develop Universes; resolve loops, chasm traps, fan traps; develop canned and adhoc reports using Business Objects

? Manage core development team in U.S, also offshore resources in U.S, Malaysia and India Development Centers

? Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution.

? Conduct daily status meetings with the team members to coordinate and track tasks, address issues and problem resolution

? Train/Mentor team members, delegate workload, assign projects, assist with complex inquiries, review work, hold team meeetings, participate in the review process feedback.

? Maintain Informatica, Business Objects development/test/production environment i.e., Review Architecuture, Upgrades, maintain and oversee complete development, test and production environment.

? Design, develop and Informaica mappings and workflows; Identify and Remove Bottlenecks in order to improve the performance of mappings and workflows

? Review existing code, lead efforts to tweak and tune the performance of existing Informatica processes

? Maintain custom mapplets that will be used cross-clients;

? Create high level design documents, technical specifications, coding, unit testing, systems testing, perform post-production verification;

? Developed unit/assembly test cases and automated them using PL/SQL procedures and UNIX shell scripts to run along with daily/weekly/monthly batches to reduce or eliminate manual testing effort

? Design, develop Business Objects reports using free hand sql; Provide training to business users

? Develop documentation and assist with the transition to a production operations team

Environment: Informatica Power Center 6.x/7.x/8.1x/8.5.x/8.6, Oracle 9i/10g, Sybase 12.x/15.x, SQL Server 2000/2005, AIX Unix, Business Objects XI R2, IBM MF, SAS, Cybermation

Wisdom InfoTech,

ETL/BI Lead

(Aug 2001 – Apr 2006)

Wisdom Info Tech is a IT services firm providing value added software solutions and services to the clients, nationally, in virtually every industry and every computing environment. In addition to my programming skills, I was trained in ETL tools, Enterprise Intensive Management systems and worked on different Integration, Data Warehouse and EIM projects at client sites.

Projects:

UBS Financial Services, Stamford, CT

ETL Developer

Worked for UBS for a brief period of 4 weeks on a Hedge fund reconciliation project. Developed Informatica mappings/workflows, created PL/SQL procedures, created reports using Business Objects during my brief stint at UBS. Environment includes Oracle 9i, Inofrmatica PoweCenter 6.x/7.x

Hartford Insurance Group, Hartford Life, Simsbury, CT

Lead Developer

Description:

Hartford Life acquired a major line of business from the company C.N.A in Chicago, Illinois. A major step in acquiring this business required that the existing C.N.A. Disability (STD,LTD), Life, and specialty data be moved from their systems to Hartford systems. The objective of this project was to come up with the architecture and strategy necessary to move approximately 24 TB’s of data to both the Hartford Operational, Data Warehouse systems. We completed this huge task in three different projects i.e., Spiders Conversion, Reserving & Experience, Core Conversion

Responsibilities:

? Lead a team of developers in creating the Informatica mappings and workflows to move the C.N.A source systems (mainframe, flat file, Oracle) to a staging area, Hartford Life Case Management systems, Data Warehouse and other downstream systems

? Responsible for the analysis, designing and coding of the database

? Created Informatica sources, targets, reusable transformations, mapplets, mappings, sessions, worklets and workflows

? Designed Universes, generated reports using Business Objects; Created custom reports using free hand sql

? Involved in fixing the problems and improving the mappings and workflows.

? Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

? Involved in Unit, Assembly and System Integration Tests. Documented Unit & Assembly Test Scripts.

? Utilized Test Director to log defects. Responsible for triaging defects and disseminating the work to the development team.

? Responsible for providing status to higher management, Defect resolution time and impact to overall ETL schedule.

? Responsible for the design of the overall workflow batch design.

? Responsible for the migration of ETL code through the deployment process.

? Responsible for creating reports; Involved in performance turning of ETL processes, Report generation

Environment: Informatica Power Center 6.2/7.1.x, Oracle 9i, Business Objects, HP UNIX

Bank of America, Charlotte, NC

Senior Interface/Conversion/ETL Developer

Description:

The existing BAI sales force compensation processes and systems are no longer able to sufficiently support the needs of the business for responsiveness, flexibility, accuracy, and timeliness – all critical factors in maintaining a compensation plan that attracts and retains critical sales resources.

The objective of this project is address key problem areas that the business is encountering. The solution will include process changes and the acquisition and implementation of a new compensation application that better supports the business needs.

Responsibilities:

? Developed mappings and workflows to move the data from different stages i.e., staging, validation, TrueComp and DataMart.

? Developed mappings and workflows to transfer data from TrueComp to DataMart.

? Involved in fixing the problems and improving the mappings and workflows.

? Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

? Wrote PL/SQL procedures for processing business logic in the database.

? Involved in Unit, Assembly, SI Testing phases. Documented processing times, developed test cases and used them to run through each process. Tuned the matching parameters based on test results.

? Involved in production support. Monitored sessions that were scheduled, running, completed or failed. Debugged mappings for failed sessions.

Environment: TrueComp 3.7.3, Informatica Power Mart 6.2, Oracle 9i, SQL Server, Actuate, Windows NT

Mylan Pharmaceuticals

Sr. ETL Developer

Project: POS (Point of Sale) DataMart

We used to receive different retail link files from our various vendors on weekly basis. I was involved in designing the new structure and different aggregates needed as per the business requirement for the different account and Item level data. At the later stages was also given the responsibilities of installing and upgrading the Informatica server from PowerCenter Version 6.2 to PowerCenter 7.1.

Responsibilities:

? Involved in upgrading the Informatica PowerCenter from 6.2 to 7.1 Dev, QA and production environment.

? Identifying and Removing Bottlenecks in order to improve the performance of Mappings and Workflows

? Troubleshoot Informatica Server issues.

? Involved on designing the error handling strategies for Informatica to abort the job if one or more record fail to meet the business logic.

? Used partition table in order to improve the performance on the sales table.

? Extensively created mapping/mapplets, reusable transformations using transformations like Lookup, Filter, Expression, Stored Procedure, Aggregator, Update Strategy etc.

? Identify and Remove Bottlenecks in order to improve the performance of Mappings and Workflows.

? Dynamically creating parameter files with Database calendar tables and Unix shell scripting to determine runtime values like run date, run type, test or live run etc.

? Designed and developed Informatica workflow batches

? Extensively written shell scripts in order to automate the day-to-day batch load process.

? Extensively worked on SQL for reporting purpose and have some quality check steps to identify the quality of data loaded.

? Developed unit/assembly test cases and automated them to run along with daily/weekly/monthly batches to reduce or eliminate manual testing effort

? Developed functions, stored procedures, triggers to transform data and created indexes on tables to improve query performance

? Extensively worked on SQL for reporting purpose and have some quality check steps to identify the quality of data loaded.

Environment: Informatica PowerCenter 6.2/7.1, Oracle 9i, SQL Server, AIX UNIX

DataPro Infotech Systems, Visakhapatnam, India

Programmer Analyst

(December 1998 – June 2001)

Description:

DataPro is a software consulting Services Company that specializes in various areas like IT services, Product Design services, Business Process Outsourcing etc…

Worked for various clients in Pharmaceutical, Health Care Industries on various projects like Field Tracking and Customer Tracking System, Development of MIS Package, Integrated Medical Education System etc.

Responsibilities:

? Designed and developed views involving complex joins to multiple tables

? Involved in logical and physical design of Databases.

? Involved in the design of the database using Entity Relationship diagrams.

? Documented processing times, developed test cases and used them to run through each process

? Wrote triggers, functions, procedures and packages in PL/SQL.

? Involved in developing interactive forms and customization of screens using Forms 4.5.

? Involved in building, debugging and running forms.

? Designed and developed all the tables, views for the system in Oracle.

? Designing and developing forms validation procedures for query and update of data.

Environment: Oracle 8i/7.x, SQL*plus, PL/SQL, TOAD, SQL Navigator, Forms 4.5, Reports 2.5

EDUCATION:

M.S, Mechanical Engineering (Design), West Virginia University, Morgantown, West Virginia, U.S.A

B.S, Mechanical Engineering, Andhra University, Visakhapatnam, Andhra Pradesh India

Contact this candidate