James Burns Email & Phone Number

• Work directly with the president to analyze and research customer signups, retention and churn so that he could maintain a constant pulse on the growth of the company.
• Research and report on potential fraudulent accounts to help reduce losses associated with those accounts and to help mitigate future fraud.
• Generate monthly reports to the executive team and analyze as directed.
• Built MySQL stored procedures to automate reporting of daily cash receipts. This enabled the company to identify billing issues within a day of occurrence so that they could be corrected and cash collected within days.

San Diego

• Provided level 3 technical support researching and resolving defects and performance issues in existing stored procedures and SSRS reports.
• Worked with the Product Team and senior management to build a new SSRS report to simplify and improve the reporting time for medical coders using the core CAC (Computer Assisted Coding) application. This report.
• Documented and performed quarterly updates to the QA environment involving detaching and attaching multiple SQL databases, removing and adding those databases from the AlwaysOn Availability group, and assigning.

San Diego

• Designed, built, implemented, and maintained a SQL-based system to automate revenue billing, reporting, and forecasting for the Ad Operations department. Compiled email delivery data for load to AdBook (SaaS-based.
• Saved over 40 hours of report preparation time per month by building an Excel macro that took a flat-file download from AdBook and generated over 70 Excel workbooks in approximately 90 minutes. The Excel macro included.
• In order to augment revenue reporting and meet contractual needs, rewrote Ad Operation’s marketing credit system in SQL by designing a new data model and building 15 tables and 7 stored procedures. The new system.
• Taught SQL to members of the Ad Operations department. Trained users how to link Excel workbooks directly to a SQL reporting database which became the standard for most of the department’s reporting and allowed for.

San Diego

• Developed a top 10 client report for senior management that consolidated data from three SQL databases to provide an overview of the company’s appraisal business. This daily report gave details on the current stage of.
• Designed and built an Access 2007 database to provide a client-specific pricing and gross margin estimate using a myriad of factors including weighted average costs based upon state and product allocations. This.
• Worked with business analysts and developers to migrate over twenty-five SQL Reporting Services reports from a stand-alone system to our division’s core platform.
• Coordinated report development with our India team by gathering and clarifying requirements, answering questions, and reviewing code.

• Worked with the senior inventory analyst to design and develop a process to project inventory balances based upon existing sales quotes, sales orders, credit orders, purchase orders, debit orders, and work orders. The.
• Designed a Balance Sheet and two Income Statements (internal and external) in SQL Reporting Services for the Controller and Director of Financial Planning giving them instant access to real-time financial information..
• Built a Visual Basic.NET application that integrated with the accounting software. This provided more accurate information to the Purchasing department by allowing users to update work order data that was previously.
• Developed and defined several reports for Purchasing allowing them to identify excess inventory in stock and on order. Purchasing was able to reduce inventory levels by cancelling or postponing purchase orders that.

• Received the Senior Leadership Team award for Exceptional Contributor for the 2006/2007 fiscal year. This award is given to those individuals who exceeded expectations and made critical contributions to MedImpact’s.
• Acted as lead developer in a department of six developers guiding their development efforts and acting as subject matter expert on the systems in place.
• Designed and maintained the core Access 2003 database that comprised the heart of MedImpact’s involvement in the Medicare Part D program, a program that accounted for a significant portion of MedImpact’s annual revenue.
• Trained new developers on the pertinent aspects of the regulations associated with the Medicare Part D program and on the numerous Access 2003 databases developed to support those regulations.
• Designed and developed an Access 2003 database that loaded a denormalized set of data from Excel 2003 workbooks, normalized the data, and then prepared adjusting entries that could be loaded into the main Oracle.

• Worked on-site for multiple clients in various industries providing customizations to Great Plains using a combination of VBA, VB.NET, and SQL Server.
• Designed process in Great Plains using VBA, SQL stored procedures, and SQL triggers to automate the creation of accounts payable transactions from posted sales invoices.
• Modified and improved VB.NET application to facilitate the processing of commissions, royalties, and licensing information.
• Created SQL views to summarize accounts receivable information stored in the Great Plains database. These SQL views were then linked to Excel workbooks to provide easy access to the information.
• Designed stored procedures and a SQL Server 2000 Reporting Services report to analyze sales data by territory and customer. This new report provided near-instant access to the sales data in lieu of the prior manual.

• Designed and developed Access 2002 application to improve tracking of clients and the services offered to those clients.
• Wrote end-user training manual and technical manual for the application developed for the client to provide the client with key information needed to use and maintain the application in the future.

• Won the employee-nominated Unsung Hero award for 2002. This award is given yearly to the best performer behind the scenes.
• Developed and supported the integration between Siebel and Navision.
• Migrated the company’s financial information, including sales history, general ledger balances, and opening accounts receivable balances from Platinum (a Btrieve based system) to Navision Financials by using Microsoft.

• Worked directly with CFO, Controller, and Treasurer to create Microsoft Excel 97 and Lotus 123 financial projections and analyses.
• Maintained and updated 5-year income and cash forecasts of the company’s home building, land development, and commercial activity.

• Used Excel 5.0, Visual Basic for Applications, and extracts from the financial software to generate financial statements in less than twenty minutes when prior preparation took a day to prepare.
• Reported directly to the Director of Finance to handle all aspects of the general ledger system including journal entry preparation and posting, month-end close, financial statement preparation, account.