PROFESSIONAL SUMMARY:

Over 10 years of experience focused on Corporate Performance Management Systems in consolidation, planning, forecasting, budgeting and management reporting and analysis. Completed 7+ full life cycle implementations focused on SAP Confidential / Outlooksoft applications version EPM 10.0, 7.5 NW & MS, 7.0 NW & MS, 5.1 MS, 4.2 MS.

AREAS OF EXPERTISE:

• SAP Confidential application design, implementation, testing, and administration
• SAP Confidential integration expert with BI, ECC, and other ERP sources
• SAP Business Objects Xcelsius Dashboards (BOBJ)
• Microsoft SQL Server, SSIS, DTS, T - SQL, PL-SQL
• NET, XML, Java, Java-Script, VB-Script
• BI Open Hub and Process chains

TECHNICAL SKILLS:

SOFTWARE: SAP Business Objects Planning and Consolidation OutlookSoft 4.2, 5.1, 7.0,7.5 and BI

LANGUAGES: Advanced Excel and MS office skills including MS Project. Advanced MS SQL, AS, SSIS, & Reporting Services.

EXPERIENCE:

Confidential

Managing consultant (SAP)

Responsibilities:

• Architect for SAP Confidential 7.5 to EPM 10 Migration/Covnversion
• Design and implementation of Confidential and BW objects
• Design and Implementation of integration objects: Confidential /BW

Confidential

Managing consultant (EPM/SAP)

Responsibilities:

• Modeled Dimensions, Properties, Applications, Security as per design
• Performed multi currency conversion using Business rules and application script logic
• Developed input schedules for budgeting, forecasting, planning and adjustments
• Configured Business Process Flow (BPF) to provide consistent process across organization
• Created conversion and transformation files for loading transaction and master data from BI
• Created Journal templates to book adjustments
• Implemented Securityand User access using Applications, Task Profiles and Member Access Profiles
• Promoted/Transported objects to upstream environments using STMS
• Created custom Process chains, Data Manager Packages and performed data loads
• Built and designed BW objects for source data loads to BW and Confidential cubes (Staging layer)
• Configured Drill Through to BI and ECC
• Developed Xcelsius dashboards for executive cockpit to report KPIs at various aggregations

Confidential

Senior Consultant

Responsibilities:

• Worked closely with the following clients to implement SAP Confidential solutions, with a focus on leveraging best practices.
• Full life cycle implementation of SAP Confidential 7.0.
• Implemented standardized enterprise-wide Finance procedures, processes, and integrated tools which include aligning of planning, forecasting, and reporting processes across all ConAgra’s businesses.
• Created new applications in Confidential 7.0 with 5 cubes (applications) and 30 dimensions with multiple hierarchies, MDX formula, scripting logic, and over 100 reports and input schedules.
• Configured approval status for managing and systemizing the client’s planning and monthly closing processes.
• Designed and built enterprise financial consolidation, P&L and Balance Sheet planning solutions for Finance and Marketing
• Designed and developed all elements of the solution; dimensions, cubes, scripts, and security model (30 dimensions, 5 cubes for over 300 users)
• Developed scripts for calculations, allocations, and data movements utilizing SQL scripts, Confidential ScriptLogic, and MDX
• Developed and configured an Intercompany Elimination utilizing Allocations
• Developed production support, escalation plans and decisions tree for help desk and advanced support teams
• Configured currency translation with multiple reporting and input currencies to deliver an integrated global planning and reporting platform
• Provided knowledge transfer and documentations to the client
• Developed SSIS with Confidential custom tasks for Master data and cubes data automation
• Migrated existing cubes and applications from Confidential 7 MS SQL 2005 to Confidential 7.0 MS SQL 2008

Confidential

Responsibilities:

• Full life-cycle implementation
• Migrated existing OutlookSoft 4.2 to Confidential 7.0.
• Created new Application Set in Confidential 7.0 with 4 cubes (applications) and 30 dimensions with multiple hierarchies, MDX formula, scripting logic, and over 100 reports and input schedules.
• Created journal template and approval status for managing and systemizing the client’s planning and monthly closing processes.
• Designed and build various complex reports and input schedules with EVDRE
• Reviewed and validate design elements for dimensions, cubes, scripts and configurations
• Provided knowledge transfer and documentations to the client
• Developed SSIS with Confidential custom tasks for Master data and cubes data automation
• Developed MDX dimensions formula for calculated accounts
• Migrated existing cubes and applications from Outlooksoft 4.2 to Confidential 7.0

Confidential

Responsibilities:

• Full life cycle implementation of SAP Confidential 7.5
• Developed Finance & drill through application.
• Configured currency translations for multi currency environments.
• Developed allocation scripts to allocate admin expenses cross all locations based on volume.
• Increased performance by eliminating MDX dimension formula and replacing them with script logic where appropriate.
• Designed and implemented multiple hierarchies for account and time dimensions to implement internal and external cash flow applications.
• Improved Company’s ability to understand Foreign Currency exposures and the timing of foreign currency needs
• Provided best practices review of the application with suggestions for change during their validation stage, prior to go-live.
• Developed dimensions, hierarchies, and cubes for Cash flow planning application with foreign currency
• Automated administrative tasks and nightly processing tasks as it relates to the allocation engine and drill through data
• Implemented application, leveraging as much of existing structure and metadata as possible
• Ensured initial design decisions will continue to meet long term business requirements
• Ensured SOX and Audit processes are followed
• Leveraged out of the box functionality wherever possible
• Delivered user and admin for application administrators and users

Confidential

Responsibilities:

• Full life cycle implementation of SAP Confidential 7.0
• Developed allocation application and scripts.
• Automate related process using scripts, Confidential custom tasks, generic packages and custom SSIS packages.
• Provided for application administrators, and provide techniques and processes on managing a production environment for optimal performance.
• Developed cash flow planning application and all related input schedules to provide a consistent process across the entire organization.
• Developed all dimensions for Allocations, Cash flow and rate applications
• Configured Multi currencies translations with Confidential
• Developed Logic scripts to allocate expenses across cost centers and profit centers
• Provided for users and administrators
• Re-designed Confidential generic packages to improve efficiencies and provide easier maintenance for the administrators and more usability for Confidential tasks. Customized administration for new users

Confidential

Responsibilities:

• Improved efficiency of current consolidation process.
• Leveraged new toolset to improve scenario management
• Developed Entity dimension to accommodate existing legal entities, mergers, acquisitions and divestitures
• Developed Cash flow Planning application usable on a global basis by multiple company planners
• Developed security model to ensure that only the appropriate individuals are allowed access to certain information
• Developed input schedules to allow planners to plan the Assets and Liabilities/Equity portions of the Balance Sheet, as well as the Non-ops portion of the P&L
• Developed Logic scripts to calculate roll forwards, and retained earnings
• Develop Account Receivable application to allow planners to plan AR activities by groupings of customers - where those groupings may be unique to their business
• Developed Confidential script to calculate DSO (Days Sales Outstanding) using the count back method
• Partnered with planners to develop Accounts Payable application planners to plan AP activities by Planning Vendor
• Developed Inventory application to allow planners to plan inventory as a function of COGS and historical volumes
• Developed Long term Debt application to allow planners to define the terms of each individual loan, and to aggregate all the loans into a single roll-up number for a particular company code

Confidential

Senior Technical Analyst

Responsibilities:

• Worked closely with the Finance, HR, Accounting & Store Operations to understand their business model, design and implement SAP Business Objects Business Planning and Consolidation, with a focus on leveraging best practices and improving their business practices.
• Completed multi-full life cycle implementations of SAP Confidential
• Managed 4 people and completed project plans development, requirements gathering, design, testing, implementation and SOX compliance.
• Go-Live documentation and post implementation support for several solutions including Budgeting and Forecasting; Payroll Optimization and Planning.
• Provided guidance and oversight to multiple projects running concurrently within different departments.
• Coordinated events and resources to ensure delivery in timely manner and within the allotted budget.
• Designed and implement multi server configuration environments with SAP Confidential 4.2, 5.1, and 7.0
• Managed full project life cycle of the upgrade process from Confidential 4.2 to 5.1 and to 7.0 SP3 M
• Developed dimensions, cubes, conversion and transformation files using Confidential admin modules
• Developed MDX dimensional formula logic for calculated accounts, ratios and custom measures
• Developed Confidential script logic for moving data across multiple cubes, and for calculating roll forward and retained earnings
• Developed allocation scripts for allocating expenses across cost centers using Confidential allocation engine
• Recommended solutions Configure currency translation for single and multi currencies environments to achieve maximum performance and storage
• Developed bursting scripts and templates using Confidential ePublish tools
• Developed MS DTS (for SQL 2000), and SSIS (for SQL 2005/2008) to automate, extract, and extend the functionalities of Confidential eData menu
• Developed stored procedure for implementing calculations that cannot be done with dimensional or scripting logic
• Developed EvGet, EvSend, and EVDRE reports and templates for budgeting and forecasting applications
• Configured and develop the entire security model for US and international users
• Provided technical guidance to programming staff regarding design, specification, coding and testing of SAP Confidential and MS SQL and AS production systems.
• Provided to staff members on new technologies, and new OLAP applications.
• Developed technical design documentation for all elements of OLAP projects: cubes, dimensions, reports, templates, DTS, SSIS, transformations and conversions maps.
• Extended functionality within Confidential using SSIS.
• Investigated use of available software to analyze programs to perform analysis, consolidation, planning, budgeting, and forecasting to maximize production throughput.
• Analyzed and recommends alternative solutions for system enhancements and problem resolution.
• Coordinated technical activities of related projects.
• Maintained knowledge of system modifications and enhancements installed on relevant platforms.
• Assisted in providing solutions to current processing conflicts and problems caused by the growth of the business.
• Built relationships with IT support and development groups to allow proper delegation and assignments of all projects activities.
• Coordinated efforts to implement/upgrade Confidential solutions with enterprise level deployment of more than 400 users.
• Developed project plans, hardware and software installation test plans, and UAT plans for all Confidential projects.
• Evaluated technical environments (production, test, development) and to address database, application, and other processing limitations.

Confidential

Senior Application Analyst

Responsibilities:

• Generated management reports and production reports utilizing Excel and Crystal Reports
• Developed cubes for data warehousing purposes using MS Analysis services
• Developed application sets, dimensions, and cubes with Outlooksoft 4.2
• Developed EvGet, & EvSend reports and templates
• Developed DTS packages for data extractions and transformations
• Configured Outlooksoft security model for all users based on their organizational functionalities
• Conducted analysis to extrapolate trends: Average sale per item, Average sell through and pay through rates, negative feed back implications, and ROI of marketing investments.
• Modeled business processes, and workflow using Visio, Project, MS office, PowerPoint.
• Designed, implemented, and maintained SQL server database to hold all customers and transactions data (Database Marketing).
• Developed requirements and unit tests for web application that utilized eBay and PayPal APIs.

Confidential

Technical Sales Analyst

Responsibilities:

• Provided sales support and project management, securing commitment on the largest deployment of fiber to the premise in company history ($20M).
• Developed and implemented Ethernet PON project plans, solutions, and execution schedule.
• Delivered competitive analysis comparing multiple in the telecom market.
• Managed pre-sales and post-sales technical account relationships, providing client .