Power Bi Database Developer

PENNY VANZANDT

469-***-**** *******@*****.***

PROFESSIONAL SUMMARY

Dedicated and experienced database developer and administrator with 24 years of experience at the Social Security Agency. Proficient in SQL development, ETL processes, and creating complex SSIS packages. Strong background in report requirements gathering, complemented by familiarity with data visualization tools including Tableau and Power BI. Adept at utilizing a variety of technologies to enhance organizational effectiveness and support user needs.

PROFESSIONAL EXPERIENCE

SOCIAL SECURITY ADMINISTRATION

Database Developer & Administrator

2001 - Present

• Developed and maintained SQL databases, ensuring optimal performance and reliability.

• Authored complex SQL queries and stored procedures to support various applications and reporting needs.

• Designed and implemented ETL processes, creating multiple SSIS packages for data integration and transformation.

• Experienced in gathering user requirements to create accurate and meaningful reports, facilitating data-driven decision-making.

• Managed SharePoint Administration tasks, enhancing productivity through effective collaboration and document management.

• Utilized ASP, ColdFusion, JavaScript, InfoPath, and PowerShell to develop and maintain applications in a dynamic environment.

TECHNICAL SKILLS

Database Management: SQL Server, T-SQL, Stored Procedures, ETL, SSIS Reporting Tools: Tableau, Power BI, SSRS

Programming Languages: Classic ASP, ColdFusion, JavaScript, PowerShell, DAX, SQL Development Platforms: SQL Server Management Studio (SSMS), Visual Studio, Excel, Tableau, Power BI EDUCATION

Bachelor of Arts in Journalism

University of Minnesota & Columbia College

ADDITIONAL EXPERIENCE

Over 35 years of total work experience in the public sector, with a focus on enhancing operational efficiency and supporting community services.

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate