SUMMARY

• SAP Professional experience of more than 10 years including 3 implementation, 3 Minor releases and 2 support projects in version HANA SP7/SP9, ECC 6.0,SAP BW 7.4/7.3/7.0/3.5 and BOBJ 4.1/4.0 with proven track record of company and customer satisfaction.
• Exposed to all phases of project from Blueprinting, Configuration, Development, Integration Testing, Cutover, and Training to Go Live.
• Expertise in HANA Data Provisioning techniques like Flat File, SAP Landscape Transformation, BO Data Services, Direct Extractor Connection, Replication Server, Smart Data Access, Smart Data Integrity and Smart Data Quality.
• Exposure to HANA DB security including User creation and providing authorizations privileges like Object, System, Package and Analytic privilege.
• Hands on experience with HANA information modeling include creating Attribute views, Analytic Views and Calculation views to the complex business requirements using HANA Studio/Eclipse.
• Exposure to conversion of DSO and InfoCube from regular to HANA optimized models.
• Exposure to Composite providers, Open DSO and Advanced DSO models with BW on HANA.
• Very good knowledge on SQL and SQL Script language for coding complex calculation views and creating Stored Procedures for information models.
• Worked on performance improvements and management of Information models in SAP HANA.
• Knowledge on SAP HANA Native development and HANA Live modeling and worked on proposals.
• Expertise in SAP functional modules SD, MM,IM, FI, FI - SL, COPA and POSDM.
• Worked on various Source Systems for Data Extraction, specifically from SAP R/3 using Standard Extractors, LO and Generic Extraction.
• Extensively worked on modeling and transportation of BW objects like InfoObjects, Hierarchies, Data Store Objects, InfoCube, MultiProvider, Infoset, Open Hub etc.
• Involved in extracting data from legacy systems like Traffic, Budget and Forecast through middleware Informatica connection.
• Implemented business logics with complex Start Routine, End Routine, Field Routine and Expert Routines in the transformations to enable highly efficient reporting using ABAP programing.
• Hands on experience SPO (Semantic Partitioning Object) n in BI 7.3 for Fiscal year portioning and BODS from non-SAP systems.
• Created Merchandise and Assortment planning (MAP) templates using SAP Integration Planning module for business planning users with the help of complex Planning functions and Planning sequences.
• Expertise in creation of BEx Analyzer, Query designer Queries, Workbooks, Structures, Variables, Calculated Key figures, Restricted Key Figures and RRI reporting. Portal reports creation using WAD templates.
• Extensive experience in the Maintenance of Information Warehouse and good acumen in troubleshooting and Performance Tuning.
• Participated in Business Objects 4.0 to 4.1 upgrade preparation and execution with Platform configuration team.
• Expert in IDT - Management (Connections/Universe), Promotion Management (BIAR/Live) for the easy business reporting.
• Complex landscape with platform rebuild and sync, greatly worked in Recurring Instance management.
• Worked on SAP Business Objects 4.1 Design Studio, Office for Analysis and Web I, Dashboards, Crystal reports and Lumira.
• Expert in validating reports, data models enhancements and interfaces through STLC and Agile testing.
• Expert in defect management reporting, requirement tractability trough HP QC 11.5.
• Onsite Team Lead managing offshore team of 3 and having a high-level of communications, consulting and client relationships skills. Participate well within a team and work diligently to share skills and information with other team members using brainstorming technique.

TECHNICAL SKILLS

Operating Systems: Windows-NT, MS-DOS, UNIX

Software Tools: MS-Office, Visio, ABAP/4, Solution Manager(SOLMAN), Service Now (SNOW) ticketing tool, WCC tool

Component Version: SAP BW 7.4, 7.3, 7.0 and 3.5 & SAP ECC 6.0

SAP-Techno Functional: SAP HANA SP09, BW 7.4, 7.3, 7.0 and 3.5

Reporting Tools: BOBJ 4.1 and 4.0, Analysis for Office, BEx 7.4,7.0 and 3.5

Testing & Training Tools: HPQC-Quality Testing Tool

PROFESSIONAL EXPERIENCE

Confidential

SAP BW /BOBJ/HANA Consultant

Responsibilities:

• Estimating the effort of change requested by client as per the business requirement.
• Replicated tables from ECC into HANA using SAP Landscape Transformation (SLT) data provisioning technique.
• Created jobs using SAP Business Objects Data Services and pulled data from SQL into HANA for modeling.
• Supported all the information models installed in HANA using SAP HANA Live tool.
• Created Information model by joining required tables from ECC in HANA using Calculation View for business requirement and reporting with HANA Studio\Eclipse.
• Created universe with individual calculation views for reporting purposes for Business Objects BOBJ WebI documents.
• Expertise in SAP HANA security management including user roles and privileges including Analytic privilege for Information models.
• Actively involved in incident resolution and service request resolution raised by business users.
• Actively worked on maintenance of BOBJ WebI documents across the system landscapes through promotion management.
• Created recurring instances for the WebI documents for daily and weekly broadcasts to the portal environment.
• Extensive knowledge in classifying the ticket priority as P1, P2, P3 or P4 using Service Now tool and adhere to the defined SLA of the priority.
• Adhere to the process followed by client including change approval, COE approval and then development. Transporting BI/BW objects from the DEV system to the Quality/Production servers.
• Creating the Technical specification documents for the new HANA/BW/BI objects. Reviewing the HANA/BW/BI development objects of team the members before sending it to QA.
• Involved in Dry Run and Cutover activities of minor releases both in Quality and Production environment.
• Extensively worked on standard and custom Info Cubes, ODS objects, Info Objects, Info Sources which provides source of data to Business Objects web Intelligence.
• Creation of Process Chains segregated by Process Areas designed in such a way, that Transaction Data Chain starts after the completion of Master Data Chain.
• Creation of PSA Deletion Chain which would increase the performance of the system by not occupying much memory of the DB.
• Continuously contributed towards business improvements by developing value added models and reports. Created data model to compare the NA retail store sales in Global Store System (GSS) and SAP BI. Created reports with daily variance in sales and broadcasted to business users and all other stake holders for quick view.
• Monitored the batch jobs scheduled in production daily and involved in resolution of any kind of failures that happened during the load.
• System performance improvement, periodic checking of Unused Aggregates, deletion of Change Log, PSA, recording of system statistics.
• Involved in design solution suggestion for the defects identified and implemented many best solutions both in frontend and backend.
• Worked closely with other landscape teams such as middleware and Informatica (ICC) for both inbound and outbound SAP BI objects.
• Created workbooks for Quick Statistics for the business with the requirement to have decision making with Category options.
• Responsible for peer review for regression changes before moving the change from a development system to another development system.
• Involved in submitting the Ticket Status (Open/Close) report.
• Maintain Work History for all the tickets until it is closed down.
• Interacted with Clients to get the inputs from the user to close the tickets.
• Maintaining reconciliations to verify the data in SAP R/3 and SAP BW are same or not after the data loads.

Environment: SAP ECC, IS - Retail BI 7.0, 7.4 BEx, WAD, dataVard,HANA,BODS,BOBJ, Portal

Confidential

SAP BW/BOBJ Consultant

Responsibilities:

• Worked with onsite counter-part to understand the business requirement and the solution options.
• Involved in Knowledge transfer sessions and workshop with business users on the requirement discussion.
• Estimating the new development requirements in SAP BW/BI implementation by analyzing Functional specification / High Level design documents.
• Created Sales Tax reconciliation report using Sales for business community to report on the tax and take appropriate decision on tax payment.
• Coordinating with onshore team and operations to develop the application based on the exact requirements.
• Created APD solutions with BEx query as the source and loaded into DSOs.
• Created Aged Inventory model with Storage Location granularity to facilitate the business with seamless transaction inventory movements.
• Involved in transport collection and migration of transports from development system to quality and then to production after QA testing.
• Reviewing the BW/BI development objects of team the members before sending it to QA.
• Defect Management and Post Go-Live Support in BW/BI for stabilization.
• Extensively worked on standard and custom Info Cubes, ODS objects, Info Objects, Info Sources which provides source of data to Business Objects web Intelligence.
• Responsible for end to end testing for all the reports designed as per the requirement.

Environment: SAP ECC, IS Retail BI 7.0 BEx, WAD, Datavard, BOBJ,BODS,Portal

Confidential

SAP BW/BOBJ Consultant

Responsibilities:

• Worked with onsite counter-part to understand the business requirement and the solution options.
• Estimating the new development requirements in SAP BW/BI implementation by analyzing Functional specification / High Level design documents.
• Coordinating with onshore team and operations to develop the application based on the exact requirements.
• Created model for First cost to help business taking decisions on actual cost inquired for a product rather than second cost which is MSRP.
• Created Size Profile designs to load data from SQL RIS system for allocation reporting in BI.
• Created Proof Of Concept for challenging scenarios which came across the path and have successfully implemented solutions.
• Involved in transport collection and migration of transports from development system to quality and then to production after QA testing.
• Created daily sales summary dashboards using Design Studio and Sales and Margin report using Lumira.
• Created model and report for Physical Inventory in all NA retail stores. Model includes flash sales for all the stores from last PI count data till current count date and the inventory adjustment details for higher management to have a look on shrink % in stores.
• Reviewing the BW/BI development objects of team the members before sending it to QA.
• Defect Management and Post Go-Live Support in BW/BI for stabilization.
• Involved in End To End solution for Allocation purpose which involves, extraction from Informatica, Staging DSOs, Application Layer Info Cubes, Reporting Layer MultiProviders and n number of queries.
• Responsible for end to end testing for all the reports designed as per the requirement.

Environment: SAP ECC, IS Retail BI 7.0, BEx, WAD, BOBJ, Netweaver Portal

Confidential

SAP BW/BOBJ Consultant

Responsibilities:

• Estimating the new development requirements in SAP BW/BI implementation by analyzing Functional specification / High Level design documents.
• Actively involved in changing functional specification document and technical specification as per the requirement for the newly developing BI objects.
• Involved in meeting with COE team to review the solution options prepared and get approval for one of the feasible solutions best to the business requirement.
• Created well formatted BOBJ WebI reports like Category Quick Stat, Complementary Sales for the business users and broadcasted to the emails and portal for quicker and mobility decisions.
• Created models and queries for Trend factor with concept category and billing details for allocation purpose for business use from ECC.
• Created and modified all the time characteristics customer exit variables to facilitate Work Week 53 for report comparison.
• Created In-transit report by modeling open inbound delivery units to the handling units by extracting required data from ECC.
• Report includes aging of cartons used by business to charge vendor for delays.
• Always adhere to the coding standard defined and best practices suggested by SAP.
• Involved in transport collection and migration of transports from development system to quality and then to production after QA testing.
• Reviewing the BW/BI development objects of team the members before sending it to QA.
• Defect Management and Post Go-Live Support in BW/BI for stabilization.

Environment: SAP ECC, IS Retail BI 7.0, BEx, WAD, BOBJ,BODS, Netweaver Portal

Confidential

SAP BW Consultant

Responsibilities:

• Involved in requirement gathering with client and the business users to identity the exact need for the implementation.
• Worked along with Functional team to prepare the Function spec and the technical spec for each reporting requirement.
• Prepared data dictionary document comprises of Extractor & fields details of each extractor to help BI to pull the data from SAP R/3 to SAP BI.
• Involved in development of flows including Master Data, Sales, Inventory, Purchasing, Billing etc.
• Installed SAP delivered BI contents for all modules like Master Data, Sales, Inventory, Purchase, and Billing etc.
• Worked with Point Of Sales Data management (POSDM) team in configuring POSDM types like, Transaction, Sales Item, Discount, etc. for the sales flow.
• Extensively worked on creating activation of BI objects and also custom objects of DataSource, DSO, InfoCube, and MultiProvider.
• Created transformations between objects with routines as per the business requirement using ABAP.
• Created complex reports with Sales and Inventory modules. Facilitated business with WTD, MTD, STD and YTD KPIs for greater analytics.
• Created InfoPackages, DTPs to load the datasources and DSOs/InfoCubes.
• Converted 3x DataSource to 7x to support multiple targets.
• Created corporate memory for all the datasource to have data backup just in case we need to reload the target by dropping it completely.
• Created Process Chains for different flows to automate the load and for email report broadcast using batch schedules.
• Created ‘n’ number of Management and Operation reports along with Adhoc reports using BEx query designer.
• Created many user exit variables to achieve Business reporting needs including Last Year Adjust comparison.
• Designed complex reports with Conditions, Exceptions & Cell Editors to meet Business reporting needs.
• Created MAP templates for Factory planning business team. Planning template includes Location planning and Merchandise Planning using Planning sequences, planning functions.
• Involved in user training for all the super users of NA retail SAP BI reports including Management and Operational teams.
• SPOC for the maintenance of documents project related FS and TS in Solution Manager (SOLMAN).
• Involved in COE review for each and every objects created to have approval and move it to QA.
• Involved in transport collection and migration of transports from development system to quality and production environment.
• Part of Dry Run and Cutover activities in quality and production for smooth release.
• Performed the application handover to the Service Management (Support).

Environment: SAP ECC, IS Retail BI 7.0, BEx, WAD, NetWeaver Portal

Confidential

SAP BW Consultant

Responsibilities:

• Involved in modeling InfoCubes, update rules and multi-provider in order to meet the end user reporting requirements for US TOM project.
• Involved in Transferring & Replicating the Transfer Structure, Applying Transfer Rules, assigning Data Source to Info Source.
• Upload master data and transactional data information to BW system.
• Involved in the initial data upload from R/3 and worked on the initialization run to set up for delta uploads.
• Integrated all the data in BW using Multi-Providers and InfoCubes to create reports like Cost Analysis, Location Analysis, Damage Analysis and Maintenance Consumptions reports for the application Plant Maintenance.
• Extracted data from LO data sources to BW system.
• Created OSB (Order Shipping Billing) Report: Data model was created to merge Order, Shipping (Delivery) and Billing Information into one single line rather than using the traditional way of reporting OSB from 3 different cubes. This helped business to study the complete cycle of OSB and also allows Business to check for example what has been ordered but not delivered or what has been delivered but not billed.
• Created Account Receivables Ageing Report: This report helps business to study the outstanding payments from Customers. The pending payments are bucketed into 0-30 days, 31-60 days, 61-90 days and >90 days overdue.
• Created Customer Pick up report: Customers who send their own trucks to pick up goods gets a discount from P&G. This report lets business to study the customers who availed CPU discounts and validity of the discount.
• Created Dangerous Material Report: Materials that are marked as hazardous need to be packed differently when it is shipped from P&G warehouse and also follows different custom clearance processes when it was exported outside US. This report helps business to study when was the hazardous material last ordered and when it was last Goods Issued. It also helps warehouse in packing and shipping the materials as per government guidelines
• Transported BI objects and BEX objects to Acceptance and Quality boxes.
• Created Process chains to automate the Process of Loading Data into Data Targets.
• Performed Unit Test in Development and SIT in Quality box.

Environment: SAP ECC, BI 7.0, BEx, WAD, NetWeaver Portal

Confidential

SAP BW Developer

Responsibilities:

• Worked closely with strategy consultants in utilizing Top-down and Bottom-up approach to understand current measurement metrics and to convert them into deliverable KPI's.
• Architected and developed Sales and Delivery Performance data model comprising of multilayer for reporting.
• Open Sales, Open Deliveries and unbilled datamarts. The sales performance report with the waterfall effect provided the upper management an insight on the efficiency of the sales operations. Developed a QM data model with qualitative and quantitative data to generate First Pass and Yield reports. Developed a production planning data model using repetitive manufacturing LO extractor to generate production volume KPIs. Designed and developed Inventory data model using BX, BF and UM LO extractors.
• Developed a General ledger data model using 0FI GL 4 data source to generate Income statement, Balance Sheet and Cash Flow statements.
• Created a FI-SL (Special Ledger) data model based on material and cost center. Installed Asset master data and InfoCubes to create customized annual depreciation reports. Created financial inventory data model using material ledger data source.
• Developed a data model based on COPA to report Sales Margin Reports by product line and by regions. Developed a global spending datamodel based on Accounts Payable, General Ledger, External data and Purchasing Good Receipts.
• Prepared technical documentation for the BW team and training materials for the end user training. Published sales dashboards using BEx Analyzer and Web Application Designer for the sales managers.

Environment: SAP ECC, BI 3.5, BEx, WAD, NetWeaver Portal

Confidential

VLSI Designer

Responsibilities:

• Requirement gathering for image compression.
• Preparation of High Level Design and Functional document as per the client requirement.
• Learning VLSI designs with best practices.
• Involved in coding for image compressions with new algorithm Tag Setting In Hierarchical Tree (TSHIT).
• End to end testing and defect fixing for compression coding.
• Preparing project documents with simulation and working of VLSI design.
• Co-coordinating team meetings with cross team members for project integration.
• Complete project submission to the department head with no backlog and no defect in the project.

Environment: VLSI, Electronics.