Mohan Govindarajan

SAP Project Manager

214-***-****

adoz6t@r.postjobfree.com

Professional Summary:

Mohan is an experienced SAP Certified BW / HANA Enterprise Applications Practitioner with a wide range of expertise and skills, that includes SAP HANA (in memory computing engine) Business Intelligence / Data Warehouse management, process redesign with information systems planning and implementations. He possesses a Master’s in Manufacturing Engineering (The University of Texas at El Paso). His extensive experience includes working in the automotive, semiconductor, aerospace and defense sectors. He has excellent communication and organization skills and is a highly regarded team player. Mohan also possesses strong technical and functional knowledge of the BI - FI, SD, MM and PP packages.

●17 + years of professional experience in project management, analysis, design, development and implementation of business applications that includes custom development in SAP and BI and possess active SECURITY CLEARANCE.

●SAP S4 HANA 1709 Implementation

●SAP HANA - SLT/BODS Replication Methodologies

●SAP HANA Modelling/Analytical Views/Calculated Views

●SAP BODS, Information Steward

●Back office Cransoft/dsp toolset

●System Landscape Architecture Design

●Database Troubleshooting

●SQL/Microsoft SQL Server/Oracle

●SAP MM, PP, SD, FI, WM, P2P

●Program management

●AIM Practice lead

●RFP, SOW, Hiring, Interviewing

●Strategic Planning and Implementation

●Software Development Life Cycle

●Data Governance/Management

●Business Intelligence, Data Modeling

Technical Skills:

OPERATING SYS : UNIX, AIX, Windows Server 2008 R2, Linux.

DATABASES : SAP HANA, DB2, and MS-SQL – 2008, 2012

MIDDLE WARE / ETL : SAP XI, Business Objects Data Services 4.1, Informatica.

APPLICATIONS : SAP ERP, ORACLE Financials, SAS, SAP BW, SAP CRM.

REPORTING TOOLS : SAP Report Writer, SAP Report Painter, Business Objects4.1, Bex Analyzer, and Report Writer.

Professional Experience:

Lyondell Basell, TX 07/2020 - present S4 / HANA Consultant

●Managing a portfolio of functional and technical projects relating to its SAP systems.

●Working with clients to determine project definition and business requirements.

●In charge of the contractual and administrative aspects of a SAP project.

●Managing client and stakeholder relationships at project level.

●Providing leadership to project teams and clients in a SAP environment.

●Extensive experience in successfully implementing greenfield and brownfield migrations from ECC to S4/HANA, solving HANA performance issues, Databases, and Operations.

●Highly skilled professional with 22 years of proven track record in significant client facing roles, utilizing strong technical, analytical and management skills to successfully complete complex systems integration and governance within Pharmaceutical, Healthcare, Energy, Oil & Gas, Retail, Manufacturing and Food sectors.

●Confidential has In - depth expertise providing elegant solutions that improve corporate quality and efficiency, well-versed in all aspects of technology stack.

●Collaborated with internal and external stakeholders; worked cross-functionally blending technical, project management, and leadership disciplines.

Kubota Manufacturing, TX 07/2019 - 6//2020

SAP S/4 HANA Technical Lead

●Met business stake holders to understand the business requirements

●Worked with functional consultants to understand the blueprint

●Configured the Data services and SLT to connect to S4/HANA.

●Conducted meetings with business shareholders to share the data quality scorecards

●Architected and Configured local, Central and Profiler repositories and Management console.

●Managed and reviewed data conversion rules and data quality rules

●Worked with business to cleanse the data

●Designed and documented the data migration approach and mentored the team to work in silos.

●Administered the dry runs and collaborated with security, basis and functional teams

●Worked with cutover team to plan the data loads and cleansing efforts.

●Report the delivery stats, issues and work with SAP incidents with SAP management,

●Shared metrics with stakeholders and PMO

Ziimmer Warsaw, IN 05/2018 - 06/2019

S4/Hana Project Manager / Technical Lead

Roles & Responsibilities

●Designed Data migration from SAP ECC to S4 HANA using SAP SLT and Data Services

●Collaborated with Functional SME’s to generate requirements and data ETL procedures

●Played a technical liaison role with functional and business users to generate data mapping and data Validation technical documents.

●Leading the effort of optimizing the loading process of large financials ( SAP AR, AP, GL and Recurring ) data sets including both transparent and clustered tables from legacy ECC to S/4 HANA.

●Designed and implemented Customer Master Data mapping and reference data implementations in SLT using ABAP include programs.

●Implemented performance filters, source side filtering for migrating large data sets.

●Designed and configured SLT Replication (Real time and Batch) from SAP ECC sources using HANA Data provisioning and BODS.

●Expertise in CMC configuration and administration of SAP Data services repositories.

●Balancing the efforts required to complete a project.

●Project status reporting.Basis project planning steps for the scope of work.

●Pre and post migration activities relating to BW/4HANA conversions for info cubes, dso and infopackages.

●Involved in the Landscape build on SAP NW 7.5 & HANA SP12

Cardinal Health, Columbus, OH 11/2017-04/2018

HANA / BPC HANA Technical Architect

Roles & Responsibilities

●Configured the new GL functionality (standard company hierarchy, account groups, accounts for company codes, fiscal year variant, field status variant and posting period variant, implementation of parallel accounting methods and document splitting)

●Configured AR/AP for customers based upon interest calculation on items, account balance configuration / validation of substitution rules for documents, recurring entries, taxes, currencies and correspondence

●Customized payment terms for Dunning and down payments, lockbox application in compliance with the BAI2 Format

●Developed the future state architecture for extraction, transformation and loading of data from SAP and non-SAP sources.

●Hierarchy flattening and loading to SAP HANA.

●Development of CDS views, basic, composite and customized views.

●Took the role of project manager for process improvements, which included estimating projects, designing project plans, held update meetings with stakeholder and supported teams.

●Hosted workshops with all business parties involved to gather business requirements.

●Designed and mapped business processes and business solutions.

●Presented requirements and solutions to senior management

●Managed the delivery of business change and business readiness, working closely with the business to ensure the solution is delivered at a high quality.

●Coordinated testing, cutover activities, and managed post go-live support for SAP system.

●Managed offshore team, organizing testers, test scripts, and delegating workload.

●Configuration and maintenance of security profiles in HANA.

Arthrex, Ft Myers, FL 02/2017-10/2017

S4 / HANA Project Lead

Platform 1609

Roles & Responsibilities

●Logistics lead supporting Production, Procurement, Intercompany and Billing process areas.

●Lead S/4 HANA migration workshops covering delta training, end-user impacts, and conversion topics.

●Support data conversion, testing, and issue resolution.

●Coordinate issue resolution with an off-shore S/4 Center of Excellence.

●Development and implementation of the security model utilizing Windows AD for HANA and BOE.

●Performance Analysis of complex embedded calculation views utilizing SQL View Plan.

●Familiar working with the linked database feature and naming convention (three part).

●Have developed hierarchies utilizing the hierarchy generator function.

●Managed a team of 8 consultants (on shore/ offshore)

●Led in the requirements gathering sessions for the reports.

●Responsible for coordinating the daily meetings, ensuring delivery timelines and providing technical solutions and architecture.

●Work with Business Analysts to test and validate integration and regression tests.

●Ensure all documents are updated to HPQC and coordinated the test results / resolution with the off-shore team.

Waters, Burlington, MA 09/2016-01/2017

SAP Hana Project Lead

Roles & Responsibilities

●Managed the project and worked with the client on establishing timelines, schedules, resource allocations and status of projects.

●Requirements gathering for COPA, GL and Sales contracts reporting.

●Architected and developed the solution, in native Hana.

●Architected the solution for optimizing the profitability Analysis reports by improving performance by 40%.

●Mentored, trained and on boarded developers and senior consultants.

●Assisted with technical design documentation.

Keurig, Burlington, MA 06/2014-08/2016

Project Manager

SAP HANA 1.0

Roles & Responsibilities

●Defined and initiated SAP BW / BW on HANA project to manage risk by monitoring cost, schedule, and performance of component projects, while working to ensure the ultimate success and acceptance of the program.

●Architected and managed the solution implementation and delivery from various SAP and non-SAP source systems to HANA, for subsequent reporting utilizing BOE.

●Managed a team of on shore and offshore consultants (30), responsibilities included onboarding, mentoring and managing requirements gathering sessions.

●Manage expectations of stakeholders, define and develop the Governance documents, assist and provide feedback on SOX compliance.

●Produced project status reports, managed the team and resolved day-to-day issues with emphasis on SDLC.

●Extensively worked with SAP financial hierarchies and SAP financial tables.

●Configure data manager extraction from ECC and BI system for the actual, plan data .

●Usage of conversion, transformation files for the data management process.

●Configure the application set, Configure application for legal, Management consolidation,

●Create, Maintain custom dimension/ info object, dimension property, dimension hierarchy for entity, account, product, time

●Correspond with SAP on the product bug, defects, apply the OSS note.

●Maintaining the exchange rates in the rate application.

●BPC process chain development to the financial data to staging DSO and to the cube

●Process chain development to support master data loads from BW to BPC

●Executing the optimization tool for lite and full optimization

●Maintaining the FI configuration required for BPC consolidation such as Operations account, group

account relationship, intercompany elimination, trading partner related settings, Currency and rate

maintenance.

●Loading the historical data, opening balances, current year data to BPC application from Hyperion ESSBASE.

●Responsible for the recruiting, management and onboarding and career development of consulting staff.

●Managing client expectations, monitoring project costs and schedules, establish relationships and maintain effective communication with stakeholders, both internal and external to the organization.

●Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization.

●Responsibilities included managing and mitigating risk, (technical, infrastructure and resources) and expectations of the customer.

Reynolds, Chicago, IL 06/2014-08/2015

SAP BI/BW HANA Technical Architect

Roles & Responsibilities

●Extracted data from Hyperion ESSBASE, Great plains, JDE, Oracle Financials and Siebel to SAP BPC.

●Experience with BCS / BPS design, development, support, maintenance and interfaces.

●Responsible for the administration of the HANA development environment and managed security, backup, restore and other troubleshooting related to the HANA server.

●Provided business consulting, technical knowledge and expertise in SPM techniques and methodologies, process assessment work, and the application of technologies to business.

●Led the development of test scripts and creating and uploading test plans to HPQC.

●Creation of test sets, documenting test results and SIR’s (defects) in HPQC.

●Creating and building test requirements (scripts) and uploading the same to HPQC.

●Mapping the test plan to the test requirement for update of the Requirement Traceability Matrix.

●Administration and installation of Business Objects Enterprise, Business Objects Data Services, Information Steward, DQ and DS.

●Definition of the solution architecture, integration, configuration and installation of SLT server, for replication of data from SAP source systems.

●Development and implementation of the security model utilizing Windows AD for HANA and BOE.

●Definition, configuration of NFS/ FTP mounts for Windows / AIX platform integration for ETL services utilizing BO data Services.

National Grid, NY, Boston, MA 11/2013-06/2014

SAP Project Manager

Roles & Responsibilities

● Defining and setting goals for the individual members of the team. Training development plan.

● Managed a team of 28 to 32 technical resources as well as authored Statement of Work.

● Manage and evaluate risk, assess mitigating factors and resolve contingencies.

● Coach, mentor and lead personnel within a technical team environment.

Zurich, Chicago, IL 01/2013-10/2013

SAP Solution Architect

Roles & Responsibilities

●Development of complex models utilizing hierarchies and SQL for profit / loss, balance sheet and expense reporting.

●Worked extensively with financial hierarchies – flattening, modelling and reporting of compounded hierarchies in financial reporting.

●Coordinated all test, development and end user training efforts.

●Worked with the SAP HANA COE team to build profit and loss, Report card, Expense reporting and other financial reports.

●Development of the DMO project plan that transforms the current reporting architecture for enhanced and optimal reporting utilizing SAP HANA.

●Manage expectations of stakeholders, define and develop the Governance documents, assist and provide feedback on SOX compliance.

●Produced project status reports, managed the team and resolved day-to-day issues with emphasis on SDLC.

●Responsible for the recruiting, management and onboarding and career development of consulting staff.

●Managed and perform the process of Statement of Work and contract creation to secure new and follow-on work.

● Managed 8 to 10 technical resources as well as authored Statement of Work.

Alacrity Solutions/ County/Gov 11/2011-04/2012

SAP BW / BI Lead

Environment : ECC 6.0, BI 7.0, BOBJ 4.0(Business Objects Reporting XI)

Roles & Responsibilities

●Managed a team of 5 on shore consultants and 7 offshore consultants.

●Co-ordinate, implement and monitor the activities of the BASIS, BOE, and DATA Services teams and resolve day to day issues.

●Administration, upgrades, renaming, backup, recovery performance traces, hash partitions, table partitions, user administration, query optimization involving SAP HANA.

Alacrity Solutions/ Amtrak 10/2011-11/2011

SAP BI Lead

Roles & Responsibilities

●Managed the end user solution for client (SAP BW, BOBJ architecture, configuration and sun setting of existing landscapes)

●Architected the solution for transitioning from Legacy databases to SAP BW.

●Implemented / architected the solution roadmap for as is to future state landscape.

●Definition, configuration and management of interfaces, reporting tools, archiving and data cleansing and data management.

●Query optimization, management of table spaces, indexes, load balancing, configuration for broadcasting and extensive experience monitoring, configuring administrative cockpit.

●Creation of Universes based on Bex queries and Webi reports.

●Development of Bex queries and user exits.

●Extraction and of data from non-SAP sources.

Dey Fischer Consulting, Sedalia, MO 07/2011-10/2011

Data warehousing Lead

Roles & Responsibilities

●Successfully architected a solution to extract data from MSSQL to SAP BI (7.1) utilizing MS Visual

Studio 2008.(SSIS)

●Designed and developed the data model to extract sales, billing and delivery data. Developed and

successfully deployed the move forward ARUN report for AFS Sales Org.

●Requirements gathering workshops for the shipping, purchasing and inventory reconciliation reports.

●Development and deployment of AFS queries utilizing user exits, restricted and virtual key figures.

Dey Fischer Consulting, Sedalia, MO 12/2010-06/2011

Bass Pro Fishing, Columbia, SC

BI Lead / Strategy management

Roles & Responsibilities

●Develop and implement the Business Intelligence Roadmap.

●Experience of more than 3 years as a Business Objects Developer.

●Created Repository and assigned privileges to users and groups using Supervisor.

●Imported/ Exported the Universes from/ to repository to make them accessible to end-users.

●Defined Aliases and Contexts to resolve loops in the universes.

●Created User Conditions and Filters to improve report generation & readability of report and displayed the summary of data by creating Charts.

●Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.

●Manage team member’s tasks and identify and resolve technical and business issues.

●Manage and implement the reporting requirements for Inventory, forecasting and MRP. (development thru post go live phase)

●Defining the current state to the future state architecture and landscape.

●Develop and implement naming standards for all BI development objects.

●Identify and document technical and business pain points as it affects system upgrades.

Dey Fischer Consulting 11/2009-09/2010

Estee Lauder, NY

Consumer / Retail

SAP BI Senior Consultant

Roles & Responsibilities

● Extensive Analysis to Design the Universes and assigned those to respective domains.

● Facilitated the gathering, consolidation and prioritization of client business requirements

● Documentation and presentation of business requirements for a variety of audiences including client executives, project managers, end users and technical designers and developers.

● Participated in creating current and end state functional business intelligence vision and implementation plan

● Participated in designing and developing the architecture for all business intelligence solution components

● Contributed to the design of business intelligence application solutions including database design, ETL, report design and analytics integration.

● Lead data warehouse analysis and design activities.

● Translated business requirements into functional application requirements and logical data model requirements.

● Performed source system analysis, identifies key data issues and performs data profiling.

● Captured and compiled meta data and help define and deploy B.I. meta data strategy

● Review and approve functional and technical specifications for offshore development.

Lockheed Martin, Dallas, TX 11/2008-12/2009

BI Sr Developer / Functional Analyst

Roles & Responsibilities

● Involved in Installation and Configuration of all products of Business Objects.

● Perform quality assurance and testing of SQL server environment

● Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management

● Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.

● Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

● Provided business consulting, knowledge expertise in strategic performance management methodologies, process assessment work, and the application of technologies to business.

● Configuration of business partner functions, XI/ Bi connectivity, ABAP / RFC connections etc.

● Extraction of real time data from SAP XI to BI utilizing proxies (ABAP).

● Definition, design and deployment of the current and future state architecture landscape, which included integration of MDM, BI, ECC and other Legacy systems.

● Facilitation of requirements gathering sessions, definition of functional specs, technical specs and peer reviews.

● Fulfilling all government documentation requirements per government guidelines for the SRM, TRR, and VDD etc.

● Maintain continuous alignment of program scope with strategic business objectives and make

recommendations to modify the program to enhance effectiveness toward the tactical result or strategic intent.

● Proactively managed systems development, implementation and risk via the use of SDLC.

Lockheed Martin, TX 06/2007-10/2008

SAP BI Reporting Architect

Roles & Responsibilities

● Managed a team of three consultants whose responsibilities included...

● Configuration of DB Connect for extraction of data from Oracle databases.

● Definition, development and configuration of BI security.

● Configuration of partner profiles and the SAP portal.

● Extraction of data from ECC – PS Utilities for water and electricity revenue accumulation etc.

● Development of reports utilizing report designer, WAD, and Visual composer.

Harry & David, OR

BI Performance / reporting Architect

Roles & Responsibilities

●Responsible for the recruiting, management and career development of consulting staff.

●Monitored project activities and advised staff of issues due to resource availability.

●Definition of the current and future state architecture.

●Defined and implemented the Data Archival strategy and the Reporting Strategy.

●Managed and perform the process of Statement of Work and contract creation to secure new and

follow-on work.

●Managed performance at the strategic level based on monitoring of the most critical users, the kind

of data being most frequently accessed the assessment of how IT infrastructure is being used.

●Developed and implemented the archiving strategy, archiving data to improve performance on the

cubes.

Environment : SAP BI 7.0, SAP BW 3.5, SAP ECC 6.0.

Walmart, AR

SAP BI Lead

Roles & Responsibilities

● Facilitated the gathering, consolidation and prioritization of client business requirements

● Documentation and presentation of business requirements for a variety of audiences including client executives, project managers, end users and technical designers and developers.

● Contributed to the design of business intelligence application solutions including database design, ETL, report design and analytics integration.

● Lead data warehouse analysis and design activities.

● Translated business requirements into functional application requirements and logical data model requirements.

● Performed source system analysis, identifies key data issues and performs data profiling

● Captured and compiled meta data and help define and deploy B.I. meta data strategy

● Coordinated with the Project/Technical/Resource Managers and participated in project planning

● Managed a team of 5 Consultants / Sr. Consultants in the BI implementation at a retail / consumer products company. Defined the current, to the to-be reporting landscape and performed gap analysis.

● Defined the BI strategy, managed the project plan, budget and resources. Mentored and guided the team in the blueprinting, design and the realization phase.

● Developed the project plan to manage the post go live / transition phase. This involved working extensively with the client, to resolve outstanding issues, development of a training curriculum, and documentation for the maintenance of process chains.

● Requirements gathering, activating standard business content, gap analysis, design / build of generic extractors, custom user exits, deletion and initialization of setup tables for inventory and production data extraction.

● Creation, release and repair of transports, resolution of transport errors, and creation and monitoring of process chains.

● Creation of security roles, to aid in the continued support and development of the BI system.

Technical Environment: SAP BI 7.0, SAP ECC 6.0.

Deloitte Consulting 06/2007-11/2007

Sr. Consultant

Supply chain and FI / CO implementation

Roles & Responsibilities

●Working on development of new queries, web templates, and extractors, in Engagement Management, Co-PA, AP, AR, PCA, and SL etc. Requirement Analysis of Next phase reports.

●Involved in creation of role based security and authorization for certain Info Cubes and Info Objects.

●Created flexible reports using calculated key figures, filters and variables. Provided drill down functionality on reporting. Extensively used all the features in BEx Analyzer.

●Definition and formulation of a data warehouse and the reporting strategy that encompassed a divergent number of reporting tools, legacy and SAP systems.

●Definition of the as-is to the to-be reporting / data warehouse architecture.

●Risk analysis and risk mitigation, reporting tool options and a decision matrix to assist in tool selection. Helped client team understand the need for Information Lifecycle Management Strategies.

●Requirements gathering for BI hardware using the BI SIZER tool, to compute SAPS and hardware requirements.

● Involved in the Deployment 1 Pilot for evaluation of BI tools and strategies. This project involved the extraction of financial data from an oracle database and utilizing the Web Application Designer, Visual Composer etc. for reporting. Utilized ABAP code for cleansing and transforming data.

● Data ageing and ILCM : Formulated a data archiving strategy, establish parameters for data archiving, define and evaluate third party tools like PBS, etc.

● Assisted in scoping and estimating the requirements for the Deployment 2 Enterprise Data warehouse project, for the Global Sustainment, Supply Chain and Financial Management modules. This estimation was based on several factors that included but not limited to GAP analysis, data cleansing, and customization of objects / cubes reporting requirements and data / hardware architecture.

Technical Environment: SAP BI 7.0, SAP ECC 6.0.

L-3 Communications / Integration Systems. Greenville, TX 07/01-05/2007

MIS / BW Engineer

Roles & Responsibilities

●As part of existing BW team focusing on Unit Testing, Integration testing, Extractor testing, enhancements and Validation with SAP R/3 (4.6C).

●Hands on experience in SAP Authorization concepts, Profile Generation based up on the roles.

●Customization of workplace for user role to publish web reports.

●Monitored the queries using Query Monitor and Trace tools.

●Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

●Monitored Transport Management, CCMS, and background jobs.

●Set up LIS environment (deletion and creation of setup tables, delta configuration, etc.)

●Set up of LO cockpit.

●Set up Reporting Agent in background to process large volume of data.

Business content:

●Transferred Business Content objects from FI/CO, COPA modules to active version with all its dependence objects like queries, workbooks, updated rules, info sources, transfer rules etc.

●Transferred the business content BW Statistics Info Cubes and checked the performance of the system through the queries delivered as the content.

Extractions:

●Generated Data sources in R/3, flat file sources, activated Info Sources, Transferred Master data to Characteristics and Transaction data from R/3 systems to Info Cubes in BW in the modules FI/CO.

●Maintained extract structures for Purchasing, Inventory and Sales & Distribution. Generated data sources & activated the extract structures for the above modules. Scheduled data uploads in cockpit.

●Stored data within BW in a PSA object, ODS object and finally in Info Cubes.

●Worked with Business Content provided standard cubes, extracted Data from R/3 into BW, modified transfer rules and update rules. Scheduled and Monitored.

●Loaded data into Data targets from flat file sources.

●Loaded Master data and Transaction data to info cubes, monitored data loading into the Info Cube and also validated with respect to BW data.

●Created process chains, info packages.

●Created aggregates and also developed hierarchies as per the user requirement.

●Created a multi Cube, joining the Info Cubes from which the queries got data and published on the Web.

●Responsible for loading Master data (Texts, Attributes and Hierarchies) for Materials, Sales.

●Enhanced the existing LIS Extractor and modified the design of existing Info Cube to include the Characteristics.

●Developed the data sources for the FI-CO on the basis of operating concern (Account based or Cost based) and developed ODS objects for the Data Source.

●Performed delta units on CO-PA extractors when the profit center realignment was done in R/3.

●Developed ODS object to load Sales Order Data.

●Developed & demonstrated prototypes to upper management on my SAP SEM components including Balanced Scorecard, Management Cockpit.

●Created measures, transactional info-cubes including data modeling, extraction of sales data into BW etc.

●Solved problems encountered during the processes using OSS notes.

Reporting:

●Implemented several standard queries for the Info Providers using BEx Analyzer, Browser.

●Involved in modifying queries, created on the Multicubes SD – US Summary Order/Billing. Worked on reports.

●Created workbooks and views and templates. Used Web Application Designer to publish queries on Web with HTML / Java Scripting BW style sheets for making user-friendly browser.

●Created Info set Queries to extract data from Flat tables.

●Tested the Aggregates in development as well as in production environment to check the

Contact this candidate