Thomas Dukes

Brought in to develop reports in Financial Reporting Studio. Built out various Balance Sheets and Income statements including consolidating reports. Built SmartView reports. Built multiple Alteryx workflows including publishing the server.

• Evaluated client needs and expectations, establishing clear goals for each consulting engagement.
• Liaised with various departments and management to better understand company needs and recommend appropriate solutions.
• Mentored junior consultants, fostering professional growth and building strong team dynamics.
• Developed effective improvement plans in alignment with goals and specifications.
• Supported clients with business analysis, documentation, and data modeling.

• Worked as independent consultant to personal clients in accounting and data analysis environments
• Development of statistical and financial models
• Database development.

• Consultant serving on team initiating implementation of ASC 606 Revenue Recognition rules
• Development and implementation of models used in ASC 606 implementation
• Audit support.

• Consultant serving Fortune 100 client in developing databases used in financial and statistical modeling
• Development and implementation of Tableau Dashboards
• Cost modeling using various applications including Alteryx, Excel and Access.

• Consultant to property and casualty insurance company in global Oracle system conversion project
• Developer of company financial reports using Hyperion Smart View
• Administrator of project financial data using Microsoft Project and Microsoft SharePoint systems
• Development and implementation of Smart View reports based on previous Sun GL VisionXL versions
• Microsoft Project and SharePoint administrator.
• Consultant to property and casualty insurance company analyzing and rebuilding databases used in monitoring internal processes and compliance reporting
• Preparation of statutory compliance reports
• Reverse engineering of existing Access database and complete rebuild into a menu driven application used in the United States, Europe and India to monitor and track over 10,000 compliance tasks
• Preparation of statutory compliance reports.

• Consultant to major insurance company enacting an international implementation and conversion of SAP systems
• Development and validation of company financial statements using SAP Business Planning and Consolidation (BPC) Excel tool
• Developed VBA routines used to enable various financial reporting functions
• Developed Access databases to convert and import legacy historical information used in conversion.

• Consultant to property and casualty insurance company tasked with developing an Access database to aid in preparing GAAP and statutory financial statements
• Created database managing premium and loss transactions for multiple subsidiaries
• Data reconciliation to the general ledger
• Compliance reporting.

• Worked as independent consultant to personal clients in accounting and Microsoft Access and Excel environments
• Interim controller for privately held construction company
• Developed VBA enabled Excel workbooks used by company to automatically segregate general ledger account transactions into separate worksheets for analysis
• Developed Access databases to automatically extract and analyze general account transactions from SQL Server database
• Developed executive level dashboard-type Excel workbooks used to analyze sales and expense data.

• Member of consulting group acting as third party fiduciary managing Federal grant awards for the USVI Department of Education
• Developed and implemented the USVI Department of Education’s first automated inventory system
• Developed Microsoft Access database application to normalize Excel inventory data into text delimited files for import into client accounting system
• VBA procedures automatically formatted the Excel input sheets into correct data formats and character lengths while checking for errors.

• Consultant for SOX related issue concerning development and implementation of complex sales reserve database tracking system
• Worked with Accounting, IT and Sales management to develop process for gathering, entering and reporting sales reserve data
• Worked with database developers in troubleshooting and enhancing sales reserve database system
• Trained new employee on procedures and maintenance of the database system
• Prepared procedures manual for operation and maintenance of system.

• Consultant to international company installing global budgeting and forecasting system in a fast paced environment with short deadline
• Worked directly with North American CFO in developing strategies for gathering, cleaning and inputting sales data into Prophix budgeting-forecasting system
• Coordinated information data retrieval with over 40 global subsidiaries for input into budgeting system
• Created and maintained Microsoft access database system to clean data and ready for input into Prophix SQL database.

• Consultant to publicly held company structuring a complex $300 million IRC Section 1031 Like Kind Exchange of real and personal property
• Developed project strategies including tax research and development of work programs
• Designed, implemented and maintained database and excel worksheets for tax calculation modeling and final calculations for tax returns
• Made presentations to senior management during the project of work progress and final tax calculations.

• Consultant to publicly held company involving financial restatement, forensic, tax and divestiture issues
• Consultant — Corporate Tax
• Designed and maintained data rooms to hold due diligence tax documentation for divestiture of divisions with a total value in excess of $1 billion
• Designed database for management of transactions for escheat audit
• Developed various databases and excel worksheets for maintaining and reconciling large pools of information including corporate and partnership entities
• Lead Consultant — Cash Reconciliations
• Oversaw team of 4 consultants resolving cash reconciliation issues
• Forensic reconstruction of cash transaction trails
• Developed and managed work program to resolve complex accounting issues for 350 bank accounts.