Project Sql Server

Summary:

Microsoft Certified Professional with over 12+ years of IT experience in designing, architect and development of .NET, MVC 5.0, SharePoint Centric Solutions/Applications for Medium to Large Enterprises using out-of-the box and custom code.

End to end involvement in requirement gathering, POC’s, design, architect, development, deployment, QA and UAT of application life cycle.

Extensive expertise in development, customization, deployment, administration and maintenance of .NET Web Application, SharePoint 2010 solutions and SharePoint 2013 solutions.

Software development experience using C#, ASP.Net, VB.Net, ADO.Net, VB, Advance JavaScript, AJAX,XML, Web Services, Webforms, WinForms, SQLServer2008/2005, SSRS, VS.Net 2010/2008/2005/2003 and .NET Framework 4.0/3.5/3.0/2.0/1.1, Windows Services, VB Script and JavaScript.

MVC 5 .NET web application architecture, design, development with Kendo controls, razor engine and different JavaScript frameworks. Integration of application and application data with different application to create reports.

Proficiency in development tools such as Visual Studio.NET 2012, 2015 Business Intelligence Development Studio, and SharePoint designer.

Hands on experience in Database (DB design, Stored Procedures, Triggers, Packages, Cursors, Jobs, T-SQL, SQL, PL/SQL) using SQL Server 2012/2008/2005. Moderate experience on Teradata to create Tables, SPs, indexes.

Worked on every phase of SDLC and good in analysis/design.

Experience with world’s fortune 500 clients like Gilead Science, American Express, Wells Fargo, Ameriprise, State Street, Moodys.

Microsoft Certified Professional: MOSS 2007 Application Development, Microsoft .NET Framework - Application Development Foundation.

Proficiency in working with Life science customer with more than 3+ years

Good Communication, problem solving and analytical skills, ability to learn new technologies.

Technical Skills:

Programming Environments : ASP.NET, ASP.NET MVC 5, SharePoint 2013/2010, C#, JavaScript, JQuery, HTML 5

Tools and Technologies : Visual Studio 2015/2013/2012, SharePoint Designer, Kendo UI, Enterprise Application Blocks, InfoPath

Application Server : Internet Information Server (IIS) 5.0 / 6.0-

Database Servers : SQL Server 2005/2008/2012

Configuration Management : VSS, TFS, ClearCase

Education and Certifications:

Bachelors in Information Technology

Microsoft Certified Professional (MCP) .NET and SharePoint

Professional Experience:

Wincere Inc, SFO, CA Nov 13 – Till date

Lead Developer

Project : DART – Data Analysis and Review Tool

Description : DART is web application which stores huge amount of data and allow users to retrieve this data based on flag. This application is divided in 2 parts. First is ETL where data comes in stage area which require processing based on type and code. This data then transformed into main table where is available to web application. At web application, user can create, edit, personalize views and view information accordingly. On data they can comment with status or put flag for further reference.

Project : My workspace, My Training and Prolo

Description : My Workspace and Prolo are two different project but work together. My Workspace allows admin to setup different applications in study explorer including prolo, allow different applications to render in iFrame and allow to redirect or open in new window based on settings. This also opens area for users to see application study wise. Prolo is analysis management tool which allow users to create, edit, cancel, lock/unlock analysis. It allows to create and upgrade new version of files based on types.

Project : CCC base and Study Explorer

Description : CCC base is Platform to create cases in terms of Studies/Project and track the effort on it. All studies are related to particular Therapeutic Area and has tasks/subtasks and Amendment. Part of implementation was design Visual webparts, application pages, Event receiver, and designer workflows.

Responsibilities:

Interaction with customer and business owners for Requirement gathering

Database Design using code first approach and usage of entity framework to add/edit/delete/view record.

Front end development using Kendo Controls, bootstrap, other html controls with MVC razor views.

Development of partial views as reusable components.

Designed SSIS packages and SQL jobs to for data integration with different systems.

Custom report design with excel extract.

Designed fully controlled kendo grid in the application where user can arrange columns, show/hide columns,

Perform excel like search, column search, can save views as personal view.

Created timer jobs which sends email to users based on role and schedules as reminder email.

Daily communication with offshore team.

Participating in change management for build deployments.

Working with network admin team to deploy the application and setup of periodic build deployment.

Documentation (Functional Spec, Technical Design, test cases)

Design site to Maximize its usage with Microsoft best practice (home page, search page, other pages design)

Troubleshooting issues

Developed my workspace in a way that any application can be easily integrated and linked to study, Compound or Theparuatic area easily. Also individual application can also integrated easily.

Designed common ASP.NET MVC 5 template which can be used for development of project which has My

Workspace integrated, common branding and look and feel.

Environment: C#, ASP.net MVC 5, Kendo controls, SharePoint 2013, SharePoint Designer 2013, Visual Studio 2012, SQL Server 2008 R2, HTML 5, Different JQuery plugins, SQL Server 2012, SSIS, SQL Jobs for data integration, IIS 6.0.

Syntel Inc, SFO, CA Feb 13 - Oct 13

Designing System, Senior Developer & Analyst

Project : Moodys Analytics Knowledge Management and Sales & Delivery Portal

Description : Designing KM portal based on wiki and document library. Design metadata model using Managed Metadata feature if SharePoint and Content type. Establish different search options with the help of enterprise search and advance search. For search used search scope, JQuery.

Sales and delivery site is an application where customer, engagement, opportunity and project related information maintained. On project creation, workflow automatically creates Project Page, library, calendar, user group for that project. Project page will get auto filled with this artifacts along with few more custom project related Webparts (like Project Team, Project Client Contacts, Project Issues).

This Design Issue tracking site for maintaining issues and track. Designed new/edit/display forms with advanced JQuery options, OOTB workflows and other SharePoint features.

Responsibilities:

Design architecture for Sales & Delivery, KM portal and presented to stake holders of this application.

Developed custom interface using ASP.NET forms as a webpart/pages which will be deployed in SharePoint.

Developed full approval workflow for creating of new project which has client, engagement, opportunity involved. Groups and individual users can participate in Project creation workflow to complete it.

Developed Timer jobs which were sending notifications to users, groups based on priority.

Developed event receiver/workflows which will be invoked as soon as reviewed final approval with the system.

Developed fallback process if in case workflow fails to create Project.

On Project creation, system automatically create custom page, project document library, responsible group, calendar for project, issue list, discussion board. And everything gets added on custom page as web part.

Support issues and Following Control Board Change Management.

Documentation (Functional Spec, Technical Design, test cases)

Design site to Maximize its usage with Microsoft best practice (home page, search page, other pages design)

Troubleshooting issues

Environment: SharePoint 2010, Tools: SharePoint Designer 2010, Visual Studio 2010, SQL Server 2008, C#, JavaScript, JQuery

Syntel Inc, MN Jul 12 – Feb 13

.NET Developer &SharePoint Administrator

Project : Ameriprise CDS Brokerage Support and Maintenance

Description : CDS – Clearing Data Services is the SharePoint 2010 platform which is used by higher authority of clearing group in Ameriprise. This platform is setup on farm architecture of SharePoint 2010 which includes 2 WFE, 2 APP, 2 SSRS, 1 Query, 1 Fast Search, 2 DB Servers. Clearing site is hosted on this SharePoint Instance. Clearing site is configured with SSSR is configured in SharePoint integrated mode and daily reports snapshots generates on the HODS Oracle datasource. These snapshots are backup into separate site collection in PDF format and stored there with expiration policy. Apart from that there are Performance Point Services, PowerPivot services, Word Processing Series configured. Document and some power users’ dashboards are also managed in the site.

Responsibilities:

Daily maintenance activities and reporting to business stake holders.

Designed SSRS reports which will be generated daily and backup is saved in SharePoint document library for further use or compliance purpose.

Providing extensive Support on issues if they were on Application Server.

Represent for any deployment to the Control Board for Change Management.

Daily server checks, application checks

Regularly SharePoint upgrade, application upgrade as received.

Documentation (Functional Spec, Technical Design, test cases) for SharePoint department site.

All Microsoft release patches installation

Troubleshooting issue on server and communicating with Microsoft to get it resolve

TFS as code source safe.

Setup of development and deployment process.

Environment: C#, Visual Studio.Net 2003, ASP.Net 1.1, ADO.Net, Oracle 8i, Visual Source Safe 6.0, IIS 5.0., Java Script.

Syntel Inc, USA Nov 11 – Jul 12

.NET Developer

Project : Guitar Center SharePoint

Description : Guitar center is retail chain in the USA having more than 60 Stores and more than 12000 users. This system is work as intranet portal where all users can access different application, raise requests for new contractor onboarding and termination, single-sign-on for Custom point login, document libraries management, report webparts (Which are configured with SSRS), visual webparts, application pages, etc. based on their role. K2 Workflow support is involved in it which mainly for K2 workflow redirection, task management, report generation, SharePoint plug-in installation and configuration, etc. SharePoint support involves users’ management, code management, solution deployment, designer workflow etc.

Responsibilities:

Interaction with client (Requirement gathering, changes)

Support issues and Following Control Board Change Management.

Documentation (Functional Spec, Technical Design, test cases)

Developed Search, Custom form, Visual Webparts, Designer Forms, Designer workflow, views

TFS as code source safe.

Setup of development and deployment process.

Environment: SharePoint 2010, Visual Studio 2008, SQL Server 2008 R2, SSRS, K2 Workflow

Client

Project

Duration

Environment

Kronos

AMT Tracking Utility

May 11 – Nov 11

MOSS 2007, ASP.NET,

SQL Server Database

Wells Fargo

TMSAC

Jan 11 – May 11

ASP.NET, Web Services,

InfoPath Form, SQL Server Database

American Express

AMEX- Bus Intel Ref Arch (BIRA)

Aug 10 – Dec 10

MOSS 2007, SharePoint Designer, JavaScript

State Street

FlexWork management tool

Oct 07 – Aug 07

MOSS 2007, SharePoint Designer, C#, ASP.NET, JavaScript, XML, XSLT,

Windows 2003, Clear Case.

SQL Server 2005

Bins Mgmt. Pvt. Ltd

Image Rotator Web part

May 07 – Sep 07

MOSS 2007, C#, ASP.NET, XML, XSLT, Windows 2003, Clear Case

Experience from July 04 - May 07 was primirally in Various C# .net projects using ASP .NET Using VB .NET, Crystal Report, SQL Server 2000 and responsible for Design, Development, Coding, Front End design, Cross tab report design, Unit Testing and Production.

Contact this candidate