Sonya Traylor

Sonya Traylor

Access, Excel and SQL Reporting

Summay

I have developed the skills and acquired the knowledge to ensure the highest level of competence, productivity and effective operation in the Automotive and IT industry. It is with this high level of experience, plus a commitment to quality that I believe will bring added value to your organizations efforts.

After working for General Motors for 11 years as an assembler I decided I wanted something challenging. A recruiter advised me to pick up various small projects to learn as many technologies as I could.  My journey consists of working for a lot of companies on both long and short term contracts. This has been exciting. I was able  to add value to their teams, yet I learned a lot as well.

I have enjoyed my contracting experience,  it has allowed me to meet different people and learn different business processes, but I'm at the point in my career I would like to find a permanent position and something closer to home . Unfortunately there isn't many jobs fitting my skills set in the Flint .Grand Blanc area. My plan is to continue to work hard , search and hope something will come my way.

*PEASE TAKE A MOMENT TO REVIEW SOME OF MY ACCOMPLISHMENTS ATTACHED*

Work History

Work History
Mar 2015 - Present

Qualilty Specialist

BOSCH

Bosch (Short term Contract Position)   March 2015 - Present

Position: Quality Analyst

  • Enter Warranty  parts  claims using SAP  Netweaver
  • support Regional quality champion in Diesel System
  • Handle Diesel  engine, after treatment and PM sensors
  • Report quality issues to management
  • Keep track of customers complaints, history and DTC'S codes
  • Transfer Data from warranty claim into several application: SAP IQIS, ECU Tracker, Excel and Access
  • Use SAP Mass Processing Editor
  • Verify that data entry is 100%
  • Familiar with creating  transactions
  • Created relational databases for tracking, analysis and reporting. I used Access, SQL, macros and  VBA modules.

AC Delco (Contract Position)   Sept 2013 – Sept. 2014

Position: Quality Data Analyst

  • Created an application in Access which allow several GM facilities to input their information in efforts to improve the quality of high error employees.
  • Modify and maintain parts Claims and Returns Quality Metrics spreadsheet and database
  • Update Key Performance Indicator (KPI)
  • Automated reports via Access using Tableau workbooks
  • Create and maintain Statistical Process Charts (SPC)
  • Data analysis using Access, SQL queries, Excel and Tableau
  • Ad hoc reporting
  • VBA programming
  • Access and Excel Automation (updating spreadsheets using access queries)
  • Report Deployment
  • Integrating Reporting Services with Share Point
  • SSIS - Bulk Inserts, Creating and Executing Packages, Executing with Stored Procedures, FTP,
  • Data Flow Transformation
  • Tableau 

TGI Direct Marketing   Mar 2012 - May 2013

Position: Data Analyst

Sep 2013 - Sep 2014

Quality Data Analyst

AC Delco Customer Care
  • • Created an application in Access which allow several GM facilities to input their information in efforts to improve the quality of high error employees.

.• Modify and maintain  parts Claims and Returns Quality Metrics spreadsheet and database

  • Update Key Performance Indicator (KPI)
  • Automated reports via Access using Tableau workbooks
  • Create and maintain Statistical Process Charts (SPC)
  • Data analysis using Access, SQL queries, Excel and Tableau
  • Ad hoc reporting
  • VBA
  • Access and Excel Automation (updating spreadsheets using access queries)
  • Report Deployment 
  • Integrating Reporting Services with Share Point
  • SSIS - Bulk Inserts, Creating and Executing Packages, Executing with Stored Procedures, FTP, Data Flow Transformations
Mar 2012 - May 2013

Data Analyst

TGI Direct Marketing
  • ·Download delimited or database data from FTP sites or other source
  • ·Determine field layout and restore data to table(s)
  • ·Validate values in critical data fields (truncation, correct data type, missing, within range, etc.)
  • ·Visually review and correct specified fields
  • ·Merge similar files into combined table
  • ·Copy values from one field into separate fields (such as First Name Last Name)
  • ·Compare related files based on key fields and populate/mark records
  • ·Query and report on file contents for specified fields
  • ·Select records based on criteria
  • ·Process tables using third-party or custom software for standardization, postal coding, etc.
  • ·Programmatically populate fields based on values of other fields
  • ·Create various output files with selected records and field layout
  • ·Create user-friendly reports
  • ·Programmatically and manually quality-check output and copy files to appropriate production and archive locations
  • ·SQL scripts to help validate data (testing)
Jun 2011 - May 2012

Programmer Analyst (Contract Position)

MESSA
  • Develop test scripts and continuous integration for regression testing
  • ·Created test plan and test cases for the automation testing efforts.
  • ·Created a data driven Regression testing framework within Rational Functional Tester using the data grid. 
  • ·Participated in Agile test planning and project reporting
  • ·Used the following aspects of testing: functional, regression and system testing.
  • ·Used LoadRunner for performance testing
  • ·Implemented Fitnesse (http://fitnesse.org/ ) to help automate user acceptance testing.
  • ·Implemented Jenkins (http://jenkins-ci.org/ ) for the continuous integration testing efforts.
Mar 2010 - Apr 2011

QA Analyst

Promodel
  • ·Design, execute & document test cases for windows-based applications using manual and automated procedures.
  • ·Identify, reproduce & isolate Software defects.
  • ·Report & track defects using Seapine's Test Track Pro.
  • ·Work closely with Software Developers to clarify feature specifications & defect reproduction
  • ·Execute test cases (manual and automated)
  • ·Log issues and report results.
  • ·Help establish test strategies to optimize test automation efforts.
  • ·Used Selenium for regression testing.

Education

Education
Oct 2006 - Jun 2008

Bachelors Science Information Technology

University of Phoenix