Shikha upneja

Jobs 0% verified

U

Data Analyst

UEIBI Private Limited,

Jul 2020 - Jun 2023 (3 years)

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 sup
C

Jr Data Analyst

CTAC Services Pvt Ltd,

Jul 2019 - Jun 2020 (1 year)

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

Education 0% verified

About

Detail

Timeline

Résumé