Yashwanth Velpoori
Download
Recommend
Messages
Share
Yashwanth Velpoori

Yashwanth Velpoori

About

Detail

Data science and Data Engineering | Python, SQL, AWS, ETL, Tableau, Power BI | Project Management
Hartford, Connecticut, United States

Contact Yashwanth regarding: 

work
Full-time jobs
Starting at USD100K/year

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • K
    Senior Business Analyst
    Kraft Analytics Group
    Aug 2023 - Current (1 year 11 months)
    • Achieved a 30% reduction in data loading time by automating the ingestion of data from external sources like AWS S3 buckets into Snowflake tables. Leveraged Snowflake's SnowSQL for efficient data querying and analysis • Created and maintained data dictionaries and master data templates for over 6 data ingestion sources, ensuring efficient schema and table management to promote data consistency and accuracy • Re-architected database systems, enhanced data loading efficiency by 20% through automation from six sources into Snowflake, continuously improved schema management, and aligned solutions with business objectives • Collaborated with clients and account teams to gather technical requirements, conducted post-code change QA assessments i
  • University of Connecticut
    Data Analytics Student Assistant
    University of Connecticut
    Apr 2022 - May 2023 (1 year 2 months)
    Skills: A/B Testing · Web Analytics · E-Commerce Consulting · e-commerce sales · Tableau
  • Accenture
    Senior Analyst
    Accenture
    Aug 2020 - Jan 2022 (1 year 6 months)
    • Mentored a team of four to create a real-time dashboard in Tableau, saving 10 hours of manual reporting effort per week and enabling easy identification and analysis of the company’s KPIs. • Implemented credit risk modeling using a logistic regression model in Python with a detection accuracy of 81% to determine credit card defaulters. • Performed regular model monitoring and validation to uphold credit risk models' accuracy and reliability, fine-tuning them against new data for effective credit card defaulter prediction. • Optimized SQL query runtime by 30% with optimization techniques such as CTEs, temporary tables, and joins in My SQL. • Developed an end-to-end ETL pipeline for insurance claims data using AWS Glue to extract, transform
  • Accenture
    Business Intelligence Analyst
    Accenture
    Jan 2019 - Jul 2020 (1 year 7 months)
    • Executed complex SQL queries, including stored procedures, indexes, and triggers, to get customer data on medical claims, EHR, and clinical data for more than 2 million customers. Performed ad-hoc analysis as per business requirements. • Applied transformations like deduplication and change data capture using Python and lambda functions on usage data extracted from Athena ensuring accurate data loads to AWS S3 buckets and AWS redshift. • Enhanced efficiency by 25% through the automation of data collection, processing, and analysis via AWS Lambda and Python scripts, streamlining workflows and improving processing times. • Created 10+ Power BI dashboards to transform and analyze medical claims and high-risk patient data based on business re
  • Accenture
    Data Analyst
    Accenture
    Feb 2018 - Dec 2018 (11 months)
    • Forecasted demand-supply data for a major retail client by time series forecasting techniques (ARIMA model) in Python, which helped inventory management save up to $2Mn, avoiding resource wastage. • Built Power BI dashboards and reports to analyze key performance indicators (KPIs) such as sales, revenues, and inventory turnover and presented them to stakeholders to identify trends and patterns. • Improved data ingestion efficiency by 30% through developing and implementing SSIS packages, integrating data from SQL Server, flat files, and streaming data sources into the enterprise data warehouse. • Enhanced data accuracy and accessibility, resulting in a 25% reduction in manual effort for data processing, by automating the ETL process into
Education verified_user 0% verified
  • U
    Masters, Business Analytics and Project Management, , Business Data Science
    UNIVERSITY OF CONNECTICUT SCHOOL OF BUSINESS
    Jan 2022 - May 2023 (1 year 5 months)
    Coursework: Data Management and Business Process Modeling (SQL) Predictive Modeling (Machine Learning) Statistics in Business Analytics (R Programming Language) Data Science using Python (Numpy, Pandas, Seaborn, Matplotlib, Scikit-Learn) Visual Analytics (Tableau) Advanced Business Analytics and Project Management (Capstone Project) Big Data Analytics with Cloud (AWS) Data Mining and Business Intelligence (SAS) Business Decision Modeling (Optimization techniques) Web Analytics (Google Analytics) Introduction to Project Management (MS Project, Project Charter, Gantt Chart) Project Risk Management and Agile Methodologies (JIRA) Project Leadership and Communication Technical Communication in Business Analytics
  • Vasavi College of Engg
    Bachelor of Engineering (B.E, Mechanical Engineering
    Vasavi College of Engg
    Sep 2013 - Jun 2017 (3 years 10 months)