Project Sql Server

RENU THAKUR, PMP

**** ******* ** *-****: ********@*****.***

Dublin, OH 43017 Phone: 646-***-****

SUMMARY

• Significant experience as a Business Analyst/Quality Analyst in Finance and Banking Industry.

Experience in the field of business analysis, business process design, application systems analysis, object oriented

analysis and decision support systems.

Experience in gathering requirements from subject matter experts, through JAD sessions, interviews, questionnaires,

surveys, and collaboration tools. Documenting the requirements in format that was easily understood by business

users and application developers.

• Involved in QA Life Cycle, which includes Designing, Developing and execution of the entire QA Process

and documentation of Test Plans, Test Cases, Test Procedures and Test Scripts.

Extensive success in translating business requirements and user expectations into detailed specifications employing

Unified Modeling Language (UML).

Strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational

Unified Process (RUP), Waterfall and Agile Methodology.

Extensive experience in writing Test Plans, Test Cases and Test Scripts for Manual and Automated Testing for

various business applications and also with the generation of SQL queries to Test database functionality.

• In-depth knowledge of creating Use Case, Activity, logical, component and deployment views with

Rational tools to extract business process flows and workflows thereby helping development and quality

assurance teams in understanding the requirements.

Expertise in Manual and Automated Testing of Client-Server and Web based Applications.

Expert in Root Cause Analysis, Feasibility studies, Risk Assessment studies.

• Developed Test Procedures, Methodologies and Policies for ensuring a thorough Testing.

• Excellent in data analysis and data modeling.

• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new

business requirements.

Worked with existing mainframe applications to understand requirements, workflows and document them for

developers to do conversion to web based systems.

EDUCATION

• Masters in Business Administration – New York Institute of Technology, NY

Bachelors in Engineering – MSU, Baroda, India

CERTIFICATION

• Project Management Professional (PMP) from PMI

• Certified Associate in Project Management (CAPM) from PMI

• Certification in Fund Accounting from Citigroup

Certification in Transfer Agency, Mutual Fund from Citigroup

WORK STATUS

US Permanent Resident (Green Card)

TECHNICAL SKILLS

RENU THAKUR, PMP

2886 Sawdust Ln E-mail: ********@*****.***

Dublin, OH 43017 Phone: 646-***-****

• Analysis & Design Methodologies: RUP, UML, SDLC, Waterfall, Agile

Requirements Tracking: Rational Requisite Pro, Rational Clear Quest

Business Modeling Tools: Rational Rose, MS Visio

Version Control: Rational Clearcase, MS Visual Source Safe

Project Management Tools: MS Project, MS Office

Languages: HTML, XML, SQL, MS Visual Basic 5.0/6.0

Testing Tools: Mercury Test Director, WinRunner

Databases: Oracle Database 9i/10g, MS SQL Server 2000, MS Access

Operating Systems: Windows 2000/XP, UNIX, Windows NT,

EXPERIENCE:

Citigroup, Columbus, OH – Business Analyst (June 2008 - May 2009)

Major Assignment involved Web-based application integrating company's gain-loss calculation module with

settlement, recon and fund accounting module.

Responsibilities:

• Interfaced with different business unit groups and knowledge experts to gather requirements, prepare and

update Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).

Developed Work Flow diagrams in MS Visio for new and existing Gain-Loss process.

• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.

Performed GAP analysis of business rules, business and system process flows, user administration, and requirements

• Ensured all artifacts complied with corporate SDLC Policies and guidelines.

Involved in weekly meetings, walkthroughs with gain-loss team to continuously improve process for the application

development and created weekly meeting minutes.

• Analyzed data fields and source of data for various processes in Gain-Loss.

Created several work orders and scope documents for other short term projects.

• Installation and Configuration of Unix network operating systems.

Environment:

HTML, XML, .NET, SQL Server, Requisite Pro, Bug Tracker, MS Office, MS Visio, MS Project

JP Morgan Chase, Chicago, IL- Business/Quality Analyst (Jan 2007- Dec 2007)

Assignment was development of a Remittance processing system called Remit One for the Treasury and Security

Services. Remit One when integrated with an existing TMS Image System increased efficiency to process payments

for customers by working from images rather than moving paper from place to place.

Also was involved in a Productivity Central Application which captured productivity data from various Receivable

Operation (RO) sites and stored the data in a single central repository.

Responsibilities:

RENU THAKUR, PMP

2886 Sawdust Ln E-mail: ********@*****.***

Dublin, OH 43017 Phone: 646-***-****

• Worked closely with team members in preparing new releases and application enhancements.

• Documented new defects in Mercury Quality Center - Test Director, assigned defects to different

people and kept track of status.

Prioritized list of Enhancement Requests and their estimates.

Prepared different types of Chart in Microsoft Excel and Power Point such as Release Charts, Change Area Charts and

Defect Trend Charts.

Uploaded documents in docshare also called Sharepoint and accessed by everyone.

• Developed Work-Flow diagrams in MS Visio.

• Performed manual testing following test scripts to check functionality of Productivity Central

Application.

Environment:

HTML, .NET, Oracle 10g, MS Office, MS Visio, Mercury Quality Center.

Oppenheimer & Co. Inc., NY – Business/Quality Analyst (Aug 2004- Dec 2006)

The project involved creating an application called Oppenheimer Portfolio Management System. This system allowed

planners and advisors to create and modify new or existing portfolios. The application would generate most favorable

portfolio based on risk profile

Responsibilities:

• Worked directly with portfolio managers and other investment and operations professionals in defining

and documenting system requirements and workflows.

• Provided on-site application support to business users.

• Developed technical and functional specifications relating to areas such as system integration, application

enhancement, and data analysis.

• Conducted JAD sessions between business users and Subject Matter Experts .

Analyzed business needs and created Class Diagram, Activity Diagrams, Use-Case Diagrams and

Sequence Diagrams.

Prepared Logical Process and Data Models that contained set of diagrams and

supporting documents containing the essential business elements, detailed

definitions, and descriptions of the relationships between the data elements to

analyze and document Business Data Requirements.

Developed comprehensive functional test plans that can be executed by internal staff or can be potentially outsourced

to third parties

• Helped maintain and prioritize lists of outstanding application issues and user enhancement requests.

Environment:

Windows 2000, SQL server 2000, Visual Basic 5.0, HTML, UNIX, Rational Clear Quest.

RENU THAKUR, PMP

2886 Sawdust Ln E-mail: ********@*****.***

Dublin, OH 43017 Phone: 646-***-****

Brown Brothers Harriman, Chicago, IL – Business/Quality Analyst (Feb 2003- July 2004)

Worked on multiple short term projects that involved adding billing feature to a broker application, enhancement of

equity and debt related applications.

Responsibilities:

• Gathered requirements by conducting JAD sessions with all the stakeholders. Resolved model clashes

amongst various stakeholders to come up with mutually agreeable set of agreements.

• Modeled functional requirements, converted business requirements in to technical specifications using

sequence and activity flow diagrams in MS Visio and MS Project.

• Actively involved in the UML based Use Case modeling for in collaboration with Design Team.

• Analyzed and designed business process flow diagrams.

• Involved in Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL

queries to filter data within the Oracle database.

Suggested process and product improvements for the application. Analyzed system requirements, developed

detailed Test plan, Test cases, Test scripts for testing the functionality, GUI and security testing.

• Performed manual front-end testing to check all functionalities of different modules.

Identified areas of risks, assessment, monitoring, having security and audit controls in place.

Ensured that the application met user and management expectations.

Environment:

MS Visio, MS Project, Excel, Rational RequisitePro, Oracle 9i, SQL server, Rational Rose, Rational Clear Case,

Rational Clear Quest.

Contact this candidate