SAP
Mahesh Srinivasula
Downingtown,PA
Summary
Profile Highlights 16 Years of SAP Experience SAP, Beas Manufacturing on SQL and HANA, Business Intelligence, Integrated Planning, Business Objects (BOBJ), IS-Utilities, SRM, CLM, SPM (Spend Performance Management), APO, and Global implementations/rollouts. Experienced and enthusiastic Consultant with track record of success across wide range of industries. Possesses exceptional interpersonal, problem-solving and analytical skills to provide advice and expertise to client organizations improving business performance. Experienced in all aspects of operations, strategy and finance.
Overview
17
17
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
Work History
Sr. Business Analyst
Certified SAP
09.2016 - Current
- Installing Business One, beas manufacturing Addon, Crystal reports B1 Usability Package and configuring business applications based on SAP and Beas manufacturing process
- Blue Printing business process, Design Specs, and managing implementation till Go live and post go-live support
- Developing menus and screens by using dialog programming methods
- Developing and designing process to integrate Business One with third-party applications
- Planning project schedules
- Supervising and maintaining MS SQL backups and SQL servers
- Recommending and responding to issues and questions regarding software implementation
- Creating reports by using queries, user-defined fields, formatted searches, and user-defined tables
- Conducting training for users on SAP functionality
- Assisting users regarding screen and menu development to streamline their process flow
- Developed forms and structures of Print Layout designs
- Assisted project manager in handling ERP implementation projects
- Provided technical support in case of issues related to SAP Business One, and SQL Server setup
- Handled system integration, configuration, and initialization
- Generated reports through PLD and Crystal Reports
- Analyzed and customized Ledger, Sales, Purchase, and other modules as required.
BI HANA BOBJ Business Analyst
Genentech, SFO SAP
06.2014 - 09.2016
- Worked with global procurement users for reports, dashboards, KPIs, Metrics, and Scorecard requirements and Conducted workshops
- Present mockups to finalize Global Procurement Reporting requirements on HANA and BOBJ reporting tools
- Documented Global user requirements and gaps to evaluate the requirements to report mapping
- Worked with functional teams to standardize payment documents and tax postings for global reporting
- Prepared Functional Specifications to assist CLM HANA technical design
- Integrated Contracts (CLM), PO (SRM), and Invoice (ECC) data for cross-functional reporting KPI requirements
- Worked with ARIBA Back Office Associates (BOA) Team to extract and cleanse data from ARIBA
- Developed a complex security model for highly sensitive contracts accessed by respective contract teams
- Design and Developed Procurement report in BOBJ – Analysis for OLAP and Web
- Worked with the security team in setting up Portal Roles and user-group alignment
- Prepared test scripts in “HP-ALM” and developed BOBJ Reporting navigation training material and led Global UAT sessions and managed the BI IT and BOBJ teams to ensure timely completion of deliverables
- Modelled multiple views on Business Suite HANA for EDW Extract to Support Downstream Interfaces
- Created an Order Flow & Real-Time Order Fill Calculation View to support OTC Business
- Created multiple Story Books on Lumira 1.30 using HANA Connections for PTP and OTC Process
- Supported BW extracts for Purchasing, Quality, and Finance Modules for BW reporting
- Worked on Smart Data Access to Connect Remote HANA Server and Model-based on Virtual Tables
- Designed Complex security model for sensitive contract access Involved in Modelling of HANA Security
- Environment: SAP BI 7.5, HANA CLM 9.0, SRM 7.0, ERP 6.0, BOBJ 4.1, BEx, WAD, and Portal 7.3.
BI Business Analyst
Computer Associates, SAP
New York
12.2013 - 05.2014
- Managed off-shore/on-shore SAP SRM BI reporting implementation teams and was responsible for global procurement reporting and project handoff to the offshore team for support and maintenance
- Migrated BEx and Portal reports to Business Objects 4.0 and implemented Global SAP BI SRM e-Procurement operational reports Involved in collecting and understanding reporting requirements to prepare URS
- Developed and deployed custom reports for purchasing teams and dashboards for senior management
- Worked with BI technical team to design data models and architecture to extract data from SRM and ECC for BI reporting, Portal Dashboards, and analytics
- Cutover lead for preparing production rollout and conducting CAB meetings
- Environment: SAP BI 7.3, SRM 7.0, ERP 6.0, BOBJ 4.0, BEx, WAD, and Portal 7.3.
Hampton Sr. SAP BI/BOBJ Consultant
Ikaria Pharmacy
06.2013 - 12.2013
- Worked with KPIT reporting implementation team and was responsible for project deliverables, preparing timelines and tracking project status, and aligning with a strategic roadmap
- Working with Business users for Reporting requirement gathering and designing functional, technical Specifications “Finance, Sales, Customer Service, and Revenue”
- Preparing business blueprint and project timelines for BI reporting system design
- Enhancing extractors for finance and Revenue, FP&A report requirements
- Design Planning worksheets for revenue forecast using Integrated Planning
- Developing Data set Bex queries for BOBJ reporting, Design and developed WEBI query and WEBI reports
- Preparing test scripts for UAT, working with business users for Data validation
- Creating APD’s to move data Query data from BW to the application server in file format
- Working with KPIT offshore team, review developments and defects resolution status
- Modules & Extractors: SAP BI7.3, Integrated Planning FI-GL, CCA, SD-Billing, SD Orders & Purchasing.
Sr. SAP BW/BI Analyst
Target Technology Services
Minneapolis
01.2013 - 05.2013
- Worked with global reporting users to collect requirements for Indirect Spend Project Accountancy (ISPA) BI reporting and was responsible for creating functional and technical specifications
- Worked with functional leads in designing extraction solutions for Procure-to-Pay (P2P)
- Prepared production cutover activities, co-coordinated with BW team areas: FI, PS, and P2P, and helped business users in data reconciliation with SRM and ECC
- Worked with offshore consultants in development reviews and defect resolution
- Developed WebI Reports using Universe as the main data provider
- Designed Universes for Capacity utilization, Sales Order Processing, Sales Analysis by location, and Sales Analysis by country reports
- Created Web Intelligence Documents using Multiple Queries, filters, formulas, and cascading parameters
- Developed InfoViews to improve the performance of WebI reports
- Environment: SAP BI 7.3, SRM, MM, AP, AR, FA, PS, BOBJ 4.0, BEx, WAD, and Portal.
SAP BI/BOBJ Architect
Tate & Lyle
05.2012 - 12.2012
- Responsible for working with business users and functional consultants to finalize the requirements (RICEFs) and design architecture to extract actual data from SRM, CRM, and ECC for Demand Planning and SNP BI reporting
- Worked on the interface from DP/SNP/APO forecast to ECC planned orders
- Utilized the Analysis Process Designer (APD) to perform custom calculations of projected inventory
- Designed data warehouse layer to support SD, MM, PP, FI, AR, and AP Document-level data storage
- Designed InfoProviders, MultiProviders, and virtual cubes to support SD, MM, PP, FI, AR, and AP reporting requirements and Implemented new BI 7.0 security authorization objects
- Developed custom data sources using database views and custom function modules
- Utilized the Analysis Process Designer to populate summary cubes using complex queries on revenue cubes
- Published iViews to the Enterprise Portal to be used by external business partners to access BI data
- Worked with onshore/offshore consultants for BI-APO Implementation, testing, and defect resolution
- Environment: SAP BI 7.0, APO, SRM, CRM, MM, AP, AR, CO-PA, Bex, and BOBJ 4.0
SAP BI/BOBJ Management Analyst
IMS Health
Philadelphia
02.2010 - 04.2012
- Led managed and implemented Global BI project in the areas of SAP’s Spend Performance Management and SRM E-Procurement Operational Reports
- Responsible for Project Scoping and Planning, Defining Business BluePrint, and Supporting the Global implementation team through the realization/Testing/Production Phases
- Developed and deployed Strategic Reports/Dashboards/Briefing-Books to analyze Global Spend Management and Provide Detailed Procurement Reporting (PO/Invoice/Goods–Receipts /Shopping Carts/Contracts) across all divisions
- Developed and deployed Standard/Custom Reports for Purchasing teams and Dashboards for Executive Analysis, identifying cost savings opportunities and reducing enterprise-wide “Non-Managed” spending
- Integrated external hierarchies like Commodity Codes and Suppliers from OPERA to BI system and Commodity mapping for non-PO historical postings
- Created Roles for Reporting Users based on their functions in the organization
- Designed and implemented the BI security model for restricting the Data access based on various organizational elements for Global users and
- Trained global user community on Strategic and Operational BI reporting
- Environment: SAP BI 7.0, Spend Analytics 3.0, SRM, MM, AP, Inventory Management Accounting, BOBJ 4.0.
SAP BI/EPM Consultant
PERTAMINA, National Oil & Gas
09.2008 - 01.2010
- Responsible for value-driven strategic solutions in the global finance analytics and reporting space
- Led requirement gathering and defining the scope for overall Information Flow of Strategic level, finding the Gaps in the current Information flow and providing solutions
- Conducted Workshops with senior management including the Board of Directors for KPI definition, Legal Management Consolidation, Strategic & Operational Planning, and Risk Management
- Created design documents that depict the KPIs and the alignment of KPIs for the Group & its Subsidiaries and created design documents for Legal & Management Consolidation & Reporting
- Implemented 60 critical KPIs across the Value Chain from Upstream/Downstream (Refinery, Maintenance & Travel and Supply Chain), Finance, HR and to support Strategy Management, Including the target-setting
- Created Management Cockpits to facilitate a better visual presentation for the Management and the Government
- Created Strategies, Objectives, and Perspectives toward the Organizational Vision
- Created Balanced Scorecards for the CEO and Board of Directors to enable the Organization’s Strategy Management
- Created Cause and Effect Sequence aligned with Organizational Objectives
- Created Aggregation levels and implemented the planning and target-setting processes for all the organization-wide KPIs across the functions: Upstream, Downstream, Finance, HR, and other supporting functions
- Performed Unit Testing, Integrated Systems Testing, and User Acceptance Testing
- Environment: SAP BI 7.0, Balance score Card, CO-CCA, SD-Billing, Inventory Management, Project Systems, Shipment, FIGL-New Ledger, AR, AP, BCS-Legal, and Management Consolidation.
SAP BI Consultant
ConAgra Foods
Omaha
03.2007 - 08.2008
- Designed and Implemented BI project Identified stakeholders, collected requirements, performed GAP analysis, and documented short-term and long-term business reporting needs
- Re-designed Financial Data Model to achieve better performance and improved maintenance for high data volume, multi-sourced, complex financial data
- Designed and developed user-specific Sales Dashboards with charts, tables, trend graphs, alert messages, and other interactive drill-down capabilities using queries and views
- Worked on Transport management in BI landscape and assisted BI admin team in implementation
- Designed migration strategy from BW 3.5 to BI 7.0
- Interacted with the management and business end-users to identify business requirements and was actively involved in the overall project implementation
- Designed and implemented the migration of 3
- X data sources to new RSDS data sources and Data transfer process (DTP), separated the delta mechanism for different data targets
- Environment: SAP BI 7.0, IP, CO-CCA, FI-Asset Accounting, FIGL-New Ledger (Legal View & Profit Center View), workbooks, BEx Report Designer, and WAD.
SAP ABAP/BW Consultant
WR Grace
, Maryland
06.2006 - 02.2007
- Worked as a techno-functional consultant developing, configuring, and supporting SAP/BW applications and ABAP
- Involved in entire software engineering life cycle phases including Quality Assurance, Production Support, and Training
- Extensively used ASAP methodology
- Worked with cross-disciplined members in Finance, Logistics, and HR by preparing POCs, logical data models, workflow diagrams, and dashboards
- Environment: SAP BW 3.5, ECC 4.7, FIGL, CO-CCA, AP, AR, SD-Billing, Inventory BEx Analyzer, and WAD
- 1 | Page
Education
ACIJP (Advanced Certification Internet & Java Programming - Computers
APTECH
Mumbai 06.2000 - 03.2002
MBA - Systems & Finance
Anna University
04.2002 - 04.2004
Skills
Disaster Recovery Planning
Analysis & Evaluation
Budgeting /Financial Planning
Strategic planning
User support
Cloud Computing
Data Warehousing
Project Management
Processes and procedures
Reporting capabilities
Accomplishments
- AWS/HANA Certified Solution Architect with proficiency in cloud services
- Summary
- Implemented full life cycle and Migration Projects in Business one 9.0, 10, beas manufacturing, BI 7.5, SRM, SPM 2.0, SCPM 2.0, IP, APO, BW 3.5, and 3.1 Content
- BW 3.5 to BI 7.0 upgrades and worked with all phases of ASAP methodology for SAP BI (IS-Utilities, FI/CO, MM, SD, HR, PP, PM, CLM, SRM, ARIBA, CRM,)
- Project Management
- Managed SAP global Implementation projects including migration and upgrades
- Led off-site and on-site delivery model and assisted in setting up a Center Of Excellence (COE)
- Business Analysis
- Business analysis for metrics and KPIs across Manufacturing, Procurement, Finance, Sales, and Supply Chain areas
- Expertise in translating complex business process data flows and data modeling concepts to end-users, business analysts, functional experts, and senior management
- Exposure in Corporate Information flow gap identification and redesign processes
- HANA Modeling
- Expert in HANA In-Memory Management, HANA Architecture, SAP HANA Studio, and ABAP on HANA
- Expertise in SAP HANA Studio, usage of SAP HANA views in ABAP, and Intertegrating live data from HADOOP using SDI “Smart Data Integration”
- Expert in the design of HANA Attribute Views, Analytic Views, Calculation Views Objects, Customized Queries, etc., Business Content Enhancements & HANA Reporting
- BI Suite (BOBJ) Reporting
- Extensively worked on SAP BI components from data sources, expert routines, start routines, end routines, Function modules, and Variables
- Experienced with BI reporting using Business Objects 4.1, WebI, BEx Analyzer, Query Designer, Report Designer, and Web Application Designer (WAD)
- Expertise in creating universes, and building queries with the use of restricted/calculated key figures, complex structures, customized variables, conditions, and exceptions to provide customized reports for various business user groups
- Experienced in web publishing of BO/BEx reports, customized web templates, dashboard designing, integration of Enterprise Portal, security models for reporting, and Information Broadcasting
- Industry Experience
- Healthcare, Pharmaceutical, Biotech, Oil & Gas, Government Aerospace, Defense, Food & Beverages, Insurance, and Retail and Construction.
Software
HANA
SQL
Manufacturing Integration and Automation
Certification
Beas Manufacturing
Biking and Half Marathon runs
I have a personal goal of bicycling 10,000 miles in United States in 5 months. and I halfway through for "Fulfilling a goal.."
Timeline
Beas Manufacturing
06-2022
Cloud Computing
05-2017
Sr. Business Analyst
Certified SAP
09.2016 - Current
BI HANA BOBJ Business Analyst
Genentech, SFO SAP
06.2014 - 09.2016
BI Business Analyst
Computer Associates, SAP
12.2013 - 05.2014
Hampton Sr. SAP BI/BOBJ Consultant
Ikaria Pharmacy
06.2013 - 12.2013
Sr. SAP BW/BI Analyst
Target Technology Services
01.2013 - 05.2013
SAP BI/BOBJ Architect
Tate & Lyle
05.2012 - 12.2012
SAP BI/BOBJ Management Analyst
IMS Health
02.2010 - 04.2012
SAP BI/EPM Consultant
PERTAMINA, National Oil & Gas
09.2008 - 01.2010
SAP BI Consultant
ConAgra Foods
03.2007 - 08.2008
SAP ABAP/BW Consultant
WR Grace
06.2006 - 02.2007
MBA - Systems & Finance
Anna University
04.2002 - 04.2004
ACIJP (Advanced Certification Internet & Java Programming - Computers
APTECH
06.2000 - 03.2002