Savita Aade

Summary:

Developed impactful Power BI dashboards with accurate data representation and implemented row-level security. Extracted and transformed data from Oracle databases, enhancing processes with Power Queries. Wrote scripts for JIL creation, dashboard automation, and Unix shell scripts for system upgrades. Provided client support to international banking clients, adapting to agile environments. Conducted thorough testing, managed upgrades, and orchestrated deployments for seamless transitions. Created an internal support dashboard, fostering collaboration and effective communication with cross-functional teams and stakeholders to ensure project success.

Responsibility:

· Gathered requirements, understood functionality, and designed documents.

· Extracted and transformed data from Oracle databases using SQL queries to support diverse client requirements. - Utilized Power Queries to enhance data transformation processes for Power BI dashboards.

· Developed Power BI dashboards using Power Queries and DAX. - Ensured accuracy in data representation and implemented row-level security for sensitive information.

· Developed an internal support BI dashboard to streamline processes and enhance team efficiency.

· Wrote SQL Query and Unix scripts for various project tasks, including JIL creation, dashboard email automation, and state information gathering. - Implemented Unix shell scripts for automatic patching jobs and data purging during system upgrades.

· Managed client upgrades, whether related to GDS or Oracle, ensuring seamless transitions and minimal disruptions. - Orchestrated deployments for both production and User Acceptance Testing (UAT) environments.

· Create ACC ticket to for PROD code implementation.

· Provided support to international banking clients, resolving user queries, and offering guidance on running dashboards and reports. - Demonstrated experience in an agile work environment, adapting to changing client needs and requirements.

· Collaborated with cross-functional teams to design project documents and roadmaps for project release changes. - Effectively communicated with stakeholders to gather requirements and ensure project success.

Project: 7-Eleven

Summary:
· Proven experience as a Power BI Developer with a focus on ticketing systems and client support.

· Proficiency in writing SQL queries for data analysis and troubleshooting. Strong understanding of ITIL framework and experience in maintaining SLAs.

· Ability to create complex and visually appealing reports using Power BI.

· Excellent communication skills and the ability to collaborate with cross-functional teams.

· Proficient in end-to-end Power BI development, from data extraction and transformation to creating interactive reports and dashboards that facilitate data-driven decision-making.

Responsibility:
• Interact with clients promptly and attentively, addressing their queries and concerns with a focus on providing effective solutions.

• Maintain clear and open lines of communication with clients to ensure their needs are met in a timely manner.

• Managing and addressing tickets in a specific queue, including high priority and escalation tickets. Updating the Daily Status report to the Technical Lead Providing support to Level 1 agents and evaluating ticket performance, following the ITIL framework to maintain Service Level Agreements (SLAs).

• Writing SQL queries for data analysis and debugging complex user queries

• Developing and maintaining Key Performance Indicator (KPI) dashboards on a weekly and monthly basis for the entire team by using power Bi.

• Creating custom charts, such as gauge and donut charts, and utilizing text tables, bar charts, line charts, tree maps, area charts, pie charts, and dual-axis charts in Power Bi,

Project: Bajaj Finserv

· Oversee the Treasury product system, a Bajaj finance application for Loan Successfully managed the Bajaj Finance Treasury product system, overseeing Home loan, Personal loan, and Professionals loan applications.

· Ensured regulatory reporting and compliance by pulling and processing data for analysis and reporting at the end of each day, contributing to the organization's adherence to industry standards.

· Monitored the Treasury product system application and data flow daily, proactively identifying and addressing potential issues to maintain seamless operations.

· Developed SQL queries to validate data and generate daily reports, enhancing the accuracy and efficiency of data analysis processes.

· Monitored production machines and applications using ticketing tools, promptly investigating and notifying the L3 Team of any identified issues, especially those flagged as Orange/Red, to ensure minimal downtime and optimal performance.