Disha Jay Barot
Data Analyst @TD
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @TD
CA
Built a Tableau dashboard to visualize core business KPIs. Extracted, interpreted, and analyzed data to identify key metrics and transform raw data into meaningful, actionable information Extracted Data from SQL Databases and integrated it into Power BI for Data Analysis Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries Developed SQL queries using T-SQL in SQL Server 2008 R2, 2012, 2016, and 2019 platforms Involved in applying various statistical techniques for data collection, analysis, and interpretation Performed trend analysis in data using various machine learning algorithms and built visualizations Skilled in identifying problems through data, defining ambiguous and complex problems, and solving problems Presented financial reports and project development data Insights by creating dashboards using Power BI and Tableau to higher executives and clients Worked extensively on creating ETL/ELT jobs using Azure Data Factory Worked on writing Automation Scripts in PowerShell to turn on and turn off the pipelines on Schedule to save some costs Involved in creating automation scripts for Maintenance in both Azure and On-premise SQL Server Participated in the continuous delivery pipeline to fully automate the deployment of the highly available cloud platform that supports multiple projects Involved in ETL development, enhancements, and development of reporting applications using MS SQL, Power BI, Power Query, DAX functions, and Tableau Worked with live and imported data into Power BI to create reports Analyzed high dimensionality high volume data and performed Exploratory Data Analysis (EDA) using Python, Excel, Power BI, and Tableau Involved in Data Migration using SQL, SQL Azure, Azure Storage, Azure Data Factory, PowerShell
EDUCATION
K. S. School of Business Management
Master of Business Administration - MBA, Finance, General
St. Clair College
Data Analytics for Business, Data Analytics
ABOUT DISHA JAY BAROT
3.5+ years of professional experience in statistical Data analysis. Experienced in retrieving various data from different Data servers and validating, and manipulating data using SQL, Python, Macros, and VBA Excel• Advanced experience with data analysis including applying statistical methods and modeling techniques• Proficient in Advanced data analysis skills e.g, database query construction, data warehousing, forecasting, data mining, and experience in business analysis• Strong analytical skills with experience in relevant technical tools, such as SQL, T-SQL, Tableau, Power BI, Advanced excel/PowerPoint, macros, pivot tables, VLOOKUP• Experienced in creating stored procedures, views, triggers, and tables using T-SQL• Expert in data sourcing and liaised with data source owners to understand available data sets and defined regular data extracts to facilitate manipulation/analysis within the appropriate tooling • Experienced in using analytical techniques on large data sets for delivering ad hoc analysis and development of business intelligence• Proficient in importing, exporting, and cleaning databases using SQL, NumPy, and Pandas in Python• Advanced Tableau user to analyze the data, develop Dashboards, and generate sophisticated reports to exhibit data visualization results• Skilled in developing and implementing databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality• Good knowledge of Microsoft data solutions software stack (Azure Databricks, Azure SQL Server, Azure Data Lake Gen 2, Azure Synapse, Azure Cosmos DB, Azure Analysis Service, Azure Data Factory)• Designed and developed ETL processes based on functional and non-functional requirements in python within the Azure platform• Exhibited strong communication skills and a keen understanding of project timelines and dependencies. Team player with excellent interpersonal skills, self-motivated, dedicated, and understanding • Worked in an agile environment and have good insight into agile methodologies and Lean working techniques. Participated in Agile ceremonies and Scrum Meetings
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.