Quality Assurance Project

Yunus A. Patel

******@*****.***

**** ****** ******

M: 630-***-****

Naperville, IL 60564

H: 630-***-****

Highly talented and accomplished Information Technology professional

with strong background in Software development and Quality Assurance

Testing

The Systems Sleuth: "I always Get My Bug"

Systems and Data Analysis / ETL & Data Warehouse / Business Intelligence /

Systems Software Architecture and Design / Software Integration / Oracle /

SQL Server / Cognos / Debugging and Trouble Shooting / Test Strategies /

Test Plans / Test Suites / Systems Test / Bug Documentation / Project Team

Leadership / Project Management

INFORMATION TECHNOLOGY PROFESSIONAL with strong experience in Software

Development and Quality Assurance (QA) with a wide variety of projects,

environments and systems with knowledge of development and testing process,

software integration and full life cycle product development (SDLC). Team

player with ability to meet challenges and quick in implementing new

knowledge. Uses forensic approach to determine problem origin. Very

creative in producing solutions that are high quality and supersede typical

"band-aid" application remedies.

Technical Skills Summary

Software: DataStage, PLSQL, Perl, Awk, Shell, C/C++, XML, HTML, JCL

Databases: Oracle (8i/9i/10g), SQL Server 2000, InterBase,

5E-Switching & MSC RDBMS

Operating Systems: AIX, Sun Solaris, Linux/UNIX, MS-DOS, Win XP/2000/NT,

Mainframe z/OS

Software/Docs Mgmt. JIRA, Clearquest, Quality Center, ClearCase, CCMS, Sable,

Tools: Sharepoint, sourceforge

Other Tools: SQL *Loader, LDAP, PL/SQL Developer, SQL Navigator, Toad,

Nexus Orbiter, AGS, DDTS, Make/Makefile, dbx (Debugger)

Reporting Tools: Reporting Tools: Cognos BI (Report Studio, Query Studio,

Analysis Studio)

Microsoft Tools: Office Project, Excel, Word, Power Point, Visio, Visual

Basic

Hardware: PC, AIX, HP and SUN UNIX Servers, 3B20, Compaq CPSB

Professional Summary

Quality Assurance Analyst (Consultant)

aLLANT gROUP, Naperville IL

10/2010 - Current

client delivery solutions System

. Planned and organized QA tasks tested and validated Client Delivery

Solutions for marketing and BI database solutions used by Insurance,

communication, media and marketing industries.

. Developed Test Plans/Test Cases documents, planned and organized System

Test, executed test scripts, compared and validated the tests results.

. Analyzed log/error files, investigated, identified root cause, reported

and tracked defects, worked with development engineers for defects

resolution, re-validated fixes. Provided detail QA test report to

Management.

. Developed Unix shell/Perl, Oracle PL/SQL Scripts and utilized SQL Loader

to automate ETL testing activities.

. Created Database Tables, Views, modified exiting tables, views based on

enhancement and development of new ETL framework.

Programmer / QA Analyst (Consultant)

Eddie Bauer., Westmont, IL

06/2010 - 10/2010

E-Commerce Marketing Contact system Migration

. Analyzed and Investigated Marketing Contact System, made a careful

inventory of Datastage and mainframe CA-7 jobs, Oracle DB tables, Stored

Procedures, Shell/Perl scripts and other tools in use prior to CDM (Data

Mart) upgrade implementation.

. Validated Oracle 10g, Datastage software installation and directory

structures on a new AIX 10 server, exported/imported Datastage jobs from

SunSparc Unix Server to new AIX Unix server.

. Replaced, redesigned and modified ETL workflows and mainframe jobs,

Oracle tables, stored procedures, Shell/Perl scripts that are

incompatible with new system.

. Unit tested Datastage and mainframe jobs and made sure all jobs are

successful on the new server prior to full deployment.

YUNUS A. PATEL

Page 2

. Developed Test Plans/Test Cases documents and PLSQL scripts, planned and

organized Integration and System Test, executed test scripts, compared

and validated the tests results and made sure the resulted datasets are

identical between existing and new Production systems.

. Identified and logged defects in JIRA, corrected software programs for

the defects, re-tested and validated them.

. Provided System implementation documents on system setup, disaster

recovery etc.

Quality Assurance Analyst

ACXIOM CorpORATION., Downers Grove, IL

11/2005 - 10/2009

Web applications and Data Warehousing Solutions

. Planned, organized and prioritized QA tasks, tested and validated Web

applications and Datastage ETL process results for enterprise Data

Warehousing solutions used by retail marketing, auto and banking

industries.

. Reduced test data creation time by 50% through development of UNIX Korn

shell, awk & PLSQL automation scripts.

. Implemented and used Manual ETL techniques (using SQL, PL/SQL) to

extract, transform, load and test/validate data into Oracle data

warehouse.

. Modified and implemented Datastage ETL workflows to extract, transform

and load data into Oracle data warehouse tables.

. Coordinated creation and management of Database Objects (Tablespaces,

Tables, Views, Indexes) and delivered critical database support to the QA

team for ongoing testing. Performed exploratory/ad hoc testing.

. Designed Reports using Report studio features (Conditional Formatting,

Conditional Page layout, Sections, page Breaks, Master-detail, Drill

Through, Drill Down, Drill Up).

. Used QTP for functional and Regression testing and utilized Quality

Center to record, report and track defects, worked with development

engineers for defects resolution and re-validated the fixes. Provided

detail QA test report to Management.

. Led a team of QA test engineers while working on the project. Assigned

work, guided in their work, monitored their progress and helped resolve

issues. Managed resource contention between ongoing QA testing and urgent

defects reported in production.

. Presented Web and Data Warehousing solutions overview to clients and

implemented client feedback in product development and enhancement.

. Provided training and mentoring to Poland QA team members. Identified,

developed and delivered targeted training and knowledge sharing

initiatives.

Programmer / QA Analyst (Consultant)

MotOROLA, INC., Schaumburg, IL

02/2005 - 08/2005

Rebanding project (two-way Radio Systems)

. Designed, enhanced and deployed 2-way Radio System applications (Client-

Server) for restructuring of 800 MHz radio frequency band plans.

. Planned and organized testing, executed load and performance testing,

functionality testing of various features of the Two-way Radio system.

. Discovered and investigated software defects, provided technical

resolution, validated and verified the fixes ensuring the product

quality.

. Developed testing scripts to aid in test case execution and develop

supporting tools to troubleshoot defects.

. Supported system integration, system validation & Test Life Cycle teams

in their testing for modified band plans in legacy systems.

. Participated in technology transfer to Motorola Poland (Krakow) team;

identified and developed training materials and provided training to

colleagues in Poland team.

. Provided end-user documentation for installation and operations of the

Two-way radio system applications (System Configuration Manager, Radio

Control Manager, Control Display and Radio Traffic monitoring)

Lead Developer

Lucent TEchnologies, INC., Naperville, IL

1998 - 2003

RNC project (Radio Network Controller)

. Led the technical effort in planning, designing and implementing of RNC

(Radio Network Controller) feature. Automated RNC application software

packaging, installation, activation and back-out process for the system.

This automation saved 30 % in time and resource and increased

productivity of developers and system testers.

. Led a small team of developers from India, trained the developers,

provided design and technical leadership to the project, developed a

project plan, assigned the work, monitored the team members progress, and

assisted in resolving problems.

YUNUS A. PATEL

Page 3

. Led a small team of developers from India, trained the developers,

provided design and technical leadership to the project, developed a

project plan, assigned the work, monitored the team members progress, and

assisted in resolving problems.

. Provided project management support defining project tasks, estimation,

progress reports, and managing activities and resources for the team

according to Standards and Methodologies.

. Effectively planned and implemented RNC application software integration.

Developed Perl and UNIX scripts to package and integrate the software and

to automate the software installation in the System Labs as well as at

the customer site.

. Successfully designed and implemented IP addressing scheme for LAN/WAN

network interfaces and supported OA&M (operations, administration and

maintenance) application development (Unix/C) for RNC Packet switching.

. Instrumental contributor in developing RNC software installation and

verification procedure guide that saved time and resources for the system

bring-up and deployment.

. Created and managed database objects (Tablespaces, Tables, Views,

Indexes)

IOS PROJECT (Systems Inter Operability Specifications

. Led a development team for IOS (Inter Operability Specifications) Base

Stations feature development. Developed a thorough understanding of the

customer's process, created Project Plans, established Project

Milestones, Assigned Resources and monitored team members' progress.

Identified hardware needs of the project and coordinated its purchase and

installation. Worked on a part of design and testing while leading the

project.

. Successfully planned and developed software application that enabled IOS

Interface (with Motorola Base station) for the maintenance of

transmission facility in the MSC (Mobile Switching Center) system.

. Played a major part in system integration and testing basic calls, SS7

signaling, Trunk maintenance, etc.

Wireless System DB project (Database User Interface)

. Designed, Developed and maintained Mobile Switching Systems (MSC)

database application and infrastructure for User Interface (RC/V)

software development. As a member of a large project team worked on the

DB subsystem interface and quality control.

. Identified database security loopholes, analyzed the problem and devised

a security solution to restrict the database access to end users through

setting various levels of security controls.

. Designed and developed database features to allow newly introduced

network elements (Micro-cell and Mini-cell).

. Supported on-going maintenance and resolution of customer reported

problems in functional areas of database infrastructure and User

Interface software.

. Member of Quality Process Management Team and provided various quality

improvement ideas.

. Worked closely with customer support group and provided critical

technical support.

EDUCATION

BS, Computer Science, Northeastern Illinois University, Chicago, IL, USA

BS, Mathematics, South Gujarat University, Gujarat, India

Contact this candidate