 Total Experience: 6 Year(s) 0 Month(s)

 Annual Salary: Rs 7.0 Lac(s)

Kiran Kumar
E-mail: kumarsbobi@gmail.com
Contact: 9014935254
Hyderabad.

Summary
 6.2 Years of experience in Design, Development, Data Warehousing, documentation and implementation of
the software in Six Sigma approach.
 Managed both offshore and onsite-offshore project delivery models
 Managed team with 6 members.
 Extensively worked on Business Objects 5.x/6.x/XI/R2/XI3.1/4.0 Designer, Reporter, Deski Webi and Crystal
Reports.
 Knowledge on Supervisor, CMC, CMS and CCM.
 Worked on Business Objects XI 3.1 Integration with SAP BI and SAP R/3.
 Having work experience on BO Data Services
 Having working experience on Crystal Reports2008 and Xcelsius2008.
 Extensively worked on Informatica7.1.1/8.5 (Source Analyzer, Warehouse Designer, Transformation
Developer, Mapplet and Mapping Designer).
 Having working experience of methodologies like Star Schema and Snowflake Schema.
 Knowledge in Oracle 10g & 9i, SQL Server and OBIEE, Microstrategy8.0.2.
 Have good communication skills, interpersonal relations, hardworking and result oriented as an individual
and in a team
Experience
• Working as a Sr. BO Consultant in IBM, Hyderabad from Sep’13 to Till Date.
• Worked as Software Engineer in TATA Consultancy Services(TCS), Bangalore from Jun’2008 to Aug’2013.
Educational Qualifications
 MCA from Nagarjuna University with an aggregate of 70%

Technical Profile:

 Reporting: SAP BO 4/3.1/R2/6.X/5.X, Crystal Reports2008 & Xcelsius2008, Dashboards, Live

Office 2010
 ETL: Informatica, BODS,SSIS
 Data Modeling: CA Erwin Modeler
 DB : Oracle, Teradata, SQL Server,SAPBI
 Others: Windows 9x/2000/XP/7, UNIX, MS DOS

Trainings:
Attended training on Data Warehousing tools BODS, OBIEE, Informatica, BusinessObjectsXI4.0, Microstrategy
 and SAP BI7.

Project Experience:
Catalyst-Phoenix, UK www. britishgas.co.uk
SAP BO Lead / Sr.Developer
British Gas serves around 12 million homes – half the homes in Britain and nearly 1 million businesses.
This is both a strength, and a responsibility. Service excellence is critical and will remain at the heart of all our offers.
Our challenge in 2012, as an energy industry, is to continue to work hard to win our customers’ trust. We are leading
the way – working with our customers to change British Gas for the better.
Smart energy technologies are about making people more aware of their energy consumption. At the
forefront of these technologies are smart meters, which provide real-time information on energy use to the customer.
British Gas is an industry leader in the installation of smart meters and has already fitted more than 80% (453,907) of
the UK's total. Our work so far indicates that having access to energy use information facilitates behaviour change
among consumers, with 80% of our customers stating that smart meters have made them think differently about
their energy use and 64% saying that they have undertaken energy efficiency improvements in their home since the
smart meter installation.
The market for electric vehicles continues to grow with manufacturers offering a range of electric cars and vans.
British Gas is supporting the emergence of electric vehicles and is the preferred supplier of home and work charging
stations for Nissan, Renault, Toyota and Hitachi Capital. We're on track to be the largest installer of electric vehicle
charging points in UK homes, supporting 70% of the domestic market in 2012.

Key Deliverables: Phoenix Phase1, Block Tariff, GludadBGDW, Nector, Catalyst MI Debt Wizard, Catalyst MI PPP
(Products, Pricing and proposition) (Using Business Objects, TeraData and SAPBI Queries).

Responsibilities:
 Interacting with clients and gathering the requirements.
 Working on Design of the project along with the onsite team leader.
 Working as Team Lead for 6 members Team.
 Working closely with SAP BI team to understanding the SAP BI Cubes and Queries.
 Working for the development of POC for the project to showcase to the client.
 Developed, Tested and Deployed SAP Universe, Web Intelligence Reports as per specification.
 Converted Data stage Jobs to BODS jobs.
 Converted Deski Reports to Webi Reports using Report Conversion tool
 Migrated BOXI3.1 to BOXI4.0

Environment: Business Objects XI3.1/4.0, Crystal Reports2008, Xcelsiues2008, SAP BI, SAP GUI, SAP R/3, MS-Excel
and Windows XP.

UFO WFE Portal,U.S www.att.com

SAP BO Lead / Sr.Developer
Description:

The Portal will be a single source web application for U-verse Field Operations (UFO) Technicians to perform any and
all mechanized work functions as it specifically relates to the installation and repair of U-verse, DSL, IP-DSL and U-
verse helper tickets. The concept is to provide a consistent and streamlined process for technicians while significantly
reducing task/job cycle times.

This project will be collectively shared between network operations (UFO and LFO), Care (T1 and T2 agents) and on-
line services. Our intention is to collaborate with the key principles to develop a consolidated list of key functionality,
systems and APIs where as IT does not duplicate work.
Responsibilities:
 Understanding the Client Requirements.
 Prepared High Level Design Document for the Project.
 Involved in the creation of Data Model per the project.
 Prepared the Low Level Design Document for Universe and Reports.
 Created the Unit Test Cases document.
 Created, tested and deployed the Universe and Reports with back end as an Oracle 10g.
 Enhanced Existing Universe as per user requirements.
 Developed, tested and deployed the Web I Reports.

Environment: Business Objects XI3.1, Informatica 8.5, Oracle10g, TOAD9.5, Import Wizard, MS-Excel and Windows XP
AT&T Proactive Churn Management Tool (PCMT),U.S www.att.com
SAP BO Sr.Developer
Description:

The PCMT application is a web-based system used to identify AT&T customers most likely to churn and to
manage campaigns to proactively contact these customers and assist in resolving potential issues before the
customer contacts AT&T to disconnect service. The application consists of four primary components, a web
application used by Customer Service Representatives (CSR) to manage outbound calling campaigns and
Management Customer service Representatives (MCSR) to coordinate the calling efforts of CSRs. A backend database
(DB) layer is used to capture and store data for Application use. A backend Extraction-Transformation-Load (ETL) layer
is used to maintain data provided by source systems, integrating source data into functional components and present
a Production Layer for web application use along with an Analytics layer for reporting. Finally, an Analytics / Reporting
layer is used to provide data on campaign operations and effectiveness.

Responsibilities:
 Understanding the Client Requirements.
 Prepared High Level Design Document for the Project.
 Prepared the Low Level Design Document for Universe and Reports.
 Created the Unit Test Cases document.
 Created, tested the Universe and Reports with back end as an Oracle 10g.
 Deployed the Universe and Reports using Import Wizard.
 Enhanced Existing Universe as per user requirements.
 Developed, tested and deployed the Web I Reports
Environment: Business Objects XI3.1, MSBI (SSIS), SQLServer2005, TOAD9.5, Import Wizard, MS-Excel and Windows
XP

SPECTRA Energy SAP Impl ,U.S www.spectra.com

SAP BOBJ Sr.Developer
Description:
Spectra Energy Corp, a FORTUNE 500 company, is one of North America’s premier natural gas infrastructure
companies serving three key links in the natural gas value chain: gathering and processing, transmission and storage,
and distribution.For nearly a century, Spectra Energy and its predecessor companies have developed critically
important pipelines and related infrastructure connecting natural gas supply sources to premium markets.

Responsibilities:
 Understanding the Client Requirements.
 Prepared High Level Design Document for the Project.
 Involved in the creation of Data Model per the project.
 Prepared the Low Level Design Document for Universe and Reports.
 Created the Unit Test Cases document.
 Created, tested and deployed the Universe and Reports with back end as an Oracle 10g.
 Enhanced Existing Universe as per user requirements.
 Developed, tested and deployed the Web I Reports.
Environment: Business Objects XI3.1, Crystal Reports2008, Xcelsiues2008, SAP BI, SAP GUI, SAP R/3, MS-Excel and
Windows XP.

Smart Selection (CR) , U S www.dell.com

SAP Business Objects Developer.

Description:
The Client Reinvention (CR) program at Dell is a multi-year program to transform Dell’s product portfolio from a
primarily Configure-to-Order (CTO) set of products to a simpler and more manageable set of fixed configurations
(known as Smart Selection) that are easier to market, forecast and fulfill. Those products which will continue to be
CTO will be known as Customer Configurable products.

The CR Program will drive significant business process change (and related application changes) in many areas,
including product configuration, sales and marketing, demand planning, supply planning and order fulfillment.
Responsibilities:
 Understanding the Client Requirements.
 Created, tested and Deployed he Universe with back end as an Oracle 10g.
 Enhanced Existing Universe as per user requirements.
 Developed, tested and deployed the Web I Reports.
 User training
 Production Support handling bug fixes and enhancement requests.

Environment: Business Objects XI3.1, Informatica 8.5, Oracle10g, TOAD9.5, Import Wizard, MS-Excel and Windows XP

PICASSO / Pack.NET Integration , U.S www.coca-cola.com

SAP Business Objects Developer.

Description:
PICASSO / Pack.NET Integration project will provide the Pack.NET functionality using PICASSO and sunset the
Pack.NET application. Pack.NET is an externally hosted solution that collects and reports TCCS Beverage Packaging
bills of materials, packaging sustainability information (packaging efficiency and recycled content…) for our finished
products around the world. The data housed in Pack.NET is also used by the Packaging Research & Innovation (R&I)
department to identify efficiency opportunities.
This data integration and reporting phase of the project will help to integrate various components of
PICASSO database with finance database along with percent sales allocation data, transform data for detailed
reporting, and pre-compute from some complex reporting metrics in data layer for better performance BO reporting.

Responsibilities:
 Understanding the Client Requirements.
 Created, tested and Deployed he Universe with back end as an Oracle 10g.
 Enhanced Existing Universe as per user requirements.
 Developed, tested and deployed the Web I Reports.
 User training
 Production Support handling bug fixes and enhancement requests.

Environment: Business Objects XI3.1, MSBI (SSIS), SQLServer2005, TOAD9.5, Import Wizard, MS-Excel and Windows
XP
AMB Property Corporation , U S www.amb.com

SAP Business Objects Developer

Description: AMB (Abbey Moghadam Burke) Property Corporation is a leading global developer and owner of
industrial real estate, focused on major hub and gateway distribution markets throughout the Americas, Europe and
Asia. AMB Property Corporation® (NYSE: AMB) is a leading industrial REIT that develops, acquires, owns and operates
facilities in key distribution markets globally. We serve approximately 2,800 customers in 47 markets in 15 countries
throughout the Americas, Europe and Asia, with a portfolio totaling 155.5 million square feet (14.5 million square
meters). AMB is turning the power of global trade into distribution real estate opportunities. Our customers are
leaders in air and ocean cargo, freight forwarding, third-party logistics, retail and consumer products. Their success
depends on expediting the delivery of goods to market. That's why AMB's facilities are in locations vital to global
trade and the supply chain—near key international airports, seaports, highway systems and in supply-constrained
submarkets of major metropolitan areas.
Responsibilities:
 Worked on Design of the project along with the onsite team leader.
 Worked closely with SAP BI team to integrate SAP with BO.
 Worked closely with SAP Basis team to integrate SAP with Crystal Reports.
 Worked extensively on hierarchies for the client specific requirement.
 Worked for the development of POC for the project to showcase to the client.
 Developed SAP Universe, Created Classes with Dimension, Detail & Measure Objects and specified the
hierarchies.
 Created Web Intelligence Reports for SAP Universe.
 Organized data in reports by using filters, sorting, ranking and highlighted data with Alerters.
 Created the reports using BO functionalities like combined Queries, Slice and Dice, Drill Down, Cross Tab,
Master Detail and formula.
Environment: Business Objects XI3.0, Crystal Reports2008, Oracle9i, AS400, SQLServer, SAP BI,
SAP R/3, MS-Excel and Windows XP.

Penske Truck Leasing Business Intelligence (PTL BI) GE Consumer and Industrial

Business Objects Developer

Description: Penske Truck Leasing is one of the largest transportation services companies in North America. At
Penske, we're dedicated to providing precision solutions for all your transportation needs. We'll work with you to
match the right precision products and services to those needs- no matter what your requirements. It's our goal to
exceed your expectations.
PTL BI is part of eBusiness Group that provides Business Intelligence reports to different PTL functions like
Fleet Services, Rentals, Financials, and Billing etc. These BI reports provide Business leaders preview of their
functional processes.
Key Deliverables: Contract Management Case Dash boards, PL/AR Delinquency, EAM CR, MEPA, Partsnet average
Price Variance, Customer Review and these reports are being used extensively for determining the Status / Trend of
the Licenses / Permits of the Trucks that are rented. (Using Business Objects, Oracle and AS400).
Responsibilities:
 Understanding source systems and customer requirements
  Developed Universe, Created Classes with Dimension, Detail & Measure Objects and specified the
hierarchies.

 Specified the Joins, Aliases Created Condition and checked the cardinalities in Universe.
 Implemented User Objects in Reports.
 Organized data in reports by using filters, sorting, ranking and highlighted data with Alerters.
 Created the reports using BO functionalities like combined Queries, Slice and Dice, Drill Down, Cross Tab,
Master Detail and formula.
Environment: Business Objects XI/R2, Crystal Reports2008, Oracle9i, AS400, SQLServer, MS-Excel and Windows XP

Service Management Group www.newcorp.com

Data warehouse for National Electronic Warranty (NEW)
Informatica / Business Objects Developer
Description:
National Electronics Warranty (N.E.W) Corporation is an Independent Third Party Administrator of Service Contract. It
was founded in 1983 with Headquarters in Dulles, Virginia. It currently protects the purchases of over 150 million
consumers and generates over $1.2 billion a year in incremental revenue for its clients like Best Buy, Kmart etc. It
currently employs 1500+ employees and runs 5 Call centers with 2,000+ seats in Florida, Montana, Iowa, Oregon,
Kansas and a small Spanish-speaking team in VA. The domain areas of work for N.E.W include Retails, Manufacturing,
Financial and Utilities.
The Data Warehouse project will enable the effective and timely measurement of service claims performance
from 2 disparate operational sources (ORACLE and AS400). This will be accomplished via a series of ETL processes
that will consolidate and standardize data from two sources. The Data Mart will be the source of data for a Business
Intelligence tool (Micro Strategy) that will provide a front end GUI based application to enable End User Business
Analytics querying and reporting.

As a Team Member I was responsible for the following

 Understanding source systems and customer requirements

 Created Universes and resolved Loops by creating table aliases and contexts.
 Designing Universe and defining universe parameters.
 Designed Class, Dimension, Detail, Measure Objects and organized these objects in Universe designer
with business logic
 Accessing Business Objects using web intelligence.
 Involved in Master Detail and Cross Tab reports to view the data in an analyzed way and Creating User
Prompts, Conditions and Filters to improve the report generation.
 Involved in to create Hierarchies from providing drill down options for the end- user.
 Active Involvement in Production Support.

Environment: Business Objects6.5, Oracle9i, Windows XP, UNIX and Power Center 7.1.3 of Informatica.
PC-NGM CDWH, ABN AMRO BANK www.abnamro.co.in
Data warehouse for PCNGM CDWH
ETL/ Business Objects Developer
Description:
ABN Amro, one of the leading bankers in the present banking area. The CDWH, A data warehouse for the bank
operations and historic data will have an open architecture that allows for changes, allows for incorporation of new
business area’s and allows for both central and de-central implementation. The CDWH project extracts data from the
present OLTP systems and loads it to the Data warehouse to create standard & ad-hoc reports from the Data
warehouse
Responsibilities:
A s a Te a m M e m b e r I was re s p o n s ib l e fo r t h e fo ll ow in g
 Understanding source systems and customer requirements

 Designing Universe and defining universe parameters.

 Involved in Master Detail and Cross Tab reports to view the data in an analyzed way and Creating User
Prompts, Conditions and Filters to improve the report generation.
 Involved in to create Hierarchies from providing drill down options for the end-user and exporting the
Reports to the Broad Cast Agent Server.
 Active Involvement in Production Support.

Environment: Business Objects 5.1.3/6.5, SQL Server, flat files and Power Center 7.1 of Informatica.