Lagna Ray

Background

About Lagna Ray

Data Analyst with 5+ years of experience in analyzing complex datasets, developing data models, and delivering insights that drive business performance. With a strong foundation in SQL, Python, and BI tools like Power BI, I specialize in transforming raw data into actionable strategies that enhance operational efficiency and growth. Recently completed a Data Science internship at BEPEC, where I worked on machine learning models for customer retention and predictive analysis. At Accenture, I significantly improved data accuracy, developed SQL queries for financial insights, and collaborated with cross-functional teams to deliver data solutions that optimized vehicle production and pricing strategies, resulting in $1M in annual savings. Core Competencies: Data Modeling, Data Analysis, SQL, Python, Power BI, Data Cleaning, Feature Engineering, Data Visualization Data Science Intern | BEPEC Feb 2024 – Present Developed expertise in machine learning algorithms (logistic regression, decision trees, random forests) to build predictive models. Worked on customer churn prediction, utilizing feature selection techniques (RFE, LASSO) to enhance model performance and interpretability. Gained proficiency in statistical analysis and hypothesis testing, analyzing data distributions and relationships for accurate insights. Built data workflows using Pandas, NumPy, and Scikit-learn, collaborating with mentors to refine models and improve accuracy. Data Analyst | Accenture India(Nov 2016 – Jun 2023) Managed and optimized large financial datasets, achieving a 25% improvement in reporting accuracy through advanced data cleaning techniques. Created complex SQL queries for operational and financial analysis, leading to data-driven business strategies. Analyzed automotive market trends and performance data, driving decisions that saved $1M annually in production costs. Enhanced post-purchase services by 15% through customer satisfaction analysis, which contributed to a 10% increase in repeat customers. Generated Power BI dashboards for key metrics, enabling data-driven decisions by senior management. Key Projects: Revenue Analysis: Identified key revenue drivers using SQL and data modeling, resulting in a 10% increase in year-over-year revenue. Automobile Data Analysis: Developed a predictive model for vehicle maintenance, reducing maintenance costs by 20%. Skills Programming Languages: SQL, Python, Database Systems: MySQL, PostgreSQL, SQL Server, BI & Visualization Tools: Power BI, Tableau, Looker Data Analysis Tools: Pandas, NumPy, Matplotlib, Seaborn,ScikitLearn