Ronald Eddy
SQL Developer
BEDFORD,NS
Summary
Results-driven SQL Developer with a proven track record at Imarketing Solutions Group, specializing in ETL development and query optimization. Enhanced database performance through rigorous data validation and indexing strategies, while fostering collaboration with stakeholders to deliver high-quality reporting solutions. Adept at troubleshooting and providing technical support, ensuring user satisfaction and operational efficiency.
Overview
19
19
years of professional experience
1
1
Language
Work History
SQL Developer
Imarketing Solutions Group
01.2016 - Current
- Extensive use of SSIS to both import and export data from multiple sources and file formats supporting over 100 individual clients needs and requirements.
- Reviewing data from multiple sources and in variety of formats to best design SSIS package and underlying tables / stored procedures to ensure data quality, accuracy and correct formatting.
- Maintaining SQL job scheduling to run a variety of database tasks to minimize conflicts across thousands of stored procedures, SSIS package imports / exports and external applications.
- Data modeling to ensure normalization, data formats, correct indexing, and performance
- Enhanced database performance by optimizing SQL queries and indexing strategies.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Maintained high-quality code standards through rigorous testing and peer code reviews, minimizing potential bugs and security vulnerabilities.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Provided technical support for end-users by addressing SQL-related issues, enhancing overall user satisfaction with the application.
- Developed custom database objects, stored procedures, and delivered application support.
- Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.
- Supported projects enabling delivery efficiencies and technical resolution.
- Conducted comprehensive performance tuning efforts, identifying bottlenecks and implementing optimizations to improve overall system responsiveness.
Reporting Analyst
EastLink Communications
06.2006 - 01.2016
- Prepared monthly ad hoc reporting in alignment with client needs.
- Utilized in-depth analysis and creative problem solving to troubleshoot reporting issues.
- Worked with business unit managers to provide quick resolution for submittal to client.
- Managed commissions application for front line agents, supporting multiple different commission plans and metrics
- Created visually appealing dashboards that effectively communicated key metrics to stakeholders.
- Maintained ongoing schedule and documentation for all reporting procedures.
- Developed custom reports to address specific business needs and support decision-making processes.
- Increased efficiency of existing processes by identifying areas of improvement during routine report reviews.
- Served as a subject matter expert in data analysis, providing guidance and support to colleagues when needed.
- Developed auditing systems around employee reported sales to actual sales within POS applications resulting in savings to company both monetarily and dramatic time savings for management
- Extensive use of excel along with VBA to webhook and update applications that could not be updated directly on a database.
Education
SQL Server Integration Services For BI (SSIS) - Information Technology
Learning Tree International
Toronto, ON 05.2001 -
SQL Server Analysis Services For BI (SSAS) - Information Technology
Learning Tree International
Toronto, ON 05.2001 -
Developing SQL Queries For SQL Server - Information Technology
Learning Tree International
Toronto, ON 05.2001 -
Microsoft Access Levels 1 - 3 - Information Technology
Dalhousie University School Of Continued Learning
Halifax, NS 05.2001 -
Computer Service Technician Diploma - Information Technology
Nova Scotia Community College
Halifax, NS 05.2001 -
Skills
SQL development
SQL analytics
Advanced SQL queries
Stored procedures
ETL development
Data validation
Data extracting
Database design
Query optimization
T-SQL coding
Data migration
Indexing strategies
Timeline
SQL Developer
Imarketing Solutions Group
01.2016 - Current
Reporting Analyst
EastLink Communications
06.2006 - 01.2016
SQL Server Integration Services For BI (SSIS) - Information Technology
Learning Tree International
05.2001 -
SQL Server Analysis Services For BI (SSAS) - Information Technology
Learning Tree International
05.2001 -
Developing SQL Queries For SQL Server - Information Technology
Learning Tree International
05.2001 -
Microsoft Access Levels 1 - 3 - Information Technology
Dalhousie University School Of Continued Learning
05.2001 -
Computer Service Technician Diploma - Information Technology
Nova Scotia Community College
05.2001 -