DENNIS WILLIS
SENIOR DATABASE DEVELOPER
Charlotte,NC
Summary
Results-driven data professional with solid foundation in report development and data analysis. Skilled in SQL, data visualization tools, and business intelligence platforms. Strong team collaborator who adapts to evolving project requirements and consistently delivers high-quality results. Recognized for problem-solving abilities and effective communication that drive impactful business insights.
Overview
11
11
years of professional experience
Work History
Report Developer
Step Up For Students
Tampa, Florida
04.2024 - Current
- Designed and developed interactive Power BI dashboards, reports, and datasets aligned with business requirements.
- Collaborated with stakeholders to gather, analyze, and document BI and reporting requirements.
- Built optimized Power BI data models to ensure accurate, scalable, and high-performance reporting.
- Developed and maintained SSIS ETL pipelines for efficient data integration and transformation.
- Wrote and optimized SQL stored procedures for reporting, automation, and backend processing.
- Integrated Power BI with multiple data sources including SQL Server and Excel to enable unified analytics.
- Improved performance of reporting and ETL workflows, enhancing scalability and reducing processing time.
- Troubleshot and resolved data, refresh, and performance issues across Power BI, SSIS, and SQL environments.
- Enhanced existing report templates, improving usability and reducing manual effort for end users.
- Managed multiple concurrent projects, consistently meeting deadlines and delivering high-quality outputs.
- Ensured compliance with data privacy standards and industry regulations in all reporting solutions.
- Identified reporting workflow inefficiencies and implemented improvements, reducing errors and increasing data accuracy.
- Balanced multiple simultaneous projects while maintaining strict deadlines and consistently delivering high-quality work products.
- Optimized existing report templates for improved readability, reducing manual intervention required by end users.
- Participated in regular meetings with stakeholders to present findings and discuss potential improvements for upcoming report iterations.
Senior Database Developer
Charles Schwab
Denver, CO
03.2022 - 01.2024
- Optimized existing queries and provide recommendations and development for database architecture.
- Audited existing databases, identifying opportunities for improvement and recommending actionable steps for optimization.
- Reduced server load by implementing partitioning strategies that optimized storage allocation and resource usage.
- Built databases and table structures for web applications.
- Developed efficient data migration processes for seamless integration of new systems.
- Performed extensive, in-depth optimization of SQL queries, stored procedures and views to improve performance, scalability and execution time.
- Wrote new queries to support enhancements for new and existing Java applications.
- Designed and built the financial reporting data warehouse to support the on-demand reporting system.
- Partnered with the Java team to design and develop a robust ETL process for data integration, transformation and reporting.
- Resolved SQL issues and provided technical guidance to strengthen team SQL development capabilities.
- Automated database functionality by implementing C# solutions to generate ad-hoc reports.
- Troubleshot SQL Server issues by auditing traffic and utilizing tools such as Query Store.
- Updated Java applications to support new functionality and system enhancements.
- Streamlined data processing workflows, reducing system bottlenecks and improving overall efficiency.
- Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
- Managed identification, protection and use of data assets.
- Established and secured enterprise-wide data analytics structures.
- Created technical documentation for database technologies, providing updates.
- Optimized hardware resources by utilizing innovative caching techniques that minimized response times during peak usage periods.
- Created and updated database designs and data models.
- Developed scripts and processes for data integration and maintenance.
- Gathered, defined and refined requirements, led project design and oversaw implementation.
SQL Consultant (Temporary)
CVS
Woonsocket, RI
04.2021 - 02.2022
- Recruited to provide data and back-end programming services to clients for specified project.
- Develop new SQL and SSIS projects as well as update existing projects.
- Convert existing T-SQL projects to Hadoop.
- Configure existing projects to work seamlessly with automation tools such as Tidal.
- Build or modify new data reports utilizing Excel and VBA script.
- Create project documentation and give updates as needed for any required meetings.
- Work in unison with different technical teams to facilitate successful project outcomes.
- Collaborated with cross-functional teams to successfully deliver comprehensive solutions for clients.
Dashboard Data Developer
Tsunami Tsolutions
Glastonbury, Connecticut
04.2020 - 04.2021
- Delivered and deployed reporting solutions across multiple projects, meeting diverse business requirements.
- Developed Java-based data applications to parse and process large XML datasets for ingestion into target platforms.
- Enhanced existing client applications by implementing new features and improving functionality using Java.
- Collected, cleansed, and integrated data from multiple sources to support accurate and reliable reporting.
- Modified complex PL/SQL materialized views to support new and evolving reporting needs.
- Strengthened application security by mitigating XSS vulnerabilities and validating fixes using tools like Acunetix.
- Designed and created PL/SQL table structures and scripts to support new and updated reporting solutions.
- Updated and maintained web-based reporting applications to incorporate new fields and functionality.
- Authored and maintained technical documentation to improve team workflows and knowledge sharing.
- Collaborated with cross-functional teams to perform testing and quality assurance for reporting deliverables.
- Supported business intelligence initiatives by delivering customized, stakeholder-focused reporting solutions.
SQL Consultant (Temporary)
Town Fair Tire
East Haven, CT
04.2019 - 01.2020
- Architected and implemented a scalable data architecture to support enterprise A.I. and reporting initiatives, establishing a robust foundation for advanced analytics.
- Designed and developed a sales data warehouse, significantly improving reporting efficiency and simplifying data management across business units.
- Engineered and optimized stored procedures, reducing execution time and improving overall database performance under high-load conditions.
- Developed a data communication and SMS application using C#, APIs, and JSON, enabling real-time data-driven notifications.
- Re-engineered legacy reporting data processes, improving query performance and reducing report generation latency.
- Automated critical data workflows using SSIS and C#, ensuring consistent data delivery, validation, and cleansing.
- Executed large-scale data migration from legacy SQL environments to modern infrastructure using ETL pipelines and advanced SQL scripting.
- Built interactive dashboards in Qlik Sense to provide actionable insights into regional sales performance.
- Administered database systems, including backup strategies, performance tuning, IO/CPU monitoring, and query optimization.
- Led and coordinated offshore consultant teams, ensuring timely delivery of project milestones and alignment with business objectives.
- Managed and mentored college interns on a MongoDB initiative, improving performance and scalability of next-generation data solutions.
- Established and maintained strategic partnerships with hardware/software vendors and consulting firms to support evolving technology needs.
- Evaluated emerging technologies at industry trade shows to identify opportunities for improving data processing efficiency and reporting capabilities.
Database Engineer/SQL Programmer
Powwr
Newtown, CT
11.2017 - 02.2019
- Architected and delivered database solutions on Microsoft SQL Server (T-SQL) for a critical reporting infrastructure, ensuring high data integrity, availability, and performance.
- Led end-to-end design and development of complex data pipelines and reporting solutions using SSIS, C#, SQL Server (T-SQL), and Tableau, aligned to client-specific requirements.
- Designed and implemented a scalable data warehouse on MSSQL to manage historical reporting data and maintain accurate current-state records.
- Developed a T-SQL–based anomaly detection framework to proactively identify data inconsistencies and trigger stakeholder alerts prior to ingestion.
- Built and deployed a linear regression forecasting model in Python (Jupyter), replacing manual processes with a repeatable, data-driven solution.
- Engineered automated Excel reporting integrations using VBA, enabling seamless data refresh from Google Cloud and AWS data sources.
- Directed database performance and reliability efforts, including backup strategy, query optimization, schema design, and system-level monitoring (IO, CPU, query execution).
- Spearheaded an AI data initiative to enhance forecasting accuracy through advanced analytics and model development.
- Recruited, trained, and managed UConn interns to support data modeling and algorithm training, accelerating project delivery timelines.
SQL Developer–Consulting
Charter Communications (Temporary)
Stamford, Connecticut
05.2017 - 08.2017
- Write SQL reports and design automations in TOAD to service company wide departments. Create extensive documentation for existing processes including data dictionaries and report automation processes.
- Created complex chart and graph reports at the request of stakeholders, from both Excel spreadsheets and SQL.
- Created automated ETL pipelines and scheduled nightly reporting processes in TOAD.
- Revised SQL generated from MicroStrategy to design and automate new reports from the Teradata Warehouse.
Senior Report Writer–Consulting
Newman’s Own Inc. (Temporary)
Westport, Connecticut
04.2016 - 11.2016
- Recruited to complete day to day financial reporting tasks, that require SQL Server Queries, Crystal Reports, VBA and Bi360. Direct interaction with department heads and staff to gather requirements for deliverables.
- Quickly adapted to the Bi360 reporting platform to build complex multi-level financial and supply shipment reports.
- Assessed and proposed new more efficient design of current stored procedure library and the product financials and sells data warehouse.
Database Programmer
Ion Bank
Naugatuck, Connecticut
01.2015 - 02.2016
- Served as lead database engineer, owning delivery of SSRS/SSIS and database development initiatives while providing oversight for .NET application projects.
- Defined project scope, gathered requirements, and produced technical documentation; collaborated cross-functionally to resolve data integration and reporting issues.
- Developed automation solutions that eliminated manual processing, including scripting for Excel data cleanup and report standardization.
- Designed and optimized SQL Server views and indexing strategies to improve query performance, data access efficiency, and security.
- Engineered OLTP database architectures and applications using advanced T-SQL (stored procedures, triggers) and SSIS to automate ETL workflows.
- Migrated banking data and systems from Oracle to Microsoft SQL Server, ensuring data integrity, minimal downtime, and seamless transition of reporting processes.
- Built custom C# tools to streamline Active Directory administrative tasks and support internal application development.
- Managed offshore consulting resources, ensuring timely delivery and adherence to project milestones.
- Developed Crystal Reports templates for a new banking vendor, enabling automated processing of payment workflows.
Education
Master of Business Administration - Corporate Finance
Sacred Heart University
Fairfield, CTMaster of Science - Management Information Systems
Sacred Heart University
Fairfield, CTSkills
SSIS (SQL Server Integration Services) SSAS (SQL Server Analysis Services) Tableau MicroStrategy Jupyter QLIK Power BI
Advanced SQL
Data integration techniques
Data analysis proficiency
Agile development
Data warehousing
ADDITIONAL RELEVANT EXPERIENCE
- At DeVry University
- Adjunct Professor
AREAS OF EXPERTISE
Strategic Business Process Evaluation | Project Management Methodologies | Business Requirements | Documents (BRDs) | Data Scrubbing/ETL Scripting | Business Intelligence (BI) & Reporting Analysis | Data/Analytics Visualization & Modeling | Ad Hoc Report Generation & Presentation | Team Building/Leadership/Mentoring | Data Warehouse Development
Timeline
Report Developer
Step Up For Students
04.2024 - Current
Senior Database Developer
Charles Schwab
03.2022 - 01.2024
SQL Consultant (Temporary)
CVS
04.2021 - 02.2022
Dashboard Data Developer
Tsunami Tsolutions
04.2020 - 04.2021
SQL Consultant (Temporary)
Town Fair Tire
04.2019 - 01.2020
Database Engineer/SQL Programmer
Powwr
11.2017 - 02.2019
SQL Developer–Consulting
Charter Communications (Temporary)
05.2017 - 08.2017
Senior Report Writer–Consulting
Newman’s Own Inc. (Temporary)
04.2016 - 11.2016
Database Programmer
Ion Bank
01.2015 - 02.2016
Master of Science - Management Information Systems
Sacred Heart University
Master of Business Administration - Corporate Finance
Sacred Heart University