We provide IT Staff Augmentation Services!

Sap Bw Hana Consultant Resume

SUMMARY

  • A goal - oriented professional, offering 8 years of experience with SAP BW, HANA, BO and Oracle applications
  • Possesses adept consulting skills, involving understanding client’s business pre-requisites, architecting viable solutions and guiding the implementation of end product
  • Performed well in both managerial and architectural aspects; completed complex project tasks; identified key drivers of defined problems and proposed innovative solutions
  • Highly skilled in managing Full Life Cycle Implementation, Business warehouse complete workflow, ETL (Extraction, Transform & Load) processes and Agile methodology.
  • Exhibited excellence in developing reports in Webi Dashboards by using SAP BEx Queries and experienced in running HANA queries
  • Holds rich experience of BW for BEx Query Analyzer and Designer
  • Created dashboards using SAP Lumira/Design Studio using Client specifications
  • Proficiently created BEx Reports, Workbooks, Variables, Calculated / Restricted Key figures, Structures
  • Thorough understanding of Business Objects and Dynamic Dashboards, Created and tested various VBA macros for implementation
  • Profound knowledge in writing packages, procedures and functions with ABAP code
  • Well experienced in SAP HANA Data Modeling
  • Successfully provided fixes to bugs raised by onsite during final phases of project delivery
  • Team-based Management style with expertise in driving the company’s vision into reality

TECHNICAL SKILLS

OLAP: SAP BEX, SAP BO, SAP HANA, SAP Lumira

Programming Languages: PL/SQL, SAP ABAP, C, Java

Web Technologies: HTML, VBA, XML

Databases: Oracle 11g

Functional Areas: Banking Domain, FLEXCUBE, Product Testing

PROFESSIONAL EXPERIENCE

SAP BW HANA Consultant

Confidential

Responsibilities:

  • Extensively used BEx Query Designer and developed Queries to retrieve the Analysis Actuals and Budget data for the chemicals data used in Sasol
  • Worked on Lumira Designer to create dashboards for Various chart applications
  • Developed scripting code to retrieve data from BW backend and created dynamic dashboards, reports in Business Objects
  • Integrated data from data sources into SAP HANA using ETL replication
  • Involved in Full Life Cycle Implementation from extraction till implementation
  • SAP Hana Data Modeling and creation of triggers and sequences in HANA schemas
  • Created Info objects, DSOs and Info providers in CO-PA area to support Business reporting and Sales forecast/planning.
  • Troubleshooting Report and query issues reported by users, to retrieve resolutions
  • Supported Sales and Marketing team with solutions for workbook and query issues
  • Created Aggregation levels, planning functions and planning filter in BW-IP to develop 5-year forecast tool for Sales and Marketing team
  • Hands on Experience in BW support during BW on HANA migration
  • Extensively used BEx Query Designer and developed Queries to Facilitate Sales forecast data Analysis in a Drill Down or Summarized way to provide Detailed levels of information
  • Written VBA macros code to convert data to BW flat files for data loads
  • Updated BEx queries and reports using BEx Query Designer/BEx Analyzer and evaluating performance of queries
  • Generated several Sales forecast planning workbooks using BEx and created planning filters in BW-IP
  • Designed ABAP based extractors for data extraction
  • Interacted with onsite team members to resolve issues related to Workbook macros and structures/variables
  • Involved in project planning and resource planning for Offshore team, and worked with Onsite lead to provide weekly status reports on tasks finished by Offshore team
  • Day-to-day support for Management team power users
  • Worked on data loads in Business Reporting, Management Reporting, Operational Reporting & Data Validation process
  • Written packages, procedures and functions using PL/SQL Developer

SAP BW/BO Consultant

Confidential

Responsibilities:

  • Created Management Analysis tool for Sales team using Business Objects Dashboards
  • Worked extensively on creating queries using BEx Query Designer
  • Designed various analysis applications using different charts to depict the various data selections
  • Worked extensively on BEx Query Designer and developed Queries to obtain Chemicals data
  • Design Studio application implemented to create dashboards for different chart applications such as Waterfall, Pareto, Ranked analysis, and Scatter graphs
  • Written scripting code to retrieve data from BW backend
  • Developed reports in Webi Dashboards by using SAP BEx Queries
  • Managed Full Life Cycle Implementation, involving initial analysis, configuration, testing, training, conversions, customization, documentation, roll-out and support activities

Associate Consultant

Confidential

Responsibilities:

  • Creation of new forms and reports, enhancement of existing forms and reports
  • Assisted team leads during onsite call and project closure, implemented fixes to various bugs during closure stages using PL/SQL code

Associate Consultant

Confidential

Responsibilities:

  • Carried out the role of programming backend code to implement relevant customer changes
  • Interacting with clients to resolve various critical issues faced during UAT support
  • Simulating and providing fixes to the issues raised by onsite team during project support

Hire Now