Lakshmi Kantha Reddy
Data Analyst with almost 4 years of experience delivering data-driven insights through advanced analytics, statistical modeling, and scalable data pipelines. Strong expertise in SQL, Python, R, and BI tools to analyze complex datasets and build executive dashboards.
ETL PipelinesRisk AnalyticsCloud PlatformsData Visualization
Location
Herndon, VA
Experience
~4 Years
Current Role
Data Analyst @ PNC Financials
Primary Toolset
SQLPythonRTableauPower BIAWSSnowflakeAirflow
Skills
Programming & Analysis
PythonPandasNumPySciPyStatsmodelsscikit-learnTensorFlowRSQLAdvanced QueriesJoinsCTEsWindow FunctionsSASJupyter NotebookData CleaningExploratory Data Analysis (EDA)
Data Pipeline & Integration
AirflowdbtAzure Data FactoryAWS GlueDatabricksData ModelingData WarehousingData Ingestion PipelinesAPI IntegrationsWorkflow AutomationFeature EngineeringHypothesis Testing
Databases & Cloud
SnowflakeAWS RedshiftPostgreSQLMySQLBigQueryMongoDBAWS S3CSV/JSON Processing
Visualization & BI
TableauPower BIExcel (Advanced)StreamlitPlotlyMatplotlibSeabornExecutive KPI DashboardsFinancial & Risk ReportingTrend AnalysisData Storytelling
Machine Learning & Predictive Analytics
Regression & Classification ModelsXGBoostTime-Series Forecasting (LSTM)ClusteringEnsemble MethodsModel ValidationCross-ValidationModel Evaluation (ROC-AUC, F1, Precision/Recall)
NLP & Text Analytics
Sentiment Analysis (FinBERT, DistilBERT)Retrieval-Augmented Generation (RAG)Text Embeddings (Sentence-Transformers)Document Intelligence
MLOps & Model Management
MLflowModel Versioning & MonitoringPerformance TrackingExperiment Logging
Data Governance & Quality
Data ValidationReconciliationAudit ControlsData Quality ChecksData Drift Detection (Evidently AI)Regulatory Compliance (SOX, PCI-DSS)Governance Standards
Tools & Collaboration
GitGitHubDockerGitHub Actions (CI/CD)Azure MLPython 3.11LoguruAgile/Scrum
Experience
PNC Financials
Data Analyst
- Designed scalable ETL pipelines using SQL, Python, Airflow, and dbt to integrate multi-source financial, transactional, and risk data, improving data availability and accuracy by 35%.
- Built executive dashboards using Tableau, Power BI, and Python (Matplotlib, Plotly), delivering real-time financial KPIs and risk metrics, accelerating data-driven decision-making by 40%.
- Collaborated with risk analytics, fraud detection, and data science teams on feature engineering, validation, and A/B testing using Databricks, TensorFlow, and PostgreSQL, improving predictive model performance by 20%.
- Ensured enterprise-grade data quality and governance across Snowflake, Redshift, SAS, and MySQL by implementing automated validation, reconciliation, and audit checks.
- Performed advanced ad-hoc and exploratory financial analysis using Excel, SciPy, Statsmodels, AWS S3, and Redshift, generating actionable insights on credit risk drivers.
- Partnered with finance, risk, compliance, and technology teams in Agile environments to translate requirements into KPIs and automated reports, reducing manual reporting effort by 40%.
Avenir Technologies
Data Analyst
- Analyzed large-scale customer transaction, behavioral, and risk datasets using Python and R, applying statistical modeling and segmentation, improving marketing targeting precision by 50%.
- Designed and optimized SQL-based ETL pipelines and data models across Snowflake, AWS Redshift, and BigQuery, increasing data scalability by 45% and reducing reporting latency by 40%.
- Built and validated regression and classification models using Python, scikit-learn, TensorFlow, and XGBoost, achieving 35% prediction accuracy improvement and enabling real-time monitoring.
- Developed interactive dashboards and executive reports using Tableau, Power BI, SQL, and Excel, tracking KPIs such as churn, revenue, and fraud risk.
- Automated data workflows and quality checks using AWS Glue, Airflow, SAS, Alteryx, and Azure ML, improving customer retention by 40% while enhancing analytics system scalability by 35%.
Projects
Education
Webster University
Master of Information Technology Management
Key coursework
Data AnalyticsIT StrategyDatabase ManagementBusiness IntelligenceCloud Computing