We provide IT Staff Augmentation Services!

Hana Consultant Resume

Santa Clara, CA

SUMMARY:

  • A Technically sophisticated as Solution and Design Consultant,Masters in Computer Applications (M.C.A) graduate and business - savvy management professional with a pioneering career reflecting strong leadership qualifications coupled with “hands-on” experience in Modeling, development, UAT, Production Support, Rollout. Performance and Trouble shooting. Maintain focus on achieving bottom-line results while formulating and implementing advanced technology and business solutions to meet a diversity of needs.
  • Architect Solution for Real Time operational Reporting and Design consultant and Leadershipmanagement/Offshore Coordinator.
  • Involved as a Architect role in previous assignment to propose the End-to-End implementation projects solution
  • Designing HANA Modeling Information views using modeling techniques.
  • Graphical, SQL Scripting & Procedures
  • Data Provisioning techniques used for Data Analytics using SLT.
  • Performance Testing & Trouble Shooting
  • SAP HANA Security and Privileges
  • Implemented Three full life cycle implementations for different modules of Logistics (SD,PM, PP,MM,QM) & Financial (FI-CO, COPA) for Data Analytics reporting
  • Experience in Configuring and Consuming SAP HANA models/views clients such as BO (Dashboards & WEBI), SAP Lumira for Visualization &Predictive Analysis and AO- Analysis Office.
  • Worked on BO(UDT, IDT, and WEBI) more on visualization
  • Interact with Stake holders and Client Discussions
  • Involved as a Architect role in previous assignment to propose the End-to-End implementation projects solution
  • ERP Implementation of ETL SAP BW on HANA
  • SAP BW Data Ware House Modeling
  • Requirements Gathering, Gap analysis
  • Functional and Technical Specification Development
  • Mentoring & Team Building
  • Transition Management& End user Training
  • Agile Scrum model methodology
  • Test Case process & Procedures
  • Defect fixManagement

TECHNICAL SKILLS:

Business Intelligence Tools: SAP BW3.5, Bi 7.0/ 7.3/7.4,Bex Analyzer & BO 4.0/4.1 Reporting Tools- WEBI, AO and Design Studio.

Technologies: SA BW/BI

ERP: SAP R/3 (Version 4.7E, Ecc5.0 and ECC6.0)

Database: SAP Hana (Certified), Oracle, SQL, MS- Access

Operating Systems: Windows NT 4.0, and Windows 2000 to XP

Other(Ticketing Tool): Solution Manager, BMC Remedy

EXPERTISE AREA:

SAP HANA Modeling Views: Build and Design the HANA modeling views for Data Analytics using both Graphical and SQL/Procedures to implement the solution design for the Account Mapping, Pipeline Conversion Ratio, Delivery Tolerance Report and Equipment Expenditure Replacement Cost. Adopted parallel techniques/filter pushdown/variables/input parameters, Hierarchies in developing models to achieve the performance

SAP HANA Security: Worked on HANA security for providing the access to DB Object Privileges and Analytical privileges to Provide the access/restrict the data access.

Data Provisioning: Expertise in Data Provisioning Techniques using SLT/BODS/SDA/DXC for Data Analytics. Worked with many of the clients using SLT to replicate the ECC tables to SAP HANA to leverage those to the HANA Modeling Views. Using Data Services connect to the Non-SAP systems like MYSQL/SQL server to replicate the data dictionary tables to SAP HANA server.

SQL scripting/ Procedures: Created many Calculationviews using SQL scripting/ procedures Rank (), DENSE Rank, Nth Highest, to determine the Delivery Tolerance using Add Workdays () Created SAP HANA information models such as Stored Procedures and HANA Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting and Stored Procedures.

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

HANA Consultant

Confidential, Wichita, KS

Solution & Design Consultant

Confidential, San Jose, CA.

SAP HANA Lead Consultant

Confidential, LA

Sr SAP BW on HANA Consultant

Confidential, Manila, PH.

SAP HANA Consultant

Confidential

SAP BW Lead Consultant

Confidential

SAP Sr BW Consultant

Confidential

SAP BW Consultant

Confidential

Sr. QA Analyst

Responsibilities:

  • Over 12 years of SAP HANA and BW on HANA consulting experience with clients spanning across Pharmaceutical, Media & Entertainment, Oil/Gas, Manufacturing and Retail in functional areas SAP PP,QM, FICO, SD,LE,MM,PS,HR . Have multiple certifications in SAP HANA and BW, BW on HANA..
  • BI Solution Architect on 2 full lifecycle SAP BW implementation projects, which includes 1 HANA BW, Two native HANA implementation projects. My Technical Hands on experience enables high productivity rate starting day1.
  • Have been working as a Architect in HANA modeler since HANA 1.0 SP9 & lately with SP12 version.
  • Certified in HANA - HA100/300 & 200 (Application & Tech Associate certification)
  • Expertise in implementing Enterprise Data Warehouse design architecture, allowing for flexible reporting and long-term sustainability. Successfully architected and delivered the reporting data by integrating data from multiple (non- SAP) data sources for Data Analytics.
  • Specialized in evaluating/dissecting existing BI /HANA Data Warehouse architecture and suggesting the right areas of improvements/redesign options/optimization opportunities. Experience in optimizing, performance tuning Native HANA, BW on HANA based on SAPs proven best practices and standard design principles
  • Translate complex business requirements into technical design solutions as per Data warehousing standards to meet user expectations.
  • Worked on BODS (Data Services) to extract the data from Non-Legacy Systems like Oracle server in to HANA system using Data harmonization and used for Data analytics
  • Experienced in working with stake holders Involved as a Architect role in previous assignment to propose the End-to-End solution for the Plant Maintenance business to get the Equipment Expenditure Replacement Cost at Functional location.
  • Proposed a complex solution for Service line towards the Deliveries Tolerance Report by using multiple calculation views of Graphical & SQL based on the Factory calendar of the plant.
  • Experience in SAP HANA data modeling using Attribute Views/Analytic Views/Calculation Views, Privileges, variables, input parameters, Hierarchies
  • Good exposure in Creating schema, designing Views using the join types, Nodes like Aggregation, Star Join, Projection, Data foundation.
  • Extensively worked on SAP HANA SQL scripting in the development of scripted based calculation view models
  • HANA admin activities: User / role management, HANA security, expensive statement analysis, performance/memory issues.
  • Involved in importing the BW models from SAP BW HANA to the HANA Studio
  • Created SAP HANA information models such as HANA Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting and Stored Procedures to design the models for Data Analytics.
  • Extensively worked on Attribute Views (Standard, Time and Derived), Analytic and Calculation Views (Graphical and Script based), Creation of Hierarchies, Adopted parallel techniques/filter pushdown/variables/input parameters
  • Experience in Working on HANA Studio, HANA BW Modeling Tools and Eclipse tool.
  • Extensively involved in Data Provisioning Techniques using SLT, BODS and SDA for Data Anlaytics and slice and dice.
  • Proficient in SAP SLT/SDA configuration and replication of tables by using various replication techniques.
  • Solution optimization and performance tuning expertise.
  • Experience in Configuring and Consuming SAP HANA models/views clients such as BI tools (Dashboards & WEBI, Tableau), SAP Lumira for Visualization &Predictive Analysis and AO- Analysis Office.
  • Good understanding on Star Schema and Extended Star Schema.
  • Worked on BO(UDT, IDT, and WEBI) more on visualization .
  • HANA admin activities: User / role management, HANA security, expensive statement analysis, performance/memory issues.
  • Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
  • Good in integrated understanding of the various aspects of business processes.

Hire Now