SUMMARY

• Over 12+ years of experience in SAP Business Warehousing (BW/4HANA, BW 7.5/7.4/7.3/ BI 7.0/BW 3.5) and SAP Business Objects 4.2/4.0/XI 3.1 and SAP Data Services 4.0/4.2.
• Strong hands on experience in full life cycle implementation of BW 7.4/7.3, BI 7.0, and BW 3.5 which includes Data modeling, Data Extraction, Data Loading (Full/Delta Up - Loads), scheduling, monitoring, BEx Analyzer, Query Designer, Application Designer, Testing, Go-live and Production support.
• Strong experience in Business Objects 4.2/4.0/XI 3.1
• Extensively worked in Business Objects Data Services (BODS 4.0/4.2).
• Extensive experience in developing data models in SAP HANA 1.0.
• Knowledge in creating SAP Native HANA information models such as packages, Attribute Views, Analytic Views, and Calculation Views.
• Knowledge in creating Advanced DSO’s and Composite Providers on BW on HANA.
• Comprehensive knowledge on data extraction from SAP R/3(FI-CO, MM, SD, CRM, SRM, HR, HCM) using different Extractors such as LO Cockpit and CO-PA.
• Good knowledge of complete Software Development Life Cycle as worked in a CMM level-5, PCMM level2 companies.
• Good experience in onsite and offshore model.
• Experienced in writing Start routines, End routines, Field routines and Expert routines using ABAP.
• Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.
• Experience in transporting the Business Warehousing Objects from Development to Quality and Productions. Knowledge of Transport Connection to collect objects for transport.
• Experience and good knowledge in the migration of data sources and content from SAP BW 3.5 to SAP BW 7.3 maintaining the Transformations and DTP’s.
• Experience in the configuration and implementation of the Process Chains for the regular data loads and scheduling and monitoring the data loads.
• Strong Experience in transporting the BW objects from Development system to Quality system by using STMS.
• Experienced in SAP BW front end tools BEX Analyzer, Query Designer and Web Application Designer (WAD).
• Experience with Calculated Key Figures, Restricted Key figures, Structures, Characteristic Variables, Text variables, Exceptions and Conditions.
• Strong experience in Business Objects and Proficient in Business Objects tools: Universe Designer, Desktop Intelligence tool, Information Design Tool, Web Intelligence Rich Client, Info View, BI Launch Pad, Crystal Reports, Dashboards/Xcelsius, Query As A Web Service, Report Conversion tool, Import Wizard and Live Office.
• Experience in Design, Development and Deployment of Business Objects Solutions for corporate reporting requirements and experienced in building Universes, running queries and developing reports.
• Proficient in generating Xcelsius Dashboards using the components like Charts, Selectors, Maps.
• Expertise in Installation, migration, maintenance, troubleshooting and overall administration of the Business Intelligence and Business Objects Suite.
• Compile and analyze detailed, user requirements with teams of primary business users, and technically trained personnel within IT department.

TECHNICAL SKILLS

Business Intelligence Tools: SAP BW/4HANA, BI 7.5/7.4/7.3/7.0 , BW 3.x

Reporting Tools: SAP Business Objects 4.1 / 4.0, BOXI 3.1, Xcelsius, Business objects Query for Excel, Crystal Reports, Universe Designer, Information Designer, Business Explorer, Web Application Designer, Reporting Agent, Report Designer.

Performance Management Tools: BW Accelerator, HANA Studio

ETL/ERP Tools: SAP R/3 3.0/4.0B/4.6C/4.7, ECC 5.0/6.0/7.0

Data Migration Tools: Business Objects Data services (BODS), SAP Landscape Transformation (SLT)

Database Experience: MS SQL Server/Access Sybase IQ Oracle DB2

Programming: ABAP HTML/DHTML SQL/PLSQL C/C++ UNIX

Software: MS Excel / PowerPoint / Project / Word Outlook

Operating Systems: Windows UNIX Linux Citrix

Monitoring Tools: Clarify (CRM Tool) HP Quality Center Solution Manager Share Point

Scheduling Tools: Tivoli Control-M Redwood UC4

PROFESSIONAL EXPERIENCE

Confidential, Manchester, CT

Sr. SAP BI Consultant

Environment: SAP BW/4HANA, SAP BW 7.5 on SQL Server, SAP ECC 6.0 (EWM, SD, MM), SAP BO WEBI, Analysis Office

Responsibilities:

• Highly involved in BW/4HANA migration and worked closely with SAP team on migration approach.
• Created ADSO, Composite providers, Open ODS view and Calculation views as per the data model to meet business requirements.
• Highly experienced in Data modeling, Development, ABAP coding, Calc views, Debugging, Data Extraction, Reporting, Performance tuning, Open Hub Services, Analysis Process Designer (APD), Process Chains, applying OSS Notes and Production Support.
• Exposed ADSO’s as calculation views to HANA DB and used it in Webi written sales reporting.
• Created multiple Sales and Finance datasets thru Open hub for non-SAP systems to meeting business reporting requirements.
• Involved in conversion of BEx to Analysis for Office workbooks.
• Developed and implemented the data approach, manage the detailed work and data load plan, coordinate and assist in unit testing, Integration Test, Acceptance Test and Production data load activities including overall cutover plan.
• Involved in various project cutovers (Outdoor Goof, Versatile, Mpos and CCA).
• Worked on development of new reports in BOBJ as per the business requirement.
• Involved in resolving the various tickets related to Stores/Store Managers and Business users by using Manage Engine ticketing tool.
• Good Knowledge in SQL-BI reporting and Power BI.
• Responsible for collection and documentation of the end user requirements and created technical specifications.
• Involved in Analysis Office End-user training.

Confidential

Sr. SAP BI Consultant

Environment: SAP BW/4HANA, SAP ECC 6.0 (EWM, SD, MM), SAP BO WEBI, Analysis Office

Responsibilities:

• Analyzed functional specification, converted into technical specification and provided estimation to complete the development to the client.
• Prepared Conceptual data modeling flows and presented it to the client.
• Involved in Granite enhancement project.
• Created Generic datasources on top of views V EQUI and ITOB.
• Created Generic datasources on top of tables SER01, SER03, SER06, SER08 and OBJK.
• Worked on WEBI reports Serial Number History and Serial Crate.
• Created Attribute views, Analytic views, and calculation views as a part of SAP Native HANA Modelling using HANA Studio.