Resume
Sign in

Sap BO/BW/HANA Developer

Location:
Toronto, Ontario, Canada
Posted:
March 01, 2013
Email:
abojr6@r.postjobfree.com
Contact Info:
******@************.***


Kapil Reddy
abojr6@r.postjobfree.com (m) 647.***.****

Professional Summary
● 6+ years of information management and development experience with focus on Business
Intelligence and Data warehousing using SAP Technologies
● Expert in business analysis, metadata management, reporting and dashboards with SAP
NetWeaver BW 3.5 and 7.x and SAP BusinessObjects 4.0 Product suites
● Seasoned technical consultant with strong development, administration and lifecycle management
skills.
● Expert in requirement gathering, documentations and creating POC's to better meet the business
requirements.
● SAP Business Intelligence Certified (SAP BI – NetWeaver 7.0)
● Sound knowledge on SAP HANA 1.0, completed HA100 & HA300.
● Has a very strong technical foundation with excellent interactive and communication skills.

Technical & Business Skills
● SAP Business Objects 4.0

Web Intelligence 4.0 Dashboard Design Crystal Reports 2008
BW NetWeaver 7.x and Information Design Tool Analysis for OLAP and Office
BICS OLAP (Universe)
SAP and BO Integration BI Architecture and Security Live Office 4.0

● SAP Business Warehouse 7.x

SAP BEx Query Designer Web Application Designer
SAP BEx Analyzer
DTP, DSO InfoPackages MultiProvider
Authorization and Security Transformations InfoCubes Design

● Programming

Excel Macro SQL HTML

● Database, Data Warehouse, ETL & OLAP Technologies

Oracle 10g MS SQL Server 2005/2008 MySQL
SAP HANA 1.0 DB2

● OS Platforms

Linux Windows Server 2003, 2008

Page 1 of 5
Project Experience

Client : Sedgwick County – Wichita,Kansas
SAP BusinessObjects Developer Feb 2012 – Nov
SAP NetWeaver BW 7.x, SAP BusinessObjects 2012
4.0,

Role & Responsibilities
• Gathered User requirements,
Analyzed reporting requirements and
created technical specifications.
• Created five complex Xcelsius
dashboards connecting with SAP BW BEx
query for budgeting and long term financial
planning
• Created Scenario Builder using
WebI and LiveOffice with additional
Macro Programming in Excel
• Create complex WEBI reports
using multiple queries, merged dimensions,
filters, variables.
• Extensively developed reports
using Live Office using WEBI as the data
source as per the client requirement.
• Worked closely with the client in
all phases to design, build, test and deploy
SAP BI 4.0 solutions

Key Accomplishments
• Completed complex reports including
revisions within time and under budget
from extensive experience with BOBJ
using BEx connecting with the BW
backend.
• Effective communication and training
of client users for their daily usage of
WEBI and Live Office reports and
department customizations

Client : Leprino Foods- Denver,Colorado
SAP Integration Consultant
Kapil Reddy
abojr6@r.postjobfree.com (m) 647.***.****

SAP NetWeaver BW 7.x, SAP BusinessObjects 4.0,

Role & Responsibilities
• Design and develop PM and FI-CO content and customized InfoCubes for various reports
• Gathered User requirements, Analyzed reporting requirements, Evaluated Standard
business content.
• Create Process chains to load master and transactional data .
• Interacted with all end-users for information gathering and production support
• SME for Functional and Technical expertise in FI and PM Modules
• Help to integrate Reporting Solutions to SAP BusinessObjects 4.0 using various OLAP
connection (BICS)
• Created interactive Web Intelligence reports and Xcelsius Dashboards
• Production Support for SAP NetWeaver BW and SAP BusinessObjects Environments

Key Accomplishments
• Created mock-up dashboards demonstrating a variety of data and presentation
possibilities.
• Developed financial dashboard connected to existing SAP BW objects, delivering new
analytical capabilities to executive decision makers on spending execution and budget.

Client : Tencate - Pendergrass, GA
SAP BusinessObjects Developer, Migration Planning, Upgrade to BI 4.0 Nov 2011 – Dec 2011
Role & Responsibilities
• SAP BusinessObjects Technical Lead for migration from BusinessObjects 3.1 SP3 to BI BOBJ
4.0 SP4
• Responsible and accountable for phased migration plan and cutover strategy to migrate 350 users
(approx.) across 4 business units
• Strategy and plan included clean-up of environments resulting in savings through reduced
processes and job schedules, effectively lowering failures
• Migration entailed user groups, personal documents, Universes, WebIntelligence Reports, Crystal
Reports, Xcelsius dashboards and agnostic documents
• Lead for designing, architecting new 4.0 environments in DEV, TEST and PROD
• Coordinated with test leads and business users to provide support for testing and break-fixes

Key Accomplishments
• Developed reusable training assets for business users and super users for new BusinessObjects
platform
• Significant cost savings through clean-up strategy
• Environment was healthier and helped reducing support workload and increased server uptime

Capgemini – Cleveland, Ohio

Page 3 of 5
SAP Integration Consultant Feb 2008 – August 2011
Kapil was the SAP Integration Consultant for SAP Business Intelligence

Client: Gerdau
SAP NetWeaver BW 7.x, SAP BusinessObjects 3.1,& 4.0,
Role & Responsibilities
• Conducted brown paper sessions and one-on-one review sessions with business users and
business leads to assimilate end user requirements
• Established templates to document findings, functional, non-functional and technical
specifications
• Documented requirements for reporting from three SAP source systems – SD, PP, MM
• Drafted data model for InfoCubes to match reporting requirements
• Created InfoCubes DSO, DTP and InfoPackages to support reporting requirments
• SAP BusinessObjects developer responsible for build and unit test of WebIntelligence reports and
Xcelsius dashboards with SAP BW back-end
• Assisted in BI Platform upgrade/migration from XI 3.1 to BI 4.0

Key Accomplishments
• Built WebIntelligence reports that combined existing reports thus reducing the number of reports
• Provided a daily work based step-by-step approach to story boarding and accomplished the design
by linking reports and dashboard thru context based menus

Client: Advanced Micro Devices
SAP BW 7.0, Business Explorer, Analyzer,
ECC 6.0

Role & Responsibilities
• SAP BW reporting lead for Sales & Distribution and Finance modules (ECC 6.0)
• Lead for reporting and data loading performance management team
• Gathered requirements for reporting and analyzed existing information in BW to determine
natural fit for report data
• Designed and developed new cubes, loaded data from SAP ECC (historical & delta records)
• Resolved performance issues by using aggregates, monitoring statistics, indices and compression
• Delivered reports using Business Explorer Analyzer and WAD tools for SD and FI modules

Key Accomplishments
• Several existing reports had significant performance issues; initiated and lead a performance
management team to focus on delivering high quality reports following basics and best practices
• Effort resulted in tremendous success with savings through potential hardware procurements

Tech Mahindra Limited – Pune, India
Database Administrator – Oracle 10g Mar 2006 – Dec 2007
Kapil was the Oracle 10g database administrator for Development and QA systems supporting
Kapil Reddy
abojr6@r.postjobfree.com (m) 647.***.****

enterprise datawarehouse, oracle applications and custom applications

Oracle 10g, database performance monitoring, Linux, STATSPACK
Role & Responsibilities
• Installed, maintained and administered Oracle environments on Linux platform
• Implemented daily, weekly and monthly monitoring and checkpoints for DBAs to ensure clean
and stable database environment for application development, testing and UAT
• Monitoring and checkpoints included tracking of project requirements, forecasting space / disk
utilization, memory allocation, statistics etc.
• Supported project requirements for moving data between environments
• Extract production subset into DEV and QA for development and testing
• Setup daily backups during active development phase of projects
• Participate in all code reviews where databases are involved (data is sourced from or written to)

Key Accomplishments
• Successfully duplicated a number of production databases using RMAN to allow for hardware
upgrades and to enable development and test environment.
• Assisted with design and implementation of new data warehouse database.

Training
• HA100 SAP-HANA Introduction
• HA 300 SAP-HANA Implementation and Modeling

Education
● Awarded a Bachelor of Electrical and Electronics Engineering degree from Kakatiya
University, India

Page 5 of 5