Vishnu Kumar Annamraju

• Collaborated with multiple clients across different time zones over the last 4.6 months; transitioned from individual contributor to project lead; expanded team from 5 to 30; led and mentored new joiners on technical aspects of BI projects and Power BI while managing multiple overlapping projects.
• Managed the entire BI project life cycle from planning and designing to implementation and maintenance.
• Designed Power BI reports and executive scorecards.
• Guided business teams in developing BI strategy and prioritizing reporting needs.
• Gathered stakeholder requirements for dashboards and analytics solutions.
• Validated data sources and reporting logic across systems.
• Analyzed dashboard performance and addressed reporting issues to ensure data accuracy and reliability.
• Mentored analysts on BI tools, SQL, and dashboard standards.

• Helped migrate and deliver over 300 Tableau reports to Power BI.
• Supported data visualization and reporting using Tableau, Power BI, SQL, and BI Port.
• Delivered 40% faster report turnaround to the client.
• Used BI Port to assist reporting migration and improve delivery process.

• Utilized advanced Excel, Power BI, SQL Server, and Fabric for data analysis and reporting.
• Wrote SQL queries to load data into Power BI and handled most transformations and source-level filters to improve DirectQuery report speed.
• Moved data from multiple sources into Fabric and created single source of truth for organization.
• Created shortcuts and dataflows in Fabric to improve data access for developers.
• Optimized reports by removing extra columns and building bridge tables to resolve many-to-many relationships.
• Managed flat files and Excel files in OneLake to centralize access and reduce local file duplication.
• Performed troubleshooting to resolve data validation issues.

Analyzed data using Power BI and Microsoft SQL to identify trends and insights.

• Created reports for pipeline activity data to monitor and address failures proactively.
• 30% improvement in response time for fixing the issues and reducing failures of the pipeline activity

• Developed KPIs for impressions, reach, CTR %, cost per click, monthly ad spend, CTR by age group, and lead metrics to support data-driven marketing decisions.
• Enhanced business strategies by analyzing data and generating reports, leading to a 50% improvement in strategic decision-making.
• Developed Social Media Marketing Analytics Reports on Looker Studio
• Utilized 3rd party tools for extraction of Facebook and Instagram data to Looker Studio
• Utilized Google BigQuery instance to store the historical data of lead centre as by default, business was able to see only 3 months of data using Meta Graph API
• Technologies Used: Looker Studio, Google BigQuery, Google Sheets

• Technologies Used: Power BI, Data Lake Azure Cognitive Services, Azure Data Factory
• Engaged with the client to clarify project requirements and ensure alignment with business objectives.
• Developed a report to periodically track employee experience at onboarding, 3 months, and 6 months.
• Built key metrics for employee experience based on designation, grade, age, and promotion timeline, with drill-through capabilities for respective KPIs. Separate pages
• We get data through the HR Systems API. Used ADF to get data into Datalake, from Datalake to Power BI.
• Performed sentiment analysis using Azure cognitive services.

• Collaborated with the business team to develop a logistics tracking report for near real-time updates and an inventory report refreshed twice daily.
• Built reports using composite model, delivering near real-time data and refreshing key performance indicators twice daily.
• 40% improved business outcomes through live tracking of dairy collection to delivery
• Technologies Used: Power BI, AWS Redshift

• Technologies Used: Power BI, MySQL
• Optimized performance of 50+ page report to enhance load times and user interaction
• Redesigned UI of existing report to improve accessibility and clarity
• Recommended visual updates to modernize reports and enhance user experience
• Added new visuals and new calculations as per the request of the client
• These changes have improved user consumption by 15%
• Engaged with a client to understand their needs and expectations.

• Created visualizations in Power BI and utilized Microsoft Report Builder for tabular data visualization, improving user insights
• Built reports for direct and indirect taxes with source-level transformations to enhance data accuracy and accessibility
• Utilized Power BI Report Server, Microsoft Report Builder, MS SQL, and PostgreSQL to manage data and reporting tools.
• Implemented custom authentication to streamline report access for end users, eliminating repetitive credential input

• Identified key KPIs; enhanced visibility into average time to reimbursement, prior authorization turnaround time, and claim denial rate.
• Developed Time Intelligence and regional reports, providing actionable insights for decision-making.
• Optimized SQL queries to enhance performance.
• Engaged with a client to clarify needs, ensuring alignment of BI solutions with business objectives.
• Technologies Used: Power BI, SQL

• Led BI reporting for Aer Lingus client stakeholders across operations and finance.
• Built Power BI dashboards for airline performance and executive review.
• Utilized Power BI Report Server, Oracle, Azure Synapse Analytics, and Excel for data analysis.
• Developed a report tracking course completion status of employees by department, designation, grade, and course category, including YOY comparison and hours spent on each course.
• Queried SQL datasets to support flight, customer, and revenue analysis.

• Created master semantic model and department-wise RLS in Power Pivot; built KPIs, scheduled data refresh, and shared reports with users for improved accessibility
• Created and monitored KPIs including Batch Success Rate, Overall Equipment Effectiveness, and Cold Chain Excursion Incident Rate to drive operational performance
• Developed interactive dashboards in Power BI to enhance data visualization and facilitate decision-making

• Built Power BI dashboards for SILL production optimization teams.
• Utilized Power BI and Excel to analyze data trends.
• Developed data models for production, quality, and inventory analysis.
• Queried SQL databases for operational and manufacturing reporting.
• Built comprehensive sales report for Essilor India, tracking monthly, yearly, and weekly sales, YOY comparisons, regional and area sales, employee performance, and category- and product-wise revenue