Summary:

• Software professional with over 10years of experience in the field of Information Technology as a QA Analyst/Data Analyst/BA
• Well experienced in gathering test requirements from business groups and designing and documents.
• Ability to clearly determine client’s objectives, analyze current processes, operational improvements and integrate information technology to improve performance.
• Excellent knowledge in Functional and Load testing business applications using tools including ETL Ascential Data Stage,HP Test Products (QTP, WinRunner and Quality Center), IBM/Rational Suite Test Studio (ReqPro, Robot, Test Manager, Clear Quest, Clear Case), and Segue Silk Test Suite (Silk Test, Silk Radar, Silk Performer).
• Well versed with SDLC processes and Software engineering Methodologies like CMM, RUP & AutoSys
• Possess excellent communication skills and ability to work either independently as well as in a team.

Technical skills:

ETL Tools:

Data stage 8.0/7.5.2/7.5.1/7.1

Business Intelligence:

Microsoft OLAP Manager, MicroStrategyDesktop 7.5.0/8.0/9.0,

Databases:

Oracle9i/8i, MSSQL Server, T SQL, SQL*Plus, TOAD, SQLNavigator& SQL Developer, SQL*Loader, DB2, SQL, PL/SQL, Oracle, MS SQL server, MS Access,DB2

Languages:

COBOL, C, C++, SQL, PL/SQL, SQA Basic, HTML, XML, and Visual Basic- 5.0/6.0.

Microsoft Tools:

MS-Word, MS-Excel, MS Access, Power Point, Visio

Operating Systems:

Windows Vista/ NT/2000/98, UNIX and MSDOS

CRM/Billing Systems:

Clarify, Seibel, AMDOCS

Reporting and Other Tools/Applications:

SharePoint, Doors, Telelogic, RUP, Crystal Reports

Defect Tracking Tools:

Quality Center 9.0, Test Director 8.0/7.6, Clear Quest, Silk Radar, ARS Remedy, Change Synergy, and CM Synergy.

Professional Experience:

Confidential (Charlotte, NC) 11/2010 Present

Role: QA Data Analyst

ECRIS Wholesale System F4P Data Model

ECRIS is the system of the record for managing credit risk across enterprise. As part of the strategic solution design , the F4P Data Model and Reporting project will be implementing an ECRIS Data Store,
ECRIS Data Mart and F4P models. The strategic solution will be implemented on Netezza. MicroStrategy 9i is the front-end reporting tool used for reporting.

• Effective command of the Global Delivery Model and cross-cultural sensitivities
• Actively participated in design, data model and code reviews
• Worked on F4P Data Model & reporting for EDS (ECRIS Data Store) & EDM (ECRIS Data Mart)
• Developed test plans, test cases for all necessary projects and application releases which cover data movement from the source systems, through the ETL processes to the end-user applications.
• Performed data validation and testing of PL/SQL scripts
• Worked on the Pivot tables for data validation and defect triage.
• Worked on the front end reporting of MicroStrategy reports for the ECRIS Wholesale
• Worked with DI (Data Integration) for all the data sourcing needs for ECRIS
• End-to-end grasp of the entire software development life cycle (SDLC) including analysis, design, development and testing of software applications.
• Create test strategies at the outset of initiatives/enhancement projects
• Reviewed test cases and executed(functional testing, integration testing, regression testing & UAT) for all enhancements.
• Perform execution of test cases and scripts, creation of department documentation and defect tracking
• Worked on Quality Center for the defect reports.
• Confidential New York, NY) 05/2010 11/2010
• Role: QA Data Analyst
• Kaplan provides higher education programs, professional training courses, test preparation materials and other services for various levels of education.
• Translate business requirements into technical code and provided data output to Product management team.
• Responsible for QA documentation, test scripts, ETL / BI automation tests and QA metrics
• Extensively wrote SQL queries to validate data in warehouse and reports by comparing source and target systems and performed data analysis.
• Actively involved in end-to-end testing, BI testing, Integration testing, ETL testing, etc.

Environment: Oracle, UNIX, Data Stage, MicroStrategy, Quality Center, TOAD.

Confidential (Houston, TX) 04/2008 05/2010

Role: QA Analyst

City of Houston, under the Federal Govt. Department of Health deals with different projects with the state dealing with all the Birth/Death certificates, Police Dept, Water/Sewer and the different counties with Houston.

• Defining the project objective and developing a plan to accomplish the objective.
• Experienced with full life Cycle and Methodology for implementing logical and physical models of Data warehouse.
• Enhanced the Job Performance by using proper partitioning methods and analyzing the resources utilized using Job Monitor.
• Experience in UNIX, for various functions such as maintenance, backup, and configuration.
• Extensive experience working with complex mainframe EBCDIC files using complex file stage
• Implemented Data Stage Application using Change Data Capture (CDC).
• Created job sequences and job schedules to automate the ETL process. Enhanced the job properties for performance tuning.
• Involved in all the stages of Software Development Life Cycle (SDLC).
• Anticipate problems, recognize them when they arise, and solve them quickly and efficiently.

Environment:IBM Data Stage 7.5, 8.01, oracle 10g/ 8i, IBM AIX, Oracle, DB2, Flat files.HP Quality Center

Client: Confidential (Overland Park, KS) 04/2006 12/2007

Role: QA / BA AnalystUBP (Unified Billing Process)

Sprint and Nextel have merged into one company that now supports two cellular networks - CDMA and iDEN. As a result, Sprint now requires a unified Customer Care and Billing system supporting policies, activities and processes related to both networks. The Unified Customer Care and Billing system will support Sprint in its goal to create a unified policy for creating and managing its CDMA and iDEN customer and subscriber base. Being part of the testing team my primary focus areas were CSM, WLNP, AR and Billing (Post-Paid), s-View and e-Care. Apart from conversion testing, was also involved in testing the later releases of the applications till date
Responsibilities

• Demonstrate functional knowledge of Amdocs-Ensemble Billing System
• Organized and conducted User Acceptance Testing with business users for groups CCAT & SALES OP
• Carried out Data Validation and Data Integration using SQL Queries.
• Executed UNIX scripts on exterm to run the different jobs in AR, AP, GL and BOOST.
• Performed black box testing on CSM, s-View, e Care, WLNP and AR.
• Performing the User acceptance testing. Actively participated in Status report meetings and interacting with Development team to discuss the technical issues.
• Used Quality Center as a repository for all of the testing efforts.
• Assisted for all the requirements which included activation pins, setting up profiles and running the Revenue Assurance jobs for the Boost business UAT support.
• Worked on the Handset testing for all the various applications on 3G CDMA handsets.
• Provisioned handsets and tested for various services(Messaging, Download Content, Ringtones & Wallpapers)
• Gained knowledge of the Qualcomm Binary Runtime Environment for Wireless (BREW) software architecture to verify proper integration of the software to the handset.
• Additional testing included: high-speed packet data (HSPD), short messaging, extended messaging, and multimedia messaging services (SMS/EMS/MMS), extended user interface (UI) troubleshooting, various calling features, accessories, and PC synchronization tools, among other testing.
• Tested the usage content of the handsets in the STIC lab for CDMA and IDEN networks.
• Worked in the War room as the shift in charge in driving the defects and getting them resolved.

Environment: IBM Data Stage 7.5 (Parallel extender), oracle 9i, IBM AIX,Java, XML, Voice XML, .NET, ASP and JavaScript, Quality Center 8.2 EJB servers Interface with Tuxedo, MQ Series, Convergys Billing system, AMDOCS ENSEMBLE billing system & Change Synergy.

• Confidential (Buffalo Grove, IL) 11/2005 04/2006
• Role: QA / BA Analyst
• CTS (Claims Technology Service) Nextgen 0.5, Express Repair Link & Work Force Management System - This application is developed to schedule appointments with the adjuster. Drive-Ins can be created for the vehicles. This application allows the adjuster to take a new appointment for vehicle inspection, updating the existing appointment, scheduling appointments, and rescheduling appointments. The estimates can be uploaded and the assignments can be closed. This application has been built using .NET and Oracle.
• Involved in functional testing and regression testing of the application.
• Involved in planning, preparation and execution of the System Test using Process Claims and PenPro in TSO.
• Involved in writing test scripts, identifying test conditions and implementing them.
• Reviewed functional requirements for writing test cases.
• Involved in the walkthroughs and gathering the business requirements from BA.
• Involved in creating claims using the LRS.
• Have written test scripts in TD 7.6 for functional requirements.
• Logged defects in TD and closed them when fixed.

Environment:Windows NT, .NET, Oracle, Teradata, Test Director and Mainframes systems.

Confidential (Overland Park, KS) 01/2001 11/2005
Role: QA / BA Analyst
Sprint PCS Customer Care (ITAD) PRT and ITM
ITM & PRT are primarily responsible for testing applications that are designed and developed for Sprint’s customer care advocates to handle A/C billing and maintenance for Sprint’s PCS division. Applications vary from Clarify (CRM), Siebel, Java, JSP, .NET and ASP based applications.
Test Lead for CRM-based modules. Assisted in the design of the GUI and requirements gathering. Organized User Acceptance Test infrastructure, including test case design, test management logistics and trouble tracking.
Functional Test responsibilities:

• Developing Test and Defect Status Reports, Test Case Design, Test Automation and Test Execution for a system development life cycle.
• Created test data to validate test cases using P2K CONVERGYS database and AMDOCS ENSEMBLE database for 2G and 3G accounts.
• Was involved in system testing for the data migration from CONVERGYS to AMDOCS ENSEMBLE database
• Performed Regression, Merged testing and User Acceptance Testing.
• Was involved in the back end testing of databases using SQL statements and Unix Scripts
• Worked on the Handset testing for all the various applications on 3G CDMA handsets.
• Provisioned handsets and tested for various services(Messaging, Download Content, Ringtones & Wallpapers)
• Tested the usage content of the handsets in the STIC lab.
• Logged Defects using Rational Clear Quest, Silk radar, Remedy and Change Synergy.

Environment:
Clarify (CRM), Siebel (7.7), Java, XML, Voice XML, .NET, ASP and JavaScript, EJB servers Interface with Tuxedo, MQ Series, Convergys Billing system and AMDOCS ENSEMBLE billing system, Silk, TestDirector, WinRunner, Rational Robot, Silk radar, Clear Quest and ARS Remedy.

Education:
Bachelor of Arts