Technical Summary:

Project Manager within business group acting as application architect, coordination and liason to the IS department. Translating IS requirements for documentation and deliverables into business area requirements. Develop implementation schedule, plan and reporting requirements for multiple concurrent projects within the Environmental Health & Safety department. Work with Health and Safety personnel to define system requirments for software. Work with software vendors (MedGate, Chemical Safety, SAP-BW) to collect and define functional and reporting requirements and process flows for software. Plan and conduct weekly status meetings with deliverables. Designed and implemented EH&S KPI web system with user authentication and online reporting interfaces using PHP and Crystal Reports.

Technical Manager in charge of legacy Vantive applications (v9) and new PeopleSoft CRM 8.8 Support and Field Services implementation.
Hired and mentored 16 member development and implementation team. Designed project plan, steps to implementation and template documents for Gaps, Functional Specifications, Technical Specifications, Configuration Decisions and Server hardware. Designed hardware system to support 2000+ users on Sun Solaris system with Crystal reports/Enterprise and NT server. Reviewed Gaps for criticality and presented configurations in CRM which would replace functionality of Gap. Mentored team on PeopleTools 8.45 and technologies in CRM. Reviewed and managed Integration technologies that included Integration Broker, DB Snapshots, Application Engine load programs and XML near-time messaging. Designed EPM hardware and worked with functional analysts to define analytics. Familiar with Financials Services, Energy, Communications and Insurance verticals. Presented functionality reviews to functional team for possible uses within business team. Examples of presentations was worklist management, correspondence management, reminders, notifications, workflow, issue/case management, service request and fulfillment, contracts and services/entitlements.
Oversaw estimating of Gaps and technical solutions. Reviewed technical solutions with developers in pier review to validate the solutions and provide creative ideas for other solutions through configuration.
Managed budgets for team including forecasts for contractors, software, servers, services and business resumption systems.
Main contact for production systems and issues concerning legacy Vantive/Peoplesoft application. Required weekly review meetings to resolve reported issues. Reviewed issues and created solutions to reduce problem tickets by 100% and server system load by 10-20%. Upgrade Vantive system from unsupported v8.2 to v8.6 SP2 (9.x client). Upgrade went live with no user interruptions.
Reviewed CRM 8.9 and 8.8 to discuss mid-stream project plans on whether to switch to CRM 8.9 or upgrade. Involved reviewing business functions and mappings in both 8.8 and 8.9 with suggested course of action.

Implemented new PeopleSoft CRM 8.8 and CIS 8.8 with minimum integration between the two systems. Integration used EIP (Enterprise Integration Points) delivered with CRM and custom developed in CIS. Proven integration with near real-time synchronization was demonstrated. Implemented PeopleSorft CRM 8.4 and CIS 8.0. Modified CIS objects per Gap specification to support customized Inventory Rules. Reviewed Bugs and Issues to access criticality and assign to development groups. Mentored developers not familiar with PeopleTools 8.x. Completed several late and unsuccessful development programs which were started by other developers. Programs involved Application Engine, PL/SQL and Application Packages. Developed custom component and compound models using PeopleSoft Configurator (Calico). Component models utilized SQL queries to populate domain members, build constraints and generate XML for complex constraints. Designed and built custom CRM tables to drive the JSP and JAVA rules which dynamically enforced complex business rules. Project required in depth understanding of Order Capture (OC), PeopleCode, PeopleSoft Configurator (Calico), Application Packages and the CRM process. Promoted to Project Manager for Configurator Team. Met or exceeded goals and project timelines. All work was done on PeopleSoft CRM v8.4, CIS 8.1 and PeopleTools v8.17 and v8.4

Install PeopleSoft CRM 8.16 and tools on Windows 2000 server. Configure SQL Server and PeopleSoft client. Determine client requirements for CRM, Sales, Marketing, Field Services based on customer requirements (business processes) and PeopleSoft supported functionality. Discuss with customer options for implementing functionality within standard functionality to limit customizations and implementation time. Analyze workflow within client to define additional Rules, Roles and Routings for custom workflow requirements. Implemented PeopleSorft CRM, Field Services, Sales, Marketing for customer running on windows and Oracle database with HTML interface.Create new records (derived, view and tables) to support new 360°ree; view objects. Modified existing 360°ree; view screen to accommodate new objects, to restrict sub page where clause and add additional fields and sub pages Created new 360°ree; product screen to view an installed product for a client. This required the modification of over 140 objects ranging from complicated PeopleCode to new fields view and records. Created new consolidated search screen for 360°ree; view. Screen uses dynamic where clause and derived work record to streamline users' search into a single screen. Created new 360°ree; (Customer Interaction) menu and components to support new objects. All objects (screens, fields, menus, message catalogue, records, etc.) were done in Multi-language to support English and French. Project required in depth understanding of Customer Interaction, PeopleCode to dynamically modify objects, multi-language options and configuration, Interaction processing, Workflow and Worklists, Customer, Products, Cases, Service Orders, RMA's, Contacts, Opportunities, Leads, Contracts and Contract lines, Call Center, Field Service, Products and Items and Business Rules. All work was done on PeopleSoft CRM v8.1 and PeopleTools v8.16

Prepare and install Oracle Applications 11i (11.5.5) with 9iAS on Linux multi-tier servers to support multiple functions of the company. Acted as DBA/Administrator for 11i installation requiring configuration of roles, security, installation configuration (DB, etc.). Required review of file systems requirements, application modules used and desired performance based on node configurations. Required modification of env_*.mk make files to use Linux 6.2 libraries. After modifications, install went seamlessly on both the database server node and forms server node. All financials modules, istore, eprocurement , service/contracts, grants and CRM were installed. Install test instance of Oracle 9i for J2EE (OC4J) and 9iAS testing. Imported legacy data to load and migrate information. Duties included: applying patches both tar/zip replacements and through adpatch; configuring responsibilities and roles for users, concurrent manager configuration (jobs, shifts, holidays, etc.) and review of technical issues and bulletins for updates.

Review existing PL/SQL application code of over 28,000 lines to determine complexity, architecture, functionality, database tables used, and general program flow. This code is used to make automated loan decisions after the loan officer has gathered all the information. The code is quite complex in statistical computations, user defined structures and collections, over loaded function/procedures and redirection. The information collected from the PL/SQL code review will be used to re-architect the system for newer entities and greater functionality to support multi-state requirements. Created UML diagrams using Magic Draw of (Sequence and Use-Case) for program flow, complex variable derivation and variable usages.

Provide expert perspectives on JD Edwards' One World software installed at a client and problems seen during attempted go-live. Investigate design, program execution, Oracle installation and setup to determine problems and causes of software failures. Provide counsel during depositions. Review testimony and affidavits for technical issues.

Reverse engineered existing panel survey applications to define and modify existing software. Developed software using csh, ksh, bsh, PL/SQL, and Web Objects to support production applications. Diagnosed performance and data integrity problems on database and Web Objects applications using logs and database queries. Modified two production batch jobs in PL/SQL to reduce run times by 150%. Managed panel data for research analysts which required loading/extracting into excel or similar format. Developed formula and technique to flatten out a tall table using complex database structures. This process of flattening out a table replaced an existing program which reduced run time by 50% and allowed real-time analysis of incoming survey results. Designed high-availability 24x7 redundant production platform on Redhat Linux running Convolo Cluster manager, Oraclel 8.1.6, mirrored and striped disk array dual mounted to two Linux systems. System performed 400% faster than previous Sun based system and reduced operating/purchase cost by 50%. Installed and configured Legato backup software, Oracle Enterprise Manager 2.x and Legato Networker Oracle backup module and RMAN to perform online backups. Restored production tables and entire environment to development servers using RMAN backups. Worked with NT administrators to promote a BDC to PDC after a hardware failure. Then on recovery of the original PDC worked to demote it back to being the BDC.

Configured Hummingbird Exceed for NT clients to access various disparate servers. Required in depth knowledge of TCP/IP, X, network services on NT (hosts, routes, DNS, default gateways, domain resolution, ….).

Analyzed and designed a database for an E-commerce web application. Design included interfaces for credit card/ATM processing, advertiser and advertisement processing, multi-dimensional attributes, and secure sign-on/login. System will go online with Oracle Application Web Server. Designed and configured high-availability hardware to support 24x7 requirements.

Tuned Oracle®/Vantive® installations to improve overall performance and system security. Advised CIO on platform and development installation to protect production environment and allow increase productivity in enhancing Vantive application. Diagnosed problems by examining key performance parameters within the Oracle data dictionary using tools (DBA Reports®) which provided key diagnostics and documentation for Oracle®. Wrote Invoicing system using Oracle Reports 6i® and PL/SQL. Invoicing system maintained Accounts Receivable, Billing, Payments and Statements. System required high-security and validation for state administrators and accountants.

Tuned Oracle®/PeopleSoft® installations to improve overall usability. Tuning included Cytrix® installation for client and server, application manager parameters, process scheduler parameters, database parameters and physical database structures. Diagnosis was done by examining key performance parameters within the Oracle data dictionary. Proprietary tools used were DBA Reports® which provides key diagnostics in the Oracle® environment. Advised on platform configuration and on server purchases to enhance performance.

Worked with NT administrators to debug NT Citrix server installation and configuration. Citrix is a complex shared client/server application which allows clients to be disk-less and run applications on the server. The applications here were SQL*Plus, PeopleSoft, Tuxedo transaction manager, SQR (PeopleSoft reporting tool), PC*Anywhere, and general MS products. Installed NT 4.0 on DEC Alpha for server install. Configured user shares and access. Applied service packs 1-6a. Installed and upgraded PeopleSoft server, transaction engine and clients. Diagnosed performance problems in online PeopleSoft screens and SQR batch processes. Increased performance of applications by over 1000% (several days for a process prior to enhancements to a few hours after enhancements).

Installed and configured Oracle on Compaq Zenon server(s) running Windows NT 4.0/patch 3 for PeopleSoft financials applications. Configured ArcServe for NT to do online (hot) backups from a remote backup NT server. Configured exports to file systems for logical data recovery. Debugged performance problems where clients and server had differing performance. Planned new development installation to mirror the production system. Worked with NT users and Administrators to troubleshoot security issues. Configured automated batch jobs to do database maintenance and reporting for growth monitoring.