SUMMARY:

• Having 14+ Years of professional experience engaging with the business stake holders to understanding business needs and provide solutions out of 9 years of SAP Business Warehouse experience encompassing a wide range of skill set, roles and industry verticals.
• Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes based on HANA ASAP 8 Methodology.
• Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA 1.0
• Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.
• Excellent knowledge on: HANA Optimized InfoCubes, HANA Optimized DSO’s, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.
• Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes.
• Experience in Importing BW models (Info Cube, DSO) in HANA as Analytical view.
• Good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users in SAP HANA.
• 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 using SAP BODS.
• Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis BusinessObjects Explorer & MS Excel.
• Implemented 5 end to end full-life cycles using ASAP methodology across various modules in SAP BI/BW projects.
• Experienced in designing and maintaining Data targets like Info Objects, DSO, Info cubes and Virtual Provides like Info sets, Hybrid Providers and Multi Providers.
• Strong experience in BW 3.x and BI 7.x version and upgrade (technical and functional).
• Strong experiences in installing the Standard Business Content objects and enhance them into custom objects based on the business requirements.
• Worked on BW support project activities (data loading & monitoring and troubleshooting the failures).
• Experience in system maintenance tasks (Delta queue cleaning, Setup table deletion & validation)
• BW load/job automation through process chain and Control-M.
• Worked extensively in SD, MM, PP, and FI Modules.
• Strong in performance tuning (Data loading and BEX reports) and job failure reduction activities.
• Working knowledge and proficiency with Business Objects Enterprise products namely Business Objects Reporting, Business Objects Designer, Web Intelligence and InfoView.
• Working knowledge on creating universes using IDT on SAP HANA views and reports development on the same using Web Intelligence.
• Strong knowledge in building queries on different types of Data Providers and Universes.
• Migrated 3.x universes to 4.x,copied,enhanced and created the new Universes
• Designed the Universes in IDT & UDT on HANA & BW Sources.

PROFESSIONAL EXPERIENCE:

Confidential

SAP BI/BW HANA Consultant

Responsibilities:

• Involved in Collaborating with Client managers, DBA's, Reporting team, Business users and other Stake holders to understand SAP HANA, the existing landscape and identify key business use cases for the Poof of Concept (POC).
• Interacted with Business stake holders in order to understand their structured and ad-hoc reporting requirements, User stories, business rules for finance, sales and marketing domains.
• Worked on conducting workshops to go over the new tasks with the system administrators and SAP Basis Consultants and also created an application by application migration approach from SAP BW to HANA system.
• Leveraged knowledge of data ware house, ETL and software development methodologies to contribute to the overall planning by recommending approaches, identifying resources and developing timelines.
• Using Import selective Meta data for (SAP BODS 4.0) imported Meta data in the ETL Process prior to on boarding data into sap HANA, created schemas and data provisioned using SAP LT Replication Server (SLT).
• Developed Business Object Data Services (BODS4.0) jobs to pull external data from Flat files and Oracle into HANA database.
• Developed jobs to complete remediation of legacy data, data quality management, data profiling using both built in and custom functions.
• Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical Specifications.
• Created master data objects as Attribute views, joined multiple master data tables depending on the requirement, selected key figures and attributes to give context to the master data.
• Involved in creation of Analytical views to support multi-dimensional reporting by joining Fact table (data foundation) to modeled dimensions (attribute views), selected attributes and measures.
• Created Calculation views using data base tables, attribute views and analytic views, in order to address complex business requirements created SQL Script based Calculation views.
• Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE STUDIO
• Used Information Design Tool (IDT) to create connections to SAP HANA databases, Create data foundations and also created Business layer and publish these connections and layers to SAP BO Repository.
• Created reports by connecting to IMCE from SAP Lumira, SAP Business Objects Explorer (BEx) and MS Excel through ODBO/MDX for multi-dimensional reporting.
• Involved in business users and team members of SAP HANA Scenarios.
• Accessed HANA data as Pivot tables in Microsoft Excel through via MDX provider.
• Enabled Business Objects Explorer to search data present in HANA.
• Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through BOBJ Crystal Reports, BOBJ Dashboard Design, BOBJ Web Intelligence (Webi), BO Analysis.

Confidential, New York, NY

SAP HANA Modeler

Responsibilities:

• HANA and Business Objects Development done across all the below Areas for the COS Project:

  Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.

• Setup Table Replication (SLT) for ECC and 3rd party table’s real time into Hana. Data replication enhancements created for custom fields when required (during replication).
• Worked on SAP SLT Configuration and Monitoring Dashboard to create schema, monitor tables, monitor connections, monitor statistics of tables.
• Worked on Hana studio to load, replicate, stop replication suspend and resume tables in Server based table data provisioning screen.
• Worked on SAP SLT complex table structure changes (change data type or length, add or delete key fields) the trigger and logging table have to be dropped and recreated. Also on HANA side dropped and recreated to ensure data consistency.
• Developed Data Services (BODS 4.0) job to pull data from Flat & Excel files into HANA database.
• Developed complex mappings as per the requirement using almost all transformations and effectively used Debugger for identifying errors and resolving them in BODS 4.0.
• Involved in data profiling and used validation and address cleansing transformations while updating data into HANA using BODS 4.0.
• Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views (Graphical and SQL Script) to Join/Union the various Attribute and Analytic Views.
• Developed the following in Business Objects: Business Layer (Universe) which contained all the Characteristics and Measures in the underlying HANA Data Model (Calculation View). Webi reports developed from the Business Layer. In addition Dashboards and Crystal Reports were developed for required formatted reporting.
• Business Objects Data Services utilized to create Real-Time Web Service Developed to read HANA calculation views for external users reporting requirements.
• HANA transporting done through the Import/Export via the Developer Mode and Business Objects transporting done via the CMC.
• All below Development done 100% in Hana Studio for all back-end work and in SAP Business Objects Suite (IDT (Universe/Business Layer), Webi, Crystal and Dashboards.

Confidential

SAP BW/BOBJ Architect

Responsibilities:

• Listen to the business stake holders to understand business needs, analyzes complex business requirements, reporting requirements and propose the best solution for them, and convert them into write the functional specification.
• Worked alongside the database administrator and SAP BW consultant to identify the technical names and sources for the KPIs (key performance indicators) defined by the final user.
• Implemented data security access with Universe level security and report level security also system security access with integrating the Active directory according to design specification.
• Designed a Semantic layer based requirements from business a total of 3 Single source Universes and 2 Multi source enable (DB2 AND SQL Server) universe using Information Designer (IDT) for the HCM and FI business.
• Architected and developed 3 financial dashboards (Variance Price Exchange, Daily Sales, Profit & Loss) using Dashboard Designer and connected source data from SAP BW BEx queries using BICS.
• Provided Solutions and Developed 2 HCM Dashboards using Dashboard Designer allowing the leadership teams to analyze headcount, compensation and performance trends and metrics for all levels of the organization and source data feed from Universes using QaaWS export dashboard to mobile server as HTML5.
• Involved and analyzed in creation of 8 Web Intelligence Reportswith different functionality likecascading prompts,drilldown, Scope of Analysis, charts, ranking, alerts and implemented with row level security.
• Worked on BEx Query Designer in designing queries using Variables, Navigational Attributes and Structures to facilitate flexible, detailed drill down data analysis to required level of information.
• Created 2 Crystal Reports on BEx queries that were built on BEx Query Designer and wrote complex queries including Sub queries for Supply Chain business areas.
• Migrated 8 Universe designed Universes (UNV files) into Information Design Universes (UNX files) using upgrade management tool.
• Worked closely with the Database and ETL team to get required table structures.
• Involved in working with different database environments (PROD, DEV, and QA) and migration of the universes and reports using LifeCycle Manager. Established a change control for each development.
• Conducted sections for all BI Business Users and created end-user documentation.

Confidential, Tampa, FL

SAP BI Architect

Responsibilities:

• Interacted withBusiness stake holdersto know their business needs and effectively develop and modify UniversesandReports.
• Defined row level security at universe level as per user entitlements, this enabled IT to create one report and make it available to global users based on their rights.
• IntegratedSAP BWwith Business Objects and extracted data fromSAP Data sources.
• Provide reporting solutions using 2 OLAP Universes using BOE XI 3.1 - Universe Designer on top of SAP BEx queries, (enabled OLE DB for OLAP) and InfoCubes / MultiProviders, created/modified classes, objects, dimensions, measures and details.
• The development of a total of 6 reports using Web Intelligence, according to functional specification and write the technical specification for each development.
• Provide complex reports solutions inWeb Intelligenceusing advanced functionality like report level prompts, scope of analysis and ranking data source from DB2.
• Architect and developed a Campaign Marketing Dashboard that measures leads and contacts for different marketing channels. Implemented end to end solution, starting from the Universe, to the Web Intelligence dataset layer, to the Xcelsius Dashboard.
• Follow the company procedures to migrate from the development environment to QA (quality assurance) all the universes and reports until the production server.
• Provide to the final users about the correct use of the new business Intelligence elements.
• Involved in Realization, Final Preparation, Go-Live and Post Implementation, developed production support plan and resolved production support issues.

Confidential

Sr. SAP BW/BOBJ Developer

Responsibilities:

• Worked with SAP BI and BOBJ Business users, Project managers and architects in requirement gathering, analysis and creation of best practice architecture.
• Enabled Single Sign-On (SSO) feature, imported SAP BI roles into BusinessObjects, enabled automatic imports of SAP BI users, managed users and groups in Central Management Console (CMC).
• Worked with Business Users on design changes and deployed Business Objects Rapid Marts, sourced data from SAP, Non-SAP and flat-file datasources.
• Created 5 Universes using Universe Designer, worked with tables, fields and joins, involved in resolving loops by creating aliases and contexts using SAP BEx queries.
• Created/Edit queries and reports in BOBJ - InfoView for multidimensional analysis and trained users on drill-down, cross-tab, triggers, master detail, slicing and dicing, ad-hoc reports by Web Intelligence (WebI), Voyager workspace, scheduling and publishing (to BO Inbox, email, FTP, ..) in multiple formats (html, pdf, ActiveX doc,..)
• Involved in data extraction from SAP R/3 system, Cognos and Non-SAP systems and scheduled Full Loads / Delta Loads using Process Chains.
• Created Dashboards and Scorecards integrating reports using Business Objects dashboard manager.
• Worked with SAP BASIS team in regards to moving Transport Requests and worked with SAP SECURITY team in providing authorizations for Users by assigning specific Roles.
• Worked with SAP Basis and BI teams and involved in upgrading the SAP BI support package to SP21, installed BusinessObjects Enterprise XI 3.1 Integration for SAP Solutions FixPack 1.x.
• Involved in developing and conducting extensive Unit testing, Integration testing (FIT), Regression testing, User Acceptance Testing (UAT) and documentation.
• Worked with Network Administrators and setup .Net framework on VMware with Windows 2003/2008 Server, creation of SQL server 2008 databases, ODBC connections and Java Run-time Environment for BusinessObjects installation.

Confidential, Marysville, OH

Sr.BW Developer

Responsibilities:

• Responsible for requirement gathering by working with business and technical users, analysts, Project managers, and involved in analysis and creation of architecture that can be considered 'best practice' and scalable.
• Worked closely with Production Planning (PP), material management (MM), Sales and Distribution (SD), Logistics (LE), Financials (FI) - AP, AR, GL teams involving SAP and Non-SAP team members in creating Order-To-Cash, Procure-To-Pay, Point of Sale (POS) data via DataStage and other integrated solutions.
• Designed Data Marts as per the System landscape, created Functional and technical BW specifications, considered proper data modeling techniques and data management strategies and created Technical BW Specifications for BW Objects.
• Captured the BW data elements required by the end users and extensively involved in analysis, design, development, configuration, testing, deployment of BW Objects (Info Objects, ODS, DSO, InfoCubes, InfoSets, MultiProviders, InfoSources, DataSources and corresponding extract, transformation, communication structures).
• Implemented the BI 7.0 concepts of Transformations and DTPs using the existing datasource migration and involved in up gradation and migration from BW 3.5 to BW 7.0
• Worked with SAP ABAP team and created code that will result in the highest performance possible.
• Involved in loads initialization in SAP BW system followed by extraction (LIS/LO Cockpit extraction, FI, CO-PA extraction) from SAP R/3 system and Non-SAP systems and scheduling regular Full Loads / Delta Loads using Process Chains.
• Provided Knowledge transfer (KT) and to BW team members and Super Users and guidance to team members on Excel-to-SAP project related to Manufacturing during all phases of project.
• Created Service Level Objectives (SLOs), Solution Documents with the BW team that will guide the production support team when issues occur.