Qa Lead System Resume Profile
SUMMARY:
- Over 18 years of IT experience, with 6 years Oracle Application DBA, 8 years dedicated to System Testing and ensuring Software Quality, and 4 years of Tier Production Support. As a Lead Application DBA for AT T Provisioning Systems responsible for DataBase Integrity for every Release during Deployments per Corporate Guidelines.
- Worked with business requirements to define test plans, write test cases and executing them manually and using Automated Tools. Applications worked on have been in IP Provisioning Services, HR and education training which involves order processing, payment, and customer service and Family Welfare. Software tool proficiency includes Automated System Testing Tools Win Runner, Load Runner, PowerBuilder, PL/SQL Oracle, Sybase, Perl and Unix.
- Software: TOAD, Win Runner 7.0, Load Runner, Test Director, QTP, PowerBuilder, Crystal Reports, C, C , Shell, PERL, JAVA, SAS, COGNOS Impromptu, Powerplay, Report Net, Visio, Adobe Photoshop, DreamWeaver
- Operating Systems: Windows Vista, Windows NT/ 95/98, XP, Windows Vista, UNIX, MS-DOS
- Databases: Oracle 7.3/8.0/10/11g/12c, Sybase, Informix, DB2, Ms SQL, Watcom SQL
EXPERIENCE:
ORACLE DBA
Confidential
- Plan, coordinate, and administer database systems, including base definition, structure, documentation, requirements, and operational guidelines for AT T Provisioning Systems.
- Responsible for Reference Data and Schema changes in Development and IT environments for more than 100 projects with 120 developers every release and have DB INTEGRITY with SCME Source Control Management Environment and SVN. Optimize the schema changes with integrity for efficient Environments. Troubleshoots and resolves database, application, and development related problems. Administers all database objects including tables, indexes, views, schemas, packages, and procedures. Recommendations are made to other DBA Teams to apply the Migration scripts in System Testing UAT environments. Responsible for compiling PL/SQL programs and fix ORACLE errors for Development Teams on day to day basis. Responsible for Performance Tuning of SQL scripts using TOAD Optimization Tools. Also responsible for build failures related to INSTAR Database. Knowledge of backup and Recovery, Managing Table Spaces, INDEX Management, Materialized Views, External Tables, Global Temporary Tables, SGA, Shared Pool, Performance Tuning etc.,
QA Lead System Tester
Confidential
As a Lead System Tester for Global Integrated Management Tool GIOM which provides common user portal to AT T Business Services' service-specific order infrastructures Data/IP, FR, ATM, Private Line, Ethernet, Network Based Virtual Private Networks, Network Based Firewalls to facilitate customer centric ordering of both standalone and bundled services. Responsible for System Testing, Inter System Testing IST , User Acceptance Testing UAT executing pertinent Test Plans, Testing of real-time communication using SOAP/XML over HTTP and Unix environment and verification of end to end billing process functionality. Constructing of the high-level assessment plan with the project management team, system engineering team, and the developer team. GIOM NBVPN MPLS comprises VPN Access, Port, PVC, Logical Channel, CPE, Point to Point connectivity, International PVCs connecting different VPNs, VPN configuration, Network Performance Reports, Traffic Classification using various Class of Services CoS Packages.
Confidential
- As a Lead System Tester for IPDepot and CUR Customer Usage Reports responsible for writing and executing Test Cases. Integration Testing and Pair-Wise Testing based on the Requirements for the IP Services to support design, development, and implementation of INSTAR applications and documenting Use Cases. Also responsible for Interface testing for data migration from the upstream systems like Universal Service Request Platform USRP and Clarify to INSTAR. Managed integrating testing process and procedures into their development projects in support of their business
- Responsible for supporting and interacting with Development and System Engineering Group, Capacity Management, Network Care to define, write the Test Plans. Perform general system maintenance and troubleshooting functions - attempt to duplicate problems identify specific problems using system logs various test tools. Also closely work with Customer Care Support before and after every release to do complete Sanity Testing and prepare the Release Notes for their reference material. Create and Monitor the MR Status from System Testing group using Sublime System and Training the Customer Care with the new release features. As a Lead Role in System Testing Group for coordinating the production related problems with Capacity Management, Network Care, System Engineers, and Development Groups. Wrote Guidelines for Sanity testing to verify the checkpoints during software releases. Used Automated Tools Win Runner 7.01 to perform System Testing of Customer Usage Reports. Also used SQL, PL/SQL, Shell scripting to develop tools for system testing. SQL always used to test backend testing and data migration among various interfaces. Wrote test case scripts manually in WinRunner from invoking the application to the exit of the application in Web Testing.
- QA Applications support for the following functional areas - Data maintenance for Customer Premise and Site allocation Access circuit information Access Speed and Bandwidth Provisioning for Private Line, ATM, DSL, and Frame Relay Customers Usage Billing AR, GAR provisioning Component Card Maintenance IPAddress and Primary Domain Assignments IP Address Management, Emerging Service Biller.
- Worked as Data Analyst with Revenue Assurance Department to identify the potential gaps in the Billing Process. Played as SQL Server DBA for creating denormalized database from various databases ESB, INSTAR, CLARIFY, POCITS in SQLServer2000 and created regular monthly feeds to the team for identifying the recovery/contra revenues of IP Services
QA Lead System Tester
Confidential
- As a Lead System Tester for Gemstar application developed test plans based on system requirements to test the entire application from end to end. Documented test cases based on Use Case verifications. Responsible for intensive evaluation of a UNIX-based Database Management System using Oracle database and Oracle tools such as SQL and PL/SQL in a Client/Server environment. Also, responsible for planning, implementation, and testing for Y2K compliance of these projects. Worked with System Engineers, developers, and end users throughout the project life cycle to implement the application.
- The application supports the following functional areas -- student enrollment data maintenance of students, instructors, and customers course and session schedules maintenance register or waitlist students for training sessions generate correspondence training site schedules maintenance registration closeout activities maintenance billing clients security maintenance for the users.
- Responsible for complete Web testing based on the guidelines stipulated by project management and documentation of Use Cases, Test Cases, and Test Plans for the Web applications - Gemstar, Library System, Catalog and Registration, developed in PowerBuilder, Cold Fusion and CGI/Perl. Also created several Shell tools for testing all these applications.
Software Consultant, Confidential
- Actively participated in system testing of Families and Children Tracking System FACTS project for Department of Human and Health Resources, West Virginia State Government. Target platform was PC/HP9000 based Client Server environment running HP-UX and Oracle.
- The system was designed to support the following functional areas - Perform Intake Processing, Assessment, Placement, Investigation, Child Welfare Services. Performed Quality Assurance, Safety Plan, Maintenance of Policy and Procedures.
- Developed test plan based on system requirements to test the entire application end to end. Documented the specifications and reported the discrepancies. SQL syntax from datawindows and procedures was tested using Database Administration painter after entering test data. End user problems were recognized and Error Tracking Reports were developed for the developers. Early in the project participated in Development for 4 months.
Programmer Analyst
Confidential
System tested a scientific application developed in Power Builder 4.0, which reported the quantity of pollutants in the environment under investigation. This may become the model for the US Department of Agriculture and many Government Scientific Projects to generate reports on a regular basis. Developed test cases based on system requirements in order to test the entire application end to end. Documented and reported when the software was not according to the requirements.
Programmer Analyst
Confidential
- Involved in designing and system testing of a Client/Server Architecture for Sales Analysis Application. Reports involving monitoring of the inventory, sales details, and shipping details. Also, involved in testing Accounts Payable Application and Credit Application for the same company. This application allowed users to enter and change accounts, print invoices and checks, and to enter memos for credit requests, approvals and rejections.
- Involved in designing, developing, and testing an application for a restaurant delivery service. Customer, Restaurants, Menu, Orders, Order Details, and other detailed information were stored in database. Reports were generated for Orders, Sales by Date, Sales by Month, Sales Summaries, Invoices and customer mailing labels using queries on different tables.
- Designed, developed and tested Unit, Integration, System an extensive interactive hospital management application. The application was developed for a group of Hospitals. Several screens to be used by administrative staff in different situations were tested. The application provided several views such as the doctors in each facility, state, and hospital and lists such as daily appointments, clinical tests and patient enrollments.