Experience

Pickens Technical College

• United States
• Higher Education
• 1 - 100 Employee

• CTE Data Reporting Specialist / Registrar

  • Feb 2019 - Present

  • Compiles student records for the purpose of meeting state, federal and/or district requirements. • Performs enrollment activities (e.g. registering students, dropping students, interpreting transcripts, updating student information system in Jenzabar J1) for the purpose of ensuring compliance with financial, legal, state or federal requirements. • Prepares a variety of reports and written materials (e.g. emailing grades to APS school district and contracting schools, transcript requests, attendance activity report, schedule report requests, VE135, IPEDS, etc.) for the purpose of meeting state, federal and/or district requirements. • Assists other personnel for the purpose of supporting them in the completion of their work activities. • Performs data research for accuracy and completeness through reports I created. Show less



CoreLogic

• United States
• Information Services
• 700 & Above Employee

• Data Fulfillment Analyst Associate

  • Feb 2017 - Jan 2019

  • QA input data for completeness, while removing bad data that prevent successful loading of files. • Communicate with the client via email when issues are found that could affect report results. • Load Excel input files for processing and monitor any issues with the workflow. • Perform data checks of the SQL-generated results within the various Excel report templates. • Deliver the data through Excel reports based on product type and the client's custom needs. These reports are: TaxWatch, Lien Report Lite, Lien Report Lite 2.0, Lien Report, Lien Report 2.0 and Portfolio Risk Report. • Continually improve existing Excel reports through creating further data checks. • Modify existing SQL code to perform ad-hoc requests. • Run the daily NextAce report which assists the team by notifying of any new open Title Orders. • Help the team by completing billing orders through the Oracle CRM On Demand platform. • Responsible for the ongoing production of customized data sets for specific client requests. • Perform data research and deliver reports to the clients. Show less



Impartial Services Group

• Motor Vehicle Manufacturing
• 1 - 100 Employee

• Data Analyst

  • Nov 2014 - Jul 2016

  • Performed daily extracts from ExactTarget (email) and ShoreTel (calls) to capture activity for reporting applications. • Designed queries and reports as required to perform analysis and complete work assignments utilizing Microsoft Excel 2010, SQL Server 2014, and IBM Data Studio. • Developed more efficient ways to record and archive data to help reports in Microsoft Excel 2010 function more efficiently. • Completed weekly status reports for several auto manufacturers to track recall progress, including repair rates, inbound call activity, predictive dialer calls, robocalls, emails sent, and postcard mailer volume to client on weekly basis. • Conducted business-related analysis of trends and business conditions. • Created new status reports for various auto manufacturers. • Changed reports design from static to dynamic approach, showing contact type for all VINs in part of recall campaign. • Moved archive of robocalls and email outreaches for various automotive manufacturers, saving significant network drive space. • Tracked over 2,000,000 emails for Honda HR3 recall campaign, greatly increasing efficiency. Show less



Oncor Electric Delivery

• United States
• Utilities
• 700 & Above Employee

• Operations Analyst

  • Oct 2011 - Oct 2014

  - Performs periodic and/or ad-hoc data extracts from the appropriate data stores using Microsoft Access and/or other database and reporting applications. - Designs queries, forms and reports as required to perform analysis and complete work assignments utilizing Microsoft Access. - Performs data and business analysis of the meter-to-cash work streams to identify existing or potential issues. - Performs daily report execution, including metric reports to my manager on a weekly/monthly basis. - Performs business related analysis of trends and business conditions. - Produces quality results in a rapidly changing environment. - Performs the Low KWH Exception Review tool daily to identify possible sources of tampering and records the findings either in LCIS, or in a tampering archive which is stored internally. Show less



Citigroup

• United States
• Financial Services
• 700 & Above Employee

• Database Analyst

  • Apr 2009 - May 2010

  - Managed the business-critical download and analysis of key internal database reports to ensure the accuracy of complex security and employee access protocols. - Maintained the CTC database within Archer and tracked / resolved duplicate wraps, providing weekly status updates to senior management. - Executed a variety of ad hoc database reports as part of a 4 member team. - Additionally contributed applications development assistance, particularly through initial concept design and requirements gathering. - Played a key role in the development of a new interface for an existing program, brainstorming with and visually showcasing the development team's functionality proposals in MS Visio for presentation to the development team. - Effectively delivered a project to track and align supplier information across the CTC and Archer database systems, providing a complete project report in SharePoint. - Developed hands-on subject matter expertise in such key database technologies as Excel and Access, with in-depth knowledge of such system functions and formulas as: VLOOKUPS, Pivot Tables, COUNTIF, IF/THEN, and Data Validation. Show less



ADAPTIVE IMAGING SOLUTIONS

• United States
• Software Development

• Keyshop Operator (data entry)

  • Jun 2004 - Jun 2008

  This company processed medical and dental claims. - Drove the achievement of stringent internal data quality and consistency standards, reviewing and clarifying the readability and information on submitted forms to ensure accuracy within the database. - Ran daily "fix files" as an added layer of data validation prior to returning the processed claims to each client. - Consistently maintained a 99% accuracy rate while analyzing up to 400 claims per hour. - Made significant contributions to the ongoing delivery of highly accurate, top quality data for client submission to large healthcare and insurance corporations. Show less