Grace Mccullough Email & Phone Number

Las Vegas, Nevada, United States

• Engineered and deployed a robust ETL pipeline using REST APIs, API Gateway, Lambda, SNS, and Athena; enhancing processing efficiency by 25%, cutting initiation times by 30%, and enabling real-time monitoring.• Automated the creation and deployment of AWS QuickSight dashboards for the QA team, centralizing data visualization across 20+ clients and allowing the team to transition from preparation to analytical roles and improved productivity.• Developed a scalable AWS Glue Data Quality… Show more • Engineered and deployed a robust ETL pipeline using REST APIs, API Gateway, Lambda, SNS, and Athena; enhancing processing efficiency by 25%, cutting initiation times by 30%, and enabling real-time monitoring.• Automated the creation and deployment of AWS QuickSight dashboards for the QA team, centralizing data visualization across 20+ clients and allowing the team to transition from preparation to analytical roles and improved productivity.• Developed a scalable AWS Glue Data Quality framework standardizing test suites across diverse datasets, automating pre-processing integrity checks, halting processing upon error detection, and ensuring 100% compliance with critical data standards.• Utilized Angular to modernize the front and back ends of an internal CRUD web application. This redesign updated workflows and UI to better align with client needs; user reports state satisfaction has improved by over 70%. Show less

• Replaced serial data processing structure with parallel workflows utilizing AWS Step Functions, enabling simultaneous operations and end-user visibility into individual client successes and failures, and reduced total run time by 80%.• Automated AWS Glue PySpark jobs to transform Kafka stream data and utilized AWS Lambda to load into PostgreSQL, streamlining processing for tens of millions of messages daily while significantly boosting throughput and capacity.• Developed a centralized… Show more • Replaced serial data processing structure with parallel workflows utilizing AWS Step Functions, enabling simultaneous operations and end-user visibility into individual client successes and failures, and reduced total run time by 80%.• Automated AWS Glue PySpark jobs to transform Kafka stream data and utilized AWS Lambda to load into PostgreSQL, streamlining processing for tens of millions of messages daily while significantly boosting throughput and capacity.• Developed a centralized logging system with AWS CloudWatch and SNS to forward logs into Kibana for consolidated oversight, enhancing ETL traceability, reducing issue resolution times by over 50%.• Designed and integrated an email notification system using AWS SES and HTML/CSS to alert end-users upon completion or failure of processing tasks, eliminating the need for manual monitoring of the console. Show less

• Designed a usability evaluation-based survey based on Human Computer Interaction literature to analyze the effectiveness of a task and time management application and improve the design of future iterations• Distributed survey using Qualtrics and analyzed results using IBM SPSS Statistics

• Built an application that replaced the Android UI to make communication out-of-the box accessible for users with visual impairments, limited literacy, diverse language background• Developed usability experiments to measure the effectiveness of the design based on Human Computer Interaction literature

• Undergraduate Research Fellowship• Analyzed the Swift, iOS version of the application to create a minimal viable product for Android devices using Android Studio, Java, XML and the Firebase API for the backend server to make the product accessible to Android users

Albany, New York, United States

• Created interactive dashboards introducing basic anomaly detection and forecasting using Amazon QuickSight that reduced man hours and increased accuracy for processing tens of millions of health care claims monthly.• Refactored over 500 SQL data quality assurance tests into a Python framework, enhancing cloud compatibility and simplifying test maintenance and creation.

Albany, New York, United States

• Generated Python models that achieved 94% accuracy when predicting the quality of claims data utilizing a Bag-of-Words model for Bayesian analysis, and achieved 95% accuracy utilizing Amazon SageMaker Autopilot.• Successfully predicted error codes for invalid claims using a multi-label machine learning approach, achieving 80% accuracy in Python and 99% accuracy with AWS Comprehend.

Niskayuna, New York

• Managed a team of 30 athletes, staff, and equipment• Established a clear line of communication between athletes, parents, and coaches• Organized and tailored daily practices for several boats with different goals and needs

Albany, New York, United States

• Consolidated 27 clients’ custom staging and processing code into a single sourced-controlled location to streamline their data processing and code maintenance, and tested each client’s change through parallel staging runs to ensure properly integrated• Optimized search time for specific code by investigating and removing 50% of completed code branches• Created a tool in Excel that categorized over 1500 data quality assurance tests that allow users to visualize which tests are standard… Show more • Consolidated 27 clients’ custom staging and processing code into a single sourced-controlled location to streamline their data processing and code maintenance, and tested each client’s change through parallel staging runs to ensure properly integrated• Optimized search time for specific code by investigating and removing 50% of completed code branches• Created a tool in Excel that categorized over 1500 data quality assurance tests that allow users to visualize which tests are standard versus custom and help determine if custom tests should be standardized• Utilized in house and commercially available tools (Deployment Wizard, Job Manager, Tortoise SVN) to reconfigure client deployments• Contributed as a member of a Scrum team towards improving their data pipeline in an agile environment• Communicated project updates through JIRA Show less

Niskayuna, Ny

• Individually coached adults ranging from 30 to 75• Tailored each practice and workout plan depending on the individual boat• Analyzed the technique of the rowers in the boat and created alternative practice plans in order to increase efficiency on the water

• Developed and executed group lesson plans for elementary aged children• Taught basic swimming and water safety skills • Created individualized swim reports

Schenectady, Ny

• Coordinated with a team of lifeguards both in the event of an emergency and during regular pool surveillance • Provided emergency care and treatment when appropriate while maintaining high levels of professionalism • Enforced and upheld facility regulations to maximize incident prevention

Amherst, Ma

The Isenberg Undergraduate Consulting Group provides a venue for students to gain the academic and practical knowledge to pursue careers in management consulting through engagement with local businesses, startups, and global enterprises.• Created weighted average model in Excel to prioritize potential customers for a $600mm global company in addition to marketing material that can be incorporated into client engagements • Co-authored an industry report analyzing the disruptive… Show more The Isenberg Undergraduate Consulting Group provides a venue for students to gain the academic and practical knowledge to pursue careers in management consulting through engagement with local businesses, startups, and global enterprises.• Created weighted average model in Excel to prioritize potential customers for a $600mm global company in addition to marketing material that can be incorporated into client engagements • Co-authored an industry report analyzing the disruptive forces affecting the hotel industry and its key players Show less

• Responsible for preparing tailored food orders for customers in a timely manner • Multitasked and maintained high levels of customer service during high-volume, fast-paced operations • Collaborated with shift team to maintain a clean and orderly workspace

Bachelor Of Science - Bs, Computer Science, 3.97

B.S in Computer Science and Applied Mathematics with a Data Analytics Concentration and Math Minor Honors College - Summa Cum Laude.

Bachelor Of Business Administration - Bba, Management, 3.94

Activities and Societies: Analyst for Isenberg Undergraduate Consulting Group Honors College