Analytical and detail-oriented Data Analytics Professional with 9+ years of experience at the intersection of data analysis, application support, QA/testing, and IT systems across pharma, healthcare, retail, and finance. Proven track record in extracting, validating, and analyzing complex datasets to ensure accuracy, compliance, and actionable business insights in highly regulated environments (HIPAA, GRC, OFSAA, POS, CRM).
Proficient in SQL-based querying, ETL testing, and data warehouse validation (Oracle, SQL Server, MySQL, DB2, Teradata, NoSQL), with deep expertise in data mapping, lineage, and discrepancy resolution. Skilled in designing dashboards and reports using Power BI and Tableau to translate raw data into business intelligence solutions that support decision-making, performance tracking, and regulatory reporting. Experienced in documenting and delivering functional specifications (RTM, FSD, TDD), enabling clear data traceability across enterprise systems.
Hands-on experience with automation testing and scripting (Selenium, Python, Excel Macros, Java), enabling rapid data validation and quality assurance in BI pipelines. Adept at supporting analytics-driven projects end-to-end — from data extraction and cleansing, to analysis, visualization, and stakeholder presentation. Strong background in collaborating with technical and business teams, mentoring junior analysts, and building governance-oriented data solutions.
Notable Projects & Contributions:
- Conducted data discrepancy analysis across ETL pipelines; identified quality gaps and recommended fixes for more reliable reporting.
- Designed RTM for 500+ Key Data Elements (KDEs) for OFSAA projects, ensuring transparent lineage, compliance, and audit readiness.
- Built advanced SQL queries and performed log/code analysis (Java, XML/XSD) to identify root causes of data and system defects.
- Created interactive dashboards in Power BI and Tableau for healthcare and financial stakeholders, improving decision-making with real-time insights.
- Validated Security GRC dashboards and reporting pipelines, ensuring accurate vulnerability tracking and metrics alignment with compliance requirements.
Core Competencies:
- Data Analysis & Visualization.
- ETL & Data Warehouse Validation ·
- BI Reporting (Power BI, Tableau) ·
- SQL Scripting & Data Mapping ·
- Data Governance & Compliance (HIPAA, GRC, TVM) ·
- QA/Testing & Automation ·
- Root Cause/Data Defect Resolution ·
- Cross-Functional Collaboration ·
- Requirements Gathering (RTM/FSD/TDD) ·
- Agile/Scrum Delivery