GARSAN SolutionsSoftware Engineer
Jun. 2019 - May. 2021Columbus, Ohio AreaFull-Stack Development
- Use of .NET framework, React, Redux, Java, Angular, C#, HTML, TypeScript, JavaScript, and CSS to develop and modify elements of a government-owned commerce website
- Integration of SQL Server databases to hold and call data to front end elements and REST API development
- Development of ETL processes to move data between databases
- Integration with Microsoft Azure, Azure web hosting, and Azure machine learning Database Administration
- Performance tuning, query optimization, and index optimization to improve SQL Server performance and reduce computational costs
- Maintained more than twenty databases across multiple servers
- Implemented database mirroring and availability groups to avoid unexpected data loss
- Used DynamicsPerf performance analyzer to seek out expensive queries ETL Development/Datawarehousing
- Worked with SQL Server Integration Services to perform ETL processes
- Created ETL packages for full data loads and incremental data loads
- Utilized different SSIS design patterns such as IUD and CDC incremental loading
- Updated SQL jobs in order to capture data changes and import to the data warehouse AX Development
- Redesigned data cleanup processes to eliminate database deadlocking
- Generated forms and reports using existing tables and custom batch jobs Business Intelligence Development
- Developed innovative reports to deliver to external users for analytical purposes
- Designed reports using SSRS and MDX queries - Created PowerBI KPIs to broadcast performance metrics to the business Poweshell Development
- Designed Powershell scripts around monthly maintenance processes that reduced the expected maintenance time by 50% Machine Learning
- Developed machine learning models using various, common ML algorithms in order to predict business metrics and categorize existing data captured by the business
- Combined machine learning with linear programming to assign optimal quantities to available business locations