We provide IT Staff Augmentation Services!

Hana Consultant Resume

SUMMARY:

  • Having 6.9 years of IT experience in development, deployment and troubleshooting of Business Objects Enterprise using SAP HANA Modeler, SAP Crystal reports, SAP BODS, SAP HANA XS/OData
  • Expertise in creating Attribute, Analytic, Calculation Views.
  • Hands on experience in HANA modeling. Created multiple schemas and table Functions. Experience in creating Attribute views, Analytical view and Calculation views. Experience in applying privileges.
  • Created Batch Jobs using SAP BODS for various data sources.
  • Scheduling and monitoring BODS jobs in BI Launch pad
  • Experience in creating Tableau reports using SAP HANA as a data sources and other different Data sources.
  • Experience in Creating Crystal Reports (2008\2011\Enterprise 4.0) using Standard reports as per the requirements.
  • Have good working experience in RDBMS concepts
  • Strong Understanding of Data warehousing concepts and data modeling.
  • Report registration, scheduling and distribution of BO and Crystal Reports.
  • Involved in end - to-end implementation projects.
  • Experience in analyzing user requirements documents and preparing technical /design documents.
  • Designed the documentation for the Universes/Reports worked on.
  • Knowledge on SQL

MY STRENGTH:

  • Strong determination to succeed
  • Quick learner and hardworking
  • Flexible and adapt quickly to new working environments
  • Work independently and as part of a team
  • Effective communicator - can liaise with clients and communicate ideas with a wide range of people

TECHNICAL SKILLS:

Primary Skills: SAP Native HANA,SAP Crystal enterprise 4,Knowledge on S/4 HANA,SAP BODS

Secondary Skills: Oracle 10g/9i,MS SQL Server 2008/2005

Data Modeling: SAP HANA Studio( 2.0)

Reporting Tools: Crystal Reports

PROJECT EXPERIENCE:

Confidential

Tools: & Technologies: SAP HANA, Crystal Reports, SAP BODS

Operating System: Windows 8

HANA Consultant

Responsibilities:

  • Gathering and analyzing user requirements.
  • Creating Views in SAP HANA using HANA Modeler.
  • Converted Scripted Views to Graphical views.
  • Created Table Functions.
  • Created Data Services Jobs for loading data into HANA Tables.
  • Created Crystal reports on top of SAP HANA as per the requirement.
  • Loading data into HANA using SLT.
  • Scheduling and monitoring BODS jobs using launch pad
  • Working on Support tickets.
  • Working on Production Issues.
  • Working on Enhancement / New Development Projects
  • Knowledge on Xs/Odata services
  • Tuning reports to improve performances.
  • Created Tableau reports using HANA as data source as per requirement.
  • Creating Technical Design Documents.

Confidential

Tools: & Technologies: Business objects 4.0, Web intelligence, Information Design Tool, Oracle 10g and Teradata.

Operating System: Windows 2007

Software Engineer

Responsibilities:

  • Gathering and analyzing user requirements.
  • Interacted with functional team to gather the requirements of core reporting system.
  • Tuning reports and universe to improve the performances.
  • Modified the existing webi reports as per user requirement.
  • Creating new webi reports and graphs as per user request.
  • Used For each and for all function in calculations.
  • Used Break and sections functionalities as part of report development.
  • Attending the meeting calls on weekly basis.
  • Resolving the loops using alias and context in Data foundation.
  • Creating classes and objects in Business layer.
  • Creating the LOV’s and Parameter in Business layer.
  • Creating the Derived tables as per the user requirements.
  • Creating Global Filters and @ functions in Business layer.
  • Creating multiple tabs and headers as per user requirements.
  • Implemented the run period logic in universe and SQL Query level.
  • Created derived table in universe level based on SQL Query.
  • Scheduling the reports as per client requirements like daily and weekly.
  • Testing the webi reports SQL query in PL\SQL developer.
  • Tested Reports.
  • Prepare TDD and TOD documents.

Confidential

Tools: & Technologies: Business objects 4.0, Information Design Tool, Crystal Reports 2008\2011 and SAP Crystal Enterprise 4.0, Oracle 10g, SAP BW.

Operating System: Windows 2007

Associate Software engineer

Responsibilities:

  • Gathering and analyzing user requirements.
  • Interacted with functional team to gather the requirements of core reporting system.
  • Tuning reports and universe to improve the performances.
  • Modified the existing crystal reports as per user requirement.
  • Designed the universes using multiple data sources in IDT.
  • Resolving the loops using alias and context in Data foundation.
  • Creating classes and objects in Business layer.
  • Creating the LOV’s and Parameter in Business layer.
  • Creating the Derived tables as per the user requirements.
  • Creating Global Filters and @ functions in Business layer.
  • Creating crystal reports with the data sources IDT Universes, SQL Queries and tables.
  • Designing the crystal reports using various version in 2011 and crystal enterprise 4.0.
  • Creating the parameters in report level and SQL Query level.
  • Creating complex formulas by using formula editor and apply filters in reports.
  • Creating sub reports as per user requirements.
  • Creating drill down reports using group expert and suppress the fields for page headers.
  • Creating multiple page headers as per user requirements.
  • Implemented the run period logic in universe and SQL Query level.
  • Created derived table in universe level based on SQL Query.
  • Scheduling the reports as per client requirements like daily and weekly.
  • Testing the crystal reports SQL query in PL\SQL developer.
  • Tested Universe and Reports.
  • Prepare TDD and TOD documents.

Confidential

Tools: & Technologies: BOXI3.1, web intelligence, Universe, MSSQL SERVER 2012.

Operating System: Windows Server 2008

BO Developer

Responsibilities:

  • Converting Functional documents to technical document.
  • Designed Webi Reports as per the user requirements
  • Created Filters at Universe and Report level per the user needs
  • Scheduling and distribution of reports as per list updated in document.
  • Created standard reports based on the Universes.
  • Designed new reports and enhanced existing reports.
  • Training users to use the tool and create Ad-hoc business objects reports.
  • Developing user documentation.

Confidential

Tools: & Technologies: BOXI3.0, Crystal Reports 2008, Universe, CMC Oracle 9i.

Operating System: Windows Server 2008

BO Developer

Responsibilities:
  • Converting Functional documents to technical documents.
  • Designed crystal Reports as per the user requirements.
  • Created Filters at Universe and Report level per the user needs
  • Scheduling and distribution of reports as per list updated in document.
  • Created standard reports based on the Universes.
  • Designed new reports and enhanced existing reports.
  • Created Crystal Reports for highly formatting Requirements.
  • Used group by functionality some of the reports.
  • Training users to use the tool and create Ad-hoc business objects reports.
  • Developing user documentation.

Hire Now