ALOK MEHTA

Florida Power & Light Email:

aco7j8@r.postjobfree.com

Juno Beach, FL, 33408 cell: (216) 269

7218

http://www.linkedin.com/pub/4/492/452

SUMMARY:

. Over 10 years of experience in SAP Business Intelligence (BI) with

multiple Fortune 500 companies.

. Worked in different capacities from a Project Manager to a Solution

Architect, techno/functional consultant and offshore coordinator/manager.

. Involved in six full life cycles of BI project implementations.

. Experience in the field of ISO, 6 Sigma - Green Belt and Agile Project

Management

. Excellent technical, presentation, interpersonal, organizational,

communication and leadership qualities.

SAP BI EXPERTISE:

. Experience in Requirement gathering, Gap analysis, design, development,

testing, documentation, maintenance, troubleshooting and performance

tuning.

. Proficient in BI Design and Data modeling using ERM, MDM. APD, APO, SRM,

CRM & BW extended star schema models.

. Experience in ETL i.e. Data Extraction, Data Transferring, Data Loading

such as SAP BI and Informatica.

. Extracted from SAP ECC (FICO/PS/HR/SD/MM/APO/POS/SRM/CRM) using extract

structures such as General Legher (FIGL, CO, PS, LO-Cockpit, Generic

Extractors).

. Experience in Hierarchies, Authorizations, BW Statistics, Archiving,

Process chains and Open hub.

. BI Reporting - Experience in Design and Development of Queries, Reports,

Workbooks, Business Explorer Analyzer, Query Builder, Info Set Query, Web

Reporting, RRI, Reporting Agent and Broadcaster.

. Knowledge of Cognos Query Studio, Cognos Report Studio, Oracle SQL

Navigator, Oracle SQL Developer, and Teradata SQL Assistant

. Experience with SAP Business Objects suite - Dashboards, Web

Intelligence, Universe designer, Analysis, and Explorer.

. Experience in Customizations - Data source enhancements, generic

extractors, user Exits and Logistics Cockpit Data extraction from flat

files, Business Content Activation, Direct and Flexible update of Master

data.

. Experience in the technical and functional system upgrade from BW 3.1C to

BI 7.0 (NW2004s) and to EHP1.

. BI operations - Data load management, event processing, experience also

in Scheduling Start Process and Process Chains of Events, Data source

Enhancement, Remote Cubes, and Open Hub Service, Performance Tuning,

Aggregates, BW Transports.

. ABAP - Reporting, User Exits, Customer modifications.

. Testing - Master/Transaction data testing. End to End testing for

Technical and Functional aspects of model.

. Training - Capable of Conducting training sessions for users in BI

reporting

. ASAP Methodology - ASAP for BW project plans and Accelerators

PROFESSIONAL EXPERIENCE:

BI Principal / Architect

NextEra Energy, Inc., Juno Beach, FL

Feb' 2012 - Current

NextEra Energy, Inc., is ranked 191 in the Fortune 500 list and through

its subsidiaries, generates, transmits, distributes, and sells electric

energy in the United States and Canada. The company has 42,500 megawatts

of generating capacity and generates electricity from gas, oil, solar,

petroleum, nuclear and renewable sources. NEE has several subsidiaries

like FPL, NEER and FPL FiberNet.

Key Responsibilities:

. Developed a Supplier delivery performance dashboard with SAP

Xcelsisus, which resulted in increase in on time delivery for ~10% of

line items and ~$2MM worth of additional materials now come on time.

. Designed and developed a "Spot buy reduction" report leveraging SAP

APD module to identify materials which qualify to be moved on

Contracts based on Inventory turns and high PO counts, to reduce

buyer's processing time and get negotiated contract rates.

. Designed and developed Transmission and Distribution Inventory

forecast dashboard with SAP Xcelsius to help reduce Surplus Inventory

and meet year-end targets by providing visibility to Demand, Purchases

and Inventory data.

. Developed multiple reports on APO data for Storm pre-buy and for ABC

Material classification.

. Worked extensively on the SRM and ECC extractors for Purchasing and

Shopping Cart data

. Designed dashboards using SAP Webi to track the allocation of

expensive software licenses for recycling and compliance using

Inventory batch modeling. Team member for James Boradhead (ex-CEO)

Quality Cup.

. Worked with Power Generation group to broadcast ~180 Inventory month

end, exceptional reporting etc. resulting in elimination of 50% of a

contractor's work.

. Worked with Sourcing and Logistics leads to define and design a

savings tracker for companywide savings initiative (Momentum).

Recipient of Supply Chain Vision Award for Q4-2013 for this effort.

. Worked on Integration of Nuclear Oracle datamart with ECC data in BW

for global reporting.

. Developed several data models and dashboards to provide snap shot

reporting for Inventory trends, Surplus Demand, Reservations, Material

usage, Goods Movements reporting.

. Created outage models for Nuclear sites based on Demand to Order and

five year look ahead reports.

. Worked on Spend classifications reporting based on Accounts Payables

and integration with Procurement information and rolled out reports in

BOBJ Explorer.

. Involved in POC and HANA sidecar scenarios for Finance BPC project

. Involved in developing SAP Fiori POC apps for Material Inventory

Balances for Distribution Filed employees.

BI Architect

American Sugar Refining, West Palm Beach, FL

Apr' 2010 - Feb'2012

American Sugar Refining, Inc. is the world's largest cane sugar refining

company, with a production capacity of 7 million tons of sugar through

refineries in USA, Canada, Mexico, UK and Portugal. The company's

products are marketed through its brand portfolio that includes the

premiere sugar brands Domino, C&H, Florida Crystals, Redpath and Tate &

Lyle.

Key Responsibilities:

. Solution Architect for System Consolidation Project to get data

from different companies into single BI system and creating

scope-document, level of effort and specs for Projects.

. Project lead for BI -EHP1 Enhancement pack upgrade.

. Implemented the technical design standards and templates for

functional specifications for BI.

. Project Lead for delivering the Canada Sales and COPA reports

based on respective plant factory calendars; Implementing

Security for global implementation and for BI Performance tuning

from BI Stats cube.

. Identified the Financial extractors 3FI_SL_XX_SI (SPL Summary),

0EC_PCA_3(Profit Center Accounting), 0FI_AR_4(A/R) and logic for

custom field to meet the needs.

. Designed and documented data model design for COPA - Account and

Cost based COPA, Special Ledger and Profit Center accounting /

Costing Accounting and reported using Business Object Month end

reporting.

. Solution Architect for TLS2 Project to get data from UK and

Portugal Plants in the system.

. Involved in delivering the Trade Promotion Reports from CRM with

the ECC data.

. Implemented the standard functionality of GL and Cost

allocations, Project systems, COPA and Statistical key figures

and configured mappings to extract the balance sheet specially

formatted reports like Income statement, cost accounting

reports, and management P&L reports using BEx (Business

Explorer) reporting tools/Workbook.

. Responsible for setting up the BI Quality landscape.

. Designed and delivered the new reports for Inventory for the

Sugar Plants.

. Involved in the Customer Validation Project with SAP for the new

product of Business Objects - 'Aurora 4.0' and implemented the

new temporary landscape with the upgraded version.

. Experience with creating Business Objects Universe, Webi and

Dashboards.

Environment: SAP BW NW 04s, SAP ECC 6.0, Business Objects XI 3.1

Sr. Business System Analyst, VentureSoftGlobal, Pleasant Hill, CA

Oct' 2006 - Apr'2010

Client:

Nike Inc, Beaverton, OR

Feb' 2006- Apr' 2010

Nike Inc. is ranked 126th in Fortune 500 list and is the largest sportswear

manufacturer in the world. The company designs, develops, and markets

footwear, apparel, equipment, and accessory products worldwide. The company

also markets its products under the brand names of Converse, Chuck Taylor,

All Star, One Star, Umbro, Jack Purcell, Cole Haan, Bragano, and Hurley.

Sr. BI Consultant GIT Manufacturing Planning

Jan' 2009 - Apr'2010

The Planning Foundation - Plan 2 PO project involved divestiture of legacy

BW and Oracle objects and moving the source systems to Teradata, with IBM

Cognos as a reporting tool.

. Involved in full life cycle of Planning Foundation Project.

. Responsible for loading and validating the business config dates

for Business months / calendar in BW through flat files to ensure

correct implementation of change in business processes.

. Responsible for maintaining BI cubes- Material Closeouts, PAR

(Product Availability Report) and NAR (Non Availability Report)

using Inventory, Sales and Delivery data.

. Involved in the front-end reports migration from BW 3.5 to BI7

. Created the Data Definition Specifications for sourcing the

existing Oracle table to Teradata for the Product view table.

. Involved in end to end validation for Product views in Teradata

using Teradata SQL Assistant, SQL Developer and SQL Navigator.

. Perform requirements gathering workshops with business leads and

developed Report Specs.

. Developed Reports like "Confirmed Transfers", "Scenario Sourcing",

"FGCT- Finished Goods Capacity for Tooling" in Cognos Report Studio

and Cognos Query Studio.

Sr. Business System Analyst Nike - GBI Sales Phase II

Apr'2007-Dec'2008

The Global Business Intelligence Project involved transition of EMEA

countries into B3 systems, implementation of Business Intelligence

Accelerator and SAP BW upgrade to SAP BI7.

. Involved in the full life cycle development of "EMEA" Sales

Project.

. Created functional specs for Sales, based on HLDs and served as a

key liaison to work with Architects, Technical-lead and Functional

-leads to ensure robust cross-functional design.

. Involved in Upgrade from BW 3.5 to BI7

. Involved in implementation of BIA - Business Intelligence

Accelerator for Sales multi-providers.

. Developed the "Hard-delete" DSO to capture deleted sales orders in

BW.

. Responsible for consolidating multiple BW systems into a single

system, with migration of workbooks, user exit codes, roles,

authorization and underline data-base due to BIA implementation.

. Involved in data conversion for EMEA Freeze -Sales snap shots

history from Oracle database to BW.

. Performed validation against the legacy system - Oracle by writing

and running SQL Scripts to ensure smooth migration and divestiture

into BI system.

. Deliver a new and improved Web BEx template for Americas Sales

reporting.

. Involved in the Governance process of Global Content creation

development.

. Prototyped Reports using new Front End tools in 2004s/BI-7

environment and evaluated new Front End tools.

. Used NW 04s Broadcaster functionality to email the important

reports to the top level management.

Sr. Business System Analyst Nike - GBI Tier 3 and Sales Production

Support Nov'2006 -Apr'2007

The Global Business Intelligence Tier 3 involved business funded Sales

projects and Production support.

. Analyze and set priorities for all Tier-3 Sales Reporting gaps /

enhancements and support requests.

. Manage Relay tickets and obtain PM and CCB approvals for

development and deployment of fixes.

. Monitor and analyze sales batches and recommend performance

improvement measures.

. Created workbooks like "AMER SGF Country", "Cancellation Impact

Analysis", "Amer AAF Customer" etc.

. Created reports like "Rejection Analysis", "Top 10 Reports by

Style, Material, and Color", "Manage Un-priced Materials", "Daily

Flash Reporting" "Product Availability" etc.

Business System Analyst, Compugra Systems, Inc. Newark, DE

Jul' 2005 - Oct'2006

Client:

Nike Inc, Beaverton, OR

Business System Analyst Nike -GBI Sales Phase I

Feb'2006-Oct'2006

The Global Business Intelligence Project involved transition of Latin

America countries into BW systems and implementation of Global "Freeze

Logic" which reports to Wall-Street.

. Involved in the full life cycle development of "Americas" Sales

Project.

. Created functional specs for Sales, based on HLD and served as a

key liaison to work with Architects, Technical-lead and Functional

-leads to ensure robust cross-functional design.

. Designed, developed, and validated the "Freeze Process"; the output

of this process is reported directly to "Wall-Street" involving

future sales order details.

. Created "Test-Harness" for ongoing Data Quality, since the critical

reports of "Wall-street" and incentives of "Management

Representatives" were computed from the Sales cube.

. Key team member of "DAT" - Data Alignment team for the Global

solution.

Environment: SAP BW NW 04s, 3.5, SAP R/3 4.6

Client:

Allstate Insurance Company, Chicago, IL

Jul' 2005 -Dec' 2005

SAP BW Consultant

Allstate Insurance Company is ranked 47th in Fortune 500 list with around

$150 billion in assets. The company has 13 major lines of insurance in 49

states and Canada.

Key Responsibilities:

. Served as key link between onsite and offshore resources.

. Created several Claims, Premiums, Sales and Expense Actual and Plan

Info Cubes and ODSs.

. Created many aggregates on the basis of catastrophes and locations.

. Wrote several transfer rules and update rules to support the

business logic and conditions.

. Expert in flat file extraction of master data and transaction data

of Non-SAP R/3 systems into BW.

. Extensively worked on BEx analyzer for creating various queries,

workbooks and views. Published queries on web. Worked on Business

Explorer and Web Browser.

. Worked on conditions, formulas, RRI interfaces, filters, drilldown

methods.

. Defined exceptions using exception monitor and added exception

entries in report monitor by scheduling the packages.

Environment: SAP BW 3.5, SAP R/3 4.6

Recognitions and Trainings:

. Recipient of FPL - Integrated Supply Chain vision award for Q4-2013

for designing and developing the Momentum savings tracker tool.

. Participant of James Broadhead (ex-CEO) Quality Cup for Software Asset

Management Project at FPL.

. Trained in Web Intelligence and Universe Design course's by SAP.

EDUCATION:

. M.S. Industrial Engineering

Cleveland State University - Ohio

Reference: Available upon request. / http://www.linkedin.com/pub/4/492/452

Contact this candidate