Engineer Sql Server

Priya Ganta

**************@*****.*** Mobile: 508-***-****

Home: 617-***-****

PROFESSIONAL SUMMARY

• Eight years of IT experience with emphasis in Quality Assurance and engineering of Software applications including Complex Financial Systems, Web, Mainframe and Client / Server Based Applications.

• Experience in helping to establish QA processing and methodologies.

• Ability to effectively communicate project status/issues to a wide technical, as well as business audience.

• Experience with Windows and Unix Operating environments.

• Extensive work experience and expertise in Black Box Testing, Writing Test Plans, Test Cases, GUI Automation testing, Unit Level Testing, System Testing, Integration Testing, Regression Testing, Load/Stress and Performance Testing and code walk through.

• Experience in QA processes and standards, Software Testing Methodologies, Development of test Cases, Design and Execution of strategic Test Plans and Test Scenarios.

• Strong in Requirement Management, Documentation, Report Analysis, Business Analysis, Work Flow Design, Coding, Testing and Defect Reporting.

• Expertise in using testing tools HP Quality Center for Web and Client-Server applications.

• Experience in Back End Testing on databases using SQL.

• Experience in development, analysis, testing and implementation of database applications of RDBMS in SQL Server 2008, SQL Server 2003, ORACLE, SQL Server 7, Sybase and MS-Access.

• Experience in Agile Technology and WaterFall methodologies

• Excellent understanding of the Software Development Life Cycle (SDLC) and QA Methodologies.

• User interface and business requirement analysis experience.

• Ability to quickly master new applications and concepts.

• Excellent Communication, Documentation, Interpersonal Skills, Team Player with good customer interaction.

EDUCATION

Masters in Computer Engineering, Clemson, SC, USA

Bachelors in Engineering, Jawaharlal Nehru Technological University, India

TRAINING

Agile Methodology

Mercury Interactive Advanced QTP 9.0

TECHNICAL SKILLS

Operating Systems: MS-DOS 6.22, Windows 98/95/3.1,NT4.0/3.51,CE/2000/XP/Vista/7, UNIX,

IBM Mainframe OS/390, AS/400, RedHat Linux, AIX, Sun Solaris.

Servers: Windows 2008, Novell Server, NT Server, Windows 2000 / Terminal Server.

Languages: SQL, PL/SQL, Unix Shell, C, C++, Visual Basic, Power Builder, Java, J2EE, C#, UML Rational Rose, CGI, PERL, JavaScript, HTML, XML, XSL,XSD, ASP.NET, ADO.NET, VB.NET

API: WIN32 SDK, Winsock 2.0, ODBC.

Databases: SQLServer7.0/2000/07/08, Oracle 11/10/9/8/7, Sybase

Data Warehouse/BI: Informatica/ETL, Microstrategy

.

QA Tools: Mercury (QuickTest Pro, WinRunner, LoadRunner, Quality Center, Test Director), JUnit, JTest, JProfiler, JMock, Segue Silk, QA Partner, Rational Suite, ClearQuest.

Configuration Mgt. Tools: SVN, CI, Clarity, Perforce, PVCS 6.0, CVS 1.10, Visual Source Safe, Rational Clear Case.

Applications: MS Office Suite, MS Project, Visio, Share Point, Plan View, HP NonStop Tandem DDP Emulator

PROFESSIONAL EXPERIENCE

Thomson Reuters, Boston, MA July’07- Present

Senior Engineer, QA

Description: Thomson Reuters Corporate Webhosting Team hosts the Investor Relation pages for the companies. The team develops, hosts, and maintains more than 2,700 Investor Relations and Public Relations websites for corporations of all sizes. Worked on multiple complex projects like migration of Legacy applications to new environment, change of vendors, web services testing, caching, change of applications from 32 bit to 64 bit, etc.

Responsibilities:

• Analyzed functional and business requirements, attended change request meetings to document changes and implemented procedures to test changes.

• Led testing efforts in terms of effort estimations, team formations with test planning execution and defect management activities from project ranging in various sizes

• Developed Test Plans, Test Cases, Design-Test steps and associated the corresponding requirements.

• Developed and tested installs of the Microsoft Installers(MSI) in the project where we are upgrading the infrastructure from old environment i.e. from Windows 2000 servers to Windows 2008

• Worked on projects which require interaction with various third party vendors like Akamai, MIS Sciences, 10 K Wizard, West Law API and Morning Star

• Responsible for the development and testing of test cases for various Web Services Interfaces and Windows Services for Hosted (Phoenix Tool and Phoenix1) and Non-Hosted (irXML) clients.

• Tested the caching for the web based applications

• Worked extensively on XML, XSD and HTML

• Led the testing effort of the Web Services and Web based apps installations on the windows servers.

• Performed Back End testing by writing SQL statements for various business transactions on SQL Server.

• Developed and debugged complex SQL scripts/queries for data verification.

• Performed API Level testing by creating XML input files.

• Extensively used UNIX commands and performed batch testing using UNIX shell scripts.

• Deployed DB and front end code on weekly basis to QA and pre-prod environments

• Coordinated with application support during the releases for code deployment to production

• Worked on multiple browser testing of the applications

• Smoke tested applications that are built on a weekly basis.

• Development QTP scripts for regession tests for quaterly releases

• Worked with automation lead in developing the automation scripts for the quaterly releases

• Coordinated and conducted meetings with various teams including Product Management, Release Engineering and Development to resolve issues in a timely manner.

• Responsible for coordinating and execution of Regression testing for each Quarterly Releases and patch releases.

• Provided White Box, Unit, Functional, Regression, System, Integration, UAT, Load, Stress and Performance Testing

• Led weekly status meetings showing progress and future testing efforts to the QA Manager

• Worked with the business teams to perform UAT by providing them all the detailed information and coordinating with them throughout the process

• Conducted the post mortem reviews after every project for the lessons learnt during the project

• Interacted with the off shore and US based teams for various projects

Environment: HP Quality Center, XML, XSL,XSD,XBRL,HTML,ASP.NET,VB.NET, Java,J2EE,SOAP UI,Oracle,SQLServer,IIS,MSOffice,QTP,Project,Visio,TeamTrack,Clarity,Agile,SVN,SharePoint,FTP,Unix,XML Spy, Windows 7/Vista/XP, Windows 2003, Windows 2008, TPM, Microsoft Installers, IE 6.0, 7.0, Firefox, Netscape, Chrome

State Street Investments (Investors Bank and Trust) , Boston, MA May’06- Jun’07

Business Analyst / SQA Engineer

Description: IBT provides services to a variety of financial asset managers that include services such as global custody, multicurrency accounting, fund administration and middle office outsourcing, and value-added services.

The project involved testing of ATI (Automated Trades Instruction), RTE (Remote Trade Entry) and IVL (Invest Lend).

ATI is a PowerBuilder application. ATI involved testing of the incoming Trade Files that are instructed out to various DTC, FED and Intl Markets using Messaging tools such as SWIFT.

RTE is an oracle database where trades files, coming from sources such as MTECH, Mercator, ETL, Swift Alliance, FTP, etc, are posted. Once the trades are posted they are validated by Accounting and Custody, an internal bank application, and then posted to their respective destinations.

IVL is a web based Securities Lending application.

Responsibilities:

• Worked as the Business Analyst for change requests for requirements gathering and business analysis.

• Involved in maintaining, enhancing and trouble shooting of the application according to the needs of the business users.

• Prepared Business System Requirements document, which involved writing the System Requirements using UML methodologies.

• Participated in requirement analysis and prepared System Test Plans.

• Mapped data of the new client’s test files to the already existing remote trade entry database.

• Analyzed system specifications, designing and development of test plans.

• Reviewed the Business Requirements Document and prepared detailed Test Plan and Test Criteria for the testing effort using Mercury Quality Center.

• Conducted Manual as well as Automated Testing of the Business applications.

• Extensively used Messaging tools such as SWIFT Alliance, Mercator and Seebeyond for the testing.

• Used market standard SWIFT language to create test SWIFT files for the testing.

• Reviewed and allocated requirements to hardware, software, and manual operations.

• Led the set up of Test environment and ensured that the facilities, test tools and scripts are in place to successfully perform the required testing effort.

• Performed Regression, Integration and end to end system testing.

• Extensively used SQL queries to manipulate, analyze and retrieve data from multiple systems.

• Created several scripts for an entire the application for the Load/Performance Testing using Mercury Load Runner’s Vugen. Integrated all the individual scripts into a single test scenario.

• Uploaded the Load Runner Scripts in Performance Centers and ran the test cycle for a bank wide initiative where the data and apps were migrated from Sun Solaris servers to IBM AIX servers for the reliability and response time of the application.

• Created Vuser scripts and performed Load Testing for oracle upgrade from 8i to 10g.

• Performed Load Testing for the Oracle patch upgrades.

• Prepared the Winrunner scripts for the Regression testing of a power builder Trade Instruction application using the Test Script Language (TSL).

• Created the scripted test components of Winrunner scripts and integrated these to Quality Center.

• Automated a web based securities application using QTP.

• Performed Integration Testing of the Change Requests.

• Led Data Setup for the User Acceptance Testing (UAT) to check the reliability of the apps for end users.

• Maintained test matrix and bug database and generated reports using the Document Generator.

• Used Mercury Quality Center to report and track bugs.

• Performed project planning, coordination and implemented QA methodology.

Environment: Mercury Quality Center, Load Runner, Win Runner, QTP, Performance Center, Power Builder, Oracle 10g/ 8i, Toad, SQL Plus, XML, SWIFT Alliance, Mercator, Seebeyond, Basel Calculator, PL/SQL, Unix, Microsoft Office 2003, Windows XP, MS Excel 2003

UBS, Stamford, CT Sep’04-May’06

Business Analyst/Sr. Software QA Engineer

Description: UBS is the world’s leading investment banking and wealth management bank. UBSDOX system is the primary UBS system that facilitates contract negotiation and captures contract terms for all major trading agreements. The underlying technology, architecture and functionality have not changed much since DOX inception about 8 years ago. This system has grown into a global system with a many users worldwide and dependencies on other important applications.

DOX project meets the increasing focus on regulatory risk (Sarbanes-Oxley, Basel II etc.) and operational risk excellence. The new DOX system replaces the ten-year-old legacy DOX system to achieve various tasks.

Responsibilities:

• Worked as the Business Analyst for requirements gathering and participated in the entire requirements engineering process right from requirements elicitation phase to the phase involving documentation of the requirements.

• Created detailed source to target mapping of the old and the new attributes. Created the value mapping of the old and the new values and also worked on creating the complex attributes matrix.

• Defined the data cleansing requirements and then worked extensively on the Data Cleansing of the legacy Database.

• Worked on requirements gathering for interfacing the various credit systems to the new system using Informatica as the Interface between these systems.

• Worked extensively on the Data Reconciliation.

• Gave the Infrastructure requirements for the set up of the Dev and the UAT environments for testing.

• Performed functional, regression and end to end system testing.

• Created various data marts for agreement data and used effective querying and formatting tools to present the data to the end users.

• Designed the data interfaces between the SQL server, Oracle and the Sybase using Informatica.

• Worked on the templates for the backout strategy.

• Performed the code review and unit testing of the entire systems informatica mappings.

• Worked extensively on the XMLs and XSDs.

• Validated data and created the test cases in Test Director.

• Created the Winrunner scripts for the regression testing of the Legacy application.

• Created the QTP test scripts for the regression test of the New web based DOX application.

• Performed extensive testing along with the testing teams to ensure that the end-to-end requirements lifecycle management and enterprise test practices are supported.

• Created the Real-Time reports for the various test run of the migration.

• Ran the test runs in the dev and uat environments. Also ran the dry runs in the prod environment and documented the results at the run time.

Environment: Test Director, Win Runner, QTP, Informatica Power Center 6.2.2, Oracle 8i , SQL Server 2000, Sybase(Jisql), DBArtsian, Toad, UNIX ,IIS, Microsoft Office 2003, PL/SQL, Windows XP, MS Excel 2003, XML, XSL, XSDs, .NET, SQL Plus, Documentum

ECIL, Hyderabad, India Jun’02-May’03

Test Engineer

Responsibilities:

• Analyzed the User/Business requirements and functional specification documents.

• Created test cases and helped in test plans according to requirement specifications.

• Used Test Director to track and manage change requests throughout the development and testing process.

• Identified and documented all issues and defects to ensure desired quality of the application functionality.

• Worked with development team members to better understand system functionality in order to improve testing quality.

Environment: Oracle 7.3, Test Director, MS Access, MS Excel, SQL, PL/SQL

Contact this candidate