Nancy A. Scalzitti

**** ******* ****** - #**

Saint John, Indiana 46373

ad4cgl@r.postjobfree.com

219-***-****

https://www.linkedin.com/in/nancy-scalzitti

Summary

Practical experience coding, testing, analyzing, optimizing, and supporting Microsoft Power BI stack (SSMS, SSIS, SSAS, SSRS, Power BI) including SQL Server stored procedures, views, tables, table indices, ETL (SSIS) packages, and both Power BI and SSRS reports

Proficient at learning new concepts quickly, working well under pressure, and communicating ideas clearly and effectively

Skills: Data Analysis, T-SQL, Analyzing and Optimizing SQL Queries and Views, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), Visual Studio, TFS (Team Foundation Server), SQL Server Integration Services packages (SSIS), SQL Server Business Intelligence (BI), SQL Server Analysis Services (SSAS), Power BI, MSACCESS, VBA, MS Office Suite (Access, Excel, Project, Visio), ColdFusion, HTML, CSS, Java, VB.Net, Project Management, Agile, SDLC, Business Continuity, Risk Management, Change Control, Strong business understanding

Career History & Accomplishments

Senior BI Developer, 2021 – 2023

Infosync Services, Wichita, Kansas (Remote)

Designed, developed, tested, and deployed Power BI reports and dashboards to meet client needs.

Designed, developed, tested, and deployed MS SQL Server Analysis Services (SSAS) tabular and multi-dimensional data models.

Analyzed and researched data integrity issues within an existing data warehouse.

Designed, developed, tested, and deployed ETL solutions and packages in Visual Studio for existing and new data models.

SQL Server Database Developer, 2018 – 2019

LHI - Logistics Health Incorporated, La Crosse WI (UHG - United Healthcare Group) (Remote)

Designed, created, and tested numerous T-SQL stored procedures in an enterprise level environment in the healthcare industry using the full SDLC (System Development Life Cycle).

Designed, created, and tested a variety of SSRS Reports in SSMS, Visual Studio and TFS (Team Foundation Server) related to military healthcare contracts.

Extensively researched data relationships and developed a “Leadership Productivity Report” to enable all levels of management to track and review their actual business process times and staff productivity, readjust their business targets, and improve productivity overall.

SQL Server Database Consultant, 2013 – 2018

Various Contracts including Robert Half, Chicago, IL

Designed, created, and tested SQL Server database objects including tables, stored procedures, views, SSRS reports, and ETL (SSIS) processes for client projects.

Created new custom reports and applied requested changes to existing custom SSRS Report Builder reports for a Made2Manage ERP system.

Designed, created, and tested many SSIS objects that extract data from various data sources into SQL Server databases.

Migrated and normalized backend data and table objects from MS Access to SQL Server.

Master of Science - Information Systems, “with Distinction", GPA: 4.0/4.0, 2010 - 2012

DePaul University, Chicago, IL

Included 6 months hands-on SQL Server experience covering SQL Server architecture; installation and configuration; database management; security; backup and recovery; SQL Server development (SSRS, SSIS, BI, SSAS); Cube and dimensions development; and integration with MS Excel.

SQL Server Database Administration (DBA) Program: A 3 month in-depth program covering database administration using Microsoft SQL Server. Topics included SQL Server architecture; installation and configuration; database management; SQL Server Management Studio; security; spatial data; backup and recovery; performance tuning; and database high availability options.

SQL Server Business Intelligence (BI) Program: A 3 month in-depth program covering how to build BI solutions using analysis services (SSAS) with real-time analytics, integration services (SSIS), data mining, reporting services (SSRS), Key Performance Indicators, cube and dimensions development and integration with the Microsoft Office system.

Data Warehousing: Designed, created, tested, and loaded test data into a fully functional, detailed data cube in SSAS during a 3 month graduate student project under the direction of a Microsoft guest lecturer.

Upsilon Pi Epsilon (UPE) National Honor Society

Top 5% of graduates in Computing & Information Disciplines

Senior MIS Specialist, 1998 - 2005

Federal Reserve Bank of Chicago, Chicago IL

Designed, developed, tested, implemented, analyzed and optimized SQL Server stored procedures, views, ETL (SSIS) packages, and Report Services (SSRS) as well as ColdFusion and MSACCESS front-ends.

Developed a more efficient reporting tool by eliminating a Visual Basic piece and rewriting related reports directly on SQL Server. The required Excel reports ran in 20 minutes (instead of 14 hours) and eliminated the prior contingency with live production transaction data.

Participated in both Agile and full SDLC development projects as well as provided ongoing support for numerous applications in the Seventh District for various departments including Accounts Payable, Payroll, Human Resources, Billing, and Building Services using technical, business and leadership skills.

Received numerous bonuses and cash awards including an “Outstanding Performance Award (OPA)” for developing, testing, and implementing a ColdFusion/SQL Server web application for visitors to schedule tours of the Bank online.

Application Developer, 1993 – 1998

Federal Reserve Bank of Chicago, Chicago IL

Developed and supported various client server applications for Financial Services group including Lawson ERP Financials system and related MS Access reporting applications.

Participated on a team that researched, requested RFIs, reviewed, vetted RFPs, selected, and installed a new client server Lawson ERP Financial System that replaced a mainframe Walker Accounting system.

Received a cash bonus from the Financial Services manager for creating a quick work around to manually capture Accounts Payable check data from the Lawson (Oracle) database, manipulate the data, and send it directly to the check printer. The daily checks were successfully printed by the deadline during a system outage.

Contact this candidate