SUMMARY:

• Delivering Agile and Sustainable Business Intelligence and Performance Management Solutions SAP BPC/Business Intelligence Solution Architect
• Expert in the development and deployment of on premise or cloud - based business intelligence, reporting, planning, and consolidation solutions.
• Well versed in requirements gathering, agile software development, configuration management, project management.
• Innovative and solution driven, highly adaptable, can lead the team doing the work or can roll-up my sleeves and do the work myself.
• A natural communicator with a comprehensive understanding of financial statements, reporting and the technical infrastructure to support them.
• Able to build rapport with users at all level within the community.

FUNCTIONAL AREA PROFICIENCIES:

• Bottom-up and top-down planning
• Integrated models with profit and loss, balance sheet, cash flow, tax, and treasury functions
• Corporate Performance, KPIs, dash boards, and custom reporting initiatives
• Consolidation, Eliminations, Currency Translation, CTA, Trading Partner reporting, Intercompany, Joint Venture Accounting, Escalation and Minority Interest Planning Models
• Automation of master data management with SSIS packages
• SSIS package development
• Process chains development
• Custom application development
• Multiple coding language background
• Expert in SQL, ETL, transformation
• Interfaced with multiple systems including SAP ECC, Oracle Financials, Peoplesoft, JDE Oneworld, Dynamics, Great Plains, iVantage, Solomon, Endura and others
• Experienced in all phases of software development life cycle and ASAP methodology
• Fluent in all aspects of configuration management in multi-tier environments including sandbox, development, QA, pre-prod and production environments with several transport management systems
• Have supported user communities with sizes ranging from a handful to over 15,000
• Disaster Recover planning and testing
• Experienced in all aspects of general ledger accounting, financial statement analysis and reporting - financial statement preparation, analysis, summarization, account reconciliation, closing, General Ledger, Journal Entry, financial statement audit, tax planning, comparative analysis, closing, custom sub-ledger interfaces including inventory, cost allocations, payroll and benefits, accounting system conversions, accounts payable, accounts receivable, and capital and project accounting systems.

TECHNICAL PROFICIENCIES:

Platforms/DB: Windows, IBM AIX, Linux (Redhat) and Unix, SQL Server, Oracle 7-11g, Sybase 10, VM Ware Configuration and Support

Tools: / Languanges:: C, PL/SQL, Transact-SQL, ASP, HTML, XML, Java, Javascript, VBScript, .Net, VBA, Kornshell, SED/AWK, Vi Editor, Pro*C, Pro*Cobol, Microfocus Cobol, Com+, SQL Server 2005/2008/20112 BI/Visual Studio, Oracle Forms/Reports, Microsoft Excel, PowerPoint, Word, Access, Visio, Erwin, Powerbuilder, Packages, Procedures, functions, DML, DDL, Enterprise Manager, Query Analyzer, Toad, AllRound PL/SQL Developer, UltraDev IIS, PVCS, Visual Source Safe, Microsoft Team Foundation Server, SCCI.

BI, ERP, and other systems: SAP BPC (Microsoft and Netweaver - 10.1/10/7.5/7.0/5.1/4.3/4.2/4.1 ), BW (7.3/7.4/7.5), Business Objects, Webi reports, Analysis for Office Client, Excelsius, Solomon, Oracle, Great Plains, FRX, PeopleSoft, JDE OneWorld, Ivantage, Softrax, Hyperion, HFM, FI, CO, MM, SD, BPC, BW, ABAP, ABAP OO, BPC, BEX, Confidential, PS, Confidential, COPA, Master Data, HR, ECC, Transport Expresso & Rev Trac transport management systems, Function Modules, Expert Transformation Routines, programs, reports, process chains, custom start/end routines, Security profile development, testing, Multi-Providers, automated master data loads.

PROFESSIONAL EXPERIENCE:

SAP BPC Solution Architect/Lead

Confidential

Responsibilities:

• Design, architect and implement planning solutions using SAP BPC (Microsoft and Net Weaver (10.1, 10, 7.5, 7.0, 5.0, 4.2) solutions for clients and consultancies as projects arise.
• Have completed over 30 implementations and mainly serve as the solution architect in designing and delivering budgeting, forecasting, planning, consolidations, reporting, daily sales, HCM, CAPEX, Debt Instrument, and other application.
• Source systems that I’ve worked with to integrate data with include data warehouses, data marts, raw data files, SAP (R/3 and ECC), Oracle Financials (10 and 11), Great Plains, FRX, Solomon, JDE Oneworld, Business Objects, PeopleSoft and Ivantage HR systems.
• Projects generally follow ASAP methodology or SDLC depending on client protocol.

Enterprise Systems Analyst

Confidential, Englewood Cliffs, NJ

Responsibilities:

• Support system after go-live
• Close out hypercare with documentation and knowledge transfer to key resources.
• Continue with targeted report development and as requested
• Provide daily status reporting to project management on report development providing status, issues and outlook

Senior SAP BPC Report Developer

Confidential, Melbourne, FL

Responsibilities:

• Devise and implement strategy for managing data loaded from Confidential into profit center combined views within BPC. Devise and implement strategy for splitting revenues and costs for some profit centers to support required reporting
• Develop reporting hierarchies for Park financials including Balance Sheet, Income Statement, Budget, Forecasts, and Revenue Operations at the park level, venue level and functional area.
• Developed operational reporting including venue/functional area profit and loss statements, general manager consolidated reported, park area/park consolidated reporting across multiple parks, coding of custom metrics on reports, use of VBA macros and conditional formatting and custom logic to support custom reports
• Maintain master data in both Quality and Production environments using specified roles in each environment. Synchronize environments, manage updates and reporting of completion, devise and maintain rollback strategies.
• Develop strategy to support reporting of daily budget and actuals using multiple calendars. Implement strategy and reconcile data between calendars to prove that the solution is working.
• Develop over 35 reports often validating existing reports against prior reports from system being replaced
• Interface data between models using application logic, write logic to ensure synchronization of actual and budget data loads across reporting landscape, reconcile/troubleshoot differences
• Review and approve transport migration through Transport Espresso - record results, approve transport, manage conflicts, report status
• Provide daily status reporting to project management on report development providing status, issues and outlook

SAP BPC Solution Architect

Confidential, Columbus, OH

Responsibilities:

• Develop revised calculation for Sales Quotes to handle product discounts and how they are reported resulting model level revenue calculations in Gross Profit planning. Update interfaces between Cost Per Unit models and Budgeting Cubes for gross profit calculation.
• Architect solution to revise 5-tier product hierarchy and its automated maintenance from ECC through BW as used by 6 different BPC models
• Design, develop and supervise testing and deploy a write-back BADI in a project system model in BPC to improve master data management and better manage currency conversion. Using ABAP OO principles to develop multi-method class to manage aspects of write-back processing for updates to product and profit center based on business rules.
• Implement new project system model hierarchy in BPC and BW and automate its load in process chain and automated scheduling tools as well as update calculations used in BW report in both BOBJ objects and BEX Queries
• Develop BOBJ Report, BEX Query, InfoCubes, and control tables and custom TCode in ECC, develop security protocol (object authentication) and roles for Confidential .
• Develop Function Modules and Custom Expert Transformation routines to replace existing BW data mart with custom DSOs and SPOs for AP Activity by GL report in BW. Function modules replaced source data for original report and integrated it with new data source from FI GL. Write FM, expert routines for proof of concept and then develop and deliver complete solution. This eliminated the need to load data to separate cubes with separate field extensions from different FI GL data sources and unified them in one source without impacting report performance.

Confidential

Manager - SAP Practice

Responsibilities:

• Developed the LNG model and production models with all components - including input schedules, reports, SSIS packages and data interfaces. Schedules included custom calculation logic, use of VBA macros and custom formatting as required to support business model. Work with business team to test and deploy to production.
• Some of the complex functionality included in the production planning model included contract entry, allocation production volume to contracts and spot contracts managing available for sale resources with the calculation of revenues and costs with custom pricing.
• Assisted with development of custom treasury module that managed capturing and reporting of financing activities for the Australian Business Unit.

Confidential

SAP BPC Solution Architect, Houston, TX

Responsibilities:

• Planning Suite Upgrade and new development for Confidential - 3 model complex solution with multiple enhancements and upgrades, Integration with Confidential, Rewriting of Support Models, implementation of cost allocation model
• Revise reporting strategies across all models, automate data interface with GL for expense data, develop custom cost allocation rule processing engine, integrate BPC and Confidential security using custom package that allowed administrators to maintain data access profiles by model without having to interface with admin client - thus dividing proper roles between IT and Business for data access profile management and maintenance