Senior Program/Project Manager

EXPERIENCE

RCM Technologies **/**** – **/****

Aramark – Senior Program Manager

Responsible for consolidation of Financial, HR, and Payroll applications from a multi billion dollar acquisition which occurred 7 years prior. Coordinated the efforts of multiple project managers by promulgating project management standards, templates, and processes. Prepared executive level status reports and stakeholder communication. Managed an integrated project plan and milestones in conjunction with the various business and technical team leads. Facilitated program integration activities such as managing issues to resolution and preparing and executing risk mitigation plans. Managed the Program budget, tracking and reporting the actual expenses against forecast.

TekSystems 05/2004 – 10/2008

City of Philadelphia – Program Director

General responsibility for Oracle eBusiness suite implementations, with direct control for the HRMS module for the Office of Human Resources. Established roadmap for the City to fully utilize their investment in Oracle eBusiness software and worked with both the Division of Technology and administration agencies to foster adoption. Directly accountable for all aspects of delivering a $7 million implementation of the R12 HRMS module to the Office of Human Resources. This entailed replacing their 30 year old mainframe application with Core HR with Position Management, Employee Self Service, and Oracle Advanced Benefits for an employee population of 33,000. Effort involved interfacing to existing Payroll, Pensions, Budgeting applications. Process change was developed in conjunction with Finance, Budget, Labor relations, Managing Directors office and required developing tight change management controls to minimize risk across the federated environment. The business intelligence component provided staff analysis to central and agency teams through the use of OBIEE, and Brio reporting tools.

City of Philadelphia – Project Director

Project Director for a $6 million, multiple agency initiative to create the Virtual Property Management Information System (VPMIS), a series of integrated applications intended to better manage the City’s property related information and business processes. Phase One deliverables included a property research query function with textual and spatial capabilities, an electronic inventory of city-owned properties, a workflow application to automate property acquisition, and an Imaging component for electronic document storage and management. Phase Two deliverables, include a property request and tracking function, workflow automation of property disposition, and a property data warehouse enabling historical maintenance and evaluation of data.

• Selected and managed a diverse consulting team during project planning, development, and implementation. Coordinated the activities of business and technical resources from Central IT and participating functional agencies.

• Developed and presented project scope, status, and deliverables to all echelons of city government. Coordinated round table discussions to solicit input on tactical/strategic activities that would have city-wide administrative benefit.

• Dissected existing business workflows to define, analyze, and streamline work processes while remaining within legally mandated business requirements. Business process was re-engineered to derive efficiencies and governance controls as best as practical.

• Directed team in the development of a constituent/developer centric geospatial application which included all properties with City limit. The application provides analysis and property request for neighborhood development using a shopping cart metaphor. Developed using the City’s Parcel base with integration of data from various City agencies.

• Directed policy making discussions to ensure that ongoing technology initiatives serve existing and future business needs.

• Ensured that agency technology initiatives adhere to city enterprise IT standards, including the use of Documentum as an Imaging solution, e-Work as a workflow application, and Oracle as an enterprise database management system.

• Initiated a multi-tiered reporting architecture based around the capabilities of the Brio and Cognos suites which were enterprise standards.

• Collaborated with disparate city agencies to collect system input and integrated that data to deliver a stronger business solution. Scheduled frequent Steering committee meeting in order to resolve issues quickly and deliver status to executive sponsors and Agency Commissioners.

• Developed and monitored processes to ensure that all project activities subscribe to City contractual, integrity, MBEC, and legal requirements.

• Created a “project vision” by interpreting current business needs and going beyond those identified needs to deliver a product that provides additional system utility while remaining within budget. The value add being potential revenue generation for the Revenue, and Water Agencies.

February 2002 – April 2004

CRMI Consulting

Bentley Systems Inc

Consultant - Data Warehouse Project Manager

Project managed and architected a data warehouse project in Oracle 9i and implemented a Business Intelligence reporting environment merging information from SAP ERP and Siebel CRM operational systems to provide business users with trending and forecasting information. Coordinated and communicated all project tasks and expenditures to appropriate business and IT participants.

• Managed the initial proof of concept initiative that was successful in securing the funding to carry the project in to full production implementation. Produced a working prototype utilizing Oracle Warehouse Builder and select features of the 9i initial release. Presented the POC findings to sponsors and business community to garner acceptance and support.

• Project managed and coordinated the activities for both the business and technology communities during each phase. Developed Project Scope, project definition documents and overall project plan. Distributed and managed project deliverables amongst Bentley internal staff and contract resources, tracking and reporting activities to all project participants on a persistent basis.

• Interviewed business users individually and in-group sessions in order to surface data requirements and to properly address open issues and planning activities. Instilled standard reusable processes and established change management procedures.

• Supervised and participated in logical and physical data structures creation, determined and defined business rules for data scrubbing, transformation and data refresh frequencies.

• Structured and scheduled vendor reviews during reporting and ETL tool selection process. Arranged for software delivery, installation and subsequent IT/User community training of the Cognos and Business Objects reporting suites.

• Migrated the original design from a Wintel platform to Solaris on a Sun 5500 server. Performed QA testing to ensure all scripting and features remained intact.

• Worked with infrastructure, operations, and application development groups to establish a working environment to test and QA all processes prior to productionalization.

September 1999 – January 2002

J P Morgan Chase - Chase Insurance Group

Vice President, Data Services

Information Technology Executive with responsibility for ensuring the integrity and availability of database sources for new CRM development data activity, and legacy application databases. Managed a staff complement of 13 full time employees and 7 contractors located in DE and NYC, and administering an annual data services budget of $3 million. The group encompassed data modeling, ETL, database administration and Unix systems administration development and support staff.

• Successfully managed the design and implementation of data environments for multiple Siebel Financial systems, including data migration through the full lifecycle. Activities included data mapping, transformation, validation, and conversion from legacy sources to the Siebel Schema. Project activities were facilitated by common usage of RUP/UML via the Rational Rose Suite.

• Directed overall Oracle performance planning and tuning, and extensive tuning of the Siebel databases and EIM/EAI load process. Ensured that tuning and capacity planning were addressed in all pre and postproduction environments.

• Actively participated in all Chase data project activities to ensure that the Insurance group was aligned with the target of seamless customer data access across all divisions. This included staying abreast of all regulatory issues, including customer privacy restrictions.

• Successfully architected and implemented a Campaign Management solution which utilizes the Banks inclusive customer information database. Created a 3 terabyte data warehouse of customer contacts used for data mining and sourcing of data into the campaign management process. The warehouse reflected data that had been filtered, cleansed, and scored to meet the specific needs of the Insurance group.

• Directed all mapping, business rule, and ETL tool selection and implementation activity. Improved the load/extract environment through trial and error using product from Ascential, Sagent, and Informatica. This included using Informatica for one of the Siebel implementations in order to bypass the EIM tool.

• Influential in revising the process of lead and response collection and worked with various Sales and Marketing group members to design and implement a greatly improved method which was managed through the Prime Response PrimeVantage tools.

May 1997 – August 1999

Oracle Corporation

Technical Director, Consulting Services

Lead a team of highly skilled Oracle consultants whose complement ranged in size from 40 to 70. Participated in the recruiting, interviewing, hiring and placement of the technical staff. Provided mentoring and leadership to the consulting staff in the areas of training, career development, project reviews, and annual skills assessment. Facilitated business development within the practice by participating in project proposals, pre-engagement consultation, and recommending staff augmentation to existing clients on various engagements.

Conversion and Migrations Center of Excellence - Responsibilities centered on the continued growth of a specialty practice within Oracle Consulting focused on the movement of applications using competitors' database products as the backend to Oracle. The tier one targeted databases being MS SqlServer, Sybase, Informix, DB2/UDB, Teradata and Ingres. Full conversions were conducted using Oracle developed Migration Workbench software, and integration of applications within the enterprise were facilitated by third party integration products (i.e. MQ, Weblogic, Tuxedo). Migration projects required varying degrees of modifying the existing enterprise architecture. Tasks included working with Oracle Marketing, Development, and Sales to create business development opportunities for licensing. The highest priority was given to proper scoping, effort validation, and project planning required to ensure client applications perform as well as and preferably better in the Oracle environment. Duties included staffing review, training and mentoring existing consultants in project methodology, conversion tool usage, and project review and management. Clients included E*Trade, Fidelity Investments, Florida State Government, Deutsche Bank, et al.

Pennsylvania State University - Technical Project lead for the team responsible for infrastructure required for a Release 11 Financial Applications implementation. With this being PSU's first foray into a major N-tier production system, a full analysis of the network, application and database server equipment, security, Backup and Recovery scenarios, and desktop equipment were dictated. The final recommendations included the specifications for a Test, Development, and Integration environments that had been excluded from Production installation planning.

Bristol-Meyers-Squibb - Performed high level review of existing Oracle database environment for the corporate office system environment. Proposed revised architecture that would better utilize their existing Oracle/Intel/NT infrastructure, facilitate use of change management processes, and free up capacity for future expansion. The effort included implementing database change processes, Backup and Recovery procedures and test plans, as well as performance tuning and debugging mentoring to the applications development staff.

Electronic Payment Services - Project Manager for the conversion effort of several mission critical applications from an existing NCR hardware platform to Sun enterprise class servers. The applications were a mix of packaged and custom developed software. In all cases the Oracle DBMS was upgraded from 7.1/7.2 to current 7.3 or Oracle 8 releases. For both Peoplesoft and Remedy the current application software releases were installed, which involved running the full development life cycle as quality assurance. In addition to running the conversion functioned in an advisory role on two new applications project which will be running on Oracle 8, and worked with EPS management to establish a development DBA function, and standard practices and procedures for the production support staff.

Chase Bank - Physical database designer for a 4-terabyte consumer credit data warehouse, with an initial dimensional datamart to support the Consumer Value Management Group in historical and predictive analysis. The data being sourced to the warehouse from various mainframe and mid-range applications represents an initial load for a 12-month period from Credit Card, Non-Card, Auto, Mortgage, and Deposit and Investment

operations. Both the warehouse and mart have been designed to take advantage of Oracle 8 enhancement. Both vertical and horizontal partitioning was used to allow for ease of maintenance, backup and recovery, and query optimization. The CVMG data warehouse has been tuned and tested to be used with Discoverer 3.0, and Cognos suite. Design, documentation, and data dictionary work was conducted and communicated through Logicworks Modelmart, installed and maintained on an Oracle8/NT platform. Final warehouse iteration was hosted on a Sun

E10000 with EMC disk array and made available to all Chase business units.

Lockheed-Martin - Project lead for a data team working on a conversion of a legacy IDMS system to a three-tiered client-server application at Lockheed-Martin. This Buyers workstation system required bi-directional replication in order to retain existing interfaces not currently slated for rewrite. Established initial load procedures using a developed automation tool, and required processes to ensure subsequent appends maintained integrity. Personally responsible for assessing tuning requirements and definition of historical performance tracking.

June 1996 – April 1997

Comcast Cellular Communications Inc.

Director, Data Services

Managed the database administration and data analysis staff responsible for supporting multiple database platforms across the enterprise. The strategic goal was to develop a cost effective reusable data architecture that will provide a centralized operational data store, data marts, and initially a layer providing a virtual data warehouse. The design allowed for consolidation into a physical data warehouse should business requirements dictate it's creation. Initial data warehouse POC developed by NCR was converted from Teradata to Oracle/Unix platform.

March 1995 – May 1996

Reliance Standard Life Insurance Co.

Technical Manager

Responsible for designing the LAN/WAN hardware and software infrastructure, and staffing for RSL's strategic direction of client/server development. Efforts included integrating Windows NT for the database and application server platform into an existing Netware environment. With information existing in unrelated systems on a number of disparate platforms, a fair amount of data analysis had been conducted in order to populate a data warehouse. To curtail future data spread and reduce the volume of host-based applications, our goal was to create new systems which can directly populate the data warehouse and transactional databases located in the new environment. We had decided upon the COGNOS toolset for power user access, and began

deployment of business line specific Data Marts with Oracle/NT back ends.

January 1990 – March 1995

Sun Company Inc.

Senior Database Administrator/Database Manager

As a member of the Central I/S organization my initial responsibility was to create a stable environment for all DB2 database activity throughout the Company. I developed and implemented standards, policies, and procedures necessary to regain control of, and properly manage the DBMS growth. All existing structures, and development efforts were reviewed for design integrity, security, and system performance. The Bachman DA/DBA toolkit was used to review logical schemas, and build the physical database structures for new development projects. Was responsible for performance tuning, technical consultation, software evaluation, and problem resolution for all directional products with access to DB2. Established both functional database backups, and disaster recovery capability, and performed recoveries when necessary. Project managed the implementation, and application testing as new releases of DB2 were installed by our data center. Became involved in Sun's distributed data effort on the LAN by installing/supporting the Sybase DB2 Gateway, and MS SQLSERVER. Due to burgeoning database growth in our refinery operations systems area, my efforts were refocused to include ORACLE, and to a lesser extent SYBASE. I was entrusted to bring the same quality support structure of our host DBMS, to ORACLE in the LAN/WAN environment. To help streamline support, SYBASE databases were being converted to ORACLE 7, and plans were created to replace legacy RDB applications with same. To coincide with a project to unify our token ring/ethernet networks through NT

Server, I architected a plan to unite current ORACLE/VMS with new/future ORACLE/NT, OWS client/server development, utilizing the SQL*NET Multi-Protocol Interchange. As team leader for the database group, I was responsible for coordinating the activities of four (4) senior level DBAs providing company wide support.

December 1986 – January 1990

Campbell Soup Company

Database Administrator

Joined the staff as a Senior Analyst/Programmer responsible for development, coding, and support of Sales and Marketing systems using DB2, CSP, AS, QMF, and COBOL II. Successful completion and demonstrated

ability in database design secured a position in the data resource management group. The DBA function consisted of logical/physical design, security administration, performance monitoring and tuning,

application promotions, and application consultation. The DBA group also participated heavily in new product evaluations and installations. Successes included design and support of the Metaphor DIS package that

provided EIS capability to a number of business areas and senior management.

November 1985 – December 1986

Penn Mutual Life Insurance Co.

Senior Analyst/Programmer

Performed detailed program analysis, design, and implementation of a wide range of insurance, and pension applications. Primary support for a variable universal life package written in Cobol/CICS accessing VSAM files. Participated in the prototyping and eventual implementation of a pension retirement advice system that accessed IDMS/R, and was written in ADS/O.

May 1982 – November 1985

CIGNA Corporation

Programmer/Analyst

Designed, coded, and implemented enhancements for an employer self-insurance system, which provided processing capability to Fortune 500 companies. Primarily responsible for claims handling, and service

fee issuance using IMS/DB/DC, COBOL, MFS, and CICS. Easytrieve, and Focus facilitating the reporting function.

EDUCATION

Drexel University, Philadelphia, PA,

Degree in Business Administration

TECHNICAL SUMMARY

Software

Unix/Solaris/HpUx, MVS/COBOL/TSO/CICS/JCL/ISPF , OS400, OpenVMS, Windows 2000/NT,

SAS Connect, Oracle R12 eBusiness suite, SAP/R3 4.6, PeopleSoft, Oracle 11i, Siebel 6x/7x, Easytrieve, Focus, Express, Pilot EIS/MDB, Actuate, Crystal Reports/Server, PL/SQL, TSQL, SQL Navigator, Cognos / Architect / PowerPlay / Impromptu / UpFront Transformer / IWR, Brio reporting, Business Objects Business Query, Chordiant Campaign Management suite, MetaStorm eWork, Oracle Forms/Reports, Discoverer, Visual Basic, MS-Office suite. ArcSDE, ArcIMS, HP PPM, XML

DBMS

Oracle 6x, 7x, 8i, 9i, 10i, Teradata, Sybase, MS SqlServer/SQL 2000, Informix, DB2/UDB, IDMS/R, VSAM, Access, MOLAP/ROLAP, OEM, Stats pack, BMC, Platinum, Quest, TOAD, Oracle Warehouse Builder,

Express, Oracle Migration Workbench

Case/Methodology/Architecture

Designer2000, Erwin, Power Designer, Bachman, IEF JAD facilitation, Kimball, Inmon, Rational Rose/UML/RUP, Method 1, TQM, Oracle AIM/CDM/DWM, SOA,

ETL

Data Junction, Oracle EDMS, Ascential DataStage, Sagent, Siebel EIM, Informatica, BCP, Sqlloader

ADDITIONAL TRAINING

Certification in Project Management Institute Principles

Data Design and Modeling

Total Quality Management

Oracle 8i/9i New Features Utilization

Oracle Data Warehouse Performance and Tuning

CRM planning and implementation

Siebel Foundation

Siebel Administration

Contact this candidate