PROFESSIONAL SUMMARY:

• Dedicated professional with 9+ years of experience in Software testing and 3+ years in Utilities (Electricity) industry. Specialized in end to end functional/system testing. Worked in several large - scale projects within Energy Procurement management. Knowledge in ISO operations, contract management and settlements in addition to expertise in Endur, MCG and Versify (Bidding and scheduling, outage management) COTS products. Worked in IT sector in Utilities (Electricity) industry, Healthcare and Satellite TV domain.
• Experience in testing complex systems including COTS products in Electricity Utilities Industry.
• Knowledge in Energy Procurement business & ISO Markets. Market Operations - Bidding, scheduling, outage management, tagging. Contract management and settlements. ETRM - Energy Trading and Risk Management.
• Good knowledge of Endur product for Front, mid and back-office functions including Formulae engine.
• Good knowledge of MCG and Versify used for bidding and scheduling into ISO market and outage management.
• Hard-working, result oriented individual with an ability to work with aggressive timelines and deliverables.
• Experience withdifferentSDLC methodologies (Waterfall, Agile/SCRUM).
• Performed manual testing, sanity testing, Pre-Integration testing, Integration testing, Functional testing, System Testing, Regression Testing, Performance testing, alpha testing, and Black Box testing in various projects.
• Experience in Software Quality Assurance, test plan, test strategy, test matrix and test results documentation.
• Experience in analysis of User/Business Requirements, Design documents, Release documentation, Functional Requirement and Feature Requirement documentation.
• Collaborate with diverse stakeholders including product vendors, project team members (onsite and offshore) for delivery and support activities.
• Experience working with various business users during requirement gathering, test plan and system test scenarios approvals and UAT support. Provided demos to users after every sprint cycle.
• Experience in creating documentation for Knowledge transfer sessions to MSP team as part of service transition.
• Experience with data validation / data analysis using SQL (Oracle, Snowflake)

TECHNICAL SKILLS:

SDLC Methodologies: - Waterfall, Agile

Management Tools: - Octane, HP-ALM, QTP, JIRA

Database: - SQL, Oracle, Hadoop, Snowflake

Cloud Technologies: - MS Azure

ETL: - Datastage & Reporting - Power BI

PROFESSIONAL EXPERIENCE:

Test Lead, QA Analyst

Confidential

Responsibilities:

• End- to-End functional testing reflecting day in a life of trading life cycle (deal entry, confirm, price fixing and EOD operations)
• End- to-End functional reflecting month in a life of Contract life cycle (Contract entry, Settlement desktop, Accounting desktop).

Test Lead, QA Analyst

Confidential

Responsibilities:

• Endur functional lead responsible for creating and executing functional scenarios to test different deal types (Power, gas, emissions, capacity -physical and financial deals).
• Creation of test data in Endur and validation of data in snowflake for deal header, deal schedule and deal payments. Validation of renewable/tolls and conventional payments (including prior period adjustments-PPA).
• Validation of around 166 Endur tables/views from source to raw and raw to core in snowflake.
• Data validation between on-premises system vs Snowflake cloud data using Python code.
• Usage of time travel to check older data on cloud. Scale out and scale in based on data volume using SQL queries.
• DQ (Data Quality- null, merge, duplicates, mismatch records) Level checks on Snowflake data
• Validation deal headers, deal schedule and deal payments from raw layer to core in snowflake using transformation and business logics. Validation of effective dating of records in snowflake core.
• Validations on views and tables of Snowflake based on role based security (CPE/Non-CPE contracts).
• Conducted demo for business users for system test results after every Sprint.
• Attended daily scrum calls with project team, test planning and system testing execution, worked with development team for bug fixes, co-ordinate with offshore test team, retesting after fix and documentation of test case execution and test results in octane.
• CPE Phase 2 and 3: Creation of counterparty, contract, deals
• SOD testing and Validation of Reports with CPE changes
• Validating eDMRM integration for CPE settlement invoices.
• Testing of RA tracker automation for CPE contracts, Deal Automation for CPE contracts, Energy exercise dashboard with CPE user security.
• Integration testing between Endur and MDM when contract attributes are changed in Endur
• Verified functionality for various roles including Endur Super User like contract meter relationship, attribute update and Formulae Engine.
• Attended daily scrum calls with project team, test planning and system testing execution, worked with development team for bug fixes, co-ordinate with offshore test team, retesting after fix and documentation of test case execution and test results in octane.
• Created test scenarios/test plan and executed test cases to validate emission calculation for various types of resources.
• Emission calculation for UOG,ACS/ Imports (actual, bookout, trading volumes), Toll/CHP (default and parameterize value), GTS: Emission calculation for UOG, ACS, Imports, Toll/CHP, and Reports.
• Validated Power BI dashboard that displays actual and forecasted emissions.
• Attended daily scrum calls with project team, test planning and system testing execution, worked with development team for bug fixes, co-ordinate with offshore test team, retesting after fix and documentation of test case execution and test results in octane.
• Created test scenarios/test plan and executed various functional test cases. Below are some key functionalities
• Front Office: Auto Deals creation
• Contract management: Energy Storage Exercise-Full exercise, Partial exercise. Party Agreement Automation interface
• Mid Office: Confirmations: Power and Gas, Daily margin, DB Views, MTM workflow
• Compliance Programs: Scheduled Maintenance, Forced Outage, Curtailments, MAE, all tabs
• Settlements - workflow process from the accrual process for all deal types, workflow status to finalize and generate invoice, PPA events validations of volume and price, Formulae Engine.
• Accounting - Accruals, Actuals rules, full and partial processing
• Integration: Interfaces like Meter, Prices, Vendor ID, FE workflow, ISO Billables, Cash applied, Accruals, Actuals, IID interface,
• BAV report for energy contracts, expected energy, contract Load, available capacity etc.
• CAISO NQC interface - functionality for PWR RA, Placeholder, Tolling, Zero out, Proration, Email Notification.
• Attended daily scrum calls with project team, test planning and system testing execution, worked with development team for bug fixes, co-ordinate with offshore test team, retesting after fix and documentation of test case execution and test results in octane.
• Lead/Supported UAT sessions with different stakeholders for review and approval of test results.
• Validating if Talend job is rendering the same data with precision in terms of number of records, counts and total sum such as that of the Data stage jobs.
• Recording the performance of each job using stop clock method and creation of performance matrix.
• Worked with users during UAT sessions by providing a demo of the system test results and supported in test data setup for users.

Confidential

Responsibilities:

• Work closely with vendor and users in reviewing the business requirements and design documents for preparing test cases.
• Developed Test plan, test strategy, test scenario, test cases and test steps for MCG and Versify applications.
• Responsible for systems and interface testing
• MCG: Validation of modules including resource management, planning and forecast, bidding, and scheduling, bid entry and bid submission into CAISO markets, bid status and CAISO validation, inter-tie wizard, web services task queue viewer, market services task queue viewer, interface testing and MCG reports and Reports -CMRI reports, Oasis reports, s and prices used for storing informational data from CAISO CMRI and CAISO Oasis.
• Versify Application: Validation of different modules including day-ahead outage, real-time outage planning, creation of outage tickets and outage entry, outage workflow screens, outage dashboards and outage reports.
• As a lead role from Infosys and co-inodiated with offshore team to meet all the deadlines and deliverables worked with offshore team to coordinate system test execution.
• This project gave firsthand experience in understanding the end-to-end IT processes followed by Confidential .
• Participated in defect triage reviews with vendors and client for tracking issues to closure.
• Obtained both functional/domain knowledge in the Casio market operations and trading. Involved in leading the testing efforts from Infosys, by working closely with vendors and users (real-time operations and day ahead traders) from the inception to closure of the project.

Associate Bus Process/UAT Analyst

Confidential

Responsibilities:

• Responsible for end-to-end business process activities - creating, controlling and improving business processes.
• Responsible for testing the systems/applications impacted by business process changes.
• Developed test plans, test scenarios and cases for testing claims system.
• Conducted smoke and regression testing for applications to ensure no impact to existing functionality due to enhancements.
• Conducted/Supported relevant testing (e.g., pre-production; user acceptance; post-production) to validate processes are working as designed
• Participated in entire testing lifecycle, including test planning, test preparation, test execution and defect management.

QA Engineer

Confidential

Responsibilities:

• Tested specialized set-top box features and interactive apps tailored to different Latin American markets
• Performed extensive testing for embedded middleware components concerning NVRAM, Modem, Satellite Software Download, Satellite Expansion, Data Port, SHEF, PPV, BBVOD, ITV Apps, SHEF, Bit stream Modulator and PC to Set-top Box Serial Port Commands.
• Worked on quick, smoke, full regression, functionality, user interface testing as well as bug reproduction. Managed and maintained bugs in JIRA while communicating bug severity to development teams
• Performed Remote Stress Rack Testing on Sky Brazil, Sky Mexico and Pan Americana platforms on stress racks and VPL. Used automated Bash scripts for executing daily testing activities on stress racks.
• Participated in entire testing lifecycle, including test planning, test preparation, test execution and defect management.

PACE Americas

Confidential

Responsibilities:

• Involved in Bitstream, Phase 1, phase 2, Phase 3 and Phase 4of HR 44 testing life cycle.
• Performed the interactive Sanity test for all new versions of middleware software to ensure functionality is as expected. Quick, Unit, Integration, Beta, and full Regression testing on various released versions of the software installed on the HR 444 and processed the installation of Plugins to run the iTV applications.
• Conducted extensive testing with the Set top boxes connected to the Linux OS. Tested software builds with Linux commands, dt commands(built in DirecTv specified) and verified the expected test results.
• Executed daily tests and auto scripts on Set top boxes in Linux environment usingterminal emulator Putty. Gathered and reported data logs as an output from the set top boxes.
• Performed auto stress tests using bash scripts /java scripts on auto stress racks with multiple Set Top Boxesin different platforms like RVU, MRV AND STANDLONE environment. Generated dailyauto stress reports and submitted reports for HR 44 integration team.
• Participated in entire testing lifecycle, including test planning, test preparation, test execution and defect management.