Pranay Borkar
Data Analyst
Pune
Summary
Data professional with 3+ years of experience as a Data Analyst, specializing in data analysis, reporting and visualization, automation of reporting tasks, data storage and management, SLA reporting and stakeholder management.
Overview
3
3
years of professional experience
6
6
years of post-secondary education
Work History
Data Analyst
Cognizant Technology Solutions
02.2022 - Current
- Developed and maintained dynamic dashboards in Tableau and Power BI to track key performance indicators (KPIs), enabling real-time monitoring and trend analysis.
- Migrated reports from Tableau to Power BI, ensuring seamless data transition, maintaining visualization consistency, and optimizing report performance.
- Designed and implemented scalable data storage and retrieval solutions, improving query efficiency and reducing processing time.
- Worked with Data Warehouse and Staging areas to optimize ETL processes, ensuring smooth data integration and consistency across multiple sources.
- Hands-on experience in writing and debugging SQL queries for data extraction, transformation, and optimization, improving query performance and data retrieval speed.
- Automated data processing and reporting tasks using VBA, reducing manual effort, improving accuracy, and enhancing operational efficiency.
- Worked with ticketing tools like ServiceNow (SNOW), generating reports, extracting relevant data, analyzing SLA breaches, and performing error corrections to ensure compliance.
- Performed data validation to ensure accuracy, completeness, and consistency across reports and dashboards, reducing discrepancies in business insights.
- Collaborated with cross-functional teams and stakeholders to gather requirements, provide data insights, and drive business decisions through effective communication and reporting.
Education
BE - Electronics And Telecommunication (E&Tc)
Marathwada Mitra Mandal's College of Engineering
Pune 01.2015 - 07.2020
Skills
- SQL (SQL Server, Impala)
- SSIS (SQL Server Integration Services)
- Tableau
- Power BI
- Data Modeling
- Python
- Advanced Excel
- VBA (Visual Basic for Applications)
- Data Warehousing/ Data Staging
- Extract, Transform, and Load (ETL)
- Reporting and Analysis
- ServiceNow (SNOW)
- Problem Solving, Collaboration & Management
PROJECT EXPERIENCE
Banking Domain - Infrastructure Services
Client : Credit Suisse/ UBS
Roles & Responsibilities :
- Gather and analyze client requirements to design, develop and maintain reports and dashboards tailored to business needs.
- Generate and distribute daily, weekly and monthly reports ensuring accuracy and timely delivery.
- Work on developing new reporting and data management solutions to enhance efficiency and meet evolving business requirements.
- Monitor and track Service Level Agreements (SLA) through accurate reporting, identifying areas for improvement.
- Provide ad hoc data extracts and reports to support trend analysis across different timeframes(shift-wise, hourly, daily, weekly, monthly, yearly).
- Automate recurring reporting tasks using tools such as Excel macros, SQL, and BI platforms to improve efficiency and reduce manual efforts.
Timeline
Data Analyst
Cognizant Technology Solutions
02.2022 - Current
BE - Electronics And Telecommunication (E&Tc)
Marathwada Mitra Mandal's College of Engineering
01.2015 - 07.2020
Similar Profiles
PRAKASH NARAYANA VIGNESH BPRAKASH NARAYANA VIGNESH B
Business Analyst- Technical Lead at Cognizant technology SolutionsBusiness Analyst- Technical Lead at Cognizant technology Solutions
Raja RathinamadasamyRaja Rathinamadasamy
QA Manager at Cognizant Technology SolutionsQA Manager at Cognizant Technology Solutions
Josephine Arockiya Rani SJosephine Arockiya Rani S
Technical Lead -AWS at Cognizant Technology Solutions, CTSTechnical Lead -AWS at Cognizant Technology Solutions, CTS