Beth Munn Email & Phone Number

Springfield, Il, Us

Springfield, Il, Us

• Primarily responsible for developing and extracting data from Microsoft SQL Server databases for state health programs, providing daily operational support and database enhancements in software release cycles. • Create SQL Server database objects including stored procedures, tables, indexes, functions, views • Develop customized reports using TSQL for customers• Write and alter complex stored procedures including window functions, defining parameters, loops, error… Show more • Primarily responsible for developing and extracting data from Microsoft SQL Server databases for state health programs, providing daily operational support and database enhancements in software release cycles. • Create SQL Server database objects including stored procedures, tables, indexes, functions, views • Develop customized reports using TSQL for customers• Write and alter complex stored procedures including window functions, defining parameters, loops, error handling• Optimize stored procedures by analyzing execution plans, adding indexes, writing more efficient T-SQL, add error handling • Manage, deploy SSRS reports with Visual Studio and Report Builder• Create and manage ETL process to external data warehouse using JSON extracts • Create MS Power BI reports using normalized datasets • Leverage SQL Server Replication to sync multiple databases• Deploy production database changes with new software versions; refresh UAT and TEST databases for next software version• Manage database source code in TFS / DevOps using Visual Studio and feature branches• Create/maintain SQL jobs to monitor database performance and maintenance tasks• Maintained and managed backup, recovery, storage and user administration.• Develop technical documentation such as data dictionaries, entity relationship diagrams• Develop customized reports in Excel• Create file extracts using XML, JSON, fixed length files, csv, more• Establish, manage SFTP connections to exchange files with partner systems• Resolve interface errors in data exchanges with partner information systems• Involved in requirements gathering and participate in all phases of development life cycle (Scrum/Agile) Show less

Olympia, Washington

• Involved in requirements gathering and participated in all phases of development life cycle.• Created stored procedures, triggers, user defined functions, views, indexes etc.• Exported reports to different format as (Excel, word, PDF, database, RTF, text, and CSV). • Understand, evaluate and implement tools and trends in database systems administration.• Maintain and manage backup, recovery, storage and user administration.• Assist and support in production installations… Show more • Involved in requirements gathering and participated in all phases of development life cycle.• Created stored procedures, triggers, user defined functions, views, indexes etc.• Exported reports to different format as (Excel, word, PDF, database, RTF, text, and CSV). • Understand, evaluate and implement tools and trends in database systems administration.• Maintain and manage backup, recovery, storage and user administration.• Assist and support in production installations of various ASA releases.• Managed over 100 replicating databases through Sybase replication• Involved in preparing and updating databases for application development and QA/UAT teams. Show less