SUMMARY

• Around 10 years of IT experience in analysis, design, development, implementation and production support. This includes SAP BW/BI/ABAP functional and technical experience.
• Involved in 4 full life cycle implementations for different modules in SAP BW BI and BO projects.
• Directly worked with end users and clients at various client locations.
• Highly experienced in upgrade of SAP BW Application from 3.5 to BI 7.0 and from BI7.0 to BI7.04
• Worked on business requirements gathering, developing functional and technical specs, and data modeling using Multidimensional Modeling and extended star schema.
• Worked on Migration projects from BI 7.0 to 7.4
• Thorough understanding of installation, configuration and customization of BW objects including InfoCubes, ODS Objects, MultiCubes, InfoObjects, InfoSources, InfoPackages, Transfer Rules, Update Rules, Process Chains
• Created Start, End, Expert routines, info package level, DTP level and Info Object level Routines .
• Worked extensively in creating objects in SD, MM, FI - AR, FI-AP, FI-GL, FI-CO,PP, CPM, and QM functional areas
• Proficient in installing business contents (in BI 7.4/7.0/3.X) and enhancements of Data Sources and writing the start routines, transfer routines, update routines.
• Extensive experience working with LO Cockpit and Generic data extractions.
• Proficient in working with setup tables scheduling task in all the areas like Sales Order, Deliveries, Billing, Purchasing, Inventory and Quality management.
• Worked on the BI Admin Cockpit and provided the statistics reports to analyze the usage of Queries and data load performance.
• Expert in using APD and Open Hub Destination features of Data Warehouse Workbench.
• Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques.
• Worked on Cut over activity plans for soft Go-live and back-up for the SAP BW systems.
• Worked with WAD to develop the web templates and scheduling those reports to the users .
• Worked on Authorizations. (PFCG), Analysis Authorization (RSECADMIN).
• Participated in user meetings to resolve ongoing implementation issues, performance and code reviewing.
• Scheduling and Monitoring the Process Chains and rectifying the issues to ensure the regular data update to BI from R3 System.
• Good experience in analysis, design, development, testing, support, maintenance of applications and Team management process, coordination and monitoring deliverables from team.
• Created Function Module based data sources to get the data from ECC to BW.
• Developed Transfer /Update Rules and ABAP user exits for transaction and master data
• Worked on BADIS for the data source enhancements.
• Having good Communications skills, being a smooth team player with excellent interpersonal Skills and ability to work independently.
• Good Knowledge on SAP HANA Architecture and BW on HANA.
• Strong knowledge in the integration of BODS with SAP modules and Non-SAP data sources.
• Good Knowledge on replicate the ECC content in HANA using data provisioning methods, SLT, and DXC.
• Having Good Knowledge on Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Extensively worked in SAP HANA security including User Management, Rolesand Privileges.
• Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Extensively worked on Data modelling (Dimensional & Relational) concepts including Star-schema modelling, Snowflakes modelling, fact and dimension tables.
• Proficient in Business Objects BI(4.x) Reporting using BI Launchpad, Web Intelligence.
• Knowledge on Business Objects Design Studio, Analysis for OLAP, SAP LUMIRA and Crystal Reports
• Worked on the Most Of the components in the design studio like Filter pane, Dimension Filter, Chart, Cross Tabs, CSS style sheets, Cascading Filters, Combo Box, radio Button ..
• Trained the users on SAP Lumira on the Lumira Functionalities, getting the Data and doing slice on dice on the data .

TECHNICAL SKILLS

Data Warehousing: SAP BW 7.4, SAP BI 7.0 and SAP BW 3.5

ERP Packages: SAP ECC 6.0 & R/3 4.7 E

SAP Modules: SD, MM, FI/CO, PP, PM, QM,CPM

Operating System: Windows 98, 2007, XP, VISTA, 7

Languages: ABAP/4, C, C++ and SQL

Reporting Tools: BEx Reporting, Web Application Designer, Business Objects, WAD, 4.1, Business Objects Design Studio, Analysis for OLAP, SAP LUMIRA

PROFESSIONAL EXPERIENCE

Confidential, PA

SAP BI/HANA Consultant

Responsibilities:

• Understanding the Business requirement, preparing the Functional specifications.
• Involved in the BW HANA Migration from BW 7.0
• Interact with business to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/ for BW Reporting and applications.
• Prepared project related documentation (functional design, technical design, test scripts) during the different stages of a project.
• Worked on Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model based on the requirement in HANA Studio.
• Extracted sales and FI real time data using SAP Data provisioning method.
• Migrated HANA content from development, testing environment to Production environment using imports and exports method.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Created Data Services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations Table Comparison, Case, Validation, Merge, lookup etc in Data flows.
• Preserving the Historical data/Slow changing data by using change data capture technique.
• Created complex Jobs, Work Flows, Data Flows, using Integrator to successfully load data from multiple sources into a desired target using Business Objects Data Services.
• Developed Webi reports for different operations and finance KPI'S like Project planning, quality management, warehouse management, Material management.
• Extensively worked in SAP HANA security including User Management, Rolesand Privileges.
• Crated interactive dash boards with design studio for the Finance and inventory module.
• Used most of the functionalities like Charts, Drilldown capabilities, conditional formatting, Filters and selectors with Design studio.
• Worked on the Design studio with sap HANA by consuming the HANA Views.
• Created and automated the Crystal reports using parameter inBusiness ObjectsInfo view

Confidential, Modesto, CA

SAP BI/BO Lead Consultant

Responsibilities:

• Inventory Data loading from Ecc to BW.
• Inventory reconciliation between ECC and BI.
• Created Inventory Ageing Reports based on Different dates
• Created Inventory movement report for complete cycle.
• Created the Stock transfer order report to analyze the loss.
• Created the Storage loss report .
• Provided the data to third party systems.Implemented the Price valuation for the inventory
• Created the data flow for the price valuation.
• Created the report for the price valuation to get the PUP price of material.
• Designed the data flow for the Account payable and Account receivables for the new GL implementation in ECC.
• Created the Customer balance report.
• Created the Vendor Balance Report
• Created the Customer Ageing report based on Different dates.
• Created the Vendor Ageing report based on different dates.
• Account Receivables reconciliation between ECC and BI.
• Account Payables reconciliation between ECC and BI.
• Designed the data flow for the cost center Accounting .
• Created the reports to show the plan and actual.
• Designed the data flow for the sales and distribution.
• Created the pending contracts report.
• Created the sales master report.
• Designed the Sales Comparison reports based on YTD, LYTD,FTM.LTM.
• Designed Sales Vs Production Vs Inventory report by integrating multiple modules .
• Designed OTD and Delayed delivery reports for the delivery section.
• Designed the data flow for the Purchase data flow implementation in ECC.
• Created the pending purchase order report.
• Provided the Purchase order data to 3rd party systems.
• Designed vendor performance reports.
• Designed purchase order tracking reports which contains PO,GR&IV.
• Designed the data flow for the Material ledger .
• Created the stock movement report from material ledger with different UOMs.
• Designed the cost component report to track the actual cost at product level and helped the business to close the month end activities with the help of the above reports.
• Worked on Customised authorisations on Different Objects.
• Development and maintenance of Bex queries, SAP universes and WebI reports. Designed, developed, modified and maintained Business Objects universe using Designer XI R3 for ad hoc reporting.
• Involved in the design of Universe based on SAP as source
• Extensively worked on designing WEBI reports using Webi Rich Client and Info View.
• Created Combined Queries, Query level Filters and Report level Filters.
• Created and scheduling of Web intelligence reports from Central management Console.
• Worked on Simple dash boards with Design Studio for the sales and distribution KPIs to show the sales trends analysis.
• Created the Dash board for production planning based on the forecast with the Charts and planning data . So that business can take the critical decisions.
• Prepared the dash boards for risk reports to analyze the risk of the business by combing the sales, purchase, finance, inventory and production data with the Design studio dash board tools .
• Worked on Dash boards for CPM related KPIS.

Confidential, Issaquah WA

SAP BI Consultant

Responsibilities:

• Prepare functional and technical design documents
• Developed Service Statistics Report for Fiscal YTD, WTD, PTD and Rolling 13 periods
• Changed the sales audit report to get both created and processed records, used constant selection to achieve this in BEx
• Modified the RTMS report to get the counts based on, used exception aggregation to achieve this requirement
• Create/Modifying Existing Infoobjects and Infoproviders as per the requirement
• Write customer exit variables for Rolling 13 periods for current year and last year
• Extract data from SAP to BW manually using Infopackges & DTP’s for FUT and SIT, created process chains for automated data loading
• Participated in pre go-live and Hypercare activities
• Worked on Performance improvement in BW side .

Confidential

Responsibilities:

• Analyzed and corrected production problems as they occur in the SAP BW system
• Provided high level of customer service to end users, business units and groups
• Handled the tickets of priority 2 and 3 tickets also.
• Understanding the procedures followed in support.
• To communicate with the customer who post the ticket
• Monitored Daily Chains, weekly Chains, and Monthly Chains.
• Handled the tickets of priority 3 and 4 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
• Scheduled data loads to BW from SAP R/3, Informatics, and flat files and Monitored data loads which are running daily, weekly & monthly basis and solving errors when errors occurred.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA and reloaded to ODS.
• Maintaining Work History for all the tickets until it is closed down.
• Checking the data in the POSDM and process the error data manually from POSDM to BW.