SUMMARY:

• 18 years of experience in IT Industry, 13+ years of experience in working with SAP BW 2.0 to 7.4, SAP HANA, SAP ECC, CRM, HCM, SCM, IP, BPC, BOBJ, Lumira, Tableau, BODS, Vistex, BI - ISU, PLSQL, EDW, ETL Tools, Oracle and Teradata and specialize in SAP BW(13 +Years), SAP HANA( 3 +Year) and SAP BO(4+).
• Strategic thinker with ability to understand business strategy and provide consultative business analysis and leverage technical skills to create insightful, effective BI solution.
• Involved in integrating business needs and technology solutions, that include defining systems strategy, Team Lead, BI road map strategy, BI Project management(Water fall / Agile), architect, requirement gathering, Gap analyzing, BI configuration and technical documentation, activated and enhanced Business Content, designed and developed analytical Reports, SAP Data Conversion, prototype, development, transport/change management, testing, training, QA, performance tuning(Back end and front end), administration, define support procedures and implementation .
• Worked as BI team lead and project lead and responsibilities include managing BI team, managing product deliverables, conducting meetings, finding out solution for complex issues, reviewing the project scope, communicating management and team members about project accomplishments and deadlines and reviewing status reports.
• Integrated SAP HANA, SAP BW, Informatica and Teradata.
• Experience in development of Project Documentation, training materials, requirement gathering and implemented SAP best practices, implemented project ASAP methodology.
• Extensively worked on SAP HANA data modeling, Information views(Attribute views, analytical views, Calculation views), analytical privileges, data provisioning, data validation, HANA content transport management & SAP HANA application lifecycle management etc.
• Excellent experience in design and development of Info cubes, Multiprovider, DSO/ODS, Infoset, data source, Info Objects, transformation, open hub, Process chain, extractors, ABAP exits, ABAP routines, system configuration, information broadcasting, administration and support.
• Experience in BW on HANA migration this include Project planning & scoping, Migration Strategy (Standard/Partial/Sidecar/Copy ), Sizing, Technical/Functional Pre migration task, Validation check/testing, issue documentation & resolution, functional migration task - Optimization task- LSA to LSA++ approach, Optimizing of code, Optimizing of cube etc.
• Extensively worked on various BW/BOBJ analytical reporting, Published report in EP, Formatted reporting, Dashboard, Sending report to Mobile Apps, BEx Query designer, Universe, CMC, Webi, Crystal etc.
• Involved in extracting data from R/3 using BW content extractors, Custom Generated extractors and Generic Extractors.
• Involved extracting data from Legacy systems(SQL Server, Oracle, Teradata, Flat file) using DB connect, UD connect
• Involved in investigating issues related to BW BASIS, OSS note support & Database.
• Extensive experience in supporting SAP BW application and involved in performance tuning, write and modifies existing ABAP codes for better performance.
• Extensively worked in various modules in R/3/ECC - SD,MM, SCM, FI(AR, AP, GL), CO, COPA, HCM, ISU CRM, PS,SEM-BPS/IP, P2P, OTC and APO-DP.
• Implemented BW Through 4 Full Life Cycle Projects and enhancement project.
• Undergone complete life cycle Implementation of BW / BW on HANA-BOBJ-BODS/ BW-BOBJ-BODS/ which includes right from analysis, design specification, development, performance tuning, testing, documentation, maintenance, trouble-shooting etc .
• Involved in development of ABAP/4 programming including SAP enhancements, start routine, data extracts, writing function module, user exit and custom exit.
• Involved in complete phase of testing (Unit testing, User acceptance testing, Data validation testing) and validated data between BW and R/3.
• Manage BW onsite and offshore team during implementation and support phase.
• Excellent leadership qualities and inter-personal Communications Skills.

PROFESSIONAL EXPERIENCE:

Sr. SAP BI(BW-HANA-BO) LEAD Consultant

Confidential

Environment: SAP BW 7.4, SAP HANA, SAP SLT, BODS, SAP ECC (SD, MM, FI-AP-AR-GL-CO, P2P, BPC, IP), Vistex, ABAP, SQL Script, BOPF, SAP SUM-DMO, BEx, Lumira, BO4.1 (Webi, Explorer, Crystal, Dashboard, Analysis, Explorer, Design Studio) and BO Mobile App.

Responsibilities:

• Involved in multiple SAP BW/HANA/BO Projects related to Requirement gathering, Blueprint, POC, SAP HANA Roadmap, Project Management, Solution Architect, Development, Implementation, Migration, Enhancement, development, Authorization, Testing, Troubleshooting, Upgrade and Support.
• Involved and experience in HANA data modeling Architecting, design, development and maintenance of HANA data models (Attribute view, Analytical View and Calculation views), SQL Script, HANA Analytical privilege, data provisioning thru SLT & BODS, Import, export, migration, data validation & testing of the Objects, SAP HANA content transport management & SAP HANA application lifecycle management etc.
• Involved in architect, development and enhancement of BW Infocubes, Multiprovider, DSO, Infoset, Composite Provider, Transient Provider, data source, Info Objects, transformation, ABAP customization, Open Hub, APD, BW Workbench, extractor configuration, transformation routines, Generic extractors, ABAP Customization, information broadcasting and Process chain.
• Experience in BW on HANA migration this include Project planning & scoping, Migration Strategy (Standard/Partial/Sidecar/Copy ), Sizing, Migration cockpit, Technical/Functional Pre migration task, Validation check/testing, issue documentation & resolution, functional migration task - Optimization task- LSA to LSA++ approach, Optimization of code, Optimizing of Infocube, BW-HANA mixed scenario recommendation and development etc.
• Involved in requirement gathering, development of functional/technical documents based on ECC and other data sources, gap analyzing, development, unit testing, transport/manage of BW objects, integration/QA testing, data extraction and loading, issue investigation and resolution, retesting, data loading, cutover task, Go Live and Support.
• Experienced as SAP BW-HANA-BOBJ Lead/Architect for development of both traditional BW and BW on HANA.
• Analyzed the existing BW data flow /LSA architecture and recommended short term and long term plan for moving to LSA++ architecture to BW on HANA system.
• Review business requirements and translate into a SAP BW HANA architectural design. Provide options and recommendations.
• Extensive experience BW BEx query development using variable, calculated key figure, formula, exit, filters etc, maintenance and performance tuning.
• Extensively work BW/BOBJ front end reporting in BOBJ/BEx/Lumira, this include new developments, modification, trouble shooting and performance tuning.
• Involved in SAP BI/BW Back-end development and configuration, testing and pre-production support.
• Involved in design, developing & support of custom BW objects using BW LSA (Layered Scalable Architecture).
• Involved in SAP BW on HANA system architecture design and performance optimization
• Involved in development and tuning related to front end reports BEX / BO(Webi, Universe, Crystal, Explorer, Lumira) Reports.
• Developed Lumira dataset, acquired data, prepare data, cleanse data, created Story and visualization by using Lumira.
• Extensively work in the area of SD/Logistics, MM, FI, Vistex reporting this include development and customization.
• Involved in development, maintains, monitors and manages data loads and functions.
• Involved in documents test plans and completes unit testing of developed objects.
• Works closely with Testing/Business resources to support system and integration testing.
• Responsible for performance tuning of BW systems utilizing best practices
• Responsible for supporting Business Objects reports in production and new report development
• Responsible for root cause analysis and providing solutions for production and development issue
• Published SAP HANA Analytical/Calculation views as Analytical index(Transient Providers) in SAP BW used those Transient providers for BW Query developments.
• Conducted various workshop and meeting created proposal and presentation related BW new reporting requirement, BW upgrade and BW on HANA proposal.
• Implemented and developed various scenarios in SAP HANA system related to modeling (Creating Attribute views, Analytical views and Calculation View), Data provisioning (Thru SAP SLT method), Authorization, Import /export etc.
• Co-ordinate with various onsite and offshore team in the areas of BW/HANA/BO/BODS project.

Confidential, NY

Sr. SAP BW Consultant

Environment: SAP BI 7.0, BOBJ, BEx, BW-Vistex, FICO, COPA, SD, HCM, MM, FI(AP/AR/ New GL), ABAP.

Responsibilities:

• Involved in requirement gathering, Architect, design and development of BW implementation.
• Involved in various meeting with stake holders related to project scope, change request, I.T. and business leaders, cross functional team, technical team, onsite and Offshore co-ordination etc.
• Architect the solution by using BW/BOBJ that include BW(Info Objects, DSO, InfoCubes, Data Sources, Transformations, routines, Extractors for Master and Transaction Data, Multi-providers,, BEX Reports and Process Chains).
• Extensively work on BOBJ (Crystal, Webi, Universe, Xcelsius) front end reporting this include new developments, modification, trouble shooting and performance tuning.
• Involved in leading and managing BI project implementation plan, co-ordinate with client business team, functional team conducted various training and demo.
• Architect best strategy for publishing/sending the report thru Portal, Dashboard and Mobile apps- thin client/thick client.
• Involved in integrating BW and BO report solution as per the various reporting requirement.
• Involved in design and development of various reports related to SD, Vistex, MM and FICO.
• Involved in vistex requirement gathering, BW-Vistex configurations, customization, development of BW backend and front end objects.
• Design and developed complex report in BW-using Bex, Jump Query,, Variables, formula variables, Calculated key figures, Restricted key figures, Formula, cell editor, integrated with BO.
• Involved in unit testing, QA, data validation, loading, created test scenarios, fixed the issues and collected and manage transport object to QA and Production.
• Involved in extracting data using DB Connect, Flat file and send data using open hub to the external system.
• Involved in BW cutover activities, this include production system build up, configuration, transport fix, master, transaction data loads, setup tables, initialization, delta loads.
• Investigated various defect find solution, apply OSS notes, raised OSS notes etc.

Confidential, Richardson, Tx

Sr. SAP BW Lead Consultant

Environment: SAP BI 7.0, BW-Vistex, SAP ECC, Vistex, BEx and ABAP.

Responsibilities:

• Involved BW-Vistex implementation this include system configuration, development of front end and back end objects.
• Developed or customized multiprovider, infocube, DSO, transformation, Datasource.
• Developed and customized transaction and Master data extractors as per requirement include ABAP customization.
• Involved in development of various complex reports BEX reports by using variables, exit, restricted key figures, condition, filter, formula, restricted key figures, calculated keyfigures etc.
• Involved in development BW security related to BW-Vistex reports including configuration and testing.
• Involved in unit testing, QA and production roll out BW-Vistex back end and front end objects.
• Resolved various issues during development, QA, Go live and production support.

Confidential

SAP Lead BW Consultant/BW Performance Consultant

Environment: SAP BI 7.0, BEx, WAD,VC, ISU, SD, MM, FI(AP/AR/ New GL), PS, HCM, ABAP.

Responsibilities:

• Involved in requirement gathering and enhancement of new ISU report by activating/enhancing ISU content like FI, Billing, meter reading, disconnection and developed ISU reports.
• Involved in analyzing existing BW system recommended and implemented BW performance tuning.
• Involved in implementing performance optimization method like compressing cube, indexing the DSO, partitioning the cube, ABAP code tuning, BEX report tuning.
• Implemented various SAP best practice related to Database, SAP parameters, BW backend and front end.
• Apply and implemented various solution as per SAP OSS note.
• Created complete documentation related to SAP best practice for BW performance and daily, weekly and monthly maintenance required to get best performance optimization.

Confidential, Monroe, LA

SAP BW Testing Lead

Environment: SAP BI 7.0, BO XI, WAD, BEx, WAD,VC, SD, MM, FI(AP/AR/ New GL), PS, HCM, and ABAP.

Responsibilities:

• Project Lead Consultant involved in requirement gathering, project plan, upgrade of BW-EHP1(BI 7.1) and ECC 6.0(From ECC 5.0 to ECC 6.0).
• Involved in upgrade preparation, upgrade, upgrade cutover activities, post upgrade, testing in various land scape (DEV, QA and PROD), manage onsite, offshore team, test plan, documents etc.
• Involved in resolved various upgrade technical issue related to BW Backend, frontend, BASIS by applying OSS Note and raising OSS request.

Sr. SAP BW Team Lead/Project Delivery Manager

Confidential

Environment: SAP BI 7.0, BO XI, WAD, Crystal Report, BEx, WAD,VC, SD, MM, FI(AP/AR/ New GL), PS, HCM, BO, ABAP and Mercury.

Responsibilities:

• Involved in leading SAP BW/BO implementation this include: Architect, BI strategy plan, business requirement, solution design, managing resources, system configuration and development, QA/testing, go live and support .
• Involved in BW-BO integration created universe based on BEx Query, Infocubes, Multicube and infoset.
• Develop and configure standard and custom BW extractors -LO,MM, F, objects and queries
• Extensively worked various areas in BOXI this include Creating BO Reports(Webi, Crystals), Infoview, CMC(Admin), Query as web service, Live office, Publishing report, import and export wizard.
• Extensive experience all the areas of BW reporting development thru BEX and WAD using variables, exit, restricted key figures, condition, filter, calculated keyfigures etc.
• Hands-on working Experience with BW configuration, Batch Delta Uploads, Database monitoring, performance tuning, troubleshooting and resolve BW issues.
• Create and modified technical and detailed guidelines, policies, and procedures.
• Involved in ABAP customization for extractors, BEX user exit and transformation routines.
• Involved in providing Solution Performance (analysis/tuning) and works across business/technology teams to ensure alignment between business solution definition & systems architecture for the organization .
• Involved in analyzing data movements and dependencies between SAP BI, non-SAP DW and external systems.
• Define and develop data structures to support reporting needs. Data warehousing modeling, staging and reporting. Defining, building, and controlling info-cubes, universes, aggregates, extractors, update rules, queries, reports, process chains etc.

Sr. SAP BI Architect/Lead Consultant

Confidential, Salt Lake City, UT

Environment: SAP BI 7.0, SAP ECC 6.0, BEx, WAD,VC, BO XI, SD, MM, FI(AP/AR/ New GL), PS, HCM, BO, ABAP, NW2004S and Erwin.

Responsibilities:

• Involved in BI implementation requirement gathering, BI configuration, functional and technical documents, extraction setup, BI development, QA, Go live and Support.
• Activate master data object related to FICO, HCM, SD, MM and PS and loaded Attribute, Hierarchy and Text data and test the data fix issues related data loading.
• Design and created custom multiprovider, infocube, DSO, infoset, enhance extractors, transformation, DTP and Info package.
• Extensively worked on front end reporting by using BEx, WAD and publish report in portal, configure information broadcasting.
• Created generic extractors, enhance the extractors and created custom reports for SD, MM and FICO.
• Work extensively in financial reporting this include P&L, balance sheet etc.
• Implemented newGL, AP and AR related new extractors, DSO, infocubes, remotecubes, multiprovider and reports.
• Created process chain for master data and transaction data automated complete data loading and maintenance thru process chain.
• Involved in security and authorization by using new BI 7.0 analyze authorization this include object level authorization.
• Created new BI reports and publish in Portal and configure Information broadcasting for sending BI reports thru mail.
• Involved in BASIS related activities Investigated issue related to BI find resolution thru OSS note and apply OSSNOTE and Patches.

Sr. SAP BI Lead/Architect

Confidential

Environment: SAP BI 7.0/BW, SAP ECC 6.0, BEx, WAD, BO, SD, MM, FI(AP/AR/GL), SCM, ABAP, NW2004S and Visio.

Responsibilities:

• Sr. BI Consultant for implementing full life cycle BI/BW project for new business unit/company and also involved in BI upgrade, enhancement and production support.
• Involved in working with business community to collect reporting requirements and architect, design and develop the BI components (Activating Business content and enhance, Multiprovider, ODS/DSO, BEx Reports, Visual Composer, WAD reports, Portal integration, Information Broadcasting) .
• Involved in the definition of Key Performance Indicators (KPIs) and involved in design the data model and its components within SAP BW.
• Worked extensively in LO extraction (SD,IM,PO) and FI( GL, AR, AP).
• Involved in requirement gathering, GAP analyzing, Data modeling, Data Conversion, Developing, Unit testing, Transport Management, moving to QA and PROD.
• Developed complex report in BW- by using Bex Analyzer, Dashboard, Jump Query, WAD, Variables, formula variables, Calculated key figures, Restricted key figures, Formula, cell editor, custom exit using ABAP and publish in net weaver portal.
• Involved in various Production support this include trouble shoot and investigating the production ticket issues and resolving issues in a timely manner.
• Thru DBConnect extracted data from external oracle table and loaded to custom DSO and Infocube.
• Extensively work on Inventory related issues resolve some of major issues related to inventory start routine and reload the data.
• Developed Infocubes, DSO, Transformation, Datamart, custom extractors, Start routine in ABAP, infosource, Datasource, Process chain & Reports.
• Involved in architect, design, development of sales history data conversion this involves bringing historical data from other company and transform and loading.
• Involved in development of process chain, Transaction and master data loading full load, Init delta and delta.
• Involved in implementing role based authorization for BI report this involves in plant, Profit center, sales organization etc based authorization.
• Involved in collecting BW transports and resolved issue related to transport failures.
• Implemented and recommended best SAP practices to follow during and design, development phase of BI project.
• Resolved issues in BI/BW BASIS & Database by the help of OSS.
• Conducted training and created training documents for the go live plan.
• Created documentation related BW regular maintenance and administration as per SAP recommendation.

Sr. SAP BI/BW Consultant

Confidential, PA

Environment: SAP BI 7.0, SAP ECC, SD, MM, FI(AP/AR/GL), SEM, BPS,BCS, ABAP, BEx Query Designer, XI, EP, NetweaverWeb Application Designer, Cognos, MS office(Excel, Word, PP) and Visio.

Responsibilities:

• Involved in requirement gathering of Management closing reports, Architect, Design and developed, ETL, BEx reports, Cubes, Datastore Objects.
• Extensively work for performance related issues in BW, this involves better response time for BW reports(This include regular maintenance of BW Statistics, Compression, Index recreation etc.) Data loading and regular maintenance and monitoring procedures.
• For performance enhancement Partitioned and compress the cube, created index, use of OLAP cache, BW statistics maintenance.
• Created documentation related BW regular maintenance and administration as per SAP recommendation.
• Conduct various meeting with management team for identifying BW performance related issues and new requirement and enhancement of existing BW system.
• Modified standard and Created Custom Data sources, Infosources, Infocubes, Multiprovider, Datastore objects.
• Extracted data from R/3 and legacy system to BW.
• Created Open hub for sending data from BW cube to external source.
• Using UD connect extracted data from external Database(Oracle) and loaded data in to BW.
• Review and propose improvements to existing BW Support processes
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Created iviews and publish in BI reports in Netweaver portal/EP.
• Validated data from SAP-R/3 against the BW data in PSA. Identified error and back track them in Data Targets and handle the errors.
• Used BW Statistics, Query Monitor. Created Indexes to enhance query performance.
• Worked on production tickets fixed the issues related BW.
• Involved in testing of BW reports in SD & MM and validated the data between R/3 system and BW.
• Planned and executed Integration test and involved in designing User Acceptance Test and Procedures.
• Transferred technical knowledge specific to SAP BW and the existing data model to other team members.
• Coordinate with Basis team for necessary update, patches, apply OSS notes, corrections, transports, and application enhancements

SAP BI Lead Consultant

Confidential, Dallas,Tx

Environment: SAP BI 7.0, ECC 5.0,LO, SD,MM, IM SEM-BPS, BCS,MM, FICO, APO-DP, FI(GL,AP,AR), ABAP, BEx Query Designer, Netweaver Portal, Visual Composer, Web Application Designer,, Teradata, Unix, MS office(Excel, Word, PP) and Visio.

Responsibilities:

• BI Consultant to identify planning reporting requirement and architect, technical design, development above reports.
• Extensively worked on development of management BW reports, created dashboard and publish report in WAD and portal.
• Extracted and transform and Load(ETL),Created new Info cubes, Multiprovider, infosoke(For sending to external database), Info Source, Info Objects, Datastore objects, Transformation and Bex and WAD.
• Migrated objects update rules, data sources, BEx from BW 3.5 to BW 7.0
• Worked extensively on LO Extraction-SD, MM and FI (GL, AR, AP).
• Investigated issued and find out solution recommended OSS notes apply those solution.
• Investigated the data coming from SAP APO/SCM to Teradata for the Demand planning reports, created new views and enhanced existing views, Virtual cubes and multi providers for generating above reports in BEX.
• Involved architect and design the data going from BW to Teradata thru open hub and from Teradata to BW.
• Created and modified Variables, Calculated Key Figure, Restricted Key Figure, Structures and Queries for users.
• Expertise in Front-End Queries, Filters, Conditions, Exceptions, Hierarchy and Variables.
• Created master data and loaded master data from R/3.
• Analyzing the Business Content required, activating the business content components.
• Extensively worked on Generic Data Extraction mechanism to create Data Sources for transaction and master data.
• Customized Data sources including ABAP code for functional enhancement (User-exits) for Master and Transactional Data.
• Created new views in Teradata for calculating unit conversion to gallons and created Virtual cubes in BW based on those view.
• Created Remote cube, Custom infocube, Infospoke/Open hub and data store objects, Transformation, for demand planning reports.
• Transferred technical knowledge specific to SAP BW and the existing data model to other team members.
• Architect and develop the plan for getting the data from SCM remote cube to BW.
• Extensively worked on developing various custom report in BEX.
• Created BW transports, fix errors in transport and transport to quality and Prod system.
• Conducted various testing related to Unit test(FI, MM, SD areas), User acceptance testing created test scenarios, after the testing transported objects to production.
• Involved in Support related activities like worked on support issues with onsite team and offshore team.

Confidential, Houston. Texas

Sr. SAP BW Consultant

Environment: SAP BW 3.5, SAP R/3, BEx Query Designer, XI, Web Application Designer, Mercury (Testing), Oracle, Unix, Windows XP, MS office(Excel, Word, PP) and Erwin & Visio.

Responsibilities:

• Involved in implement the project from Blueprint to go-live, Involve in development & support during the implementation phase towards self reliance.
• Lead consultant to identify all reporting requirements for BW and identification of technical GAPS for the R/3 system.
• Involved in SAP BW Data Warehouse Architecture Design, Functional document, ETL, Physical and Logical Data Modeling.
• Design and developed BU dashboard reports for Performance management team.
• In-depth knowledge of Business content as well as created custom Info sources, Info objects, Info cubes, ODS, Remote cube, Virtual cube,Infospoke, Info objects, Transfer/update rules, process chains and reporting agent.
• Extracted data from SD, MM, FICO, PS, BCS&BPS from R/3, from flat files, from Oracle(Thru DB Connect) and from XML into SAP BW.
• Configured the Information Broadcasting Messaging system to send Alert information to business owners as and when needed.
• Involved in development of the performance management reporting dash board report (240 cells) printing 12 months of data, getting information from Purchase, Sales, Inventory, FI, Flat files and Oracle tables.
• Developed various complex report In BW using various technology like variable, Cell editor, Restricted key figures, Formulas, Jump query, Variable using user exit, replacement path and publish report in Web application designer and Enterprise Portal.
• Requirements Analysis, Data Model Design and implementation of the architecture and Support of BW solution.
• BEx query Reporting using various, Install Business Content, Generic Extraction.
• Designed and built multiple custom Info providers for SD,MM,WM, TSW (IS-OIL) and FI/CO reporting and analysis.
• Extended Standard Business Contents based on client requirements using User Exit and Function Module.
• Created complex start routines and function module in ABAP.
• Setup flat file extraction for Legacy Data, Assigning Data Sources to the Info Source, Defining Transfer Structure and replication and updating of data source from the source system.
• Involved in various testing during phase of BW development like integration testing, user acceptance testing and maintained test scenarios in Mercury Quality center
• Designed and developed authorizations strategies for info object and info cubes to execute queries.
• Worked with functional business contacts to develop activity groups, profiles and authorizations.
• Acted as a liaison between Information Technology, SAP functional project teams, Basis administration and Auditors in gathering and communicating information on the SAP R/3 and BW security systems.
• Co-Ordinate with various development team meeting for delivering as per requirement, conduct business meeting and communicate Project status and project planning meeting, manage offshore team
• Train Power Users on utilizing, developing, and administering BW Queries.