SUMMARY:

• Has strong understanding and solid experience in ETL, Business Intelligence and Data Warehouse testing
• Proficient in writing complex SQL queries in both Oracle and SQL Server environments
• Has superior analytical and quantitative skills to perform data analysis, mining, validation, debugging, etc.
• Capable to perform a techno - functional Data Analyst role Has advanced MS Office skills (Excel, Word, Outlook, etc.)
• Developed, published and implemented test plans
• Wrote and executed test cases, test scenarios and scripts in support of business functional requirements
• Created data setup for test cases Analyzed test results, applying validation techniques, to determine compliance with business requirements
• Performed defect analysis to isolate the problem for faster debugging Supported User Acceptance Testing and Production rollouts Reported directly to Managers

TECHNICAL ENVIRONMENT:

Platforms: Windows 10 & lower, Solaris, Novell, HP-UX

Database: Oracle 11g & lower, SQL Server 2008 R2 & lower (T-SQL), MS Access 2007 & lower

Programs: .NET Framework, Java, JavaScript, ASP.NET, Visual C#, VBScript, Visual Basic 6XML, HTML, ASP, Delphi

Applications & Tools: HP ALM 12.0, Atlassian (JIRA, Confluence), Team Foundation Server (TFS), MS Visual Studio 2010, Microsoft Test Manager (MTM), SharePoint 2010, HP Quality Center 9.2, TestDirector 7.6, Test Manager, Remedy, ClearQuest, Rational Robot, SQA Suite Team Test, Informatica PowerCenter 9.5, TOAD 11.6 & lower, SAP Business Objects, Oracle E-Business Suite, Oracle BI Discoverer, SQL Server Reporting Services (SSRS), SSIS, Ab Initio, Crystal Reports, Siebel 7.7 & lower, Siebel CRM, Siebel eMedia, DataStage 7.5.2, MQSeries, EAI, Developer 2000, MS Office, MS Project, Visio, Lotus Notes, Netmeeting, Visual SourceSafe, Serena ChangeMan Version Manager 8.1.1, Serena TeamTrack, Fidelio SPMS, Fidelio MMS, Seaware Cruise Reservation, Quick Checkin, Gangway Control System, Micros POS, Retek/RMS, Dynacomm, Edify/IVR

PROFESSIONAL EXPERIENCE:

Confidential, FL

Senior QA Tester

Responsibilities:

• Lead user acceptance and quality assurance tasks and testing initiatives for the Positive Train Control (PTC) project using a simulator, as well as, for actual field testing
• Report potential anomalies to the entire PTC team (which include the senior management team)
• Train new and junior testers in the team
• Create documentation for all testing tasks and procedures

Environment: Wabtec, HP ALM 12.0, HP UFT, SharePoint 2013, MS Office 2013, MS Lync, WinSCP, SimSimulator, HP Screen Recorder, SnagIt

Confidential, TX

Senior BI/ETL QA

Responsibilities:

• Lead the ETL and Business Intelligence quality assurance tasks and testing initiatives for the following projects:
• Financial Data Warehouse Conversion
• Health Informatics Data Management
• Clinical Trial Management System
• Write complex SQL queries to validate ETL specifications in the multi-layered DWH architecture
• Interpret business rules then convert them to appropriate SQL queries in order to validate
• Formulate and develop test strategies to validate reports generated in Business Objects
• Write stored procedures to automate some validation processes
• Log defects and work closely with developers and data architects to properly debug and resolve all issues found
• Write and publish test summary reports for the entire project team’s perusal (distribution list includes business stakeholders)
• Liaise and collaborate with offshore QA team (i.e.; conduct knowledge transfer sessions, defect triage sessions, etc.)
• Part of the Data Knowledge & Management team which operates using Agile Scrum and Kanban methodologies

Environment: Informatica PowerCenter 9.5, Oracle 11g, SQL Server 2008 R2, SAP Business Objects, HP ALM 12.0, Atlassian (JIRA, Confluence), MS Office 2010 (Outlook, Excel, Word, etc.)iKnowMed Generation 1 and 2 is the source EHR (or EMR) which includes:

Confidential, FL

Senior DW QA Analyst

Responsibilities:

• Lead all data warehouse quality assurance tasks and testing initiatives related to the Oracle-decommission project
• Translate ETL and business rules to complex SQL queries in order to validate data hub’s adherence to business requirements and specifications
• Write complex SQL queries to ensure that the new data hub contains only cleansed data
• Translate the ETL mapping document to SQL queries to validate source to target landing process
• Create SQL queries using the physical data model as guide to validate new tables (e.g. table structure, field constraints, uniqueness, not null, etc.)
• Validate the SSIS package process, for incoming XML vendor feeds containing repair/service orders, to populate Xtime Service Appointments tables
• Validate data extracts from Google Analytics Query results based on various Marketing use cases
• Validate the accuracy of outbound file extracts for ftp to various vendors
• Identify and report all data anomalies in the defect tracker, then work closely with the developers to ensure issues are resolved
• Produce documents related to test procedures, defect findings and test summary reports
• Create necessary QA documentations, which includes the Sign-Off document, before a build is deployed to Production
• Part of the Business Intelligence/ Data Warehouse team which operates using the Scrum Methodology

Environment: SQL Server 2008 R2, Team Foundation Server (TFS), Visual Studio 2010, Microsoft Test Manager (MTM), SharePoint 2010, MS Office 2010 (Outlook, Excel, Word, etc.)

Confidential, FL

Senior EDW QA Analyst

Responsibilities:

• Lead all Enterprise Data Warehouse (EDW) and Business Intelligence (BI)-related quality assurance tasks and testing initiatives on Enrollment and Claims data
• Write complex SQL queries to validate dataset’s adherence to business requirements and data mappings
• Create SQL queries to validate data landing process at various levels of EDW ETL process: from source to target tables, then through to the data mart and on to end-user reports
• Analyze requirements then write equivalent SQL queries to validate SSRS reports
• Validate the actual data mart outputs against the intended outputs
• Identify and report data anomalies, then work closely with the developers to ensure issues are resolved

Environment: SQL Server 2008 R2, JIRA, MS Office 2010 (Outlook, Excel, Word, etc.), Team Foundation Server (TFS), Visual Studio 2010

Confidential, FL

Senior Data QA Analyst

Responsibilities:

• Coordinate, organize and lead EDW and BI-related quality assurance and testing initiatives
• Conduct ETL testing to validate data completeness, data granularity and data aggregations
• Write complex SQL queries to validate dataset’s adherence to business requirements
• Test the ‘Electronic Data Capture’ EDC web application created on the .Net framework
• Define and develop test plans, test strategies, test scenarios and scripts for a complete system integration testing of the entire data delivery process
• Manage defect logs and work closely with the developers to ensure specifications are met
• Produce documents related to test procedures, defect findings and test summary reports
• Report directly to Project Managers and Senior Managers

Environment: SQL Server 2008, MS Office 2007 (Outlook, Excel, Word, etc.), SharePoint 2007, MS Visual Studio 2010 Team Web AccessCerner is the source EMR (or EHR) for all patient-related information (e.g. Diagnosis, Labs, Meds, Tumor Markers). LabVantage Biobank is the tissue repository and Rosetta for sequencing the tissue. Data from scanned PDFs were abstracted into their own EDC web app.

Confidential, FL

Business Planning Senior Analyst Data Specialist

Responsibilities:

• Perform complex data acquisition, data manipulation (mapping and transformation), and data mining within the data warehouse
• Perform business process analysis and work with the Development team to implement new or enhanced functionality
• Perform data cleansing and data reconciliation to preserve data warehouse integrity
• Provide analytical support and generation of complex queries to support business reporting and analyses needs
• Fulfill end-users’ adhoc reporting needs, which includes support for online reporting tools (Oracle Discoverer, Knowledge Manager and Dashboards)
• Perform check-outs/ sign-offs on functional quality of developed or enhanced processes before go-live (this includes UAT for dashboards)
• Provide expertise to implement effective processes to recurring requirements to gain efficiency
• Create and maintain process specifications, process flows and other documentation
• Participate in translating business requirements into functional specifications
• Report directly to project managers and assist with necessary project documentation

Environment: Oracle apps: Procure-to-Pay P2P, Travel & Expense T&E, other financials, PeopleSoft EPM environment, Oracle 11i, SQL Server 2000, MS Access, Oracle Discoverer, Knowledge Manager, Ab Initio, MS Office (Excel, Word, PowerPoint, etc.), SharePoint, Netmeeting, Office Communicator

Confidential, FL

Senior QA Analyst

Responsibilities:

• Tested and maintained the cruise ships’ property, material, guest and crew management application packages. This included the check-in and boarding processes.
• Participated in validating DCL applications’ PCI compliance.
• Created and executed functional, integration/system and regression test plan, cases and scripts.
• Validated data quality (completeness, conformity, consistency, accuracy, duplicates, integrity) as it flows from one application to another, utilizing the .Net framework.
• Identified problems and analyzed issues within the application and reported them to developers for a quick resolution.
• Clearly communicated and documented test status to Managers and other project leads.
• Supported the Business Service Management team, Port and Ship users when they performed the user-acceptance testing and implemented Production roll-outs.

Environment: Fidelio SPMS & MMS, Seaware Reservation, Quick Check-in, Gangway Control System, Micros POS, Mobile Micros, OARS, HP Quality Center 9.2, .NET Messaging, BizTalk, Oracle, TOAD, Crystal Reports, SharePoint, MS Office

Confidential, FL

Data Warehouse QA Analyst

Responsibilities:

• Created Data Quality Point (DQPs) to validate loaded and mapped data between source and target systems.
• Created and executed functional, regression, and performance tests.
• Focused on data quality; identified issues/ problems (completeness, conformity, consistency, accuracy, duplicates, integrity).
• Provided proactive weekly status of issues and progress made during test execution and general application testing.
• Clearly communicated and documented test results.
• Recorded and monitored all defects and their resolution.

Confidential, FL

Senior QA Analyst

Responsibilities:

• Participated in the integration, system and regression testing of the Portal - Release 1 project (for both internal and external users).
• Executed test scripts in Java 2 Platform.
• Conducted interface testing with external apps: Oracle E-business suite (HR, Payroll, Benefits, CRM), Salesforce (CRM), Eprintview and Oracle Web Conferencing.
• Verified and analyzed test results.
• Logged and tracked defects in Sapient ResultSpace.
• Data element-validation on the Oracle HRMS 11i module.

Confidential, FL

Senior QA Analyst

Responsibilities:

• Created System Test Plan based on High-Level Design, Business Requirements and System Requirements documents.
• Developed and wrote test cases and test scripts based on Detailed Design Specifications and other documents provided by the customer.
• Executed test scripts in UNIX/Oracle environments.
• Verified and analyzed test results utilizing testing tools and utilities.
• Documented defects utilizing Remedy incident reporting system.
• Coordinated work activities within the project team.
• Set up test environment, provision tables, executed shell scripts, etc.

Confidential, FL

Senior QA Analyst

Responsibilities:

• Reviewed business requirements and technical specifications to write a comprehensive Test Plan.
• Wrote test cases, test scenarios and scripts in support of business functional requirements and in a reusable state.
• Executed test scripts and analyze test results.
• Reported and tracked defects or issues found during testing.
• Performed defect analysis to isolate the problem for faster debugging.
• Re-tested after implementation of fixes.
• Provided test status and results to the entire project team.
• Led various web testing and client-server testing projects
• Participated in Datamart / Business Objects report testing
• Validated XML-formatted messages in conjunction with ETL testing
• Worked with application programmers to resolve defects identified during test execution.
• Interacted with internal/in-bank users.
• Performed System Integration, Regression and Security Testing.
• Actively participated in Integration/System Tests (IST) and Enterprise Release testing.
• Juggled between projects for timely completion of QA tasks.

Confidential, FL

Senior Siebel QA Analyst/Tester

Responsibilities:

• Developed, published and implemented system test plans for various Siebel CRM implementations.
• Wrote test cases and test scripts based on System Design Specification and Functional Requirement documents.
• Developed, published and implemented functional and system test plan and test cases for Siebel eMedia implementation (an ABC Network project).
• Created data setup for test cases (e.g.: create bookings in Siebel via Sales and Booking Client which interfaces with multi-channel systems such as Accovia/Logibro, Central Reservation, Ticketing).
• Executed test scripts.
• Analyzed test results, applying validation techniques, to determine compliance with business requirements.
• Reported and tracked defects or problems found during testing using Quality Center.
• Performed defect analysis to isolate the problem for faster debugging.
• Re-tested after implementation of fixes.
• Provided test results and feedback to the entire project team.
• Worked closely and cooperatively with developers, business analysts, project managers and other coordinators.
• Interacted with users (e.g. reservation agents).
• Actively supported User Acceptance Testing and Production rollouts.
• Worked on multiple projects and multi-tasked for timely completion of QA tasks.

Confidential, FL

Senior SQA Analyst/Tester

Responsibilities:

• Developed test plans for a B2B web application based on High Level and Detailed Level Requirements document.
• Created test scripts for all new requirements and/or enhancements both for the front-end and backend processes for the B2B web app.
• Handled the entire testing of the B2B web app when it was fully recoded from VB6 to .NET.
• Developed test plans for several warehouse management applications (MOVE, GIFTS).
• Created/modified/updated the warehouse configuration test plans for Optum's MOVE application.
• Executed test scripts.
• Handled the Retek interface testing with WMS and B2B applications. This involved MQSeries testing/verifying the message flow and making sure all data are transmitted successfully.
• Tested the interface between the B2b web app and BridgeGate (translating EDI, CSV and XML files).
• Tested the back-end processes and did heavy data analysis with reference to the Oracle database.
• Verified newly coded reports.
• Dealt directly with the Project Managers, Systems Analysts, Developers, Business Analysts and Configuration Management team and discuss application specs and issues found in the system.
• Worked closely with the Systems Analysts and suggest enhancements in minimizing, if not eliminating, possible flaws in the application.
• Identified issues and log defects using ClearQuest Web.
• Coordinated with and assisted the UAT team.
• Created and maintained QA documentation.
• Tested the front-end design & functionality of the different warehouse applications developed using Oracle forms.

IVR QA Analyst/Tester

Confidential

Responsibilities:

• Created new test plans.
• Modified existing test scenarios.
• Created the data setup; prepared the required test scenarios.
• Modified IVR Order Entry test plans to conform to the IVR-CLiC integration project specifications.
• Executed IVR Order Entry test scripts and verify results on the CLiC application (Siebel interface).
• Executed IVR Order Entry test scripts and verify results on the Dynacomm application (Mainframe interface).
• Discussed and reviewed new specs and enhancements with Business Analysts before they got sent out to higher management and to the development team.
• Dealt directly with Business Analysts and developers, discussed the defects found and/or verified business requirements.
• Identified, logged and tracked defects using ClearQuest web.
• Updated all necessary QA documentations.

Lead QA Analyst/Tester

Confidential

Responsibilities:

• Performed User Acceptance testing on the company's e-retailing website. User Acceptance testing, which involved functionality and regression testing, was done using IE and Netscape browsers, as well as, WebTV.
• Performed automated testing using Rational Robot 2000.
• Created automated test scripts for load testing, inside MS-WAST.
• Conducted performance testing via Rational Site Check.
• Developed test plans and test cases.
• Executed test scripts.
• Performed back-end testing and heavy data analysis with reference to the database residing in SQL Server 2000.
• Day-to-day activity involved testing new codes, revisions and fixes before next day's implementation to Production site.
• Recorded defects and issues inside ClearQuest Web.
• Dealt directly with developers, database managers and content managers to discuss site enhancements and/or defects.
• Supported Customer Service Representatives with their website problems either first-hand experience or via customer complaints.
• Re-created scenario that supported the defect reports.
• Evaluated and recommended web testing tools (i.e.; Rational Robot 2000, e-Tester 5.0, SilkTest 5.0, WinRunner 6.0).
• Created and maintained QA documentation.

Confidential, FL

Programmer/Consultant

Responsibilities:

• Developed programs using Visual Basic 6.0, SQL Server 7.0 and Crystal Reports 7.0, focusing work on the integration of Motorola's accounts into Pinnacle's old accounts, adapting Motorola's Information System reports.
• Programmed and tested customized screens utilizing MS Visual Basic to extract data and conduct data validation according to business rules.
• Handled program enhancements. Program application ranged from users accessing a particular report to customers' feedback reports and all other lease-related reports to which the marketing and management people referred to in assessing the flow of business.
• Participated in the analysis of user needs that involved talking to users, getting feedback/assessment of applications.
• Tested web-interface functionality of billing and customer tracking applications.
• Assisted in writing application system design and requirements outline documents, incorporating possible enhancement to the existing system.
• Wrote the documentation for the different levels of program testing.

Confidential, FL

Analyst/Tester

Responsibilities:

• Developed test plans and ran test cases for the Y2K testing of client/server systems. Test plans were created from reading technical specs (Business Function Matrices, Reports, Cyclical Processes, etc.).
• Reviewed and approved existing test plans.
• Used Sybase Windows ISQL to complete data setup.

Confidential, PA

QA Analyst/Tester

Responsibilities:

• Developed test scripts and tested a time accounting/reconciliation application, both manually and electronically, using SQA Suite-Team Test v5.1.
• Reported all defects of the newly created program and validated programmers' corrections.
• Dealt directly with programmers to discuss process improvements.