Shikha Upneja
Data Analyst
Dallas,Tx
Summary
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
Overview
5
5
years of professional experience
2
2
years of post-secondary education
6
6
Certifications
Work History
Data Analyst
UEIBI Private Limited
Irving, TX
07.2020 - Current
- 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
- 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
07.2019 - 06.2020
- 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.
- 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
Education
Master of Science - Mathematics
University of Bikaner
Rajasthan 07.2006 - 05.2008
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
Analytical Problem Solving
SQL
Reporting Tools
ETL processes
Data Analysis
Certification
Business Analytics with Excel
Timeline
Data Analyst
UEIBI Private Limited
07.2020 - Current
Jr Data Analyst
CTAC Services Pvt Ltd
07.2019 - 06.2020
Master of Science - Mathematics
University of Bikaner
07.2006 - 05.2008