Project Sql Server
Resume:
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