Data Analyst Power Bi
Resume:
Sonya Traylor
***********@*****.***
Grand Blanc, Michigan US
Summary
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 organization's efforts.
Highlights:
●Access Database
●VBA
●SAP
●Data Analytics
●SQL Queries
●Excel
●Tableau
●Macros
●SharePoint Administration
●PM sensor testing using INCA software.
●Created ECU Tracker application.
●Guidewire
●Jira
●HP QC
●Power BI
●Power Apps
Consumers Energy (Contract Position) March 2022 to Present
Position: Data Analyst
Automation of Excel Spreadsheets
Create Reports using Power BI
Create apps using Power Apps
SharePoint Administrator
Data mining
Data mapping
FlowCal
Oracle
Analyze data.
Create KPI’s
Accident Fund (Contract Position) June 2021 to 2022
Position: Software Test Analyst
Functional testing
Responsible for developing test cases.
Capture results and test for defects.
SQL queries, performing as the test lead on small and medium scale projects and testing initiatives; working with other testers to determine test environment set-up requirements; developing and executing systems testing; providing system expertise on small and medium scale system changes; sharing test results with members of the project team; and logging and tracking defects found in testing.
Participates in product design reviews to provide input on functional requirements, product designs, schedules, or potential problems. Works collaboratively with BSA’s, Testers, Developers, and Internal Business Customers to investigate and explore alternatives to system issues and enhancements.
Consult with business unit staff to stay current with workflow processes, understand system processes, and discuss test plans/results. Contacts include Enterprise employees at all levels as well as external vendors.
State of Michigan (Short term Contract Position) June 2018 - October 2019
Position: Software Test Analyst
●User Acceptance testing
●Reviews new or modified program including document. Diagram and flow chart
●Reviews computer operating log to identify program processing errors
●Enters instructions into the computer to test programs for validity of results and accuracy
●Observes computer monitor screen during program test to detect error codes
●Set up tests at request of user to locate and correct program operating error
●SQL Queries
●Oracle Databases
●Testing using SoapUI
●Jira
●Jama
GM – AC Delco (Contract Position) February 2018 to May 2018
Position: Data Analyst
● Process part data from ERAPA utilizing Excel and Access databases
● Research data in IMDS and ProEComs
● Create reporting tools; maintain and track changes for commodities and substances
● Implement improvements to databases
● Identify inconsistencies and incorrect data
● Provide updates to management
● Create, modify or repair macros to obtain required data
● Perform file back-up (existing parts only)
● Streamline and commonize processes
● Create, modify and review work flow for domestic and global processes
● Follow-up to ensure necessary data and controls are applied (if applicable)
● Add labels to SDS’s (new parts only)
United States Postal Services ( Short term Contract Position) September 2017- January 2018
Position: QA Specialist
●Complete quality control and inspection of vehicle with Supplier when the vehicle arrives on site, identify and notify Supplier of any issues and if corrective action is required.
●Conduct daily vehicle inspection to check for damage, fluid levels, loose hardware, cracks, etc. to identify any mechanical and/or physical problems. Record fluid levels. If fluid levels need adjustment contact vehicle supplier for needed service and record observation and what was done by the supplier. (QAR check is to be independent of or the Carrier’s morning vehicle inspection.)
●Log vehicle daily mileage, energy consumption (fuel, electricity), time vehicle left post office, time vehicle returned, etc.
●Report safety issues or out of service status as soon as possible; no later than the day the issue was identified.
●Conduct driver review upon the carriers return from delivery to determine if there were any problems, things liked, or disliked.
●Conduct carrier in person survey at the conclusion of the 3-week test period.
State of Michigan ( Short term Contract Position) January 2017 - September 2017
Position: Software Test Analyst
●User Acceptance testing
●Reviews new or modified program including document. Diagram and flow chart
●Reviews computer operating log to identify program processing errors
●Enters instructions into the computer to test programs for validity of results and accuracy
●Observes computer monitor screen during program test to detect error codes
●Set up tests at request of user to locate and correct program operating error
●SQL Queries
●PL/SQL Database
Bosch (Contract Position) March 2015 - Oct. 2016
Position: Quality Analyst
●Enter Warranty parts claims using SAP Netweaver
●Create Main Investigation
●Create Goods and Shipping receipts
●Ability to automate Data entry in Sap Netweaver
●Familiar with creating tasks in SAP Netweaver
●Familiar with Mass Processing Editor
●Familiar with creating transactions
●Test PM Sensors using INCA
●Created ECU TRACKER tool for data management and analysis purposes.
**(Received accolades for my hard work, ability to quickly learn SAP and processing over 1000 warranty claims in a very short time)**
GM -AC Delco (Contract Position) Sept 2013 – Sept. 2014
Position: Quality Data Analyst
●VBA programming
●Access and Excel Automation (updating spreadsheets using access queries)
●Report Deployment
●Integrating Reporting Services with Share Point
●Tableau
●Created Access database application
●Created Excel reports
**(Received an award from MSX for my hard work, dedication and customer satisfaction) **
TGI Direct Marketing Mar 2012 - May 2013
Position: Data Analyst
●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
●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
●SQL scripts to help validate data (testing)
MESSA (Contract Position) Jun 2011 - May 2012
Position: Programmer Analyst
●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
●Participated in Agile test planning and project reporting
●Used the following aspects of testing: functional, regression and system testing.
●Used Load Runner 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.
Promodel
Position: Quality Assurance Analyst (Software Tester) Mar 2010 - Apr 2011
●Design, execute & document test cases for windows-based applications.
●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.
Sarcom (Contract Position) Nov. 2009 – Feb. 2010
Position: Service Technician (Huntington Banks)
●Perform Software upgrades and configuration
●Assisting in computer moves, adds and changes
●Providing technical support in hardware and software issue diagnosis and troubleshooting
Education
University of Phoenix - Sept. 2006 - Dec. 2008
(Completed the credits and requirements)
BSIT – (Software Engineer)
**REFERENCES AVAILABLE UPON REQUEST**
Contact this candidate