Rosy Shrestha

310-***-****

abhr2p@r.postjobfree.com

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