Modify and manage Azure Data Factory pipelines. Work with Azure storage explorer. Create MS Access applications to generate, store and email complex visual reports to clients using VBA scripting. Create automation using Power Automate working with email, file storage, SharePoint list data comparisons, notifications, excel & more. Create report visualization using Power BI with connections to SQL, SharePoint lists and excel. Run daily reports using Azure storage explorer, Azure pipelines, SQL procedures, excel templates and PowerShell scripts. Perform data analysis, cleanup, mapping, and import. Train staff in system operations and create user manuals.

Develop applications in Alteryx, MS Access and SQL to help process various file formats for import. Responsible for maintaining its integrity, including performance tuning and monitoring, backup, and recovery and troubleshooting as well as adding new customers. Create training documentation, provide training and technical support for all users. Translate business requirements, forms and reports into database objects and processes. Develop Power BI reports and dashboards for tracking applications. Develop and maintain SharePoint sites and content. Work with Azure DevOps. Work in an Agile environment.

Database Analyst / Developer – Office 365 / Teams / Power BI Reporting / Power Automate / Power Apps / Raiser's Edge NXT / MS Access 2013 Database / MS Excel 2013 Applications Create Raiser’s Edge batch templates, IOM import structures, Global changes, Admin and NetCommunity portal, Configurations, Dashboards and Mail portals.Create queries and reports using MS Access, Power BI, SQL and Raiser’s Edge query platform. Create database objects such as tables, queries, views, jobs, procedures, forms, macros, modules, reports, fields, record types, page layouts and validations using MS Access, Raiser’s Edge and Salesforce platforms. Develop, enhance and support over 15 databases/business applications with over 70 users. Manage over 300K records, over 300 tables/queries and over 200 reports/charts.Confirms project constraints by studying user requirements within the project team.Manage data integrity, extraction, analysis and performance enhancements. Input automation using scripting languages (VBA/SQL). Create audit and archiving modules. Import and Export datasets using Excel/CSV spreadsheets. Protects database by developing access system; specifying user level of access. Maintains user reference by writing and rewriting database descriptions. Perform data updates, cleanup, mapping, import, and troubleshooting system bugs.

Database Management/ Development - MS Access/SQL Develop, enhance and support over 13 databases/business applications with multiple users. Manage over 400K records, over 200 tables/queries and over 100 reports/charts. Confirms project constraints by studying user requirements within the project team. Manage data integrity, extraction, analysis and performance enhancements. Create database objects such as tables, queries, views, jobs, procedures, macros, modules and reports. Input automation using scripting languages (VBA/SQL). Create audit and archiving modules. Import and Export datasets using Excel/CSV spreadsheets. Connect local database interfaces to separate network back end tables through external links/ODBC. Determines and make changes in physical database structures (characteristics, location, storage, and access method). Secures databases by developing a proper access system; specifying user level of access. Maintains user reference by writing and rewriting database descriptions. Perform data updates, cleanup, mapping, import, and troubleshooting system bugs.

Database Management – SQL Server/iMIS 10 DatabaseManage 5 different databases with 30-50 users, over 600K records, over 300 tables and views.Manage data integrity, extraction, analysis and performance enhancements. Create database objects such as tables, queries, views, jobs, procedures and reports. Generate detailed queries using SQL Server 2008 Management Studio. Perform data updates, cleanup, mapping, import, and troubleshooting system bugs.

Database Development - Publishing Rights Clearance Master DatabaseCreated MS Access Database to use in the legal department to track book publishing rights. Created database objects such as tables, queries, reports, forms, modules, and macros. Configured more complex queries using SQL view. Converted database to a shared application; split system tables and uploaded to server. Performed data cleanup, analysis, mapping and import. Trained department staff on system operations and created user manual.

Provided support and maintenance of departmental desktop PCs/laptops hardware, and system applications. Performed system backups on external hard drives and web-based backups. Responsible for creating, programming and managing 5 different content management websites. Maintained the user accounts, passwords and data integrity for all 5 systems. Designed and developed CMS web pages using script templates based in HTML, XHTML, CSS, JavaScript and PHP. Created and managed an Access database. Managed a MemEx (FoxPro) system and edited SharePoint client pages. Managed the database systems for 5 non-profit organizations (NYSAE, WX, 7x24, AREW, and MetFDA)Accomplishments: Improved the production time from 2 weeks to 3 days for the online monthly magazine. Maintained impeccable data records of users and members, which improved web-marketing e-blast delivery rates from over 1500 errors to less than 30 errors for the data load.

Provided support and maintenance of departmental desktop PCs/laptops hardware, and system applications. Managed data integrity, and accessibility of multiple database systems. Created database training procedures. Assisted in the configuration, design and implementation of Interwoven and InfoEd web-based applications. Imported and Exported datasets using Excel spreadsheets and Access tables. Created profiles, logins, roles and set user permissions for over 1000 users. Managed data clean-up/conversion and validation for over 80,000 records. Accomplishments: Improved database configurations that allowed the department to evolve in their business processes enabling the staff to track projects more efficiently and maintain over 95% accuracy with their data records. Implemented and developed an electronic filing system that eliminated file lost and produced more efficient archiving saving the company money on storage space.