N

Nayan Shewkani

Data Scientist

Mumbai, Maharashtra, India4 yrs 9 mos experience

Key Highlights

  • Expert in Power BI and SQL for data visualization.
  • Strong background in risk management and compliance analytics.
  • Proficient in Python for automating data processes.
Stackforce AI infers this person is a Data Analytics professional specializing in Risk Management and Business Intelligence.

Contact

Skills

Core Skills

Microsoft Power BiRisk ManagementData AnalysisData EngineeringData VisualizationPerformance Management

Other Skills

Amazon RedshiftAnalytical SkillsApache SparkAzure DatabricksCleansingDAXData AnalyticsData ModelingData ScienceData modellingDatabasesExploratory Data AnalysisIT Business AnalysisInsuranceInsurance Analytics

About

I am a passionate and versatile Business Intelligence Developer and Data Engineer, with a strong command of SQL, Power BI, and Python for in-depth data analysis and automation. My journey in the world of data began with a natural curiosity for uncovering patterns and insights, which has evolved into a professional drive to harness data for strategic decision-making. In my current role, I specialize in empowering M&G Global Services organizations by managing and analyzing data related to risks, controls, issues, and notifiable events. I design and maintain sophisticated Power BI dashboards that provide actionable insights, enabling stakeholders to monitor compliance metrics and mitigate risks effectively. Additionally, I optimize SQL databases and queries to ensure seamless data processing and retrieval. A significant part of my work involves leveraging automation through Python scripts to streamline manual processes, such as refreshing Power BI dataflows. I also play a key role in ensuring data security by implementing row-level security (RLS) and managing role-based access requests using ServiceNow. I am deeply intrigued by the transformative power of data in the Risk and Compliance domain. From enhancing operational efficiency to enabling data-driven decision-making, I am committed to exploring how advanced analytics and predictive modeling can further revolutionize this space. In today’s data-centric world, I believe in the power of insights to drive innovation and success. My mission is to stay at the forefront of this field, continuously refining my skills and helping organizations leverage data to achieve excellence, ensure compliance, and stay ahead in an ever-changing landscape. Let's connect and unlock the potential of data together.

Experience

4 yrs 9 mos
Total Experience
1 yr 1 mo
Average Tenure
1 yr 4 mos
Current Experience

M&g plc

Senior Data Analyst

Dec 2024Present · 1 yr 4 mos · Mumbai, Maharashtra, India · Hybrid

  • ● Manage, analyze, and visualize data related to risks, controls, issues, and notifiable events, ensuring actionable insights are delivered to stakeholders.
  • ● Design and maintain analytical dashboards in Power BI, enabling stakeholders to monitor compliance metrics and risk indicators effectively.
  • ● Work extensively with SQL databases containing risk and compliance data, developing and optimizing complex queries to enhance data retrieval and processing efficiency.
  • ● Develop Python scripts to automate manual tasks, such as refreshing Power BI dataflows, improving operational efficiency and reducing errors.
  • ● Act as an approver for role-based access in Power BI, utilizing ServiceNow to manage and resolve role-related requests, ensuring compliance with organizational security policies.
  • ● Implement and manage row-level security (RLS) to enforce data access control based on user roles.
  • ● Partner with risk and compliance teams to understand key requirements, translate them into scalable BI solutions, and drive informed decision-making.
  • ● Streamline reporting processes by developing robust dashboards and tools tailored to organizational needs.
Microsoft Business Intelligence (MSBI)Risk SystemsPython (Programming Language)Apache SparkMicrosoft Power BIRisk Analytics+5

Exl

Data Analyst - Analytics

Jan 2024Nov 2024 · 10 mos · Ahmedabad, Gujarat, India · Hybrid

  • ● Currently employed as an Analytics Consultant within the insurance domain, specializing in digitizing reporting methods
  • into Power BI.
  • ● Utilizing Amazon Redshift as a primary database source to access and retrieve client data.
  • ● Proficiently employing Power BI dashboards and Python to manipulate and structure data for integration.
  • ● Leveraging advanced DAX functionalities to develop comprehensive dashboards tailored to client needs.
  • ● Focused on enhancing Agents Manager Productivity by analyzing sales and lead data on monthly, quarterly, and
  • yearly basis.
  • ● Developing and maintaining a claims dashboard to facilitate tracking of legitimate claims and comparing claim
  • withdrawals against company revenue.
  • ● Designing sales dashboards to identify top-performing clubs and entities in terms of sales and revenue across the
  • organization.
  • ● Implementing row-level security measures to restrict access to sensitive data and ensure data privacy compliance.
  • ● Actively engaging with senior management stakeholders to gather and understand project requirements and
  • expectations.
Analytical SkillsMicrosoft Power BIMicrosoft SQL ServerInsuranceMarketingIT Business Analysis+15

Accenture

Data Engineering Analyst

Feb 2022Jan 2024 · 1 yr 11 mos · Ahmedabad, Gujarat, India · Remote

  • As a data professional at Accenture, I am engaged in various responsibilities, including:
  • Designing, developing, and maintaining SQL Server databases to ensure data accuracy, consistency, and security.
  • Developing and maintaining ETL (Extract, Transform, Load) processes to efficiently move data from various sources into the SQL Server database.
  • Creating reports using SSRS and Power BI to present data in a clear and concise manner to end-users.
  • Collaborating with stakeholders to identify and document reporting requirements.
  • Developing a suite of interactive and visually appealing Power BI reports that provide clients with comprehensive views of their performance metrics, facilitating data-driven decision-making.
  • Analyzing data using Microsoft Excel to identify trends, patterns, and insights.
  • Troubleshooting and resolving issues with the database and reporting systems.
  • Seamlessly integrating SQL Server Reporting Services (SSRS) and Power BI Services into data workflows to produce detailed and customizable reports for clients, enhancing data visibility.
  • Documenting database and reporting processes, procedures, and standards.
  • Moreover, I am actively involved in diverse projects at Accenture, including:
  • Risk Management Quality Dashboard: Handling contract revenue and contract management to ensure data accuracy and consistency.
  • Solution Contingency Monitoring Tool: Tracking additional budget costs allocated to potential risks that may arise during ongoing projects. This proactive measure prevents any adverse impact on Accenture's profitability.
  • Root Cause Analysis Dashboard: Managing brand performance and contract revenue-related activities at Accenture.
Analytical SkillsDAXMicrosoft Power BIDatabasesCleansingData Analytics+10

Kpmg australia

Data Analyst

Feb 2022Feb 2022 · 0 mo

  • Conducted Data Quality Assessment in Dataset provided by Client in Microsoft Excel.
  • Gained some Data Insights from the Dataset provided by the Client using Pandas and Numpy library in
  • Google Colab using programming language Python. Implemented a few visualizations using
  • Matplotlib and Seaborn library to be enlightened about the particular market trend.
  • Built a full-fledged interactive Power BI dashboard to create some visualizations to acknowledge
  • the Client about their target customers to accelerate their business and marketing strategy.
Analytical SkillsData AnalyticsQuery WritingPredictive ModelingData AnalysisData Visualization

Almabetter

Data Science Trainee

Nov 2021Nov 2022 · 1 yr · Ahmedabad, Gujarat, India

  • 1. Built Exploratory data analysis project on Hotel booking to know how people are choosing a hotel to stay or booking a hotel based on the location that location may be a city area or Resort area. Also, which destination country to choose on which season.
  • 2. Libraries used in the project are NumPy pandas and for data visualization, we use Matplotlib and seaborn and also used pycountry library which provides the ISO databases for the standards like Languages, country currencies etc.
  • 3. We cleaned and preprocessed the data which contain lots of missing values and then performed the EDA to extract information from the data
  • 4. Analysis was done on – Cancelled booking, booking ratio between hotels, percentage of booking, busiest month, most visited country, people stay duration and also most booked accommodation type.
Analytical SkillsData AnalyticsInterpersonal CommunicationPredictive ModelingPresentation SkillsData Visualization+1

Teksun inc

Data Reporting Analyst

Jun 2021Jan 2022 · 7 mos · Ahmedabad, Gujarat, India

  • At Teksun Inc, we leverage Embedded Hardware, AI&ML, Cloud, Industry 4.0, and Web/Mobile services to meet our customers' product development needs.
  • Key Responsibilities:
  • Identified and engaged potential customers and companies globally to drive business growth.
  • Understood the objectives and roadmaps of client companies and identified areas where Teksun's solutions could aid in achieving those goals.
  • Crafted and sent customized emails and executed effective follow-ups to nurture client relationships.
  • Managed the sales pipeline, from lead generation to conversion, ensuring seamless progress.
  • Utilized LinkedIn for prospecting, engagement, and nurturing, contributing to lead generation.
  • Thoroughly understood and forwarded qualified leads and their specific requirements to the team.
  • Continuously enhanced technical and prospecting skills for an efficient sales process.
  • Notable Achievements:
  • Implemented Power BI dashboards for in-depth tracking and analysis of quarterly metrics. This provided real-time visibility into revenue performance by region, enabling data-driven decision-making and strategic adjustments.
  • Collaborated closely with sales teams to ensure that sales activities were aligned with company objectives, resulting in increased revenue.
Analytical SkillsDAXMicrosoft Power BIInterpersonal CommunicationIT Business AnalysisQuery Writing+7

Education

Gujarat Technological University (GTU)

Bachelor of Engineering - BE — Electronics and Communications Engineering

Jan 2016Jan 2020

Stackforce found 100+ more professionals with Microsoft Power Bi & Risk Management

Explore similar profiles based on matching skills and experience