Sql Server Technical Support

Profile

Over ** years of experience in software testing and packaging, primarily

with InstallShield (InstallScript MSI and Visual Patch). Also, experience

in performing all types of testing in Windows environment. Worked on

projects ranging from simple in-house to large enterprise-scale

applications.

Technology

Platforms: All versions of Windows (XP, Vista, 7, 8, Server 2003/2008),

IIS

Languages: C, C++, Visual Basic .net, ASP.NET, C#

SDK Technologies: ActiveX Controls, DAO, ADO, Jet

Software: Microsoft Word/Excel/Access, MS Project Manger, CorelDraw,

Macromedia Director, Adobe Photoshop, Seagate Crystal

Reports, InstallShield Developer, Rational Visual Test

(automated testing), TestTrackpro, BugZilla, 2005-2012 SQL

Server, MS Visual SourceSafe (configuration management),

TFS (Team Foundation Server), Red-gate (SQL Compare 6.2,

SQL Data Compare 6.0), SQL Visual Patch 3.0, TrueUpdate

3.0, MS Visual Studio Test Professional 2010, and Jaws (for

Windows Screen Reading Software), ESRI ArcGIS 10.2.

Internet: HTML, authoring in NetObjects Fusion, Shockwave, Multimedia

authoring (Lingo)

Professional Experience

Ipipeline North Carolina (http://ipipeline.com/), March 2014 - Current

(contract to hire)

Title: Software Configuration Specialist

. Create, update, and maintain installshield packages.

. Maintain auto build applications and create new ones if needed.

. Provide support using SalesForce software (configuration requests and

build issues).

Atkins (www.atkinsglobal.com), March 2000 - 01/16/2014

Title: Sr. Software Tester/Release Engineer

Atkins is one of the world's leading engineering and design consultancies.

Since joining Atkins, involved in more than seven projects from desktop-

based tools to web-based enterprise-scale applications.

. Create, update, and maintain test plan, test cases, and test scripts

based on functional specifications and technical specifications for

products (using IEEE STD 829-1998).

. Performs all types of testing in complex Windows environment (black box

testing, integration, functional, regression, performance, stress,

validation, and beta).

. Handle Technical Support tickets via a dedicated on-line portal

(ManageEngine)

. Create automated tests using Rational Visual Test, 2012 Visual Studio.

. Performs web application (load, performance test using 2012 Visual

Studio).

. Manages defects using Seapine TestTrackpro, BugZilla, or Microsoft TFS

2010.

. Performs software testing life cycle.

. Built a setup using InstallShield (InstallScript MSI), integrated

modules, tested setup, and performed CD mastering.

. Wrote utilities in VB.NET for custom action for InstallShield.

. Tests desktop and web-based applications. Also, experience with testing

applications for mobile\ Handheld devices- iPhone.

Project experience includes:

. Built a complex setup and application test for the Federal Emergency

Management Agency (FEMA) and other desktop applications using Hazus-MH,

which is a powerful risk assessment software program for analyzing

potential losses from floods, hurricane winds, and earthquakes (GIS-based

loss estimation program).

. Developed various merge modules that handled the setup of MSDE/SQL Server

and SQL Server 2008 Express (including instance naming/check).

. Performed pre-requirements (operating system or other)

checking/verification.

. Performed database/SQL scripting during installation (import, user

accounts, custom actions, etc.).

. Managed technologies including Windows, IIS, and Microsoft SQL.

. Performed scripting using InstallScript and Visual Basic (custom

actions).

. Provided direct technical support to end users that have issues with

installation

. (ManageEngine ServiceDesk Plus).

. Performed configuration management using Microsoft Visual SourceSafe

(current configuration management) for all setup scripts repository.

Maintained version control using Visual SourceSafe.

. Performed release management. Created new versions, updated programs,

gathered requirements and dependencies with the existing components which

must be checked out in advance, built new version, and tested so that

release can be prepared.

. Documented/wrote all steps for new setup, tested the plan, and tested the

script for new applications.

. Wrote utilities in Visual Basic to QC Access database.

. Built patches that checked for correct version to be updated, replaced

several files (dll. mdb. doc, exe), and updated existing SQL server

database. When user uninstalled the patch, it restored the original

files.

. Managed configuration management activities to establish version control

on source code and project artifacts, reduced errors, and increased

confidence in application deployments.

. Wrote, modified, and executed release scripts.

. Wrote custom actions to be included in the setup in Visual Basic or

InstallScript (attached SQL Express database, added user, changed rights,

moved several files to different location).

. Executed any SQL script within the setup.

. Reduced errors in released code sets which resulted in 50-percent

reduction in patch re-releases and an increase in customer success rates

of patch implementations.

. Developed database applications using Visual Basic and Visual Basic.NET,

designed forms and menus using Visual Basic.NET 2008, and wrote some

codes (validations).

. Created setups for desktop applications for Microsoft Windows XP and

Windows 2000 (different services packs), Windows Vista, and Window 7 (32-

bit and 64 bit).

. Wrote and executed test plan and test script for Windows applications

(manually and automated).

. Wrote macros in Excel.

Environment: ASP.NET, C++, C#, SQL Server 2005/2008/2010, SQL, VB.NET, MS

Access, MS Excel, MS Visual Source Safe

Testing Tools: Rational Visual Test, MS Visual Studio Test Professional

2012, and Jaws (for Windows Screen Reading Software)

Education

ISTQB Software Tester Certification in progress.

A.S. in Computer Programming/Management Information Systems (MIS) - Ohlone

College - Fremont, CA. - 1999

Certifications

Software Testing & Quality Assurance Techniques Certificate, American

Society of Professional Education, North Carolina, 2006

Work Status

U.S. Citizen

Contact this candidate