S

Shiva Prakash Reddy Gopanpally

About

Detail

Maryland, United States

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • Capital Bank
    Senior Data Analyst
    Capital Bank
    Nov 2024 - Current (1 year 11 months)
    • Drove risk mitigation by analyzing large-scale customer transactions, loan portfolios, and credit risk datasets using Python, SQL, and advanced statistical modeling—improving credit decision accuracy by 15%. • Streamlined data quality by cleaning, pre-processing, and transforming raw banking data from multiple systems with Pandas and NumPy, reducing errors and improving analysis turnaround by 30%. • Built and deployed 50+ interactive dashboards in Tableau, Power BI, and Looker, delivering real-time insights into KPIs (NPL ratios, fraud alerts, deposit growth) that empowered executives to make faster, data-driven decisions. • Optimized data infrastructure by managing Snowflake, AWS Redshift, and Google Big Query environments— improving
  • MedStar Health
    Senior Data Analyst
    MedStar Health
    Nov 2023 - Oct 2024 (1 year)
    • Enforced data quality standards across healthcare datasets by monitoring pipelines and resolving issues in real time, ensuring 99% accuracy in reporting and compliance. • Designed and automated ETL processes to integrate healthcare data from EHR systems, claims databases, and third party APIs, reducing data processing time by 40%. • Built 30+ interactive dashboards and reports in Power BI, Tableau, and Qlik to deliver actionable insights on patient outcomes, member engagement, and claims processing efficiency. • Optimized SQL queries and storage solutions across SQL Server, Oracle, MySQL, Snowflake, Redshift, and BigQuery, improving query performance by up to 50%. • Leveraged Hadoop, Spark, and Kafka to process and analyze terabytes
  • Unilever
    Data Analyst
    Unilever
    Aug 2021 - Jul 2023 (2 years)
    • Designed and implemented ETL pipelines using SQL, Apache NiFi, and Talend to integrate financial transaction data from various sources into data warehouses. • Developed and maintained data warehouse systems using SQL Server, Snowflake, and Amazon Redshift to ensure efficient data storage and querying for financial analysis. • Created interactive dashboards and visual reports using Tableau, Power BI, and QlikView to provide actionable insights to business stakeholders. • Applied machine learning algorithms for predictive analytics using Python (scikit-learn, pandas) to forecast financial trends, customer behaviour, and service demand. • Developed tools for monitoring system performance and transaction activity using Prometheus, Grafan
  • Takeda Pharmaceuticals
    Data Analyst
    Takeda Pharmaceuticals
    Jun 2020 - Jul 2021 (1 year 2 months)
    • Developed and maintained interactive dashboards and reports using Power BI, Tableau, and Excel to present key performance indicators (KPIs) for pharmaceutical operations and sales management. • Integrated data from multiple sources, including sales data, inventory, and clinical trial data, ensuring accuracy and consistency using SQL, Python, and ETL tools. • Applied machine learning algorithms using Python and scikit-learn to predict market trends, optimize inventory management, and improve drug sales strategies. • Designed and implemented custom ETL pipelines using Informatica, Alteryx, and custom scripts to extract, transform, and load data from various pharmaceutical systems, ensuring seamless integration and efficient data process
Education verified_user 0% verified
  • U
    Masters in information
    University of Maryland Baltimore County
    Aug 2023 - May 2025 (1 year 10 months)