Kiran Gaikwad
Pune
Summary
Adept BI Developer with a proven track record at Asset Analytix, I excel in transforming complex data into actionable insights using Power Bland SQL. My expertise in data modeling and effective communication has driven business decisions, showcasing a blend of technical prowess and collaborative success.
Overview
4
4
years of professional experience
1
1
Certification
Work History
BI Developer
Asset Analytix
Pune
11.2020 - Current
- Develop complex SQL queries and stored procedures to design a dashboard
- Develop and execute SSIS packages, and load data on the product/application as per customer needs, and perform data validation for the same
- Database backup, restored database, import, export, and updates data from different servers, etc
- Designed and developed interactive Power BI reports and dashboards to visualize key business metrics
- Created complex data models using Power BI Desktop, and optimized DAX queries for performance
- Implemented ETL processes to extract, transform, and load data from various sources
- Collaborated with business stakeholders to gather requirements and translate them into technical specifications
- Coordinated testing and validation procedures through software development lifecycle
- Tested new releases of software prior to deployment in order to verify functionality works as expected
- Designed and implemented dashboards using Power BI to provide interactive visualizations of business data
- Troubleshooted technical issues related to .NET development
- Configured databases and queries for optimal performance in the BI environment
- Optimized existing SQL queries for better performance when running against large datasets
Education
BE - E&TC
AISSMS
Pune07.2019
Diploma - E&TC
MM Polytechnic
Pune07.2016
Skills
- SQL
- Power BI
- SSIS
- SDLC processes
- Data analysis
- Testing and debugging
- Dashboard creation
- ETL processes
- Data validation
- Data modeling
- Business analysis
- Requirements gathering
- Database management
- Effective communication
- Team collaboration
- ETL development
- SQL programming
- Business intelligence tools
- Data integration
Certification
- POWER BI Developer, The Tools, Pune, Maharashtra
- Software Testing, Qspiders, Pune, Maharashtra
Hobbies and Interests
- Traveling
- Cooking
- Makeup
Languages
- English
- Hindi
- Marathi
Personal Information
- Date of Birth: 06/15/97
- Nationality: Indian
Languages
English
Proficient
C2
Hindi
Proficient
C2
Marathi
Proficient
C2
Timeline
BI Developer
Asset Analytix
11.2020 - Current
BE - E&TC
AISSMS
Diploma - E&TC
MM Polytechnic