With over 5 years in QA, I've led comprehensive testing initiatives and developed automated regression testing workflows. Achievements include delivering a 50% increase in efficiency through Python and SQL scripts for testing, processing 40GB+ logs, improving QA performance by 65%, and upskilling new hires in QA best practices in 6 months.⟐ Track record of providing valuable insights from complex datasets, supporting business decision-making processes

Skills:

•           Python, SQL, BigQuery, GCP, VSCode, Postman

•           Machine Learning, Statistical Analysis & Predictive Modeling, Supervised & Unsupervised Learning, Dimensionality Reduction, Hypothesis testing, Data Mining

 

Education:

Boise State University, MS in Economics • Dec 2022 (GPA 3.8)

Courses: Quantitative Methods, Advanced Econometrics, Data Science, Machine Learning, Data Structures, Linear Algebra, Probability & Statistics

Boise State University, Economics, BA, Applied Math and Music minors • May 2016 (GPA 3.0)

Courses: Computational Methods of Mathematics, Microeconomics, Labor Economics, Probability & Statistics, Computational Math, Linear Algebra, Calculus I, II, & III, Computer Science I & II, Data Structures, Computer Security and Information Assurance

 

Work Experience:

Fitted - SQL/Quality Assurance Engineer • May 2022 - May 2023

•           Led comprehensive QA testing efforts, both manual and automated, across user interfaces and functionalities within a greenfield b2b platform, ensuring comprehensive coverage across critical areas such as brand, retailer, and internal admin portals, login flows, auth0 user management (with some icing on top to mitigate some auth0 shortcomings), ordering, payments systems with retailer- and product-specific wholesale discounting, invoicing, a retailer map with data in MongoDB, as well as created data integrity checks for various BI datapoints for brand and retailer statistics.

•           Engineered numerous python and SQL scripts to bolster QA operations and issue identification: implemented a regression test for a client- to server-side cart migration, established a set of scripts to deleted test users from auth0 and across the platform for maintaining a clean test environment, crafted a script to reproduce orders from products to lower environments to effectively debug user-issues, and created a set of SQL scripts for efficiently identifying data issues. This resulted in a 50% increase in QA efficiency in 6 months.

•           Transformed the Software Development Life Cycle (SDLC), enhancing visibility into issue statuses and deployment expectations. Additionally, developed custom Jira dashboards specifically tailored to QA and Product teams, streamlining task management and improving interdepartmental communication.

•           Orchestrated a large-scale data analysis project in half a day, processing over 40GB of logs from GCP’s Logs Explorer using Python, facilitating identification and repair of client accounts affected by a days-long inventory ingestion failure.

•           Swiftly addressed high-priority ad hoc requests and emergencies, showcasing ability to respond and adapt to changing needs and unexpected challenges

Boise State University, PI Michail Fragkias, PhD - Researcher • Jun 2022 - Jan 2023

•           Utilized structural causal model to understand the causal direction of growth factors in the Pearl River Delta region of Southern China.

•           Combined satellite image embeddings and socio-economic data to conduct a unique regional economic analysis.

•           Constructed a directed acyclic graph (DAG) using an Additive Noise Model to estimate the causal structure.

Clearwater Analytics (CWAN) - Quality Assurance Analyst III • Mar 2020 - Dec 2020

•           Engineered an automated process for dynamic construction of regression test cases, leveraging Python, Bash, and Jenkins. The workflow encompassed 65% of client report variations, covering over $3T in assets, and successfully identified 90% of data regressions pre-manual QA. This achievement significantly improved efficiency and report generation accuracy over 3 months.

•           Advocated for higher-quality project outcomes and reduced deployment risk by refining acceptance criteria and aligning deployment cycles more closely with business objectives, fostering a more predictable and reliable project delivery environment.

•           Demonstrated leadership capabilities by onboarding and training four new hires on best practices for quality assurance, risk mitigation, and microservice deployment management. This improved team productivity and adherence to QA standards.

•           Recognized as being in the top 10% of R&D employees, selected for a professional development and mentorship program, indicative of technical expertise, commitment to quality, and potential for leadership.

The Krazy Coupon Lady (KCL) - Sr. Quality Assurance Engineer • Aug 2019 - Mar 2020

•           Leveraged Cypress and Python to build comprehensive end-to-end testing for server-side renderings, covering 80% of React components

•           Executed and monitored metadata regression test, validating production sitemap and capturing all regressions that would negatively impact SEO

•           Promoted best practices for QA and release management by defining release processes, working closely with stakeholders to define acceptance criteria, participated in code reviews to provide a voice focused on automated testing needs

Clearwater Analytics (CWAN) - QA Analyst • Sep 2016 - Aug 2019

Mathematics Learning Center (MLC) - Math Tutor • Aug 2015 - May 2016

•           Assisted students in understanding mathematical concepts ranging from algebra and trig to differential equations and integral calculus

Village Hope, PI Don Holley, PhD - Research Intern • May 2015 - Aug 2015

•           Researched regional economics literature on mid-scale poverty reduction projects in Africa. Authored a literature review for Village Hope on the research in sustainable methods for poverty reduction in Sierra Leone, Africa

Canyon County Celebration Book, PI Don Holley, PhD - Research Intern • Jan 2014 - May 2014

•           Collected, Aggregated, and presented data on agricultural, financial, and housing markets over the prior 120 years to tell the story of Canyon County’s economic development

Projects:

Risk Scorecard (Fitted) • Discontinued/Anticipated May 2023 - July 2023

•           Launched a Risk Scorecard project, with a specific aim to minimize financial exposure by predicting retailer reliability in fulfilling accounts receivable. Earned dedicated weekly development time of 10 hours due to the project's strategic importance.

•           Collaborated closely with the Lead Cloud Engineer and the Director of Finance, defining the project's business objectives and scope. Key features for the risk scorecard were identified during these meetings, including degrees of delinquencies, weighted averages of successful payments, NAICS industry codes of the retailers, and a host of additional features.

•           Created a complete epic in Jira, outlining clear steps for various stages of the project - feature engineering, model experimentation, and risk dashboard construction - and scoping each phase of the project. The project plan incorporated various credit scorecard techniques, notably clustering algorithms like KNN and K-means, and a strategy resembling an RFM analysis where internal decision-making on factor weights was based on domain knowledge and the retailer's industry exposure to macroeconomic conditions.

•           Made significant headway in the initial couple of weeks by completing most of the feature engineering for new datapoints and maintaining them in BigQuery views, with each update meticulously documented in respective Jira tickets.

Dynamic Order Builder from Invoice Data (Fitted) • Apr 2023

•           Conceived and implemented a dynamic Python module to construct and place orders based on datapoints from multiple sources, enhancing order processing efficiency.

•           The module transformed data from CSVs, database tables, and API responses into actionable orders, demonstrating the potential of automation in improving operational efficiency.

•           Catalyzed a 20% boost in gross market value across the platform on the first day of module usage, showcasing the direct business impact of efficient data use.

Recency, Frequency, Monetary Value (RFM) Analysis (Fitted) • Mar 2023

•           Pioneered an innovative RFM analysis, segmenting clients based on their revenue impacts, leading to enhanced understanding of customer behavior.

•           Leveraged the RFM insights to inform marketing and client service strategies to better target campaigns.

Payment Terms Analysis (Fitted) • Feb 2023

•           Conducted an in-depth Payment Terms analysis to gain valuable insights into the rationale behind clients' selection of different terms, fostering a deeper understanding of financial behavior and its impact on delinquencies.

•           Presented analysis findings at a company-wide meeting, promoting an organization-wide understanding of client motivations and influencing future strategies to mitigate potential financial risks.

Auth0 Role Migration (Fitted) • Feb 2023

•           Designed and developed Python scripts to facilitate the migration of Auth0 roles, improving user management and system reliability, and utilized Python, JSON, pandas_gbq, and requests for efficient role mapping.

Data Integrity and BI Dashboard Feed (Fitted) • Dec 2022

•           Designed and implemented views in BigQuery to perform data integrity checks, simultaneously feeding business intelligence dashboards with meaningful data for company-wide insights.

Assessing the Impact of the 2018 Tariffs on European Wine (Master’s Thesis) • Published Dec 2022

•           Investigated the impact of the additional 25% tariff levied on French, Spanish, German, and British wine using a vector autoregression model in statsmodels on data collected from various datasources (APIs, web scraping, and downloaded PDFs and CSVs) to gain a better understanding of the trade flows of wine in the U.S., their domestic production, and the impacts on unimpacted countries’ wine flows as well as the price paid for wine by U.S. consumers

•           https://doi.org/10.18122/td.2021.boisestate

•           https://github.com/henrymjohnson/the-effect-of-tariffs-on-wine-prices

Invoice Parser for Brand Invoices (Fitted) • Nov 2022

•           Provided POC of automated ingestion of brand invoices using python and GCP, training the model on PDFs stored in Buckets and utilizing Document AI to extract the invoice datapoints with their corresponding confidence levels and store it off in Buckets for business to decide whether or not it needs reviewed

Multi-Label Classification of Movie Genres From Their Scripts (Self-guided) • Dec 2021

•           Supervised learning for identifying movie genres based on their scripts; most genres predicted with over 90% accuracy. Scraped movie script data using beautifulsoup from IMDB’s primary website and linking it to additional datasources to use in the model.

Predicting the Directional Change in Retirement Filers from Publicly-Available Financial Data (Self-guided) • May 2021

•           Project received second place in the Graduate Research Conference

 

Awards and Leadership:

SQL (Advanced) Certificate, HackerRank (Jun 2023)

Second Place, Graduate Research Poster Competition, Boise State University (May 2021)

•       Recognized for research excellence for the project “Predicting the Directional Change in Retirement Filers from Publicly-Available Financial Data”

Selected as Top 10% of Development, Clearwater Analytics (May 2020)

SQL (Intermediate) Certificate, HackerRank (Sep 2020)

President, The Economics Association, Boise State University (Aug 2015 - May 2016)

•   Coordinated large-scale lectures featuring nationwide economists along with monthly meetups with local industry professionals, enhancing club visibility and engagement

•   Grew the club’s annual budget by 200% through pursuing grants and forming partnerships with both local and national think tanks