Nikitha Bala Pilli

Nikitha Bala Pilli Healthcare & Pharmacy Data Analyst | Power BI, SQL, Excel | Claims, Eligibility, Financial Modeling | - | Gmail SUMMARY​ Data Analytics and Data Engineering expert with 6+ years of experience specializing in healthcare and pharmacy claims analysis. Proficient in building real-time dashboards and financial models using Power BI, Tableau, SQL, DAX, and Excel. Experienced in integrating data from Azure Synapse, SharePoint, and Microsoft Lists to deliver seamless reporting solutions. Skilled in managing secure cloud environments, Linux systems, and troubleshooting via Splunk logs and APIs in ServiceNow. Adept at collaborating with stakeholders, documenting in JIRA/Confluence, and translating complex data into actionable insights to drive operational efficiency and data-driven decision-making. WORK EXPERIENCE Data Analyst | CVS Health | USA​ Oct 2024 – Present ●​ Analyzed pharmacy and medical claims data from large datasets to support formulary strategies, resulting in a 12% reduction in unnecessary drug costs. ●​ Collected and interpreted business requirements to build Power BI dashboards that improved data visibility and reduced manual reporting time by 30%. ●​ Designed ETL workflows using Stitch to extract and load data from HubSpot, Segment, and backend PostgreSQL into BigQuery, ensuring real-time availability of customer engagement metrics. ●​ Built and maintained modular dbt models for transformation logic, improving query performance by 30% and standardizing business metric definitions across teams. ●​ Developed dashboards in Metabase and Mixpanel to visualize user behavior, feature adoption, and marketing campaign performance, driving data-driven product decisions. ●​ Collaborated with business teams and mentored interns, providing guidance on analytics best practices and ensuring consistent project delivery standards. Data Engineer | Springer Capital Properties | USA​ Jan 2024-Sep 2024 ●​ Coordinated with business teams to gather data needs and document clear requirements. ●​ Built dashboards and automated reports in Power BI to help teams make better decisions. ●​ Integrated Sharepoint with PowerBI and created reports as per the business needs. ●​ Researched Azure Cognitive Services for integrating them into business applications to enhance data analysis capabilities. ●​ Explored Azure SQL Database and Azure Cosmos DB for efficient data storage and management, ensuring scalability and performance for hosting large datasets. ●​ Assisted in connecting Azure Synapse Analytics with Power BI to enable real-time data visualization and reporting, improving data-driven decision-making for AI-based projects. ●​ Communicated key insights to management and stakeholders, leading to increased leadership responsibilities and positive feedback on performance. Data Engineering Senior Analyst | Accenture | India​ Jan 2019- Jul 2023 ●​ Provided clients with dedicated and managed platforms in the myWizard AiOps cloud, helping them run automation applications smoothly and troubleshoot any issues they faced. ●​ Monitored and optimized AWS EC2 instances and Linux servers, ensuring high performance, managing backups, and maintaining reliable file storage infrastructure. ●​ Set up and managed AWS networking, including VPC peering, security groups, load balancers, and Route 53 domain configurations, while keeping Apache servers running efficiently. ●​ Strengthened cloud security by implementing multi-factor authentication, access key rotation, and encryption with KMS, along with cleaning up unused resources and decommissioning outdated setups. ●​ Handled Splunk administration, participated in upgrading activities , monitoring and maintaining the license of on-prem and on-cloud , resolving access and compatibility issues, creating dashboards and alerts, managing system upgrades, and troubleshooting critical issues to meet SLAs. ●​ Streamlined workflows by integrating applications with ServiceNow, resolving ticket flow issues using Splunk and Postman, automating compliance alerts, and documenting processes for seamless team operations. ACADEMICS ●​ Master’s Data Analytics, Concordia University, Saint Paul, MN SKILLS Databases & Languages :​ SQL Server, MySQL, PostgreSQL, Azure SQL, Cosmos DB, DAX, Power Query (M), Python(Pandas, NumPy, Matplotlib, Seaborn) ETL & Data Warehousing : SQL-based ETL, Data Modeling, SharePoint Integration, Power Automate , Stitch, dbt Cloud platforms :​ Azure (Synapse, Cognitive Services), AWS (EC2, S3, VPC, Route 53, KMS) Visualization Tools : ​ Tableau, Power BI, DAX, AWS QuickSight , Metabase, Mixpanel Monitoring & Ticketing Tools : Splunk (Admin, Logs, Alerts), ServiceNow (Incidents, Service Requests), Postman Other Tools :​ JIRA, Excel - Pivot Tables , Linux CERTIFICATION ●​ AWS Certified Solutions Architect – Associate ●​ Microsoft Certified: Power BI Data Analyst Associate – In Progress ACCOMPLISHMENTS ●​ Created a report using Splunk Report Extractor to automate the weekly status report generation, reducing manual effort by 80% and improved efficiency. ●​ Automated IAM access key age calculation using Splunk and scheduled compliance alerts using AWS SES and Splunk which reduced the workload by 70% . LEADERSHIP AND AWARDS ●​ Process Automation Leader: Automated work processes to generate weekly reports, significantly reducing team workload and improving overall efficiency. ●​ Recognition for Reliability: My consistent on-time completion of daily deliverables and my innovative ideas to enhance work processes were regularly acknowledged, validating my work ethic and commitment. ●​ Active Team Participant: I have been an active participant in office extra-curricular activities, consistently contributing to the fostering of a positive and collaborative work culture. ●​ Championing Equality Award: Senior management also recognized me for supporting and guiding peers, taking ownership of critical tasks, and promoting a positive and inclusive team environment.