Candidates About

Prasanna Chinta

SAP BI/BW & HANA Consultant

Professional summary:

Ø  Over 9+ Years of experience in SAP, which includes 9 Years of functional and technical experience in SAP BI/BW & BW on HANA Projects.

Ø  Completed 4 full life cycle implementations in SAP BW from requirements phase to GO-Live Phase and included one BW on HANA full life cycle implementation.

Ø  Experience in Advanced DSO, Open ODS and Composite Providers and BW Modeling tools in eclipse concepts on BW on HANA like SLT Configuration & BW on HANA Studio.

Ø  Activated the standard business content to meet the customer’s requirement in gathering the Event management data to BW. Experience in Building and enhancing BI objects that include InfoObjects, Data Sources, Transformations, DTP, DSO, InfoCubes, Multi-providers, Info set and Open Hub.

Ø  Experience in Building and enhancing BI objects that include InfoObjects, Data Sources, Transformations, DTP, DSO, InfoCubes, Multi-providers, Info set, BW Accelerator and Open Hub.

Ø  Experienced in activating the SAP Standard extractors from the SAP BI Content and enhance it based on the Client requirements.

Ø  Experience in creating the transformations and mapping the source to target mapping between the source fields and target Info Objects.

Ø  Experience in creating the routines like Start routine, End routine, Field routing and Expert routine by using the ABAP code.

Ø  Extracted data from Logistics (SD, MM) using LIS and LO-Cockpit, Finance data using CO-PA, Controlling FI-GL, AR, AP standard extractors and Generic Data Sources and customized Extractor to include custom defined fields and populated those fields using customer exits before the setup.

Ø  Experienced in Report Generation – Worked extensively in BEx Analyzer, Web Application Designer (WAD), Visual Composer, Business Objects Explorer, Web Intelligence.

Ø  Acquainted with modeling and maintenance of Events and Process Chains. Created and executed process chains to load the data into the InfoCubes and DSO and monitored the process chains for daily, weekly and monthly schedule of loads.

Ø  Improved the performance of Queries by maintaining Aggregates, Compression, and Partition, indexing of InfoCubes and use of Statistics for the same in SAP BI.

Ø  Extensively worked on transporting all kinds of BI objects from Development system to Testing system and Production systems.

Ø  Extensive experience in Enhancement, Upgrade & post Go Live implementation support.

Ø  Good communication and inter-personal skills, accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure, manage multiple project.

Ø  Strong analytical skills, enabling to quickly understand the drivers of a business process.

Key Sills:

ERP                                         :  SAP ECC 6.0, R/3 4.7.

Data Warehouse                :  SAP BI 7.4, 7.0, SAP BW 3.5.

Reporting Tools                  :  BEx Reporting, WAD.

BO                                          :  Webi, Data Services.

Languages                            :  ABAP/4, C, C++ and VB.

Operating Systems            :  WINDOWS 2007/XP AND WINDOWS/NT.

RDBMS                                  :  MS SQL Server 2008 and ORACLE 10g and 8i.

Education:

MSc in Information Systems in Osmania University, Andhra Pradesh, India during 2003-05.

Experience:

Macy’s New York City, NY                                                                                                                      June’15 to till date

Sr. SAP BI/BW & Hana Consultant involved in Implementation in Retail module.

Responsibilities:

·         Worked with the business to gather requirements and participated in designing solutions in line with the SAP best practices and Involved in the end to end implementation from requirement gathering to post go-live activities in Retail modules.

·         As a part of an implementation team, helped in the design of an end to end data flow to get new GL transaction data, LFL Data, Exchange rates and Master data from ECC to BW on HANA including activation of standard business content, creation of Advanced DSO, Open ODS Views, Composite Providers, Transformations, and Routines.

·         Involved in extracting the data from SAP ECC by using the SLT Configuration and BW on HANA Studio and BODS by HANA data provisioning

·         Created the HANA optimized InfoCube/DSO, Composite providers, Transient provider, InfoObject on HANA Attribute view, InfoCube on HANA Analytical view, Open ODS view on HANA Calculation view and vice versa. Pushed the BW standard transformation code into HANA ABAP.

·         Successfully designed and developed the whole data model like Attribute views, Analytical views, Calculation views and Procedures in BW on HANA Studio for Enterprise reporting in SAP Finance data like General Ledger transactions, Global Expense dashboard, Global P&L dashboard and Accounts Receivable dashboard, Media Product master, Projects, Asset accounting dashboard.

·         Designed and Developed HANA Model for AP invoice with offsetting line items, Vendor Discounts Gained and Lost and Vendor Master, WIP Inventory, Asset & Depreciation and Journal P&L reporting.

·         Worked with SAP and Macy’s basis team to establish the end to end configuration for HANA CTS transports mechanism to move objects from DEV to QA & Prod systems.

·         Delivered multiple reports for Billing and Revenue analysis, Consolidation and Elimination reports for IFRS and USGAAP, Investment and Equity by Trading Partner, Roll Forward and Cash Balance Reports, Intercompany Reports including P&L, BS and IC Dividends and Recon Reports in EPM Add-in

Environment: SAP BI 7.4, HANA 1.0 ,ECC 6.0 ,SAP BO 4.1.

National Fuel Gas, Buffalo, NY                                                                                                               June’13 to May’15

Sr. SAP BI/BW & Hana Consultant involved in Implementation in SD & PP modules.

Responsibilities:

·         Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modeling principles in Data Design, and used expert knowledge of data warehousing concepts.

·         Created extractors to extract SD data like Sales Order, Purchase Order.

·         Extracted the Purchasing data, Purchasing orders, of SAP R/3 into ODS and then transformed from ODS into Info Cubes after filtering the data at DSO.

·         Created the indexes for InfoCubes to improve the query performance.

·         Proficient in uploading master data and transactional data both from flat files and SAP R/3 Systems.

·         Extensively worked on Web Reporting, BEx Analyzer for designing the reports on Sales, Deliveries, Shipment, Purchasing, and Inventory using Conditions, Exceptions, and Variables & Structures.

·         Model and Design the Database by using KPI(Key performance Indicators).

·         Used BEx Analyzer for enhanced the already created queries. I created Calculated Key Figures, Restricted Key Figures and Variables in the existing queries.

·         Created the Universes on top of SAP BI Infocubes and build the Multiproviders with existing SD Infocubes for the Reconciliation reporting.

·         Created the Business Objects Webi reports on top of the Universe.

·         Created process chains for daily data loads, Aggregates Roll up, etc. Created messages in the process chains for load failures using emails.

Environment: SAP BI 7.2, ECC 6.0 SAP BO 4.1.

Lockheed Martin, Crystal City, VA                                                                                                         Feb’11 to June’13

SAP BI/BW Consultant involved in Implementation in SD module.

Responsibilities:

·         Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modeling principles in Data Design, and used expert knowledge of data warehousing concepts.

·         Extracted the Utility data of SAP R/3 into ODS and then transformed from ODS into Info Cubes after filtering the data at DSO.

·         Programmed several Start routines in Transformations to meet the business requirements.

·         Proficient in uploading master data and transactional data both from flat files and SAP R/3 Systems.

·         Extensively worked on Web Reporting, BEx Analyzer for designing the reports on Sales, Deliveries, Shipment, Purchasing, and Inventory using Conditions, Exceptions, and Variables & Structures.

·         Model and Design the Database by using KPI(Key performance Indicators).

·         Used BEx Analyzer for enhanced the already created queries. I created Calculated Key Figures, Restricted Key Figures and Variables in the existing queries.

·         Created the Universes on top of SAP BI Infocubes and build the Multiproviders with existing COPA Infocubes with the SPIN, POS data for Siebel Reconciliation reporting.

·         Created process chains for daily data loads, Aggregates Roll up, etc. Created messages in the process chains for load failures using emails.

·         Manually tested String testing, Formal testing, and Regression testing, Interface testing.

·         Conducted Defect Meetings, assign prioritization of defects and escalate to Project Manager, if necessary.

·         Responsible for monitoring test matrix and communicating status and issues to the Test Manager.

·         Executed integration end-to-end testing scripts in Bi/BW system.

Environment: SAP BI 7.0, ECC 6.0 SAP BO 4.1.

Brunswick Boat Group, Knoxville, TN                                                                                                     Oct’09 to Jan’11

SAP BW Consultant involved in Implementation & Production support Project in MM, FI Modules.

Responsibilities:

·         Implemented the full life cycle Project of Integrating the functional area HR, MM with BI, Responsible for Interacted with end users and project business sponsors to gathered business requirements, Performed GAP analysis, Prepared the Technical spec, Design of data models, comparing the model with delivered contents and Implementing the business logic with delivered contents along with modifications, Extracting the data, Transport the BI objects and resolving the issues on variance analysis and reporting.

·         Estimated the required memory in the R/3 as well as in BI by Quick Seizer.

·         Activated the standard business content BW Objects and extensively carried out LO extractors and enhanced the same to extract data into BI.

·         Created Generic Data Source using the database view for Employee data which is not satisfies in the standard extractors for the business needs.

·         By using CO-PA data source extracted the FI data for the relevant Operating Concerns for Customer forecasting, accruals and rebate calculations in SPD (Special Products) project.

·         Installed the Integration kit (imported the co-files & data transports into SAP) for BO XI products integration with SAP R/3 and BI.

·         Created Inventory valuation by closing period, Listing PR's PO's and RFQ's by invoice R/3 reports.

·         Experience with Data Services Standard Rapid Marts for purchasing & Inventory data extraction from ECC 6.0 to SQL Server 2008 database for PR-IA project and custom built ETL processes for Supply Network Collaboration (SNC) project.

Environment: SAP BI 7.0, ECC 6.0, SAP BI SAP BW 3.5, SAP R/3 4.7, Data Services 12.2

AFLAC Columbus, GA                                                                                                                                  June’08 to Oct’09             

SAP BW Consultant involved in Production support Project in SD Module in SAP BW

Responsibilities:

·         Interacted with end users to gathered business requirements, at Client’s place.

·         Analyzed business reporting requirements that could be satisfied by Business content InfoCubes of Sales and purchasing.

·         Installed BW standard business content Sales InfoCubes and Technical Cubes. Created custom cubes on the sales overview, billing and transportion.

·         Developed InfoSources and Written Routines in Update and Transfer Rules.

·         Working extensively on standard and custom defined LIS and LO extractors.

·         Logistics Cockpit configuration and customization for sales order overview.

·         Designed Generic Extractors and Data Sources for loading transactional data into Infocube and ODS objects.

·         Made enhancements according to the requirements and write ABAP routine in Transfer structure.

·         Worked on creating Aggregates, Compressions, Indexes, Multi cubes and parallel setups for data loading to improve performance and utilize data effectively.

·         Used RRI to drilldown from InfoCube pre-query to detail ODS result set query.

·         Involved in various tuning techniques in order to improve query performance.

Environment: SAP BW 3.5 & SAP R/3 4.7.