Hello there!

I'm an analyst with experience in information technology, human resources and administrative support. Thanks to years of refusing to say the words "that's not my job", I've obtained hands on experience with SQL, data validation, requirements gathering, testing, Salesforce, Microsoft Dynamics, data archiving and document digitization.

Jason J. Ervin

E-mail: jjervin@gmail.com | Austin, Tx |

Skills

• SQL (T-SQL, Db2, MySQL, Microsoft SQL Server, IBM Data Studio)
• Excel/Google Sheets (VLOOKUP, IF, SUM, COUNT, Data Visualization, Conditional Formatting, Pivot Tables)
• Basic Python (Jupyter, Pandas, Numpy, MatplotLib, Folium, REGEX, Requests, API, Data Cleansing)
• Basic Statistics
• HTML5/CSS
• Basic JavaScript and jQuery
• Business Applications: Word, Powerpoint, Project 2010, Visio, Google Docs, JIRA, MS Dynamics CRM, SalesForce, GitHub

Work Experience

Production Support Analyst - FindHelp.org

1/2021 - Current

• Provide technical support to FindHelp users and customers.
• Create, repair and modify customer forms via json file manipulation.
• Assist in the set up of customer SSO platform connection to FindHelp platform.
• Utilize data tools such as MySQL and Google Cloud Platform’s Datastore to perform database updates or obtain data as needed.
• Assist in the documentation of Production Support processes.

Data Delivery Specialist - Scale AI via Aerotek

9/2020 - 1/2021 (contract)

• Assisted in the successful migration from Scale's previous business intelligence tool and into Redash. This included transferring SQL queries, rebuilding dashboards and training new users of the platform.
• Performed quality assurance of customer ML data tasks.

Data Analyst - CIT Group/Celink

6/2016 – 8/2019

• Transform business user requirements into SQL based data sets using queries that range from simple to complex.
• Assist in ensuring the successful generation and distribution of scheduled data sets.
• Repair and modify SQL queries as new business needs arise.
• Data validation

Catalog Operations Analyst – Bazaarvoice

9/2014 – 6/2016

• Remotely validate product and service matches between manufacturers and retailers using the internal Bazaarvoice platform.
• Proofing the output of fellow analysts.

Junior Data Analyst – Invenio Marketing Solutions

3/2014 – 8/2014

• Imported normalized data into the firm’s CRM systems (Salesforce, Epsilon,MS Dynamics CRM 2013).
• Assisted with the administration of the firm’s MS Dynamics CRM instance (editing permissions, helping users with login issues, troubleshooting).
• Created a custom object for an internal customer in MS Dynamics, which included gathering requirements, building and testing.
• Archived and removed old data from the firm’s SalesForce instance.
• Pulled user data from the employee database via MS SQL Server Studio.
• Made corrections to the timekeeping database as needed.

Administrative Associate – University of Texas at Austin

8/2012 – 9/2013

• Monitored the 250+ ITS and OTS employee timesheets.
• Created payroll vouchers for ITS part-time employees and overtime/on-call/shift-differential pay earning full-time employees.
• Coordinated the Programmer Aptitude test for the ITS-Applications Education team. This included scheduling, registration, proctoring, grading and entering applicant test scores.

Student Administrative Associate – University of Texas at Austin (Information Technology Services)

12/2011 – 7/2012

• Created purchase request orders for office supplies.
• Served as the main contact for ITS-Applications department in re: building issues.
• Created weekly time entry forms for the ITS-Applications department via Microsoft Project 2010 and Excel.

Internship/Officer Positions

Intern – Greater Austin Chamber of Commerce

1/2011 – 5/2011

• Verified and updated member information.
• Assembled sales packets for the Sales Team.
• Trained incoming interns and created a manual for future Membership Department interns.

Education

The University of Texas at Austin

IBM Data Science Professional Certification

Data Analytics

Misc HTML/jQuery