Skills
Featured Projects
Excel | Tableau | Power BI | SQL | Python | R
Nepal Tourism Economic Analysis🛫🗻🏞
Capstone Project
◾ Used SQL to query 25 years of visitor data and Excel for trend modeling. Identified a shift to adventure tourism post-COVID, providing data that informed a proposed marketing strategy focused on trekking packages to accelerate sector recovery.
🍔 DoorDash Marketing Project
Excel | Exploratory Data Analysis | Data Storytelling
◾ Real world-marketing campaign data
◾ Using only Excel for analysis and data visualization
◾ Utilized VLOOKUPS, Pivot Tables, Scatter Plots, & Bar Charts
◾ Provided a comprehensive write up to help the marketing team on their next campaign
🏥 Analyzing Hospital Data with SQL
SQL| Exploratory Data Analysis
◾ Analyzed what affections hospital stay length in MySQL
◾ Created a histogram using SQL (weird, I know)
◾ Real data from over 101,000 hospital patients
🏀 Analyzing NBA Data with Tableau
Tableau | Dashboarding
◾ Analyzed the 2022 NBA season statistics
◾ Created Stacked Bar Charts, Heatmaps, Treemaps & Bubble Charts
◾ Built a Tableau story & shared via written report
⛏️Analyzing Mining Data with Python
Python | Data Analysis
◾ Cleaned and preprocessed industrial dataset with 737,454 rows for analysis
◾ Used Python for statistical summaries, correlation matrices, and data visualizations
◾ Created line plots, pair plots, and correlation matrix to examine trends and relationships
About me
Data Analyst I Business Analyst I Healthcare Analyst
👋 Hi, I'm Omhari Gurung | Data AnalystI am a results-driven analyst with over eight years of experience turning business data into actionable strategies and measurable profit. My background in business operations and financial analysis is powered by a deep proficiency in SQL, Excel, Tableau, and Python. I specialize in building models, creating dashboards, and uncovering insights that directly improve forecasting, optimize processes, and drive revenue growth.I am now formally advancing my career in data analytics, seeking to apply my blend of business acumen and technical skill to help companies make smarter, data-informed decisions.Core Competencies & Tools:· Data Analysis & Visualization: Advanced Excel (PivotTables, Macros, Financial Modeling), SQL, Tableau, Power BI
· Programming & Analytics: Python (Pandas, NumPy), R
· Business Intelligence: Process Optimization, KPI Development, Financial Forecasting, Data Storytelling
· Tools & Platforms: ChatGPT Advanced Data Analysis, Google WorkspaceProfessional ExperienceNaandkul Farm | Birendranagar, Nepal
Business Operations Analyst | April 2017 – April 2025· Drove Profitability: Analyzed financial, sales, and operational data to identify inefficiencies, leading to strategic initiatives that increased profitability by 15% within 12 months.
· Built Forecasting Models: Developed a dynamic budgeting and pricing forecast model in Excel, improving financial forecasting accuracy by 20% and enhancing budgetary control.
· Automated Reporting: Spearheaded a new data tracking system, standardizing reports and reducing monthly financial analysis time by 10 hours.
· Enabled Data-Driven Decisions: Designed and delivered interactive KPI dashboards for management, providing clear visibility into business performance and informing strategic planning.Sakhsham Knowledge Services | Lucknow, India
Data Management Specialist | July 2015 – January 2017· Ensured Data Integrity: Executed data entry, validation, and quality control procedures, implementing new protocols that reduced data input errors by 30%.
· Improved Processes: Optimized data handling and documentation workflows to increase department efficiency.Crossdomain Solutions Pvt Ltd | Bengaluru, India
Senior Process Auditor | February 2010 – May 2015· Optimized Workflows: Analyzed operational processes to pinpoint bottlenecks, recommending solutions that improved team efficiency by 15%.
· Enhanced Quality: Authored performance reports that identified root causes of errors, leading to targeted training that reduced error resolution time by 25%.