Data Analyst Quality Assurance

Dayton, USA ***** 412-***-**** *********@*****.*** WWW: Bold Profile

JAMEY HINDS

WEBSITES,

PORTFOLIOS,

PROFILES

● https://www.linkedin.com/in/jamey-hinds-65078a211/ PROFESSIONAL

SUMMARY

Highly proficient analysis, data mining and data profiling skills. Brings robust SQL and Python experience with consistent track record of solving real-world problems using design- oriented modeling approach.

●

History of delivering high-value insights on strategies for improving business processes, increasing efficiency and boosting the bottom line.

●

Qualified Data Analyst with thorough background in Quality Assurance and proven track record of delivering actionable insights. Developed and implemented data models leading to improved business decision-making processes. Demonstrated proficiency in SQL and Python, showcasing keen ability to collaborate with cross-functional teams.

●

ACCOMPLISHMENTS Acted as Data Analyst and Project

Coordinator to help deliver, maintain, and

enhance web-based data warehouse

solution to the Territory Sales Team at

Wrigley/Mars North America while at

Management Science Associates

●

Worked with Development and Primary

Stakeholders to convert fifteen actuarial

scorecard reports from Business Objects

to Cognos and anew backend Operational

Metrics schema as the lone Data QA

Consultant while at HMIG

●

Acted as Test Data Management lead and

QA consultant on conversion of Minnesota

and Nebraska based business to Highmark

Health ICIS application

●

Lead SQA team of four in performing

complex onsite testing and integration

efforts on high visibility Warehouse

Automation and Material Handling project

at LBrands Warehouse in Columbus, Ohio

while working at Swisslog

●

SENIOR DATA ANALYST (DATA GOVERNANCE) 03/2022 to 10/2023 Mass Mutual Ascend, Cincinnati

WORK HISTORY

Performed automated data testing, ETL testing, data migration testing and data monitoring using MS SQL and Groovy expressions in ICEDQ Platform

●

Created and verified daily, weekly and monthly outlier and error reports and modified SQL and Groovy code when necessary

●

Developed segmentation, ad hoc analytics and test design to support decisions within Actuarial and Annuities

●

Managed performance reporting and dashboards to provide performance reads of strategy changes and new initiatives

●

CIC TEST LEAD (ELIASSEN CONTRACTOR) 08/2020 to 09/2021 Cincinnati Financial, Fairfield

LEAD SQA TEST ENGINEER (CONTRACTOR) 02/2019 to 04/2020 Swisslog Automation, Mason

INTEGRATION AND TEST ENGINEER 06/2018 to 12/2018

Bombardier Transportation (Oxford Solutions)

Supported internal and external audits by preparing and providing relevant reports and analyses

●

● Performed detailed data and root-cause analysis for process improvements Documented test plan, test cases and provided traceability reports for monthly Agile releases

●

● Created, modified and coordinated test data needs with other departments Responsible for testing new functional enhancements, identifying and performing regression testing

●

● Collaborated with Stakeholders, BA's and Developers during agile meetings Reduced manual data entry errors by designing and deploying automated process with Python Pandas library to transform raw data into usable formats and load to staging schemas, saving ~ 30 hours of monthly processing

●

● Provided functional testing of SAP based internal claims system Documented test plans, test cases and provide traceability report for monthly waterfall releases

●

Responsible for identifying testing new functional enhancements and identifying opportunities for automation with Selenium IDE and collaborating with automation team

●

Lead testing efforts on project to convert ASCII data into XML for increased visibility with downstream web based applications using Soap UI

●

● Created Operational Metrics dashboards with Tableau and Crystal reports for underwriting Conducted risk assessments for various projects, prioritizing testing efforts based on potential impact and resources available.

●

● Delivered lectures on testing techniques, tools and protocols to internal staff. Lead complex onsite testing and integration efforts on high visibility Warehouse Automation project at The Limited LLC in Columbus, Ohio

●

Executed and modified automated functional tests, smoke tests and regression tests in Eclipse using Selenium

●

Performed onsite regression testing efforts of PLC based Warehouse automation and Material Handling systems for multiple clients (Victoria Secret, Tesla, Michelin)

●

Collaborated with offshore development team to report bugs, implement enhancements and provide testing metrics

●

Collaborated with controls engineers on PLC testing and integration of web portal into automated picking system

●

Monitored daily performance, gathered metrics and created data visualization charts for clients with Python Matplotlib Library

●

Reduced product defects by performing thorough root cause analysis and implementing corrective actions.

●

Applied group policy standards with Active Directory and tested security standards based on specified requirements

●

● Configured different server applications with Putty to adhere to diverse array of testing QA ANALYST/CONSULTANT AT HIGHMARK HEALTH AND HMIG 04/2012 to 05/2018 SDLC Partners

DATA ANALYST AND PROJECT LEAD 11/2004 to 10/2011

Management Science Associates, Pittsburgh, USA

standards

● Collaborated with Siemens Engineers during testing sprints in Bombardier Rail Control lab

● Configured C# and C++ Simulator programs to meet testing criteria

● Used Putty, Cygwin to execute Bash commands to restart process tracking scripts on the fly Collaborated with development teams to identify, reproduce, and resolve software issues promptly.

●

Created and managed complex test environments that simulate different temporary speed restriction scenarios for Primary Train Control in Bombardier Train Control lab

●

● Tested Front end web applications integration into safety system

● Attended Training sessions on Siemens Programmable Logic Controllers Acted as Quality Assurance/Business Intelligence Analyst with team of developers and Business Analyst's to convert fifteen actuarial and underwriting scorecard reports from Business Object's and Crystal Reports to Cognos and Tableau Desktop

●

● Tested ETL changes to customer workflows in Informatica using MS SQL Server Tested and modified database triggers, stored procedures and packages during monthly releases

●

Performed manual and automated mobile, tablet, and cross browser testing as part of the Web Ops project at Highmark Health

●

Implemented a cloud based solution with Device Anywhere to run Mobile and Tablet Regression with Selenium on most smart devices on the market using IOS and Android

●

Gained Exposure to automation testing with Selenium and JUnit/TestNG as part of the Web Ops project

●

Involved in GUI enhancement testing, Web Service testing and data migration testing in the ICIS application at the client, group and benefit level

●

Lead testing efforts on .net based procure to pay system used by several large PBM's, Cardinal Health and UPMC Health Systems

●

Acted as a QA Resource and worked with team of develepors and Business analysts on high visibility implementation of Splunk into Highmark Health Billing systems

●

Created complex queries to research data discrepancies and provide build metrics for in-house applications

●

Monitored, enhanced and debugged customer workflows in Informatica, Appworx and Control M

●

● Updated and created build and script parameters in Unix Developed and maintained technical and functional documentation for data warehouse systems for large Grocery, Confectionary and Tobacco clients

●

Attended professional training on multiple software development life cycle methodologies; I.e, Waterfall, RUP and Agile

●

Responsible for navigating an oracle database of 900+ tables using PL/SQL queries to assist in the research and creation of accurate test data for functional and integration testing

●

Helped perform integration testing between customer information system and a variety of downstream applications

●

● Monitored SAP based OLAP builds in Appworx platform Identified different types of relevant data to improve business performance with better analytics

●

● Leveraged available data to create charts and presented findings via written reports and in-person presentations

Maintained Web Based SCM using VMS Mainframe and SAS Interpolation program for Vending Clients

●

Identified and resolved data anomalies and inconsistencies to improve data accuracy and reliability

●

● Produced ad-hoc payment reports using PL/SQL and Perl WriteExcel module Python Pandas Library Issuing Organization: W3Schools Date Obtained: February 2019 Introduction to Programming Perl Issuing Organization: Learning Tree International Date Obtained: June 2005

CERTIFICATIONS

Point Park University, Pittsburgh, PA

Bachelor Of Applied Science, Information Technology, 08/2008 Pennsylvania Silver Certificate, Wexford, PA

Achievements In Multimedia, Multimedia, 01/2001

EDUCATION

SKILLS ● REQUIREMENTS ANALYSIS ● DATA ANALYSIS

● REPORT DEVELOPMENT ● QUALITY ASSURANCE

● COGNOS ● INFORMATICA

● TEST DATA MANAGEMENT ● PYTHON PANDAS, MATPLOTLIB, NUMPY

● TABLEAU DESKTOP ● REGRESSION TESTING

● AGILE METHODOLOGY ● XML CONVERSION

● FUNCTIONAL TESTING ● SELENIUM IDE

● MS, PL and T-SQL ● SOAP UI

● ACTIVE DIRECTORY ● PUTTY, CYGWIN, AND BASH COMMANDS

● LINUX AND MAINFRAME CONFIGURATION ● DB2 MAINFRAME

● SERVICE NOW ● MOBILE APPLICATION TESTING

● CROSS-BROWSER TESTING ● ETL SOLUTIONS WITH INFORMATICA

● VBA ● INFORMATICA WORKFLOWS

● ALLEN-BRADLEY AND SIEMENS PLCs MOBILE, TABLET, AND CROSS-BROWSER TESTING

●

CLOUD-BASED TESTING WITH DEVICE

ANYWHERE

● SELENIUM AND JUNIT/TESTNG

AUTOMATION TESTING

●

● GUI ENHANCEMENT AND API TESTING ● WEB SERVICE TESTING

● DATA MIGRATION TESTING ● OLAP/DATA WAREHOUSE ETL

● PERL SCRIPTING

Contact this candidate