WILLIAM J. MCNICOLL, MBA, MS ACCOUNTING
CORPORATE FINANCIAL & BUSINESS ANALYST
HOUSTON, TEXAS 832-***-**** adbjra@r.postjobfree.com
Executive level Corporate Finance professional with significant experience that spans over 15 years. Recognized as a strong leader who not only meets but exceeds both client and company expectations. Proven track record of process and productivity improvement providing both revenue enhancement and cost reduction. Demonstrated successes in developing Excel-based productivity tools, transforming time-consuming reporting processes to rapid generation of presentation-ready output with push-button ease. Thrives in a fast-paced environment with the ability to make rapid revisions to tools to meet new requirements or respond to changing customer expectations. Highly skilled in financial analysis, managerial reporting and financial modeling. Currently seeking a role within a company that will view my skill set as beneficial and a valuable addition to their team.
AREAS OF EXPERTISE: Financial Reporting Financial Analysis Financial Planning & Analysis Advanced Pivot Tables Advanced Excel Functions Visual Basic for Applications (VBA) Microsoft Excel Macros Excel-based Modeling Oracle Relational Database Design Structured Query Language (SQL) Scrum Software Development Treasury Operations
QUALIFICATIONS:
Excels at bringing a technical discipline and problem-solving capability developed through engineering to business and financial issues.
Ability to communicate with various types of people and personalities which has aided in cultivating client relationships, diffusing situations and having positive interactions with colleagues.
Experienced in Structured Query Language (SQL) coding and development of relational databases in Oracle.
Committed to improving skills through certification programs, advanced degree work and active membership in Toastmasters.
Strong analytical skills; support operations through analysis of key performance indicators and trends.
SELECTED ACCOMPLISHMENTS:
Saved $72,000 per year by re-inventing the format and process for generation of a critical data package used by the Boeing Space Station program management team.
Saved $50,000 per year by replacing an Access database application with an Excel-based processor.
Reduced time spent planning by 50% through creation of an Excel-based tool for the annual Program Operating Plan that utilized VBA code to prevent errors, ensuring quality input for the costing process.
PROFESSIONAL BACKGROUND:
2017-PRESENT: FINANCIAL REPORTING AND SOFTWARE ENGINEERING
ROTHE DEVELOPMENT, INC. HOUSTON, TX
In charge of developing Excel-based tools and processes for financial reporting under a contract with NASA Johnson Space Center, Flight Operations Directorate.
Handle the management and maintenance of software applications involving Scrum agile software development, Git version control and GitLab.
FINANCIAL ANALYSIS AND REPORTING
ANADARKO INDUSTRIES, LLC (2010-16), AND MEI TECHNOLOGIES, INC. (2004-2010) HOUSTON, TX (2004-2016)
Reported cost and schedule status of Space Station Program as well as status of engineering and safety requirements and hardware deliveries.
Developed custom tools and processors for status reporting.
Generated status presentations for management also generated a status package to support a weekly review.
Produced PowerPoint presentation directly from Excel data table using Excel Visual Basic for Applications (VBA).
Maintained custom reporting tool for status of hardware deliveries.
Managed critical reporting systems to ensure engineering and safety requirements were completed in order to bring about a successful mission to the International Space Station.
Recognized for reducing process time by 62% and saved $72,000 per year by re-inventing the format and process for generation of a critical data package.
Established a data collection tool in Excel to generate an accurate estimate of the cost to retire the Space Shuttle and transition to alternative vehicles.
Synthesized inputs from multiple engineering discipline groups for monthly financial and technical review.
Conducted Earned Value Management analyses.
EDUCATION & PROFESSIONAL DEVELOPMENT:
MASTER OF SCIENCE, ACCOUNTING
University of Houston Clear Lake, Houston, TX
MASTER OF BUSINESS ADMINISTRATION (MBA)
University of Houston Clear Lake, Houston, TX
MASTER OF SCIENCE IN AEROSPACE ENGINEERING
Georgia Institute of Technology, Atlanta, GA
BACHELOR OF AEROSPACE ENGINEERING
Georgia Institute of Technology, Atlanta, GA
CERTIFIED CORPORATE FINANCIAL PLANNING & ANALYSIS PROFESSIONAL
Association for Financial Professionals
CERTIFIED TREASURY PROFESSIONAL
Association for Financial Professionals
CERTIFIED ASSOCIATE IN PROJECT MANAGEMENT
Project Management Institute - expired
Shareholder of Green Bay Packers, Inc.
Member of Clear Lake Toastmasters, Club #43, Houston, TX
Charter Supporter of the Ludwig von Mises Institute, Auburn, AL
Member of United States Golf Association