SUMMARY

• Having 10.4 years experience in SAP Business Warehouse. Specialized in SAP BW, BO, BODS, HANA, and ABAP. Data Warehousing Experience includes Requirements gathering, analysis, design and development of extraction, transformation and loading solutions using SAP BW.
• Involved in multiple full life cycle implementations using ASAP & Agile methodology
• Expertise in Customizations - Data Extraction with business content extractors, Generic Extractors and Master Data extraction from R/3 to BI System.
• Extracted Data from different source systems like SAP ECC, SAP BODS, SAP SRM, Informatica, Oracle and Flat File.
• Involved in writing ABAP code in Reporting customer exits, Transformation Routines, Data Source Enhancements.
• Developed SAP FIGL reports, SAP MM, PP, Sales Billing Dashboards using SAP Lumira and BO Dashboard tools.
• Expertise in designing and configuration of FI sub-modules, General Ledger (FI - GL), Accounts Payable (FI - A/P), Accounts Receivables (FI - A/R) and Asset Accounting.
• Hands on configuration in cross Modules FI- MM & FI - SD integration.
• Having Strong Functional Knowledge in SAP FI, SAP MM
• Derived the finance KPI's like Operating expenses, Total Income, Net book Value, Depreciation, Days of Sales Outstanding
• Designed models to develop the Maintenance cost report, Asset transactions report, GL reports
• Designed models to develop FSCM reports like Contact Analysis report, Degree of Worklist processing report, Receivables ageing report, dispute cases report etc.
• Designed Material Master Attribute Views, PO Analytical View based on SAP ECC tables in HANA Studio
• Created Purchasing reports on HANA Views.
• Loaded the data to HANA tables from SQL Server using SAP BODS
• Designed Delta Loads using ETL tool SAP BODS to get delta from SAP ECC.
• Having good understanding of SQL.
• Sound Knowledge of BI Reporting using SAP BO 4.0 (Webi, Dashboards) and SAP BEX
• Extensively worked on Designer ( Defining Joins, Dimensions, Measures, LOV, Hierarchies, Derived Tables, Resolving Loops, SQL Traps ) and Information Design Tool (IDT)
• Knowledge in QaaWS, Live Office, SAP Lumira, SAP Design Studio and Analysis Office.
• Certified in SAP HANA(Certification code: C HANAIMP141)
• Utilized test management tool HPQC for Defects
• Utilized ticketing tools Remedy, Service now in support projects
• Good Hands on in unit testing and integration testing
• Have the demonstrated ability to act in either a single contributor role or technical lead of a small sized team across the software full life cycle.
• Experience in writing the Acceptance Test Plans, Functional Test Cases and Acceptance Test Procedure (ATP) for System Level Requirements.

TECHNICAL SKILLS

ERP: SAP BW 7.3, 7.0, 3.5, ECC 6.0

Reporting Tools: SAP BEx suite, Business Objects

Planning Tools: SAP BPC

Big Data: SAP HANA

ETL Tools: SAP BODS

Operating Systems: Windows 2000, 2003, XP

Database Systems: SQL/PLSQL

Others: MS Project 2003, MS office, MS Excel, Adobe Acrobat

PROFESSIONAL EXPERIENCE

Confidential

Lead Consultant

Responsibilities:

• Interacting with Business users to build the Information Models such as Attribute Views, Analytic Views and Calculation Views according to the business requirements.
• Involved in implementation of HANA Information models for MM and PP Module.
• Implementation of Calculation Views using SQL Scripting and SQL Procedures.
• Implemented intensive logic in SQL Scrip to optimize the retrieval of data from HANA database.
• Transported the developed Information models from Development to Quality and then to Production using Transport Organizer through Delivery Units.

Confidential

Lead Consultant.

Responsibilities:

• Involved in Building Warehouse using HANA system
• Developed Attribute Views, Analytical views, Calculation Views in HANA system on base tables
• Updated the data to HANA tables from SAP ECC using SLT mechanism.
• Designed models to develop FSCM reports like Contact Analysis report, Degree of Worklist processing report, Receivables ageing report, dispute cases report etc
• Developed FI GL reports like Profitability analysis reports by restricting GL account
• Loaded the data to HANA tables using BODS from SQL server.
• Migrated the objects from one environment to another environment by doing schema mapping & delivery unit
• Defined row level security using analytic privileges
• Used different transforms like table comparison, merge, map operations, pivot in dataservices
• Developed FI, MM reports using BO reporting tools using Webi, SAP BO Dashboard

Confidential

Lead Consultant

Responsibilities:

• Documented requirements and performed Gap analysis to identify the gaps.
• Development confirmation with users and modification if required accordingly.
• Used Administration workbench to create Data Sources, Info Objects, Info Sources, Info Cubes, DSO, Info Sets, Multi providers
• Activated SAP delivered Business Contents.
• Followed LSA++ model to design the models.
• Created Transient provider to consume SAP HANA models
• Created Datasources on HANA tables in SAP BW
• Gathered Requirement for FI reports and developed
• Created end to end flow to meet the FI-GL reporting requirements.
• Designed models to develop the reports Billing overview, Incoming orders, value per customer, sales order and sales revenue reports.
• Defined ABAP logics in Routines, Customer Exit Variable.
• Worked on multi providers to gather data from various streams for the reports.
• Actively and regularly involved in Load Monitoring of Daily, Weekly and Monthly data loads using Process Chains.
• Monitoring of Info Packages and analyzing the reasons for frequent failures of Info Packages
• Designed the Data Flows in BODS by following best practice
• Designed the BODS jobs to load the data from SAP ECC to SQL Server and also from SQL Server to SAP BW
• Developed Webi reports using Bex Query as reference.
• Developed reports using various function operators, report filters and variables.
• Created Classes (Sub classes), Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes.
• Designed and Developed Webi Reports using the features like Charts, Cross Tabs, Drill Down, @Functions and Formulae to analyze the data.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters.
• Resolved loops and contexts to ensure the correct results from the query
• Involved in escalating tickets regarding extractions, Performance Issues and also load failures.
• Maintaining work history for all the tickets until it is closed down using service now

Confidential

SAP BI-BO Consultant

Responsibilities:

• Installed the BI content for MM,PM,PP,QM,CO Modules.
• Collected the objects in the transport requests and released using Solution Manager.
• Defined the technical specifications for COPA extraction.
• Created COPA datasource as per Technical Specifications
• Define CO Reports in the Sub areas Cost Center Accounting, Profit Center Accounting.
• Created Process chains for Master data & transactional Data.
• Developed custom programs to check the file in the application server
• Developed function module extractors to meet the PP reporting requirement.
• Initialized the master & transactional datasources.
• Designed PP KPI Dashboard using WAD
• Involved in Final Preparation as per Cutover activities plan
• Modifying existing WEBI reports and supporting the UAT process.
• Involved in developing Xcelsius dashboard with live office.
• Applied row level and object level restrictions as per the requirement.

SAP BW Consultant

Confidential

Responsibilities:

• Developed financial cubes (Income Statement, Balance Sheet).
• Extracted data from External source systems(Informatica)
• Created Historical cubes for Income Statement and balance sheet and created a Multiprovider on current cube and historical cube.
• Loaded data from Informatica using 3.x Infosource.
• Created multiple process chains to automate the data loads.
• Current load process chains will be triggered by Third Party tool and Historical load process chains are scheduled first day of month.
• Created Income Statement and Balance Sheet Bex queries which were used as source while developing the Web Intelligence reports.
• Transported the objects from Development to quality and then to production.
• Provided Production support by monitoring the loads
• Provided BO-Webi training.

Confidential

SAP BW Consultant

Responsibilities:

• Created Real time cubes and multi-providers (Standard and real time cubes), based on the user requirement.
• Extensively used Real time DSO, Standard DSO for reporting as well as for reconciliation programs.
• Responsible for taking care of actual data from BI side. For planning Involved in creating Planning functions to distribute the cost from one entity to other entity using SEM-BPS.
• Involved in Performance tuning by creating Aggregates, load balancing, compression, optimizing the code, refreshing the statistics etc.
• Developed Infoset queries on data base tables. Using Synonym SAP tables were connected to Oracle database tables.
• Created Process chains to automate the loads and used ABAP program process types to raise alerts to load monitoring tools.
• Involved in creating both monthly and yearly reports.
• Created Roles and Authorization and assigned to different users based on the requirement.
• Extensively used tools like Autosys, ITG to monitor the loads and to know status of developments.
• Used tools like IT Governence to promote the changes to Production.
• As a team lead responsible to conduct review meetings within the team and attending the status meetings with project managers and with client delegates.
• Involved in supporting the team to resolve the productions issues.
• Responsible to meet the SLA’s in response and as well as resolution time lines.
• Added value to the business by improving the performance of the system, reduced the defects in the deliverables, reduced the load failures, created programs to raise alerts for critical load failures.

Confidential

SAP FI Consultant

Responsibilities:

• Discussed with the client and documented the requirements for the Rollouts.
• Handled the configurations for FI - GL, AR, AP, Internal Orders
• Prepared the configuration Documents for Finance Modules, Controlling.
• Uploaded the Master data relating to Finance, Controlling and Asset Management.
• Carried the total Testing Cycles for the configurations done and closing the issues reported during the Testing Process.
• Prepared End User Manuals and imparted training to the End Users.
• Involved in Integration with other modules.
• Involved in implementation of CIN which includes defining condition types, tax codes, transaction keys and finalizing GL accounts for Excise, Service tax and Sales tax postings.

SAP BW-SEM CPM Consultant

Confidential

Responsibilities:

• Involved in configuring Balance scorecard, Management Cockpit and monitoring the systems.
• Design, construction and implementation of a strategic system for graphic visualization of strategic indicators of EGAT. The tool used for the implementation of the strategic system was SAP-SEM Management Cockpit.
• The activities comprised creation of the measure catalogue, construction of queries required by each frame in the Cockpit, up until the implementation of the Cockpit for the strategic indicators at Corporate level
• Involved in the design of the BSC for EGAT, construction of the graphs of each indicator with SAP-SEM tool (Cockpit). The scope of the Project concentrated to create the Balanced Scorecard.
• In the case of the frame for the visualization of HR indicators, I participated in the data modeling and loading of HR cubes.
• Customized cube such as Payroll Cube (0PY C02) and 0Employee, 0Applicant master data objects, Used DSO to stage the data before transferring the DSO contents to the Info Cube.
• Involved in creation of Info sets to meet the user requirements.
• Transported the configuration to Quality and Production systems.
• Created data flow diagrams for External Source System Modules like Water Management etc.
• Worked on the prototype of Value Driver tree (Economic Value Added EVA) with Planning Simulation (SEM-BPS).
• Uploaded HR reports to Enterprise Portal

Confidential

SAP BW Consultant

Responsibilities:

• Designed & developed custom Data Sources, Info Sources, Info Cubes and DSO as per the requirements.
• Extracted the transaction data by LO Cockpit from R/3 to BI by maintaining the extract structures, maintaining data sources, replicating the data Sources into BI.
• Involved In the designing of Technical Documentation
• Extracted the data using Generic Extractor
• Involved in enhancing data sources based on the requirement given.
• Involved in solving production support issues like load failures, Rollup, Indexes, change run.
• Involved in both the Activities monitoring and Production Support.
• Data loading was monitored and the failed data packets were analyzed and re-loaded to DSO.
• Involved in Rectification of Load Failure errors, like Master Data Loads, Transaction Loads.
• Performance Tuning of Cubes and Reports using Partitioning, Indexes, DB Statistics and Aggregates.
• Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx.
• Experience in creating complex queries using Structures, Calculated Key Figure, Restricted Key figures.
• Involved in the Data load monitoring using the Process Chain technology, As well as analyzing the data load failure issues.