Gurugram, Haryana, India
I'm experienced BI Developer with 3+ years of experience developing data-driven solutions using SQL Server, Snowflake SQL, MySQL, Python, and Power BI. Expertise in data modeling, DAX calculations, and ETL processes, ensuring accurate and efficient data transformation.
I'm primarily responsible for managing and analyzing data to support internal decision-making. My typical workflow involved collecting, managing, and transforming data to ensure it was accurate and ready for analysis. I primarily used Excel, SQL, and Power BI for this purpose. For instance, I worked with donation data. By mapping donations to donors, I was able to identify key trends, such as which sectors contributed the most, the top 10 donors of the year, and the preferred fields for donations, such as research, institute development, awards, and scholarships establishment, where I also analyzed the donation gaps to understand why some long-term donors had stopped donating in recent years. In addition, I also enhanced donors' data by identifying which fields of their information were relevant for analysis and enriched the data through email survey campaigns. This not only updated the database with the latest information but also significantly decreased the unsubscription rate by 60%. Another key area was analyzing donor engagement data. I assessed how our programs were reaching people, their responses, and the overall effectiveness of these programs. This analysis helped the organization better understand its audience and improved outreach strategies. Overall, These insights were crucial for the internal management team. They used the information to make informed decisions and strategize more effectively.
I was responsible for analyzing, reviewing, and optimizing data, which resulted in a remarkable 30% increase in operating efficiency. This not only streamlined processes but also enhanced user satisfaction by delivering faster and more reliable data outputs. Leveraged Advanced Excel functions such as VLOOKUP and Pivot Tables, conducted in-depth data analysis and created comprehensive reports. This initiative reduced manual work by 2 hours per report cycle, significantly boosted the team's productivity and workflow efficiency. One of the highlights of my tenure was driving a 59.4% increase in new signups and improving average customer ratings by 3.7%. These outcomes were achieved through rigorous analysis of KPIs related to a revenue-based product. I evaluated the impact of site and campaign changes, which directly enhanced customer experience and drove sales growth. Overall, my role involved not just data analysis, but also strategic decision-making based on insights gleaned from complex datasets. I thrived in a dynamic environment where I could apply my technical skills to deliver tangible business outcomes and contribute to organizational success.