Data Analyst Power Bi

Charitha J

Data Analyst

USA +1-913-***-**** ************@*****.*** Linkedin

SUMMARY

Data Analyst with 4 years of experience in data integration, ETL development, and large-scale data processing across healthcare, finance, energy, and technology domains.

Expertise in building and optimizing data pipelines, data lakes, and real-time data solutions using Apache Spark, Python, and AWS, ensuring efficient data architecture and workflow optimization.

Proficient in SQL, Python, and R for data transformation, statistical analysis, and predictive modeling, with hands-on experience in machine learning (TensorFlow, Scikit-Learn) for predictive analytics.

Skilled in cloud platforms (AWS, GCP, Azure) with expertise in ETL tools like Apache Airflow, Talend, and Databricks, ensuring data governance, security, and compliance (HIPAA).

Developed interactive dashboards using Power BI and Tableau, automating workflows with Python and Alteryx, and delivering actionable insights to stakeholders.

Strong collaboration and project execution skills, leveraging Agile methodologies (JIRA, Confluence) to drive secure and efficient data solutions in cross-functional teams.

TECHNICAL SKILLS

Core Skills Data Cleaning, Data Wrangling, Statistical Analysis, Trend Analysis, Report Automation

Programming Languages SQL, Python, R, SAS

Data Visualization Power BI, Tableau, Excel (Pivot Tables, VLOOKUP, Conditional Formatting, Charts)

ETL Tools Talend, informatica, SSIS (SQL Server Integration Services), informatica

Databases MySQL,PostgreSQL,Oracle,MongoDB, DataWarehousing(Amazonredshift, Snowflake)

Big Data Tools Apache Spark, Hadoop (HDFS), PySpark

Cloud Platforms AWS (Redshift, S3, RDS, QuickSight), Azure (Data Factory, Blob Storage, Data Lake)

Statistical Analysis Hypothesis Testing, A/B Testing, Regression Analysis, Predictive Modeling

Project Management Agile, Sprint Planning, JIRA, Confluence

Version Control Git, GitHub

Data Governance & Security Data Encryption (AWS KMS, Azure Key Vault), GDPR Compliance

WORK EXPERIENCE

Data Engineering Analyst

United Health Care, NC Feb 2024 – Current

Analyzed electronic health records (EHR) and patient survey data using SQL, Python (Pandas, NumPy), and Tableau to identify key trends and improve patient outcomes.

Developed a predictive model for readmission risk using scikit-learn and R to help optimize post-discharge care, improving patient retention by 15%.

Automated data collection and validation workflows using ETL tools (Talend, Informatica), ensuring data accuracy and consistency across clinical datasets.

Built interactive Power BI dashboards to monitor KPIs related to hospital performance, patient satisfaction, and resource utilization.

Collaborated with healthcare teams to ensure compliance with HIPAA regulations and data governance standards using MySQL and PostgreSQL.

Implemented cloud-based solutions for data storage and analysis using AWS (S3, RDS) and Apache Spark to handle large-scale health data, improving query performance by 30%.

Data Analyst

Capgemini, India Jan 2020 – Dec 2022

Led data extraction and analysis for financial reporting systems, integrating data from SAP and Oracle into Power BI dashboards for real-time insights supporting regulatory compliance.

Created ad-hoc reports and data extracts in TOAD and SQL Developer to support business needs, ensuring timely and accurate data delivery.

Conducted comprehensive data analysis to identify trends and anomalies, collaborating with finance and risk management teams to improve reporting efficiency by 25%.

Developed and automated financial models in Python, forecasting cash flow and reducing forecasting errors by 15%.

Utilized SQL to conduct in-depth analyses for credit risk assessments, enhancing accuracy in risk management processes by 20%.

Implemented a predictive model for fraud detection, significantly improving the company's risk assessment capabilities.

Managed and cleaned large datasets using Talend ETL tools, ensuring data integrity and quality for regulatory reporting and compliance.

Performed gatekeeping and governance on strategies and models developed for fraud detection, ensuring all implementations met production standards within the SAS Fraud Management environment.

Conducted and executed UAT test cases for data enrichment, hotfixes, upgrade projects, and model implementations, validating all new capabilities within the SAS Fraud Management ecosystem.

Worked extensively in Enterprise Data Warehousing (EDW) environments, handling Very Large Databases (VLDB) to optimize data extraction and reporting processes.

Developed ETL workflows using Informatica and Talend to automate data processing, reducing manual intervention by 25%.

Collaborated with testing teams to ensure accurate data validation and reconciliation for financial audits, improving the overall audit process by 20%.

Wrote complex SQL queries to extract and manipulate data from Snowflake databases, optimizing data retrieval processes for dashboard development.

Collaborated with supply chain teams to gather requirements and translate business needs into data-driven reports and visualizations

Implemented a predictive model using scikit-learn for credit risk analysis, resulting in a 20% improvement in risk assessment accuracy.

Automated data collection processes for quarterly financial reports with Alteryx, reducing manual efforts by 30%.

Designed a financial project to optimize cost reduction strategies, utilizing Python for statistical analysis and Excel VBA for automating scenario planning.

Monitored financial performance KPIs, integrating Tableau with cloud-based data from AWS and Snowflake to enhance accuracy in financial forecasting.

Assisted in preparing detailed financial reports for senior management, combining data from QuickBooks and SQL databases into comprehensive dashboards.

Conducted statistical analysis using t-tests and optimizing risk assessment models and improving fraud detection accuracy.

Utilized Snowflake SQL Assistant for querying large datasets and Airflow for automating data pipeline processes, enhancing data integrity and reducing manual intervention.

Conducted financial variance analysis for quarterly budgets using Excel, SQL, and Tableau.

PROJECT

Voice2AI conversation assistant (python, pyttsx3, speech recognition, ChatGPT API)

A voice-driven solution utilizing Python's speech recognition library to convert spoken input into text. This system seamlessly integrates with a transformer model like GPT-3, providing natural language responses to assist with tasks such as appointment scheduling and call center interactions.

CERTIFICATIONS

Microsoft Certified Power BI Data Analyst Associate

AWS certified Solutions architect

AsI For Everyone - Coursera

Programming For Everybody (Getting Started With Python) - Coursera

EDUCATION

University of Central Missouri, Warrensburg, MO

Master’s in computer science - CGPA: 3.7/4 Jan 2023 – May 2024

Jawaharlal Nehru Technological University Hyderabad, India

Bachelor of Technology in Electrical Engineering - CGPA: 7.7/10 Jun 2017 – July 2020

Contact this candidate