SUMMARY

• Insightful Quality Assurance Test Lead with solid experience in software testing, coupled with extensive functional testing & non - functional testing.
• Demonstrated ability in setting up and configuring automation regression tests for various projects across the organization.
• Blends technical expertise with strong interpersonal and analytical skills to create cross-functional partnerships and achieved in providing reliable, value-driven solutions that exceed stakeholder expectations.
• Adroit in optimizing resource utilization and continuous improvements to deliver large-scale testing projects within defined timelines by incorporating Waterfall and Agile Sprint Scrum Methodologies.

PROFESSIONAL EXPERIENCE

Confidential

QA Test Lead, Sr QA Test & Automation Tester

Responsibilities:

• TEE2 framework: Capable to do backend data validation and performance testing between different endpoints of the systems, process (data-agnostic automation for day-over-day changes). The endpoints are Python DALs, DB calls, REST APIs, Excel add-ins and Python add-ins.
• TEE Lite framework: Capable to front end functional and performance testing via Synthetic User Interface Test workflows and performance testing of all browser interactions.
• Led QA juniors for continuous improvement, coordinated testing efforts, test guidance, test monitoring, test control, STLC test cycles, test status, collaborated with development teams and updated QA status to the MIO IT Management periodically.
• Liaised & QA shared resource across multiple business groups projects.
• Led QA on ETL EDW data warehouse, Middle Office/ Risk IT projects & IT infrastructure projects.
• Involved in QA builds, SDLC release migrations, QA & UAT signoffs and user communication on the final production release signoffs. Production support on user reported problems.
• Created test plans, test matrix, traceability matrix and test case based on the functional specifications and requirements.

Sr Quality Assurance consultant

Confidential

Responsibilities:

• Performed manual tests for functional system, integration, smoke, sanity/ regression, white, black, gray box, component, compatibility GUI, database tests and non-functional performance (load, stress, volume tests) & security (penetration, vulnerability, SQL injection, authentication) tests in a high-volume applications, database, data warehouse systems.
• Provided KPIs, feedback and resource allocation status reports to Asst. IT Director and Managers.
• Experienced in testing AWS public cloud native APIs through AWS platform technologies & services (blue/ green builds,
• Performed automation tester role in setting up and configured automation regression tests for various number of projects for Finance, Middle Office & Data Warehouse groups.
• Involved in automation code migrations (for Change Management and Change Requests) to the AQA servers followed by SVN code checkouts and Jenkins code builds.
• Set-up Active Batch jobs for automation jobs that generate regression test results, e-mail them for IT & business users after analyzing the reports (.html/ .csv formats).
• Demoed, documented the AQA projects in the Confluence site for knowledge base.
• Built smoke test automation scripts for numerous web applications across the organization using Python, Selenium web driver, Kafka, Jinja2, Pandas, SQLite automation framework.
• Knowledge in API/ HTTP/ XPath, Cookie, Cache testing using Postman and BDD testing using Gherkin.
• Performed ETL senior-level QA in building the traditional data warehouse (ODS), audits, analytical data marts, extensively tested with complex SQL for mappings, performed data quality checks from the source to the target data marts and final data validations through BI reports. And, achieved DWH job run-time results from 10.5 hrs. to 0.5 hrs. within DWH team.
• Performed load testing using JMeter for database separation when moving Investment team on to the Finance TradeOps database.
• Performed security testing using data driven testing methodology.
• Detected, reported, and tracked defects using JIRA web application.
• Performed BI Reports developer role. Involved in gathering the client’s requirements and performed requirements analysis. Created Business Objects XI Universes (Fund performance and Performance Attribution) and published them on to the BO reporting server and exposed them through web portals
• Generated Business Objects Universe adhoc and Crystal Reports XI reports, Live Office reports and administrated user setups, security setups, BO universe/ reports migration to higher environments.
• Created Impromptu Query Definitions (IQD), Transformer models, and Powerplay Cubes which facilitated visualization for data sources.
• Created CMM Scorecards, Metrics, Metric Types and Groups.
• Involved in Excel macros creation that works with a huge amount of data for Excel reports.
• Dealt with advanced Excel capabilities - formulas, Pivot tables, both V-lookups, H-lookups, and graphs.
• Actively worked with Tableau Report developer team and experienced on backend connections, query builders and Tableau visualization dashboards generation process, published reports on to Tableau Servers and exposed them on SharePoint web portals.
• Actively worked with Database developer team and acquired exposure on SSAS Excel cubes for Performance Attribution models and DaPPR data.
• Worked closely with Finance, Investment business users, trained them and troubleshooted user reported issues.