Karan Saxena
Data Analyst
Delhi
Summary
Experienced Data Analyst with a 4-years track record in interpreting and analyzing data to drive business solutions. Recognized for analytical thinking and strong skills in Power BI, SQL, and MS Excel. Demonstrates excellent understanding of business operations and proficiency in utilizing analytics tools for effective data analysis.
Overview
6
6
years of professional experience
6
6
years of post-secondary education
5
5
Certifications
2
2
Languages
Work History
Data Analyst
Innovaccer Analytics Pvt.Ltd
04.2024 - Current
- Data Extraction through ADLS and parsing raw fact files into the company's database.
- Data Transformation and manipulation on Snowflake DB.
- Performing File and Data Gap Analysis through standard analytical procedures.
- Ingesting data through pipelines to extract, transform and ingest raw data into database.
- Utilized Python, SQL, and ETL tools to automate data workflows, reducing processing time and enhancing database performance.
- Performed comprehensive data validations to identify and rectify anomalies, maintaining data integrity and reliability for downstream analytics.
- Analyzed healthcare data to provide actionable insights into Cost, Risk and Quality assessment metrics.
Data Analyst
BDO India LLP
07.2022 - 04.2024
- Database Management - MYSQL Workbench, SSMS
- Performance Tuning and Optimization
- GST Application Database Handling
- Database Designing and Architecture Maintenance
- Created and maintained stored procedures, triggers, to automate repetitive tasks and enforce data integrity
- Familiarity with indexing strategies and query optimization techniques to enhance database performance
- Power BI - Creating interactive and visually appealing reports and dashboards
- Knowledge of data modeling, data transformation, and data visualization techniques using Power BI
- Familiarity with SQL for data extraction and manipulation
- Developed and maintained Power BI reports and dashboards
Jr. Data Analyst
ICICI Bank Ltd.
05.2019 - 06.2022
- Analyzed dataset in MS Excel and collaborated with Audit Team and IT Operations to gather and prioritize their business requirements
- Proficiency in Database Design and Architecture
- Involved in creating SQL queries for fetching data from multiple tables
- Analyzed different types of data and used Power BI to create interactive reports to help the Audit & IT operation team
- Interacted with the onsite team and worked closely with them to understand the requirements accurately
- Implentation of data cleaning techniques to gain insights in business, helping client to rise in the market
- Communicated and presented insights clearly and compellingly to senior leadership of the organization
- Creating Trends for Business Insights
- Speculating Pre-NPA Assets & Loan defaulters who are Potential Risk to the bank
Education
MBA - Risk Management, Finance, Digital Marketing
Manipal Academy of Higher Education
08.2017 - 04.2019
B.Tech - Electrical & Electronics Engineering
Dr. A.P.J Abdul Kalam Technical University
07.2013 - 05.2017
Skills
- SQL
- MS Power BI
- Python
- ETL
- Data Visualization
- Database Design
- Query Optimization
- Stored Procedures
- Data Manipulation
- Advanced Excel
Certification
Microsoft Azure Data Fundamentals Certified (DP-900), Microsoft
Timeline
Data Analyst
Innovaccer Analytics Pvt.Ltd
04.2024 - Current
Data Analyst
BDO India LLP
07.2022 - 04.2024
Jr. Data Analyst
ICICI Bank Ltd.
05.2019 - 06.2022
MBA - Risk Management, Finance, Digital Marketing
Manipal Academy of Higher Education
08.2017 - 04.2019
B.Tech - Electrical & Electronics Engineering
Dr. A.P.J Abdul Kalam Technical University
07.2013 - 05.2017
Similar Profiles
SHASHANK KUMARSHASHANK KUMAR
Data Analyst at Innovaccer Analytics Pvt.LtdData Analyst at Innovaccer Analytics Pvt.Ltd
Gulshan SainiGulshan Saini
Sr. Quality Analyst and Quality Assurance at Innovaccer AnalyticsSr. Quality Analyst and Quality Assurance at Innovaccer Analytics
Aatish MehtaAatish Mehta
Sales Process Manager (GTM) at Innovaccer Analytics Pvt LtdSales Process Manager (GTM) at Innovaccer Analytics Pvt Ltd