SUMMARY:

• Around 15 years of rich experience in SAP Net weaver BI/BW as Senior Techno - Functional Consultant and Solutions Architect this includes around 2+ years on SAP HANA.
• Worked in 7 SAP BW/BI full life-cycle implementation including gathering business requirements, analyzing the business process, identifying and analyzing the Design, Modeling, Configuration, BW sizing using Quicksizer, Development, Unit/Integration testing, Data migration, Go-live and Post-go-live support using ASAP implementation methodology.
• Extensive expertise in Extraction of data using LO Cockpit, COPA, Generic Extractions, Flat files, Archived data and from CRM.
• Very good experience in functional areas SD, MM, FI, CO-PA,HR, PP, PS, IS-Automotive, IS-Retail and IS-Media.
• Customizations - Data source enhancements, generic extractors, function modules, BAPIs, User Exits and Logistics Cockpit configuration and customization, Data extraction from flat files, DB Connect, Data sources for Master and Transactional data.
• BW Operations - activation of Standard Business Content, Data load management, Job scheduling with events, OLTP extraction data, Loading (Full /Delta Load), Monitoring, Remote Cubes, Data Mart and Open Hub Services, Process chains, Analysis Process Designer (APD) and applying OSS Notes and ECC/BW Transports.
• BW Security & Authorizations - Implemented Security access authorizations at Data mart (Info cubes, Info Objects and hierarchy) and query levels.
• BW Reporting - Expertise with Advanced Analysis tool including ad hoc reporting, pre calculated templates, authorization & creating Dashboards/cockpits, Calculated & Restricted Key Figures Exceptions, Replacement Path Variables and RRI jumps, Report Designer, Queries on Multi Providers, Publishing reports and iViews in Portal and documentation.
• Performance Tuning - IBM BLU, BW Statistics, BI Accelerator, Multi Providers, Aggregates creation, Info Cube partition & compression, Number range buffering, Query tuning and OLAP Cache Monitoring.
• SAP HANA - Very good experience in designing/developing and maintenance of persistent models (Schemas, Tables, Views), Information Models (Attribute Views, Analytic views, Calculation Views, SQL Script based Calculation views, Hierarchies, Decision Tables), Data Provisioning (Flat File, SAP Landscape Transformation for SAP & Non-SAP, Data Services, Direct Extractor Connections), Text Search (Full text search, Freestyle search, Fuzzy Search). SQL (Procedures, CE Functions, SQL Scripts), Migration of BW Database to SAP HANA (Hardware Sizing, Clean up BW Data, prepare/export/import BW Data, Conversion/Optimization of InfoCube’s and DSO’s, ABAP Code Optimization), BW- HANA EDW (Publishing HANA Data Models, Creation of virtual providers based on HANA Models).
• SAP BusinessObjects (BOBJ) - Expert in BI Platform 4.0/Business Objects Enterprise, Web Intelligence, Xcelsius, Crystal Reports Explorer and Dashboard.
• ABAP - ABAP/4 programming, User Exits, SAP Scripts and Custom objects creation.
• Upgrade - Involved in SAP 7.x, SAP 7.3 to SAP-BI 7.4 Upgrade & Testing, SAP BW Upgrade from BW 2.1C to BW3.1C and 2.1C to 3.0B and also for DB2 database upgrade testing.
• Hosted workshops for requirements gathering, GAP analysis, design discussions and end-user trainings.
• Worked in software tool Service Now, MAGIC and SOLMAN for tracking the defects and other issues, TRACKWISE (Quality Mgmt. Tool) and Confidential Tool to create training documents for end users and on SAP Production Change Management Tool (SAP PCM).
• Lead BI Best Practices effort establishing general conventions, naming standards and guidelines,
• EDW architecture and Reporting layer guidelines.
• Knowledge on Advanced Planner and Optimizer (APO).
• Met with Solutions Leadership team at client on a weekly basis communicating status, suggestions and negotiating project charter.
• Working Knowledge on SAP HANA and BusinessObjects and Data Services (BODS).
• Project Management - Very experienced in managing projects and worked as liaison between the business stake holders & IT in executing the project on time. Experienced in handling multiple projects and leading large teams in Multi-Cultural and distributed environments. Involved in various project management activities like requirement gathering, project planning, project scoping, resource allocations, project risk/impact analysis and mitigation plans, and scope/change control management, project monitoring, and SOX Compliance.
• Excellent communication, interpersonal, analytical skills and performance record backed by solid client references.

TECHNICAL SKILLS:

SAP BW Release: SAP-BI 7.4, 7.3, 7.1, 7.0, 3.5, 3.1C, 3.0B, 2.1C and 2.0B

SAP ECC Release: ECC 6.0, 5.0, SAP R/3 4.6C, 4.5B, 4.0B and 3.1H

SAP HANA Appliance: 1.0 - SPS05, SPS08 & beyond

Functional Area: SD,MM, FI, CO-PA, PP, HR, PS, IS-Automotive, IS-Retail, IS-Media and CRM

Languages: ABAP/4.

Operating system: Linux, Unix, Aix, Sun Solaris, Windows 9x/NT4.0, OS/390, MVS/ESA

Scripting Languages: HTML, Java Script and Web sphere Portal

Database: MS-SQL, SQL Server, DB2 and Oracle.

BW Reporting: BOBJ4.1, BEx Analyzer & Designer, Web Application Designer and Crystal Reports

Design Tools: MS Visio, Microsoft Project and SAP Solution Manager

QA & Testing Tools: Service now, Panaya Application Lifecycle Mgmt. (ALM), Magic

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Sr. SAP BW Consultant

Environment: SAP BI 7.4, 7.1, ECC6.0 and Oracle 12.1

Responsibilities:

• Involved in BW upgrade and testing from 7.1 to 7.4.
• Involved in new BW performance tool testing, Oracle EXADATA.
• Closely interacted with business team and involved in SIT and UAT testing and and end to end business validation on various reports including Sales and Operational Planning (S&OP), Demand Planning and Product Profitability reports.
• Involved in knowledge transfer to offshore team, mentoring and monitoring the development and support activities and assist the team.

Confidential, Orlando, FL / Burbank, CA

Sr.SAP BW Solutions Architect & Team Lead

Environment: SAP BI 7.4, 7.3, ECC6.0 and DB2, Rapidmart, Oracle and BODS 4.2

Responsibilities:

• Worked as the lead technical BI resource in the requirement gathering process for complex projects to ensure that definitions of the new requirements are clearly defined and understood and are in accordance and compliance with best practices from a BI architectural perspective.
• Provided technical direction in the analysis, design, development, documenting, testing, deployment, maintenance, and enhancement of complex technical solutions related to enterprise applications projects.
• Defined formal departmental methodologies and procedures for BI based on best practices in the industry to perform requirements gathering, architecting for optimum performance, prototyping and development, and deployment with a minimum of design changes.
• Organize, create and maintain critical technical and functional documentation for related business processes, including technical specifications, test plans and training materials.
• Coordinated with security requirements and user administration, rights and user groups supporting various organization views.
• Worked on SAP Rapid Marts which are rapid deployment solutions for data marts based on SAP ECC subject areas. They provide extraction jobs from ECC, data models for the extracted data, relevant semantic layers and delivered reports.
• The 3 major focus areas are Procure to Pay (PTP), General Ledger and Process to Initiate Closing Areas (PIC) where the data is extracted from the ECC (R/3) via the shuttle folder where the extracted data is cleansed and loaded into the Oracle Datamart using BusinessObjects DataServices (BODS).
• Involved in leading an offshore team on knowledge transfer, mentoring and monitoring the development and support activities and assist the team.
• Involved in new BW performance tool testing, IBM BLU.
• Involved in BW upgrade from 7.3 to 7.4 and Migration of data source from 3.x to 7.x.
• Resolved problems by performing root cause analysis of frequent user disconnect in application, planned diagnosis approach and specified implementation.
• Investigated incident tickets, clarified acknowledgement and confirmed resolution by communicating with business leaders, service recipients and offshore teams.
• Influenced service awareness and motivation across IT community by leading SLA document annual review meetings with stakeholders.
• Conduct technical overviews and software capability demonstrations/training to key process owners.
• Involved in architecting the design and implementation of FI (AP/AR/GL), SD, MM, HR and PS per business requirement.

Confidential

Sr.SAP BW Solutions Architect / Team Lead

Environment: SAP HANA1.0, SAP BI 7.3, ECC6.0 and MS-SQL, BOE XI4.0, BODS 4.0

Responsibilities:

• Involved in new OTC& FI implementation.
• Actively Involved in BI Data Modeling discussions, Development, Realization and Go-live.
• Implemented standard Business content of various extractors, info objects and DSO's/Cubes.
• Worked with BASIS and SAP team on implementing OSS notes per their recommendation and solving the system issues.
• Responsible for collection and documentation of the end user requirements and created technical specifications.
• Involved in architecting the design and implementation of SD, FI, MM, QM, HR and CRM per business requirement.
• Involved in data extraction from various ERP source systems and from Archiving.
• Assist leading test planning and test execution effort, collecting BW Transports and assisted with detailed documentation in SOLMAN.
• Involved in System Integration Testing and User Acceptance Testing and end to end business validation.
• Involved in leading an offshore team on Knowledge transfer, mentoring and monitoring the development activities and assist the team.
• Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA 1.0.
• Participated in implementation of SAP HANA and BusinessObjects and worked with BASIS team on configuration
• Worked 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.
• Migrated HANA content from development, QA environment and to Production environment using delivery units.
• Working knowledge and proficiency with Business Objects Reporting tools BI launch Pad, Web Intelligence, Dashboard designer, Dashboard Design, BO Explorer, Crystal reports.
• Working knowledge on creating universes using IDT on SAP HANA views and reports development on the same using Web Intelligence.
• Excellent understanding work Experience of building Complex Universe of Normalized De-Normalized schemas using Information Design Tool IDT.
• Created Schemas (Universe), imported tables and loaded data and also copied standard content from SAP to local repository using SAP HANA
• Used HANA Studio to create Attribute Views, Analytical views and calculated views
• Closely interacted with business team and involved in SIT and UAT testing,
• Extensively worked in Web intelligence, Crystal Reports, and Xcelsius.

Confidential, Nashville, TN

Sr.SAP BW Solutions Architect/Administrator

Environment: SAP BI 7.3, ECC6.0 and DB2/MS-SQL, SAP HANA1.0, BOE XI4.0, BODS 4.0

Responsibilities:

• Involved in new OTC implementation for North America.
• Actively Involved in BI Data Modeling discussions, Development, Realization and Go-live/Post-go live support.
• Involved in SAP BW sizing using Quicksizer and Business Objects sizing.
• Involved in infrastructure strategy planning, BW landscape design.
• Worked in heterogeneous system migration (different OS & database, Aix/DB2 - Windows/MSSQL).
• Involved in architecting the design and implementation of SD, FI, MM, LES, Freight Accounting and IS-Automotive per business requirement.
• Responsible of creating BI naming standards and guidelines document.
• Implemented standard Business content of various DSO's and cubes.
• Installed technical content for BI statistics to capture various performance measures and monitoring.
• Worked with BASIS and SAP team on implementing OSS notes per their recommendation and solving the system issues.
• Involved in the design and implementation of data distribution using Open hub and APD to send data to 3rd party systems. (Entire net, SQL etc.)
• Worked in DB Connect to fetch data from legacy SQL system to BW to bring inactive materials and other related information for business analysis.
• Involved in System Integration Testing and User Acceptance Testing and end to end business validation.
• Involved in deployment of production go-live cutover activities and support.
• Worked with SAP on performance tuning after go-live.
• Worked on remodeling of custom info provider for better performance.
• Worked on Webi using BOBJ 4.1and Advanced Analysis tool and created new reports per business requirements.
• Hands on experience in Data modeling, Development of custom extractor, design on custom DSO, Info cube, Data Extraction, Reporting, BW Statistics and Process Chains.
• Highly involved in implementation of SAP HANA and BusinessObjects and worked with BASIS team on configuration of the system.
• Worked with SAP on problem solving of system issues during implementation of HANA.
• Created Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need. Performed clean-up activities for the pre migration of BW on HANA implementation. Optimized BW cubes for HANA.
• Configured and connected Data Source, data Services, BOE, End Users and HANA Studio.
• Design & Development of Universe with calculated measures and custom filters.
• Closely interacted with business skate holders and participated in SIT and UAT testing.
• Involved in End-user training, Knowledge transfer to offshore team and documentation.

Confidential, Bolingbrook, IL

Sr. SAP-BI Consultant

Environment: SAP BI 7.1, EHP-1, ECC6.0 and MS-SQL

Responsibilities:

• Participated in Blue print session with Senior Management and responsibilities include analysis of data requirements and translation of these requirements into dimensional data models, created functional and technical specifications and actual implementation in BW.
• Installed 0SD C03 cube and Sales order Header and item data sources from Business Content and extended the data source to bring Contract data.
• Extended 0VENDOR Master data Info Object to include Parent and Grand - Parent identification for vendor.
• Worked in Sales History migration from Report Manager Legacy system.
• Hands-on experience in development of extractor, DSO and Info Cubes, MultiProviders and BW Reports according to business requirements
• . Assist leading test planning and test execution effort and collecting BW Transports.
• Developed new reports in SD, MM& FI-AP/AR and modified existing reports per business needs.
• Performed Knowledge Transfer and created training document for end users.
• Worked on SD, MM, FI and IS-Retail modules.

Confidential, Atlanta, GA

Sr. SAP-BI Consultant

Environment: ECC6.0 and SAP BI 7.0 and DB2 9.1.5

Responsibilities:

• Worked for Confidential Canada Retail project and highly involved in new development, enhancement and overall support activities.
• Involved in enhancement of FI - AR, Vendor and Customer Masterdata datasources to include new standard and custom fields and coded user-exit to populate the custom fields.
• Developed new custom DSO for Inventory Stock Initialization (2LIS 03 BX) and Article Movements and involved in re-initialization of data load for Inventory cube. Involved in re-initialization effort for Inventory cube (YINVC01D) from ECC system.
• Worked on Analysis Process Designer (APD) for Price Optimization report for Sales History and generation of output files on the directory server.
• Worked on CRM 5.0 systems, designed new reports and modified existing CRM reports to meet business needs.
• Worked on ABAP program to fix high priority production data load error for BI on Primary Vendor determination and Merchant decision data load in ECC system.
• Worked on Basis & DBA team to improve the data load performance for PO Match custom extractor program in ECC system.
• Implemented 6 BI Statistics cubes 0TCT C01, 0TCT C02, 0TCT C03, 0TCT C21, 0TCT C22 and 0TCT C23 cubes and configured the necessary settings using RSDDSTAT transaction.
• Configured and rich experience in Information Broadcaster to send reports via email and publish them in Portal.
• Configured SOLMAN in BI system for BI process chain jobs monitoring and overall backend system performance.
• Created several SAP OSS messages with SAP and coordinated the effort to fix high priority issues and responsible for implementation of OSS notes to fix the error.
• Utilized Confidential Quality center tools (Test Director) for defects tracking.
• Worked in POSDM (Point of Sale) Sales Analysis reports and COM (Customer Order Mgmt.) reports, SD, MM and FI.
• Worked on developing new process chains and redesigned inter related dependency process chain for Gift card, FI-GL, Tandem files and POSDM chains.
• Highly experienced in Data modeling, Data Extraction, Performance tuning, BI Accelerator (BIA) and Process Chains.

Confidential, Atlanta, GA

Sr. SAP-BI Consultant

Environment: SAP BI 7.0, ECC 6.0, SAP BW 3.1 and Oracle 10.2

Responsibilities:

• Working Knowledge in IS-Media module.
• Hands on experience in SAP-BI Upgrade from BW3.5 to BI 7.0, Testing and Validation after post upgrade.
• Actively Involved in BI Data Modeling discussions, Development, Realization, Final Prep and Go-Live and Support.
• Developed around 15 custom DSO's and 5 Info cubes and 3 Multi providers to achieve the business purposes and developed various BI Reports to satisfy user requirements.
• Worked in Data Migration from Legacy system into BI system.
• Created OSS messages for SAP to help with the issues during upgrade and Development stages.
• Created DSO's, Multidimensional Cubes and Hierarchies.
• Involved in discussion with business analysts and end user for Integration Testing of reports and trained them.
• Involved in BI-Security Authorization, Testing and Validation of User Roles and Reports.
• Created Process Chain for Data loads and Involved in Performance Tuning using Indexes, Compression, Partition and Aggregates.
• Undergone SOLMAN (Solution Manager) Tool training to create log issues/creating tickets and track them.

Confidential, Atlanta, GA

Sr. SAP-BW/BI Consultant

Environment: SAP BI 7.0, SAP R/3 4.6C, SAP BW 3.1and Oracle 10.1

Responsibilities:

• Underwent mandatory onsite training in SAP BI 7.0 (Net weaver 2004s) conducted by SAP America at Confidential .
• Hands-on experience with BI upgrade testing and validation.
• Day-to-day responsibilities include analysis of data requirements and translation of these requirements into dimensional data models, with an emphasis on actual implementation in BW.
• Responsible for planning and implementing the batch load schedule for the data warehouse.
• Responsible for performance tuning, ODS and Info Cube design and implementation, aggregate design and implementation, etc.
• Worked in FI-AR and FI AP cube creation and new reports
• Participated in discussion with business analysts and end user for Data Modeling, Business Content and Performance Tuning.
• Sales History migration from Legacy system(mainframe)
• Installed 2 new data sources for 0SD C03 cube for pricing condition from Business Content
• Created new Custom Pricing Conditions (YCFP PRCE) cube and new Multi provider to satisfy business requirements.
• Worked on 0PP C01 cube and developed new reports
• Worked on R/3 - APO - BW interface for Customer-Material Info record (YCMINFO), Cust Sales and Mat Sales and DB Connect.
• Worked on Mercury Test Director Ver. 8.0 to logon defects during Integration Testing
• Performed Conversion of ABAP R/3 report into BW and did performance tuning.
• Extracted Valuations from the R/3 Classification System into BW.
• Hands-on experience in SAP Net weaver BI Accelerator for faster execution of Reports.

Confidential, Roswell, GA

Lead SAP-BW Developer

Environment: SAP R/3 4.6C, SAP BW 3.1C, SAP BW 2.1C and DB2

Responsibilities:

• Involved in Caribbean implementation of BW and go-live process.
• Worked on SOX Audit requirement for BW and corrected the issues found in audit.
• Actively Involved in Data modeling, Performance tuning, fine tuning of queries, Aggregates, BW Statistics, Process chains, Info Cube Partitioning, BW Scheduling and BW Production Support.
• Customized and Created new COPA Data Source in R/3, Info Source, Transfer Rule, Info Cube and Update rule in BW using standard transactions.
• Traveled to Brazil for new COPA release using Enterprise Data Warehouse (EDW) concept and knowledge transfer process
• Modified the V3 update methods in R/3 from Serialized v3 update to Queued Delta which is a prerequisite for Plug-in 2004.1 in SAP R/3.
• Involved in DB2 upgrade testing from Ver. 7.0 to Ver. 8.0 a prerequisite for BW 3.5 upgrade
• Team lead for pre and post work for Support pack 16 and Support Pack 19 for BW3.1C.
• Worked on CO-PC & CO-CCA cubes and created new reports per business requirements.
• Worked on Reinitialisation and coordinated with Business Liaisons, SAP R/3 team and
• BASIS for the following cubes in BW and R/3 for Controlling and Profitability Analysis (CO-PA), Purchasing data (0PUR C01), Inventory Analysis (0IC C01), Repetitive ManufacturingMaterials Consumption (0PP C08), Sales& Distribution (0SD C03).
• Highly involved in BW 3.1C upgrade (with Support Pack3 and 8) testing and solving the post upgrade issues. Communicated with SAP during and after the upgrade regarding the issues encountered during the upgrade.
• Participated in discussion with business analysts and end user for Data Modeling, Business Content and Performance Tuning.
• Worked in Custom Info cubes in Profit Center Accounting in FI module using Strategic Enterprise Management (SEM).
• Involved in requirement gathering from end user, Analyzed user functional requirements for queries and developed the queries using BW query designer and created the reports using BEx Web Reporting Tool and Crystal Reports.
• Used Variables, Filters, Free characteristics, restricted key figures, calculated key figures in developing queries.
• Involved in publishing the reports using Crystal Enterprise and in Web Portal using IBM Web sphere Portal.
• Developed Ad-hoc queries to work upon Info Cube. Tutored in-house employees of firm, knowledge transfer with profound documentation and in-depth BW Retooling.