PAVANI GOLLA

I have performed extensive data analysis using Excel to analyze and interpret large data sets, identifying trends and drawing meaningful insights.

• In Excel, I efficiently cleaned and organized data by removing duplicates, fixing errors, and formatting it appropriately for further analysis.

• To present data findings and trends, I developed visually appealing charts, graphs, and dashboards in Excel, ensuring clear and effective communication of data insights to stakeholders.

• Update and verify tax amounts and client remittances in the spring and fall seasons.

• Ensure accuracy and compliance with financial regulations through examination of client tools, tax amounts, and customer data.

• Tailor tax calculation and reporting process to meet specific tax requirements of different loan types.

• Update and maintain loan records to ensure correct submission and adherence to regulatory standards.

• collaborates with team to process loan-related documents and reports accurately and on time, while providing professional customer service to resolve client queries and discrepancies.

• Proficient in Microsoft Office Suite, particularly Excel, for data analysis and reporting.

• Acquired proficient command of Excel functionalities and data analysis techniques, including data cleansing, manipulation, and conditional formatting techniques.

• Gained expertise in data visualization and storytelling using Excel and PowerPoint by creating impactful charts and interactive dashboards.

• My data analysis process falls under the category of loan servicing within the banking and lending industry.

• Proficiency in developing interactive reports and dashboards using Power BI Desktop.

• Experience in connecting Power BI to various data sources to retrieve and visualize data.

• Skilled in creating and customizing visualizations to effectively present data insights.

• Knowledge of Power Query for data transformation and manipulation.

• Familiarity with DAX formulas for data modelling and calculations.