PRIYANKA VASHISHT

SUMMARY

. Over * years of IT experience with experience in business/systems

analysis, software application development and systems implementation.

. Expertise in translating Business needs into end-user Reports with

Business Intelligence Tools like Business Objects, Business

Intelligence, Crystal Reports and Crystal Enterprise.

. Performed business/systems analysis within, financial services.

Skillful at Documentation on User requirements and System

Specifications.

. Extensive project management and Implementation lead experience with

managing the release implementation and coordination efforts.

. Extensive technical and functional experience with Microsoft Software

Products: Access, Visual Basic, Project, Excel and Word. Adept in

design tools like Visio.

. Knowledge to work on tools for requirements gathering and defect

management RTC & RRC.

. Worked on High level design document (HLDD) and Low level design

Document (LLDD).

. Skillful in developing Financial Reports for preparing monthly

closing entries and financial reporting package reports.

. Full development life cycle database experience (SDLC) with Oracle-

based business applications.

. Strong interpersonal and presentation skills, ability to interact with

people at all levels.

. Excellent knowledge of Databases having worked on Oracle, DB2, MS SQL

Server and MS Access.

. Excellent analytical, functional, design and development skills with

excellent communication skills, both written and verbal. Ability to

work in both individual and team environments.

. Very good working experience with customers, end users and colleagues.

. Good knowledge and experience in Database Modeling Concepts and Query

Building.

. Worked with DBA's to design ER (Entity-Relationship) diagrams and

appropriately optimize and normalize database design.

. Acquaintance in implementing different types of Replication Models

like Snapshot, Merge and Transactions.

. Capable of working efficiently with emerging technologies.

. Distinctive Communication, Interpersonal, and Analytical skills.

. Excellent Client interaction skills and proven experience in working

independently as well as in a team.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/2000/NT/XP, MS Dos, IBM AIX, UNIX, Sun

Solaris

Languages: SQL, PL/SQL, UNIX Shell Scripting

Databases: Oracle 7.x/8i/ 9i, 10 g, MS SQL Server 7.0/2000, MS

Access 2000

ETL: Ab Initio 2.8 / 2.10 / 2.11.

Business Intelligence: Crystal Reports 8.0/8.5/9.0/9.5/10.0,BOXI R2/ R3/

R4, Crystal Enterprise 8.0/8.5/9.0/9.5.

Web Technologies: IIS 4.0/5.0/5.1 Server, VB script, JavaScript, JAVA

2.0, Servlets, JSP, JDBC, HTML, DHTML

GUI Tools/IDE: Visual Basic5.x/6.0,MS word, MS Excel, Developer 2000

(Forms 4.5/5.0, Reports 2.5/3.0).

IDE Tools: Macromedia Dream Weaver, Adobe Photoshop 7.0, Eclipse, MS-

Visual Studio.Net, MS-Visual Studio 7.0, and JBuilder, MS

FrontPage

Other Tools: ClearCase, Quality Center, DOORS, Remedy, RRC, RTC.

EXPERIENCE

OPM, DC Feb 13 - Present

Business Analyst

Project: OPM

Role & Responsibilities:

. Involved in business requirement gathering and translating in these

requirements to technical specifications.

. Developed system requirements for Business Objects, Business

intelligence.

. Query database using SQL.

. Employed structured software development framework methodology (SDM).

. Analyzed user requirements and wrote business and user requirements

documents.

. Inspected and base lined system requirement and design documents.

. Prepared analyst test cases and performed analyst testing.

. Provided business and technical support during application

development, testing and implementation.

. Acted as liaison between development and Production release management

groups.

. Excellent interaction with cross-functional teams

. Responsible for quality and timeliness of project progress and

completeness

. Environment: Microsoft Project, Crystal Reports 9.5/10.0, Crystal

Enterprise BOXI XIR2/R3, Oracle 10g, Toad 6.3.3.1, Power Builder 7.0,

ClearQuest,Microsoft Access 2000, SQL Server 2000, HP Unix 11.0, PVCS

Version Control, Windows 95, Windows NT 4.0, DB2, PL/SQL, Ab Initio

2.11, GDE 1.12, Sun Solaris 2.8, Windows NT, and Rational ClearCase,

Quality Center/ Test Director, IBM Rational Suite.

Merlin-Intl (Veteran Affairs)

Mar 12 - Feb 13

Business Analyst

Role & Responsibilities:

. Drive requirements gathering working with client's analysts, SMEs and

technical architects.

. Create High Level Design Documents (HLDD) and Low Level Design

Documents (LLDD) with flow diagrams and charts.

. Learn the capabilities and constraints of the COTS product and target

requirements appropriately.

. Understand the client working environment, systems in place and high-

level initiatives to guide requirements elaboration.

. Document and manage requirements using Rational Requirements Composer

(RRC) and/or Rational Team Concert (RTC).

. Participate in a Scrum team with a high-level of communication with

technical staff.

. Document use cases, business models, functional and non-functional

requirements.

. Create business process models as needed using Business Process

Modeling Notation (BPMN), Use case diagrams or other UML-based

diagrams.

. Write requirements specifications based on a variety of inputs and

models in conjunction with a technical architect.

. Communicate status, feedback and priorities to project lead.

. Environment: Microsoft Project, Thunderhead, Oracle 10g, Toad 6.3.3.1,

Power Builder 7.0, Microsoft Access 2000, SQL Server 2000, DB2,

PL/SQL, DOORS, Rational Clear Case, Clear Quest, Quality Center/ Test

Director

DHSS (Defense Health Service systems) Nov 10

- Mar 12

Business Analyst

Role & Responsibilities:

. Analyze and document technical and business requirements and processes

in context of Business Objects, BI, Geospatial Information Systems

(GIS), and Informatica.

. Query database using SQL.

. Support development of engineering solutions for Business Objects, GIS

technology, and Informatica.

. Constructs data models and activity/process models as required to

define system functions for Business Objects, GIS, and Informatica.

. Support analysis and engineering throughout the project lifecycle for

the installation, testing, data conversion, implementation, and

ongoing maintenance of information systems involving Business Objects,

GIS technology and capabilities, and Informatica.

. Environment: Microsoft Project, Crystal Reports 9.5/10.0, Crystal

Enterprise BOXI XIR2/ R3, Oracle 10g, Toad 6.3.3.1, Power Builder

7.0, DOORS,Microsoft Access 2000, SQL Server 2000, HP Unix 11.0, PVCS

Version Control, Windows 95, Windows NT 4.0, DB2, PL/SQL, Ab Initio

2.11, GDE 1.12, Sun Solaris 2.8, Windows NT, Rational ClearCase,

ClearQuest, Quality Center/ Test Director

Victor O Schinnerer, Chevy Chase MD

Mar 09 - Dec 09

Business Analyst

Project: Real Estate

Role & Responsibilities:

. Involved in business requirement gathering and translating in these

requirements to technical specifications.

. Developed system requirements for Business Objects, Business

intelligence.

. Query database using SQL.

. Employed structured software development framework methodology (SDM).

. Analyzed user requirements and wrote business and user requirements

documents.

. Inspected and base lined system requirement and design documents.

. Prepared analyst test cases and performed analyst testing.

. Provided business and technical support during application

development, testing and implementation.

. Acted as liaison between development and Production release management

groups.

. Excellent interaction with cross-functional teams

. Responsible for quality and timeliness of project progress and

completeness

. Environment: Microsoft Project, Crystal Reports 9.5/10.0, Crystal

Enterprise BOXI XIR2/R3, Oracle 10g, Toad 6.3.3.1, Power Builder 7.0,

ClearQuest,Microsoft Access 2000, SQL Server 2000, HP Unix 11.0, PVCS

Version Control, Windows 95, Windows NT 4.0, DB2, PL/SQL, Ab Initio

2.11, GDE 1.12, Sun Solaris 2.8, Windows NT, DOORS, Rational

ClearCase, Quality Center/ Test Director, IBM Rational Suite.

Fannie-Mae, Herndon

Sep 05 - Dec 08

Business Requirements Analyst

Project: FAS 149, Team Lead

Role & Responsibilities:

. Team Lead with end-to-end grasp of entire software development life

cycle (SDLC) including business requirement analysis, design,

development and testing of software applications

. Worked closely with Business team to document business requirements

and any specific use case/s

. Created design documents on reports

. Responsible for quality and timeliness of project progress and

completeness

. Provide business and technical support during application development,

testing and implementation.

. Act as liaison between development, test, systems integration and

release management groups. Responsible to oversee the Development

group and assign tasks as and when required.

. During the Design and development phases, verified if business

requirements did require any modification based on specific technical

limitation/s

. Developed ad hoc reports based on technical requirements including

unit testing of the developed reports.

. Performed quality assurance, test and verify requirements during

development and implementation using Oracle tools: Oracle Discoverer,

Toad and Microsoft Access.

. Compilation of monthly results using computerized database for

reporting purpose & variance analysis of results.

. Excellent interaction with cross-functional teams

. Great customer interfacing skills and customer orientation

Environment: Microsoft Project, Crystal Reports 9.5/10.0, Crystal

Enterprise BOXI/ XI R2, Oracle 10g, Toad 6.3.3.1, Power Builder 7.0,

Microsoft Access 2000, IBM Rational Suite,SQL Server 2000, HP Unix 11.0,

PVCS Version Control, Windows 95, Windows NT 4.0,, PL/SQL, Ab Initio 2.11,

GDE 1.12, Sun Solaris 2.8, Windows NT, and Rational ClearCase, ClearQuest,

Rational Team Concert,IBM Rational Suite, Quality Center/ Test Director

Project: SCBSL Tax/RACE

. Developed numerous reports extracting data from Oracle & Sybase

tables.

. Created design documents on reports

. Compilation of monthly results using computerized database for

reporting purposes & variance analysis of results.

. Used prompts to make reports confined to a particular case as per

business requirements

. Created PL/SQL for accessing and manipulating data from database.

. Involved in preparation of monthly entries and financial reporting

package

. Created linked, unlinked, Parameterized, CrossTab and on-demand sub

reports for various business needs, reports scheduled for different

file based / schedule based events, distributed in email, PDF and HTML

format.

. Developed user manuals for the reporting application.

. Generated complicated reports using sub reports developed

parameterized reports and created charts by using BOXI.

. Developed report alerts based on conditions as per user requirements.

. Created lot of complicated queries involving sub queries, correlated

queries for generating finance related reports.

. Functional testing for all BOXI Reports.

Environment: Crystal Reports 9.5/10.0, Crystal Enterprise BOXI, Oracle

10gHTML, VB 6.0, ASP 2.0, IIS 4.0,, SOL* Loader, PL/SQL, Ab Initio 2.11,

GDE 1.12, Sun Solaris 2.8, Rational Team Concert, Windows NT, Rational

ClearCase, Quality Center/ Test Director.

Wachovia, NC

Mar 04 - June

04

Business Requirements Analyst

Role & Responsibilities:

. Team Lead with end-to-end grasp of entire software development life

cycle (SDLC) including business requirement analysis, design,

development and testing of software applications

. Worked closely with Business team to document business requirements

and any specific use case/s

. Created design documents on reports

. Responsible for quality and timeliness of project progress and

completeness

. Provide business and technical support during application development,

testing and implementation.

. Act as liaison between development, test, systems integration and

release management groups. Responsible to oversee the Development

group and assign tasks as and when required.

. During the Design and development phases, verified if business

requirements did require any modification based on specific technical

limitation/s

. Developed ad hoc reports based on technical requirements including

unit testing of the developed reports.

. Performed quality assurance, test and verify requirements during

development and implementation using Oracle tools: Oracle Discoverer,

Toad and Microsoft Access.

. Compilation of monthly results using computerized database for

reporting purpose & variance analysis of results.

. Excellent interaction with cross-functional teams

. Great customer interfacing skills and customer orientation

Environment: Microsoft Project, Crystal Reports 9.5/10.0, Crystal

Enterprise BOXI, Oracle 10g, Toad 6.3.3.1, Power Builder 7.0, Microsoft

Access 2000, SQL Server 2000, HP Unix 11.0, PVCS Version Control, DOORS,

Windows 95, Windows NT 4.0,, PL/SQL, Ab Initio 2.11, GDE 1.12, Sun Solaris

2.8, Windows NT, and Rational ClearCase.

Lucent Technologies, FL

May 02 - Feb 03

Crystal Report Developer

Responsibilities:

. Involved in business requirement gathering and translating in these

requirements to technical specifications.

. Developed Forms that allow editing the data from multiple tables using

MS Access.

. Created group of update, insert and transform queries.

. Worked on database connections, SQL Joins, Loops, Indexes, Aggregate

conditions, Parsing of objects and written TSQL procedures and

functions for processing business logic in the database.

. Generated complicated reports using sub reports, developed

parameterized reports and created charts by using Crystal Reports 8.5.

. Generated reports by using Stored procedures and generated

Parameterized, Drill Down reports.

. Developed reports with parameters, sub-reports, cross-tabs and charts

based on Stored Procedures and Queries by using Crystal Reports 8.5.

. Created lot of complicated queries involving sub queries, correlated

queries for generating finance related reports.

. Created report templates, developed Ad-hoc reports, complex reports

(e.g. reports from multiple data sources), drill down capabilities by

using Crystal Reports.

. Generated finance related report for the risk management group for

analysis..

Environment: Crystal Reports 8.5, Crystal Enterprise 8.5, Oracle 8.1.6,

Sybase, SQL Server 2000, TSQL, MS Access 2000, CVS, Remedy, Autosys, Win

SQL, Java, JSP, Unix Shell Scripting, Sun Solaris 2.7 and Windows 2000.

Standard Chartered Bank, New Delhi

Oct 98 - April 01

Crystal Report Developer

India Hit, New Delhi

Mar 98 - Sep 98

Programmer/Analyst

EDUCATION:

Bachelors in Economics (Hons), Delhi University, India, 1996

Contact this candidate