Anuj Lohala
I'm Designer
About Me
Data professional with over 5 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
Resume
Summary
Anuj Lohala
Data Analyst / BI Specialist with over 5 years of experience in designing and optimizing Power BI dashboards, advanced DAX calculations, and scalable data models. Adept at transforming complex business requirements into clear, actionable insights that drive strategic decision-making and improve operational efficiency. Skilled in SQL, ETL processes, and data transformation, with a proven record of delivering accurate, visually compelling, and performance-optimized analytics solutions for international clients and organizations.
- Madhyapur Thimi, Nikosera, Bhaktapur
- +977 9849728879
- [email protected]
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
Power BI Trainer and Consultant
Aug, 2025 - Present
FE+ Business Solution (ROSA UNICEF, UNDP)
- Delivered hands-on Power BI training sessions to staff from UNICEF and UNDP across the Regional Office of South Asia, Kathmandu head office and Bhairahawa field office, supporting both local and internationals teams.
- Conducted customized workshops for foreign and local staff members, ensuring participants gained practical, job-ready reporting skills.
- Provided in-depth training covering Power Query, Data Modeling (star schema, fact/dimension), DAX (calculated columns, measures, time-intelligence), Modern Visualization Concepts, and Power BI Service (publishing, workspaces, RLS, collaboration).
- Designed and facilitated real-world case studies and practical exercises using program-related datasets, enabling participants to build, publish, and share impactful dashboards.
- Supported project teams in a BI support and advisory role, assisting with report troubleshooting, performance optimization, data model improvements, and best-practice guidance during and after training engagements.
- Recognized for the ability to simplify complex BI and analytics concepts into clear, actionable lessons, significantly improving data literacy and self-service reporting adoption among non-technical staff.
Analytical Engineer (Azure Synapse & Power BI)
Jan, 2025 - Aug, 2025
Frost Digital Venture ('Frost & Sullivan', Arizona, USA)
- Joined a large-scale Domo-to-Azure migration project, supporting over 40+ international client projects, moving ETL pipelines and dashboards from Domo to Azure Synapse Analytics and Power BI.
- Conducted in-depth analysis of existing Domo projects, including ETL logic, dataflows, and dashboard design, collaborating closely with original data engineers and project teams to understand business logic and data requirements.
- Migrated ETL processes and analytical queries into Azure Synapse Analytics, ensuring data accuracy, scalability, and improved performance.
- Developed and optimized Power BI dashboards with advanced DAX calculations and modern visualization techniques to meet updated business and reporting requirements.
- Collaborated with stakeholders to gather new requirements, refine KPIs, and ensure dashboards aligned with client expectations and global standards.
- Built reusable data models and self-service BI frameworks, enabling faster development cycles, consistent reporting, and improved adoption across client organizations.
- Leveraged SQL and DAX extensively to transform, model, and analyze large datasets for reporting and decision-making.
- Recognized for the ability to translate complex Domo logic into optimized Synapse models and Power BI dashboards, ensuring smooth migration and high-quality analytics outputs.
Data Analyst
Jan, 2022 - Jan, 2025
Four Symmetrons Innovation (Plieger Group, Zaltbommel, Netherlands)
- Developed and optimized interactive Power BI dashboards for sales and logistics, enabling data-driven decision-making and operational efficiency.
- Developed a logistics dashboard to monitor key metrics, including incoming goods, inventory levels, and delivery timelines, improving supply chain efficiency by 25%.
- Built sales performance dashboards analyzing revenue trends, customer behavior, and identifying growth opportunities, supporting strategic sales planning.
- Developed campaign dashboards focusing on daily or weekly sales performance, helping the sales team track promotions, special offers, and seasonal campaigns effectively.
- Served as a BI and data engineering lead, extracting and transforming data from Oracle SQL databases using Azure Data Factory and Dataflows, and loading it into Azure Synapse Analytics for enterprise reporting.
- Built robust and scalable data models in Synapse, supporting automated reporting and self-service Power BI dashboards for internal teams.
- Collaborated with cross-functional teams to ensure dashboards met business requirements and supported operational and sales process optimization.
- Leveraged SQL, DAX, and advanced Power BI visualizations extensively to translate raw data into actionable insights for management and operational teams.
- Played a critical role in integrating multiple data sources, improving accuracy, consistency, and performance of reporting for company-wide decision-making.
Data Analyst & Integration Specialist
Jun, 2020 - Jan, 2022
Four Symmetrons Business Consulting
- Led data enrichment projects for clients like Plieger Groep and Black & Decker, collecting, standardizing, and enhancing product, supplier, and color data for the Product Information Management (PIM) system, including attributes such as categories, specifications, SKU details, pricing, dimensions, and color variants to ensure data completeness and usability across sales and logistics.
- Integrated multiple data sources including ERP systems, supplier feeds, CSV/Excel files, and internal databases into unified, high-quality datasets for reporting, analytics, and decision-making, improving consistency, accuracy, and accessibility of enterprise data.
- Performed SQL-based data analysis and transformation, identifying missing or inconsistent records, validating data accuracy, and preparing it for analytics.
- Designed and implemented data cleansing, standardization, and transformation processes, ensuring consistent and accurate product, supplier, and inventory data across systems.
- Developed and optimized Power BI dashboards and reports to monitor data completeness, consistency, and accuracy in the PIM system, ensuring reliable and actionable insights.
- Provided business insights into product attributes, supplier coverage, and inventory quality, supporting operational and strategic decision-making across teams.
- Tracked data enrichment progress and enabled stakeholders to quickly identify gaps, inconsistencies, and anomalies, improving the overall reliability and quality of the PIM system.
- Applied best practices in data modeling, fact/dimension design, and DAX calculations to create performance-optimized dashboards that were both scalable and actionable for business users.
Data Analyst Intern
May, 2019 - Jun, 2020
Four Symmetrons Business Consulting(Dept Agency, Netherlands)
- Assisted in data collection, validation, and cleaning of large datasets, preparing them for reporting and analytics.
- Wrote and executed SQL queries to validate data integrity, identify anomalies, and ensure high-quality datasets for reporting and dashboards.
- Gained hands-on experience in end-to-end Power BI solutions, including Power Query for data transformation, data modeling and fact/dimension design, DAX calculations, and advanced visualization techniques.
- Contributed to building and preparing datasets for Power BI dashboards, enabling stakeholders to monitor KPIs, track trends, and make informed decisions.
- Performed data quality checks and documentation, improving reporting accuracy and supporting BI process adoption across the team.
- Developed practical skills in data modeling, transformation, and visualization best practices, establishing a strong foundation for a career in analytics and BI.
Portfolio
- All
- Power BI
- Data Engineering
- Data Analysis
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.