Sql Server .Net

Yogesh Shah *** Arbors Pkwy East, Apt ***, Findlay, Ohio 45840 - United States

Mobile: - 567-***-**** Email: - ***********@*****.**.**

https://www.linkedin.com/in/yogeshshah2184

CAREER SUMMARY:

Results-oriented IT Professional with valuable 11 years of work experience in Microsoft.Net technology with specifically 10 yrs in Windows applications (C# & VB.Net), web applications(Asp.Net MVC, ASP.Net, web services, WCF), 5 years in Service Oriented Architecture (SOA), Publisher Subscriber Architecture (NService Bus & Azure Service Bus) & Data Base (Microsoft SQL server & MS Access).

More than six years of senior software engineering experience, with strong analytical skills and a broad range of computer expertise. Nine years' experience developing, implementing, and managing complex projects within time and budgetary constraints.

Mentored more than 25 consultants and helped them broaden their technical knowledge by guiding on continuous improvement methodologies.

Served 6 onsite positions majorly as a System Analyst.

PROFESSIONAL SKILL SETS:

Programming Languages : Asp.Net MVC, C#.NET, VB.Net, ASP.Net, ADO.NET, SOLID Principles, Azure Service Bus, NService Bus, Test Driven Design

Databases : SQL Server 2012, Oracle 10G, MS-Access

Version Control Tool : Microsoft Team Foundation (TFS), Microsoft Visual Source Safe, Tortoise Subversion(SVN)

Operating Systems : Windows 7

Tools/Platforms : Visual Studio.NET 2005/2008/2010/2012, SQL Server 2012, Service Bus Explorer

Design Patterns : MVP, MVC, Singleton, Factory.

Testing Frameworks : Nunit, FakeItEasy, BDD Gherkin using Specflow

COGNIZANT TECHNOLOGY SOLUTIONS LTD, PUNE (Dec, 2010 – Till Date)

Designation: Associate – Projects

Current Client: Marathon Petroleum Company (Working on Asp.Net MVC, C#.Net, SQL Server 2012)

Have been designing various UI screens that are used in the kittyhawk application by using ASP.NET MVC as there has been extensive use of Kittyhawk application which is a middleware application that receives data from multiple sources, formats it and displays it on UI and sends it to Right Angle i.e. a sort of database.

Initiated work by using NServicebus as a publisher-subscriber pattern to develop services that interact with different modules that has helped in enhancing the scalability.

Implemented SOLID principles to improve code quality upto 40 %.

Used TDD to test and implement the business logic.

Client: ASOS – Fashion (Worked on ASP.Net, C#.Net, SQL Server 2008 R2 from July, 2012 till Feb, 2016)

Developed “Dispatch Import Service” which used to read xml sent by warehouse containing information of dispatched or unable to ship items.

Used Nservicebus & Azure service bus as publisher subscriber architecture to publish and handle dispatched or unable to ship event thereby enhancing the overall scalability and performance.

Used MVP design pattern to develop different modules like STOCK Engine, Zonal Pricing and various enhancements like cookie law, basket clear down performance etc.

Used SOLID principles and Winsor Castle as dependency injection tool to improve the code quality.

Used N-Unit, FakeItEasy and specflow frameworks for unit and integration testing.

Achievements:

Received Hats Off award for recognition of outstanding contribution and excellent performance.

Client: Tobin Enterprise Land (Worked on C#.Net, Oracle 10g from Dec, 2010 till June, 2012)

Designed “E-Calendar” module for land users to give recommendations on leasing events that happen over a period of time.

Implemented 12 different UI screens using model view presenter design pattern for E-Calendar module’s functionality.

Used infragistic grid for designing UI.

Achievements:

Received the Rain Maker Award for successful delivery of E-Calendar Enhancement.

Received a hand written appreciation note by client and memento sent all the way from Houston, Texas, US to Pune, India

GEOMETRIC SOFTWARE SOLUTIONS LTD, PUNE (Aug 2007–Dec 2010)

Designation: Senior Software Engineer

Projects Undertaken:

A.Client: Good Year Tire and Rubber company (March, 2008 – Dec, 2010)

Cured Manual Code Generator (Worked on VB.Net)

Designed MDB based application to create two code (.vb) files called Declaration File and Collection File.

Made various provisions to add, edit and delete Manual Attributes, Components, Database Objects, Functions, Variables and Namespaces.

Created User Control to arrange sequence of items within a listbox.

Designed relational database for the application.

Cured Green Workbench Manual Development:

Implementation of Specifications for various components of Tire given by Client.

Developing generic functions for common set of attributes for which standard processes are defined.

Development of Stand Alone Applications required by Client.

Creation of Unit Test Plans (UTP) and Unit Test Report (UTR) for all the attributes of all the components.

B.Geometric Online Test : (ASP.Net, SQL Server 2005, VB.Net)

Design of an Intranet Test for domain specific certifications within the company.

Generation of Random Questions and calculation of attempted answers and correct answers.

Maintaining database containing the certification questions and test records for all employees.

Display the results in terms of Correct Answers, Percentage and Gradation for the test.

INCAT, A Tata Technologies Company, Pune (July 2005 – Aug 2007)

Designation: Solutions Developer

Projects with client Tata Motors, Pune:

A.Dot Net Based Component For Vehicle Diagnostics: (VB.Net)

Design of Reusable Dot Net Component to be used for development of all the Diagnostics Software.

Implementation of Serial Port Control within the component to communicate between Computer and Engine Control Unit (ECU) via K-Line Protocol.

Provision for sending request and receiving response through single command.

B.Vehicle Diagnostics of FIAT ECU (Engine Control Unit): (VB.Net)

Design and implementation of Visual Basic Dot Net tool for Diagnostic of Fiat ECU and display of different Engine parameters.

Implementation of communication between Computer and Engine Control Unit (ECU) via K-Line Protocol.

Use of VB.Net for the generation of Diagnostic Report.

Plotting of Run Time Graph to display the variation of Parameter against Time.

C.Vehicle Data Logger: (VB.Net, ADO.Net, MS Access Database)

Design and implementation of VB.Net tool to transmit data from vehicle data logger hardware unit to VB.Net Application, which gives the values of Engine parameters such as Engine RPM, Vehicle Speed, Engine Temperature etc.

Implementation of Two Way Communication on Serial Port.

Design and Storage of uploaded data in MS Access Database using ADO.Net.

Generation of 7 reports in Excel Sheets.

EDUCATION DETAILS:

Qualification

Institute

University

Percentage

Grade

Year of Passing

B.E Electronics & Telecommunication

Government College of Engineering, Pune

Pune

University

65.86%

1st Class

July 2005

Diploma in

Industrial Electronics

Shreeram Polytechnic, Airoli, Navi Mumbai

Maharashtra Board

81.05%

Distinction

June 2002

S.S.C

Bharat Bharati Convent, Malkapur

Amravati Board

75.73%

Distinction

June 1999

PERSONAL INFORMATION:

Date of Birth: 2nd January 1984

Onsite Experience:

Sr. No

Location

Company

Client

Period

1

Findlay, United States of America

Cognizant Ltd

Marathon Petroleum Company

Feb 2016 – Till Date

2

London, United Kingdom

ASOS

Sep 2013 – Sep 2014

3

London, United Kingdom

Sep 2012 - Oct 2012

4

Luxembourg, Europe

Geometric Ltd

Goodyear Tire and Rubber Company

Nov 2009 - July 2010

5

Akron, United States of America

Jan 2009 - Apr 2009

6

Akron, United States of America

Apr 2008 - Jun 2008

References: Available on Request

DECLARATION:

I hereby certify that the foregoing information is genuine to the best of my knowledge and belief.

Place: Findlay, Ohio, United States

Date: 6th May, 2016 Mr. Yogesh P. Shah

Contact this candidate