Data Analyst Financial Reporting

Pranav Gadde

************@*****.*** Cell: +1-312-***-**** www.linkedin.com/in/pranav-gadde12

Strongly Interested in Financial Systems and Data Analyst Education

Indiana Wesleyan University, Indianapolis, USA

Master of Science in Management Information Systems Data Analytics ~ Dec 2024 ~ GPA: 4.0 • Relevant Coursework: Financial Reporting & Analysis, Economic Analysis for Managers, Finance and Accounting Systems, Data Analysis for Business Decision Making, Financial Management. Velagapudi Ramakrishna Siddhartha Engineering College, JNTUK, Vijayawada, India Bachelor of Technology in Electronic and Communication Engineering ~ May 2022 Relevant Coursework: Engineering Economics and Finance, Data Acquisition and Data Mining Experience

State Bank of India Chicago –FDIC Financial Services Company, IL, USA Data Analyst and Financial Systems Associate ~ OCT 2024-Present

● Reconciled Financial Transactions using Advanced Excel and SQL, ensuring compliance and accurate financial reporting, Automated key financial processes including interest accrual calculations, improving efficiency by 20%.

● Developed and executed SQL queries and stored procedures to extract, analyze, and validate daily, monthly, and quarterly data ensuring data integrity and accuracy for financial reporting.

● Performed backend data testing and data normalization, ensuring system functionality and aligning with business requirements Collaborated with cross-functional teams to analyze transaction datasheets providing insights.

● Utilizing SQL and Excel to perform data sorting and mapping on banking transaction data, conducting detailed profit and loss analysis to identify trends and improve financial forecasting accuracy.

● Created and maintained Power BI dashboards and reports, enabling strategic decision-making and business intelligence insights.

VI Solutions, Bangalore, India

Intern Data Analyst ~ Apr 2021- Dec 2022

● Developed interactive financial dashboards using Tableau and Power BI, enabling real-time data analysis and supporting strategic decision-making for management.

● Automated financial data validation processes with Python, reducing errors by 30% and enhancing data accuracy for business decision-making.

● Collaborated on database projects, optimizing financial applications utilizing SQL and Power BI ensuring robust data integrity and seamless integration of financial data into visual dashboards.

● Partnered with cross-functional teams to design secure, data-driven automation solutions, leveraging Tableau for business intelligence insights and ensuring high-quality data integration across systems.

● Engineered real-time financial systems using LabVIEW and integrated with Excel, improving workflow efficiency by 25% and streamlining data analysis processes.

Skills

Power BI Tableau Python Microsoft Excel, Word, PowerPoint, Project, Visio, VBA, ETL SQL, SSRS SAP Data Mining Finacle LabVIEW

Project/Courses

JPMorgan Chase & Co. Excel Skills Job Simulation on Forage - Sept 2024 Developed functional macros integrated with buttons using VBA to automate account sales data processes, enhancing efficiency, Created impactful charts and interactive dashboards in Excel, leveraging advanced data visualization techniques for effective storytelling.

Data Analysis and Data Mining - Frontlines EduTech (FLM)- Dec 2024 Mastered advanced data analysis techniques, including data mining and cleansing, to uncover actionable insights for strategic decision-making, Applied data visualization tools like Excel and Power BI to create dynamic dashboards, facilitating informed financial operations and reporting.

Contact this candidate