•   Enhanced insights and performance by developing 20+ ad-hoc dashboards / reports to support business intelligence, experimental analytics, and KPIs evaluation through the execution of complex SQL queries using CTEs, joins, and window functions.

•   Accomplished a 90% decrease in execution time by coding a VBA application to query data warehouse through ODBC drivers, extract data, and programmatically print PDFs for each record in the returned dataset, thereby automating manual processes.

•   Achieved a significant decrease of 50% in workflow compliance issues by strategically defining schemas, metadata, constraints, and table relationships, thereby enhancing ER modeling processes and facilitating the seamless integration of new workflows.

•   Devised a project plan for providing a digital window into the physical laboratory storage, resulting in seamless location tracking across 150+ cold storage units, following interviews with key business users to understand requirements.

•   Boosted user engagement by 70% by implementing Agile processes, Jira Boards, authoring user stories, and facilitating the management of the backlog of user stories for two workflows in collaboration with cross-functional teams and stakeholders.

•   Addressed the incorporation of 175+ enhancement requests and resolution of bugs by developing stored procedures, triggers, and complex SQL queries, ensuring improved functionality and backend software performance.

•   Streamlined daily processes and minimized application downtime by 20% through the creation of SQL (SSIS Scripts) jobs for database backup, enabling automation and improved efficiency.

•   Utilized PowerBI to curate interactive visualizations of ServiceNow incident data, providing valuable insights on incident resolution times, categories, and root causes contributing to a 15% improvement in the turnaround time (TAT) for bug fixes.

•   Determined business logic for 20+ product enhancement projects in an agile setting by designing and developing various abstract classes, classes and interfaces using C# on ASP.NET MVC framework, adhering to object-oriented paradigms.

•   Assumed complete ownership of application infrastructure maintenance, including backend code, servers, and databases resulting in the resolution of issues caused by UI, backend data, and code leading to over 500 incident resolutions and documentation.

•   Led end-to-end functional testing, regression testing, user acceptance testing, and successful migration of complex use cases to production for an artificial intelligence based chatbot resulting in a 90% drop in bugs encountered in the production environment.