DIMA DMITRENKO, CPA
Keller, TX 76248
****.*********@*****.***
EDUCATION
University of Texas at Dallas
M.S. in Accounting and Information Management August 2008
B.S. in Accounting and Information Management May 2007
TECHNICAL SKILLS
. MCSA - SQL Server
. Microsoft Office expert, VBA, VBScript, SQL, MDX, SSIS, SSRS, SSAS
. Knowledge of JDE, SAP, AS400 ERP systems
WORK EXPERIENCE
XTO Energy / ExxonMobil, Fort Worth TX April 2012 -
Present
Database Developer
. Initiated, developed and led business process improvement and
reengineering initiatives, including related database development
projects that maximized enterprise capabilities and efficiencies
. Worked directly with accounting teams to analyze business requirements
and translated findings into proper system specifications. Designed and
programmed final systems solutions utilizing Microsoft Office suite, VBA,
and SQL Server
. Provided guidance and support to accounting teams in the implementation
of new functionality, maintenance and upgrades of SQL databases
. Provided technical direction, functional support and served as a primary
liaison between Accounting and IT
. Troubleshot and solved complex and unique technical issues and partnered
with end users, developers, and consultants to develop creative solutions
. Designed and delivered training to the user community as well as trained
and mentored less experienced developers
AMX LLC, Richardson TX Feb
2009 - April 2012
Accounting Supervisor
. Supervised financial reporting and general ledger groups
. Coordinated the development and implementation of processes, policies,
and operational procedures to control all aspects of accounting
functions, including improvements in inventory control and other
accounting processes
. Designed and implemented processes, controls and disclosures to ensure
compliance with Sarbanes-Oxley requirements
. Oversaw execution of special projects at senior management's request
. Coordinated budgeting, forecasting and monthly balanced scorecard
analysis and reporting
. Coordinated month-end close of the general ledger for the branches,
including consolidation of this information
. Participated in establishing short and long-term financial goals and
objectives
AMX LLC, Richardson TX May
2007 - Feb 2009
Financial Reporting & Analysis Lead, FP&A Group
. Designed and maintained executive financial reporting package gathering
data from various sources using C#, VBA, SQL and MDX languages
. Fully automated various business processes, including orders and invoices
reporting, R&D project costing and ROI
. Developed methodologies, dashboards and models for operational metric
budgeting and reporting
. Coordinated budgeting, forecasting and monthly balanced scorecard
analysis and reporting
. Generated monthly/quarterly forecasts and annual budgets
. Assisted in establishing short and long-term financial goals and
objectives
. Analyzed, interpreted, and reported on periodic business performance,
including revenue, gross profit, operating expenses, pricing, and cash
flows
. Performed variance analysis, special projects and ad-hoc financial
reporting for executive and senior management
. Provided guidance and assistance with forecast and budget preparation,
expense policing, and other finance related inquiries to Marketing,
Administration, and R&D groups