Bridget Wagner
Senior SQL Developer - |-| linkedin.com/in/bbwagner
Summary
Senior Database Developer with over 18 years of hands-on experience in SQL development, data integration, reporting, and ERP system implementation. Proven success across industries including construction, healthcare, entertainment, and finance. Adept at delivering scalable data solutions using tools like SSMS, SSIS, SSRS, and Crystal Reports. Committed to improving business operations through efficient, secure, and reliable database systems. Experienced in data integration specifically within the Vista by Viewpoint ERP platform.
Technical Skills
Languages & Tools: T-SQL, SSMS, SSIS, SSRS, Crystal Reports, TimeXtender
ERP Platforms: Vista by Viewpoint, SAP Business One, Dynamics AX 3.0, Facets
Expertise: Data Modeling, Performance Tuning, Data Migration, Reporting, Integration
Professional Experience
SQL Developer | Wagner Database Solutions LLC – Remote
May 2024 – Present
- Develop and maintain custom reports and dashboards for clients.
- Create complex stored procedures, triggers, functions, and views for database development.
- Generate datasets using custom T-SQL.
- Gather requirement specifications through client collaboration.
- Implement and maintain formal SQL coding processes, documentation, and standards.
- Administer and support Vista by Viewpoint ERP systems and reporting via Crystal Reports and SSRS.
- Performed advanced data integration within Vista by Viewpoint to streamline cross-system operations.
- Integrated third-party systems with Vista by Viewpoint to automate reporting workflows and improve data accuracy.
Business Systems Developer | Peak Utility Services Group – Remote
Dec 2021 – May 2024
- Integrated two HRIS systems into ERP, saving HR and payroll teams 20+ hours weekly.
- Managed and optimized Vista by Viewpoint ERP system, including upgrades, troubleshooting, and application design.
- Reduced nightly data warehouse processing by 8 hours via TimeXtender optimization.
- Analyzed and enhanced SQL query performance, achieving up to 40% improvement.
- Designed and implemented data migration strategies for cross-platform systems.
- Executed data integration initiatives directly on Vista by Viewpoint ERP to enhance process efficiency.
- Coordinated cross-functional data exchange between Vista and payroll/HR systems to support operational reporting.
SQL Development Consultant | Business Information Group – Remote
Jan 2019 – Dec 2021
- Provided tailored SQL development solutions to clients in the Construction industry.
- Modified, reported, and administered Vista by Viewpoint ERP system.
- Developed complex stored procedures, triggers, SSRS, and Crystal Reports.
- Managed third-party data transformation using SSIS and SQL Jobs.
- Built ETL pipelines between external systems and Vista to facilitate accurate business intelligence reporting.
SQL Database Developer | Wagner Consulting, LLC – Remote
May 2008 – Jan 2019
- Designed and developed complex SQL procedures, queries, and reports.
- Utilized SSMS, Crystal Reports, and SSRS for robust database solutions.
- Implemented data integration strategies within Vista by Viewpoint to unify client reporting environments.
- Collaborated with IT and users to support wide-ranging database needs.
- Supported ERP systems including Vista by Viewpoint, SAP B1, Facets.
Report Developer III | Sole Technology, Inc – Lake Forest, CA
Dec 2005 – May 2008
- Designed and maintained enterprise reporting structure using Crystal Reports XI.
- Captured requirements and created reports for Dynamics AX 3.0.
- Defined metrics to validate data consistency and report integrity.
- Integrated reports into portal using Business Objects Enterprise Server.
Education
A.S. Computer Science (Expected 2026) | Southern New Hampshire University – Manchester, NH
Business Administration | Orange Coast College – Costa Mesa, CA -)
General Education | Fullerton College – Fullerton, CA -)
Certification Courses
New Horizons – Anaheim, CA -)
- Mastering Enterprise Development Using MS Visual Basic 6
- Mastering MS Visual Basic 6 Development
- Implementing a Database on MS SQL Server 7.0
- Mastering Distributed Applications Design Using MS Visual Studio
- System Administration for MS SQL Server 7.0
- MS Windows 2000 Network & Operating System Essentials
- Implementing MS Windows 2000 Professional & Server
- Advanced Access, Excel, Crystal Reports (w/ SQL)