Software Engineer Sql Server
Resume:
Mayuri Hitesh Goyani
Lead Software Engineer
Inquisitive, energetic computer science specialist in leadership and individual contributor, with strong foundation in math, logic and coding.
******.******@*****.***
https://www.linkedin.com/in/mayuri-goyani/
Technical Skills:
Frontend: Angular 14+, TypeScript, JavaScript, WPF, Winforms, XAML, ASP.Net
Backend: .Net 6, .Net Core, C#, VB, Web API, WCF, Entity Framework Core, LINQ, Kafka
Unit Testing Framework: xUnit, nUnit
Database: SQL Server 2019, Postgres, Oracle
Cloud: AWS, Azure (AZ-900 certified)
Reporting Tools:
SQL Server Reporting Services (SSRS 2016, 2008), Jasper DevOps: Docker, Kubernetes
Version Control Tool: Git, TFS
Professional Experience:
Project: Cloud Privilege Brocker
Cloud Privilege Broker (CPB) is a product of BeyondTrust, a leading provider of Privileged Access Management (PAM) solutions. It is a cloud-based service that enables organizations to manage access risk across multi-cloud environments.
Tasks:
• My job is to understand customer requirement, identifying its suitability as a product level features and implementing it. I have worked on features to integrate identity and access management (AWS and Azure), AWS cloud trail and Azure activity logs and AWS S3.
• I worked on features to integrate Monitoring tools (Prometheus), Messaging Framework
(Kafka) and Tracing Framework (Jaguar)
• Refactored code, tailored design, and optimized algorithms by implementing Batch and Parallel Processing, leading to 90% improvement in response time, enhancing user experience and satisfaction.
• Reduced user-reported defects by 50% after fixing the root causes of the ten most common user defects.
Skills Learned: Micro Services, Kafka, Docker, Kubernetes, Web API (Health Checks, Versioning, Documentation, Authentication, Creating Policies) AWS and AZURE. Persistent Systems Pune, Maharashtra
Lead Software Engineer 12/2020 - 06/2023
Nihilent Technologies Pune, Maharashtra
Sr. Systems Analyst – Project Lead 08/2013 - 10/2020 Project: Invoice Integration:
Invoice Integration is about the integration of more than 100 invoices of different customers. The system is capable to validate and auto process the invoices, resulting in increased efficiency and reduced manual labor costs by 90%. The system also caters separate workflow through web application for the invoices which could not be auto processed. Tasks:
• Analysis of the dependent Modules (the Customer Management, Finance, Channel Management and Titles modules)
• Database design, Angular framework design.
• Wrote an algorithm to validate and auto process the invoice.
• Lead the development of web application to handle separate workflow for the invoices which system could not auto process.
Skills Learned: Leadership, Cross-Functional Team Communication, Angular, TypeScript, JavaScript, .Net Core, Oracle
Project: Micro scheduler:
Micro scheduler is a software for managing scheduling and broadcasting of multiple channels across the South Africa continent.
Key Modules:
• Log Schedule: Managed program schedules with ease
• Regionalization: Catered to different regions with tailored content
• Channel Management: Coordinated multiple channels from a single platform
• Promo Management: Streamlined promotion scheduling and tracking
• Filler Management: Optimized filler content placement
• Commercial Management: Effectively managed commercial airtime
• Implemented features for efficient program planning, scheduling, and reporting Tasks:
• Implementation of Channel Management module.
• Design the validation workflow for each windows forms in WPF, Prism and MVVM pattern.
• Implementation of critical features (merge schedule and generate warnings, import commercials) of Log Schedule modules.
• Rewrote complex SQL queries within stored procedures to leverage set-based operations and reduce query execution time, leading up to a 70% reduction in database processing time.
• Identified and fixed deadlock errors in SQL database by rewriting the store procedures and triggers, resulting in significance improvement in application response time from Endless wait to less than a sec.
• Implemented indexing strategies to optimize query execution times and reduced database latency, resulting in a 20% improvement in overall application performance.
• Identified the feature Regionalization and Lead the development of it and successfully delivered the feature to the customer.
• Worked as Production Support Engineer at Onsite. During this time, I worked on many production defects and identified the area of improvement for the better user experience. Skills Learned: WPF, WCF, MVVM, Prism, Leadership, SSRS, Customer Interaction, SQL Server, Handling Production database and application server, Azure Devops, CI/CD, Git Project: Client Survey Management
• Designed and Developed Windows and ASP.Net web application using C# and ASP.Net framework.
• Continue collaboration with stack holder for the requirement gathering and UAT demos. Skills: ASP.Net, Sql Server, C#
Project: Invoice Management:
• Designed, developed, and implemented web applications using .Net technology and C#.
• Designed and Developed workflow for SimXTextConverter tool to parse PDF and extract data. Integrated tool with ASP.Net web application.
• Analyzed and Resolved SQL query performance issues which decreased web application response time from 5 minutes to 1 sec.
Skills: ASP.Net, Sql Server, C#, VB, Jasper, SimxTextConverter Certificates:
AZ-900 Microsoft Azure Fundamentals (2021)
Education:
Government Engineering College Gujarat, India. Computer Science 06/2009 US Tech Solutions Pune, Maharashtra
Consultant 12/2012 - 08/2013
Smartsourcing global Pune, Maharashtra
Software Developer 05/2011 - 12/2012
Contact this candidate