Catherine Weber Email and Phone Number

• Participated in Infor LN ERP system upgrades that included several phases of development and testing. Project included working with key stakeholders to design new ERP system architecture, relocate/upgrade database to new server, upgrade SSIS packages and upgrade SSRS.• Designed and developed SSIS packages and SQL Server stored procedures used in the automation of file loading to different ERP systems. This included working with financial institutions to set up SFTP connections and create… Show more • Participated in Infor LN ERP system upgrades that included several phases of development and testing. Project included working with key stakeholders to design new ERP system architecture, relocate/upgrade database to new server, upgrade SSIS packages and upgrade SSRS.• Designed and developed SSIS packages and SQL Server stored procedures used in the automation of file loading to different ERP systems. This included working with financial institutions to set up SFTP connections and create SSIS packages that encrypt/decrypt financial documents for month-end processing. • Worked with third-party vendors on access to data to integrate into various reports. This included installation of connectors, providers and/or gateways for downloading reports from cloud based applications. • Provided technical support to business teams by developing business intelligence solutions and assuming responsibility for physical database designs and report implementation.• Designed and developed time tracking application using WPF, C# and SQL• Developed MS Power Automate flows to interact with on-prem servers. Process included copying files between SharePoint/OneDrive and on-prem servers for processing by SSIS packages. • Developed PowerShell scripts to use in server maintenance, automation processes and SSIS packages. • DBA role to administer SQL server instances including software installation, instance configuration, database backup and recovery, security, performance tuning and SQL services support. • Trained interns on SSIS development and ETL best practices. Show less

• Responsible for all SQL Server 2005, SQL Server 2008, SQL Server 2008R2, and SQL Server 2012 instances, including configuration, security, maintenance plans, replication, scheduled jobs, SSRS, SQL Mail Agent and SSIS Packages.• Create and deploy standard SSRS report packages for client implementations of McBee products. • Create customized SSRS reports as required to satisfy client requests as well as internal McBee management requests.• Using SSIS (SQL Server Integration… Show more • Responsible for all SQL Server 2005, SQL Server 2008, SQL Server 2008R2, and SQL Server 2012 instances, including configuration, security, maintenance plans, replication, scheduled jobs, SSRS, SQL Mail Agent and SSIS Packages.• Create and deploy standard SSRS report packages for client implementations of McBee products. • Create customized SSRS reports as required to satisfy client requests as well as internal McBee management requests.• Using SSIS (SQL Server Integration Services) and ETL (Extract, Transform and Load) tools within SQL Server, created processes to populate data from a variety of sources. These data processes are then automated using scheduling tools.• Develop repeatable ETL processes for loading EDI from the Centers of Medicare and Medicaid Services for several health care clients.• Develop automated extract processes using SQL Server’s BCP (Bulk Copy Process) on client systems to extract data and FTP to McBee for loading into McBee databases• Designed and implemented processes for the use of replicated databases for disaster recovery (DR) scenarios.• Provide DBA consulting for McBee clients as needed.• Responsible for staff of programmers and business analysts including hiring, workload, training, mentoring and reviews. Show less

• Responsible for architectural design, creation, and maintenance of databases for ASP.NET web applications designed to help clients with revenue recovery, cash acceleration and appeals management. • Migration of all databases from SQL Server 2005 to SQL Server 2008R2, including SSIS packages and SSRS reports.• Responsible for creation and maintenance of database replication for SQL Server 2005 and SQL Server 2008R2 to McBee remote locations.• Automating processes of report… Show more • Responsible for architectural design, creation, and maintenance of databases for ASP.NET web applications designed to help clients with revenue recovery, cash acceleration and appeals management. • Migration of all databases from SQL Server 2005 to SQL Server 2008R2, including SSIS packages and SSRS reports.• Responsible for creation and maintenance of database replication for SQL Server 2005 and SQL Server 2008R2 to McBee remote locations.• Automating processes of report generation interfacing with SSRS subscription tool. The framework developed is now used across all company reports.• Completed installation of SAP Crystal Reports Server 2011 for a client and built custom Crystal reports against their Cerner and McKesson systems.• Provided application and data support to business users. Show less

• Migration of MS Access applications to web applications using ASP.NET and SQL Server backend.• Migration of web applications from ASP.NET 2003 to ASP.NET 2005• Automation of reusable routines using DTS for the loading and extraction of client data.• Creation of custom reports using tools including Crystal Reports, SQL Server Reporting Services and MS Access

•Implemented new features, improved functionality, and supported a graphical web-based application. This application allowed web administrators to configure and manage a Transaction Server.•Implemented, improved, and added security to various Java applications using SSL connection.•Implemented features for SOMS (Screen Object Modeling Studio) using Visual Basic 6. This application enabled web administrators to “scrape” terminal screens.

•Developed and improved PERL web-based applications for Wyeth's corporate intranet. The web applications utilized PERL/DBI to access an Oracle 8i back-end database.•Developed the HTML web pages for the front-end user interface of an application that searches the database for a specific text. Worked on-site with the end-users during the troubleshooting phase of development.•Authored technical documentation for this search tool application.