PROFESSIONAL SUMMARY:

Confidential is an experienced SAP BPC designer, application developer, and report/ input schedule development professional and consultant. He is has been a leader in the creation of an internal EPM10 base of knowledge, is certified in OutlookSoft 5 and is a Microsoft Excel Expert. He has extensive experience as a SOX 404 control auditor, and is familiar with a variety of technical and marketing concepts, practices, and procedures. Experienced working on significant development projects and teams as a project leader, Confidential is able to lead and communicate effectively with technical and non - technical teams alike. He has outstanding written and verbal communication skills, is comfortable with complex systems and technical information and possesses a high degree of personal motivation with the ability to self-start in unstructured environments. He has successfully used his broad experience and excellent judgment to plan and accomplish high-end goals for projects, departments and companies.

TECHNICAL SKILLS:

Technical proficiencies covers a wide range of applications and platforms including: SAP EPM10, SAP BPC 7.5 for Netweaver, Certified OutlookSoft 5 Professional, Certified Excel Expert, Oracle, Unix, HTML, Java, .Net, Sybase SQL Server & SQL Anywhere; MS SQL Server 2005; Analysis Services, MS Visual C++, MS Visual Studio, MS Access; MS Visual Basic; MS FoxPro & VFP, OOD; UML; COPC; TQA; ISO9000; COQP; Rational Visual Test & Team Test

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Managing Consultant

Responsibilities:

• Consultant specializing in SAP EPM10 and BPC Implementations and Custom Development.
• Design, develop, and implement Enterprise Performance Management (EPM) systems for clients.
• Model business processes and design application components and structures, write dimension logic, advanced logic, and default logic using MDX
• Review client systems, structures, and processes to identify where improvements can be made to enhance operations
• Developed and delivered roadmap to upgrade from BPC 7.5 for NetWeaver to EPM 10 for NetWeaver
• Lead project-definition workshops
• Conducted presentations to senior management to help define opportunities
• Developed estimates, project plans, and scope of work documentation
• Lead discovery meetings and workshops
• Developed proof-of-concept presentations to senior management
• Lead internal Sales Demo in SAP EPM10
• Conducted daily knowledge transfer calls to train HCL staff on EPM10
• Managed all development tasks and reported progress to management and sales

Confidential, Tempe, AZ

Consultant

Responsibilities:

• Consultant specializing in SAP EPM10 and BPC Implementations and Custom Development.
• Design, develop, and implement Enterprise Performance Management (EPM) systems for clients.
• Model business processes and design application components and structures, write dimension logic, advanced logic, and default logic using MDX
• Review client systems, structures, and processes to identify where improvements can be made to enhance operations
• Built complex Reports and Input Schedules in SAP EPM10
• Delivered internal presentations on EPM10 features and techniques
• Web Workspace, Report,and Input Schedule development and limitations
• EPM10 Business Process Flow setup and troubleshooting
• Controlling context in workspace and web reports
• Using multiple reports on sheets to control and optimize data presentation and input local member techniques, limitations and placement
• EPMCopyRange performance implications and impacts
• Dynamic Formatting behavior and techniques
• Using VBA to execute custom EPM10 objects to control report behavior
• Using EPMSendData and EPMCopyRange to send calculated values to the database from local members, native report cells, and Input Schedules
• Columnkey and Rowkey manipulation using various EPMDimensionOverrides and EPMOLAPMEMBER edits to gain full control over report behavior
• Member of a two-man design team developing and deploying a highly complex driver-based Sales Forecasting application in BPC 7.5. for NetWeaver, with Bill of Materials explosion allowing Commodity Price sensitivity analysis and Currency Impact analysis
• Co-Authored the design document
• Designed an innovative VBA form allowing users to create and maintain ad-hoc custom planning projects, effectively master data
• Led presentations to JCI executives in Holland, MI, and the European Sales team in Burscheid, Germany
• Developed and documented the data model, served as the team’s subject matter expert when developing logic, and the point-of-contact with the business on data issues
• Wrote complex EVDRE input schedules and reports
• Developed all master-data loads and transactional data loads
• Selected to lead the team during user acceptance testing and deployment in Cergy, France
• Lead the two-man hand-off and knowledge transfer team
• Member of a large team developing and deploying a Wages and Salaries expense forecasting application in BPC 7.0.
• Developed and documented the security model, and served as the team’s point-of-contact with the business on security issues
• Wrote complex EVDRE input schedules
• Assisted in dimension building and maintenance

Confidential, Pittsburg, TX

Architect and Lead Developer

Responsibilities:

• Trained Confidential ’s Pride staff in writing EVDRE input schedules and managed their work
• Wrote complex EVDRE input schedules requiring VBA and BPC script logic
• Lead successful deployment in BPC 5.1 and successful upgrade to 7.0
• Successful BPC 4.1 to 7.0 Upgrade project
• Tested all existing input schedules and reports in 7.0, making any necessary edits to ensure continued functionality
• Wrote new EVDRE reports where required, using VBA where necessary
• Designed and build the new security model in 7.0, using the 4.1 model as a template.
• Tested all data-load packages and DR Servers’ functionality
• Trained Southwest staff on EVDRE report-writing
• Lead Architect and builder of an integrated planning tool for ExxonMobil’s Upstream Research Company
• Allows Division Planners to prioritize and scope upcoming research efforts as well as to manage current activity by tracking key statistical information and financial activity associated with Research Programs
• Provides an easy method for Supervisors to plan, forecast, and reconcile staffing and work effort in a matrix organization
• Links Supervisor and Planner data entry to Enterprise financial activity to generate a single forecasted view of the business
• Input Schedules and Reports built using EVDRE and extensive VBA
• Built and tested complex Cash Flow Forecasting application that aggregates lines-of-business forecasted activities, and recalibrates these forecasts monthly with enterprise actuals to produce consolidated, integrated financial statements that blend actual and forecast values
• Developed detailed test plan for HR application
• Project Kick-start and Project Management for Financial Consolidation Solution for 5 international legal entities using US GAAP as the consolidation basis
• Project also included Forecasting and Budgeting

Confidential

Senior Associate

Responsibilities:

• Modeled business processes, designed dimensions, wrote dimension logic, advanced logic, and default logic using MDX
• Designed the ETL and trained client staff to implement it. Created transformation and conversion files to facilitate the ETL process
• Wrote scorecards and reports using advanced set and list building, suppression, and expansion techniques
• Built a KPI application a logistics company that reported quality, timeliness, cost, and revenue metrics by Lane, Vendor, Customer, and Shipper
• Performed a complete IT assessment for the largest private grocery supply business in Texas, and reviewed their supply chain models, reporting, databases, and supporting systems
• Business Process Improvement consulting in order to facilitate the transition from a privately-owned business into compliance with publicly-traded regulatory responsibilities
• IT Consulting services mapping existing corporate policies and procedures against CobiT and exposing areas of redundancy and exposure
• Sarbanes-Oxley Auditor
• IT Internal Controls Auditor

Confidential

IT Control Auditor

Responsibilities:

• Communicated audit progress and findings by preparing reports
• Monitored compliance with regulations and controls by examining and analyzing records, reports, operating practices, and documentation
• Designed and conducts control tests of IT internal controls, identifies deficiencies, and recommends corrective actions
• Completed audit work papers and memoranda by documenting audit tests and findings
• Improved protection by recommending changes in the internal control structure
• Interfaced with process owners to review control efficacy and develop process changes if necessary
• Analyzed processes to suggest changes that will strengthen, automate and/or simplify controls
• Assisted with third party audits
• Accomplished internal audit and organization mission by completing related activities as needed

Confidential

Compliance Analyst / Software Development Mgr

Responsibilities:

• Managed ongoing regulatory and internal compliance activities in SMI IT
• Documented, developed, and implemented controls and process improvements to ensure compliance with SOX, and Internal policies
• Evaluated all infrastructure and application functions to measure compliance with current corporate requirements and developed requirements documents for automating controls
• Developed and implemented standards and policies with IT Management to including security, networking, and application change management
• Designed and conducted control tests of IT internal controls, identified deficiencies, and recommended corrective actions
• Coordinated SOX 404 related activities with Corporate IS group, operating facilities and external auditors
• Assisted with third party audits
• Participated in corporate-wide compliance initiatives and meetings
• Provided technical project management to ensure the delivery of quality systems on time and budget
• Coordinated technical projects through the various IT groups (development, test, network services, etc).
• Ensured successful communication between multiple departments as well as with internal and external clients regarding technical issues and projects
• Responsible for the overall technical success of client projects
• Delivered status reports and financial information regarding project and client portfolio
• Lead and directed the work of a team in a matrix organization
• Determined and documented system requirements through interactions with internal and external clients
• Monitored client portfolio’s operational technical work
• Audited and documented client portfolio compliance with Internal security policies, Sarbanes-Oxley (SOX) and Health Insurance Portability And Accountability Act Of 1996 (HIPAA) regulatory requirements.

Confidential

Technical Recruiter

Responsibilities:

• On Site recruiter responsible for every aspect of the client relationship, including account management and sales Used strong understanding of the Information Technology sector to add value to the recruiting process
• Recruited IT professionals for consulting assignments and permanent placement
• Used mediation and negotiation skills to achieve budgetary goals for clients and salary goals for candidates
• Used the Internet, cold calls, and available database to locate and identify technical resources

Confidential

Membership Coordinator

Responsibilities:

• Responsible for managing and marketing the Museum’s membership program.
• Grew Q4 2001 revenue 44% over prior year, and Q1 2002 by 56% over prior year. Used strong customer focus to stabilize a steeply downward trend in Museum memberships and achieved month-over-month growth by Q4 2001.
• Brought a strong bottom-line focus to the Membership program by cutting expenses, eliminating waste, and careful cost-benefit analysis
• Cleansed and managed the Museum’s Raiser’s Edge for Windows database of constituents, and trained Museum staff in its use. Worked with Museum IT staff to expand access to the Museum’s database converting many paper-based procedures to real-time, cost-free efforts.

Confidential

Client Applications Manager

Responsibilities:

• Led team in conceiving, developing, and implementing automated tools that allow HH CRM to pull in outsourced work, grow current accounts, add new sales opportunities, and improve margins by reducing programmer time.
• Managed team of 10 web and database developers. Trained and developed staff, and evaluated their performance. Reviewed and approved client IT billing.
• Interfaced with clients and supervised planning and development of their response management solutions. Led technical presentations to clients.
• Improved the team's billing discipline resulting in a 100% increase in billing requests per person per month, and improved the team's testing discipline such that quality was above department average and improving at a the fastest rate.
• Established team-partnering program to foment good mentoring, code review, and cross-client training on all accounts, and to encourage innovation through teamwork.
• Chaired Testing Automation Software search committee and Co-Chaired Visual SourceSafe implementation team. Member of Cross-Department Communications Improvement committee.
• Top five billable hours for the one hundred-person department every month.

Confidential

Project Lead

Responsibilities:

• Generated and ensured execution of the overall project plan for the InSource product line.
• Reviewed staff's weekly status reports assigned to these products to ensure that all met goals and milestones.
• Reviewed, edited, and wrote the InSource products' proposals and technical specifications.
• Executed line-level management decisions.
• Served as point of contact for communications with other groups and with clients.
• Implemented new Lotus Notes request status-tracking system.
• Oversaw timely and successful delivery of several yearlong projects comprising up to eighteen programmers’ efforts.
• Project Managed InSource Domestic’s effort to make code web-enabled using a three-tier design and using dhtml, dcom, C++, and other appropriate technologies.

Confidential

Quality Assurance Project Lead

Responsibilities:

• Achieved promotion to Project Lead as the least senior member of the team, and in three months (usually a one to three year process).
• Led team in over six successful product releases.
• Responsible for overall test project for The Raiser’s Edge for Windows fund-raising software.
• Reviewed design specifications to ensure that features and functions were not lost, and product documentation for accuracy.
• Created project plan to determine goals, deadlines, and to assess product coverage.
• Worked closely with programmers, developers, and support staff to ensure that the released product met specifications.
• Trained new team members and evaluated individuals’ performance for reviews.
• Conducted automation code reviews with the Automation Team’s lead.
• Wrote test plans, checklists, and scripts designed to assure good coverage of assigned functions.
• Used Rational Visual Test to write automated testing routines.
• Worked with source code in MS Visual Basic 3.0 to quickly determine the precise cause of defects.
• Manually tested all assigned functions.