PROFESSIONAL SUMMARY

• SAP BW professional with over 12 years of IT experience, which includes around 10 years of Functional and Technical expertise in SAP Business Warehouse (SAP BW/BI) implementations and 3 years of Expertise in Creating Reports using Business Objects and also around 2 years of experience in HANA implementation.
• Implemented 4 full life cycle BW projects and provided key services such as data modeling, design support, data management, global and cross - functional technical design support for other SAP BW project teams related to PLM, FI/CO, SD, QM, MM, PM and HR modules.
• Experience in HANA implementation on SAP HANA1.0 . Migration from BW 7.x to 7.3 and 3.x to 7.3 and also 7.3 to 7.4 with the HANA database.
• Expert in requirement gathering, developing functional, technical specifications and analyzing providing solutions like what type of data user required, which tables from SAP to pull, type of extractors required to Model the data in BW for building the reports,dashboards to the business .
• Well-versed with development and enhancement of objects such as InfoCubes, DSO, ODS, transactional cubes, DataSources, InfoSources, transformations, transfer rules, update rules, PSA, Process chains, InfoSet queries, batch scheduling.
• Experience in the Archiving data from SAP NetWeaver BW to SAP Sybase IQ as Near line Storage (NLS).
• Experience in RDS implementation based on the user requirement.
• Experienced in the extraction of data from SAP R/3 (PLM,SD,CRM,QM,PM,MM,FI/CO), new dimension products like CRM, RPM using different data extraction structures such as LIS, LO Cockpit, CO-PA and maintaining of delta queues.
• Worked on the Quartz migration project from JD Edwards to SAP, involved in the identifying the business objective, current reporting landscape, dependencies, issues and risks.
• Worked on activating and configuring standard Business Content.
• Developed ABAP/4 reports, Data Dictionary, Transactions, Functional Module, SAP Script, and have ABAP/4 Programming skills.
• Extensively developed the reports using BEx Analyzer, Query designer, Web App Designer and published the reports using the SAP NetWeaver Portal.
• Developed complex BEx queries using restricted key figures, calculated key figures, RRI, exceptions, conditions, replacement, formula, text, user exit and structures
• Experienced in Web-Intelligence, Design studio, Tableau, Crystal Reports, Info View, Universe Designer, Xcelsius.
• Excellent communication, interpersonal and analytical skills with ability to work effectively to meet deadlines in fast paced environment.
• Ability to quickly adapt to new environments and learn new technologies. Good team player and enthusiastic in exploring new frameworks and also conducting Knowledge Transfer to teams.

TECHNICAL EXPERIENCE

SAP ERP: ECC 6.0, 5.0, SAP 4.6B, 4.6C, 4.7

Modules: SAP BW 7.3 (BW-on-HANA), BW 3.x,BI 7.0, RPM, SD, MM, PP,PM,QM, SCM/SRM, CRM, HR, FI-CO, APO

BI Tools: SAP Business Objects 4.1,4.0/XI 3.1, Design studio1.3/1.4,Tableau, Web Intelligence 4.1, Xtract Universa, Dashboard Design 2011,Crystal Reports 2011, Universe Design 4.1,, Informtion Design tool 4.1,Explorer, Infoview, CMS, CMC, Live office, Import Wizard, Xcelsius 2008, Transport manager.

App. & Web Servers: IIS, Tomcat 3.x, SAP EP 5.0/6.0

Programming Languages: ABAP/4, C, C++, Java, VB.NET, XML, HTML/DHTML, ASP.NET

Operating Systems: Windows 2000/NT, UNIX, Linux, MVS/ESA, OS/2, Z/OS

Content Management Tools: Vignette, VSS, Documentum, SAP EP Portal, MS Sharepoint

Hardware: IBM 390 and IBM PC Compatibles

Databases: SAP HANA SP-9,DB2, IMS DB, SQL, TERADATA

Other Tools: Microsoft Office, Microsoft Project, Microsoft Visio, FTP, Control, Test-director

PROFESSIONAL EXPERIENCE

Confidential, Mountain view-CA

Senior HANA BI and BO Lead/Architect

Responsibilities:

• Migrated from BI 7.3 to BI 7.4 on HANA and also Service pack upgrade SP10 through design, testing, User Acceptance Test, defect monitoring and resolution and release management as well as post go-live support.
• Carried out the house-keeping before moving the BW 7.3 to BW 7.4 on HANA.
• Migrating the all the dash boards based on the requirement into SAP Design studio dashboards.
• Followed the best practices for migrating the objects.
• Design the new data flow Book and De-booking project for the OTC team and implemented the logic in the Start and end routine, updated the data in to target. As per the requirement build the Design studio dashboard for De-booking data.
• Worked on the production support activities, monitoring the data loads, fixing the data load errors and scheduling the jobs .

Confidential, Columbus-OH

Senior HANA BI and BO Lead/Architect

Responsibilities:

• Worked on implementation and designing optimized solution to deliver successful HANA Veyron Project with HANA Cloud Integration.
• Migrated from BI 7.0 to BI 7.3 and also BW3.X to BI7.3 on HANA and also Service pack upgrade SP9 through design, testing, UAT (User Acceptance Test), defect monitoring and resolution and release management as well as post go-live support.
• Worked on Archive project i.e data from SAP NetWeaver BW to SAP Sybase IQ as Near line Storage (NLS). Analyzed the data sizing and required configuration setting while exporting the data in the infoprovider and accessing the data from the reports and also worked in the performance testing .
• Carried out the house-keeping before moving the BW to BW on HANA
• Followed best practices for optimizing the objects, ABAP routines i.e start routines, end-routines, field routines and improved the loading performance.
• Migrated and tested the master data object, transaction data and the routines from 3x to 7.3
• Worked on HANA integration with SD,FI,PLM, COPA, Inventory, Purchasing and HR Data
• Worked on the testing strategy for pre upgrade, post upgrade and data validations. Tested the Dual Delta extraction process and validated the data BW-on-HANA.
• Worked on DSO vs cube performance analysis and testing process.
• Migrated the BEx reports and work books from 3.x to 7.x .Fixed the issues faced by the users and provided trying to user group.
• Worked on POS project and built the complete flow for the UK POS, Canada POS and Channel POS . Build the Data flow for extracting the flat file process from Control-m and some from manual flat file loads. Also built the HANA views for dashboard reports using Tableau .
• Worked on the Ontime deliveries for OTC team . Build the custom extractor based on the requirement for Lagor, GM, Canada and Internationals and build the reports using the Tableau.
• Day to day support for maintaining the BW application especially monitoring the loads and fixing the data errors, performance tuning, change control, security maintenance etc.
• Created Attribute, Analytical and Calculated views as per the requirement needs.
• For one of the time critical report for sales team built the Explorer report i.e FST summary dashboard using the calculated view and analytical views and loaded data in to HANA tables for Business Explorer reporting . Used all the Explorer functionality.
• Created the Analytic Views using Transaction tables in Data foundation and joined the Attribute views in the logical join section.
• Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) in the BW (on HANA database) Scenarios and imported the DSOs, Info cubes to the HANA studio tool.
• Used the HANA studio Functions like Conversion, String, Mathematical and Date to suit the business requirements in Calculated Attributes and Calculated Measures.
• Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio as Analytic views and Calculation Views.
• Implemented the RDS for HR system and extensively worked for all the phases of the Implementation phase.
• Created complex reports by linking data from multiple data providers, stored procedures and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
• Extensively worked with Ranks, Alerter, filters, prompts, variables and calculation contexts in designing reports.
• Created theWeb Intelligence Reportand usedEventsforDaily/Weekly /Monthly Scheduling of the reports.
• Created WEBi report, Dashboard and Design studio reports for the sales and distribution team based on the requirement.
• Created the ontime deliveries dashboard for the OTC team using the Design studio for showing the ontime, late and early deliveries . Used the different options available in the design studio using the BW query as a data source and Dimension filter, filter panel, Cross tabs, images, text, buttons, graphs.
• For the OTC team build the Touched and un-touched orders new functionality and pulled the data in to the BW system for reporting. Created the WEBi and Dashboard reports for the detailed and summary reports using BICS connectivity.
• Created the validation report using the WEBI and pulled the data from different data sources like Sequel using ODBC connection, BW query and the Design studio. Scheduled and distributed report. Used the tables, merge functionality, line charts, variables, linking and other formatting options.
• For OS&D project requirement build the crystal reports for scorecard, ranking and drilldown reports.Also scheduled reports using scheduler Infoview as well as CMC
• Created the Tableau dashboards i.e WCO, Daily flash, POS, scorecard, weather history dashboards and used the all the functionalities available in the tool based on the requirement.

Confidential - Detroit -MI

BW & BO Reporting Sr Consultant

Responsibilities:

• Expert in gathering, analyzing the requirement and providing solutions and model the data in BW for building the reports and dashboards to the business.
• Extensively developed and enhanced the reports using BEx Analyzer, Query designer, Web App Designer and published the reports using the SAP NetWeaver Portal. Also worked on Broadcaster.
• Created the Customer POS dashboard where individual customers can run these dashboard based on the security levels and they can see the sales data, quantity data for CPL1, CP2, Brand, Newpart .This dashboard is built using the Design studio. This is the complex dash board with Tab strip has four tabs, each tab with crosstab and graphs, page, check box, images, text, filter conditions, Dimension filters all the standard functionality were used.
• Created the Relative performance dashboard where customers can see the performance based on the last year for specific Brand,CP1 vs current month. This dashboard is built using the Design studio using the HANA Attribute, Analytical and Calculated views as per the requirement needs.Used the tab strip with two tabs, filtering using the dimension filter, clear filter Radio button for selecting the sales and the quantity data.
• As per the business requirement built the POS Monthly Trend dashboard, this also build using the Design studio for each customer to show the monthly trend i.e the data changes for sales amount and the quantities for different time periods for last 6month . Used the Dimension filters for filtering and drilldown the data and the cross tab for showing the detail data and the graph to Bar graph for showing the Trend.
• Created the analytical reports using the standard templates and also the visualization reports based on the requirement where user can see the data based on the each customer and by the different intervals. Implemented the security levels based on the data usage for each customer.

Confidential - Albany-NY

BW and BOAnalyst/Lead

Responsibilities:

• Upgrade from BW 3.5 to BI 7.0 Technical Upgrade and Service pack upgrade. Worked on the testing process for pre upgrade and post upgrade and data validations and also documenting the issue related to the upgrade process.
• Interaction with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Extensively work on RPM .We have utilized the SAP RPM 4.5 module to streamline its NPDI process. Created the generic extractors in RPM for master and transactional data based on the requirement. Extracted the data in to BI from 0RPM ITEM FIN PLANNING, 0RPM BUCKET CAP PLANNING. Processed the data through the business rules and build the new reports.
• Build the complex WADs for NPI system in 7.0 for displaying multiple reports and graphs in the portal.
• Worked extensively with 1 CO PA 46 and 1 CO PA BRAS extractors. Created DSOs, Cubes to extract the sales, material, sales doc, org and customer data. Processing data using ABAP code based on the business functionality like MOM, PVM, Recast, material ledger and pulled in to report.
• Extracted data from SD modules and uploaded the data into the sales & shipping, sales order schedule line, sales order item, open deliveries, purchasing DSOs and cubes via 2LIS 11 VAITM, 2LIS 11 VASCL and 2LIS 11 V SCL.Created average daily order rate dashboard for management.
• Worked on EDF metrics for Supply Chain Leadership team . Which gives a measurement for Ontime performance and metrics about OnTime, Early, Late and total deliveries with respect to the customer compliances. Built the queries for each group using RRI’s, replacement path, filters, formulas, Navigational Attributes, Restricted key figures and User Exits.
• Worked on the Quartz migration project from JD Edwards to SAP. Involved in all the phases of the development from requirement gathering to creating and delivering the reports to the end users.
• Extensively worked on the PCA and CCA projects. All active materials (Raws, Intermediates, Finished, Packaging, etc.) will have their profit center updated to the new profit center structure. Cost Center assessments will be utilized to allocate costs to the new product lines from existing cost centers
• Worked on the query performance improvement by adding the aggregates and BWA based on the requirement.
• Worked extensively in the point of purchase project for understand selling patterns of our distributors.
• Strong cross functional knowledge of different SAP modules like NPI,SD,CRM,FI/CO,QM and PM.
• Worked extensively with QM module 2LIS 05 QE1,2LIS 05 QE2 and 2LIS 05 Q0NOTIF extractors and enhanced based on the business requirement, enhanced 0QM C04, 0QM C06 cubes to extract the inspection characteristics results and notification information .Reported the data in the reports.
• Developed Sales Orders Cube and Deliveries cube using LO Cockpit extraction.
• Created Generic Data Sources using database Views on Tables, function modules and InfoSet Queries. Made enhancements to transaction data extractors in ECC using ABAP routines to accommodate the custom requirements. And also enhance the standard data sources.
• Working closely with SAP Configuration Team to create manual test scripts, scenarios, test data and test conditions in Quality Center.
• Involved in support pack and Kernel upgrade testing and documented the results.
• Strong understanding of SAP User Authorization Role Maintenance
• Extracted the data from CRM and extracted in to Opportunities 0CRM C04, STNC cube using the standard extractor. Reported the data in the reports.
• Extensively developed and enhanced the reports using BEx Analyzer, Query designer, Web App Designer and published the reports using the SAP NetWeaver Portal. Also worked on Broadcaster.
• Created moderate to complex BEx queries using restricted key figures, calculated key figures, report-to-report interfaces, exceptions, conditions, replacement, formula, text, user exit and structures.
• Created Process chain to automate the Loads with the help of REDWOOD.
• Market segment tool implemented with the help of Visual composer where sales reps are updating the data for not assigned market and market segments.
• Worked on integrating and extracting data from different source systems ECC 6.0, NPI,CRM, SD, FI/CO, Flat File using standard and generic extractors.
• Used Broadcast Agent for scheduling and distributing the documents.
• Extensively worked on the production support activities, monitoring the data loads, fixing the issues and scheduling the jobs for month end, quarter end and yearend loads.
• Worked on SAP BW Production performance and fine tune extractors for processing the data more efficiently.
• Designed new Universes and modified the existing Universes based on the business requirements.
• Created reports on the web using Web Intelligence and distributed them to different users through info view portals.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
• Extensively worked on Crystal Reports into Business Objects environment.

Confidential, Detroit -MI

BW Techno-functional LeadMember/technical

Responsibilities:

• Responsible for requirements gathering, creating Functional and Technical specs, including Gap analysis, Data model, Master Data, Transaction Data and Query designs.
• Upgrade from BW 3.5 to BI 7.0 Technical Upgrade and Dash Board implementation. Worked on the issues related to the upgrade process and data validation and report validations.
• Expertise in upgrading BW 3.5 to BI 7.0 Netweaver 2004s Pre Upgrade and Post Upgrade tasks (collecting system objects, Security). Successfully executed the BI Upgrade Strategy.
• Resolved many issue around the Upgrade. Created OSS messages for Upgrade issue.
• Build and enhance BW objects such as InfoObjects, InfoCubes, InfoSources/DataSources, Update Rules, Transformations, DSO, Infosets and Multiproviders.
• Created and enhance the standard and custom extractors and user exits. Also worked on Direct update DSO.
• Worked on the PM module enhancement, extracted the fields from the enhancement tab (t-code IW32) SWRT1,USR08,USR05,USR01 and USR00 and pulled in to the BW. Extracted the new fields in to the PM Order report based on the user requirement.
• Created the generic extractor for order changes Z ORD CHGS based on the view and replicated the data source and extracted the data in to BW and build the report based on the requirement.
• Worked extensively on creating new and enhancements of BEx Query Designer, BEx Analyzer, BEx Broadcaster and BEx Web application designer. Developed complex queries, workbooks, and web applications
• Strong cross functional knowledge of different SAP modules SD,QM,PP and PM.
• Conducted brain-storm sessions with business users. Worked as a liaison between the business user and BW technical team. And also conducted the User Training on the New Bex Features.
• Created aggregates to improve the query response based on Business requirements.
• Worked on the Pricing cube enhancement and extracted the new fields in to the reports.
• Extracted data from MM modules and uploaded the data into the procurement cubes via 2LIS 02 HDR, 2LIS 02 ITM, and 2LIS 02 SCL.
• Enhanced the standard SD, MM extractors to include the custom fields using the ZXRSAU01 include program.
• Involved in support pack upgrade testing and documented the results.
• Involved in all stages of testing process Unit testing, functional testing, integration testing, and User Acceptance Testing (UAT).
• Installed and configured the BI Admin Cockpit.
• Experience with using start routine, field and end routines to customize business requirements
• Extensively worked on the Transport Request Process with SAP BW and ECC environment.
• Execution of UNIX scripts at OS level to extract the files from 3rd party servers into BW.
• Worked on SAP BW Production performance and fine tune the extractors.
• Created process chains for Master and Transaction data for BCS, CO, HR, SRM and Tax.
• Involved in writing the routines at Infopackage level for automating the selection criteria.
• Day to day production support for maintaining the BW application especially monitoring the loads and fixing the data errors, performance tuning, change control, security maintenance etc.