Ramanand Kshirsagar
Pune
Summary
Aspiring Data Engineer and BI Developer with 6 years of experience in developing robust data and visualization solutions. Skilled in delivering high-quality end-to-end business solutions to meet client requirements. Avid learner with strong work ethics and a good understanding of business principles.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Solutions Lead
Aligned Automation
Pune
12.2020 - Current
- Leading a team of 5, which is a mix of reporting and data experts.
- Monitoring the team and providing mentorship for cross-skilling.
- Collaborating with business users to gather requirements and translate them into technical solutions.
- Designing and implementing data models and ETL processes to support reporting and analytics requirements.
- Optimizing and tuning SQL queries and data pipelines for performance and scalability.
- Supporting the data team with maintaining and monitoring ADF Pipelines.
- Troubleshooting data-related issues and providing timely resolutions.
- Migrating and automating 120 manual Excel reports to Power BI. Also, reducing the number of reports from 120 to 16 by consolidating them based on business, region, and other factors.
- Implementing row-level security to ensure appropriate data access in Power BI.
- Designing and developing a Tableau dashboard as a Proof of Concept (POC).
Business Technology Analyst
ZS Associates
Gurgaon
09.2019 - 09.2020
- Interacted with customers to gather information for Tableau dashboard enhancements and change requests.
- Developed a Tableau dashboard for Medical Rep Incentive.
- Designed and implemented the ETL solution for reporting using Dataiku / DSS tool.
- Automated report testing using SQL and Python.
- Developed SQL queries for testing Dashboards and Reports.
- Maintained monthly dashboard refresh and testing.
Business Intelligence Data Analyst
Bajaj Finserv
PUNE
11.2017 - 08.2019
- Developed queries for ad-hoc requirements for various businesses, including Rural and Urban personal loans.
- Developed data models for analysis to identify various customer segments.
- Created SQL queries for daily lead extracts and shared them with the business in Excel reports.
- Managed data queries for cross-functional teams and client interactions to ensure timely project delivery.
- Maintained the Customer Vintage Analysis report on a monthly basis.
- Designed and developed Tableau dashboards for sales reports.
- Created a self-service Tableau report for the business team, enabling faster access to hot leads for loan sales pitching.
Education
Bachelor of Engineering - Information Technology
Dr. Vithalrao Vikhe Patil College Of Engineering
Surat05-2017
Higher Secondary Education - Science
Pravara Public School
Loni, Ahmednagar03-2013
Skills
- MS SQL Server
- SQL Scripting
- T-SQL
- SSIS
- Power BI Desktop
- Power BI Services
- Tableau
- Dataiku
- Excel
- Azure Data Factory
- Azure Data Lake
- Azure DevOps Boards
Certification
- PL-300: Microsoft Power BI Data Analyst, Microsoft
Languages
Marathi
First Language
English
Advanced (C1)
C1
Hindi
Advanced (C1)
C1
Gujarati
Intermediate (B1)
B1
Timeline
Solutions Lead
Aligned Automation
12.2020 - Current
Business Technology Analyst
ZS Associates
09.2019 - 09.2020
Business Intelligence Data Analyst
Bajaj Finserv
11.2017 - 08.2019
Bachelor of Engineering - Information Technology
Dr. Vithalrao Vikhe Patil College Of Engineering
Higher Secondary Education - Science
Pravara Public School
- PL-300: Microsoft Power BI Data Analyst, Microsoft
Similar Profiles
Mayur RaysingMayur Raysing
Procurement Analyst at ALIGNED AUTOMATIONProcurement Analyst at ALIGNED AUTOMATION
Indrajeet JadhavIndrajeet Jadhav
Solution Engineer at Aligned AutomationSolution Engineer at Aligned Automation
NAUMANULHAQ SHAIKHNAUMANULHAQ SHAIKH
Sr. Tactical Buyer (German) at Aligned AutomationSr. Tactical Buyer (German) at Aligned Automation