Full Stack Developer

Pranay Sarvaiya

Email: ********@*****.*** Location: Irvine, CA Phone: 818-***-****

PROFESSIONAL SUMMARY

Highly skilled and experienced Senior .NET Developer with extensive years of expertise in designing, developing, and maintaining scalable web applications and backend services. Proficient in C#, ASP.NET, and SQL Server, with extensive experience in implementing CI/CD pipelines, optimizing databases, and creating automated reporting solutions. Adept at mentoring junior developers, conducting code reviews, and collaborating with cross-functional teams to deliver high-quality software solutions. Committed to continuous learning and staying updated with the latest industry trends and technologies. Ability to embrace and apply new technologies and concepts. Extensive experience in architecting and developing cutting – edge Enterprise Applications using Microsoft .NET technologies (C#, VB.NET, Silverlight, ASP.NET, Windows Forms, ASMX Web Services, WCF, AJAX) and Microsoft SQL Server.

SKILLS

.NET Framework v 4.7.1, 4.5.2, 4.5, 4.0, 3.5, 3.0, 2.0 and 1.1, .NET 5, Visual Studio, C#, VB.NET, WPF, Windows Forms, Silverlight, ASP.NET, ASP.NET MVC, Web Services, Windows Services, WCF, Web API, Remoting, Multi-Threading, Enterprise Library, LINQ to SQL, LINQ to XML, Entity Framework, ADO.NET, ASP.NET, ASP.Net Core 3.1, AJAX, ASP, IIS, MTS, VBScript, JavaScript, DHTML, HTML, XML, XSD, XSLT, XPath, SSL, PHP, XAML, jQuery, jQuery Mobile, jTable jQuery Plugin, Plupload File-Uploader, Bootstrap frontend framework, HTML5, CSS, Google Maps API, MapQuest Maps API, SSO, SAML, REST API, RestSharp, IBM MQ Server, Netegrity SiteMinder, Microsoft Content Management Server (MCMS), Autosys, ADSI, DevExpress WinForms and ASP.NET Controls, Telerik AJAX controls, True DBGrid, Version Control (Team Foundation Server, MS Visual SourceSafe, Clearcase, TortoiseSVN, Github, Bitbucket), Agile Scrum, Microsoft Visio, MTS, COM/DCOM, Visual Basic, Citrix, Crystal Reports, Eclipse, Google reCAPTCHA, RightNow CRM, Fiddler, Control-M, Splunk, Dimensions Chrome Extension to test responsive websites, Percussion CMS, Google Mini, Quartz.NET Scheduler, MapForce, Alteryx, VBA, Excel Macros, EDI, Oracle SQL Developer, Postman, RabbitMQ, TIDAL scheduler, Box API, Microsoft Power BI, NUnit with MOQ, Appium with WinAppDriver, Azure DevOps, MS-SQL Server, SSIS, SSRS, DTS, Oracle, MS-Access, Programmatic interface to IBM Unidata 5.1, AS400 and DB2, Toad, PL\SQL, T-SQL

Qualifications and Achievements:

Bachelor of Engineering (Electronics) from VJTI, Mumbai, 1997

Received an award for “Technical Excellence” from Nucleus Software Offshore Ltd in year 1999

Won 1st prize in entire Mumbai region in a .NET Technical proposal contest (called “Beyond Code”) organized by Microsoft India in year 2002.

Received a Certificate of Achievement for contribution and successful delivery of project “Link Loans for Common Properties” from Bank of America in December 2009.

Microsoft Certified Solution Developer (MCSD), 1999

Microsoft Certified Application Developer (MCAD), 2004

Microsoft Certified Professional (MCP), Programming in C#, 2018

Certified by edureka! as Business Analyst using Power BI, 2022

Certified by edureka! as Angular Developer, 2023

PROJECTS:

Lead I - Software Engineering

UST HealthProof Inc, Remote (May 2023 – Dec 2023)

Technology: Visual Studio 2022, MS SQL Server 2019, .Net framework version 4.7.1, C#, ASP.Net, TFS, Control-M, JIRA

Resolved various JIRA tickets. Implemented design patterns and architectural principles in C# to create extensible and testable software solutions.

Provided technical and functional guidance and support to team members for building maintainable and scalable ASP.NET applications.

Performed database optimization and tuning techniques on SQL Server 2012 to improve query performance and resource utilization.

Implemented error handling and logging mechanisms in stored procedures to enhance troubleshooting and monitoring capabilities.

Conducted code reviews and provide feedback to team members on code quality, best practices, and adherence to coding standards.

Developed various SQL scripts and reports for the Annual Enrollment activity deployment.

Analyzed and documented complex SQL Server stored procedures and jobs.

Participated in testing of various releases.

Team Lead. Actively involved in Production support. Supported system outage calls.

.Net Developer (Contractor)

Kayne Anderson Rudnick, Los Angeles, CA (Jul 2021 – Jun 2022)

Technology: Visual Studio 2019, .Net framework version 4.8, C#, WinForms, SSIS, MS SQL Server 2019, TFS, Github, FundApps, REST API, RestSharp, JSON, DevExpress 21.1 controls, TIDAL scheduler, RabbitMQ, Box API, Azure DevOps, Microsoft Power BI, Appium with WinAppDriver, NUnit with MOQ

Collaborated with product teams to define and implement business logic in C# for new features and enhancements. Created C# jobs that is scheduled in TIDAL

Conducted code reviews of stored procedures to ensure they meet performance criteria and maintainability standards.

Involved in implementing RabbitMQ for Queues to build the application as SOA platform.

Created various SSIS packages. Monitored and optimized SQL Server Integration Services (SSIS) packages for efficient data flow and error handling.

Involved in developing Azure DevOps pipelines for continuous integration and continuous deployment (CI/CD) of applications.

Involved in migrating TFS repository to Github. Involved in implementing Azure DevOps security policies and access controls to ensure data protection and compliance.

Developed data export tasks for FundApps. CSV file is generated and uploaded to FundApps via REST API.

Developed WinForms screens using DevExpress controls.

Created employee report in Power BI.

Created WinForms UI Test automation scripts using Appium with WinAppDriver.

Performed unit testing using NUnit with MOQ

ClickOnce deployment of UI and manual deployment of C# jobs.

C#/VB.net (SQL EXP) (Contractor)

Exa Data Solutions Inc., NJ (Jan 2021 – Feb 2021)

Technology: .Net 5, C#, Visual Studio 2019, SQL Server 2019, SSIS, LINQ to XML

Involved in creating a C# program that reads an excel file in "AS IS" format and populates corresponding database table. The C# program auto-detects the desired spreadsheet cells to be extracted and transformed, maps them to SQL Server database table columns using XML file and then populates the database table. I also explored doing this with SSIS.

Implemented object-oriented programming principles in C# to create modular and maintainable codebases for various projects.

Designed and implemented database schemas and data models in SQL Server 2012 to support application requirements and reporting needs.

Interacted with the client for various clarifications regarding the business requirements of the project.

Senior Programmer

ABS Auto Auctions, Corona, CA (Sep 2020 – Nov 2020)

Technology: Visual Studio, SQL Server, Bitbucket, JSON, VB.NET, REST API, Visual Basic 6, Classic ASP, Postman, WinMerge, Windows 10 VDI

Integrated New API from a transportation vendor. This involved modifying existing code with the new API from transportation vendor.

Created reports using T-SQL and updated existing .NET code for various ad hoc requests.

Actively involved in production support and development.

Technology Lead - US

Infosys Limited (Jul 2018 – Jul 2020)

Clients: Molina Healthcare, Long Beach, CA - March Vision Care, Los Angeles, CA - Blue Shield of California Promise Health Plan, Monterey Park, CA - Capital Group, Irvine, CA

Technology: Visual Studio 2017, SQL Server 2016, Web API, ASP.NET MVC, ASP.NET Core 3.1, Github, Azure DevOps, TFS, Postman, SSO, SAML, Agile Scrum, Windows 10, PL\SQL, SSIS, C#, EDI, Oracle, Oracle SQL Developer, TortoiseSVN, MapForce, Windows 10 VDI, Windows 7, MS Access database, VBA, Excel Macros, Alteryx

Enhanced responsive web application using ASP.NET MVC and ASP.NET Core to meet evolving business needs.

Wrote clean, scalable, and efficient code in C# to implement application functionalities and meet project requirements.

Utilized Visual Studio for debugging, testing, and deploying applications, ensuring adherence to best practices in software development.

Developed and consumed RESTful APIs to facilitate seamless integration between front-end and back-end services.

Implemented CI/CD pipelines in Azure DevOps to automate the build, test, and deployment processes for applications.

Managed and optimized SQL Server 2012 databases, ensuring data integrity and performance for application data storage.

Created and maintained stored procedures to enhance database operations and improve application efficiency.

Designed and implemented SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading (ETL) processes.

Collaborated with cross-functional teams using Azure DevOps for project management, tracking progress, and ensuring timely delivery of features.

Managed source code repositories in GitHub, ensuring version control and collaboration among team members throughout the development lifecycle.

Actively involved in interacting with client for various clarifications. Involved in code reviews and making improvements to it.

Working with offshore team members, participating in various meetings and reporting status to client.

Provided Spanish translations, images and mockups to offshore team after working with onsite team members for Member Portal Changes For NY Acquisition project.

Actively involved in analyzing and designing the system for developing Stop Loss Report and Enrollment Count Report.

Understanding CG 1.4 changes and performing impact analysis on technical components.

Involved in enhancing SSIS and Oracle components for CG 1.4 changes.

Support QA and UAT teams.

Created a workflow using Alteryx

Actively involved in development and production support of various MS Access databases

Converted various MS Access databases from Windows 7 to Windows 10

Software Engineer

Veros Real Estate Solutions, Santa Ana, CA (Mar 2015 – Dec 2017)

Technology: Visual Studio 2010/2013, .Net framework versions 4.0/4.5.2, C#, WCF, ASP.NET, Windows Services, Oracle, Toad, TortoiseSVN, Telerik AJAX controls, Microsoft Visio, WPF, XAML, XML, XSLT, XSD, XPath, Google Maps API, MapQuest Maps API, Quartz.NET Scheduler, PHP, Windows Server 2012 R2, Windows 7

Made various enhancements to ASP.NET web application, ensuring adherence to security best practices and performance standards.

Made various enhancements/updates of Windows Services and WCF service.

Conducted API testing and validation to ensure functionality, reliability, and performance of RESTful services.

Wrote and optimized stored procedures to handle complex queries and improve data processing efficiency.

Created various Unit tests, Regression tests and Performance tests.

Enhanced internal tools using WPF/XAML.

Actively involved in Customer Service support and weekend monitoring of Pathway and VeroSCORE.

Involved in QA for Pathway, VeroSCORE and VeroPDF projects.

Involved in validation of Pathway UAT test results.

Smoke testing for various deployments and system maintenances.

Contractor (.net developer)

HISNA, Irvine, CA (Aug 2014 – Oct 2014)

Technology: Visual Studio 2005/2013, .Net framework version 2.0, C#, ASP.NET, MS SQL Server 2008, TFS 2013, Javascript

Made various enhancements to an existing asp.net website and made corresponding database schema changes.

Contractor (Software Developer)

Fidelity National Financial, Santa Ana, CA (Sep 2013 – May 2014)

Technology: Visual Studio 2013/2012/2010/2008, .NET framework version 4.5/2.0, C#, ASP.NET, MS SQL Server 2008, TFS 2012, Plupload File-Uploader, jQuery, jTable jQuery plugin, Bootstrap frontend framework, HTML5, CSS, Dimensions Chrome Extension to test responsive websites, Percussion CMS, Google Mini, Agile Scrum, Windows 7

Made various enhancements to an existing asp.net website. Designed tables and wrote corresponding stored procedures for those enhancements.

Created a new asp.net web-page for Closing Protection Letter Request. Created a web page to upload multiple files using Plupload file uploader.

Explored importing the website using Percussion CMS LiveFirst technology and building responsive templates.

Created various templates for a new responsive website for smartphones, tablets and PCs using Bootstrap frontend framework. The website is www.ChicagoNCS.ctic.com

Created a RESTful WCF service that returns search results from Google Mini as a JSON object. Created a Search html page that displays these results using jTable jQuery plugin. Explored various configurations in Google Mini for crawling and indexing the website.

Independent Contractor (Software Developer)

Experian, Costa Mesa, CA (Jan 2012 – Jun 2013)

Technology: Visual Studio 2010/2008/2005/2003, .NET framework version 4.0/3.5/3.0/1.1, C#, WCF, ASP.NET, jQuery, Visual Basic 6, Control-M, Splunk, MS SQL Server 2008, XML, XSD, Team Foundation Server, Dimensions, Windows 7

Developed/enhanced Control-M jobs.

Developed an internal WCF service to communicate across different servers. Also, created a RESTful WCF Service using the WebGetAttribute for a business partner.

Developed/enhanced various middle layer components.

Updated static/dynamic content on the webpages.

Involved in various deployments and resolving production issues.

Contractor (Developer)

Western Digital, Irvine, CA (Jun 2011 – Dec 2011)

Technology: Visual Studio 2010, C#, ASP, ASP.NET, WCF Service, SQL Server 2008, Silverlight, XAML, XML, XSD, LINQ to SQL, LINQ to XML, RightNow, SSIS, PHP, Eclipse, Team Foundation Server, Javascript, jQuery Mobile, Google reCAPTCHA, Fiddler, Windows 7, iOS

Developed TextManager Intranet website using Microsoft Silverlight. Imported existing data from xml files using SSIS packages.

Developed and deployed WCF service.

Primary developer for creating an ASP.NET website for Channel Marketing Survey project.

Added Google reCAPTCHA to a web page.

Actively involved in doing various updates and customizations to Web and Mobile support sites using RightNow Technologies.

IT Programmer/Developer III

OneWest Bank, Irvine, CA (Nov 2010 –May 2011)

Technology: Microsoft Access 2003, C#, ASP.NET, Windows Service, Visual Studio 2003/2008, SQL Server 2000, DTS, Citrix, Windows XP

Actively involved in production support of IReSS system

Independent Contractor (Senior developer and database programmer)

Web Service Company LLC, El Segundo, CA (Apr 2010 –Sep 2010)

Technology: Visual Studio 2010/2008/2005, .NET framework version 4.0 and 2.0, C#, Silverlight 4.0, WCF, ASP.NET 2.0, ASP.NET MVC, WPF, MS SQL Server 2000/2008, SSIS, XAML, XML, XSD, LINQ to SQL, LINQ to XML, Entity Framework, AJAX Control Toolkit, Javascript

Created various screens using Silverlight and LINQ to SQL technologies

Created a report using Report designer in Visual Studio 2010

Created inbound and outbound interface with a bank for enrolling customers using XML/XSD and LINQ to XML

Created various proof of concepts using ASP.NET MVC, Entity Framework and SSIS

Developed Refund Request and Add location to batch screens. Used AJAX Update Panel control, Calendar control, Filtered Text Box and Masked Edit extenders from AJAX Control Toolkit.

Consultant - Applications Programming

Bank Of America, Irvine, CA (May 2008 – Mar 2010)

Technology: Visual Studio 2005, C#, ASP.NET, AJAX, Windows Forms, .NET framework version 2.0, MS SQL Server 2005, SSIS, Microsoft Visio 2007

Involved in code review/development of various windows services

Developed/enhanced web UI and Reports

Developed various SSIS packages

Reconstruction and conversion of DTS packages to SSIS

CAMO Technologies INC, Woodbridge, NJ (May 2004 – May 2008)

Clients: US LABS, A division of LabCorp, Irvine, CA - Countrywide, Calabasas, CA - Countrywide, Malibu, CA - Merrill Lynch, Hopewell, NJ

Technology: Visual Basic 6.0, Visual Studio 2008, Visual Studio 2005, C#, VB.Net, ASP.NET, AJAX, Web Services, ADO.Net, Windows Forms, .NET Framework version 1.1, 2.0, 3.0 and 3.5, WCF, NUnit 2.2, MSMQ, MS SQL Server 2000 and 2005, SSRS, DTS, DevExpress ASP.NET controls, AS400, IBM Unidata 5.1, IBM MQ Server, Netegrity SiteMinder, Microsoft Content Management Server, Autosys, Microsoft Visio 2007, Enterprise Library, Team Foundation Server, Windows XP, Windows Server 2000 and 2003, Microsoft Visio

Reliable Communication LLC, Edison, NJ (Oct 2003 – May 2004)

Role: Project Leader

Technology: ASP.NET, VB.NET, Web Services, ADO.NET, Win Forms, VS.NET, Windows 2000, MS SQL Server 2000

i-flex solutions ltd., Mumbai, India (Aug 1999 – Sep 2003)

Clients: Citigroup Treasury System Department, New-York (Role: Project Leader), CitiFinancial USA, Citicorp Development Center Los Angeles, Citibank Japan and Internal (i-flex solutions ltd.)

Technology: ASP.NET, C#, VB.NET, Web Services, ADO.NET, VS.NET, Win 2000, MS SQL Server 6.5, 7.0 and 2000, Netegrity SiteMinder, ADSI, LDAP, Windows Forms, Remoting, Multi Threading, Crystal Reports 8.0, Windows 2000,

Visual Basic 6.0, ActiveX, COM/DCOM, HTML, XML, IIS 4.0, ASP, VBScript, JavaScript, SSL, Mercury Interactive tools like Load Runner and WinRunner, MS SNA server to connect to IBM mainframe, Windows 2000 Advanced Server

Nucleus Software Offshore Pvt. Ltd., Mumbai, India (July 1997 – Aug 1999)

Client: Citibank N.A., Mumbai

Technology: Visual Basic 6.0, Windows Forms, Oracle 7.3, Crystal Reports 6.0, True DB Grid control, Active X, COM/DCOM, Pro *C, Visual-Interdev 6.0, FrontPage 98, MTS, VBscript, Jscript, Windows NT, UNIX

Contact this candidate