About
Accomplished Data Engineer with a strong foundation in back-end development and database management. I focus on designing and optimizing scalable data solutions that drive business insights and performance. I have hands-on experience working with Microsoft SQL Server, ETL design, implementation and maintenance, developing complex stored procedures, functions, troubleshooting, debugging and performing advanced query optimization to ensure efficient data handling across systems.
I bring several years of experience across the medical technology, library, and local government sectors, I combine technical expertise with a commitment to continuous improvement. I'm a results-driven developer with a passion for leveraging data to drive informed decision-making.
- Website: https://melissaschenk.github.io/
- Phone: +1 (360) 383-6794
- City: San Diego, CA, USA
- Degree: B.S. Manufacturing Management
- Minor: Spanish and French
- Email: melissa.b.schenk@gmail.com
Interests and hobbies include golf, ice hockey, watercolor painting, chess and surfing.
Skills
Tools: Microsoft Visual Studio, VS Code, AWS, GitHub, Node.js, React, Java, Snowflake, MS Azure, D3, Tableau, Excel, Word, Access, Visio, Figma, Crystal Reports, Jupiter Notebook, Pandas, Photoshop, Illustrator, Matplotlib
Databases: SQL Server, PostgreSQL, SQLAlchemy, MongoDB, NoSQL
Languages/Markup: C#, Python, SQL, Javascript, Java, Json, Xamarin, XAML, CSS, HTML, Visual Basic/VBA
Resume
Summary
Melissa Schenk
Passionate about uncovering meaningful insights through data analysis and transforming complex information into actionable, business-relevant outcomes. Experienced in collaborating with cross-functional teams designing and implementing complex solutions. Skilled at interpreting and presenting data in a clear, accessible way for stakeholders with diverse priorities and perspectives, helping to drive informed decision-making.
- San Diego, CA
- +1 (360) 383-6794
- melissa.b.schenk@gmail.com
- https://melissaschenk.github.io/
Education
Data Science and Visualization Certificate
2020 - 2021
UCSD Extension San Diego, California
A 24-week intensive program focused on gaining technical programming skills in Excel, VBA, Python, R, JavaScript, SQL Databases, Tableau, Big Data, and Machine Learning.
Bachelors of Science in Manufacturing Management
2001 - 2006
Western Washington University, Bellingham, Washington
Minor in Spanish and French
Professional Experience
Lead Solution Developer
2024 - Present
Medidata Solutions, Boston, MA (Remote)
Results driven Data Engineer with deep expertise in SQL development, back-end systems, and scalable data architecture. Proven ability to design, optimize, and implement high-performance data solutions using Microsoft SQL Server, developing complex stored procedures, advanced queries, and ensuring data integrity across systems.
- Built parallel job kickoff utility. Client asked to prioritize on-time, efficient delivery of business insights. Parallel job utility monitors job chain and automatically starts dependent jobs after target job has completed successfully. After parallel job utility implementation, server processes completed three hours faster, making business insights available to end-users faster and more efficiently.
- Created custom functions and stored procedures to support complex data remediation.
- Agile scrum leader committed to continuous improvement, and empowering teams to build a culture of collaboration, and delivery excellence.
Senior Solution Developer
2021 - 2024
Medidata Solutions, Boston, MA (Remote)
- As part of a process improvement initiative, I identified two opportunities for improvement in sql stored procedures that resulted in 96% and 99% improvement in processing time (from 81 minutes down to an average of 2.7 minutes and 85 minutes down to 1 second). Was recognized by leadership team for biggest time savings improvement implemented during that quarter.
- Scrum leader removing blockers efficiently, and keeping everyone aligned on goals.
- Converted automatic slack notification from powershell process to python.
- Maintained and built out front-end data visualizations in Tableau and PowerBI
Software Engineer
2006 - 2021
Infovision Software, Inc. San Diego, California
Built and implemented software solutions for libraries (public, school, special libraries) and local and county government planning departments.
- Using Microsoft SQL Server, Azure cloud services and Visual Studio, developed and implemented functionality to improve the library reserve process based on user development requests. Added preference in configuration that allows reservation at copy level or catalog level in order to solve the problem with reserve queue (the order the library patrons get the holding).
- Built console application in C# that monitors incoming support emails and auto-generates support cases in case management system (Language: C#, Database: Microsoft SQL Server database). Increased case tracking by 84% from the first year case management system was implemented.
Front-End Developer
Responsible for design implementation in addition to troubleshooting style and display issues.
- Lead application design implementation for ASP.NET enterprise web application. Implemented front-end design into web-based Evolve EDMS, Evolve ILS and Evolve Planning enterprise software solutions.
Project Manager
Onsite and remote project manager for software implementations for library and planning web applications. Data conversion, application configuration, business analyst, training, and project closure. Fully responsible for client satisfaction throughout the implementation process.
- Implemented Eau Claire Wisconsin Code Enforcement Project. Analyzed business process, built out system requirements, added configuration and based on user feedback.
Software Support Engineer
Responsible for communication with customers, documentation, prioritization and resolution.
- Technical account manager for customer base of over 120 libraries, cities and counties using our software solutions. Technical and customer support to end-users and IT professionals.
- Increased case close rate by 6%. Completed 4149 cases and 8243 case actions since current case management tracking was implemented in May 2015.
Portfolio
Collection of projects
