SUMMARY:

• Over 15 years experience in IT, mostly in Project or Team Lead positions.
• Over 14 years experience in SAP with 10+ years in BW as functional and technical consultant to Domestic and International companies.
• Project lead experience on small and large scale implementations
• Experienced in the full life cycle implementation of SAP BW/BI, SEM - BPS, Integrated Planning (IP), CRM, SAP R/3 and ECC Projects for SD, FI/CO, SCM, Purchasing and MM.
• Experienced in mySAP™ ASAP methodologies.
• Expertise in configuring and setting up the SAP BW environment including Data Architecture, Extraction Process, and Data Access Process, Data Mining Models, BI Accelerator / TREX 7.0 & Overall integrated design and realization of the BW solution.
• In depth knowledge in LO Cockpit, LIS Extractors, FI Extractors, BW User exits, Custom Cube Designs, BW Adapters for CRM, Web Application Designer, BW-BPS, BI Integrated Planning and Netweaver 7.0 (2004s).
• Experience with BW 7.3, BusinessObjects 4.0 toolsets, Crystal reports 2008 & 2011, Xcelsius, SAP BOBJ Dashboards, Design Studio and SAP Lumira
• Recently Trained in SAP HANA via TZHANA and HA300 (certification pending)
• Experienced ABAP Programmer with excellent troubleshooting and debugging skills
• SAP expertise spans across multiple modules and BW versions.
• Well versed in Finance applications especially general accounting and cost accounting principles
• Experience with project planning tools Microsoft Project and NIKU/CA Open Workbook
• Former Legacy Systems Analyst and Programmer
• Embraces and researches new technologies.
• Results-oriented, self-managing team player with outstanding communication & presentation skills.

SAP MODULES/PLATFORMS:

• BW - Business Information Warehouse FI - Financial Accounting
• SEM & BW BPS - Bus. Planning Simulation CO - Controlling
• SD - Sales & Distribution WM - Warehouse Management
• MM - Materials Management CRM- Customer Relationship Mgt
• Netweaver BI 7.0 & BI 7.3 IP - BI Integrated Planning
• BusinessObjects Edge 4.0 Xcelsius 2008
• Crystal reports 2008 & 2011 Dashboard Design
• Business Objects Explorer SAP Lumira

PROFESSIONAL EXPERIENCE:

Confidential, Sandy Springs, GA

SAP BI Technical Consultant

Responsibilities:

• Incorporates year-over-year performance vs. inflation reporting;
• Provides Current vs. Plan vs. Outlook reporting;
• Publishes KPIs daily via Business Objects Explorer and SAP Lumira
• Tracks claim reimbursements;
• Identifies freight move and expense components of business movements;
• Tracks customer ordering performance
• Created BW Production Variances Reporting solution for FI Acccounting. This solution was built with the following goals in mind.
• Include production variances in Sales reporting for simulated actual cost of sales.
• Report by die over several periods, several plants and compare variances.
• Reporting in Bobj Explorer, BoBj Analysis for Excel and SAP Lumira via IDT Universe
• Explain by month the cause of the variance amount posted to the GL on the trial balance:
• Price difference, quantity variances, lot size, substitutions, etc…
• What caused the variances: board, packaging, labor etc…
• Production Variance Financial Postings (settlement)
• Total balance by order by period
• Order level only
• Production Variances Categories in PA (settlement)
• Categories by order by period
• Order level only
• Production Variances Details (SAP Lumira reporting)
• Categories by order by costing line items:
• Combination of GL/cost element & origin
• Cumulative values only
• Portal interface for uploading data
• WAD template with multiple tabs to support reports and input-enabled queries for Integrated Planning
• Calculations DSO to hold actuals that are read to determine 3 month moving average for sales. tons and quantities sold
• Created pricing DSO for uploading prices monthly for dies/materials
• Multiple process chains to support process
• 3 different aggregation level to support real-time updates and other functions
• 2 Cubes for Outlook (staging and working)
• 3 different multiproviders to support different reporting scenarios
• Created Annual sales load cubes and process to offload aged data to created more efficient reporting. Years
• Remodeled multiple cubes to add NEW keyfigures so as not to have to empty and reload cubes
• Multiple reports for new process
• Built prototype for sales reports and dashboard using Design Studio 1.0

Confidential, Sandy Springs, GA

SAP BI Consultant

Responsibilities:

• Interacting with Business Users, Business Owners to know their Business views in developing and modifying reports accordingly.
• Resolved defects in existing reports.
• Validated Test Plans and Documented the Defects.
• Rebuilding BW queries
• BW 7.3 backend design and maintenance

Confidential, Marietta, GA

SAP BI Technical Consultant

Responsibilities:

• 2 First level DSO’s (one for each source for raw data)
• 2 Second level DSO’s (where complex transformations are performed via start routines)
• 3 Transformation Start Routines (2 for ECC extractions 1 for file uploads)
• 3 Real-time Cubes (1 each for COPA and Altivity data)
• 1 Consolidated data Cube (merges COPA and Non-SAP data)
• 1 Consolidated Reporting Cube
• 1 Consolidated Reporting Multiprovider
• 2 Infosets ( for specialized reporting and verification)
• 9 Integrated Planning Aggregation Levels
• 2 BPS Planning Areas
• 28 BPS Planning Functions (consisting of reposts, copy and delete functions)
• 2 Web Application Designer templates to support multiple IP repost functions
• 2 IP Repost functions to allow changing of up to 20 Characteristics simultaneously
• 26 Function Modules (mainly user exit variable processing for BPS & IP)
• 45 queries and workbooks to report on various metrics such as; Act vs Plan sales, by customer and plants, customer and market net sales analysis, customer and product profitability and more

Confidential, Houston, TX

SAP BI Consultant

Responsibilities:

• Developed solution for Inventory Cost of Production ( Confidential ). The Confidential solution called for BW Queries to be used to generate components used in Book and Tax Cost of Production. Components consists of several different costs and quantities used.
• The resultant key figures from the BW queries needed to be loaded back into R/3 to calculate the Cost of Production in “dollar per Kg” or “dollar per SGG” terms for Book and Tax purpose. Over a dozen files were generated from the queries.
• This task was developed in BI 7.0. The solution was accomplished using multiple BW Queries, Analysis Process Designer (APD), custom ABAP (for variables) and Event driven Process Chains executing RSAN PROCESS EXECUTE

Confidential, MELVILLE, NY

SAP BI Consultant

Responsibilities:

• Utilized as BI help desk support. Initially verified BWQ system configuration. Re-built BWD systems from BWQ after a botched system copy from BWD. Performed backwards transports from BWQ to BWD.
• Maintained and fixed numerous process chains that were inactive and broken after system copy.
• Detected defects and provided solution within Integrated Planning txn ‘rsplan’ web dydnpro. Detected and provided solution to correct transport errors due to transport log being filled. Wrote ABAP class/program to remodel custom MM cube for Confidential addition.
• Wrote ABAP program to populate Confidential in Sales DSO. System is SAP Netweaver BI 7.0 and SAP ECC 6.0
• Assigned to the PLM+ project in Falls Church, VA. As the Solution Architect and Lead Developer for Business Activity and Dashboard Monitoring solution. Created the solution in NetWeaver BI environment. Software applications for this project utilized SAP XI, SAP BI 7.0, SEM-CPM Management Cockpit and Balance Scorecard, BW-BPS, BI Integrated Planning, Visual Composer and Web Application Designer. All reporting and cockpit info published to secured portal. Project is classified.

Confidential, GREENVILLE, SC

Sr. SAP BW/SEM Consultant

Responsibilities:

• Created first Sealed Air Bex reporting solution using ‘dynamic variables’ via user-exit that greatly increased query performance on multiproviders by excluding those infoproviders that did not meet the criteria defined by the bex variable.
• Created first Sealed Air BPS solution to automate the period closing and locking the RE months in planning layouts for rolling forecast using a combination of BPS user exit and custom BPS derived variables.
• Created custom transaction and role menu to allow users to maintain certain master data objects without IT intervention. Developed using ABAP and creating IViews. Accessed via Portal
• Wrote functional specs for second phase of project
• Was able to detect and resolve risk and problems in a timely manner
• Created custom transaction to activate certain master data objects without IT intervention. Developed using ABAP and creating IViews. Accessed via Portal
• Assisted BI 7.0 upgrade team with migrating roles and authorizations
• Assisted BI 7.0 upgrade team with BI Integrated Planning setup and testing
• Created BPS re-post/re-alignment functions. Accessed via Portal
• Created function for users to activate and de-activate Dataslices via Portal
• Created first application to execute BPS planning sequence in background
• Created custom program and user interface to schedule & execute process chains
• Created several start routine function modules in transfer and updated rules.
• Modified BSP applications to generate custom messages on errors and when application saved
• Performed detailed technical documentation of all BW-BPS Portal applications
• Developed ABAP routines at info source level and update rule level for data manipulation and restriction
• Performed evaluation of Visual Composer as part of BI 7.0 upgrade for Resin cost and indices management reports.
• Interacted with the project team and end users for designing the data models
• Created custom program to allow BW transport administrator to see the contents of BEX transports.
• Managed transports

Confidential, ATLANTA, GA

SAP BW/SEM Development Lead

Responsibilities:

• Helped to ensure that project milestones & deadlines were met
• Worked closely with the business resources during Gap Analysis thru Integrated testing to Go-live.
• Addressed and handled post go-live issues
• Conducted several lessons learned forums
• Wrote functional specs
• Architect and designer for MCP system.
• Ensured that SAP Best Practices were followed
• Periodically conducted team building events such as; luncheons, bowling and laser tag.
• Wrote or modified project plan for blueprint realization, go-live and post go-live training and support
• Effectively managed scope creep by highlighting or explaining the technical and resource requirements for any additional inclusion to the core requirements after realization
• Kept team motivated by listening to and understanding their concerns
• Built strong relationships with Basis and other Change management personnel which enabled us to get tasks/transports expedited when needed.
• Was able to detect and resolve risk and problems in a timely manner
• Reported to the steering committee monthly.
• Managed transports
• Co-chaired weekly status meetings
• Assisted in resource planning
• Trained 48 North America finance plant managers on usage of MCP system and performing RE and ABP functions
• Conducted training workshops in Europe for 32 Commercial Products Supply finance managers on international MCP system and performing RE and ABP functions
• Designed and developed specs for junior team members and offshore team
• Team/Project Lead on multiple BI projects during tenure
• Managed team of several developers and functional members thru multiple projects
• Designed and developed Manufacturing Cost Planning solution for CPS & CCNA
• Created first Coca-Cola BPS solution using ‘dynamic variables’ via function modules for planning area selection.
• Created first Coca-Cola Bex reporting solution using ‘dynamic variables’ via user-exit that greatly increased query performance on multiproviders by excluding those InfoProviders that did not meet the criteria defined by the bex variable.
• Created first Coca-Cola BPS solution to automate the period closing and locking the RE months in planning layouts.
• Created first Coca-Cola BPS solution to use custom transactions to for accessing planning folder transactions instead of standard UPSPL transaction.
• Created method to automatically clear and refresh user variables in BPS.
• Created function for users to activate and de-activate Dataslices via Planning Folder
• Created user interface solution to activate and de-activate dataslices.
• Designed and developed custom BPS allocation solution to allocate dollars and percentages across multiple cost centers.
• Designed and developed multiple BPS planning layouts in ALV & Excel
• Designed customer-specific BI Integrated Planning functions for copy and revaluate
• Designed and developed multiple BPS planning folders including web apps
• Created first application to execute BPS functions in background
• Designed and developed multiple BW InfoProviders and related objects
• Lead BW/BPS architect on multiple projects
• Helped design security authorization roles for multiple projects
• Helped configure RFC connections
• Assisted production support when asked in an advisory role
• Technical consultant to multiple groups within the Coca-Cola BI organization

Confidential, BOCA RATON, FL

Sr. SAP BW Consultant

Responsibilities:

• Design, creation, and maintenance of custom InfoObjects, InfoCubes, MultiProviders, ODS Objects, DataSources, User Exits, InfoSources, Update Rules, Transfer Rules, and Communication Structures.
• Develop InfoPackages, DataSources, Transfer Rules, Communication Structures, Update Rules and Start Routines to load source data from R/3, flat files and ODS objects into Master Data, Text, and ODS Objects. Also developed custom R/3 and CRM extractions (Marketing Attributes and Batch Characteristics).
• Created ODS’s for CRM - Activities, CRM Marketing - Lead Header Data, Lead Item Data, Leads Management, Opportunities, Quotes, Sales and Sales Promotions
• Designed and built custom solution using multiprovider technology joining 0BPARTNER, 0CUSTOMER & 0BP REL ODS .
• Created views and R/3 generic extractors for KNB1 Customer Master (Company Code, KNVP Extract for Partner Functions.
• Created view and R/3 generic extractor ZBW KNKK EXTRACT (KNKK Extract Cust. master credit)
• Created process chains for CRM and R/3 Transactions and Master Data
• Performed activation of business content for CP Analytics TPM and provided analysis to identify key benefit areas including field account planning, sell-in and negotiation, retail execution, validation and settlement, and evaluation and analysis.
• Enhanced Multiple TPM Planning functions including but not limited to Copy Actuals ( 4TPM9151) created several TPM planning functions for rolling estimate planning off of 0CP SLSC7 and 0CP SLSCA
• Created custom clone of 0CP SLSC8, VPKBC08 for Confidential Promotions Knowledge Base cube.
• Created custom clone of 0CP SLSC1, VSLSPC01 for Confidential Sales Promotions cube.
• Discovered bug in SAP function module CRM BW OPPT H MAP and fixed
• Activated and maintained settings for CRM BW adapters
• Researched and discovered gaps with BW business content release and provided recommendation
• Created over 60 custom InfoObjects for CRM and R/3
• On-going validation of all update rules and transfer rules
• Provided guidance to basis in correcting time stamp issue
• Fixed alpha conversion issues as they were discovered
• Researched and devised new logic to properly retrieve and update CRM marketing attributes, which are similar to batch characteristics
• ABAP Programming: Prepared detailed specifications from which programs were written, and participated in impact and detailed design documentation. Write/configure programs and function modules based on detailed designs.

Confidential, SAN FRANCISCO, CA

Sr. SAP BW Consultant

Responsibilities:

• Performed analysis, design, development and implementation of standard/ customized InfoCubes and ODS Objects for MM modules.
• Wrote functional/technical specifications.
• Modeled and built 13 custom InfoCubes for Marketing Analytics solution.
• Modeled and created 112 custom InfoObjects.
• Created InfoObject catalogs, application packages, function groups and other components of BW.
• Created multiple queries for training the Marketing Analytics Data Mining Clustering model.
• Assigned time-dependency and navigational attributes on all InfoObjects
• Maintain and create Aggregates and Hierarchies.
• Created Communication Structure, Transfer Structure, Transfer Routine, Update Rules (both ODS and InfoCubes) for all InfoProviders
• Created 3 ODS objects to feed the InfoCubes for Marketing Analytics.
• Created 3 MultiProviders to give various views of data from reportable InfoCubes and ODS objects.
• Used Data Mining classification method of clustering to determine which customers would be susceptible to new marketing campaigns.
• Created 4 function modules that are used in start routines to facilitate master data lookups during load process.
• Created custom ABAP to retrieve BW master data from 0POSTAL CD, massage and re-load to BW.
• Created data marts from CO/PA cubes to feed the Marketing Analytics custom InfoProviders.
• Come up with solutions to handle the timing and high volume of the data. I.e. Creating persistent staging cubes and monthly staging cubes.
• Built all InfoPackages for extraction from datamarts & Ascential’s Datastage extractors.
• Created InfoSet for master data to enable querying on data.
• Created 33 Process Chains with program variants to automate the loading of data.
• Debugged failed data loads and repaired.
• Set up logical file definitions for flat-file loads from Application Servers (UNIX) via FILE transaction.
• Analyze and communicate issues, including problems with data integrity, data design and functional and technical issues.
• Resolved production support issues.
• Involved in gathering user requirements along with the Project Manager.
• Come up with Performance tuning which involves running Compressions on Cubes, DB Statistics, and Drop and re-build Indices during data loads, Built Aggregates.
• Supported the on-going enhancements, and migration of the enhancements into Production environment.
• Designed and developed Complex Queries with workbooks for Marketing Analytics solution using Query Designer and Web Application Designer.
• Trained others in little known tips & tricks in BW (FILE, RSRV, Transport Organizer expert tool, ABAP workbench, BW shortcuts etc.)