Engineer Sql Server
Resume:
Ashwini Patil
Email: abhj2u@r.postjobfree.com
Phone: 858-***-**** (C)
PROFESSIONAL SUMMARY:
Around Five plus years of experience in Information Technology as QA
Analyst/Tester.
. Experience in writing System Test Plans, Test Cases from
business requirements and release documents
. Experience in Manual Testing and Test automation using Mercury
tool Win Runner, defect tracking tools PVCS Tracker, Bugzilla,
Product studio, Star Team, Team foundation server and test
management tool Quality Center.
. Involved in every stage of SDLC (Software Development Life
Cycle) and QA life cycle.
. Experience in working with agile testing methodology.
. Extensive experience in Functional, Integration, System and
Regression Testing.
. Strong knowledge in SQL and working knowledge of UNIX commands
and shell scripts.
. Proficient in identifying and reporting software bugs and
suggesting Business and System changes
. Ability to interact with developers and product analysts
regarding testing status.
. Good team player and also have ability to work independently in
a time sensitive environment.
. Maintain detail QA documentation.
. Able to understand and translate functional requirements/
specifications into working test plan and/or test cases as
required.
. Testing Experience in GUI and Client-Server Applications.
TECHNICAL SKILLS:
Languages : C, C++, Visual Basic, SQL, PL/SQL. UNIX Shell
Scripts, XML
Testing Tools : Win Runner, Load Runner, Quality Center 9.0
Bug Reporting Tools : BugZilla, PVCS Tracker, Bugger, Star Team,
Product Studio,fogbugz,TFS
Databases : Oracle, MS Access, SQL Server
Tools and methodologies: VSS, PVCS Version Manager, MS Office. Source
Depot, CF 2.0,bedrock 3.6, Shuttle 5.0, Cute FTP,
visual Def, Toad, Quickbase, Secure CRT
Operating Systems : Windows 95/98/00/NT/XP, MS-DOS and UNIX
EDUCATION:
Masters in Computers
PROFESSIONAL EXPERIENCE:
CMS - Time Card management System
Southern California Edison
February 2011 - Till Date
QA Engineer
Southern California Edison (SCE) is one of the largest electric utilities
in California, serving more than 14 million people in a 50,000 square-mile
area of central, coastal and Southern California, excluding the City of Los
Angeles and certain other cities. CMS is a role base configurable tool that
will work in a wireless environment as well as when a user is connected in
the office. It is time keeping system for SCE. CMS application is used for
time card management of individual crew man, the crews which get approved
by the supervisors. Also it is used for managing and assigning the work
orders
Responsibilities:
. Understanding Internal and External Interfaces of the CMS application.
. Designed, developed, and executed test cases, test procedure, test
scenarios and prioritizing test according to Functional Requirements
and design specifications of the enhancement.
. Used Team Foundation Server as bug tracking tool to keep track of
bugs.
. Found Defects and interacted with developers to resolve technical
issues.
. Understand and Perform the Testing of newly developed CMS application
. Performed Regression and Functional Testing.
. Provided weekly updates through status report and weekly meeting.
. Interacted actively with the team in identifying bugs and retesting
the resolved bugs
. Interacted with developers and QA team in fixing schedules for
assignments
. Knowledge of SQL server for querying database.
. Testing Experience in Utility domain(Electricity)
Environment: Caliber RM, Team foundation server, SAP, Sql server
2008,sharepoint,Windows XP,vista,WiN 7,Windows Server 2008, .Net 4.0
PTMS- Property Tax management Systems
Tax Compliance Inc
QA Engineer September 2010 -
February 2011
Tax Compliance, Inc. develops market-leading state and local tax
software solutions for corporations. PTMS property tax software helps
minimize property taxes and expenses. It eliminates redundancy and
minimizes tax processing time allowing tax departments to focus on tax
management. This software support following functionalities- Preparing
Tax Returns Gathering Jurisdictional Information, Processing Tax
Payments, Managing Documents, Forecasting Tax Liabilities, Tracking
Appeals, Managing Audits, Ensuring SOX Compliance and Creating
Reports. PTMS is browser based application developed using VB.net as
a frontend and SQL Server Database. TCI recently migrated their
application from FoxPro to VB.NET. I was working in Quality assurance
team to make sure deliver new VB.Net software with highest quality to
corporate America.
Responsibilities:
. Understanding Internal and External Interfaces of the PTMS and
Dashboard application.
. Designed, developed, and executed test cases, test procedure, test
scenarios and prioritizing test according to Functional Requirements
and design specifications of the enhancement.
. Used FogBubz as bug tracking tool to keep track of bugs.
. Found Defects and interacted with developers to resolve technical
issues.
. Understand and Perform the Testing of newly developed browser based
.NET application
. Performed Regression and Functional Testing.
. Provided weekly updates through status report and weekly meeting.
. Interacted actively with the team in identifying bugs and retesting
the resolved bugs
. Interacted with developers and QA team in fixing schedules for
assignments
. Knowledge of SQL server for querying database.
. Prepared test cases for PTMS application functionality testing using
Access Database.
Environment: Visual Studio 2010, .Net 3.5/4.0, C# language, Windows
Forms using Developer Express custom controls, SQL Server
2005/2008,fogbugz, Team Foundation Server, Windows NT and 95, 98
Health.msn.com
Microsoft Corporation, Redmond, WA
Software development and Test Engineer (SDET)
December 2009 - June 2010
The channels content management Team is responsible for managing content,
publishing content on msn sites across different channels like Latino,
health, Kids, Lifestyle, Travel @ msn.com. The mission of this team is to
drive web application excellence into production by providing web content
management leadership using Bedrock and Shuttle.
Responsibilities:
. Performed Integration, Regression, and Functional Testing.
. Performed web Testing Using shuttle 5.0, Bedrock 4.1
. Used Product studio as a bug-tracking tool.
. Provided weekly updates through status report and daily report as well
. Interacted actively with the team in identifying bugs and retesting
the resolved bugs
. Interacted with developers and QA team in fixing schedules for
assignments
. Involved in provisioning templates, interacting with bedrock support
team and ops team as well for other file drops.
. Created test cases for msn health (women's health Anti aging) release
7.2 project.
. Executed test pass for Women's Health Anti Aging realese 7.2
. Involved in SDLC from spec review till post mortem
. Knowledge of SQL server for querying database.
. Using Sharepoint and bugger tool
. Omniture tracking for msn.health.com
. Prepared test cases for the database upgrade
. Experience in testing XML code manually.
Environment: Source Depot, Product Studio, Windows NT and 95, 98,XP
IE 6.0,IE 7.0, XML, HTML, JAVA, SQL server 2005,ajax,c#, vb.net,CF
2.0.bedrock 4.1,shuttle 5.0,bugger,Browsers: IE 6,opera,Firefox
MedAccess - Pharmacy Benefit Management system
MedImapct Helthecare Systems Inc. San Diego, CA, USA
QA Engineer
November 2008 - November 2009
MedImpact is a transparent Pharmacy Benefits Management (PBM) company.
MedAccess is application developed in Developer 2000 and Oracle 10g as a
backend provides full-service for PBM. It Includes products and services
like: claims processing, direct member reimbursement, standard and custom
formularies, network management and benefits plan administration.
Responsibilities:
. Testing cycle includes Integration Testing, Regression Testing,
Performance Testing, Black Box testing, Functional Testing and data
testing.
. Performed Transaction Testing Using SQL, PLSQL and Oracle 10g and 8i.
. Performed testing of enhancement of complex PBM business operations.
. Performed testing of UNIX jobs, Unix Shell Script based report and SQR
based reports and Oracle packages. Procedures and functions.
. Performed testing MedAccess Job Scheduler includes submitting new
jobs, monitoring job status, checking the log files the job and
actually result of job.
. Performed validation Oracle database objects like tables, constrains,
index, views.
. Interacted actively with the Business Analyst and Dev team to identify
bugs and retesting the resolved bugs.
. Perform preproduction test before releasing code to production
. Used Star Team as a bug-tracking tool and change management tool
. Understanding Internal and External Interfaces of the MedAccess
application.
. Designed, developed, and executed test cases, test procedure, test
scenarios and prioritizing test according to Functional Requirements
and design specifications of the enhancement.
. Tested Mas 500 web application using test management tool Quality
Center
Environment: : Oracle 10g/8i, PL/SQL, SQL*PLUS, IBM-AIX, Linux, Unix Shell
scripts, StarTeam, TOAD, MS Visio, SQR, SR Systems, TOAD, SalesForce,
SlickEdit, Quality center 9.0
Latino.msn.com
Microsoft Corporation, Redmond, WA
Lead Software development and Test Engineer (SDET)
June 2007- July 2008
The channels content management Team is responsible for managing content,
publishing content on msn sites across different channels like Latino,
health, Kids, Lifestyle, Travel @ msn.com. The mission of this team is to
drive web application excellence into production by providing web content
management leadership using Bedrock and Shuttle.
Responsibilities:
. Performed Integration, Regression, and Functional Testing.
. Performed web Testing Using shuttle 5.0, Bedrock 3.6
. Used Product studio as a bug-tracking tool.
. Interacted actively with the team in identifying bugs and retesting
the resolved bugs
. Interacting with developers and QA team in fixing schedules for
assignments
. Created test cases for Latino HP 10.5 and slide show project.
. Executed test pass for IE 7, Bedrock 3.6 and GTL 2.01 QFE
. Involved in SDLC from spec review till post mortem
. Knowledge of SQL server for querying database.
. Using Sharepoint and bugger tool.
. Web localization testing experience(lation.msn.com)
Environment: Source Depot, Product Studio, Windows NT and 95, 98,XP
IE 6.0,IE 7.0 XML, HTML, JAVA, SQL server 2000,ajax,c#, vb.net,CF
2.0.bedrock 3.6,shuttle 5.0,bugger,Browsers: IE 6,opera,Firefox,
Omniture tracking
Total Access and Total LMS - The leading application for e-learning
content development.
SumTotal Systems, Inc. Bellevue WA
Software Engineer December
2006 - May 2007
SumTotal system is the largest provider of learning and business
performance technologies and services. ToolBook helps organizations
create effective learning content and sophisticated simulations. It
blends comprehensive functionality, unprecedented power, and ease of
use into a suite of products for the authoring market.
Responsibilities:
. Performed Integration, Regression, and Functional Testing.
. Performed Transaction Testing Using SQL, PLSQL.
. Used Bugzilla as a bug-tracking tool.
. Participated in QA Team meetings for weekly QA Testing Reviews.
. Provided weekly updates through status report and daily report as well
. Interacted actively with the team in identifying bugs and retesting
the resolved bugs
. Interacting with developers and QA team in fixing schedules for
assignments
. Updated test plan. Redeveloped new test cases based on old test plan.
Environment: SQL, VSS, Bugzilla, Windows NT and 95, 98, IE 5.0, XML,
HTML, Slik Test. IE 6.0, JAVA, Oracle 9i, PLSQL, Scorm 1.2 and Scrom
2004 ADL Testing
Mainsail: A Terminal Management System
Tideworks Technologies, Seattle, WA
QA Tester August 2005
-November 2006
Tideworks provides full-service marine terminal management and
planning software, logistics chain solutions, and professional
services to terminal operators and transportation companies worldwide.
Tideworks gives solutions for terminal operator, shipping line, depot
operator, freight forwarder, warehouse operator, or trucking company.
Mainsail is industry-leading software gives to its customer the
reliability and flexibility to manage their business productively and
cost-effectively. I was involved in maintenance and enhancement
project for Mainsail System.
Responsibilities:
. As a Team Member Analyzing Business and System Requirements.
. Design and Developed Test Cases according to Functional Requirements
and design specifications of the enhancement.
. Performed Integration, Regression, and Functional Testing.
. Performed Positive & Negative Testing.
. Performed Transaction Testing Using SQL, PLSQL.
. Understand and Perform the Testing of newly developed and modified
Unix shell scripts
. Used Tracker as a bug-tracking tool
. Found Defects and interacted with developers to resolve technical
issues.
. Used SQL queries for database testing.
. Strong analysis ability in functional and scripting in win runner.
Environment: PVCS Tracker, PVCS Version Manager, D2k, SQL, PLSQL, UNIX
Shell Script, Oracle9i
Ebankeasy.com - An Online Banking Portal
EBZ Online Pvt Ltd, Pune, India
QA Tester May 2005 -
July 2005
The online banking application was developed for the customers to
enable them to manage their finances via internet and perform various
transactions like accessing personal accounts, checking account
balances, payment of recurring bills, such as loan payments, transfer
funds, and other products and services and the best thing is that it
can assure it's customers of safe and smooth functioning by joining
the network.
Responsibilities:
. As a Team Member Analyzing Business and System Requirements.
. Performed Webpage testing.
. Designed and Developed Test Cases according to Functional Requirements
and design specifications of the application.
. Performed Integration, Regression, and Functional Testing.
. Used SQL for producing the test data for UAT.
. Used Bugzilla as a bug-tracking tool.
. Interacted with Business People and Developers to exchange the updated
Functionality specification.
. Created the multiple users using Loadrunner to test the application
performance.
. Worked as an Automation specialist in Winrunner.
Environment: Winrunner, Loadrunner, Bugzilla, VSS, Java, Oracle 8i,
UNIX, Windows NT and 95, 98, IE 5.0, XML, HTML.
Dead Stock Maintenance System for Bank
EBZ Online Pvt Ltd, Pune, India
QA Tester November 2004-
April 2005
This is the one of the important module in banking system. It
maintains all type of furniture and fixture and movable property of
Bank. It also calculates depreciation of deadstock items according to
Bank and RBI rules.
Responsibilities:
. Analyzed functional specifications and Technical specifications.
. Prepared and executed System test cases and tested different modules
and their functionality.
. Participated in QA Team meetings for weekly QA Testing Reviews.
. Provided weekly updates through status report.
. Organized the testing process and Problem Reporting using Bugzilla.
. Interacted actively with the team in identifying bugs and retesting
the resolved bugs.
Environment: Bugzilla, VSS, D2k, SQL, PLSQL, Oracle, Winrunner,
Loadrunner, UNIX
Contact this candidate