Sql Server .Net

Deepak Chawla

Email: **************@*****.***

Phone# 404-***-****

Experience Summary:

Microsoft Certified Technology Specialist with over 9 years of experience in executing full project life cycle including System Study, Analysis, Project Planning, Technical Design, Development, Testing, Implementation, Maintenance and Support.

Extensively worked on SharePoint 2010 & 2013, to create custom web parts as well as OOB web parts, custom workflows and designer workflows, InfoPath forms, event handlers, master pages.

Have done migration from SharePoint 2010 to SharePoint 2013 on premises.

Have done migration of SharePoint 2010 to Office 365.

Have exposure to Migration tools like Metalogix, Metavis & Avepoint.

Have hands on experience for writing client side code for SharePoint pages using JavaScript & JQuery.

Good understanding of CAML Query & LINQ.

Have extensive experience in working with SharePoint Designer.

Have hands on experience with PowerShell scripts.

Hands on experience in maintaining health of SharePoint farm.

Extensively developed web based applications using ASP.NET, C# .NET, ADO.NET, WCF, T-SQL and XML.

Strong Object Oriented Analysis and Programming skills.

Extensive experience with database development using SQL Server and Oracle.

Proficient in analyzing and translating business requirements to technical requirements.

Strong skills in working with version controlling tools using SVN and VSS.

Good experience in handling multiple projects within the timelines.

Ability to learn new technologies and challenging concepts quickly and implement them.

Excellent analytical, problem solving, decision-making and presentation skills with ability to co-ordinate activities in a fast paced team environment.

Ability to work productively and effectively in a team as well as individually to meet the Project deadlines.

Experience in using third party tools like Dundas Dashboard, Bamboo Web parts.

Extensively involved in interacting with clients and various technology teams in analysis and resolution of production issues.

Expertise in database development, creating complex stored procedures, user defined functions and triggers using Microsoft SQL Server 2005.

Experience in end-to-end full lifecycle (SDLC) of software developments, including configuration management using Visual SourceSafe.

Excellent communication and interpersonal skills.

Technical Skills:

Programming Languages

.NET 1.1/2.0/3.5, C#.Net, ADO.Net, SQL,T-SQL, PL/SQL, XML, HTML5, SSIS, MVC FrameWork, VB.NET

Web Technologies

ASP.NET, Ajax, WCF, Web Services, CSS, JavaScript, JQuery

DataBase

SQL Server 2005/2008

Operating Systems

Win 2012,2008, Win7

Enterprise Solutions

O365, SharePoint 2013, SharePoint 2010, MOSS 2007, Great Plains 9.0

Miscellaneous

MS VSS, SVN, SharePoint Designer, InfoPath Designer

Technical Certification:

Microsoft Certified Technology Specialist in .NET Framework 2.0 and Web Development.

Educational Qualification:

M.C.A. (equivalent to M.S) in Computer Applications 2005, from Punjab Technical University, Jalandhar, India.

Work Experience:

Present: Atlanta Public School (Atlanta, GA) April 2015 – Till Date

SharePoint Developer & Administrator:

Following are projects undertaken by me during my tenure at APS to help organization achieve its goal to become more effective and paperless:

Provisioning of OneDrive’s for students: Wrote PowerShell scripts to provision one drives for students, to check students for whom one drives are not provisioned, to provision user profiles for new students.

Digital Signatures: Did POC for integration of in-house Digital signatures as well as Cosign (3rd Party Vendor) for digital signatures.

Pre Migration Activities (From 2010 to 2013): Wrote PowerShell scripts to do following as a part of pre-migration activities:

1)Did study to figure out suitable approach between migrate and upgrade.

2)Suggested H/W and S/W for new environment.

3)Installed SharePoint farm on new test environment.

4)Wrote PS scripts to find large lists, and move old data from root folder to archive folder and subfolders.

5)Wrote PS script to create inventory of Sites, users, site owners, site usage, last updated etc. for cleanup purposes.

6)Find out customizations installed and planed on how to deal with these.

7)Create inventory of servers.

Migration from 2010 to 2013: Planned database attach upgrade, define best practices and strategy to do the upgrade. This step is under process, where we are doing upgrade on test environment to make actual migration experience smooth.

InfoPath Forms: I have convert multiple manual paper forms into digital forms with InfoPath and SharePoint designer workflows to ensure more efficient, reliable & better collaborated solutions. My roles were to gather requirements, deliver solutions in iterations and get it accepted by user.

.

Daily Activities: Work on daily Service/Incident tickets logged in “HEAT”, Manage sites, permissions etc, Interact with users on daily basis to understand their issues and provide them solution. Provide power users training on how to do various tasks in SharePoint sites.

B2B Technologies (Atlanta, GA) Oct 2014 – March 2015

SharePoint & .Net Consultant:

Following are projects undertaken by me during my tenure at B2B:

B2B Internet Portal: This is SharePoint 2013 internet facing portal for b2b, my role was to do enhancements like creating page layouts, configuring search and creating OOB and custom web parts for the portal.

B2B Intranet Portal: This was originally hosted in SharePoint 2010 on premises, under this project, I migrated there intranet to Office 365 using tools like AvePoint’s Docave 6.2

Caraustar Migration (Atlanta): Under this project, my role was to migrate Caraustar’s google drives to OneDrive’s using Metavis migration tool.

Clarkstown County School (NY): Provisioned OneDrive of students and staff for Clarkstown county school using PowerShell scripts, and mapped OneDrive’s as network drive for each student using PS scripts.

AirTran Airlines, Atlanta, GA July 2011 – Sept 2014

Senior .Net Developer & SharePoint Developer

Being part of AirTran Team (Agile Environment), I have been handling multiple projects based on SharePoint 2010 technology, Net 3.5 & SQL 2008.

Following are projects handled by me in AirTran:

ShareTran: SharePoint 2010 Intranet Portal

ShareTran is intranet web portal used by AirTran, hosted in SharePoint 2010 environment. This intranet portal has 6 SharePoint site collections, and is used by almost all the teams to manage & share data among themselves. To view reports based on different SharePoint list views. This intranet portal employs many third party webparts like bamboo & Dundas dashboard. This Portal extensively uses InfoPath forms to collect user information for various purposes. This portal also uses designer workflows extensively in many sites.

Responsibilities:

Creating SharePoint pages & SharePoint lists.

Creating custom webparts using C# & MS-VS2012.

Creating web services to read data from SQL Server 2008 and show in SharePoint webparts.

Maintaining Permission/Access levels on various sites

Writing PowerShell scripts to do administration activities.

Involving in code review of the team members for custom code.

Off-shore team coordination

Writing JavaScript for client side code for webparts to show data from SharePoint lists.

Creating Master pages, CSS for branding of portal.

Deploying solutions in SharePoint farm.

Responsible for taking granular backup of lists & SharePoint sites, whenever required.

Responsible for Maintain health of SharePoint Farms.

Involving in unit testing of the application.

Environment: .NET 3.5, Visual Studio 2012, C#.NET, SharePoint 2010, SharePoint Designer, InfoPath Designer, ASP.NET, ADO.NET, SQL SERVER 2008,XML, Java Script, JQuery.

BackOffice Applications: .Net 3.5 & MS-SQL 2008 based application suite

BackOffice suites in AirTran consists of various applications that pull data from Great Plains 9.0, all these applications are developed internally or by external vendors using .Net Platform. Following are various applications maintained by me, along with their descriptions:

a)MS-SQL Jobs/ Batches: Used to pull or push data into Great Palins DB from other applications like CrewQual, CASS, Vaccation Tracker, ShareTran, ADP, PassBureau etc.

b)CASS: Cockpit access security system, it let gate agent know who has access to jump seat in cockpit.

c)Dundas Dashboards: These dashboards are used internally by various development teams to have access of stats related to health of their respective applications.

Responsibilities:

Writing scripts to create SQL stored procedures & views.

Writing code to maintain & enhance .Net 3.5 based applications.

Writing and maintaining SQL jobs and batches to feed data from Great Plains to other application DB, as well as to feed Great Plains from applications like ADP & CewQual.

Maintaining & Fine-tuning MS-SQL DB.

Creating Dundas Dashboard, to show data from various MS-SQL DB’s for various applications.

Involving in code review of the team members.

Off-shore team coordination

Involving in unit testing of the application.

Environment: .NET 3.5,.Net 2.0, Visual Studio 2012/2005, C#.NET, ASP.NET, ADO.NET, SQL SERVER 2008,XML, Java Script, JQuery.

CevaLogistics (Houston, TX / Noida, India) Jan 2010 – June 2011

Senior SharePoint Developer

CevaLogistics is a Logistics & Transportation based company, which uses SharePoint Intranet & Internet to share information among employees, vendors and customers. Both Intranet & Internet portals are based in MOSS 2007 environment.

Responsibilities:

Created Lists & SharePoint pages.

Created master pages.

Created custom workflows

Created deployable solutions.

Wrote list event handlers.

Created custom forms/pages using SharePoint designer

Maintained access/permission levels.

Environment: MOSS 2007, C#, Visual Studio 2008, JavaScript.

www.ourweddingday.com (NYC / Chandigarh, India) Oct 2006 – Oct 2009

Senior .Net Developer

Ourweddingday.com is a wedding planner web portal that provides various services to brides in US, beside this it also provides platform to various vendors to market their services to brides. Worked as Lead Developer for ourweddingday.com development team, and following were my responsibilities:

Responsibilities:

Involved in all phases of development includes analysis, design, development and Unit Testing.

Developed SQL Server stored procedures, functions and triggers as part of various modules.

Write & review code for various modules for ourwedding.com site using VS2005.

Developed various web user controls for the website.

Developed the pages using C#.NET, ADO.Net.

Used ADO.Net to access SQL Server database.

Involved in the weekly builds and monthly releases.

Utilized ADO.Net technology extensively for data retrieving, querying, storage and manipulation.

Developed the UI and implementation for important modules.

Coordinating with client & UI Designers.

Used Ajax to enhance performance of site.

Managed Database for portal by performing certain DBA tasks.

Environment: ASP.Net 2.0, C#, IIS6.0, SQL Server 2005, SVN

www.ohmygov.com (NYC / Chandigarh, India) April 2006 – Sept 2006

.Net Developer

Ohmygov.com was a US based political media site, it gave users ability to share/discuss local government success and failures. It also featured polls for users.

Responsibilities:

Developed and maintained different modules, using C# and Ajax.

Used ADO.NET to get the data from data base and send it back.

Created and Maintained Store Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment

Coordinated with client to understand requirements and getting changes accepted.

Integrated code with community server using community server API’s.

Environment: .ASP.Net 2.0, C#, IIS6.0,, SQL Server 2005,AJAX, Community server API’s

Intranet Portal for Telecommunication Organization (Amritsar, India) Oct 2005 – March 2006

.Net Developer

Worked for India based Telecommunication Company to maintain and enhance their existing CRM written in ASP.Net 1.1 & MS-SQl 2000. This internal portal was used by internal users to check KM articles, log tickets etc.

Responsibilities:

Created web forms using MS Visual Studio .Net, ASP.Net, C# and HTML.

Created User Controls to be used across the application.

Used ADO.Net in connecting to Data Access management with SQL Server 2000.

Design and implement the GUI (ASP.Net) with web form controls, web-server controls including Data Grid, Data List.

Used ADO.Net technology extensively for data retrieving, querying, storage and manipulation.

Integrated CRM application with Nortel switch using Nortel API’s to populate CLI in CRM tickets.

Environment: .NET 1.1, Visual Studio 2003, C#.NET, ASP.NET, ADO.NET, SQL SERVER 2000, Windows NT, IIS

Contact this candidate