SUMMARY

• Over all 10 years of IT experience in SAP Net Weaver BW 7.4, 7.3, 7.0 and 2 year of SAP Native HANA, BW on HANA.
• Involved in Complete life cycle implementations of BW projects from Systems Analysis, Defining Requirements, GAP Analysis, Data Modeling, Design and Development, Data Extraction, Validation, Data Reporting and Transport, till Go - Live to Production and Application Support.
• Conducts End User training in navigating reports, post go live maintenance, web application, and designer portal.
• Highly organized, detail-oriented professional with strong communication, Client Interfacing and Strong technical skills.
• Experience in creating Attribute View, Analytical Views, Calculation Views and Importing BW Models to HANA Studio and Eclipse.
• Worked on integration of HANA with GCP data lake using SAP BODS.
• Worked extensively on optimization of Hana Views.
• Extensively worked on creation of InfoObjects, Hierarchies, Transformations, ODS/DSOs, InfoCubes, MultiProviders, SPO’s, Data Transfer Process (DTP), Infopackages, Process chains, Open Hub Destination.
• Worked on Performance Tuning (BWA, Aggregates, Index, Compression, Partitioning and optimizing data package).
• Worked extensively with Transport Management using BW Transport Connection and involved in cutover planning.
• Experience in extracting data from different Source Systems (SAP SD, MM, FI CO, CRM, SAP POSDM, Flat file) and different connections using DB Connect and UD Connect.
• Worked with all kind of BEx elements such as Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures and developed complex reports using ISTEP.
• Created Universes over BEx queries and Info cubes of SAP BI using Universe Designer.
• Expertise in translating Business needs into end-user Reports with Business Intelligence Tools like Web Intelligence.
• Experience in coordination with administrative system management teams on BI performance, system maintenance, and SAP security. Establish a performance baseline. Monitor system load and reporting and tune for peak performance. Use resources including SAP Knowledge Base and Notes.
• Develop, promote and implement team processes and technical standards, including technical and support documentation for any modified or developed BI components.
• Support nightly BI batch processes and identify and resolve any recurring issues.
• Research and implement new technologies to increase productivity and performance.Participate and provide input and guidance to tool selection.

TECHNICAL SKILLS

Tools: MS Office, MS Outlook, MS Access, MS Project

SAP Proficiencies: SAP HANA, BW on HANA, BW 7.0,7.3,7.4, SAP R/3, SAP ECC 6.0, SAP IPSAP BO, SAP BODS, GCP

Operating Systems: Windows NT/2000/XP/2003/2010

SAP Tools Used: SAP HANA SP07, BW 3.5, BI 7.0, BW 7.3, BW 7.5, SAP HANA Studio, Solution Manager.

Reporting Tools: Information Design Tool, Universe 4.1, Dashboard, BEx and Business Objects XI R3, WAD, Enterprise Portal, BOBJ 4.0/4.2.

Testing Tool: HP Quality Center & Tools, MS-Office

Admin Tools: SLT, SAP Data Services and Flat file Uploader

Planning Applications: IP, SAP BPC

ERP Integration: SD / MM / New FI-GL / CO / PP / PM / CRM modules.

Languages: SAP HANA Database, ABAP/4, C, SQL, PL/SQL & VB

SAP Change Control Tool: Remedy / Service Now ticketing tool.

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Responsibilities:

• Creation of Hana views - Calculation view, Analytical view, Attribute view,customizing Info objects, ADSO’s, Composite providers, worked with CDS views.
• Conducting meeting with business to gather requirements and create stories for them, assign work to the team accordingly
• Conducting scrum meeting to take updates from team and understand any road blocks and take action accordingly.
• Responsible for interaction with business stakeholdes in order to understand their reporting requirements, business rules.
• Involved in performance tuning of Hana views.
• Involved in daily discussions with Solution Architect and business team to understand the functional specs and create technical specs accordingly.
• Attending Workshops with business users / Technical Specifications based on Functions specs & High Level Design Documents .
• Working with functional teams & stakeholders to prepare the reports.
• Preparing with blue print / requirement gathering / realization / go-live and post go-live activities to deliver the project requirements.

Confidential

Technology Lead

Responsibilities:

• Attending Workshops with business users / Technical Specifications based on Functions specs & High Level Design Documents .
• Working with functional teams & stakeholders to prepare the reports.
• Preparing with blue print / requirement gathering / realization / go-live and post go-live activities to deliver the project requirements.
• Conduct meetings with business and understand there difficulties and suggest solutions which could ease them in day to day work.
• Responsible for developing various objects and data flows on different change requests.
• Debugging and troubleshooting the failures as well as suggesting and implementing the appropriate solutions for the issues.
• Manage and work on Production incidents on the priority basis.
• Monitoring the data loads, incident management, SER’s,CHARM.
• Responsible for creation of BW queries, BW backend technical issues and resolution, Responsible for creation of InfoObjects, Hierarchies, Transformations, ODS/DSOs, InfoCubes, MultiProviders, SPO’s, Data Transfer Process (DTP), Infopackages, Process chains, Open Hub Destination in SAP BW system.
• Involved into BI reports Performance tuning to improve the critical BW / Workbooks reports execution time and worked with Basis teams to allocate addition CPU to improve the report performance.
• Responsible for designing Calculation Views using database tables, attribute views, analytic views in HANA.
• SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)

Confidential

Technology Analyst

Responsibilities:

• Participate in business and system requirements sessions, requirements elicitation and translation to technical specifications related to SAP BW and HANA.
• Work with EAM, MM and FI functional teams & stakeholders to prepare the HANA views and BI reports for key business holders which could help them in strategic business decisions.
• Interact with clients to elicit architectural and non-functional requirements like performance, scalability, reliability, availability, maintainability.
• Provide inputs to business on solution architecture based on evaluation/understanding of solution alternatives, frameworks and products.
• Designing Calculation Views using database tables, attribute views, analytic views in HANA.
• Responsible for creation of InfoObjects, Hierarchies, Transformations, ODS/DSOs, InfoCubes, MultiProviders, SPO’s, Data Transfer Process (DTP), Infopackages, Process chains, Open Hub Destination in SAP BW system.
• Designing Calculation Views using database tables, attribute views, analytic views in HANA.
• Designing SQL Script based calculation views in HANA, SQL Procedures to address complex business requirements.
• Performing table partitioning on large tables for performance optimizationand involved into Archiving process to save system space.
• Conduct meetings with business and understand there difficulties and suggest solutions which could ease them in day to day work.
• Work with cross work streams like data warehouse team, Salesforce team to determine best solution design.
• Preparing estimations, release plan and road map for future releases.
• Actively participate in Go-Live cut over activities and hypercare issues.

Confidential

Techonolgy Analyst

Responsibilities:

• Participate in business requirement gathering to develop the Finance Transformation Project reports which were related to BW data models into SAP HANA with sidecar approach / Enterprise HANA
• Attending Workshops with business users / Technical Specifications based on Functions specs & High Level Design Documents / Low Level Design Documents
• Working with functional teams & stakeholders to prepare the reports.
• Preparing with blue print / requirement gathering / realization / go-live and post go-live activities to deliver the project requirements
• Analyze the requirement gathering to work on HANA related reports, which are related to SPL / FI / MM / OTC NA, Canada & MEDi reports.
• Work with super users / users for SPL and P&L reports data issues and provide quick solution for report issues
• Interact with Business/Functional team to understand the Profit Center / Cost Center / Cost Elements Hierarchies, which are related to SPl, FI and Inventory reports.
• Work with stakeholders and completed the SIT / UAT activities and get signoff from users within the time lines.
• Actively participate in Go-Live cut over activities and coordinate with different project teams like Basis, ECC, Functional, SLT, Autosys, GTC BW and Security teams.
• Involve in creation of BW queries, BW backend technical issues and resolution
• Work on BW queries, DSO, Cube transformation and Brand / Management Description logics
• Involved into BI reports Performance tuning to improve the critical BW / Workbooks reports execution time and worked with Basis teams to allocate addition CPU to improve the report performance.

Confidential

Techonolgy Analyst

Responsibilities:

• Lead Responsibility of the support project with the team size of 6.
• Coordinating and guiding Offshore Team with Technical Issues.
• Design and implement SAP HANA data modeling using Attribute View, Analytic View and Calculation View.
• SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)
• Responsible for KT Acceptance document while RFC is being moved to Production.
• Participate in meetings with Business and Client BI governance in identifying the Issue and raising a Request for change (RFC).
• Responsible for developing various objects and data flows on different change requests.
• Development of Bex Report on Remote cube to show the Error Stack Sales data in BW system based on the selection conditions.
• Debugging and troubleshooting the failures as well as suggesting and implementing the appropriate solutions for the issues.
• Manage and work on Production incidents on the priority basis.

Confidential

Senior Systems Engineer

Responsibilities:

• Preparing Technical specification for infobject, DSO, cubes and information broadcasting.
• Modify standard and created custom Data Sources, InfoObjects, DSO and InfoCubes for SD, MM & FI.
• Validating data consistency in reporting with Data Target against PSA after loading them to data targets.
• Designing the SAP BW reports and web templates.
• Preparing the Status reports on weekly basis and Metrics on Monthly Basis.
• Involved in the discussions with the Business Users and helped the team in preparing the functional requirements.
• Involved in Creation of Events & Process chains.
• Involved in solving Data loading Performance issues and issues raised by the testing team during the testing phase.
• Developed Webi Reports on Bex Queries
• Involved in writing ABAP code as part of customization.

Confidential

Senior Systems Engineer

Responsibilities:

• Involved in preparing Technical specification for Inf object, DSO, cubes and information broadcasting.
• Successfully implemented a full life cycle implementation including Gap Analysis, Blue-Printing, Report Design and Development.
• Worked extensively on standard and custom defined LIS and LO extractors. Installed relevant SAP business content.
• Preparing the technical specs to meet the additional requirements/GAPs.
• Involved in ABAP phase relating to BW on creating the Routines like Start, End Routines.
• Regular interaction with the functional team and end users to understand their Reporting Requirements and creating function specifications
• Worked closely with business users within the Business Line and provide them with technical & functional support, advice and expertise in the solutions.
• Designing and remodeling the solution as per business requirement.
• Generated reports using BEX (Business Explorer) with variables, exceptions restricted key figures and calculated key figures
• Worked on performance of queries and performed various tuning techniques using Compression, Aggregates and Multiproviders.
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing.
• Participated in change control team for defect prevention/correction and approving changed/additional requirements. Defined phases for requirements that were not critical for initial go-live.