Data Analyst Power Bi
Resume:
Work History
Data Analyst
Shikha
Upneja
Contact
Address
Dallas, Tx 75063
Phone
******.********@*****.**
m
WWW
https://bold.pro/my/shikha-
upneja-240*********/731
Skills
Data Analysis
Excel/ Google Sheets
Power BI
Tableau
MY-SQL
Database programming
and SQL
Data Visualization and
Presentations
Report Writing
Data Modeling
DAX
Technical Analysis
Skilled and detail-oriented data analyst with a certificate in data analytics and visualization and over 4.6 years of experience across multiple projects,Proficient in Power-BI, SQL,Microsoft Excel with a passion for working with complex data to develop creative solutions. A collaborative team player with excellent communication skills,currently pursuing Tableau certification to further enhance skills Data Analyst
UEIBI Private Limited, Irving, TX
Built out data and reporting infrastructure from
ground up using Power BI and SQL to provide
real-time insights into product, marketing funnels, and business KPIs
Successfully designed and developed advanced
SQL queries, views, functions, CTE, constraints and stored procedures to meet business requirements
Utilized Advance Excel functions (vlookup, pivot & Macros, countifs, concatenate etc) to analyze large datasets & generate comprehensive reports for
management
Support, maintenance, and troubleshooting for
databases, SQL Queries
Accountable for implementation of ETL (Extract,
Transform and Load) processes using SAS to load
data from multiple sources (excel, Sharepoint,
database) to staging tables and develop SQL Script to load data to support data analysis and reporting and ensure that all data is loaded correctly in
database
Created complex Power BI reports and dashboards
which includes leveraging multiple sources for
business and improved operational efficiency
Developed different chart types including Pie chart, Bar chart, Line Chart, Scatter Plot and matrix
Also used DAX functions to create measures and
columns
Imported data from different sources in different
formats such as Excel, CSV to transform, clean and validate the data and load the data into database
2020-07 -
Current
Analytical Problem Solving
SQL
Reporting Tools
ETL processes
Data Analysis
Developing queries, executing scripts, reports, and monitoring
Maintained SQL scripts and complex queries for
analysis and extraction
Involved in the continuous enhancements and fixing of production problems
Managing yearly company profit and loss related
data sheets and calculating overall revenue of the company
Developed and Maintain Sql Scripts, Views,
Functions, Procedures to work seamlessly based on
business requirements
Preparing daily order sheets in Microsoft excel and submitting to backend system
Hands-on experience on RDBMS like MS-SQL.
Provided actionable insights through comprehensive reports and dashboards, supporting strategic
initiatives
Presented findings to executive leadership teams
through concise presentations, influencing future
strategy development
Enhanced business efficiency by identifying trends and patterns in complex datasets
Streamlined data processing for faster results by
implementing advanced analytics tools
Jr Data Analyst
CTAC Services Pvt Ltd, Jaipur, NE
Maintained SQL scripts and complex queries for
analysis and extraction. Involved in the continuous enhancements and fixing of production problems.
Managing yearly company profit and loss related
data sheets and calculating overall revenue of he
company
Developed and Maintain Sql
Scripts,Views,Functions,Procedures to work
seemlessly based on business requirements
Preparing daily order sheets in Microsoft excel and submitting to backend system
Participated in project planning meetings, ensuring that data requirements were clearly defined and
understood by all team members involved.
2019-07 -
2020-06
Education
Certifications
Enhanced data accuracy by meticulously cleaning
and organizing datasets for analysis
Facilitated data-driven decision making by creating custom reports tailored to stakeholder needs and
preferences
Master of Science: Mathematics
University of Bikaner - Rajasthan
2006-07 -
2008-05
Business Analytics with Excel
Python
Tableau
Master program of Data Analyst
Power BI
My Sql
Contact this candidate