payal Jain
Brampton, Canada
payal Jain
Data Engineer, Data Analyst, AI Engineer, AI Train
Category : Data base
Data Engineer with 10+ years of experience in designing and optimizing ETL pipelines, data warehouses, and reporting systems. Expertise in SQL, Python, Linux with a strong track record of building scalable data solutions and real-time alert systems. Proven ability to translate business requirements into actionable insights and deliver high-quality data solutions that improve efficiency and decision-making. AI Application Design, Implementation, and Deployment, Model Adaptation Techniques AI Model Evaluation and Monitoring Performance, Latency, and Cost Optimization
TECHNICAL SKILLS
• Programming Languages: SQL, Python, Java, Bash, VBA
• Databases: MySQL, PostgreSQL, SQL Server
• Data Engineering: ETL Pipelines, Data Modelling, Data Warehousing, Data Migration
• Tools & BI: IBM Cognos, Pentaho, Power BI, Tableau,
• Big Data: Hadoop
• Operating Systems: Linux, Unix
• Other Tools: Jira, MS Excel, Git
• AI : LLM Implementation, Deployment, AI Model Evaluation and Monitoring Performance, Training Models
• AI Tools: RAG, Vector search, Semantic Search, Deep Eval, Pydantic models, Pandas
TECHNICAL SKILLS
• Programming Languages: SQL, Python, Java, Bash, VBA
• Databases: MySQL, PostgreSQL, SQL Server
• Data Engineering: ETL Pipelines, Data Modelling, Data Warehousing, Data Migration
• Tools & BI: IBM Cognos, Pentaho, Power BI, Tableau,
• Big Data: Hadoop
• Operating Systems: Linux, Unix
• Other Tools: Jira, MS Excel, Git
• AI : LLM Implementation, Deployment, AI Model Evaluation and Monitoring Performance, Training Models
• AI Tools: RAG, Vector search, Semantic Search, Deep Eval, Pydantic models, Pandas
Portfolio
Working hours
- Monday:08h00 To 18h00
- Tuesday:08h00 To 18h00
- Wednesday:08h00 To 18h00
- Thursday:08h00 To 18h00
- Friday:08h00 To 18h00
- Saturday:Not available
- Sunday:Not available
• Designed and implemented ETL pipelines using SQL and Bash, automating data workflows and improving processing efficiency
• Developed real-time alert systems to detect abnormal player behaviour, enhancing monitoring and fraud detection capabilities
• Built and optimized complex SQL queries and stored procedures to support business reporting and analytics
• Defining SQL Procedures and functions for website campaigns flow.
• Developed automated reporting solutions for stakeholders, improving data accessibility and decision-making
• Led database migration initiatives, ensuring data integrity and seamless transition with minimal downtime
• Writing Unix and python scripts for Data Pipeline designing and monitoring.
• Developed real-time alert systems to detect abnormal player behaviour, enhancing monitoring and fraud detection capabilities
• Built and optimized complex SQL queries and stored procedures to support business reporting and analytics
• Defining SQL Procedures and functions for website campaigns flow.
• Developed automated reporting solutions for stakeholders, improving data accessibility and decision-making
• Led database migration initiatives, ensuring data integrity and seamless transition with minimal downtime
• Writing Unix and python scripts for Data Pipeline designing and monitoring.
Singpool UBT Report:
• Developed ETL pipelines using Pentaho, enabling efficient data integration and transformation
• Designed OLAP and optimized SQL queries and Python scripts for data processing and analytics
• Created dashboards and reports using Tableau to provide actionable insights to stakeholders
• Executed Data migration from MS-SQL to PostgreSQL
Singhealth Odyssey:
• Implemented and administered data catalog solutions, improving data governance and accessibility
• Responsible for delivering client training sessions and technical presentations on data tools and solutions
• Implemented Pentaho and Lumada Data Catalog
• Responsible for project management and creating documents
• Developed ETL pipelines using Pentaho, enabling efficient data integration and transformation
• Designed OLAP and optimized SQL queries and Python scripts for data processing and analytics
• Created dashboards and reports using Tableau to provide actionable insights to stakeholders
• Executed Data migration from MS-SQL to PostgreSQL
Singhealth Odyssey:
• Implemented and administered data catalog solutions, improving data governance and accessibility
• Responsible for delivering client training sessions and technical presentations on data tools and solutions
• Implemented Pentaho and Lumada Data Catalog
• Responsible for project management and creating documents
• Designed and developed OLAP databases for analytical reporting and business intelligence
• Built dashboards and reports using IBM Cognos, improving data-driven decision-making
• Gathered and analysed business requirements to design scalable data solutions
• Developed SQL queries and stored procedures for data extraction and transformation
• Led data migration and automation initiatives, improving operational efficiency
• Collaborated with cross-functional teams to deliver end-to-end data solutions
• Built dashboards and reports using IBM Cognos, improving data-driven decision-making
• Gathered and analysed business requirements to design scalable data solutions
• Developed SQL queries and stored procedures for data extraction and transformation
• Led data migration and automation initiatives, improving operational efficiency
• Collaborated with cross-functional teams to deliver end-to-end data solutions
Managed Pentaho tool –Business Intelligence tool along with report automation
• Report generation using Tableau and Qlick view
Automated the process for fast execution and timely delivery of the deliverables which resulted in direct receiving of the reports to the end user without manual processing
•
Designed SQL query along with MySQL Database Designing and maintenance
•
Created and designed analytics reports for business stake holder’s deliverables along with ad-hoc report generation and dashboard creation using Excel
Managing Analytics team of 4.
• Report generation using Tableau and Qlick view
Automated the process for fast execution and timely delivery of the deliverables which resulted in direct receiving of the reports to the end user without manual processing
•
Designed SQL query along with MySQL Database Designing and maintenance
•
Created and designed analytics reports for business stake holder’s deliverables along with ad-hoc report generation and dashboard creation using Excel
Managing Analytics team of 4.
Created reports using VBA and SQL
•
Handled different project for report automation
•
Worked on requirement gathering and perform data analysis using excel and python
Report generation using Tableau at later stages.
•
Handled different project for report automation
•
Worked on requirement gathering and perform data analysis using excel and python
Report generation using Tableau at later stages.
Performed requirement gathering and analysis and liaising with different teams.
•
Generated report using SQL Server and MySQL and Pentaho
•
Migrated data from SQL Server to MySQL
•
Report extraction and analysis via Google Analytics and designed ETL in Pentaho.
•
Generated report using SQL Server and MySQL and Pentaho
•
Migrated data from SQL Server to MySQL
•
Report extraction and analysis via Google Analytics and designed ETL in Pentaho.
Research presentation for Project
Data Implementation for COGNOS
Data Analysis and Report generation
Automation on MS-Access of manual excel reports.
Client handling for the project.
Data Implementation for COGNOS
Data Analysis and Report generation
Automation on MS-Access of manual excel reports.
Client handling for the project.
• Deploying AI Microcredential
It provides the complete guide to implement and deploy AI at company level.
It provides the complete guide to implement and deploy AI at company level.
Masters in computer Application
• Advanced Diploma in IT
Basic Diploma in Computer Applications
Graduation from science Strream
Subjects included : Maths, Physics, Chemistry, Biology
Subjects included : Maths, Physics, Chemistry, Biology
- Deploying AI from University of Toronto, Canada 28/05/2026
![Deploying AI from University of Toronto, Canada]()
• AI : LLM Implementation, Deployment, AI Model Evaluation and Monitoring Performance, Training Models
• AI Tools: RAG, Vector search, Semantic Search, Deep Eval, Pydantic models, Pandas - Certificate in Advanced SQL from HackerRank 10/02/2026
![Certificate in Advanced SQL from HackerRank]()
Complex SQL Query handling
Complex SQL design
Designing Procedures and cursor for web implementation - Agentic Data & Analytics Bootcamp from Ascend 05/02/2026
![Agentic Data & Analytics Bootcamp from Ascend]()
Creation of Pipeline and reports using AI Agents through ASCEND Agents
- 🇬🇧 English
- 🇮🇳 Hindi
Please sign in as a customer to give your feedback
Need a service ?
Do you want to hire the services of this Professional ?
Post your need and you will receive dozens of proposals from the Professionals of the community.
