Career Summary: • Over Nine plus years of IT experience in QA testing with extensive Web based, Client/server, WebService, Middleware for Finacial, Banking, Healthcare, Telecom domains. • Experience in creation and execution of Test Plans, Test Scripts and Test Cases using both Manual and Automated testing techniques. • Well Versed with System testing, Integration testing, Performance testing, Functional testing, Regression testing and User Acceptance Testing. • Experienced in analyzing Business Requirements and Specifications. Worked with Development team and Business Analysts to analyze the test scenarios and ensure that test requirements are correct and complete. • Sound knowledge and exposure in working with the various relational databases like PostgreSQl, Oracle, SQL Server etc. • Experience with QA Methodology and QA Validations to ensure the Quality. • Experience in data ware house tools like Informatica and Ascential Datastage Director. • Extensive working knowledge in UNIX/Linux operating systems. • Good knowledge in DBMS and RDBMS concepts for large oracle databases. • Good knowledge in Unix and Shell Scripting • Solid Back-end testing experience in writing and executing SQL Queries. • Worked on Web Services associated with BEA Weblogic servers. • Experience in Automated Tools LISA4.6.7, Win runner 6.x&7.x, QuickTest Pro, TestDirector (6.x,7.x&8.x), Quality Center (8.x, 9.x & 10.x) and Rational ClearQuest, ClearCase, TestManager). • Worked as Quality Center project administrator. • Experience in testing Web Services through XML • Knowledge in Software Development Life Cycle (SDLC) like Waterfall, Agile and RUP. • Strong Communication and Interpersonal skills to maintain effective work relationships with all levels of personnel. Clear Understanding of Business Rules and Ability to work as a part of team. • Ability to interact with all levels of personnel from technical to high level executive management within the information technology and business communities.
Education: • Bachelor Degree in Mathematics • Post Graduate Diploma in Computer Applications.
TDAmeritrade Inc, Omaha, NE Mar 2009 to present Role: Sr.QA tester TD AMERITRADE, Inc., member FINRA/SIPC, TD AMERITRADE Clearing, Inc., member FINRA/SIPC, and thinkorswim, Inc. member FINRA/SIPC/NFA are subsidiaries of TD AMERITRADE Holding Corporation. (NASDAQ: AMTD).TD AMERITRADE Holding Corporation, through its brokerage subsidiaries, provides a dynamic balance of investment products and services that make it the investment firm of choice for millions of retail investor and independent registered investment advisor (RIA) clients. Responsibilities • Responsible for creating Test plans, designing test harnesses and test cases, and executing the test cases. • Performed Web Application and Web Services testing in the Banking and Financial Domain. • Performed Smoke test, System test, Functional, Integration, End to End, User Acceptance testing and Regression testing activities in Test environment and Production support environment. • Created bank setup for the bank account and performed Electronic (ACH), Wire, and Check transfers, deposits via Web app and Back Office System, and verified those transactions in the down stream systems like BOS, AOM, and in the back-end database. • Placed orders for Stocks, Options, Complex Options; Mutual fund and validated the end to end flow of the orders as per Business requirements, Functional Requirements in Front-end, Application servers(Websphere), Middleware Weblogic (Tuxedo) Request, Responses, Web Services (SOA) and Back-end data base. • Performed Services testing using the JMX-console. • Extensively used LISA middleware testing tool to test JAVA middleware applications. • Extensively worked on creating the XML's for DDS testing. • Built effective test data covering all possible scenarios and added in datasheets for LISA Testing. • Executed the Lisa scripts by using ITR option which is incorporated in Lisa. • Created datasheets for Services like DDS, OMS, COT, MDMS and OSI testing, executed the LISA Scripts, and validated responses by writing SQL queries with AOM database (Oracle), OMS (Oracle), EDOCs db (PostgreSQL), MDMS db (SQL Server 2005) and validated data in AOM Broker GUI. • Executed backend data-driven test efforts with a focus on data transformations between various systems and a data warehouse. • Responsible for testing all new and existing ETL data warehouse components. • Experienced at testing ETL's and flat file data transfers without relying on a GUI layer. • Performed validation and verification for Wireframes for tax documents as per requirements and Annotations for Spanish and English Version. • Test Management tool --Quality Center 10.0 is used to prepare test cases, for test execution and to extract testing status and Defect tracking. • As a Team player worked very closely with other data warehouse testers and with development team. • Have experience in validating the business transformations by writing complex SQL queries. Built the SQL logic in the LISA tool for automating the test efforts. • By using Exstream server was able to convert the raw XML into the readable PDFs. Validated BOS PDFs to created online PDFs, Manifest files, and AFP files for Tax forms which are 1099C, 1099R, 1099Q, Consolidated 1099, Publication (911, 1220,1187), 2439, 1042S,480.6A and 480.6B. • Validated the server logs for Exstream server errors which are running on UNIX boxes by using Putty. • Coordinated with the Back Office system team i.e. BOS QA team to generate the XML's based upon the account criteria. • Communicated with Manager, Team lead daily for testing efforts and sent Status Reports as needed like Daily and Weekly. • Responsible to tactfully communicate with project managers, development managers, release managers and developers to ensure comprehensive test planning and execution.
Tools & Technologies : Oracle Database10g, SQL Server 2005, PostgreSQLv8.3, Cache, Quality Center 10.0, IBM Rational Clear Case(v184.108.40.206), XP Professional, UNIX, Putty, Extream Server, Tuxedo, WebLogic, WebSphere, DbVisualizer v6.5.9, WinSQL, TOAD v8.0, Informatica v7.0, IE, LISA 4.6.4, XML, JAVA, JDBC, Jboss, EJB, Servlets, JavaBeans, Outlook, & MS Communicator.
VerizonBusiness, Ashburn, VA Feb 2007 to Feb 2009 Role: Sr.QA Tester Responsibilities • Written Test plans, Test cases, executed Test cases for SQL/backend test and tracked defects in Quality Center based on the Business Requirements, Functional Requirements, Business Workflows, A&D documents and ICD documents. • Participated in BREQ meetings and FREQ meetings to keep track of new requirements from the project. • Reviewed the A&D documents with Tech lead, Database Developers and Test team for better understanding of the requirements. • Performed System Testing, Integration System test (IST), End to End (E2E), D2D Test, Environment Shakeout test, Implementation Shakeout test, regression testing, UAT test and Production test per the needs of the application and record Issues / Defects and track in Quality Center. • Participated in End to End testing flowing orders from Order entry to Billing • Validated out going XML messages • Validated flat files coming from downstream systems and mocked up feed files by using vi editor. • Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins used TOAD and SQL Developer • Performed Backend/SQL Test for Insert, Update, and Functions. • Ran main frame JCL jobs to collect the data from Main frame systems and load them into Oracle Tables. • Participated in business requirements reviews and software system (application) designs for testability. • Immediate notification / escalation of issues to the Management. • Coordinated the Onsite and Offshore teams to resolve issues. • Track and report upon testing activities, including the test case execution stage, defect status if any defects opened during execution and the testing results status. • Ensuring content and structure of all the testing artifacts are documented in SharePoint Tool. • Tested the data extraction procedures designed to extract data into flat feed files. • Connected remotely to UNIX servers using PUTTY and FTP files across different test environments by using Hummingbird and Command prompt. • Ran the batch jobs using client component Ascential Datastage Director for validates jobs, schedules jobs, runs jobs and monitors jobs. • Executed the UNIX shell scripts that invoked SQL loader to load data into tables. • Generated Reports in Front end and validated Reports in Backend to ensure data integrity and validate Business rules. • Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage in the Mercury Quality Center. • Clearly communicated defects with developers and updated comments in Mercury Quality center. • Executed the regression test cases along with testing new enhancements by using QTP and analyzed results. • Reviewed Error log files in UNIX box when order fails to load into SQL tables.
Environment: Windows 2000/XP, Oracle 9.i, 10g, Outlook, UNIX, Humming Bird, Putty, TOAD, SQL Developer, XML, Quality Center 9.2 IE 6.0, 7.x, JAVA, Web Services, JCL, COBOL, DB2. Ascential Datastage
Kaiser Permanente, Silver Spring, MD Nov '04 to Jan 2007 Role: Sr. QA Tester Kaiser Foundation Health Plan, Inc. (KFHP). Kaiser Permanente consists of KFHP and Kaiser Foundation Hospitals (both nonprofit, public benefit corporations), and the Permanente Medical Groups (for-profit corporations and partnerships). Kaiser Permanente is America's largest nonprofit health plan, serving more than 8 million members in 9 states and the District of Columbia. I have involved on various web based projects in Kaiser which were GE Centricity RIS_IC (Imagecast), EPIC (HealthConnect), Surgical Informational System (SIS), Hospitalist and Inpatient Tracking System (HITS), HITS-PDA, CACTUS, Mammography Reporting System (MRS), MACESS, J-Point, KRONOS, included here during two years period. Responsibilities: • Written Quality Test Plan based on the Business Plan, Qualified Idea phase, Concept Phase, Definition phase and Development Phase and Plan, Test Strategy, Business Requirements, Solution Design, and Interface Design Documents. • Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions. Executed test cases from Quality Center. • Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage in the Mercury Quality Center. • Extracted Patient data from Server into flat file and imported to Oracle DB. • Loaded data into Oracle using SQL loader and validated data • Written SQL Queries and executed them using TOAD and SQL Editor. • Performed Shakedown test, System test, Workflow Integration Test, ser Acceptance testing and Regression testing activities in Test environment and Production support environment • Facilitated UAT (Business partners) in the areas of test planning and defect mitigation. • Attended application walk-through and reviewed Requirements to understand the scope of the project and Attended project meetings as needed and Coordinated with the Developers to resolve the issues/defects. • Written shell scripts to invoke the SQL Loader to load the data into oracle DB from flat files using control files. • Tested and validated HIPPA compliance requirements in the application. • Developed automated Test Scripts in QTP using VBScript for Regression Testing. • Uploaded Requirements and Excel Test Cases into Mercury Quality Center. Executed Test scripts from Test Lab manually. • Written, executed Test cases, and documented defects in the Test Director/Quality Center 8.x. • Worked as Quality Center project administrator, customized the project to meet testing needs. • Used Mercury Quality Center for test planning, defect report and executing the test cases. • Tested application when DB upgraded to Oracle 9i from Oracle 220.127.116.11 • Performed Interface testing for KMATE data (TMS, RIS and MPM) in the MRS via Integration Broker (IB) and validated data provided by all three systems was stored in the MRS SQL database. • Performed Back end testing by writing SQL statements using SQL Plus and TOAD. • Ran ETL jobs using Ascential Datastage. • Verified logs after running ETL jobs. • Involved in System Testing, Regression Testing and Integration Testing. • Participated in requirements walkthroughs with users to get better understanding. • Used Rational Clear Quest for bug tracking and followed up with development team to verify bug fixes, and update bug status for third party application. • Environment: Windows2000 pro, MS/Office, Crystal Reports, IE, Attachmate for access to non-Imagecast applications(Mainframe), MS IIS, DBMS platform-MS SQL-2000, Wintel Server, Citrix Server, ConnectR, IntegrationBroker (IB), GE Centricity RIC-IC, ASP, XML, JAVA, C++, UNIX, Ascential Datastage, HTML, KMATE Cache, KPHC, Crystal Reports, Zebra Label printer, Right Fax system, MRS, MS Project and Quality Center, Test Manager, ClearQuest.
Project: TD Ameritrade, Columbia, MD Sep '02 to Oct '04 Role: QA Tester Ameritrade Holding Corporation has a more than 30-year history of providing investment services to self-directed individuals through its brokerage subsidiaries. I have involved multiple projects. Those are UNIFIED, Advanced Analyzer, Exchange Agreements and Subscriptions, RepTAL, Maintenance, CRs (Change Request), IVR and CTI and SPR (Small projects). Responsibilities: • Developed the Test Plan based on the Business requirement doc, Design and Analysis doc, Business workflows, Configuration Specifications doc, Vendor system and Subject Matters experts. • Developed and Executed the Test Cases for various scenarios based on requirements. • Viewed errors in App server Log files using Exceed (Hummingbird) and discussed with the appropriate persons. • Responsible to test major modules includes Place a trade, Review orders, Quotes, Real-time Balances, Positions, transactions and Mkt info and Verified, validated and executed • Verified data in BOS (Back Office System) and AOM Broker Application Tool Bar. • Tested in IVR and Wireless as part of the TAL vs. RepTAL changes. • Performed Backend testing and migration from SpeakEasy SQL Server to IVRPROD Oracle database • Used Toad and Win SQL to validate the data in Database • For Subscriptions, created different types of Bundles and verified Bundles in BOSweb. Run the Routines in UNIX box (TNVTPlus) and verified reports in appropriated servers. • Using ud32, created script and modified script, verified Tuxedo Compiler Upgrade for services. • Verified RT quotes, Delayed quotes, intra-day Charts, EOD Charts, Analyzed, Watch lists, Indicators, Portfolio and etc using Advanced Analyzer tool. • Verified Request and Respond Data in Tuxedo Middle ware log files, which were coming from Database and BOS. • Verified Data with the Toad Interface tool running SQL queries in the Data Base (Oracle8i & 9i). • Tested SPR (Small projects) like CRs, HD tickets, Remedy tickets. • Participated in Functional, Integration, Beta, Regression, System testing and end -to-end testing. • Automated the test process by developing scripts using QuickTest Pro 6.5 as per test cases and Executed automation scripts using QuickTest Pro 6.5 application. • Verified and validated in Production releases. • Communicated with Development, Operations, and Product Management. • Used TestDirector for requirement analysis, scheduling and generating test cases. Defects were tracked, reviewed, analyzed and compared using TestDirector Generated Reports and Documented and Communicated test results on daily bases. • Tested Upgrade from Weblogic 6.1 to Weblogic 8.1. Verified different browsers for rectifying configuration problems for Weblogic Upgrade. Environment: Java, HTML, XML, UML, CGI, Unix, Linux, Weblogic 6.1, 8.0, Apache Servers, BEA Web servers, Oracle 8i&9i, Interface tools. QuickTest Pro 6.5, Test Director 8.0, IVR (Intervoice/Brite), Oracle TAPI, VXML