Skills
Excel | Tableau | Power BI | SQL | Python | R
Featured Projects
Nepal Tourism Economic Analysis🛫🗻🏞
Capstone Project
◾ Used Excel to clean the data, filling these gaps with the median values
◾ Used SQL for data extraction and Exploratory Data Analysis.
◾ Created visualizations using Tableau to highlight trends and relationships.
🍔 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 Om & welcome to my portfolio! Driven by my passion for data and analytics, I am transitioning into data analytics to leverage my analytical mindset and process improvement skills in a new and exciting way. I am proficient in data analysis, financial planning, and identifying trends that drive decision-making.I'm proficient in analyzing data with:
- Excel
- Tableau
- SQL
- Python
- R
And I'm looking to help a company extract insights from their data. If you'd like to contact me, feel free to reach out via LinkedIn or email me: [email protected]PROFESSIONAL EXPERIENCENaandkul Farm, Birendranagar, Nepal Apr 2017 – Present
Business Owner● Oversee daily financial operations, including accounts payable, receivable, payroll, and financial reporting, ensuring accuracy and compliance.
● Develop and implement financial strategies, resulting in a 15% increase in profitability through improved budgeting and forecasting.
● Monitor and analyze financial performance, identifying trends and making data-driven recommendations for operational improvements.Sakhsham Knowledge Services, Lucknow, India Jul 2015 – Jan 2017
Data Entry Specialist● Conducted data cleansing and validation, achieving a 30% reduction in data errors and significantly enhancing data quality
● Developed and implemented new data entry procedures, resulting in a 20% increase in productivity.
● Audited production reports to track data entry and processing errors, improving overall operational efficiencyCrossdomain Solutions Pvt Ltd, Bengaluru, India Feb 2010 – May 2015
Senior Process Auditor● Created detailed reports on process performance metrics for senior management, facilitating informed decision-making.
● Collaborated with cross-functional teams to troubleshoot and resolve data entry errors, reducing error resolution time by 25%.
● Assisted in onboarding new employees by providing comprehensive training materials and guidance, enhancing team performance
● Data Entry Specialists consistently maintained a 99% accuracy rate