Untitled Document

Career Overview:

Sr. SAP BI Lead with 8+ years of demonstrated success in SAP Business Warehouse project management and development is seeking the position of Project Manager.
Technical Skills:
Skills, Experience, Total Years
Data Modeling Expert 8
Data Extraction – R/3, CRM, SRM Expert 8
BW Reporting – BEx, WAD Expert 8

Functional areas – LO, SD, MM, PP, FI-CO, CRM Expert 8
ABAP Expert 8
Microsoft Excel, Project Expert 8
SQL Expert 5
Cognos Impromptu Working knowledge 2
Ascential DataStage Expert 1
Business Objects Trained 1
PMP Certification In process Nov 2012
Accomplishments:
Project Management

• Responsible for leading and managing integrated BI solution project teams and projects from concept to completion.
• Performed effort and budget estimation for developing project plans and proposals.
• Evaluated alternatives and developed recommendations for technology/process solutions to meet business requirements.
• Designed and implemented over five full life cycle implementation projects including requirements gathering, design and development, testing and go-live using ASAP methodology in both Waterfall and Agile models.

General Management:

• Efficiently managed and coordinated at least six different modules in a project, from job initiation through job completion.
• Gave recommendations and proposals for architectural improvements, design solutions and integration solutions, leading to reduction in company expenses.
• Established and implemented projects using SDLC methodology.

IT Training:

• Designed SharePoint master page and page layouts, serving as the BI team’s main SharePoint support for all technical complications.
• Conducted training sessions for users to accustom them with new reports and tool features.

System Upgrade & Support:

• Provided continued maintenance and development of bug fixes for existing data and reports.
• Provided daily support to ensure company staff had necessary tools to perform tasks efficiently. Improved reliability from 90% to 99% for supply chain, demand planning, forecast and other CRM data related reporting.
• Designed, documented and executed appropriate maintenance procedures including system upgrades, patch management and system backups.
• Ensured customer satisfaction by providing online technical support.

Development:

• Extensive experience with both back-end and front-end BI/BW development.
• Worked on both custom and delivered extractors, ABAP routines, BADIs, Info Cubes, ODSs/DSOs, Multi Providers, Transformations, Update and transfer rules, DTPs, Virtual key figures, Open Hub, BEx Analyzer, WAD, calculated and restricted key figures and many other BI/BW objects.

Work Experience:

Sr. SAP Business Intelligence/Business Warehouse Architect June 2006 – Current
Confidential,MA/Dallas, TX

• Working on the conversion and consolidation of Financial Customer Service reports and Material Management reports from Impromptu and Powerplay to SAP BI. Cognos will be replaced saving the company yearly maintenance and licensing cost of $1M.
• Team lead on the conversion and consolidation of 150+ reports in the areas of Purchasing, Planning, Manufacturing, Warehouse Management and Deployment from Impromptu to SAP BI.
• Performed extensive work with project proposals, timeline determination, budget estimation and user staffing for testing reports on the migration project.
• Part of a large global implementation team to provide Osram Germany with consolidated demand planning data for NAFTA countries for the automotive department and for the general lighting department.
• Provided a customized solution for Demand Planning for the following organizations: General Lighting, Display Optic, ECS, NVG, LED Systems and Osram Mexico.
• As BI team lead provided production planners with Forecast data. Enabled functionality to report on various levels - customer, sales organization, distribution channel and material.
• Introduced consistent methods for measuring business performance through KPIs. Improved forecast quality by making enhancements that brought OSI forecast accuracy reports in line with the Siemens’ definition of forecast quality.
• Made continuous improvements to enhance performance of data loads and reports because of the high volume of data.
• Lead a team of external consultants to replace the monthly demand planning process. Built a Business Warehouse integration point to the history structure within Manugistics to develop a statistical weekly demand plan. The business uses this plan in conjunction with the SAP / ERP system to manufacture or procure products.
• Also included separate demand streams for key customers within specific channels. Future plans include possible expansion to Automotive and Osram Canada.
• The new functionality provided the ability to enter events when required versus the month allowing SAP/ ERP to properly time phase product requirements.
• Increased forecast accuracy on under forecasted types by 6.5% and over forecasted types by 12.5%.
• Collaborated with production planners to gain consensus on business processes and key performance indicators. From these discussions, configured data model and reports to better determine in-stock requirements which led to more accurate material availability and on time delivery. BI reporting included integration of inventory, sales and forecast data.
• Responsible for creating “Kanban” project management documentation to define project scope, requirements, deployment plans and data conversion/migration plans. The project led to $6.3 million in inventory cost reduction and $1 million in warehouse cost reduction.
• Led a team of 5 on the operations side of the Sylvania Lighting Services Project to track the performance of technicians using BI reporting with CRM as the source system.
• This reporting initiative led to the creation of a reporting system to calculate the days taken from start to completion of a job by technicians, the tasks completed in first pass, time spent on travelling, analyze scheduled services and track the daily service call status.
• Two time recipient of discretionary award from Sylvania Lighting Services for outstanding design and customer support.
• As BI team lead responsible for providing GL / Auto transportation the ability to accurately accrue and report on transportation costs for every shipment. Provided the functionality to correctly calculate shipping costs and accurately report them to the SBUs.
• Additionally, provided the ability to report trends and perform cost to serve analysis by customer, product or location to accurately calculate shipment costs across every mode of transportation.
• Thereby leading to the replacement of the legacy system. The TCDB costing database, Various Access based databases and SAP program ZVLOG019 were also replaced resulting in cost savings of about $2 million.
• Responsible for integrating the changes made to EDI with SAP BW and SAP R/3.
• Awarded with discretionary award for cost savings by new hire.

SAP BW Consultant Jan 2004 – June 2006
Confidential,Portsmouth, NH

• Provided consulting IT services to different end-clients including Merisant Inc, Kindred Healthcare and Kansas City Service Center. Knowledge of pharmaceutical, health-care and manufacturing industries.
• Enhanced the existing business model with input from plant managers to incorporate a new product line in the data model.
• Provided multiple reports to plant managers to assist them in determining the average delivery time for a material, information on backorders, price trends on materials and identify discrepancies in the values of goods as per the purchase order and the values invoiced or received.
• Conducted training sessions for customers to help them use the reporting tool to better analyze the data and make better business decisions.
• Led a team of 3 to automate the collection of data from hundreds of facilities.Data from nursing homes was integrated with data from hospitals and this information could be accessed from anywhere in the enterprise.
• Reduced the number of man-hours needed to do the same work from 100 hours/week to 10 hours/week.
• Created the business plan for removing 0source_system compounding from the entire BW implementation.
• Implemented authorizations for sales reporting.
• Created a data model to identify cost reduction for prescription drugs.
• Created reports to analyze market value and sales of specific prescription drugs.

Qualifications:

• Team building/leadership Hands-on and proactive
• Excellent communication skills Resource/capacity planning
• Strong analytical skills Enterprise-Wide solutions

Education:
University, Confidential,MBA Austin, TX

• Graduated at top of the class from a top twenty national MBA program
• Honored with Dean’s award for academic excellence - Awarded for GPA greater than 3.8
• Honored with Beta Gamma Sigma award - Awarded to top 10% of the graduating class
• Related coursework: IT Management, Supply chain and Operations management, Strategic Management, Financial Analysis

Confidential,University, MS New York City, NY
Confidential,Institute of Technology Bhilai, India