Anuj Lohala

I'm Designer

About Me

Data professional with over 4 years of experience specializing in data analytics, engineering, and visualization. Expertise in SQL, Python, Databricks, Azure Synapse Analytics, Power BI, and DAX, with a strong focus on data modeling and performance optimization. Proven ability to design and develop interactive dashboards, streamline data workflows, and transform complex business requirements into actionable insights. Adept at delivering data-driven solutions in collaborative team environments, with a consistent track record of enhancing decision-making processes and driving business value through advanced analytics.

Skills

SQL 90%
Python 75%
Power BI 100%
DAX 80%
JavaScript 55%
Tableau 80%

Resume

Summary

Anuj Lohala

Data Enthusiast with over 4 years of experience, specializing in SQL, Python, Databricks, Synapse Analytics,Power BI, DAX and Data Modeling. Proficient in designing interactive dashboards and enhancing report performance. Strong track record of converting business requirements into actionable insights and delivering data-driven solutions within a collaborative team environment.

Education

Bachelor in Computer Science & Information Technology

2014 - 2018

Samriddhi College, Bhaktapur, Nepal

Completed a Bachelor's Degree in Computer Science with a focus on assignments in Java, Object-Oriented Programming, Artificial Intelligence, Big Data, Data Mining, Network Security, and Cloud Security.

Professional Experience

BI Analyst

2020 - Present

Four Symmetrons Innovation

  • Developed and optimized interactive Power BI dashboards for sales and logistics, driving informed decision-making.
  • Designed a logistics dashboard to monitor key metrics such as incoming goods, inventory levels, and delivery timelines.
  • Improved warehouse operations and inventory management through data visualization and tracking.
  • Created a sales dashboard to track sales performance, revenue trends, and customer insights.

Data Associate & Content Migration Specialist

2017 - 2018

Four Symmetrons Business Consulting

  • Data Enrichment Project (Plieger Groep): Enriched product, supplier, and color data for the PIM system.
  • Data Enrichment (Black & Decker, Facom): Updated product data in GS1 format through Data Circle.
  • Product Information Optimization (Plieger): Cleaned up duplicate product data to enhance the PIM system.
  • Web Content Migration (Dept Agency): Managed content migration for websites using W ordPress.
  • Web Content Management (Smart, Germany): Managed content on the Smart automotive site using Adobe Experience Manager (AEM).
  • Web Content Management (Inter Milan, 2023): Managed content for the Inter Milan website using Contentful.
  • Web Content Migration (ONVZ, Netherlands): Migrated content to a new CMS (Optimizely) to enhance user experience.
  • Frontend Tutor: Specialized in teaching HTML, CSS, JavaScript, and ReactJS.
  • Mendix Trainee: Gained hands-on experience in the Mendix platform for rapid application development.
  • Salesforce Trainee: Gained experience with Salesforce platform tools and processes.

Frontend Developer

2018 - 2019

Web Bank Nepal

  • Develop and maintain user-friendly, responsive web applications using HTML, CSS, JavaScript, and React JS.
  • Collaborate with UI/UX designers to implement intuitive, visually appealing designs.
  • Write clean, maintainable, and eficient code while adhering to best practices.
  • Integrate APIs and third-party services into web applications.
  • Optimize web applications for performance, scalability, and cross-browser compatibility.
  • Conduct testing and debugging to ensure high-quality code and user experience.
  • Stay updated with the latest frontend technologies and trends, and apply them to improve user experience.
  • Work closely with backend developers to ensure seamless frontend and backend functionality integration.

Website Developer Intern

2017 - 2018

Tech Devotees

  • Assist in the development and maintenance of web applications using PHP and MySQL.
  • Build and manage CRUD (Create, Read, Update, Delete) functionality for database-driven websites.
  • Work closely with senior developers to implement new features and improve existing functionality.
  • Troubleshoot and debug issues in applications.
  • Contribute to the design and architecture of web-based solutions.
  • Optimize website performance for speed and scalability.
  • Collaborate with the team to ensure responsive and user-friendly web applications.
  • Participate in code reviews and suggest improvements.

Portfolio

  • All
  • Power BI
  • Data Engineering
  • Data Analysis

Plieger Suitcase Day

Tube Day

Incoming Overview for Logistics

Daily Sales

SQL DataWarehouse Project

This project is a complete guide to building a modern data warehouse with SQL Server, covering design, ETL, data modeling, and analytics integration using the Medallion Architecture for scalability and efficiency.

Credit card transaction data analysis using SQL

Solved key data analysis questions on credit card transactions, uncovering insights on spending patterns and customer behavior using SQL

sales-advance-data-analytics

Advanced SQL analysis on sales data, covering change-over-time trends, cumulative analysis, performance tracking, part-to-whole contributions, data segmentation, and reporting to derive actionable insights.

Services

I provide end-to-end data solutions, including data engineering, analytics, and visualization. Services include building scalable ETL pipelines using Azure tools (ADF, Databricks, Synapse), designing interactive Power BI dashboards, optimizing data models, and transforming raw data into actionable insights to drive business decisions.

Data Pipeline Development

Design and implement scalable ETL/ELT pipelines using Azure Data Factory (ADF), Databricks, and Synapse Analytics to ensure seamless data integration and transformation.

Interactive Dashboard Design

Create visually compelling and interactive Power BI dashboards with DAX optimization to enable data-driven decision-making for stakeholders.

Data Modeling & Optimization

Develop efficient data models and optimize database performance to enhance query speed and reporting accuracy.

Cloud Data Engineering

Leverage Azure cloud services (ADF, Databricks, Synapse) to build and manage robust, scalable, and cost-effective data solutions.

Business Insights & Analytics

Transform raw data into actionable insights by analyzing trends, patterns, and KPIs to support strategic business decisions.

Data Workflow Automation

Automate repetitive data processes and workflows to improve efficiency, reduce errors, and ensure timely data delivery.

Testimonials

"Anuj has been an exceptional data analyst and Power BI developer, consistently delivering insightful reports and data-driven solutions. He expertise in analyzing complex datasets and creating impactful visualizations has significantly contributed to the team's success."

Anish Sthapit

Analytical Head

"It has been a pleasure working with Anuj Lohala, who stands out as a highly skilled data analyst and Power BI developer. His ability to transform raw data into actionable insights and their mastery of creating dynamic dashboards have been invaluable to our projects."

Sajal Raj Joshi

Senior Data Scientist

"Anuj is an outstanding data analyst and Power BI developer, demonstrating exceptional analytical skills and creativity in presenting data. His dedication to accuracy and delivering meaningful insights has made a remarkable impact on our team's decision-making processes."

Manin Shrestha

BI developer

"Anuj has consistently proven to be a reliable and talented data analyst and Power BI developer. He expertise in handling data and creating visually compelling dashboards has been instrumental in driving key business insights and achieving project success."

Ayush Pandey

Lead GenAI Data Scientist

Contact

Address

Madhyapur Thimi, Nikosera, Bhaktapur

Call Us

+977 9849728879

Loading
Your message has been sent. Thank you!