Quality Assurance Sql Server

Mintu Desai

**** ******* *****

Phone: 248-***-****

Troy MI 48085

E-

mail:******@*****.***

Summary of Experience:

Over 7+ years of experience as Business System Analyst, Business Analyst

and Quality Assurance in working on variety of changing environments.

Expertise in Business Requirement Gathering, Analysis, Process Mapping,

Documentation, Data Analysis, Data Element Mapping, Estimation and

Planning, Client/Business Interaction, Issue Resolution, Gap Analysis,

Trouble Shooting, Testing, Defect Tracking and Roll out and Maintenance.

. Strong functional and work-flow knowledge in Finance, Automotive, e-

Commerce and Health Care domains.

. In depth knowledge of Software Development Life Cycle (SDLC) with

understanding of various phases such as ID and

Assess/Analysis/Design/Build/Testing and Deployment.

. Knowledge in project life cycle methodologies like RUP (Rational

Unified Process), Iterative, Waterfall.

. Experience in Requirement Analysis, Risk Management, Resource

Management, Team Management and Quality Assurance.

. Meetings Coordinator with excellent inter-personal and conflict

resolving skills.

. Facilitated JAD (Joint Application Discussion) with Business,

Developers, DBAs.

. Expertise in documentation of Training material, System reference

documentation, Customer and User training.

. Handled multiple projects and diverse activities in parallel while

also managing critical and complex issues.

. Experience in conducting Joint Requirement Planning (JRP) and Rapid

Application Development (RAD) sessions.

. Experience in Project Development Lifecycle, knowledge in Object-

Oriented Analysis and Design (OOAD).

. Highly initiative, self-motivated with excellent communication,

interpersonal, analytical and presentation skills.

Training/Certification:

. Microsoft SQL Server DBA certification

. Microsoft SQL Server Developer certification

. Microsoft Visual Basic Developer certification

. Attended training for Business Analyst

. Attended training for Automated testing tools(Quality Center, QTP)

Work Experience:

Ford Motor Company, Dearborn, MI

IT Business Analyst

Feb'10

- Present

Environment: Unix, J2EE, Oracle10g, Windows XP, HP Quality Center 9.2, SQL,

Ford SDM Classic Water Fall development methodology, Visio, Excel, Power

Point, Share Point 2007, SQL Developer, WebEx, MS Office Communicator .

CSS is a web based application based on J2EE technology which is running

on an Oracle application server. The backend is Oracle 10G. CSS is used

for Production (products related to manufacturing vehicles) and Non

production (miscellaneous products. various other non manufacturing

products) purchasing. CSS is a global tool used by all ford motor company

brands.

Roles and Responsibilities:

. Working on CSS application Enhancements like backend security rewrite,

Production Major and Minor approval process change, New user admin

screens, New site Elimination Detail Screens.

. Working with team and Business Users in order to gather detail system

requirements.

. Working with the SDA to develop the user interfaces prototyping

documents.

. Creating Ford SDM 02 (Requirement Document) and 62 (User Interface

Requirement document) for the proposed changes on CSS.

. Created process flow diagram for as is and to be system in order to do

gap analysis and better understanding of the business flow for

Security Rewrite and Approval Process change.

. Working with Data Modelers to define Logical Data Model

. Developing and executing system test cases and Support the team in

defect resolution.

. Supporting the business in Customer Acceptance Testing

. Supporting the team in launch planning creating milestone and Gate

Review documents for CSS application enhancements.

. Working with the PM to develop project plans.

Ameriprise Financials, Detroit, MI

Business Analyst

Jul'06 - Oct'09

Environment: Unix, Linux, IBM AS400, Windows XP, HP Quality Center 9.2, HP

Quick Test Pro, Oracle, DB2, SQL, Water Fall development methodology,

Visio, IBM RequistePro (Requirement Management Tool), Snagit.

Investor 5.0 applications is used by investors in order to manage

investment portfolio including brokerage accounts, trading, e-Money

transfers, e-Docs, OFX (account transactions) download to Quicken or

MS Money etc.

401K Web Application developed as an investment suggestion portal for

employers, employees and existing H&R customers. Users can get

investment advice after they provide their risk profile and other

demographic details. Email and coupon campaigns can be generated and

maintained from Admin Client.

Roles and Responsibilities:

. Worked with various business units to gather system requirements and

created SRS/SRD and RTM.

. Created process flow diagram for as is and to be system in order to

do gap analysis and better understanding of the business flow.

. Created functional, non functional requirements and use cases using

standard organization templates.

. Various Design options are documented and discussed with different

teams regarding Performance, fail-over and Maintenance perspective.

. Ensure functional and non-functional requirements are translated to

technical requirements and communicated to development teams.

. Ensure that performance and quality standards are met at various sub-

system levels and at the complete system level.

. Walk through of requirements with business and obtain their

approvals.

. Conduct build gate reviews with business to make sure product is as

per their expectations.

. Compute Effort Estimation and Schedule Tracking and communicate it to

top management.

. Create test cases, integration testing for UAT during various

releases.

. Create System Requirements Document for reports module from

functional requirements and by conducting client meetings.

. Worked primarily on Reports Designing for Data Analysis and DB

queries for reports. Reports component has the option to run reports

in On-Demand mode and Scheduled mode

. Document Data element mapping of common fields from various systems

for data integrity.

Workforce Software, Livonia, MI

Jan'05 - Jun'06

System Analyst

Environment: Unix, Linux, AIX, Windows, Windows 2000 IIS, Apache

Tomcat, IBM Websphere and WebLogic, Perforce, GUI testing tool (Grinder

- developed internally by WFS), (TestCaseRunner -Developed internally by

WFS to test software's different components) SSL, Oracle, Rational Tools

Workforce Software's Time and Attendance system is a time keeping

software designed to stream line the time reporting process, while

providing the back-end calculations needed. Few of the ways this

software is deployed to the users:

a.) in a desk-based environment, employees report their own time and

labor distribution through a web-based browser interface. Supervisors

approve time sheets at the end of each period,

b.) in blue-collar or other environments with hourly employees, time

can be recorded with badge readers, biometric devices, or touch

screens. Supervisors review time sheets daily or every period, c.)

For environments where employees don't have their own computers, you

can set up a common PC where employees can review time and check

their time off balances.

Roles and Responsibilities: Primary Contact for WFS's Time and Attendance

System.

. Business Requirement Gathering from Clients, Analysis of requirement,

Business specification documentation using Web flow diagrams, Process

Diagrams, UML diagrams, Change Requests, Estimation and Planning.

Communication of the requirements to the development team. Testing

and bug/error reporting, Defect Tracking.

. Requirement and Workflow Analysis, Process Change, Process redesign,

Trouble Shooting, Issue Resolution and Gap Analysis.

. Supported the migration of Legacy Application to Web Based

Applications.

. Documentation of User Manuals, Training Manuals, System reference

Manuals, Guidelines, Template Responses, Desktop Procedures etc.

. Coordination with other run site coordinators for system optimization

and up-gradation.

. Handled upgrades and maintenance cycles. Primary contact for all the

minor as well as major system issues.

. Performed Business Specification identification and documentation for

User Interface Development.

. Lead client facilitation meetings to gather requirements (Inception

phase) and was involved in reviewing the business process.

. Participated in the identification, understanding, and documentation

of business requirements, including the applications capable of

supporting those requirements.

. Involved in preparation and maintenance of the Requirement

Traceability Matrix (RTM) to measure the progress, test matrix and

test script review.

. Developed Test Plans and Test Cases to be used in testing, based

on business requirements, technical specifications.

Metavante Corp (M&I Bank), Milwaukee, WI

Feb'04 - Nov'04

Business System Analyst

Environment: Windows 2000, Visual Basic, SQL Server 2000, Ms Access,

Sybase, XML Editor,

E-commerce, Ultra edit 32, Citrix, Mainframe, Test Director, Winrunner,

Oracle, e-Commerce banking

Applications such as Banker Insight and Teller Insight.

Metavante Corporation delivers banking and payments technologies to

financial services firms and businesses worldwide. Metavante products

and services drive account processing for deposit, loan and trust

systems, image-based and conventional check processing, electronic

funds transfer, consumer healthcare payments, electronic presentment

and payment, business transformation services. I worked on their e-

Commerce banking applications such as Banker Insight, Teller Insight

and Ops Tops.

Roles and Responsibilities:

. Worked with the business users to define business requirements and

analyze the possible technical solutions.

. Worked with the Business users, tech Lead and 3rd party vendors in

gathering their requirements and data transactions.

. Co-author of business requirements document (BRD) with project teams.

Extracted, discussed, and refined business requirements from business

users and team members.

. Analyzed user problems, including automated and manual business

processes and identified, researched, investigated, defined and

documented business processes

. Designed and developed project document templates based on SDLC

methodology.

. Designed and developed Web flow diagrams, Use Cases, Activity

Diagrams, Sequence Diagrams, and Collaboration Diagrams.

. Assist project managers with the development of project schedules.

Develop requirements and preliminary design for client applications.

. Performed analysis and designed projects using a systems development

methodology.

. Worked with all levels of client staff in solution definition.

. Conducted workflow, process diagram and gap analyses to derive

requirements for existing systems enhancements.

. Collaborated with the QA team to develop test plans, test conditions

and test cases to be used in testing based on business requirements,

technical specifications and/or product knowledge.

. Setting up and monitoring development for UAT, Staging and Production

environment.

. Organized cross training of team members and Users to become more

responsive.

. Assisted in development of training materials for new technology and

process improvements.

GKN Sinter Metals, Romulus MI

Oct'02 -

Jan'04

Business System Analyst

Environment: Visual Plant, SQL Server 2000, Windows 2000, Visual Basic,

Excel, Ms Access, Test Director.

Visual Plant application is used as a plant floor monitoring

application for Automotive Industry. It is used for creating asset,

creating different type of data collection categories in order to

generate reports, Trends, Production views, Layouts and many other

detailed views.

Roles and Responsibilities:

. Requirement Gathering from the Clients by conducting meetings and

brainstorming sessions and document the same using the Business

Requirement Documentation, Business Specification and Business Rule.

. Gathered and formalized user and business requirements towards

enhancements to the current web interface.

. Gathered and documented Business and Functional requirement analysis.

. Facilitated JAD sessions with management, SME (Subject Matter

Experts), vendors, users and other stakeholders.

. Developed various UML diagrams for design and for documentation.

. Assisted project managers with the development of project schedules.

Develop requirements and preliminary design for client applications.

Perform analysis and design projects using a systems development

methodology. Worked with all levels of client staff in solution

definition.

. Designed and developed Use Cases, Activity Diagrams, Sequence

Diagrams using UML and Visio.

. Created process and data flow diagrams to derive requirements

. Coordinated with the DBA, Development team, testing team for the

development and implementation of the application.

. Assisted in creation of test plan and validated them.

ADDITIONAL SKILLS:

Operating Systems: Windows NT/2000, XP and NT, UNIX (Solaris

2.5.1, SunOS, HP UX), Citrix, IBM

Mainframe

Languages: Java, .Net, VB Scripts, HTML, XML,

J2EE, ASP.

Databases: Oracle, SQL Server 2000, MS Access

Others: SDP, Microsoft Project, IBM

RequistePro, Microsoft Word, Power Point, Excel,

SharePoint, Visio, iRise,

Lotus Notes, Ultra Edit, Clarity, Test Track.

EDUCATION:

DEGREE: Diploma in Computer Science (2 years)

Contact this candidate