Architect and principle engineer converting Access database project into ASP.NET website utilizing C#, SQL Server, jQuery and Ajax, and SSRS.

• Developed an internal tools website that streamlined reporting processes and improved team efficiency by implementing user hierarchy ETL, subscription, and requirements functions.• Collaborated with top leading entities in the healthcare and job training sectors to create a cross-company reporting website to display data based on selected criteria, demonstrating excellent collaboration and communication skills.• Led the development of an internal data-driven website for a client using ASP.NET MVC pattern that improved communication and data sharing between locations, showcasing exceptional project management and technical skills.• Designed, developed, and managed a team to fully execute a comprehensive online WelfareToWork program, integrating popular tools such as DocuSign, Zoom, Teams, Olark, and DropZone to create a user-friendly and secure environment for state workers.

• Researched and implemented relational database services and AWS to enhance reporting efficiency, reduce costs, and optimize data extraction.• Developed a flexible and scalable ETL backend utilizing AWS services (Amazon S3 and Redshift) and created a suite of functions for extensibility.• Created a user-friendly MVC-based UI for managing ETL tool history and editing program/application settings.• Supported end users in utilizing the ETL tool effectively and meeting customer requirements.• Debugged and optimized complex data warehouse processes, handling tables and cubes with over 500 million records and a billion weekly transactions.• Successfully delivered data load, processing, and reporting for multiple concurrent projects under tight deadlines and SLAs.• Developed custom applications, tools, and interfaces to increase efficiency, productivity, and seamless integration with vendor applications/services.• Conducted comprehensive data analysis, including client, group, and member-level activity, history, and trend analysis.• Utilized SQL for ad hoc investigations and troubleshooting system and application issues.• Developed and debugged stored procedures, triggers, DTS and SSIS packages, and code in SQL, VBA, VBScript, VB.NET, and C#.• Actively participated in peer code reviews to ensure the deployment of high-quality code into production environments.

• ETL Developer utilizing MS Access leveraging VBA code• Developed solutions in MS Access for complicated and recurring campaigns leveraging macros,forms, reports and VBA code• Migrated unsupported legacy applications running on obsolete equipment and converted tomodern systems• Developed a data processing template to standardize and automate the ETL process• Maintained ISO Document Control, processed change requests and facilitated in the revision ofoutdated documents and forms