Sai Charan Paithara

About Sai Charan Paithara

Data Analyst with 4+ years of experience managing Agile-driven SDLC projects in healthcare and financial sectors, focusing on advanced data analysis, statistical modeling, data visualization and deriving actionable insights to improve business outcomes. • Strong expertise in Python, SQL, and R, with significant proficiency in data science libraries such as Pandas, NumPy, Scikit-learn, and seaborn for data manipulation, exploratory data analysis, and machine learning model development to evaluate trends, optimize processes, and enhance analytical accuracy. • Proficient in handling and optimizing large datasets across SQL Server, Oracle. Leveraged cloud platforms like AWS and Azure and developed interactive dashboards and reports in Power BI and Tableau empowering data-driven strategic decision-making.

Experience

1. Data Analyst

   PNC

   Nov 2023 — Present · VA, US

   Enhanced data accuracy by 20% across 1M+ customer records by automating data validation, cleaning, and reconciliation using SQL and Python (Pandas, NumPy), ensuring compliance with data governance policies.• Designed interactive reports in Microsoft Excel with PowerPivot and advanced formulas (INDEX-MATCH, SUMIFS, VLOOKUP), improving KPI tracking and performance analysis for finance and operations teams.• Conducted ad hoc data analysis on credit risk, loan performance, and transaction trends, generating insights that influenced strategic decision-making for senior management.• Developed and maintained SQL queries and stored procedures to extract, transform, and load (ETL) large datasets fromOracle and SQL Server for reporting and analysis, reducing data retrieval time by 30%.• Automated KPI tracking for loan default rates, transaction volumes, and operational metrics by developing interactive dashboards in Tableau and Power BI, improving report turnaround time by 40%.• Enhanced loan approval strategies by analyzing 20+ financial variables (credit history, income trends, spending behavior) and collaborating with business and risk teams to refine lending models.• Led data migration from legacy banking systems to cloud platforms (AWS S3, Snowflake), ensuring seamless integration and maintaining a 98% data quality success rate.• Boosted customer retention by conducting monthly churn analysis using Python, uncovering patterns in customer behavior, and delivering actionable insights to customer experience and retention teams.• Optimized ETL workflows for financial data pipelines in Snowflake and Databricks, reducing data processing time and improving real-time financial reporting.• Improved data accessibility for risk analysts and regulatory teams by documenting SQL scripts, data dictionaries and data lineage workflows, enhancing standardization and compliance reporting.

Education

• George Mason University

  Master of Science - MS

  2022 — 2024

• BV Raju Institute of Technology (BVRIT)

  Bachelor of Technology - BTech

  2018 — 2022