Systems Analyst United States
Resume:
Darin Holloway
Helena, MT *****
**********@********.***
Summary of Skills
Experience in database development, design, reporting, and ETL.
Worked in Scrum, Agile, and Kanban environments to manage workflow and provide continuous deployments.
Responsible for troubleshooting issues and production support for Oracle and SQL Server databases.
Diverse technical background with experience in PL/SQL, TSQL, VB6, PowerBuilder, HTML, XML, C#, Powershell, and Cold Fusion.
Maintained systems for DEQ, U.S. Army, U.S. Postal Service, Amerisure, and Montana State Fund.
Work Experience
Database Developer
January 2022 – 2024 Sapiens, Montana, United States
Maintain enterprise insurance applications written in Powerbuilder and Oracle 12c/19c
Agile environment with development teams utilizing Scrum and Kanban boards
Jira for issue tracking, requirements, and deployment requests
Oracle PL/SQL, complex queries, subqueries, procedures, functions, and views
Coordinate with QA teams to conduct unit testing, integration testing, and documentation
Troubleshooting production issues, debugging, code reviews
Maintaining a PowerBuilder based insurance applications
Git and ClearQuest version control systems
Software Developer
January 2019 – 2021 Battelle, Idaho, United States
Responsible for installing, configuring, and maintaining Hitachi ABB Asset Suite, ERSuite and eSOMS applications for the INL nuclear facility
Develop and maintain ETL processes to load data from various sources, ensuring data consistency
Azure DevOps CI/CD pipelines to automate the deployment and update of database systems
SQL Server 2012, 2016, TSQL, procedures, functions, and dynamic SQL
Oracle 12c, 19c, 21c, PL/SQL, packages, procedures, views, triggers, and TOAD
Code versioning using Git, Gitkraken, and Collaborator
Jira Kanban boards for issue tracking, user stories, and assignments
Software Engineer II
November 2010 – 2018 Montana State Fund, Montana, United States
Maintain insurance policy applications using Powerbuilder, VB6, C#, and XML
Work closely with customers to define business requirements, QA testing, and documention
Oracle 11g / 12c PL/SQL, packages, procedures, views, triggers, and PL/SQL Developer
Troubleshoot billing and accounts receivable applications for workers comp insurance
Configure IBM Datacap application to index documents and interface with FileNet
Provide help desk support and production recovery
Converted Oracle Reports to Crystal Reports
Maintain C# and VB6 applications using MS Visual Studio 2013, 2015, 2017
Consultant
September 2008 – 2010 Deloitte, Montana, United States
Developed data conversion for Montana Department of Justice license and registration system
Writing test cases and supervised testing of DOJ registration and title system
Traveled around the U.S. working with the FDIC to extract and archive the financial data of failed banks
Extracted data from a variety of databases to include Oracle, SQL Server, Access, and FoxPro
Systems Analyst
August 2004 – 2008 BearingPoint, Montana, Unites States
Developed ETL solutions and built web applications for the Montana Department of Justice
SQL Server 2005/2008, SSMS, SSIS, and TSQL, stored procedures, and functions
Database administrator tasks, including backup, disaster recovery, and performance monitoring
Built web applications using ASP (VBScript), JavaScript, HTML, CSS, and Dreamweaver
Managed requirements using Rational RequisitePro
Developed ETL processes using TSQL and SSIS (SQL Server Integration Services)
Web Developer
February 2004 – July 2004 U.S. Postal Service, Missouri, Unites States
Maintenance and testing on U.S. Postal Service scheduling and tracking web applications Drop Shipment Appointment System (DSAS) and Concentration and Convoy Tracking System (ConCon)
Developed web application using Dreamweaver, ColdFusion, JavaScript, HTML, and CSS
Worked with Oracle 9i and DB2 databases using TOAD, SQL Plus, PL/SQL, and DB2 Connect
Creating PL/SQL stored procedures, SQL scripts, and generated reports
Optimization queries to processed batch uploads
Web Developer
January 2001 - July 2002 Jason Associates Corporation, Idaho, Unites States
Designed, developed, tested, and maintained web applications written in ASP (VBScript), ColdFusion, JavaScript, HTML, SQL, and CSS
Developed SQL Server 7.0/2000 and Access 97/2000 relational databases
Create database schemas based on data dictionaries and ER diagrams
Backing up databases and user data, resolving network issues, installing software and hardware
Conducted group and individual training on the use of hardware and software technologies
Education
Bachelor of Computer Science, University of Idaho, United States
Contact this candidate