Data Analyst with 3 years of experience analyzing large operational datasets across Healthcare/Pharma Manufacturing, Commercial Real Estate, and Nonprofit sectors to identify trends, performance metrics, and financial in…
Data Analyst with 3 years of experience analyzing large operational datasets across Healthcare/Pharma Manufacturing, Commercial Real Estate, and Nonprofit sectors to identify trends, performance metrics, and financial insights that drive client decision-making. Skilled in advanced SQL (joins, subqueries, window functions, aggregations, query optimization, stored procedures, views, indexes) against SQL Server and PostgreSQL. Strong hands-on experience designing and developing operational dashboards and analytics reports using Power BI, Tableau, and advanced Excel (pivot tables, advanced formulas). Experienced in designing and maintaining ETL/ELT pipelines and data models, integrating data from multiple sources — databases, flat files, and APIs — with strong focus on data validation, reconciliation, and troubleshooting. AWS Certified Cloud Practitioner with hands-on exposure to AWS cloud analytics services, Python automation, and Microsoft Power Platform (PowerApps, Power Automate). Background in building audit-ready, regulatory-compliant reporting within a WHO cGMP healthcare manufacturing environment; comfortable in client-facing, consulting-style delivery within Agile/Scrum.
Experience
N
Data Analyst
NWS Soft Consulting Pvt. Ltd.·Pune, India
Jul 2023 - Present · 3 years 4 months
<p>Analyzed large healthcare manufacturing operational datasets to identify trends, performance metrics, and operational insights, building 10 Power BI dashboards (DAX, Power Query, Star Schema modelling) with automated refresh to monitor OEE, Yield %, Rejection Rate, and Downtime — lifting operational visibility by 15% for plant leadership.</p><p> Designed and maintained analytics datasets and data models used for operational dashboards, investigating production failures and batch deviations through anomaly detection and root cause analysis — contributing to a 10% reduction in yield losses over 6 months.</p><p> Built WHO cGMP-compliant, audit-ready dashboards for batch traceability, deviation reporting, and CAPA tracking, in line with healthcare regulatory data security standards, alongside a Python-based extraction and transformation pipeline for production datasets.</p><p> Ran daily data validation, reconciliation, and troubleshooting checks across PostgreSQL and SQL Server to ensure accuracy across analytics datasets, while delivering ad-hoc SQL analysis on production variances to QA and Supply Chain stakeholders.</p>
