Stanley Mendonza

Phone: 516-***-****

Email: adz998@r.postjobfree.com

SUMMARY

Hands on Quality Assurance Specialist with over 15+ years of experience in manual/automation testing of distributed web, client server, mobile and Real Time embedded applications and GUIs on various browsers across various Domains such as Financial, Media, Logistics, Energy/Gas and Public Sectors. Well versed in building and managing relationships with internal and external stakeholders, setting project priorities, effort estimation, and providing status reports. Specific software testing expertise includes Integration Testing, System Integration Testing, Functionality Testing, ETL/E2E Testing, Sanity Testing, Load/Stress Testing, Performance Testing, Regression Testing and User Acceptance Testing. Well experienced in defining, implementing, and integrating quality principles and quality processes of QA using agile/scrum, spiral and waterfall models. I am self-motivated with strong analytical ability, communication & interpersonal skills and I possess the ability to work either independently, or in a team or as a Team Lead.

Excellent Data Warehouse, Data Migration and Data Lake testing skills. Very strong with SQL/ PLSQL and experienced in conducting backend testing using Oracle Query builder, TOAD, SQL Developer, Embarcadero Rapid SQL and MS SQL Server for data warehousing/data migration projects, running ETL Jobs, verifying Table structures and attributes, data population, business rule & exception validation, backend database testing include validating Stored procs and triggers.

Created and administered functional, integration & regression test suites for various web-based applications, GUI screens/objects and field validation, client/server architecture, database applications including reference data, aggregates and computations.

Developed, executed and enhanced automation test suites using Selenium WebDriver/RC/IDE/Grid, JUnit/TestNG and HP UFT/Vb-Scripting for functional, regression, integration and unit coverage scripted procedures targeting key aspects of multi-tier web-based and distributed applications.

Excellent Analytical skills in analyzing design documents, business requirements, functional specifications, Data Feed specifications, Data Mapping Documents and identifying testable scenarios – both manual and automated.

Experience testing n-tier apps including modified Custom off the Shelf (COTS) apps & SQL Server based Client Relationship Management (CRM) apps including INFOR CRM namely M3, LN and SCI.

Experienced in Portfolio Management, Risk Management, Asset Management & Wealth Management/Private Banking and Investment/Commercial Banking, Fixed Income Securities (Bonds, Cash Equities, Stock Equities, Debentures, Treasuries, Money Markets, etc.), Derivatives (Options, Futures & Forwards, & Swaps), & Credit Derivatives (CDS, CLN, etc.), Asset Backed Securities (ABS), Mortgage-Backed Securities (MBS), & CMO.

Developed and Maintained Test Plans, Test Cases, Use Cases including Testing Approaches & Testing Strategies for front-end/back-end web and Client-Server architecture as well as stand-alone desktop applications and mobile applications.

Defined and developed strategic processes and eliciting requirements for inventorying and mapping data flows, identifying and rationalizing CTQ (critical to quality) data elements, and performing basic and business rule profiling on large data sets spanning multiple products/sectors/regions.

Managed and Mentored Junior & midlevel QA Resources, including overseeing and directing testing activities with testing teams both onshore and offshore.

Created various management / stakeholder reporting metric methodologies and results to measure the Quality of Data including accuracy, consistency and timeliness both in QA as well as in real time production environments.

TECHNICAL SKILLS

Languages

C, C++, SQL, PL/SQL, VB Script, Java, Dot Net Applications, MS Access

Database

MONGO DB, Oracle 19C, Sybase, Gemstone, DB2, MS SQL Server 2012/2016

Operating Systems

DOS, Windows 11, UNIX, Windows server 2019

Testing Tools

HP Application Lifecycle Management (ALM), Jira Test Rail, Rally, Version One, Soap UI, Postman

Test Automation Tools

HP UFT, Selenium, Jira Test Rail, Rally.

Reporting Tools

Business Objects, Cognos, Microstrategy, Actuate Reports, Qlikview, BIRST

ETL Tools

Informatica Power Center, Autonomous DW

EDI Testing Tools

EDISIM Analyzer, Altova XML Spy, Test Data Generator, Ultra edit, Gentran Integration Suite (GIS), N/W protocols TCP/IP, DNS, FTP, SFTP, AS2, ION and Webservices.

Defect Tracking tools

HP ALM, Bugzilla, Rational Clear Quest, Silk Radar, Mantis, Atlassian Jira

Document Repository

SharePoint, Project Web, huddle, SVN, Atlassian Confluence

WORK EXPERIENCE HIGHLIGHTS

INFOR, New York, NY 08/2016 – 07/2023

Sr. Quality Assurance Engineer/Lead

Infor is a global leader in business cloud software products for companies in industry specific markets. Infor builds complete industry suites in the cloud and efficiently deploys technology that puts the user experience first, leverages data science, and integrates easily into existing systems.

As part of the Messaging Integration team, performed EDI transaction testing and xsd schema validations with trading partners both Inbound and Outbound with standardized formats X12, edifact, xml, acknowledgements and rejection codes using mapping specs.

Performed connectivity testing between Server/Client systems with multiple Industry standard communications protocols ( FTP, SFTP, AS2, ION, Platform Service, Webservice, EmailAlertSmtp and EmailSmtp). Also performed REST API testing via Postman Inbound and Outbound.

Worked with different ERP systems namely M3, LN and SCI to connect various business units under infor namely Infor with GTNexus platform to handle Order Collaboration, Shipments, B/L’s, Invoices, Deliveries, Settlements & Account reconciliation.

Engaged in E2E Testing of Product data to Data Lake using Cloud technology such as AWS to connect to Infor’s Cloud suite portal’s ION desk and BIRST. Testing included connectivity, Schema validation, Field/data selection, SQL querying of data objects/records from source to target for integrity, accuracy and completeness both Initial load and subsequent loads.

Experience contributing to full lifecycle deployments with a focus on KPI metrics for reporting, quality, and scalability.

Prepared E2E integration Test plans/Strategies in QA environments and participated in User Acceptance testing in other environments namely Demo, Preprod, Support, RCT.

Reconciled Test Data Quality Issues and Coordinated Functional Testing for Selected Modules like Topside Adjustments, Uploads and Data Gaps.

Extensively used SQL queries via Toad and Rapid SQL to test Reporting UI, Backend database, data verification, ETL joins and process flows, data/format validation and Gap Analysis.

Performed Data Analysis, Accounts Reconciliation and Applications Integration E2E Data verification.

Environment :- DB2, MS SQL Server 2018, AWS, Java, Cloud Suite Portal, PL/SQL, Postman, Linux, BIRST, Sharepoint, MS Excel, UNIX, Ultraedit 32, CoreFTP, ARCESB, Solarwinds SFTP, SecureFX 8, MQ, X12, XML, CSV Reports and Standards

FITCH SOLUTIONS, New York, NY 12/2015 – 05/2016

Sr. Quality Assurance Analyst

Fitch Group is a global leader in financial information services with operations in more than 30 countries. Fitch Group is comprised of Fitch Ratings – a global leader in Credit Ratings and Research. Fitch Solutions – Provider of Credit Market Data, analytical tools and risk services.

Interacted with heads of the Business Units, Product Owners and other project stakeholders to actively manage data sources as well as produce various source to target data quality reports for Bank Financials data, Insurance Financials data, Sovereign Financials data, FDR Corp data and Lloyds Broker data.

Ensure that high quality data is delivered via Fitch Connect web interface from external feeds - Moodys & S&P including product portfolios, Financial Data and ensuring data consistency and flow with upstream systems and/or system Interfaces.

Enhance data quality procedures and deliver Quality metrics and data validation reports required by Product team from FDR Oracle and Mongo Big Data NOSQL Universe via E2E ETL data validation using complex SQL Queries, joins and filter conditions for Financial Portfolio data and Reporting in accordance with applicable business logic.

Performed functional testing to identify various critical points in the application and identified test cases for automation of repeated tests.

Performed data Conversion testing from source to target Database/applications systems as defined in Data Mapping/UI Specs as part of Data transformation prior to loading data in the Initial Load.

Performed data reconciliation as part of UAT testing and exported data to perform data validations via MS Excel.

Created data mapping specs and updated Business rules based on reverse engineering of Critical to quality data points from Downstream MONGO Big Data DB to Upstream ORACLE RDBMS schemas in coordination with product stakeholders.

Environment:- Oracle 11g, SQL, PL/SQL, Atlassian Jira, Confluence, Selenium (WebDriver 2.0), IDE, TestNG, Eclipse, Test Rail, MS Excel, MS Access, UNIX, SQL Developer, mongochef, robomongo, webservice, Adhoc Reporting via Qlikview, Talend ETL, C, C++, Java.

STANDARD & POORS RATINGS SERVICES, New York, NY 12/13 – 11/15

Data Quality Assurance Lead/Associate

S&P Ratings with its 26 offices around the world and a history that dates back more than 150 years, Standard & Poor's Ratings Services provides high-quality market intelligence in the form of credit ratings, research, and thought leadership.

Worked with project stakeholders as well as regional and global representatives to actively manage data sources as well as Data quality metrics for S&P.com disseminated Corporates and Government as well as Structured Finance ratings data. Also included other external content delivery sites for Ratings Services by addressing their data reporting issues and partnering with them to achieve higher data quality and enhanced efficiency.

Enhanced data quality procedures and ongoing maintenance of information quality documentation.

Created RTM (Requirement Traceability Matrix) to map the requirements with test case coverage.

Engaged in E2E ETL and UAT testing and validation of features and enhancements including data on web interface S&P.com and underlying repositories.

Tested various data projects within the repository that sourced over 1.7 million records for reference Data such as BECRS as well as well as validated Business Rules Driven ETL processes from Source to Staging, ODS and Reporting Data Mart.

Identified manual test cases eligible for automation - Smoke testing, functional regression testing and created/designed automation test cases/scripts using Selenium WebDriver, Selenium Grid for parallel test execution using TestNG framework/annotations.

Performed data driven testing to test positive/negative scenarios on selective functionality by enhancing and periodically maintaining/enhancing the test scripts.

Performed periodic Data Quality Checks for different systems procuring data from S&P CORE ratings repository using complex SQL Queries, joins and filter conditions for Data Adjustments in accordance to applicable business rules.

Designed, implemented and execute best practices around Quality Assurance including design and implement data quality metrics and measurements for identified set of information sources;

Participated in Integrated Events Management meetings to discuss reported incidents across different systems and to prioritize Test planning and execution.

Managed 4 offshore testing resources and scheduled periodic meetings to review work assignments and progress.

Environment :- Oracle 11, SQL, PL/SQL, HP ALM, MS Excel, MS Access, MS Powerpoint, UNIX, Webservice, Adhoc Reports via Business Objects & Microstrategy, Qlikview, ALM, Selenium IDE, Selenium WebDriver, Selenium GRID, Java.

SANEF ITS TECHNOLOGIES AMERICA, Port Washington, NY 05/13 – 11/13

Sr. QA Analyst

Sanef ITS Technologies America is among the world’s leading companies providing complete Global Toll systems and solutions integrator which includes Barrier Tolling, Free Flow Tolling, Back office Systems (CRM) and Emergency Call Networks.

Functional and Regression testing of Toll-CRM front office and back office integrated Systems solutions including Account Management, Vehicle and transponder management, financial and payments, Tolling and Statements, Transaction entries and adjustments, Violations, Citations, notifications and correspondence,

Functional and Regression testing of customer facing Web server application after each build which included all the main features as stated under Toll-CRM above.

Extensively used SQL for back-end and E2E testing, including validating store procedures, triggers and jobs, and validating Transaction Management from gantry controllers for Barrier Tolling and Free Flow tolling systems.

Environment :- MS SQL Server 2012, Java, Dot Net, SQL, PL/SQL, Quality Center 10.0, Mantis, Win 7, MS Excel, Sharepoint, Webservice, SOAPUI, HP UFT 11.5, HP ALM (Quality Center), VBScripting.

NYC DEPARTMENT OF BUILDINGS, Broadway, NY 01/12 – 05/13

Sr. Quality Assurance Lead

NYC Department of Buildings Information System (BIS) provided information on a property in all 5 Boroughs of NYC including recorded complaints, violations, actions, applications and inspections and search for Skilled Trades Licensees/General Contractors Search and Registrant Search.

Created test plans, strategies and executed manual test cases for various systems which included e-Submit, e-Filing, Hub Payments, Electric Firm Payments System and Development Hub Sharepoint application in an Agile Scrum environment.

Hands-on experience performing sanity testing, systems integration testing, end to end testing, web services and UAT testing for both frontend UI and backend testing using SQL Server to verify table structures and attributes, including data population and business rules validation.

Created manual and automated test scripts using QC/QTP.

Developed, executed and maintained automated test cases to validate business requirements and system stability.

Validated daily/weekly receivables and remittance file generated by the BIS Mainframe system.

Assigned, coordinated and reviewed work activities of 4 onsite QA resources.

Environment :- Oracle 10g, MS SQL Server 2012, Java, Dot Net, SQL, PL/SQL, Quality Center 10.0, Win 7, MS Excel, MS Project, Sharepoint, UNIX, Webservice, Mainframe, Oracle 10, Toad 11, QTP 11.0, HP ALM.

CNBC, Englewood Cliffs, NJ 09/10 – 12/11

Sr. QA Lead – On Air RTG and Market Data

CNBC is the recognized world leader in business news, providing real-time financial market coverage and business information to more than 340 million homes worldwide, including more than 95 million households in the United States and Canada. The Shows broadcasted include Squawk Box, Squawk on the Street, Fast Money, Mad Money, Kudlow, Closing Bell, Trading the Globe, Money in Motion, Wall Street Journal report and Options Actions.

Hand-on experience verifying backend GDRS (CNBCs Proprietary Global Data Repository Systems) using Toad across CNBC.com applications.

Utilized the Agile Scrum Process and worked out of Sprint Sessions to manage Testing and follow the defect life cycle.

Extensively used Reuters Traders v8.5 to perform Data Analytics, Technial Analysis (Duration), Index watch, Market Watch, and TAS (Time and Sales).

Performed functional/Regression Testing of various Asset Classes during regular trading sessions – Treasuries, Currencies, Stocks, Futures, Indices, Spreads, Fair Value, Equity Derivatives, for Economic and Analytical On Air Broadcasts.

Performed testing of Pre-Market and Post Market sessions including Business Rule validation.

Ensured overall efficiency in a real-time distributed environment and worked in an integrated team that produces business-critical software to meet tight deadlines, to supplement multiple asset classes, business, economic and earnings analytics.

Verified Live Market Data on HD Side Panels, including Charts/Boards/Ticker Related News across different Panels, buckets and sources.

Assigned, coordinated and reviewed QA tasks of 5 offshore QA resources on daily/weekly basis.

Environment :- Oracle 10g, MS SQL Server 2005, Java, Dot Net, Inews 3, Playout Manager, SQL, PL/SQL, Toad 9.5, Quality Center 10.0(Test Director), Win2000/XP/7, MS Excel, MS Project, UNIX, Ultraedit 32, ftp, Webservice, JDK 1.5, Servlet 2.3, EJB 2.0, Weblogic 9.2 MP1, AXIS 1.2, ANT 1.7.0, Log4J v1.2, JAX-RPC 2.0, Eclipse Helious 3.0, Tomcat 6.0.

CABLEVISION, Bethpage, NY 08/2009 – 08/2010

Sr. QA Analyst – Network Management Quality Assurance Group

Cablevision Systems Corporation is a leading telecommunications, media and entertainment company with a portfolio of operations that includes a full suite of advanced digital cable television, voice and high-speed Internet services, digital voice service, valuable local media and programming properties

Provisioned voice services on Modems, including clean up and assisted in trouble shooting device communications using VMware and related environment/configuration issues with Dev Team/Lab Engineers for successful test execution.

Extensively used Soap UI to conduct web Services testing and validated request/response XML’s element/tags.

Extensively used SQL queries via TOAD and SQL Developer for back-end testing by extracting data from Database.

Used TIBCO Iprocess and TIBCO Leaf to test logging, errors, audits and format for Equipment Returns and Static IP and New York 311 accessibility feature regionally based. Also used Vitria Task list to identify issues with provisioning modems and retry tasks or approve tasks upon resolution of issue.

Ran/debugged automated scripts via QTP as part of Regression Testing.

NYK LOGISTICS & MEGA CARRIER, Secaucus, NJ 09/07 – 08/09

Lead QA - MIS / ETL / EDI

Nippon Yusen Kaisha (NYK Line) is a leading global shipping company. Their diverse range of logistics services include warehousing & distribution, freight forwarding, international network solutions, supply chain consulting, and IT solutions.

OSCAR (One System Covers All Regions) is a single integrated IT system used by NYK for their business operations/transactions in different regions such as Oceania, Europe, Asia, Central, South and North American.

Performed E2E testing of ITS-VMF and VENUS Flat file extractions by running ETL jobs and validating/verifying data has been sent and processed by AS400 Legacy system.

Conducted back end CDW (Central Data Warehouse) repository testing of Data migration from Sybase Staging to ODS area, and onward to Oracle Middleware Tables including Exception Handling to various business operations/activities.

Performed testing of Database Table Structures in Oracle, Sybase and SQL Server which included Quality of Data, Data Cleansing, Data Extraction and Transformation Rules against Data Mapping Documents. Extensively used SQL queries via Toad and Rapid SQL to test Reporting UI, Backend database, data verification, ETL joins and workflows, structure/attribute validation and Gap Analysis.

Designed and executed Test cases for Cognos Portal Security as well as created integration test plan for Cognos Reports and Cubes and validated front end data by executing SQL Scripts.

Actively involved in QA of all Outbound Vendor Transaction Messages, Acknowledgement messages (824) from RIBS using GIS (Gentran Integration Suite) 4.3 for verification of XMLs and translation to EDI in accordance to established EDI standards / Paper maps.

Co-ordinated with the Off-Shore and On-site personnel on allocation of tasks until completion.

Validated Test Files using EDISIM Analyser and trouble-shooting errors.

Performed detailed and comparative analysis and verification of the following ANSI/

EDIFACT Customer and Vendor message types

Environment :- Sunopsis/ODI, Informatica, Oracle 10g, Sybase, MS SQL Server 2005, C, C++, Java, Dot Net, SQL, PL/SQL, Toad 9.5, Embarcadero Rapid SQL 7.4.0, Linux, Cognos, SQL Developer, Unix Shell Scripting (Perl), Quality Center 9.0(Test Director), WinNT/XP, MS Excel, MS Project, UNIX, Ultraedit 32, Ipswitch WS_FTP Pro, Hummingbird ftp, HP Servicedesk 4.5, Q Pasa, MQ, Lotus Notes 6.5, X12 Reports and Standards, Sterling Gentran Integration Suite (GIS) 4.3.

BANK OF AMERICA, NY – Basel II Data Warehouse 11/06 – 08/07

Sr. QA Analyst

T-Hub Basel II Initiative

Bank of America - Bank of America’s Basel II infrastructure was designed to be both vertically and horizontally integrate to address business-specific credit and operational risk requirements, and ensure enterprise-wide coverage and consistency of definitions/processes across business lines.

Leveraged the Mapping Spec incorporating the Sources and Targets using the TSS (T-HUB Sourcing and Staging), TDS (THUB Data Store) and TDM (THUB Data Mart) to develop various detailed Testing Strategies.

Worked closely with Business Analysts/Data Analysts to analyze data sources as well as to address any gaps in the functional specifications.

Schedule daily status, weekly status meetings with Onshore and Offshore Team.

Performed SIT (System Integration testing), Regression Testing and (UAT) User Acceptance Testing for different iterations/enhancements to Data Structures, business functionalities, newly added attributes and changes to data mapping specs including verification of Transformation rules changes / Extraction Criterias.

Extensively performed Data Profiling and analyzed the data.

Executed Workflows Manually from the Workflow Manager and analyzed the Workflow log via Monitor.

Executed Autosys Jobs in SIT(System Integrating Testing) environments and UAT environments to validate source and target data.

Validated Reference Data Positions provided by Bloomberg Feeds.

Prepared Daily and Weekly QA Status Report and Defect Metrics.

Performed UAT with business users to get the sign-off.

Environment: Informatics Power Center 7.1.2, Oracle 10g, DB2, SQL, Pl/SQL,SQL LOADER, Toad 9.0,Embarcadero Rapid SQL 7.2, Cognos, Java, C#.net, C++, ASP.net, SQL Developer, Auto SYS, Quality Center 9.0(Test Director),WinNT/XP, MS Access, Excel, Microsoft Project, MS-Visio, UNIX Shell scripting.

THOMSON FINANCIAL, NY 06/06 – 10/06

Sr. QA Engineer

Thomson Financial, the most complete source for integrated information and technology applications in the global financial services industry, is dedicated to driving profitable and measurable performance improvement for its clients.

Project : Thomson One Banker Application (The Research & Analytical Investment Banking Solution).

Manual execution of Scripts related to GUI Testing of new Builds and Releases of Thomson One Banker Modules, Tabs and Menu Functionality coded in Java and dot net applications.

Application Interfaces included various Tabs and Menus for Portfolio Management, Companies Overview, Indices, Mutual funds, Stocks and Bonds, Reports generation, Advance Search Engine Test, Charts, Price History Reports and interactive charts, Performance Overviews, Company Financials, Earnings/Dividends, Peers, Deals and News.

Performed verification of Client Reporting and Revenue Generation from multiple sources like Bloomberg and Reuters including Accounts Maintenance.

Participated in testing of Individual Application Components for both Stand Alone and Web Server based applications.

Tested Billing Functionality to ensure that page visits and requests are being processed accurately.

Environment: Windows NT/XP, Web Logic, Web Services, Oracle 9, Java 1.4, JSP, Servlets, VB.Net, C++, C, Win Runner 8.2, Mercury Interactive Quality Center 9.0, Quick Test Pro 9.0, Load Runner 9.0, Web Test Tracker, MS Visio, Business Objects 6.1, Embarcadero Rapid SQL 7.2.1, Informatica Power Center 7.11, Control-M, UNIX Shell Scripting.

CREDIT SUISSE SECURITIES, NY – Basel II 03/05 – 05/06

Sr. QA ETL Analyst

Basel II Reporting Data Warehouse

FLEET BANK, NY 11/03 –02/05

QA Analyst, Online Banking Project

KUWAIT NATIONAL PETROLEUM COMPANY, KUWAIT 10/91 – 10/03

Systems Analyst / Programmer

EDUCATION:

Professional Diploma in Software Technology and Systems Management, NIIT, India.

MA, Madurai Kamraj University, India - April 2002.

Contact this candidate