SUMMARY

• SAP HANA SPS 11 Certified Application Associate.
• 10 years of experience with proficiency in data warehousing concepts on SAP BI - BW platform.
• Expertise in SAP BW Architecture and various data design models such as LSA, LSA++, multi-Dimensional data modeling using Star Schema and Extended Star Schema models Infocubes (Real Time & Standard) and Multiproviders .
• Expertise in modelling SAP HANA Information views using HANA Studio and worked on new functionality provided by SAP for consuming BW Backend Objects as views from HANA database directly without addressing BW Backend.
• Experience in SAP ABAP, SAP HANA modelling, BODS and SQL .
• Proficient in Data staging and transformation using DSO before transferring data to further datamarts.
• Written various complex Update routines, Transfer routines, Transformations (start, end and expert routines) using ABAP.
• Expertise in creating generic datasources using views, function modules and Infosets in ECC.
• Expertise in Delta Extraction, Generic Delta Extraction, Data Load Scheduling and Extensively involved in the data extraction for SAP ECC and ISU (COPA, LO, FI, SD) andnon-SAP source system’ datainto SAP BW server.
• Good hands on in classical and advanced Enhancement technologies using ABAP (User exits, Customer exits(SMOD/CMOD, BADI and Enhancement framework).
• Good problem solving and advanced debugging skills for ABAP dictionary objects.
• Proficient in Performance tuning using Aggregates/BIA, Rollup, Partition, Compression and BW Statistics.
• Worked with other BW backend objects like Open Hub, Data Transfer Process(DTPs), Info package, APDs, PSAs, Process chains and BW Integrated Planning tools etc.
• Extensively worked in BEx Reporting of Selections, Formulas, RKF, CKF,Variables, Processing Types, Conditions, Exceptions. RRI & Bex Broadcasting.
• Worked with Master and Transaction Data User Exits on R/3 and Variable exits.
• Experience in working with advanced front end tools like BO Web Intelligence and Crystal reports, SAP Lumira etc.
• Expertise in SAP BW7.X and BW on HANA configuration and Query development.
• Experience with SAP ECC modules Like Sales & Distribution (SD), Materials Management (MM), Inventory Management (IM) and Finance and Controlling (FI/CO)
• Worked as a Technical Architect, Team Lead, Quality lead, Onsite coordinator,L3 and L2 support analyst in various implementation, support development and upgrade projects.
• Proficient with planning, Gap analysis, design implementation, trouble shooting, performance tuning, production support and user training of SAP Business Information Warehouse.
• Worked with Report Painter, Report Writer and SAP Quick Viewer.
• Worked on the support for BW Integrated Planning module i.e. Fox code modifications, creating BEX input ready queries, modifications and maintenance for real time infocubes, using IP planning functions etc.
• Sound understanding of different SDLC phases including Requirement gathering, Analysis, Design, Development, Testing, Support and Maintenance.
• Designed documentation templates for Technical and Functional Specs and test plans for UAT, Integration testing.
• Involved in system upgrade and migration activities from BW 3.5 to BI 7.0, BW 7.3 to BW 7.4 on HANA, BW 7.3 to BW 7.5 on HANA SPS03 (SPAU/SPDD Transactions).
• Involved in cutover and migration activities with Basis using CTS.
• Used Service Now, Remedy, SAP Solution Manager & HP QC tools for Change management.
• Involved in end-user training and documentation.
• Experience in Project Management; Worked with Global Delivery Model and lead various teams across geographical locations.

TECHNICAL SKILLS

Environment: s: SAP HANA SPS 11, SAP BW 7.5 on HANA, SAP BW 7.4 on HANA, SAP BI 7.0SAP BW 3.5, SAP R3 ECC 6.0, SAP BO 4.0.

Database Languages: SQL.

Programming Languages: ABAP, C.

Reporting Tools: SAP Business Explorer (BEx), SAP Netweaver Visual ComposerSAP BO Web Intelligence (WEBI) and Crystal ReportsSAP Lumira.

PROFESSIONAL EXPERIENCE

Confidential, Carneys Point, NJ

SAP BW Test Lead

Environment: SAP BW 7.5 On HANA

Responsibilities:

• Identifying and documenting the existing system landscape and critical business processes for upgrade effort estimations.
• Preparing and Maintaining test script document for pre and post upgrade testing as per SAPs best practices for BW on 7.5 SPS03 platform.
• Identifying and performing pre upgrade housekeeping activities like deleting temporary system objects Y-tables, Y-ABAP programs, Function modules, PSA deletion etc.; Archiving historical data to NLS and other activities to reduce database size and make system ready for upgrade.
• Fixing the errors/issues during system upgrade like validating and performing SPAU/SPDD changes proposed by system.
• Performing pre and post upgrade data loading full/delta and data reconciliation for BO Webi reports for CRM, ISU, ECC and DBConnect source systems.
• Identifying and fixing the potential issues using BW HANA Migration cockpit like Inactive BW objects, Bex query definitions etc.
• Executing the designed test cases and fixing the defects raised during testing like issues pertaining to ABAP codes as per BW HANA standards, BO Webi query scheduling and source system repointing issues, BEX variable issues, inbound/outbound file destination issues etc..
• Developing test data models using new SAP BW on HANA objects like Composite providers, HANA optimized cubes, advanced DSOs etc.
• Documenting the test results, defect resolution and status for future reference.

Confidential, Herndon, VA

SAP HANA Modeler/Developer

Environment: SAP HANA (SPS 11)

Responsibilities:

• Identifying and documenting the gaps between existing implemented HANA solutions on SPS05 and SPS11.
• Providing the effort and cost estimations for migrating existing Attribute and Analytical views in calculation views.
• SAP HANA Data Provisioning and Data replication using SLT(SAP Landscape Transformation) and BODS.
• Developing complex SAP HANA calculation views pertaining to finance module like Customer G/L line items model for open and clear items, COPA E2E Modelling, Models for calculating YTD, MTD key figures etc. using Graphical modelling tools and SQL procedures.
• Migrating HANA content from development, testing environment to Production environment using delivery units.
• Creating Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA STUDIO.
• Analyzing scope for performance optimization in existing SAP HANA solutions.
• Migrating existing SAP BW infocubes into SAP HANA system using HANA Studio.
• Creating a connection from SAP HANA to Lumira and consume the data from various information models to create user reports as per requirements.

Confidential - Cincinnati, OH

SAP BW/HANA Technical Lead

Environment: SAP BW 7.0, SAP HANA SPS09, SAP ECC 6.0, SAP BO 4.0

Responsibilities:

• Requirement gathering and blue printing after analyzing scope of improvement in existing applications for LO and MM modules.
• Participating in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Preparing high level and low level design documents by following P&G BW 7.4 powered by HANA design principles.
• Participating in brain storming sessions for optimal use of BW7.4 HANA features in existing HANA application.
• Conducting design reviews with P&G governance and P&G architects.
• Leading all the phases of the projects like planning, requirement gathering, development, System Integration Testing, Business acceptance testing and Parallel Run testing, Handover, Hypercare etc.
• Performing lead reviews for identified modules against defined standards and templates.
• Extensively worked on LO Extraction Cockpit to extract Logistics data from Source System( R/3).
• Developing ‘Safety & Max Stock’ Logistics Module using SAP FM based generic extractors, Infocubes, DSOs, Transformation with Expert Routines, DTPs, Info packages and process chains.
• Consumption of HANA information Models in BW by creating Composite and Transient Providers.
• Coordinating with P&G IS team and Business Users during business acceptance testing and parallel run .
• Developing and documenting test cases and test results after SIT, BAT and parallel run.
• Resolving priority 1 failed test cases raised in HP QC tool.
• Developing tools to automate manual testing using ABAP .
• Cutover planning for migrating EDW project containing more than 500 transports; Received ‘Team of the Quarter Award’ for migrating these transports to production without any issues.
• Helping the business users and solving the issues pertaining to Phase1 as L3 support analyst.
• Coordinating documentation and training for support team for project handover and hyper care.
• Improved performance of the LO and MM Module Identified applications by 40% and data consistency by 20%.
• Identifying critical objects and queries for PSEDW applications before BW system migration from BI 7.0 to BW 7.4 on HANA.
• Performing housekeeping activities like PSA clean up, Identifying and moving historical data to NLS, deleting unused aggregates and other objects to reduce DB size before BW system migration.
• Testing and verifying the PSEDW BW identified critical objects after SAP BW 7.0 system migration to BW 7.4 on HANA.
• Identifying and converting normal cubes into HANA optimized cubes for performance optimization for PSEDW application.
• Migrating data from non-SAP systems into SAP HANA using BODS.

Confidential

SAP BI BO Developer

Environment: SAP BW 7.0, SAP BO 4.0

Responsibilities:

• Developing BO WEBI reports with functionalities like Drill down, Ranking, Merge Dimensions, Filters, Prompts, conditions etc.
• Developing simple BO Universes using Information Design Tool.
• Developing WEBI reports using BICS Connection.
• Migrating UDT designed Universes UNV files into Information Design Universes UNX files using upgrade management tool.
• Leveraging the application specific needs like data for Rolling 12 months, YTD & MTD reports, scheduling it to generate reports in excel files etc.

Confidential

BI/BW Technical Architect

Environment: SAP BW 7.0, SAP ECC 6.0, SAP ISU

Responsibilities:

• Handling various enhancements CRs for performance optimization and BW data flow changes using LSA architecture.
• Improved Confidential Smart Metering module performance with FM based ISU extractors by 70% .
• Controlling Incident count for BW BAU queue and resolving P2 level and critical incidents pertaining to BW FI and Logistics Module.
• Participating in BW Finance Critical Month end billed and unbilled processing for Confidential with SAP ISU as source system.
• Providing support for BAU BW Integrated Planning module like modification and performance optimization for fox code, real time info cubes and process chains, creating and modifying input ready BEX queries, using IP planning functions etc.
• Developing various ABAP tools like Early watch partitioning alert, Unused DIM ID deletion, AL11 application file system space management, FM to perform Dynamic DTP selection splits, DTP Utilities tool for mass updates etc. to reduce manual efforts by 50% and to improve system stability.
• Involved in modularization of data source enhancement framework i.e. Adding old CMOD datasource logic and variable user exits into BADI.
• Coordinating with Basis team for moving the TRs across the stack for all BAU FOF related changes.
• Process chain Monitoring and handling the error pertaining to them to keep BW system up and running.
• Managing housekeeping activities like partitioning, PSA and DSO data deletion, AL11 space cleanup, cube compression, clearing out DTP error stacks to reduce DB size.
• Managing the communication with Confidential IS team and other BW development /implementation projects as a BW BAU support Lead.
• Documenting Confidential BW BAU processes and managing the SharePoint repository for internal and client audit purposes.
• Handling team management activities as an onshore coordinator and Offshore Technical Leader for BAU .
• Participating in effort and cost estimations for upcoming Confidential development projects.
• Interviewing and mentoring the new team members for Confidential BAU support activities.
• Contributed for winning BAU support fixed price model proposal and various BG RFPs for Confidential .

Confidential

BI/BW Senior Developer

Environment: SAP BW 7.0, SAP ECC 6.0, SAP ISU, SAP BEX

Responsibilities:

• Requirement Gathering and creating design documents (HLD & LLD).
• Developing generic extractors using function modules and BADIs.
• Developing and Testing BW back-end data models from Datasources till Infocubes/Multiproviders.
• Fixing the defects raised during user acceptance testing phase.
• Involved in Realization, Final Preparation, Go-Live and Post Implementation.

Confidential

SAP BW Module Lead & Developer

Environment: SAP BW 7.0, SAP ECC 6.0, SAP BO 4.0

Responsibilities:

• Gathering the requirements from users and comprehending their business perspective .
• Developing BW Dataflow objects Info objects, Info cubes, Multi providers, standard and write Optimized DSOs, APDs, transformations.
• Creating reports using tools like BEX query designer, WAD or Visual composer, BO WEBI tools as per client requirements for Confidential LO and MM Modules.
• Making the changes in existing objects and tweaking the existing transformation logic to develop Cross Functional reports (FI & MM).
• Reconciling the data with R3 or source system and rectifying the data mismatch issues if any.
• Transporting these objects across the stack using SAP Solman tools and Confidential change Management process .
• Handling the defects raised during testing via HP quality center tool.
• Conducting business meetings and solving the issues pertaining to developed reports to reduce defect count.
• Creating user manuals and conducting user training sessions after report go live.

Confidential

SAP BW Developer

Environment: SAP BW 7.0, SAP ECC 6.0

Responsibilities:

• Requirement gathering, preparing functional and technical specifications.
• Enhancing extractor logic for new fields using BADI enhancement framework.
• Developing Master data Infoobjects to handle alpha conversion, lower case and long text data Requirements.
• Creating Standard and write optimized DSOs for datamarts and Infocubes for transactional Data reporting.
• Creating transformations using direct mapping and field level routine transformation rules.
• Developing FULL/Delta Infopackages to extract data from ECC.
• Developing BEx Queries similar to existing R3 ABAP infoset queries.
• Automating data loads into BW system using process chains.
• Resolving the issues after UAT and ongoing project support after go live.

Confidential

SAP BW Consultant

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

Responsibilities:

• 24 X 7 Data Load monitoring in Production system pertaining to Confidential FI, LO, MM, BPC modules .
• Taking proactive actions to correct deviations and data load errors.
• Enhancing generic extractors, customer exits or custom BW objects.
• Making changes in transformation start or end routines for performance optimization or to handle erroneous characters coming from ECC tables.
• Performing data reconciliations with R3 and Other source systems to ensure data consistency.
• Migrating BW data flows from 3.5 to BI 7.0.
• Clearing out delta and extraction queues before system upgrade.
• Designing test scripts and performing Testing during BW system upgrade/migration or support pack application in BW System.
• Resolving Functional and System Generated tickets related within defined SLAs using BMC Remedy tool
• Involved in development of Customized Confidential BW Support cockpit for data load monitoring and reporting the success and failure of process loads to Confidential IS management.
• Managing BW report authorizations using PFCG tcode.
• Received ‘Certificate of Appreciation’ from L&T Confidential management for keeping BW up and running after BW system upgrade from 3.5 to 7.
• Improved system stability by 50% by conducting problem management activities .
• Getting involved in L&T Internal and Client audits as a Quality Lead and responsible for managing weekly management dashboard for incident queue trend and aging analysis.