Candidates About

 

Ramu Potharam

SUMMARY OF QUALIFICATIONS:

·         SAP Certified Senior consultant having 11+ years of experience working on SAP HANA / BWonHANA/ BW / BO/ BPC and Tableau technologies.

·         Experienced in 5 full lifecycle implementations for different modules in SAP BI.

·         3 years of experience working on new Tableau Software – Reporting tool for Visualizations.

·         5+ years of exceptional experience working on SAP BOBJ 4.1, 3.x, Tools – Web Intelligence, Design Studio, Crystal Reports, Analysis for Office, Excel and Lumira.

·         3 years of extensive experience working on SAP native HANA modeling (Attribute views, Analytic views and Calculation views) data profiling and security administration in HANA studio.

·         Worked on assigning Analytical privileges on different schemas for the business requirement and exposure to Procedures, decision tables and calculated columns.

·         Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SDA, SLT, BODS (ETL Extraction), DXC and Flat files.

·         Hands-on experience with SQL scripts like stored procedures and well versed with BW on HANA working functionalities.

·         Solid experience working on the Information Design Tool and the Central Management Console in Business Objects platform.

·         Solid experience working on SAP BI 7.4 on HANA platform and BW 7.5 powered by HANA.

·         Interacted with Clients to understand the business processes (functional and technical) across various SAP functional areas like SAP (SD): Sales Order, Delivery and Billing, SAP (MM) Material Management: Purchasing, Procurement and Inventory, SAP FI-CO (General Ledger, Accounts Payable and Accounts Receivable), SAP PP: Production Planning (Manufacturing), SAP PM: Plant Maintenance, SAP CRM: Sales Contract Analysis, SAP IS-U and SAP PS: Project Systems.

·         Experienced with ABAP models (Routines, Function modules, customer exits) in BI/BW.

·         Experienced in BPC integration with BI/BW.

·         Modeling: Experienced with creation and maintenance of Data Sources, Info Packages, Info Objects, DSO’s, DTP’s, Info Cubes, SPO’s, Multi Providers, Open Hub, APD’s and Composite Providers.

·         Extraction: Proficient in data extraction from SAP ECC, flat files and BW using extractors such as LO Cockpit, CO-PA, FI, Generic Extractors and legacy systems.

·         BEx Reporting: Experienced in BEx Designer, Analyzer, Variables, Conditions, Exceptions, Formulas, Calculated and Restricted key figures, Structures and Filters.

·         Performance tuning: Involved in the evaluation of statistical performance, data load improvisation and query performance using compression, pruning, aggregates and partitioning techniques, BWA and BI accelerator for index maintenance.

·         Migration projects: Involved in migration from BW 3.1c to BI 7.0 (NW 2004s) and from BW 7.0 to BI 7.3 (NW 2004s) and BI 7.4 powered by HANA.

·         Production Support: Experienced with REMEDY, ALM and HPQC tools for Incident management, defect resolutions and ticketing issues.

·         Integrated Planning: Aggregation levels, Filters, Planning functions and planning sequences in Integrated Planning.

·         Created Web Intelligence Report and Analysis for OLAP reports on the BEx Queries using BICS connectivity.

·         Excellent analytical skills, proficient in analyzing data, solid domain knowledge of Health Care, Finance, Food and Beverages, Supply Chain, Consumer Products, Consumer Goods and Sales environments and with a strong Manufacturing background.

CERTIFICATIONS:

 

·         SAP Certified Application Associate - SAP HANA (Edition 2015) License 0016661595.

·         SAP Certified Application Associate - SAP Business Planning and Consolidation 10.0 License 0016661595.

TECHNICAL CAPABILITIES:

·         Data Warehouse     : SAP BI 7.4/7.5 on HANA, BI 7.3, BI 7.0, BW 3.5, HANA SPS 09/10/11/12.

·         ERP Integration       :  SAP R/3 4.7, ECC 6.0 – SD, MM, FI, PP, PM and PS modules.

·         BI Reporting Tools   : SAP BEx, WEBI, Crystal, Design Studio, Analysis for Office,           Tableau and Lumira.

 

EDUCATION/TRAINING:

 

·         Master of Science in Computing from University of West London, London, United Kingdom.

·         Bachelors in Electronics and Communications engineering from Anna University, Chennai, India

 

PROFESSIONAL EXPERIENCE:

 

1) Client: The Scotts Miracle-Gro Company - Columbus, Ohio                            Nov 2017 – Present

Role:  Sr. SAP BWonHANA HANA BO Tableau Consultant                                                                    Consumer Goods – Consumer Database Project

 

Description:

The Scotts Miracle-Gro Company was founded in 1868 by O.M. Scott as a premium seed company for the U.S. agricultural industry. In the early 1900s, the Company began a lawn grass seed business for homeowners. The company grew from a leading lawn care business to an international marketer of industry-leading brands with a 1995 merger with Miracle-Gro.

Responsibilities:

·         Actively involved in leading prototyping and design sessions, workshops with the business.

·         Creating the Advanced DSO and Composite Providers for data consolidation.

·         Creating the BW models in the backend and importing the models to HANA.

·         Worked on designing the native HANA Information view models like Attribute views, Analytic Views and Calculation views.

·         Worked on BWonHANA eclipse based models for the consumer database project.

·         Provided expert technical assistance with training, design and architecture tasks, and daily oversight of system processes and performance.

·         Worked on the data modeling and building complex calculations in HANA models.

·         Expert in creation of Attribute Views, Analytical Views and Calculation views Graphical and SQL Script – CE Functions and Stored Procedures.

·         Involved in moving transports from source to target using life cycle management LCM.

·         Working on creating Tableau dashboards on HANA information models.

·         Involved in publishing the Tableau dashboards to the Tableau server and training users to access the dashboards via IPad and mobile devices.

·         Involved in creating complex calculations in Tableau and building visualizations by using different types of charts.

Environment: SAP BWonHANA, SAP BW/BI 7.3, 7.4, 7.5 on HANA, HANA studio, Tableau 10.1.3, Web Intelligence, Analysis for Office 2.1, 2.3.2, 2.4, BPC, Query designer, Bex Analyzer.

 

 

2) Client: Colgate – Palmolive; Piscataway - New Jersey                                   May 2017 – Oct 2017

Role:  Sr. SAP HANA BW BO Tableau Consultant                                                                     Consumer Products – (Procure 2 Pay (Finance – Accounts Payable) Compliance Project)

 

Description:

Colgate-Palmolive is a leading global consumer products company, tightly focused on Oral Care, Personal Care, Home Care and Pet Nutrition. Colgate sells its products in over 200 countries and territories around the world with global brands sold in over 200 countries and territories, Colgate, Speed Stick, Lady Speed Stick, Palmolive, Ajax, Soft-soap and Hill’s pet Nutrition are among the world’s most recognizable household names, trusted and relied upon by consumers everywhere. The scope of this project is to provide the visualizations of data on Procure-to-Pay vendors based on the different compliance metrics.

 

Responsibilities:

·         Participated in all phases of application development including requirement gathering, functional specifications, design, development, testing, deployment and support.

·         Actively involved in leading prototyping and design sessions, workshops with the business.

·         Creating the function module based extractors in ECC and replicating the data into BW.

·         Creating the BW models in the backend and importing the models to HANA.

·         Worked on designing the native HANA Information view models like Attribute views, Analytic Views and Calculation views.

·         Provided expert technical assistance with training, design and architecture tasks, and daily oversight of system processes and performance.

·         Involved in technical discussions with the team and the business as per requirements.

·         Worked on the data modeling and building complex calculations in HANA models.

·         Created native HANA modeling scenarios and activities such as setting up HANA environment – adding a system, creating schemas and creation of USERs and ROLES, etc.

·         Expert in creation of Attribute Views, Analytical Views and Calculation views Graphical and SQL Script – CE Functions and Stored Procedures.

·         Monitoring the replication process using native SAP HANA studio and SAP LT replication server for transactional Integrity.

·         Involved in moving transports from source to target using life cycle management LCM.

·         Working on creating Tableau dashboards on HANA information models.

·         Involved in publishing the Tableau dashboards to the Tableau server and training users to access the dashboards via Ipad and mobile devices.

·         Involved in creating complex calculations in Tableau and building visualizations by using different types of charts.

 

Environment: SAP HANA 2.0/1.0 SAP HANA SPS09/10/11/12, SAP BW/4HANA, SAP BW/BI 7.3, 7.4, 7.5 on HANA, Tableau 10.1.3, Web Intelligence, Analysis for Office 2.1, 2.3.2, 2.4, BPC, Query designer, BEx Analyzer.

 

3) Client: BB&T, Greensboro, NC                                                                               Oct 2015 – May 2017

Role:  SAP HANA BI BO Tableau Consultant                                                                                                  

Banking – Finance (Hyperion Replacement Project)

 

Description:

BB&T is one of the largest financial services holding companies in the U.S. with $181 billion in assets and market capitalization of $22.0 billion. The objective of this project is to replace all Hyperion reporting capability with SAP based reporting tools and delivery methods. Replacing the Hyperion application will also eliminate risk associated with limited support from Oracle (vendor) and retire the current Hyperion application and infrastructure from BBT’s landscape. The Hyperion replacement project scope includes self-service reporting capabilities, report delivery to a content manager, adhoc extracts, and outbound data feeds to other applications and databases.

 

Responsibilities:

·         Worked on redesign on SAP migration of Hyperion project to enable self-servicing report to end users.

·         Provided expert technical assistance with training, design and architecture tasks, and daily oversight of system processes and performance.

·         Involved in discussions with the functional and technical teams and the gathered the business requirements for the scope of the project.

·         Worked on financial data for GL, Non-GL, Profitability calcs, internal ratios, plan and forecast data.

·         Created HANA modeling scenarios and activities such as setting up HANA environment – adding a system, creating schemas and creation of USERs and ROLES, etc.

·         Expert in creation of Attribute Views, Analytical Views and Calculation views Graphical and SQL Script – CE Functions and Stored Procedures.

·         Monitoring the replication process using SAP native HANA studio and SAP LT replication server for transactional Integrity.

·         Created native SAP HANA Information Models using Attribute, Analytic and Calculated Views.

·         Replicated data using SLT and BODS and created models as per business requirement.

·         Expertise on data flows, query transforms, case transforms and replication jobs in SAP BODS and imported BW objects in native HANA studio.

·         Involved in creating different objects for the modeling which includes DSO, Cube, SPO and Multi Provider.

·         Worked on various inbound and outbound data feeds from Hyperion interfaces.

·         Worked on leveraging the existing models for the balance sheet and Income statement flows.

·         Developed performance improvement measures like pruning, aggregates, indexes and partitioning.

·         Involved in writing the start routines, end routines, expert routines and field routines as per the business logic.

·         Involved in creating end to end flow for analysis authorizations for BW objects for security purposes.

·         Involved in the Data source enhancements for the Business content extractors 0FI_GL_14.

·         Worked on 0FI_GL_60, 0FI_GL_14 and other generated financial extractors.

·         Involved in data loading and mirror data validations from source to target.

·         Involved in creating SIT scripts for the quality and staging environments.

·         Involved in creating various BEx queries for the financial needs and used Analysis for excel as a reporting tool for the end users.

·         Involved in creating EPM self-service input templates for the financial needs. 

·         Involved in creating various WEBI reports for the community banking financial purposes.

·         Involved in creating dashboard visualizations using Design studio and Lumira.

·         Involved in creating trending visual story boards using Lumira.

·         Worked on Charm process for moving the transports from Development system till production environments.

 

Environment: SAP HANA SPS09/10, SAP BW/BI 7.3, 7.4 on HANA, WEBI, Analysis Office for Excel, BPC, BEx, Analyzer, Tableau 8.x, 9.x, Lumira, Design studio and EPM.

 

4) Client: Memorial Health Care, Fountain Valley, CA                                      April 2015 – Sept 2015

Role: SAP HANA BI Analytics Developer/Architect                                                                               Health Care Domain

 

Description:

Memorial Care Health System is a nonprofit integrated delivery system that includes six top hospitals and as an innovator in health care delivery, Memorial Care focuses on evidence-based, best practice medicine. Our physicians and health care professionals study health care’s best practices and work to implement them at all our medical centers.

 

Responsibilities:

·         Worked as an architect role on advising and assisting in data modeling from legacy systems like Epic and Hyper wave.

·         Creating the dashboards for patient survey in hospital management using design studio.

·         Worked on creating universes and HANA views (Attribute views, Analytic views and Calculation views) and populating the data for Health Care Industry.

·         Designed Logical Data Model and database objects and developed Semantics Layers with UDT/IDT, Dashboards and Reports.

·         Created data visualizations and Dashboards using SAP Design Studio for the health care industry by using dimension filters, CSS styles, scripts and methods.

·         Creating patient detail reports using Web Intelligence in the front end.

·         Creating different visualizations by using charts and graphs for healthcare industry.

·         Creating models in the backend for Hospitality billing.

·         Created roles and assigned them to users of HANA.

·         Stored data in columnar and row store in Database.

·         Creation of multiple Graphical Calculation Views including Projections, Joins and Unions

·         Worked on various data models according to the requirement

·         Involved in the data provisioning tools SLT and Data Services for Hospital Industry.

·         Prepared various Testing Technical Documents, and User requirements.

·         Created Procedures to populate in Tables using Analytical and Calculated views.

·         Designed and developed operational dashboards with parameters, calculated fields, groups and hierarchies.

·         Developed workbooks with various functionalities and deployed them on Tableau server.

 

Environment: SAP HANA, WEBI, Design Studio, IDT, Crystal, Data Services, Epic, Hyper wave, Tableau Desktop 8, Tableau Server v8/v7.

 

5) Client: FTS International, Dallas, TX                                                              July 2014 – March 2015

Role: SAP HANA BW BO Consultant/Lead                                                

Manufacturing – Oil and Gas

 

Description:

FTS International is a leading provider of well completion services, including pressure pumping, wire line and pressure control, and water management. The company also has several international joint venture projects in progress. Exploration and production companies use FTSI’s services primarily to enhance their recovery rates from oil and gas wells drilled in shale and other unconventional reservoirs.

 

Responsibilities:

·         Develop HANA Models to Validate the Master Data and Transaction data Tables with multiple Analytical View, Attribute View, Calculation View, Restricted Measures and Calculated Measures.

·         Created analytic and complex calculation views using SAP HANA modeler.

·         Involved in Load testing of various calculation views with HANA BASIS DBA Team.

·         Experience in SAP HANA Data provisioning using SAP LT replication server (SLT) and data server.

·         Worked on SAP HANA Data provisioning, Delivery Units and Schema Mapping.

·         Experience in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system-generating joins.

·         Information Modeling in SAP HANA and Report Generation in BOBI 4.0 for Sales and Distribution module towards Comparative Analysis for Actual Sales and Planned Sales.

·         Data Replication using BODS 4.0

·         Execute migration from traditional DWH to HANA.

·         Experience implementing Rapid deployment solutions and modify HANA models.

·         Information Model Designing using HANA Studio.

·         Creation of multiple Graphical Calculation Views including Projections, Joins and Unions

·         Used SAP HANA XS engine for administration activities.

·         Worked on Catalog schemas with System Tables, Content Packages and Roles in the Security Folder.

·         Worked On SAP HANA Data Provisioning, Delivery Units and Schema Mapping.

·         Review and QA deliverables of the team.

·         Involved in BW system administration tasks.

·         Experience in Creating and executing Data Service Job in SAP BODS to populate HANA.

·         Created multiple Universes for ad-hoc and canned reports based on the relational data model that will replace the existing Stored Procedures as the data sources.

·         Worked on transports to different environments till production.

·         Designed SPO DSOs based on Fiscal Year and included the SPOs in the Multi Provider.

·         Worked on Installing the Business Content.

 

Environment: SAP HANA 1.0, SAP ECC 6.0, BI 7.4, HANA, ABAP, BPC, JOB PILOT, WEBI, Design Studio, OLAP, BEx, BO, Tableau Desktop 7, Tableau Server 7.

 

6) Client: BB&T, Greensboro, NC                                                                          June 2013 – May 2014

Role: Sr. SAP BW/BI/BO Consultant                                                                                                  

Banking – Finance (Project One)

 

Description:

BB&T is one of the largest financial services holding companies in the U.S. with $181 billion in assets and market capitalization of $22.0 billion. Based in Winston-Salem, N.C., the company operates 1,842 financial centers in 12 states and Washington, D.C., and offers a full range of consumer and commercial banking, securities brokerage, asset management, mortgage and insurance products and services.

 

Responsibilities:

·         Worked on business requirements gathering and gap analysis to identify gaps that existed from standard business content.

·         Worked on installing and configuring various master data, transaction and hierarchy related data sources and replicated them in BW.

·         Installed business content and worked on FI data sources 0FI_GL_14, 3FI_GL_0L_TT, 3FI_GL_DL_TT and 3FI_GL_SL_TT.

·         Developed several customized Info Objects, Info Cubes, SPO’s, DSO and Multi Provider according to specifications provided by the client.

·         Involved in creating SPO partitions for all the reporting years and included SPO’s on top of Multiprovider for reporting.

·         Involved in SAP data modeling by new HANA models and data analysis by building standard and custom BW solutions such as Info Cube design and creating custom semantically partitioned objects (based on Info Cube and DSO), DSO’s and Info Objects.

·         Involved in creating balance sheet and income statement flows for reporting purposes.

·         Involved in creating canned and adhoc reports using BEx query designer and connected the queries with Webi using BICS connectivity.

·         Involved in data loading, job monitoring and created process chains for automating the process.

·         Worked on various inbound /out bound interfaces from ETL and Informatica and to third party via open hubs.

·         Created various financial reports related to General Ledger and had given the data to the BPC.

·         Utilized all the performance tuning methods that helped queries to run fast for business.

·         Collected all the developed objects and released the TR’s.

·         Created queries using BEx and then generated universes and reports using Webi.

·         Enhanced FI-GL data sources and populated the data from them.

 

Environment: SAP ECC 6.0, BI 7.3, HANA, ABAP, BPC, ETL, HPQC, WEBI, BEx, BO.

 

 

7) Client: Kraft Foods, NJ                                                                                             Feb 2011 – May 2013

Role: SAP BI BO HANA Analyst                                                                                                          

Food and Beverages

 

Description:

Kraft Foods Group, Inc. was an American food processing and manufacturing company headquartered in the Chicago suburb of Northfield, Illinois. The company was restructured in 2012 as a spin off from Kraft Foods Inc., which in turn was renamed Mondalez International. The new Kraft Foods Group was focused mainly on grocery products for the North American market, while Mondalez is focused on international confectionery and snack brands.

 

Responsibilities:

·         Extracted master data/transactional data into BI landscape (data from both SAP R/3 and external source systems) with custom extractors, modifications, enhancement of business content extractors, generic extractors, transports and process chains.

·         Developed several standard and customized master data Info Objects/texts, Info Cubes, DSO and Multi Provider according to specifications provided by the clients.

·         Performed LO-Cockpit extraction to extract the header and line item data from SD module (Sales Order, delivery and billing (2LIS_11_VAHDR/VAITM, 2LIS_12_VCHDR/VCITM and 2LIS_13_VDHDR/VDITM).

·         Created multiple Universes for ad-hoc and canned reports based on the relational data model that will replace the existing Stored Procedures as the data sources.

·         Developed SQL and PL/SQL scripts to implement business logics of database through Stored Procedures.

·         Involved in creating the Graphical Calculation Views by including the analytic views using Unions, Projections and Joins based on the business logic.