Proficient in building interactive Power BI dashboards, utilizing Power Query for data cleaning, DAX for calculations, and creating reports to analyze key performance metrics.

Power BI

Skilled in managing relational databases, writing advanced SQL queries, and optimizing performance through indexing, normalization, and data integrity practices.

Skilled in data analysis, cleaning, and visualization using advanced Excel tools like Pivot Tables, LOOKUP functions, and charts for actionable insights.

Spreadsheets

<ul><li>Gold Medal in Science Olympiads, Secured 3rd position Scient Fabio E-quiz competition.</li><li>Wrote a research paper in the field of Biotechnology</li><li>Served as the Secretary of the Biotech Club, successfully organizing multiple events and coordinating team&nbsp;activities.</li></ul>

Bachelor of Science

Biotechnology

Intermediate (Class XII)

Biology

Matriculation (Class X)

Mathematics

<ul><li>Conduct internal audits to ensure compliance with policies, regulatory standards, and SOPs.</li><li>Analyze data trends and provide insights to management, assisting in forecasting and strategic planning. </li><li>Skilled in ADVANCED EXCEL, data visualization, and presentation techniques.</li><li>Skilled in MYSQL utilizing JOINS and SUBQUERIES to extract and manipulate data for actionable insights.</li><li>Skilled in building interactive POWER BI dashboards and applying DAX formulas to transform data into visually compelling reports and update and monitor Key Performance Indicators (KPIs) for accurate reporting and decision-making.</li><li>Collaborate with cross-functional teams (Finance, Airports, Engineering, CX) to ensure data integrity and alignment with business objectives.</li></ul>

Data Science & Analytics

Data Analyst (Internal Audit & Compliance)

<ul><li>I worked on collecting, cleaning, and analyzing educational data to support business decisions.</li><li>I frequently used SQL and Excel to extract, organize, and process data. </li><li>One of my key contributions was creating dashboards and reports that highlighted important trends in student performance and business metrics. </li><li>In addition, I participated in stakeholder meetings, which gave me practical exposure to how data insights are applied in decision-making.</li></ul>

Data Analyst(MIS) Intern 

India

Detail-oriented Data Analyst with expertise in data visualization, business intelligence, and CRM systems. Proficient in Power BI, SQL, and Advanced Excel, with a strong ability to streamline reporting processes, enhance data accuracy, and generate actionable insights. Experienced in internal audit support, KPI tracking, and collaborating with cross-functional teams to drive business performance and organizational growth. Skilled in utilizing Salesforce CRM to optimize customer operations and deliver data-driven recommendations.

<ul><li>Enhanced customer experience at Amazon by identifying opportunities to reward customers and optimize their shopping journey through discounts and Prime perks. </li><li>Cleaned and prepared data using Power Query Editor, removing duplicates, handling missing values, and creating custom columns. Applied DAX formulas to compute key metrics and built interactive Power BI reports to support data-driven decisions.</li><li>Tools: Power BI, Power Query Editor, SQL, Microsoft Word.</li></ul>

Amazon Sales Analysis 

<ul><li>Analyzed Instagram users data to classified users based on activity levels to identify re-engagement strategies and analyzed photo uploads and engagement metrics to boost user-generated content. </li><li>Identified high-engagement users as potential influencers and provided data-driven recommendations to improve Instagram’s engagement, retention, and acquisition through personalized marketing.</li><li>Tools: SQL, Microsoft Excel, PowerPoint.</li></ul>

Social Media Analysis

<ul><li>Developed interactive Excel dashboards using Pivot Charts and slicers to visualize metrics like ratings, engagement, and pricing trends. Conducted in-depth analysis of restaurant distribution, competition, and customer preferences across countries.</li><li> Provided data-driven recommendations on pricing, cuisine strategies, and operational enhancements like table booking and online delivery.</li><li>Tools: Microsoft Excel, Word, PowerPoint.</li></ul>

Shivani TiwariIndia

Social Accounts

Achievements

Projects

Amazon Sales Analysis

Social Media Analysis

Zomato Restaurants Analysis

Experience

Data Analyst (Internal Audit & Compliance)

Data Analyst(MIS) Intern

Education

Manipal University, Jaipur, Rajasthan

DAV Public School, Bariatu, Ranchi, Jharkhand

Saraswati Vidya Mandir , Buxar, Bihar

Certificates

Power BI

SQL

Spreadsheets

Skills