Priyanka Dixit(Data Analyst)
Kanpur
Summary
I am a highly analytical and detail-oriented Data Analyst with over 4.8 years of experience in data extraction, analysis, and visualization. I have proven expertise in leveraging tools like SQL, Python, and Power BI to deliver actionable insights and drive data-driven decision-making. My focus on automating workflows and optimizing performance supports analytics and reporting functions effectively.
Overview
5
5
years of professional experience
6
6
years of post-secondary education
Work History
Data Analyst
Tata Consultancy Services
Lucknow
04.2021 - Current
- Data Extraction and Reporting
- Extracted, cleaned, and processed large datasets comprising 10,000 of records using SQL to support business decision-making efficiency by 20%.
- Designed and optimized complex SQL queries, reducing query runtime by 15% and improving overall reporting efficiency.
- Identified and resolved performance bottlenecks in query execution, ensuring timely data availability for stakeholders.
- Automation
- Automated repetitive data processing workflows using Python, achieving a 30% improvement in operational efficiency.
- Developed advanced Excel macros to streamline reporting tasks, reducing manual effort by 40% and improving accuracy.
- Reporting and Data Visualization
- Revamped the Software Compliance Dashboard from a static Excel format to a dynamic, automated reporting tool, reducing the time required to generate server data summaries from 2 hours to 45 minutes.
- Monitored and resolved critical security issues, such as SAST (Static Application Security Testing) and DAST (Dynamic Application Security Testing), for internal applications using SQL reducing potential risks for over 400 internal applications by 60%.
- Prepared detailed security compliance assessment reports using Excel and Power BI, enabling higher management to make quick and informed decisions.
- Improved report performance by 20% through DAX (Data Analysis Expressions) optimization techniques in Power BI.
- Continuous Improvement and Innovation
- Designed and implemented efficient ETL pipelines to automate the extraction, transformation, and loading of data, ensuring data integrity and reducing reporting time by 25%.
- Conducted root-cause analysis for data discrepancies, implementing solutions that minimized errors and enhanced workflow Reliability.
- Data Management
- Collaborated with cross-functional data teams to integrate data from various sources, ensuring seamless integration with Snowflake.
Education
Master of Technology - Computer Science
Rama University
Kanpur, 09.2018 - 08.2020
Bachelor Of Technology - Computer Science
Maharana Institute of Professional Studies
Kanpur, 08.2014 - 09.2018
Skills
- SQL
- API
- Microsoft Power BI
- MySQL
- Snowflake
- Amazon Redshift
- ETL Processes
- Excel
- AWS
- Regression
- Time Series Forecasting
- A/B Testing
- Data Mining
- Data Modeling
- AWS S3
- Communication
- Problem Solving
- Business Intelligence
Projects
- Analytics, SQL, Sales Analysis
- Created a sales analysis dashboard in Power BI, improving data accessibility and decision-making by 30% for 20 channels.
- Optimized SQL queries and used Python to clean data, reducing retrieval time by 40% and enabling data manipulation from 10 sources.
- Designed and implemented data models to represent key sales trends, including revenue, product performance, and regional insights, which led to a 25% increase in sales in the targeted region.
- Constructed adaptive visualizations such as charts, graphs, and tables in Power BI. Integrated multiple data sources.
Languages
English
Proficient
C2
Hindi
Proficient
C2
Timeline
Data Analyst
Tata Consultancy Services
04.2021 - Current
Master of Technology - Computer Science
Rama University
09.2018 - 08.2020
Bachelor Of Technology - Computer Science
Maharana Institute of Professional Studies
08.2014 - 09.2018