Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Camp Hill, PA
Posted:
July 16, 2015

Contact this candidate

Resume:

MAYUR THAKKER

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

(201) 982 – 0077 acqsbi@r.postjobfree.com

Looking to make a difference in the field of information technology; would like to be known as a professional with an instinct for understanding software engineering dynamics and an inherent ability for developing highly innovative and effective software solutions; currently seeking a challenging position as Program Analyst in a growth oriented firm.

Summary:

Over 8+ years of experience in Analysis, Design, Development, Management and Implementation of

Various web/window based applications, intranet portal and database application.

Good knowledge and hand on experience of all stages of software development life cycle.

Hands-on experience in developing Web Applications in .NET Framework, Using ASP.NET, SQL Server.

Experience in developing windows Application in VB.NET and C#.

Worked extensively with Data Adapter, Dataset, Data Table, Data reader as a part of ADO.Net to

Access and update database.

Experience in Web Services, WCF, SOAP, XML, XSLT, DTD, XML Schema, CSS, DOM, HTML.

Experience in developing web application using VB script, Java script, XML.

Extensive experience in SQL Server Database Design, developing T-SQL queries, Stored Procedures, and Triggers using SQL server.

3+ years of experience in developing applications using VISUAL BASIC 6.

Worked in TDD (Test Driven Development) Environment with NUnit.

Used SQL Server tools such as SSIS, SSRS, and SSAS.

Used XML for storing and transporting data among different systems.

Worked in Agile Methodology with Scrums and Pair Programming.

3+ years of experience in developing web applications using Classic ASP.

Performed Input validation using ASP.NET Input Validation Controls like Required field Validator,

Range Validator, Regular expression Validator, Compare Validator, Custom Validator and Validation

Summary.

2+ years of experience in developing applications using Continues Integration (CI) System

Good Experience in using TFS, VSS and SVN as source control.

Experience in maintaining Active Directory Application Mode (ADAM) Server.

Strong knowledge of Object Oriented Design Methodologies (OOD).

Used T-SQL languages for writing Stored Procedures, Triggers, Indexes, Functions and Complex queries.

Good experience in converting the Business Requirements into Technical Specifications.

Excellent in Structured methodology in software development Life cycle using Agile

Methodology, UML and Use Cases.

Excellent analytical and problem solving skills. Hardworking and enthusiastic with excellent

Communication and interpersonal skills and strong interest to learn new skills.

Skills:

.NET Framework

.NET Framework 4.0, 3.5, 3.0,2.0, 1.1, ADO.NET, ASP.NET, XML, Classic ASP

Environment

Visual Studio 2003/05/08/10/13, VB6

Languages

VB.NET, T-SQL, C#, Java script, VB script, Windows Script

Data bases

SQL Server 2005,2008, 2012

Source Control

SVN, VSS, TFS

Other Tools

MS Visio 2007 & 2010, Mockup Screen, Lucid, Fiddler, SSIS, SSRS

Hands On Skill

SSAS, SOAP, MQ Server, FTP Server, Active Directory(ADAM)

Operating Systems

Windows Xp, Vista, 7

Work Experience:

Sr DotNet Programmer, Department Of Corrections, PA JULY 2012- Current

The Department of Corrections (DOC) is responsible for overseeing the operation for 26 state correctional institutions, one motivational facility, 14 community corrections centers, nearly 40 contract facilities. DOC has more than 51,000 inmates. Department Of Correction (DOC) And Parole Board Of Probation PA (PBPP) has various application for inmates and Paroles which is maintained by Department Of Correction (DOC). Applications are in different environments from Classic ASP to ASP.NET as well as desktop application from vb6 to vb.net. New Development and Maintenance are primary things related with the this project.

Responsibility:

Used ASP.NET, HTML in designing front end and SQL Server 2005, 2008 & 2012 as back end.

Used VBScript to validate the client-side applications.

Developed the Application using Agile Development methodology.

Designed and modified the database tables and wrote complex SQL queries, Stored Procedures and User Defined Functions in SQL Server.

Designed of WCF based Service, Data, Fault and Message Contracts.

Used various data controls grid view, multi view and detail views for creating user controls.

Configuration of Bindings.

Used XML technology to store and fetch data using stored procedure from SQL Server.

Maintained ADAM Server – LDAP (Active Directory Application Mode) for user Information, Security and Service Policies.

Developed applications using Vb.net and VB6.

Wrote DML and DDL statements for SQL Server.

Used Replication Quab to get and Post data with Mainframe.

Coded arithmetic functions in JavaScript for the ASP.NET application.

Used RDL, RDLC, PDF and SSRS Reports to generate various Reports.

Used Remorting for various application to access the other services.

Created SSIS Packages to share the inmate data across other agencies.

Used SQL Profiler to analyzed and diagnose Application Flow.

Developed applications using Continues Integration (CI) System.

Worked on Team Foundation Server and Visual Source Safe.

Involved in Applications Deployment on Various Servers.

Working Knowledge of MQ Server and FTP Server.

Created design documents and technical specifications.

Interacted with Project Managers, Clients and team members to understand the business process.

Actively participated in the status view meetings.

Ensured project deadlines and milestone met.

Modified applications according to the client requirements.

Responsible for fixing the defects received time to time from testing team and Involved in enhancement and supporting the application.

Conduct application testing based on test cases and test plans.

Created Impact analysis documents for new development.

Environment:

VB.NET, ASP.NET 4.0, 3.5, 3.0, 2.0, 1.1, CLASSIC ASP, CSS, SQL server 2005/08/12, HTML, ADO.NET, Visual Studio 2010/05/03/VB6, VSS, TFS, MQ Server, FTP Server, Active Directory

Software Engineer, First Internet Systems, NJ JAN 2011- JUN 2012

First Internet Systems is NJ based Software company. Time and Bill Tracking application is an online application for billing, payroll and cost accounting. Features job estimation, a desktop application and customizable reports. Tracking features include cost and billing rates, timesheets, generating and sending invoices, billing approvals process and time tracking reports. Once reported, this data can be used for multiple purposes, such as calculating the monthly working hours of employees, seeing who’s overloaded and who’s underutilized, or calculating the total effort invested on certain project.

Responsibility:

Setup systems for Customer Demos.

Developed Web Forms, Components in ASP.NET using C#.

Developed Data Interacting pages to Update and Maintain Info using ADO.Net technology.

Responsible for the analyses of the requirements of the business, designing database tables using MS Visio.

Developed shortest distance to find Project using Web services, WPF, MVC, LINQ and WCF.

Developed the application using Visual Studio 2008 with C# Win Forms.

Writing or modifying Stored-Procedures, Triggers and user defined functions in SQL to carryout database operations Provide technical support.

Created reports for more data visualization and used multidimensional entities by using SSRS.

Used various data controls gridview, multiview and detail views for creating user controls.

Used MS Visio and Lucid charts to make ERD and UML charts.

Used Mock Screen to show the Screen Layouts of UI.

Coded arithmetic functions in JavaScript for the ASP.NET application.

To enhance the project quality used Pair Programming.

Used J Query for calling web services and client scripting.

To make it more simpler made GUI

Interacted with developers and team members to understand the business process.

Ensured project deadlines and milestone met.

Actively participated in the status view meetings.

Modified applications according to the client requirements.

Created web service for some of the functionality.

Environment:

C#, ASP.NET 3.5, CSS, SQL server 2008, J Query, HTML, ADO.NET, Visual Studio 2010, SVN

Program Analyst, Sun Trust, GA DEC 2009- DEC 2010

Sun Trust is bank holding company located in GA. The heart of the application is Sales/Trade matching that automates trade capture, trade routing between legal entities, allocations, and back-to-back trade generation. Once the transaction has been generated from GUI, software converts the data into vendor specific format using various adapters and then passes it to Transaction Server to match the trade.

Responsibility:

Analyzed system and prepared documentation using VISIO.

Designed and developed database as per client’s requirements.

Used ASP.NET, HTML in designing front end and SQL Server 2005 as back end.

Server side and client side scripting to validate data using VB Script.

Designing ASP.Net Pages using various user controls.

Made the connection and get the data from different data source using SSIS, and created analysis cubes using SSAS.

Used cookies and forms authentication for the security purpose.

Written stored procedures and triggers for maintaining and interfacing with the database.

Involved in preparation of test cases.

Back end integration using ADO objects and coded a centralized class module for data access/update routines.

Created UML Diagram using Lucid.

Created reports using SSRS.

Participated in analyzing the system requirements and developed a detailed test plan to test functional, security and performance requirements of the application.

Environment:

VB.NET, ASP.NET 3.0, SQL server 2005, Java Script, Lucid, SSRS, ADO.NET, SSIS, SSAS

Junior Developer, Ekkay Magic India Pvt Ltd JAN 2008- OCT 2009

Ekkay Magic India Pvt Ltd is total software solutions, Energetic and innovative companies, based in India They developed a web based applications for a real estate client.

Responsibility:

Designed and implemented the re-usable components as ASP.NET WEB SERVICES.

Developed web application in 3-tier architecture.

Developed data access layer and business logic layer using ADO.NET and C# and using SQL Server 2005 as back end.

Used ASP.NET Validation controls and JavaScript to perform client side validation.

Developed Master Pages, User Controls, and Custom Controls for presentation layer.

Used .NET Navigation Controls such as Site Map Path, Tree View, and Menu Control.

Extensively used CSS, and Master Pages to maintain and enhanced the identical look of the application.

Used Data Set, Data Table, Data Adapter, and Data Readers to access data.

Extensively used Grid View, Data List, Repeater, and List View to display data.

Used Form based Authentication to authenticate users.

Environment:

Microsoft Visual Studio 2005, ASP.NET 2.0, c#, MS SQL server 2005, JavaScript, XML, CSS, ADO.NET, Crystal Report

Program Analyst, IPCL JUN 2007 - DEC 2007

IPCL is located in India. It is government owned Petrochemicals Corporation. IT Services department of IPCL with their day-to-day operations and will interface with the Workflow management system to function as a complete Workflow and Data Entry product.

Responsibility:

Used Created Master page, CSS to maintain consistency in the look and feel of the web application.

Writing the codes using VB.NET

Manipulative ASP.NET Pages using various user controls.

Have used cookies and forms authentication for the security purpose.

Back end mixing using ADO objects and coded a centralized class module for data access/update routines.

Developed Data Interacting pages to Update and Maintain Info using ADO.Net technology.

Written stored procedures, triggers, T-SQL queries, functions in SQL server

Environment:

VB.NET, SQL server, CSS, ASP.NET



Contact this candidate