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.