SUMMARY

• Total 15 years of IT experience, out of which 12 years in SAP BI/ SAPHANA data analytics Projects involving Full Life Cycle Implementations, Enhancements & QA to suit client needs and Maintenance Processes with strong ability to create and execute technical, management and business strategies. Experienced professional in Process design, Development & Implementation.
• SAP Certified Solution Consultant in SAP Netweaver 04 - BI/BW
• Six Sigma Green Belt Certified Professional
• Designing the data flows to load the data from non-SAP source systems to SAP HANA
• Successfully completed full-cycle implementation of SAP BW/ Inventory Management / CRM/ Sales & Distribution / IBP projects
• Good Knowledge of SAP HANA Modeler HANA Studio, Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytical Privileges
• Experience in Inventory Management, Goods Receipts, Goods Issue, Invoice Verification, Stock Transfers, Stock Determination, Cycle Counting
• Hands onSAPdevelopment (BI/BW, HANA, BOBJ) and testing experience in SAP MM, BW, OTC, PP, PS, FICO, CRM modules
• Hands on experience in Core Data Services to import S/4 HANA data and build consumption views
• Solid understanding and experience of Data Warehouse, Cubes and MDM tools
• Embedded all the calculation in HANA Analytical View and Calculation Views
• Expertise in creating database procedures and script based calculation views using HANA programming languages like SQL script and CE functions or native SQL
• Developed custom function to save the invoice data in the HANA tables for recording and auditing purposes
• Worked with exiting BI team to integrate Wat if reports using native HANA, Webi4 and Dashboard
• Leverage SAP SLT and Business Object Data Services BODS to acquire the data into SAP HANA DataMart Native and BW on HANA
• Involved in validating AO Queries, BEx Queries, Crystal Reports in Enterprise
• Good communication and interpersonal skills, accustomed to work in a team environment with tight schedules, capable of working efficiently under pressure
• Strong analytical and problem-solving skills, with ability to multi-task and detail oriented

• SAP BW /HANA Data Modelling/Reporting
• SAP BI.HANA experience
• SAP BW4/HANA Modelling Knowledge
• S/4HANA Logistics and Embedded Analytics experience
• Knowledge in SAP Analytics Cloud (SAC)
• Extracting data from S4/HANA and CDS View
• Knowledge in creating CDS Views
• SAP BI WEBI/IDT/UDT/Design Studio/Analysis office experience
• Microsoft SharePoint Technology Administration

PROFESSIONAL EXPERIENCE

Confidential

SAP B4HANA/SAC- E2E Supply Lead

Responsibilities:

• Involved in leading the development of providing supply feed to APS (Advanced Planning System) featuring SAP IBP improve planningprocess, for better service to customers, improve supply chain operations, and to align with corporate E2E, EWA Transformation strategy.
• Responsible for understanding the functional requirements from the business and transforming into Technical design for the End to End Supply Planning from different source systems into GBI and feeding into IBP forecasting system.
• Involved in Functional and technical design/requirements gathering for Input Key Figure, Output Key Figure, Lead Time Variance (Safety Stock) and Days on Hand (DOH) and BDV projects.
• Hands on technical and functional expertise on Sales & Distribution, Inventory Management, Purchasing
• Responsible for coordinating the cutover tasks for IKF, Safety Stock projects and successfully moved the technical objects to production.
• Responsible for creating Technical specifications document for GBI team and standard modeling documents for End to End Supply Input Key Figures (IKF), Safety Stock (LTV) and Days on Hand (DOH) report projects.
• Worked extensively and provided solutions for MDM Item Translation, MDM Unit of Measure (UoM) Harmonization, Alt UoM to EA Conversion logic.
• Knowledge on E2EDemand Planningwhich will bring demand data from all source system (including SAP andNon SAP), planning data from Set CasterApplication system and consolidate& manipulate the data in GBI system
• Worked with 11 source systems SME’s involving Non-SAP and SAP source system to extract Sales, Inventory, Purchase related transactions into Global Business Intelligence (GBI) landscape in HANA
• Involved in HANA information model design including Package, Attribute View, Analytic View, Calculation View and Schemas.
• Designed SAP HANA data model information Views for report consumption with time dimensions.
• Developed various Procedures, Calculation Views, Tables and functions for complex reusable scenarios in Lead Time Variance and DOH projects within GBI.
• Involved in design and development of reports for BDV projects like Harmonization reports, Tie-out reports, Master Data/Hyperion reports.
• Developed custom currency schema and exchange data for complex currency conversion logic for BDV project.

Confidential, MI

SAP S/4 HANA Change Management Lead

Responsibilities:

• Involved in reviewing Functional Specifications, Business Requirement Documents, Technical Documentation, and Test Scripts to create training documentation to the super users.
• Published periodic Status Reports and provided input to quality metrics to measure the effectiveness of the IT process.
• Excellent communication and coordinating capabilities. Involved in setting up meetings with business users to understand business value/context of the SAP Process areas like OTC, EWA, FTM, PTP, FSCM, and SCM to develop training materials.
• Involved in creating job aids, Power Point presentation of the processes, Indexes, Practice scenarios to train the end users on how to run reports in SAP.
• Ability to understand complex requirements and architect end to end Analytics solution comprising of ETL, HANA, reporting components.
• Experience in working with the technical teams to assist and support them in determining technical solutions to requirements.
• Proficient in using HPQC ALM for Test Planning, RequirementsManagement, FIT Test Execution and Defect Management Reporting.
• Trained the testers, users in HPQC for test execution and defect management tool
• Responsible for identifying content and development requirements for process and system training. Liaison with the team to update existing materials and develop new materials

Confidential, MD

Sr. S/4 HANA Lead

Responsibilities:

• Strong understanding of SAP HANA in-memory technology, columnar database, innovations.
• Responsible for building multiple universes for reporting data mining needs.
• Experience in building multiple reports and dashboard using Webi4, BO Dashboard Xcelsius, and Crystal Report, BEX reporting and Visual Intelligence.
• Good knowledge to configure and execute the migration on SD and Inventory Management.
• Configured SAP HANA Finance and controlling rapid-deployment solution using CDS views.
• Used HANA model development for non-SAP Databases and application.
• Developed CO-PA and ODS date models for reporting.
• Worked with Power users from different business units to design traditional and HANA universe.
• Created 100 plus interactive analysis for Inventory Analysis, Income Statement and Balance Sheet using Webi4.
• Experience in building filters, prompts, creating merge queries and linked reports with breaks. Integrating Financial Statement Versions as Hierarchies in Webi4 documents over HANA engine.
• Involved in the development of HANA CDS views for reports used for Dispute & Collections Management.
• Experience in using Stored Procedures, Functions and Data Modeling
• Involved in development of Calculation Views for Dispute and Collections Management
• Involved in automating loading of non-SAP data into HANA DB (payment files, shipment files, SQL DB-RFO)
• Created printable reports for actual verses plan data using Crystal Reports for Production, Sales and Revenue.
• Integrated Microsoft Office to HANA reporting build scale out HANA design for growth and performance boost and disaster recovery.
• Developed testing scripts and performed UAT on SAP net weaver portal using Test ID's for developers, super users, and end users.
• Worked with SAP BI and BOBJ Business users, Project managers, and involved in requirement gathering, analysis and creation of best practice architecture.
• Created SAP Business Objects SAP BW 7.3 Roadmap document, functional and technical specifications for seamless integration and reporting.
• Worked with SAP BO, BI, EWA, ECC Basis, and R/3 teams and involved in providing integrated solutions.

Confidential, MI

SAP S/4 Finance - Test Lead

Responsibilities:

• As a test lead, contributed to the Project LiFT Realization test phase by coordinating execution of FIT cycles
• Managed and coordinated day to day testing activities at the project team level for Project LiFT
• Involved in test initiation through implementation of Project LiFT SAP implementation
• Assisted in establishing formal QA processes and ensures the team adheres to that processes
• Published periodic Status Reports and provided input to quality metrics to measure the effectiveness of the IT process
• Trained the testers, users in HPQC for test execution and defect management tool
• Developed, published, and secured acceptance of a Testing Strategy for assigned initiatives
• Responsible for logging defects in HPQC and assigning, updating the status and drive them to closure
• Assisted and provided support to the onshore / offshore test delivery teams
• Provides QA services and acts as point of contact for IT QA delivery
• Led the testers in FIT environment and in successful execution of the scenarios across PTP, FTM, PS modules
• Involved and assisted in Building and tracking detailed project plans, FIT Implementation schedules covering all end to end QA activities
• Involved in test validation activities and established acceptance criteria
• Conducted peer reviews of test cases and other deliverables to ensure quality
• Verified traceability of requirements through test cases and defects to ensure coverage
• Managed the defects discovered during the assigned initiative in compliance with the Defect Management Process
• Identified and recommended process improvements as necessary

Confidential, NYC

SAP BW HANA Consultant

Responsibilities:

• Conducted Discovery session: Proof of Concept scenario and success criteria. Storyboarding, validating user requirements and defining use cases.
• Prepared the Blueprint of HANA Proof of Concept.
• Experience in extracting Source Data using BODS and SLT.
• Involved in data modeling in HANA Studio using Attribute, Analytical and Calculation views.
• Responsible for reviewing, Refining and Validating Data Generated Reports in Excel and SAP Lumira.
• Involved in evaluation and Decision Detailed Presentation to compare As-is and proposed HANA Scenario.
• Experienced in designing the SAP HANA Roadmap for the client and next steps on the project.
• Accountable for managing testing teams and test delivery for testing FICO, PTP modules
• Hands on experience with SAP BI 7.4 on HANA system to validate data, dataflow from SAP BI down streams
• Involved in Data Collection for deep dive analysis to inform action plans and decision making
• Involved in validating AO Queries, BEx Queries, Crystal Reports in Enterprise
• Involved in training end users on BEx analyzers, query designers, Business Objects, Web Intelligence reports, Universes, Dashboards, and HANA Studio
• Extensively involved in testing of SAP SD, Retail, MM modules and validating data from Info cubes
• Responsible for validating the data coming from the BI/BW in the Quality Environment
• Design data structures to optimize data load times and end-user data access response times. Design processes to minimize data quality risks and proactively identify potential data issue. Perform analysis and design; write technical specifications; configuration and programming in the SAP/BI environment, including testing and implementation
• Worked with functional, technical and validation colleagues to drive schedule to deliver on time
• Responsible for reporting test execution & defect management status to stake holders every day
• Analyze and configure BW/7.0, BW 7.4 on HANA, Bi 4.1 and Xcelsius data environment to facilitate custom reporting and data analytics solutions.

Confidential, VA

Test Manager - SAP Implementation

Responsibilities:

• Experienced in working in a Validated SAP Pharma Environment
• Handled and managed functional testing teams
• Accountable for Test Strategy definition and Business Planning and schedule
• Experience in creating, managing the status wall in Sharepoint to provide progress update to the management
• Support the on boarding and training of BW and Business Objects Power Users. Involved in providing technical training of key BW/BI toolsets such as BEx analyzers, query designers, Business Objects, Web Intelligence reports, Universes, Dashboards, and HANA Studio
• Involved in creating standards to author and execute test scripts
• Handled Defect Management and responsible for closure during each testing cycle
• Responsible for creating testing schedule on day to day basis
• Involved in Planning of test case dependencies upon data and access and monitoring them
• Responsible for reviewing of testing cases to ensure quality is adequate
• Plan to the lowest level to ensure testing schedule remains on track
• Hands on working in a ValGenesis, a validation tool

Confidential, IN

SAP BI Test Lead

Responsibilities:

• Working closely with Business Analysts, SAP Team to create manual test scripts, scenarios, test data and test conditions in Quality Center.
• SAP Unit, Integration & UAT testing for SAP SCM, FICO Modules.
• Helped in creating account groups, assigning number ranges, maintaining field status variant for account groups
• Handled offshore testing team and was responsible for the delivery at the client site.
• Experience in formulating/enhancing test strategies and plans.
• Worked on HP UFT for automating the Regression Test Suite for SD, EWA, ECC, MM, FICO.
• Experience in identifying the defects and escalating them to CCC team through consol tickets.
• Experience in different kinds of tests such aspositive, negative, smoke, integration, user acceptance, performance, regression, load, security.
• Utilized SAP best practicesfor test documentation, test tools, and test approach.
• Coordinate with the Validation team for all validation activities.
• Documentation of Business Processes/ Procedures
• Led activities for the Automation project, identified Test Scenarios for Automation, planned future automation requirements and Test Scenario identification.
• Designing and execution ofautomated test suites.
• Maintainedtest scripts for regressionand trouble shoot on failure.

Confidential, GA

Sr. SAP Test Analyst

Responsibilities:

• Experience in handling onsite and offshore team.
• Testing for SAP HR module includes, Benefits, PA, OM, ESS, e-Recruiting, Payroll & Time.
• Worked on the Test Scenarios for all HR, FI & Procurement Testing.
• Lead the HR BOSS/UAT team for Testing in QC.
• Developed Defect Management Plan for Integration Testing.
• Worked with HR team to develop Test Scenarios, Test Cases & Test Steps for Benefits, PA, OM, ESS, e-Recruiting, Payroll and Time.
• Gave QC Training for three batches of Client Users, teams who are involved in UAT for Cycle 2 & 3 Integration Testing.
• Involved in Planning, for Unit, Integration and UAT, Cycle 2 & Cycle 3 Testing.
• Developed Test Strategy, Plan, Reports for PMO, EWA, ECC, Conducted Training Sessions and meetings with Functional Teams and Development Teams.
• Developed QC Field Guide and Training material for Client Users.
• Conducted an online-Integration test kick off session for client users attended by about 20 Client team members.

Confidential, Minneapolis, MN

Sr. SAP Lead Consultant

Responsibilities:

• Responsible for handling offshore IBM team for testing activities.
• Supplier support and off-hours coverage for production support activities
• Monitoring and managing data loads in the production environment.
• Preparing Functional specs for new programs to be developed on the basis of Client requirements
• Worked on supportingSAP BW --FI, Sales &HRReports.
• Responsible for the first level support which extended to SAP BW -- FI, Sales & HR Modules
• Handling the service request raised by the users within the stipulated time frame.
• Designing synchronized test scripts for HR Application functional requirements.
• Rich experience in functional automation testing using Mercury Interactive Tool - Quick Test Professional (QT Pro* 8.2).
• Createdtest casesandtest scriptsfor thefunctional testingandregression testing.
• Participated in walkthroughs and inspections to ensure business rules, deliverables, and processes are addressed.
• Resolved issues involved with different interfaces
• Maintained and executed test cases and test scripts in Test Director.
• Executed tests in functional, integration, system, regression, back-end and user acceptance testing.
• Participated in weekly assessment meetings with business analysts and developers.
• Worked closely with the development team in getting fixes for the defects that has been in open status.
• Regression testing for new release.

Confidential, Plymouth Meeting, PA

SAP BW Lead Analyst

Responsibilities:

• Involved in generating MS SQL Queries to prepare reports as requested by the functional teams, validation
• Worked in BI 7.0 environment. Handled 3 Go-Lives EMEA, Japan, APAC. Involved in post-production support on a daily basis.
• Worked on extracting the legacy data into BW.
• Worked with the third party tools like Informatica and Hyperion for reporting.
• Developed the Technical Documents, Unit Test scripts and deployed them in to the document repository.
• Worked extensively on LO cockpit logistics extraction.
• Responsible for translating Business needs into Functional Specs, managing Development works, handling Change Control Meetings. Responsible for the overall BI 7.O development and deployment activities of FIQ Project
• Successfully handled EMEA, EWA, ASIA PACIFIC, JAPAN and RUSSIA Go lives
• Responsible for all BW activities and handling offshore team
• Built and optimized Complex Process chains and incorporated ABAP Programs and handled communication with ETL (BW downstream) via Process chains.
• Involved in successful handling of total refresh activities to keep the BW in Sync with ECC and BW downstream warehouses
• Collected developed objects in various transport requests and released them to upper landscape.
• Created the ABAP programs for reconciling the data between the BI and Source.
• Resolving the tickets that are created by Application Management by applying the notes and doing some customizations.
• Attending Change control Meetings and updating the status of progress.
• Solved many challenging production issues which I encountered after go live.
• Good knowledge of QMS Procedures, maintaining Trouble shooting guides, handling end user training

Confidential, Phoenix, AZ

Sr. SAP BW Consultant

Responsibilities:

• Experience in requirement gathering with CRM, SD, MM Users to understand the basic flow of data in R/3 system.
• Responsible for design and development and extraction from R/3 Source system and Flat file to BW.
• Worked in Data Modeling, Extraction and Reporting.
• Worked on query development by using BEx with calculated key figures, restricted key figures, Variables, conditions and workbooks.
• Experienced in building of Info spoke and generic data source.
• Responsible in building the Process chain for daily updating of data from R/3 to BW Server.
• Experienced in monitoring the process chin batch loads and fixing them when it fails
• Responsible for activating the business content reports and customizing it according to the users specifications.
• Resolved the bugs/issues occurred during upgrade by coordinating with SAP.
• Captured load times, query response times before and after upgrade to make sure everything is working as expected.

Confidential, Orange County, CA

SAP BW Developer

Responsibilities:

• Involved in SAP Net weaver 2004s Release 3 planning phase of Management Information Data Analysis System implementation project.
• The MIDAS strategic roadmap includes five complementary releases, each of which is designed to build on the capabilities of previous releases.
• Environment: SAP R/3 4.6C, BI 7.0, ABAP/4, Net weaver 2004s, BEX Report
• Identified the business case for BI 7.0 upgrade.
• Release3 of WWIT encompasses the following scope like Budget, IT Expenses, IT Fees and allocations.
• Automation of data collection and consolidation processes. Increase efficiency and effectiveness of adhoc reporting capabilities which consume 50%-75% of CGIT.
• Detailed usage analysis and consolidation of existing reports.
• Responsible for gathering technical design requirements like data flow diagram, technical spec for each BW objects, report design, source to target mapping, ETL technical specifications.
• Brought in Financial, Staffing, HR, Recruiting data into a single repository and organized it to support reporting.
• Involved in reporting of Actual & Plan worldwide IT cost by Lines of Business and business companies.

Confidential, Philadelphia, PA

SAP BW Developer

Responsibilities:

• Written ABAP routines for deriving posting period (FISCPER3) from Fiscal Year/Period.
• Responsible for the ABAP routine in Info Package selection to exclude the Cons Unit from BCS Consolidation.
• Responsible for creating a datamart which is a Tax Stream cube (Z1FISLC03) and TEMPhas a record layout of Account Number, Consolidation Unit, Beginning Balance and Ending Balance
• Responsible for creating the update routine for the Opening balance calculation which is Period 0.
• Involved in creating a custom ZBCS2 look up table in R/3 which maps the Company Code to Company which is being used for all the different business areas like CPG, Bio Polymer and Lithium.
• The data to be fed to Tax Stream in this flat file format will reside in two separate SAP systems and will come from a Special Ledger totals table in SAP R/3 (ZGLT1T) and from the SAP BW system consolidations Info Cube (ZBCS C50).

Confidential, San Antonio., TX

SAP BW/BI Developer

Responsibilities:

• Led large-scaleTesting of SAP R/3and B2B (Extranet) systems using the e-catt Automation Tool, Testing - SAP R/3.
• Defined performance requirements and test environments.
• Coordinate Teams for End Testing, functional clarifications, understanding of the work processes.