SQL/Power BI Developer - II

• Mar 2023 - Present

- Involved in creating different reports based on business request and ad-HOC requirements using Power BI desktop.
- Developed 80% customized Microsoft Power BI dashboards, visualizations and Microsoft SSRS interfaces to offer insightful and useful information.
- Monitoring the working of Data pipelines and performance of already published BI reports and eliminating the associated issues.
- Experience in handling and automating database backup and recovery.
- Hands on experience in managing and troubleshooting different high Availability techniques like Always on, Database Mirroring, SQL Clustering.
- Collaborating with various business units of the client organization to understand additional needs and requirements.
- Understanding of business, preparing financial budgeting reports and performing UAT by connecting with the client counterpart and delivering the solutions successfully.
- Key Achievement – The business management team is provided with unified and granular reports via a scalable and secure Power BI dashboard to enable them to make rapid and precise choices regarding resource allocations. KPIs including the number of open projects and resources allocated, processes with task counts, resource skills, and project completion percentage are tracked using this dashboard. Using this dashboard, reports on resource loading, progress, task skill, and project allocation have been obtained. Show less

SQL/Power BI Developer

• Apr 2020 - Jun 2021

- Develop, maintain, and optimize SQL databases, tables, views, stored procedures, and functions used for onboarding a customer. - Design and implement efficient and accurate ETL processes for data extraction, transformation, and loading. - Responsible for Identifying and resolving data quality issues, performance bottlenecks, and other database-related problems. - Create and execute SQL queries, scripts, and reports to extract, analyze, and present data insights. - Monitor database performance, conduct regular performance tuning, and recommend optimization strategies. - Implement and enforce data security measures, ensuring compliance with relevant regulations and standards. - Document database structures, processes, and procedures for future reference and knowledge sharing. - Key Achievement: A Power BI dashboard on the Digital Lending Lifecycle is made to track the effectiveness of e-lending from origination to processing and also provides information on the financing and repayment segments. Along with insights, this dashboard also keeps track of fraudulent situations. Using this dashboard, KPIs like application count, funded application count, application decline rate, fraud rate, and dealer-specific statistics are tracked. This dashboard enables managers and business stakeholders in the financial services industry to accurately assess their operational performance. Show less

Information Technology Trainee

• Jun 2018 - Aug 2018