Cody Mayers Email & Phone Number

Charlotte, North Carolina Area

• Built interactive dashboards in Spotfire, enabling financial institutions to analyze compliance risk.
• Led Python projects ranging from custom Spotfire extensions to end-to-end data pipelines.
• Integrated Spotfire analyses into web applications using HTML, CSS, and JavaScript.
• Developed stored procedures and functions in a Microsoft Azure SQL Server environment.
• Developed ETL processes, including workflows in Alteryx and scripts in SQL and Python.
• Implemented version control in GitHub for department’s code repositories.

Charlotte, North Carolina

• (Wells Fargo contract)
• Extracted, manipulated and analyzed large datasets in a Teradata SQL environment.
• Identified strategic business problems that require analyses or process improvement.
• Presented analytical conclusions in the form of Excel pivot tables and summary calculations.
• Developed macros that boost team productivity by automating analysis and reporting tasks.

Charlotte, North Carolina

• (Bank of America contract)
• Built analytic queries and procedures in Microsoft SQL Server and Teradata environments.
• Developed, automated and conducted troubleshooting of ETL data pipelines using SSIS.
• Deployed SQL procedures that provided investment portfolio information to CRM applications.
• Assisted with data and process migration efforts across database management systems.

Charlotte, North Carolina

• Developed database structures and stored procedures in Microsoft SQL Server.
• Designed and implemented dimensional data warehouse architectures.
• Deployed and configured ETL control flows using SSIS packages and projects.
• Built dashboards, reports and other visualizations using SSRS, C#, and MicroStrategy.

Augusta, Georgia Area

• (federal government contract)
• Applied data cleaning techniques to ensure exclusion of erroneous data.
• Authored, reviewed, and exported time-sensitive reports on statistical findings.
• Created custom Kibana dashboards to visualize data from Elasticsearch data sources.
• Developed, tested and deployed SQL and Python procedures that automated analytics efforts.

Augusta, Georgia

• Led and trained team of 5 analysts, regularly exceeding weekly production goals.
• Optimized SQL queries and Python algorithms in accordance with reporting requirements.
• Modeled relevant data using Microsoft Excel and reported actionable conclusions.
• Performed quality assurance and provided formal feedback on team members’ reports.