SUMMARY

• More than 15 years of experience in Digital Analytics space i.e. SAPBI (10+ Years in BW, 6 years in ABAP, 8 years in BOBJ, 3 years in BPC,4 years in HANA )experience, all project stages including business development, project estimating, requirements determination, gap analysis, business process reengineering, issue resolution, configuration, custom code specifications, testing, training, go - live assistance and post implementation support.
• Project management: Performed extensive work with project proposals, oral presentations, timeline determination, budget estimation and staffing plans. Multiple engagement experience with global delivery model including offshore functional and development support, Certified in PMP, ITSM, well versed with agile methodology. Expert in managing stake holder’s expectation and involve almost all stake holders in each stage of projects through SCRUM meeting as well as Sprint.
• Operational Activities in projects: BI Extraction: SAP extraction for Finance, Logistics, HR, Generic (view, function module, BADI), Oracle & SQL server based tables and flat files for full and delta extraction.BI Modeling: LSA, LSA++ Model Design & implementation, Data Mart Model, DM&ER modelling based on Kimball’s Principles.BI Reporting: Bex, WAD, Workbooks, Bex Variables ( user-exit ) on OOPS framework & function module based, Performance tuning in Reporting areas.BI Security: Authorization objects, roles, user settings.
• Nature of projects: Customizations: Expert in writing ABAP & OOABAP in enhancement on sap datasources, DTP selection fields, Transformation routines, programs in process chain & query variables, Utility tables & programs.BI Implementation:9 implementation projects in the area of FI,CO,SD,MM,PM,COPA,PS,HR,CRM.BI Operations: Process Chains, locking and unlocking, Data load management, Event processing, Reporting optimizations, BI Statistics and Reporting agent, Batch load strategy, Housekeeping activities.BI Upgrade: 4 Upgrade Projects BW 3.5 to BI 7.o,and BI 7.o to BI 7.3&7.4,involved in many support pack upgrade projects

TECHNICAL SKILLS

Planning Tool: SEM BPS 4.0, IP(Integrated Planning), SCM 5.0 ( APO-DP, APO-PPDS,APO-SNP), SAP BPC7.5,10 & 10.1 Net weaver & Microsoft Version, SAP industry specific solution IS Oil, IS utility, POSDM, Solution manager.

Reporting Tool: SAP BO3.x/4.x( crystal reports, WEBI, Xcelsius, Data services, DESKI,Olap Analysis ).

In memory Database: SAP HANA, HADOOP. Front End Tool Fiori & UI development (HTML5),Lumira.

Programming: ABAP, PL/SQL, Javascript, Interface Eclipse, Toad and SQL Plus. Mercury quality center, Service center, HP open view

MSBI: SSIS,SSAS,SSRS,SQL server 2012 .

Visual Tools: QlikView,Tableau.

PROFESSIONAL EXPERIENCE

Confidential, Seattle

SAP BW BO Architect

Responsibilities:

• Created Universe in UDT as well as IDT based on various source systems like Teradata,Netezza, Sql server & Sap system
• Used Promotion management to promote various BO reports into different environments
• Created universe as well as many webi reports based on BW views & Bex queries.
• Created WEBI & OLAP analysis reports on top of HANA Cubes
• Used Data services to extract data from Teradata system to hana system for csr & rsl project
• Created some cool dashboards for finance users.
• Used 360 products to enhance BO capability.
• Used new technology like Denodo to enhance virtualization layer for the reporting objects.
• Designed overall solution for upcoming projects like OER & Forklift project.
• Created multiple dashboards & reports from Tableaue & BO.

Environment: HANA SP9, BO4.1, CRM6, BW, Teradata, Hadoop, SAPDS

Confidential, Chicago

SAP BW BOBJ Architect

Responsibilities:

• Worked on various info cubes likePurchasing Groups, Vendor Evaluationfor the Material Management module from the Business content.
• Created BO4.1 reports ( webi,Analysis ) & dashboards using DS4.1
• Maintained connections in CMC, created users,roles,migrated BO objects across landscape using LCM.
• Created universes on top of HANA models using IDE or sql server based data sources.
• Worked on info cubes likeQuotations, Sales Order and Customerfor the Sales and Distribution module from the Business content.
• Trained technical personnel on BIW,BEx Reporting, Web Reporting, and Knowledge transfer.
• Designed Technical Specs forextractors, DSOs, Open hubs, Cubes and reportsfor the Point of Sale project.
• Designed Technical specs forArticle and Merchandise hierarchiesand article assignments for extracting from ECC and loading into BW and EDW.
• Developed the DSO for Article hierarchy with Article Assignments.
• Primary support and on call 24/7 for all SAP BW production issues.

Environment: HANA SP8, BO4.1, SAP, CRM6,Teradata,SAPDS,BW7.4,ECC6

Confidential

Reporting Manager

Responsibilities:

• Delivered the Business Intelligence solutions to the end user with in a structured framework based around the SAP Business Objects BI and SAP Business warehouse BW platform.
• Created Reports using SAP BW data as data source.
• Designed Technical Specs for extractors, DSOs, Cubes and BEx queries
• Designed & Developed custom DataSource, InfoSource, Extractor, InfoCube and ODS to fulfill user requirements.
• DevelopedTransfer rules, Update rules and Start routines using ABAPto in corporate Business logic and perform data manipulation.
• Maintaining RFC connection,Monitoring BWA,Starting & stopping the BWA,sequence of blades, Admining BWA index,Monitoring & analysing BWA index,Tracing BWA, BWA back up blades,Optimizing BWA landscape,Setting up service connection for BWA,Config Trex alert server for BWA
• Enhanced master data sources 0Customer, 0Material and 0Vendor to meet custom reporting requirements.
• Build Universes, Crystal and WEBI reportsfor Cost Center Analysis Report, Work Orders and Notification Data. Creating various Sales Analysis and other KPI\'s report used by business.
• Created query using QAAWS and using Dynamic query created Xcelsius Dashboards.
• In R1, implemented enhancements of data sources in Back office ( FI,HR PA (ESS & MSS),Logistics ) in BW.
• Worked as BO admin, to do server/services configuration, create user groups, rights, trace log etc in BO4.1.
• Built WEBI as well as Crystal reports using BO 4.1 environment.
• Completed SAP BI upgrade project which involves SAP 7.0 to SAP 7.3

Environment: HANA SP7, BO4.1, CRM6,Cordys,Hadoop,BODS,BW7.4,ECC6

Confidential, Houston

BOBJ Lead Consultant

Responsibilities:

• Worked as Lead consultant for Sales Apps project roll out (phase1, phase2) in GPMR program, which is mainly based on Sales data across all region along with Billing and credit data in BI 4.0 platform.
• Created very intuitive dashboards (around 5) on BI 4.0 environment based on sales data for Lubes business, B2B specialty Business.
• Web service connection, BICS, creation of WEBI, Performance Tuning of WEBI and dashboard, used IDT and Design Studio to create connection and universe to report on multi sources.
• Created IP based Target cubes so that Users can upload target sales data for all months in Region and Sales group level.
• Interacting with various groups of users about the usability of BI4.0 objects in their business and try to bring high end product into the project deliverables.
• Drive KT session with SOM team as well as project team to transfer any things practiced in this project.
• Around 700 web template exist in BW system got migrated to AOLAP(Olap Analysis Report) and WEBIs in the 6 month duration project.
• Worked closely with SAP and applied several fix in product release of 4.1.
• Managed various get going phases of this project without any issues.

Environment: HANA SP7, BO4.1,BW7.4,BODS,ECC6

Confidential

BW Lead architect

Responsibilities:

• Fixed and coordinates in terms of fixing issues on production like Tickle feed data from POSDM system by using 0rt pa tran control data source.
• Gathered and analyzed the requirement to replicate the ECC content in HANA usingdata provisioning.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Established the best modeling and recommended strategies for BOBJ environment and architecture forSAP HANA.
• InstalledBOBJ 4.0andBODS 4.0and configured SAP and Windows AD authentication for Business objects enterprise.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
• Created Technical specifications and standard modeling documents for HANA.
• Developed testing scripts and performed UAT on SAP net weaver portal using Test ID’s for developers, super users, and end users.
• Performed datamodeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Developed data models for theoperations, PP, Global sustainment, Quality management tables in HANA.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• IntegratedSAP Net weaver portal to Business objects content using Knowledge management, Iviews, work sets, portal roles.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Developed Webi reports and dashboards for different operations and finance KPI’S likeProject planning, quality management, warehouse management, Material management, Global Sustainment, Value management.
• Created Universes on top ofHANA calculation viewsand developed the Webi reports and dashboards usingIDT(Information design tool).

Environment: HANA SP5, BO4.0,POSDM, IS-RETAIL,CRM6,PI,SAPDS,BW7.3,ECC6

Confidential

BW Lead Consultant

Responsibilities:

• Its and ongoing implementation and support based projects based on ECC6 and BI7.0 as well as SRM system.
• Designed and developed ETL mappings to read source data and loading into target warehouse by using Data services.
• Developed New Transaction codes for creating Actual/Forecast file into local PC and upload it into BW.
• Involved in projects development and cutover activities (Regression testing, technical cutover, post cutover activities) moving into the production system.
• Running Reconciliation Reports and compare the data between BW and R/3 in case of exceptions and also fixing the issues.
• Created Group economic capital, Group Capital Balance and Risk reports like enterprise risks, Credit risk Business Areas, Liquidity Risk Limits etc
• Customized Master Data objects, Cubes, Process Chains, APD, and Info spokes etc in
• Mainly involved in Material Master Data in BODS and loading in SAP using LSMW.

Environment: BO4.1, CRM6,Teradata,Hadoop, BODS,BW7.0,ECC6

Confidential, San Ramon

Application Lead

Responsibilities:

• Successfully implemented on an average 4 projects per quarter and 6 enhancements per month, worked on an average of 3000 hours of work per month via a team of around 20+.
• Reviewing Support Pack strategy, early watch alert, backup strategy, monitoring query performance strategy, data management strategy for system performance. Based on the actions, system will go through required changes to give more stability.
• Extracted purchasing documents and equipment records from R/3 and transforming it to meaningful data Via ABAP code, allowing users to identify equipments by serial number which have been replaced by OEM vendor under warranty condition and highlight erroneous equipment records.
• Worked with senior management on business process reengineering, providing advice on business structures and how they best align with SAP and best business practices.
• Done sizing and Capacity planning for BO 4.o project.
• Designed and developed reports for many real estate projects in SAP Business Object 4.0.
• Upgraded successfully from SAP business object XI 3.1 to SAPBO 4.0.
• Worked on improving performance of WEBI reports as well crystal reports.
• Designed and Developed complex dashboards like inventory dashboard and inventory viewer in Xcelsius.
• Deliverables of development and Maintenance work needed for the Confidential &T users in Uverse business
• Developed consolidated Project plan to keep track of all the projects in CORP portfolio.
• Designed and developed reports for many real estate projects in BO.
• Designed and developed Reverse logistic data flow.
• Designed RL reconciliation tool by creating customized program based reporting

Environment: HANA SP1, BO4.1, CRM6,Teradata,Hadoop,SAPDS,BW7.4,ECC6

Confidential, Houston

Project Lead

Responsibilities:

• Leading SAP BW team in getting KT and provide seamless support to Confidential
• Functional Support and Maintenance for the manufacturing unit of Iberia region of Confidential .
• Worked as an SME in one of application area for the PF project in Confidential .
• Implemented Sales solution for Confidential in PF project.
• Have gone through all the solutions implemented in all areas in SAP and suggested the improvement areas.
• Worked in reconciliation model for the solution delivered by PF project.
• Expert in Performance tuning in ETL, Queries in BI space.
• Implemented BIA in this project.

Confidential, Houston

Team Lead

Responsibilities:

• Estimated man hour(FTE) for various projects rolled over to WRM(like PF,ECCS,NIKE,BI 7.O Upgrade, technical cut over)
• Driving the CAB meeting & User Group meeting to explain the technical solution required for the change requested by different users
• Creating PD, estimating the duration and cost for all the change tickets coming into WRM
• 24/7,365 days Supported to all application data (PCA, CCA, FI, CO, MM, SD, APO) including all year end, quarter end, month end process in BW.
• Involved in end to end SAP BPC 7.5 implementation.