SUMMARY:

• Over 15 years experience in leading enterprise level projects that includes test planning, test case design, and execution.
• Experience developing manual and automation scripts, testing back - end databases, APIs, and web-based applications.
• Adept Confidential identifying process improvement initiatives and implementing testing standards across the organization.
• Effective communicator and problem solver with extensive knowledge overseeing the testing efforts of both onshore & offshore teams.

TECHNICAL SKILLS:

Database: Hadoop, DB2, SQL Server, Oracle, MySQL, Teradata, Microsoft Access, IBM EME (Electronic Marketing Enterprise)

Business Intelligence: Oracle BI, MicroStrategy, Business Objects

Software/Other Tools: Quality Center/ALM, HUE, TOAD, PL/SQL Developer, Teradata SQL Assistant, VerisonOne, HP QTP, SOAP UI Pro, Postman REST Client, Visio, Putty, Remote Desktop, UltraEdit-32, Remedy Action Request System, WebMethods Integration Server, WebMethods Developer, WebMethods Optimize Analytic Engine, Cloudera, Fiddler2, Firebug Lite Debug, Microsoft Excel, TFS (Team Foundation Server), MTM (Microsoft Test Manager), Visual Studio Ultimate 2013, JIRA

Programming: GroovyScript, UNIX Shell Scripting, Hbase shell, C, C#, 4690 IBM Basic, COBOL, XML (JSON)

Methodology: Agile Scrum, Waterfall, Iterative

EXPERIENCE:

Confidential, Alpharetta, GA

QA Test Lead

Responsibilities:

• Responsible for leading/managing a small group of global QA test analysts and overseeing all functional testing efforts in an Agile Scrum environment.
• Working on a multi-million dollar audit transformation technology tool .
• This web based tool (C#, Javascript) helps auditors plan and execute audits, enhance audit quality, and better align audit risks with audit procedures.
• Worked on the Low Connectivity/No Connectivity functionality that gave auditors the ability to collaborate work while offline connected thru a local network hub.
• Verified Dochelper, which is a self-hosted windows application running on a local user’s machine, built on C#, Owin, and Signal R Technologies.
• Dochelper can queue documents, upload & download documents, and handle errors within the Confidential application.
• Create Test Plan, Test Summary, and Defect Reports.
• Perform multi-browser, exploratory, and risk based testing.
• Review, Develop and Execute Test Cases in MTM.
• Write SQL queries in SQL Server Management Studio.
• Review stories and create defects in TFS and determine root cause analysis.
• Execute API scripts in Visual Studio Ultimate to create test data.
• Utilize IE developer tools/Fiddler to debug web pages and view API calls.
• Participating in daily scrum/stand up, Release/Iteration Planning sessions, and Retrospective meetings.
• Created a Knowledge repository and training materials for new QA resources.

Confidential, Alpharetta, GA

Lead Data Analyst

Responsibilities:

• Manage and maintain test cases for customers across various Confidential Risk Solutions product lines.
• Design & develop test data extract files using Groovyscript in SOAPUI Pro from XML transactions.
• Those extract files were then used to load the company’s Confidential database.
• Used Linux Commands to copy input & hashkey files onto Linux and execute scripts to have those files loaded into a MySQL DB.
• Verified the web services retrieved data correctly and that data was also correct in the Rules Framework Application.
• Analyze data in MySQL DB to ensure data is consistent across products lines.
• Created tables in Toad Data Point from Excel Spreadsheets for the
• Customer Service Team, making it easier to query product information and provide test data to customers.
• Document Requirements and train team members on how to use new software application & tools.

Confidential, Alpharetta, GA

Test Engineer

Responsibilities:

• Supported the Claims Transparency project which places fed-ex type tracking on medical claims.
• Validated Java and .Net applications functions according to the acceptance criteria.
• Verified data moves from source to target in databases such as Hadoop, Oracle, and SQL Server.
• Used Hbase shell and HUE/Hive/Impala to verify data in Hadoop.
• Tested web services/API’s using Postman client (JSON) and Soap UI.
• Maintained test cases and scripts using ALM.
• Scheduled meetings with project team to discuss defects, project status, and communicate risks.
• Performed security testing verifying users had authorization to access the front-end applications.
• Utilizes VersionOne to access User Stories & assign resources.
• Participate in agile/scrum planning sessions, daily stand-ups & requirement reviews.

Confidential, Atlanta, GA

Lead Test Data Analyst

Responsibilities:

• Provided resource allocation and projected hours for all assigned projects.
• Assigned and managed offshore resources ensuring proper project coverage.
• Performed test case & data requirement reviews.
• Supported test team in identification and resolution of data related defects.
• Mentored and trained new Test Data Analysts.
• Gathered, analyze, and document data requirements for the entire Enterprise Testing Organization.
• Verify the data requirements satisfy the business requirements for the project.
• Extracted data from the DB2 database using SQL and TOAD for Data Analysts.
• Responsible for leading all data automation and other process improvement projects that includes XML, Excel, ALM, QTP, & SOAP UI.
• Communicated project status to the Test Project Manager and associated teams.

Confidential, Alpharetta, GA

Lead Test Engineer

Responsibilities:

• Lead the Trending & Correlation project (Agile Environment) that allows Confidential the ability to detect when and where there is a device problem on their Confidential Network, in order to reduce the number of unnecessary truck rolls, increase customer service and save the company $24 million annually.
• Trained new Test Engineers and prioritized defects.
• Verified data in the target database coming from 5 Source systems using MySQL Query Brower and Oracle SQL Developer.
• Reviewed Informatica log files to verify data was loaded into the target tables without error.
• Verified that when the database displayed a problematic device, a corresponding trouble ticket was automatically created in the UET Remedy ticketing system.
• Created BI Reports for management to measure project success.
• Performed web testing on the Confidential Monitoring Page and verified it contained the correct Points of Interest for each problematic device on the network.
• Tested and Validated WebMethods Integration Server and MWS deployments.
• Deployment artifacts included IS packages, Remedy & JDBC adapters, and .war files.
• Verified the WebMethods Optimize Analytic Engine (KPI’s) “fired” and alerted the business as to when a device was “trending” out of spec so the business can identify problems in real time, instead of after-the-fact analysis.

Confidential, Alpharetta, GA

Senior QA Analyst

Responsibilities:

• Execute SQL Scripts in Teradata to validate data going into and coming out of BID (Business Intelligence Database).
• Review project documentation to ensure requirements are clearly defined.
• Responsible for testing and validating Extract Files, BI Business Object Reports, and Data in the Data Warehouse.
• Responsible for requesting test data from multiple source systems for system testing.
• Defined and executed Test Plans, Test Cases, and SQL Scripts based on the Functional Requirements, Technical Specifications, and Design Documents.
• Coordinate conference calls to communicate project test status, data issues, and defect resolution.

Confidential, Atlanta, GA

QA Test Lead

Responsibilities:

• Developed detailed regression and functional test cases in Quality Center based on review of technical specifications and business requirements.
• Created and maintained required QA documentation including test plans, test scripts, and defect summary reports.
• Executed SQL statements in Teradata to validate MicroStrategy reports.
• Responsible for security testing and verification of user roles.
• Reported to and communicated all work and project status to Project Management.
• Lead Test case and defect summary review meetings.
• Assigned resources based on project scope.
• Created dashboard & analytic reports for upper management.