BI Principal / Architect
Resume:
ALOK MEHTA
Florida Power & Light Email:
**********@*****.***
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