SUMMARY

• Around 10 years of IT experience and 8+ years in SAP BI/BW and SAP ABAP Programming and around 1+ years in SAP HANA implementation and support experience. As a Lead consultant with Four Full End - to-End life cycle implementation experience with strong understanding of Business Requirements, Business Process flow, System Process Modeling and System Analysis and implementation project
• Extensive Experience of SAP BW/BI components and ETL process like creating Infocubes, Multi Providers, Remote Cubes, Transactional Cubes, Data Marts, Info Source, Info Package, Data Source, Info Objects, ODS (DSO), Transformation, routines, Transfer rules, Process Chains
• Extensive experience with all the elements of ABAP/4 language: Report writing such as Classical and interactive Reports, Dialog Programming, BDC, SAP Scripts/Smart forms, LSMW, User Exits, Workflow, Function Modules, Business Add - Ins (BADI’s), BAPI, RFC, WebDynpro and ALE/IDOC/EDI
• Extensive Experience in SAP HANA data Modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio
• Experience working in SAP BW 3.5, SAP BI 7.0, 7.3 and SAP HANA 1.0
• Modelled SAP BW using Layered Scalable Architecture (LSA Architecture) with its seven layers and best practices
• Worked on SAP Accelerators and involved in performance tuning to minimize the query retrieval time and data load time.
• Worked extensively on Web Intelligence (Business objects 4.0) reporting tool - along with Universe.
• Implemented Full Life cycles as a BI consultant using ASAP methodology that includes gathering business requirements, analyzing the business process, Identifying and analyzing the Gaps, Implementation, Designing, Configuration, Customization, Unit/Integration testing, Data migration, Go-live and Post-go-live support along with other Post-Implementation and Post Maintenance project
• Developed objects in OTC (Order to cash), Procure to Pay (P2P), Require to report (R2R) including AR, AP and FIGL.
• Experience in extracting data from SAP R3/ECC, non-SAP systems, and flat files
• Involved in managing Info cube, which involves Info cube content, performance issues like Indices, Statistics, compression of Info cube and rolling up the data to the aggregates.
• Expertise in Generic Extraction of Table, Views and function Module
• Expertise in Start Routines, Field Routines & End Routines
• Experience in process chain management, Monitoring and scheduling the batch jobs
• Debugging Data load errors, Delta Queue Monitoring, and Extractor Checker by simulating BW asking for data and Customer Exits. Master/Transaction data testing
• Extensive experience in SAP BW components including BW Administrator Workbench
• Experience in BW Configuration Process Chains and BW Extractors, User-exits, BADI and Authorization Objects
• Expertise in Business Explorer Analyzer for Reporting
• Proficiency in creating various strategy documents such as programming standards, user test reports, integration testing and project implementation - cutover strategy, backup plan, and knowledge transfer plan to enable operations to take over support
• Strong experience in quality methodologies such as technical specifications, functional specifications, code reviews, and skilled in documenting processes, identifying issues, handling multiple tasks and training end users
• Highly involved in full life cycle of BI/BW implementation
• Functional Knowledge for implementing SAP SD, MM, FI-CO, PP, SAP CRM, SAP SCM, QM modules in order to meet with client’s specific business requirements
• SAP HANA Development of Scenarios involving Attribute, Analytic, and Calculation Views
• Worked with the clients to support all aspects of the business analysis and design of custom development requirements for the SAP solutions including Reports, Interfaces, Conversions, Enhancements, Forms and Workflow (RICEFW)
• Extensive Experience in integrating SAP BW and other systems.
• Extensive experience in SAP Upgrade/Unicode Projects (SPAU/SPDD and UCCHECK/SPUMG)
• Part of an implementation team and implemented HANA for customers using HANA RDS Solutions
• Extensive experience in SAP Enhancement and Modifications
• Extensive experience in the implementation, development, upgrade and integration strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills
• During the development and testing phase, worked closely with the development team, extensively worked with QA team for designing Test plan and Test cases for the Unit and User acceptance testing
• Thorough experience in managing projects with large team size with excellent team management and leadership skills well augmented with strong problem solving skills and excellent interpersonal, negotiation and relationship management skills
• Involved in training, co-ordination with the offshore development team to provide input, development, code review, test scenarios and test cases
• SAP BW components - Strong working knowledge of Info Objects, Info Cubes, Info Source, Update Rules, Transfer Rules, Transformation Rules, Data Transfer Process (DTP), Multi Providers, Remote cubes, and Open Hub Service
• Extractions - Experience in extracting data from SAP R/3 using LO Cockpit, Generic Extractions, and also extracted data from the flat files. Experience in ETL extraction from R/3
• Extracted data from Logistics SD, MM, QM, PPM, and FI/CO
• Data Loading - Experienced in performing data load using Info Package, performing Initial /Full/ Delta Up-load, Scheduling and Process Chains
• Customizations - Experience in activating standard Business Content, and enhancing Info Cubes according to the requirements, Data Source Enhancement, Formula Builder and update/transfer rules creation
• Reporting - Experienced in developing Queries with Calculated Key figures, Restricted Key figures, Structures, Variables, Exceptions, Conditions
• BEx - Worked in BEx designer in building Queries, saving it in Workbooks (Excel Worksheets)
• Web Intelligence - Developed reports using Web Intelligence BO tool along with Universe.
• Open Hub/APD: Downloaded data from SAP BW into flat files using Open Hub Services to feed other sources as per the business requirement
• Worked with the clients to support all aspects of the business analysis and design of custom development requirements for the SAP solutions including Reports, Interfaces, Conversions, Enhancements, Forms (RICEF) in SAP ABAP space.
• Expertise in Design and Develop Data Models using Attribute, Analytic, and Calculation Views. Full lifecycle implementation of SAP HANA Project. Experience in Administration and Data Provisioning
• SAP HANA Studio, SAP HANA Information Composer
• Experience with SAP HANA Administration including managing schemas, data model objects, Performance Optimization import/export content
• Experience in using different SAP HANA Data Provisioning techniques like SAP LT Replication Server (SLT), SAP Data services, DXC, Flat File Uploader
• Experience with SAP HANA programming including SQL, SQL Script, and CEScript

TECHNICAL SKILLS

ERPs: SAP R/3 4.6C/ 4.7, ECC 5.0/6.0 (MM, SD, PP, FICO/HR and EHS), SAP SCM, SAP CRM, SAP Net Weaver, SAP-BI 7.3, 7.0, 3.5 and SAP BODS SAP BO and SAP HANA RICEF (Reports Interfaces Conversions Enhancement Forms)

LANG/ TECH: ABAP/4, Java, C, C++, Visual Basic, ASP

DATABASES: Oracle 7.3, MS SQL Server

SERVERS: Web Methods

TOOLS: SAP Script, Smart Forms, LSMW, ALV, ABAP (Workbench, Query, Objects, Reports, Data Dictionary), Screen Painter, SAP Workflow, SQL Trace, CATT.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Lead Consultant SAP BI/BW ABAP HANA

Responsibilities:

• Understanding of Functional Flow from Functional Specifications, High level design (HLD), Technical Specifications (TD), Unit test plans (UTP), provide estimation details, Review check list, and development and review the code of team members
• Understanding of business requirements, resolve the issues and development of new objects
• Understanding of project requirements, landscape, transportation mechanism and process flow
• De-bugging to fix the bugs, Optimization and analysis of user defined and existing SAP programs. Solving of Incidents/Change requests/Problem reports within the time limits
• Involved in initial discussions to identify the scope, track, time lines and different activities for project with architect teams, business and QA team
• Installed Business Content for Standard Info Objects, Cubes, DSO and Queries
• Created Transformation Routines, Start Routines, End Routines as per the requirement and for the lookups from one DSO to other
• Created monthly and summary reports in WEBI 4.0
• Worked on datasources of different modules of SAP like SAP SD, MM, FI-CO, PP, SAP CPM, QM modules in order to meet with client’s specific business requirements
• By using BADI RSU5 SAPI BADI to enhance BI Data Source worked in SAP Solution Manager for posting of documents
• Created Info packages and scheduled them in order to load Master and Transactional data from SAP R/3 as well as flat file source system into BI
• Performance tuning/Process improvement is done during the support phase by rearranging the process chains, index creation, Aggregate creation in cubes.
• Creation of Generic Data sources for master and Transaction data
• Sent CSV and Excel format data to 3rd party company using Open hub.
• Applied OSS Notes and Contact to SAP People
• Assisted in defining complete test scenarios to cover full scope of the business and carry out the unit and integration tests
• Implemented User exits, BADI's and OSS notes
• Carrying out Performance tuning by using Run Time Analysis and SQL Trace Tool
• Responsible for the evaluation of the current system and defining the scope of the BW project for cost controlling and developing extractors and reports.
• Developed SAP HANA Data Modelling by using of HANA Studio
• Developed data models for SD, MM, PP in SAP HANA
• Using SLT, tables are loaded to SAP HANA catalog and on top of it the information models like attribute views, analytical views and calculation views are built.
• Analytic Privileges are created based on certain fields and helped the admins in assigning it to a role/user
• Performance tuning is done based on the visualize plan report
• Helped BO team in creating a connection between HANA system and UNIVERSE tool
• The inbuilt BW in the NetWeaver is made to interact with HANA system using DXC connection and the IMDSO (In memory DSO) is used in building the information models
• Extensive experience in SAP BI upgrade from 7.3 to 7.4 and used /ASU/UPGRADE to check for the overall consistencies of the system.
• During the upgrade, the aggregates in the has been removed and BWA will not be used anymore.
• Used RSAODSACTIVATE standard program to activate all the DSO which turned inactive after the upgrade and used standard program ANALYZE RSZ TABLES to check for inconsistencies in the queries and corrected them when faced issue with exceptional aggregation.
• Used standard program RSDMD CHECKPRG ALL to check for inconsistencies in master data. If some errors are found, the repair option is used to correct it.
• During upgrade, the ABAP programs were corrected with the help of standard transactions (SPAU/SPDD and UCCHECK/SPUMG)
• Post migration clean and optimization to save 25% of disc space on new BW 7.4 BW on HANA system
• Monitored data extraction and created queries according to requirement
• Built complex generic extractors when the standard extractors are not suitable for the business
• Created Business Objects (BOBJ) reports in Web Intelligence tool, Queries with constant interaction with the end users.
• Trained end users in understanding the reports
• Involved in developing different type of objects like Info objects, Info cubes, DSOs, DTP, Transformation & Multi-provider
• Assisted SAP Basis team in installing HANA and solely integrated it with Business Objects 4.0
• Migrated to SAP HANA for all objects
• Created SAP HANA calculation views and developed the Web Intelligence (BOBJ) reports

Environment: SAP BI 7.3, BO 4.0, SAP HANA, SAP R/3 ECC 6.0 (FICO, COPA, SD, MM, QM, PP), PI, BI, ABAP/4, User Exits/BADI’s, ALV, ABAP Reports

Confidential, Hopkinton, MA

Senior SAP BW/BI ABAP Consultant

Responsibilities:

• Understanding of Functional Flow from Functional Specifications, High level design (HLD), Technical Specifications (TD), Unit test plans (UTP), provide estimation details, Review check list, and development and review the code of team members
• Understanding of business requirements, resolve the issues and development of new objects
• Understanding of project requirements, landscape, transportation mechanism and process flow
• De-bugging to fix the bugs, Optimization and analysis of user defined and existing SAP programs. Solving of Incidents/Change requests/Problem reports within the time limits
• Involved in initial discussions to identify the scope, track, time lines and different activities for project with architect teams, business and QA team
• Involved and developing different type of objects like Info objects, Info cubes, DSOs, DTP, Transformation & Multi-provider
• Using BADI RSU5 SAPI BADI, enhanced the standard BI Data Source or extractors
• Extracted data from data sources like2LIS 02 ITM, 2LIS 02 SCL,2LIS 02 HDRand populated into the procurement infocubes0PUR C07, 0PUR C08, and 0PUR C09to evaluate service levels
• Created Transformation Routines, Start Routines, End Routines as per the requirement and for the lookups from one DSO to other
• Created Info packages and scheduled them in order to load Master and Transactional data from SAP R/3 as well as flat file source system into BI
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard datasources 0FI AP 04, 0FI AR 04 to meet the client requirement
• Creation of Generic Data sources for master and Transaction data
• Performance tuning is done to increase the loading speed as well as report execution speed
• Maintenance activities for a full load without disturbing the delta load is done by taking downtime from the users
• Sent CSV and Excel format data to 3rd party company using Open hub
• Applied OSS Notes and Contact to SAP People
• Maintained and trouble shoot CIF jobs for Master Data
• Assisted in defining complete test scenarios to cover full scope of the business and carry out the unit and integration tests
• Developed reports in SAP BO by using WEBI and UNIVERSE.
• Implemented User exits, BADI's and OSS notes
• Carrying out Performance tuning by using Run Time Analysis and SQL Trace Tool

Environment: SAP BI 7.3, SAP HANA, BO 4.0, SAP R/3 ECC 6.0 (FICO, SD, MM, PP), PI, BI, ABAP/4, User Exits/BADI, ALV, ABAP Reports, SQL Trace

Confidential, Rochester, NY

SAP BW ABAP Consultant

Responsibilities:

• Started as an SAP BI developer to develop BI related objects.
• My role here is to attend the ORB0 meeting to gather the requirements from the functional designers or from the end users directly.
• Once the QRB0 meeting is successful, then technical specification is prepared where it contains the technical details of the solution which is likely to be given. And I will be initiating a QRB1 meeting to discuss the technical specification document. Once the designer is satisfied with the technical design, I will start with the code and will do a unit testing from my side and document it.
• Once the user or functional designer is satisfied about the testing in development, my responsibility is to release the Change request and request the BASIS team to migrate the change to the Quality server.
• Later I was made as a QA lead, where my role is to assign work to my team and do a Code and testing review.
• Will maintain the status sheet for my team.
• Played a role of BI ABAP consultant as well to write the user exits and BADI.

Confidential, Rochester NY

SAP ABAP Consultant

Responsibilities:

• Created ABAP Data dictionary objects like tables, domains and data elements
• Created search objects, table maintenance generators and Transaction code for the tables, reports and screens.
• Changed the layout of the Dunning forms like F150 DUNN 01 by copying into Z forms.
• Changed the layout of Balance confirmation forms like F130 CONFIRM 01 by copying into Z form.
• Changed the layout of interest note F DUZI 01 by copying into Z forms.
• LE SHIP TAB CUST ITEM BADI is implemented to add an additional tab in delivery screen.
• Worked on Pricing requirements routines in VOFM.
• Module pool programming for screen designing is done.
• Form designing using SAP Script and SMARTFORMS are done.
• ALV report with grids are done as per the client requirement.

Environment: SAP ECC 6.0