Quote
Summary
Software
Overview
Work History
Interests
Education
Skills
Certification
Timeline
BusinessAnalyst
RM MOHANTY

RM MOHANTY

Data Analyst
New Delhi,DL

Quote

No data is clean, but most is useful
Dean Abbott

Summary

Results-driven professional with a strong background in data-driven analysis, ETL processes using Matillion and Snowflake, Python for data visualisation, and Power BI. Experienced in leveraging data to drive business insights and optimize operations. Seeking to contribute expertise in data analytics and visualisation to a dynamic team.

Software

Python

Snowflake

Power BI

Matillion

MYSQL

AWS

Overview

8
8
years of professional experience
4
4
Languages

Work History

Senior Business Analyst

StudyIq
06.2023 - 01.2024
  • Utilized Python with Numpy and Pandas for data manipulation and statistical analysis, including time series analysis to forecast student enrolment trends and optimize resource allocation
  • Employed Seaborn and Matplotlib for visualizations, creating interactive dashboards in Power BI to monitor student engagement metrics and educational analytics
  • Managed and optimized MySQL databases for customer segmentation and targeted marketing campaigns, implementing complex SQL queries with Joins and CASE statements to drive 10% increase in user engagement and sales conversion rates
  • Designed and automated ETL pipelines using Matillion, integrating data from diverse sources (e.g., XML,JSON files) into Snowflake for real-time analytics
  • Utilized Matillion's API for workflow automation
  • Troubleshoot and resolve issues related to Matillion jobs and workflows
  • Able to design, develop, and maintain ELT/ETL pipelines in and out of data warehouse using combination of Python, data build tools (DBT),Matillion and Snowflakes SNOWSQL
  • Leveraged AWS services (s3 bucket) for continuous data ingestion, storage, and management, enhancing scalability and performance of data solutions
  • Collaborated with cross-functional teams to drive business intelligence initiatives, improving operational processes and educational outcomes.
  • Analyzed performance metrics to identify opportunities to increase sales.
  • Worked with team leads and managing leadership, establishing robust talent pool with focus on people and continuous improvement.
  • Mentored junior analysts on best practices for business analysis techniques, fostering professional growth within team.
  • Recruited new members for business analysis team to support division growth and create strong and productive department, replacing underperforming staff.
  • Analyzed open orders, backlog, and sales data to provide sales team with insights.
  • Generated ad-hoc reports to evaluate specific business requirements.

Business Analyst

Think and Learn Pvt ltd
06.2018 - 05.2023
  • Snowflake
  • AWS - S3,EC2
  • Matillion, Managed MySQL databases for sales analysis and customer segmentation, writing complex
  • SQL queries (including Joins to extract actionable insights)
  • Designed and implemented ETL processes using Matillion to integrate diverse data sources into Snowflake.
  • Conducted data analysis using Python, Numpy, Pandas, Seaborn, and Matplotlib to analyze student performance metrics and course effectiveness
  • Developed Power BI dashboards to visualize and monitor KPIs, supporting data-driven decision-making and strategic planning
  • Enhanced business intelligence capabilities through advanced analytics and reporting solutions.
  • Implemented best-practice methodologies that improved overall project delivery timelines while maintaining quality standards.
  • Interacted with internal customers to understand business needs and translate into requirements and project scope.
  • Conducted market research studies, providing valuable insights for strategic planning initiatives and competitive positioning efforts.
  • Created dashboards to monitor and track key performance indicators.
  • Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
  • Streamlined data processing for faster results by implementing advanced analytics tools.
  • Identified patterns and trends in large data sets and provided actionable insights.
  • Developed customised reports, summarising and presenting data in visually appealing format.
  • Developed complex dashboard and reporting tools to track business performance metrics.

Junior Analyst

HCL
02.2016 - 01.2018
  • Third party for HCL
  • Utilized Python for time series analysis and data manipulation, forecasting trends in student enrollment and course availability
  • Analyzed customer reviews using NLP techniques to improve user experience and satisfaction, visualizing insights using Matplotlib and Seaborn
  • Developed interactive Power BI dashboards to track educational metrics and optimize resource allocation.
  • Evaluated historical financial data to identify patterns and trends that informed future projections, enabling proactive decision-making among management teams.
  • Leveraged advanced data analysis tools and techniques, such as SQL querying and Python programming, to extract valuable insights from large datasets.
  • Provided administrative support to senior analysts and department professionals.
  • Supported senior analysts with ad-hoc data analysis requests, ensuring accurate results were delivered in timely manner.

Interests

Public Speaking

Data Insights

UI/UX

Education

B.Tech - Electrical and Electronics EngineeringBPUTElectrical and Electronics Engineering

BPUT
Rourkela
2014

Skills

  • Snowflake
  • SQL
  • Power BI
  • Matillion
  • Python
  • Pandas
  • Numpy
  • Seaborn
  • Matplotlib
  • Statistical Data analysis
  • AWS
  • Data Visualization
  • Exploratory Data Analysis
  • GitHub
  • Data Analysis Expertise
  • SQL Proficiency
  • KPI Tracking
  • Reporting skills
  • Customer Service
  • Sales Reporting
  • Business process understanding
  • CRM Management
  • Quantitative Analysis
  • Sales Metrics
  • Data Cleaning
  • ETL processes
  • Data Storytelling
  • Web Scraping
  • Statistical Analysis
  • Operations Analysis
  • Customer Needs Assessment

Certification

Master Data Analyst By Ineuron

Certified In Matillion and Snowflake by Analytics with Anand

Timeline

Senior Business Analyst

StudyIq
06.2023 - 01.2024

Business Analyst

Think and Learn Pvt ltd
06.2018 - 05.2023

Junior Analyst

HCL
02.2016 - 01.2018

B.Tech - Electrical and Electronics EngineeringBPUTElectrical and Electronics Engineering

BPUT

Similar Profiles

CREATE PROFILE
RM MOHANTYData Analyst