John Gojani

John Gojani

Data Analyst
United States of America

About Me

Dedicated and versatile professional with a strong background in both Data Analysis and Technical Support. Proficient in harnessing the power of data to drive business insights while providing exceptional technical assis…

Experience

Business Intelligence Analyst

ADCO Electrical Corp
Oct 2021 - Present · 4 years 8 months

• Data Visualization Expertise (Power BI):
Created dynamic and interactive dashboards using Power BI, visualizing complex datasets for actionable insights.
• Advanced DAX Proficiency:
Developed complex DAX expressions to calculate key performance indicators (KPIs) and customized measures tailored to business
needs.
Utilized time intelligence functions to analyze trends and patterns in time-series data.
• Advanced SQL Querying:
Developed and optimized complex SQL queries to extract, transform, and analyze data from relational databases. Utilized SQL joins,
subqueries, and window functions to consolidate data from multiple tables and databases efficiently.
• Collaborative Project Management:
Collaborated with cross-functional teams to define project scope, data requirements, and key performance metrics. Successfully
managed end-to-end Power BI projects, delivering results within deadlines and exceeding executive expectations.
• Continuous Learning and Research:
Stayed updated with the latest AI research and industry trends, applying new techniques and best practices to
Business Intelligence: Power BI, Data Analysis, Data Visualization
Technical Skills: SQL, Excel, AI Language Models, Smartsheet
Project Management: Collaborative project management, communication skills
Data Mining and Transformation: DAX Proficiency, Data cleansing, Excel functions
IT Support: Hardware/software troubleshooting, system maintenance, software deployment
enhance AI capabilities. Conducted A/B testing and experimentation to evaluate the performance of AI models and
validate their impact on business outcomes.
• Data Transformation:
Ability to cleanse, transform, and prepare raw data for analysis using Power BI's data transformation capabilities.
• Excel and Organizational Skills:
Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, data validation, and conditional formatting.
Proficient in using Smartsheet for project management, data organization, and collaboration.
Skilled in data cleaning, transformation, and analysis using Excel functions and tools.
Experience with VBA macros in Excel to automate repetitive tasks and enhance efficiency.
Ability to create insightful data visualizations using Excel charts and graphs.

Data Analyst

ADCO ELECTRICAL CORP, New York, New York
Oct 2021 - Present · 4 years 9 months

Created dynamic and interactive dashboards using Power BI, visualizing complex datasets for actionable insights.
Developed complex DAX expressions to calculate key performance indicators (KPIs) and customized measures tailored to business needs.
Utilized time intelligence functions to analyze trends and patterns in time-series data.
Developed and optimized complex SQL queries to extract, transform, and analyze data from relational databases.
Utilized SQL joins, subqueries, and window functions to consolidate data from multiple tables and databases efficiently.
Collaborated with cross-functional teams to define project scope, data requirements, and key performance metrics.
Successfully managed end-to-end Power BI projects, delivering results within deadlines and exceeding executive expectations.
Stayed updated with the latest AI research and industry trends, applying new techniques and best practices to enhance AI capabilities.
Conducted A/B testing and experimentation to evaluate the performance of AI models and validate their impact on business outcomes.
Ability to cleanse, transform, and prepare raw data for analysis using Power BI's data transformation capabilities.
Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, data validation, and conditional formatting.
Proficient in using Smartsheet for project management, data organization, and collaboration.
Skilled in data cleaning, transformation, and analysis using Excel functions and tools.
Experience with VBA macros in Excel to automate repetitive tasks and enhance efficiency.
Ability to create insightful data visualizations using Excel charts and graphs.

IT Support Specialist

Fibonacci Llc, Trumbull, CT
Nov 2017 - Sep 2019 · 1 year 10 months

Provided top-tier technical support to end-users, resolving hardware, software, and network-related issues promptly and efficiently.
Utilized a systematic approach to problem-solving, ensuring minimal downtime and maximum user productivity.
Installed, configured, and maintained desktops, laptops, printers, and peripheral devices, ensuring optimal performance and reliability.
Deployed and updated software applications and operating systems, adhering to licensing and security requirements.
Resolved most calls with first contact and escalated remaining calls to appropriate personnel for swift handling.
Accommodated wide-ranging customer experience levels by adjusting technical support strategies.
Researched latest technology and products to stay abreast of current trends.

Skills

Integrated Business Intelligence Cognos Structured Query Language (SQL) Data Model Data Representation Data Repository SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) Data Analysis Skills Power BI QlikView Tableau Data Analysis Excel AI Language Models Smartsheet Collaborative project management communication skills DAX Data cleansing Excel functions Hardware/software troubleshooting system maintenance software deployment Microsoft Excel pivot tables data validation conditional formatting VBA macros data cleaning data transformation Excel charts graphs
Report this Profile?