PROFESSIONAL EXPERIENCE in SAP BW Total Duration: March 2014 – October 2016

American Railcar Industries, May 2014 – September 2016 St. Louis area, MO

Lead SAP BI Architect

Part of re-implementation team brought in during the blueprinting phase and put directly in charge of bringing up reporting for go-live phase.

Worked intensively with functional groups (PTP,RTR and OTC) to source data in SAP ECC modules (FI, SD, MM, CO, and PP)

Worked with business groups to gather reporting requirements and maintained documentation through development and realization phases

Collecting objects for transport and coordinating with BASIS team as objects were moved between clients.

Debugged start and end routines inside of transformations

Interfacing with end-users to update them on the status of reporting requests and level of completion

As third-party consulting company was brought on board for the implementation, interacted with consultants in order to ensure project was on-track for “go-live” date

Created generic and custom datasources and extractors for the purposes of enhancing reporting structures (DSOs, OLAP cubes and MultiProviders)

Utilized BI Statistics in order to monitor BI system load; made changes to infoproviders and queries in BI to optimize runtime and prevent crashes

Troubleshot issues concerning transporting objects and transformations, DTPs from one client to the next in each stage of the development, testing and realization phases of the re-implementation project

Installed standard and custom queries using BEx Query designer for the purposes of enhancing overall visibility of production and financial standing of ARI

Built and maintained functional and technical specifications of custom reporting structures needing to be built for the overall solution

Documented dataflows for BPC implementation and the structures (OLAP cube and DSOs) needed for financial forecasting and planning

Responsible for Unit, String and Integration testing of BW system

Insuring Master Data and Transactional loads in DEV and QA environments for testing purposes; troubleshooting and documenting any issues as they arose

Designed and tested security parameters around queries developed in Business Explorer; ensuring that report users at various plants would have access to the proper data set for their reporting area

Connected Tableau server to publish dashboard to a central location for portal integration.

Connected Tableau server with share-point portal and setup auto refresh feature.

PROFESSIONAL EXPERIENCE Finance and Accounting Total Duration: March 2005 – February 2009

APQC, Houston, TX October 2008 – February 2009

Analyst - Custom Benchmarking Group (Contract)

Compiled and verified survey data in MS Excel, analyzing data set for anomalies and collaborated with project managers and director to generate customized client reports based on survey results.

Streamlined score reporting process in APQC’s Smart Grid survey initiative thereby drastically reducing turnaround time in reporting survey results.

Merchants Metals, Houston, TX October 2007 – April 2008 Staff Accountant (Contract)

Collaborated with Assistant Controller in updating bank reconciliations and posted adjusting entries to general ledger.

Reconciled inventory-in-transit accounts for company’s business units and compared to reports in Merchants’ general ledger utilizing MS Excel; submitted necessary adjusting journal entries for review by Assistant Controller.

Delaware Investments, Philadelphia, PA August 2007 – October 2007

Accountant / Researcher – Institutional Accounting (Contract)

Identified and resolved interest and dividend payment discrepancies between Delaware’s (the Bank) general ledger and custodian accounts.

Reconciled daily cash and short-term investment funds in client bank accounts against the Bank’s general ledger.

JP MorganChase, Christiana, DE (Greater Philadelphia area) June 2007 - July 2007

Staff Accountant – Prime Brokerage Accounting Group (Contract)

Prepared daily reconciliations of trading activity for selected prime brokerage clients.

Compiled information needed to make general ledger adjustments for mortgage-backed securities.

CDI Corporation, Philadelphia, PA March 2006 – June 2007 Treasury Analyst – Cash and Credit Department (Contract)

Produced weekly report of CDI’s gains and losses in operations and investment accounts

Created and updated working model of treasury banking fees that saved company over $10,000 in FYE 2006.

Public Financial Management, Philadelphia, PA March 2005 – November 2005 Consultant – Quantitative Strategies Group

Responsible for the creation and update of debt profiles for state and local governments and screened each profile for potential debt refunding

Constructed analysis of assets and liabilities of a city government to establish optimal variable and fixed rate debt structure of an additional $300MM debt

UBS Investment Bank, New York, NY May 2003 – August 2003

Analyst - Restructuring Group (Summer Internship)

Analyzed balance sheet implications $300MM debt restructuring plan for a technology company

Researched prospective multimillion–dollar corporate clients and prepared internal briefing documents for each

client.

EDUCATION

DePaul University - Chicago, Illinois, Master’s in Business Administration (MBA) in Finance March 2012

Morehouse College – Atlanta, Georgia, Bachelor of Arts (BA) in Accounting; Economics minor December 2004

COMPUTER SKILLS

Microsoft’s Excel, Access, PowerPoint, Internet Explorer and Word, General Ledger Accounting, Data/Finance Analysis, VBA, Bloomberg, DBC, Oracle Discoverer, COGNOS, CPORT, Lawson, SQL

Contact this candidate