SUMMARY:

• IndustryHealthcare, Healthcare Insurance, Financial Services, Banking, Railroad, Automotive, Retail, Cruise Line, Media, Hotel Industry, Telephony, HR, etc.Intuit, Confidential, Confidential, Confidential, Florida Health Care Plans, M2Gen, Confidential, Confidential, Confidential, Confidential, Confidential, Confidential, Confidential HR, etc.
• 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.)
• 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 SKILLS:

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 6,XML, HTML, ASP, DelphiApplications & 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:
• 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.)

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

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.
• Tested the following bank applications (mostly are related to the BankOne Conversion project): Electronic Payment Initiation (In-house and 3rd Party e.g. First American, Barclays), Automated Clearing House (ACH) functions, Middle Market Funds Transfer Log, Swift Message Analysis Reporting, Risk Management Solution, Risk Event Management System

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).
• Datawarehouse/ETL validation: Developed detailed test scenarios and validation criteria to test data processes (e.g. Data Merge Process).
• Validated XML-formatted messages in conjunction with ETL testing.
• 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.

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

Y2K 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.

Confidential

Lead Y2K Analyst

Responsibilities:

• Performed quality assurance testing for a Y2K-compliance project.
• Performed impact analysis.
• Supervised a team of three Junior Programmers revising test scripts, analyzing programs tagged as unaffected by Y2K, picking out undetected bugs, providing solutions and implementing changes.
• Performed testing using Expediter on a mainframe application developed in Cobol II and CICS.
• Developed MS-Excel templates for testers to write their test matrices.
• Developed MS-Word templates for test documentation.

Confidential

Mainframe Programmer/Analyst

Responsibilities:

• Maintained and enhanced IMPACS application system, implemented under OS/390, MVS/ESA, TSO/ISPF, COBOL II and CICS. This system includes Systematics - CASA, which is an online and batch subsystem that processes monetary and non-monetary transactions.
• Designed and developed new programs; modified existing online and batch programs; and standardized JCL and Procs.
• Performed impact analysis.
• Maintenance, development and enhancements were performed on an OS/390 using JCL, VSAM, COBOL II, CICS and Eztrieve.
• Performed both integration and user acceptance testing functions throughout system maintenance and conversions.