Sql Server Quality Assurance

Raisun Inc., ******@******************.*** Ph : 732-***-****

Sridharan Ramaswamy

Summary:

. Over 10 years of information systems experience in client server/internet

technologies using Crystal Reports 2008/XI/10.0/9.0/8.0/8.5,Crystal

Enterprise XI/10.0, ASP, Visual Basic, VB.NET, VBSCRIPT, JAVASCRIPT,

HTML, Oracle 9i/8i, PL/SQL, SQL Server 2005/2000/7.0/6.5, DB2

. Highly motivated Information Technology professional with extensive

experience in full Software Development Life Cycle (SDLC), including

project planning, and system design and development.

. Possess strong analytical and technical skills, excellent communication

skills, strong leadership and expertise in designing, developing.

. Extensive experience in interacting with the end users for understanding

the business requirements and translating them into technical

processes.

. Attended training in Informatica 7.0 and Business Objects ( Mar '07)

Technical Experience:

Languages/Technologies Crystal Reports XI/10.0/9.0/8.0/8.5, VB.NET,

Visual Basic 6, Active Server Pages, VB

Script, Java script, HTML, COM, COM+, ADO

Software Development Visual Studio. NET, Visual Studio, Visual

Tools Source Safe, Visio, DreamWeaver, FrontPage

Database Oracle 9i, MS Sql Server 2005/2000/7.0/6.5,

MS Access

Operating Systems Windows 2000/XP/NT/98/95

Professional Experience:

Client Bristol-Myers Squibb, NJ

Duration Jul' 07 - Sep' 09

Environment Crystal Reports 2008, Oracle 9i, Crystal Enterprise

2008

Role Senior Technical Consultant

Remedy is a ticket management system that has several major functions like

Problem Management (Helpdesk), Asset Management, Change Management, Work

Requests. Remedy Problem Management is a functionality used by BMS support

personnel, this functionality provides the ability to record requests for

assistance or reported problems with supported hardware and software. The

Remedy Asset Management application is used in BMS to create and maintain

asset records for supported assets. Remedy Change Management enables BMS

users to assess the impact, risk and resource requirements associated with

these changes. Remedy Work Requests is a functionality used by BMS Client

and Technical Services groups, this functionality provides the ability to

track the type and quantity of requests not captured by the Helpdesk

(Problem Management) or Change Management functionalities.

. Primary responsibility is to understand the requirement of the legacy

report, document the requirements, create the appropriate database

object, and create the new report.

. Migrated reports from Crystal Reports version 10 to version 2008.

. Created several full client complex reports using multi data providers

and different functionalities of Crystal Reports 2008 like slice and

dice, cross tab, drill down.

. Several simple, complex and Ad-hoc reports were created having Slice and

Dice, Drill Down, Cross Tab, Master Detail and Formula.

. Created complex queries and stored procedures in Oracle 9i.

. Testing the reports with the test database and moved the reports to the

production environment.

. Deployed, Scheduled reports in Crystal Enterprise 2008.

. Worked on assigning various User level group access.

Client Principia Partners LLC, NJ

Duration Feb' 07 - Jun' 07

Environment Crystal Reports XI, Oracle 9i

Role Senior Programmer

. Primary responsibility is to understand the requirement of the legacy

report, document the requirements, create the appropriate database

object, and create the new report.

. Created several full client complex reports using multi data providers

and different functionalities of Crystal Reports XI like slice and dice,

cross tab, drill down.

. Several simple, complex and Ad-hoc reports were created having Slice and

Dice, Drill Down, Cross Tab, Master Detail and Formula.

. Created complex queries and stored procedures in Oracle 9i.

. Testing the reports with the test database and moved the reports to the

production environment.

. Worked closely with the development team in integrating these reports

with the front-end application.

Client Ajilon Solutions

Duration Oct'06 - Jan'07

Role Senior Programmer

Platform Crystal Reports XI, Sql Server 2000, ASP.NET, VB.NET

Compliance System

. Design & develop the complex reports using Crystal Reports XI and plug

them with the existing .NET application.

. Business analysis user requerements for the ad-hoc reports and reports

show Month-To-Date, Year-To-Date Data, reports from Archive Database.

. Design and implement the database elements like Stored procedures,

Views required to be consumed in the reports using Sql Server 2000.

. Create parameterized dashboard reports (these reports show information

from highest level by company and can be drill-down to single product

using hyperlinks and drill-down technique), cross-tab, conditional,

Top N, Summary, Form, OLAP reports and Subreports.

. Multiple complex reports were created using customary calculations,

running totals etc.

. Created multiple user interface screens using ASP.NET and business

logic using VB.NET

Client Alliance Bernstein, NY

Duration March 2006 - October 2006

Environment Crystal Reports 11, Oracle 9i, Crystal Enterprise

11,

Lotus Domino, PL/SQL

Helpdesk Reports

Developed complicated reports for the Helpdesk using Crystal Reports

9.0.The report is an analysis of SLA (Service Level Agreement) for each

Request Codes during a period of time. It provides a monthly breakdown of

Request Codes and also a summary. New request codes will be added upon an

activity. The reports generated provide an overall performance chart for

installation & maintenance departments.

. Primary responsibility is to generate the data for reporting system as

well as generate the reports.

. Created several full client complex reports using multi data providers

and different functionalities of Crystal Reports XI like slice and dice,

cross tab, drill down.

. Created several complex web base reports in web intelligence using

alerter, ranks, formulas, sections, sorts, filters and other formatting

options.

. Several simple, complex and Ad-hoc reports were created having Slice and

Dice, Drill Down, Cross Tab, Master Detail and Formulae.

. Published Web reports using Crystal Enterprise XI

. Scheduled and monitored the reports.

. Testing the reports with the test database

. Requirement gathering and proof of concepts.

. Created Complex SQL Queries, views and stored procedures using PL/SQL for

generating complex reports.

Title BOND TRADING APPLICATION

Client Federal Farm Credit Banks Funding Corp,

NJ

Duration July 2005 - February 2006

Environment: Crystal Reports XI, VB.NET, Oracle 9i, PL/SQL and SQL

Navigator

Scope:

The Funding Corporation issues a variety of Federal Farm Credit Banks

Consolidated System wide Debt Securities (Farm Credit Debt Securities) on

behalf of the Farm Credit System Banks with a broad range of maturities and

structures.

BOND TRADING APPLICATION

The Bond Trading Application (BTA) allows addition, modification of all the

bonds traded everyday and generates week, monthly or annual reports for the

various bonds traded. This application is a three tier application

developed with VB.NET and Oracle 9i, PL/SQL, SQL Navigator was used

extensively as the tool for the database. Crystal Reports XI has been used

extensively used for reporting.

The output of the reports is generated in both PDF & Excel formats saved in

a dedicated path.

. Involved in complete Software Development Life Cycle including

. Scoping, Planning, System study and Requirement Analysis

. Process Definition, Technical Reviews, Quality Assurance and

Standardization

. Analyzing, Coding and Implementation.

. Requirement analysis involving current system analysis, user requirements

and, description of new system proposed.

. Preparation of systems requirement specifications.

. Used VB.NET and ADO.NET to define and implement secure middle-tier

components using both connected and disconnected environment strategies.

Components were consumed by web applications and windows applications

utilizing Oracle 9i and stored procedures to perform logical business

transactions

. Designed and developed user interface screens using VB.NET

. Spear-head Code Reviews and Setting Standards for software development

for the team.

. Reports are generated using Crystal Report XI for the application to

create more than 30 reports for the entire securities operation.

. Created several full client complex reports using multi data providers

and different functionalities of Crystal Reports 9.0 like slice and dice,

cross tab, drill down.

. Managed the entire reporting project which was mentored out to Off-Shore

for development.

Title Record Keeping System

Client Name CitiStreet, NJ

Duration Aug '04 - Jun '05

Environment: Crystal Report 10.0,VB6.0, ASP3.0, MS-SQL Server

2000, Crystal Report 10.0, VB6.0,COM, COM+,

VBScript, JavaScript, HTML, FTP tool, VPN

Scope:

PlanLinkZ is a record keeping system of the Employee Benefit Plans and

their Contributions towards 401K and other Defined Retirement Plans. The

System helps in getting the information from the Client about their

employee's payroll and plan information. The application imports data from

any payroll processing company and processes the plan details and exports

to the recordkeeping company. This product development was originally done

in Client Server Application with Visual Basic & MS-Access. It was later

moved to web technology.

. Analyzing, Coding and Implementation.

. Developed solutions for diverse programming scenarios using ASP.NET &

VB.NET, employing object-oriented programming concepts such as;

encapsulation, inheritance, polymorphism, and abstraction.

. Used VB6.0 to define and implement secure middle-tier components using

both connected and disconnected environment strategies. Components were

consumed by web applications and windows applications utilizing SQL

Server 2000 and stored procedures to perform logical business

transactions

. Designed and developed user interface screens using ASP3.0

. Reports are generated using Crystal Report 10.0 for the application to

create more than 110 reports for enrollments, participant updates,

contribution transactions, compliance transactions, client details,

customer details, plan information, source details, loan details, plan

source information.

. Creating tables, Building queries using SQL Server 2000.

Title Judicial Information System JIS

Client Name 17th Judicial Circuit, Broward County, Florida

Duration Jul '03 to Jul' 04

Environment Crystal Reports 10.0, DB2, Java, and JSP

17th Judicial Circuit, Broward County serves the citizens of Broward

County. It is the second largest jurisdiction in the State of Florida with

a population of over 1.5 million residents. The Circuit utilizes the

services of 77 full time judges. More information is available at their web

site www.beamis.org. My role in JIS focuses on creating Ad-hoc reporting

using Crystal Reports 10.0, generated reports on various parameters to the

higher management of 17th Judicial Circuit.

Responsibilities

. Primary responsibility is to generate the data for reporting system as

well as generate the reports.

. Created several full client complex reports using multi data providers

and different functionalities of Crystal Reports 10.0 like slice and

dice, cross tab, drill down.

. Created several complex web base reports in web intelligence using

alerter, ranks, formulae's, sections, sorts, filters and other formatting

options.

. Several simple, complex and Ad-hoc reports were created having Slice and

Dice, Drill Down, Cross Tab, Master Detail and Formulae.

. Testing the reports with the test database

. Requirement gathering and proof of concepts.

. Created Complex SQL Queries and used in creation of views, functions for

generating complex reports.

Title Fast Trac (Work Order Tracking System)

Client Name Broward County Traffic Engineering Division, FL

Duration May '02 - May '03

Environment CrystalReports9.0, ASP, VB, SQLServer2000, IIS,

COM/COM+

Scope:

Fast Trac is an intranet application to track the Work Order generated for

the Traffic Engineering Division, Broward County in Florida.

. Involved in complete Software Development Life Cycle that includes

requirements gathering, preparing system requirement specifications,

analyzing user requirements, preparation of High level Design(HLD) and

Low level design(LLD)

. Developed dynamic data driven web pages using ASP and VB

. Developed complex business logic and data access components using VB

. Extensively used ADO for data access in both connected and disconnected

environment strategies

. Creation and Maintenance of Database tables, Views, Stored Procedures in

SQL Server 2000.

. Developed run-time reports using Crystal Reports 9.0

Title Synergy - Primary Health Care System

Client Name ISoft R&D Pvt. Ltd (Banbury, United Kingdom)

Duration Jun '01 - Apr '02

Environment ASP, ADO, VB6.0, Oracle8i, C++, VC++

Scope:

Synergy is a Primary health care product, primarily targeting general

practioner's in United Kingdom. Primary health care is nothing but a

General Practioner's office. This product development was originally done

in C++, VC++ and Visual Basic 6.0.The enhancements like PDS (Patient

Demographic Service), LRS (Legitimate Relationship Service) & PCS (Patient

Consent Service) were developed in .NET. These were the services which were

used to acquire the minimum details about a patient from the Data Centre.

These were done as Web services which will be called from simple ASPX page.

. Team Lead for the complete transition of the product from the parent

company.

. Process Definition, Technical Reviews, Quality Assurance and

Standardization

. Imparting Domain Knowledge from the mentors to the software development

team.

. Developed the ASP pages which will be accessed to acquire the minimum

details about a patient from a Data Centre.

. The business logic for the asp pages were written in VB 6.0

. Requirement analysis involving current system analysis and description of

new system proposed.

. Preparation of systems requirement specifications.

Title Inventory Management System

Client Name Hanco ATM Systems (Milton Keynes, United Kingdom)

Duration Aug '00 - May '01

Environment:

Client/Server Application Visual Basic 6.0, SQL Server, Crystal Report

8.0, COM, Windows 2000

Web Application Visual Basic 6.0, Visual Interdev, ASP 2.0, IIS 4.0, COM,

VB Script, Java Script, SQL Server 7.0, Crystal

reports 8.0

Scope:

Hence ATM Systems is one of the largest ATM Selling companies in Europe.

The Application was a straight forward Inventory Management System. The

customers are allowed to place their orders through the web. The orders

will be scrutinized and processed. The company followed a policy of FIRST

IN FIRST OUT. The stocks will be cleared on FIFO basis from the store near

to the customers address.

Title DaySheet Information System

Client Name Casseys India

Duration Apr '99 - Jul'00

Environment VB6.0, SQL Server 7, Crystal Reports,

ASP, ADO 2.5, COM, MTS

Scope:

The project involves re-engineering of existing Remote Connect Project into

Visual Basic 6.0, SQL Server 7.0 and Seagate Crystal Reports 7.0. The

project involves computerizing 1200 chain of stores in USA. This involves

Remote Connect software for interlinking 1200 stores at various locations

of USA. Purchase Order, Daily Sales, Billing, Stock details are maintained.

Reports are produced using Crystal Reports. Head office reports and

components are developed using ASP, VB & MTS.

Title Tropitone

Client Name Tropitone India

Duration Jan '98 - Mar '99

Environment MS Visual Basic 6.0 / MS SQL Server 7, Crystal Reports ASP

2.0,

ADO 2.5, COM, MTS, Visual Interdev 6, HTML, VBScript

Scope:

The project involves re-engineering of existing Oracle and Pro-C code onto

ActiveX documents using Visual Basic 6.0, SQL Server 7.0 and Seagate

Crystal Reports 7.0. ActiveX documents are required so as to make the

application web oriented. The ActiveX documents were tested in Internet

Explorer. The reports are launched from the internet explorer which acts as

a container for the user document. Part of the whole application is

developed using ASP, HTML, ADO, VB Components, MTS, VB Script.

Title International Tax Management System

Client Name Computer Language Research Inc. India

Duration Apr' 97 - Dec '97

Environment MS Visual Basic 5.0 / MS SQL Server 6.5, VDO, Revelation

Basic

Scope:

International Tax Management System is leading tax management software that

has major user base in USA and Canada. This is the flagship product of

Computer Language Research Incorporation USA. This product takes care of

the Tax of individuals, Corporate Companies and Multi national Companies.

This helps in converting between different tax schemes.

This product was first developed using proprietary software called

Revelation Basic. The system was the phase 1 of this project. The phase 2

involved development, testing and implementation. Visual Basic 5.0 and MS

SQL Server 6.5 are used for development.

Contact this candidate