Home projects
SQL developer Experience
Allen DeGraw
Platte City,MO
Summary
Professional ETL expert with keen focus on data integration, transformation, and loading processes. Adept at working collaboratively within teams to deliver high-quality, scalable solutions. Strong skills in SQL, data warehousing, and ETL tools, ensuring seamless data flow and reliable performance. Known for adaptability and consistent results in dynamic environments.
Overview
12
12
5
5
Certification
2
2
years of post-secondary education
Work History
Lead ETL Developer
Research Management Consultants Inc. (RMCI)
Macon, GA
02.2022 - Current
- Lead modernization and maintenance of ETL processes using Oracle, SQL Server, Informatica, and Databricks.
- Manage and mentor RMCI employees, conducting performance reviews and hands-on training.
- Oversee data ingestion and quality assurance for HR datasets received from federal agencies.
- Develop and automate custom data quality processes using Collibra, Databricks notebooks, and APIs.
- Lead efforts in modernizing older systems, improving efficiency and ensuring seamless data integration.
- Utilize ADO/TFS and Agile methodologies for project management and workflow optimization.
- Federal Government Contractor
- Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
- Mentored junior developers on best practices in ETL development, fostering a culture of continuous learning within team.
- Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users.
Lead Database Administrator
nFocus Solutions
Fort Leavenworth, KS
10.2018 - 01.2022
- Designed and maintained SQL Server databases, optimizing performance across multiple ETL processes.
- Provided mentorship and leadership to teams, conducting performance evaluations and training.
- Automated routine tasks through scripting, saving time and resources for more strategic initiatives.
- Developed customized reports for management using SQL queries, aiding in informed decision making.
- Collaborated with developers on optimizing application queries, resulting in improved user experience and system responsiveness.
Database Administrator
Innovative Management Concepts (IMC)
Fort Leavenworth, KS
09.2015 - 10.2018
- Spearheaded database optimization initiatives for Digital Training Management System (DTMS).
- Built and maintained SSIS projects for data warehousing and reporting.
- Conducted detailed analysis of business processes, supporting IT strategy development.
- Enhanced reporting capabilities by designing efficient ETL processes that improved data accuracy and completeness.
- Maintained complex T-SQL queries, views, and stored procedures in multi-database environment with little supervision.
- Developed custom database objects, stored procedures, and delivered application support.
Database Administrator
Research Analysis Maintenance (RAM)
01.2013 - 09.2015
- Migrated and optimized over 200 SQL objects to improve system efficiency.
- Reduced execution times for complex queries and SSIS packages.
- Implemented ANSI-standard best practices for data integration and management.
- Documented analysis results and provided performance improvement feedback.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Worked on and resolved 70 + Tickets/Bugs.
- Complete “Cradle to Grave” documentation done for SSIS processes.
- Added, updated, or dropped 80 + SSIS/ETL processes.
Environmentalist
Utah State Hospital
Provo, UT
11.2006 - 12.2012
- Oversaw compliance with HIPAA, JACHO regulations, and risk management initiatives.
- Coordinated training, purchasing, patient financial liaison, and discharge planning.
- Conducted regulatory compliance inspections.
- Patient financial liaison with state-sponsored banking
- Participate on interview panels (for new-hire process)
- Coordinated training/ Trained new as well as seasoned employees
- Over Saw intake and discharge of patients
Skills
- Proficient in SQL Server (2005, 2008, 2008 R2, 2014), Oracle, and azure database systems
- ETL & Data Integration: SSIS, Informatica, Databricks notebooks
- Data Quality & Standardization: RightData RDt, Collibra, Azure, Data Governance Solutions
- Collibra and Databricks notebook automation
- Proficient in Agile methodologies
- Error handling
- ETL modeling
- Data modeling
Accomplishments
- Supervised team of 6 staff members.
- Achieved better data quality by introducing Collibra data quality for data validation of flat files received from customers.
- Achieved improved performance with ingestion processes through effectively helping with loading practices and custom tools to help mitigate common errors.
- Made lead over data quality for modernization efforts in addition to being lead over current manual data ingestion team.
- Built custom process to validate data through use of third party tool, Collibra, using data bricks notebooks and API to pull in data from the database, run checks, and return report of data value errors. These reports were then sent to customers to resolve and send back through.
Certification
- Azure Fundamentals (AZ-900) – 2023-08
- Security Clearance – Active since 2013-01
- Technical Level II Certification (Sec +) – 2013-01 – Present (CEUs maintained)
- MS SQL 2012 – 5 Certifications (Skill Port) – 2020-05 – 2020-08
- Designing an Effective Data Warehouse – 2015-11
- Developing High-Performance SQL Databases – 2016-03
- BYU-Idaho Pathway Program – 2017-09 – 2018-08
- Utah Valley University – General Education
Awards
GEM Award (IMC) – Recognized for outstanding contributions
Utah State Employee Five-Year Service Recognition and Utah State Employee VIP Awards (Received 14)
Eagle Scout & Order of the Arrow
Interests
Playing music
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Preference
Work Type
Full TimeWork Location
RemoteHybridImportant To Me
Career advancementWork-life balanceFlexible work hoursHealthcare benefitsWork from home optionPaid time offTeam Building / Company Retreats401k matchStock Options / Equity / Profit Sharing4-day work weekEducation
No Degree - Information Technology
Utah Valley University
Orem, UT 08.2005 - 03.2006
No Degree - Information Technology
Brigham
Provo, UT 09.2017 - 08.2018
Professional Locksmith - Locksmithing
Penn
12.2009 - 06.2010
Software
Redgate
Office
Informatica
Microsoft SQL server
Oracle/PL SQL
Collibra data quality
Linux/putty
SQL server integration services (SSIS)
Azure
Databricks
Timeline
Lead ETL Developer
Research Management Consultants Inc. (RMCI)
02.2022 - Current
Lead Database Administrator
nFocus Solutions
10.2018 - 01.2022
No Degree - Information Technology
Brigham
09.2017 - 08.2018
Database Administrator
Innovative Management Concepts (IMC)
09.2015 - 10.2018
Database Administrator
Research Analysis Maintenance (RAM)
01.2013 - 09.2015
Professional Locksmith - Locksmithing
Penn
12.2009 - 06.2010
Environmentalist
Utah State Hospital
11.2006 - 12.2012
No Degree - Information Technology
Utah Valley University
08.2005 - 03.2006
Similar Profiles
Andy SolomonAndy Solomon
Team Lead/Tech Lead at Research Management Consultants Inc (RMCI)Team Lead/Tech Lead at Research Management Consultants Inc (RMCI)
Troy MartinTroy Martin
ETL Developer at RMCIETL Developer at RMCI
Jeremy floresJeremy flores
Safety Superintendent at RMCISafety Superintendent at RMCI
Samuel ChaseSamuel Chase
Customer Service Sales Representative at Cohens Art Printing & FramingCustomer Service Sales Representative at Cohens Art Printing & Framing
Antonio BarteeAntonio Bartee
Senior Officer Specialist at FCI LeavenworthSenior Officer Specialist at FCI Leavenworth