Engineer Sql Server

SUJATHA SADAGOPAN

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

Contact: 818-***-****

SUMMARY:

. Senior QA consultant with 7 years of extensive experience in Quality

Assurance, Test Management, build test environment, analyzing System

and functional specifications, business requirements and business

rules to prepare test schedules, identify test requirements, create

test plans, document the testing procedures and test cases to meet the

requirements.

. Solid understanding of quality assurance testing methodology as per

Software Development Lifecycle (SDLC) .

. Lead the test team by co-ordinating the test activities on a daily

basis with the offshore team in India, run a smoke-test on everyday

builds and publishing them to the entire team by tagging it as a

stable build and run the tests on the stable build to test the newly

implemented features. Took the responsibility of publishing the alpha,

beta build release candidates to QA team prior to the final release.

. Have played the role of an application developer for a banking

application called 'Financial Needs and Analysis' for Citibank

customers across the World. Wrote a client module which accepts the

client's personal information. The basic functionality is to help the

customers could plan out their finances and make investments for their

future. Coded in Visual Basic and used SQL Server as the back-end.

. Experience in Manual testing process, QTP Automation, Selenium

Automation, Server side testing and methodologies like Regression

testing, Smoke Testing, Black box, White box testing and Grey box

testing.

. Experience in documenting the testing process using MS-Office products

(Word Excel), Clearspace Wiki and Test Director.

. Has experience to track and report bugs using JIRA, Bugzilla, Rally

and Test director.

. Experience working with relational databases such as Oracle 10g, SQL

Server 7.0 and 2005, DB2 and MySQL.

. Strong exposure on client/server applications and Web-services

testing.

. Involved in testing Web-Services by publishing and accessing them

through the web using the web-services platform elements like SOAP,

WSDL and UDDI.

. Has experience working on the Flexera products 'InstallAnywhere 2009'

tool.

. Has tremendous experience to work closely with Development

Counterparts and resolve any issues smoothly.

. An exceptional team player, able to interact and motivate others to

achieve targets as well as strong ability to assist projects moving

from conception to successful completion.

. Have created and deployed web-services in various application servers

like Apache Tomcat, IBM Web Sphere and BEA Weblogic on diverse

platforms like UNIX/Linux, Windows.

. A proactive individual with a logical approach to challenges, perform

duties effectively within a highly pressurized working environment.

. Excellent communications and interpersonal skills backed up-by-sound

professional ability to work independently as well as a team member.

. Involved in testing the SOAP message security exchanges by providing

encryption and authentication support using various Operational

Policies like wsse-Symmetric Binding Policy, wsse-Asymmetric Binding

Policy, wsse-Transport Binding Policy, wsse-message policy, wsse-

supporting tokens policy (Username token and SAML token).

. Tested the Survey Application which involves different types of

surveys like Point-of-Sale, Fulfillment, Visitor, Visitor Fulfillment,

Offline and Exit surveys across different OS/Browser combinations like

(Windows XP - IE 6.0, IE 7.0, Fire fox 2.0, Fire fox 1.0.7, Netscape

Navigator 7.0, AOL 9.0 & Mac OSX 10.4.4 - IE 5.3, Fire fox 2.0,

Netscape Navigator 7.2, Safari 2.0)

. Involved in installing the product 'Policy Manager' by configuring

various Databases like SQL Server 2005, Oracle 10, DB2 on different OS

/ Browsers.

. Involved in testing Auditing Policies to keep a complete, persistent

record of SOAP requests and faults.

TECHNICAL SKILLS

Languages:

XML, Java Script, Java/J2EE, Visual Basic 6.0, C/C++

Databases:

MS SQL server 7.0 and 2000, Oracle 10g, IBM DB2 and MySQL server.

Technologies: Webservices and XML, Enterprise Java, JDBC and Java Beans,

RMI, Servlets, JSP,EJB, J2EE, IBM Websphere, BEA Weblogic, Apache Tomcat

5.x and 6.x versions.

Test Tools:

Worked extensively on Rally tool, knowledge in Win runner 7.0, QTP 9.0,

Selenium,

Test Director 7.0, SOAP UI 2.5.

LEGAL STATUS:

Green card holder/ Permanent resident of the United States.

PROFESSIONAL EXPERIENCE:

DIRECTV., El Segundo, CA

Feb 2010 - Present

Software Test Engineer

Responsibilities

. Involved in testing Set-top-box applications for the Broadcast

Engineering group.

. Involved in testing Internet facing mobile applications like Program

Guide Web Services.

. Involved in testing Directv Cinema application - Conditional Access

Webservices

. Involved in preparing a test plan and conducted/lead the test-plan

review meeting with the development and the test team.

. Involved in drafting test procedures based on the test plan for

Conditional Access - Authorization web services.

. Involved in back-end testing using Oracle and DB2 databases by

connecting using the Squirrel client.

. Currently assigned to work on DVR addressable ads for Directv Cinema.

SOA Software Inc., Los Angeles, CA

Jun 2008 - Jan 2010

Software Engineer

Responsibilities:

. Involved in testing the Web-based Applications and Services.

. Worked closely with other team members to implement key features and

functionality and delivered a quality product to Customers in a timely

manner.

. Co-ordinated with other SOA Branches within USA and with the off-shore

team regarding the project issues to get them resolved.

. As a sole QA person, was responsible in testing the Company's products

and suggested features to be implemented for better performance.

. Involved in testing Web-services security Policies. (SOAP Message

Protection using various policies like WSSP Symmetric Policy, WSSP

Asymmetric Policy, WSSP Transport Binding Policy, WSSP Supporting

tokens Policy.

. Involved in testing Webservices Authentication, Authorization and

Auditing Policies.

. Created several project related documents and posted in Wikipedia.

. Took part in test case management system evaluation to suggest the

best test tool for integration with the existing test tool JIRA.

. Installed several versions of BEA Weblogic and IBM Websphere in

different OSs like Solaris, Windows, AIX and Linux systems to test the

deployment of web services.

. Involved in backend Database testing like Oracle, DB2,SQL Server 2005

and MySQL.

. Involved in testing the SOA Products in the NetWeaver platform by

configuring and starting the processes in the SAP Systems Manager.

. Involved in testing the Web Services Policy security components.

. Involved in IBM Websphere Application Server installation and

configuration in Windows, Linux, Solaris.

. Ran smoke tests on the product builds. As a part of the Service

Manager Product smoke test:

< Involved in installing the builds.

< Configuring the product with a supported list of databases (SQL

Server, MySQL, DB2 and Oracle).

< Starting the server instance and ensure that web console login

is successful..

< Involved in creating / configuring Management Point container to

deploy the services.

< Create Web Services using the product 'Policy Manager' and host

it on the Management Point.

< Create a contract for authorizing the users to access the web

services.

< Create policies and attach it to the Virtual Web service.

< Using the WSDL URL send messages to the Virtual Service on the

MP using the SOAP client.

< Ensure that there is an appropriate SOAP response for the

request sent.

< Ensure that the usage activity for the transactions are recorded

appropriately.

< Ensure that the performance charts display the success/failure

information in a graphical format and data format.

. Involved in testing the product deployment in Apache Tomcat Server,

Bea Weblogic and Websphere server.

Environment:

Java, UNIX/Linux/AIX/Solaris, Windows, HTML, DHTML/Javascript, XML,

JSP/servlets, (Testcase management tool : JIRA), (Document Management:

Wikipedia).

ValueClick Media Inc., Westlake Village, CA

Jan 2007 - May 2008

QA Engineer

Responsibilities:

On Regression Testing:

. Followed the waterfall model to test these applications through the

phases of requirements analysis, design, implementation,

testing/validation, integration and maintenance.

. Involved in setting up the Test Environment.

. Set all permissions for the Admin user ID to 'Update'.

. Configured the Admin user to have privileges for all accounting

divisions.

. Determined the currency conversion between your Advertiser and

Publisher.

. Ran the check.sh script on each RHEL server to inspect the server

configuration.

. Inspected www server configuration.

. Inspected main database server configuration, build server

configuration, the budget101, budget102 server configurations, the

app1, app2, and app3 server configurations, cmedia server

configuration and accum server configuration.

. Inspected the test1.qa configuration.

. Involved in Publisher Site creation and approval process.

. As an Admin user, configured the Account and Payment information for a

Publisher.

. As an Internal user, configured the Publisher Site information.

. As an Admin user, involved in the creation of a new account for an

Advertiser.

. As an Advertiser, involved in creating several Campaigns with

different Media Types like: Banner, Pop-Under, Sky Scraper, InVue,

Leader Board, Interstitial, Wide Sky Scraper, Medium Rectangle,

Rectangle, Half Page, Flex Banner and In-stream-video

. Involved in creating and applying Virtual Networks to link the

campaigns to the Publisher Sites.

. Created HTML files in our QA environment to enable to In-Stream Video

Ads to get served.

. As a QA Engineer, generated impressions, click and actions on the Ads

and ensured the impression, click, and action counts are propagated to

the main database.

. As a Publisher, inspected the counts and earnings and as an

Advertiser, inspected the counts and served.

. Used Selenium IDE, a plugin to Firefox, to automate a 'Publisher

creation and approval process' feature in the Adnetwork regression

system.

Backend Testing:

. Ensured the campaigns and site are linked in the site target table.

. Involved in working on the new campaign and site data to make sure it

is successfully propagated through the build process and the budget

process.

. Ensured the new campaign and site data is propagated to the cmedia

server.

Bug Testing:

. Involved in the Regression testing of the Ad Network system for Value

Click Media.

. Reviewed software requirement documents like the Engineering

Checklists, Functional spec, the Unit Plan to understand the component

details and business perspective.

. Performed the Database Validation to verify that QA have the necessary

and correct SQL for the release ticket list.

. Performed the Code Validation to verify that we have the expected code

changes in the release branch once it is deployed in QA. We use the

Perforce's client P4V to inspect the code changes in the dev branch

against the release branch.

. Involved in Localization Testing:

. USA Publishers against USA Advertisers.

. UK Publishers against UK Advertisers.

. FR Publishers against FR Advertisers.

. DE Publishers against DE Advertisers.

. Involved in Cross Currency Testing.

. USA Publishers against UK Advertisers

. UK Publishers against USA Advertisers.

. Involved in preparing test cases and executing them.

. Prepared a Test Plan for a Feature Enhancement Project called 'Virtual

Networks'

. . Documented "How to Create, Setup and Deliver In-Stream Video

Campaigns" and posted it in the VC Media Document Management Tool

"SharePoint".

. Involved in interacting with the Engineers, Analysts and Business

executives smartly to resolve issues.

. Involved in running the new feature enhancement tests on different OS

/ Browser combinations.

Environment:

Linux, MS Windows, Mac OS X, Software: Perl, CGI and JavaScript, HTML OS:

UNIX System, Web Dev Platform: MySQL, PHP and Apache web server, SCM

System: Perforce (P4V Client), Bug Tracking System: Bugzilla v 2.22, Doc

Management Tool: SharePoint, Test Automation: QTP, VB Script

Shopzilla.Com, Los Angeles - CA

Feb 2006 - Jan 2007

Sr. Validation and Verification Engineer.

Project Name: Research / Survey Systems.

. Involved in the Functionality testing of the survey system web

application for Shopzilla (online shopping).

. Followed the traditional Waterfall methodology in the beginning and

later implemented the Agile process.

. Involved in finding the bugs, entering them in bug tracking system.

. Worked with the development team to develop test cases and test plans.

. Reviewed software requirement documents to understand the component

details and business perspective.

. Wrote SQL queries to verify GUI front-end results and to extract and

manipulate data to validate test cases/requirements.

. Involved in the functional testing and Regression testing for each

component during the test pass.

. Involved in localization testing.

. Prepared exhaustive test cases and executed test cases manually.

. Designed and executed Quality Test Plans and Test Cases to verify

reliability, accuracy and Compatibility of applications.

. Was also involved in the preparation of the Survey System legacy

documentation.

. Was involved in Database migration functional testing.

. Involved in interacting with developers and analysts to resolve

issues.

. Solely responsible for Survey deployment and release processes.

. Involved in writing QTP scripts and automating them to import 14

million records from the current Survey System to the new Confirm IT

System, in order to pilot a commercial alternative as the solution to

the current technology requirements.

. Involved in testing the response data collection for all the Survey

products.

Environment:

Windows XP, Perl Script 5.6.2, Automation tool: Mercury QTP, Aqua Data

Studio 4.5, (Database), Secure CRT 5.0.Test Management & Defect tracking

tool: Rally 101

International Credential Evaluators, Norman, OK

Jan 2004 - Jan 2005

Credential Evaluator -Office Management

. Evaluated the credentials of foreign students and immigrants from

foreign countries.

. Entered all the client and law office information into a Visual Basic/

SQL server application. This will generate the format required by the

immigration and naturalization service.

. Involved in collecting the financial statements/ prepared invoices.

Covansys India Ltd., (Formerly CBSI Ltd., India)

Mar 2000 - Dec 2000

Visual Basic Programmer/Quality assurance Tester.

Citibank FNA (Financial Needs Analysis).

. Designed, programmed and tested the client module for Citibank - FNA

(Financial Needs Analysis).

. Reviewed software requirement documents to understand the component

details and business perspective.

. Wrote test plans that detailed testing scope, strategy, hi-level test

requirements, and required resources.

. Performing SQL queries to verify GUI front-end results and to extract

and manipulate data to satisfy test cases/requirements.

. Involved in the functional testing, Regression testing for each

component during the test pass.

. Involved in localization testing.

. Prepared several test cases and executed test cases manually.

. Was also involved in the preparation of the User Manual document for

Citibank Indonesia and Citibank Singapore.

. Designed the Citibank- Financial Needs Analysis logo for Indonesian

clients.

Environment:

Windows 2000, Visual Basic 6.0, SQL Server 6.0, and MS-Office, 2000 (Word,

Excel), Test Management tool: Test Director 7.0.

EDUCATION:

. Bachelor of Science in Computer science - University Of Madras. India

- 1996-1999

. Professional Diploma in Software Technology and Systems Management

from National Institute of Information Technology (NIIT), India 1996-

1999

CERTIFICATIONS:

. Microsoft Certified Solution Developer (MCSD) - (Obtained Certificate

of Excellence from Microsoft Corporation for having successfully

completed the Microsoft Certified Programs in Visual Basic, VC++,

Windows Architecture part 1 & 2 and SQL Server).

. Oracle Certification.

. Java/J2EE Certification.

KEY ACHIEVEMENTS:

. Cleared the ASVAB (with a score of 79%)

. Holding a PMP membership from PMI.

Contact this candidate