Data Analyst Power Bi

RAMYA SRI KARNATI

DATA ANALYST

Location: TX Email: **************@*****.*** Phone: 408-***-****

SUMMARY

•Experienced Data Analyst with over 3+ years in data analysis and visualization, proficient in basic Python and SQL for comprehensive data processing.

•Advanced Libraries Expertise in using Pandas for data manipulation, NumPy for numerical analysis, and Matplotlib for data visualization, driving actionable insights from complex datasets.

•Dynamic Reporting expert in creating interactive dashboards and detailed reports using Tableau and Power BI, translating complex data into clear, actionable insights for stakeholders.

•Database Management proficient in managing MySQL, Oracle, and MongoDB databases, ensuring data integrity, security, and optimized performance.

•Cloud Technologies leverage AWS services like EC2 for scalable computing, S3 for secure storage, and Lambda for serverless data processing, enhancing workflow efficiency.

•Agile Methodologies experienced in Agile project delivery, participating in sprint planning, stand-ups, and retrospectives to ensure timely project completion aligned with business priorities.

•Operational Efficiency committed to enhancing decision-making processes and operational efficiency through meticulous data mining, analysis, and visualization, providing invaluable insights for strategic planning and execution.

EDUCATION

Trine University MI, USA

Masters of Science in Information Studies Jan 2023 – Mar 2024

Lakireddy Balireddy College of Engineering Mylavaram, India

MBA 2017 – 2019

Sri Vani Educational Institutions Mylavaram, India

Bachelor of Pharmacy Jun 2011 – Apr 2015

TECHNICAL SKILLS

Languages: Python, SQL.

Libraries: Pandas, NumPy, Matplotlib, Scikit-Learn, SciPy, Seaborn.

Databases: MySQL, Oracle, MongoDB.

Visualization Tools: Tableau, Power BI, Microsoft Excel.

Cloud Technologies: AWS (EC2, S3, RDS, Lambda).

Methodologies: Agile, Waterfall.

Analytical Skills: Data Cleaning, Data Wrangling, Data Mining, Data warehousing, A/B Testing.

Tools: PL/SQL Developer, TOAD.

PROFESSIONAL EXPERIENCE

Blue Cross Blue Shield, CA

Data Analyst Apr 2024- Current

•Developed comprehensive reporting dashboards using Power BI to analyze customer purchase behavior and healthcare utilization patterns, aiding in the understanding of patient needs and insurance trends.

•Crafted SQL queries for ad hoc analyses and report generation, delivering timely insights into healthcare service usage and alarm categories. Designed and monitored KPIs to assess performance metrics across various projects.

•Created numerous data visualizations in Power BI, effectively communicating complex healthcare data findings to team members and stakeholders, facilitating better decision-making across various projects.

•Utilized Pandas and NumPy libraries in Python to manipulate and ensure the accuracy and consistency of data, crucial for reliable downstream analysis in the majority of data manipulation tasks.

•Performed advanced data cleansing using Excel, leveraging functions like VLOOKUPs and pivot tables to refine healthcare data, which was integral to data preparation.

•Engineered advanced data visualizations in Power BI, including Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic maps, Pie Charts, Bar Charts, and Density charts, enhancing the visual reporting of healthcare analytics.

•Conducted data validation using MySQL and Python's Pandas and NumPy libraries, ensuring high data integrity and consistency across various healthcare databases and reports.

•Automated routine data entry processes with VBA for Excel, standardizing data inputs and reducing manual errors in most data entry operations related to healthcare records.

•Extracted and cleansed data from internal databases using SQL, performing essential data cleaning and aggregation to support detailed reporting and analysis in healthcare analytics projects.

•Generated detailed reports and graphical presentations using SQL and Excel, including the use of VLOOKUP, HLOOKUPs, pivot tables, and Macros, which supported the preparation of extensive analytical reports on healthcare services and patient outcomes.

Cipla, India

Data Analyst Jan 2020 – Feb 2022

•Performed comprehensive data analysis, manipulation, and visualization using SQL and Python to derive actionable insights in healthcare-related projects.

•Formulated complex SQL queries to extract, manipulate, and analyze healthcare data from relational databases, ensuring accuracy and timeliness in reporting, thereby enhancing healthcare analytics and reducing report generation time.

•Engineered predictive models and carried out sophisticated data analysis using Scikit-Learn's powerful tools and algorithms, providing data-driven insights and decision-making as a data analyst.

•Optimized inventory management processes for a healthcare product using Oracle, reducing excess stock levels through improved demand forecasting and inventory optimization strategies.

•Crafted dynamic visualizations in Tableau for healthcare analytics, integrating calculated fields and trend lines to enable interactive exploration of healthcare data, leading to actionable insights and informed decisions.

•Conducted detailed analysis of healthcare provider datasets to evaluate facility performance, service quality, and provider specialties, aiding in network optimization and provider selection.

•Leveraged Electronic Medical Records (EMR) data to conduct comprehensive analysis and generate actionable insights, supporting evidence-based decision-making and improving healthcare outcomes through data-driven strategies.

•Developed interactive dashboards in Tableau to visualize trends and key performance indicators (KPIs) for a specific healthcare product, leading to improved campaign effectiveness through targeted optimizations.

•Integrated various hospital management data sources to create a comprehensive view of hospital operations, facilitating strategic planning and operational improvements.

•Implemented the Waterfall methodology in project management to ensure systematic completion of healthcare data analysis projects, achieving a high rate of on-time delivery and meeting industry standards.

•Utilized Electronic Health Records (EHR) data to perform detailed analysis, extracting valuable insights that informed strategic decisions and improved patient care outcomes in healthcare settings.

•Maintained code integrity and consistency in healthcare data analysis projects by utilizing Git for version control, effectively managing changes in analysis scripts, and ensuring collaborative efficiency.

•Analyzed insurance claims data to identify cost trends, treatment efficacy, and patient outcomes, providing insights to optimize reimbursement processes and reduce claim denials.

•Enhanced healthcare data workflow efficiency and scalability by implementing AWS Lambda functions for automated data processing, coupled with end-to-end solutions on AWS utilizing S3 and EC2 for secure storage and computation.

•Discovered valuable strategic insights by executing comprehensive data mining and cleansing procedures specific to healthcare data, uncovering hidden patterns and correlations while maintaining data integrity and enhancing analysis accuracy.

•Conducted comprehensive data profiling in healthcare datasets to identify anomalies and outliers, ensuring data accuracy and reliability for informed healthcare decision-making.

Ouranos Technologies Pvt Ltd, India

SQL Developer May2019 – Dec 2019

•Analyzed, designed, developed, and tested applications to ensure robust functionality, contributing to increased system reliability and user satisfaction.

•Utilized FTP/Telnet protocols to securely transfer .rdf files from a UNIX box to the local machine, reducing file transfer times and facilitating efficient data manipulation.

•Developed complex PL/SQL batch processing jobs using UNIX Shell scripting, automating routine data processing tasks and improving overall system efficiency.

•Authored comprehensive PL/SQL scripts, including stored procedures, triggers, and views using TOAD, enhancing database functionality and performance.

•Modeled data and transformed raw data into actionable insights using Power BI, creating interactive dashboards that improved reporting and data analysis.

•Executed performance tuning for various Oracle-based applications using EXPLAIN PLAN and TKPROF, optimizing query performance and resource utilization.

•Managed data backup and recovery operations using RMAN, safeguarding critical data and ensuring business continuity with reduced recovery times.

Contact this candidate