SUMMARY:

• SAP Certified HANA Consultant with over 11 years of Experience in Various technical and functional modules of SAP. Played a key role as a solution architect for the successful implementation of a Central Data warehousing environment using SAP HANA and SAP BI - BO-BW.
• Extensive client interaction & Team management skills.

WORK EXPERIENCE:

Confidential, PA

Sr. SAP HANA Consultant

Responsibilities:

• Worked on SAP HR consolidated Reporting.
• Extensively worked on SAP HANA Native DB Modeling data extraction and Reporting.
• Developed Complex Graphical & SQL Calculation Views and Analytical Privileges.
• Created Highly Complex SQL Dynamic Analytic privileges using stored procedures.
• Expert in Creating Hierarchical Models on HR info types.
• Developing SQL based Calculation views stored procedures, SQL Debugging and troubleshooting.
• Performance optimization of the HANA artifacts Functional and technical error handling.
• Transportation using HANA lifecycle management tool.
• Created dynamic/user specific currency conversion using stored procedure.
• Worked on automatic flat-file loading into HANA from FTP and developed an auto error correction mechanism to correct the errors such as duplicate records, type compatibility, miscellaneous characters etc.
• Worked on SQL Analytic privileges to apply the dynamic row level restrictions.
• Access data though virtual tables using Smart Data Access from Sybase and Oracle DBs.
• Analyze Sizing, configuration requirements & articulate specifications based on the Organizational data growth.
• Worked on Hierarchical Variables to filter the data based on organizational Hierarchies.
• Created complex input parameters using stored procedures.
• Implemented a mechanism in HANA to apply column level restriction to the data based on login user.
• Expert in SAP Data services (BODS) & have good knowledge of integrating Hadoop to HANA.
• Worked on SAP Netweaver OData, XS OData, Server-side Java Script, UI5 & Fiori.
• Migrated the Attribute views and analytical views into Calculation Views.
• Expert in complex filters using filter expressions, dynamic input parameters using procedures, parameters derived from tables etc.
• Worked on Parameter mapping in calculation views to optimize the performance.
• Can efficiently handle most of the performance issues in Native HANA models.
• Created proof of Concepts on HANA Cloud Platform (HCP) & HANA Cloud Integration (HCI).
• Did End to End Configuration, Design & Development using Smart Data Access, Smart Data Integration & Smart Data Quality in test environment.
• Extensively worked on HANA Cloud Connector to integrate the On-premise ECC application to the cloud to develop Fiori Applications.
• Worked on Data Provisioning Agent to connect various databases to HANA using DB Adapters.

Environment: SAP HANA 1.0 (SPS12), ECC EHP7, BODS, WEBI, Dashboards, IDT, UI5, FIORI, XS ODATA, NW ODATA, HCI, HCP, SDA, SDI, SDQ, Server-side JS

Solution Architect

Responsibilities:

• Analyze Sizing, configuration requirements & articulate specifications based on the Organizational data growth.
• Worked on HANA installation, Upgrade and Load balancing scenarios.
• Thorough understating of SAP HANA security and backup recovery concepts, Recovered HANA from critical failures.
• Access data though virtual tables using Smart Data Access from Sybase and Oracle DBs.
• Developed custom Approval screens using SAP UI5, creating XML and JavaScript Views using Eclipse and Web IDE.
• Configured sap Gateway services and Fiori Launchpad for deploying the SAP UI5 Applications.
• Worked on XS-OData and Netweaver Gateway based OData Services.
• Good at JavaScript, HTML5, CSS & XML technologies.
• Worked on Navigations, UI5 Viz Controls, Geo Maps in UI5, tree tables, hierarchies, folders etc.
• Developing Attribute, Analytical, Calculation Views and Analytical Privileges.
• Developing SQL based Calculation views stored procedures, SQL Debugging and troubleshooting.
• Performance optimization of the HANA artifacts Functional and technical error handling.
• Transportation using HANA lifecycle management tool.
• Created dynamic/user specific currency conversion using stored procedure.
• Worked on automatic flat-file loading into HANA from FTP and developed an auto error correction mechanism to correct the errors such as duplicate records, type compatibility, miscellaneous characters etc.
• Worked on SQL Analytic privileges to apply the dynamic row level restrictions.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau
• Extensively worked on Tableau visualizations such as Maps, Forecasting, Sets, Parameters etc.
• Can efficiently handle the User/Group management, security & permissions in Tableau.
• Created several dashboards on Sybase, HANA, Oracle, Flatfile system using Tableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Created Customer credibility analysis report using Design studio 1.6 with KPI tiles to display current and comparative year figures.
• Worked on Geo Maps and advanced Geo-maps to display the Bubbles.
• Developed CRM Dashboard to display the overview of the open, closed and on-going tickets and their details in the corresponding drilldown reports.
• Implemented cascading filters, report linking, personalization, multi-selection features using Design studio.
• Configured BODS to replicate data from Sybase to HANA DB, used scripts to handle delta, Monitored and troubleshot the replication errors.
• Developed complex WEBI report which is used by the organization to track and compare KPIs by month, quarter and year against the benchmarks.
• Created universes to consume HANA models in the BO Reports using (IDT)
• Created Crystal-Enterprise Financial Accounting reports with complex calculations, row /column /cell coloring and grouping.
• Created sub-reports in Crystal to accomplish the drilldown functionality.

Environment: SAP HANA 1.0 (SPS09 - SPS12), ECC EHP7, UI5, FIORI, ODATA, Tableau, BODS 4.1, IDT, CMC, Crystal Enterprise 4.1, Design Studio 1.6, WEBI 4.1, SUSE-Linux -12

Lead BW/HANA Consultant

Responsibilities:

• Played a key-role in building the functional migration strategy to migrate the BW system from Oracle to HANA DB.
• Worked closely with the Admin-team to handle the migration errors.
• Worked on Eclipse and Web-IDE based environment to create a Custom UI5 application to track the inventory consumption.
• Worked on SAP HANA Cloud Connector to integrate Netweaver gateway to Cloud.
• Created and extended FIORI analytical apps based on XS OData service.
• Created Fiori Applications using HANA live Views.
• Worked on Graphs, Geo Maps, Hierarchies, Trends, Table Controls, Layouts in SAP UI5.
• Strong understanding of Aggregation Binding, Context and Property Bindings in UI5 Controls.
• Can efficiently use Firefox, Chrome and Internet Explorer's Console Debugging JAVASCRIPT.
• In-Depth knowledge of JSON data models and other OData Formats such as XML.
• Built complex Composite providers to consume multiple SAP HANA views and Advanced DSOs together to achieve the required functionality.
• Worked on Multi-Temperature Data Management with un-load priorities to save memory.
• Thorough understanding of the Sybase Near-line Storage.
• Worked on HANA optimized Info cubes with Non-cumulative key figures.
• Thorough with the LSA++ architecture, used Advanced DSO for data staging and reporting.
• Created Open-ODS Views to virtually consume the HANA models using Smart Data Access, also used Open-ODS views with staging feature to optimize the performance
• Configured the replication strategy to replicate the data from Multiple ECC source systems to HANA DB using SLT.
• Consumed External views in BW and created Bex Queries on External Views.
• Worked on Operational data provisioning to bring data real-time using ECC extractors.
• Created Composite providers combining ADSOs and HANA Views.
• Consumed the Input parameters of HANA views in Composite providers.
• Extensively worked on Expert routines using SQL scripts.
• Partitioned the tables with high record volumes in SLT and replicated them as row tables instead of columnar tables for better and faster loading.
• Created complex ABAP routines in SLT to do taxation, pricing and discount calculations during the replication.
• Created Attribute, analytical and calculation views with Calculated, restricted columns, Currency conversions, variables and input parameters.
• Worked on SAP HANA Native Job Scheduling to stage the slow running views to improve performance and for batch processing the calculations.
• Implemented HANA live and extended standard business content using live Extension tool.
• Efficiently mapped BW authorization objects with SAP HANA analytical privileges.
• Created Customer, Material, cost-center cockpits to display the performance of each business entity using Xcelsius Dashboards.
• Created Crystal Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.
• Converted the reports into PDF, Excel and HTML format and scheduled Email to different business users based on their roles.
• Worked on Column level security in in information design tool with different security profiles to hide/ show business critical columns to the users based on their roles.
• Created derived tables in IDT with complex calculations and custom prompts.

Environment: SAP HANA 1.0 (SPS08), SAP UI5, XS ODATA, NW GATEWAY ODATA, SAP FIORI, SLT, ECC EHP6, BW-7.4, IDT, CMC Lumira 1.2, HANA Live, Crystal Enterprise 4.1, WEBI 4.1, Xcelsius Dashboards4.1, SUSE-Linux -11

BI/BO-BW Consultant

Responsibilities:

• Interacting with the Customer, Understanding Customer business requirements, analysis, technical design, development and testing of various global templates.
• Developed a BW data mart for vendor's information, which includes all operating expenses transacted from 2 Legacy R/3 systems.
• Applied ABAP code to restrict confidential Company Codes, GL Accounts, Vendor numbers, Cost Centers and Chart of Accounts in the standard master and transactional DataSources.
• Handled currency and unit of measure conversions using expert routines.
• Did LOC extraction and extended the standard extractors using BADI implementation.
• Worked on FI extractors with cube compatible and non-cube compatible modes.
• Handled process chain errors with respect to Data loading, PSA errors, TRFC errors IDOC errors and other data compatibility related / depended process errors.
• Installed and extended the standard BW business content as per the requirement.
• Created multi-providers to combine the data from multiple source systems.
• Worked on non-cumulative key figures to load the inventory data.
• Developed reports on Profit and Loss account, Income statement and Balance Sheet. Created Variable Exits to show the Invoicing amount of the respecting periods.
• Created CO-PA report in Crystal-Enterprise to display the current and comparative year key figures such as Planned and Actual values.
• Worked on complex calculations in Crystal Reports such as conditional formatting, running totals, conditional hiding of rows and cell data, dynamic display of the report headers etc.
• Used WEBI reports as the drilldown reports to navigate from crystal reports.
• Implemented the component navigation functionality in WEBI.
• Created complex WEBI reports from multiple BEx Queries with input parameters.
• Designed WEBI reports with dynamic / calculated / Dependent prompts, multi selection prompts, inter dependent graphs etc.
• Scheduled WEBI reports to the users to receive the PDF attachment every morning.
• Worked on roles and authorizations in CMC to display / hide certain folders based on the privileges of the groups.
• Extensively worked on the Life cycle management to Transport as well as back-up the necessary versions of the reports.

Environment: ECC EHP6, BI-7.0 Crystal Enterprise 4.0, WEBI 4.0

BW Consultant

Responsibilities:

• Responsible for developing BW data models and to analyzing the BW reporting requirements, developing detailed reporting specifications.
• Thorough understanding of the Functional specifications and outstanding issues related to specifications.
• Created various BW modeling objects such as info-objects, real time/ virtual cubes, Info-cubes, DSOs, info-sets, multi providers
• Developed complex ABAP code in the end routines and start routines of the Transformation.
• Created Process chains for Master data and Transaction data loading.
• Enhanced standard LIS extract structures and Master Data objects and extractors.
• Worked on Infosets to provide reporting solutions of cross functional areas.
• Extensively used BEx Analyzer, created queries with variables, restricted/ calculated key figures, conditions and exceptions.
• Designed and developed complete data loading procedure using process chain and events.
• Set the extraction process using LIS, LO execution cockpit and V-3 updates.
• Scheduled and monitored the data loads in production.
• Monitored the LO Extraction Cockpit and the Delta Queue Maintenance.
• Performed detailed analysis to improve the performance using Info Cube Compressions and Aggregates.

Environment: ECC 6.0 ABAP, BW-7.0, BEx Analyzer, BEx Query Designer

Confidential, The Woodlands, TX

ABAP Developer

Responsibilities:

• Worked on Data migration to transfer the data from Legacy system to SAP using BDCs and BAPIs.
• Created Standard and Custom IDOCs for data transfer & share data between systems.
• Developed a complex module pool program for product tracking, which enables the business users to find out the missing products during the shipments.
• Worked on RFCs to communicate with the vendor's SAP environment to check the stock information.
• Enhanced several sales and purchasing transactions using BADIs and user exits.
• Used scripts and Smartforms for printing business forms and Cheques.
• Proficient in ALVs, Created several Classical, Interactive, Drilldown and ALV Tree reports.
• Used ABAP Objects to Embed ALVs in Module-Pool Programs.
• Worked on barcode label printing using SAP, created a program in ABAP which can be used for printing barcodes on Sheets as well as roles.
• Worked on Automatic E-Mailing of Purchase Orders
• Worked on RFID tag detection through non SAP system for stock audits
• Extensively worked on IDOCs to communicate with 3rd party system through EDI tools
• Worked on Web-Services to update the stock on the Web portal
• Generated ALVs with Drag & Drop function, Custom Menus & Buttons through OO ABAP
• Worked on Search help Exits, Lock Objects, Custom validations in TMG.