S

Sunil Sawani

About

Detail

Michigan, United States

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • P
    Technology Director
    Polyvinyl Record Co.
    Aug 2022 - Mar 2025 (2 years 8 months)
    • Made improvements to and developed new features for Polyvinyl's homegrown web store and CMS written in Angular and NodeJS • Integrated CMS with FUGA SaaS for delivery of digital media to digital media providers via REST API • Integrated webstore with Polyvinyl's Shopify store to keep inventory in sync between stores and provide product updates from CMS to Shopify store via Shopify's GraphQL API • Optimized methods and SQL code for speed and efficiency in order to prevent data issues caused by high system usage • Performed AWS EC2/RDS management and mySQL 5.7 to 8.0 upgrade • Led decision-making efforts and discussions regarding migration from homegrown system to Shopify Plus platform for future of the business • Led ETL efforts to
  • P
    Senior .NET Developer
    PortfolioNAE
    Oct 2021 - Jul 2022 (10 months)
    • Project integrating data and applications for Portfolio acquisition of NAE • Lead developer integrating NAE's homegrown MVC e-store with Portfolio's nopCommerce driven e-store • Lead developer integrating Portfolio and NAE's separate C# MVC Pre-Paid Maintenance and Warranty Forever applications • ETL of data from NAE into Portfolio SQL Server databases • Stored procedure writing and optimization for new integrated data model
  • Tetra Tech
    Senior ASP.NET Consultant
    Tetra Tech
    Jul 2020 - Jul 2022 (2 years 1 month)
    • Industrial Health Letters Automation - Built a scheduled automated process in C# to pull data from GM's Industrial Health System and Workday and generate PDF letters to be printed and mailed. • GMR2 SSO Implementation - Implemented single sign-on (via Microsoft Azure) for existing GMR2 .NET C# application • GM Personnel Admin - Built data processors to import and transform large amounts of personnel data, a .NET Core 3.0 web application with C# backend to manage that data, and code to update the master personnel system via REST API. Provided ongoing support and upgrades to this system over the course of 2 years. • SCIP Tool - .NET desktop application in C# to generate i6z file from Excel data for submission to ECHA • Genessee County
  • Trillium Health Resources
    Senior .NET Consultant
    Trillium Health Resources
    Mar 2020 - Jun 2020 (4 months)
    • Developed the Denials and Appeals module of the Trillium Business Systems web application, working on an Agile team through six two-week sprints • Built new .NET Core Razor pages and controls using Entity Framework and Kendo UI. • Created Razor-based letter templates used in the processing of insurance claims. • Built Azure CI/CD pipeline for dev deployments, as team transitioned to Azure from TFS for devops.
  • Universal Logistics Holdings, Inc.
    Senior Application Developer
    Universal Logistics Holdings, Inc.
    Nov 2015 - Mar 2020 (4 years 5 months)
    • Created Xamarin Forms (C#/.NET) inventory tracking system for use on Android RFID scanners. • Developed ASP.NET Web Forms based outbound orders system, and was responsible for full stack, including UI and SQL Server database design. • Developed and maintained command line C# scheduled task ETL utilities for various data input sources (flat file, JSON, XML). • Independently designed and developed Container Management System at customer site under tight time constraints, completely replacing a paper based system. • Served as subject matter expert for several clients' operations and workflow (Nissan WMS/CMS, CNH). • Developed SOAP and REST based ser
  • XPO logistics
    Applications Engineer III
    XPO logistics
    Jan 2015 - Oct 2015 (10 months)
    • Developed Shipment Details page with an Agile team to replace existing legacy ASP page. This included creating new REST API endpoints and data access layer in C#/ASP.NET, and creating frontend page using AngularJS, Bootstrap, and Kendo UI controls. • Performed deployments of APIs and frontend code to test and production environments. • Worked with Business Analysts to distill lengthy requirements documents into a concise format for use by developers. • Developed ASP.NET/AngularJS web-based check printing solution to replace existing legacy Delphi appli
  • Molina Healthcare
    Senior Programmer Analyst
    Molina Healthcare
    Jul 2012 - Oct 2014 (2 years 4 months)
    • Created new features and re-architected the data model on two major MVC based ASP.NET web applications (mCare Online and UMK2) as part of the Care Management Services team, using C#, Entity Framework, and SQL Server 2012 • Provided support, configuration, and deployment of vendor software utilized by Molina's Nurse Advice Line, a 24x7 phone line available to Molina members • Developed and maintained SSIS packages to perform ETL data load from source systems into our application specific databases • Developed ad hoc reports for business stakeholders using SSRS and SQL Server 2012 • Exhibited attention to detail while implementing rapid changes in b
  • R
    Senior Application Developer
    Reliance Software Systems
    Feb 2004 - Dec 2011 (7 years 11 months)
    • Joined R&D team to implement architecture updates to a web-based EMR, comprising MS SQL 2005/2008 database, C# server code, and frontend JavaScript, jQuery, and DHTML • Used Agile software development methodologies, including scrum and sprint, to create quality software under tight deadlines, with focused deliverables and features • Developed automated test scripts for new code using NUnit and QUnit • Assisted in the design and build of both web-based frontend, using DHTML, XML, XSLT, XPath, JavaScript and C#, and workflow engine backend systems, using C#, ASP.NET and XML configuration files
Education verified_user 0% verified
  • Oakland University
    Bachelor of Science
    Oakland University
    Sep 2001 - Dec 2003 (2 years 4 months)