Manager Project
Resume:
Scott P. McPherran
Miramar FL 33029
******@*****.***
EMPLOYMENT
TOUSA Homes Apr 2004 – Current
Chief Information Officer Hollywood, FL
Manage all technical operations related to network infrastructure, server engineering, telecommunications, Helpdesk and PC Support functions for corporate office and 15 divisions located throughout the United States. Maintain all network/telecommunications traffic through data center located in Atlanta that supports, Windows, Unix and AS400 environments.
Manage a development staff skilled in SQL Server, Essbase, DB2, RPG, Java (J2EE), .NET and Visual Basic who are responsible for the creation and maintenance of a wide variety of relational and multidimensional databases used in decision-making at all levels of the 11th largest homebuilder in the United States.
Manage Web Development group that designed and maintains a supplier portal allowing the 5,000 vendors of Technical Olympic to stay current on key purchase order, accounts payable and construction scheduling information related to their business. Group is also responsible for development of CRM, Website development and data interface to and from 3rd party vendors for lead management. Managed the development of an internal web application using MS SharePoint and .NET programming that allows internal users and subcontractors to access the most current architectural plan information resulting in a $250,000 annual savings.
Manage Business Intelligence group responsible for the design and maintenance of an Essbase financial forecasting database that stores actual and projected financial and backlog information for the past three years and projections for the next three years. Responsible for design and development of Data Warehouse using DB2 SQL
Responsible for all maintenance and development of AS400 based ERP system (HSP) that handles all job costing, purchase order, accounts payable and general ledger functions for Technical Olympic including their Homebuilding, Title, Insurance and Mortgage divisions. Insure data integrity through streamlining of business process, improved data validation and work flow. Establish data interface to between Technical Olympic's ERP and all secondary applications including the web based CRM solution (Builder 1440), construction scheduling application (Appwright) 3rd party vendor lead management and all Technical Olympic websites. Responsible for the maintenance and development required for all secondary applications.
Led the conversion of 7 acquired divisions into company ERP along with implementation and integration of company CRM solution (B1440), construction scheduling application (Appwright) and re-engineered marketing and corporate websites to integrate and streamline all acquired companies operations in to corporate culture.
The Sports Authority August 1998 – Feb 2004
Director of Business Intelligence Fort Lauderdale, FL
Managed a development staff skilled in Oracle, Essbase, RPG, SQL and Visual Basic who was responsible for the creation and maintenance of a wide variety of relational and multidimensional databases used in decision-making at all levels of a $1.5 billion retail organization. Handled the performance, tuning and sizing of all data sent to the Datamarts from JDA and Lawson ERP files residing on four AS400 servers and two RS6000 servers, storing over 5.5 terabytes of information. Maintained Essbase multidimensional databases used to track all aspects of business for over 200 stores and two Regional Distribution Centers operating throughout the United States. Disseminated Business Intelligence data reporting to corporate employees using the following OLAP tools: Showcase Analyzer, Analyzer for the Web and SPSS Enterprise Reporting.
Provided data to store managers and field agents via a secured connection on the World Wide Web. Created inventory model in Essbase that compared inventory values for an entire fiscal year at a Store/Subclass level from both our General Ledger and Retail Systems using SPSS Warehouse Builder ETL tool. Wrote audit process that identified variances between Oracle Arthur Allocations Database (Unix based) and JDA Retail system (AS400 based) that writes correcting entries on a nightly basis to keep systems in sync. Built Open to Buy system that allowed Merchandise Buyers and Planners to interactively project inventory levels at Sub-department level while instantaneously rolling those numbers to the Department, Category Business and Division levels, allowing executives to rapidly implement company Open to Buy strategy. Provided training on a Beginner, Intermediate and Advanced level to corporate employees on the use of Showcase Query, SQL and Essbase interfaces.
Responsible for Logical and Physical data modeling using Erwin for database modifications to insure both the business and technical needs of all projects are addressed. Performed as Technical Project Manager of company conversion from Legacy Systems to the JDA Retail Management DB2 system. Managed the implementation of Retail Ideas, a merchandise decision support system, MarketMax, a store space allocation package and creation of CRM with more than nine million households currently stored. Provided Oracle and data interface support for implementation of Kronos TimeTracker-Workforce Scheduler and Arthur Allocations projects. Supported web applications running on Weblogic and Websphere application servers (both are J2EE Compliant).
Gunster, Yoakley, Valdes-Faulí & Stewart May 1996 – August 1998
Finance Manager/Financial Systems Manager Palm Beach, FL
Managed Finance Department with three full time accountants, two accounts payable clerks, one trust/payroll clerk, seven billers, two collectors and two accounting clerks that collectively provided accounting support to seven separate offices with over 300 employees. Oversaw the billing and collection of over fifty million dollars in legal fees and disbursements annually. Provided the training and orientation of new accounting and legal staff on proper and ethical finance procedures. Designed, produced and maintained End of Month/Year financial reports using CMS Financial Database (Sybase DB) Report Writer, Standard Query Reportwriter (SQR) Excel, Norman Weiss Report Writer (Overlay program that uses Access engine) and Monarch Data Retraction.
Designed, created and maintained an SQL Server database that produced a wide variety of financial reports. Provided reports and financial information on demand using SQL and CMS Management Menus. Supervised the release of paychecks for billing attorneys and legal staff. Authorized payment of vendor invoices, employee personal reimbursements and Trust account disbursements. Resolved customer complaints and mediate attorney/client fee disputes. Produced a wide variety of documents using WordPerfect 6.1, Word 97, Excel 97, PowerPoint 97, RFFlow, and Corel Draw. Created and maintained web pages for the Firm’s Internet site
89 AW Judge Advocate General's Law Office June 1993 - May 1996
LAN Network Manager Andrews AFB, Maryland
Installed Novell 3.12 LAN system for Law Office that operated for two years with less than two hours of unscheduled downtime. Network Manager for conversion to Microsoft Ethernet Network. Trained paralegals and attorneys on computer hardware and software. Maintained twenty-five workstations. Designed internal programs for MS Word for Windows 6.0, Word Perfect 6.0, MS Access 2.0 and MS Excel 5.0 using Visual Basic that maximized efficiency. Analyzed office functions and identified areas that could be improved through the use of available computer software. Made decisions for new acquisitions.
Paralegal
Processed personal property and tort claims for and against the U.S. government in accordance with Air Force regulations and guidelines. Provided basic legal assistance to military personnel and their dependents by assisting minor dispute resolution, researching legal issues, and will preparation. Prepared and maintained bi-weekly dockets providing discovery and superseding information to attorneys for Andrews Air Force Base Magistrate Court which tried over four thousand cases annually. Managed thirty-five part time employees for the Andrews Base Tax Facility and coordinated their training with the Internal Revenue Service and local tax agencies. Administered the first tax program in US Air Force history responsible for the preparation of over three thousand state and federal returns electronically.
24 Air Postal Squadron June 1988 – June 1993
Postal Finance Officer Albrook AFS, Panama
Acted as Postal Finance Officer maintaining a five hundred thousand-dollar floating credit account that disbursed funds and postal effects to all the American embassies and Military Stations in Central and South America. Maintained an eighty-six thousand dollar annual budget for an Air Force Postal Squadron. Procured Surveillance cameras for counterdrug operations of the U.S. Southern Command. Acquired and installed computer systems along with developing a computerized mail directory database using DBASE IV. Member of audit team responsible for inspecting all U.S. embassies in Central and South America.
EDUCATION
2002- 2005 Masters Business Administration, Magna Cum Laude
Regis University, Denver, Colorado
September 1995 Bachelors of Science, Cum Laude, Computer Information Systems
AA, Civil Engineering
AA, Paralegal Studies
Strayer College, Alexandria, Virginia
AWARDS and HONORS
Winner of The Sport’s Authority’s Quarterly Victor Award in April 1999 and October 2000. Named Annual Victor Award winner in March 2002 for Customer Service.
Two Air Force Commendation Medals/ Two Air Force Good Conduct Medals
Distinguished Graduate of AF Paralegal School & Airman Leadership School
Named Airman of the Quarter at the squadron level six times and twice at the base level. Named Airman of the Year in 1992 and 1995.
Contact this candidate