Ramakrishna Velamala

Junior Business Analyst

• Job Details:Enhanced project management efficiency and data analysis in PNC Bank's corporate and institutional banking division by leveraging Confluence and SQL, resulting in optimized workflow processes. Collaborated with developers to investigate root causes of recurrent issues, eliminating 200 reported client issues and yielding cost savings of $10,000. Produced clear and concise reports, presentations, and documentation, creating 10 data models to visualize complex data relationships using Tableau, facilitating strategic planning and informed decision-making. Provided technical support and troubleshooting for business intelligence tools, enhancing user experience and system performance by 30%. Spearheaded data collection, cleaning, and analysis, constructing Oracle SQL Developer views that reduced manual workload from 10 hours to 5 minutes, enhancing efficiency by 99%. Led agile practices, including 200+ daily stand-ups, 50 sprint planning sessions, and 50 retrospectives, ensuring timely and efficient project delivery. Implemented CA7 batch jobs, reducing client task durations from 100 hours to 2 hours per week, achieving a 98% productivity gain. Extracted, cleaned, and analyzed data using Microsoft Excel and integrated it with MS SQL Server for comprehensive analysis and reporting, driving data-driven decision-making and resulting in a 25% increase in reporting accuracy. Designed 15+ interactive dashboards and reports using Power BI, enabling in-depth analysis of defect occurrences and trend identification, supporting proactive issue resolution and reducing defect rates by 20%.