Sharmi

Ph: +1-971-***-****

Email: ad30my@r.postjobfree.com

PROFESSIONAL SUMMARY:

3+ years of experience in Power BI, Tableau and SQL Server.

Experience in Data Modelling, Database Design and Implementation of Database systems using SQL Server

work knowledge in handling huge databases and worked on performance tuning and query optimizations.

Involvement in the creation, design, implementation and analysis of SQL Server database systems, queries, and processes.

Practical knowledge of SQL-based data modeling techniques like Star-Schema Modeling and Snowflake Schema Modeling.

Possessing expertise with stored procedures, triggers, views, user defined functions, sub-queries, and joins.

Experience in creating Microsoft Power BI reports, dashboards, and publishing to end users.

Working understanding of developing and publishing dashboard reports in the Power BI service and scheduling the dataset to be refreshed for upcoming data.

Experience in writing DAX Expressions to construct new tables, measures, and calculated columns on the Power BI desktop.

Creating the data modeling in Power BI desktop

To check both static and dynamic data for data validation, concurrent SQL queries were created and analyzed in Tableau Desktop.

Used Tableau's advanced chart visualizations, including dual axis, box plots, bullet graphs, tree maps, bubble charts, and waterfall charts, to create interactive dashboards and visualizations to solve challenging challenges.

Involved in transforming complex business requirements into data visualizations using Tableau.

Developing interactive Tableau visualization and delivering reports to Business team on timely manner.

Experience on how to build and use stored procedures, triggers, views, user defined functions, sub-queries, and joins.

Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative, and the ability to think outside the box.

Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS:

BI Reporting Tools

Tableau Desktop, Power BI

Business Skills:

Business Definition Requirements, Business Process Analysis

Scripting Languages

SQL, Python

WORK EXPERIENCE:

Company: Yogic Ripples Pvt Limited, Hyderabad, India July’ 21– March’ 22

Role: Data Analyst

Responsibilities:

Created interactive dashboards using Power BI with business requirement documents that help users of the business to make better data-driven decisions.

Responsible for developing a Star flake schema model, assisted in optimizing for querying huge datasets, resulting in faster aggregations and easier period-over-period.

Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.

Made sure that standards and best practices in database development were followed and maintained.

Defined and designed the data sourcing and data flows, data quality analysis.

Designed and Implemented the Stored Procedures and Triggers for automating tasks.

Using Power Query to convert data and connect numerous data sources allowed the team to swiftly produce reports and insights.

Designed, developed, tested, maintained Tableau functional reports based on the user requirements.

Participated in writing SQL queries for Data Loading along with the databases team.

Data Manipulation and Extraction using Alteryx from various data sources, which in turn is used to feed data into Tableau.

Design, development, and deployment of Tableau reports on Tableau Online

Gathering the requirements from business and creating the Business Requirement Document (BRD).

Worked on development of SQL and stored procedures on MYSQL.

Effectively communicated with the external vendors to resolve queries.

Performed tuning of reports and resolving issues with Tableau Server.

Worked in creating and modifying the worksheets and data visualization dashboards.

Worked on development of SQL and stored procedures on MYSQL.

Data was managed and stored by running SQL Server stored procedures using Power BI Parameters, allowing for flexible data reuse.

Interacted with corporate clients, gathered their needs, and provided comprehensive data and reporting solutions, taking responsibility for the design, creation, and upkeep of ongoing metrics, reports, analyses, and dashboards that serve as the basis for important business decisions.

Company: Yogic Ripples Pvt Limited, Hyderabad, India July’ 20– June’ 21

Role: BI Data Analyst

Responsibilities:

Responsible for creating tables using constraints, creating new stored procedures and views.

Data cleaning, transformation, conversion, aggregation, and merging were put into practice.

Implemented join statements, including Inner, Outer-Joins and Self-joins.

Experience in creating worksheets and dashboard using multiple measures with Tableau.

Responsible for documenting the business requirements given by clients which helped team to build worksheets with Tableau.

Responsible for documenting the functional documents which helped the client to gain knowledge on the functionality of the report.

EDUCATION:

Southern New Hampshire University, NH, USA 2022-2023

Master of Science, Business analyst GPA: 4.0

MRITS Hyderabad, India 2017-2021

Bachelor of Technology, Information Technology GPA: 3.2

Contact this candidate