Sql Server .Net Developer

Pranjal Shinde

Summary:

• Over ** years of strong experience in Software development using Microsoft Technologies [client/server

and web based applications using .NET framework]

• Expertise in .Net Framework 1.0, 1.1, 2.0, 3.0, 4.0 [ASP.NET 1.0, 1.1, 2.0].

• Proficient at Web and windows applications using ASP.NET, ADO.NET, C#.

• Working Knowledge of WCF, Oracle 11i, TOAD, Informatica, SharePoint, HTML, HTTP, JavaScript,

CSS, crystal reports, SSRS, Lotus Notes R5/ Domino and MS-Office.

• Expertise in GUI development and implementing Relational Database Management Systems using

Microsoft SQL Server 2000/2005/2008, Oracle 9i/8i, writing complex Database Queries, Views,

Functions and Stored procedures, Cursors and Triggers.

• Expertise in 3rd party tools like FileBound, Telerik Grid, Tall Components and Infragistics Grid.

• Experience in developing Distributed Component Applications using Windows Service.

• Expertise in all phases of SDLC including analysis, design, coding, testing with 4 + years in converting the

Business Requirements into Technical specifications, workflow preparation, process mapping, business

analysis documentation standards, designing Activity diagrams, Use Case diagrams, Logical Class

diagrams and logical sequence diagrams for detailing functional requirements.

• 4+ years Expertise in using ADO.NET objects such as SQL/OLEDB Connection Object, SQL/OLEDB

Command Object, Data Reader Object, Dataset Object and Data Adapter Object, Object Oriented

Analysis and Design [OOAD], Test cases, Unit Testing.

• Excellent analytical, inter personal, communication & written skills with problem-solving and

troubleshooting capabilities.

• Good team player with strong work ethics, desire and ability to quickly learn new technologies and work

in fast ever-changing environment.

Technical skills:

.Net Technologies C#.NET 1.1/2.0/4.0

ASP.NET 1.0/1.1/2.0/4.0

Latest Technologies Microsoft .NET 3.0 WCF, CAB

GUI/ Front end Visual Studio .NET 2003/2005/ 2010.

Java script, VB Script, HTML, DHTML, CSS, XML

RDBMS / DBMS Ms-Access 2003, Oracle 11i, SQL Server 2000/2005/ 2008 T-SQL.

Reporting Tools Crystal Reports, Data Report.

Operating Systems WINDOWS XP/NT/2000/2003.

Hardware Pentium Compatible Based Systems.

Ms-Office [Word, Excel, PowerPoint], Lotus Notes R5 /Domino.

Source Control Visual Source Safe 2005/2003

System Testing Unit Test Cases

Business Definition Requirements, Business Process Analysis,

Pranjal Shinde

Use Case Modeling & Analysis.

Modeling Tools MS Visio

Project Management MS- Project

PROFESSIONAL EXPERIENCE

Client : Amidacare, NY April 2014 - Till Date

Project Title: ACDB Database

Role: Senior Developer / Project Lead

Description : Amidacare is a managed care company . Designed User Interface for Medicare Application module

and simulating SSIS package to data migration .

Responsibilities:

• Business analysis, talking to the business users.

• Designed web server controls and user controls for Medicare Application module.

• Performed Object Relational to create a new database structure.

• Creating triggers, stored procedures, creating packages.

• Validation of scripts, deployments.

Environment: VS 2010, .NET 3.5, C#, SQL Server, ASP.NET, JavaScript, jQuery, HTML, CSS, SSIS

Client: JP Morgan Chase, NY Jan 2014- April 2014

Project Title: Asset Management Infrastructure e-signature

Role: Senior Developer

Description : Email Signature automation was Asset Management Instructure technology wide initiative to

automate e-signatures for their global team . The first step was designing instructure for a live feed to get phone,

blackberry, other information and simulation of a signature.

Responsibilities:

• Implementing RESTful API architecture to integrate application with the service.

• Multithreaded programming for livefeeds automation for Phonebook, ID Vault data

• Simulating Email Signature for entire asset management Infrastructure technology team

Environment: VS 2010, .NET 3.5, C#, SQL Server, ASP.NET, JavaScript, jQuery, HTML, CSS, Restful API.

Client: Icon Clinical Research, North Wales, PA August 2012- December 2013

Project Title: ICOTrial

Role: Senior Developer

Description: On-going maintenance and up-gradation of a Web application ‘ICOTrial’ for ICON which involves

the development of a Web service called ‘ICOTrial Import’ to import Clinical Trial data (patient visit and site list

data) from two other related data hubs to the main ICOTrial database and a windows service for generating

reports. ‘ICOTrial’ deals with creation and management of clinical trial studies managed by ICON for its clients

like Pfizer. Apart from study management, it also includes site management, patient management, patient and site

visit management, documents management, report generation, user roles management etc. Application

architecture is primarily based on platforms like MVC architecture, nHibernate, JSON, ASP.NET, Infragistics

controls, and most of the UI and the business is driven by data in Oracle 10g database while the sources of import

are MS-SQL Server and MS-Excel.

Responsibilities:

• Creating user controls to maintain data flow and data integrity using ASP.NET User Controls, Web Server

Controls and Infragistics controls.

Pranjal Shinde

• Writing Business and Data Access Layer Validation objects based on Model-View-Controller design

pattern

• Performing Object Relational Mapping [ORM] technology using nHibernate classes and HQL queries

• Implementing audit reporting architecture for Pfizer using MVC Architecture, database objects and data

modeling,

• Extensive use of PLSQL triggers, stored procedures, creating packages.

• Coordinating with off-shore QA team for designing Test Plan and Test Cases for the User Acceptance

testing

• Test Driven Development for the controllers

Environment: MVC, VS 2008, .NET 3.5, C#, Oracle 10g, Infragistics, ASP.NET, JavaScript, jQuery,

HTML, CSS, TDD, Web Service, REST, Oracle SQL Developer 3, PL/SQL, nHibernate, JSON.

Client : Multiplan Inc, NY June 2011- July 2012

Project Title : PDM Imaging and Workflow Program

Role: Consultant Software Engineer - Application Development & Architecture

Description :

Windows Application : Developed FILEBOUND project solution generates all documents as PDF’s for high

quality reproduction, allows printing, faxing, and emailing using the same source documents using a third-party

component namely, Tall Components to make it easier to maintain and own for MPI. The new code provides

better flexibility for maintenance of the customization and sets the foundation for future enhancements along with

easier maintenance of form templates and PDF files associated with this custom code. This project consists of

writing a FileBound Viewer plug-in (i.e. DLL) and a helper program (i.e. EXE). All of this code executes on the

users workstation. The plug-in is executed within the FBViewerLauncher.exe which executes in its own process.

ASP.NET application: Most recent role was working on application to provide Single-sign on’s to the Multiplan

partners and services to clients using client’s WCF services using the MVC architecture. The user was data was

retrieved using partner WCF web service and authenticated against Multiplan database and theme for respective

partners.

Responsibilities:

Strategic Redesign: Restructured

• and programmed the code for prescreening practitioner data

management to make it easier for MultiPlan Inc to maintain around 900,000 healthcare providers under

contract, offering better flexibility of form templates and PDF documents.

• Cross-Team Collaboration: Bridged the Quality Assurance Team, User Acceptance Team and Business

Users Team together for approval.

• Business Analysis: Performed system wide analysis to build a FILEBOUND project solution to generate

all documents as PDF’s for high quality reproduction, allowing printing, faxing, and emailing using the

same source documents using third-party component, namely, Tall Components.

• Designed the WinForms for the above mentioned windows application.

• For the web application, created clients for WCF web services for different partners.

• Used extensive Forms Authentication, LINQ to SQL queries, HTML, CSS, themes based on MVC

design and test driven development .

Environment: MVC, Razor, VS 2010, .NET 4.0, C#, SQL Server 2008, win Forms, FileBound, Tall

Components, ASP.NET, JavaScript, jQuery, LINQ to SQL, WCF, HTML, CSS, TDD.

Client : Quest Diagnostics, PA June 2010- May 2011

Pranjal Shinde

Project Title : Bridge

Role: .Net Developer / System Analyst.

Description : National Bridge Team created bridges [systems to Connect to doctors offices / blood laboratories

and Quest]. The patients information is communicated in HL7 protocol to process information for billing, claims,

etc. MS-sql Server, MySQL, MS-Access databases and HL7 accelerator, 7 edit.

Responsibilities:

• Responsible for the creation of standalone windows applications to help the doctors and Labs to connect

to Quest from anywhere in the network and help them access patient history and claims details.

• Customized the WinForms for the above mentioned windows application to cater as per doctors

requirements like bridging the data by Patient Name or the information they would like to see in their

clinic.

• Extensive T- SQL queries and stored procedures.

• Processing HL7 data using XML.

Environment: VS 2008, .NET framework 3.5, C#, SQL Server 2008, My-SQL, MS-Access, 7Edit, win Forms,

EDI, XML.

Client : State Dept Of Mental Health, MO Oct 2008- May 2010

Project Title : HL7 Drug Editor, CPS OHCDS, EDW Dashboard

Role: .Net Developer / System Analyst.

Description : ‘HL7 Drug Editor’ is a web application to correct the discrepancies found in HL7 data generated

from the Pharmacy systems using Biztalk server.Episode of care[EOC] reports hosted using SSRS.

‘CPS OHCDS’ is a windows application which performs insurance claim calulations for service providers like

the MedicAid and MediClaim . It includes automation of DTS packages, startup VBScript to change the DNS

remotely, distributed computing using MSMQ and Windows service at the end users.

‘EDW Dashboard’ is a Web-based database management dashboard which displays drill down server-wise SQL

job history with step wise best load summary.

Responsibilities:

• Responsible in all the stages from systems analysis, requirement gathering to its implementation and post

implementation evaluation.

• Managed the projects single- handedly.

• Analyzed the systems and gathered software requirements.

• Worked with third party DevExpress Grid in the dashboard to enhance the functionality of the

presentation layer.

• Designed the WinForms for the above mentioned windows application.

• Extensive use of multi threading in the distributed computing.

• Developed a windows service as a part of distributed computing based on object oriented principles.

Environment: VS 2005/ 2008, .NET framework 2.0/3.5, C#.NET, SQL Server 2005, SSRS, DevExpress Grid,

Biztalk Server, JavaScript, HTML,CSS, Windows Services, Multi – threading, WinForms, MSMQ,

VBScript, Windows Service, EDI.

Client: Young and Rubicam, NY April 2008 – August 2008

Project Title: Brief Builder

Role: .Net Developer / System Analyst.

Description: Developed a generic brief builder to generate global marketing campaigns for DELL computer.

Interfaced with advertisers and corporate marketers to solidify a coherent brief design that would satisfy

Pranjal Shinde

immediate user requirements in a short development time frame. Implemented an ASP.NET solution on Vista for

extranet access. Developed middle tier business logic in C#. Designed a highly relational schema and

implemented this in SQL Server 2005 with stored procedures. Developed login page interaction with Active

Directory for authentication. The new system contains various levels of approvals for different application, Users

right management, Authorization, Password management based on Active directory.

Responsibilities:

• Interacted with DELL team and gathered software requirements.

• Authentication of the user information against Active Directory.

• Contributed towards the security model in .NET framework for the administration module using

verification process and Role-based security.

• Performed the performance tuning by configuration of IIS logs and SQL Server Transaction Logs.

• Used ADO.NET for SQL Server database interactions using Enterprise Library, Data Adaptors, Data

Reader and Dataset.

• Worked with third party Infragistics GRID to enhance the functionality of the presentation layer.

Environment: C#.net, Web Forms, .net frame work 2.0/3.0, SQL Server 2005 using T-SQL, Windows Vista,

and visual studio 2005, Infragistics 8.2, RAD, Enterprise Library 4.0, Team Foundation Server and Active

Directory.

CLIENT: Mercer HR Consulting, Norwood, MA Feb 2007-March 2008

Project: Leave Management System Role: Sr.Net Developer/ System Analyst

Description: This application offers various levels of approval and authorization as well as automated and

manual provisioning. Leave Management system is the application that will allow the employees to post their

leave requests online and facilitate the managers in efficient leave management, making the entire process quick

and manageable. The reports are meant to be referred by the people soft . The system gives the approver, access to

approve the leave applications and forward it to the next higher level for approval. Every time a leave application

is submitted the system efficiently sends automated alerts through lotus notes, informing the approvers about it.

Interfacing with lotus / domino application using com component [domino object]. The system also

facilitates the approver to log into the system through lotus notes.

Responsibilities:

• Elicit business requirements from business users and subject matter experts.

• Define and document requirements, Analyze and prioritize requirements then write functional and design

specifications.

• Model the requirements/specifications.

• Integrating Lotus Notes R5/Domino object with the application.

• Extensively used Master page, User Controls, Custom Controls and Themes to suit client needs.

• Created UML (Class Diagrams, Sequence Diagrams & Component Diagrams).

• Developed ADO.Net based database access layer against SQL Server Database.

• Made use of Datalist, Data Grid and Repeater Controls to display data in a customized format.

• Validation was done using Validation Controls in ASP.NET, Client side validation in JavaScript.

• Providing technical support to the Database Team, developed SQL queries for data extraction purposes.

• Used Global. asax and Web.config for setting the Application and Session variables.

• Used Crystal Reports for developing reports.

• Cascaded Style Sheet [CSS] was used for UI design.

• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance

testing.

• Thoroughly tested the units, the functionality and the design of the interface.

Pranjal Shinde

• Involved in the complete documentation of the project.

Environment: SQL Server 2005, Visual Studio 2005, .Net Framework 3.0, UML, ADO.NET, JavaScript, Lotus

Notes R5, Crystal Reports.

CLIENT: American Airlines Cargo, Fort Worth, TX Jun 2006 – Jan 2007 Project:

Query Database Role: Senior .Net Developer/

System Analyst

Description: The Query Database is an intranet based web system which provides support to the cargo handling

team to track freight, missing courier, cargo sent to incorrect destination, or any other type of discrepancy. The

database holds the customer information, as well as facilitates and records the details of the actions to resolve

freight and courier queries. Used report server for hosting reports using SQL Server Reporting Services

[SSRS].

Responsibilities:

• Undergone various phases like requirements, analysis, design, functional and technical specification,

coding, and testing and document preparation.

• Involved into workflow preparation, statistical and data analysis.

• Involved in identifying the most efficient solution and preparing the architectural designs for components

using UML using the OOPS concepts.

• Used UML to draw system requirements with Use Case Diagrams, Use Case Scenario, Activity Diagrams

and Sequence Diagrams, identified system functionality and wrote Use Case Narratives for the same.

• Involved in project management activities like scheduling, setting milestones & deadlines and status

reporting for the development team and the Testing Team.

• Used ASP.NET, JavaScript, HTML and CSS to create dynamic web pages.

• Created all the user interface web pages to maintain data flow and data integrity using ASP.NET User

Controls, Web Server Controls.

• Implemented forms authentication in ASP.NET web forms like Login, password, and user authentication.

• Created the necessary Business and Data Layer components in C#.

• Designing the database using complex SQL queries, stored procedures, functions and packages to extract

data from various databases for data analysis and generating reports.

• Implemented SSRS [SQL Server Reporting Services] Package to create reports and host them on the

report server.

• Developed Macros in VBA with MS-Word, MS-Excel.

• Performed Data analysis, Data integration and Data manipulations in SQL.

• Generated test data for unit testing and system testing;

• Worked in conjunction with other testers, developers, and other team maintenance of Quality Standards

in Projects.

• Conducted project related presentations and walkthroughs.

• Used the source control tool Microsoft Visual Source Safe 6.0.

Environment: - C# 1.1, ASP.NET 1.1, JavaScript, T-SQL, SQL Server 2005, SSRS (SQL Server Reporting

Services), UML, MS - Excel, VS-2003, Reports.

CLIENT: WNS Global Services, India Feb 2004- Jun 2006

Project: Exit Interview Application

Role: System Developer

Description: This was an intranet based web application to automate the process of exit interview which goes

through dialogues at several levels and then completing the further exit formalities in the organization.

Pranjal Shinde

Responsibilities:

• Undergone various phases like requirements, analysis, design, functional and technical specification,

coding, and testing and document preparation.

• Involved into workflow preparation, process mapping.

• Involved in identifying the most efficient solution and preparing the architectural designs for

components.

• Involved in project management activities like scheduling, setting milestones & deadlines and status

reporting for the development team and the Testing Team.

• Used ASP.NET, JavaScript, HTML, HTTP, and CSS to create dynamic web pages.

• Created all the user interface web pages to maintain data flow and data integrity using ASP.NET User

Controls, Web Server Controls.

• Implemented forms authentication in ASP.NET web forms like Login, password, and user authentication.

• Designed the Configuration of the System.

• Created the necessary Business and Data Layer components in C#.

• Used ASP screens to host reports and system configuration.

• Created Complex SQL queries, functions and packages to extract data from various databases for data

analysis and generating reports.

• Designed reports using Customized data reports firing queries.

• Performed Data analysis, Data integration and Data manipulations in SQL.

• Generated test data for unit testing and system testing.

• Worked in conjunction with other testers, developers, and other team maintenance of Quality Standards

in Projects.

• Provided hands on training to the Users on the system..

Environment: C# 1.1, Web Forms, ASP.NET 1.1, MS-VISIO, SQL Server 2000, Visual Studio .Net 2003,

JavaScript.

CLIENT: Free India Holiday Tours, New Delhi. Mar 2003 – Feb 2004

Role: .NET Developer

Description: This is the site of tourism displaying the tourist locations of India. Users across the globe can use it

for easy search of various Indian locations, the hotels for accommodation and the travels to go there, book hotels

and travel packages and get the online confirmation. Hotels and travel agents can register with the website to

display their information on the website.

Responsibilities:

• Gathered software requirements from the stakeholders.

• Creating the artifacts like use case Diagrams, Work flow diagram etc.

• Prepared technical design documents.

• Developed server side validations in ASP.Net and C# using the validation controls.

• Developed business logic and data access layer object in C#.

• Cascade Style Sheets were used for Front End Designs.

• Used ADO.net extensively for data retrieving, querying, storage and manipulation.

• Used Validation controls for Text Areas and Text boxes and performed validations on the data prior to

being submitted to the database.

• Performed Unit testing or manual testing on all interfaces developed.

• Responsible for performing data investigations to assess problems associated with the application.

• Good experience in writing stored procedures, triggers user data type.

Pranjal Shinde

• Good experience in writing T-SQL

Environment: C#.net 1.0, Web Forms, ASP.NET 1.0, SQL Server 2000, Visual Studio .Net 2002.

Educational Qualifications:

• Master in Computer Application

• Bachelor in Computer Application

Contact this candidate