Alekhya Palakodeti

A seasoned data analyst with over 3 years of professional experience. Excited to leverage passion in a professional environment and collaborate with a high-performance team. Accomplished timely and quality-driven delivery of over 4 projects under stringent schedules. Proven ability to leverage data-driven insights for strategic decision-making, utilizing a robust skill set in SQL, Power BI, Tableau, and Excel. Applied strong problem-solving and analytical skills, resolving 90% of complex issues within tight deadlines. Combining a detail-oriented approach with strong organizational planning, this skill set excels in requirement analysis, employing critical thinking to deliver outcome-oriented results. Applied effective communication skills to ensure seamless collaboration across teams, enabling strategic decision-making and achieving organizational objectives.

• MSKCC – Developed and designed 10+ Tableau dashboards for comprehensive project tracking and analysis incorporating various visualizations resulting in a 20% increase in user engagement and a 15% decrease in report generation time. Created interactive controls to switch between different data views, enabling dynamic analysis of project trends and quality metrics. These dashboards provided actionable insights for effective project management, risk assessment, and quality assurance

• PepsiCo - Analyzed and mapped data from 5+ diverse sources to consolidate information and support data integration efforts, developing comprehensive Power BI reports to visualize key metrics and trends, facilitating data-driven decision-making across departments. Developed comprehensive Power BI reports to visualize key metrics and trends, facilitating data-driven decision-making across departments. Created and maintained backups for tables containing crucial information on triggers and stored procedures using SQL Server Management Studio, ensuring data integrity and disaster recovery. Crafted and optimized complex DAX queries in Power BI to enhance report performance and deliver precise insights tailored to business needs.

• Bank of New York Mellon – Successfully worked in a $1M project to identify gaps in a legacy billing system through dataset reconciliation, streamlining fee extraction, review, and reconciliation by identifying commonalities in schedules and creating repeatable templates, resulting in a 30% improvement in data retrieval efficiency. Streamlined fee extraction, review and reconciliation by identifying commonalities in few schedules and creating repeatable templates. Extracted 4000 client rate agreements into a standardized database for world's largest custodian.

• Acci-Insure - Configured IAM users and assigned them role-based permissions as needed. Deployed EC2 instances to meet project requirements.

• Microsoft Certified: Azure Data Fundamentals
• Microsoft Certified: Power BI Data Analyst Associate
• AWS Certified Cloud Practitioner