SUMMARY:

• Over eleven years of multi - national ERP industry experience in the area of HANA, SAP BW/BI, ECC involving major global implementation projects in US and Europe.
• Worked with top Consulting firms like Confidential, IBM,CSC, working with various work force models of across the world.
• Extensive experience in the functional areas of SAP CRM/ECC 5/6(MM,SD,FI).
• Over an year of expertise in implementing SAP BI on HANA solution using Data Services, DXC,SLT.
• Dealing with ODP,Transient/CompositeProviders,HANA Studio,Attribute/Analytic/Calculated/Decision tables
• Worked on a wide variety of a Reporting tools from BOBJ 3.x/4.1 like Universe Designer/IDT, Dashboards,Design Studio1.5/1.6,Crystal Reports, Webi,Qaaws etc
• Stong knowledge of SAP-BW/BI skills - Data Modelling, Infocubes, Generic Data Extractions, BEx Analyser, BEx Browser, Remote cubes.
• Excellent knowledge of SAP BW components like Data Source Enhancement, User Exits, OLTP extraction data Loads, Scheduling, Monitoring, Process Chains, Remote Cubes, Data Mart and Open Hub Service,Info Spokes, Reporting Authorizations, user profile maintenance.
• Experience in Design and Development of Reports, Web Report publishing and Queries using BEx Analyzer, BEx Query Designer, BEx Browser and Info Set Queries.
• Involved in 6 full life cycle BW implementations and have Managed 3 of them.
• Significant experience with ASAP/SDLC Methodology - requirements,analysis,design,development testing, documentation, user training and support. Out-standing skills in debugging and problem solving. Fast learner and enthusiastic with good analytical skills.
• Time bound, Result oriented, Motivator, Team Player

TECHNICAL COMPETENCY:

Languages: ABAP, Java, Java Script, CSS, XML, T-SQL, PL/SQL,JSP.

ETL Tools: BOBJ Data services 3/4.x, SQL DTS,DXC,SLT,

ERP: ECC6, CRM 5,

Data Warehouse Tools: SAP NW 2004s, BW 7.4

Cross Applications: ALE/IDOCS/RFC/LSMW/EDI.

RDBMS: Oracle, DB2, SQL Server.

Development Tools: Visual Studio .net, HANA Development Studio,SQL Developer

OLAP Tools: BOBJ Universe Designer,Information Design Tool(IDT)

Reporting Tools: BEX, BOBJ4.1, Crystal Reports, Xcelcius/DashboardsWAD,WEBi,Qaaws,WebServices, Design Studio1.6, Analysis for office

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. BW Consultant

Environment: ECC, SAP HANA, SAP BI 7.4, BOBJ 4.1

Tools: BOBJ Tools Webi,Crystal Reports,QAAWS, Xcelsius/Dashboards, Java Script, SQL, Design Studio1.6

Responsibilities:

• Involved in requirement gathering and Functional Designs for reporting on SD,MM,FI, COPA systems
• Supporing various Business Units with their reporting needs.
• Designed, Developed, and Deployed backend data models to support various reporting initiatives from various Business Units giving varied reporting front ends like BEX/BOBJ/Dashboards/Design Studio,Crystal reports etc.
• Built and deployed Dashboards from Oracle data warehouse using BOBJ4.1 Tool Suite like Qaaws,Dashboards, Design Studio,IDT, webi, Crystal Reports 2008/13.
• Migrated Xcelsius/Dashboards/WAD dashboards which are based on BICS/BEX Connections to Design Studio using HTML Grids, Crosstabs.
• Used Hana Views/IDT with relational Universes with Design Studio.
• Developed SQL scripts for hana objects.
• Developed Custom enhancements to the datasources, Customer Exits, Expert routines, complex Transformations, Function module/Program based extractors.
• Created HANA Attribute/Analytic/Calculated Views for reporting on BOBJ 4.1 tool suite using IDT.
• Migrated critical data flows from traditional BW to HANA platform and tested to completeness in data quality.
• Developed various models in HANA using different loading techniques (Data Services/DXC/SLT) to multiple targets like Transient/Composite/Operational Data providers.

Confidential, Tucson, AZ

BW Consultant

Environment: ECC 6(MM,SD,COPA), SAP BW/BI 7.3, BOBJ 3x/4x

Responsibilities:

• Involved in requirement gathering and Functional Designs for reporting on PRISM(SD,MM) and APEX(FI) systems
• Designed, Developed, and Deployed backend data models to support various reporting initiatives from various Business Units giving varied reporting front ends like BEX/BOBJ/Xcelsius,Crystal reports etc.
• Developed various backened/ABAP objects like Datasources from FunctionModules,Custom extractors,LIS cockpit,Infoobjects,DSOs,InfoCubes,MultiProviders,VirtualProvider,HybridProviders, infoSets, ProcessChains.
• Developed Custom enhancements to the datasources, Customer Exits, Expert routines, complex Transformations, Function module/Program based extractors.
• Built and deployed Dashboards from Oracle data warehouse using BOBJ Tool Suite like Qaaws, Xcelsius, webi, UDT, Crystal Reports .

Confidential, Dallas, TX

CRM Analytics and Reporting Functional Consultant

Environment: SAP CRM 7.0, SAP BI 7, BOBJ 3X

Responsibilities:

• Involved in requirement gathering and Functional Designs for the SC Bi Reporting
• Led the Strategic reporting initiative to convince the Business owners of a solution which is feasible and agreed by the Development Team with options like WAD/VC
• Involved in the initial Project scoping, effort/cost estimations and resource Management

Confidential, Juno Beach, FL

SAP Supply Chain BI Lead

Environment: SAP ECC 6.0, SRM 5.0, MM, SAP BI 7

Responsibilities:

• Involved in requirement gathering and Functional Designs for the SC Bi Reporting
• Led the Strategic reporting initiative to convince the Business owners of a solution which is feasible and agreed by the Development Team with options like WAD/VC
• Involved in the initial Project scoping, effort/cost estimations and resource Management
• Responsible for the whole planning effort from the Design, Development, Technical/Functional testing and Integration Testing and the Mock up of cutover activities and monitoring
• Redesigned and Architected some of the existing build Solutions.
• Worked on MM, SRM, FI-AP Areas using both Standard Business content and generic Extractors involving Views, Function Modules.
• Implemented OO concepts in the design in CMOD area using individual enhancement Programs for eachExtractor.
• Improved performance using Indexes, Aggregates and partitioning of cubes

Confidential, San Jose, CA

SAP BI Lead/Architect

Environment: SAP ECC 6.0, CRM 5.0, SAP BI 7, ABAP, MM, SD, FI

Responsibilities:

• Involved in end to end implementation ;Blue Print to Support & Transition.
• Designed and Implemented SAP BI reporting for USA and Europe Business Units
• Managed Application Support activities meeting the SLA'a and Change Management.
• Managed and Architected the CRM BI Reports solution.
• Designed & developed custom Extractors using ABAP and CMOD/BADI.
• Enhanced Business content extractors to meet the user requirements
• Designed and developed data models using DSOs, InfoCubes, Info Sets, Multiproviders,
• Designed reporting solution to cater to both US and Europe BU’s using Bex, WAD on Portals and Information broadcasting.
• Performance Tuning by implementing best practices
• Designed and delivered reporting using BO Suite of reporting tools using Crystal Reports 2008, Webi and Xcelsius dashboards

Confidential, Whiting, IN

SAP BI Lead

Environment: SAP ECC 6.0, BI 7, MS Access, Oracle, Informatica, VB

Responsibilities:

• Led a Team of 10 from Brazil, India and USA
• Designed & Developed data models and
• Main goal is to replace spider web of Access DB's used for reporting by BEX reporting supported by BI7.0 back end. The source system was Oracle Datawarehouse built using Informatica as the ETL tool.

Confidential, Irvine, CA

SAP BI Consultant

Environment: SAP ECC6.0, BI 7, Legacy source systems, Informatica, Oracle

Responsibilities:

• Worked as the offshore coordinator for Confidential and Confidential Projects
• Led a diversified team of four personnel from US and India
• Drive the design, build and testing of all loading and process chain scheduling for Confidential
• Support with various Confidential BW back-end related work.
• Designed and built a time sensitive data load model to take care of the complexities
• Support integration and user acceptance testing

Confidential, Houston, TX

SAP BI Consultant

Environment: SAP ECC 6.0 SAP BI 7, MM, SD

Responsibilities:

• Led the Requisition to Pay team's BI Reporting effort right from requirements to Functional/technical specification of BI 7.0 reports
• Managed a Team of 5 (Onsite and Off Shore Vendor resources)
• Developed KPI reports to evaluate the RTP process and Report to Report interface to a detailed report.
• Designed and Developed data models, Transformations, Bex Queries

Confidential, San Francisco, CA

SAP BI Consultant

Responsibilities:

• Involved in the Confidential list lock down, user interviews for requirements
• Functional design and first cut estimate of the info providers needed for each work stream reports.
• Involved in Project Management activities, developed communications flow schedule, developed security