| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
DATA ANALYST
Ohio, USA | Gmail Id: EMAIL AVAILABLE | Ph. No: PHONE NUMBER AVAILABLE | LinkedIn
SUMMARY
With 4+ years of hands-on experience in Finance and Healthcare sectors, focusing on data extraction,
transformation, and loading (ETL) processes using SQL, Python, and advanced Excel techniques to support data-
driven decisions.
Proficient in SDLC, Agile, and Waterfall methodologies, with hands-on experience in Python and SQL programming
languages.
Derived database objects and data dictionary, generating capacity planning reports using Python packages like
NumPy, pandas, and Matplotlib.
Expertise in Tableau, Power BI, and Advanced Excel for creating insightful visualizations and dashboards.
Experience with databases including MySQL, MongoDB, PostgreSQL, and Google Cloud Platform.
Extensive experience in data extraction, transformation, and loading (ETL) from various sources such as flat files,
XML files, and databases.
Participated in Facets Table data modelling planning, designing, and implementation of the data warehouse.
Conducted comprehensive market analysis in both healthcare and real estate domains, leveraging SQL and Python.
Conducted A/B testing for performance evaluation and utilized forecasting models for future trend predictions.
Used Informatica Designer, Workflow Manager, and Repository Manager for data integration and management.
Collaborated with cross-functional teams, fostering a data-driven culture within organizations, and ensuring
effective communication between technical and non-technical stakeholders.
SKILLS
Methodologies: SDLC, Agile, Waterfall
Programming Language: Python, SQL, R
Packages: Scikit-Learn, ggplot2, Pandas, NumPy, Matplotlib, SciPy, Seaborn
Visualization Tools: Tableau, Power BI, Advanced Excel (Pivot Tables, VLOOKUP, Power Query)
IDEs: Visual Studio Code, PyCharm, Jupyter Notebook, IntelliJ
Database: MySQL, MongoDB, PostgreSQL, Oracle, Tera Data
Cloud Technologies: Google Cloud Platform
Other Technical Skills: Google Analytics, DAX, SAS, JIRA, SAP, SSIS, SSRS, Machine Learning Algorithms,
Mathematics, Probability distributions, Confidence Intervals, Hypothesis Testing,
Regression Analysis, Linear Algebra, Advance Analytics, Data Mining, Data
Visualization, Data warehousing, Data transformation, Data Storytelling, Association
rules, Clustering, Classification, Regression, A/B Testing, Forecasting & Modelling,
Data Cleaning, Data Wrangling, Process Mapping, Solution Oriented, Ad Hoc Analysis,
Project Management, Data Presentation, Requirement Gathering, Root Cause
Analysis, Data Sets, Data Modules, Quantitative Analytics, Critical Thinking,
OTBI, BIP, Communication Skills, Presentation Skills, Problem-Solving
Version Control Tools: Git, GitHub
Operating Systems: Windows, Linux, Mac iOS
EDUCATION
Master of Science in Computer science Southeast Missouri State University, Cape Girardeau, MO
Bachelor of Technology in Computer Science Sathyabama Institute of science and technology, Tamil Nadu, India
CERTIFICATION
Career Essentials in Data Analysis by Microsoft and LinkedIn.
EXPERIENCE
Data Analyst | Capital One | Mar 2023-Present
Led the development of a Financial Risk Management Dashboard designed to monitor and assess credit risk across
various portfolios, utilizing Power BI for interactive data visualization.
Performed comprehensive data extraction and transformation using SQL and Informatica, consolidating financial
data from multiple sources into a unified data warehouse to ensure accurate and timely reporting.
Conducted advanced statistical analysis with Python (pandas, numpy) to identify risk patterns and forecast
potential financial losses, resulting in a 12% reduction in credit default rates.
Collaborated with the risk management team to define key performance indicators (KPIs) and metrics, integrating
them into the dashboard to provide real-time insights and support data-driven decision-making.
Optimized data processing workflows by implementing automated ETL processes with Informatica, reducing data
latency by 30% and improving the efficiency of daily risk reporting.
Utilized Hadoop and Hive for big data management, enabling the analysis of large-scale historical financial data to
uncover trends and correlations that informed risk mitigation strategies.
Developed predictive models using R and Python to assess the impact of economic changes on credit risk,
enhancing the accuracy of risk assessments by 15%.
Ensured data accuracy and compliance with regulatory requirements by implementing rigorous data validation
procedures and working closely with the Data Governance team.
Integrated AWS cloud services such as Redshift for scalable data warehousing, ensuring secure storage and
processing of sensitive financial data.
Provided training and support to business users on utilizing the Financial Risk Management Dashboard, ensuring
stakeholders could effectively interpret and act on the insights provided.
Data Analyst | NextGen Healthcare, India | Jan 2019-Dec 2021
Led the development of a claims analytics system to identify and reduce fraud. Integrated data from claims
databases and financial records using SQL for data extraction. Used Python for data processing and anomaly
detection algorithms, which led to a 15% reduction in fraudulent claims and improved financial accuracy.
Conducted detailed data analysis and extraction from relational databases to support healthcare operations and
improve patient outcomes. Used complex queries to aggregate and filter data for various reporting needs.
Designed and implemented ETL processes to streamline data flow between different systems. Created data
pipelines for extracting, transforming, and loading data, ensuring accuracy and efficiency.
Utilized Tableau to create interactive dashboards and visualizations, enabling stakeholders to visualize and
interpret healthcare data effectively. Developed custom reports to track key performance indicators and patient
metrics.
Developed and maintained data models in Python for predictive analytics and statistical analysis. Employed
libraries such as Pandas, NumPy, and Scikit-learn for data manipulation and machine learning tasks.
Employed Redshift for data warehousing, managing large datasets, and optimizing query performance. Utilized
Redshift s SQL-based querying capabilities to analyze and retrieve data efficiently.
Performed data validation and quality checks using Alation, which helped maintain data consistency and reliability.
Managed data cataloging and lineage to ensure transparency and accuracy in reporting.
Used advanced MS Excel features and VBA scripting for complex data manipulation, automation of repetitive tasks,
and development of custom financial models and reports.
Applied SAS and SPSS for statistical analysis and interpretation of healthcare data. Used these tools for hypothesis
testing, regression analysis, and other advanced statistical methods.
Ensured compliance with data privacy laws (HIPAA) by implementing robust data security practices. Conducted
regular audits and updates to safeguard sensitive healthcare information.
Facilitated training sessions for healthcare staff on interpreting and utilizing data. Created detailed documentation
and user guides to support data literacy and effective use of analytics tools across the organization.
|
