|
Randall L. Hitchens |
|
|
203 313-2812 (C) |
41-B Secor Road |
|
203 775-1955 (H) |
Brookfield, CT 06804 |
|
413 723-8407 (F) |
rlhitchens@actioncentric.com |
More than a decade of full life cycle Project Management; Technical implementation team leadership; System architecture planning; Data Warehousing; Digital Asset Management; database design; .NET; various ETL tools; various OLAP reporting tools; various ER modeling tools; ORACLE, Teradata, SQL Server; Sun, IBM, Teradata, and DEC hardware running MVS, Solaris, VMS. Application areas include Customer Relationship Management, Supply Chain Management, Manufacturing Execution Systems, financial and marketing applications.
Specific industry experience includes Consumer Marketing, Manufacturing, Distribution, Pharmaceuticals, Insurance and Health Care, Investments, Publishing, and Retailing.
Background ranges from real-time systems developed in assembler language, through large Data Warehouses using state of the art tools, languages, and facilities. Selected professional experience includes the following, mostly from consulting positions:
2001 – Present as an independent consultant, Action Centric LLC, specializing in project management.
· 2002: Assembled a team and developed vision, roadmap and specifications for Outsourcing Partners International, a privately owned financial systems outsourcer, for internationally accessible application servers and offshore developers.
· 2001: Managed the QA team on a state of the art MS .NET implementation of an extranet portal accessing some of FM Global’s backend systems.
1998 – 2001 as a Manager with KPMG Consulting (now BearingPoint) managing projects.
· 2001: Led the Data Warehouse track on a Datasweep MES implementation for Lucent Technologies. The three databases (Active, ODS, and Mart) were Oracle based. ETL between the databases was handled with Microsoft’s Transaction Server. The OLAP tool was Business Objects using Web Intelligence and Info View. The team consisted of a half dozen people making up 4 FTEs. The track was responsible for mapping the legacy system information into the Datasweep package databases, document the mappings among the package databases, specifying, writing, and documenting approximately 100 reports, and arranging training, support, and the rollout. Challenges surmounted included balky package behavior, lack of client resources in each implementation phase, and lack of client expertise in each of the package elements.
· 2000: Designed special cost accounting interfaces and complex reporting specifications for Freightliner’s Financial Information System Data Warehouse. The sources of data for the Data Warehouse included SAP interfaces as well as external files imported from foreign subsidiaries. Complexities addressed included consolidations, inter-affiliate transfers, and profitability analysis.
· 2000: Evaluated content management vendors for Target to select the tools used to move them to eCommerce using commercially available packages to replace a home-grown, under-powered system. The dynamic, seasonal nature of the business, and tracking more than a quarter million SKUs meant having to manage as much as 1 million images and other media.
· 2000: Planned, for 3M, a web-enabled extranet interface to legacy international order entry systems with particular emphasis on handling the tricky documentation and regulatory requirements of the systems.
· 1999 – 2000: Managed a team developing the highly customized ETL and web-based back-end support systems of an international supply-chain data-warehouse for Arrow Electronics. The support systems included both data management through the client’s Intranet and complex rule-driven data cleansing written in Java.
· 1998 – 1999: Managed the data extraction team on a Customer Management data-warehousing project for Doubleday, a division of Bertelsmann. Working at Doubleday’s headquarters, the team helped develop the data mappings, transformation rules, data dictionary, source code, job streams, documentation, and project plans, developed all program specifications, test plans, and supervised the team during programming the extracts, unit, integration, and volume testing, and the startup of production.
1994 – 1998 as an independent consultant, Randall L. Hitchens LLC, specializing in building DSS and EIS using 4th generation languages and Client/Server technologies.
· 1998: Managed for United Rentals, an initial start up firm growing rapidly through acquisitions, a team to assimilate up to 7 new companies' data per week. Working at the firm's headquarters, the team received data from conversion teams at each of the acquired companies. This extraordinarily successful project resulted in the conversion of 25 companies with nearly 100 locations nationwide in just over one month and put the firm nearly a year ahead of their schedule for growth.
· 1997 - 1998: Managed the technical conversion of claims tracking data from the legacy system (RMS) to a new client/server system (Rdb) for Intracorp, a subsidiary of Cigna. This included producing all the project plans, documents, schedules, staffing requirements, building the conversion matrix and supervising the programmers during implementation. The programmers used Prism and COBOL for the conversion.
· 1997: Reviewed for GE Capital’s Real Estate management group, the design of an existing system and proposed a number of enhancements and changes to simplify and streamline the systems while optimizing the investment in programming and maintenance efforts. The proposals were accepted and implemented after being expanded to include other divisions of the parent corporation.
· 1994 – 1997: Managed for a Purdue Frederick, a tightly regulated pharmaceutical firm, a team that developed a digital asset management system for the firm’s packaging artwork and text, and for the package inserts. The LAN-based system used Documentum, Oracle, Powerbuilder, C++, and some FOCUS to build a custom document workflow system. In addition to supporting complex routing, the system had to secure each approval and positively identify each signature digitally using Smart Cards, pins, user Ids and passwords.
1983 – 1994 consulting for Sundance Software, Inc., a boutique consulting firm, building large interactive databases to support both DSS and operational systems.
· 1993 – 1994: Managed for A. C. Nielsen Media Research, a team of as many as 8 programmers to implement an extremely complex reporting system for ratings. The system downloads ratings information daily and produces a wide range of reports. Users of the system are able to define their own reports, store them, and run them as needed.
· 1983 – 1993: Numerous projects, across Marketing, Financial, Pharmaceutical, Manufacturing, and other industries.
9 years industry experience working for Nestle, General Foods, and Chesebrough-Ponds implementing systems for: Cash Accounting, Finished Goods and Work-In-Progress Costing, Risk Management, Capital Projects Tracking, Factory Shipments and Forecasting, and an Interactive Coffee Blending process control application. The last several years were spent supporting users using interactive data management systems such as FOCUS and EXPRESS.
Frequent speaker at trade meetings and educational symposia. Author of several trade journal and newspaper articles. Chaired the Y2K committee for the National Focus Users Group and chaired a roundtable on the Y2K challenge published in Information Week.
· Charter member Microsoft Certified Solutions Developer
· Gold Certified MicroStrategy DSS Consultant
· e.Piphany
· Working on PMP (Project Management Professional) certification from PMI (the Project Management Institute)
· Masters of Engineering in Operations Research / Industrial Engineering from Cornell University
· Bachelor of Science in Engineering from Cornell University
· Secondary school diploma from L’Ecole Internationale de Geneve in Switzerland.
· Speaks moderate French.
· Willing to travel.