Project Manager Sql Server

Keyur Gondalia

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

Phone: 347-***-****

PROFESSIONAL SUMMARY:

. Business Analyst/Project Manager with 8+ years of experience in the areas

of Business Analysis, Requirements Gathering, Design, Development,

Quality Assurance Testing, User Acceptance Testing (UAT) & Training.

. Domain knowledge and work experience in Retail and E-Commerce

applications.

. Analyzed and synthesized results from Joint Application Development (JAD)

session proposed alternative tasks and transform those into Business

Requirement Document (BRD) and Functional Requirement Document (FRD).

. Strong working experience in Software Development Life Cycle (SDLC) using

various methodologies including RUP, Agile, Waterfall.

. Experience on interacting with stakeholders, Subject Matter Experts

(SMEs) and end-users to understand, analyze, communicate and validate

requirements using Joint Application Design (JAD), Joint Application

Review (JAR) sessions.

. Conducted walkthroughs and code reviews with developers, designers,

involved groups, project manager, stakeholders to comprehend business

workflow of applications.

. Developed various documents like Business Requirements Document (BRD),

Use Cases, Functional Requirement Document (FRD), System Design

Specification (SDS), Requirement Traceability Matrix (RTM) and testing

documents.

. Experience in modeling AS IS and TO BE e-commerce solutions.

. Ability to gather business and technical requirements from both formal

and informal sessions and format them into formal documentation by

utilizing a variety of software tools.

. Used MS office Suite extensively which includes MS Word, MS Excel, MS

Visio for documentation and analysis reports.

. Used RUP and SDLC methodology, and managed the iterative cycles through

an effective project plan created using MS Project.

. Skilled in performing business processes, identifying risks, impact

analysis, UML modeling, flow charts and diagrams using Microsoft Visio.

. Experience in writing SQL for Data Analysis and QA report testing.

. Basic knowledge about Omniture for online marketing and web analytics.

. Responsible to Track, Document, Capture, Manage and Communicate the

Requirements using Requirement Traceability Matrix (RTM) which helped in

controlling numerous artifacts produced by the teams across the

deliverables for a project.

. Involved in Test Planning, Test Preparation, Test Execution, Issue

Resolution and Report Generation to assure that all aspects of a Project

are in Compliance with the Business Requirements.

. Experience working with Data Mapping for data element mapping between two

distinct data models.

. Experienced in Business analysis, Risk analysis, GAP analysis and Project

Planning.

. Experience in developing mock-up screens and wire frames using SnagIt and

Axure Pro.

. Experience testing implemented systems and system changes including

liaising with QA teams to develop test cases, test plans, test scenarios

and generating test data; conducting manual testing (regression, end-to-

end, functional).

TECHNICAL SKILLS:

Business Skills Business Definition Requirements, Business Process

Analysis, Gap Analysis, Use Case Modeling &

Analysis, Market Research Analysis

Modeling & Designing MS Visio, SnagIt, Axure Pro

Tools

Testing Tools RM Track

SDLC Methodologies RUP, Waterfall, Agile

Operating Systems Windows XP/NT, VISTA, Lion (Apple)

Languages HTML, ASP.NET

MS Office Excel, Word, Outlook, PowerPoint, Project 2010

Databases Oracle 8i/9i, SQL Server 7.0 & 2000, Access 2000,

MySQL, TOAD

PROFESSIONAL EXPERIENCE

Bed Bath & Beyond, NJ

Business Analyst

July 2012 - Mar 2013

Bed Bath & Beyond is a chain of domestic merchandise retail stores across

United States, Canada and Mexico. They sell goods primarily for the bedroom

and bathroom, as well as kitchen and dining room. The project in which I

work is QR Code Management System and website upgrade for all concepts

means the Bed Bath & Beyond USA, Bed Bath & Beyond CA and buy buy Baby.

. Reviewed and gathered requirements from the Subject Matter Experts

(SME) and Business Partners using various elicitation techniques and

create Scope Management Documents, Business Requirements Document (BRD),

Functional Requirement Document (FRD).

. Created artifacts such as Use Cases, Prototypes, Business Flows and Work

Flow diagrams for effective plans.

. Gathered user and business requirements through open-ended discussions,

brainstorming sessions and role-playing.

. Experience in creating blueprint of the system, Database team in

designing the database and maintaining the proper ER relationship.

. Effectively created Data Dictionaries, XML mapping spreadsheets for

interface requirements based on design solution.

. Loaded and managed the business, system and data requirements using

Microsoft Office and RM Track.

. Work on Agile and Waterfall methodology.

. Performed in-depth GAP Analysis on the requirements, identified the gaps

and documented the GAP Analysis report.

. Managed changes in requirements using a Change Control process.

. Use SnagIt & Azure to prepare mockups/wireframe designs for website

functionality.

. Responsible for analyzing project goals, breaking down what needs to be

created and attempting to engage users so that definite requirements can

be defined.

. Write detailed requirement for System Enhancement and making high-level

flow charts.

Work Environment: MS Office, MS Visio, Lotus Notes, Oracle, PL/SQL, ATG,

.NET, SnagIt, Azure.

Kera Designs, Ahmedabad, India

Project Manager

Jan 2011 - Jun 2012

. Manage team of Microsoft and Open Source technology.

. Manage all kind of software related issues. Handle development team and

integrate projects through all phases of project life cycle - analysis,

design, development, testing, implementation and post-production support.

. Used Object Oriented Design to develop Analysis and Design model.

. Write proposals in response to RFP and win new contracts from private

business sectors. Manage multiple contracts and negotiate new teams for

contract extension.

. Designed and developed custom controls to use with web forms using

ASP.NET Server Controls.

. Write SQL queries according to requirement.

. Responsible in creating the Test Cases, Scenarios and Steps for the new

requirements.

. Making team reports to analyze the areas of improvement.

. Identifying newer areas for growth and always looking for ways for the

betterment of the team's performance on the floor and thus helping the

organization.

Work Environment: VB.NET, ASP.NET, ASP, HTML, Joomla, Core PHP, SQL Server,

MySQL, MS Project 2010.

Avid Technosys, Ahmedabad, India

Project Manager

Sept 2009 - Dec 2010

. Manage team of Microsoft and open source technology.

. Manage software development and integration projects through all phases

of project life cycle.

. Basic role is client communication, requirement gathering, allocate work

to developer, testing of done work and finally submit work to the client.

. Used Master Pages, CSS for look and feel for Web pages.

. Follow Waterfall methodology to execute project.

. Accomplished cross-Browser compatibility and simplicity through JQuery.

. Look into newer areas for growth and always looking for ways for the

betterment of the team's performance on the floor and thus helping the

organization.

. Interact with SQL Server to get data from respective tables.

. Used ADO.Net components such as Datasets, Data Reader, Data View and Data

Table.

Work Environment: ASP.NET, Joomla, SQL Server, MySQL.

URL Software Pvt. Ltd., Ahmedabad, India

Web Manager

Jun 2007 - Aug 2009

. Manage team of website division of Microsoft technology.

. Manage website development division. Communicate with client, understand

requirement, give quotation according to requirement.

. Involvement in layout design, development, testing, deployment and give

technical support of website develop.

. Designed and developed an External web service by which new smaller

businesses could integrate directly into our existing system.

. Designed and developed .NET components using C# and XML to communicate

with Web Services.

. Cascading style sheets (CSS) were used to attain uniformity through all

pages.

. Work on Waterfall methodology.

. Integrated a Credit Card processing gateway into our system for instant

billing of our smaller customers.

. Designed and developed an in house Instant Messenger Client and Server

which tied directly into our existing SQL backend.

. Implemented a new set of coding standards that all of my developers now

follow.

. Allocate task to developer, review of completed task and if any mistake

than reallocate task to respective developer.

Work Environment: VB.NET, ASP.NET, ASP, HTML, SQL Server.

Anant Softech Pvt. Ltd., Ahmedabad, India

Sr. Software Developer

Feb 2006 - Jun 2007

. Manage team of developers. Assign work to them, review there done work,

upload on server & testing on live server.

. Participating in clients' strategic promotional and technology decision-

making.

. Responsible for pre-sales and post-sales negotiations with clients,

leading sales and training sessions.

. Responsible for post-production project support and development.

. Implement client side validation and messages using Java Script.

. Designed and developed web forms in ASP.NET & C#.NET using .NET Framework

2.0.

. Written SQL queries and Stored Procedures for data manipulation,

insertion, deletion and updates.

. Design and implement web site features using HTML, Cascading style sheets

(CSS), image editing software.

. Handle Work Order System means creating work order, allocate work order

to developer, after completion test the work, upload to server, inform

developer to check done work etc.

. Work on Waterfall methodology.

. Used various ASP.NET client side and server validation Controls, used

JavaScript for client side validations.

. Worked on Microsoft technology.

Work Environment: ASP.NET, ASP, SQL Server.

I-People Tech Solution Pvt. Ltd., Pune, India

Software Developer

Jan 2005 - Feb 2006

. Learned Performing analysis of existing system's efficiency and

suggesting improved ways to report on existing data

. Designing and implementing spend reporting web application (developed in

ASP.NET/VB.NET with MS SQL on the back end) to provide upper management

with user-customizable reports based on detailed accounting (Accounts

Payable/General Ledger) data available

. Enhanced existing functionality with additional features, such as reports

export to Excel/Access, ability to save and reuse reports, tracking

application usage, common login.

. Designed and developed (using VB.NET) a server component plus set of MS

SQL stored procedures for uploading data feeds and prepare data for use

in reports.

. Reviewed and suggested updates to existing data feeds, suggesting

improved ways to integrate various data feeds into single data warehouse.

. Developed routines to cross-match variations of vendor name to single

vendor, improving report outcomes.

. Participated in decision-making on projects goals, timeline and

milestones, producing CBT and printed manuals on software features,

hosting training sessions with business analysts and project managers.

. Have extensively used the web controls like Grid Views, Tree Views, Data

tables for effective User Interface.

Work Environment: ASP.NET, VB.NET, SQL Server.

Pioneer Softech, Pune, India

Software Developer

Aug 2004 - Dec 2004

. Performed the existing system analysis and new architecture design (UML).

. Coordinated and supervised the efforts of several other programmers.

. Individually designed MS SQL Server 2000 database, coded stored

procedures (T-SQL).

. Coded ASP in MS Visual InterDev 6.0 using VBScript, JavaScript,

HTML/DHTML/CSS, XML and ADO.

. Created components in MS Visual Basic 6.0, used CDO and Outlook 2000 for

messaging.

. Generated reports using Crystal Reports and MS Access Database.

. Deployed the solution, participated in testing and documenting.

Work Environment: VB, SQL Server, MS Access, HTML

EDUCATION

Master of Computer Application (Gujarat University, Gandhinagar, Gujarat)

2001-2004

Bachelor of Science [Physics] (Gujarat University, Ahmedabad, Gujarat)

1997-2000

Contact this candidate