Data Analyst Analysis

Simran Dhoju

New York 475-***-**** ***********@*****.*** https://www.linkedin.com/in/sdhoj/

Time Series Analysis of buses and passenger

Consolidated more than 100 (125-150) datasets into one and explored the data for missing values. Identified the historical trends for the number of passengers and buses using (SSA) and OLS for decision-making. Data Management, Data Analysis, Report Generation, Data Visualization, Business Intelligence JavaScript, HTML, CSS, Java, C, C++, Jira, Git, GitHub, AWS, MS Office Python, R, Microsoft Excel, ETL, SQL Server, MySQL, SSRS, SSIS, Tableau, Microsoft Power BI, Visio, PowerPoint, Looker, Qlik Sense, AWS Quicksight,

Women in Data (WID), Women in Tech (WID), Beta Gamma Sigma Developed and implemented advanced data cleaning scripts using R and Python, streamlining manual efforts by 30% and improving data accuracy by 20%.

Collaborated with cross-functional teams to identify areas for process improvements through data visualization showing KPIs in the Power BI dashboard, resulting in a 30% reduction in operational costs. Managed a database of 1000000+ user records, ensuring data integrity and accuracy for effective reporting and analysis. Integrated multiple data sources into cohesive data sets, leading to a 20% increase in report generation efficiency. Coordinated with the development team to successfully migrate over 1,000,000 records to the AWS database, resulting in a 50% increase in data retrieval speed and efficiency.

.

Implemented automated ETL scripts with SSIS for data transformation from relational databases to data warehouses, achieving a 20% improvement in processing efficiency. Visualized KPI dashboards for stakeholders to address target clients for email marketing resulting in a 30% increase in event attendees than last year.

Conducted in-depth data analysis using Excel, Power Pivot, and SQL to identify trends and patterns, resulting in a 15% increase in customer retention rates.

Participated in a team project to enhance data quality, achieving a 20% improvement in data accuracy. Analyzed customer feedback on in-house applications, leading to a 20% enhancement in custom features for the users. Presented feasibility studies and technical requirement documentation for new development products contributing to a smoother development lifecycle.

Captured and documented functional and technical requirements by directly liaising with stakeholders, resulting in a 15% reduction in project kick-off time.

Developed and executed test plans, identifying and resolving critical defects that resulted in a 40% increase in overall product quality.

Utilized Excel to clean data by removing outliers, identifying null, and validating data integrity to generate actionable insights. Calculated key metrics such as revenue and profit margins to track business progress and strategize for revenue enhancement Meri Skill

Yeslab Design Studio

Business Analyst

Tribhuvan University

Bachelor of Science in Computer Science

Untapped Potential Inc

Data Analyst Intern

WORK EXPERIENCE

Cual Corp

Marketing Analyst

EDUCATION

University Of New Haven

Master of Science in Business Analytics (GPA: 4 out of 4) SKILLS & MEMBERSHIP

Skills:

Technical Skills:

Analytical

Skills

Membership:

:

PROJECT/ VOLUNTEER EXPERIENCE

Port Authority NY and NJ

CA

Jun 2024 - Present

NY

NY

CT

West Haven, CT

Nepal

Mar 2020 - Oct 2021

Jun 2023 - Dec 2023

Contact this candidate