P h a n i k a n t h R a n g a

** ********* ***, ***** ********, NY 11710

Ph: 310-***-**** Email: acz97n@r.postjobfree.com Work Authorization: US Permanent Resident (Green Card) https://www.linkedin.com/in/phanikanthranga

P r o f e s s i o n a l P r o f i l e

Master of Science in Computer Science and ASQ CSQE

(Certified Software Quality Engineer) with 15 years of diverse experience in QA Leadership, Test Management, People Management, QA Mentoring, Creating Automation Frameworks, moving projects from doldrums to production, automated testing, performance testing, end-to-end testing of complex Web, Mobile, Cloud, Client/Server, Desktop and Mainframe based applications.

QA Leadership – Managed on-site and off-shore QA teams. Created and grew test engineering teams and sustained software quality at several organizations. Hired and mentored several technical and non-technical QA Engineers.

Test Automation Leadership – Architected and maintained several automation frameworks and scripts. Developed automation frameworks in Unified Functional Testing/QTP.

Willingness to Exceed Expectations – Worked on Page Object Model automation framework using Selenium

WebDriver while managing the team. Administered HP Quality Center / ALM as a complete test management tool at several organizations. Rolled out new processes for Support teams so that they could be self-sufficient.

Accountable & Results driven - Strategic visionary exceling at managing projects, collaborating with project teams, interfacing with clients, and deploying technologies to build successful solutions for clients.

E d u c a t i o n a n d C e r t i f i c a t i o n s CSQE (Certified Software Quality Engineer), ASQ, Dec 2008 – Dec 2017 Certification Number: 4345

Project Management, Customer Requirements Analysis, Software Business Analysis, and SQL certified by Brainbench, Transcript ID: 8196393

MS, Computer Science, University of Louisiana at Lafayette, US Bachelor of Technology, JNTU College of Engineering, Hyderabad, India

A r e a s o f E x p e r t i s e

QA Leadership, Test Management

Mentoring, People Management

Architecting Automation Frameworks

Performance Engineering

Test Automation Maintenance

Test Planning, Defect Triage

Coaching & Performance Improvement

Cloud (SaaS, Paas, IaaS) Testing

Agile Methodologies – SCRUM, XP

E x p e r i e n c e a n d S k i l l s

HP Quick Test Professional / UFT

HP LoadRunner, JMeter, TFS, Appium

Selenium WebDriver, Java, TestNG

HP Quality Center, HP ALM, WCF

Hudson, GIT, TeamCity,Maven, Jenkins

VBScript, SQL, Tortoise CVS, WatiN

UNIX, XML, J2EE, C, C++, C#, NUnit

JavaScript, ATOM, TestComplete,

Ranorex, TFS, Azure, AWS

Octo Deploy, Postman, FIX Protocol

SOAP, REST, Soap UI, Cucumber,BDD

I n d u s t r i e s

Financial Services

eCommerce

Retail

Government

Non-Profit

Health Insurance

Mortgage

Telecommunications

Pharmaceutical

P h a n i k a n t h R a n g a

P a g e 2 o f 10

E x p e r i e n c e H i g h l i g h t s

QA Leadership

Freestyle Solutions/Dydacomp: Worked here

twice. Managed eight QA Engineers and the QA

delivery of complex Cloud and Web applications.

Setup QA processes across the organization.

Identified and hired the best QA talent in the

industry. Mentored QA resources and helped them

advance in their careers. Initiated Database and API testing.

NYC DEP: Managed five QA Specialists and the QA

delivery of several complex web, mobile,

client/server and mainframe applications. Setup and improved QA processes across the entire

organization. Setup mobile test lab.

Leukemia and Lymphoma Society: Hired QA

resources and trained and mentored five QA

Analysts. Established and implemented QA Best

Practices across the organization.

Yahoo! Inc.: Managed the entire QA efforts,

including manual and automation, of an application in Agile Methodology – SCRUM environment.

Demonstrated leadership by delivering two technical presentations. Mentored a tech support engineer to complete manual testing.

Charter Communications: Led three automation

engineers. Mentored and trained team members on

using QTP’s expert view. Determined the number of

QTP licenses required and worked with

management to reduce the costs of automated

testing.

Compuware Corporation: Presented “QA 101” to

22 Technical Consultants. Presented “Test

Automation 101” to 20 QA Analysts, Developers,

Project Managers, and Technical Writers. Presented my “CSQE Experience” to QA Consultants.

Lincoln Financial Group: Worked here twice.

Presented “Introduction to HP Quality Center / ALM” to the Business Analysts and Managers to show

them how the QA team uses Quality Center and how

the organization would benefit by them using it as well.

QA Automation & Performance Testing

Freestyle Solutions/Dydacomp: Managed and

participated hands-on in QA Automation using

Selenium WebDriver and Performance Testing using

JMeter.

NYC DEP: Created and maintained the automation

framework using HP QTP / UFT and utilized HP

LoadRunner / Performance Center for performance

testing & CA APM (formerly Wily Introscope) for

performance monitoring.

Yahoo! Inc.: Developed test scripts for automation of Web and client/server applications using VBScript in QuickTest Professional. Reduced the regression

test execution time by 30% by automating major

functionalities. Used JMeter for Web Services

testing.

Charter Communications: Set up and maintained

the framework for automation in Quick Test Pro.

Created a master suite of 139 QTP tests.

Kohl’s Department Stores: Created the automation framework in QuickTest Professional. Automated the creation of 143 test sets in HP Quality Center / ALM which saved Kohl’s 120 hours of manual effort.

Created business components in Quality Center

using QTP nearly three days ahead of expected

delivery date.

Leukemia and Lymphoma Society: Utilized Web

Performance Load Test for performance testing.

Evaluated and initiated automated testing efforts.

Lincoln Financial Group: Saved the team 1000s of dollars by simplifying entering of requirements into Mercury Quality Center by automating the process.

Generated test scripts for load and performance

testing using LoadRunner. Analyzed transaction

graphs, Web resource graphs, and network graphs

in LoadRunner to help pinpoint bottlenecks.

Automated the test cases for regression testing

using QuickTest Professional.

P h a n i k a n t h R a n g a

P a g e 3 o f 10

C h r o n o l o g y o f E x p e r i e n c e

Global Visse Inc. / Pick Technologies Inc., NY Jul 2016 - Present Client: Technology/Government – Microsoft Corporation / New York City Government, Manhattan, NY Position: Senior Test Consultant

Environment: ASP .NET, VB .Net, C#, JQuery, AngularJS, nHibernate, WCF, WPF, JavaScript, Infragistics, SQL Server, XML, HTML 5, Azure, UWP, Xamarin

Tools: Microsoft Coded UI, Visual Studio 2015, SQL, SQL Server Management Studio, TFS, Microsoft Test Manager, Ranorex, TestComplete, Selenium WebDriver, Fiddler Manual, Automation, API, Database testing of DAS.

Key contributions:

Performed Web API testing using Fiddler and RFHUtil

Provided an automation proof of concept using Ranorex and TestComplete

Performed database testing using SQL Server Management Studio

Created automation scripts using Selenium WebDriver

Deployed builds to test environments using Continuous Delivery tool Microsoft TFS

Wrote automation scripts to automate several manual test tasks

Regression tested .net 4.5 to DotNet462 upgrade and ensured successful production deployment

Tested Stored Procedures optimization and automated the process Freestyle Solutions Inc. (2nd stint), Parsippany, NJ Jun 2015 - Jun 2016 Position: QA Manager

Environment: ASP .NET, VB .Net, C#, JQuery, AngularJS, nHibernate, WCF, CSS, JavaScript, Bootstrap, SQL Server, PhantomJS, XML, HTML, Amazon AWS, Confluence, New Relic Tools: Selenium WebDriver, Visual Studio 2015, GIT, JMeter, Smartsheet, QA TestLink, SQL, SQL Server Management Studio, TeamCity, Hudson, JIRA, OctoDeploy, JSON, Postman, ATOM, Firebug Managed manual, automation, and performance test teams of Freestyle O.M.S. cloud application Key contributions:

Managed the automation and performance testing efforts of the IaaS (Infrastructure as a Service) application

Managed and mentored the eight QA Engineers and helped them grow in their careers

Helped create and maintain the automation framework using Page Object Model

Created automation scripts using Selenium WebDriver

Ran automation scripts using Continuous Integration tool Hudson

Moved one of the manual test engineers into an automation role by constantly providing guidance

Provided direction and strategy to on-site and off-shore manual, automation, performance testing teams

Utilized JMeter for creating performance test scripts and running them

Identified issues by having open communication with VP, Development Manager, and Project Manager

Improved QA TestLink test case review process

Identified and hired the best QA talent in the industry

Coached manual test engineers in Database and API testing and implemented database and API testing across the entire cloud-based application

Deployed builds to QA environment using Octo Deploy

Improved JIRA defect workflow

P h a n i k a n t h R a n g a

P a g e 4 o f 10

SVAM International Inc. / Pick Technologies Inc., NY Jan 2012 - Jun 2015 Client: Utilities – New York City Department of Environmental Protection, Elmhurst, NY Position: QA Lead Consultant

Environment: ASP .NET, VB .Net, C#, JQuery, AJAX, WCF, Web Services, CSS, JavaScript, DHTML, SQL Server, SSIS, SSRS, iOS Devices, Android Devices

Tools: HP QuickTest Professional (QTP), LoadRunner, BugNet, SQL, SQL Server Management Studio, CA APM, PerfMon, Microsoft Test Manager, TFS

Worked on BAPPS, CISM, CIS, and WSPS projects.

Key contributions:

Managed the automation and performance testing efforts of the entire organization

Implemented Test Plan and Test Case templates for the entire QA team

Implemented QA Best Practices across the organization

Performed manual and database testing of various applications

Created and maintained the automation framework using QTP / UFT

Wrote user-defined functions in QTP using VBScript

Created and maintained HP LoadRunner / Performance Center (PC) scripts

Ran LoadRunner scenarios and analyzed the results

Utilized CA APM (formerly Wily Introscope) and PerfMon for deep-dive analysis of performance issues

Worked with Dot net and Cobol Developers and SQL Server and DB2 DBAs to find bottlenecks in the application and fix them

Tested WCF Services using RESTClient

Utilized Microsoft Test Manager for writing test cases and TFS for issue management

Performed thorough mobile testing on iOS and Android devices

Tested ETL process and wrote complex SQL queries

Configured and Installed BugNet

Advansys Inc. (formerly Technotec Inc.) May 2009 - Jan 2012 Client: Non Profit – The Leukemia & Lymphoma Society, White Plains, NY Position: QA Automation Lead

Environment: Java, Flash, Flex, JSP, Servlets, J2EE, Hibernate, Spring, JavaScript, HTML, CSS, SQL Server Tools: HP QuickTest Professional (QTP), Zap-fix, HPE Quality Center (QC), Web Performance Load Tester, SQL, SQL Server Management Studio, Firebug, Fiddler, JIRA Worked on LLS.org, LightTheNight, TeamInTraining, Society Central, and Mission360 projects. Key contributions:

Hired onsite and offshore QA Analysts and QA Automation Engineers

Trained, Mentored, and Led all five QA resources

Reviewed the automation needs of the applications and finalized the automation software (QTP & Zap-fix)

Setup QA processes across the organization

Created and implemented test case template, defect template, and test plan template

Implemented and administered HPE Quality Center / ALM as a complete test management software

Created QA test plans and executed them

Reviewed all the test cases and JIRA defects for quality

Created and maintained the automation framework in QuickTest Professional

Created automation scripts in VBScript to reduce the regression testing effort by 50% P h a n i k a n t h R a n g a

P a g e 5 o f 10

Automated the flash and flex parts of various web applications

Worked with management to discuss project priorities and planned the QA schedule and resource allocation

Established and implemented QA Best Practices across the organization

Planned and implemented performance testing of web applications

Trained manual testers to create automation scripts in QTP Client: Retail – Freestyle Solutions (formerly Dydacomp), Totowa, NJ Position: Sr. QA Automation Lead

Environment: ASP .NET, VB .NET, CSS, Spring .net, MS IIS, SQL Server, TFS Tools: HP Quality Center, WatiN, SQL, SQL Server Management Studio, QA TestLink, Visual Studio 2008, Trac

Complete Commerce allows Dydacomp to offer its clients eCommerce websites. There are over 400 small business clients for this application.

Key contributions:

Setup QA processes across the organization

Implemented changes to QA, Development, and Configuration Management processes

Led defect triage meetings and brought several long standing defects to closure

Implemented SLAs for development to turnaround bug fixes

Created test case template, defect template, and requirements document template

Created automation scripts using WatiN

Performed end-to-end testing of the application and found 265 defects

Created bench strength report of QA

Had each QA Engineer write 5 test cases a day. Got to creating several test cases for the application

Standardized and later enhanced the defect recording, defect tracking, defect prioritization, and reporting process that enabled the team to get into testing rhythm

Provided management with QA status dashboard with all important metrics

Reviewed each of the test cases for accuracy and got the team to improve them in such a way that any new QA Engineer can execute them

Worked on improving the deployment process

Reviewed all the bugs for quality before assigning them to appropriate teams

Rolled out a clear road-map of best practices and processes. This included processes of escalation of tickets from Support to QA, encouraging all developers to use Trac, and implementation team to go through Support before coming to QA (so that support could become self-sufficient)

Shared my QA knowledge with the team and made sure they were retaining the information by conducting regular tests

Reviewed new requirements for the application and provided Product Management with recommendations for improving requirements

Client: Direct Marketing - Publishers Clearing House, Port Washington, NY Position: QA Automation Lead

Environment: PHP, JavaScript, HTML, CSS, ASP .NET, VB .NET, MS IIS, SQL Server, TFS Tools: Selenium, Java, TestNG, SQL, SQL Server Management Studio, Joomla, Firebug, Fiddler, TeamCity PCHLotto.com is an online lotto application where users can login every day, play 4 games, and win money every single day.

Key contributions:

P h a n i k a n t h R a n g a

P a g e 6 o f 10

Involved in creating the Page object model automation framework of Selenium

Created and maintained scripts using Selenium WebDriver and Java in Eclipse

Used TestNG as Unit Testing framework for Selenium Execution and Management. Included assertions and verifications for tests.

Tested data migration from the old database to the new database by creating complex SQL scripts

Performed Functional Testing, Regression Testing, Integration Testing and Database testing

Used Joomla for content management of the website and Pivotal Tracker for Agile Requirements Management

Used Firebug and Fiddler for inspecting and monitoring HTML, JavaScript, and Net requests in web pages Client: Financial Services - Lincoln Financial Group (2nd stint) Position: Test Lead

Environment: Java, Informatica PowerCenter, SQL Server, Servlets, JSF, J2EE, Vitria, XML, Oracle, WebLogic, Business Objects, Crystal Reports

Tools: HP Suite (QuickTest Professional, LoadRunner, Quality Center), SQL, PL/SQL Developer Lincoln Unifier is a critical application to the Defined Contribution line of business. As the application matures, there are certain changes needed for the application. This project is to enhance the environment with the following enhancements: Enhancements to the current QA and UAT environments, Enhance the current Groupnet Security Authentication process, Obtain new Software to enhance Testing Activities, Improve the current scheduling process in all environments (e.g. Adopt AutoSys)

Key contributions:

Understood the entire Lincoln Unifier application and its internal business processes

Created Automation test plan and Performance test plan for Unifier

Saved the team 1000s of dollars by simplifying entering of requirements into Quality Center by automating the process

Implemented best practices for Business Analysts to follow while writing the requirements

Performed system testing, integration testing, functional testing, regression testing, performance testing, and exploratory testing of Unifier

Automated critical functionality using QTP

Created user defined functions in VBScript

Created Performance test scripts using LoadRunner Virtual User Generator

Created LoadRunner scenarios using LoadRunner Controller

Helped find memory leaks in applications using LoadRunner Analysis and worked with Dev and DBA to fix them

Delivered several presentations including: Role of QA in Agile Methodologies, Effective Test Case Design, White box testing terms, Testing and Traceability, and Simplifying entering of requirements into Quality Center

Created test plans, test cases, test data, and test summary reports

Executed test cases and found defects in applications

Drove defects to completion by interacting with developers and Business Analysts

Created an estimation tool for all the QA Analysts to provide estimations for their work efforts

Created DB Field mapping document for all the fields in the application

Performed Data warehouse testing

Implemented QA Process Improvement Ideas with the help of the QA Manager

Tested several assist tickets and fast tracks

Compuware Corporation December 2007 - March 2009

Client: Retail – Kohl’s Department Stores, Menomonee Falls, WI Position: QA Automation Lead

P h a n i k a n t h R a n g a

P a g e 7 o f 10

Environment: ASP .NET, VB .NET, C++, SQL Server, SharePoint, WebLogic, StarTeam Tools: HP QuickTest Professional (QTP), WinRunner, Quality Center (QC), StarTeam, SharePoint, SQL Point of Sale (POS) is an application used at the cash registers of over 1000 department stores throughout the United States. There were 5400 test cases of POS written using Keyword-driven testing methodology. The entire automation code was written in WinRunner and my team was responsible for rewriting the code into QTP using QC. Key contributions:

Understood the entire framework of the current automation in WinRunner

Involved in creating the new automation framework using QTP

Created business components in QC using QTP nearly three days ahead of delivery date

Prepared documentation for 105 Business Components

Created user defined functions with VBScript to enhance the maintainability of test scripts

Automated the creation of 143 test sets which saved the team 120 hours of manual effort

Created several recovery scenarios in QTP to handle unexpected errors

Performed Functional Testing, Regression Testing, Integration Testing on POS using QTP

Created Error Handler functionality to reboot the application in case of a fatal error

Maximized the usage of QTP result reports and utilized the tool to its maximum advantage

Designed test data using text files, created data driven tests for testing POS with positive and negative values

Provided the team with guidance on the usage of QTP and Quality Center

Minimized the use of log files for debugging

Automated 40% of test sets in Quality Center using Quick Test Pro

Utilized StarTeam as a code repository and SharePoint to report project status to management Client: Pharmaceutical – Capital Returns, Inc., Milwaukee, WI Position: Sr. QA Analyst

Environment: ASP .Net, VB .Net, SQL Server, SQL Server Management Studio, ASP, VB, DTS Tools: SQL, MS Word, MS Excel

CapNet is the customer facing application of Capital Returns, Inc. (currently Genco Pharmaceutical Services) where customers can log in and track the progress of their pharmaceutical returns. It is built on DOT NET framework. Key contributions:

Created smoke, functional, and regression test cases to test three different applications.

Performed smoke, functional, regression and GUI testing.

Wrote SQL queries to perform database and backend testing.

Interacted with users and performed user acceptance testing.

Resolved and closed several issues in production.

Created and maintained a traceability matrix to map requirements to test cases.

Reported, tracked, resolved, and closed defects before they got into Production. Keshav Consulting Solutions, LLC July 2007 - December 2007 Client: Telecommunications - Charter Communications, St. Louis, MO Position: QA Automation Lead

Environment: Java, JSP, Servlets, J2EE, SIGMA, XML, Remedy, SharePoint, Oracle, WebLogic Tools: HP QuickTest Professional, Remedy, SharePoint OSS Portal is a Web application used by their customer service representatives to support customer service calls for their high speed Internet customers. It is built entirely in J2EE. JMS messages are sent for communication between OSS Portal and SIGMA.

Key contributions:

P h a n i k a n t h R a n g a

P a g e 8 o f 10

Set up and maintained the framework for automation of regression testing.

Created and maintained a shared object repository for QuickTest Professional (QTP).

Created a function library using VBScript to modularize scripting in QTP.

Created and enhanced test scripts in QTP using synchronization and parameterization.

Created a master suite of 139 QTP tests.

Generated reports for management using user-defined functions in VB Script.

Trained team members on using QTP’s expert view.

Determined number of QTP licenses required; worked with management to reduce the costs of automated tools.

Performed overnight batch testing using QTP.

Created and tracked defects in Remedy.

Client: Financial Services - Lincoln Financial Group Position: Sr. QA Automation Engineer

Environment: Java, EJB, Servlets, JSF, J2EE, Vitria, XML, Oracle, WebLogic Tools: HP Mercury Suite (QuickTest Professional, LoadRunner, Quality Center), SQL SOA 403(b) plan is a tax-advantaged retirement savings plan available for public education organizations and some non-profit employers. The application is built on Service Oriented Architecture (SOA), so that the components can be reused for 401k and other LFG applications. The front end of the application is JSP and reports were built using Java Server Faces (JSF).

Key contributions:

Automated the regression test cases using QuickTest Professional.

Parameterized the test scripts and created checkpoints.

Involved in database testing of the application to check for insert and update operations.

Handled unexpected errors using QTP’s exception handling.

Performed regression testing to check for defects in previous tested modules.

Generated test scripts for load and performance testing to see how the system behaved under load using LoadRunner.

Used LoadRunner monitors to identify load and performance bottlenecks.

Correlated the unique data generated from the server such as Token ID.

Analyzed transaction graphs, web resource graphs and network graphs to pinpoint the bottlenecks.

Performed database and backend testing using SQL queries.

Prepared test cases for navigational testing, functionality testing under load, and GUI testing using Quality Center.

Performed manual testing of the application and identified defects.

Participated in meetings and walkthroughs.

Yahoo! Inc., Burbank, CA September 2005 - June 2007 Industry: eCommerce

Position: QA Automation Engineer

Environment: UNIX, Java, JSP, Servlets, EJB, J2EE, XML, Oracle, JMeter, Windows NT/2000, Oracle, WebLogic, TestManager, Tomcat, CVS, AJAX, Agile Methodology

Tools: QuickTest Professional, SQL, XML, JMeter, SOAPTest, UNIX, TestManager Panama was the new generation advertiser system of Yahoo! Search Marketing (YSM), replacing the legacy system, the front-end of which is DirecTraffic Center (DTC). It was built entirely in J2EE. Workflow Management (WFM) is Panama’s editorial system wherein managing editors assign work to all YSM editors. Key contributions:

Worked with business analysts to finalize the requirements for Panama WFM.

Developed test scripts for automation of the web-based application using VBScript in QuickTest Professional. P h a n i k a n t h R a n g a

P a g e 9 o f 10

Created user defined .vbs files to check date functionality features.

Wrote functions in Quick Test Professional for reusability.

Automated test scenarios for GUI, functionality, boundary, security, and regression testing using QuickTest Professional.

Used QTP checkpoints and regular expressions for checking web pages, web objects, images, texts, and tables.

Reduced the regression test execution time by 30% by automating major functionalities

Built QA scripts to test AJAX components of the UI using QTP

Wrote UNIX shell scripts for testing WFM

Tested WFM in a 2-week sprint cycle using Agile Methodology-SCRUM.

Conducted walkthroughs and bi-weekly Sprint meetings to verify that project milestones were met.

Validated data extracted from the databases and updated the Oracle database.

Performed extensive backend testing by writing SQL queries against Oracle database

Performed positive and negative testing using data driven tests.

Performed all aspects of validation, including functional, acceptance, regression, load, and system testing.

Mentored a tech support engineer to complete all aspects of testing.

Reported and tracked defects and enhancement requests using TestManager. Presentations:

“Overview of Workflow Management” to Managers, Developers, and Business Analysts so that they had an understanding of the application I was testing.

“Advantages of Panama Advertiser UI over legacy DTC” to the entire Yahoo! QA team so that they appreciate why we were moving to the new UI.

Integrated Software Solutions, Inc. July 2004 - September 2005 Client: Financial Services - Ameriquest Mortgage Corporation, Anaheim, CA Position: QA Analyst

Environment: Java, JSP, Servlets, J2EE, XML, Oracle, JMS, EJB, Windows NT/2000, Oracle, XMLSpy, WebLogic Tools: WinRunner, Rational ClearQuest, Rational ClearCase, SQL, XMLSpy Vendor Management System (VMS) is the middle-tier system which receives requests from multiple client applications and based on the request type and product type performs a vendor selection, XML mapping, and routes the request to appropriate vendor using Web service calls. Automated Sales Application Process (ASAP) was the new Loan Origination System of Ameriquest based on J2EE framework which replaced the existing Empower application. JMS messages are exchanged between various engines of ASAP.

Key contributions:

Helped implement changes to improve the functional requirements.

Implemented new test case numbering for ASAP.

Performed White Box testing on VMS.

Developed and executed functional and integration test cases for ASAP.

Performed functional and integration testing.

Automated regression test cases using Mercury WinRunner.

Followed Rational Unified Process quality assurance and testing processes.

Participated in meetings with business analysts to resolve defects in IBM / Rational ClearQuest.

Used Rational ClearCase for version control and for storing all the documentation.

Reported, resolved, retested, and closed defects in ClearQuest. P h a n i k a n t h R a n g a

P a g e 10 o f 10

Client: Insurance - Blue Cross Blue Shield of Wisconsin / WellPoint / Anthem, Inc., Pewaukee, WI Position: QA Engineer

Environment: WellPoint Distinct Intelliterm Attachmate Extra! X-treme, WGS 2.0, IMS, OS/390, DB/2, z/OS Tools: SQL, WellPoint Distinct Intelliterm Attachmate Extra! X-treme, WGS 2.0, ISMi, eRoom, PIMS Core Systems Integration-Claims Revitalization (CSI/CR) is a mainframe application of BCBSWi to merge their new business system into the WellPoint Group System (WGS) 2.0. Worked on three different functional areas of the project: Provider, Pricing, and STAR (Individual Small Group) Claims. Key contributions:

Wrote system test plans and test cases for the three functional areas after analyzing the requirements.

Prepared functional design document for STAR Claims COB/Medicare from functional requirements.

Extracted data from Oracle database using SQL queries.

Used WGS 2.0 mainframe systems WellPoint Distinct Intelliterm Attachmate Extra! X-treme to process claims.

Validated the provider file and provider contracts using SQL queries.

Performed system testing by executing test cases on WGS 2.0.

Performed regression testing, production readiness testing, negative testing, and end-to-end testing to make sure that system worked per the specifications.

Executed system, regression and UAT test cases for Pricing, WI IT Provider/Pricing and STAR Claims.

Created a traceability matrix to map requirements to the test cases.

Interacted with users to perform user acceptance testing for the three functional areas.

Participated in walkthroughs and weekly meetings and reported daily and weekly status to the IT Leads and STC.

Maintained version tracking with eRoom.

Reported, tracked, resolved, and closed defects in Information Service Management intranet (ISMi).

Completed system test outstanding defects list document and system test results document for each release. Vivian Alexander, Inc., Lafayette, LA June 2003 - August 2003 Industry: Fine Art

Position: Web Developer

Environment: Oracle 8.0

Tools: JavaScript, SQL, HTML, Adobe Photoshop

Designed, developed and maintained their web site www.vivianalexander.com Key contributions:

Designed and developed the layout of all the web pages using JavaScript and HTML

Implemented ways of increasing sales, such as Cross-Sell, Promotions and Auctions at eBay University of Louisiana at Lafayette, Lafayette, LA January 2001 - December 2003 Industry: Education

Position: Graduate Assistant

Environment: Oracle 8.0, UNIX Solaris 5.8

Tools: Java, JSP, Servlets, JavaScript, Tomcat

Developed online examination environments for the students enrolled in MCHE 365 and FNAN 405 courses offered at the University of Louisiana at Lafayette.

Contact this candidate