Software Consultant

• Aug 2019 - Present

Senior Application Programmer

• Apr 2018 - Aug 2018

Programming Analyst

• Aug 2016 - Nov 2017

Senior Programmer Analyst

• Jun 2012 - Jun 2016

Sr Programmer Analyst

• Jun 2012 - Jun 2016

VisualStudio.NET 2012, C#.NET 4.5, MS SQL Server Progressive is one of the largest car insurance provider in US. Progressive has various groups to support, maintain and enhance the internal system. One of the group is Customer Data Solutions (CDS) group which is responsible for integrity of sensitive customer information and applications that make a platform for other modules in system to access this information. Responsibilities: •Incident and problem resolution as part of CDS group on-call and triage •Root cause analysis of a problem •Debug the C# code using Visual Studio 2012 and various internal tools •Create a project for coding changes and work them through the internal process of SDLC •Production data fixes in MSSQL Server and Mainframe DB2 as part of problem resolution •Create or Modify database objects like Tables, Views, Stored Procedures, Triggers, Synonyms •Maintain Version control using TFS Show less

Sr Programmer Analyst

• Feb 2009 - Jun 2012

VisualStudio.NET 2008, C#.NET 3.0, Infragistics NetAdvantage El Paso Corp is one of the North America’s largest provider of natural gas and related energy products. WestpipeConnect is an in-house project to maintain and process the data related to various pipelines. It also provides a robust platform to external customers to work on. Responsibilities: •Project development using VisualStudio.NET 2008, C#.NET 3.0 following Microsoft C# coding standards •Designed and developed various UI screens (Windows Forms) using WPF and MVVM (Model-View-ViewModel) pattern. Created various UI Elements like Converters, Adorners using XAML •Front end design and development using various Infragistics UI Controls (NetAdvantage) •Database access using Entity Relationship model as well as ADO.Net •Data Manipulation using LinQ •Working with MSSQL Server 2008 to create database objects like Tables, Views, Stored Procedures, Triggers, Synonyms •Implement CDC in MSSQL Server for tracking and auditing •Version control using Serena Changman Version Manager •Change and Process management using Serena TeamTrack Show less

Programmer Analyst

• Oct 2008 - Dec 2008

Project: Investment Management Environment: VisualStudio.NET 2005, C#.NET 2.0, Infragistics NetAdvantage Charles Schwab is America’s leading Investment Firm. It was a short-term enhancement project to help Customer Representatives of Schwab work more efficiently and in customer oriented approach. Responsibilities: •Project development using VisualStudio.NET 2005, C#.NET 2.0 following Microsoft C# coding standards •Designed and developed various UI screens (Windows Forms) •Front end design and development using various Infragistics UI Controls (NetAdvantage) •Writing stubs to access Mainframe Web Services that expose business logic to the front end. These services provide access to the database and to the core business logic taking Service Oriented (SOA) approach. •Version control using Subversion (SVN) and TortoiseSVN •Worked with Continuous Integration using CruiseControl and CCTray Show less

Programmer Analyst

• Dec 2007 - Oct 2008

Environment: VisualStudio.NET 2005, C#.NET 2.0, Spring.NET, NHibernate, Oracle 10G, Infragistics NetAdvantage Barnes & Noble Inc. is the largest book retailer in United States. This application delivers a reliable, extensible, easy to maintain, feature rich and user-friendly solution for Inventory Management. Application adds functionality to drive sales, improves buyer productivity, gives visibility & control over DC inventory and provides better information. More than 700 users are expected to use the system to get the various reports and make the purchase decisions based on it. Responsibilities: •Application uses Three-Tier Architecture and Object-Oriented Analysis & Design (OOAD) as foundation design methodology •Project development using VisualStudio.NET 2005, C#.NET 2.0, Spring.NET following Microsoft C# coding standards •Involved in development of various modules like Search engine, Ordering module, User profile, Caching etc. •Designed and developed various UI screens (Windows Forms) •Front end design and development using various Infragistics UI Controls (NetAdvantage) •Worked with Dependency Injection (DI) – also know as Inversion of Control (IoC) – which is the core design pattern used to magically connect those otherwise independent building blocks •Writing Web Services to expose Business logic to the front end. These services are primarily consumed by front end and various other systems & applications. This supports Service Oriented Architecture (SOA) implementation •Used NHibernate with Oracle 10g •Development of a module using MS Caching Application Block for caching needs of project •Use of Test-Driven Development (TDD) technique using NUnit •Version control using Subversion (SVN) and TortoiseSVN •Worked with Continuous Integration using CruiseControl and CCTray Show less

Senior Software Engineer

• Nov 2005 - Oct 2007

Environment: VisualStudio.NET 2003, C#.NET 2.0, CSF, MMCMicrosoft Connected Services Framework (CSF) is an integrated, server-based software solution for building and managing services using a service-oriented architecture (SOA). Billing- SBE (Billing Standard Business Event) is an extension to Microsoft CSF, which provides basic events for billing of various services. It runs as Microsoft Management Console (MMC) snap-in. Responsibilities:•Worked as module leader with the team of 6•Requirement analysis through regular meetings with customer•Application Design•Configuration and version management using VSS•Preparation of various documents like FS, SDD, Test Plan•Preparation of sequence diagrams and dataflow diagrams in MS Visio•Development of prototype screens•Project development using VisualStudio.NET 2003, C#.NET 2.0•Worked with CSF, Web Services, MMC (Microsoft Management Console)•Unit testing and peer reviews Show less

Senior Software Engineer

• Oct 2005 - Oct 2007

Environment: VisualStudio.NET 2005, ASP.NET 2.0, C#.NET 2.0, MS AJAX, SQL Server 2000•Development of module using VisualStudio.NET 2005, ASP.NET 2.0, C#.NET 2.0, MS AJAX•Writing stored procedures and SQL Scripts in SQL Server 2000 using T-SQL•Unit testing and peer reviews

Software Consultant

• Nov 2002 - Oct 2005

Project: Software Interface for Optical Density Measurement InstrumentEnvironment: VisualStudio.NET, C#.NET 1.1, Oracle 10GThis is Instrument Interface Software for ACC’s Optical Density measuring Instruments. It collects data from instrument through RS232 port and stores this raw data in a database. Further analysis and calculations are done on this data to generate reports and graphs.Responsibilities:•Worked as module leader with the team size of 15•Requirement analysis through regular meetings with customer•Time estimation for specific module•Preparation of FS, SDD and Test Plan for various modules•Preparation of sequence diagrams and dataflow diagrams in MS Visio•Development of prototype screens•Project development using VisualStudio.NET, C#.NET 1.1 with back end as Oracle 10g•Writing stored procedures and SQL scripts in Oracle 10g•Peer reviews and unit testing Show less

Software Consultant

• Nov 2002 - May 2003

Project: Data Extraction Application (DExA)Environment: VisualStudio.NET, VB.NET 1.1, NuGenesis SDMS 6.0This is a product, which integrates NuGenesis SDMS with WinNonLin. NuGenesis is a scientific document management system basically designed for Pharmaceutical Labs to comply with FDA’s 21 CFR Part 11 rules. WinNonlin is a widely used tool for pharmacokinetic analysis. Depending on various user inputs and conditions it extracts data from SDMS and prepares it for the use of WinNonLin.Responsibilities:•Worked as Project lead with the team of 5•Requirement analysis and SRS preparation•Preparation of project plan and time estimation•Application Design•Setup for Configuration and version management using VSS•Preparation of various documents like FS, Test Plan•Development of prototype screens•Project development in VisualStudio.NET, VB.NET 1.1 and NuGenesis SDMS 6.0•Unit testing and reviews•Knowledge transfer to Support team Show less

Software Engineer

• Apr 2000 - Oct 2002

Canal Irrigation Management SystemEnvironment: Visual Studio, VB 5.0/6.0, VC5.0/6.0, Crystal Reports 7.0, Sybase 11.9CIMS is a system for complete automation and optimization of Canal and Reservoir Management. This application has twelve different modules. Data from different locations is sent to central station through VHF communication (Telemetry) where it is processed to optimize the available water resources and to generate different reports, which helps in further decision-making. Further extension to this project is complete automation of the gates on the canal and reservoir based on the data received by telemetry module.Responsibilities:•Worked as Project Leader with the team of 12•Requirement analysis through regular meetings with customer•Preparation of SRS•Preparation of project plan in MS Project•Work and time estimation and work delegation•System, application as well as database design•Responsible for database administration (Sybase 11.9)•Setup for Configuration and version management using VSS•Preparation of SDD, Test Plan•Development of Database Synchronization module in VC 5.0 which subsequently upgraded to VC 6.0•Worked with Visual Studio 5.0/6.0, VB 5.0/6.0, VC5.0/6.0, Crystal Reports 7.0•Writing Stored Procedures and SQL Scripts in Sybase 11.9•Conducted regular peer reviews•Managed deployment at user site_____________________________________________________________________________________________ Sumant Kulkarni Page 5 of 6 Show less

Software Engineer

• Feb 2000 - Feb 2002

Visual Studio 6, VB 6, Crystal Reports 8.0, Oracle 8APIIS is a web-based application, which helps in optimizing the available water resources and also provides integrated access to information from various clients using dialup connections/RAS. Data is transferred to central location through telemetry where it gets processed to give required optimization. Various Data maintenance screens and Reports within an organization are maintained on a single machine and the application facilitates the user to access these reports according to the access privileges in a secure way. Application contains fourteen modules.Responsibilities:•Worked as Project Leader with the team of 21•Requirement analysis through regular meetings with customer•Preparation of SRS•Preparation of project plan in MS Project•Work and time estimation and work delegation•System, application as well as database design (Oracle 8)•Setup for Configuration and version management using VSS•Preparation of SDD, Test Plan with CMM compliance•Worked with Visual Studio 6, VB 6, Crystal Reports 8.0•Writing Stored Procedures and SQL Scripts in Oracle 8•Conducted regular peer reviews•Managed deployment at user sites Show less

Software Consultant

• 2000 - 2002

ApplicationEnvironment: Java, Jscript, NuGenesis SDMS 6.0A completely web based small application is an add-on to NuGenesis SDMS. It automates the process of retention/deletion of records in NuGenesis database by defining rules for the same, takes action on records according to rules and sends mails to respective users confirming the same.Responsibilities:•Worked as Designer / Developer with the team size of 10•Requirement analysis through regular meetings with customer•Application Design, Database design•Setup for Configuration and version management using VSS•Development of prototype screens•Required modifications in front-end screens through various end user meetings•Project development in Java, Jscript, NuGenesis SDMS 6.0•Conducted regular peer reviews•Unit testing according to test plan Show less