TECHNICAL SUMMARY

Software

• Unix/Solaris/HP-UX, MVS/COBOL/TSO/CICS/JCL/ISPF , OS400, OpenVMS, Windows 2000/NT, SAS Connect, Oracle R12 eBusiness suite, SAP R3 through ECC 7.x, SAP NWBC Business Warehouse 7.x,
• SAP BusinessObjects Explorer BEx , SAP BusinessObjects Excelsius, 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, .Net, Java, Oracle Forms/Reports, Websphere server, Discoverer, Visual Basic, MS-Office suite. ArcSDE, ArcIMS, XML/Soap, OBIEE, uPerform

DBMS

Oracle 6x, 7x, 8x, 9x, 10G, 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, MDM, Rational Rose/UML/RUP, Method 1, SOA ETL
• Data Junction, Oracle EDMS, OWB, Ascential DataStage, Sagent, Siebel EIM, Informatica/PowerExchange for SAP, BCP, SQL Loader

Project Management / QA Tools

MS Office Suite current to version 10 , MS Project/Project Server, HP Project and Portfolio Management Mercury IT Governance , Earned Value Management, TQM, Oracle AIM/CDM/DWM, Agile/iterative, Waterfall, ITIL v3, Sharepoint for project artifacts, APSE proprietary tool for ASAP methodology , HP Quality Center.

EXPERIENCE

Confidential

Consultant SAP Sr. Project Manager

Project Manager responsible for implementing SAP Financials, BW/BI analysis capability, and interfaces to legacy applications. The effort and new processes are in support of a shared services center which will allow TMNA to expand their US presence through acquisition. Worked with business and technical staff on short term and strategic architecture for analysis. Initial phase delivered BW server with core and peripheral data for use via BEx and KPI Dasboard. Duties include coordinating integration and hosting partners, internal resources and contractors onshore and offshore in Functional and Technical activities against plan. Delivered implementation, roadmap to incorporate subsequent companies, Regression testing support procedures and structure, Quality control processes, and operational guidelines. Tracked and managed budget burn rate across multiple vendors and internal resource chargeback. Utilized RICEFW matrix and Transport requests Solman to monitor object development and movement through SDLC clients. Subscribed to ASAP methodology and project artifacts and workflows signoffs were stored in APSE.

Confidential

Oracle HRMS Sr. Project Manager

Project Manager tasked with serving as liason to PMO and HR staff managment for the successful global implementation of Oracle HRMS R12 across multiple business groups and legislations. Reporting to the Global Director of HR Systems and Operations. Responsible for keeping project on task and ensuring that all technical and functional requirements are successfully met for this ERP implementation. Prompted by a merger of equals, the scope includes developing one vision of best practices, Migration of legacy data from both Peoplesoft and Oracle R11, developing Business analytics via OBIEE against a cross function data warehouse, and integration of Payroll and other peripheral systems. HR implementation is in conjunction with consolidation of Financial suite to R12 where Accenture has been contracted as the integrator. HR milestones were tightly integrated into overall project milestones and deliverables had to fit into a very tight schedule.

Confidential

Consultant Sr Project Manager

• As a member of the program management office PMO , responsible for managing multiple enterprise projects..
• Part of a highly structured PMO chartered with instilling best practices around implementation of new technologies across a very large enterprise environment.
• Managed migration of SAP 4.6 HR modules to SAP 6.0 which included transitioning support to new service provider structure. The project included all internal and external interfacing applications, used for both domestic and international employees.
• Responsible for the manufacturing applications and interfaces which are being utilized by a paperless Biologics plant which is currently in the Recipe validation phase. SAP Financials and Inventory Management are integrated to Maximo, LIMS, and Emerson applications being used at the facility.
• Managing the consolidation of two Research and Development labs dedicated to the Biologics stream. Applications are being reviewed to eliminate redundancy, meet new business requirements, and provide best of breed capability. The goal was to recommend a new application architecture which will allow standardization of equipment, faster resource reallocation between locations, and flexibility to address future growth. Application standardization included support, quality control review, and change management guidelines.

Confidential

Consultant 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 of actual expenses against forecast.
• Ensured that enhancements had passed through earned value calculation assessment and had been signed off by steering committee

Confidential

TEKsystems Consultant Project 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. Worked closely with central IT to adopt ITIL best practices in anticipation of supporting current and future E-Business applications.

Sr Project Director

• Lead 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 I 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 II 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.
• 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. Ensured that collected property data would server a master reference data for various integrated systems. Developed using the City's Parcel base with integration of data from various City agencies ArcSDE, ArcIMS .
• Several distinct applications were delivered from the effort to serve a diverse client group. The software utilized XML, Java, .Net, SOA, Websphere, Citrix, MS Sharepoint, Webservices, ARC/GIS technology to deliver sustainable products with full integration to legacy systems. Iterative approach and refactory code improvement contributed to an outstanding product which received a 2008 Computerworld Laureate Award.
• 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 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.
• Navigated and communicated with all levels of the business and IT community during full project lifecycle
• 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.

Confidential

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.

Confidential

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.

Confidential

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 SQL Server, 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. Worked with an international team of PMs and developers to produce a database migration toolkit developed with Java/J2EE. Process improvement was provided from field use of the product and client conversion requests. 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.

Confidential

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.

Confidential

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.

Confidential

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.

Confidential

• 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.

Confidential

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.

Confidential

Director, Data Services

Confidential

Technical Manager

Confidential

Senior Database Administrator/Database Manager

Confidential

Database Administrator

Confidential

Senior Analyst/Programmer

Confidential

Programmer/Analyst