Experience

• 

  Relias

  • Boise, Idaho Area

  • System Analyst

    • Sep 2018 - May 2024
    • Boise, Idaho Area

    Managed data migrations, ensuring accuracy of data transfer and tracking project performanceDeveloped and troubleshot API endpoints, implemented authentication, and resolved data and configuration errorsProvided tier-two technical support for users of healthcare analytics and training platformIdentified and documented software defects, testing fixed defectsDeveloped and thoroughly tested scripts in Staging and Sandbox environments before deploying to Production, while also working directly in Production to validate data accuracy and integrity.

• 

  UnitedHealth Group

  • San Diego, California

  • Senior Software Engineer / Database Analyst

    • Aug 2017 - Sep 2018
    • San Diego, California

    I analyze and troubleshoot stored procedures and write SQL queries. I debug database scripts, reports, and procedures. I develop, define, and document system specifications. I submit software interface issues after recreating and documenting them.Achievements:• Handled almost one hundred requests including reports, account changes, ad-hoc scripting, and stored procedure troubleshooting.• Leading report revamp ensuring better efficiency, added functionality, and more streamlined.

• 

  Charlotte Russe

  • Greater San Diego Area

  • Programmer Analyst

    • May 2016 - Aug 2017
    • Greater San Diego Area

    I used numerous applications to improve automation efficiency. I supported applications written in VBA. I automated jobs using ETL process flows and provided troubleshooting and fixes for reported application issues.Achievements:• During transition to new software aided in the troubleshooting of the retail merchandising software.• Successfully modified an automated daily job for HR to accommodate new specifications.

• 

  Grasp Technologies, Inc.

  • San Diego, CA

  • SQL Report Developer

    • Jul 2015 - Apr 2016
    • San Diego, CA

    I changed existing reports and developed new reports based on customer specifications. I supported database tables, stored procedures, views, and database objects. I designed and adapted reports and directed data loads using Visual Studio, Crystal Reports, SQL Server, and Microsoft Office Suite.Achievements:• Created, fixed and modified hundreds of client base reports.

• 

  GreatCall

  • Greater San Diego Area

  • Senior Usage/Database Analyst

    • Oct 2012 - Jul 2015
    • Greater San Diego Area

    I solved billing and database issues while supporting software deployments. I reconciled usage files to ensure proper billing and reported data for billing operations. I developed SQL queries to identify issues and provide solutions during third-party vendor audits. I provided streamlined SQL reports to support billing and product launches. I provided troubleshooting for file imports on the SQL Usage Server and managed the Fraud Server.Achievements:• Successfully transitioned company to new data file format due to a Verizon Wireless requirement.• Reconciled millions of phone and data records from Verizon to company billing system.

• 

  Affinity Development Group

  • United States
  • Advertising Services
  • 100 - 200 Employee

  • Database Analyst

    • 2009 - 2012

    I began as an account developer in 2006 and promoted to Data Analyst in 2009. I maintained SQL scripts, stored procedures, and created reports using Crystal Reports and Microsoft Report Builder. I reported daily progress and identified concerns using spreadsheets and reports. I ensured pricing decisions based on key assumptions using Excel and SQL reports for management. I support data quality, improved plans, setup and developed queries, created reports, and provided analysis. I trained dealers and shadowed client on the Costco Auto Program processes. Achievements:• Developed a tool using Microsoft Excel VBA that input information into an Access database and then used SQL and Microsoft SQL Report Builder to create reports allowing for an almost paperless process.• Aided in developing reports for specific automobile-related promotions which became the standard in reporting because of efficiency, result accuracy, and ease of use.• Increased efficient processing and consistent pricing for the Volvo Holiday Promotion by creating a lease calculator using Microsoft Excel VBA.

  • Field Support

    • 2006 - 2009

    Trained new dealers on the Costco Auto Program processes to ensure consistency among dealers. Researched new vehicles models to be recognized by the Costco Auto Program, and provided suggestions to management based on extensive pricing, product, and market factors. Followed-up with dealers to ensure that they were sending in their pricing information through for Costco Auto Programs, and entered pricing into spreadsheets and models for analysis. Programmed a lease calculator with Microsoft Excel VBA for the Volvo Holiday Promotion, which increased adherence to more efficient process as well as consistent pricing programs.