Pranay Sarvaiya

Email: ad4vzn@r.postjobfree.com Location: Irvine, CA Phone: 818-***-****

Summary:

Over 20 years of IT experience mainly in the area of Web Programming, Responsive Web Design, eCommerce and Windows Forms applications

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

Qualifications and Achievements:

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

Microsoft Certified Solution Developer (MCSD), 1999

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.

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

Technical Proficiency:

.NET Technology

:

.NET Framework v 4.7.1, 4.5.2, 4.5, 4.0, 3.5, 3.0, 2.0 and 1.1, 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

Web Based

:

ASP.NET, 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

Tools/ Middleware

:

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, GIT repository, 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

Databases

:

MS-SQL Server, SSIS, SSRS, DTS, Oracle, MS-Access, Programmatic interface to IBM Unidata 5.1, AS400 and DB2, Toad, PL\SQL, T-SQL

OS

:

Windows 7, 10, XP, Windows Server 2012 R2/Windows 2003/2000, UNIX, iOS

Testing

:

NUnit, Automated testing using Mercury Interactive Products like WinRunner and LoadRunner, MS Web Capacity Stress Tool (WAS)

Domain Knowledge

:

Exposure to Healthcare, Forward and Reverse mortgage, Banking Systems (Retail and Corporate), Treasury & Money Market Operations, Trade Finance, Home and Auto Insurance, Property Valuation, Investment management, Wealth advisory, Health insurance, Online auto auctions

Projects:

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

Technology

:

MS SQL Server 2019, Visual Studio 2022, .Net framework version 4.7.1, C#, ASP.Net, TFS, JIRA

Responsibilities:

Production Support. Resolved various JIRA tickets.

Team Lead

Kayne Anderson Rudnick, Los Angeles, CA (July 2021 – June 2022)

Position

:

.Net Developer (Contractor)

Technology

:

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

Responsibilities:

Created C# jobs that is scheduled in TIDAL

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

Created various SSIS packages.

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.

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

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

Technology

:

C#, Visual Studio, SQL Server, SSIS, LINQ to XML

Responsibilities:

Actively 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.

Actively involved in interacting with the client for various clarifications regarding the business requirements of the project.

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

Responsibilities:

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.

For Infosys Limited (July 2018 – July 2020)

Project

:

Member Portal Changes For NY Acquisition

Client

:

Molina Healthcare, Long Beach, CA (Mar 9, 2020 – May 15, 2020)

Role: Onsite Coordinator

Technology

:

Visual Studio 2017, SQL Server, MVC, GIT repository, SSO, SAML, Agile Scrum, Windows 10

Project

:

One Vision

Client

:

March Vision Care, Los Angeles, CA (Feb 3, 2020 – Feb 17, 2020)

Role: Development Lead/Onsite Coordinator

Technology

:

Visual Studio 2017, SQL Server 2016, Web API, MVC, TFS, Postman, Agile Scrum, Windows 10

Project

:

CE (Customer Experience) Optimization - Stop Loss Report, Enrollment Count Report

Client

:

Blue Shield of California Promise Health Plan, Monterey Park, CA (Oct 2019 – Dec 2019)

Role: Development Lead

Technology

:

PL\SQL, SSIS, Oracle, Oracle SQL Developer, TortoiseSVN, Windows 10 VDI

Project

:

LACare 1.4 Companion Guide (CG) Changes

Client

:

Blue Shield of California Promise Health Plan, Monterey Park, CA (July 2019 – Sep 2019)

Technology

:

PL\SQL, SSIS, C#, EDI, Oracle, Oracle SQL Developer, TortoiseSVN, MapForce, Windows 10 VDI

Responsibilities for above projects:

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.

Projects

:

Alteryx Workflow, PCS Oversight App Support

Client

:

Capital Group, Irvine, CA (Aug 2018 - Jun 2019)

Technology

:

MS Access database, VBA, Excel Macros, Alteryx, Windows 7, Windows 10

Responsibilities:

Actively involved in creating a workflow using Alteryx

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

Actively involved in conversion of various MS Access databases from Windows 7 to Windows 10

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

Projects

:

Pathway, VeroSCORE

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

Responsibilities:

Actively involved in various enhancements/updates of Windows Services, WCF service and ASP.NET UI

Actively involved in creating various Unit tests, Regression tests and Performance tests

Actively involved in enhancing 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

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

Position

:

Contractor (.net developer)

Technology

:

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

Responsibilities:

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

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

Position

:

Contractor (Software Developer)

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

Responsibilities:

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.

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

Position

:

Independent Contractor (Software Developer)

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

Responsibilities:

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.

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

Projects

:

TextManager, Channel Marketing Survey, Customizations to Web and Mobile support sites using RightNow

Position

:

Contractor (Developer)

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

Responsibilities:

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.

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

Project

:

IReSS

Technology

:

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

Responsibilities:

Actively involved in production support of IReSS system.

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

Project

:

ePayments Website (May 2010 – Sep 2010)

Position

:

Independent Contractor (Senior developer and database programmer)

Technology

:

Visual Studio 2010/2008, .NET framework version 4.0, C#, Silverlight 4.0, WCF, ASP.NET MVC, WPF, MS SQL Server 2000/2008, SSIS, XAML, XML, XSD, LINQ to SQL, LINQ to XML, Entity Framework

Responsibilities:

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

Project

:

Refund Request Screen, Add location to batch screen (April 2010 – May 2010)

Position

:

Independent Contractor (Senior developer and database programmer)

Technology

:

Visual Studio 2005, .NET framework version 2.0, C#, ASP.NET 2.0, AJAX Control Toolkit, Javascript, MS SQL Server 2008

Responsibilities:

Developed above screens. Used AJAX UpdatePanel control, Calendar control, FilteredTextBox and MaskedEdit extenders from AJAX Control Toolkit.

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

Projects

:

Link Loans, Proactive Auto, CSAR and BOSS

Technology

:

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

Responsibilities:

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

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

Project

:

Anatomic Pathology (AP) application analysis

Client

:

US LABS, A division of LabCorp, Irvine, California (Feb 2008 – April 2008)

Technology

:

Visual Basic 6.0, Visual Studio 2008, Visual Studio 2005, C#, ASP.NET, Windows Forms, .NET Framework version 3.0 and 3.5, WCF, MS SQL Server 2005, SSRS, IBM Unidata 5.1, Microsoft Visio 2007, Team Foundation Server, Windows XP

Responsibilities:

Actively involved in analyzing the existing AP Resulting and Reporting legacy applications developed in Visual Basic 6.0. Created various Visio diagrams and documents depicting the current architecture.

Created a small proof of concept for AP reporting.

Project

:

Meridian EMR

Client

:

US LABS, A division of LabCorp, Irvine, California (Oct 2007 – Jan 2008)

Technology

:

Windows Forms, VB.NET, .NET Framework version 2.0, NUnit 2.2, MS SQL Server 2005, IBM Unidata 5.1, MSMQ, Team Foundation Server, Windows Server 2003

Responsibilities:

Created a windows service that continuously listens to MSMQ, generates Electronic order file and puts it in hold directory on IBM Dec Unidata Server

Created entity object in C# that is serialized and send to FTP share

Created high level and low level design documents

Created NUnit tests for unit testing the modules

Explored Test Master standardization using LOINC

Project

:

CLEAR (Countrywide Loan Economics Accounting Reconciliation)

Client

:

Countrywide, Calabasas, California (Feb 2007 – Oct 2007)

Technology

:

MS SQL Server 2005, Visual Studio 2005, C#, Windows Forms, .NET Framework version 2.0, Windows XP

Responsibilities:

Involved in development of various Data Sourcing jobs using T-SQL

Developed various modules in C#

Designed and developed a “build” module using Windows Forms and C# to automate deployment of various CLEAR objects from VSS to different servers.

Developed a screen scraper to extract relevant information.

Created reports and SQL smoke scripts to validate data integrity and accuracy

Project

:

Corporate Accounting Ledger (CALedger) Rewrite

Client

:

Countrywide, Malibu, California (Sep 2006 – Jan 2007)

Technology

:

C#, ASP.NET, AJAX, Web Services, ADO.NET, Visual Studio.NET, .NET Framework version 2.0 and 1.1, DevExpress ASP.NET controls, MS SQL Server 2000, DTS, Microsoft Visio

Responsibilities:

Created various web screens and reports using ASP.NET.

Developed asynchronous webservice to handle long running reports and trigger SQL Server jobs.

Project

:

Consolidated Business Arrangement (CBA)

Client

:

Countrywide, Malibu, California (Sep 2005 – Aug 2006)

Technology

:

C#, ASP.NET, AJAX, Web Services, ADO.NET, Visual Studio.NET, .NET Framework version 1.1, DevExpress ASP.NET controls, Windows 2000, MS SQL Server 2000, AS400, DTS, Enterprise Library, Microsoft Visio

Responsibilities:

Primary developer responsible for all additions/modifications of CBA modules and integrating them with the Web Portal.

Developed various user controls that can be reused in multiple web pages. Used DevExpress ASPxGrid and Calendar on various screens.

Working on suggesting solutions, implementing and testing the solutions.

Creating various adhoc reports requested by the business users for the system.

Actively involved in various deployments and resolving production issues of the system.

Project

:

Merrill Lynch Rewards Point Bank

Client

:

Merrill Lynch, Hopewell, New Jersey (May 2004 – Sep 2005)

Technology

:

C#, ASP.NET, Web Services, ADO.NET, Windows Forms, VS.NET, IBM MQ Server, Netegrity SiteMinder, SQL Server 2000, DTS, Nunit, Microsoft Content Management Server, Enterprise Library, Autosys, Microsoft Visio

Responsibilities:

Making various changes to the logged-in portion of the Internet Rewards site (rewards.ml.com).

Making enhancements for various security aspects of the website.

Integrating the non-logged site developed using MCMS (Microsoft Content Management Server) with the logged in site.

Creating a data conversion utility using C# for importing data into the system.

Creating various adhoc reports requested by the business users for the system.

Actively involved in various deployments and resolving production issues of the system.

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

Project

:

Phone Card Website

Role: Project Leader

Technology

:

ASP.NET, VB.NET, Web Services, ADO.NET, Windows Forms, Visual Studio.NET, Windows 2000, MS SQL Server 2000

Responsibilities:

Managing the offshore project team in India and interacting with the users of the company for business requirements. Created the design document and functional specs for the system.

Developed Payment Gateway using Verisign Payflow Pro solution.

Created a web screen, a middle tier component, common modules and Windows Forms based screens.

i-flex solutions ltd. (formerly, Citicorp Information Technology Industries Limited), Mumbai, India (Aug 1999 – Sep 2003)

Project

:

Citigroup Treasury Website (Document Management System)

Client

:

Citigroup Treasury System Department, New-York, USA (Oct 2002 – Sep 2003)

Role: Project Leader

Technology

:

ASP.NET, VB.NET, Web Services, ADO.NET, VS.NET, Win 2000, MS SQL Server 2000, Netegrity SiteMinder, LDAP

Responsibilities:

Actively involved in analyzing and designing the system onsite and developing it offshore in India.

Integrating the system with portal.

Involved in developing common modules like Data Access Layer, Exception Manager, Resource Manager and Javascript library of common functions.

Developed screens in ASP.NET.

Involved in configuring the system to use Netegrity SiteMinder.

Developing an automated schedular and web service for the system.

Project

:

Branch Self Assessment System (BSA)

Client

:

CitiFinancial, USA (Offshore) (Sep 2002 – Oct 2002)

Technology

:

ASP.NET, C#, ADSI, ADO.Net, VS.NET, Windows 2000, SQL Server 7.0

Responsibilities:

Creating a custom web control for the navigation bar.

Developed a deployment script using ADSI to create a new virtual directory on the Web server, define it as an application, give the option to turn on script permissions and assign the appropriate permissions on the folder.

Project

:

Treasury Management System

Client

:

CitiFinancial, USA (Offshore) (April 2002 – Aug 2002)

Technology

:

VB.NET, ADO.NET, Windows Forms, Remoting, Multi Threading, Visual Studio.NET, Crystal Reports 8.0, Windows 2000, MS SQL Server 7.0

Responsibilities:

Coding .NET assemblies for 3 screens. Created custom controls that are used by various assemblies.

Participated in developing TCP-IP remoting component to communicate between the client and the middle-tier. The business logic resides in the middle tier.

Involved in creating a multithreaded component to provide notifications to various client machines when a change in interest rate takes place.

Developing various reports for the system using Crystal Reports.

Projects

:

a)CitiAlert (Dec 1999 – March 2002 Mostly Onsite)

b)Direct Access (Offshore) (Oct 1999 – Nov 1999)

c)Perdiem System (Sep 1999)

Technology

:

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 SQL-Server 2000 and 6.5, MS SNA server to connect to IBM mainframe, Windows 2000 Advanced Server

Responsibilities:

CitiAlert (Client: Citicorp Development Center, Los Angeles, USA)

Coding for creating server side ASP pages and scripting using VB Script and Java Script

Developing COM components for the CitiAlert gateway

Performance testing of the web site using MS Web Capacity Stress Tool (WAS) and Mercury Interactive LoadRunner

Automated functionality testing of the system using Mercury Interactive WinRunner

Developed the mechanism for 2-way immediate database replication across multiple MS SQL servers

Successfully deployed the system onsite during my travel to Singapore

Direct Access (Client: Citibank, Japan)

Involved in developing the middle layer using Visual Basic ActiveX components

Perdiem System (Client: Internal (i-flex solutions ltd.))

Coding for Advances and Settlement modules

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

Project

:

Export Product Management System (EPMS)

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

Responsibilities:

Involved in implementing the integration of EPMS with a Central Imaging System using ActiveX technologies.

Coding for client-server modules

Preparing various reports using Crystal Reports for the system

Deployment of the system at various locations in India

Contact this candidate