SUMMARY:

• End to End Knowledge of project process and methodologies, experience with Waterfall, Scrum, SDLC, ITIL and Agile development methodologies.
• Experience with Agile, and sprint planning activities while factoring in scope, effort, and complexity.
• Work alongside project teams during design and test stages throughout the project life cycle.
• Diversified IT experience including system analysis, writing technical documentation, application development, validation Analyst, Software Quality Assurance Engineer and Tester.
• Experience in Transportation, Finance, Trading, Telecommunication and Health Care Systems.
• Specialized in analyzing the functional requirement and Technical specifications and writing detailed test plans, test cases, test scripts, execution of test scenarios.
• Extensive experience of full life cycle project development, data warehousing, business analysis, and business intelligence tools.
• Excellent written, verbal communication skills and strong analytical/troubleshooting skills.
• Created Quality assurance center of excellence, and testing frameworks to support/meet organization goals.
• Participate in continuous improvement of test processes and methodologies.

PROFESSIONAL EXPERIENCE:

Confidential

CRM QA Lead

Environment: Azure, AWS, JIRA, TOSCA, AD, MS - Dynamics, Agile, SSIS, SQL, Sales Force, SaaS

Responsibilities:

• Prepared resource allocation, and estimate for upcoming releases.
• Created QA program high level test strategy to outline/define scope of 15 Book of records (Internal Applications), and E-CRM scope.
• Work closely with stakeholder/business teams and vendors to provide clear line of sight for upcoming objectives
• Work with product owner, and manage/prepare back log for upcoming sprints.
• Work with product management team to refine/scope/plan product scope, and user stories.
• Tailor technical stories to the attribute we need for Program Increment (PI).
• Tombstone of data loaded into E-CRM via a onetime batch (data migration)
• Auto sys/batch uploads based on scenario approach.
• Worked with cross functional teams, and vendor for code deployments in various env owned by internal, and external teams.
• Maintain existing data migration program with occasional upgrades and enhancements.
• Prepare test env, and test data to support end to end testing including Functional, regression, security, API testing.
• Create/prepare complex SQL queries to validate data for dashboards.
• Provided updates to cross functional team on regular basis.
• Set up Daily meetings to provide updates on project status to dev, business, and internal/external QA teams.
• Generated end to end test scenarios based on data analysis.
• Performed POC using Conformiq, and Tricentis TOSCA script less automation tool.

Confidential

Quality Assurance Analyst (Business Intelligence)

Environment: Tracking Devices (hardware), JIRA, AGILE, SQL, Vertica, Postman, Reports.

Responsibilities:

• Created test plan, test case to validate streaming data from hardware devices to software applications.
• Provided updates daily during scrum standup, and status report was provide at the end at the end of the week.
• Configure the devices to understand the workflow of Point of Interest for courier, and asset tracker.
• Created automation framework using Python to automate ETL process that will trigger cron scripts, and populate fact and dim tables.
• Execute SQL queries to validate the data at the backend.
• Created API using Postman to validate the middle-tier.
• Review streaming snapshots from around the globe from different assets, and resources, verify the accuracy of the data.
• Validate data in Production, and trouble shoot production issues.
• Simulate data from devices and validate the workflow.
• Perform live testing on variety of devices in production environment.
• Review data challenges for testing, and collaborate/assess with cross functional team to improve data quality for better reporting purposes.

Confidential

Quality Assurance Analyst

Environment: TCP/IP, ISDN, Modem, Program Logic Controller (PLC), SCADA, HMI, TFS, SQL, ODBC, Java, AODA

Responsibilities:

• Responsible for hardware and software testing on group of devices (Fare gates, BFTP, LFTP)
• Created regression test suites to cover integration, and end to end workflow.
• Performed testing/validation on deployment/hot fixes prior to Go Live.
• Reviewed/analyzed data in reports.
• Executed sanity test cases on Production environment.
• Updated existing regression packages to meet the new requirements, and code logic.
• Execution of commands at HMI to validate PLC response.
• Tested sensor logic to determine customer entry and exit criteria.
• Identified scenarios for fraudulent activities.
• Generate reports, and validate data for gate transactions, online status, missing shift, transactions details, and revenue by device, ticket sales.
• Review logs for all transactions.
• Worked with 3rd party vendor Scheldt & Bachmann (S&B) during GO live testing.
• Perform Root cause analysis on reported issues.
• Maintain, and updated configuration documentation.
• Tested fare types from Senior, Adults, Students, weekly and monthly passes.
• Performed back-end testing
• Prepared Test Data and performed Positive and Negative testing.
• AODA compliance testing on Computer Aided dispatch was performed.

Confidential

QA Lead/Analyst

Environment: SAAS, service now, ITIL, Configuration Management Database (CMDB), TFS, AODA

Responsibilities:

• Created design documents, and executed manual test cases, and test scripts for functional, system, integration, and regression testing for web application, and mobile apps (service now).
• Participated in sprint planning, provided estimation, and followed processes within Agile Methodologies.
• Worked with scrum team to ensure the clarity of Business/functional requirements.
• Validate the end to end flow of Change advisory Board (CAB) workflow in service now.
• Created test strategy, and test plan for different releases.
• Worked with Project manager on testing timelines, resources and schedules
• Oversight a team of six testers and monitor/assigned tasks.
• Involved in JAD session to understand the scope of work and functions that will be party of release 1, release 2 and release 3.
• Mobile testing performed on all Samsung, and IPhone devices.
• Security testing was performed though a cloud based solution.
• Manually create test data for test coverage to validate business rules, and application functionality.
• Overlook/Managed UAT testing and provided assistance with data creation.
• Analyzed test results and provided daily status, and test summary reports to Project team.
• Performed scenario based testing.

Confidential

Senior Test Lead Business Intelligence

Environment: ETL, Qlik sense, Power BI, Power view, SSRS, Pivot tables, SQL, SQL Server, Cognos, Business Intelligence, Postman

Responsibilities:

• ETL, Full Load, and Incremental Load testing
• Functional and regression testing on existing cubes.
• Coordinate project/testing activities to Team, and 3rd party vendor.
• Prepared test schedules, and execution timelines for multiple projects.
• Provided impact analysis reports on test planning, and execution.
• Participate in JAD session with solutions, planning, finance, Information technology teams.
• Ensure algorithm within reports is accurate.
• Execute back end data driven test with the focus on data transformation between various systems, and data warehouse.
• Draw/create scenarios using specific Measures, and Dimensions to validate data within Finance, Ridership, Revenue, and Sales cubes.
• Execute complex SQL queries to review/analyze data at the backend (Database).
• Created SQL queries and tested data integrity across multiple databases.
• Data from various devices is captured in Data warehouse.
• Understand End to end workflow, and data sharing of 3rd party agencies and vendor to prepare data scenarios.
• Work with Data Analyst/Business intelligence SME to create wireframes, swim lanes, flowchart and star schema.
• Prepared BAT, and UAT testing cycles, provided information and overview on projects during kick off meeting.
• Created and executed API calls using Postman, and compare the API call output with backend via SQL queries.

Confidential

QA Lead/Analyst

Environment: TFS, SQL, XML, API, .NET, Reports, MS SQL Server, CRM, ERP, AODA, Achecker

Responsibilities:

• Created test plan, test cases, traceability matrix, and manage/triage defects.
• Reviewed the Detailed Design Specification (DDS) to in corporate the technical and functional.
• Performed End to end testing during functional and regression phases.
• Managed and manipulated data pertaining to bidding session for all the drivers.
• Troubleshoot data related issues and customize the forms to accept data validation.
• Managed internal and Offshore team resources.
• Worked with Project manager to streamline the business processes for testing.
• Triage the variance with vendor, business and PMO.
• Validated AODA contents using web accessibility checker, JAWS, Achecker.

Confidential

Quality Assurance Analyst

Environment: TFS, SQL, CRM, ERP, MS Visio, Agile, LDAP SOA, AODA, JAWS

Responsibilities:

• Trip Manager Union Pearson application was developed tested and implemented in three releases.
• Prepared Test plan, Test Cases and Test data.
• Worked closely with Business Analyst, Developers, and Lead Architect through Project Life Cycle.
• Modify/updated ITIL change incident management by working with business change management team that were specially designed to effect QA process and methodologies.
• Created traceability matrix functions as per the Functional/Technical Specifications and/or Business Requirements.
• Documenting full business logic coverage through traceability from the Functional Specifications and/or Business Requirements to the UAT scripts.
• Worked with Report developer and end users to generate calculation scenario for testing for track mileage reports based on track usage among Bombardier, CN and Confidential .
• Reviewed and analyzed the data for reporting test cases for scenarios evolving around on time performance (OTP) calculation and service fare guarantee.
• Union Pearson website content adheres to AODA standards and guidelines.
• Logged Defects and assist in resolution process in some instances.
• Tested UP and GO transit website across various browser and mobile devices.

Confidential

Quality Assurance Analyst

Environment: HP Quality Center, Microsoft Dynamics CRM, SOAP, Share point, Oracle, SQL, SAP, Mobile Brokerage, SWIFT, ASP.NET

Responsibilities:

• Performed Business Acceptance testing (BAT) with Confidential Investors Edge and Confidential Wood Gundy Business team.
• Performed Gap analysis on business requirements in planning phase of the project.
• Validate Business requirements and provided feedback to functional & Technical business analyst.
• Prepared Project specific Quality Plan revised and updated for each project phase.
• Developed and Maintained Functional,Regressionand End to End test cases and other test Artifacts like Test data, data validation and test harness.
• Created Test plan and test cases then walkthrough and review the test plan and test cases with Cross Functional Teams.
• Managed test coverage based on risk analysis and coordinated testing with offshore testing team.
• Performed End to End mobile testing on Iphone, Blackberry andAndroidfor Brokerageapplications.
• Interacted with 3rd party vendor to resolve production issue.
• Assigned, reviewed and evaluated the work of off-shore teams.
• Trouble shoot production issue and coordinated with appropriate team players to resolve prod issues in timely manner.
• Ensured end to end, system, functional and regression Test cases were executed throughout the test iteration phases.
• Performed data Conversion testing for English and French Contents.
• Created and Executed Scenarios for Disaster Recovery (DR) Testing.
• Interfaced with developers to resolve technical issues
• Performed data checks on Market watch, Monthly World Market, The Week Ahead, Economic Insights and Index Return Monitor reports.
• Search for Symbol or Company via market watch widget will display the right data set.
• Prioritize variance issues during test execution cycle.
• Detected defects and communicated to the developers using HP Quality Center

Confidential

Business Analyst

Responsibilities:

• Identified, outlined, evaluated and then documented the business requirements.
• Prioritized the business requirements and advised business on the options, risks, and costs versus the benefits.
• Researched current business models to determine if business requirements currently exist within or outside the business.
• Reviewed current practices and procedures, and all available documentation, and solicited client requirements through interviews, workshops, and online questionnaire.
• Identified and communicated relevant test scenarios to the testing team.
• Conducted Joint Applications Development (JAD) sessions with the participation of the users and the stake holders to gather requirements.
• Met regularly with key business personnel in Marketing, Brokers, customer service, Technical Service and the R & D functions to determine business needs.
• Participated in functional tests and helped guide business users through User Acceptance Testing (UAT) of the application.
• Contributed to Use Case sessions to drive out user requirements, using RUP templates
• Conduct dataflow analysis using use cases, dataflow diagrams and activity diagrams
• Coordinated the requirements to various teams regarding interface architecture and technology

Confidential

QA Analyst

Responsibilities:

• Responsible for leading the commission testing phase by defining various scenarios on how the commission will be distributed among Investment Advisor, Estate Planning specialist, Confidential and vendors (for instance Manulife, Canada Life or AIG)
• Performed configuration, network and Integration testing during various scenarios.
• Executed Functional & Regression Test cases
• Worked closely with Claims & SME’s during commission Testing.
• Performed conversion testing to ensure all records on existing database system, CPU tracker has been migrated to Smart Office application.

Confidential

QA Analyst/Lead

Environment: IBM Websphere, JIRA, SQL, DB2, JMETER, QTP, SCRUM, Load Runner, ETL.

Responsibilities:

• Created Test Plans which encompass the business requirements specific to various applications.
• Performed various types of testing including white box, black box, integration, back-end DB validation and system testing as needed.
• Configure and Tested Data sources as per Test Scenarios.
• Tested Acquirer Interface through IBM Websphere Message Broker (MB).
• Performed IVR testing for Oceania Cruises by calling IVR to activate payment accounts for Visa, MC, Maestro UKDM or JCB via Payment Connexion application.
• Validated Transactions as per business scenario from different providers around the world such as Pre-Auth, Void, Settle, Capture etc.
• Simulate connection to perform integration testing with Acquires for all card & payment Types.
• Validated the Response and Request mapping using Log files between Message Broker, Application and Acquirer Logs
• Tested major application migration to ESB (Enterprise Service Bus) starting from Encryption, Payment Processing Services (PPS), Transaction Acceptance Processing Service (TAPS), Merchant Inbound Batching, API, Automated Outbound Batching (AOB), Israel CAL etc.
• Verified Payment Card Industry Data Security Standard (PCIDSS) are covered during a transaction life cycle.
• Created Test Plan, Test Cases and prioritize defects using JIRA.
• Provided gap analysis, risk analysis and scoring analysis on high risk transactions.

Confidential

User Acceptance Tester/Quality Assurance Analyst

Environment: SQL Reporting Services, Tablet PC development, SQL server 2005, HL7

Responsibilities:

• Worked closely with case manager (‘Nurses’) to finalize the User interface design.
• Participated in JAD meeting at Nursing Homes.
• Responsible for handling deployment control guides.
• Created Test cases and Test data.
• Tested Tablet PC to cover data synchronization.
• Conducted test case reviews with Case manager.
• Prioritize defects throughout the testing cycle.
• Provided weekly status updates to Project Manager.
• Review and analyze data imported and exported from HL7.
• Verify the selection criteria and rating is appropriately integrated between CSC and HL7 system.
• Validating the contents of Business Use cases and providing feed back to business analyst.
• Modify the XML data for business rules associate it with HL7 and Compliance application.

Confidential

Quality Assurance Analyst/Manual Tester

Environment: Windows NT, XML, Oracle 10g, TCMS, PR Tracker, Microsoft Visual Source

Responsibilities:

• Created detailed test cases for full requirement coverage/traceability.
• Work closely with business analyst and 3rd party vendor to provide an IT Solution that will manage Laboratory results.
• Creating and updating Test cases as per business requirements.
• Validating the contents of Business Use cases and providing feed back to business analyst.
• Ensure Data is Consistent across Ministries and various systems.
• Perform verification and validation on data which will be extracted from 3rd party applications.
• Participated in high level design walkthrough’s with business team and 3rd party vendor.
• Ensuring Integration and End to End testing will be performed.
• Responsible for testing contents as per user roles.
• Compliance reports are generated based on Algorithm defined by public Health Inspectors.
• Described best suitable scenarios for performance testing.
• Ensure information is extracted as per business rules from Risk Categorization Tool (RCAT)
• Ensure data is imported from Ministry of Environment as per Effective Dates.

Confidential

Quality Assurance Analyst

Environment: Rational Functional Tester, Rational Performance Tester, Rational Rose, Rational Clear Quest, RUP, .NET, WebSphere, HL7, Oracle, PL/SQL, UNIX, TOAD, COGNOS and SQL Server

Responsibilities:

• Managed tasks and defined business requirement with system analysts and developers to provide cost and time effective solutions.
• Tested functionality as well as ensure content has been migrated properly.
• Ensure archived data is written to appropriate data sources as well as archived data deleted from the data source.
• Responsible for creating Star schema for appropriate designs.
• Analyzing the detail and formulating Test Plans and Test Scenarios for functional testing.
• Prepared test input data for positive and negative test cases.
• Created Test plans - Test cases for GUI, Regression and functional testing.
• Created Test scripts Using Rational Functional Tester.
• Responsible for managing and executing Benchmark, Stress and Stability Testing
• Ensured data is synchronized between Tablet PC and Web application,
• Analyze and communicate test results and suggest improvements.
• Defect Reporting & Defect Tracking using Clear Quest
• Created end to end workflow for Confidential t tracking information in HL7 and Client portable application.

Confidential

Quality Assurance Analyst

Environment: Rational Functional Tester, Rational Robot, SQL, JCL, RPG, COBOL, DB2, IMS, TCMS, SPUFFI, QMF, Procedures, Toolkit, MS SQL Server.

Responsibilities:

• Conducted meetings with project teams to understand the application, its dependencies and the environment.
• Set up environment for testing the jobs, scheduling and executing jobs and load databases etc.
• Coordinated with Technical lead in Test planning, execution and scheduling.
• Responsible for validating/executing test cases in Mainframe Environment.
• Analyzing Business, Design documents and Functional Requirements.
• Performed Backend testing using SQL on DB2 Mainframe.
• Confirm new enhancements/functionality will not impact existing functionality and created regression test suite.
• Updated existing automation Test Scripts along with change requests.
• Execute/Verified reports generated by executing COBOL and RPG programs are in SYCN with system design specs.

Confidential

Quality Assurance Engineer

Environment: Rational Functional Tester, Rational Rose, Guidewire

Responsibilities:

• Performed Functional, Integration and End to End testing to identify the defects in the application
• Performed Data Validation and Data Mapping via SQL queries.
• Interacted with Development Teams, Business Team and Project Management in explaining the business and Functional requirements.
• Worked closely with business to identify real time scenario for claims and payment transactions workflows are updated in Guidewire system.
• Ensure cache Functionalities are set up and performed correctly for both portlet and servlet cached based on the security proxy.
• Worked closely with QA lead to assess QA process deficiencies, and provide feedback to improve the QA process.

Confidential

Quality Assurance Engineer

Environment: Guidewire, Tivoli, IAM, Active Directory, UML, AIX, Mainframe (DB2, SQL)

Responsibilities:

• Created Master Test Plan, Test Cases, Test Scripts, and traceability matrix.
• Reported Defects using Clear Quest.
• Reported for creating test data Prepared data for functional, integration, security testing.
• Updated Manual Test cases for Functional and Regression Testing
• Created Test Scripts Using Rational Functional Tester
• Updated the test cases and test Scripts with Business Requirements
• Created Security Strategy and Security Test cases
• Ensure IAM security system and portal application is correctly integrated in WPS 5.1 and AIX environments.
• Verified the end-to-end flow of the data and insurance policies through Webseal and WPS.