Gopikrishna Lingam

• Connecting data sources and performing necessary ETL operations in Power Query to prepare datasets for reporting.
• Creating data models with relationships, calculated columns, and advanced DAX measures for robust reporting.
• Developing impactful KPIs and metrics, validating results with source data for accuracy.
• Building interactive Power BI dashboards with drill-through, bookmarks, and filters for a web-like UI/UX experience.
• Creating and managing Row Level Security (RLS) to restrict access based on user roles.
• Publishing reports to Power BI Services, creating workspaces and apps, and managing access at the workspace and app levels.
• Creating alerts, subscriptions, and scheduled refreshes to deliver timely insights.
• Performing predictive analysis and trend identification to support decision-making.
• Automating reporting by integrating CRM systems (Bitrix, Meritto) with Power BI for real-time analysis.
• Setting up and configuring WhatsApp chatbots (WABA, Interakt, Haptik) to automate reporting and client communication.
• Sustaining and optimizing existing dashboards to improve performance and usability.

• Converted Remit (PDF) files into spreadsheet format (Excel).
• Calculated patient claims manually against insurance claims.
• Ensured compliance with terms and conditions for all claims.
• Created patient claim accounts using CVS Health spreadsheets.
• Posted each spreadsheet accurately to its corresponding claim.

• Monitored stock levels to ensure optimal inventory management.
• Managed ordering and stock based on historical sales data.
• Handled billing for all products sold while ensuring compliance with local regulations.
• Projected future demand and developed strategies for new product sales.
• Created and entered sales orders using Microsoft ERP and Amazon platforms.