Prathyusha U
Hyderabad
Summary
Results-driven Data Analyst with a proven track record at Acuity Knowledge Partners, specializing in Power BI and Python. Successfully automated reporting workflows, enhancing efficiency by over 40%. Adept at collaborating with stakeholders to deliver actionable insights and training teams, leveraging strong analytical and communication skills to drive strategic decision-making.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Data Analyst
Acuity Knowledge Partners
Bangalore
08.2022 - 11.2023
- Developed dynamic Power BI dashboards to visualize team performance and productivity metrics.
- Employed statistical techniques to analyze data, delivering actionable insights to stakeholders.
- Published reports via Power BI Service with scheduled data refreshes and access controls.
- Automated reporting workflows reduce manual effort by over 40% through Excel-Power BI integration.
- Collaborated with stakeholders to define requirements and present clean, interactive visuals.
- Led analytics and reporting team of 15, providing training and conducting performance evaluations.
- Created centralized reporting templates and data models for strategic reporting needs.
- Analyzed large datasets to address strategic and operational business challenges.
CAT Modeling Analyst
Chubb Business Services India Pvt Ltd
Hyderabad
03.2022 - 08.2022
- Executed risk and portfolio modeling services through Risk Link, Python, and SQL.
- Conducted loss validations and compared annual average losses against previous quarter data during quarterly assessments.
Senior Analyst
Berkadia India Services Private Limited
Hyderabad
06.2019 - 02.2022
- Company Overview: A leading commercial real estate company.
- Preparing SPOs and process flowcharts.
- Analyzed financial and market data to support underwriting decisions for Freddie Mac and Fannie Mae properties.
- Built structured Excel and Power BI dashboards to represent affordability metrics, property-level insights, and trend reports.
- Leveraged Power BI Service for interactive stakeholder reporting, and used Gateway for real-time data updates.
- Automated data preparation for affordability tests using Python and Excel macros, improving processing speed and reliability.
- Created process flowcharts and SOPs for data workflows, improving clarity and onboarding efficiency.
- Delivered insights through narrative summaries, supporting internal decision-makers, and client presentations.
CAT Modeling Analyst
Allianz Technology
Pune
09.2017 - 02.2019
- Processed pre- and post-bind risk modeling and portfolio roll-up tasks using Catastrophe Modeling tools.
- Conducted data review and cleansing for property insurance policy data analysis with MS Excel.
- Prepared Nathan peril and Google Earth reports detailing various risks for underwriter requests.
- Modeled diverse policy structures per account, offering multiple options as requested by underwriters.
- Delivered risk and portfolio modeling services utilizing Risk Browser to enhance analytical capabilities.
Process Analyst
Gallagher Operations Support
Pune
01.2015 - 09.2017
- Performed data analysis on significant value statements using Excel for data scrubbing and formatting.
- Managed policy issuance for commercial properties while calculating accurate premiums.
- Prepared PKTs as a process trainer and tested team awareness of updates.
- Compiled performance reports to identify areas for improvement within the team.
Education
B.Sc. - Mathematics, Statistics, Physics
Andhra Loyola College
Vijayawada06.2012
Intermediate - Mathematics, Physics, Chemistry
Narayana Jr, College
Vijayawada06.2009
Skills
- Data analysis: Python and R
- Data visualization: Power BI
- Database management: SQL and Excel
- Reporting tools: Power BI and Excel dashboards
- Microsoft Office proficiency
- Process mapping and flowcharting
- VBA programming (basic)
- Generative AI for business analytics
Strengths
- Analytical mindset with a strong attention to detail
- Proven leadership in cross-functional teams
- Process improvement and automation
- Data storytelling and dashboarding
Certification
OPEX Yellow Belt, OPEX Yellow Belt trained
Accomplishments
- Successfully led the end-to-end client process launch within 3 months at Acuity Knowledge Partners
- Recognized with multiple RnR awards for delivery excellence and stakeholder satisfaction
- Automated affordability testing at Berkadia using Python and Excel
- Created enterprise-wide dashboards using Power BI Service and Gateway for performance monitoring
Projects
Capstone project of Power BI - Intellipaat
Analyzed a YouTube dataset to extract valuable insights and provide actionable recommendations for content creators and marketers, the primary objective of the analysis was to uncover patterns, trends, and correlations within the YouTube dataset, focusing on engagement metrics and video attributes, the analysis aims to answer key questions that will guide content creators and marketers in making informed decisions to improve their YouTube content and maximize their viewer interaction tasks performed: card visual to display maximum uploads, minimum view ranks, and average views for the last 30 days radar chart to display channel type and channel rank, packed bubble chart to display category-wise subscribers a table visual to represent the channel type and views per subscriber, and a decomposition tree to represent rank-wise categories a navigation button to navigate between two pages
Training
- R Language, Completed a course in R Language
- Power BI, Completed Course in Power BI from Intellipaat
Languages
- English, Native
- Hindi, Native
- Telugu, Native
Timeline
Data Analyst
Acuity Knowledge Partners
08.2022 - 11.2023
CAT Modeling Analyst
Chubb Business Services India Pvt Ltd
03.2022 - 08.2022
Senior Analyst
Berkadia India Services Private Limited
06.2019 - 02.2022
CAT Modeling Analyst
Allianz Technology
09.2017 - 02.2019
Process Analyst
Gallagher Operations Support
01.2015 - 09.2017
B.Sc. - Mathematics, Statistics, Physics
Andhra Loyola College
Intermediate - Mathematics, Physics, Chemistry
Narayana Jr, College
Similar Profiles
Naveen KumarNaveen Kumar
Senior Associate at Acuity Knowledge Partners (formerly Moody’s Analytics Knowledge Services)Senior Associate at Acuity Knowledge Partners (formerly Moody’s Analytics Knowledge Services)
Bidesh DasBidesh Das
Business Analyst at Acuity Knowledge PartnersBusiness Analyst at Acuity Knowledge Partners
DOLLY SHARMADOLLY SHARMA
Delivery Lead at ACUITY KNOWLEDGE PARTNERSDelivery Lead at ACUITY KNOWLEDGE PARTNERS
Rupesh GopisettyRupesh Gopisetty
Market Research Executive at Taxilla IT Solutions Private LimitedMarket Research Executive at Taxilla IT Solutions Private Limited
Adithya BuddhirajuAdithya Buddhiraju
Game Tester at The QubeGame Tester at The Qube