SUMMARY

• 8+ years of I.T Experience in developing solutions in S/4HANA,SAP HANA 1.0,BI/BO 3.1/4.0/4.1/4.2 (Dashboard Desgin,Crystal Reports,Web Intelligence,Explorer,Universe,CMC),SAP BODS 4.x,SAP BW and SAP Fiori
• SAP HANA 1.0 certified consultant
• Full life cycle implementation in SAP Business Intelligence projects using SAP HANA,bW,BODS and Business Objects
• Expertise in extracting datasets to HANA using data provisioning methods like BODS,SLT, BW Info providers,Smart data access and Flat file upload
• Hands on experience in designing/modelling HANA information views
• Expertise in BO reports creation like Explorer, Dashboards, Universes, WEBI, Crystal Reports on top of HANA,BW and relational datasources.
• Created HANA views and datasets on top of BW info providers
• Involved in converting BW cubes into HANA optimized cubes
• Developed SAP UI applications to consume HANA info. views using OData services
• Involved in creating SAP FIORI applications integrating with Suite on HANA,ABAP gateway services which is new innovative technology from SAP
• Understand the customer requirement, involved in creating Customer POC ‘ s in SAP HANA, BO,BW,BODS,Linux
• Proficient in backup/restore,securing the datasets,server load balancing on Linux machine
• Hands on experience in BO CMC,HANA administration

TECHNICAL SKILLS

BI Tools: SAP HANA(Modelling,Administration,Developer mode),SAP Fiori, SAP Business Objects XI 4.1/4.0 /R3, Dashboards, Explorer, SAP BO MOBILE, (SAP BOBJ, Xcelsius - Connected and Unconnected Mode, Live office, Web-Intelligence, Desk-I, Universe Designer, Information Design Tool, OLAP Universe over SAP BW7.0/7.3, CMC Administration- Import Wizard, Security Group Creation, Performance Management - Metrics Universe, Dashboard Manager),Crystal Reports 2008/2011/4.0 , Lumira,Advanced Analysis for Excel, Life Cycle Management Console

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, and data definition table, Business Rules, data modeling, system integration,Data warehouse

DataBases: HANA,Sybase,SQL Server 2005/ 2008, Oracle 11 g,IBM Netezza

PROFESSIONAL EXPERIENCE

Confidential

SAP Consultant

Responsibilities:

• Gathered functional requirements from the Business Users and Analysts and translated them to technical requirements and SRD (Specification Requirement Documentation) to create SAP HANA information views.
• Designed the Universe by defining necessary Joins, Cardinalities and applying Contexts/Aliases to maintain the overall integrity of the Universes by resolving loops
• Created Customer and System WEBI,Crystal,Dashboards,BOE Explorer and Lumira reports of high complexity which involved multiple data providers, Report level and Block level drill filters, Alerters for conditional output and Input Controls
• Daily/Weekly/Monthly basis tested and checked the integrity of the reports after migration.
• Created complex monthly, Quarterly, MTD and YTD rolling graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
• Administrating the content by creating the users in SAP BO
• Designing and developing BOE reporting Solutions on traditional database and Business Intelligence
• Have extracted source tables to HANA using data provisioning method BODS
• Have created various information views like Attribute,Analytical and Calculations Views
• Provisioned HANA information views in IDT Universe and developed BO reports
• Project Carried out the following activities:
• Experience on understanding the reporting requirements and involved in requirement gathering sessions with Business Analysts.
• Involved in creating various prototypes showing capabilities of SAP BO reporting tools
• Have scheduled and maintained distribution of various reports as per end user requirements
• Have created SAS EG reports for all state data with foreign locations
• Have simplified most of the complex traditional reports by transitioning to BO
• Have contributed various learning's on internal WIKI page to show the power of SAP BO reporting capabilities and how your business can be easily simplified using BO reporting

Confidential

SAP HANA Consultant

Responsibilities:

• Involving in Business Workshops and Facilitated Workshops
• Content migration HANA datasets from one HANA server to another HANA
• Administrating the content by creating the users in SAP BO, SAP HANA
• Working on Work Break down Structure (WBS) and Risk Mitigation factors
• Key resource in designing and building High Performance Analytical Appliance (HANA) database schemas, providing Business Intelligence solutions.
• Designing and developing BOE reporting Solutions on HANA database and Business Intelligence
• Working on ETL tools for data provisioning and Integrating multiple databases from ERP,BW,Non SAP to HANA and performing modelling to provision data
• Key resource for gathering requirements from pre-sales team and designing planning scenarios using High Performance Analytical Appliance (HANA) with BI using integrated planning.
• Identifying project gaps during requirement analysis
• Playing a vital role on creating new database models and schemas for HANA database, Business Intelligence on HANA using Revine™ as per the requirement.
• Working on HANA database to extract data from several 3rd party systems to Business Warehouses
• Involving on data cleansing activities to extract data in HANA to Business Intelligence using DataClean™.
• Working on performance optimization, data load stress optimization, query optimizations
• Working on data quality validation after is made available in HANA database.
• Key resource for modelling of reporting solutions in HANA modeller.

Confidential

SAP HANA Consultant

Responsibilities:

• Created WebI reports include formatting options such as Charting, Sorting, Crosstab, Alerting, Field highlighting, Parameter prompts.
• Developed Ad hoc reports.
• Done reports based on Query Filters, Report Filters &Prompts in Webi.
• Used multiple data sources and performed merging options.
• Created various reports like Plant wise, Company Wise, Year wise reports.
• Involved in Business workshops for client requirements
• Analysing existing data for current requirements and performed test script to improve data quality
• Involved in Business Requirement Specification, Software Requirement Specification and Software Development Specification documentation.
• Have played a vital role in designing Layered and Scalable Architecture.

Confidential

BO Developer

Responsibilities:

• Created Crystal and Web I reports include formatting options such as Charting, Mapping, Grouping, Sorting,Crosstab, Alerting, Field highlighting, Drill-down, Parameter prompts
• Created linked Sub-reports (regular and On-demand) & unlinked Sub-Reports along with the Primary reports in Crystal Reports.
• Used new features like Cascading Parameters in Crystal Reports .
• Maintained and modified the existing reports depending on the user requirements.
• Created the reports using WEBI like prompts, Drill Down, Cross Tab.
• Created Alerter using WEBI to highlight the columns based on business criteria.
• Developed various Sales perspective dashboards viz Sales Overview, Sales by Sales Person, Sales by Product line and Sales by Region.
• Designed and Developed Xcelsius Dashboards by using various components.
• Grouping, Sectioning, Summarizing and Filtering were carried out efficiently in the reports developed using Crystal Reports.
• Created QaawS and Live Office connectivity to WebI for refreshing Xcelsius with current data.
• Worked with the creation of Pricing reports in WEBI to show the conditional records by Sales orgs wise.
• Used Slice and Dice, Drill Down, Filters, Cross Tab and formulas and developed Hierarchies to support drill down reports.
• Interacting with team and analyse the requirements, suggest them the changes where required and then develop the objects as per the evolved specifications in the High Level Design Document.
• Provided the training to end user on Business Intelligence like reports development and usage
• Validated the Business Intelligence data with respect of Functional concepts using SQL Queries.

Confidential

BO Developer

Responsibilities:

• Used predefined conditions and prompts to filter the data in the universes.
• Generated various number of reports on a daily, weekly and monthly basis using WebI and Crystal Reports.
• Created Web Intelligence reports, graphs and charts facilitating drill down.
• Maintained and modified the existing reports depending on the user requirements.
• Developed Ad hoc reports using Business Obj ects.
• Created the reports using WEBI like prompts, Drill Down, Cross Tab.
• Created Alerter using WEBI to highlight the columns based on business criteria.
• Grouping, Sectioning, Summarizing and Filtering were carried out efficiently in the reports developed using Crystal Reports.
• Used Slice and Dice, Drill Down, Filters, Cross Tab and formulas and developed Hierarchies to support drill down reports.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Preparing the Technical Specifications after fixed the issues and uploading them in central location for sharing it to the respective teams.
• Analyzing and finding a solution for the various defects/tickets raised by teams.
• Enhancing various reports in health care systems making relevant changes in data Sources and Semantic layer.
• Download the data of various reports in different formats as per the requirement of the users.