SUMMARY:

• Sr. SAP Consultant with 9 Years of experience in analysis, design and development of SAP BW/BI, HANA, BODS, BOBJ applications.
• Expertise in SAP HANA Platform Edition, SAP HCI, BW, BOBJ & BODS. Worked in 3 full life cycle implementations, support of SAP HANA based solutions including Data Modeling, SAP ECC, SAP Data Services, SAP Business Warehouse (BW), and SAP BI/Business Objects in large and complex environments.
• Experience as a BW HANA Consultant working on HANA studio along with multiple data provisioning - Data Services and SLT, DXC to extract data from SAP and NON-SAP systems.
• Extensively worked in Implementation, Maintenance Production Support projects and have in-depth exposure in technical as well as functional areas like CRM, SRM and ECC includes SD, MM, PP, PM, QM and FI/CO and HR modules augmented by strong testing skills acquired from various project experiences.
• Extensively worked on ECC Logistics data extraction for SD, MM Inventory, PP etc.
• Extraction from (CRM, SRM, Logistics, SD, MM, FI, PP, HR and Generic): Source systems (SAP, Non-SAP like SQL data using DB Connectivity, Web Services, and Flat File).
• Extensively worked on BO data services designing data flows, BO reporting with Webi, Crystal reports, Explorer.
• Extensively working on BW on HANA new developments creating HANA models, and Optimized BW modeling objects like Advance DSO, Composite Providers, Open Views etc. Rectifying the alerts on HANA studio.
• Extensively worked on HANA models creating views and Data provisioning and user privileges.
• Extensively worked on Performance tuning at 3 levels in SAP BW - Database level resolving table space issues, Modeling level-data loads performance optimization and Frontend Report level - Query optimization.
• Maintaining Cutover Steps post and pre transportation of SAP objects used for development and enhancements.
• Transports include Transportation of BI/BW and R/3 Objects, collected objects in Development System and transported throughout the System landscape using Revtrac.
• SAP HANA Database revision upgrades, refreshes and data base Administration (fine tuning, parameter changes, memory configurations, and start/stop).
• Involved in Full life software development lifecycle (SDLC) implementation of Business Intelligence applications using SAP BI/BW, HANA & BO (UDT, IDT and WEBI).
• Extensively Worked on Smart Data Access (SDA), defining Joins, Attribute view, Analytical views, calculation views, entity views, table functions, SQL procedures, formula functions and other calculations and restrict measure.
• Worked on development, maintenance, and heavy customizations on ETL tools like full loads, Delta loads.
• An enthusiastic, highly self-motivated, Excellent Technical, Interpersonal and solid communication skills with the ability to interact with end-users and managers and Experience in requirement gathering and Training End-users.

TECHNICAL SKILLS:

Data Warehousing:: SAP R/3, SAP NetWeaver BW 7.x, BW/4HANA 1.0.

SAP Modules:: SD, MM, PP, HR, FI-CO, SCM

Data Replication, ETL:: SAP BODS 4.x,SLT.

Business Modeling: SAPHANA Design Studio, SAP Data Services Designer, and SAP BW Workbench.

Cloud tools: SAP HANA Cloud Platform, Microsoft Azure, SAP Ariba.

Database: SAP HANA 1.0, 2.0, Oracle, My SQL.

Reporting Tools: SAP BO/BI 4.x/3.x, Webi, Bex Query Designer, Bex Analyzer, Crystal Reports for Enterprise, BO Explorer, SAP Lumira, MS Excel.

Operating Systems: Windows XP/Vista, iOS, UNIX.

Microsoft tools: MS Power BI, MS Office, MS Excel, MS Power point, MS Access.

PROFESSIONAL EXPERIENCE:

Confidential, Warsaw-IN

Sr. SAP HANA/BI-BW/BODS

Responsibilities:

• Provide implementation consultation and support services during SAP BI installations, customization, upgrades, data migration, and other projects
• Assess and fully comprehend client needs, business practices, challenges, strengths, and gaps as it relates to the SAP BI system, environment, customization, application, and resourcing
• Effectively build understanding, consensus, and agreement with clients on implementation, customization, and upgrade steps, actions, and timing through consultative communication
• Support and develop the scope of work, project plan, timing, and related details
• Track all billable time on a daily basis in accordance with project plans, achieve targets, and report on results to the company each week
• Complete a weekly work plan of projects and related tasks and update client details in the SAP environment
• Respond to all client and company messages and requests promptly, following up as needed to confirm requested action was taken and effectively addressed the issue or concern
• Maintain service excellence and follow organizational values and standards
• Continuously develop professional and technical knowledge by attending educational workshops and events, reviewing professional materials and participating in professional associations
• Involved in requirement gathering and have worked on building the Functional Specifications
• Helping the team in understanding the requirements and deploy the requirements within the timelines.
• Involved in creating the complex information models such as calculation views and dimensional CV’s in native HANA.
• Responsible for validating the BEx report with the ECC standard transaction output.
• Involved in the UAT validation and getting user sign off after the validation.
• Involved in creation of HDB tables and stored procedures to handle delta maintenance in HANA.
• Involved in creation of Process chain to complete the data loading process.
• Leading the project team, client communication and ensuring the delivery of the project.
• Involved in identifying solution and design HANA Models for the requirement.
• Involved in development of various HANA Modeling objects.

Confidential, Abbott Park-IL

Sr. SAP HANA/BI-BW/BODS

Responsibilities:

• Interact with management and business Decision-makers to identify business requirements. Documented the reporting needs of the Business Service and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Responsible for analysing the scope of Requirement and the Impact analysis for all major enhancements & incidents.
• Prepared functional and technical specifications based on the business requirements.
• Attended MIM (Major incident Management) calls and meetings to update the status of the major incidents.
• Extensively worked on Business Information Warehouse Info Cubes, DSO's, Info Objects, Multi providers, Data Sources, Transformations and DTP's.
• Extensively used Open Hub Service functionality to distribute data from SAP BI to other non-SAP data systems.
• Expertise in maintaining Process Chains & Meta Chains for automating data loads.
• Extensively involved in creation of BEx Reports. Worked on Calculated Key Figures Restricted Key Figures, Free Characteristics, Filters and Customer Exists.
• Good understanding and experience of various components of SAP HANA,
• Extensively Worked on SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views (both Graphical & SQL script based) & SAP HANA Data Provisioning using SAP LT Replication Server (SLT).
• Extensively worked on Analytical Privileges, Procedures and decision tables.
• Extensively involved in writing SQL scripts in HANA Studio

Confidential, Wichita - KS

SAP BI-BW/BOBJ/HANA Consultant

Responsibilities:

• Understanding the functional and business requirements by participating in User discussions.
• Preparing project specific technical specifications, DTP design documents, unit test documents and estimation of efforts required for new change requests.
• Extensively involved in end to end development from CRM area to BW system
• Worked on new developments on BW on HANA system creating HANA views calculation view, analytical view and reports.
• Rectifying the alerts or issues on HANA system.
• Extensively worked on logistics extraction of SD, Inventory, MM, PP, HR other modules
• Worked extensively on creating Badi's, User exits, Function Modules for customized ECC and CRM Data sources, transformation routines, end routines, start routines, DTP routines, Field routines customer exits.
• Worked intensively on upgrading SAP Systems - ECC 4.6 Ver to ECC 6.0 and SAP BW 7.0 Ver to SAP BW 7.3 Ver which includes managing ECC system delta loads cleaning and re setup.
• Extracted the third-party data (SQL data) through DB connectivity and flat file data to BW system.
• Developed webi reports and Bex Reports for business use.
• Developed process chains as per the requirement and maintained auto-scheduling of process chains which includes - ECC background jobs as well as ECC events auto trigger.
• Collecting the Objects in transport requests for which changes made in ECC, CRM and BW and importing them across landscapes (from development to QA and Prod accordingly).
• Handling the Level 3 support issues within agreed SLA's which include analyzing (RCA) and resolving any data load failures, break fixes in production, performance issues, and support issues.

Confidential, Amarillo-TX

SAP BW/BI/BOBJ Consultant

Responsibilities:

• Gathered requirements during Blueprinting phase for this Retail Wholesale Distribution company.
• Gathered Business requirements then recommended and designed reports in BEx or BOBJ based on reporting functionality.
• Worked on all areas of SAP BI from extracting data using custom extractors / ECC/ Flat files, encompassing all steps of ETL process, (DataSources, DSO's Cubes, MultiProvider)
• Identifying, Activating, and loading of Master Data from ECC.
• Loaded Data to PSA using Data Services.
• Created reports based on functional requirements in Bex.
• Created WEBI reports in BOBJ using Bex as source.
• Created XML DataSources to load data into BW from WMS.
• Created MultiProvider for Syncing Inventory Data from ECC and WMS.
• Created InfoCubes for F&R (Forecast and Replenishment).
• Implemented Inventory Management (Material Movements) 2lis 03 BX, BF and UM extractors.
• Worked with end-users to validate reports for data from ECC (MB5B, MMBE, MB11).
• Trained users on functionality of WEBI.

Confidential, Houston-TX

SAP BW Engineer

Responsibilities:

• Interacted with management and end-users and created Functional Documents based on their requirements, and have done GAP analysis.
• Extracted data from SAP R/3 and from flat files into SAP BI System.
• Involved in Design, Development of the Business Information Warehouse and enhanced the R/3 extractors.
• Activated Business Content for standard Info Cubes and Info Objects.
• Transported the objects from Development to QA for testing.
• Worked for design, development and testing of custom and standard Info Cubes, Multi providers, Info sources, data load process using Info packages, DTP and process chains.
• Flexible queries using BEx reporting features like variables, restricted key figure, calculated key figure, exception and conditions
• Delivered reports according to the user specified format.
• Responsible for Development, User Acceptance testing and Go-Live preparation.
• After Go-Live hyper-care support and project handover to support team.
• Responsible for post implementation process chain scheduling design.
• Have good hands on experience in Process chain monitoring.
• Involved in fixing the job failures that occurs in Production environment.
• Have worked in Onsite-Offshore model and handled Weekly meetings from offshore providing updates and Involved in Knowledge transfer to various new team members.
• Involved in Batch job failure fixing process and Monitoring the Batch job run.
• Handled R&D for the job that fails frequently and fixed it permanently.
• Handled tickets and resolved some simple CR’s raised in BEX reporting area.
• Involved in sending reports to the Client regarding the each and every job run on daily basis.
• Involved in coordinating with the client and developers in case of raising defects.
• Actively participated in Knowledge transfer and sharing views among the project members to effectively solve the problem.
• Involved in fixing issues that is reflected in Short dumps during the batch run.

Confidential, Houston-TX

SAP Functional Analyst

Responsibilities:

• Interpret data and analyze results using statistical techniques.
• Designing the data solution to satisfy defined business requirements.
• Contribute to Data Migration efforts working with business.
• Provide guidance on as well as execute best practices in data cleansing and data extraction for migration.
• Develop, create, and automate reports, working with multiple forms/feeds/sources to optimize statistical efficiency and quality.
• Identifying the data in the source system.
• Mapping the data to the BW environment.
• Identifying and Developing a plan to close the data quality gaps.
• Developing the required extraction programs, if necessary.
• Testing of all developed programs and ensuring integration testing of data from various source.
• Developing the required data access solutions.
• Scheduled Daily/ Weekly & Monthly Data loading using process chains, corrected & maintained work log for data loading errors in a shared folder.
• Prevented activities of errors which occurred repetitively, maintained and redefined aggregates if required on weekly basis
• Initiated performance tuning activities related to reporting as well as loading and possess good experience of creating process chains
• Interacted with end users by giving expert support and was involved on migration project
• Checked the Info Packages, scrutinized the reasons for frequent failures of info packages and maintained queues related to the system generated tickets and customer generated tickets
• Efficiently maintained work history for all the tickets until it was closed down, validated data consistency in reporting with data target against PSA after loading them to data targets
• Proactively involved in maintaining documentation for all the support activities
• Conducting and monitoring weekly performance tuning activities, comparing BI Data with R/3 and sending the reconciliation report to the business on daily basis.
• Involved in developing Multi-Dimensional Data Models like Info Cubes, Multi-Providers, Operational Data Store (ODS), Aggregates, Info Objects, Data Sources, Info Sources, Transfer rules, Update rules, generic data sources.
• Worked extensively on LO Cockpit and loaded data from SAP R/3 to BW by initializing of delta update by filling the setup tables.
• Extracting data from custom table using Generic Extraction.
• Developed flexible queries using Filters, Variables, Exceptions, Conditions, restricted key figures and calculated key figures in BExanalyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Transporting the Queries and workbooks from Development to Acceptance and Quality.
• Scheduling and Monitoring the Data loads in Acceptance and Quality systems.
• Created Process chains for Master data and Transaction data loads and Prepared the Design document for the same.