Resume

Sign in

Project Sql Server

Location:
Jersey City, New Jersey, United States
Posted:
December 01, 2016

Contact this candidate

Prabodh Sawant

acxqc1@r.postjobfree.com

+* 732-***-****

EXPERIENCE SUMMARY:

A dynamic full stack professional with 10+ years of rich experience in Software development, Systems Analysis and Systems Design with descent knowledge of C#.Net, VB.Net, ASP.Net, AngularJS, JQuery, Bootstrap, Javascript, LINQ, WCF 4.0, SQL2008 R2, MVC and Agile on both Windows and Web platforms.

Proficient at developing complex business applications using SCM, Healthcare, Custody and Finance domain with latest technologies & experience of developing service standards for technical excellence.

Extensive knowledge of Object Oriented Analysis and Design (OOAD), Service Oriented Architecture (SOA), Design Patterns like MVC, database design including query optimization, creating tables, views, stored procedures, triggers and functions etc.

Very well versed with all phases of Software Development Life Cycle (SDLC) and involved with end to end software development

Established expertise in creating web based applications using technologies like ASP.NET, Java Script, XML, AngularJS, HTML. Worked on Angular JS frame work in various projects.

Experience in using ADO.Net data controls like Dataset, Data Reader, Data Adapter, Data Grid, Grid View, Tree View and Data List

Good experience in converting the business requirements into technical specifications and proficient in designing systems.

Experience with Authentication and Authorization .NET security mechanisms

Excellent experience in developing, consuming WCF and configured end points and have a good knowledge regarding Service-Oriented Architecture, APIs, JSON etc.

Experience in designing and developing Databases in SQL Server which includes the development of functions, stored procedures, views, joins and triggers using T-SQL and PL/SQL.

Good experience in understanding SWIFT messages like MT 540, 541, 542, 543.

Good experience and knowledge in AJAX for partial page execution and asynchronous data transfer from web server to the client.

Experienced in designing reports for Web Applications using Crystal Reports and SSRS and also worked on SQL Server Integrating System (SSIS).

Experience in utilizing UNIT testing framework and followed Test Driven Development (TDD) on DevOps servers to develop the Web applications for verifying the code integrity.

Very good experience with Agile/SCRUM development and ADO.NET Entity Data Model.

Good at web services in visual Studio. Experienced in implementing waterfall and incremental model in the Software Development Life Cycle.

Experienced with Microsoft Application building blocks for .Net projects (Data Access, Exception Handling, Caching and Configuration Management Application Blocks).

SOFTWARE SKILLS:

Expertise

Details

UI Technologies

AngularJS, JQuery, Bootstrap, JavaScript, HTML5,

Languages

C#.Net, VB.Net

Tools

Visual Studio 2015/2010, SQL server management studio, TOAD, JIRA, On Time 2010, Version One

Database

SQL 2012/2008/2005, Oracle 9i/10g, PL/SQL, MYSQL, MS Access

Web Techonology

HTML/CSS, MVC, WCF

Web and Application servers

MS Internet Information Server (IIS)

Development Tools(IDE)

Microsoft Visual Studio, SQL Server Management Studio, MS Visio

Modelling Tools

UML & Rational rose 98 /2000, MS Visio

Configuration Management Tools

TFS, Visual Source safe, SVN

Reporting Tools

Crystal Reports 8.5/2008, SSRS

CERTIFICATIONS:

Microsoft Certified Technology Specialist in Windows Communication Foundation (WCF)

PROFESSIONAL EXPERIENCE

Client/Customer : Coach Inc.

Project Title : ClienTrack

Role : Technical Lead/Sr. Software Developer

Duration : 06/09/2016 – Till date

Location : New York

Skills used : C#.Net, ASP.NET with Framework 4.0, AngularJS, JQuery, Bootstrap, HTML5, SQL2012

Team Size : 6

Project summary:

ClienTrack is web application used in Coach Stores across United States to collect customer information, maintain follow ups and appointments and generate daily reports. This project was focused on migrating data from SaleForce to ClienTrack and introducing new features like ability to schedule appointments, reminders, advance address book search etc.

Responsibilities:

Met with all businesses to discuss BRD’s and decide the scope as this was complete revamp of old web application using latest technologies without touching the existing functionality.

Conducted thorough analysis of application and proposed development timelines.

Designed and owned Appointments module and its reports.

Introduced responsive design using Bootstrap and AngularJS and complete migration of old VB Scripts code to JQuery wherever possible.

Involved in data migration plan from SalesForce to ClienTrack.

Developed batch processes (console applications) like Appointment reminder creation, load repair followups, Monogram Loader etc. to support daily business processes.

Led business UAT and resolved defects on time. Used JIRA for defect logging and reporting which resulted in smooth completion of UAT.

Client/Customer : General Electrics

Project Title : GE GSL Standardization and Simplification

Role : Project Lead

Duration : 11/15/2013 – 05/20/2016

Location : Schertz, TX

Skills used : C#.Net, ASP.NET with Framework 4.0, Scrum, AngularJS, Agile, SSRS

Team Size : 18

Project summary:

Standardization and Simplification was entirely focussed on bringing all business workflows used by GE for end to end supplier on boarding on one single workflow which was major step towards making configuration and maintenance extremely simple. This project entailed complete SDLC activities having configuration as centre for all of activities.

Responsibilities:

Met with all businesses across the globe to explain the benefits of one single solution for all, understand and finalize their requirements

Followed Agile methodology and executed the sprints to deliver agreed product backlog with product owner

Developed Use case, Sequence, Activity diagrams using MS Visio.

Used technologies like C# and ASP.Net, WCF services to design and deliver end to end solution for all businesses.

Involved in database design like deciding tables and view structures, writing queries, joins and stored procedures etc.

Involved in integration with different ERP systems like Supplier Shared Services (SSS) and SAP and agreed on the XML structure to be used by all teams for smooth integration.

Worked as a scrum master and conducted daily scrum calls with the scrum team to keep sprint items on track and deal with any roadblocks

Involved in load and performance testing of the application and bug fixing throughout the process.

Involved in report creation using SSRS as per the business requirements.

Used TFS for version controlling, branching, merging and configuration.

Worked on the resolution of cross browser issues.

Created WCF services using Service oriented architecture and handled instance and concurrency management.

Prepared Go-live communication plan for different stakeholders and completed successful delivery of the project

Client/Customer : Humana

Project Title : Humana GB PSM

Role : Project Lead

Duration : 01/01/2013 – 11/25/2013

Location : Mumbai, India

Skills used : C#.Net, ASP.NET with Framework 4.0, WCF, Web services, SQL Server 2008, SSRS

Team Size : 44

Project summary:

This is all about supporting and maintaining all Humana operations through Green bay city. The combination of three teams Workflow, Account Manager and Dental-Solar. Main aim was smooth settlement of claims generated for Humana through different sources like text files, emails, faxes, scanned documents etc. Developing and supporting different web and windows applications in order to run smooth claim settlement process and maintain Humana star rating by avoiding any discrepancies. This was the one single team maintaining three different areas of Humana.

Responsibilities:

Leading team of 20 software engineers and providing technical guidance as well and individual contributor.

Created UML diagrams like use case, sequence, activity and technical specifications

Responsible to drive KANBAN model for entire project and completing monthly target as per SOW.

Following agile model and participation in sprint estimation meeting and weekly review meetings, release meetings.

Developed UI pages using ASP.NET, MVC3, HTML, Razor engine, VB.NET, used html input, literals, table as the controls for razor pages

Developed cross browser compatible, customer facing online application based on n -Tier architecture.

Involved in bug fixing and delivering new user stories created by business users and getting the UAT done.

Using technologies like SSRS, WCF, Web services, ASP.Net, C#, SQL2008 and Service oriented architecture

Created SQL database objects like tables, stored procedures, views, functions, triggers.

Worked on SQL query optimization and stored procedure logic optimization.

Leveraged MVC design pattern to organize AngularJS controllers, directives and views in the various pages.

Used CSS style sheets to make UI controls look same across the application

Used TFS for version controlling, branching, merging and configuration.

Worked on the resolution of cross browser issues.

Involved in Interaction with BA team on a by-weekly basis to gather requirements and also involved in creating Business Requirements documents (BRDs) based on Requirements

Used SQL Server Reporting Services (SSRS) for providing comprehensive reporting functionality for variety of data sources for the project.

Used LINQ to keep standardized way of accessing multiple data sources.

Used AJAX for partial page execution and asynchronous data transfer from web server to the client.

Client/Customer : Humana

Project Title : Humana Workflow

Role : Project Lead

Duration : 10/14/2011 – 12/31/2012

Location : Mumbai, India

Skills used : C#.Net, ASP.NET with Framework 4.0, WCF, Web services, SQL Server 2008, SSRS

Team Size : 20

Project summary:

This is workflow system designed for Humana US based healthcare payer. Consists of various applications including web/windows applications, web/WCF/windows services. Main aim was smooth settlement of claims generated for Humana through difference sources like text files, emails, faxes, scanned documents etc. Developing and supporting different web and windows applications in order to run smooth claim settlement process and maintain Humana star rating by avoiding any discrepancies.

Responsibilities:

Leading team of 20 software engineers and providing technical guidance as well and individual contributor.

Responsible to drive KANBAN model for entire project and completing monthly target as per SOW.

Following agile model and participation in sprint estimation meeting and weekly review meetings, release meetings.

Involved in bug fixing and delivering new user stories created by business users and getting the UAT done.

Handling KANBAN retrospective meetings from Syntel side.

Using technologies like SSRS, WCF, Web services, ASP.Net, C#, SQL2008

Developed UI pages using ASP.NET, MVC3, Razor engine, VB.NET, used html input, literals, table as the controls for razor pages

Developed cross browser compatible, customer facing online application based on Service oriented architecture architecture.

Leveraged MVC design pattern to organize AngularJS controllers, directives and views in the various pages.

Used CSS style sheets to make UI controls look same across the application

Used TFS for version controlling, branching, merging and configuration.

Worked on the resolution of cross browser issues.

Involved in Interaction with BA team on a by-weekly basis to gather requirements and also involved in creating Business Requirements documents (BRDs) based on Requirements

Used SQL Server Reporting Services (SSRS) for providing comprehensive reporting functionality for variety of data sources for the project.

Used LINQ to keep standardized way of accessing multiple data sources.

Used AJAX for partial page execution and asynchronous data transfer from web server to the client.

Client/Customer : Mauritius Commercial Bank – Custody Services

Project Title : Custody Plus

Role : Senior Software Engineer

Duration : 01/01/2010 – 10/07/2011

Location : Mumbai, India

Skills used : C# with Framework 3.5, WCF, SQL Server 2008, SSRS, Telerik controls

Team Size : 20

Project summary:

This is a custody back-office system being re-written using the latest technologies like C# (3.5), SQL Server 2008, WCF etc. It is complete software package to maintain customer portfolio details and quick reporting. It is used to generate various messages including SWIFT messages and report positions of any account.

Responsibilities:

Mapping requirements into deliverables, preparing functional specifications and providing customized software solutions.

Preparing business test plans to test final product before release to client.

Researched new technologies like WCF and LINQ and was instrumental in the adoption of these technologies by the company for development of our new product.

Designed service oriented architecture in order to consume business components over the web.

Designed flexible database access layer to connect multiple RDBMS like SQL and Oracle.

Actively involved in coding and designing using C#, XML, ADO.NET, LINQ and SQL 2008.

Created complex business reports using SSRS.

Developed and optimized stored procedures and trigger using SQL 2008.

Used Team foundation server (TFS) for version control, branching, merging etc.

Involved in performance testing and fixing the bugs

Worked on Telerik Controls and theme engine to give unified look to UI controls across the application.

Developed key modules and played complete role in designing Use case, flow chart, ER diagram, technical specification and actual development.

oContainer screen to provide central login for all accessible applications.

oBase form from which all maintenance screens can be inherited.

oAlert mechanism using WCF duplex communication to notify user upon any event occur in the system.

oTheme engine to centralise appearance of all controls and screens.

oMessaging framework to provide central communication point to send messages like email, fax, SWIFT, sms etc.

oBase Data Access layer to provide flexibility to communicate with multiple RDBMS like SQL and Oracle.

Client/Customer : Barclays and Standard Chartered

Project Title : C2K Diagnostic Tool

Role : Senior Software Engineer

Duration : 10/01/2009 – 12/15/2009

Location : Mumbai, India

Skills used : VB.Net with Framework 2.0, SQL Server 2000, Telerik controls

Team Size : 2

Project summary:

This application upon running scans the user’s machine and generates report to display current state of all the parameters/settings required by Custody 2000 application. This application is used to understand the system status and feasibility to deploy Custody 2000 on user machine and enables installer to take appropriate action before deploying the software on user machine.

Responsibilities:

Prepared functional specification, technical specification to define the scope of an application.

Developed entire application and taken responsibility of it.

Designed future oriented architecture in order to consume business components over the web.

Used ADO.Net objects like DataAdapter, DataReader, DataSets, DataTables etc. to deal with back end data.

Created tables, written queries using multiples joins and sub queries, stored procedures, triggers etc.

Actively involved in coding and designing using VB.Net, XML, ADO.NET, LINQ and SQL 2008.

Created complex business reports using crystal reports 2008.

Used Team foundation server (TFS) for version control, branching, merging etc.

Client/Customer : Barclays Securities

Project Title : SWIFT Gateway

Role : Senior Software Engineer

Duration : 02/15/2008 – 09/17/2009

Location : Mumbai, India

Skills used : C#.Net with Framework 2.0, WCF, SQL Server 2008, Telerik controls

Team Size : 5

Project summary:

This application is responsible for sending, receiving and processing SWIFT messages. The messages are generated as text files and are dropped in shared folders from which third party SWIFT services pick them. Similarly application monitors the shared folder for incoming files and pick up and processes them to create/settle trades in the system. It was a WCF service hosted in Windows form application.

Responsibilities:

Prepared functional specification, technical specification to define the scope of an application.

Used ADO.Net objects like DataAdapter, DataReader, DataSets, DataTables etc. to deal with back end data.

Created tables, written queries using multiples joins and sub queries, stored procedures, triggers etc.

Actively involved in coding and designing using C#, WCF, ADO.NET, LINQ and SQL 2008.

Developed and optimized stored procedures and trigger using SQL 2008.

Used windows FileSystemWatcher to monitor SWIFT messages.

Used Team foundation server (TFS) for version control, branching, merging etc.

Involved in performance testing and fixing the bugs.

Client/Customer : Hindustan Co-op bank Ltd. (All Mumbai branches)

Project Title : Core Banking System (CBS)

Role : Software Engineer

Duration : 05/15/2006 – 12/31/2007

Location : Mumbai, India

Skills used : VB.Net with Framework 2.0, SQL Server 2005, crystal reports

Team Size : 15

Project summary:

The system stores all details of customers of banks, account information, day to day transactions and gives all banking reports. The system gives facilities like online transactions, any branch banking, online ATM facility, Net banking.

Responsibilities:

Developed modules like Cashier, Daily transactions etc.

Used ADO.Net objects like DataAdapter, DataReader, DataSets, DataTables etc. to deal with back end data.

Created tables, written queries using multiples joins and sub queries, stored procedures, triggers etc.

Developed complete Audit Trail System for this banking application using CLR Trigger which led to easy maintenance and rapid development.

Involved in performance testing and fixing the bugs.

ACADEMIC QUALIFICATION:

PGDBA

(Welingkar’s institute of management) Nov 2013

Microsoft Certified Technology Specialist Feb 2011

(Windows Communication Foundation)

Bachelor of Science in Information Technology May 2006

University of Mumbai



Contact this candidate