SUMMARY:

• Over 18 years of experience in IT Industry implementing SAP Analytics Solutions for diverse industry areas include Retail, Manufacturing, Utility, Consumer, Chemical, Telecommunication, Confidential & Auto industries for various application areas viz. SAP Logistics, FI - CO, HR and IS-Retail
• Strong expertise as Solution Architect defining Strategy and Roadmap, design and deliver solution deployment architecture, extraction process designs, Infrastructure sizing, performance tuning, archiving, scalability options, integration, technical roadmap, benchmark for EIM & reporting tools
• Architected technical designs which support a robust solution taking into account the user requirements, technical requirements & integration etc.
• Sourcing data from and into the data warehouse from disparate source applications using different ETL technologies and related master data management
• Provided strategic direction for SAP BW/HANA landscape build/upgrade as well as reporting tool set for presentation and mobility
• In-depth experience in SAP BW 7.x on Traditional DB, BW 7.4 on HANA, HANA Live, SDA,SLT, ABAP,BO 4.x, BODS 4.1, Security, HANA DB, SAP EP 7.3, POSDM, NLS, Tableau & BI Mobility
• Experience with HANA & Hadoop integration
• Strong Project management understanding and help PMs to manage scope and deliverables
• Full lifecycle Functional Experience ranges from functional/business requirements gathering and analysis, efforts estimation, Blue-Printing/Designing, conceptual/logical & physical design and modelling, cross-team coordination/team management, development, testing, implementation cut-over and support activities
• 7 Full Life cycle implementation, BW on traditional Database
• 2 Full Life cycle implementation, BW on HANA
• 2 HANA Live Project Implementation
• 4 BW Upgrade on Traditional DB & 2 BW on HANA Upgrade
• 3 BO Upgrade (Technical & Functional)
• 4 Full Life cycle implementation, Business Objects
• 2 BODS & BW integration project
• 1 Big Data & HANA Integration
• 1 POSDM (Point of Sale)

TECHNICAL SKILLS:

Data warehouse: SAP BW 7.x, BW 7.4 on HANA, HANA Live

ERP: SAP R/3, ECC 6.x, IS-Retail

Database: HANA 1.0, Oracle, SybaseIQ, DB2, SQL Server

Reporting: BOBJ, Tableau, Lumira, Qlikview & BI Mobility

Portal: SAP EP, SharePoint

Planning Tool: SAP BPS & BPC

ETL: BODS 3.x/4.x, SLT & DataStage

Big Data: HDFS, Hbase, Hive, Impala, Sqoop, Yarn, Sentry & Flume

Language: ABAP, Java, SQL, Xcode

PROFESSIONAL EXPERIENCE:

Confidential, New York

SAP BW/HANA/BO Solution Architect

Environment: SAP BW 7.4, ECC 6.0, HANA 1.0 SP10, POSDM 1.6, BO 4.1, BODS 4.1, Cloudera, Tableau

• Designed and Architected solution for BW on HANA upgrade from 7.0 to 7.4, BO 3.1 to BI 4.1 & POSDM
• Responsible for detailed planning, design and execution of overall technical & functional migration effort for BW on HANA, BO reports & POSDM ( Point of Sale)
• Assessment of current BW environment and provided over all environment and functional area specific data flow optimization guidelines
• Involved in system landscape setup for BW/BO upgrade & Data center migration
• Experience with Post Copy Automation process and DMO option
• Working with other technical teams viz. Basis, Infrastructure, DBA, BO Admin, POS, Portal, Security, and other technical wings
• Analyzed and implemented 400 + notes on ECC and BW for delta cloning
• Design and development of native HANA data models
• Design and developed HANA optimized model for Inventory
• SSO configuration between different SAP and non-SAP systems using Hitachi, SAP Authentication and Windows AD
• Analyzed and developed a solution for workbook migration from 3.x Bex to AO & CR 2008 to CR 2013 and CR ENT
• Architected the solution for report publication for AO Workbook, CR 2013 & ENT reports using Java & VB Script
• HANA and cloudera integration to enable enhancing analytics, data tiering/offload and analytics offload
• Experience with cut-over planning and co-ordination

Confidential, Atlanta

Senior BW/HANA Consultant

Environment: SAP BW 7.3, BO 4.0, SAP EP 7.3, SAP ECC 6.0, Windows 2008, SQL Server, HANA, Oracle

• Developed methodologies, templates, tools and services to offer value added solutions to customers.
• Written ABAP routines, and the functional aspects of the Logistics and Finance modules; overall BW functional design, configuration and technical development.
• Demonstrated ability in defining complex multi-dimensional data models, including InfoCubes, DSOs, MultiProviders, Master Data with hierarchies, navigation and time-dependent attributes, InfoObjects, InfoSources, transformations, process chains and batch scheduling.
• Developed SAP BW ETL mechanisms: DTPs, Update/Transfer rules, Startup Routines, user exits, etc. to support data extraction, transformation, and loading

Confidential, Schaumberg

BW/BO Architect

Environment: SAP BW 7.3, BO 4.0, SAP EP 7.3, SAP ECC 6.0, HANA Windows 2008, SQL Server

• Responsible for analysis and execution of solution meeting business requirements across Sales & Purchasing
• Worked extensively in backend and front-end development of SAP BW 7.3
• Build complex queries using BEx 7.3 designer
• Developed WebI document and crystal report on top of BEx queries
• Responsible for content design and development in SAP EP 7.3 for BEx/BO reports
• Worked with security team to define the security model in BW
• Created testing strategy involving end users for UAT and user experience and feedback
• Managed BW and Portal transport across the landscape
• Involved in configuration of SAP BW-BO-Portal integration
• Managed production cut-over activities

Confidential,Southfield, MI

SAP Technical Architect

Environment: ECC 6.0, MFCGPRO, NW BW 7.0, SAP EP 7.0, Linux, Oracle

• Responsible for memory and storage calculation for BWA
• Defined, planned, well managed, disciplined and accepted process for application development and maintenance of SAP BW
• Established fail safe procedure for Data extraction from source system
• Performed a lead role for BW upgrade and refresh
• Performed software review and evaluation for BW NLS Archiving and submitted a report to client
• Working with security team to define the BW/Portal security model
• Working with Basis, Database and infrastructure team on Disaster Recovery for BW/Portal

Confidential,Gallup,NM

BW/BO Solution Architect

Environment: ECC 6.0, GIS, SCADA, NW BW 7.0 EhP1, BOXI 3.1, Crystal Reports, DS 3.2, SAP EP 7.0

• Responsible for BW/Portal architecture hardware/software, planning, sizing, configuration and system validation
• Responsible for BOXI architecture hardware/software, planning, sizing, installation, configuration and implementation of BO Data Services 3.2
• Developed project strategy with ASAP methodology throughout SDLC: blueprint, development, testing, cutover & go-live.
• Involved in the SAP BW/BO full project life-cycle from gather requirements, design, development and implement report solution for multiple business streams: SD, Purchasing, Project System, Plant Maintenance & GIS

Confidential, Racine, WI

Sr. SAP BW / BO Consultant

• Worked closely with the business users of SCJ’s EU (European Union) division in gathering BI reporting requirements for REACH.
• Responsible for the development of various Test cases/scenarios and reconciliations of BW reports, ECC and PLM data at various stages of testing such as Unit Test, Functional unit Test and Detailed Integration testing.
• Built the Master and transaction data process chains and integrated with TIVOLI.
• Worked closely with the BASIS team in configuring the optimum system parameters for better load and reporting performance.

Confidential,Eden Prairie,MN

SAP BW Lead / BO Consultant

• Involved in the current state assessment of an existing custom data warehouse system and performed qualitative comparison of alternatives data warehouse tools like SAP BI,Oracle
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Technical lead for design, development and support for clients, and driving the development and oversight activities.
• Delivered SAP BI development standards like implementation methodology, naming standards, transport strategy, sizing estimation and performance tuning.
• Involved in the implementation of SAP BW 7.0 for SD, PS, GL and CRM module which includes requirement gathering, data modeling, data extraction, Performance Tuning and BEx reporting.
• Worked extensively in backend and front-end development of SAP BW 7.0.
• Installing SAP BI Integration kit and configuring single sign-on between BOE XI 3.1 and SAP BW systems.

Confidential,Naperville,IL

Sr. SAP BW Consultant

• Established a detail project plan for each BI system within the landscape describing the activities needed to be carried out before, during and after the technical upgrade
• Prepared and involved in Pre and Post Upgrade activities in BI System
• Identified and resolved a major issues with regards to New BI 7.0 functionality
• Key member in completing to fully tests and validates the capabilities of the BI 7.0
• Involved in migration of ETL and front end components to BI 7.0
• Interact with the users, gather requirements, develop design, and write functional and technical specifications based on the requirement
• Worked extensively on BI-Portal integration

Confidential,Albuquerque,NM

SAP BW Consultant

• Worked with key SCM business analysts to define information required and convert them into functional specifications, and determine the required solution in a SAP BI in order to achieve supplier on-time delivery performance based on Purchasing and Inventory data.
• Support the entire implementation effort during all project stages, ensuring that in areas of assigned responsibility milestones and related sign-offs are achieved on a timely basis and in accord with current project plan.
• Extracted data from Purchasing, Inventory, Time Management and Payroll into SAP BW04s BI.