Sql Server Quality Assurance

Sree Varanasi

Rockville, MD

Phone: 301-***-****

Email: *****@*****.***

TECHNICAL SKILLS

. Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft

SQL Server 2008, Microsoft SQL Server Integration Services (SSIS)

. Oracle 10G, Oracle 11G

. Toad for Oracle, Toad Data Modeler

. Microsoft Visual Studio 2005, 2008

. Erwin data modeler, Microsoft Visio 2005,2007

. SAP BusinessObjects Data Services

. Configuration Management - IBM Rational 6 and Rational 7, IBM

Rational Team concert

. PeopleSoft CRM, PeopleSoft Student Administration, Epiphany

Campaign Management & Analytics, Association Management Software

. Windows 98/NT/XP/2000/2003/2008

. Experienced in the use of agile approaches for a software

development project, including test driven database development

and scrum.

. Security Clearance -Secret

PROFESSIONAL EXPERIENCE

4/2007 - 9/2013 URS Federal Services, Inc, Bethesda, MD (Employment ended

due to termination of government contract)

Lead Database Engineer

. Served as the lead Database Engineer/Developer for multiple

projects based on SQL Server and Oracle database for Department of

State contract.

. Write/modify SQL Server database scripts (DDL and DML) for the

production deployment of passport systems software.

. Wrote/modified PL/SQL scripts in Oracle 11g database using Toad

for Oracle and PL/SQL database scripts for (DDL and DML) for the

production deployment of passport systems software.

. Worked on SQL Server database migration to Oracle 10g/11g

database. Converted, modified and compiled SQL Server database

tables, triggers, functions and stored procedures to Oracle.

. Created functions, stored procedures and T-SQL scripts in SQL

Server 2000 and SQL server 2005.

. Modified the transact SQL code as needed to support SQL Server

2005 SSIS packages and SQL Server 2000 Data Transformation

Services Packages (DTS). Also briefly used SQL Server 2005 SQL

Server Analysis Services (SSAS) to build a proof of concept for a

data warehousing project.

. Review and provide feedback on developers SQL Server code

(functions, stored procedures and sql server queries) using visual

studio 2005.

. Worked on database migration from SQL Server 2000 to SQL Server

2008 database

. Worked on a proof of concept for a project using SAP

BusinessObjects Data Services.

. Performed database reviews to ensure the database development

guidelines/standard are followed by application developers for

various projects of the state department contract

. Collaborated with application developers in designing, building

and modifying database schemas.

. Worked on data modeling, database design and data dictionary

during software development phase.

. Performed backup/restores and performance tuning databases for

passport systems

. Troubleshoot and resolved frequent production database issues and

assist the production support team as needed.

. Wrote database installation guides and perform unit testing, code

reviews, peer reviews, software and design specification reviews

for deployment of software application.

. Assisted QA team with database deployment scripts during the

software testing phase and database related tasks and issues.

. Assigned to Rational 7.0 product upgrade team and migrated data

from legacy database (SQL Anywhere) to IBM DB2 database.

. Served as a backup Database Administrator/developer for the

database development group for each project as needed. Serve as

the primary database administrator/developer for configuration

management team.

4/2002 - 6/2005 Envision EMI LLC, Vienna, VA

Business Applications Director

. Led and managed team of seven developers and database

administrator in the ongoing development, operation, maintenance

and integration of our PeopleSoft CRM, Student Administration and

Epiphany Campaign Management applications.

. Worked with third party vendors, consultants and offshore

resources for ongoing maintenance, support and enhancements of

PeopleSoft application.

. Led and managed Data Manipulation and data quality efforts for

mission critical data for direct marketing.

. Worked with the project manager in vendor selection, requirements

gathering, architecture design, implementation and roll out of

PeopleSoft CRM 8.8 and Student Administration 8.14. Participated

in all phases of the software development lifecycle.

. In parallel to the PeopleSoft implementation, led and managed

implementation of Epiphany an Online Analytic Transaction

Processing System (OLAP)

. Led and managed data migration from a Fox Pro based legacy system

(OLTP system) to PeopleSoft CRM and Student Administration.

. Responsible for recruiting development team for PeopleSoft and

Epiphany.

. Responsible for managing implementation of Epiphany to support the

PeopleSoft CRM as the data source.

. Involved in the modification and customization of Epiphany Star

Schemas and extractions to support PeopleSoft as data source.

Senior Database Administrator /Developer

. Managed team of data analysts for the Epiphany system (data

warehouse solution)

. Led the Epiphany team in design, modification and enhancements of

the application for data mining functionality.

. Responsible for managing production data warehouse data marts

ranging from 4 GB to 370 GB.

. Responsible for hardware planning, budgeting and acquisition for

production and development data warehouse solutions.

. Responsible for leading and managing developers and consultants

thru Epiphany version release.

. Responsible for managing updates and upgrades to Epiphany system.

. Responsible for project management, estimating, planning,

controlling and execution of Epiphany upgrades.

. Responsible for backup and recovery, performance tuning and

maintenance of SQL Server 2000.

Database Analyst

. Involved in the upgrade of SQL Server 7.0 to SQL Server 2000.

. Extensively modified and created Epiphany extraction using

Transact SQL.

. Responsible for backup and recovery, performance tuning and

maintenance of SQL Server 2000. Responsible for importing mission

critical data into the databases.

. Responsible for data modeling, designing and building star schemas

to customize the data warehouse tool.

. Experience with data cleansing software- Sagent

. Provided Epiphany software front-end user support.

. Research potential new software applications to improve processes

to format and standardize International data.

. Developed Epiphany end user documentation.

1/1998- 3/2000 GWSAE, Washington, DC

IT Manager

. Database maintenance, writing queries and generating reports in

the database.

. Projects involved developing an intranet, and implementing a new

database management system.

. The responsibilities as a system administrator include support and

maintain PCs and networks in a Novell Netware 5, Windows 95/98/NT

environment, install, configure and provide technical support on

Microsoft Office97/2000, and other Windows applications.

. Staff liaison for Information Technology Special Interest Group.

9/1997 - 12/1997 ICF Kaiser Consulting Group, Fairfax, VA

Associate

. Analyzed power and fuel markets and the effect of changing fuel

prices and deregulation on power sector investments.

. Designed and developed databases to track hourly electric load

data to forecast power prices.

. Worked on wide range of consulting assignments related to power

generating companies.

9/1996 - 9/1997 Orthotics and Prosthetics National Office,

Alexandria, VA

Research Manager

. Responsible for collecting and disseminating statistical data on

the Orthotics and Prosthetics industry to members and the public.

. Duties include developing and designing surveys, interpreting and

analyzing data, and generating statistical reports from the

membership database and external sources.

. Served as computer support for the association.

. Assist committee members and senior staff in their efforts to

review and evaluate research information.

5/1990 - 8/1996 American Public Transportation Association, Washington, DC

Statistical Analyst

. Duties included design and development of databases for public

transit.

. Served as technical support to the staff on membership management

system.

. Worked on various projects involving advanced programming in DBASE

III+, Microsoft Access.

. Designed transit statistical surveys and provided data analysis.

. Developed and published quarterly statistical reports on national and

international public transit ridership.

. Performed research on issues and policies relevant to the industry's

legislative agenda.

. Served as a key contact person on transit statistics to association

members and the general public.

5/1989 - 12/1989 Information Dynamics, Inc., Washington, DC

Financial Analyst

. Developed and automated financial programs for NASA software

reliability and quality assurance projects

. Provided funding justification and task descriptions for NASA

Quality Assurance projects.

. Developed financial presentations for NASA software reliability,

maintainability and quality assurance budget direct and the

Congress.

6/1988 - 8/1988 Department of Justice - Immigration and

Naturalization, Washington, DC

Management Analyst Intern

. Served as computer support for the division.

. Assisted with preparing budgets.

. Developed, generated and distributed budget accounts and reports.

. Worked on a team project to improve, further develop and educate

the general public about the historical significance of Ellis

Island.

EDUCATION

. B.A. in Economics, with minor in Computer Science, University of

Pittsburgh, Pittsburgh, Pennsylvania, December, 1988

. M.S. Computer Systems Management, University of Maryland

University College, College Park, Maryland, December, 1999

TECHNICAL COURSES

. Oracle 10g PL/SQL programming

. Oracle Application development and tuning

. Introduction to Oracle Database 10g for Experienced SQL users

. Oracle 10g Database Administration

. Microsoft SQL Server 2000 Administration

. PeopleSoft PeopleTools Foundation (Tools I and II)

. Epiphany Campaign Management and Analytics Implementation,

Ephipany End User Training

SECURITY CLEARANCE

. Secret

CITIZENSHIP

. United States of America

References are available upon request

Contact this candidate