Experience

• 

  Centene Corporation

  • Gillette, Wyoming, United States

  • SQL Developer

    • Apr 2024 - Present
    • Gillette, Wyoming, United States

    On behalf of Apex Systems, I'm excited to join Centene for a project-based, 6-month position to achieve their goals. I'm open to conversations about long-term fits once the client contract has ended.

• 

  MedAssist, a Firstsource company

  • Gillette, Wyoming, United States

  • SQL Server Developer

    • Mar 2008 - Jan 2024
    • Gillette, Wyoming, United States

    • Active, high-touch tools included VS 2019 IDE, SSMS, T-SQL, and SSRS to create and maintain operational and management reports (detail and summary) from SQL Server data sources (2012 and 2016).• Frequently used T-SQL, VB.NET, ASP.NET, AJAX, and JavaScript using VS 2019 IDE to develop desktop and web-based applications to organize and automate business processes. The four applications described here demonstrate the diversity of business logic coded and UI/UX experiences created.1) Patient Screening (ORT): Web-based tool used by eligibility services staff to screen patients. In response to COVID restrictions, refactored code to capture and analyze remote-based screening productivity.2) Quality Control (QRS): Web-based tool used by internal auditors to review processed claims. Included logic to conduct in-app training, appeals, and scoring.3) Claims Inventory (PRS): Desktop application used to distribute and monitor health insurance claims for processing.4) File Tracking (EDI): Web-based tool used by staff to track import and export file inventory, and to document the file interaction between house system of record and healthcare clients. Included a scheduling module.• ETL experience using SSIS, Power Query, SSMS, T-SQL, and SQL Server jobs to import and export data, create data transformation flows, and execute scheduled data maintenance tasks.• Frequent use of DAX to query data for Power BI paginated reports, MDX to consume SSAS tabular data for month-end reports, and m-query for creating measures in Power BI semantic models.• Regular use of Power BI Desktop, Power BI Report Builder, Power BI Service, Power Query (Excel), and m-query to build reports, online visualizations, dataflows, and semantic models.• Course instruction and labs for Power App, Power Automate, and C#.

• 

  TEKsystems

  • Overland Park, KS

  • Web Developer

    • Jul 2007 - Jan 2008
    • Overland Park, KS

    Skills: VB.Net, ASP.NET, AJAX, JavaScript, Visual Studio, VBScript, Classic ASP, T-SQL, SQL Server DBA• Managed customer-facing sites hosting online resources such as marketing kits, information journals, and store catalogs.• Developed complex pages for various site features including searching and selecting books from catalog, implementing a bookstore shopping cart feature, managing association memberships, subscribing to journal, and registering for meetings.

• 

  Bartlett & West

  • Topeka, KS

  • GIS Systems Support | August 2006-July 2007

    • Aug 2006 - Jul 2007
    • Topeka, KS

    • Gathered requirements, coded business logic, confirmed data quality, and tested app performance in Visual Studio, VB.NET, ASP.NET, and GIS software stack for municipal client to manage stormwater system, map pipes and drains, and track improvements projects.• Developed classic ASP-based application to manage railway maintenance contracts and map railway segments.• Managed data export process for delivering custom-converted real estate transaction data to railroad client. Worked with data processing leads to identify parcels ready for delivery and ran QC checks on those parcels against delivery specifications.

• 

  AdvantageTech Inc for US Department of Agriculture

  • Kansas City, KS

  • SQL Server ArcSDE DBA

    • Jun 2005 - Jul 2006
    • Kansas City, KS

    • Ensured high availability and optimum performance of more than 2,300 remote spatial servers running ArcSDE 8.3 and SQL Server 2000 for USDA Farm Services Agency.• Monitored status of SQL Server scheduled jobs, investigated & resolved failures.• Analyzed table indexes and defragged, as needed.• Tracked and implemented software updates and patches.• Reviewed event logs and counters to determine trends in server performance.• Ran SQL Profiler, as needed, to troubleshoot performance issues.• Evaluated long-running, high-resource queries; made recommendations to reduce execution time.• Developed custom monitoring process that ran several stored procedures on each remote server.

• 

  U.S. Geological Survey (USGS)

  • Denver, Colorado, United States

  • SQL Server ArcSDE DBA

    • Jun 2001 - Mar 2004
    • Denver, Colorado, United States

    • Administered SQL Server GIS databases supporting USGS web based ArcIMS applications.• Installed/upgraded Advanced Server 2000, SQL Server 2000 Standard, & ArcSDE software.• Monitored hardware/software performance and applied updates, patches, and fixes.• Ran integrity and indexing checks.• Ran traces in SQL Profiler to troubleshoot performance issues.• Tuned ArcSDE & SQL Server settings to improve server performance.• Managed SQL Server transaction logs.• Managed data migration to ArcSDE, planning for disk space and database schema.• Collaborated with team members to document security requirements & procedures for the high-availability, redundant web-hosting systems.