Summary
Diligent BI Developer with 2+ years of experience compiling and maintaining extensive database systems to track comprehensive BI information. Adept at leading analytics efforts to generate critical custom business intelligence reports. Implements a meticulous approach to ensure availability and performance of analytics applications throughout the lifecycle. Makes crucial contributions to BI database backup, recovery, and maintenance.
Overview
2
2
years of professional experience
1
1
Certification
Work History
BI Developer
Koch Business Solutions India
01.2023 - Current
- Years of demonstrated experience in developing and promoting business adoption of OLAP cubes using
- SSAS, SSRS, and SSMS
- Skilled in monitoring daily refresh processes, managing exceptions in case of failures, ensuring cubes are updated with the latest data, and providing daily refresh status updates to business users
- Designed automated alerts for critical job failures using power bi and mdx queries, these notifications escalated response time among team members, resulting in an overall decrease of incident resolution time by six hours weekly
- Developed a strong understanding of business processes and technical knowledge to effectively support enhancement tasks based on requirements, while managing (70+) incidents, (120+) tasks generated by the business and Enhanced 10+ requests, generating $50K+ in business value using this expertise
- Enhanced ETL processes by optimizing View/stored Procedure queries, SSIS, SSAS Packages resulting in a reduction in cube refresh time
- Developed comprehensive documentation for root cause analysis and Knowledge transfer, enabling colleagues to gain key business insights and providing clear guidance for effective decision-making
- Created power BI reports based on business user requirements, utilizing modelling techniques to deliver actionable insights and support data-driven decision-making.
Data analyst intern
06.2022 - 09.2022
- Customer Segmentation Model (python, NumPy, pandas, Matplotlib, seaborn, SciPy, statistics)
- Identify potential customer segmentation and provide some meaningful insights from each segment
- Suggested decision the company should take based on the data insights
- Capital Asset Pricing Model (python, NumPy, pandas, Matplotlib, Regression)
- Created CAPM to describe the relationship between systematic risk and expected return for assets with respect to S&P 500
Education
Bachelor of Electrical Engineering -
08-2022
Skills
- ETL development
- Data quality management
- SQL programming
- Data warehousing
- Data modeling
- Data analysis
- Database management
- Customer-oriented
- Technical analysis
- Stakeholder management
Certification
Introduction to Data Analytics (IBM)
Data Analytics Essentials Authorized by IBM
Python for Data Science, AI & Development (IBM)
Databases and SQL for Data Science with Python (IBM)
Timeline
BI Developer - Koch Business Solutions India
01.2023 - Current
Data analyst intern -
06.2022 - 09.2022
Introduction to Data Analytics (IBM)
Data Analytics Essentials Authorized by IBM
Python for Data Science, AI & Development (IBM)
Databases and SQL for Data Science with Python (IBM)
SPPU University - Bachelor of Electrical Engineering,
Similar Profiles
Praveen M PatilPraveen M Patil
Subject Matter Expert at Koch Business Solutions India Pvt LTDSubject Matter Expert at Koch Business Solutions India Pvt LTD
VIJAYARAJ A. V.VIJAYARAJ A. V.
P2P & O2C - TRANSFORMATION MANAGER at KOCH BUSINESS SOLUTIONS INDIA PVT. LTDP2P & O2C - TRANSFORMATION MANAGER at KOCH BUSINESS SOLUTIONS INDIA PVT. LTD
KIRAN B SKIRAN B S
AP-Inv-Process Lead at Koch Business Solutions India Pvt LtdAP-Inv-Process Lead at Koch Business Solutions India Pvt Ltd