Jamey Hinds
Data Analyst and QA Consultant
Dayton,USA
Summary
- Highly proficient with expert-level gap analysis, data mining and data profiling skills. Brings robust SQL experience and 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. Skillfully collect, review, and model data to understand problems and devise creative solutions. Well-organized in managing assets and evaluating trends.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Senior Data Analyst (Data Governance)
Mass Mutual Ascend
03.2022 - 10.2023
- 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
- 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.
CIC Test Lead (Eliassen Contractor)
Cincinnati Financial
08.2020 - 09.2021
- 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 SAP 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 test efforts based on potential impact and resources available.
- Delivered lectures on testing techniques, tools and protocols to internal staff.
Lead SQA Test Engineer (Contractor)
Swisslog Automation
02.2019 - 04.2020
- 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 IDE using Selenium
- Performed onsite regression testing efforts of Warehouse automation systems for multiple clients (Victoria Secret, Tesla)
- 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.
Integration And Test Engineer
Bombardier Transportation (Oxford Solutions)
06.2018 - 12.2018
- 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 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
QA Analyst/Consultant At Highmark Health And HMIG
SDLC Partners
04.2012 - 05.2018
- 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 database triggers, stored procedures and packages during monthly releases
Data Analyst And Project Lead
Management Science Associates
11.2004 - 10.2011
- Created complex queries to research data discrepancies and provide build metrics for SCM based applications
- Investigated defects and performance of services using SQL profiler in MS SQL
- Responsible for functional and regression testing multiple C# and .net based SCM/CRM applications in the Toreion/Prodigo web suite
- Monitored and enhanced customer workflows in Informatica
- Updated and created build and script parameters in Unix
- Developed and maintained technical and functional documentation for data warehouse systems at HMIG
- Excellent knowledge of 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
- Gained experience with mobile, tablet, and cross browser testing as part of the Web Ops project
- Implemented a cloud based solution with Device Anywhere to run Mobile and Tablet Regression on most smart devices in the market using IOS and Android
- Gained Exposure to automation testing with Selenium and JUnit/TestNG as part of the Web Ops project
- Performed all aspects of testing as lone QA tester on agile team
- Including test strategy, test planning, test execution and defect resolution
- Involved in GUI enhancement testing, Web Service testing and data migration testing in the ICIS application at the client, group and benefit level
- Helped perform integration testing between customer information system and a variety of downstream applications
- Assisted with testing on the Circle K automation project at HMIG
- This project programmatically streamlined multiple archaic manual processes that took the actuarial department days to process every time there was an updated input file or change in policy
- Performed parallel QA testing between the three applications to ensure statistics were accurately reflected the database
- Developed various mappings to perform ETL of source data into the OLAP/data warehouse
- 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
- Validated integrity and completeness of statistical data
- Identified and resolved data anomalies and inconsistencies to improve data accuracy and reliability
Education
Bachelor Of Applied Science - Information Technology
08.2008
Achievements In Multimedia - Multimedia
01.2001
Skills
- REQUIREMENTS ANALYSIS
- DATA ANALYSIS
- REPORT DEVELOPMENT
- QUALITY ASSURANCE
- PRODUCTION AND DEPLOYMENT SUPPORT
- PROJECT COORDINATION
- WEB-BASED DATA WAREHOUSE SOLUTION
- BUSINESS OBJECTS
- COGNOS
- INFORMATICA
- TEST DATA MANAGEMENT
- SQL
- ICEDQ
- SAP APPLICATION
- TEST PLAN CREATION
- TEST CASE CREATION
- TEST DATA COORDINATION
- REGRESSION TESTING
- AGILE METHODOLOGY
- XML CONVERSION
- CRYSTAL REPORTS
- FUNCTIONAL TESTING
- SELENIUM
- MS SQL
- SOAP UI
- ACTIVE DIRECTORY
- SECURITY TESTING
- C# AND C PROGRAMMING
- PUTTY, CYGWIN, AND BASH COMMANDS
- TEST ENVIRONMENT MANAGEMENT
- LINUX AND MAINFRAME CONFIGURATION
- ENCRYPTION TESTING
- TEST DATA CREATION AND MAINTENANCE
- DB2 MAINFRAME
- WEB-BASED TICKETING SYSTEM
- MOBILE APPLICATION TESTING
- CROSS-BROWSER TESTING
- ACCESS DATABASE MAINTENANCE
- ETL SOLUTIONS WITH INFORMATICA
- VISUAL BASIC MACROS
- CLAIMS AND CUSTOMER SUPPORT
- PERL-BASED EDI IMPORTER APPLICATION TESTING
- NET-BASED DASHBOARDS AND SUPPLY CHAIN MANAGEMENT APPLICATIONS TESTING
- BUYER APPLICATION SUITE TESTING
Accomplishments
Achievements in Multimedia
Pennsylvania Silver Certificate 2001
Certification
Python Pandas Library
Issuing Organization: W3Schools
Date Obtained: February 2019
Introduction to Programming Perl
Issuing Organization: Learning Tree International
Date Obtained: June 2005
Timeline
Senior Data Analyst (Data Governance) - Mass Mutual Ascend
03.2022 - 10.2023
CIC Test Lead (Eliassen Contractor) - Cincinnati Financial
08.2020 - 09.2021
Lead SQA Test Engineer (Contractor) - Swisslog Automation
02.2019 - 04.2020
Integration And Test Engineer - Bombardier Transportation (Oxford Solutions)
06.2018 - 12.2018
QA Analyst/Consultant At Highmark Health And HMIG - SDLC Partners
04.2012 - 05.2018
Data Analyst And Project Lead - Management Science Associates
11.2004 - 10.2011
Python Pandas Library
Issuing Organization: W3Schools
Date Obtained: February 2019
Introduction to Programming Perl
Issuing Organization: Learning Tree International
Date Obtained: June 2005
Point Park University - Bachelor Of Applied Science, Information Technology
Pennsylvania Silver Certificate - Achievements In Multimedia, Multimedia
Similar Profiles
Angela HoltAngela Holt
New Business Representative at Mass Mutual AscendNew Business Representative at Mass Mutual Ascend
Diamond CarrollDiamond Carroll
Senior Accounting Representative at Mass Mutual AscendSenior Accounting Representative at Mass Mutual Ascend
KIMBERLY MASTERSKIMBERLY MASTERS
Claims Processor at Mass Mutual AscendClaims Processor at Mass Mutual Ascend