Jagpreet Kaur Gill
Brisbane,QLD
Summary
I have hands-on experience in extracting insights from data to inform business decisions and creating, executing troubleshooting, and managing visualization in a deadline-driven environment, and had completed assigned projects on time with clients' satisfaction. Known for translating complex data sets into actionable business insights and contributing to strategic decision-making processes. Demonstrated expertise in statistical analysis and data visualization.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Data Analyst
Valley International College
01.2025 - Current
- Manage, analyze, and interpret large-scale institutional data to support strategic, evidence-based decision-making across academic and administrative units.
- Design and maintain interactive dashboards, reporting tools, and predictive models to track key performance indicators (KPIs) such as student success rates, enrollment patterns, and financial performance.
- Extract, transform, and validate complex datasets using tools such as SQL, Excel, and Power BI, ensuring data accuracy and consistency.
- Collaborate with academic leaders, administrative staff, and IT teams to ensure the integrity, security, and governance of institutional data assets.
- Prepare comprehensive analytical reports for accreditation bodies and government agencies, ensuring full compliance with regulatory requirements and data standards.
- Provide actionable insights through advanced data visualization and statistical techniques to enhance institutional effectiveness and drive continuous improvement.
- Lead data initiatives that contribute to strategic planning, academic excellence, and the college’s mission of innovation and educational quality.
- Uphold ethical data reporting practices and promote a data-informed culture across departments
- Analyzed complex data sets to identify trends and provide actionable insights for decision-making.
Freelance Data Analyst
UpWork
09.2021 - 12.2024
- Proficient in data analysis technique and data visualization tool.
- Experience working with various databases and data storage systems, such as SQL database and cloud|based storage solutions.
- Ability to gather, clean, and preprocess data from multiple sources, including structured and unstructured data.
- Experience in designing and implementing data pipelines for ETL (Extract, Transform, Load) processes.
- Strong problem-solving skills and the ability to interpret and communicate insights derived from data analysis to stakeholders.
- Experience working independently and managing multiple projects simultaneously.
Application Development Analyst
Accenture Limited
04.2021 - 09.2021
- Monitored daily loads of Azure Data Factory (ADF).
- Collaborated with team members, lead and manager regarding changes in the RDBMS or Source systems for input/impact assessment.
- Provided training to team members on Power BI.
Project Engineer
Wipro Limited
10.2017 - 12.2020
- Designed SSIS packages (using SSDT) and executed SQL server jobs (created and scheduled in SSMS) for Xerox clients’ data extraction from source systems, modification (using business logic) and ingestion into the Data Warehouse.
- Developed Azure Data Factory (ADF) Pipelines to extract data from different data sources to the OLAP system and supported the existing pipelines.
- Analyzed customer issues with existing DBMS (Indigo Project) and migrated data from the Access database to SQL Server 2012 databases (using SQL Server Migration Assistant) to optimize performance, security and scalability capabilities.
- Analyzed and gathered business users’ requirements and imported data from source systems, transformed and loaded into Power BI application to build Covid-19 dashboards to conceptualize Covid’s impact on L’Oréal business in America.
- Design, test and implement physical Data Models for Data Warehouse and Data Mart in the L’Oréal project.
- Developed reports, dashboards and KPI scorecards that provide insights on regional and quarterly sales of 3D printers.
- Created and Managed dataflows, workspaces, data gateways, and Row Level Security and scheduled data refresh in Power BI service for HP-3D-Printing users.
- Created SQL Tables, Views, Functions, and Stored procedures, and worked on query optimization.
- Performed troubleshooting, identified root causes and resolved the reported issues in the relational database management system (SSMS), ETL, Data Mart and Power BI based on SLA.
- Coordinated reporting and analytics modules of projects and provided training to other team members.
- Provision of project management for the team, including effort estimation, project tracking, and status updates.
Education
Bachelor of Technology - Information Technology
SRM University
05.2017
Master of Science - Information Technology
Asia Pacific International College
Brisbane, QLD07-2026
Skills
- Power BI - Expert
- SQL - Expert
- AZURE - Experienced
- ServiceNow - Expert
- SSIS - Experienced
- EXCEL - Experienced
- DAX - Expert
- SQL Server Management Studio - Expert
Certification
Microsoft Azure fundamentals certified
Languages
Hindi
Full Professional
English
Native or Bilingual
Timeline
Data Analyst
Valley International College
01.2025 - Current
Freelance Data Analyst
UpWork
09.2021 - 12.2024
Application Development Analyst
Accenture Limited
04.2021 - 09.2021
Project Engineer
Wipro Limited
10.2017 - 12.2020
Bachelor of Technology - Information Technology
SRM University
Master of Science - Information Technology
Asia Pacific International College
Similar Profiles
Navneet KaurNavneet Kaur
Office Manager at Star Community College/Star international CollegeOffice Manager at Star Community College/Star international College
Peyton MechamPeyton Mecham
Technical Lead at Sevier Valley Center - Snow CollegeTechnical Lead at Sevier Valley Center - Snow College
Matheus MoraesMatheus Moraes
Resident Advisor at Wenatchee Valley CollegeResident Advisor at Wenatchee Valley College
Ailysh Lewis-MillarAilysh Lewis-Millar
Support and Advocacy Worker at Micah ProjectsSupport and Advocacy Worker at Micah Projects
Seb LewSeb Lew
Senior Consultant, Advisory Services at KPMG AustraliaSenior Consultant, Advisory Services at KPMG Australia