SUMMARY

• SAP techno - functional consultant with 16+ years of IT experience - 14+ years of SAP-BI/BW 7.5/7.4/7.3/7.0/3.5 , 3.1/3.0B, 10+ Years of SAP-BOBJ 4.2/4.1/4.0/3.5/3.1 , 3+ years of HANA modeling.
• Proficient in Modeling of BW developments, BO Reporting, & HANA Objects; designing dashboards, reports & scorecards using Lumira, Design Studios, Xcelsius & Power BI.
• TEMPEffectively contributed to major projects & client needs as a technical consultant - lead/developer/analyst.
• Multiple full life cycle implementations as SAP techno-functional consultant - requirement gathering, GAP & OLAP analysis, business blue print, design & development, code review, testing, reporting, go-live & support.
• Demonstrated ability to think as a solution/platform architect to provide long-term sustainable solutions.
• Liaison between teh key users to agree to teh reporting requirements & designs, modelling techniques, & data flow.
• Successfully worked in an agile project management environment.
• Strong experience in consuming BW data models into SAP HANA & vice-versa
• Hands-on experience with data replication scenarios ofHANA from SAP/non-SAP source systems.
• In-depth insight into BW data modelling, strong in BW data extraction process, Expertise in report generation.
• Strong technical presence in integration ofBODS - Data Migration, configuring data-stores, extracting teh meta data.
• Expertise in end-to-end data migration process and ability to interpret, configure and implement data mapping / transform business rules into data services.
• Performed Urgent and Normal corrections using multilevel development environment “Solution Manager Charm”
• Techno-functional player in integration of SAP BW with SD, MM, APO, SRM, CRM, SCM, PP, FI, CO;
• Extensive experience in working with BAPI, OO ABAP, Java, data migration and interface technologies.
• Proficient in universe designing & development using Oracle, SQL Server, Teradata & BW queries and info cubes.
• Expert in front-end reporting with BEx, Web intelligence,Xcelsius, Design studio, Lumira, AO, Power BI, and Tableau.
• Extensively worked on converting existing dashboards and reports to Tableau dashboards for various projects.
• Designed various Power BI analytical dashboards dat depicts critical KPIs with slicers and dicers.
• Best practices with focus on researching and making recommendations for emerging and future technology trends.
• Extensively worked on Project plan during cutover tasks like maintaining quiet time activities for a seamless go-live.
• Solid leadership, relationship & communication skills; configuration & project management skills.

TECHNICAL SKILLS

Languages: ABAP/4, SQL, PL/SQL, C, C++, Java

SAP modules: ERP (SD, MM, PP, FI-AP, AR, GL, CO-PA, HR), BI/BW, SRM, CRM, AFS, SCM, APO

ETL Tools: SAP BO Data Services 4.0/XI3.2/3.1/3.0, SAP BO Data Integrator XIR2/11.7/11.5

Reporting tools: Business objects 4.2/4.1, Crystal reports, BEx report designer, WAD, Power BI, Tableau

SAP versions: HANA2.0/1.0, BI 7.5/7.4, ECC 6.0, BODS 4.0/3.2, Net weaver, Portal.

Cross applications: Interactive reports, ALV, ALE, LSMW, SAP script, Smart forms, user exits, BDC, BADI and BAPI

Databases: SAP HANA2.0/1.0, Oracle 8i, SQL server 7.0, MYSQL, MS-Access, HDFS

Web tools: Adobe flex builder, Photo shop, HTML, Java script

Packages: Microsoft office Suite, MS-Project

Prod support tools: Remedy, HP quality center

PROFESSIONAL EXPERIENCE

Confidential - MEMPHIS, TN

Sr. SAP HANA/BI/BO LEAD CONSULTANT

Environment: Hana 2.0/1.0, BI 7.5/7.3/7.0, BODS 4.1, ECC 6.0, BO 4.2/4.1, UDT/IDT, WEBI, Lumira, Design Studios, Xcelsius, Power BI, Tableau, Oracle, Windows 2008 R2, SQL Server

Responsibilities:

• Collaborate with business engagement managers and project managers along with global IT team to formulate and structure technical projects; heavy involvement in design & implementations of Business Intelligence solutions.
• Hands-on leadership & guidance to design & develop a sustainable enterprise wide BI reporting framework & solution.
• CreatedHANAmodelling scenarios and activities such as creating schemas and content models, views and privileges.
• Utilizing smart data integration, created few remote sources to connect from MSSQL servers to hana database.
• Virtual tables are accessed in teh hana database schemas to populate teh daily snapshot data for historical reporting.
• Created replication tasks, hdb procedures, data tables, schemas & flow graphs using HANA development workbench.
• Extensively worked on migration ofstandardInfocubesandDSOstoHANA optimizedinfocubesandDSOsby using Tcode 'RSMIGRHANADB' and migrated old data flows to Hana optimized flows.
• Designed and developed complex calculation views utilizing multiple projections, joins, unions and aggregations
• Worked onAdvancedDSO,OpenODSView,Compositeproviders&Transientproviders.
• Converted teh ABAP Logic used in transformations to SAP HANA Compatible Code for In-Memory Optimization.
• Expertise on object oriented ABAP concepts, ABAP managed database procedures and core data services.
• Developed real time data acquisition from ECC & CRM ABAP CDS view as a data source to extract and load into BW Open ODS Views; Created BEx query on top of it to show it utilizing AO reporting tool.
• Involved in latest technical upgrade planning and coordination of system maintenance activities.
• Extensively worked on Project planning during cutover tasks like maintaining Quiet time activities for a seamless go-live.
• Diagnosed root causes for incorrect vendor postings based on master data, and custom table analysis.
• Recommended solutions for historical data /archived document posting for entry correction in financial reporting.
• Extensively worked on Transport management system and CHARM for migrating of objects across different landscapes.
• Developed a transport program in BI system to validate all transport consistency check ZBW TRANS.
• Involved in teh end to end implementation of teh Business Near-Line Storage project across teh SAP BW landscape.
• Worked on Technical and Functional migration from 3.x to 7.x for teh BI data models in different application areas
• Developed a program to selectively delete target records based on multiple fields and saved so much of database size.
• CreatedWebI reports and deployed them through BI Launchpad with Hana calculation views as a source.
• Extensively used various features likeJoins,AliasandContextsinIDTto overcome varioustrapsandloops.
• Built Lumira dashboard stories for different businesses with multiple report functionalities (including exporting to excel, PDF and PPT) using reusable composites.
• Created Power BI interactive reports & advanced analytics in a true self-serving manner utilizing SAP HANA connector.
• Designed and developed Power BI graphical and visualization interactive dashboards using gauge, funnel, line graphs; Utilized power query to Pivot and Un-pivot teh data model for data cleansing and data massaging.

Confidential - MEMPHIS, TN

Sr. SAP BI/BO LEAD CONSULTANT

Environment: BI 7.4, BO, BODS, BO Java SDK, Teradata, SQL, Tableau

Responsibilities:

• Managed critical projects needing PMO level expertise, executive level status updates on a weekly basis.
• Recommended standards of best practices of report development and maintenance of universes.
• Created and followed-up on OSS messages forSAPto discuss on resolving teh issues on a timely manner.
• Designed and developed data sources, jobs, data flows and work flows using BODS.
• Monitored and maintained BODSdata load jobs which extract data from third party systems.
• Built dashboards using design studio, created visualizations for analysis purposes.
• Created BIWS connections to provide inputs to Xcelsius dashboards from webi reports.
• Involved in performance tuning of existing dashboards and dashboard design alternatives.
• Performed administration tasks like moving universes & reports between environments using Promotion Management.
• Provided testing and quality support for Enhancements, New Developments and Upgrades.
• Trained and supported teh users to use Business Objects and resolved Trouble Tickets/Cases reported by user.

Confidential - ST. LOUIS, MO

Sr. SAP BI/BO LEAD CONSULTANT

Environment: BI 7.4/7.3/7.0, ECC 6.0, SCM, SRM, BO 4.1 (SP3), SAP HANA 1.0 SP5, BODS 4.0, Windows 2008 R2, SQL Server

Responsibilities:

• Assessed and cultivated long-term strategic goals for data warehousing in conjunction with key stakeholders.
• Provided hands-on leadership, direction and guidance to design and develop a sustainable enterprise wide solutions.
• Demonstrated teh ability to think as a solution/platform architect to provide long-term sustainable solutions.
• Migration of Legacy SAP BW/BI to BW on HANA with SAP best practices.
• Provided design expertise in support of team efforts for flexible reusable components to increase cost TEMPeffectiveness.
• Liaised as a domain expert to work closely with software developers to explain teh application design, and coordinated activities between teh two functions to enhance product quality and efficiency.
• Extensively worked on performance tuning using BW Statistics, Aggregates, Compression, Partitioning.
• Involved in supporting teh administration team for upgrading SAP BI to BW on HANA including pre & post activities.
• Designed and developed SAP HANA data modeling architecture by translating teh business KPIs.
• Activated HANA optimized Business Content for Billing, Conditions, Delivery and Sales Overviewareas.
• Created Analytical privileges, calculated attributes, calculated measures, constant columns, parameters and variables.
• Using BODS, created connections between source (ECC, SQL) and teh BW 7.4 and HANA systems to move data.
• Designed and development of DataServices (BODS) jobs, data flows and work flows.
• Created teh information spaces using SAP BO Explorer tool on top of teh SAP HANA Information models.
• Created relational universes by combining SAP BW cubes with existing SQL Server & Oracle for multiple sources.
• Designed/Created many complex and customized reports for specific business requirements.
• Specialized in creating SAP Lumira Dashboards with HANA views for SAP AFS and Retail Vertical Industries.
• Developed dashboards on universes using teh SAP Design Studio for an enterprise Business Intelligence (BI) portal.
• Involved in making changes to teh design studio 1.2 SDK for few components as per teh client’s requirement.
• Designed and developed major reports like Master schedule and PPV on top of inventory, Super sheet and On-time fulfillment on top of sales, Warehouse Flash on top of sales, deliveries and purchasing, Bonus report on top of HR.
• Monthly drilldown Dashboards with separate views for different levels of management using Xcelsius 2011.

Confidential - OAKLAND, CA

Sr. SAP BI/BO - DELIVERY TEAM LEAD

Environment: BI 7.3, ECC 6.0, BO XI 3.5

Responsibilities:

• Managed and supported teh business information team; carried out teh multiple IT projects in SAP BI/BO environments.
• Led teh business lines & onshore/offshore teams to ensure on-time delivery by performing code reviews, resolving escalations and enhancing current processes.
• Ensured dat business requirements and technical design of teh solutions meet business needs.
• Introduced best practices with focus on researching & making recommendations for future trends.
• Solved business and technical problems by leveraging expertise and technology from across teh organization.
• Led teh planning, data modeling, detailed requirements analysis and deployment of a project engagement for IM & P2P.
• Engaged in teh designing and implementations of business intelligence solutions with business partners/ IT teams.
• Worked on integration of SAP business objects (XI 3.5) to SAP BW and SAP R/3 environments.
• Proposed teh redesigned architecture for teh Sales Order and Delivery flows with teh inclusion of teh EDW layer for flexibility and utilized teh new Semantically Partitioned Objects (SPO’s) introduced with teh 7.3 version.
• Expertise utilizing webi, crystal reports, xcelsius, business explorer.
• Use HP quality center for defects, reporting & tracking post go-live activities, incidents and tasks.

Confidential - SANTA ANA, CA

Sr. SAP BI/BO - TEAM LEAD

Environment: BI 7.0, ECC 6.0, SCM, SRM, BO XI 3.1/3.5, BODS 3.2, SQL Server

Responsibilities:

• Led teh activities of teh global implementations for cross-country client’s business processes & reporting needs.
• Involved in teh implementation of teh Business Warehouse Accelerator project across teh SAP landscape.
• Responsible for requirements gathering, design, development & implementation of data warehouse using SAP BI for ETL with custom R/3 extractors and business objects for front-end reporting.
• Liaison between teh key users to agree reporting requirements, report designs.
• Tracked deliverables, monitor and mentor team, giveprojectstatus to teh Leadership Team and Client Team
• Created, executed & documented initial acceptance, performance, regression tests.
• Created teh BI application for teh SD module using teh sales overview, loaded sales, deliveries and billings for Reliability (Deliveries on time) and Availability (Delivery dates confirmation at time sales order) reports.
• Developed function module generic extractors to pull MRP related information from ECC.
• Supported a successful go-live and hypercare tasks.

Confidential - CINCINNATI, OH

SAP BW/BO ONSITE LEAD

Environment: SAP BI 7.0, BO 3.5, ECC 6.0, SAP web dynpro abap, SQL server, Enterprise portal

Responsibilities:

• TeamLead, On-site Coordinator for P&G as a primary POC for all deliverables (full life cycle implementation) dat includes gap analysis, requirements gathering, blue print, development, testing, reporting, and go-live & support.
• Monitored teh team action items & procedures; developed weekly status reports for teh project manager.
• Responsible for teh deliverables of data source developments & enhancements, end to end BI solutions.
• Developed Global info cubes, DSO objects and extracted Master data and Transaction Data in CRM, and FI Info areas.
• Used DB connect and UD connect to communicate to 3rd party servers.
• Developed an ABAP program to run in teh background on daily basis as part of teh process chain.
• Extracted & validated teh data of teh cubes & dsos by using generic data sources, and developed universes & BO reports on top of them; delivered defect free objects to teh client after reviewing them.
• Involved with various database administrators to map teh requirements and proposed new solutions.
• Enhanced data sources from SAP MM: 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 02 SGR, 2LIS 02 SCN, 2LIS 03 BF.
• Worked on BEx query designer to create custom queries, and embedded those as iviews in teh enterprise portal.
• Responsible for running disaster recovery and high availability tests; designed training manuals, conducted workshops.

Confidential - LISLE, IL

SAP CONSULTANT

Environment: Portal EP6 WAS 6.40, guided procedures, Adobe live cycle designer8.0, SAP netweaver 7.0, xRPM

Responsibilities:

• Executed an on-site delivery model, developed product request process using adobe interactive forms, and integrated in ECC/xRPM back-end.
• Coordinated and managed product ionization and rollout activities
• Involved in teh end to end implementation of teh Business Near-Line Storage project across teh SAP landscape.
• Developed a guided procedure process in enterprise portal dat used 4 different online interactive forms.
• Wrote various remote function modules, designed & developed Smart forms to modify per required layout.
• Developed a portal iview to upload documents for supporting product requests using noledge management API’s.