Data Analyst A Team

Yashwanth Reddy Kasala

Email: *******************@*****.***

Mobile: +1-203-***-****

Data Analyst

PROFESSIONAL SUMMARY:

Data Analyst with 4+ years of experience, demonstrating strong analytical thinking and problem-solving skills, delivering actionable insights and innovative solutions across diverse business domains. I am a team player.

Designed comprehensive dashboards, improving report accuracy and accessibility for stakeholders, while connecting dots across applications to provide an E2E view and facilitate executive summaries. I have attention to detail.

Built scalable ETL pipelines, automating transformations and enabling seamless data integration, while effectively communicating across the organization, adapting to both technical and non-technical audiences. I am good at prioritization.

Developed robust data pipelines, efficiently orchestrating multi-source ingestion workflows, and demonstrating proficiency with query tools to aid data analysis, including strong PL/SQL skills. I am willing to ask questions.

Utilized statistical modeling to enhance predictive analytics and support strategic initiatives, while demonstrating expertise with Microsoft Office suite usage and working well in a team environment. I have innovative thinking skills.

Implemented churn prediction models, integrating model outputs into marketing workflows, and achieving measurable results, while exhibiting experience with Oracle Exadata or 10g and above. I am a team player.

Conducted A/B testing and multivariate analysis to validate product enhancements, supporting UX decisions based on empirical insights, and demonstrating strong communication and presentation skills. I have attention to detail.

Created interactive dashboards to monitor real-time performance, allowing users to drill into key metrics, while demonstrating know-how working in Agile/scrum teams for prioritization and resource assignments. I am good at problem solving.

Developed data quality checks and anomaly detection alerts, ensuring accuracy across reports, while demonstrating the ability to write and analyze complex queries and stored procedures. I am good at prioritization.

Automated monthly and weekly reporting processes, eliminating manual tasks and improving delivery consistency, while demonstrating know-how of effort and financials estimation for project management. I am a team player.

Built real-time fraud detection dashboards, reducing response times by enabling proactive alerts, while demonstrating the ability to effectively communicate across the organization with minimal supervision. I have attention to detail.

Aggregated and enriched data using REST APIs and Python scraping tools, enhancing customer profiles, while demonstrating strong PL/SQL skills and the ability to analyze complex queries. I am good at problem solving.

Authored centralized data dictionaries and lineage documentation, standardizing analytics workflows, while demonstrating analytical thinking and the ability to connect dots across various applications. I am a team player.

Created reusable SQL assets to optimize logic consistency and scalability, while demonstrating expertise with Microsoft Office suite usage and the ability to influence and guide the team for success. I have attention to detail.

Mentored analysts on Python scripting and SQL performance optimization, facilitating knowledge transfer, while demonstrating willingness to ask questions and reach out for assistance as required. I am good at prioritization.

Analyzed customer feedback using NLP methods, identifying sentiment trends and converting comments into insights, while demonstrating strong communication skills to both technical and non-technical audiences. I am a team player.

Engineered survey ingestion pipelines, supporting real-time feedback dashboards, while demonstrating the ability to manage multiple projects simultaneously and work well in a team environment. I have innovative thinking skills.

TECHNICAL SKILLS:

Languages & Tools - Python, SQL, R, SAS, PySpark, Java, PL/SQL

Visualization - Tableau, Power BI, Looker, Google Data Studio

Databases - MySQL, PostgreSQL, Google BigQuery, Snowflake, SQL Server, Oracle Exadata, Oracle 10g

Cloud Platforms - Google Cloud Platform (BigQuery, GCS, Cloud Functions), AWS (S3, Redshift), Azure (ADF, Azure SQL)

ETL & Workflow Tools - Apache Airflow, Cloud Composer, Informatica, Talend

Analytics Libraries - Pandas, NumPy, SciPy, Scikit-learn, Matplotlib, Seaborn

Other Tools - Git, Jupyter, Excel (VLOOKUP, Power Query), APIs (REST), Fivetran, dbt, Microsoft Office suite

Processes - Agile, Scrum

PROFESSIONAL EXPERIENCE:

Capital One Nov 2023 – Present

Data Analyst

Responsibilities:

Demonstrated expertise in analytical thinking by delivering actionable insights through full-cycle analysis and executive-level dashboards, improving reporting turnaround by 40% and enhancing strategic visibility. This showcased strong communication skills to both technical and non-technical audiences.

Designed and implemented machine learning-based fraud detection models in collaboration with data scientists, enabling real-time scoring and reducing risk exposure across high-volume transactional streams, requiring attention to detail. This was achieved working in an Agile/Scrum team.

Automated performance reporting pipelines for business segments using Python, SQL, and Tableau, reducing manual reporting efforts and increasing consistency in cross-departmental metric alignment, demonstrating problem-solving skills. This required innovative thinking skills.

Orchestrated high-fidelity ETL pipelines using Google BigQuery and Cloud Composer, automating dataset refreshes and supporting reliable reporting schedules across multiple teams, showcasing proficiency in connecting dots across various applications. This required minimal supervision.

Partnered with finance and compliance teams to design alert systems for regulatory metrics using GCP Pub/Sub, Data Studio, and Slack, ensuring timely escalation of compliance violations, demonstrating strong PL/SQL skills. This required willingness to ask questions.

Applied advanced SQL techniques—window functions, partitioning, CTEs—to optimize KPI queries, reduce latency, and minimize compute load across key financial reporting dashboards, showcasing ability to write and analyze complex queries. This required attention to detail.

Collaborated with data engineers to enhance GCP data lake schema standards, metadata tagging, and table partitioning strategies, improving storage efficiency and querying consistency, demonstrating strong communication and presentation skills. This required innovative thinking.

Authored reusable documentation, metric definitions, and data dictionaries for enterprise dashboards, improving onboarding efficiency and cross-functional collaboration among analysts and business teams, showcasing expertise with Microsoft Office suite usage. This required innovative thinking.

Built and maintained ad-hoc and recurring dashboards in Power BI, Tableau, and Looker with dynamic filters, empowering leadership with on-demand access to decision-critical insights, demonstrating proficiency in connecting dots across various applications. This required innovative thinking.

Ingested marketing campaign datasets and mapped performance KPIs across customer journeys, providing visibility into touchpoint effectiveness and attribution for digital acquisition strategies, showcasing ability to write and analyze complex queries. This required innovative thinking.

Target Jun 2022 – Aug 2023

Data Analyst

Responsibilities:

Designed retail sales dashboards in Tableau to monitor daily performance across 100+ stores, enabling regional managers to act on real-time insights and drive store-level performance improvements, demonstrating analytical thinking. This required attention to detail.

Conducted customer churn analysis using logistic regression models, identifying key risk indicators and improving re-engagement campaign targeting, which boosted conversion rates by over 20%, showcasing problem-solving skills. This required innovative thinking skills.

Partnered with supply chain analysts to forecast demand and optimize lead times, leveraging Python and Looker to visualize stock fluctuations and reduce stockouts in high-volume product categories, demonstrating strong communication and presentation skills. This required innovative thinking.

Created custom SQL logic to support product assortment strategies, aligning inventory with revenue and regional preference trends to improve in-store conversions and merchandising effectiveness, showcasing proficiency in connecting dots across various applications. This required innovative thinking.

Built interactive Looker dashboards and real-time alerts using Python for inventory and return anomalies, improving issue response time across store operations and inventory control teams, demonstrating strong PL/SQL skills. This required willingness to ask questions.

Collaborated with pricing teams to identify underperforming SKUs using margin-based modeling and pricing elasticity analysis, supporting decisions for markdowns and discontinuation strategies, showcasing ability to write and analyze complex queries. This required attention to detail.

Automated ingestion and transformation of sales and pricing data from third-party APIs using Python, reducing manual data preparation time and improving reliability of reporting pipelines, demonstrating expertise with Microsoft Office suite usage. This required innovative thinking.

Established and maintained data validation checks to detect inconsistencies in pricing, returns, and promotional activity data, enhancing the trustworthiness of store-level performance metrics, showcasing proficiency in connecting dots across various applications. This required innovative thinking.

Deployed real-time customer service analytics dashboards using Looker and SQL, allowing supervisors to monitor performance trends, feedback scores, and resolution turnaround in near real time, demonstrating analytical thinking. This required attention to detail.

Led A/B testing initiatives to assess impact of digital promotions, interpreting statistical significance through SQL and Python and informing adjustments to marketing strategies and offers, showcasing problem-solving skills. This required innovative thinking skills.

Cigna Jan 2021 – May 2022

Data Analyst Intern

Responsibilities:

Analyzed claims and engagement data to identify gaps in digital tool usage across age groups, providing recommendations to increase platform adoption and enhance overall member experience, demonstrating analytical thinking. This required attention to detail.

Built Power BI dashboards to track marketing outreach performance, visualizing campaign lift, regional engagement, and response segmentation for strategic reporting and leadership presentations, showcasing problem-solving skills. This required innovative thinking skills.

Cleaned, transformed, and merged structured and unstructured datasets from internal systems and external partners to support compliance documentation and audit-readiness for reporting teams, demonstrating strong communication and presentation skills. This required innovative thinking.

Developed stored procedures and scheduled SQL scripts to automate the refresh of key operational tables, improving data availability for real-time dashboards and reducing manual updates, showcasing proficiency in connecting dots across various applications. This required innovative thinking.

Visualized service efficiency metrics, including time-to-claim-resolution, using Tableau and SQL, empowering teams to monitor performance trends and identify areas for process improvement, demonstrating strong PL/SQL skills. This required willingness to ask questions.

Generated exploratory data profiles using Python and Pandas to detect null values, distribution anomalies, and data quality issues within key operational datasets, showcasing ability to write and analyze complex queries. This required attention to detail.

Implemented automated schema tracking scripts in Python to monitor data changes and send alerts for inconsistencies, supporting data integrity across multiple development environments, demonstrating expertise with Microsoft Office suite usage. This required innovative thinking.

Created visual summaries of healthcare utilization and regional trends using Tableau Public and internal tools, improving insight delivery to marketing and compliance stakeholders, showcasing proficiency in connecting dots across various applications. This required innovative thinking.

Collaborated with actuarial analysts to model cost impacts of plan design updates, using SQL and Python to simulate scenarios and analyze historical claims data, demonstrating analytical thinking. This required attention to detail.

Designed, distributed, and analyzed survey responses using chi-square tests and correlation metrics, providing quantitative insights to shape communication strategies and wellness initiatives, showcasing problem-solving skills. This required innovative thinking skills.

Certifications:

Certified python programmer

Finalist in quiz competition held by JNTU University Hyderabad

Educational Details:

Master of Science in Computer and Information Sciences - Rivier University

Bachelor of Technology in Civil Engineering - Marri Laxman Reddy Institute of Technology and Management, India

Contact this candidate