Crystal Smith

Led end-to-end IT consulting and contracting projects, delivering custom software and system integration solutions to enhance operational efficiency and reliability for B2B clients.

• Designed and implemented custom software solutions, significantly improving operational workflows for diverse B2B clients and achieving high client satisfaction.
• Directed end-to-end system integration projects, providing technical guidance that ensured seamless deployment and optimized performance.
• Conducted comprehensive stakeholder meetings and requirements scoping sessions, leading to the successful delivery of complex projects and effective training sessions.
• Developed and deployed repeatable solutions and standardized processes, reducing implementation errors and enhancing overall system reliability.

Managed the full lifecycle implementation of complex software products for multiple clients, ensuring high satisfaction and retention through expert technical solutions and support.

• Managed the successful implementation of complex software products across diverse clients, ensuring on-time delivery and adherence to project scope.
• Utilized advanced SQL queries, scripting, and schema definitions to customize product functionalities, enhancing system performance for client-specific needs.
• Collaborated cross-functionally with internal teams to align client needs with software features and timelines, resulting in a reduction in project delays.
• Provided critical post-go-live support and technical guidance, ensuring high client satisfaction rates and contributing to strong client retention.
• Translated complex business requirements into well-designed technical solutions, leveraging platform capabilities and APIs for efficient data ingestion and integration.

Executed full lifecycle software development, designing and implementing robust SQL queries and applications to support university operations.

• Designed and implemented complex SQL queries, stored procedures, and functions, optimizing database performance for critical university applications.
• Managed full lifecycle software development, from planning to deployment and maintenance, ensuring high-quality software delivery within project timelines.
• Developed and maintained scalable software applications using .NET, C#, and ASP.NET, enhancing system functionality and user experience.
• Utilized TortoiseSVN for version control, streamlining source code management and enabling efficient team collaboration across multiple projects.

Managed IT operations, overseeing web application development, database management, and technical support to ensure system stability and efficiency.

• Analyzed, designed, coded, tested, and maintained database-driven web applications within a LAMP environment, improving application stability.
• Upgraded critical applications from PHP 4.x.x to PHP 7.x.x, enhancing security and performance across key systems.
• Managed comprehensive database import/export processes, ensuring data integrity and availability for critical business operations.
• Provided expert end-user support and troubleshooting for web applications, hardware, and software, resolving issues efficiently to minimize downtime.
• Researched and evaluated new technologies, leading to the successful implementation of an upgraded IT infrastructure that boosted system capabilities.

Served as a key liaison for information systems, developing and maintaining database objects, and supporting evaluation computer applications for the school district.

• Acted as a crucial liaison between departments and information systems staff, facilitating the design and resolution of programming issues for applications.
• Developed and modified complex database objects using C# and T-SQL, enhancing data management efficiency for the MSSQL Server 2016 environment.
• Managed and queried MSSQL Server 2016 databases, optimizing job scheduling and SSIS packages to improve data processing speed.
• Collaborated extensively with other departments on processes and projects, ensuring seamless integration and data flow across various systems.
• Researched, analyzed, designed, and maintained critical evaluation computer applications, supporting data-driven decision-making for the district.

Managed system integration processes, optimized database performance, and provided critical support for the student information system within the school district.

• Created and managed robust processes for integrating systems across multiple platforms, enhancing data consistency and interoperability.
• Monitored MSSQL performance using native and third-party tools, identifying and resolving issues that improved system uptime.
• Analyzed and optimized T-SQL code for accuracy, reducing query execution times and improving data retrieval efficiency.
• Provided comprehensive support for the student information system, ensuring reliable access for over 40,000 users.
• Collaborated with multiple departments to standardize and systematize internal processes, leading to improvement in operational efficiency.

Developed new functionality for government education applications and enhanced cybersecurity posture by identifying risks and modifying database structures.

• Developed new, critical functionality for Government Education-based applications using .NET and C#, enhancing user experience and system capabilities.
• Identified and exposed areas of cybersecurity risk within applications, leading to proactive mitigation strategies that improved system security.
• Collaborated effectively with non-technical personnel to analyze requirements and impacts, ensuring technical solutions aligned with business needs.
• Modified MSSQL Server 2008 database tables and stored procedures, optimizing data processing and retrieval speeds by 10%.
• Created and modified essential reports using Crystal Reports for Visual Studio 2013, providing key insights for data-driven decision-making.

Led the development of native and hybrid mobile applications for iOS and Android, enhancing user experience and implementing critical functionalities.

• Developed and launched native and hybrid mobile applications for iOS and Android platforms
• Created and modified WCF web services using JSON/REST/XML/SOAP, improving data integration efficiency for mobile applications
• Implemented robust push notification capabilities, increasing user engagement by 15% and improving communication effectiveness.
• Optimized application UI for both tablet and phone dimensions, enhancing user experience and accessibility across various devices.
• Modified internal websites for mobile-friendliness using ASP.NET, C#, and Kentico CMS, improving responsiveness and user satisfaction.

Developed an AI Auditing system designed to uphold organizational standards by automating compliance checks and identifying anomalies.

Created a system for identifying automation opportunities across departments and setting up efficient data pipelines.