Michael P Coughlin (401-212-0892)	48 Bellevue Avenue, Westerly, RI  02891
MPC317 at gMail dot com	46 Gale Street, Malden, MA  02148

Profile: project manager/systems designer programmer/financial analyst/MBA (3.9/4.0)

technologies

Languages	SQL, PHP, JavaScript, C# .Net, Visual Basic, Crystal Reports
Operating Systems	Microsoft, Linux
Database Development	Microsoft SQL Server & Access, SQLite, MySQL, Oracle, DB2 (reporting, using Control Center, IBM Developer Workbench and Aqua Data Studio)
AMP	Apache, MySQL, PHP
Office Suites	Microsoft Office, Microsoft Project, Open Office
Web Development	PHP, JavaScript, CSS, HTML, MVC framework libraries

strengths

• Award-winning project manager; demonstrated leadership in challenging environments
• Full-project-lifecycle development (identifying requirements & getting it done) via “best practices”
• Visualizing complex business-system interrelationships and architectural design
• Startup-business planning, budgeting, forecasting, development

industries

• Distribution & direct marketing (catalog sales)
• Insurance & banking
• Energy (oil & gas exploration) & chemicals
• Aerospace & government
• Manufacturing operations product-line forecasting & accounting
• Automotive

career Highlights

• Director, Management Systems in #8 on Fortune 500
• Air Force corporate commendation for long-range data-processing planning
• Startup business planning & operation

honors

• Won Hughes Aircraft a U.S. Air Force commendation for best long-range data processing plans (compared to McDonnell-Douglas, Boeing, Rockwell, Northrop, General Dynamics, Grummen etc.).
• Elected to Beta Gamma Sigma, the national business scholastic honorary society.

experience

Data-based-Systems.com (owner, since 1995) designs and programs custom business systems.  Example projects …

Client   Data-based-Systems.com   Tools   PHP, SQLite, CodeIgniter framework Role   FPLC/SDLC - 100% of project management
Project Description   convert Data-based-Systems.com to an object-oriented (PHP MVC framework) database (SQLite) driven architecture. Used small HTML 4.01 Strict documents for search engine 'friendliness'; sidebar links are database generated through the MVC framework in 0.01 seconds.

Client  a catalog direct-marketing firm  Tools  SQL Server, C# .Net, VB, ADO, Crystal Reports, Access, Excel  Role  FPLC/SDLC – 100% of project management
Project Description  Client had an old 3rd-party order-entry and warehouse fulfillment system, which they would not abandon – for economic and political reasons ... and asked for analytical and reporting capabilities, lacking in their old system.  Project management success required “handling” VP’s with conflicting agendas – to the surprise and delight of the President.

• Designed and built a high-volume (6.5 million customers, 7 million orders and 15 million order items) data mart on SQL Server, which automatically rebuilds itself, nightly, via ~ 100 DTS ETL Packages, including data typing from a non-data-typed source.
• Planned for the RAID capacity, physically built the server, installed the operating system and configured Windows domain authentication.
• Built all department analytical systems, utilizing this datamart.
• Generates operations reports in ~4 minutes, prompting via VB only for date boundaries, passed to stored procedures which go through 2.5 million records 24 times in 2 minutes.  Analysts used to collect component reports for three days – to generate the equivalent operations report. 
• Wrote stored procedures to generate demand by order-entry system, cost per order, backorders, open orders (e.g. hold-to-arrive open orders, customer pickup open orders, re-ship open orders and open orders by age) and shipments reports in Seagate Crystal Reports.
• Built a warehouse labor tracking system, integrating timecard and operations systems to track picker and packer productivity and packer-error exchange reports.
• Built a marketing system, utilizing stored procedures to feed ~25 reports for mailed-catalog forecasting analysis.
• Reports demand during user-defined periods by drop, drop split, drop & segment etc.
• Process customer email opt-in and opt-out demands for email promotions.
• Group email customers by various criteria, such as orders-by-quarter and orders-by-category for selective promotions.
• Wrote cross-selling code to present Top 3 purchases by others who bought the item in the buyers’ shopping cart.
• Coded support clients’ LinkShare commissioned sales program, including C# programs to generate and maintain text files, demanded by the merchandiser affiliates program.
• Implemented the above systems with VB and Access front-ends to supply parameters for stored procedures to do the 'heavy lifting' for analysts.
• Small resultsets were written directly to the user spreadsheets for more elaborate formatting and analysis.
• Reduced 1.5 days of Microsoft Access queries to 1.5 minutes, using VB through ADO to SQL Server.
• Received Administrative privileges to all systems and 24x7 facility access reflecting trust, earned.

Client   a recycling firm  Tools  Microsoft Access  Role   FPLC/SDLC – 100% of project management
Project Description  Point-of-sale system, requiring parts-picking & sales slip in 2 windows, constantly on screen + MIS reports.  Designed, developed, documented & delivered in 10 weeks.

Client   Platte Chemical  Tools  Visual Basic, SQL Server, RDO, ODBC  Role  a module
Project Description  Production-line bar-code assignment, requiring nested loops (for bottles, cartons & pallets), updating SQL Server in ~1 second - for manufacturing process-control software (Wonderware).

Client   Barrett Resources  Tools  SQL Server, Access  Role   reporting enhancements
Project Description  Custom queries & reports for an oil & gas industry trading programs.

Client   Ball Aerospace  Tools  Oracle, Access  Role: data-loading macros
Project Description  ETL into Oracle; `took substantially less time than client estimated.

Client   Surprenant Cable Corp.  Tools  Microsoft Access  Role   FPLC/SDLC – 100% of project management
Project Description  brought in PC’s, servers & network; designed & wrote quote system, part number cross-referencing system & cable-engineering design system; all delivered in 5 months.

Client: AlliedSignal  Automotive Tools  Microsoft Access  Role   FPLC/SDLC – 100% of project management
Project Description:  Data warehouse for income statements by product line, product category, distribution channel & customer; ~70 IBM AS/400 queries and ~100 tables (delivered and documented in 5 weeks).

Client   Dunn & Co.  Tools  Microsoft Access  Role   FPLC/SDLC – 100% of project management
Project Description:  Order entry, production scheduling, warehouse inventory control, MIS reporting, accounting handoff (delivered in 5 weeks) – for a book refurbishing firm.

Client   GE Capital, Stamford, CT Tools   Microsoft Access  Role   FPLC/SDLC – 100% of project management
Project Description:  Commercial real-estate product-discount service (order entry service followup/scheduling, MIS activity management and direct marketing).  Client needed design and data entry within 2 weeks (delivered in 2 days).  Delivered & documented within 6 weeks.

***************************************************************

Digital Equipment Corporation Stow, MA  technology-startup business planning & project management
Negotiated flourishing independent software vendor relationship in the adaptive pattern recognition market.  Developed a content-based retrieval office product through 6 customer-requested base levels and four pricing tests for 1/4 the investment of a competing Digital Central Engineering product which never got to market. Business planning for networking technology businesses (a patented server dynamic tuning capability; an inexpensive, high performance NFS file server; X.500 Directory Services; mail integration into a multi-server network operating system and mobile computing) and emerging information retrieval and machine learning markets (approach won contracts in excess of delivery capacity).

Health Professionals Corporation Woburn, MA  Venture Startup – Owner
Designed, programmed and test-marketed (in Rbase, VPPlanner i.e. Lotus 123) a tax-deferred 401k savings/retirement and profit sharing system to provide temporary-worker benefits.

Conoco/duPont Houston, TX  Director, Management Systems, North American Exploration
Designed and directed North American Exploration business systems development (financial modeling, planning and forecasting); none pre-existed this effort.  Managed sourcing, testing & installation of hardware and telecommunications for business systems access by 9 U.S. and Canadian Divisions.  Configured and networked workstations for business and scientific mainframe access, as well as personal computing, before the market offered these.  Designed the risk analysis system (80 Cobol large array subroutines on a Cyber mainframe) that Conoco used in sealed-bidding lease sales against Exxon, Mobil etc. to win nearly 50% of Gulf of Mexico tracts - worth $billions in cash flow over a decade.  Amoco took five times as long with more people to produce less-successful results.  Represented $400M North American Exploration on the duPont Long-Range-Planning Task Force.

Hughes Aircraft  Los Angeles, CA  Senior Financial Analyst
Changed long-range data processing planning (60+ computing centers, $100 M/year, 50,000 employees) from hardware-capacity emphasis to customer-demand orientation.  Won a U.S. Air Force corporate commendation for best defense contractor long-range data processing plans.  `had Secret clearance at Hughes Aircraft.

Related Experience

• Manufacturing product-line cost-absorption forecasting.
• A bank management-training program - all departments … accounting, auditing, secured and unsecured lending.  Highest mark in Boston banking association “Home Mortgage Lending” class.
• Estate and small business financial planning (Connecticut General trained & NASD-licensed for securities sales).

education

University of Denver	Master of Business Administration (3.9/4.0 GPA)
U. of Lowell (Lowell Technological Institute)	B.S. Industrial Management Major: Finance

studies & writing

More than appropriate on a resume, regarding systems designed & built, writings, readings etc. is available at: http://data-based-systems.com/articles/systems/trackRecord.htm