Yogendra Adhikari
MSc | Data Scientist | Application Developer at Blue Earth County MN
- Role
- Application Developer at Blue Earth County
- Location
- Minneapolis, MN, US
- LinkedIn followers
- 500 followers
About Yogendra Adhikari
Experienced Application Developer and Business Analyst with a strong background in data…
Experience
Application Developer
Oct 2022 — Present · Mankato, MN, US
Re-engineered a failing payroll web application (C#.NET MVC), reducing data load times from 7 minutes to under a minute by developing and using a background ETL process.•Developed a robust stored procedure that manages SQL Server job execution and built an error detection system for real-time tracking of ETL job executions from the SSIS catalog.•Reduced ETL run time from 30 minutes to 2 minutes by re-engineering SSIS ETL processes for daily and monthly data retrieval from the State’s data warehouse to extract only necessary tables, incrementally updating larger tables.•Developed a C# Class Library using Visual Studio to integrate an internal web application with SharePoint, leveraging Microsoft Graph API to manage API permissions, enabling the C# library to add, delete, and list existing files in the SharePoint Document Library.•Published internal C# library as a NuGet package on GitHub after conducting thorough testing with.NET Console and Web applications for re-usability and demonstrated steps to use it.•Developed a Power BI dashboard for tracking SQL Server usage and identifying frequently used SQL objects, using SSIS ETL to collect daily DMV data and Python scripts to extract table names from SQL texts and Query Plans.•Led the County\'s transition to GitHub version control by organizing regular demo sessions and DevOps meetings, training developers on Git commands, pull requests, and repository management.•Reduced 70% of frequent errors and improved efficiency in SQL Server Agent job executions by leading the migration of ETL projects from network drives to the SSIS catalog.•Co-authored the organization\'s first AI policy as part of the AI team and ethics committee, simplifying complex AI concepts for senior stakeholders and establishing ethical guidelines for responsible AI use
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.