Developer Sql Server

Over ** years of software development and architecture experience using Microsoft technologies in a technology lead capacity

Extensively involved in design and development of Object Oriented, RDBMS applications and Component based systems, including Multi-tiered architectures using SOA and Microsoft Application Blocks and Design Patterns

Worked in Component based and service based software development

Worked Extensively in RDBMS applications using ORACLE (8i, 9i, 10g), SQL Server (2005,2008), Sybase, MS ACCESS

6+ years of experience in SharePoint Technologies MOSS 2007, SharePoint 2010, SharePoint Portal Server 2003 and Windows SharePoint Services 3.0/2.0, SharePoint Designer 2013/2010/2007, MS InfoPath 2007/2003, MOSS Central Administration, Web Parts, Web Part Pages, Excel Calculation Services, Document Management

Experience developing SandBox solutions for Site Collection use

Developer/Administrator & Support roles for Microsoft SharePoint Portal &SharePoint Services

Experience in Installation, Configuration, Customization, Managing and Administering Microsoft SharePoint Portal Server 2003, Microsoft Office SharePoint Server 2007 (MOSS 2007), SharePoint 2010, Windows SharePoint Services v2

Strong development skills in ASP.NET, C#, ADO.NET, VB.NET, VB, ASP, VBScript, Java Script, PL/SQL, HTML, CSS, ASP.NET 3.5, LINQ, SSOM, CSOM, JSOM, JSLink, Display Template, JQuery, Powershell.

Architected and implemented SAP user management module interfacing C# .Net with SAP

Experience working with trading applications for Credit Default Swaps and Settlements

Developed solution for SARBOX and SAS 70 audits

Extensive knowledge of data modeling and report generation with MS Reporting Services and ERWIN

Closely worked with all stages of software development including Change Management, Release Management and Production Support

Data warehousing experience using MS SQL Server 2000 (DTS)

Ability to work independently with minimal supervision

Excellent communication, analytical skills and ability to perform as a part of a team and ability to lead teams effectively

Languages: VB.NET, C#, ASP.NET, Visual Basic (6.0), ASP, COM/ DCOM, ATL COM, Pro*C, HTML, VBScript, Jscript, CGI, PERL

Operating Systems: UNIX, Windows-XP/8.0

IDE Environments: Visual Studio 2005, Visual Studio 2008, Visual Studio 2010, Visual Studio 2012

Web & GUI Development: JavaScript, XML, HTML, jQuery

Components Models

Middleware: COM/ DCOM, ATL COM, ADO, ADO.NET, ODBC, DAO, BODS

Data Base Systems: ORACLE, SQL Server, MS-ACCESS, SQR, Crystal Reports, MS Reporting Services

Document Management: WSS 3.0, SharePoint 2007, SharePoint 2010, SharePoint 2013, OAuth, Lotus Notes 5.0

Office Automation: Microsoft Office

System Design: SAP

Methodologies: RUP, AUP,

Project Management: MS Project

Industries: Financial, State (Federal & State Departments), Telecom, HealthCare

Tools: Erwin, Rational Rose, InstallShield, Bounds Checker and SQA Test Suite. Microsoft Visual Source Safe, PVCS, Clear Case

IndigoIT (SEC contractor)

Washington, DC August 2016 – Till Date

SharePoint Administrator

Responsible for the Production, Staging and Development SharePoint Site Collections.

Customized existing Production Portals

Monitored SharePoint Site Collection Storage Metrics.

Created new Sites and Lists based on customer requests/ inputs

Worked on Customizing the List Forms using JavaScripts and JQuery

Also setup column based user privileges

Created new users privileges and user groups

Verizon Wireless, Baskin Ridge, NJ Jan 2016 – June 2016

SharePoint Architect/ Developer

Responsible for the Production and QA SharePoint Site Collections.

Customized existing Production Portals

Implemented 200+ Document Libraries based on existing briefs

Trained end users to start using Document Libraries instead of creating Folders under the Parent Document Library

Monitored SharePoint Site Collection Storage Metrics.

Maximum allocated quota was set at 3GB

Created new Lists based on customer requests/ inputs

Worked on Customizing the List Forms using JavaScripts and JQuery

Also setup column based user privileges

Created new users privileges and user groups

Carrier Company, Farmington, CT May 2015 – Nov 2015

SharePoint Developer/ Administration

Blackjack application is replacing the current HVAC application. Also HVAC developed in MOSS environment has been migrated to SharePoint 2010. SiteMinder is used as a claims based solution for the entire farm.

Developed and Deployed new WSPs using Powershell. Deployed database scripts and took backups from the database.

Participated in a Change Control Board meetings to validate the upcoming releases

Monitored the SharePoint usage using Site Collection Monitoring Matrix

Closely interacted with the developers to train them about best practices

Developed CRUD Operations using ASP.NET Web API and Angular.js, working together with the developers

Project 1 – Alliance Bernstein, Avenue of Americas, NY, NY Aug 2014 – Feb 2015

SharePoint Developer/ SharePoint Consultant/ Business Analyst

Streamline the ticketing system for the various processes in the Digital Marketing department.

Led the effort of isolating the requirements.

Worked with the SME to better understand all current issues, users face

Design solutions that best fits the organization after suggesting custom solutions using Visual Studio and SharePoint code using CSOM and Rest API.

Only OOB solutions using InfoPath 2010 have been implemented per company suggestions.

Implemented workflow using Nintex.

Restful services have been used to generate reports

Unilever, Trumbull, CT Apr 2013 – July 2014

Technical PM / .Net Developer

Data Center migration from NA to UK

Supported Lotus Notes migration to new version.

Responsibilities:

Worked on the As Is Architecture and To Be Architecture along with the solution architects.

DataWare House system was developed for reporting purposes and ease of use by the end users.

Responsibilities:

Developed SSRS financial reports leveraging financial data from Midas.

Developed frontend application using .net 4, Enterprise Library, Entity Framework and Lync for data entry and data reconciliation for accounting department.

Also developed reconciliation modules for Backoffice, Settlements and HR Departments.

Ansell Healthcare, Iselin, NJ Dec 2012 – Apr 2013

SharePoint Developer/ Sharepoint Architect

Ansell Intranet portal is a new initiative to leverage the SharePoint environment as a collaboration environment. This is an Architect / Administrative position. Portal Intranet environment utilizes Sharepoint 2010 Online (365), Sharepoint Designer 2010/2013, RESTful services and CSOM SandBox Solutions.

The environment was upgraded to SharePoint 2013 while I was on the project. We used Metalogix for both Administrative tasks and Upgrade.

Responsibilities:

Published Portal for External Facing

Install and maintain plug-ins, features, web parts, templates, and custom software

Managed site domains, user access, roles and privileges

Support services and applications provided by 3rd parties, and data interface with other service providers

Develop and execute operation support management plans, including but not limited to: system backup, performance tuning, performance improvement recommendations and practice

Worked on 365 Developer Site InPremise, and isolating app domain for SharePoint-hosted apps, preconfigured to use OAuth, so that the Windows Azure Access Control Service (ACS) can be used for authenticating and authorizing provider-hosted apps for SharePoint that are deployed to this site.

Configure and maintain document libraries, enterprise lists and site collections. Perform typical system administrative activities such as site creation, user training, back up, restore and issue resolution

Extensive Troubleshooting experience

oSetting up user privileges and roles

oWork with users when privileges are lost

oCheck ULS logs for potential issues with SharePoint farm

oMemory outage issues with log files

oRecovering deleted files for users

oLogin issues

oExpiring Service Accounts

oWebPart issues

oCSOM Code

oRest API

Developer for implementing SharePoint templates

Developed custom workflows

Developed custom SandBox solutions as alternatives for deployment

Extensively used JavaScript for Ajax and Client side Callback for Provide User Friendly GUI which like Window application

Designed and developed InfoPath forms using SharePoint Designer 2010

Worked with SharePoint Lists, SiteCollections, Master pages, Site Definition, Style Sheets / Branding, Page Layouts, BDS and Excel services

Worked with SSRS Reports

Used Team Foundation Server (TFS) for version tracking control and process guidance

Used Microsoft Enterprise Library for Overall Application, mainly used in Data Access Tier for asp.net Application

Landmark Preservation Department, NY, NY July 2012 – Nov 2012

PILLAR project is a business requirement to streamline the process of issuing violations, permits and generate other official documents some of them with seals and water marks for landmark properties.

System utilizes Sharepoint Designer 2010, BDC, BCS, LINQ, SQL Server 2010, SharePoint Client Object Model and RESTful services.

Responsibilities:

Developer for implementing SharePoint templates and stored procedures

Developed custom workflows

Added web part to updates LDAP and SharePoint list

Added custom feature using .net and SharePoint object module to create a list from a xml file

Added custom event handlers to update SharePoint list and LDAP

Created custom web part for system administrators to monitor the site discussion boards

Extensively used JavaScript for Ajax and Client side Callback for Provide User Friendly GUI which like Window application

Designed and developed InfoPath forms using SharePoint Designer 2010

Used SandBox solutions and used 3rd party SandBox solutions like jQuery Sandboxed Solution

Used Visual Studio Tools for Application (VSTA) to write C# code behind class for InfoPath forms to add custom logic using InfoPath Object Model and CSOM.

Worked with SharePoint Lists, SiteCollections, Master pages, Site Definition, Style Sheets / Branding, Page Layouts, BDS and Excel services

Worked with SSRS Reports

Used Team Foundation Server (TFS) for version tracking control and process guidance

Used Microsoft Enterprise Library for Overall Application, mainly used in Data Access Tier for asp.net Application

Also used Rest API

Unilever, Englewood Cliffs, NJ Jan 2011 – June 2012

Project 1: SharePoint Production Support

Lead SharePoint Administrator / Architect

Extensively used new ASP.NET 2.0 data controls like GridView, DetalisView and FormsView for Web Part

Layered C# Class libraries and integrated those libraries for Web Part developments

Working as a SharePoint administrator, involved in complete set-up and maintenance of all SharePoint features. Extensive experience in monitoring and maintaining all SharePoint servers in the farm and troubleshooting any issues

Extensively used SharePoint Designer and JQuery to design and develop various custom new forms, data form web parts, spot light web parts, custom edit forms, custom display forms, metadata search

Used Central Administration for administration and set up and configured Shared Services for implementing several other functionalities

Extensively worked on deploying the sites from Development / test environment to Production environment

Created new Applications and content databases with it

Managed all the new and existing applications and involved in trouble shooting several issues by monitoring the server performance, event viewer and error logs

Created Sites, Document Libraries, Lists and List Views to collaborate users

Configured Outlook 2007 with MOSS 2007 to synchronize Share Point Document Library and Lists

Used Share Point Designer for branding and customizing Share Point portal sites by developing new Master Pages and Page Layouts

Developed and deployed custom Web Parts, Event Receivers / Handlers and Custom SharePoint solutions using Visual Studio. Also worked with deploying and working with several third party Web Parts

Created Custom Workflows and also workflows using Office SharePoint designer and Visual studio 2005

Worked on preparing project plan to upgrade MOSS to SharePoint 2010 environment

Project 2 - Master Data Administration

Lead .net Developer

Involved in Requirement gathering, Analysis, Design, Development, Testing and Deployment of entire application for the new SAP ECC environment. Used C#, ASP.NET

Implemented new stored procedures

Created batch scripts for TWS and created new TWS jobs for loading and extracting files to and from SAP ECC

Planned and deployed new database and new front end server

Extensively used jQuery for enhancing UI

Extensively used new ASP.NET 2.0 data controls like GridView, DetalisView and FormsView

The Obout suite was used due to the ease with which the contents of it’s controls could be refreshed using its callback features, based on changes to the values of other controls on the page, without causing the entire page to be reloaded

Developed the Plan Maintenance Module, by utilizing the Infragistics AJAX functionality Commission percentage to be paid for each and every product, will be determined in this module

Creating a Webservice to fetch data from SAP ECC using the .net 2.0 SAP Connector.

Implemented stored procedures to convert customer data in SQL Server 2005

Generated Wireframes and all design documents

Implemented the web pages and all dependent classes

Project 3- Landing Zone

Environment: Microsoft Office Share Point Server 2007/2010, VS.NET, ASP.NET 2.0, C#, Share Point Designer, InfoPath, Oracle 10G, PL/SQL, Ajax, HTML, DHTML, VSS.

AIG Global Investment Group, NY April 2005 – Dec 2010

Project 1: Sr. SharePoint Developer on MOSS / Administrator

Involved in Requirement gathering, Analysis, Design, Development, Testing and Deployment of entire portal

Involved in design and development using C# and ASP.NET

Involved in Installation and Configuration of MOSS 2007, Windows Share Point Services 3.0 and Share Point Designer

Installed, configured and upgraded SharePoint 2007 to SharePoint 2010 in development environment

Experienced in maintaining and developing Portals / Applications using MOSS 2007 and WSS 3.0 Object Model

Working as a SharePoint administrator, involved in complete set-up and maintenance of all SharePoint features. Extensive experience in monitoring and maintaining all SharePoint servers in the farm and troubleshooting any issues

Extensively used SharePoint Designer and JQuery to design and develop various custom new forms, data form web parts, spot light web parts, custom edit forms, custom display forms, metadata search

Used Central Administration for administration and set up and configured Shared Services for implementing several other functionalities

Extensively worked on deploying the sites from Development / test environment to Production environment

Created new Applications and content databases with it

Managed all the new and existing applications and involved in trouble shooting several issues by monitoring the server performance, event viewer and error logs

Created Sites, Document Libraries, Lists and List Views to collaborate users

Configured Outlook 2007 with MOSS 2007 to synchronize Share Point Document Library and Lists

Used Share Point Designer for branding and customizing Share Point portal sites by developing new Master Pages and Page Layouts

Developed and deployed custom Web Parts, Event Receivers / Handlers and Custom SharePoint solutions using Visual Studio. Also worked with deploying and working with several third party Web Parts

Created Custom Workflows and also workflows using Office SharePoint designer and Visual studio 2005

Worked extensively on custom aspx forms and InfoPath Forms and integrated them with SharePoint for data collection from the users

Configured Shared Service Provider for Search, Audiences and User Profile management

Configured People Search and made utilized Advanced SharePoint search, Enterprise Search for providing top notch search capabilities

Worked on List template, Site template and Site definition to customize Share Point Portal 2007.

Assign Roles and Permission to sites, lists and list items

Created WebParts using Web Controls Library and WSS 3.0 object model and deployed them in to Web Part

Configured SharePoint to integrate with SQL Server Reporting Services (SSRS) to display the reports directly in SharePoint site

Involved in adding users to Active directory, adding servers to the domain and creating necessary service accounts for the application

Extensively used new ASP.NET 2.0 data controls like GridView, DetalisView and FormsView for Web Part

Experience in creating Event Receivers to perform certain actions when an item is modified.

Extensive experience in Trouble Shooting and handling several server and client related issues Configured the ULS logs for error and performance monitoring and used them along with event viewer for trouble shooting

Created layered C# Class libraries and integrated those libraries for Web Part developments

Worked with VBA macros for creating the Dash Board style data and presenting them to the end users by embedding them on MS Excel

Extensively used Share Point Object model to show SharePoint data in different ASP.NET Web Applications

Worked on Business Data Catalog to integrate business data from back-end server applications to Office Share Point Server 2007

Worked with Office Share Point Server 2007 Excel Services to enable the interaction of the end users with spreadsheets through a Web browser

Created document work flow by handling Document Libraries Event handlers

Created InfoPath 2007 forms and published it in to Share Point Forms Library

Configured InfoPath Forms Services to access InfoPath 2007 forms through browser

Extended out of the box Share Point Portal Search by inheriting and extending Core Search Result Web Part and scheduling crawl properties and managed properties

Migrated Content and Sites

Environment: ASP.NET 2.0, C# 2.0, Visual Studio .NET 2005, Microsoft Office Share Point Server 2007/2010, Windows Share Point Services 3.0, Windows Server 2003, Share Point Designer, InfoPath 2007, PowerShell, MS SQL Server 2005, IIS 6.0, HTML, DHTML, TFS, Visual Source Safe

Project 2- Identity Management System:

Lead Developer

Assisted in data modeling and generating all DDLs for the DB creation process.

Created all stored procedures and DTS packages

Develop and maintain RCMS system

Work with BA, management and auditors to architect and build additional functionality into the application

Ensure application is SAS70 and Sarbox compliant

Manage additional developers for this application

Manage development schedule for improvements and enhancements to this application

Generated Wireframes and all design documents

Implemented the web pages and all dependent classes

Implemented and used web services for use with Reporting Services and to generate Email notifications

Implemented windows service to parse emails and take necessary action

Environment: ASP.NET, C#, SQL Server 2000, ADO.NET, Visual Studio. Net 2003/2005, Windows 2000, stored procedures, DTS, Reporting Services, Windows Service, Web Service, SAP BAPI (Connector 2.0), XML, Windows Workflow Framework

Project 3 - CDS Ticketing System:

Lead Developer

Environment: ASP.NET 2.0, C#, ORACLE 9i, ADO.NET, Visual Studio. Net 2005, Windows 2000, stored procedures, DTS, Reporting Services

Digital Group, NJ Feb 2005 - Apr 2005

Project TimePort

Senior Software developer

Environment: ASP.NET, C#, Oracle9i, ADO.NET, Visual Studio. Net, Windows 2000, Visio 2000 Professional Edition

BOC Gases, NJ July 2002 - Feb 2005

Lead Developer

Environment: ASP.NET, C#, SQL Server 2000, ADO.NET, Visual Studio. Net, Windows 2000

Veteran Affairs Medical Center, Little Rock, AR Jan 2002 - Jul 2002

Project - The Radioactive Material Management

Lead Developer

Environment: C++, SQL Server 2000, DTS (Data warehousing) ADO, Visual Source Safe, Windows 2000, InstallShield

Elemco Building Controls, Hauppague, NY Nov 2001 - Feb 2002

Project - The Tenant Executive

Environment: Visual Basic, ASP, SQL Server, VBScript, JavaScript

Department of Business Services, New York City, NY July 2001 - Nov 2001

Environment: Windows 2000,VB6.0, VBScript, JavaScript, ASP, Visual Interdev, SQL Server 2000, ADO, DAO, Microsoft Speech Engine

Timberline Software, Portland, OR Oct 2000 - Jul 2001

Environment: Windows 2000, C++, ATL COM, ORACLE, ODBC, InstallShield

Quest Communications, Lakewood, Co Jan 2000 - Oct 2000

Environment: VB 6.0, VC ++, ASP, ORACLE 7.3, Forms 4.5, Pro* C, Oracle Application Server, HTML, JavaScript, UNIX, SUN OS and Windows NT

Siemens Communications, Bangalore, India July 1997 - Jan 2000

Environment: VC++, C ++, VB, MFC, MS ACCESS, DAO, PVCS, Rational Rose, InstallShield and SQA Test

Jawaharlal Nehru Technological University, India

B.S Computer Science & Engineering

Contact this candidate