SUMMARY:

• An accomplished SAP Business Intelligence professional with over 25 years of experience with large, multi - site, global implementations. I have extensive experience with SAP BI/BW as a technical consultant in the roles of project manager, team lead and as a team member/developer for consumer products, defense, textiles, energy, insurance and life sciences industry projects.
• I have established SAP BI/BW expertise with both front-end (BEx) and back-end (ETL) design, development, and strategy along with SAP Business Objects Webi and Dashboard design and development.
• Most recent work included working on initial project phase to implement BW 4/HANA with a green-field approach and recently completed
• Project work to cleanse legacy data from BW clone in prep for hand-off to new company after sale of one the divisions. Also developed and implementing reporting and cloud datasources for Global SAP C4C implementation as BI lead for project.
• I have been the project manager of a successful SAP BW upgrade and migration to SAP BW on HANA, and as a BI Lead for full life-cycle SAP BW on HANA implementation.
• My project experience includes all phases of the development life-cycle, from project planning and requirements gathering through implementation and go-live support.
• I have also managed projects with offshore development teams for several projects, working with teams in India and the Philippines.

PROFESSIONAL EXPERIENCE:

Confidential

Applications Business Analyst/BI Functional Lead

Responsibilities:

• Worked with existing BI technical resources for knowledge transfer on existing Sealed Air BI environments (Qlikview,SAP BW, SAP Portal, SAP BOBJ), as well as the current migration projects that are in progress to move divisions of Sealed Air onto same corporate ECC and BW instance.
• Performed detailed As-Is assessment of entire existing SAP BW Prod environment, documented and presented to BI leadership for go-forward optimization and cleanup activities .
• Lead for going from current SAP BW to SAP BW 4/HANA internal project planning.
• Performed design &development of SAP BW and SAP BOBJ Webi development for three short term projects.
• Initiated rework of BI functional and technical specification documentation, as current versions were inconsistent and incomplete for effective BI development.
• BI lead for SAP BW work related to SAP C4C Global implementation. (BW reports, C4C Mashups with BW reports, C4C Cloud Datasource integration)
• Provided Tier 1 support of BI issues raised by business across all functional areas.
• Responsible for analysis and development associated with project work to remove all Sealed Air data from cloned BW environment post sale of Sealed Air Diversey business to meet regulatory requirements.
• Architected a new BW solution to replace third party reporting tool that classified ECC data for indirect spend dollars that was sent directly to third party via flat files generated from ECC ABAP program. Annual cost savings of ½ million dollars and providing business users with more reporting flexibility and analysis than they had with third part tool.

Confidential

Testing Coordinator/Lead

Responsibilities:

• Responsible for coordination and tracking of Early Deployment global testing across areas of Consolidations, Tax, Management Reporting & Analytics, and Planning & Budgeting. (prior to Wave1)
• Developed detailed Unit Test, Acceptance Test, Functional Test, and Integration testing approach and presented to business for early deployment testing kick-off.
• Tracked testing progress of each process team against testing plan daily as well as held weekly status calls.
• Provided executive/dashboard testing summary for steering committee meetings on weekly basis.
• Utilized ALM testing tool for tracking progress and defects, and working with business process teams to ensure timely updates in ALM and project teams for defect resolution.
• Initial responsibility on project was to develop comprehensive project plan for project management.
• Existing plan contained varied level of detail and many inconsistencies in levels, making tracking and planning when dates were missed impossible.
• Worked with Process and Technical teams to come up with project plan structure and appropriate levels of tracking and estimating that would allow project management to better leverage the plan by release and by functional and technical areas.
• The project plan started with around 130 lines/Tasks. When my rework was completed, the plan contained over 1,300 lines that aligned to each release, complete with accurate start and end dates (Plan/Actual).

Confidential, Parsippany, NJ

Project Manager - SAP BW Technical Upgrade/HANA Migration

Responsibilities:

• Responsible for management of technical upgrade of SAP BW 7.3 to 7.4 and HANA Migration.
• Developed and maintained technical detailed project plan as well as higher level plan to be integrated with other client projects.
• Developed testing approach and documentation standards for BW and BASIS upgrade/migration.
• Determined consulting staffing levels, staffed project and coordinated activities of 1 on-site BASIS lead, and 5 offshore resources (2 BASIS, 3 BW)
• Worked closely with client project manager to manage client led activities and resources (BASIS, BW, Security, database administrators and infrastructure)
• Coordinated installation of additional boxes to existing X5 HANA environment to increase number of nodes from 5 to 10, to be used for client’s sandbox, development, and quality assurance HANA environments.
• Worked closely with client to provide support for reviews done with client and SAP as a part of client’s Max Attention program with SAP.
• Worked through Project Change Request, based on extension (2 months) of project timeline due to other dependent client projects. I was able to work in a second iteration of staging migration, and able to reduce consulting staff without sacrificing timeline or quality.
• Led client “Stage Gate” review meetings for client leadership after completion of each environment migration (sandbox, development, quality assurance and staging (2). Each of these meetings were used to summarize each environment upgrade/migration and review issues/concerns/questions about each environments upgrade/migration, and then gain consensus from client leadership on proceeding to next environment.
• In addition to managing SAP BW upgrade/HANA migration, worked with the client to also integrate a BPC upgrade and application server switch from zlinux to RHEL application servers. While these were not scope additions to our consulting SOW, they needed heavy management from the consulting end based on these being in critical path for our success.

Confidential

SAP Business Intelligence Lead

Responsibilities:

• Responsible for overall BI Architecture solution (SAP BW/Hana back-end, SAP/Business Objects - Web Intelligence front-end)
• Developed BI Blueprint presentation and approach towards gathering BI requirements that heavily leverage BI Content architecture and queries.
• Within Blueprint, worked with Process teams and client team members to generate scope of BI content that is to be activated and GAP's required to meet GMCR reporting needs per ECC release.
• Performed Resource planning based on anticipated scope of BI Content that client chose.
• Responsible for determining specific hardware to be used as well as front-end tool selection (within BOBJ suite) to best meet client needs.
• Gained working knowledge of client business and processes as they relate to reporting and related legacy client data warehouse.
• Developed approach to BI content Selection that is based on what will be needed by business for each ECC release, and not based on gathering requirements based on Legacy reporting requirements.
• Developed SAP BW back-end Naming Standards and Development Guidelines.
• Developed Reporting Functional Specification and Technical Specification templates.
• Performed informal SAP BW learning sessions with client team members prior to their formal SAP training, as well as worked with client lead in identifying relevant SAP BW/BOBJ training for client.
• Created and managed detailed BI work plan tasks required for activation of SAP BI Content architecture and queries, as well as connected Business Objects Web Intelligence queries in realization.
• Created and managed tasks required for approved reporting GAP's generated by client process teams for reporting needs that could not be met by ECC standard reports or the activation of BI content Bex Queries.
• Ensured workload and resource management of both GMCR and IBM Offshore resource tasks in Realization.
• Work closely with Client BI Lead in all tasks to ensure full knowledge transfer and also to drive client BI resource development.

Confidential, Maumee, OH

SAP Business Warehouse Architect

Responsibilities:

• Validated reporting functional specifications created by process teams for assigned areas.
• Developed reporting technical specifications for each approved functional specification and post in Solution Manager.
• Work with Offshore resources (both SAP BW and BOBJ) to assign and monitor development for development in which I had created the technical specifications.
• Developed and tested, back-end and front-end SAP BW architecture for more complex requirements.
• Create High level data flow for assigned area for architectural components (cube, dso, datasource, bex queries)
• Assisted in development of design templates, based on my past project experience.
• Worked with client counterpart on assigned tasks (where possible), and facilitate learning and knowledge transfer on both BW back-end and BOBJ front end.

Confidential, Pittsburgh, PA

SAP Business Warehouse Lead

Responsibilities:

• Initially assigned to review entire BW system from architecture and reporting standpoint and provide an initial assessment to project management and partners, as well as assist in post go-live support.
• Review work done to date to determine soundness of architecture, any risk areas, assess quality of work, review documentation, review BW procedures of development, assess overall BW approach going forward.
• Get up to speed on SAP BW Utilities specific business content as well as learn utilities specific ECC processes and procedures as they relate to this BW application.
• .Work with BW team members and assist in design, development, and testing required to complete regulatory and utilities reporting requirements that needed closure as soon as possible to complete SLA and allow IBM to move into next phase of support.
• Work to gain client confidence in BW architecture and reports, and offer outside perspective in terms of what they have at this point in the project as compared to other implementations.
• After initial assessment, assumed the BW lead roll for the project, and gained client trust in confidence.
• Re-established BW development guidelines for development, test, approval, and implementation.
• Worked to bridge gap between BW and functional teams in terms of status of BW work, prioritization of tasks, knowledge of architecture, and overall BW awareness and capabilities.
• Drove to completion outstanding SLA reporting requirements and rework/re-architect troubled areas of architecture for better long term performance and support..
• Lead client BW team members for long term support of BW environment in terms of batch load processing by reworking Process chain design and preparing for integration with Redwood for batch job scheduling.
• Designed, Developed, Tested, and implemented solutions required for on-going TPR's and GAP's that arose.
• Continued to assess architecture and reporting for any redesign or enhancement work needed and presented to client as areas of focus as part of continuous BW life cycle.

Confidential, Grand Prarie, TX

SAP Business Intelligence (BI) Project Manager

Responsibilities:

• Returned to project, at client’s request, to replace departing BI Project Manager who had left Dell Services.
• The project was post go-live by 3 months and dealing with massive amount of high priority tickets regarding metrics not showing expected values.
• Main tasks included managing issues list in terms of clarifying issues, assigning developers, and tracking progress, as well as work as BW developer.
• This role also required active communication between BI project team and executive leadership in terms of conveying message as to why things are the way they are, next steps, and path forward. From Exec standpoint, there was little to no understanding as to the impact of ECC issues as they relate to the BI Dashboard issues they were recording.
• BI related open issues list was greatly reduced within short time frame, and I provided solid framework for client to follow going forward for managing issues.
• I also worked to provide a clear message to client executives as to reliability of Dashboard and report metrics as well as the dependencies we have on ECC process changes and data that was not clear before.

Confidential, Lexington, KY

SAP BWA Consultant

Responsibilities:

• Client was dealing with problem in BWA installation based on Hardware configurations not matching SAP certified configuration. Until hardware situation could be resolved, worked with Lexmark to optimize as best we could within BW for optimal reporting short term.
• Worked with Lexmark support to trouble shoot existing problem areas and provided solutions to streamline data loads as well as maximize query performance.
• This was one week effort done while still working Charmer-Sunbelt project.

Confidential, Baltimore, MD

SAP HANA Consultant

Responsibilities:

• This project was an SAP Ramp up project for SAP HANA. SAP led the effort for this proof of concept initial phase for replicating existing massive ABAP report in SAP HANA.
• Assisted in Data modeling and deconstruction of ABAP program logic.
• Developed Attibute and Analytic views in HANA information modeler.
• Created data model diagrams for analysis of SAP table relationships to be modeled in HANA which crossed over functional areas WM, SD, IC, and GL.
• Developed naming standards and conventions to be used in Hana information modeler.
• Served as liason between SAP team memebers not familiar with SAP tables and client team members.
• Attended introductory SAP HANA 2 day training at SAP Training center in Chicago, Il.

Confidential, Grand Prarie, TX

SAP Business Intelligence (BI) Team Lead

Responsibilities:

• Project consisted of development of complex set of 6 Xcelcius Dashboards and associated Webi Trend Charts and Webi Data Detail/Analytical reports using SAP BW as primary datasource to be developed concurrently with ECC implementation.
• Started the project 6 months after initial project kickoff and quickly came up to speed and worked as team member of BW development team in the sales and distribution area and finance, developing infocubes, dso’s, transformations, process chains and bex queries.
• I then took the hands-on BW Team lead position as they headed into integration testing. With three levels of testing (Bex Queries, BOBJ Xcelcius Dashboards, and Webi Trend charts and queries)
• Also assumed responsibility of integration testing (IST) coordinator. As IST coordinator, I had to ensure all BW/BOBJ functional areas had documented scripts, create and manage timeline for testing, layout how to document and then assign breakfixes from script execution, and then assign and manage developers performing breakfix work.
• As migration coordinator for the business intelligence team, I served as main coordinator of all development migration from development client to quality environment for IST. With the iterative testing within each cycle, migration timing and coordination were key to progressing with testing and improving results with each successive run through, and this was achieved with success

Confidential, Louisville, KY

SAP Business Warehouse (BW) Team Lead

Responsibilities:

• I joined the project in a Quality Assessment role to review the BI 7.0 development completed in the initial 8 months of the project.
• After reviewing the Forecasting and COPA infoproviders and queries developed to date, I stayed on the project in a Lead capacity to implement BI standards and procedures, as well as to lend my expertise to what has been developed thus far and make necessary architecture changes.
• Developed and implemented a new reporting solution in the PP area by bringing up the complete PP architecture with customizations for population of Scrap values and Material Batch Characteristics from ECC.
• I worked extensively with the client resource to educate and transfer knowledge to ensure the resource was developing the needed skills to move forward. I also made recommendations for additional infoprovider implementations in the QM and SD areas based on requirements coming in from end-users.

Confidential, Albany, NY

SAP Business Warehouse Consultant

Responsibilities:

• Joined project just after initial design for BI architecture was completed based on initial ECC reporting requirements which was in BI 7.0 environment with over 70 infoproviders identified. BW implementation concurrent with ECC 6.0 implementation.
• My main areas of focus within BW were SD, QM, PP, and IC.
• With a base architecture in place, I worked on gathering and documenting reporting requirements and develop Bex queries and developing an infoset architecture to meet user requirements.
• Implemented ISS notes for issues that arose with BW 7.0.

Confidential, Raleigh, NC

SAP Business Warehouse Consultant

Responsibilities:

• BW project work done in over 7 phases over course of time spent working for client all while myself and rest of client and consulting team members worked remotely from home or home office location.
• I worked primarily with the client team lead in the Sales and Distribution area to develop and implement SAP Business Intelligence SD solutions in terms of back-end infocube, DSO, and Infoset development, as well as front-end query and workbook development.
• Development was done in BI 7.0 environment with usage of 3.5content for older business content.
• My role included requirements gathering, gap analysis, documentation of specifications, process chain development for all functional areas, project plan development for go-live activities of BI, and general trouble shooting assistance for team members.
• I also did development in the Quality Management area of BI, modifying Infocubes and DSO's and developing set of 10 workbooks for quality reporting scorecard.
• The primary goal was to successfully develop and implement solutions for the client and the other main goal was to transfer as much knowledge as possible to client team members to get them up to speed and as standing on their own as quickly as possible.
• Working remotely required clear communication of methods and approaches for BI, as well as transferring good practice techniques to client team members, which I did successfully.

Confidential, Columbus, OH

SAP Business Warehouse (BW) Consultant

Responsibilities:

• Refined requirements started by lead consulting firm in the Order Fulfillment area.
• Created templates for documentation of reporting requirements, data flow diagrams, data mapping and gap analysis.
• Performed analysis of SD business content in BW for best fit to client requirements.
• Developed 3 SD infocubes based on Business content cubes and heavily modified.
• Developed ABAP Start routines and Update and Transfer Rule Routines.
• Assisted new, less experienced team members with technical BW questions in a variety of areas.
• Created, tested and implemented 9 Bex queries.
• Advised consultants on best practices for batch scheduling and infopackage group usage versus process chains.
• Government Authorization granted (ADPII )

Confidential, Gaithersburg, MD

SAP Business Warehouse (BW) Team Lead

Responsibilities:

• I was the BW team lead responsible for analysis, design, and implementation of SAP BW reporting solutions for Finance area.
• I worked with Finance client team members to gather requirements, develop requirements documentation standards, and developed over fifteen queries in to support executive level Finance reporting.
• I trained client personnel in BW query development as well as provided best practice procedures and templates for BW development, in addition to assisting in back-end (ETL) troubleshooting and production support assistance for client development team.

Confidential, Manhattan, NY

ABAP/4 Development Lead

Responsibilities:

• Development team lead for 21 interfaces and conversions to and from newly acquired Client Divisions legacy systems to SAP for design and construction stages.
• Responsible for managing 6 internal and 2 client development team members.
• Coordinated development efforts between legacy systems development team located in the Corporate Data Center in Westminster, MD and SAP developers in Manhattan, NY.
• Management tasks included introduction and implementation of internal methods and tools, workplan creation and management, conducting technical design reviews and ABAP code reviews, cutover planning, and technical program process flow diagrams.
• Designed programs for ABAP BDC programs, IDOCS, extract programs, and performed ABAP development.

Confidential, Newark, NJ

SAP Workflow Developer

Responsibilities:

• Full development life cycle of multiple SAP workflow's in the areas of MM, FI, AP, and HR.
• Performed ABAP/4 development for workflow’s that included function module creation for role resolution, implementation program modifications, custom table creation, and triggering event programs.
• Consulted with process team members to gather requirements, validate workflow designs, user training, and system testing, as well as trained a client to be the workflow administrator.
• Created procedural and technical documentation for all workflow's developed and provided post implementation support.

Confidential, Winston-Salem, NC

SAP ABAP/4 Developer

Responsibilities:

• Joined the development team in the development phase of the project. The client was migrating from traditional legacy systems to SAP for more than 10 manufacturing plants.
• Gathered requirements from process team members and then designed, constructed, developed, and implemented ABAP reports for HR and production control areas.
• Performed data scrubbing, error tracking of conversions, SAPScript modifications, ABAP/4 conversion program modifications, and ran conversion programs for BOM's & Routes from client legacy systems into SAP. The end result was the successful conversion of over 17,000 BOM's and 14,000 Routes.

Confidential, Lancaster, SC

BPICS Planning and Scheduling/Inventory Team Member

Responsibilities:

• Performed gap analysis and issue resolution for the Planning and Scheduling/Inventory Team in the implementation phase of BPCS for Springs main cloth finishing plant.
• Prepared and executed prototype test scripts and created supporting test data.
• Managed an independent contractor in the development of several shop order maintenance programs, and wrote his design specifications and unit test plans.
• Coordinated interface testing of the new software to existing legacy systems.

Manor Healthcare

GUI (Powerbuilder) Developer

Responsibilities:

• Worked as a member of a five person Powerbuilder development team to create the GUI’s for a custom billing system to be used at all 160 facility locations.
• Developed custom base objects for screen development, as well as extensive use of inheritance for window function stubs, button positioning, and event scripts.
• Designed, constructed, and tested approximately 20 of the 100+ windows for the system as well as performed the final quality and standards check for all of the windows and menus for consistency and correctness before the first release.

Confidential, Greensboro, NC

Powerbuilder Developer

Responsibilities:

• Gathered requirements, designed, developed, and implemented a client server driven Customer Database Pilot Application front end.
• The pilot application utilized Dunn & Bradstreet data on heavy truck consumers and a Powerbuilder GUI, with an Oracle database back end.
• Constructed and scripted approximately 27 windows, consisting of maintenance, inquiry, and graphical presentation screens.