Summary
Overview
Work History
Education
Skills
Languages
Certification
Timeline
Generic

Sowparnika Mathialagan

Toronto

Summary

Highly accomplished IT professional with 16 years of experience delivering strategic leadership in Quality Engineering and Business Intelligence. Demonstrated capacity to drive substantial enhancements in software quality, testing methodologies, and data-informed decision-making. Specialized in cultivating and leading high-performing teams, establishing comprehensive quality assurance frameworks, and providing impactful BI reporting solutions that elevate business performance.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Technical Lead

Wipro LTD
01.2022 - Current
  • Led a team of Quality engineers to successfully deliver high-quality Angular Grid Reports and Power BI reports sourced from Microsoft Azure cloud for Fraud Analytics and Fraud Performance Management teams.
  • Built automation framework in Python for ETL testing and started with Selenium for the UI automation.
  • Coordinated with cross-department teams like BSA, DEV, QA, DevOps, and Support to ensure seamless end-to-end software delivery process.
  • Maintained all testing documentation (Test Plan, Test Strategy, Test Scripts/Test Data Approach, JTMF(Epic/User Story/Test cases/Test Execution/Defects/Linking/X-ray Reports)
  • Enhanced system performance with thorough code reviews, debugging, and optimization techniques.
  • Streamlined QA processes, significantly reducing testing cycle time by implementing automated testing tools.
  • Maintained close communication with clients throughout project life cycles for accurate progress reporting and prompt issue resolution.
  • Increased stakeholder confidence by presenting detailed QA reports and insights during project review meetings.
  • Monitored resolution of bugs, tested fixes, and helped developers tackle ongoing problems by providing QA perspective.

Technical Lead (ETL QE Lead)

Tech Mahindra
12.2017 - 01.2022
  • Company Overview: Client – Rogers Communications, Canada
  • Working as ETL Test Lead responsible for the requirements analysis, ETL Testing of the flow and the logic for the Data warehouse projects.
  • Have successfully delivered large scale projects like V21 Sequencing Upgrade as part of Data warehouse component and MicroStrategy Decommissioning as part of reporting tool upgrade spanning across 1.5-year executing 6k + test cases.
  • Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
  • Experienced in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
  • Performed database tables testing (both structure and data validations) by understanding the load strategy (Type-1/Type-2) of each table.
  • Analysed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
  • Prepared test data for the successful data load(Initial/Delta) to compare the source and target systems.
  • Understanding the Control-M job dependencies and setting up the environment required for testing.
  • Prepared technical specifications and Source to Target mappings (STM) documents.
  • Testing of cloud-based projects using Microsoft Azure.
  • Created UAT test cases and scenarios based on Use Cases and made sure those UAT test cases meets the business requirements.
  • Expertise in writing Complex SQL Scripts in querying Oracle, SQL Server, Sybase, and Hadoop.
  • Managing and leading a team of 12 members in onshore-offshore delivery model handling multiple projects.
  • Client – Rogers Communications, Canada

Reporting Lead

Markitech/Amyantek
07.2017 - 08.2017
  • Company Overview: Client – Freedom Mobile, Canada
  • Extensively worked in testing of MicroStrategy reports to understand the Campaign Effectiveness, Promo Usage, Promo Status, Promo Benefits and Care Promo Details.
  • Created views for defining the objects required for Promo Detail Display project in Teradata.
  • Worked with Marketing Analyst and Business Architects to understand the usage of reports and document it in BRD.
  • Created test plans and test cases and unit tested report layouts, validated SQL queries, business logic, identifying solution gaps, data flow and on-demand testing of reports.
  • Created SQL scripts to perform database testing and to verify data integrity.
  • Tested different detail, summary reports and on-demand reports developed by BI team.
  • Designed and developed UNIX scripts as part of the ETL process for loading, pulling the data for testing ETL.
  • Worked on reports which had slow performance to improvise the performance.
  • Worked on reports that had missing data, incorrect metric values.
  • Client – Freedom Mobile, Canada

Senior Analyst

Procom
02.2015 - 03.2015
  • Company Overview: Clients – Bell Canada
  • Designed Freeform SQL reports using MicroStrategy Tool and created documents for WN-OSS (Wireless Network Operation Support Systems) team.
  • Investigated and resolved issues out of Unit testing.
  • Gathering of user requirements and source system analysis and establishing mappings between source to target attributes.
  • Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
  • Involved in writing the Test Cases and Test Plans based on Informatica mappings.
  • Executed SQL statements for data validation to check data integrity, error handling, data redundancy, and data consistency.
  • Clients – Bell Canada

BI - QA Analyst

CGI/S.I Systems
07.2014 - 12.2014
  • Company Overview: Clients – Bell Canada
  • The Fonse project involved in understanding the Remote and TV app functionalities, metrics.
  • Imported views created in Impala and made available to the project.
  • Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill Down and Score Cards.
  • Tested complex reports generated by MicroStrategy including Dashboards, Dossiers, Summary Reports, Detailed Reports, Drill Down Reports.
  • Used IBM Cognos Query Studio to test ad hoc reports.
  • Involved in Unit Testing of all reports and packages.
  • Developed complex queries using different data providers in the same report.
  • Testing of Intelligent cubes using view reports and time-triggered schedules.
  • Clients – Bell Canada

Information Technical Analyst

Tata Consultancy Services
07.2008 - 11.2013
  • Company Overview: Clients – Bank of America, Nielsen
  • Hands on experience as a BI Reporting and ETL test lead and managed a team size of 10.
  • Proficient as MicroStrategy Consultant with extensive business intelligence consulting.
  • Worked as Quality Engineering Team Lead for Quality Assurance projects related to ETL testing.
  • Proven hands-on experience with quality assurance practices, including project plan development, test strategy development, test plan development, test case & test data review, and test automation.
  • Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
  • Experienced in writing complex SQL queries for extracting data from multiple tables.
  • Logged and closed issues using JIRA, HP - ALM as a part of Quality Assurance.
  • Created test cases to perform Sanity, Functional, Regression, Database and ETL Testing.
  • Analysed and report on complex data which involves both source and target systems to identify potential gaps in mapping documentation.
  • Worked with Business Analysts to define testing requirements to satisfy the business objectives.
  • Responsible for reporting status ensuring accurate coverage of requirements and business processes.
  • Clients – Bank of America, Nielsen

Education

Bachelor of Engineering -

Thiagarajar College of Engineering
04-2008

Skills

  • Agile methodology
  • Quality assurance (ETL, UI, accessibility)
  • JIRA and HP ALM
  • Microsoft Azure (Databricks, Data Factory, Lake Storage, VM, SQL)
  • Python programming
  • Power BI reporting
  • MicroStrategy consulting
  • QlikView analytics
  • Tableau reporting
  • Informatica ETL

Languages

Tamil
English

Certification

  • Microsoft Azure Fundamentals
  • MicroStrategy Developer V9.3


Timeline

Technical Lead

Wipro LTD
01.2022 - Current

Technical Lead (ETL QE Lead)

Tech Mahindra
12.2017 - 01.2022

Reporting Lead

Markitech/Amyantek
07.2017 - 08.2017

Senior Analyst

Procom
02.2015 - 03.2015

BI - QA Analyst

CGI/S.I Systems
07.2014 - 12.2014

Information Technical Analyst

Tata Consultancy Services
07.2008 - 11.2013

Bachelor of Engineering -

Thiagarajar College of Engineering

Similar Profiles

  • Deanna Williams

    Deanna WilliamsDeanna Williams

    Prior Authorization Configuration Audit SME/Prior Authorization Analyst at Wipro LTDPrior Authorization Configuration Audit SME/Prior Authorization Analyst at Wipro LTD

  • Monika Parida

    Monika ParidaMonika Parida

    Senior Analyst at Wipro LTDSenior Analyst at Wipro LTD

  • Ananya Singh

    Ananya SinghAnanya Singh

    Senior Consultant – Digital Transformation & Change Management at Wipro LtdSenior Consultant – Digital Transformation & Change Management at Wipro Ltd

  • Vinay Negi

    Vinay NegiVinay Negi

    Citrix Administrator L2 at Wipro LtdCitrix Administrator L2 at Wipro Ltd

  • Anisha Bishnoi

    Anisha BishnoiAnisha Bishnoi

    Cashier at Tyndale University CafeteriaCashier at Tyndale University Cafeteria

CREATE PROFILE
Sowparnika Mathialagan