We provide IT Staff Augmentation Services!

Sr. Sap Hana Consultant Resume

PA

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

Confidential, Fort Worth, TX

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

Confidential, Plano, TX

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

Confidential, Houston, TX

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

Confidential, Atlanta, GA

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.

Hire Now