SUMMARY

• Around 7+ years of software development experience in SAP Native HANA/BW/BOBJ/SAC.
• Expertise in performing BI Role gathering requirements, analysis, modeling, design, and development of reports and dashboards for analytics and reporting applications.
• Proficient in data extraction from SAP ECC, FI/CO, SD, MM, Flat files and BW using standard extraction structures and generic extractors.
• Experienced in developing Hana calculation views, CDS views, SLT replication and SAC Dashboards.
• Involved in full life cycle implementation which includes analysis, requirements gathering, development, testing, Go - live and Post Go-live support
• Excellent Team Player and Team Handling Capabilities.
• Good interpersonal relations, strong communication skills, hardworking and high level of motivation.
• Experience on working with SAC Models, Story Board, Digital Board Room, Analytical reporting on Multiple Source Connections, Hierarchies, Geo Maps, Smart Insight and Discovery, Smart Predictive, Search to Insights, etc.
• Was responsible for setting up Security Architecture in SAC connecting to HANA, BW production systems.
• Expert in Implementing complex calculations inSACstories and Analytic Applications.
• Analytics & Reporting experience using native HANA models, BW and SAP Analytics Cloud (SAC).
• Trained users on developing adhoc storyboards connecting to Analytic models already developed.
• Experience in migrating BW/Bex objects to Hana DB and SAC along with proper migration documents and user training.
• Developed Dashboards using Xcelsius and Design Studio. Wrote and used complex CSS scripting to format the components in design studio. CSS Scripts used on the components in CSS Class and CSS Style sections.
• Extensive experience in Business Objects Client tools like IDT, Universe Designer, Crystal reports, WEBI BO Explorer, and Analysis for Office.
• Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes.
• Proficient in developing models in Hana 2.0 using Web IDE (Cloning containers, Building Models, Deployment of Models, Synonyms.
• Expert in building complex models using Calculation views, Input Parameters, Filter expressions, Input parameter mappings, Calculated columns, Functions, Table Functions, Window Functions, Procedures in Hana Studio and Web IDE.
• Good hands-on experience in Hana SQL (Writing complex queries, use cases for Table Functions and Procedures), Decision tables & Analytical Privileges.
• Proficient in Performance Tuning of Complex models using Plan Viz, SQL Trace, Partitions techniques, push down mechanism etc.
• Worked on Materialized Views and stored the data into Tables using Procedures to improve the performance.
• Proficient in SAP SLT configuration and replication of tables using various replication techniques.
• Extraction from SAP sources to non-SAP targets and vice versa using SAP BODS.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

SAP Analytics Cloud/ HANA Consultant

Responsibilities:

• Worked on reading theBWmodels in to HANA and creating the HANA view to achieve the complex reporting requirement using SAC.
• Exposing SAC Data Models intoSACusing live connection.
• Expertise in using data models created in Sap Analytics Cloud and creating stories, publishing those stories in digital board room for executive reviews for sales/ finance performance.
• As a Member of SAP Analytics Cloud Implementation team, worked on the Analysis/Design/Development of the system by interacting both at managerial and user level, understanding their requirements.
• Created user SAC stories with business case and trained technical users for self-service.
• Successfully created Dashboard story inSACusing Canvas, Responsive pages and Digital boardroom.
• Tested and resolved data issues inSACDashboard stories.
• Expert in Implementing stories using different features ofSAC.
• Expert in Implementing complex calculations inSACstories.
• Manage security restriction inSAC.
• Revived and resolved both Front end and Back end performance issues.

Confidential - Madison, WI

SAP Analytics Cloud / HANA Developer

Responsibilities:

• Successfully Designed and Developed full stack BI/BW and HANA projects for different area of business.
• Gather functional/non-functional user requirements in order to optimize end to end design using BW/HANA and SAC/Tableau.
• Design, develop and implement new functionality for existing reports or Hana Objects.
• Knowledge of SAP HANA security including User Management, Roles and Privileges.
• Work with users to create personalized reports and to provide training on new functionality of the tool.
• Fine-tuned the data flow, for improving data load performance.
• Experience in SAP HANA Data Provisioning using SLT and data services.
• Work collaboratively with SAP Offshore consultants, project managers and users to develop consulting and project methodology, techniques, tools and solutions.
• Experience in migrating BW/Bex objects to Hana DB and SAC along with proper migration documents and user training.
• Determine the size and scope of technical developments of BW/HANA and SAC/Tableau projects.
• Handled various post-production support issues related short dumps, data loading, monitoring or DB space.
• Leading BW to Snowflake migration project including POC. Enabled Smart Insights and Smart Discovery features on Dash boards using Predictive Analytics functions.
• Tested and resolved data issues in SAC Dashboard stories.

Confidential - San Diego, CA

SAP SAC/BOBJ Developer

Responsibilities:

• Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.
• Analyzing the Function Inputs. Interacting with functional team to resolve the issues in the given objects. Development of technical specifications for the developments assigned.
• Exposing Data Models into SAC using live connection and create Dashboard story using Canvas, Responsive pages and Digital Boardroom. Successfully display story in Mobile SAC app using Responsive pages.
• Aided the upgrade of BusinessObjects to 4.2 SP11 - oversaw patching, governed analyst testing, performed and documented testing, and resolved incidents directly with SAP
• Responsible for complete migrating of BEX queries into BO reports extended to Xcelsius Dashboards.
• Single point of contact for the whole SAP BI BO project.
• Created 7 xcelsius Dynamic dashboards over SAP BI
• Designed BEx queries for HR Headcount and Turnover reporting. Reviewing the existing HR reports and calculations to work on re-designing them. Created cubes and DSO’s objects for petroleum business. Performed a system wide BEx query clean-up.
• Developed Business Objects WEBI reports with filters, ranks, prompts, drill downs, variables, charts, text cells, cross-tabs, merged dimensions, multiple queries.
• Worked on post go live production support in fixing, improving performance and investigating in finding root cause for data issues and worked extensively on support tickets.

Confidential, Houston, TX

SAP BI/BO Developer

Responsibilities:

• One of the core members of the project was involved in full implementation of the project right from the initiation of the project.
• Actively participated in the business user meetings to gather requirements by analyzing the business processes.
• Developed Dashboard mockups for initial cold eyes reviews with historical data of the company.
• Designed functional and technical specifications for implementation and development of BI 4.0 over SAP
• BI/BW 7.0.
• Created BICS connections on development and acceptance systems to be used across the board.
• Created Pre-Canned and Ad-hoc reports using Business Objects Web Intelligence (Webi) Rich Client by utilizing BICS Connection.
• Worked on BO Explorer in order to analyze the required business information.
• Strong Knowledge on Password repositories like Windows AD, LDAP, and configuring them with BOE.
• Successfully configured Windows AD and BOE with SSO enabled.
• I was in the Support team for Pre, post implementation of BOE environment over SAP starting from installing Application Servers to Migrating Documents in Production.
• Worked on SAP BI 4.0 and configured with existing SAP BW 7.3 environments.
• Extensive experience in working on IDT (Information Design Tool). Created BICS Connection using IDT in
• SAP BI 4.0.
• Created Xcelsius dashboards directly over BICS Connections using Query Browser and BI Web Services in
• SAP BI 4.0. Developed Dynamic Dashboards using Xcelsius by using SAP Netweaver BW Connection and
• Web Services like QAAWS (Query as a Web Service), BI Services and Live Office.
• Designed Xcelsius Dashboard with Filters, Label based menus, Flash Variable connections, SWF loader,
• Tabsets, Accordion menus, List Builder, List Views, Sliders, Fish Eye menu, Play Selectors, Grids Etc.
• Created dashboard to dashboard jumps for passing parameters using Flash Variables and created jumps from dashboards and WebI reports to WebI reports using Open Doc URLs.
• Worked on Performance tuning of Dashboards and WebI reports by enabling query stripping on WebI reports and elimination complex calculations from the excel layer of xcelsius and by optimizing the BEx queries and underlying WebI reports for dashboards using BIWS.
• Worked on BEx Query Designer and built queries using Restricted Key Figures (RKF’s), Calculated Key
• Figures (CKF’s), Free Characteristics, Structures, Variables, Formulas, Navigational Attributes, Filters,
• Conditions, and Exceptions to meet the business requirements.