SUMMARY

• An SAP BW/HANA Certified Solution Consultant with around 11 years of experience in SAP Business Intelligence, SAP HANA, SAP Business Objects (BOBJ) and SAP ERP.
• Involved in Multiple Full lifecycle BI/ABAP/HANA/BOBJ implementations which including requirements gathering & analysis, functional & technical specifications, technical design and development, testing and UAT phase, cutover and go - live support and post-production support.
• Involved in all phases of the BI project includes Requirements gathering, GAP analysis, Business Requirement documentation & Business Blueprint, getting client approvals, Development, Unit Testing, Integration testing, End user training, Go live and Support.
• Expertise in SAP HANA Data Provisioning using SAP LT Replication Server (SLT) and Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services 4.0(BODS), SDI and BW extractors.
• Expertise in creating SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script based methods, using SQL, SQL Script, and CE Functions as needed.
• Good knowledge and expertise on SAP HANA Live, BW/4HANA Virtual Data Models (VDM), CDS Views
• Worked on HANA 2.X with Web IDE for HANA Browser Based Integrated development environment.
• Expertise in develop calculated attributes, calculated measures, restricted measures, calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA studio.
• Worked on the Life Cycle Management to transport delivery unit across system land scape.
• Knowledge in SAP HANA advanced features - Dynamic Tiering, Smart Data Integration and BW modelling using HANA studio.
• More than five years of SAP BO experience in BO integration with BI/BW and HANA platforms and hands-on with BOBJ tools like Web Intelligence, Crystal reports, Lumira and Design Studio
• Modeling - Strong working knowledge of modeling SAP BW InfoCubes, InfoObjects, DSOs, InfoSources, Update Rules, Transfer Rules and Transformations, MultiProviders, Data Mart and Open Hub Service
• Worked with standard SAP R/3 & ECC 6 in areas including SD, MM, DM, FI, CO-PA, SCM, HCM, DM, QM COPA, CRM and SRM.
• Developed, Configured and Customized Data Extractions from SAP R/3 and Legacy Systems . Created Transformation, DTP, T ransfer and U pdate rules, R outines in transformations and currency translations.
• Good exposure on Schemas, table definitions, Attributes, Measures Hierarchies in HANA. Good Knowledge in SAP HANA security including User Management, Role and Privileges. Strong knowledge on data flows & workflows using BODS.
• Good knowledge of creating visual analytics using SAP Lumira on top of HANA information models and BOBJ design studio for Dash boards.
• Involved in SAP BIBO Reporting (Crystal Reports, Xcelsius, Design Studio and Web Intelligence).
• Expertise in working with new tools in BO4.x like Design Studio and Lumira

TECHNICAL SKILLS

Operating Systems: UNIX, MS-Windows XP/2000/NT/9x.

ERP: S/4 HANA, SAP R/3 4.7, 4.6C, ECC 5.0 and ECC 6.0

Data Warehouse Tools: SAP BW 3.5, 3.1c, 3.0b, BI 7.0,BW 7.4, Informatica, Talend, Cognos, BO XI 3.1, Qlikview and Tableu.

Programming Languages: ABAP/4, C, C++, Java.

Databases: Oracle 10g/9i/8i/7.x, MS-SQLServer, DB2.

Web Technologies: Servlets, Applets, JavaBeans, HTML and JavaScript.

GUI: VB 6.0 Swings.

PROFESSIONAL EXPERIENCE

Confidential

SAP HANA/BW Consultant

Responsibilities:

• Performed end to end SAP HANA implementations for several Align Technologies business units globally.
• Involved in various requirement gathering sessions with several Align Technologies business units across North America, South America, APAC and EMEA regions to analyze business requirement for real-time and historical reports
• Designed and developed HANA models like attribute views, analytic views, calculation views (both graphical and script based), calculated columns and input parameters as per the reporting requirement.
• Worked on JIRA Tickets, estimates, development and deploy as per SLA.
• Created information models for pVelocity reports that include Raw material BOM Levels quantities, cost and forecast reports by using SQL script and graphical Calculation views using HANA studio.
• Created Data models for costing info providers using BW modelling tool and developed composite providers on top of HANA calculation views.
• Conducted peer reviews and performance tuning of developed HANA models using best practices.
• Delivered simple to complex reporting capabilities based on project requirement and worked closely with teams in several geographical locations.
• Delivered reports in SAP BOBJ Analysis for office, Webi and Lumira tools as per report requirements.
• Involved and successfully implemented Unit testing, UAT and cutover activities as per the schedule of the project time lines.
• Designed and developed BW models for sales volume reporting requirement and provided data for AZURE data lakes using open hub destinations.
• Involved in production support for existing BW data flows and reports.

Environment: SAP HANA 2.X, XSA, Web IDE, HANA STUDIO, SQL, Flat Files, SD, FI, JIRA, pVelocity and BOBJ 4.2

Confidential, Mount Vernon, OH

SAP BW/4HANA Consultant

Responsibilities:

• This is SAP BW4HANA green field implementation under early adapter program from SAP and involved in successful implementation of Sales and finance reporting requirements. .
• Interacting with business users by conducting meetings and understanding the requirements and developing functional documents and reviewed the functional Specification document with Business and Functional T lead.
• Involved in Finance and logistics operational reporting requirement as per the user requirement and designed and developed data flows.
• Worked on logistics data sources and created data sources for tables like VBPA and replicated and loaded data using ODP Frame Work in both SLT and ECC sources.
• Designed and developed logic for converting partner functions multiple rows into single row using HANA AMDP and pushed transformation logic into HANA database.
• Developed artifacts like tables, CDS views using Web IDE using flow graphs for characteristic values of compressor on top of tables.
• Developed Flow Graphs Using Web IDE for Inventory Aging report using Case, Join, and Projection and Union transformations.
• Worked on UI5 Application for ATP (Global Available To Promise) Indicator for sales and deployed into XSA server . This will check finished product is available or not from all the warehouses .
• Created open DSO and integrated into sales order item level and provided required fields to reporting requirement
• Designed and developed LSA++ architecture and reduced redundancy and developed better solution
• Installed business content for Sales and Finance objects for reporting requirement.
• Designed and developed Bookings and Backlog reporting objects like ADSO, composite provider and reports using BW modelling tool
• Designed and developed complex Calculation views like price override reports for tracking price overrides for specific period which gets data from changelog tables using HANA Studio .
• Delivered reports in SAP BOBJ Analysis for office, Webi and Lumira tools as per report requirements.
• Involved and successfully implemented Unit testing, UAT and cutover activities as per the schedule of the project time lines.

Environment: SAP HANA 2.X, XSA, Web IDE, HANA STUDIO, SQL, Flat Files, SD, FI, and BOBJ 4.2

Confidential

SAP HANA Live /BOBJ Lead Consultant

Responsibilities:

• Interacting with business users by conducting meetings and understanding the requirements specified in the functional documents and reviewed the functional Specification document with Business and Functional Technical lead.
• Involved in Finance and logistics operational reporting requirement as per the user requirement.
• Developed SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script based methods, using SQL, SQL Script, and CE Functions
• Analyzed Information models in plan visualization tool and identified performance bottle necks and applied performance techniques to resolve the performance issues.
• Involved in Performance tuning of existing Models and improved performance of the reports by applying filters to table level and mapped input parameters to different views.
• Designed and developed Sales to stock dash board using Design Studio on top of HANA information models.
• Customized SAP delivered models, designed and developed models as per user requirements.
• Delivered reports in SAP BOBJ Analysis for office, Webi and Lumira as per report and user requirements.
• Involved and successfully implemented Unit testing, UAT and cutover activities as per the schedule of the project time lines.
• Developed and published stories and reports in Lumira server and in BI launch pad.
• Worked on the Life Cycle Management to transport delivery unit

Environment: SAP HANA STUDIO, SUITE ON HANA, SD, FI, HR, Lumira 1.29 and BOBJ 4.1