Sap Data

SAP Certified BI and HANA Consultant

Santhosh Chinthalapalli **************@*****.***

SAP BW/BI Sr Consultant 732-***-****

Professional Summary:

• In addition to solid educational background in Computer Science, I carry around

9 years of SAP experience mainly focused in design, development and implementation

of SAP BI Net weaver7.4, SAP ECC 6.0 & R/3 (4.7, 4.6C), SAP BO XI 3.X,SAP BO 4.1

and Certified SAP BI HANA Consultant.

• Excellent professional experience in Software Development Life Cycle that includes

requirement gathering, design, project implementation, system test and implementation, user

support and training

• Involved in full life-cycle implementations of multiple SAP BW/BI projects using

ASAP methodology

• Experienced in OLTP extractions of SAP LO-Cockpit, FI Asset Accounting, FI-GL

(New), FI- Special Purpose Ledger, FI-AP, FI-AR, SD, MM, COPA, Inventory, Generic

extractions and non-SAP data extraction

• Experience in Implementing SAP BW projects in financial services, Oil and gas,

Energy, Pharmaceuticals, and Chemicals industries.

• Expertise in SAP BW – Extraction, Data Modeling, Report development and

Performance Tuning.

• Highly experienced in Implementation, Upgrade, Maintenance and Support projects

in SAP BI/BW environment

Precise knowledge in understanding the SAP ECC, CRM, SRM Systems and considerable

experience in SAP BW and IP technical design documents and design & development of

reports Using BEx and SAP BO- BI.

• Expertise in Multi-Dimensional Data Modeling, Planning/Forecast using Extended

Star Schema and design implementation

• Proficient in the BW system technical and functional upgrade from BW 3.5 to BI 7.0

• Deployed cutover plans, activities and coordinated tasks with different process teams

for successful SAP implementation project

• Extensive experience on SAP BO Reporting tools hosted on Business Objects 4.0

• Extracted data from Flat files, UD connect and DB Connect

• Broadcasted reports with exceptions/pre-calculations using Information Broadcasting

functions

• Handled and resolved Production Support tickets per ticket priority and transported

them into Quality and Production environments

• Expertise in BI-ABAP programming for writing User exits, Start routine, End routine

and BADI.

• Expertise in Reporting with Business Explorer using BEx Analyzer, BEx query

Designer, Web Application Designer, Condition reporting, Exception highlighting, developed

Queries, Queries using filters, Free Characteristics, Calculated Key Figures and Restricted

Key Figures, Variables, Structures and RRI (Report to Report Interface), Hierarchy design .

• Effectual skills to build reports in Business Objects expertise in

using BOBJ Enterprise Tool Set (Universe Designer, Web Intelligence, Xcelsius, Crystal

Reports).

• Expertise in creating, organizing, publishing and scheduling reports

using BOBJ Center Management console.

SAP Certified BI and HANA Consultant

Santhosh Chinthalapalli **************@*****.***

SAP BW/BI Sr Consultant 732-***-****

• Displayed reports in Info view portals for the Web Intelligence Documents created

upon the Universes.

• Good communication and interpersonal skills, self-motivated starter, quick learner,

team player.

SAP HANA - High Performance Analytic Appliance

• Superior understanding of In-memory Computing Engine and its framework

• Worked in a Proof-of-Concept project to measure data load/query performance in

SAP BW 7.3 with SAP HANA against Oracle database

• In-depth knowledge of SAP HANA Replication Technologies – Trigger Based

Replication(SLT); ETL Based Replication using SAP Data Services, Log Based Replication

using Sybase Replication Server, and Direct Extractor Connection (DXC)

• Created Attribute Views, Analytic Views and Calculation Views in HANA modeling

• Thorough understanding of Analytic privileges and Security concepts in SAP HANA

Technical Expertise:

Data Warehouse and Reporting: SAP BW 3.5, BI 7.4, BEx and SAP BO 4.1

ERP : SAP R/3 4.7, ECC6.0

Reporting Tools : BEX Analyzer, Query Designer, WAD, Dashboards, SAP BO 4.0

Programming Languages : C, ABAP/4

Databases : Oracle-9i (SQL/PL/SQL)

Operating Systems : Windows XP/98/7.0/Vista/XP,UNIX

May 2013 – March 2015

Client: Impax Laboratories Philadelphia, PA

SAP BI/HANA Sr Consultant

Environment: SAP BW 7.4, ECC 6.0, HANA SPS07

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering,

Development, Testing, Reporting, Go-live and Post go-live support.

• Interacted with functional team, global users, Order to Cash, Procure to pay departments, to study

their business process.

• Created necessary generic DataSources on R/3 with delta functionality; worked on enhancing the

extract structures based on the Client requirement and populated data to those particular enhanced

fields by using User exits.

• Activated standard Logistic DataSource content on R/3 for sales order items, header & item

statuses, Deliveries, MM (Purchasing) & FI (GL, AR & AP) and enhanced as per the user

requirement.

• Involved in Extraction, Transformation and Loading of Data (ETL) - preparing SAP R/3

for SAP BW and defining the loading strategies, initial and delta data loads via PSA; loading data

from flat files, Scheduling and monitoring data loads.

SAP Certified BI and HANA Consultant

Santhosh Chinthalapalli **************@*****.***

SAP BW/BI Sr Consultant 732-***-****

• Worked with Sales and Finance Managers to gather the requirements to create POCs to show case

the capabilities of SAP HANA

• Involved in creating FDS and TDS for SAP HANA.

• Involved in creating HLDs for SAP HANA.

• Worked with SAP HANA data modeling using Attribute View, Analytic View and Calculation

View.

• Performed Development tasks with SAP HANA programming including SQL, SQL Script.

• Designed with SAP HANA Administration including managing schemas, data model objects.

• Developed HANA data modeling scenarios and activities such as adding a system, creating

schemas, importing table definitions, adding connections setting preferences for the modeler

• Loaded data into table definitions, suspended and resumed data loads, copied contents delivered

by SAP, created information objects (packages, attribute views, analytic views etc.)

Client: Meda Pharmaceuticals, Somerset, NJ Jan 2012 – April 2013

SAP BI Sr Consultant

Environment: SAP ECC 6.0, SAP bi 7.3, BO 4.0

Responsibilities

• Participated in all phases of life cycle including Requirements Gathering, SAP ASAP

Methodology, Analysis, Design, Development, Testing, Deployment solutions, Post production

Support, Documentation, User training for knowledge transfer.

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

functionality in reporting using BEx Query Designer.

• Responsible for cross training and providing knowledge transfer to Power users.

• Configured DataSources by using LO Cockpit (LBWE) initialized the setup tables.

• Enhancement of Data Sources and Creation of Generic Extractors in ECC using ABAP wherever

required.

• Responsible for creating Queries and BW reports using BEx Query Designer and BEx

Analyzer filtering with Calculated Key Figures, Structures, Variables Exceptions and

conditions.

• Created Web Intelligence Documents by writing SQL Queries for Derived tables in the universe as

per the Functional Specifications.

• Used the formatting options like cross tab representation, section breaks, data sort options,

calculations, font, colors, etc

• Developed various Charts, Graphs and drill down reports in Webi.

• Created bar charts, pie charts and exported them to power point, PDF and presented them in user

meetings

• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, Variables,

Formulas, Filters, Sorts, Query prompt, Hyperlinks in Webi

• Created various dashboards using Xcelsius.

SAP Certified BI and HANA Consultant

Santhosh Chinthalapalli **************@*****.***

SAP BW/BI Sr Consultant 732-***-****

Client: Cameron Houston, TX Sept 2009 –

Dec 2011

SAP BI Sr Consultant

Environment: SAP ECC 6.0, SAP bi 7.0

Responsibilities

• Gathered requirement form the Business users, analyzed report format and suggested the possible

format to the users.

• Activated the business content data sources related to SD (Order, Delivery, Billing and Condition

data source), MM (Purchase and inventory), PP, FI and PM.

• Maintained the enhanced standard data sources as well as custom data sources to reach the client

requirement.

• Extracted Sales variant classification and Batch variant classification data to BI and mapped into

data targets.

• Activated the business content info cubes, info objects, Data store objects and multi providers.

• Loaded the data to BI targets like Master Data info objects, info cube and data store objects.

• Update the unit, currency and fiscal variant master data tables in SAP BI side.

• Managed the inventory data loads and material master data number range settings in BI.

• Reconciled data between ECC to BI data targets.

• Transported the business objects to BI QA as well as BI Prod as per BI landscape.

• Custom reports designed using restricted key figure, calculated key figure, selection and formula.

• Used the variables like characteristic, text and formula variables to achieve client requirement.

• Worked on customer exit variables like month to date, year to date, fiscal year to date and opening

balance on previous year.

• Created the process chains for delta loads and schedule the jobs in background mode .

Client: Bank of America Charlotte, NC April 2008 –

Aug 2009

SAP BI Consultant

Environment: SAP bi 7.0, SAP ECC 6.0,

Responsibilities

• Setting-up of the extraction processes for the Finance Modules (FI-GL/AP/AR) using the

standard as well as Generic extractors.

• Data extraction from R/3 and legacy systems according to the client’s requirements.

• Worked with BEX Query designer to build queries according to the client’s requirement using

• Calculated Key Figures, Restricted Key Figures, Variables, Structures, and Query properties,

Filters, Free Characteristics, Conditions and Exceptions.

• Monitoring of process chains and analyzing the reasons for failures

• Maintaining Reconciliation to verify the data in SAP R3 and SAP BW after th e data loads

• Involved in prioritized tickets regarding extractions, Performance Issues and also load

failures

SAP Certified BI and HANA Consultant

Santhosh Chinthalapalli **************@*****.***

SAP BW/BI Sr Consultant 732-***-****

• Handled Tickets regarding Data mismatches in reports.

• Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50.

Client: BASF Charlotte, NC June 2006 – March 2008

SAP BI Consultant

Environment: SAP ECC 6.0, SAP bi 7.0

Responsibilities

• Extensively involved in data extraction from non-SAP sources and SAP R/3.

• Customized InfoObjects, InfoSources and InfoCubes.

• Activated the business content according to the functional requirements.

• Activation of Standard Business Content, customizing and creating custom cubes.

• Developed Transfer Rules and Update rules to cleanse the data and enhance the master and

transaction data using Formula Builder.

• Created InfoSources for uploading master data and hierarchies.

• Created Aggregates and Indexes for InfoCubes to improve performance.

• Used ODS objects to store external data and updated into various data targets based on the

requirement using update rules.

• Generated standard and customized reports using BEx Query Designer.

• Published reports on web using Web Application Designer.

• Created exceptions for critical analysis of data.

• Created restricted and calculated key figures to calculate average, min, max etc.

• Developed flexible queries using filters, exceptions, navigational attributes, to facilitate data

analysis in drill down or in a summarized way to give detailed levels of information.

Academic Profile:

MSc in Computer Science University of Greenwich UK, 2006

Reference provided upon request.

Open for relocation

Contact this candidate