Database Administrator/developer Resume
3.00/5 (Submit Your Rating)
Prescott, AZ
SUMMARY
- Dedicated, hard - working database developer seeking a data/database position. I have worked in the healthcare, education, manufacturing, and finance sectors. I have a passion for making sure that data is accurate and retrieved quickly. Excellent communication skills with stakeholders of all technical expertise levels.
TECHNICAL SKILLS
- SQL/T-SQL
- SQL Server 2000 - 2019
- SSRS, SSIS, SSAS
- Data Warehousing
- Stored Procedures, Functions, Transactions, Triggers, and Jobs
- Indexing, Query Tuning, SQL Profiler
- Query Execution Plan Analysis
- Error Handling
- Dynamic SQL
- R
- C | C++ | C# | Java
- .NET 3.5/4.0/4.7
- Windows Forms
- VMWare
- Visual Studio 2008-2019
- ASP.NET MVC 3 - 5
- ASP.NET Web Forms
- PowerShell/BASH
- HTML5/CSS3
- JavaScript jQuery
- Twitter Bootstrap
- JSON/XML
- REST/SOAP
- Agile/SCRUM
- Test Driven Development
- Unit Testing
- UML
- Data Flow Diagrams
- Entity Relationship Diagrams
- TFS/SVN/Tortoise/Git
PROFESSIONAL EXPERIENCE
Confidential | Prescott, AZ
Database Administrator/Developer
Responsibilities:
- Supports the core systems’ maintenance and integrations: PowerCampus (Student Information System), PowerFAIDS, and Microsoft Dynamics Great Plains
- Writes/maintains stored procedures (T-SQL), software integrations, and SSRS reports as needed
- Created a Data Lake for pooling data from the core systems used for external integrations and reporting
- Consolidated digital forms to the Frevvo platform that pull data from/write data to the core systems
- Documented and cleaned up integrations and data pathways
Confidential | Pierceton, IN
Contracted DB Administrator/Application Developer
Responsibilities:
- Provided database administration (SQL Server 2000 and SQL Server 2008r2), development of custom software applications, and data maintenance for Visual ERP 6.3/7.0
- Maintenance and modification of an existing SSAS data cube, SSRS reports and SSIS workflows
- Developed a custom auditing solution in SQL Server 2000 using SQL Trace to produce data used for SOX compliance and wrote associated SSRS reports
Confidentia
Software Application Developer
Responsibilities:
- Modified a .NET application that imports .xml files from Coalition and Apply Texas into staging by adding logging and making the program more robust
- Updated SSIS packages that load the data from staging tables to production tables
- Modified a stored procedure so it runs in ~60% less time to update financial aid statistics
- Updated the SSRS report that displays financial aid admission data
Confidential | Wabash, IN
Application Engineer
Responsibilities:
- Primarily worked with .NET (C#), SQL Server (T-SQL), and Rockwell Software (data capture and reporting from PLC’s, sensors, etc…)
- Developed a C# application for use on a Motorola bar code scanner running Windows CE 3.0 that used MSMQ for Inter-Process Communication for tracking defects
Confidential
Divestiture Advisory Services Toolkit
Responsibilities:
- Programmed in JavaScript/jQuery in a SharePoint 2013 system for managing divestitures
- Wrote user stories as a part-time business analyst
- Created forms using BPC PowerForms to query multiple lists and perform CRUD operations
- Developed the Gantt chart section using DHTMLX JavaScript library