Data Analyst Power Bi

RUTUJA MORE DATA ANALYST

**************@*****.*** +1-857-***-**** NJ, USA. LinkedIn

SUMMARY

Data Analyst with over three years of specialized experience, I have developed a comprehensive expertise in the entire data analysis lifecycle, from the acquisition and rigorous validation of both structured and unstructured datasets to advanced predictive modeling and insightful data storytelling. A key achievement includes designing and developing interactive dashboards and visualizations utilizing Tableau, Power BI, and Excel, which directly provided actionable insights to stakeholders and contributed to a measurable 25% increase in data-driven decision-making across the organization. My technical proficiency is grounded in powerful programming languages and libraries, including Python (Pandas, NumPy, Matplotlib, Seaborn, SciPy, TensorFlow) and R

(ggplot2), which I employ for sophisticated data manipulation, statistical analysis, and machine learning tasks. Furthermore, I am an expert in end-to-end ETL processes, having designed and implemented robust data workflows and mappings in SSIS to efficiently extract, transform, and load data from diverse sources such as SQL Server and Excel, ensuring data integrity and accessibility for analytical purposes.

SKILLS

Programming Languages: Python, SQL, R.

IDEs: Visual Studio Code, PyCharm.

ETL & Visualization Tools: SSIS, Tableau, Power BI (DAX, PowerQuery), Microsoft Excel. Packages: NumPy, Pandas, Matplotlib, SciPy, Scikit-learn, Seaborn, Ggplot2, TensorFlow. Cloud Technologies: AWS (S3, Athena, Redshift, Lambda), Azure (Azure Data Lake, Azure Data Factory, Blob Storage). Databases/ Data Warehouses: MySQL, SQL Server, PostgreSQL, MongoDB, Snowflake, Redshift, Oracle. Analytical Skills: Data Transformation, Data Warehousing, Data Modeling, A/B Testing, Time Series Analysis. Others: VS Code, Data cleaning, Data Wrangling, Critical Thinking, Communication Skills, Presentation Skills, Problem- Solving, Time Management, Database Viewing, Analyse Skills Requirement, MS Suite, ETL, Informatica WORK EXPERIENCE

Hartford Financial Services Group, USA Data Analyst. July 2024 - Present

• Designed and implemented AWS Redshift data warehouses to consolidate and analyze multi-source financial data, enabling enterprise-wide trend analysis and reporting.

• Performed daily data extraction, transformation, and analysis using SQL and Excel, ensuring a 98%+ accuracy rate in data output against strict business rules and procedures.

• Enhanced database performance and reduced operational latency by 35% through advanced SQL query optimization, including strategic indexing and query plan analysis.

• Developed Python scripts utilizing Matplotlib and Seaborn to automate data visualization and exploration, accelerating the insight generation process by 33% and uncovering key data patterns.

• Executed customer segmentation analysis that identified key retention drivers, resulting in a 10% increase in customer retention rates and providing actionable insights for business strategies.

• Built and deployed three interactive Power BI dashboards to track critical financial KPIs and performance metrics, empowering senior management with real-time data for strategic decision-making.

• Established and enforced data governance frameworks to ensure the highest standards of data security, privacy, and regulatory compliance across all analytical datasets.

• Partnered with cross-functional teams including finance, risk, and executive leadership to gather requirements, deliver tailored analytical solutions, and communicate data-driven findings effectively. Boost FinCrop Group, India Data Analyst. January 2020 – August 2022

• Led end-to-end data analysis projects, enhancing processes to increase data accuracy and customer satisfaction by 25%.

• Optimized SQL queries and implemented indexing strategies, improving data retrieval efficiency by 30% and enabling faster, more accurate stakeholder reporting.

• Designed and developed interactive Tableau dashboards utilizing advanced visualizations (Bar Charts, Pie Charts, Maps) to track KPIs and support data-driven decision-making.

• Engineered and maintained ETL pipelines to load data into Snowflake, ensuring data quality and integrity while reducing data loading time by 50% for over 1 million records.

• Developed and managed ETL packages using SSIS to validate, extract, transform, and load data into Data Warehouse and Data Mart environments.

• Performed data cleansing and analysis in Excel using pivot tables, VLOOKUP, data validation, and conditional formatting to ensure data integrity.

• Managed data governance processes by identifying proposed changes, liaising with business data stewards for approval, and updating CRM and data warehouse systems.

EDUCATION

Masters in Information Systems, Northeastern University, Boston, USA. December 2024 Bachelors in Computer Science, University of Pune, India. April 2020

Contact this candidate