.Net Developer Sql Server

TUSHAR PATEL

*** ****** ****, ***#***, Camp Hill, PA 17011

Contact: 813-***-****, 321-***-****, **********@*****.***

PROFESSIONAL SUMMARY

Experience in developing .Net framework applications using C#, VB.NET, ASP.NET, ADO.NET, Web services, Web forms and Win forms.

Extensive knowledge of web UI development using HTML, CSS, JQuery, JavaScript, Telrik controls, Bootstrap and Asp.Net controls.

Hands-on Experience in Writing Complex Queries, Stored Procedures and Triggers in SQL Server.

Expertise in database programming involving Views, Store Procedures and implementation in SQL Server 2005/2008/2012/2014,SQL Anywhere 2012.

Good understanding of Software Development Life Cycle (SDLC), which includes requirements specifications, design specifications, development, testing, implementation, and support.

Good experience in improvement of software process using Agile and waterfall method methodology.

Experience in interacting with B.A. teams and refining the requirement for clarity and simplicity.

Good experience in working with TFS, Perforce, Tortoise GIT (sub version) for source code management.

Experience in coordinating with on site and offshore team members.

Always eager to learn latest technologies and ready to take up challenges.

Able to work under time constrains as effective team player.

Expertise in debugging and solving critical problems.

TECHNICAL SKILLS

Programming Languages: C, C++, C#, Matlab, VB.

Databases: SQL Server 2008/2012, SQL Anywhere 2012, Oracle 11g.

.Net Technologies: ASP.Net, ADO.Net, Web services, WCF, MVC.

Version Controls: TFS, Tortoise GIT, Perforce.

Methodologies: SDLC, OOAD (Object-Oriented analysis and design).

Web Technologies: ASP.Net, HTML, jquery, JavaScript, CSS, Telerik controls, Bootstrap.

Operating Systems: Windows 2000/2003/XP/2008.

Software: MS word, PowerPoint and Excel.

General Skills: Software and hardware installation and troubleshooting.

EDUCATION QUALIFICATION

M.S., Florida Institute of Technology, FL May 2012

Major: Electrical and Computer Engineering. GPA: 3.6

B.E., Shantilal Shah Engineering College (SSEC), India, July 2009

Major: Instrumentation and Control Engineering GPA: 3.8

PROFESSIONAL EXPERIENCE

Client: Deloitte, Camp Hill, PA Jun 2013 – Till Date

Role: Computer Programmer Analyst ( .Net Developer )

General Description:

Deloitte is one the biggest leading company, working in four key business areas audit, financial advisory, tax and consulting by providing services to their client as per need. At Deloitte, Camp Hill we are providing services in one of our four areas - consulting.

Project 1: (PELICAN) Pennsylvania’s Enterprise to Link Information for Children Across Networks (Mar 2016 – Till Date)

General Description:

PELICAN is the ‘Department of Human Services’ initiative to integrate the department’s child care programs under a single management information system. All child care services information is managed in PELICAN. I am working as .Net Developer for PSS (Provider Self Service) phase-3. As part of PSS team, I am involved in enhancement of existing web application. As part of this initiative we are adding new screens, functionality and expanding responsiveness feature to interconnected application page by making it compatible for all devices like mobile, tablets and different sizes of computer screens. PSS is like a dashboard application which will enable child care services provider to connect various child care information systems.

Responsibilities:

Implemented new functionality of web applications using VB as programming language.

Upgraded web UI for application to accommodate different styles and work flow based on user type.

Increased responsive of screen using bootstrap and media query for different screen resolutions.

Used JQuery and Java Script for client side validation.

Designed new screen for performing CRUD operations of email entries by consuming WCF service.

Create mapping functions between service and application objects.

Extensively used ASP Validator for server side validations.

Involved in creating Unit test and testing screen in multiple browser and validating responsiveness using inbuilt emulation option of Google Chrome to test screen for different devices (iPhone 4, 5, 6, 6+, Samsung Galaxy, iPad etc.).

Used ASP literals for toggling of CSS styles on page load based on user.

Extensively used Oracle 11g as database for PSS (Provider Self Service) application.

Used TFS bug tracking tool to fix bugs and attaching unit test results to it.

Used TFS 2012 for source code management of all PELICAN applications.

Collaborated with team members for review and analysis of system requirements.

Project 2: Child Welfare (Jun 2013 – Mar 2016)

General Description:

I was part of child welfare (CW) Team and working as Computer Analyst and .Net Developer. As part of CW team, I was involved in maintenance and enhancement of existing windows and web applications using different technologies and tools.

Responsibilities:

Involved in enhancing the existing application by adding and modifying new features and functions as per the client’s daily requirement.

Involved in development and support for both windows and web applications.

Created setup project for windows application deployment.

SQL Server 2008R2 is used as Child Line database. We were querying data for client as well as part of maintenance and enhancement we were creating and modifying the existing stored procedure and functions.

Crystal Reports are used for reporting of child line.

SSIS packages were created which are now running on schedule for generation of reports on daily certificate print at client office.

Used TFS 2010 for source code management of both windows and web based application.

Automated daily manual report generation task by creating tool and scheduling it on windows scheduler.

Involved in fixing bugs and resolving maintenance tickets.

Code review and unit testing were done as part of release management team.

Experience in working with multiple team for release of application in production environment by creating playbook for tracking.

Tracking and providing instructions for windows and web server migration of all applications as part of technology upgrade.

Involved in installation and post deployment validation of windows application on client machines.

Performed task on TFS like branching, merging, iteration and creating branch lock as needed bases being TFS admin of maintenance team.

Created package XML files as part of TFS build and deployment using existing folder structure requirement.

Modified NANT scripts as part of build and deployment team.

Good experience in working with team environment and providing production support.

Environment:

ASP.NET, ADO.NET, TFS-2010-12, SQL Server 2008-R2-2014, VB.NET, Visual Studio 200*-**-**-**,Windows Applications, .Net Framework 3,3.5-4-4.5-4.6, Microsoft Access 2010, SSIS, Crystal Report 2008, Web Service, WCF, HTML 5, CSS 3, JavaScript, JQuery, Bootstrap, Oracle 11g.

Client: Next Sphere Technologies, FL Feb 2013 – Mar 2013

Role: .Net Developer

Description:

Next Sphere is a software services firm that develops, manages, hosts and maintains applications for companies in a wide range of industries. The task was to enhance existing application for our client Health Axis Group. The objective of the project was to add some features to enrich functionality of the application like adding of benefit index module.

Responsibilities:

Involved in enhancing the existing application by adding new features and functions as per the client requirement.

Extensively involved in design and development of the application using C#.Net, ASP.Net, ADO.Net, Telerik controls.

Experience in enriching application without disturbing architecture of the application i.e. 3-tier.

Worked on Agile environment to meet short timelines with quality deliverables.

Used C# as the base language for the development.

Created stored procedures and tables for the storage and retrieval of data in SQL Server 2012.

Involved in design and development of database.

Used Team Foundation Server (TFS) for source code management to check in and check out the application code.

Developed UI for user to select, enter and search data using ASP.Net and Telerik controls.

Involved in Unit testing and used Bugzilla for bug fixes management throughout the application.

Highly involved in coordinating with on site and offshore team members to understand the requirement and resolving issues related to ongoing project activities.

Environment:

ASP.NET, ADO.NET, CSS, TFS, Bugzilla, SQL Server 2012, C#.NET, Telerik Controls, Visual Studio 2010, .Net Framework 4.

Client: SAP America, GA Oct 2012 – Dec 2012

Role: .Net Developer

Description:

Afaria is the enterprise tool for securing and managing corporate-owned and personally owned mobile devices with your enterprise policies at SAP. These mobile devices include smart phones, computers and other computing devices, such as tablets, and desktop or laptop computers. Afaria provides other tools to solve complex management tasks in a very easier and effective way. Information technology department has full control of all the devices and applications deployed with the flexibility to manage even away from the central console. I worked there as .Net developer as part of development and testing team. The task was to modify the existing functionality of the application by enhancing the application/tool with Email and Messaging feature for mobile devices.

Responsibilities:

Expanded features of existing application as per the requirement to improve the performance and functionality of the application.

Used Version One tool for the management of agile methodology as part of ongoing activity tracking system about daily updates of tasks and also for estimating task as for each sprint.

Used Perforce as Version Control to manage source code and performed tasks related to creating workspace, checking in and checking out the code and also for fetching the latest revision.

Involved in modifying existing WCF services as part of it did API changes.

Used SQL Anywhere 2012 as backend database, created and modified tables and stored procedures scripts as per the functionality of the development of the process.

Extensively Used Telerik controls and ASP.Net controls as part of GUI development.

Development was extensively done using C#.Net as base language.

Added Re-Compliance message setting block to UI and according to that did source code changes to add email and messaging functionality.

As part of testing team used Afaria Admin console and Self-service portal to enroll device to Afaria server.

Developed and tested the application for various scenarios like Single Tenant Single User, Multiple Tenant Single User and Multiple Tenant Single User to achieve the functionality as per the requirement.

Used IOS and Android devices for unit testing and manual testing.

Highly involved in validation of test cases written by QA team.

Involved in coordinating with on site and offshore team members in daily status meeting to resolve issues related to project Activities and to understand testing related issues.

For testing purpose used Bugzilla to post the bugs also involved in fixing those bugs.

Environment:

ASP.NET,CSS, Perforce, Bugzilla, SQLAnywhere 2012,SQLServer 2008,C#.NET,Telerik Controls, Visual Studio 2010, .Net Framework 4,WCF,Version One.

Florida Institute of Technology, FL Oct 2011 – May 2012

Role: .Net Developer (On campus part time/School Project)

Description:

While studying at Florida Tech, I worked in IT department as part time. I worked on a data tracking system application which dealt with what data is accessible to the user and to which building user has access.

Responsibilities:

Involved in designing Web Application which will keep track of all the information about which user will have access to what data and also to which buildings in the campus.

ASP.Net was used thoroughly for designing of the web pages for the Application.

Used SQL Server 2008 as the database of the system to create stored procedure and tables.

Designed Web Service which will communicate with MySQL database to retrieve data according to supplied user name.

Designed Windows Application that will communicate with the web service and will update the Key Software.

C# was the core language of the design and development of the web service and windows application.

My SQL was used as the database for the Application.

Involved in unit testing and integrated testing of the application.

Environment:

C#.NET, ASP.NET, CSS, Visual Studio 2010, My SQL, SQL Server 2008, .Net Framework 4.

Company: Diamond cables Ltd, Gujarat, India. Sep 2009 – June 2010

Role: Jr.Net Developer

Description:

Diamond Cables is an integrated manufacturer of power transmission equipment and turnkey services provider (EPC). I worked on Product management system that dealt with addition, modification or removal of their products. PMS helps to manage the products in a professional manner by allowing the user to specify the specifications for a product. It also helps to track the number of subscribers/members for a particular product with an ability to group it by industry wise.

Responsibilities:

Involved in gathering requirements from end users as well as scope changes.

Created the UI layers and web pages, and integrated them to maintain the performance of data flow and data integrity using ASP.NET User Controls, Web Server Controls.

Implemented ASP.NET View state and Session state to store and transfer data within same pages and to other pages.

Designed and Implemented application using ADO.NET objects like Dataset, Data Table and Data Adapter for manipulating, retrieving, storing and displaying data from SQL Server 2005.

Extensive use of client side scripts using HTML and JavaScript for appropriate balance between the server side and the client browser capabilities.

Created automated Unit test plans using Visual Studio 2008 and performed Unit testing modules according to the requirements and development standards with N-Unit testing.

Used Team Foundation Server (TFS) for Version Control and Source code repository.

Environment:

C#.NET, ASP.NET, ADO.NET, HTML, CSS, Visual Studio 2008, SQL Server 2005, JavaScript, .Net Framework 3.5.

CURRICULAR ACTIVITIES

Active Member of IEEE Eta Kappa Nu – Zeta Epsilon Chapter (Florida Institute of Technology).

Participated in Techno events in college also in poster presentation, cultural events and sports events.

REFERENCES

Available on request.

Contact this candidate