SUMMARY:

• Having around 7+ years of professional experience in Design, Development and Implementation of business applications i.e.SAP HANA 1.0,SAP BI 7.4 on HANA, SAP BI 7.3/BW 3.5 and BPC 10.1 as Techno Functional consultant.
• Worked on multiple full life cycle implementations for different modules in SAP BI/BW and SAP HANA, which involves Requirement analysis, Development, Testing, Documentation, Data extraction, Data modeling, Data loading, Reporting and Production Support.
• SAP BI/BW: Worked on Support Pack upgrade for BW and ECC systems.
• Excellent support experience includes process chain management, Monitoring and scheduling the jobs, tickets handling and performance improvement.
• Involved in OLTP extractions from SAP R/3 using LO Cockpit, FI & Generic Extractors (views, tables & Function modules).
• Created InfoObjects, InfoCubes, InfoSources, Aggregates, ODS objects, Update rules and Transfer rules, Transformations.
• Worked on installing and enhancing Business Content.
• Monitored data loads and trouble shooting of Master Data and Transaction Data.
• Involved in Performance Tuning & Optimization of data loads and reports.
• Designed queries in Bex Query Designer using Conditions, Structures, Exceptions, Calculated and Restricted key figures, Variables.
• Developed RRI Jump queries to drill down from summary to detail queries.
• Designed complex WAD Management Dashboards
• Worked on low, medium and high priority incidents and closed the incidents within SLA.
• Experience in ABAP with Start routines, End routines, Transformations level, Transfer rules level and Update rules level routines.
• Possess conceptual and analytical skills supplemented with good communication and interpersonal skills.
• ABAP knowledge to support Start, End, Transfer and Update Routines.
• SAP HANA: Good understanding of various components of SAP HANA and In - memory database concepts like Column store, row store, and attribute vector, delta merge functionalities.
• Good Understanding on creation of Schemas, table definitions, Attributes, Measures & Hierarchies in SAP HANA.
• Good Understanding on Data Modeling, Data Provisioning, Data Optimization and Authorization aspects of SAP HANA 1.0.
• Good Understanding 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) and Business Objects Data Services.
• Good Knowledge on using SQL CE Functions in SAP HANA for pushing data intensive logic to the database.
• Good Understanding of SAP HANA security including User Management, Roles and Analytic Privileges.
• Created multiple Webi reports on SAP BW queries using BICS.
• SAP BPC: Good Knowledge of SAP Business Planning and Consolidation Application in creating input forms, reports and various data models
• Hands on experience in developing functional models like CAPEX, Headcount planning and Department Spend.
• Experience in, master data and transactional data automation from BI to BPC.
• Good experience in Building input schedules, Reports.
• Automating month end process using Business process flows to facilitate users to close the month end reporting.
• Good understanding on Script Logics, EPM functions, Transformation files, conversion Files and DM packages

TECHNICAL SKILLS:

Data Warehousing: SAP BW 7.4 on HANA, 7.3, BW 3.5

ERP Packages: SAP R/3 ECC 6.0, 4.7E, 4.6C

EPM: SAP BPC 10.1

Languages: C, C++, and SQL

Operating Systems: Windows 95/98/2000/NT and MAC

Database: Oracle, HANA 1.0 SPS 09

Other Tools: HP ALM Tool

PROFESSIONAL EXPERIENCE:

Confidential

Environment: SAP ECC 6.0, SAP BI 7.4 on HANA and SAP HANA 1.0

SAP HANA Consultant

Responsibilities:

• Worked on Real-time FI GL reports using BW on HANA and views from SAP HANA
• Extracted data from BSEG, BKPF and GLT0 using SLT to get real-time data from SAP ECC.
• Created complex Information Models such as Attribute views, Analytic Views, and Calculation Views as per user requirements.
• Created Stored Procedures to load semantic data into Aggregate tables, which further used for reporting.
• Worked on creation of Analytic Privileges for the Views
• Involved in Query building, data refresh, autosys job monitoring, and complete testing with logic coverage by coordinating with functional, UI, and other teams.
• Created SAP BEx queries using Query Designer.
• Solving various day-to-day production issues and handling various notifications related to errors, data discrepancy and enhancements issues.
• Worked on various month end issues related to FI-GL from ECC to HANA from there into BW on HANA and at the publishing layer like HFM and File Maker.
• Monitoring the daily data loads from ECC to HANA and other non-SAP systems to BW and fixing the loading issues. Solving the support incidents based on priority without violating SLA.
• Involved in solving performance-related issues in both loading and report executions.

Confidential

Environment: SAP ECC 6.0,SAP BI 7.3, SAP BI 7.4 on HANA and SAP BPC 10.1

SAP BW/BI/BPC Consultant

Responsibilities:

• Solving various day-to-day production issues and handling various notifications related to errors, data discrepancy and enhancements issues.
• Monitoring the daily data loads from ECC and other non-SAP systems to BW and fixing the loading issues. Solving the support incidents based on priority without violating SLA.
• Worked on various month end issues related to 0FI GL 4 and 0FI GL 6 extractors from ECC to BW and at the publishing layer like HFM.
• Worked on Finance year-end rollover activities and resolved various issues during that time.
• Involved in solving performance-related issues in both loading and report executions.
• Analyze and stabilize the system by resolving the recurring issues with permanent fix by doing root cause analysis.
• Configured queries using filters, free characteristics, restricted key figures, variables, exceptions, conditions, and calculated key figures
• Created queries in Designer and designed complex WAD reports.
• Created query views in BEx Analyzer and embedded them into Workbooks.
• Involved in Support Pack Upgrade of BI, Portal and ECC systems.
• Worked on various Upgrade issues related to BW and as well as Portal. Raised OSS notes and contacted SAP to resolve various critical upgrade issues and fixed on time before Go Live.
• Hands on experience in developing functional models like CAPEX, Headcount planning and Department Spend.
• Experience in, master data and transactional data automation from BI to BPC.
• Good experience in Building input schedules, Reports.
• Worked on Security Set up (Task Profile, Member Access Profiles, Users and Teams), and Work Status Settings.
• Automating month end process using Business process flows to facilitate users to close the month end reporting.
• Good understanding on Script Logics, EPM functions, Transformation files, conversion Files and DM packages

Confidential

Environment: SAP ECC 6.0,SAP BI 7.3 and SAP BI 7.4 on HANA

SAP BW/BI Consultant

Responsibilities:

• Involved in Support Pack Upgrade of SAP BI system, Portal and ECC systems.
• Worked on various Upgrade issues related to BW and as well as Portal. Raised OSS notes and contacted SAP to resolve various critical upgrade issues and fixed on time before Go Live.
• Also, I am responsible for Support Pack Team Lead activities
• Involved in Validation of various business Scenarios and preparation of test scripts for SAP BW, Portal and ECC systems.
• Involved in various phases of testing like unit testing, Integration and Regression testing of BW objects
• Helped SAP BASIS team in various issues related to upgrades.
• Prepared cut over activities for SAP BI system and also involved in Go-Live activities

Confidential

Environment: SAP ECC 6.0,SAP BI 7.3 and SAP BI 7.4 on HANA

SAP BW/BI Consultant

Responsibilities:

• Worked on developing new objects like creating Info cubes, DSO, Info objects, Transformations & DTP’s. Writing start routines and end routines in transformations. Creating BeX reports, WAD Reports and publishing them in Portal by interacting with EP team.
• Involved in collection of various objects in to transports and migration of transports to quality system. And done monitoring of process chains whenever functional team asked. are used
• Participated in the cut over activities and Go-Live.
• Post Implementation Support & Maintenance
• Analyze and stabilize the system by resolving the recurring issues with permanent fix by doing root cause analysis.

Confidential

Environment: SAP ECC 6.0, SAP BI 7

SAP BW/BI Consultant

Responsibilities:

• MDG is newest centrally supported master data management tool from SAP. I was responsible for the development of the master data objects to load the data from various systems like MDG and ECC.
• I was involved in total re-replication of master data from MDG system as part of release2.0 and Developed various Tax Attribute objects to load master data from generic data sources which are coming from ECC and created various info spokes to provide this master data to downstream system.
• I was responsible for the development of various BI objects, which includes info objects, Info cubes, virtual cubes, DSO’s and Multi providers.
• Prepared technical design documents, affected dataflow diagrams and materials related to my requirements.
• Involved in collection of various objects in to transports and migration of transports to quality system. And done monitoring of process chains whenever functional team asked. are used
• Participated in the cut over activities and Go-Live.
• Post Implementation Support & Maintenance

Confidential

Environment: SAP ECC 6.0, SAP BI 7

SAP BW/BI Consultant

Responsibilities:

• Involved in review process of WRP (Work Review Plan) and WPR (Work Product Review). Prepared Test Cases and results for User Acceptance Testing.
• Tracking all testing activities through HP Quality Center, managing defects fixing
• Developed Process Chains based on events as per the requirements
• Scheduled background jobs in the Maestro Tool for the project
• Participated in the cut over activities and Go-Live
• Analyzed the existing environment for impacts and regressions.
• Developed BEX queries by using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information
• Developed SAP Infoset Queries to provide the outbound extractors
• Post Implementation Support & Maintenance
• Involved in Cutover activities and system refresh activities.

Confidential

Environment: SAP ECC 6.0, SAP BI 7

SAP BW/BI Consultant

Responsibilities:

• Post Implementation Support & Maintenance
• Installing objects from BI Content and Customization of DSOs and info cubes
• Enhancements of transfer rules, update rules and Transformations
• Configuration of Info packages and Data Transfer Processes
• Extraction of transaction data from R/3, loading from flat files to BW
• Extracted data from SD Module to BI using sales order header, sales order item data sources using LO Cockpit after customizing.
• Performed various tasks such as deletion of set up tables (LBWE), set up extraction, extraction checker, replication of data sources, and creating the Info package for the delta initialization and delta upload.
• Responsible for job schedules for loading data and monitoring data loads to run periodic loads
• Using BEX analyzer and Bex Designer for Development of flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information
• Creation of custom variants that allow users to choose report type based on variant conditions like sales division, sold-to-party and sales representatives
• Creation of Multi providers to enhance the reporting base
• Have knowledge on Partitioning of Info cubes, created and Deleted Indexes, maintained Aggregates, Rollup, Compressions to improve query performance and loading Performance
• Working extensively on Administration work bench
• Responsible for weekly transport deployments to production box
• Created Web I reports using Business Objects.