Business Analyst Data

JALDEEP PATEL

630-***-**** *.**********@*****.*** Schaumburg, IL

Professional Summary

Highly motivated Data & Analytics Engineer with 10+ years of experience in business intelligence, data engineering, and analytics. Proficient in developing scalable data pipelines, building robust data visualizations, and implementing reporting infrastructure using Snowflake, Power BI, Tableau, and Python. Adept at translating business needs into actionable insights, automating workflows, and simplifying reporting processes in fast-paced, dynamic environments. Strong analytical skills with a passion for solving complex data challenges and driving business decisions through data-driven solutions.

Skills

•Data Engineering: ETL pipelines, Snowflake administration, Databricks

•Programming: Python, SQL

•Visualization Tools: Tableau (dashboard creation, Tableau Online administration), Power BI

•Cloud Platforms: AWS (S3, Glue, Lambda)

•Business Tools: Salesforce.com, HubSpot, Clari, Outreach, 6sense, G-Suite

•Data Modeling: APIs, database operations, data marts

•Soft Skills: Problem-solving, stakeholder management, strategic planning, collaboration

•Project Management: JIRA, TFS, Git, GitHub

WORK EXPERIENCE

Rural Municipality of Alberta Edmonton, AB

Data & Analytics Engineer May 2023 – Present

•Evaluating business process, anticipating requirements, and providing a solution to complex problems

•Collecting business requirements from the internal team

•Effectively communicating the insights and solutions to management and internal team from different

departments

•Responsible for Full Power BI Administration – user management, workspace management, gateway

administration, data source creation, monitoring, and troubleshooting

•Working Closely with project managers, financial analysts, and Director.

•Developed and maintained data pipelines in Databricks using Python-powered notebooks hosted on AWS.

•Designed and managed data infrastructure in Snowflake, creating scalable ETL workflows and database

tables/views

•Automated reporting processes, reducing manual effort and improving operational efficiency.

•Monitoring the data flow and dashboards on a daily, weekly and monthly basis.

•Delivered insights and recommendations based on data analysis and visualization, driving strategic business

decisions.

•Translated business requirements into technical specifications to create data marts, reports, and dashboards.

•Creating a technical documentation, conducting meetings and presentations to share ideas and plans and

solutions.

•Integrated Salesforce data into Snowflake and Power BI, providing actionable insights for decision-makers.

•Managed JIRA tickets, ensuring project deliverables were prioritized and completed on time.

Microsoft Seattle, WA

Technical Business and Data Analyst May 2022 – April 2023

•Integrate and work with service Americas time zone team & Finance, and Leadership, to prioritize business and

information needs aligned to field services businesses and execution.

•Present and manipulate data in Power BI

•Prepare reporting and analysis to support the Consulting Services Rhythm of the business, in addition to Ad-Hoc

Reporting requests.

•Develop a deep understanding of vast data sources and know exactly how, when, and which data to use to tackle

business problems.

•Identify and analyze non-functional requirements for both business and product system need

•Develop reporting to track financial and operational performance; collaborate with additional stakeholders on

reporting cadence and requirements.

•Leveraged visualization tools to transform complex data into meaningful and visually appealing

representations, facilitating data interpretation and decision-making.

•Proficiently developed and reviewed simultaneous SQL queries, employing join clauses (inner, left, and right)

within Power BI Desktop to validate static and dynamic data for rigorous data validation.

•Collaborated effectively with cross-functional teams to understand and address data validation requirements,

resulting in reliable and trustworthy data outputs.

•Proficiently created reports by employing data modeling techniques aligned with stakeholder requirements.

•Pull data daily, weekly and monthly basis, manage the dashboards and reports on multiple databases from

Azure Data Lake using Power BI Gateway

•Handling the data for business intelligence and analysis purpose of America, Canada and LATAM and Worldwide

data based on needs.

•Performing Data Wrangling, Data Profiling and Data Cleansing

•Conducting meetings and presentations to share ideas Managing Dashboards

•OLAP and ETL, Implementing Row-Level-Security

•Environment: Power BI Desktop, Power BI Service, Power BI Gateway Excel, Azure Data Lake, SQL Server,

Dynamic 365, Visual Studio, Microsoft Teams, RLS

CGI Edmonton, AB

Business Intelligence Analyst Aug 2018 – Jul 2022

•Participate in data integration requirements gatherings and related documentation

•Designed and maintained dashboards and reports in Tableau, providing real-time insights for sales and

marketing teams.

•Administered Snowflake databases, including optimization and security configurations.

•Doing interpretation of the data effectively, and providing ongoing reports with the result of the analysis

•Conducted data analysis using SQL and Python, extracting actionable insights to support business growth.

•Provide a training to the stakeholders and internal team

•Attained high productivity while working within tight timelines whilst being highly flexible, organized, and

prioritizing workload effectively and efficiently in a timely manner and managing multiple tasks.

•Creating pivot tables, charts, and functions in Excel sheets

•Streamlined reporting workflows, automating repetitive tasks and reducing tech debt.

•Ensure the resulting solution meets business requirements and business acceptance is achieved.

•Document current business processes, business flows, checking data that matches with governance policies.

•Collaborated with cross-functional teams to define analytics requirements and deliver tailored solutions.

•Assisted in building ETL pipelines to integrate data from Salesforce into Snowflake and Tableau.

•Delivering data-driven insights to non-technical audience and stakeholders.

•Supported the administration of Snowflake and AWS S3 operations for data storage and processing.

Nektar Data Systems Edmonton, AB

BI Developer Jul 2015 – Aug 2018

•Successfully supported internal and external user requests for technical intervention on Power BI, while

gathering user requirements

•Diligently expanded systems with new features and structural components, while escalating technical issues to

the development or technical operations team per prescribed support guidelines

•Proactively performed production support activities which involved the assignment of issues, issue analysis, and

providing best solutions to complex issues

•Attained high productivity while working within tight timelines whilst being highly flexible, organized, and

prioritizing workload effectively and efficiently in a timely manner

•Coordinated and managed multiple projects that support Operational Excellence

•Established timely and effective troubleshooting of arising issues and providing technical support to clients

•Effectively trained end-users in best practices to minimize errors and protect key data, while creating robust

reports based by using Stimulsoft platform on client's requirements, including SQL queries to fetch the data

from the database

•Designed rich dashboards with Power BI and referred user stories to create compelling dashboards to deliver

actionable insights

EDUCATION

• Humber College of Applied Technology - Toronto, ON

Post-Graduation Diploma - Computer Programmer (December 2012)

• Gujarat University - Vadodara, India

Bachelor of Engineering (B.E) - Computer Engineering (June 2010)

CERTIFICATIONS

• Entry Certificate in Business AnalysisTM - IIBA Certified

• Data Science for Business – Harvard Online School

• Dynamic 365 – Linked IN

• Introduction to R - Coursera

• Introduction to Python - Coursera

Contact this candidate