Data Analyst Power Bi

KAUSHIK GOSA

NY +1-316-***-**** *************@*****.*** LinkedIn

SUMMARY

Data Analyst with around 4 years of experience designing, optimizing, and automating data pipelines and analytics solutions across healthcare, finance, and marketing. Experienced with ETL/ELT (Azure Data Factory, Airflow, SSIS), batch/streaming data integration (Kafka, Spark), SQL optimization (MySQL, SQL Server), and dimensional modeling. Skilled in Power BI dashboards, cloud platforms (Azure, AWS), data lakes, dbt transformations, Python for automation and predictive modeling, and handling large-scale unstructured data with MongoDB. PROFESSIONAL EXPERIENCE

Data Analyst Intern BCBS USA March 2025 – Present

● Engineered ETL with Airflow & Snowflake, eliminating 18 tasks, saving 36+ hours; orchestrated nightly ETL with Control-M, reducing 3.4 hours of delays.

● Constructed SQL to extract 24 cost insights, contributing to savings; revamped Snowflake schema, increasing query efficiency by 1.5 hours.

● Deployed 9 Power BI dashboards with DAX & incremental refresh, cutting report time by 3.5 hours; built real-time dashboards to monitor claims and SLAs.

● Exposed $42,000 in recurring inefficiencies analyzing 500,000+ claims with Python, Pandas, and Seaborn. Data Analyst / Data Engineer Cognizant India August 2021 – October 2022

● Architected scalable Informatica ETL pipelines to process over 10,000 patient records, eliminating 16 monthly hours of manual data input.

● Connected RESTful APIs to integrate EHR platforms with internal reporting dashboards, enabling real-time reporting for 4 high-traffic business units.

● Optimized inefficient SQL in PostgreSQL environments, accelerating analytics turnaround times by 2.6 hours weekly for operations teams.

● Streamlined weekly reporting procedures using Jenkins and custom shell scripts, saving 104 analyst hours annually for high-impact strategic projects.

● Secured PHI data fields across 12 highly sensitive datasets using Python and AWS Lambda, ensuring complete HIPAA compliance at all stages.

● Configured Snowflake monitors and alerts, preventing $3,200 in monthly compute overages.

● Designed and piloted 10 ETL data flow diagrams with Visio and Camunda BPMN, supporting transformation logic and regulatory requirements across six operational teams. Data Analyst Cipla India June 2019 – July 2021

● Consolidated over 500K rows of customer and operations data from CRM tools, surveys, and Excel on Azure to support exploratory and trend analyses.

● Delivered 20+ weekly reports and 10+ custom visualizations in Power BI and Matplotlib, highlighting user adoption and process efficiency insights for leadership.

● Evaluated A/B tests from major initiatives and ensured KPI accuracy across Tableau and Google Data Studio dashboards to guide strategic decisions.

● Automated daily Excel data pulls into SQL Server with Azure scripts, cutting 2 manual updates per day. PROJECTS

Texas Energy Dynamics Analysis (2019-2021): Analyzed 26M+ hourly Texas electricity rows, built a 20-step Tableau Prep flow, and created dynamic dashboards highlighting demand spikes and Winter Storm 2021 price volatility. Predictive Analysis of FEMA Assistance Eligibility: Processed 20.9M FEMA records in the cloud, developed logistic regression models to improve recall for underserved groups, and visualized findings to guide equity-focused policy. TECHNICAL SKILLS

Languages & Scripting: Python (Pandas, NumPy, Matplotlib, Seaborn), SQL, T-SQL, PL/SQL, Shell Scripting, Bash Frameworks & Libraries: Apache Spark, Spark Structured Streaming, dbt, Streamlit, DAX ETL & Orchestration: Azure Data Factory (ADF), Apache Airflow, SSIS, Informatica, Databricks, PySpark, Hadoop, Spark, Automated Data Pipelines, API Integration, Data Modeling Databases & Warehousing: PostgreSQL, MySQL, Oracle, AWS Redshift, Azure SQL Database, Google BigQuery, MongoDB, Cassandra, Redis

Data Streaming & Messaging: Apache Kafka, MongoDB Atlas Triggers Data Modeling: Star Schema, Snowflake Schema, Dimensional Modeling, Map-Reduce Patterns Cloud & Storage: Azure (Synapse, ADLS, Data Lake Storage, DevOps), AWS (S3, Glue, Redshift, EC2), MongoDB Visualization & Reporting: Power BI (DAX, Row-Level Security), Tableau, SPSS, Alteryx, Excel (PivotTables, Audit Logs)

Data Management & Governance: Data Quality Checks, HIPAA Compliance, Data Lineage, Metadata Frameworks Version Control & CI/CD: Git, GitHub, Azure DevOps Pipelines Other Tools: SQL Profiler, Execution Plans, Notion, Great Expectations EDUCATION

Master’s Degree in Data Science Wichita State University Wichita, KS December 2024

Contact this candidate