Sql Server Data

Sailaja Gurram

Phone: 651-***-****(H), 952-***-****(M)

Johns Creek, GA 30097

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

[pic]

Professional Summary

More than 8 years of IT experience with wide variety of skills. Specific

strengths includes testing, application support, SQL, data loading and

configuring, data analysis, database maintenance, reporting, campaign

designing, batch processes automation. A solid background in the design and

analysis of software projects coupled with a strong background in SDLC

process. Endowed with good communication and inter-personal skills.

Technical Skills

Database : SQL Server 2005/2008, Oracle 9/10g/11g, MS

Access and

MySQL 5x

Languages : ASP, HTML, Java Script, VB Script, C++, SSIS

Reporting tools : Business Objects, Crystal Reports, SSRS

Platforms : Windows 2000/XP and IIS 5.0

Network Protocols : TCP/IP, FTP and HTTP

Microsoft suite : Word, Excel, Outlook Express

QA Tools : Quick Test Pro 9x, Quality Center

9.2, Bugzilla, Q-Track

Campaign Management Tools: UNICA, Noosh

Scheduling Tools : Tivoli Workload Scheduler, Windows

Scheduler

Workflow Tools : AMI Imaging & Workflow tools, Oracle

IPM

Other : PGP, Unix, FTP, Sharepoint

Professional Experience

Technical Support Analyst October 2013

to January 2014

Backoffice Associates:

BackOffice Associates is a worldwide leader in information governance and

data migration solutions focusing on helping customers to manage one of

their most critical assets - data. Back office develops and sells different

products to clients to clean up and manage data.

. Provided technical support to various products installed on client

machines.

. Did research and triage various issues from clients.

. Resolved different types of technical issues encountered by clients.

. Escalating critical issues to development team to resolve in timely

manner.

Environment: SQL Server 2008 and Jive

Technical Support Specialist/ QA (Contractor) November 2012 to

September 2013

ING

Image and Workflow application is a client server underwriting application

used by underwriters to arrive at an underwriting decision. This system

interfaces with many upstream and downstream applications using vendor

tools such as Pilotfish, AMI Imaging & Workflow and Oracle IPM tools.

Responsibilities:

. Scheduled various batch processes with Tivoli Workload Scheduler.

. Wrote stored procedures in SQL Server for data access and updates.

. Wrote various SQL scripts to fix production issues and to setup test

data.

. Triaged various production issues to find out root cause and also

fixed those issues if they are related to data changes.

. Analyzed requirements with developers, business analysts and Team

leads for application enhancements.

. Wrote and executed test cases to perform Functional and Regression

testing.

. Worked closely with developers and business analysts to resolve

defects.

. Created change tickets to apply data updates in production.

Environment: Windows XP, Visual Basic 6.0, MS Access 2010, SQL Server

2005, Quality center, Oracle IPM, Tivoli Work Load Scheduler, Active Agent,

Record Activator, Email Collator, Lotus Notes, Service-now, MS Share Point

and Visio.

Quality Analyst (Contractor) December

2011 to June 2012

Questar Assessment, Inc

Questar offers a full spectrum of solutions for the educational assessment

market including flexible, customizable services and complete products for

states, school districts, and other clients. As a quality analyst worked on

score point application.

Responsibilities:

. Analyzed requirements with developers, business analysts and

provided my inputs.

. Wrote and executed the test cases to perform System, Functional and

Regression testing.

. Worked closely with developers and business analysts to resolve

defects from start to end.

. Performed all cycles of system testing.

. Wrote and edit SQL queries for database testing and reports

verification.

.

Environment: Web and Windows XP, IIS, SQL Server, SQL, .Net and Q-Track

Marketing Analyst (Contractor) June 2011 -

November 2011

Thomson Reuters

Eagan, MN

The Response Marketing Department at Thomson Reuters sends direct mail to

customers to sell new products and increase the subscription list for their

products. They also create telemarketing and email campaigns to increase

the sales in different ways.

Responsibilities:

. Adding new product information to Unica plan.

. Set up new offer codes for different projects.

. Creating flowcharts for list generation by using existing campaign

templates.

. Posting new list counts to Unica plan and noosh.

Environment: Windows XP, Unica, Noosh, Business Objects and FTP

Campaign Analyst (Contractor) August 2010 -

May 2011

Best Buy

Richfield, MN

Marketing campaign division in Best Buy sends emails and direct mails to

customers to promote product deals, coupons and targeted marketing

materials based on customer purchase history and personal information.

Responsibilities:

. Analyzing the campaign requirements with marketing team and Project

managers.

. Design the campaign according to the requirement by using Unica

software.

. Wrote complex SQL queries to pull the data according to the

campaign requirements.

. Creating database tables and loading data into tables as needed.

. Verifying extracted campaign data according to requirements.

. Transfer the data to appropriate vendors and processes.

Environment: Windows XP, Oracle 11g, SQL Developer, Unica, SQL, PGP, Unix,

FTP and SharePoint

Quality Analyst (Part-time contractor):

May 2009 - July 2010

Autobasthi.com is an online portal where automobile buyers and sellers can

connect to sell and buy cars/bikes.

Responsibilities:

. Analyzed requirements, detailed design, and formulated test plan

for the functional testing of the application.

. Worked closely with development and QA team to resolve defects from

start to end.

. Participated in team meetings and design sessions and provided my

inputs.

. Re - running failed test scripts after the new build from dev team.

. Wrote and executed the test cases to perform System, Functional,

Regression testing.

. Loaded Automobiles make, model, style, features and specifications

data into SQL Server database.

. Loaded City, State, County (Dist) information into database.

. Wrote and edit SQL queries for reports and testing.

. Logging production defects with detail steps to reproduce them and

interacted with developers until resolution.

Environment: Web and Windows XP, IIS, SQL Server, SQL, .Net and BugZilla

Technical Support Engineer/QA (Employee): August 2005- Feb

2009

API Outsourcing

Eagan, MN

Programming Languages : HTML, JavaScript, Perl Script and SQL

Database : MySQL Server 5.1, SQL

Server 2005/2008

Tools : Query browser, SQL Yog,

MS Office, Wiki

QA Tools : Bugzilla

API offers services that transform companies accounts payable, accounts

receivable and document management processes to minimize the labor-

intensive work associated with back-office processing. Freight Payments

system is a web based workflow application built with lot of business rules

for paying customer invoices.

Responsibilities:

. Involved in design, creation and maintenance of database schemas.

. Loading and cofiguring data in the database and testing invoice

flow process in Freight Payment System for different customers.

. Did data manipulation in MySQL and SQL Server databases to resolve

production issues.

. Wrote complex SQL queries for ad-hoc reports, data analysis,

testing and issue resolution.

. Worked with large amounts of data to resolve issues and analysis.

. Provided Back end support for different complex applications.

. Worked closely with customer support, development and QA teams to

resolve customers Issues from start to end.

. Troubleshooting, analyzing, resolving, tracking and escalating

technical issues

. Documented troubleshooting and problem resolution steps on wiki for

other team members.

. Participated in application design sessions.

. Developed Templates for software applications with CSS, HTML and

JavaScript.

. Involved in monitoring and trouble shooting of invoice loading

process. Resolved issues by checking log files.

. Restarting all test and production servers on regular basis.

. Monitoring batch processes on all test servers for testing purpose.

. Wrote Test cases for testing the invoice flow from Data entry to

Paid screens.

. Logging defects with detail steps to reproduce them and interacted

with developers until resolution.

Quality Analyst (Contractor)

Feb 2005 - July 2005

Emerging Soft

Edina, MN

EmergingSoft develops different software products for small to midsize

companies. Worked on product called Meeting planner, which provides users

the ability to easily and quickly schedule conference rooms, video

conferencing, equipment and catering through the familiar Microsoft Outlook

client or web interface.

Responsibilities:

. Involved in the design stages of the Application and participated

in the meetings with the client and the development team.

. Involved in designing test plans with the testing manager.

. Actively involved in test case preparation and evaluation through

peer reviews.

. Extensively tested Graphical User Interface Components.

. Performed Functional, System and Regression testing.

. Investigated software defects and interfaced with developers to

resolve technical issues.

. Assisted the users in beta testing of the application.

. Responsible for documenting the application features.

Environment: ASP.NET, VB.NET, HTML, JavaScript, MS Access and IIS.

Research Assistant Jan

2003 - Jan 2004

Department of Biosystems and Agriculture Engineering, University Of

Minnesota Twin Cities, Minneapolis, MN

Programming Languages: C++

Programming Tools: Visual Studio 6.0, Visual studio.net 2003, Excel

Databases: MS Access 97

Developed various Engineering applications in visual C++ and C++.net, to

pass values to programs and print results to file. For some applications,

used dialog based and multiple document interfaces with MFC. Code was

divided into multiple classes. Simulated data is stored in Access Database.

Several reports generated from this data using Microsoft Access. Used

Excel spread sheet for calculations and drawing graphs.

Education

Finished Quality Assurance Training, Alevar technology, Apple Valley,

Minnesota.

Diploma in web programming, Hennepin technical college, Eden Prairie,

Minnesota.

Diploma in computer applications, Hyderabad, India.

MS in Agriculture Science, ANGRAU, Hyderabad, India.

References

Available on request.

Contact this candidate