We provide IT Staff Augmentation Services!

Sap Hana Developer Resume

PROFESSIONAL SUMMARY:

  • Experienced SAP professional with comprehensive technical expertise in Enterprise Resource Planning, Service Delivery, Infrastructure management and Project Management.
  • Extensive experience in working on IDE tools like SAP HANA studio, Oracle SQL developer, SAP BW workbench.
  • Strong experience in developing Information Models on SAP HANA Studio (Attribute Views, Analytical Views, Graphical and Scripted Calculation Views) in HANA 1.0 SP9/10/11/12.
  • Creating Procedures using SQL Script language supported by SAP HANA and transforming the complex SQL queries into HANA models.
  • Expertise in advanced modeling using Hierarchies, derived views, Views that need multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, variables, rank and analytic privileges.
  • Proficient in performance optimization of SAP HANA data models and SQL queries.
  • Hands on experience in SAP HANA Data provisioning using SAP BODS 4.2 with importing Metadata, table definition’s, performing initial load and replication.
  • Worked on Creating Analytic Privileges, Setting up data level authorization and privileges in SAP HANA Database.
  • Optimization of complex SQL queries and reconstructing them in order to transform them into HANA models.
  • Migration of Procedures from Oracle to SAP HANA and ensuring the data consistency in both the environments.
  • Played an active role in blueprint and design sessions, review meetings and provided recommendations while communicating the benefits, risks, and constraints to both the business and IT stakeholders.
  • Worked in Waterfall and Agile methodologies.
  • Excellent communication, organizational skills, attention to detail & the ability to meet tight deadlines.
  • Able to multi - task independently as well as an excellent team player.
  • Strong work ethics, self-starter, and a fast learner.
  • Hands-on experience in project planning, scheduling, and execution.

TECHNICAL SKILLS:

Development Environments: SAP HANA Studio, SAP BODS designer, SAP BO studio, SAP BW 7.3, Informatica PowerCenter 9.x, Oracle SQL developer

MS Office: Access, Excel, FrontPage, MS Word, Outlook, PowerPoint, Visio, and Project

Programming Languages: SQL

Databases: Oracle 11g/10g (SQL, PL/SQL), SAP HANA

PROFESSIONAL EXPERIENCE:

Confidential

SAP HANA Developer

Responsibilities:

  • Involved in complete life cycle implementation of projects that include data modeling, development, unit testing, documentation and production support.
  • Debugged and traced the views for any performance pain areas using Plan Viz for optimization.
  • Developed advanced modeling functions such as Hierarchies, derived views, counters, Restricted and Calculated measures, input parameters, filters, variables, rank and analytic privileges.
  • Provided full Support in the Production environment including resolving issues and incorporating new business requirement.
  • Managed modeling content in SAP HANA such as Import and Export of packages, Mass Copy, Schema Mapping and Delivery Units, etc.
  • Performed unit testing to verify whether the resulting data matches with stipulated performance benchmarks or not and identified the underlying issue.
  • Ensured security by creating Analytic Privileges and setting up data level authorization.
  • Followed the agile methodology for implementing the project.

Environment: SAP HANA, Oracle, SAP BO, SAP BODS

Confidential

Systems Engineer - SAP HANA Developer

Responsibilities:

  • Well-versed in complete Software Development Lifecycle (SDLC) mainly focusing on Requirement analysis, design, Development, Testing, Documentation, Reporting and Production Support.
  • Developed Information Models on SAP HANA Studio (Attribute Views, Analytical Views, Graphical and Scripted Calculation Views) based on the requirement.
  • Extensive experience in modeling using Different types of views, SQL, SQLScript topics.
  • Documented and built Unit test cases to get rid of any data discrepancies.
  • Well versed with SAP HANA Administration, Performance Optimization of HANA views.
  • Followed agile methodology and efficiently handled Sprint planning and scrum calls etc.
  • Ensured security through creating Analytic Privileges and setting up data level authorization.
  • Debugged and traced the views for any performance pain areas using Plan Viz for optimization.
  • Provided production support to end users.

Environment: SAP HANA, SAP BODS, SAP BO

Confidential

System Engineer- SAP BW Developer

Responsibilities:

  • Involved in complete life cycle implementation of BW projects that include data modeling, technical designing, development, report generation and data extraction.
  • Modeling and Building InfoCubes, ODS, InfoSets, and MultiProviders according to reporting requirements of FI.
  • Worked on data sources enhancements for both master and transaction data for the user reporting requirements.
  • Handled the tickets of priority 0, 1, 2 and 3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
  • Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
  • Enhanced LO Data sources as per the user requirement.
  • Provided full Support in the Production environment including resolving data load issues and incorporating new business requirement.
  • Creation of generic extractors to extract R/3 data from database tables and views.
  • Followed waterfall methodology for implementing the project.

Environment: SAP BW 7.3, Oracle, Informatica PowerCenter, BEx

Confidential

Systems Engineer - SAP HANA Developer

Responsibilities:

  • Worked with the business to gather and analyze requirements and create technical specifications in accordance with client business process and made changes in phases of design, development, testing based on continuous client feedback.
  • Played an active role in blueprint and design sessions, review meetings and provided recommendations while communicating the benefits, risks, and constraints to both the business and IT stakeholders.
  • Migrated Procedures and complex queries from Oracle to SAP HANA models successfully without any data discrepancies.
  • Created different graphical views and scripted view on SAP HANA Studio.
  • Managed modeling content in SAP HANA such as Import and Export of packages, Mass Copy, Schema Mapping and Delivery Units, etc.
  • Build test cases and performed unit testing to eliminate any data anomalies.
  • Knowledge of Data integration and transformation using SAP BODS and data provisioning using SRS.
  • Provided production maintenance and support to end users.
  • Usedwaterfall methodology and SVN as version control software.

Environment: Oracle 11g/10g, SAP HANA, SAP BODS, SAP BO

Hire Now