Data Analyst Entry Level

SIMNA ANAND

NEW JERSEY, USA

MOBILE: +1-732-***-**** E-MAIL: ************@*****.***

OBJECTIVES:

Motivated and detail-oriented data analyst seeking an entry-level position to leverage strong analytical and problem-solving skills in extracting valuable insights from data. Eager to contribute to a dynamic team and apply academic knowledge to real-world data challenges.

SKILL SET

Data Analysis: Proficient in analyzing complex data sets, identifying patterns, and extracting meaningful insights. Experience with analysis and data visualization.

Good knowledge in Excel, Power query and Power Pivot

Data Visualization: Skilled in creating visually appealing and interactive dashboards using tools like Power BI, Excel, And Tableau

Good knowledge in SQL

Problem Solving: Strong analytical and critical thinking abilities to identify issues, troubleshoot problems, and propose effective solutions.

Communication: Excellent verbal and written communication skills, with the ability to present complex data findings to non-technical stakeholders

TECHNICAL SUMMARY

EXCEL

Proficient in Microsoft Excel for data analysis and manipulation.

Experienced in organizing and cleaning data using Excel's functions and features.

Skilled in creating data visualizations and reports through Excel charts and pivot tables.

Knowledge of advanced Excel functions, including VLOOKUP, HLOOKUP, and IF statements.

Familiar with data modeling and forecasting using Excel.

Strong understanding of data visualization.

SQL

Good knowledge in creating Tables and Maintaining data clearly.

Good knowledge in query writing -Sub queries & Derived Tables.

Extensive database programming knowledge in writing MySQL Joins, Views, Stored procedures, triggers, Functions, and Indexes.

TABLEAU

Proficient in Tableau for data visualization and reporting.

Created interactive dashboards to present data insights effectively.

Skilled in data connection, transformation, and data source management in Tableau.

Knowledge of basic calculations, parameters, and filters for dynamic reporting.

Familiar with mapping and geographical data visualization

Able to generate actionable insights from data

Eager to expand Tableau skills and contribute to data-driven decision-making

POWER BI

Retrieved data from multiple sources.

Hands on knowledge in Power Query Editor.

Capable in Developing Complex Power BI Dash boards/reports.

Good knowledge of writing DAX queries.

Worked on all types of records like Parameterized, Metrix, charts, Sub reports, Drill down, Drill through, Document Map etc.

EXPERIENCE

FUSION BEADS DESIGNER BOUTIQUE - FOUNDER/OWNER, DESIGNER - MARCH 2014 – SEP 2022

Launched and successfully operated an upscale dress boutique, specializing in Customized designer dresses.

Oversaw all aspects of the business, including business planning, budgeting, inventory management, and marketing strategies.

Developed a brand identity, ensuring a unique and desirable shopping experience for customers.

Leveraged Amazon, social media platforms, and digital marketing techniques to increase brand awareness and reach a broader customer base.

Established and maintained relationships with vendors and suppliers, negotiating favorable terms and ensuring quality products and timely deliveries.

Implemented Exhibition strategies to enhance product presentation and drive sales.

Provided exceptional customer service, building and fostering long-term relationships with clients, resulting in a high rate of repeat business and positive reviews.

Managed a team of 3 employees, providing leadership, training, and ongoing support to ensure a cohesive and motivated workforce.

FIDELITY NATIONAL FINANCIALS -

TEAM MEMBER -

APRIL 2010 – MARCH 2011

Analysis of Business requirements, identifying the test areas, test case preparation, Test case review, Test execution, bug reporting, retesting, regression testing, smoke testing

EDUCATION

Certification in Data Analytics from ExcelR Solutions, New York, US (2023)

IBM CEP certification in Data Visualization

Graduated in Computer Engineering from Nettur Technical Training Foundation, Bangalore, India (2010)

PROJECTS

Project

Domain

Olist Store Analysis September 2023

E-Commerce

Description

The Olist Store Analysis project aims to analyze customer purchasing patterns and payment statistics on an E-commerce platform, Olist. This project covers several key performance indicators (KPIs) such as weekday vs weekend sales, payment statistics, delivery time, and customer behavior. The analysis is based on nine CSV files, which are cleaned and manipulated to extract valuable insights.

Role

Technical Environment

Excel, Power Query, Power Pivot, Power BI, Tableau, SQL, Power point

Contact this candidate