Murray Stephen Minter III

**** ***** ** **

Washington, DC 20002

443-***-****

ad2sp0@r.postjobfree.com

Educational Information:

University of Maryland, College Park 2010

B.A, Economics & Philosophy

Summary:

Experienced IT professional with database development, consulting, hardware & software troubleshooting, software development and analysis experience with a variety of software and programming scenarios. Experience with business process solutions via software management. I have experience in T-SQL, C#, .NET concepts, SSIS, and the software development lifecycle and data management and retention policies. Also experienced in data mining, scripting and analysis. Have utilized technological skills to develop and implement software solutions to improve business functions and developed advanced solutions to increase profit and decrease cost, protect data security, and improve ETL workflows. Professional Experience:

Cornerstone Research Inc. (08/20 – 09/22)

Financial Systems Analyst

Washington, DC

• Create SSRS Reports using Visual Studio 2017, Report Builder and SQL Server Management Studio (T- SQL)

• Search through complex and large (Enterprise Level) Aderant Database architecture with thousands of tables and complex schema, research and build queries.

• Build and deploy custom data tables using Aderant Data Dictionary Editor, Makepop and DBGen

• Use Aderant End User Painter to edit, create and deploy custom forms

• Create Aderant Reports in SSRS to report on AR, Writeoffs using data from blt_bill_amount tables

• Deploy SSRS Reports to Sharepoint using Visual Studio 2017, Report Builder.

• Write complex SQL queries for ad-hoc data requests

• Perform Software traces to do SQL analysis on backend software queries to build reports

• Learn and teach software functions to business users for business processes in (AP, AR, GL, Billing, etc)

• Work with different departments to provide systems support and analysis and help automate and streamline processes

• Use Microsoft Excel, PowerQuery,VBA, Tableau, to create data driven projects Steptoe & Johnson LLP (04/18 – 08/20)

Financial Systems Analyst

Washington, DC

• Elite 3.11 Troubleshooting, Software Support

• Created SQL Functions to streamline queries for Reporting and Development

• Administration of Expense Software (Chrome River) Responsible for testing feeds, troubleshooting issues with Person and Matter feeds

• Utilized Web Focus and Chrome River Analytics to create Reports for Data analysis and development for Accounting Staff

• Familiarized self with Collections software (Arcs3) to provide support and troubleshooting to Accounting Department

• Created Ad-Hoc T-SQL queries for Excel reporting

• Responsible for Data Mining Elite database to discover patterns in Data.

• Responsible for uploading costs to Elite and supporting Accounts Payable with issues relating to precost, cost and Elite software

• Worked with Report Builder to create SSRS reports to help with data discovery and accounting reporting

• Created Reports in Excel using VLOOKUP and Powerpivot

• Imported Data into System Databases, created database tables for accounting projects to locate centralized data and translating data from Elite.

Hogan Lovells (05/2013-07/2016)

Sr. Financial Systems Analyst

Washington, DC

• Contributed to merger and acquisition of different firm by creating scripts to convert financial and accounting data into Firms Proprietary Elite database

• Using SSRS and SSAS Cube, created reports detailing financial function of organization – billings, revenue, AR, collections, and partner compensation

• Created stored procedures, views, dynamic SQL scripting for SSRS reporting system

• Validated month end data from cube builds for reporting system after billing cycle was completed

• Created accounting rules and maintained system controls for Chrome River, an expense tracking system that the firm utilized – helped transition firm into full time use of Chrome River

• Created, modified and utilized SharePoint to deploy reports, create landing pages for accounting function

• Worked with Expense Department, Collections, AR and Billing to troubleshoot and solve software and hardware (printer, scanner) issues with Elite

• Using SSIS and Integration Builder, created functions, programs and rules to safely move and transition data between databases.

• Using C#, created application to control the insertion and update of Global Exchange rates from the Oanda Exchange System API

• Created, maintained and updated scripts for Mass Data Insertion into database to streamline new client intake

• Helped create and test updated scripts from old 4GL system to either C#, Integration Builder with SQL or other scripting languages

• Attended meetings with business process owners to understand how to translate accounting problems into software solutions for business function

• Collaborated with Executives, Managers, Attorneys and Business Owners to create on demand and ad- hoc reports by querying SQL databases to find patterns and data

• Assists team members with knowledge of software, database structure and processes

• Gave input on Finance System projects like merge of LLP databases, Elite Upgrade, Firm Merger,etc,

• Helped with QA and walkthrough of business scenarios to ensure software updates did not limit business operation

Dow Lohnes, PLLC (02/2012-05/2013)

Database Administrator

Washington, DC

• Designed and Created SSRS reports, Deployed them into SharePoint and MSSQL Environments

• Used PowerShell to design projects for system level maintenance and data synchronization with outside extranet applications and internal SQL databases

• Responsible for ensuring that 3rd party applications on the system were operating correctly in tune with business users needs

• Used SQL Profiler to ascertain database information from 3rd party systems on Firm’s extranet for purposes of data retrieval, report building and ETL projects

• Created SharePoint Collaboration Sites, performed diagnostics with technical issues related to SharePoint extranet

• Responsible for monitoring the health, performance, and stability of enterprise level SQL production servers (SQL 2005, 2008 R2)

• Created, modified and fine-tuned SQL scripts to ensure compatibility with dynamic business applications and extranets

• Restored backups to enterprise production business SQL databases (SQL 2005,2008 R2)

• Created and fine tune SQL maintenance plans (database & transaction log backups, drive cleanups, database indexing)

• Made SQL Maintenance tasks more efficient using SSIS to create database tasks to import data and minimize SQL tasks using scripting with T-SQL and Powershell

• Assisted with the planning and execution of server upgrade projects, application upgrades and end user testing

• Served as a liaison between business end users and application systems teams in order to bridge technological gaps and increase productivity

• Documented workflow procedures for internal business systems and technical specifications

• Responsible for learning, maintaining and troubleshooting software such as Ceridian and Workday(HR) and Sage Accounting Software, and eDiscovery Tools to create reports and administer system updates Motionsoft Inc, Rockville MD (07/2010-02/2012)

Technical Engineer

• Performed data mining for clients by researching queries pertaining to informational requests (data information outside of software reporting norms, information pertaining to database management on backend)

• Installed and configured SQL Server 2005, 2008/08R2. Ran stored procedures for software and analyzed the SQL readiness for application systems

• Created and modified SQL stored procedures to account for new incoming client proposals for their custom business contracts

• Assisted in the ongoing project management for client readiness for new installations – monitored progress for client setup, performance, and customization of systems

• Modified and analyzed crystal reports to display information that pertained to client needs – examples include modifying programming queries to match up and pull correct data, or different data than originally intended

• Conducted training session and consulting with clients on software capabilities as it pertained to various business operations including accounting, club management, employee management, front desk operations, and accounts receivable

• Performed hardware configuration and customization: Responsible for troubleshooting non-working hardware in conjunction with Citrix platforms, Windows and Mac Operating Systems and Legacy Hardware

• Conducted SQL database restores from SQL Server backup files, restored segments of data from backup tables, responsible for restoring sensitive information for clients such as account information, banking and credit card info

• Assisted with QA and Testing for new release of Product Life Cycles – participated in meetings regarding the performance, enhancement and functionality of new software, volunteered resources to improve product functionality

• Trained new employees on software capabilities, support procedures, and product function

• Documented software capabilities by creating manuals and internal procedures for various software functions, organizational operations, and QA testing walkthroughs

Contact this candidate