Or
payal Jain

Payal Jain

Data Engineer, Data Analyst, AI Engineer, AI Train
📍 Brampton, Canada · (0) · Member since June 2026
Availability
🏠 Works remotely / from home Yes No
🧰 Travels to client Yes No

Presentation

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
📋

Background

Data Engineer
Boyd Interactive · 01/11/2022 – Today
• 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.
Senior Consultant
Hitachi Vantara · 03/09/2021 – 30/05/2022
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
Database Analyst
Nitso Technologies India Pvt. Ltd. · 01/09/2016 – 01/09/2021
• 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
Assistant Manager – Analytics
Askmebazaar · 02/02/2016 – 30/08/2016
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.
Senior Executive-Business Development
Misumi India Pvt. Ltd. · 10/01/2016 – 01/02/2016
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.
Assistant Manager- MIS & Analytics
Utsav Fashion Pvt Ltd. · 01/09/2012 – 01/01/2016
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.
MIS Executive
IBM · 11/11/2010 – 15/10/2011
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.
Microcredential
University of Toronto · 2026 – 2026
• Deploying AI Microcredential
It provides the complete guide to implement and deploy AI at company level.
MCA
IGNOU · 2010 – 2014
Masters in computer Application
A level
NIELIT · 2008 – 2012
• Advanced Diploma in IT
O Level
DOEACC · 2007 – 2007
Basic Diploma in Computer Applications
Graduation
IGNOU · 2006 – 2009
Graduation from science Strream
Subjects included : Maths, Physics, Chemistry, Biology
Deploying AI from University of Toronto, Canada
Deploying AI from University of Toronto, Canada
28/05/2026
• AI : LLM Implementation, Deployment, AI Model Evaluation and Monitoring Performance, Training Models
• AI Tools: RAG, Vector search, Semantic Search, Deep Eval, Pydantic models, Pandas
🔍
📄PDF
Certificate in Advanced SQL from HackerRank
10/02/2026
Complex SQL Query handling
Complex SQL design
Designing Procedures and cursor for web implementation
↗️
📄PDF
Agentic Data & Analytics Bootcamp from Ascend
05/02/2026
Creation of Pipeline and reports using AI Agents through ASCEND Agents
↗️
🇬🇧English 🇮🇳Hindi
🕐

Working hours

Monday
From08h00To18h00
Tuesday
From08h00To18h00
Wednesday
From08h00To18h00
Thursday
From08h00To18h00
Friday
From08h00To18h00
Saturday â–ª Today
Closed
Sunday
Closed

Reviews

No reviews

⚠️
Please as a customer to give your feedback
💬
No reviews yet.
Be the first to share your experience with this professional.