SUMMARY:

• SAP Techno Functional Consultant with over 10 years of executive level experience in Implementation, Support, Development and Upgrade areas in BW/BPC/HANA with Functional knowledge in SAP SD/MM/FI/EPM/HCM modules.
• Worked in Development and support of Software Applications in the areas of SAP HANA/BPC/BW /LUMIRA and BOBJ, TABLEAU.
• Exhaustive analysis of business content at the Project Blueprint level, Requirement gathering to perform GAP analysis.
• Worked on AGILE/SCRUM, facilitated sprint planning, backlog grooming, daily stand - up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings.
• Experience on implementing projects using ASAP and WATERFALL methodologies of Project Preparation & Blue Print Design.
• Worked on Native HANA studio & BW on HANA also the data provisioning methods like SLT, BODS and DXC.
• Replicated data from the Native HANA studio to BW using Composite providers & Transient providers for BEx reporting.
• Had worked closely on DMO activities as part of migrating BW 7.3 on DB6 to BW 7.4 on HANA.
• SPS09 support multiple HANA DB’s on single HANA systems.
• SPS10 will allow 1 to N Asynchronous table replications.
• Understanding on ABAP/EPM-BADI’s debugging, Function modules, Start and End Routines.
• Expertise in all phases of BW/BPC Implementation-Data Analysis, Data Modeling, Data Extraction/Uploading and Reporting.
• OLTP Extraction from SAP R/3 into BW using different extraction structures such as LO, CO-PA, and Generic Extractors along with flat file extractions of Data from application server and carried out transports to Quality and production environments.
• Involved in the production support, fixing errors in daily ETL Data load (Full/Delta up-load) Monitoring of the BW jobs and designed Process chains for Daily, Weekly, Monthly data loads.
• Experience in Performance Tuning including Aggregates, Partitioning, Indexing, and Filling OLAP Cache through Broadcasting.
• Worked on AUTOSYS and automated the BW PC’s by deploying the code in IXP and PUTTY.
• Good experience in extracting data from SAP & non-SAP systems. Sophisticated skills to work on Flat File Extraction, FI Data Sources, BI Content Data Sources.
• Functional knowledge on BIG DATA Analytics, Hadoop frameworks (Sqoop, Hive, Pig, Hbase & Impala) and Predictive Analytics.
• Had resolved production issues by working on incident tickets and proactively monitored to make sure the SLA’s have been met.
• Expertise in Unit testing, Integration testing and user Acceptance testing.
• Worked on TABLEAU & LUMIRA for predictive analysis and reporting.

TECHNICAL SKILL:

Database: Oracle, My SQL, HANA.

Reporting Tool: Tableau, Lumira, BOBJ, Bex Analyser

SAP: SAP BW 7.0, 7.3, 7.4,7.5 Native HANA, HANA Live & BW on HANA (SP09, SP10) SAP BPC 10.0 and 10.1

Ticketing Tools: HP Quality Center, Remedy, HP Service Manager

Automation Tools: RPA-UI path, AUTOSYS, IXP, PUTTY (Unix scripting)

Methodologies: ASAP, Agile, Waterfall and SDLC

Microsoft Packages: MS Office, MS Access.

Languages: SAP BI ABAP, SQL Scripting for HANA.

Confidential

Responsibilities:

• Worked closely with the Business Relationship Management, Architecture, Development and Support teams
• Involved in delivering the projects from ideation to implementation and support.
• Develop functional / technical specifications and other documentation, as needed for audit purposes.
• Worked with business closely in designing and reviewing the T-specs to ensure the development is as per the expectation. involved in Technical and Functional Unit Testing.
• Worked on Success Factors API’s as the source feed for data into BW by creating a BODS connection to transform live feeds and data into BW further created HANA modeling and projected HANA optimized composite providers for external reporting using BEX and WEBI.
• Extensively worked on ADSO, ODS, Composite providers, Info cube, DSO, Multi-providers, Info sources, Info objects, Transformations, DTP’s Extractors, info sources, Info packages, Data sources and PC’s.
• BW configuration, ETL background and Info Cubes design, strong on End-to-End BW Configurations
• Worked on BW/HANA modelling techniques by creating HANA models and Attribute, Analytical and Calculation views.
• Used inner, outer joins and union Process, Projection, Aggregation, Join and followed the best practices to implement the Calculation Views.
• Provide knowledge transfer / support / assistance to the Applications development and Support team.
• Engaged end users in UAT sessions and conducted MOC cutover.
• Actively involved and participated in the planning and execution of a detailed cutover plan by executing the work breakdown structure to ensure smooth and successful Go-live.

Confidential

Responsibilities:

• Used SLT mechanism to replicate ECC tables for reporting on ledger group and mapping tables in to HANA
• Worked on HANA Modeling, Attribute Views, Analytic Views, and Calculation Views.
• Used inner, outer joins and union Process, Projection, Aggregation, Join and followed the best practices to implement the Calculation Views.
• Worked on bringing in data from HANA views into SAP BW using ODS, Composite providers, Virtual providers, and Transient providers for reporting purpose.
• Worked on SAP-HANA Data provisioning using SLT, DXC, and Flat File Up loader, SAP HANA Architecture.
• Replicated the AMDP methodology in the extractors to build joins and calculation logic by automating the Data load process.
• Made sure the reports performance was as expected also checked the possibilities to enhance the process if they were not meeting the SLA’s.
• Provide knowledge transfer / support / assistance to the applications sustain and support team.
• Develop functional / technical specifications and other documentation, as needed for audit purposes.
• Actively involved and participated in the planning and execution of a detailed cutover plan for smooth and successful Go-live.

Confidential

Functional analyst

Responsibilities:

• Was closely involved in the initial Blue Printing phase and engaged in workshops with the business to understand the ’AS- IS’ and ‘TO- BE’ requirements and developed the GAP analysis.
• Designed and developed Process Design Documents (PDD) in the areas of IM, PTP, P2P, TM and OTC.
• Played a key role in the Design, Customization, Development and testing of the Development.
• Involved and helped with the mapping exercise with BW, BI Content and HANA optimized Data elements to
• Analyze the KPIs in order to recommend new solutions.
• Worked closely with developers on Sales Order and KPIs in order to recommend new solutions.
• Was deeply involved in designing various intercompany billing scenarios to meet both Plants.
• Optimization by defining Business rules and other specifications to meet business requirements.
• Was closely involved in Data Conversion efforts specific to OTC and IM Data from ECC.
• loads during cutovers and Go-Live periods for a successful and smooth GO-Live
• Work closely with the Business Relationship Management, Architecture, and Sustaining and Support teams
• Delivering projects from ideation to implementation and support.
• Drive best practices in requirements gathering and documentation of new / existing BW RICEF’s.
• Provide knowledge transfer / support / assistance to the Applications Sustain and Support team.
• Develop functional / technical specifications and other documentation, as needed for audit purposes.
• Design reporting / dashboard solutions in the SAP BW space.

Confidential

Responsibilities:

• Analyzed business needs and participated in the Design and Building of business process to facilitate important functionality to achieve the expected outcome.
• Closely involved in the design, configuration and documentation of various business processes between BW and Native/BW on HANA.
• Worked in relevant DMO activities for migrating BW7.3 on DB6 to BW 7.4 on HANA on SP09.
• Monitored upload processes, Perform technical validation of uploaded data as part of migration project.
• Worked on SAP-HANA Data provisioning using SLT and Flat File Up loader into SAP HANA DB
• Worked on SAP HANA Administration, Hana perspectives and Modeling using Different types of views, SQL.
• Used SPS09 for SLT replication, which allows running multiple HANA DB’s on a single HANA system.
• Created the Attribute and Analytical views for Master and Transaction data.
• Created Calculation Views to implement Multi dimension Modeling.
• Used Projection, Aggregation, Join and Union Process and followed the best practices to implement the Calculation Views.
• Had used HANA modeler designing the data flows.
• Written SQL Script for writing the stored procedures and Filters and used them in calculation views.
• Worked on bringing in data from HANA views into SAP BW using ODS, Composite providers, Virtual providers, Transient providers for reporting purpose.
• Strong knowledge of Bex Query Designer, Calculated & Restricted Key Figures Exceptions, Conditions, Exceptions, Queries on Multi Providers, Bex query performance issue.
• Developed and tested different migration tools to help in having a smooth and efficient Data migration process.
• Actively involved and participated in the planning and execution of a detailed cutover plan for smooth and successful Go-live.
• Requirement gathering has been done for the FIGL modules for the Data sources, which are required also analyzed the RDD's sent by the functional team and performed the Gap Analysis.
• Involved in designing relational databases for complex business scenarios.
• Used the data provisioning techniques like SLT and DXC.
• SLT has been used to pull the data into tables from ECC To HANA for performing data analytics.
• DXC has been used to pull the data from the FIGL & APFA extractors from ECC to HANA DB.
• Modified Attribute views, Analytical views for storing the master, transaction data.
• Had done information modeling in designing the calculated views from multiple analytical and Attribute views.
• Used BEx Queries as source in HANA by creating snapshots in T-code RSDDB.
• Derived BPC Audit Data by using the BPC tables to perform HANA modeling using them.
• Designed the data flows and built the structures like Cubes, DSO, Multi providers, SPO, Transformations, Start Routines, End Routines and Field routines.
• Configured the systems in client system for Dev, QA and Production systems.
• Created schemas and Packages as per the usage.
• Used Projection, Aggregation, Join and Union Process and followed the best practices to implement the Calculation Views.
• Written SQL Script for writing the stored procedures and Filters and used them in calculation views.
• Design the Reports as per the RDD's that were designed and stored in Solution Manager.
• Collected the view Backup from the respective systems as per the flow and provide them to the release manager for the release.
• Provided the End User Training and guiding them in executing the BI Reports.
• Created BEX reports on Composite providers by bringing the Data into BW from the HANA Views.
• Extensive experience in technical integration and development across various SAP modules, unit/system testing of business processes, performing data load.
• Was closely involved in the initial Blue Printing phase and engaged in workshops with the business to understand the ’AS- IS’ and ‘TO- BE’ requirements and developed Technical specs.
• Worked on creating Models, Dimensions and Properties.
• Loaded Master data from BW info-objects to BPC dimensions.
• Worked on Data Manager Package to load Master data and Transaction data from BW to BPC, Transformation Files, Conversion Files.
• Created complex logic transformation files and conversation files to handle the data manipulation while loading data into BPC Model.
• Used UJD TEST PACKAGE to automate data loads.
• Worked on inter-company elimination and currency conversion.
• Developed Delta INITS to load deltas from BW multi-providers.
• Involved in Transporting BPC objects to higher Environments.
• Have knowledge in EPM reporting and Input Templates.
• Actively involved and participated in the planning and execution of a detailed cutover plan or smooth and successful Go-live.
• Balance sheet and external audit purpose, ME-close, Consolidation book, Legal & Management close.

Confidential

BW Developer

Responsibilities:

• Extensively worked in BW Info cube, DSO, Multiproviders, Info sources, Info objects, Transformations, DTP’s Extractors, info sources, Info packages, Data sources and PC’s.
• Development reviews, FS, TS, TUT reviews.
• Developed load plans for huge volumes using Company Codes, GL Accounts, Fiscal Year, sales order, Trading partner, Audit trial and other BPC dimensions.
• R/3 and ECC logistics data.
• BW configuration, ETL background and Info Cubes design, strong on End-to-End BW Configurations.
• Automated the process of rolling forward the SPO’s as part of WRF and MRF activities.
• Successfully completed Unit testing, Integration testing and user Acceptance testing for the development before moving it to higher environments.
• Preparation and reviews of technical specifications, Unit testing documents.
• Worked on Virtual providers, Aggregation, Indexing, Compression, Remodeling and End To End Development Activity.
• Creating Report with Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters.
• Worked extensively on transporting and collecting object as per the dependency and move them to the higher environments.
• Worked on pulling Flat Files from Legacy Database into SAP Application Server through CA Autosys.
• Preparation and reviews of technical specifications, Unit testing documents.
• Solving Production issues of BW/BPC Developments.
• Co-ordinated with teams during customer acceptance testing and Automation of BW data flows using Autosys tool.
• Analyzed business requirements, functional specifications of the project.
• Interacted with business users to know what is expected requirements and developed the Tech specs.
• Developed reports, Dashboards using SAP LUMIRA 1.29 & Tableau (8x, 9x) for quick reviews to be presented to business and IT users.
• Prototyped data visualizations using Charts, drill-down, parameterized controls to highlight the value of analytics in Executive decision support control.
• Creation of Dimensions, Measures, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Developed visualizations and dashboards using the LUMIRA/TABLEAU Desktop.
• Developed storyboards, Info graphs, reports and workbooks from multiple data sources using Data Blending.

Confidential

Business Analyst

Responsibilities:

• Analyzed business requirements, functional specifications of the projects.
• Integration, volume and performance testing using testing tools such HPQC for the creation and execution of test cases.
• Created Primary, working and Historical versions of master data.
• Man-hour estimation and making the proposals.
• Interacted with client contacts and responded promptly to queries and requests and assisted the engagement team in identifying and solving the client issues.
• Built an operations cycle to enhance customer experience & increase revenue and ROI to the client.
• Prepared well-defined business Requirement documents (BRD) and statement of Work (SOW) based on clients view to meet his expectations.
• For integration, volume and performance testing using testing tools such as HPQC for the creation and execution of test cases. Responsible for tracking of incidents.
• Was the point of contact for the Cutovers and Go-Live activities for smooth and successful Go-Live.
• Headed the local Support Organization and was the liaison for On-site and Offshore resources.
• Helped with designing background jobs to schedule Order Creation automatically and related Output provided production support and handled Tickets and made sure they meet the SLA with in the time.

Confidential

Responsibilities:

• Analyzed business requirements, functional specifications of the projects
• Performed Man-hour estimation and making the proposals.
• Interacted with client contacts and responded promptly to queries and requests and assisted the engagement team in identifying and solving the client issues.
• Prepared well-defined Business Requirement documents (BRD) and statement of Work (SOW) based on clients view to meet his expectations.
• Performed Flat file loads from Application server, which are insourced by the external systems.
• Generating reports using BEX and Query designer.
• Worked on Open Hub destination to outsource the data in the form of a Flat file.
• Worked in BW Info cube, ODS Objects, Info sources, Info objects, Transfer rules, Extractors, info sources, Info packages, Info objects, Data sources, Data Extraction, Characteristics and Process Chains.
• Worked on LO Extraction & LO Enhancements, Created Generic data sources.
• Coordinated testing activities in the client environment and executed the necessary preparation for each test cycle by communicating with the technical and functional teams.
• Developed Test Cases and Test Scripts from functional specifications for integration, volume and performance testing.