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.