Quality Assurance Sql Server
Resume:
Rosy Shrestha
*************@*****.***
TECHNICAL SUMMARY
Operating Systems : Windows Vista, XP, window
****,****** **. ****** **,Free BSD (UNIX)
Databases : Oracle 10g, MS SQL Server
7.0, Access 2007
Reporting : Crystal Reports
Enterprise 9 and crystal report 11
Languages : HTML, Visual basic
6.0,C++, object-oriented programming language
Tools : MS Office 2007, MS
Visio2007, MS Project, Dreamweaver MX, Front Page,
Adobe Photoshop,
Page Maker,.
Others : UML, IE 5.0, Tomcat
5.0, Putty
EDUCATION
MS Information Systems National university, CA, USA
BS Computer Engineering Kathmandu University, Nepal
Professional Experience:
Academic advantage 01/2011 -untill now
-Teaching K-8 math and English
Five Acres, CA - 06/09 - 09/09
SQL developer/Report Developer (Contract)
- Planned, developed reports using Crystal Report (business Objects XI) and
SSRS
- Created stored procedures, view and queries for reporting using Microsoft
T-SQL Created Billing report for mental health department.
- Retrieved patient information from database.
- Worked with business users, analysts and data warehouse architects toward
the design and development of BI solutions.
- Created Standard report, sub-report, cross tab, dynamic report.
- Analyzed and developed business requirements, designs and specification
to address needs.
- Completed technical designs and specification to support business
requirements.
- Updated view, table and stored procedure.
Environment: SQL 2005, Crystal Report XI, Tier, SSRS, Oracle 10g
Transamerica / Teksystem, CA - 11/08 - 02/09
SQL Report Developer (Contract)
- Planned, designed, and implemented application database code objects,
such as stored procedures and views.
- Built and maintained SQL scripts and complex queries for data analysis
and extraction.
- Performed quality assurance of report.
- Designed database and table, modeling.
- Identified data issues and provided recommendations for resolution to
ensure optimal performance.
- Liaised with project management and development teams to identify and
implement reporting, control, and automation opportunities to improve
overall access to information.
- Experienced in developing and monitoring SSIS Packages and DTS.
- Experienced with SQL Server and T-SQL in constructing tables, user
functions, views, indexes, relational database models, and data
integrity.
- Created test scripts for quality assurance of report.
- Coordinated UAT testing between IT and the business.
Environment: SQL 2005, SSRS, SSIS, Excel, Word,
Getty Center / Ensynch, CA - 04/08 - 09/08
Business Systems Analyst/Report Analyst (Contract)
- Wrote T-SQL to create report.
- Developed report prototypes and reviews with business stakeholders.
- Linked tables, imported data from multiple sources, merged/purged,
formatted, created unique keys in a data record.
- Produced standard daily, weekly, and monthly reports.
- Reviewed ad-hoc reports requirements, analyzed data, and produced ad-hoc
report requests to meet specifications outlined by business stakeholder,
or Manager of Reporting and Process Improvement.
- Analyzed historical ad-hoc report requests, and identified opportunities
to develop self-service reporting capabilities.
- Managed Relational SQL Databases.
- Tested different application in Vista.
- Worked closely with end-users to identify and develop reporting
solutions.
- Partnered with end-users to develop requirements for reporting, including
translating non-technical requirements into technical solutions.
- Developed both ad-hoc and standard reporting solutions using appropriate
tools.
- Integration of MS SQL 2005 database with Access and Crystal Report.
- Ability to analyze end-user requests and transformed them into
appropriate reports and data extracts.
- Reported the status, issues, possible business impacts and risks within
projects.
- Transition of existing operational reports from various publication
sources MS Excel & MS Access.
- Created Crystal Reports Workshop System.
Environment: Vista, Access 2007, Excel 2007, Novell GroupWise, Crystal
Report 11, SQL 2005, data modeling.
Returned to school to obtain her Master's Degree - 2005-2007
Unlimited Software Pvt. Ltd., Nepal - 01/2000 - 12/2004
Software Engineer (Full-Time)
- Collected business requirements for all Nepal school database systems of
year 2000 for His Majesty the Government, education ministry funded by
Danida (Denmark non-government Organization), using SQL Server as
information database.
- Participated in whole life cycle including defining requirements,
designing, coding, and writing stored procedures, triggers and views.
- Performed analysis, design and development SQL Database (Tables, Primary
and Foreign Keys, Indexes, Stored Procedures, Triggers, Cascading
Updates, Default Values, Database Access policies).
- Documented use cases using UML diagrams and also documented business
requirements.
- Analyzed the requirements and identified the business needs and
documented the Functional Specifications.
- Worked on Middle tier for different functionality based on their
requirement.
- Coordinated with users, development team and ensured that all the
required information is extracted and filled in for the smooth
progression with the development.
- Prototyped the interfaces using Visual basic. Got them reviewed by users.
- Documented reporting requirements and established the test environments.
- Reviewed the development process and help co-ordinate the milestone
releases for users.
- Designed test case and test data.
- Functional tested various scenarios and identified bugs.
- Documented bugs in bug tracking system.
- Reviewed bugs with the development team and prioritized based on user
needs.
- Regression tested bugs and verified it in the system.
- Ensured delivery of bug free application for multiple release versions.
- Generated more than 200 reports for decision makers by using SQL query in
Access.
- Created multiple reports including data flow diagrams, multi-table joins;
inner, outer and nested queries.
- Generated report templates and collaborated with cross groups to
eliminate duplicate work which resolved client queries quickly and saved
money.
- Database system for Capacity Assessment Survey - carried out by
Organization Development Centre (ODC), using SQL Server 7.0 as back end
database and Visual Basic as front end interface, 2001 and SQL Server
DBA.
- Client/Server based Data Entry Project for Star Point Cards Sales Company
(United Kingdom), using Visual Basic and Access 2001.
Environment: MS Office, Visio, Visual basic 6.0, SQL Server DBA 7.0,
Access, Excel, RDB design, MDX programming, iterative development, Crystal
Report.
Instructor 01/2000- 01/2002
Unique Academy, Nepal
. Taught Hardware, Networking, Software engineering, database, Object
Oriented Programming
. Teaching labs: Programming Object Oriented C++ and taking project
under C++
Contact this candidate