Data Analyst / QA Analyst

JEAN L LEWIS

Hm: 678-***-****

Cell: 678-***-****

Email: ********@*****.***

PROFESSIONAL SUMMARY

An experienced Analyst with 7 years experience of Crystal reports v11.0/v10.0 and a solid understanding of relation

databases. Has 7 - 8 years of experience using SQL, including database, queries, stored procedures, SRS and scripting.

Strong analytical and presentation skills, problem-solving techniques, proven leadership qualities with emphasis on

individual and team effort backed by excellent communication skills.

EDUCATION:

Bachelor of Science Computer Information Systems

DeVry University

Presently pursuing Master of Science – Management in Information Systems

Keller Graduate School of Management – Graduation - Jan 2013

Certifications:

CST – Certified Software Tester

TECHNICAL SKILLS

Programming Languages: VB, VBscript, JavaScript, Visual C/C++

Software Applications: Microsoft Office Suite, Visio, Microsoft Project

Databases: Access, SQL Server 2005, Oracle, PL/SQL

Reporting/Development Tools: Rational Rose, Robohelp, Crystal Reports 10/11

PROFESSIONAL EXPERIENCE

DTI, Inc Atlanta, GA 07/2011 –

Present

Technical Specialist I

• Execute quality assurance and error correction procedures on data conversion

• Process various metadata from third party production

• Data validation and QA of imaging products.

• Export data and process extract using IPRO E-Capture software

• Process images into text using IPRO Tech software

• Create tools for various data sources using MS Access

• Perform other duties as assigned

Technical Environment: E-Discovery, IPRO Premium Suite, MS Access, Concordance db 8, 10

Consulting, Atlanta, GA 06/2008 – 06/2011

• Technical Environment: Excel, Query Analyzer, SQL Server 2005, PL/SQL, Oracle, UNIX

Vesdia Corp. Atlanta, GA 08/ 2007 – 05/2008

Data Analyst

• Responsible for processing, manipulating, validating, and comparing large data files on a Unix platform;

• Troubleshoot SQL views, stored procedures and functions, DTS packages, DDL statements (Inner Join, Outer

Join, Cross Joins);

• Monitor data to identify recurring patterns

• Run reports off a replicated SQL server and configured changes if required

• Write users, operational, and application documentation

• Support data driven applications for the input and management of data to support back office functions

• Ensure that automated processes are operating correctly

• Analyze processing problems, research product information, and make appropriate recommendations for

resolution

• Conducts appropriate research on issues; including reviewing technical and online resources

• Refer complex and unusual problems to supervisor

• Exercises judgment in accordance with well-defined policies, procedures, and techniques

Technical Environment: Excel, Query Analyzer, SQL Server 2005, PL/SQL, Oracle, UNIX

Primerica, Inc. Duluth, GA 02/2007 – 04/2007

QA Analyst

• Manual testing of company web base applications.

• Developed test case scenarios for unit & user acceptance.

• Documented defects and tracking using Microsoft Excel for a successful resolution.

• Responsible for writing test approaches, plans, cases, and results.

• Performed other duties as assigned.

Technical Environment: Excel

Scientific Games, Inc. Alpharetta, GA 09/2005 –

02/2007

QA Analyst

• Involved in the early stages of the software product development lifecycle with Product Management and

Development Engineering Teams.

• Analyze user and business requirements for new builds while comparing them with old builds to modify test

plans for positive and negative scenarios while performing functional and performance testing

• Main goal is to ensure that each product specification is accurate and testable.

• My responsibilities are test design, test implementation and test execution using industry standard techniques.

• Design, implement, and execute test cases and scenarios based on product functional and system specifications

using modern testing techniques.

• Participate in software development and testing process improvement activities.

• Maintain clear and effective communications with Technical Support and Professional Services.

• Restore test data to client server for testing.

Technical Environment: Excel, Rational Clear Quest, Crystal Reports 10/11, RDBMS, and UNIX

Sprint ION Operations Center Atlanta, GA 10/ 2000 – 11/2002

Data Analyst

• Responsible for downloading and compile raw data into daily reports reflecting status of DSL connection.

• Transferred detail and complex data into an Excel tracking program using macros for daily tabulation and current

updates of completion on DSL connection in a Visual Basic program.

• Create necessary database objects to meet the requirements and increase the performance of the reports. Used

SQL statements for restricting/sorting data and single row functions.

• Developed various databases for Order Managers status reporting and data entry for order administrators using

Microsoft Access.

• Automated reporting process to improve daily tracking of new sales & cancellations using Access/VB6 program.

• Develop a tracking system for the department productivity in return to sales using a MS Access/VB6 program.

Technical Environment: VB6, Access, Excel, Crystal Reports

Contact this candidate