Learn Data Skills

Samrat Devkota

Certified

Data Analyst

Goldstar Stride | Kathmandu Nepal

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Certification

Introduction to Python

My New Certification

Introduction to SQL

My New Course

Introduction to Python

Data explorer, uncovering insights in the digital wilderness.

My Work

Take a look at my latest work.

course

Introduction to Python

certification

Introduction to Python

certification

Introduction to SQL

course

Introduction to Python

My Certifications

These are the industry credentials that I’ve earned.

Introduction to Python

Introduction to Python

Introduction to SQL

Introduction to SQL

Intermediate SQL

Intermediate SQL

Introduction to Excel

Introduction to Excel

Data Visualization in Excel

Data Visualization in Excel

Data Preparation in Excel

Data Preparation in Excel

Introduction to DAX in Power BI

Introduction to DAX in Power BI

Introduction to Power BI

Introduction to Power BI

Data visualization in Power BI

Data visualization in Power BI

Data Preparation in Power BI

Data Preparation in Power BI

Data Modeling in Power BI

Data Modeling in Power BI

DAX Functions in Power BI

DAX Functions in Power BI

Data Transformation in Power BI

Data Transformation in Power BI

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Kiran Shoes Manufacturers | Feb 2024 - Present

Lead MIS & Business Intelligence (CMD Office)

(Leading centralized business intelligence, analytics, and ERP reporting across multiple sister companies.) - Overseeing enterprise-wide data analytics & reporting for the CMD Office, ensuring data-driven decision-making. - Managing ERP data integration from SAP B1, Synergy ERP, IMS, and Bizom, providing real-time business insights. - Developing Power BI dashboards for sales, financial reporting, stock analysis, and production planning. - Automating data processes & forecasting models, increasing forecast accuracy by 20% and optimizing inventory planning. - Presenting executive reports on sales, fund flows, target tracking, and production vs. stock vs. sales to leadership.
Show More

Kiran Shoes Manufacturers | Feb 2023 - Feb 2024

Senior Data Analyst

(Expanded scope from sales analytics to company-wide data analysis & reporting.) - Extracted and analyzed sales, finance, and inventory data from SAP, Synergy ERP, and IMS. - Designed automated dashboards & reports using Power BI, SQL, and Excel, increasing reporting efficiency by 30%. - Provided real-time insights on sales trends, receivables (DSO), stock levels, and production tracking. - Developed target vs. achievement dashboards, leading to a 15% improvement in decision-making efficiency. - Optimized demand forecasting & inventory planning, reducing stockouts by 10% and improving production alignment.

Kiran Shoes Manufacturers | Oct 2022 - Feb 2023

Sales Data Analyst | Goldstar Shoes & Hathi Chhap Chappal

(Focused on sales data analytics, dealer performance tracking, and market trend forecasting.) - Analyzed sales data & dealer performance, identifying trends to improve regional sales strategies. - Developed target vs. achievement tracking reports, improving sales performance evaluation accuracy. - Automated Power Query & Excel-based reporting, reducing manual reporting workload by 20%. - Provided insights on dealer & regional sales performance, leading to a 10% improvement in efficiency.

Search Solutions Pvt Ltd | Nov 2021 - Oct 2022

Data Analyst | SSPL & Japan Tobacco International

- Automated reporting workflows using Power Query & Power Pivot, reducing reporting time by 30%. - Developed KPI dashboards to enhance sales team productivity, leading to a 25% efficiency improvement. - Extracted, transformed, and analyzed data from multiple sources to provide business insights. - Acted as a liaison between clients and field teams, ensuring seamless data- driven decision-making.

Search Solutions Pvt Ltd | Nov 2020 - Nov 2021

Central IT Operator | MIS

- Created and managed user accounts for field teams, ensuring seamless access to company applications. - Conducted app training sessions for employees, improving user adoption and efficiency. - Monitored field team activities in the app, ensuring proper data logging and workflow tracking. - Provided technical support to resolve operational issues, reducing downtime and improving team productivity. - Collaborated with the data team to automate reporting processes, leading to a transition into a Data Analyst role.

skventures | Jan 2020 - Jan 2021

Data Management Consultant

efficiency by 20% - Supervised sales and marketing teams with data-backed strategies, boosting sales performance

My Education

Take a look at my formal education

Master of Business Administration - MBA, Business Administration and Management, GeneralLincoln University College | 2024

About Me

Looking for a job as Data Analyst/BI Analyst

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free