Sign in

Project Sql Server

Thousand Oaks, California, United States
December 31, 2017

Contact this candidate

Priyanka Dubey

Senior .Net Developer

317 *** ****


Effective and reliable Technical Project Consultant with 10+ years of consolidated IT experience across a range of industries

A results-oriented consultant with extensive experience in design & development, team leading and end to end project execution in single and multi-site project delivery models

Extensive experience in Microsoft technologies – C#, ASP.NET, MVC, Web Services, WCF, Web API, WPF, Entity Framework, Hook Framework & SQL Server

Experienced in JIRA, Git and TFS for end to end application lifecycle management

Demonstrated experience in various types of projects – web-based, smart-client, client-server, integration, and packaged solution – for mid-size to large scale clients

Excellent exposure to database management systems – stored procedures, functions, triggers, T-SQL etc.

Excellent communication and stakeholder management skills with wide range of stakeholders

Experienced in Agile, Waterfall, and Iterative project methodologies

Highly organized consultant as a team member and individual contributor, Highly organize consultant as a team member and individual contributor

Core skills include in-depth understanding of technology, people\resources management\mentoring, designing solutions


Post Graduate Degree in Computer Applications (Masters in Computer Application), Uttar Pradesh Technical University India, 2005.

Bachelor of Science: Gujarat University India, 2002.


Languages : C#, Java, Visual Basic

Query Languages : SQL, LINQ

Scripting Languages : Java Script, Query

Web Technologies : ASP.NET MVC, Webforms, Web API, REST, WCF, Web Services, HTML5, CSS3,

JQuery, XML, IIS, Java script, Classic ASP, VBScript,XSLT, JSON

Databases : MS SQL Server 2000 – Later, Access, Oracle

IDE : Visual Studio 2008 – 2015, VS Code, Eclipse

Tools : Entity Framework, NUnit, Methodologies Agile (Scrum), Kanban (DevOps), Iterative, Waterfall

EDRMS : SharePoint 2007

Concepts : OOP, SOLID, Design patterns

PROFESSIONAL EXPERIENCE Indianapolis, IN, US Jan 2014 – Till Date

Role: Senior Software Engineer Team: Content Builder Team

Team Details: Our team has responsible for managing and creating content used by other Products such as Email or Social Studio.

Content Builder Team consolidate assets in a single location. Upload, share, search and manage all types of content. Streamline production with marketing workflows for collaboration, email campaign management and approvals.

Roles and Responsibilities:

Play a pivotal role in the development of new product features and the maintenance and enhancement of existing product features.

Work closely with the product management team to define future product requirements and implement these requirements during the development process.

Implement and gather requirements based on design specifications.

Maintain and provide support for existing code.

Develop industry leading application architecture.

Develop features and functions used by clients across marquee enterprises, including retail and direct marketing, travel, and enterprise.

Environment: IIS, ASP.NET 3.5 - 4.5, C#, SQL Server 2008, Eclipse, Agile, Elastic Search 1.7, WCF, ASP. Net MVC 5, Entity Framework 6, MS SQL Server 2005 and TFS – Git, Jira

Client: Ingersoll Rand Nov 2013-Jan 2014

Senior Software Engineer Project: IR Securities Group

Project Details: EPM (Enterprise Project management) has installed here on Share point 2010 for Project and Portfolio management helps organizations gain visibility and control across all work, enhancing decision-making, improving alignment with business strategy, maximizing resource utilization and enhancing to optimize ROI.

Project Server 20010 unifies project and portfolio managers to help originations align resources and investments with business priorities, gain control across all types of work and visualize performance using powerful dashboards.

Roles and Responsibilities:

Creating sub-sites within existing sites.

Managing security of the SharePoint site.

Creating new workflows and managing site content

Addresses user issues by monitoring the Help Desk queue

Provide administrative and functional guidance to the portal management team.

Approve project scope and monitor and continually assess the portal project viability.

Resolve corporate conflict/issues. Determine corporate standards.

Provide approval to proceed through each phase of the project.

Defining all governance, standards and policies.

Individual responsible for the coding of a program, or script

Individual responsible for a system’s configuration

Environment: Share point 2010, Project Server 2010, Project Essential 2012, IIS, ASP.NET3.5, C#, SQL Server 2008.

Client: Microsoft, Bellevue – WA Nov 2008 – June 2012

Lead Engineer Project: Vision Tool

Project Details: Vision has built for schedule planning and tracking team used by the Live Search Team of Microsoft. The tool uses Product Studio to store Features, Work Items, Code Defects, and configuration data which is uses to produce views on the data that help people keep track of the work they need to get done easily and help release managers or scrum masters stay on top of work progress during a release. Teams across Search have been using Product Studio for tracking work items for some time. However, Product Studio does not provide a simple way to track work capacity, total work done, total work remaining, status of individual, teams, and releases with respect to hitting their schedules, and more. This is where Vision comes in.

The built applications were migrated to SharePoint 2010.

Roles and Responsibilities:

Development, Enhancement, Backup of site and Support of application.

Develop the customize web parts with Product Studio Connectivity

Resolve /analyze the client queries and respond accordingly.

Ensure proper manual testing

Responsible to handle Production issues and Query.

Successfully upgraded the applications to SharePoint 2010.

Responsible for Deploying packages on Pre-Production and Production Environment

Involved in customizing web parts and pages using SharePoint designer extensively.

Handled run-time and design–time errors by implementing appropriate error handlers.

Involved in Unit testing, debugging, troubleshooting and integration testing.

Provided technical assistance in deploying the solution.

Involved in writing complex stored procedures, Cursors.

Regular scrum with management team and client to access business needs and coordinate for work.

Develop application using .NET with C#.

Design and implementation SQL Server database.

Developing .NET Web Services.

Provide test environment for testing team.

Perform the Unit testing on development environment.

Environment: C#, ASP. Net, MOSS 2007, SharePoint 2010, Entity framework, SQL 2005, LINQ, .Net 3.5, Product Studio.

Client: Microsoft, Bellevue - WA May 2008 – Nov 2008

Team Member Project: MSN Insight

Project Details: MSN Insight is a web application developed on Share Point 2007, this application has developed to figure out day today Project activities through Dundas reports and Excel charts. Project has developed for HCL internal supervision of Projects and POCs. By use of Active Directory users have added in Share Point Group, users have access on site according to their group they had added. Reports are developed on Dundas Chats.

Roles and Responsibilities:

Develop the application from scratch by gathering the information from high management and Project Manager.

Grant user permission and added them according to their group.

Responsible for taking the weekly Backup of site

Create the scheduler which can take the backup of site on daily basis

Responsible for providing the support of application.

Ensure proper testing and Deployment on Server.

Develop custom InfoPath forms based upon business requirements.

Involved in Unit Testing and Integration testing according to the requirement specification.

Involved in reviewing the code of other team members.

Was responsible for integrating different modules onto an Integration server and release the application for testing.

Was responsible for creating the wsp solutions.

Was responsible for handling errors and providing custom messages to users.

Regular communication with Management team to asses business needs and coordinate for work.

Environment: MOSS2007, IIS, ASP.NET3.5, C#, SQL Server 2005, Dundas Charts

LangO’Ruke Oct 2007 – April 2008

Team Member Project: Production Control Management

Project Details: PCS application has developed for Construction Domain; PCS (Production Control Management) is web based application use role base authentication, i.e. XML files and Sitemap Control. In Construction Domain works are not properly scheduled, most of the works has depend on some previous tasks so the time laps get exceeded from pre-defined time. Here this application has manages all tasks their dependency using the concept of milestone. In this application, third party control has used (Gantt chart and Dundas Charting) to represent task, dependency, and milestone graphically.

Roles and Responsibilities:

Participated in Business Analysis and Requirement Analysis.

Involved in preparing the LLD (Lower level design) and Visio chart.

Responsible for design the 3-tier architecture i.e. Presentation Layer (UI), Business Access layer (BAL) and Data Access layer (DAL).

Involved in Analysis and Study of functional specification for development of existing functionality.

Reporting project status to Project manager and Client.

Responsible to present Team status on daily Scrum meetings.

Onsite interaction through conference calls, mails and Net meeting.

Generating the Weekly status reports.

Ensure proper testing and Deployment on Server.

Developed the SQL Store Procedure, Function and connectivity.

Environment: IIS, ASP.NET2.0, C#, JavaScript, SQLServer2005, XML, AJAX, Gantt Chart, Dundas Charting, Web Services.

Client:LangO’Ruke April 2007 – Aug 2007

Team Member Project: EMMS

Project Details: EMMS is the Eigen Marketing Management Software; it serves mainly for Eigen marketing managers, Management people, when marketing people visited on client side they need to give feedback and any future meeting details. Previously they maintain data in separate Excel sheet/Word format, but on the time to prepare report from them is not an essay task, this application solve the problem for marketing managers as well as Administrator managers to get reports on single click.

Roles and Responsibilities:

Participated in knowledge discussions and review meetings with clients in order to ascertain complete requirements from client.

Involved in designing and developing the User Interface.

Developed SQL queries for all database manipulations.

Involved in manual testing done on web pages.

Implemented Ajax components to improve performance of the web page.

Environnent: IIS, ASP.NET 2.0, VB, Java Script, SQL Server 2000, SQL DTS

Client: LangO’Ruke April 2007 – Nov 2007

Team Member Project: Bug Tracking System

Project Details: Bug Tracking System have two modules ADMIN and SCR, this application specifically made for tracking client's software change requirements (SCR), Client have to fill this SCR as their change request in Utility. Once SCR has generated then it will in-box of Team Leader (Undertaken S/W for which SCR has generated) for Approval of change request, if TL feels changes are required then they assign work to their team members with the given target date.

In Admin module, new Projects have added with the team size like developers and Project leader. Admin can edit in existing software team or delete the project. In addition, MIS is there for managerial people using crystal Reports.

Roles and Responsibilities:

Involved in design and development of the application using

Involved in writing SQL queries SQL Server.

Developed Reports for all transactions.

Grid View, Data Set, Data View and Data Adapter were extensively used to receive and display data obtained from the database.

Implemented Ajax components for improving the performance of the web site.

Environnent: IIS, ASP.NET 2.0, C, Java Script, SQL Server 2005, SQL DTS, AJAX, Web Services

Religare Securities Ltd Sep 2006 –Oct 2006

Team Member Project: PMS BackOffice

Project Details: This is an application which maintains client account details, share values and mutual fund value. PMS ”Portfolio Management System” enables the maintenance of cash detail and mutual fund details, client cash management and full account data management. Management tools include Crystal Reports as well as Import/Export option for Excel.

Roles and Responsibilities:

To develop the software modules in .net framework 1.1 with use of classes, Methods

Database designing and mapping with Sql server using ADO.NET

Involved in requirements gathering, analysis, design, development and implementation.

Developed SQL queries SQL Server for all database manipulations.

Involved in front end validations.

Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.

Environnent: IIS, ASP.NET, VB, JAVA Script, SQL Server 2000

Religare Securities Ltd July 2006 –Sep 2006

Team Member Project: RACE and RALLY

Project Details: This project is designed to optimize the new account opening process and to decrease the amount of time to open a new account. Branches can complete the entire Account Opening form online. Once initiated, branches send physical form to HO for verification and each form can be tracked online using the web interface. Other processes related to opening a new account - i.e. data integration with other software systems, physical verification of details entered, reports, status and audit trail functionality are other functionality built into this system.

Roles and Responsibilities:

Involved in design and development of the application using Asp.Net.

Involved in writing SQL queries SQL Server.

Developed Reports for all transactions.

Grid View, Data Set, Data View and Data Adapter were extensively used to receive and display data obtained from the database.

Implemented Ajax components for improving the performance of the web site.

Environnent: IIS, ASP.NET, VB, JAVA Script, SQL Server 2000, Crystal Report.

Bee-Ess Logistics Pvt. Limited Jan 2005 – June 2006

Team Member Project: Job registers Access

Project Details: Provides to Custom Housing Agent (CHA) all information related to Exporters and Importers, maintaining their jobs according to the status of warehousing or housing status. Daily Status Report of Containers position, Status of the debit note and bills for Air and Sea. Also maintaining job status according to their different offices all around the country.

Roles and Responsibilities:

To migrate the existing project which was in VB 6.0 into the .Net technology which also involved developing VB pages, components (assemblies) and Custom controls, User controls etc.

I was part of my team and involved in code, unit testing and system testing.

Environment: VB.Net, MS Access

Contact this candidate