Jamey Hinds
Cincinnati,Ohio
Summary
Over ten years of experience in Information Technology with a focus in requirements analysis, data analysis, report development, quality assurance, production and deployment support.
Overview
12
12
years of professional experience
Work History
Senior Data Analyst
Mass Mutual Ascend
Cincinnati, Ohio
03.2022 - 10.2023
- Verified Business Intelligence Reports for actuarial department using MS SQL and ICEDQ
- Created daily, weekly and monthly outlier reports in ICEDQ using SQL and Groovy Expressions
- Verified daily outlier reports and modified when necessary.
CIC Test Lead (Eliassen Contractor)
Cincinnati Financial
Fairfield, Ohio
08.2020 - 09.2021
- Provided functional testing of SAP Application of Internal Claims system
- Document test plan, test cases and provide traceability reports for monthly waterfall 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 Dev during agile meetings
- Currently working on project to convert SAP data into XML for increased visibility with downstream web applications
- Creation of Dashboard metrics in Crystal Reports.
SQA Test Engineer (Contractor)
Swisslog Automation
Mason, Ohio
02.2019 - 04.2020
- Responsible for creation and execution of functional testing of robotic pick, pack and ship system
- Executed automated system tests in Eclipse using Selenium
- Performed onsite regression testing for multiple clients
- Queried MS SQL databases to view transactional anomalies and logged issues accordingly
- Responsible for testing enhancements
- Used SOAP UI for extensive web service testing.
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 to adhere to diverse array of testing standards depending on railway
- Configured XML to adhere to testing parameters
- Configured C# and C++ Simulator and Stimulator programs to meet testing criteria
- Used Putty, Cygwin and Bash commands to restart process tracking scripts on the fly
- Estimated the scope of testing selects and defines the measuring and test equipment needed for each test scenario
- Created and manages complex test environments that simulate different customer scenarios
- Tested Front end web applications integration into safety system and compliance with safety standards
- Configured key components in linux and mainframe for execution of different scenarios
- Configured encryption for basic security testing integration.
QA Analyst/Consultant – Test Data Management
SDLC Partners
02.2018 - 06.2018
- Created and maintained Client, Group, Member and test beds for Applications
- Periodically ran jobs in DB2 mainframe and putty to update test environments and restart web servers
- Worked with agile teams in planning to create test data that will support scope of testing
- Helped implement web based ticketing system for Test Data requests
- Helped Implement mobile application for group billing status in Android and IO
- Performed cross browser testing for Mobile and desktop Apps
- Maintained access, provided enhancements and updates for 100+ access databases used by claims and customer service teams
- Created ETL solutions in Informatica to convert inbound data from flat files to relational data
- Created and maintained macros with Visual Basic to streamline and automate daily business processes
- Provided technical insight to claims and customer support team management.
QA Analyst
Prodigo Solutions (KA Hamilton)
12.2015 - 03.2016
- Responsible for the testing of changes to a perl based EDI importer application and investigation of processing defects for EDI files in C# environment
- Performed User Acceptance Testing of multiple .net based dashboards and proprietary supply chain management applications
- Tested the buyer application suite in .net environment
- Helped test and implement Prodigo mobile application in IOS, Android and for Tablet’s
- Worked with Client Service and Product Analysts on requirement gathering, SOP's and Functional Specifications
- 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.
QA Analyst at Highmark and HMIG
SDLC Partners
04.2012 - 12.2015
- 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
- Acted as Quality Assurance/Business Intelligence Analyst with team of developers and Business Analyst's to convert fifteen actuarial scorecard reports from Business Object's and Crystal Reports to Cognos
- 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.
Data Analyst/Production Coordinator
Management Science Associates
- Maintained and updated several datamart schemas that housed distributor to retail level data for manufacturer's in the grocery industry doing business with MSA
- Ran and maintained database builds for delivery of Web Based sales solution to MSA customers
- Experience with maintaining a variety of perl, pl/sql and shell scripts that tracked metrics and automated manual processes
- Lead project status meetings as a production coordinator to communicate technical issues to Client Service Management and Business Analytics group
- Worked with Access and SAS development teams to create a manufacturer to distributor volume report to help identify outliers and perform verification of shipment and contract compliance
- Maintained process and script parameters in Control M and Appworx scheduling applications
- Used BASH to examine input files and update script parameters on the fly during production builds
- Experience executing jobs and editing files VMS mainframe to support OMNI builds.
Education
Scholastic Achievements in Computer Multimedia -
Pennsylvania Silver Certificate
01.2001
Introduction to programming Perl -
Learning Tree International
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
- Prodigo mobile application testing
- Requirement gathering
- SOPs and functional specifications
- SQL profiler
- Functional and regression testing
- Oracle database navigation
- Waterfall, RUP, and Agile methodologies
- Informatica workflows
- Unix script parameters
- Technical and functional documentation
- Mobile, tablet, and cross-browser testing
- Cloud-based testing with Device Anywhere
- Selenium and JUnit/TestNG automation testing
- GUI enhancement testing
- Web service testing
- Data migration testing
- OLAP/data warehouse ETL
- Datamart schema maintenance
- Perl, PL/SQL, and shell scripting
- Production coordination
- Access and SAS development
- Control M and Appworx scheduling
- BASH scripting
- VMS mainframe job execution and file editing
Timeline
Senior Data Analyst
Mass Mutual Ascend
03.2022 - 10.2023
CIC Test Lead (Eliassen Contractor)
Cincinnati Financial
08.2020 - 09.2021
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 – Test Data Management
SDLC Partners
02.2018 - 06.2018
QA Analyst
Prodigo Solutions (KA Hamilton)
12.2015 - 03.2016
QA Analyst at Highmark and HMIG
SDLC Partners
04.2012 - 12.2015
Data Analyst/Production Coordinator
Management Science Associates
Scholastic Achievements in Computer Multimedia -
Pennsylvania Silver Certificate
Introduction to programming Perl -
Learning Tree International