SUMMARY

• Having around 7 Years of SAP experience in requirement gathering, technical analysis, Estimation, design, development & implementation of business applications for Manufacturing & Retail, Pharma, Oil & Gas Sectors.
• Strong experience in Business Objects 4.0/4.1/4.2.
• Extensive experience in developing data models in HANA 1.0/2.0.
• In Depth understanding of Data Warehouse concepts, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, Physical & Logical Data Modeling, Fact & Dimension tables.
• Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Expertise in Universe designing, developing, and generating complex, Ad - hoc Dashboards and Reports with User Acceptance Test (UAT) and data accuracy test.
• Extensively used Business Objects features such as Publication, Scheduling, Hyperlinking and Webservices.
• Extensively worked on Business Objects Admin activities in Central Management Console which includes Report/Dashboard/Universe promotions, Connection creation, providing roles to the user and folder level access to the users.
• Expertise in HANA modelling such as Creating Views, Tables, Stored Procedures, Tables Functions and Scripted view.
• Extensively used HANA features like Input parameter, Variables, Hierarchies, Join, Projection, Union, Aggregation and Rank Node.
• Experience in Data-Provisioning techniques suing SLT SAP Landscape Transformation to perform real-time data replication into SAP HANA and near time data loading into HANA.
• Ability to analyze existing systems, conceptualize and design new ones, and deploying innovative solutions with high standards of quality.
• Self-starter who takes responsibility and accountability.
• Excellent time management skills and documentation skill.

TECHNICAL SKILLS

Business Objects Tools: Web Intelligence 4.2/4.1, Universe Designer 4.2/4.1, Information Design Tool, Analysis for Office, CMC, Import wizard, Design Studio, Lumira Designer and Xcelsius 2008.

Databases: HANA DB 2.0 and MS SQL Server 2008/2005.

Data warehousing: Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables.

Visualization Tools: SAP Analytics Cloud, Power BI and Tableau.

Languages: C, C++, PL/SQL and SQL.

PROFESSIONAL EXPERIENCE

Confidential

SAP BOBJ/ SAP HANA

Responsibilities:

• Leading the Business Objects team, responsible for designing and development of Webi reports and Universe on BW and HANA systems.
• Perform the gap analysis to understand the feasibility in designing the dashboard layout per business requirement.
• Created Web Service, Hyperlinking and JSP for the Webi report to get them access from other portals than BI launch Pad.
• Created and Maintained Publications for the Business user to get them daily report copy delivered.
• Created Dashboards on Web Intelligence, SAP Analytics Cloud and Lumira.
• Applying functionalities like filter, drill, jump to, conditional formatting, Hierarchies etc. to Dashboards.
• Performed BI platform upgrade testing, Connection setup and Managing Servers to track system performance.
• Managing Basis activities which includes Reports/Dashboards/Universes promotions from system to another, defining report/folder level access based on roles and User/Group creation based on business requirements.
• Trained the end users on the detailed design and analyzing the dashboard functionality.
• Responsible for designing and development of HANA modeling which includes creating calculation views using Calculated Columns, Hierarchies and Variables/Input parameter based on business logic.

Confidential

SAP HANA

Responsibilities:

• Responsible for designing and development of Stored Procedures to covert the business logic into an optimized code.
• Worked on the different joins conditions and functions to filter out the data as required.
• Performed the Exception handling to capture an exception occurred during the execution.
• Working closely with Functional team to gather information and understanding the functionally.
• Worked on SAP Web IDE interface to implement the logic.
• Created Technical Design document from the functional document.

Confidential

SAP BOBJ / SAP HANA

Responsibilities:

• Responsible for designing and development of Webi reports to Implementing complex logic to Webi reports.
• Interacted with Business users, Business Analyst, gathered business requirements, and presented the proof of concept.
• Created different types of reports, like Tabular, Master/Detail, cross Tab using multiple queries.
• Used filters, conditions, Prompts, Drill Down, @Functions, etc.
• Extensively used breaks for white spaces and sections for better navigation.
• Created complex Web Intelligence reports by linking objects from different data providers and using Merge Dimension Option.
• Created Web I Reports using Drill down functionality within different hierarchies.
• Performed validation check between source HANA view to report created.
• Created HANA calculation views to push any complex logic to view and restrict data at query level to improve reports performance.

Confidential

SAP BOBJ / SAP HANA

Responsibilities:

• SAP Data migration team for Legacy data analysis, Master Data (Materials, Customers, Vendors), and transactional data collection, extraction, cleansing, and transformation to load into SAP
• Interacting with legacy business users to understand business process flow, business logics and to assess major data objects, data volume for data migration.
• Working with business users/owners to gather data migration requirements, design data mapping documents, and define business rules for cleansing, and transformation requirements
• Worked in HANA modeling and built reports as a front end.
• Developed HANA Information Data Models Which Involves creation of calculated attributes, measures, restricted measures, calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA studio.
• Created Stored Procedure to implement business logics.
• Created Technical design document of all the process.
• Prepared Knowledge Transfer documents and conducted KT sessions for Client employees.

Confidential

SAP BOBJ

Responsibilities:

• Responsible for designing and development of Reports and Universe.
• Working closely with the Business Analyst to understand the Ad hoc and standard reporting requirements.
• Designed the logical semantic layer using the Universe designer tool by defining joins, cardinalities between tables and applying contexts and aliases to remove cyclic dependencies (Loops/traps)
• Resolved complex loop issues by creating multiple contexts and aliases to remove cyclic dependencies in the universes
• Applied Row level securities using security restrictions option in the Universe.
• Handled Embedded BO Functions like @Prompt, @Select, @ Variable, @Where, @Aggregate awareness in the designer to handle user requests for report generators. Set up Aggregate tables to enhance the SQL performance.
• Worked on editing the List of Values (LOVS) to create dynamic and cascading prompts.
• Worked extensively on the Web Intelligence functions like multiple queries, combined queries, report and block filters, and various reporting cosmetic options like section, breaks, ranking, sorting and formatting options.

Confidential

SAP BOBJ / SAP HANA

Responsibilities:

• Responsible for designing and development of Dashboards and Reports.
• Designed 4 client Dashboards which were showing live data feed from the Gas and Oil plants involving SAP MII integration with SAP HANA.
• Worked on linking, crosstab, drill, Dynamic Visibility, and Alert Feature functionalities.
• Optimized dashboard performance for speed of thought analysis even with large data volumes and simultaneously allowed user customization on the fly.
• Documented whole process and which helped for business user to understand.

Confidential

SAP BOBJ / SAP HANA

Responsibilities:

• Create Demo Dashboards for Client using Design Studio.
• Performed testing of the Dashboards.
• Modification to the existing dashboards based on user demand.
• Modification to existing HANA models which the logic based on user demand.