Shikha Upneja
Dallas,Tx
Summary
To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Data Analyst
UEIBI Private Limited
10.2022 - 03.2023
- Built out the data and reporting infrastructure from the ground up using Power BI and SQL to provide real-time insights into the 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, 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 the 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 and used SAS to transform, clean and validate the data and load the data into the database
- Developing queries, executing scripts, reports, and monitoring.
Data Analyst
CTAC Services Pvt Ltd
07.2015 - 12.2016
- Maintained SQL scripts and complex queries for analysis and extraction
- Involved in the continuous enhancements and fixing of production problems
- Utilized Advance DAX calculation to create custom measures & calculated columns, enhancing the depth of analysis with the Power BI reports
- Developed and Maintain SQL Scripts, Views, Functions, Procedures to work seamlessly based on business requirements
- Developed dynamic Power BI Dashboards using Power Query, DAX, providing valuable insights for data-driven decision making
- Knowledge on Power BI Data modeling & Data warehousing concepts like star schema, snowflake schema, dimensions & fact tables
- Hand-on experience on RDBMS like MS-SQL.
Education
M.Sc. - Mathematics
University of Bikaner
07.2008
Skills
- SQL
- Excel/ Google Sheets
- Power BI
- Tableau
- Python
- MY-SQL
- Data Validation
- Data Modeling
- Report Writing
- Data Exports
Certification
- Business Analytics with Excel
- SQL
- Tableau
- Master program of Data Analyst
- Power BI
Timeline
Data Analyst
UEIBI Private Limited
10.2022 - 03.2023
Data Analyst
CTAC Services Pvt Ltd
07.2015 - 12.2016
M.Sc. - Mathematics
University of Bikaner
Similar Profiles
QROMIEO BARNABASQROMIEO BARNABAS
HR and Admin Assistant at VFlowTech India Private Limited & Sunkonnect Advisory Service Private LimitedHR and Admin Assistant at VFlowTech India Private Limited & Sunkonnect Advisory Service Private Limited
Vasuda KrishnamurthyVasuda Krishnamurthy
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited
B Hemanth KumarB Hemanth Kumar
Senior Ar Caller at U.S Medical billing, Visionary Rcm Infotech India Pvt Ltd, Omega Healthcare private limited and Access Healthcare private limitedSenior Ar Caller at U.S Medical billing, Visionary Rcm Infotech India Pvt Ltd, Omega Healthcare private limited and Access Healthcare private limited
Toni YoungbloodToni Youngblood
Licensed Realtor at DFW Britestar Realty PLLCLicensed Realtor at DFW Britestar Realty PLLC
Charmagne N. GelseyCharmagne N. Gelsey
Payroll Conversion Consultant at EmpowerPayroll Conversion Consultant at Empower