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