Kalpana Rao

**** ***** *** **. *****:919-***-****

Cary, NC 27519 acvyl4@r.postjobfree.com

Legal Status: US Citizen

OBJECTIVE

A Senior SAP Business Intelligence position

Design and development of Data Warehouse / Reporting solutions involving Transformations, InfoProviders, Extractors and Business Content configuration

Business process documentation and end-users training / knowledge transfer.

Utilize a combination of technical and managerial skills

PROFESSIONAL PROFILE

Over 13 years of IT experience, including 8 years of SAP BW and SAP R/3 design and development.

Worked with Standard and custom InfoCubes, InfoObjects, InfoSources, ODS, Multiproviders, Extraction process, Buisness Content activation.

Experience writing ABAP code for Custom extractors in SAP R/3 and transformations in BI.

Built custom queries using Restricted and Calculated Keyfigures, Variables, Structures, Conditions and Exceptions. Extensive experience with Query Builder, BEx Analyzer, RRI - Jump queries, Universe Designer, Xcelsius, Crystal Reports and WebI.

SAP Business Objects Data services (BODS) – experience creating Workflows, Data flows and Jobs to cleanse and push data into SAP BW and also to DB2 data base.

SAP BOBJ – experience creating Universe combining SAP BW and Non-SAP data and creating WEBI reports

SAP BOBJ WEBI – experience creating WeBI reports on Universe and BEX queries using IDT

SAP BOBJ Administration – experience scheduling WEBi reports, traouble shooting issues in the BOBJ environment

Crystal Reports – experience creating Crystal reports

Worked with InfoSets and InfoSet queries.

Sound knowledge of various data design models - Entity Relationship(ER), Multi Dimensional/ Star Schema and Extended Star Schema models.

Automated loads using process chains and use of BW Monitor to supervise data loading.

Researched new and more efficient methods of implementation of process chains, load process and query access.

Performance tuning using Aggregates, Compressions, Indexes and Partitioning, BWA.

Hands-on experience on Upgrade from BW 3.5 to BI 7.0

Over 1 year experience in creating interactive & executive dashboards using Xcelsius Enterprise 2008.

Expertise using QAAWS and creating prompts used as input parameter for the dashboards.

Involved in post production, go-live support.

Capable of working independently with minimum supervision as well as in a team.

Highly motivated, eager to learn and take on greater responsibility.

Excellent communication skills, systematic approach and ability to work effectively in fast paced environments.

EDUCATION

M.S. Computer Engineering (GPA 3.5), North Carolina State Univ., Raleigh, NC, Aug 1997

Computer Programming Certificate (GPA 3.5), North Carolina State Univ., Raleigh, NC, Dec 1995

MBA Marketing and Finance (First Class with Distinction), Osmania Univ., Hyderabad, India, Jun 1992

CAREER COURSES

SAP BW 330

SAP BPC and SAP-BO Integration

XCelsius dashboards and Universe design

SAP BW Security

BEx Analyzer and Workbooks

Oracle SQL

SOFTWARE SKILLS

Languages : SAP ABAP, Java, Object Oriented software design

Data Warehouse : SAP BI 7.0 and SAP BW 3.5

ERP Packages : SAP R/3 4.6, SAP Netweaver 2004s

Reporting Tools : SAP BEx

Platforms : Unix, Windows (XP, NT, 2000), OS/2, Sun, HP workstations, IBM PCs

EMPLOYMENT HISTORY

Teleflex Medical, Morrisville, NC (Mar 2015 to present)

Sr. SAP BW Position, Business Intelligence/Reporting Team

SAP implementation of SD module

Designed and developed Sales Actual, Forecast and Plan BEX and WeBI reports. Designed and developed the Infoproviders and transformation logic for Sales Actuals data from SAP and Plan data from Hyperion which was transformed using Data Services. This project involved writing ABAP code to transform the format of the Forecast data.

Designed and developed the backend logic, Universe and WeBI reports to report Distributor Inventory. This project involved transforming Distributor data through Data Services and storing it in Data base and combining this data with data from SAP BW through Open hub and writing WeBI reports on the combined data.

Designed and developed Sales Planning and Financial Operations solution that involved writing a program to convert the format of Demand planning files, utilize BODS to cleanse and transform data and move it to BW, creation of Landing and Staging DSO’s and cubes to host Demand Planning data, Forecasting data and merging this with Sales summary data in a Multi-provider for reporting Forecast, Plan and Actual Sales Reporting.

Developing enhancements to CRM implementation.

Involved in design discussions with APO implementation partner.

Involved in day to day Incident resolution on BW reports

BB&T, Greensboro, NC (June 2013 to Dec 2014)

Sr. SAP BW Position, Business Intelligence/Reporting Team

SAP implementation of FICO module

Involved in design and development of Balance sheet reports. Was actively involved in report requirement gathering, data modeling and design and development of InfoCubes and report generation.

Actively involved in designing and setting a standard for Customer exits using Object Oriented ABAP.

Designed and developed custom extraction modules for data extraction from ECC to BW.

Designed and developed Inbound and Outbound interfaces for reporting.

Mentored and lead developers, assigning development tasks, status tracking and communication to Management

Apex Tool Group (ATG), Apex, NC (Nov 2011 to June 2013)

Sr. SAP BW Developer, Business Intelligence/Reporting Team

SAP implementation of SD module

Designed and developed of Point of Sale reports for ATG’s key customers. Was actively involved in report requirement gathering, data modeling and design and development of InfoCubes and report generation.

Actively involved in migration of data from non-SAP plants into our current BW system and reporting.

Actively involved in migrating existing BEx queries from SAP BW 3.5 to 7.0.

Designed and developed Sales Metrics reports for merged plants after migration.

Actively involved in design and implementation of bringing EDI data from Vendors into BW for reporting Point of Sale data.

Actively involved in designing security roles for new users for Workbooks.

Production Support – Monitor Daily Process Chains and BWA resolve any issues.

Pepsi Bottling Ventures (PBV), Raleigh, NC (Apr 2011 to Nov 2011)

Sr. SAP BW Developer, Business Intelligence/Reporting Team

SAP implementation of SD module

Created Inventory Valuation reports for Finished Goods and Raw Materials and tied it to G/L Accounts. Created Customer Exit for User date validation. Created an extractor for this purpose to read MBEW and MBEWH tables for material balances. Designed InfoCubes/InfoProviders and transformation logic required for data loads. Created a process chain and ABAP program to trigger the chain based on Period closing.

Production Support – Monitor Daily Process Chains and resolve any issues

Worked on Business Objects - XCelsius Flash Dashboard reports and Web Intelligence reports for Sales data.

Created Crystal report for daily sales data.

Office of State Controller, Raleigh, NC (Mar 2008 to Mar 2011)

SAP BW Developer, Business Intelligence/Reporting Team at BEACON

SAP implementation of HR and Payroll

Gathered business requirements and deliverables along with functional analysis and worked with functional team

Wrote technical design documents for functional requirements

Wrote custom extractor in SAP R/3 for Employee master data using ABAP programming language, Created extract structure and Function module to extract Employee data into BI.

Wrote BADI for CATS data

Created views in R/3 for custom datasources

Was responsible for design, development and extraction from R/3 Source system and flat files to BW for Personnel Administration (PA) and Organization Management (OM).

Installed Business Content for Time and labor and Cross Application Time Sheet (CATS) data.

Migrated datasources from 3.5x to 7.0.

Extensively worked on building custom cubes, and written ABAP routines in transformations, Start and End routines.

Created process chains for daily loads of PA data.

Schedule Daily/Weekly/Monthly data loads.

Managed and monitored data loads with full upload and delta mechanism.

Created Infoset with InfoCube and Datastore to query data with join conditions.

Created Queries by defining rows, columns and free characteristics providing drill down

Functionality in reporting using BEx. Worked with users to understand their reporting

needs.

Created user exit for date variables for query.

Worked on performance of Infocubes using Multiproviders, Partitioning based on month, and Compression.

Researched and successfully implemented Structural Authorization program for security of BI users.

Researched in SAP documentation library and implemented new process type - Decision between Alternatives in our Process Chains.

Implemented Open Hub architecture to write files from InfoCubes to the Application server and to flat files.

Self Employed (Jan 2004 to Mar 2008)

Managed outsourced software development and testing services for clients in Raleigh. Working on the day to day operations of the consultancy such as generating leads, acquiring clients, managing client projects as a project manager.

Maternity Leave (Sep 2001 to Dec 2004)

IBM, RTP, NC (June 1996 to Sep 2001)

Software Engineer

Project - Presentation Services Navigation Services Prototyping. Investigated Navigation Services (NS) for TBSM Java Console. Existing prototype displayed TM/390 resources by manually creating a JTree. Enhanced this prototype to display TM/390 resources using NS with all major tree views. Used Java and XML in this project.

Project - Gem23 Plan Mode Easy Mapping - Gem Plan Mode was enhanced to enable full definition of business system. Used Java in this project.

Developed programs in C for testing Netscape API’s on IBM internet server. Tested Helpdesk over DB2.

RELEVANT COURSES

Database Management Systems, Advanced Data Structures & Algorithms, Operating Systems, Compilers, Computer Architecture, Multiprocessor Architecture, Computer Communication Networks, LAN Communication Protocols, Object Oriented Programming in C++, and Neural Networks, Marketing Management, Accounting, Economics, Statistics, Human Resource Management, Personnel Management.

Contact this candidate