Aaron Sprecher

Bachelor's

Computer Science

Terso Solutions

Software Development Engineer III

- Involved in requirement gathering, database design, preparing low level estimates, analysis, implementation and test phases of the SDLC and attended review meetings for business requirement documents and function documents and documented the design docs for the same - Served as a technical lead, mentoring junior developers and providing guidance on C#, ASP.NET and database optimization and coordinated with stakeholders to define technical requirements and project scope - Developed solutions for diverse programming scenarios in C# and employed SOLID principle, Object - Oriented Programming (OOP) concepts such as encapsulation, inheritance, polymorphism, and abstraction and design patterns like Dependency Injection (DI) and Repository and developed various components for business logic using C - Developed the presentation layer using WPF and silver light and service layer using WCF technologies and used WPF in creating different animated scenes using the combination of transforms, animation controls - Designed and developed the application in a typical sophisticated SOA environment, developed WCF - Created React components using Redux for unidirectional data flow, developed React pages, web services - Worked extensively on ADO.Net objects to interact with databases such as SQL Connection Object, SQL - Command Object, Data Reader, Dataset and Data Adapter and wrote data access layer methods, T-SQL - Developed Advanced PL/SQL packages, procedures, triggers, functions, indexes and collections to implement business logic using SQL Navigator and wrote conversion scripts using SQL, PL/SQL, stored - Designed & created models, controllers, views, master/layout pages using ASP.NET MVC 2.0/3.0, Razor - View Engine and created test cases and developed new ASP.NET MVC 4.0 C# web applications using - Razor using temp data, view model, HTML Helpers, layout views, partial views and Ajax helpers - Involved in developing modules using latest technologies such as ASP.NET MVC, Razor View Engine - XHTML, HTML5, CSS3, JavaScript, TypeScript, C# and various applicable frameworks or libraries such as - Angular, React, Vue.js to fulfill good Responsive Web Design (RWD) and implemented UI using MVC 4.0 - HTML5, XML, CSS3, JavaScript, Typescript, AJAX and Bootstrap or Tailwind CSS to create responsive web - Utilized Java frameworks in business, web and client-server environments including Java EE, Spring (IOC & AOP), Hibernate/iBATIS, Struts 2.0/1.2, Ant, Maven, Log4j, Servlets, Spring MVC, Custom Tags and Java - Database Connectivity (JDBC) technologies - Developed presentation layer using Java Server Faces (JSF) MVC framework and developed Servlets and Java Server Pages (JSP) to route the submittals to the EJB components and render-retrieved information - Developed and optimized high-performance software applications using C++ and utilized C++ for design and implementation of core system functionalities in embedded systems - Built cross-platform graphical applications leveraging C++/C# and OpenGL and also developed real-time 3D - Integrated Microsoft 365 APIs with .NET applications to automate workflows and synchronize data across - Outlook, SharePoint and Teams and leveraged Azure Active Directory and .NET Core for seamless - Developed custom .NET solutions to extend the functionality of Microsoft 365 services including building - Enhanced productivity by using Visual Studio IDE for comprehensive project management, unit testing and debugging in ASP.NET MVC applications and developed and debugged full-stack applications using Visual - Studio IDE by leveraging its robust features for C# and .NET development - Utilized VS Code for efficient cross-platform applications development by configuring well-known extensions and settings for optimal coding in C#/C++, JavaScript and HTML - Made Docker files to generate NGINX web server for Angular app deployment in Azure App Service Plan and created and deploy Kubernetes clusters to host micro services container feeding real time applications - Used Microsoft Team Foundation Server (TFS) (Currently Azure DevOps) to manage the team's software - Worked on Prototype microservices sample that demonstrated the use of Azure API management and Prototype concept using ASP.NET Core and EF7 model first to replace current Access apps - Used WCF and exposed Simple Object Access Protocol (SOAP), REST endpoints and RabbitMQ services for processing the data packets and tested Web API services using API testing tools like Postman and Swagger - Used XML and SOAP to exchange structured and typed information with help of web service over the Internet and utilized .NET validation controls for server-side validation and JavaScript for client-side - Implemented custom directives, custom tree-view control and client validations and developed factory - Node.js, Webpack, XHTML, HTML5, CSS3, JavaScript, Typescript, jQuery - Developed web applications using ASP.NET MVC, jQuery, Angular, React and web services using WCF - REST, SOAP) and optimized application performance by 40 - Designed, developed and also involved in writing and maintaining complex SQL queries, stored procedures - Involved in testing UI design and workflow of the application and creating a document for mapping the UI of the application to the tables in the database - Responsible for releases and production deployments. Used Git and Team Foundation Server (TFS) for security and version control management and created resource management scripts and stored procedures - Designed and implemented a real-time data processing pipeline using Apache Kafka and Azure Logic Apps to streamline and automate workflows for an enterprise-level application, resulting in a 30% increase in processing efficiency - Worked closely with business analysts and other team members to build a high quality of SOA architecture - Created Azure web apps on Linux by Python Flask API and created Azure pipelines for CI/CD configuration - Deployed the projects into SVN and used the existing CI/CD process to upload the code into Azure and created a CI/CD pipeline for the code deployment into Azure through SVN and also involved in deployment of the web application to IIS 8.5 server - Spearheaded the implementation of real-time, interactive web solutions using Blazor Server, leveraging - SignalR for persistent server connections, which resulted in enhanced user engagement and a 30 - Created stored procedures, functions, triggers and packages in PL/SQL and relational database - Worked on OAuth2.0 for accessing the cloud storages like Box, OneDrive, Google Drive, Dropbox and fetched user contacts from GMail/Yahoo/Facebook accounts using OAuth2.0 authentication from various - Migrated legacy batch processing systems to an event-driven architecture by leveraging Apache Kafka for real-time data ingestion and Azure Logic Apps to handle integration and automation across various cloud - Used multi-threading to enhance performance by running multiple processes asynchronously and extensively used Windows UI Automation & CodePlex Automation framework features to find the page - Automated intricate workflows that involve extensive data manipulation, scheduling, and monitoring, thereby - Assisted in updating and maintaining firmware for devices such as RFID-enabled refrigerators, cabinets and mobile devices and gained deep knowledge of how to efficiently update and manage firmware for distributed - IoT devices - Developed and maintained healthcare applications using .NET technologies to ensure smooth integration with Epic Systems for enhanced patient data management and worked closely with cross-functional teams to design and implement web applications, improving healthcare service delivery through advanced .NET - Integrated Epic Systems' APIs to facilitate seamless data exchange and improve the accuracy and accessibility of electronic health records (EHR) and contributed to the development of secure, HIPAAcompliant - Developed unit test cases and performed both unit and integration testing of the application using xUnit and NUnit framework and maintained 70% code coverage and used TFS for bug tracking, work item tracking and published test results in TFS to share with the team members - Wrote unit tests for the modules & libraries, developed and performed unit testing on the entire application and tracked all issues with JIRA tickets and resolved them and done unit testing on every new version before - Streamlined documentation and project tracking by leveraging Microsoft Word and Excel for process - Utilized Microsoft Excel to create detailed reports, perform data analysis and automate repetitive tasks using