Project Sql Server

Parul Agarwal

E-Mail: *******@*****.***

Cell No.: 91+995*******

Professional Summary:

Having around 10 years of IT experience in Project Management, design and development of various Application Systems for business solutions and dynamic websites in Financial and Healthcare Domain.

Having around 4.5+ Yrs of experience in agile management working as Scrum Master (Certified Scrum Professional/Master). Helping my current organization to start using and adapt to scrum methodology. Providing training to teams on regular basis for performing different agile ceremonies in better ways.

• Managing projects in agile using Jira and Rally tool.

• Certified Scrum Professional, Certified Scrum Master and certified SAFe Agilist.

• Extensive design, architecture and programming experience using C#, ASP.NET, ADO.NET and AJAX Technologies.

Onsite Experience of working in London for more than a year.

Strong Understanding of Object Oriented Analysis and Design conforming to UML.

Possess strong communication and interpersonal skills.

Qualification Details:

Bachelors from IT-BHU (institute Of Technology, Banaras Hindu University).

Software Skills:

Core Skills : Agile project management using tools like Jira, Rally

Programming Languages : C#.NET, VB.NET

Web Technologies : ASP.NET, ADO.NET, HTML, AJAX, WCF

Frameworks : .NET 2.0/3.0/3.5/4.0, WCF, LINQ.

Scripting languages : Java Script.

Third Party Tools : Microsoft Enterprise Library 4.0, Telerik

RDBMS : Microsoft SQL Server (2000/2005/2008/2010), Oracle, MS Access.

Source Control Software : Microsoft Visual Source Safe(VSS), Tortoise SVN, Team Foundation Server(TFS).

Tools : Rally, Jira, Visio, Jenkin, Visual Studio.Net 2005, Visual Studio.Net 2008, Visual Studio.Net 2010.

Server Technology : IIS, WINDOWS 2000, XP, Vista.

Software Packages : MS Office.

Organizational Experience:

Working as Scrum Master/Agile Coach in Policybazaar.com from Oct 2014.

Worked as Project Lead/Scrum Master in Sumtotal systems from May 2013 to July 2014.

Worked at UnitedHealth Group, Hyderabad as a Associate Project Lead/Scrum Master from July 2010 to May 2012.

Worked for TCS as Team Lead from Dec 2009 to Jun 2010.

Worked for Infosys Technologies Ltd as Technology Analyst from Jun 2004 to Dec 2009.

Project Details:

Project #1 : Back-office management

Backoffice is combination of many projects which provides a platform for agents to help in sales and booking different policies for customers.

Environment:

ASP.NET, C#.NET, Visual Studio.NET 2010, Sql server 2008.

Role & Responsibilities:

Working as Product owner and scrum master for the team. Creating the user stories and prioritizing them based on the market value.

Defined project scope and objectives through internal project management methodologies.

Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.

Established effective communication for the department with consistency across development and business management. Presentations, recommendations and updates provided regularly to the Director office.

Provide visibility to team impediments/risks and helps eliminate them Designed Use Cases.

Responsible for overall delivery of new features in the product.

Extensively involved in agile coaching for other teams in policybazaar adapting to agile.

Project #2 : LMS Product Management and Customization

LMS (learning management system) is well used product and I have worked on managing and developing the productization and customizations of this product based on request from customer or improving the product.

Environment:

ASP.NET, C#.NET, Visual Studio.NET 2010, Sql server 2008.

Role & Responsibilities:

Working as Product Owner/Scrum master for the team. Worked on creating user stories and prioritizing them based on the market value.

Defined project scope and objectives through internal project management methodologies.

Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.

Established effective communication for the department with consistency across development and business management. Presentations, recommendations and updates provided regularly to the Director office.

Provide visibility to team impediments/risks and helps eliminate them

Project #3 : IHS(Innovative Health Solutions) Common Work Queue/ Resource Management

CWQ is an IHS application that allows for tracking, monitoring and working of member cases, programs or activities. It will be used by nurses and coaches to manage and record their work. It is a fully unified solution for practices and enterprise groups of all sizes and most specialties, linking all features via a single database. This application helps to schedule appointments with consumers and manage resource time and workload. It will allow the users to search for available appointments based on a defined set of criteria. It will also provide the functionality to send out reminders for the consumer of their upcoming appointment. This tool will allow for easier scheduling for the users and will assist with the successful completion of the consumer health and wellness coaching sessions with the IHS Service Delivery Team. It will also allow for easier updates and modifications if necessary based on the business needs.

Environment:

ASP.NET, C#.NET, Visual Studio.NET 2010, AJAX, Telerik Controls, Web services and MVP Pattern.

Role & Responsibilities:

Working as Scrum master for the team.

Defined project scope and objectives through internal project management methodologies.

Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.

Involved in development of various modules.

Designed Use Cases & also performed Gap Analysis, Requirements gathering, analyzing new functionalities and Interface Designing for modules.

Involved in gathering Business Requirements, writing Use Cases and Identification of existing business processes and process flows.

Managed a team of 7-9 developers which includes overall project tracking and planning activities of the team.

Provided Functional guidance to the development team throughout the development phase.

Created Unit Test case scenarios and Business scenarios for my modules.

Involved in Code Reviews.

Project #4 : Rally Reporting

Rally is a web based agile project management tool which helps large enterprises perfect the art of agile development & bring products to market faster. A rally user can login to the system and can view different reports based on different metrics. However, Rally does not provide a way to generate customized reports. For ex: there is no provision in Rally to see the defect closure rate per sprint/interation, scrum master dashboard metrics and product owner dashboard metrics. Rally Reporting tool is a windows based tool which will generate these custom reports and sends a report to all the listed users on a scheduled basis. Using this tool we can configure the reports along with the list of receipents and scheduled time – may be daily, weekly, monthly, annually or customized.

Environment:

C#.NET, Visual Studio.NET 2010, WebServices.

Role & Responsibilities:

Worked as Scrum Master for the project.

Defined project scope and objectives through internal project management methodologies.

Facilitating the daily scrum meetings, spring planning, spring review, and spring retrospective.

Involved in the Analysis of Requirements.

Involved in designing the scheduler component which will be triggered as per configuration and sends the report

Coded the modules and integrated them.

Involved in working with Rally web services.

Giving technical support to the team members.

Code Review and testing of assigned modules.

Project #5 : VSTO Tools

VSTO application is an excel templates platform which helps in managing INTEL client and give better visibility on demand forecasting. This application gives insight in future demand of different products.

Environment:

C#.NET 3.5, ADO.NET, VSTO, SQL Server 2008, Visual Studio 2008.

Role & Responsibilities: Technical Lead

Project #6: OMAT (Operating Margin Analysis Template)

It is a Web application which helps in managing infosys clients. It helps in giving better visibility on operating margin to the management.

Environment:

ASP.NET, C#.NET, Javascript, SQL Server 2005, Visual Studio.NET 2008, AJAX.

Role & Responsibilities: Technical Lead

Project #7 : Financial Control Development

During this project I have developed 2 applications-

SABS & YAFL- It is a Banking Balance Sheet application which takes raw data from different banking stream and after doing some adjustment in this data, creates balance sheet every month. It also sends data to many downstream applications for processing.

Novation Fees Tool- calculate the novation fees to be paid/received by ABN and RBS and generate output file(s) with the information required to book the novation fees in the source systems ( For Integration of ABN AMRO and RBS)

Environment:

C#, Visual Studio .NET 2005, SQL Server 2005, Microsoft Access.

Role & Responsibilities: Complete owner of the application from technical front

Project #8 : Product Control Reconciliation Tool (PCRT)

It is a Data warehouse project which will get feeds from many Front-office and Back-office systems in the bank, performs a reconciliation of FO and BO systems and generates a report. Data storage uses ETL model.

Environment:

C#, ASP.NET, Java Script, HTML, Ajax, Visual Studio .NET 2005, SQL Server 2005, Sql Server Integration Services.

Role & Responsibilities: Module Lead

Project #9 : Contract Management System/Contract Summary Document

CMS (Contract Management System) is a repository tool with no upstream or downstream integration with the other existing applications. As and when, Infosys enters into a contract with any client it is entered in this system. It talks about the various legal clauses like non-hire, limitation of liability, termination etc. Contract Summary Document (CSD) captures key elements of the contract that are essential for revenue recognition, delivery/quality performance criteria that will be used for future negotiation processes. CSD is a repository for all key commercial, legal and delivery terms and conditions and will help in analysis of the same across customers, across geographies and verticals.

Environment:

NET Framework, ASP.NET, VB.NET, Visual Studio.NET 2005, SQL Server 2000.

Role & Responsibilities: software Developer

Contact this candidate