Deepali Wilkhu
Milton,Canada
Summary
With extensive experience in quality engineering, adept in creating effective test strategies and plans. Specializes in ETL and API testing, leveraging SQL for data manipulation to enhance testing processes. Proven success in delivering quality results while leading teams through Agile and Waterfall methodologies.
Overview
17
17
years of professional experience
Work History
Sr Quality Engineer Lead
Aviso Wealth
10.2024 - Current
- Created and executed test cases in end-to-end environment to ensure comprehensive coverage.
- Consume data from various system and verify into Testing Environment.
- Provided transformed data to systems, facilitating accurate verification and analysis.
- Manipulate the Data for testing (Negative Testing) and verify update scenarios.
- Attended daily meetings to review and prioritize software defects for resolution. and Participate in Demos.
- Work on Data Mining using SQL Server.
- Developed and implemented automated test scripts for AIM application using Katalon Studio, enhancing testing efficiency.
- Performed User migration Testing.
Sr Technical Lead
Aristocrat Technologies
09.2017 - 05.2024
- Crea2ng Test Design guidelines, preparing Test Strategy and Test Plans for different test cycles. Also, managing project related resource alloca2on and reviewing the work of team members.
- Providing technical help to the team for resolving their queries and problems.
- Engage in technical assistance in Casino device Live tracking - Beacon support Tes2ng.
- Manage and lead tes2ng team in planning, execu2on, and repor2ng of user acceptance tes2ng ac2vi2es using a combina2on of Agile & waterfall methodologies.
- Deliver quality results within established 2meline, develop forecast methods and metrics.
- Ini2a2ng solu2on discussions with business teams, find and closed gaps in early phase of tes2ng.
- Leading closure of solu2on issues / defects by invi2ng all relevant stakeholders.
- Helping team with hardware environment setup/issues along with so]ware tes2ng.
- Involved in automa2ng API using Ready API.
- Leading the test execu2on to include unit tes2ng, integra2on tes2ng, feature func2onality tes2ng and regression tes2ng.
- Par2cipate in both Internal and External Live Demo with Stakeholders.
Senior Consultant
Virtusa Polaris
10.2014 - 06.2017
- Markets BI is a management Informa2on System for salespersons performance in terms of income generated by them for the Sales. Act as the golden source of some of the sta2c data like the Client Hierarchy, User and team informa2on and client Kering informa2on.
- Smart was conceived as a business intelligence applica2on as such it consumes a no of feeds from various system. It receives an End of day file from GRDM of all CIS codes mapped to the Risk Hierarchy.
- Work on JIRA item assigned during Priori2zing mee2ng.
- Consume data from various system and load into Tes2ng Environment.
- Provide useful data a]er transforma2on to systems.
- Manipulate the Data for tes2ng (Nega2ve Tes2ng).
- Create and Review Peer test cases in QC.
- Amend Stakeholder mee2ng and Par2cipate in Demos.
- Client: Royal Bank of Scotland
Senior Consultant
Royal Bank of Scotland
12.2012 - 05.2014
- Score to SGL revolves around capturing data from different countries across the world such as India, SGP, HK etc. into Score and then processing the trades to get them to post to the ORACLE GL on daily basis. The incoming data gets refined using various accoun2ng rules and valida2on at each stage. Several reports are generated from the GL which are analyzed to fetch the trends and gather important sta2s2cs.
- Liaising with Clients to understand the business requirements.
- Working closely with the stakeholders in understanding the business requirements to define and implement the test processes, strategies and approaches.
- Processing the Data from various Countries up to the Oracle GL incorpora2ng Database Tes2ng.
- Crea2ng test 2melines, the release and crea2ng detailed Run Book and share them with the stakeholders to keep them in sync.
- Suppor2ng UAT Users in processing and issue resolu2on.
- Preparing test cases as per the defects/Requirement raised in JIRA.
- Resolving environment issues faced during End-to-End tes2ng of trade life cycle using Complex SQL Queries & UNIX Commands.
Lead Consultant
Genpact Headstrong Capital Market
11.2011 - 09.2012
- MSSB PWMIT department develops and maintains several front and back-end applica2ons in the pornolio accoun2ng and repor2ng space. Several of these front-end applica2ons such as DQToolkit, EMS front end, Poster, Dremel are cri2cal for opera2ons but are sKill based on outdated VB6 technology. MSSB PWMIT department is looking to remediate this end of life Visual Basic (VB) applica2ons to .NET technology.
- Understanding Requirements and preparing Func2on Specifica2on Document (FSD).
- Preparing Test Scenario and test Cases in QC.
- Executed func2onal test cases for every cycle and performing regression tes2ng.
- Defect logging and tracking done in Quality Centre.
- Individually tested and delivered few releases.
- Involved for produc2on checkouts and release as and when required.
Lead Consultant
Genpact Headstrong Capital Market
11.2009 - 11.2011
- CFS is the proprietary applica2on to create Enterprise wide Data Warehouse, one of its kinds in the industry, which will hold data of back office and middle office system of various asset classes across geographies. This will facilitate different divisions of MF Global to have global and consistent view for repor2ng which will be further used for various strategic and tac2cal decisions. Data Warehouse will be divided into Opera2onal Data Store (ODS) and Reference Data Repository (RDR) to house transac2onal and reference data respec2vely. The project has 42 applica2ons in its scope and scheduled to be completed in 3 years.
- Worked on Informa2ca tools - Repository Manager, Mapping Designer and Workflow Manager and workflow Monitor.
- Extensively used Informa2ca PowerCenter for extrac2ng, transforming and loading databases from rela2onal sources and non-rela2onal sources.
- Monitored the sessions using Workflow Monitor.
- Created test cases for system tes2ng based on func2onal specifica2ons.
- Coordina2ng with Business Analysts for requirements walkthroughs and Business users for Clarifica2on. Following up with development teams for fixing of Defects.
- Defect Logging and tracking done in QC.
- OBIEE reports tes2ng under CFS Vision in Answers to be made available to the End User.
- Code Deployment in SIT environment using TFS and FileZilla for transfer of file.
- Data loading in tes2ng environment.
- Prepared Test Plan and TCR (Test Comple2on Report). Review Peer Test Cases.
- Used Informa2ca Tool for Transforming and Loading Data. Used OBIEE for Report Tes2ng.
Education
Master of Computer Application -
GGSIPU
01-2009
Bachelor's - Computer
GGSIPU
01-2006
Skills
- Windows and ETL testing
- Reports Testing
- ETL Deployments
- UI Testing
- API Testing
- Test case design
- Data manipulation
- SQL database management
- Agile methodologies
- Defect resolution
- Quality inspection techniques
- Process improvement techniques
- Quality engineering tools
Skill Set Tools
- HP Quality Centre 10.0
- Bugzilla v.3.0.4
- Teamprise Explorer v.3.3.0
- Informatica 8.6.1
- OBIEE
- TOAD
- SQL server
- JIRA
- SSMS
- Ready API
- Visual Studio
Domain Knowledge
- Finance Domain - Derivatives and Investment Banking
- Gaming
Personal Information
Title: Senior Technical Lead
Rdbms
- SQL Server 2005/2008
- Oracle
- MySQL
Languages Scripts
- Gherkin Script
- SQL
Timeline
Sr Quality Engineer Lead
Aviso Wealth
10.2024 - Current
Sr Technical Lead
Aristocrat Technologies
09.2017 - 05.2024
Senior Consultant
Virtusa Polaris
10.2014 - 06.2017
Senior Consultant
Royal Bank of Scotland
12.2012 - 05.2014
Lead Consultant
Genpact Headstrong Capital Market
11.2011 - 09.2012
Lead Consultant
Genpact Headstrong Capital Market
11.2009 - 11.2011
Master of Computer Application -
GGSIPU
Bachelor's - Computer
GGSIPU