Sql Server Customer Service

PHONE: 847-***-**** SHARAN Email: acs0rg@r.postjobfree.com

PROFESSIONAL SUMMARY

Over 6+ years of IT experience as Quality Assurance Analyst in Internet, Client/Server and Multi-tier technologies using variety of software tools and techniques.

Hands on experience and expertise in Functional testing, System testing, Compatibility testing, Retesting, Regression Testing and Performance testing.

Proficient in using Agile Test and Waterfall Methodologies.

Expertise in Oracle ATG Web Commerce, setting up data and testing with ATG Business Control Center and ATG Control Center tools.

Knowledge and experience of SAP Materials Management (MM) and Sales & Distribution (SD) modules.

Proficient in testing techniques including Black Box, Unit, Functional, Integration, System, Back-end/Database (SQL), Regression and User Acceptance Testing.

Exposure to test planning and execution for multiple projects and releases.

Proficient in creating Test Plan, Simulating Test Scenarios, testing browser compatibility and executing smoke, usability, functionality and Integration testing and UAT testing.

Problem-solver with strong critical thinking and decision-making abilities.

Ability to work individually and as a team player with a personality to build productive relationships with colleagues, and clients across all functional and technical disciplines.

EDUCATION

Masters in Computer Science from California State University

GPA 3.6

Bachelors in Engineering (Computer Science) from Mumbai University

TECHNICAL SKILLS

Programming Languages:

HTML, SQL, C/C++, C sharp, Core Java, ADO.NET

Methodologies:

Agile (Scrum) and Waterfall

Databases:

Oracle 10g, SQL Server 2005, MS Access

Tools:

Visual Studio, Selenium, QTP, MS Office, JAMA, LeanKit tool, Toad, XML SPY,

CUCMBER, UC4, DWR, WordSoft

Mobile:

iOS and Android

Platforms:

ATG Ecommerce suite, SAP

OS:

Windows 7/Vista/XP/NT/2000/98, MAC, Unix

Browsers:

MS Internet Explorer, Mozilla Firefox, Chrome, Safari, Opera

Defect Tracker Tool:

JIRA, SharePoint, QC

1

PHONE: 847-***-**** SHARAN Email: acs0rg@r.postjobfree.com

WORK EXPERIENCE

Volkswagen (Libertyville, IL, U.S.A) (July 2014 to present)

Role: QA Analyst

Easy Leasing and Financing System: This project is intended to simplify the process of leasing, financing and cost evaluation of the vehicles, helping both car buyers and the VW sales department by easing the process of car leasing. This also helps the company to evaluate and sell/dispose the fleet and leasing vehicles after the lease is over.

Responsibilities:

Developed Test Plan, created Test Cases and worked on execution and documentation of the Test Scripts in JAMA tool.

Prepared test plans, designs and scripts and maintained testing metrics and progress report.

Prepared test environments and test data for functional and integration tests using

Proven Quality Engineering ownership at every stage of SDLC

Performed Black Box testing, Unit, (Component Functional) testing of sub-taxonomies, Integration, System, E2E testing, Performance, Back-end/Database, Regression User Acceptance Testing on web application.

Executed complex queries to compare and match test data in SQL Server Management.

Based on Dealers and Customers functionality performed SQL functionalities such as CREATED, UPDATED, And INSERTED and VIEW from Dealers and Customers tables.

Executed complex queries in SQL Server to validate customer Contract details from departments such as Customer Service, Remarketing, Financials and Collections

Analyzed business requirements and functional specifications to develop and execute test plans.

Reviewed and designed automation scripts, maintained existing automated scripts, analyzed output from scripts and wrote programs, as required, to build test scripts.

Environment: JIRA, XMLSPY, SQL Server, IBM Main frame, Biz Server, C#

Chicago Mercantile Exchange (Chicago, U.S.A) (Sept 2013 to May 2014)

Role: QA Analyst

Single Step Transaction System: This project provides financial buyers and sellers with a platform to perform trading, clearing and post trading activities. This application uses FIX protocol conventions so that financial business transactions can be completed in one single step.

Responsibilities:

Created Test Plan, Test Scenarios and Test scripts for upstream and downstream applications.

Experienced in Functional testing of PIT, GLOBEX and CPC trades using FEC application and FIX protocol respectively.

Performed in trouble shooting using log files using UNIX commands and validating the data using XML SPY tool.

Performed Integration testing on Post Trade Activities life cycle such as clearing of trades, allocation of trades, accepted, rejected and busted the trade.

Participated in full SDLC Test experience, Test Plan and Test Case Creation, end to end testing with execution and documentation of the Test Scripts.

Submitted problems found into Defect Tracking system after doing the necessary analysis to identify the failing component.

Performed Count Validation, No Duplication and Data Validation on posted Trades in SQL Server.

Proficient in Column validation for the POST Trade CLEARING house activity in SQL Server.

Performed various types of Application and System testing Black Box, Unit, Functional, Integration, System, Performance, Regression and User Acceptance Testing.

Worked on both Waterfall and Agile (Scrum) methodology.

Reviewed and designed automation scripts, maintained existing automated scripts, analyzed output from scripts and wrote programs in CUCUMBER, to build test tools.

Helped in debugging, root- analysis and checking logs for application and configuration issues, running batch files and fetching data over the application

Environment: JIRA, QC, TOAD, XMLSPY, UNIX, CUCUMBER, UC4, DWR, BEYOND COMPARE.

PHONE: 847-***-**** SHARAN Email: acs0rg@r.postjobfree.com

WORK EXPERIENCE (continued)

Medline (IL, U.S.A) (July 2012 to Sept 2013)

Role: QA Analyst

Pricing and Order Management System: The system provides the functionality of pricing, availability and order management. It uses Oracle ATG platform which is integrated with SAP modules. It also provides the shipping information in real-time.

Responsibilities:

Gathered functional requirements and created Test Plans and Test cases.

Created Test Scripts from the Test Plan and executed them.

Experienced in running queries to validate Products hierarchy in SQL server for the placed orders.

Worked with business team to understand requirements and functional specifications to develop and execute test plans and match with expected results.

Proficient in running complex queries to validate customers’ invoices, orders, delivery information and returns policies.

Worked on iPad, iPhone and Android Mobile Phone testing for B2B Medline.com.

Performed multi-faceted testing including black box, regression, smoke testing and part of UAT testing.

Used SharePoint as Defect Tracking tool for evaluating native properties and operations of object, as well as the test object hierarchy, tracking defects and testing.

Environment: Oracle ATG BCC v10.1.1, SAP MM and SD, SharePoint, SQL server

Systech Software Consultancy (Mumbai, India) (April 2006 to July 2009)

Role: QA Analyst

Pothys.com: Pothys.com is a website for a premium textile retailer in India which specializes in silk clothing for people of all age group. This site enables the ecommerce channel including online product catalog, user registration and management, cart and checkout functionalities.

Responsibilities:

Created and executed Test plans, Unit test cases, Functional Testing, Integration and UAT testing.

Logged defects in QC after verifying against the requirements.

Executed complex JOIN queries to validate customized products availability distribution over the state.

Prepared and executed automation scripts using QTP.

Environnent: ATG, QTP, ASP.Net, SQL Server 2003, QC.

Undergraduate engineering Project

Online File Sharing Application: Developed an on-line file sharing application which allowed users to register files over the web and chat instance. This project was supported by Systech Software Consultancy.

Responsibilities:

Designed and developed the application.

Performed functional testing of the entire application and prepared the user manual.

Developed scripts using both Expert View and Keyword View of Visual Studio.

Environment: Visual Studio 2005, C# 2.0 and SQL Server.

3

Contact this candidate