Sql Server Quality Assurance

Lavanya Nookala

**** ******* *****

Franklin, TN 37067

Phone: 615-***-****

E-mail: *********@*****.***

SUMMARY

Highly educated and dependable individual with over 3 years of proven

experience developing business applications. Full life-cycle project

development skills include Analysis, Design, Development, Unit and System

Integration Testing, Implementation, Production Support and Maintenance.

EDUCATION

New Horizons: Currently enrolled part-time, updating skills and earning

certifications in SQL 2008 and .NET

Bachelor of Engineering in Computer Science, Madras University, Chennai,

India

1

2 Computer Skills

Web: VB.Net, ASP.Net, ASP, IIS, HTML, VB Script, Java Script, FrontPage,

Visual Interdev, JCreator, Java (Training - Nashville State Tech Community

College)

RDBMS: MS SQL Server, Oracle, Access, SQL Loader, SQL Query Analyzer,

WinSQL

Data Warehouse: BASE/SAS(PC/UNIX), SAS/PROCS, SAS/MACROS, SAS SQL, SAS

Enterprise Guide, Informatica and Business Objects (Training)

Languages: C#, C, Visual Basic, SQL, T-SQL

Tools: Word, Excel, Adobe Photoshop

Operating Systems: MS-DOS, Windows, Unix

PROFESSIONAL EXPERIENCE

1 The Adam Group Inc. of Middle Tennessee 05/2007 - 02/2008

2 Franklin, TN

Applications Developer

Gathered requirements, designed, developed, tested, and implemented several

Intranet-based applications that included web pages for each individual

Department, a company-wide Time Tracking System, and Nurse recruitment

information

Database input/output with SQL DBA

Developed stored procedures on SQL Server 2005 database (used Access as the

"test" environment prior to moving any procedures into the production

environment)

Developed scripts (Java Scripts) to embed information on marketing

brochures

Identified and Removed duplicate entries in the raw data (related to nurses

being recruited) received from clients and then imported into the SQL

Server database

Provided production support

Environment: VB.Net, C#, ASP.Net, Java Script, MS SQL Server, IIS, Access,

Excel

3

4 AIM Health Services, Inc. 11/2005 - 11/2006

5 Franklin, TN

6 Data Analyst

Worked as a Data Analyst within the Data Mining Group and was assigned to

work on data for specific insurance companies (the clients of AIM

Healthcare)

Analyzed data and contractual information for assigned clients (insurance

carriers) to discover and provide suspect overpayments for Analysts'

auditors' validation for quality, quantity, and accuracy

Developed effective, revenue-producing queries (developed 10 to 15 queries

per day), which resulted in recovering over payments for the insurance

carriers that made to the original healthcare providers

Researched additional service areas (i.e., home healthcare, pregnancy), for

identifying additional effective revenue-generating queries

Knowledge of HIPAA Standards.

Environment: SQL Query Analyzer, WinSQL, Excel

The State of Tennessee 01/2005 - 07/2005

Nashville, TN

Statistical Programmer Specialist

Responsible for the design, programming, testing, and quality assurance of

projects that support the TennCare health plan member, claims and

utilization data from different insurance companies' commercial databases.

Includes formatting, editing, manipulating and merging of large-scale data

Executed on-going and ad-hoc reports and analysis pertaining to product or

customer analysis

Maintained and enhanced the code for existing programs, adapting functions

as appropriate to conform to project requirements defined in technical

specifications

Created SAS macros to consolidate and streamline monthly routines

Responsible for producing SAS datasets, flat files, and reports to support

both internal and external clients

Exported-imported SAS data sets to Excel, Access

Created and maintained processes that transport data from / to the SAS

system to other platforms

Managed large volumes of data on multiple platforms including Unix and

Windows

Worked with the senior analyst and other key people to evaluate and

implement initiatives for appropriate reporting needs

Environment: SAS, Oracle, SQL Server, Access, Excel and SQL Loader

Web Developer (Contractor) 06/2003 - 11/2004

Nashville, TN

Modified www.nashvilledigest.com, www.nashvilleparent.com and

www.zanies.com website contents on daily basis

Provided production support

Environment: HTML, Photoshop and Front page

www.willowtrace.com web site designed and developed to provide information

regarding rental space available in Willow Trace buildings in Nashville

Responsibilities included development, testing, installation and

maintenance of various web pages, production support

Environment: Java Script, HTML and Front page

www.kokila.com web site designed and developed to provide India related

information available in India viz., movies, songs, newspapers and

magazines in various Indian languages, banking information and quiz on

Indian history

Also provides India related information that is available in USA viz.,

Indian Groceries stores, Jewelry stores, Restaurants and Temples

Responsibilities included analysis, design, development, testing,

installation and maintenance of various web pages, including the web pages

that dynamically access and manipulates back-end database information

Environment: ASP, SQL Server, Java Script, VB Script and HTML

References Available Upon Request

Contact this candidate