Personal Email:phanee.babu@gmail.

com Mobile: (973) 572-4255

Office Email: [email protected] Office: (614) 355-3977

Phaneendra Pavuluri
Professional Summary
I have more than three (3) years of IT experience with experience in analysis, design, de-
velopment and installation of data warehousing applications using Object Oriented Analysis.
I also have three (3) years of experience in installation, configuration, development, and
performance tuning on multiple versions of SAP Business Objects Data Services/Integrator
(3.0/11.7).

My Business Objects Data Services/Integrator Experience includes experience in using Busi-

ness Objects Data Quality Management (Address Cleansing) tool while extracting data using
Data Services. I has configured and installed Business Objects Data Integrator XI and Job
Server on client systems. My Business Objects experience includes both full client and thin
client environments. I have created complex single point of entry reports by linking data
from multiple sources, using functions like slice and dice, drill down, and master detail. Ad-
ditionally, i have excellent analytical, problem solving; oral communication and team lead
skills, and can work in independently or in a team environment.

Operating Systems: Windows 2008/2003/NT/98, UNIX.

Languages: C/C++, PL/SQL, T-SQL.

Databases: Oracle 10 g/9i/8i, SQL Server 2000/2005/2008

Tools: Business Objects Data Services/Data Integrator XI/11.7

Business Objects XI 3.0/R2, Crystal Reports 2008, Xcelsius
2008

Related Skills: JAVA AWT, HTML, XML, JSP, IIS, DHTML

Star-Schema and Snowflakes Modeling, Erwin

Certifications: Oracle Certified Associate (OCA), SAP BusinessObjects Data

Integrator

Experience

Nationwide Children's Hospital, Columbus, OH May 2011 – Present

Sr. Data Services Consultant
 Loading data from clarity to oracle to build EDW.
 Resolving tickets raised by customer through magic system.
 Scheduling jobs to run daily nightly.
 Doing migration to the production every week on Monday to the changes done by me
or other developers regarding incidents or work orders raised by customers after re-
solving them.
 Doing production support and fixing the issues raised by the jobs while running in
production.
 Created Data Integrator mappings to load the data warehouse, the mappings in-
volved extensive use of simple and complex transformations like Key Generator, SQL
Query Transform, Table Comparison, Case, Validation, Merge, lookup etc.. in Data
flows
 Pavuluri Page 2
 Created Data Flows for dimension and fact tables and loaded the data into targets in
Data Warehouse.
 Tuned Data Integrator Mappings and Transformations for the better performance of
jobs in different ways like indexing the source tables and using Data_transfer trans-
formation.
Environment: Business Objects Data Services 11.7/3.2, Oracle 10g, Business Objects, Crys-
tal Reports.

International Rectifier, El Segundo, CA March 2011 – May 2011

Data Migration Consultant
 Migrated master and transactional data from legacy systems
(Vision,Oracle,ManMan,Fab3) to SAP ECC 6.0
 Created Data Integrator mappings to load the complete copy of the legacy systems
to a staging area.
 Created Data Integrator mappings to load the data warehouse, the mappings in-
volved extensive use of simple and complex transformations like Key Generator, SQL
Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data
flows
 Created Data Flows for cleansing master and transactional data.
 Used Data Quality transformations like US address cleansing for cleansing purpose of
the master data.
 Mainly involved in Vendor Master, Purchase Info records, Purchase order design in
BODS and loading in SAP using LSMW.
 Used SAP Best Practices AIO package in migration.
 Involved in defects tracking meetings and resolved all the defects which are raised in
different Mocks
Environment: Business Objects Data Services 3.2, SQL Server 2005, and SAP ECC 6.0.

Wipro, Syracuse, NY October 2010 – March 2011

Tech Lead DWH Management
 Designed technical architecture and documented technical requirements to be
needed for doing data migration.
 Installed Business objects Data services and configured different repositories (Local,
Central, and Profiler) and job server.
 Implemented security for Central repository by group and object level.
 Migrated master and transactional data from legacy systems (PeopleSoft FI,
PeopleSoft HR, Oracle SCM, Oracle FI, Fleet) to SAP ECC 6.0
 Created Data Integrator mappings to load the complete copy of the legacy systems
to a staging area.
 Created Data Integrator mappings to load the data warehouse, the mappings in-
volved extensive use of simple and complex transformations like Key Generator, SQL
Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data
flows
 Created Data Flows for cleansing master and transactional data.
 Used Data Quality transformations like US address cleansing for cleansing purpose of
the master data.
 Used SAP Best Practices AIO package in migration.
 Configured the mappings to handle the updates to preserve the existing records us-
ing History Preserve Transformation (Slowly Changing Dimensions Type-2)
 Tuned Data Integrator Mappings and Transformations for the better performance of
jobs.
 Involved in user training sessions for and assisting in UAT (User Acceptance Testing).
 Lead the team in understanding the scope of the project and what objects are to be
migrated.
Environment: Business Objects Data Services, Business Objects XI 3.0, Business Objects
Data Quality Management 12.0 /11.7, Oracle 10g.
 Pavuluri Page 3

Accenture, New York, NY March 2010 – October 2010

Sr. BO Data Services Consultant/Lead
 Involved in meetings with functional users, to determine the flat file layouts, data
types and naming conventions of the column and table names.
 Designed Conceptual, Logical, and Physical Data model design using Microsoft Visio.
 Worked on SAP BI Ondemand and scheduled Data integrator jobs using BI Onde-
mand to load the data from flat file source into SQL Server target tables in Content
Dev Environment.
 Written complex ETL scripts to get the flat files from the SFTP and to get the files
from SFTP to our local machine after loading successfully into Target tables.
 Created Data Integrator mappings to load the data warehouse, the mappings in-
volved extensive use of simple and complex transformations like Key Generator, SQL
Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data
flows
 Created Data Flows for dimension and fact tables and loaded the data into targets in
Data Warehouse.
 Configured the mappings to handle the updates to preserve the existing records us-
ing History Preserve Transformation (Slowly Changing Dimensions Type-2).
 Tuned Data Integrator Mappings and Transformations for the better performance of
jobs.
 Created aggregate tables, views using SQL for the reporting team.
 Involved in user training sessions for and assisting in UAT (User Acceptance Testing).
 Trained and lead the offshore in understanding the ETL jobs and designing the jobs.
Environment: SAP BI Ondemand, Business Objects Data Services, Business Objects XI 3.0,
Business Objects Data Quality Management 12.0 /11.7, Toad, SQL Server 2005,Microsoft
Visio 2007,WinSCP.

JP Morgan Chase, New York, NY May 2008 – December 2009

BO Data Services Consultant (Internship/Consultant)
 Gathered requirements from functional users, extracting data, building universes,
designing reports and dashboards as per the business requirements.
 Created Data Integrator mappings to load the SAP ERP and R/3 tables to Staging
area then to SAP Business Warehouse and Rapid Marts (Sales, Purchasing, Cost Cen-
ter, Accounts Payable and Accounts Receivable).
 Used parsing, correction, standardization, duplicate matching for arranging informa-
tion using Data Quality Management.
 Created Data Integrator mappings to load the data warehouse, the mappings in-
volved extensive use of simple and complex transformations like Key Generator, SQL
Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data
flows
 Created Data Flows for dimension and fact tables and loaded the data into targets in
Data Warehouse.
 Designed Summary and Aggregation tables according to the functional requirement
specifications and loaded data to support reporting.
 Configured the mappings to handle the updates to preserve the existing records us-
ing History Preserve Transformation (Slowly Changing Dimensions Type-2)
 Tuned Data Integrator Mappings and Transformations for the better performance of
jobs.
 Customized configuration of Business Objects Web Intelligence by fine tuning and
optimization for better performance.
 Created Cardinalities, Joins, Contexts and Aliases for resolving Loops, Traps and
checked the Integrity of the Universe. Analyze all tables and created various indexes
to enhance query performance.
 Involved in user training sessions for and assisting in UAT (User Acceptance Testing).
 Pavuluri Page 4
 Developed Xcelsius dashboards for presentations, live data dashboards with alerts,
Calculators, Historical data comparisons, what if analyzers for real time understand-
ing of changes in business and embedding of dashboards into webpage.
 Created Linked, Unlinked, Parameterized and On-demand sub reports for various
business needs, reports scheduled for different file based / schedule based events,
distributed in email, PDF and HTML format.
Environment: Business Objects Data Services, Business Objects XI 3.0, Business Objects
Data Quality Management 12.0 /11.7, SAP BI 7.0/BW 3.5, Visual Composer, SAP R/3 FICO
and SD, Crystal Reports, Xcelsius, Oracle 10g, SQL Server 2008.

Education
Master of Science, Computer Science, Stratford University
Bachelor’s Degree, Engineering

LinkedIn: http://www.linkedin.com/pub/phaneendra-pavuluri/15/bb6/9