OnBenchMark Logo

Sanket (RID : 6v6vlt2kbnlj)

designation   Sr. Data Analyst

location   Location : Indore

experience   Experience : 5 Year

rate   Rate: $12 / Hourly

Availability   Availability : Immediate

Work From   Work From : Any

designation   Category : Information Technology & Services

Shortlisted : 0
Total Views : 35
Key Skills
MySQL MS SQL Server SQL salesforce SSIS Azure modern apps Database
Discription

 


Post Graduation Diploma in Management (Marketing & Finance): SaiBalaji Education Society Pune
Bachelor of Commerce (Accounting and E-commerce): Amravati University, Amravati
Diploma In Computer Applications: SSMIT, New Delhi
Sanket Kakade
PROFESSIONAL SUMMARY
5 years of design, development and implementation experience in Business Intelligence, data and financial
Analytics delivering valuable data insights supporting large data and business analytics platforms.
Creation and automation of Enterprise Scale dashboards, standard reports, scorecards and ad-hoc reports to s
Experience on collecting data from varied resources and handling varied file formats, flat files, Excel sheets,
google sheets, cloud sources, streaming datasets and web scraping.
Skilled in developing and maintaining ETL processes, ensuring data accuracy and integrity.
Experience with data modeling and data warehousing, SQL queries, joins, views, CTE and creating
required to manipulate data into required formats for data analysis.
Design, develop and implement compelling data visualization solutions using DAX, power query and various
custom visuals and char particular to ensure clear and concise storytelling.
Working knowledge of Power automate to create and automate workflows providing conditional logic, error
handling and also workflow integration with Power BI and Power apps ensuring remote access to critical KPIs
and data insights and alerts.
Strong analytical, problem-solving, behavioral, organizational abilities ensuring stronger managerial and
leadership skills; Quick Learner.
Work experience with diverse domains, industry and teams.
Experience in direct client interactions, handling their complex and dynamic queries, providing support and
resolutions to stakeholders, reducing client grievances and churn.
EDUCATION
TECHNICAL SKILLS

Databases: MySQL, MS SQL Server
Scripting: SQL, DAX, Salesforce
Inspector
Tools: MS Excel, PowerPoint, SSIS, Power Automate, Power Query, Charticulator, Google Sheets, Git Cloud:
Azure Data Factory
Visualization: Power BI, Tableau, MS Excel, Salesforce (Reporting)
EXPERIENCE
Sr. Data Analyst
Insourcement Tech Solutions LLP – Indore Apr 2023- Current

I have created custom reports in salesforce to meet specific business needs.


Query data using Salesforce Object Query Language (SOQL) to extract necessary information.


Worked on Salesforce Inspector to check the Objects from Salesforce to finds valuable insights.


Design solutions that align with the firm's data management principles, policies, standards and best
practices


Develop and deploy dashboards, visualizations and autonomous and dynamic reporting interfaces to

be distributed to stakeholders via the BI reporting platform, web portal and email.

Optimize report distribution, execution and the scalability of all reporting solutions so they are
autonomous and Dynamic.


Work with the Data Management team to provide input on logical and physical database design. data


modeling and/or mapping

Work in Power BI workspace Migration and Migrated the 12 workspaces including over 50+ Reports
and Dashboards


Generate large and complex data extracts and queries for the Analytical Leads for data analysis by

utilizing various database schema such as Microsoft SQL Server and Datamart.
Work In Agile Mythology and Completed Development as per sprint planning.

Work with various Team Members, internal departments


Involved in requirement Understanding, streamlining process and developing Dynamic Dashboard.


Business Analyst
Kaseya India Software Pvt. Ltd - Bengaluru Sep 2022- Apr 2023


Was Responsible for creating Power BI Report and Dashboard and connecting with them with Live Data
for Real time Analysis.


Contributed new offering and Innovations and General advancement in Power BI Reporting through
Automate, Excel-Connecter, Power BI- Robo, Power Tiles and SOL.


Work in Close coordination with VPs to update the Business Progression.


Involved in requirement Understanding, streamlining process and developing Dynamic Dashboards.




Data Analyst, Amar Tea Pvt. Ltd - Pune Feb 2020– Sep 2022
Power BI, Tableau, SQL Server, DAX, Power Query, MS-Excel, SSIS, Power Automate, Power Apps, Charticulator, Valuation &
Modelling, Data Modeling
Project Name: Sales, logistics and Operations


Designe

Project Details
Title : Sales, logistics and Operations
Duration : 36 (Month)
role and responsibileties :
  • Designed and built statistical analysis models on large data sets that helped increase sales (up to 20% per product)
  • Automated a report for the sales team using Postgres-SQL, data warehousing programs, and Power BI for data intelligence and analysis that automatically qualified sales leads resulting in a lift in conversion rate of 40%.
  • Creating Row level Security with Power BI and integration with power b1 services portal.
  • Developed Dax functions like table function, aggregation function and iteration functions.
  • Worked on various types of transformation that are available in power bi query editor.
  • Schedule automatic refresh and scheduling refresh of the reports in power bi service.
  • Install and configure enterprise gateway and personal gateway in power bi service.
  • Developed several visualizations like Line chart, Bar chart, Table, Matrix, Tree Map.
  • Creating a relationship with help of Data Modeling.
Description :

 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!