Sr. Data Tester Resume
Denver, CO
SUMMARY:
- Seasoned professional with a variety of experience in Software Quality Assurance.
- Thorough understanding of all phases of the Software Development Life cycle (SDL).
- Strong technical, database, and system problem solving skills. Ability to work well independently and in team environments.
- Excellent managerial and organizational expertise. Experienced in writing Technical Documentation and performing Black Box, White Box,
- Functional, Interface, Integration, System, Performance and Regression testing. Capacity to multitask and perform well in high pressure dynamic environments.
- Over 19 years of software life cycle experience in Application Software Design, Development,
- Testing and Implementation of various database applications under different environments.
- 17+ years of experience on Oracle and Sybase database.
- 16+ years’ experience in SQL and writing complex queries.
- 15+ years of experience in QA.
- 4+ years of experience on SQL Server database, agile/scrums methodology, QTP, Borland Silk Test experience
- Professional experience in the following industries: financial, healthcare and insurance industry.
- Experience using tools such as Symantec Café, Forte, Test Direct, Win Runner, Rational Rose and System specifications using UML.
- Experience in environments requiring direct customer interaction during specifications, design, and development and testing phases.
- Experience in XPath
- Experience in Windows 95/98, Windows NT, Sun Solaris and UNIX environments.
- Created test cases that emulated everyday functions for online JAVA based application. Recorded test cases from within Test Director using WinRunner. Reduced testing time by 50% with automated test scripts. Done integration testing. Strong knowledge on Automated testing tools like WinRunner, Test director
- Expertise in design and development of web centric Object oriented applications using JAVA (JDK, JFC / Swing, Java Bean, JDBC/ODBC, JSP, JavaScript, HTML, RMI, Servlet), ATG Dynamo Application Server, Dynamo Personalization Server, Dynamo Commerce Server, JHTML, CORBA and Oracle 7.x as back end.
TECHNICAL SKILLS:
Languages: JAVA,J2EE,XML, Jolt, JUnit, Tuxedo, EDI, ASP, COLD FUSION, Java Script, HTML, COBOL, C, C++, FORTRAN, PASCAL, BASIC, GUIDeveloper 2000, Power Builder, Linux, Visual Basic 3.0.
Databases: Sybase 11, MySQL, postgres, Oracle 7.1/8.0, Oracle 11i, DB2, MS - Access 2.0/7.0, SQL server 2008-2014.
Tools/Utilities: Kronos 4.x, Segue/Borland Silk Central, XPath , Planview, Mercury quality center, Test Director, WinRunner, FitNesse, Load Runner, Bugzilla, SQL *Plus, PL/SQL, Forte, Visual Symantec Cafe, X-macs Rational Rose 4.0, UML, Kintana,
Finance Tools : Co nfluence, Fundlinx 7.x, PAM XG 6, Cassiopae, Mortgage loan system, Real Estate System, Operating Trading Freedom, Transfer wire and accounting, Hardware & Web Server IBM compatible PC, S/390, ES/9000 & JRun, DBVisualizer,NES4.0/3.6, Apache Operating Systems, Windows 3.1/NT/95.
PROFESSIONAL EXPERIENCE:
Confidential
Sr. Data Tester
Responsibilities:
- Responsible for QA and production support of a bandwidth optimization tool. The tool provides data on complex network functions including goal setting and tracking, manual and automatic optimization and alignment scoring, of the digital video and DOCSIS high speed data feeds across the RF spectrum. It is used by senior and mid-level management, and network engineers for strategic and resource planning and tracking purposes.
- Built complex queries of the Video Controller data warehouse, validating data across the test, integration and production environments.
- Developed, managed and executed test plans, scripts and schedules in collaboration with the development team and business users to provided end to end validation of the application.
- Provided production support for more than 300 users, helping to resolve application issues and manage system access.
- Used the Pentaho ETL tool to validate data extractions and transformations from multiple MySQL data sources.
- Used the Rally agile planning tool extensively to create test cases and track defects.
Confidential
Data QA
Responsibilities:
- Worked on data migration project for $1.3 billion invoice checked
- Wrote several complex queries to validate the business rules close to 200 queries.
- Set the test strategy & developed the test plans and test cases. Conducted review of test plans with business and Systems areas, they are SQL scripts to validate the data are correctly processed thru ETL.
- Worked with users to collect the changes in the requirements and created change tickets in Rally & allocate time for the team members.
- Worked in Rally for SCM tool, check out, check in, and promote the code from development to production.
Confidential, Denver CO
QA Engineer
Responsibilities:
- Set the test strategy & developed the test plans and test cases. Conducted review of test plans with business and Systems areas, they are SQL scripts to validate the data are correctly processed thru ETL.
- Defined and managed the test tasks and schedule, reported on test status, Represented test with upper management,
- Worked closely with software team on development of business requirements, design reviews, and review and resolution of issues and opportunities.
- Worked with users to collect the changes in the requirements and created change tickets in TFS & allocate time for the team members.
- Worked in TFS for SCM tool, check out, check in, and promote the code from development to production.
- Additionally provided project test status, escalated test issues, coordinated client acceptance testing, Interface and integration testing and End-to-End testing.
- Projects included ETL testing for Microsoft 2012 upgrade, Invoice Report generation for 150 clients and reports generation for Atlanta Team. Our Team is responsible for providers, consumers, and survey data for HealthGrades
Environment : Microsoft SQL server 2008/12/14, TFS, Salesforce, Test director, Power builder, Java, C##, Sun Solaris, Ms-Excel, MS-power point, MS-Access, Omniture, Adobe, HGBI process and Cubes.
Confidential, Denver, CO
Lead QA Analyst
Responsibilities:
- Developed the test plans and test cases for Loss Mitigation Desktop, which is an in-house system to calculate loan modifications for Aurora bank Worked in CEWL, Document tracking, RPM and Loan Modification modules
- Reviewed Business requirements, Functional requirements and Technical Requirements documents.
- Developed, managed and executed test plans, test scripts and testing schedules Worked with business users to test the Fidelity application for end-to-end testing
- Reported Defect and Execution status on a daily and weekly basis
- Worked on Wire Management systems which is an in-house product to load, process and reconcile the wires and book transfer files Involved in testing the WMS web site
Environment : Flex, Java, C++, Sun Solaris, DB Visualizer, Oracle, Mainframe System, Caliber for Requirements tracking, Jira for Defect tracking tool, Silk Test Central, Snag-it, SQL Server 2005
Confidential
Data Analyst
Responsibilities:- Validate data conversion process for the merger of home, auto and umbrella policies into one system with Farmers insurance.
- Develop the test plans and test cases for PL-Flex project. Set the test strategy & develop the test plans and test cases. Conduct review of test plans with business and Systems areas.
- Developed SQL queries conversions from SQL server data thru EDI process and to the end system. Use the Mercury Quality center tool for defect tracking process. Involved in functional testing, Integration testing, regression testing of Web Applications.
- Used Agile/scrums methodology.
Environment : Java, C++, Sun Solaris, DB Visualizer, Oracle, AZ-400,Aldon defect tracking tool, Win SQL, Snag-it, Microsoft SQL server 2005,Ms-Excel, SQL-Server, MS-Access.
Confidential, Denver, CO
Lead System Test Analyst
Responsibilities:- Handled a team for Data conversion process as (Private college 529) Test Lead. 529 Plans are named after Section 529 of the Internal Revenue Code and are administered by state agencies and organizations. 529 plans are tax advantaged investment plan designed to encourage savings for the future higher education expenses of a designated beneficiary.
- Developed the test plans and test cases for private college 529. Set the test strategy & developed the test plans and test cases.
- Conducted review of test plans with business and Systems areas.
- Involved in developing SQL queries conversions from mainframe data to SQL Server. Use the Mercury Quality center tool for defect tracking process.
- Involved in Unit testing, Integration testing, regression testing, stress testing and load testing using different tools for the Power Agent tool and Web sites. Wrote test automation scripts and executed them for regression testing.
Environment: SQL server, QTP,DB Visualizer, SQL- Power builder, Java, Sun Solaris, Sybase, Ms-Excel, MS-power point, MS-Access.
Confidential, Denver, CO
Lead System Test Analyst
Responsibilities:- Set the test strategy & developed the test plans and test cases. Conducted review of test plans with business and Systems areas.
- Defined and managed the test tasks and schedule, reported on test status, Represented test with upper management, I was accountable for coaching less experienced test personnel, cross-training the staff, and handling conflict resolution. I directed test case development, test data build, and test execution.
- Worked closely with software team on development of business requirements, design reviews, and review and resolution of issues and opportunities.
- Worked with users to collect the changes in the requirements and created change tickets in Plan view tool & allocate time for the team members.
- Worked in Quartet tool for SCM tool, check out, check in, and promote the code from development to production.
- Additionally, I was handling a team of 3 and provided project test status, escalated test issues, coordinated client acceptance testing, Interface and integration testing and End-to-End testing.
- Projects included a share price calculations for the third party subscribers of Great-West’s where my team was accountable for the processing of financial provider data
Environment : Oracle 8.X, Toad, Fundlinx, QTP, Mercury quality center PAM, Power builder, Java, C##, Sun Solaris, Sybase, Ms-Excel, MS-power point, MS-Access, Quartet, Cassiope.