Sign in


Denver, Colorado, United States
February 14, 2018

Contact this candidate

James Durkin, MBA


MBA, San Diego State University, San Diego, CA BS, Oregon State University, Corvallis, OR.



-SQL Server 2005-2016 Solutions Developer: Visual Studio/BIDS/SSDT, SSMS, SSIS, SSAS, SSRS; complex T-SQL queries, stored procedures, views, .dtsx packages, .rdl report generation; automated agent/job creation; MDX queries; data warehouse and data mart development (OLAP cubes, relational database); ad hoc reporting. SSIS ETL processing with disparate data sources: Excel/Access. XML, EDI, ERP sources, flat files. Building SQL Server solutions since 2007 (10 years). Oracle PL/SQL query builds. Advanced Excel/Access automation with VBA scripting and integration with dynamic SQL data connections.


-Financial analysis/reporting tool development: SQL Server 2005-2016 stack: SSMS, SSIS, SSRS, SSAS; BI solutions Visual Studio/BIDS/SSDT; Advanced Excel & Access with VBA/SQL automation; ERP analytics.

-Budget preparation, forecasting, variance analysis; financial statement preparation and analysis.

-Modeling: cost/pricing, sales and cash-flow models; marketing analysis; what-if scenarios; interdepartmental model linking.

-Financial principals: NPV, IRR, CAPM, ROI, ROA, FV, etc.; capitalization techniques; pay-back/break-even analysis, pro forma financial statements, business valuation, business plans.

-Controller Duties: GL, AP, AR, Payroll; period close; journal entries; GL reconciliation; automated audit and period close; SOX audits, GAAP standards. FP&A/SQL solutions for 10+ years.


-Agile methodology.

-Project management with resource requirements, task prioritization and timeline development.

-Direct reports, staffing, performance criteria/reviews, incentive program development.

Software Proficiency

SQL Server 2005-2016: BI Visual Studio/SSDT, SSMS T-SQL queries, procedures, views, jobs; SSIS packages/projects; SSAS MDX queries; SSRS .rdl report development with OLAP and ODBC data sources. Performance enhancements.

Oracle 11g: Ad hoc PL/SQL queries and stored procedures.

Microsoft Excel 2007-2013: advanced, VBA code generation with SQL queries; automated import/export, pivot tables, complex lookups, nested IFs, array formulas, charting, OLAP and ODBC linking, sophisticated modeling, Power Pivots.

Microsoft Access 2007-2013: database development; SQL queries, VBA code generation, forms, reporting, procedures.

Microsoft PowerPoint 2010: advanced graphics, dynamic data-to-chart linking; automation.

Microsoft Visio 2010: process flowcharts, organizational charts, data to shape linking.



2017-present, UnitedHealth Group, Telecommute, Denver, CO, (800) ***-****

Advanced Research & Analytics Reporting. Develop T-SQL, PL/SQL for analysis and ad hoc reporting. SQL Server stored procedures, jobs, views and ETL processing; stored procedures and VBA automation for extracting data from office applications. SSMS, SSRS 2012, report development with advanced charting, graphing and parameter-driven T-SQL stored procedures. Shared data source and dataset creation with advanced SQL generated data-driven subscriptions. Advanced Excel/Access automation with VBA scripting and integration with dynamic SQL data connections. Various reporting platforms migration to and build in SSRS. Project lead and management in an Agile environment. Healthcare services, Fortune 6 company; 100% telecommute.


2016-2017, Vulcan Materials Company, Birmingham, AL, (205) ***-****

SQL Developer, IT department. Develop T-SQL and VBA code to automate corporate dashboard for deployment on SSRS 2016 to be delivered via intranet, mobile reports and data visualizations. SQL Server 2016 stored procedures, jobs, views and ETL processing. VBA automated Excel reporting and analysis through dynamic T-SQL queries and ETL processing. SSRS 2016 report development with advanced charting and parameter-driven T-SQL queries. Fortune 600 company; telecommute.


2016, CenturyLink, Inc., Denver, C O, (318)***-****

Ad hoc SQL Developer, Marketing IT department. Developed Oracle 10g PL/SQL queries and stored procedures to analyze B2B sales and marketing databases. Lead on cost source tracking/analysis project to determine cost-effectiveness of all B2B marketing campaigns, including website and other marketing activities. Datasets and analysis were further refined utilizing advanced Excel spreadsheets and VBA. Advanced SQL queries with multiple joins on database tables exceeding 65 million records with PL/SQL performance of prime concern.

SQL DEVELOPER (contract)

2014-2015, Contract, Atkins Nutritionals, Inc., Denver, CO, (303) ***-****

SQL Developer, IT department. Developed T-SQL and VBA code to build sales, costs and gross margin forecasting model with variance to actual. Multiple Excel sales forecast templates were transformed and assimilate d with VBA and imported into SQL Server 2014 via complex SSMS stored procedures, SSIS packages and SSRS reports. Another project was automation of the POS ETL processes with SSMS stored procedures, SSIS packages and VBA routines. Final reporting was via SSRS reports deployed on Report Server and SharePoint.


2013-2014, various, short-term

SENIOR ANALYST, DCP Midstream, Denver, CO

Cost analysis for large-scale petroleum construction projects; variance analysis between actual, budget and forecast costs; BI from data warehouse OLAP cubes; acted as liaison between project managers and mid-management.

SENIOR ANALYST / MODELING, Great Western Oil & Gas Company, Denver, CO

Optimize and rebuild an integrated corporate financial model: cash flow, working capital, consolidated financial statement and forecasting modules. Rebuilt and performed error resolution and efficiency analysis of a 70 spreadsheet linked Excel 2010 model for a group of affiliated upstream oil & gas companies.

WORKFORCE PLANNING / DEVELOPER,Western Union Corporate, Meridian, CO

Develop an Access 2010 database and transition Excel 2010 Workforce Planning spreadsheets. Conversion and integration of various data sources into a cohesive, standardized warehousing database for 9000+ worldwide employees. Develop database architecture, processes and SQL queries for workforce budget and forecasting; integrate disparate HRIS and Finance data sources in preparation for reporting initiative.


Develop an Access 2010 database for IT workforce expense, budget and variance reporting system; tracked 1600+ employee IT workforce for a large non-profit healthcare organization. Designed database architecture and procedures to replace numerous manual Excel 2010 spreadsheets. Utilized SQL, VBA and automated Excel 2010 templates to analyze and report workforce expense, budget and variance.


2007-2013, CH2M Hill Inc., Englewood, CO (888) ***-****

Senior Financial Analyst, Corporate. Utilized SQL Server 2008 stack: (SSMS, SSIS, SSAS, SSRS), VBA and MDX to build automated software tools, user forms and reports; Data warehouse/mart development and maintenance for various departments; Super-user status for ERP databases and data warehouse; advanced Excel 2010 and Access 2010 (SQL/VBA automation); responsible for ad hoc financial analysis and advanced reporting requests from any department for a $6.9 billion dollar, Fortune 500 Company.

Assisted with annual and quarterly budgets, variance analysis forecast-budget-actual; developed templates for data transfer; interfaced with Business Group Managers and staff to facilitate data input and reporting. Revenue/Expense/Profitability, GL and Trial Balance analysis.

Provided financial analysis for Business Development proposals for various industries: petroleum, water resources, transportation, construction, engineering services, and the 2012 London Olympics and Qatar 2018 World Cup.

Financial analysis/reporting responsibility for all Federal Economic Surveys (Bureau of Economic Affairs, Economic Census Department), as well as all major Industry surveys (ENR, regional business journals, etc.). Coordinated and reconciled financial analysis between new acquisitions (VECO, Halcrow UK) and US corporate headquarters.

Project Examples: Built and automated CAPEX database for quarterly and annual budget. Developed and managed an automated AR aging tool and SQL database to gather/report weekly numbers and collection progress to executive team (CEO, CFO, Controller, etc.); developed cost utilization model and report on 230 offices, which included evaluation of employee count, expenses and office size to determine utilization efficiency for CFO’s exclusive use. Many others…


2006-2007, Accenture Learning, Highlands Ranch, CO (720) ***-****

Developer of highly complex financial cost/pricing model utilizing advanced Excel and VBA programming techniques; database connections and table linking; auditing, security and error-trapping. Cost model is used by corporate finance and sales departments to generate comprehensive, accounting-precision costs used in pricing contracts for the delivery of global training programs for Fortune 500 clients.


2005-2006, Crenlo LLC (Dover Corporation), Rochester, Minnesota (507) ***-****

Financial analyst for a manufacturing corporation ($220 mil. annual sales); developed SQL Server 2005 analytical tools for ERP data analysis; reported directly to controller and CFO; Developed sophisticated Excel spreadsheets (SQL and VBA) and Access database applications for analysis/automation.

Interim accounting manager and assistant controller; automated SQL,VBA, many processes, led AP Department turnaround: restructured accounts payable department and resolved dysfunction; directly managed three accountants; assisted controller with period close journal entries; greatly reducing controller’s time spent on manual journal entries.

Primary contact and internal analyst for 2005 Price-Waterhouse-Cooper and SOX year-end audits.


2003-2005, Stone Concepts, Inc., Rochester, Minnesota; (507) ***-****

Financial/Information Systems:

Financial analyst/controller for two corporations; comprehensive accounting (GAAP) and financial management; financial analysis (projected financial statements, break-even, ROI, net-present-value, etc.) for projects and capital investments; gathered and analyzed data for management objectives; developed highly sophisticated Excel spreadsheets (advanced formulas, VBA macros, pivot tables, conditional lookups, database linking).

Financial reporting/presentations to president and financial institutions for loan acquisition.

Installed multi-user accounting system, managed and trained staff (QuickBooks Pro 2003); Network administrator: 8-station, peer-to-peer Windows Network; maintenance, security, back-up.

Directly managed staff of eight. .

>>> Additional Upon Request <<<

Contact this candidate