Data Analyst

Hemanth Kumar Vatti

OH +1-330-***-**** *****************@*****.*** LinkedIn

SUMMARY

Experienced Data Analytic professional with over 3 years of expertise in data-driven decision-making, analytics, and financial modeling. Adept at utilizing Python, SQL, and R for data analysis, along with advanced machine learning libraries like Scikit-learn and TensorFlow to build predictive models. Proficient in leveraging cloud technologies such as AWS and GCP for scalable data solutions and skilled in data visualization using Tableau, Power BI, and Matplotlib to present actionable insights. Proven track record of collaborating with cross-functional teams to drive business strategies and optimize performance in financial and IT services sectors. Committed to delivering high-quality, data-informed solutions while ensuring accuracy and efficiency in data pipelines. Strong ability to adapt to evolving business requirements and work seamlessly in Agile environments.

SKILLS

Programming Languages Python, R, Java, SQL

ETL Tools Tableau Prep, Dataiku, Alteryx, SSIS, Power Automate, Azure ML, Spark, GCP Databases MS SQL Server, Mongo DB, Oracle, Hive

Other Skills

Data Visualization

Machine Learning, Data Modeling, Data Visualization, Simulation, Optimization Tableau, Power BI, Matplotlib, seaborn

EXPERIENCE

Capital One, USA Oct 2024 – Present

Data Analyst

• Designed and implemented ETL pipelines to extract, transform, and load financial transaction data from multiple sources (credit card transactions, loan data, customer demographics) into a centralized database using SQL Server and AWS Redshift, ensuring timely and accurate reporting.

• Performed detailed exploratory data analysis (EDA) on large financial datasets to identify key trends, patterns, and anomalies, utilizing Python

(Pandas, NumPy) and R (ggplot2, dplyr), helping to uncover insights into customer credit behavior and portfolio performance.

• Engineered advanced machine learning models using Scikit-learn, including Logistic Regression and Decision Trees; enhanced loan default prediction accuracy by 35%, enabling more informed credit approval decisions for over 1,000 applicants monthly.

• Utilized SQL for complex data aggregation and reporting, developing automated queries to track key financial metrics such as delinquency rates, loan default probability, and credit utilization, facilitating real-time reporting for financial managers.

• Built and maintained interactive dashboards in Tableau and Power BI to visualize credit risk analysis, portfolio diversification, and performance metrics, enabling stakeholders to make data-driven decisions regarding credit products and customer management.

• Performed time series analysis on historical financial data, applying statistical techniques to predict future financial trends, such as interest rates, loan defaults, and customer behavior, which supported risk mitigation strategies.

• Collaborated with business units, including risk management and finance teams, to align data insights with business objectives and improve reporting accuracy for regulatory compliance and internal financial assessments. Reliance Industries Ltd, India Sep 2022 – July 2023 Data Analyst

• Spearheaded data analysis for IT service management, focusing on incident response times, resolution times, and root cause analysis for critical IT incidents, using SQL and Python to extract and clean service request data from ITSM tools like ServiceNow.

• Utilized Python and SQL to analyze historical incident data, identifying trends and patterns in service disruptions, enabling teams to prioritize high-impact incidents and implement targeted improvements in incident resolution workflows.

• Developed real-time interactive dashboards using Power BI to monitor IT service performance, providing the IT operations team with actionable insights such as incident volume, average resolution time, and SLA compliance, enhancing decision-making processes.

• Applied statistical techniques like regression analysis and hypothesis testing to assess the effectiveness of IT service improvements and validate incident management strategies based on key metrics like mean time to recovery (MTTR) and customer satisfaction.

• Automated reporting processes by integrating SQL queries into Power BI, reducing manual reporting time and ensuring consistent and up-to- date incident management reports to stakeholders on a weekly and monthly basis.

• Worked closely with cross-functional IT support teams, translating data insights into actionable recommendations to reduce incident recurrence, optimize resource allocation, and improve IT service delivery, resulting in enhanced system reliability and user satisfaction.

• Provided detailed data-driven insights into recurring issues and provided suggestions for process automation in the IT service lifecycle using Python scripts, reducing repetitive manual tasks and increasing incident resolution efficiency. Wissen Infotech Pvt. Ltd., India Aug 2018 – Jul 2020 Big Data Engineer

• Led the analysis of financial transaction data using SQL and Python to identify trends, anomalies, and insights in financial operations, helping improve risk management strategies for clients in the finance sector.

• Developed risk modeling algorithms using machine learning techniques (Logistic Regression, Decision Trees) to predict potential financial risks, enhancing the accuracy of risk assessments and reporting.

• Built and maintained automated financial reporting systems using Power BI and Tableau to visualize key performance indicators (KPIs) such as revenue, expenses, and profitability, providing stakeholders with real-time insights into financial performance.

• Implemented a centralized data repository in AWS Redshift to integrate disparate financial datasets, streamlining data access and analysis for finance teams and improving overall operational efficiency.

• Collaborated with cross-functional teams, including financial analysts and portfolio managers, to ensure accurate financial data aggregation and reporting, supporting investment decision-making processes.

• Performed ad-hoc financial data analysis using Python and Excel VBA to clean, transform, and model large datasets, ensuring data accuracy and integrity across financial reports and dashboards.

• Supported clients in regulatory compliance by ensuring financial data met industry standards (SOX, IFRS) and produced audit ready reports, thereby reducing the risk of non-compliance penalties. EDUCATION:

Master of Science in Data Science Aug 2023 – Dec 2024 Kent State University, Kent, OH

Master of Technology in Data Science & Machine Learning Jul 2020 – May 2022 PES University, Bengaluru, India

Bachelor of Technology Computer Science & Engineering Sep 2014 – May 2018 B.V. Raju Institute of Technology, Narsapur, India CERTIFICATIONS:

• AWS Certified Cloud Practitioner CLF – C02 Expiry: - 04/2027

• Certified Pega Senior System Architect and System Architect (CSA & CSSA) PROJECTS

Analyzing Mortality Data: Insights and Predictive Modeling

• Analyzed mortality data to identify correlations between demographic factors (age, sex, race) and causes of death, offering valuable insights into public health trends.

• Built and deployed predictive models using Machine Learning algorithms (Random Forest, Gradient Boosting, Deep Neural Networks) to accurately forecast mortality outcomes based on demographic data.

• Delivered actionable insights to guide healthcare policy improvements and strategies aimed at reducing mortality rates, informed by rigorous data analysis and modeling.

Contact this candidate