Keith Nelson Email & Phone Number

Greater Minneapolis-St. Paul Area

Greater Minneapolis-St. Paul Area

Created and maintained testing suites in qTest for new functionality, regression, and end-to-end testing for cloud-based servicesProvided end-to-end testing for cloud-based services supporting over 200 thousand active households running over 2.1 million IoT devicesProvided exploratory and regression testing for new features and productsWork closely with development and product teams to ensure proper test coverageEnsured proper documentation in bug tickets including: - Steps to reproduce - Expected results - Relevant system logs - Customer impactUse Sumo, device logs (iOS and Android), and user logs to research issuesAdapted to rapidly changing timelines and feature scopeProvided general regression and feature testing coverage for weekly deployment of our data management system to the cloud

Minneapolis

Gather requirements from multiple sources.Combine various requirements into the simplest acceptance criteria possible. Review final requirements with stakeholders.Work with stakeholders and engineering team to prioritize tasks. Triage and prioritize needed enhancements.Create, quality check and securely transmits over 200 weekly enrollment files.Review both test and production 834 enrollment files for HIPPA and carrier specific compliance issuesDeveloped a three step testing strategy that was able to confirm all standard enrollment test scenarios while being flexible enough to accommodate non-standard scenario requestsCreate and maintain enrollment file templates using HandlebarsEnsure data is sent securelyResearch complex data and transmission issues.Initiate corrections in data and functionality

Greater Minneapolis-St. Paul Area

Created configurable ETL processes in SQL Server Integration Services to load and validate client claims data into company’s database. Assisted in troubleshooting, maintaining and modifying client-facing web portal in ASP.NET.Assisted internal clients in optimizing SQL queries to reduce run time. Designed reports in SQL Server Report Services that increased productivity by easing the access and visibility of data.Responsible for creating, validating and submitting ANSI 837 health care claim files to the Minnesota Department of Human Services. Created validation program in VB.NET that compared data from ANSI 837 flat files with data stored in our data warehouse.

Led software development for company’s highly configurable, HIPAA-compliant ANSI 834 feed, comprised of hundreds of weekly eligibility feeds to insurance carriers.Developed and deployed proprietary applications and supported seamless client-to-carrier data exchange utilizing C, SQL and PERL.Created SQL queries/reports, evaluated data quality, and developed/executed corrective action plans.Defined reporting requirements, generated project-specific internal and external data analysis and extraction reports.Built hundreds of client-specific programs that facilitated system-to-system data exchange and clean-up processes and consistently met implementation timelines.Served on several Technical Committees, evaluated technical/library standards issues, improved operational efficiencies, and strategized/expanded potential product offerings.

Graphics SpecialistProduced hundreds of graphs, charts and photos for clients’ quarterly and annual reports and supporting documents.Prepared print-ready copies of client logos, photos and graphics.Created proxy cards to exact specifications necessary to be readable by optical scan machines.Conversion SpecialistPrepared and coded financial documents for submission to the Securities and Exchange Commission.Developed macros and work flows to address formatting and data issues in client-supplied data.

Ensured customer satisfaction by asking open questions that enabled selection of best-suited product.Developed materials for and taught basic black-and-white and color print processing class.Trained staff in sales techniques, merchandise and product knowledge.Appraised used merchandise for purchase and preparing bids for schools and corporations.