Deeksha Vig
Power BI| SQL | Data Analyst
Bangalore,KA
Summary
I have always had an interest of presenting data in a way that it would be telling it's viewers a story. Additional to being pleasant to the eye, it would also be providing meaningful business insights.
Experienced Data Analyst with a demonstrated history of working in the field of Data Analytics. Skilled in Power BI, SQL, MS Excel, Data Cleaning, Analytical Skills.
Overview
3
3
years of professional experience
7
7
years of post-secondary education
Work History
Data Analyst
CGI
Bengaluru, India
04.2021 - Current
- Responsible for Data Source Connection, Data Transformation, Data Modeling, Creating Visualizations and finally publishing them to PBI Service.
- Worked on import/Direct Query and Live data connections with various data sources mainly into relational databases and flat files.
- Writing DAX queries for getting aggregated values which in turn would help in providing business insights.
- Used Power BI and Power Pivot to develop data analysis prototype and used Power View in Power Maps to visualize reports.
- Using features like Bookmark, Page Navigation to provide an app like experience.
- Created interactive dashboards with Row level security .
- Used Power BI gateways for keep dashboards and Reports up to date.
- Expertise in designing various data models with in Star Schema and Snowflake schema.
- Dashboard access to business users.
System Analyst
Functionize Software Pvt. Ltd
Noida, Uttar Pradesh
05.2018 - 12.2019
- Worked on Microsoft SQL Server database mainly in DDL and DML queries.
- Experience in different SQL joins , functions and stored procedures,CTE,MERGE,Views
- Worked on performance tuning techniques for SQL queries and SQL database.
- Tracked, prioritized and organized defects with JIRA, working with development team to facilitate timely corrections.
- Collaborated with developers and product owners to stay current on product features and intended functionality.
- Worked on preparing Release Notes for released test cases to client.
Systems Trainee
Adasoft India Pvt. Ltd
Gurgaon, Haryana
09.2017 - 03.2018
- Analyzed requirements, and functional specifications & required documents fo manual testing.
- Reviewed project specs and worked closely with BA and development for creating test cases.
Education
Masters in Computer Application -
Indira Gandhi National Open University
Delhi 01.2014 -
Bachelors in Computer Application -
Birla Institute of Technology
Noida 08.2010 -
Skills
Power BI
Microsoft Excel
JIRA
Manual Testing
Timeline
Data Analyst
CGI
04.2021 - Current
System Analyst
Functionize Software Pvt. Ltd
05.2018 - 12.2019
Systems Trainee
Adasoft India Pvt. Ltd
09.2017 - 03.2018
Masters in Computer Application -
Indira Gandhi National Open University
01.2014 -
Bachelors in Computer Application -
Birla Institute of Technology
08.2010 -