MEGHANA KODIGANTI
413-***-**** • Linkedin.com • ******************@*****.***
SUMMARY
Insight-Oriented Business Analyst with 2+ years of experience ensuring data integrity, streamlining workflows, and building reporting tools across fast-paced, cross-functional teams. Proven success in developing dashboards, managing stakeholder requirements, and improving data pipelines with Python, SQL, Power BI, and Excel. Experienced in Agile settings, with strong communication skills and a passion for optimizing talent and operational systems. TECHNICAL PROFICIENCY & CERTIFICATIONS
Data Analysis Tools: Advanced Excel, Tableau, Power BI, Dynamics 365, Microsoft Visio, Google Analytics, Statistical Analysis, SAS Programming Languages, Databases: Python(NumPy, Pandas), R Programming, C, Java, MySQL, SAP, Microsoft SQL Server, ETL Cloud Services & Tools: Azure, Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Snowflake Additional: Agile, Smartsheet, Confluence, Project Management, Microsoft Office, XLMiner, JIRA, IAM, GitHub, Looker Studio, SharePoint EDUCATION
University of Massachusetts Amherst, Isenberg School of Management Master of Science in Business Analytics December 2024 Relevant Coursework: Business Intelligence & Analytics; Business Application Development in Python; Statistics for Business Data Science for Business; Project Management; Data Mining; Data Visualization in Business; Web Analytics & Digital Marketing CVR College of Engineering, Hyderabad May 2022
Bachelor of Technology in Computer Science Engineering EMPLOYMENT
Event Options, Florida June 2024 – Present
Data Management Analyst
■ Performed data cleansing and normalization for over 5,000 vendor and product records, ensuring 99% data integrity for business operations.
■ Developed standardized reporting templates in Excel to enhance visibility of supplier performance metrics.
■ Identified inefficiencies in supplier onboarding processes, reducing data processing time by 30%.
■ Facilitated weekly sessions with operations and sales stakeholders to define reporting requirements. DBS Tech (DBS Asia Hub), Hyderabad, India January 2022 - July 2023 Business Analyst
■ Documented 100+ BRD and FRD business and functional requirements (including use cases and user stories) using Confluence, increasing documentation efficiency by 30%
■ Collaborated with stakeholders to design and implement secure, user-centric online banking functionalities using Python, enhancing transaction efficiency and user experience.
■ Integrated third-party services and developed secure APIs, including a policy evaluation service converting XML to JSON, reducing data processing time by 50% and enhancing transaction security and automation workflows.
■ Analyzed customer transaction patterns and generated actionable insights using SQL and Power BI, improving fraud detection accuracy by 25%.
■ Led UAT testing and defect tracking using JIRA, ensuring a 98% defect resolution rate before deployment, improving overall product quality.
PROJECT EXPERIENCE
McKinsey Forward Program – Learner McKinsey & Company
■ Completed a highly selective global program designed for early-career professionals. Gained practical training in structured problem solving, clear communication, digital collaboration, and agile thinking for business impact. Data Visualization: Empowering Business with Effective Insights – Forage
■ Analyzed key revenue drivers, customer demographics, and market trends to optimize business expansion strategy using Tableau. Developed interactive dashboards and presented data-driven insights to leadership. Predictive Insights for Breast Cancer: A Machine Learning Approach
■ Developed predictive models for breast cancer using Random Forest and Decision Tree (86% accuracy), analyzing healthcare data with Python and Power BI for better clinical insights. Data-Driven Analysis of NYC Vehicle Collisions
■ Analyzed 10,000+ vehicle collision records in NYC, leveraging Tableau to create scatterplots, bar charts, and heat maps that identified key risk factors, while ensuring 90% data accuracy through advanced Excel cleansing techniques, including Power Pivot, XLOOKUP, and VLOOKUP.
■ Visualized geospatial trends using Tableau maps for NYC collision analysis.