Post a Job Sign in

Satish Annavarapu

Sr ETL/Lead Consultant at Business Intelli Solutions Inc

The Woodlands, TX

-

Work Experience

Sr ETL/Lead Consultant

Business Intelli Solutions Inc
-
Houston, TX
-

May 2010 to Present

Heading the team in proposing the load strategies and preparing the architecture for handling the data objects & proposals made for the efforts required to build and load strategies. 
• Developed Capability maturity model & Management process frame work. 
• Developed Quantitative maturity assessment & scoring model. 
• Execution and documentation for data process model and maturity as per the business functional design. 
• Generated Data Analysis reports, Quality reports using Informatica Data Exchange & Data Quality tools. 
• Proposed ETL functionality and architectures for different master data migration. 
• Extracting the data from Peoplesoft 8, Flat files & Orcale for SD & FI Objects and load them through Informatica. 
• Generated and Installed ABAP Program / SAP R/3 Code Using Informatica 8.1. 
• Created mappings Using Function Modules, BAPI, LSMW, IDOC'S. 
• Performed data cleansing activities like Data Enhancement, Parsing, Matching and Consolidation. 
• Developed the integration from i2 ERP to SAP and vice versa for SD Objects. 
• Loaded data into SAP 5.0 using IDOC'S, LSMW, BAPI and Function Modules. 
• Processing the IDOC'S manually in Sap 5.0. 
• Used BCI connect and upload the data into SAP thru Informatica. 
• Have supported the MM & SD Functional consultants in gathering the requirements and document them. Strong understing of SD & MM Modules. 
• Used different methods like BCI, BAPI, IDoc, Function Modules & DMI in informatica to post the data from Legacy system to SAP system for the objects like Sales Orders, Returns, Customers, Materials and Vendors etc & also BIW Cubes & SAP APO Cubes. 
• Developed ABAP Programs(reports) to upload the data/download the data. 
• Developed LSMW's to migrate the processed data from Informatica to SAP R3 for objects like EDI Partner profiles, Text, Sales Orders, POs. 
• Delivering the ETL solutions on time as per business requirements. 
• Involved in meetings with business users to gather the requiments and understanding the business 
• Helping the business users to make up the source files & formats which would be easier to feed them to process and migrate the data 
• Implementing the proof of concept oriented solutions and present them to the client 
• Worked on performance improvement in informatica to load the data into SAP 
• Migrating the ETL objects from Dev server to Test server and from test server to UVT server and to the production system.

Software Engineer / Programmer Analyst

Business Intelli Solutions Inc
-
Richardson, TX
-

November 2007 to Present

Sr ETL/Lead Consultant

Business Intelli Solutions Inc
-

January 2010 to May 2010

Responsibilities: 
* Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data. 
* Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework. 
* Involved into design the logical data model from the technical design documents and translating to a physical data model using ERWIN/ERstudio. 
* Develop ODS logical and physical data models. 
* Extensively Used Maestro third party tool to schedule the Informatica jobs and for cleansing, and scrub data using trillium. 
* Participate in the business analysis sessions to obtain requirements for the data model. 
* In-depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases such as Requirements, Analysis/Design, Development and Testing. 
* Extensively developed scripting for customized functions for Data Quality using DataFlux and also improved error handling functionality. 
* Exntensively worked on Data profiling on source systems and target systems for data quality and better data loading. 
* Interact with datamodeling, datasupport teams to get the enterprise data for High level specs. 
* Involved into gathering the attributes from different existing models, and write high level specifications for every data requirement. 
* Liaise with the business users and business analysts to clarify requirements and walk through data models. 
* Done Installation & Configure the Informatica Version 8.6.1, Migrate the Informatica jobs from Older version to new Vrsion Using Version Control. 
* The Load Ready File is loaded into Teradata Table using Teradata's ODBC/Bteq, Fast,Multi load connection. The Load Date and Load Time are also captured in the teradata table. 
* Using Pushdown Option and increase the system Performance.. 
* Worked with CDC option is captures databse changes ,forwarding them to powercenter for further processing. 
* Oracle CDC will only consume changes to base tables. Oracle Capture can capture SQL inserts, updates, and deletes made to the underlying base tables that support the materialized view, because that is what is logged to the Oracle redo log. 
* Using With CDC, data extraction takes place at the same time the insert, update, or delete operations occur in the source tables, and the change data is stored inside the database in change tables. The change data, thus captured, is then made available to the target systems in a controlled manner. 
* Done Security & User Management in Informatica environment. Managed multiple Informatica environments which involved maintaining users with specific roles and privileges on appropriate Folder permissions. 
* Informatica production server administrator for one of WAMU's marketing technologies datamart. 
* Informatica installation and upgrade of the repository from version 7.1.3 to version 8.5.1. 
* Actively involved in interaction with the Business users, Project Manage, Data Architect, DBA and UNIX admin for better management of production resources. 
* Informatica administrative tasks such as creation of nodes, integration services, repository services for enabling Extract, Transform and Loading (ETL) processes. 
* Involved into Creating the Java transformation to get the Objected data and transform to staging area. 
* Extensively used Xml source qualifier, Mid-stream XML parser transformation, Mid-stream XML generator transformations, as our main source type was XML Files. 
* Extensively used Dynamic Lookup transformation and Update Strategy transformation to update slowly changing dimensions. 
* Sources Like DTS Packages (connections, tasks, and workflows) that can be used to access, transform and manipulate a wide range of sources including text files and relational databases and load into warehouse.. 
* Worked on Version Control in Informatica to maintain multiple versions of an object, control 
* Created and used different tasks like Decision, Event Wait, Event Raise, Timer & E-mail 
* Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode. 
* Created database Triggers, Stored Procedures, Exceptions and used Cursors to perform calculations when retrieving data from the database. 
Environment: Informatica Power Center 8.6.1,8.x,PowerExchange, Java,J2ee, Erwin 6.0, Maestro, Netezza, DB2UDB, DataFlux, Clearcase, SQL Server 2005, T-SQL, DTS Packages, TeradaV2R6, Bteq,SQL*Loader, XML, DB2UDB, ERWIN6.0, ERStudio, Cognos 8.3, Unix Solaris10.

Sr ETL/Lead Consultant

Business Intelli Solutions Inc
-
Paris (75)
-

June 2009 to November 2009

Roles & Responsibilities: 
• Heading the team in proposing the load strategies and preparing the architecture for handling the data objects & proposals made for the efforts required to build and load strategies. 
• Developed Capability maturity model & Management process frame work. 
• Developed Quantitative maturity assessment & scoring model. 
• Execution and documentation for data process model and maturity as per the business functional design. 
• Generated Data Analysis reports, Quality reports using Informatica Data Exchange & Data Quality tools. 
• Proposed ETL functionality and architectures for different master data migration. 
• Extracting the data from Peoplesoft 8, Flat files & Orcale for SD & FI Objects and load them through Informatica. 
• Generated and Installed ABAP Program / SAP R/3 Code Using Informatica 8.1. 
• Created mappings Using Function Modules, BAPI, LSMW, IDOC'S. 
• Performed data cleansing activities like Data Enhancement, Parsing, Matching and Consolidation. 
• Developed the integration from i2 ERP to SAP and vice versa for SD Objects. 
• Loaded data into SAP 5.0 using IDOC'S, LSMW, BAPI and Function Modules. 
• Processing the IDOC'S manually in Sap 5.0. 
• Used BCI connect and upload the data into SAP thru Informatica. 
• Have supported the MM & SD Functional consultants in gathering the requirements and document them. Strong understing of SD & MM Modules. 
• Used different methods like BCI, BAPI, IDoc, Function Modules & DMI in informatica to post the data from Legacy system to SAP system for the objects like Sales Orders, Returns, Customers, Materials and Vendors etc & also BIW Cubes & SAP APO Cubes. 
• Developed ABAP Programs(reports) to upload the data/download the data. 
• Developed LSMW's to migrate the processed data from Informatica to SAP R3 for objects like EDI Partner profiles, Text, Sales Orders, POs. 
• Delivering the ETL solutions on time as per business requirements. 
• Involved in meetings with business users to gather the requiments and understanding the business 
• Helping the business users to make up the source files & formats which would be easier to feed them to process and migrate the data 
• Implementing the proof of concept oriented solutions and present them to the client 
• Worked on performance improvement in informatica to load the data into SAP 
• Migrating the ETL objects from Dev server to Test server and from test server to UVT server and to the production system.  
Project Title PepsiCo

Sr ETL/Lead Consultant

Business Intelli Solutions Inc
-
Irving, TX
-

November 2008 to May 2009

Roles & Responsibilities: 
• Heading the team in proposing the load strategies and preparing the architecture for handling the data objects & proposals made for the efforts required to build and load strategies. 
• Worked on Customer Objects for cluster 1 along with manufacturing plants data like Glasgow. 
• Involved in Extraction, Transformation and Loading of data using Informatica. 
• Extracted data from SAP 4.6, DB2, Flat files and Loaded into SAP 5.0. 
• Extracted data into Oracle data base from SAP 4.6 using SAP R/3 Tables, BAPI and Function Modules. 
• Generated and Installed ABAP Program / SAP R/3 Code Using Informatica 8.1. 
• Created mappings Using Function Modules, BAPI, LSMW, IDOC'S. 
• Performed data cleansing activities like Data Enhancement, Parsing, Matching and Consolidation. 
• Extracting the data from Peoplesoft 8, Flat files & Orcale for SD & FI Objects and load them through Informatica. 
• Developed the integration from i2 ERP to SAP and vice versa for SD Objects. 
• Loaded data into SAP 5.0 using IDOC'S, LSMW, BAPI and Function Modules. 
• Processing the IDOC'S manually in Sap 5.0. 
• 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 Manager. 
• Extracting Incremental data (Change Data Capture) from Source Systems using Informatica Power Exchange. 
• Analyzed the session, event and error logs for troubleshooting mappings and sessions. 
• Debugged the mapping in the Mapping Designer using the Debugger. 
• Created updated and maintained ETL technical documentation. 
• Involvement in Shell scripting & Perl Scripting. 
• Used FTP to move data from one server to another server. 
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance. 
• Making Code Reviews. 
• Extensively used Dynamic Lookup transformation and Update Strategy transformation to update slowly changing dimensions. 
• Worked on Version Control in Informatica to maintain multiple versions of an object, control development on the object and track changes. 
• Extensively utilized the Debugger utility to test the mappings. 
• Extensively worked on Performance Bottlenecks to improve the performance of the sessions and workflows. 
• Written SQL overrides in source qualifier according to the business requirements. 
• Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency. 
• Created and used different tasks like Decision, Event Wait, Event Raise, Timer and E-mail etc. 
• Used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode. 
• Created database Triggers, Stored Procedures, Exceptions and used Cursors to perform calculations when retrieving data from the database. 
 
Environment 
Informatica 8.5, 8.6 Informatica PowerConnect for SAP R3, SAP CRM, Informatica Power Exchange, Webservices, Informatica Data Stencil,Informatica Data Quality IDQ, Informatica Data Exchange IDE, Informatica Data Profiling, DB2 8.1, Toad 9.1, SAP R3 ECC 5.0 & Oracle 9i & 10g, UNIX 5.0 and Windows, Leech, Oracle client 10g, MS office 2003, Business Objects XI, SAP Netweaver, Siperian Master Reference Manager MRM, i2 DM, SCP, Oracle Data Integrator ODI

Sr ETL/Lead Consultant

Project Everest, Federal Mogul, MI
-

July 2007 to August 2008

Responsibilities: 
* Worked closely with business analysts to understand and document business needs for decision support data. 
* Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation 
* Imported various heterogeneous and homogenous sources to load data to the different interfaces and Data warehouse using Informatica 7.1 based on the business requirement. 
* Created Complex mappings using Unconnected Lookup, Aggregate, Normalizer and Router transformations for populating target table in efficient manner. 
* Involved in developing and testing of ETL, Informatica mappings, workflows, sessions using Informatica. 
* Data Modelling 
* Extracting the data from Peoplesoft 8, Flat files & Orcale for SD & FI Objects and load them through Informatica. 
* Involved in writing procedures, functions in PL/SQL. 
• Extensively worked on Siebel Analytics, SAP R/3 source system (ABAP Functional module) 
* Extensively worked on BAPI mappings and RFC enabled functional modules using Informatica Power connect adaptor 
* Used different methods like BAPI, IDoc, Function Modules & DMI in informatica to post the data from Legacy system to SAP system for the objects like Sales Orders, Returns, Customers, Materials and Vendors etc & also BIW Cubes & SAP BIW APO Cubes. 
* Used BCI connect and upload the data into SAP thru Informatica. 
* Developed ABAP Programs to upload the data. 
* Extensively used the transactions like BD87, SE10, SE11, SE16, SE37, SE38, WE 05, WE19, WE 20 Etc. 
* Developed LSMW's to migrate the processed data from Informatica to SAP R3 for objects like EDI Partner profiles, Text, Sales Orders, POs. 
* Extensively Worked on UNIX. 
* Written Unix Shell Scripting based on requirements. 
* Designed sessions using Workflow Manager and monitored using Workflow Monitor 
* Scheduled jobs using Unix based on schedule criteria provided 
* Involved in Unit testing of Mappings and Workflows and debugging mappings for failed sessions. 
* Created partitions, SQL over ride in source qualifier, session partitions for improving performance. 
 
Environment: Informatica 7.1, Erwin 4.1, Oracle 9i, Ms Access, UNIX Shell Scripts, XML, SAP

ETL Support Lead & Sr Developer

BP Retail DART
-

July 2005 to June 2007

British Petroleum (BP) is one of the largest oil producing companies. BP engaged IBM UK to conceptualize, design, develop and implement the SAP solution. The different components of the solution are SAP, SAP BW, Data Migration ETL based on Informatica/ MS SQL Server 2000. The ETL solution involves the design and development of multiple sets of Informatica mappings to populate the SAP BW. The mappings have complex transformation logic to convert varied Source System Data to Staging Data and the Staging Data to Warehouse Data. The assignment was executed in an onshore-offshore model, the actual development activity being based at Kolkata, India. 
 
CLIENT DESCRIPTION: 
British Petroleum is a global leader in retail market across various countries like US, UK, Poland, Australia & New Zealand etc. They have got branches & franchisees in US & in European market. They sells Fuel products includes gas, petrol etc and non fuel products includes cokes, chocolates, cigarettes etc. They offer discounts on sales & promotions on articles for entire sales in BP Retail outlets. 
 
Responsibilities: * Leading of 8 member size team and proposing new strategies, monitoring the jobs. 
* Data Modeling 
* Involved in writing SQL Stored procedures to access data from Oracle 7.3. 
* Developed SQL queries to check the database. 
* Creation of Triggers, Stored Procedures, Tables, Indexes, Rules, Defaults etc. 
* Interaction with users and getting the enhancement requirements. 
* Implementation and maintenance of the product in client sites. 
* Performance tuning of SQL queries and Stored Procedures. 
* Involved in conducting the Functional, Regression and Integration testing. 
* Involved in stress and volume testing of the application. Developed Informatica objects for the countries like USA, NL, Australia, Poland & UK. 
* Preparation of Technical Design document, UTC, UTP, Test Data, Actual Results of different interfaces. 
* Interaction with the client & offshore team on various issues. 
* Preparation of various technical design documents and support spreadsheets. 
* Migrating ETL Objects from Development server to Test Server, Test Server to UVT Server, UVT Server to Production Server. 
* Extensive used Informatica to load source data from file systems to ODS and SAP BW, R3 & POSDM using Informatica Power Connect. 
 
Environment: MS SQL Server, Oracle 7.3, SQL, Shell scripts, HP 9000, Windows NT 
 
Project Title: BSkyB

ETL Developer

BSkyB
-
UK
-

January 2005 to July 2005

PROJECT DESCRIPTION: 
British Sky Broadcasting (BSkyB) is one of the largest digital channel operators in UK. BSkyB engaged IBM UK to conceptualize, design, develop and implement the CRM solution for their customers opting for paid services. The different components of the solution are CRM based on Chrodiant/J2EE, ETL based on Informatica/Oracle, Message oriented Middleware development based on IBM MQSeries and Debt Management System based on Java/J2EE. The ETL solution involves the design and development of multiple sets of Informatica mappings to populate the CRM Data warehouse hosted on Oracle RDBMS and its associated Staging Area/ODS. The mappings have complex transformation logic to convert varied Source System Data to Staging Data and the Staging Data to Warehouse Data. The assignment was executed in an onshore-offshore model, the actual development activity being based in Kolkata, India. 
 
CLIENT DESCRIPTION: 
British Sky Broadcasting (BSkyB) is one of the largest digital channel operators in UK. British Sky Broadcasting (BSkyB - formerly two companies, Sky Television plc and British Satellite Broadcasting) is a company that operates Sky Digital, the most popular subscription television service in the UK and Ireland. It also produces TV content, and owns several TV channels. It is 36.8% owned by News Corporation, an American company chaired by Rupert Murdoch, who also acts as Chairman of BSkyB. For the year to now BSkyB had turnover in billions, and made a profits in millions after tax. At Dec 2005 it had 8 million direct to home customers, although this figure included all subscribers of Homechoice, Kingston Interactive Television and every other "Sky By Wire" IPTV service in the UK and Ireland. 
 
RESPONSIBILITIES: 
• Data Modeling 
• Requirement Study and understanding business logic using the Functional Specs. 
• Interacting with client on various issues. 
• Developing the interfaces using Informatica Mappings, Sessions & Workflows. 
• Developing Informatica mappings and also tuned them for better performance. 
• Transformations like Source Qualifier, Aggregator, Expression, Update strategy, Lookup, Filters, Stored procedure, Router are mostly used as part of coding. 
• Preparation of Technical Design document, UTC, UTP, Test Data, Actual Results of different interfaces. 
• Transportation of objects from Dev Server to Test Server. 
• Worked on various TPR's (Test Program Reports). 
 
Environment: 
Informatica 6.2.1 & Oracle 7, Oracle 8i & Oracle 9i. 
 
Project Title: Examination processing system

Programmer

DGMS
-
Dhanbadh, IN
-

July 2004 to November 2004

PROJECT DESCRIPTION: 
Directorate-General of Mines Safety is an autonomous body under the Ministry of Labor & Rehabilitation, Government of India. They conduct examinations related to mines safety throughout India. The software will cater the organization with various types of student databases to provide fingertip information for various types of users. The system will generate various types of reports for different levels of management. Automated certificate and document generation modules to be provided to competent personnel connected with the mining & metalliferous industry. 
 
CLIENT DESCRIPTION: 
By drafting appropriate legislation and setting standards, by overseeing compliance thereof as intensively as its resources permit and through a variety of promotional initiatives and awareness programmes the officers of DGMS exercise preventive as well as educational influence over the mining industry. DGMS is also promoting the concept of 'self-regulation' as well as 'workers' participation in safety management' and, with changing scenario, attempting to superimpose its traditional role of seeking compliance by legal sanctions and work prohibition optimally with advisory and other safety promotional initiatives, thereby creating an environment in which safety is given due priority.. 
 
RESPONSIBILITIES: 
• Requirement Study and understanding business logic. 
• Designing Tables & Views and developing Procedures, Functions, Triggers. 
• Designing Forms, Reports and Advanced User Interfaces. 
• Interacting with client on various technical issues. 
• Working in Post Go-live support with the aim of On-Site Customization. 
 
Environment: 
Oracle 8i, Oracle Forms 6i & Reports 6i. 
 
Project Title: Soft Smith

Software Programmer

Smart Software Solutions
-
Reston, VA
-

September 2003 to November 2004

from July 14 2007 to Oct 31 2007

Developer

Mohammad Khan Jewelers
-
Hyderabad, Andhra Pradesh
-

March 2004 to June 2004

PROJECT DESCRIPTION: 
This project objective is to automate the existing sales & Inventory system, and to provide valuable information, relevant to sales & inventory, Customer billing, salaries to employees etc and daily status reports, sales transactional reports, etc and to decrease the manual work in carrying out general transactions. 
 
CLIENT DESCRIPTION: 
Mohammad Khan Jeweler sales gold ornaments. They design and create new ornaments and sells to the customers. They have got branches across different places and the main branch is at Hyderabad. 
 
RESPONSIBILITIES: 
• Involved in Analysis, design, development, deployment phase. 
• Created Database tables and Stored Procedures. 
• Used Data Access Object (DAO) in creating connection with VB 6.0 to Oracle 8. 
• Responsible for coding in VB6.0 
• Developed Test cases for Integration testing and Unit Testing 
 
Environment: Visual Basic 6.0 and Oracle 8.0. 
 
Project Title: Production Management System

Programmer

Amani Alumns
-
Visakhapatnam, Andhra Pradesh
-

September 2003 to February 2004

PROJECT DESCRIPTION: 
This project objective is to automate the existing system, and to provide the following valuable information, relevant services to the managers who are part of Amani Alumns and to decrease the time in processing the daily production transactions and to decrease manual work in order to prepare various kinds of reports and graphs of their production. 
 
CLIENT DESCRIPTION: 
Amani Alumns is leading company in chemical production based at Vizag. They produce chemicals, glycerins, plastics, soaps and oils. They have tie-ups with Vizag steel plant and other production centers across India. 
 
RESPONSIBILITIES: 
• Involved in Analysis, design, development, deployment phase. 
• Created Database tables and Stored Procedures. 
• Used Data Access Object (DAO) in creating connection with VB 6.0 to Oracle 8. 
• Responsible for coding in VB6.0 
• Developed Test cases for Integration testing and Unit Testing 
 
Environment: Visual Basic 6.0 and Oracle 8.0.

Education

Master of Computer Applications

Indira Gandi National Open University

December 2003

Advanced in Computer Applications

Indira Gandhi National Open University

June 2003

Bachelors in Computer Sciences

Nagarjuna University

March 2003

Additional Information

Technical Skills 
 
ETL Tool Informatica Powermart/PowerCenter8.6,8.5.1, 8.1.1/7.1.4/6.x/5.1, 
Power Connect, Informatica Power Exchange, Informatica IDQ 
Databases Oracle 7.x/8.x/9i,10g, MS SQL Server 2000, Sybase, DB2, Teradata 
Database Utilities/ Tools SQL Plus, SQL Loader, Toad, SQL Navigator, Rapid SQL, PLSQL Developer, SQL Advantage,Teradata V2R6 
OLAP/DSS Tools COGNOS (Impromptu6.1, Transformer and Power Play 6.1), 
Business Objects6.5.1 (Supervisor, Designer, Business Objects) 
Languages/ Packages C, C++, Java, Visual Basic, VB-Script, DHTML, HTML, ASP, Perl, SQL, PL/SQL, Shell Scripting (Csh, Ksh) 
Operating Systems UNIX, Windows XP /2000/NT /98 / 95 
Data Modeling Tools ERWIN 6.0