Cody Morelock

• Develop, maintain, and enhance BI reports and dashboards using tools like Power BI and SSRS. • Analyze sales, customer, and operational data to provide insights that drive business decisions. • Automate recurring reports and data pipelines to improve efficiency and accuracy. • Ensure data integrity by conducting quality checks, validations, and troubleshooting inconsistencies. • Develop and maintain stored procedures, views, and functions to support reporting needs. • Work closely with data engineers to design and improve data models and ETL processes. • Partner with sales, finance, marketing, and leadership teams to translate business needs into actionable insights. • Support forecasting and performance analysis to help drive revenue and operational efficiency. • Present key findings and recommendations to executive leadership in clear and meaningful ways. • Optimize BI workflows and reporting structures to enhance usability and decision-making. • Mentoring junior colleagues in SQL, Power Platform and best business practices.

• Designed and developed recurring reports using Report Builder and Visual Studio, delivering key insights to stakeholders across the organization. • Created, optimized, and maintained SQL queries and stored procedures in Microsoft SQL Server, utilizing T-SQL and other query techniques to meet business requirements. • Partnered with Business Analysts and stakeholders at all levels to develop data-driven reports and analysis projects that support strategic decision-making. • Gathered and documented reporting requirements, ensuring alignment with business goals and user expectations. • Conducted performance analysis and peer reviews to validate report accuracy, optimize query efficiency, and enhance overall data quality. • Collaborated with Marketing leadership to leverage email and SMS campaign analytics, improving engagement and targeting strategies.

• Developed and optimized SQL queries using PostgreSQL, MySQL, and PL/SQL to support email marketing initiatives and data-driven decision-making. • Designed and built user demographic reports by integrating locally gathered data with Acxiom datasets, providing actionable insights for marketing strategies. • Conducted thorough requirement analysis to ensure reports met business objectives and user needs. • Designed and implemented database schemas to support evolving data structures and reporting needs. • Managed manual data imports from various file formats into databases, ensuring accuracy and consistency. • Performed testing and validation of web applications as needed to support data integrity and marketing workflows.

• Designed and executed manual test suites for web and console applications using Microsoft Test Manager, ensuring software functionality and performance. • Gathered and analyzed requirements from multiple stakeholders to define clear and testable acceptance criteria. • Developed and documented detailed test cases, aligning with project requirements and industry best practices. • Actively participated in Change Control Board (CCB) meetings, providing quality insights and assessing potential impacts of software changes. • Supported User Acceptance Testing (UAT) by collaborating with end users to validate software functionality and business requirements. • ASTQB Certified Tester – Foundation Level, demonstrating expertise in software testing principles and methodologies.

• Designed and executed manual test cases for web and console applications using Microsoft Test Manager, ensuring software quality and functionality. • Collaborated with stakeholders to gather requirements and translate them into well-defined user stories for development and testing. • Developed and documented comprehensive test plans, detailing testing scope, objectives, and strategies to ensure application reliability. • Participated in release planning meetings, providing insights on testing timelines, risks, and readiness for deployment. • Assisted in User Acceptance Testing (UAT), working closely with end users to validate software functionality and ensure business requirements were met. • Provided user training and support, helping stakeholders navigate new application features and enhancements.

• Designed, developed, and implemented reports and queries to meet business needs, making independent decisions on best practices and methodologies. • Built and optimized reports using SSRS and SSMS. • Created and optimized T-SQL queries to retrieve, manipulate, and analyze data efficiently based on user requirements. • Conducted thorough requirement analysis to ensure reports delivered accurate and actionable insights. • Maintained and enhanced existing reports, ensuring they aligned with evolving business requirements. • Performed rigorous testing and validation of reports and queries to ensure data accuracy and performance efficiency. • Conducted query performance analysis and implemented optimizations to enhance execution speed and efficiency. • Developed and maintained stored procedures and SQL Server jobs to automate processes and improve data workflows. • Worked with SharePoint to develop and manage sites, lists, and Nintex workflows, streamlining business processes across departments. • Architected workflow solutions for various teams, ensuring scalability and compliance with business needs. • Managed SharePoint permissions and configurations in a development environment to support workflow automation. • Acquired 6C Public Trust government clearance for handling sensitive data in a secure environment.

• Support for HighJump Software's warehouse management system • Developing SQL queries and database modification • Modifying Crystal reports using Crystal Reports 9 • Creating web pages using HJS's WebWise utility • Hardware support included HP LaserJet printers, Intermec label printers, Symbol scanning devices and wireless access points