Dilsher Singh Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

Toronto, Ontario, Canada

Played a critical role in ensuring the accuracy and consistency of the data. My responsibilities included:Project: Global Anti-Money LaunderingETL Validations: Ensured data accuracy and integrity by performing count checks, null checks, and verifying transformation logic, improving data reliability.ETL Testing Automation: Created an advanced ETL verification tool that generated detailed validation reports and constructed efficient queries, reducing manual validation time by… Show more Played a critical role in ensuring the accuracy and consistency of the data. My responsibilities included:Project: Global Anti-Money LaunderingETL Validations: Ensured data accuracy and integrity by performing count checks, null checks, and verifying transformation logic, improving data reliability.ETL Testing Automation: Created an advanced ETL verification tool that generated detailed validation reports and constructed efficient queries, reducing manual validation time by 80% and query execution time by 30%.Analyze Case Statements: Developed a tool to parse queries, extract conditions, and verify data availability for case statements, enhancing data processing accuracy and identifying unmet conditions.Analyzed Requirements: Collaborated with Business Systems Analysts to ensure alignment with requirements, identifying and resolving discrepancies to maintain project integrity. Project: Enterprise Data MaskingMasking Algorithm Design: Created and validated custom Java-based algorithms for data masking, specifically designed for uniform transformation of various data types including numeric and dates, ensuring precise and consistent data handling in the project.Automation & Efficiency: Created Python tools to automate and optimize complex data processing tasks, significantly increasing operational efficiency while reducing manual workload across data management projects. Data Masking: Analyzed and implemented data masking for various formats, ensuring uniform output across joins. Conducted thorough post-masking validations, reinforcing data integrity and project’s coherence goals.My work as a Quality Engineer allowed me to hone my skills in Python, Java, and SQL while also gaining valuable experience in data engineering and ETL workflows. I'm proud to have contributed to the success of TD Bank's data projects and to have gained valuable experience in the finance industry. Show less

Greater Toronto Area

Worked on a range of exciting projects that allowed me to apply my skills in machine learning, data engineering, and software development. My key responsibilities included:Data Cleaning and Preprocessing: Routinely handled data cleansing, preprocessing, and transformation to ensure high-quality datasets for AI system inputs.ETL Pipelines: Specialized in creating compact ETL pipelines for efficient and reliable data extraction, transformation, and loading across various sources… Show more Worked on a range of exciting projects that allowed me to apply my skills in machine learning, data engineering, and software development. My key responsibilities included:Data Cleaning and Preprocessing: Routinely handled data cleansing, preprocessing, and transformation to ensure high-quality datasets for AI system inputs.ETL Pipelines: Specialized in creating compact ETL pipelines for efficient and reliable data extraction, transformation, and loading across various sources and platforms.Data Modeling and Design: Engineered robust data models and schemas, focusing on optimizing data integrity, relationships, and performance for web-based applications.Time Series Forecasting: Utilized advanced time series forecasting techniques to analyze and predict complex data patterns, aiding in insightful data-driven decision-making.Data clustering and Analysis: Applied clustering algorithms and similarity measures for grouping complex data sequences, enhancing pattern recognition and predictive analysis capabilities. Show less

Mangalore Area, India

AI POC initiatives: Actively engaged in AI-based proof-of-concept projects, focusing on clustering techniques to strategize enhanced resolution methodologies for operational tickets.Data Monitoring System Development: Spearheaded the creation of a sophisticated system for preemptive analysis of batch job data volumes, aiming to mitigate potential data overload issues.Developed SQL queries and artifacts to validate the completeness, integrity, and accuracy of data within the ETL… Show more AI POC initiatives: Actively engaged in AI-based proof-of-concept projects, focusing on clustering techniques to strategize enhanced resolution methodologies for operational tickets.Data Monitoring System Development: Spearheaded the creation of a sophisticated system for preemptive analysis of batch job data volumes, aiming to mitigate potential data overload issues.Developed SQL queries and artifacts to validate the completeness, integrity, and accuracy of data within the ETL process testing cycle.Performed data mock-up in the database when test data was not available, manually selecting and mocking data to meet testing conditions.Developed an automation tool that reduced test case creation time from 16 hours to under 15 minutes. Enhanced JIRA reporting using Pandas and Seaborn for improved test execution insights and defect analysis.Conducted count validation, schema validation, and data quality validation.Retested modifications once bugs were fixed and reinstalled the application to ensure accuracy and stability. Show less

Mysore

4 months internship in developing Enterprise applications using J2EE, hibernates, Angularjs , Rest API services, HTML, CSS and Bootstrap. Project- Marginal Finance tracker. This application is used to track the daily household expenditures/incomes and also display the transactions in form pie charts, line charts and bar graphs.

Post Grad Certificate, Data Analytics For Business Decision Making, 4.78

Post-Grad Certificate, Artificial Intelligence, 4.96

Bachelor Of Engineering - Be, Computer Engineering, B+

Activities and Societies: Model United Nations