Data Analyst Business Intelligence

US • **********@*****.*** • +1-201-***-****

DORA SAI KUMAR

Data Analyst and Business Intelligence Developer

PROFESSIONAL SUMMARY

Prospective Data Analyst and Business Intelligence Developer with over 7 years of experience leveraging SQL, Python, and Power BI to enhance data-driven decision-making. Demonstrated expertise in developing automated data pipelines and interactive dashboards, resulting in significant operational improvements and increased efficiency. Skilled in utilizing Snowflake and Tableau for scalable data management and visualization, with a passion for driving business intelligence through innovative solutions.

SKILLS

SQL, Python, R, Excel, Power BI, Tableau, Matplotlib, SSIS, Alteryx, Talend, Snowflake, AWS, Azure, Git, JIRA, Confluence, Domo, Databricks, Qliksense, SSRS, ETL, Hadoop, Spark, GCP, A/B testing, SaaS, T-SQL, Airflow, DAX, Looker, Oracle, BigQuery.

EMPLOYMENT HISTORY

SR. DATA ANALYST Jul 2022 - Present

Orange County Public Schools Orlando, Florida

• Led a team of analysts to develop automated data pipelines and dashboards, driving business intelligence across departments.

• Analyzed large datasets using SQL and Python to identify key performance trends, resulting in a 20% increase in operational efficiency.

• Created dynamic reports in Power BI, streamlining data access and enhancing visualization for stakeholders.

• Built automated data pipelines using SQL and SSIS to load, transform, and analyze data from multiple sources.

• Managed large datasets in Snowflake, ensuring data quality, scalability, and security.

• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

• Led data migration to Snowflake from on-premise SQL Server, optimizing query performance and reducing processing time by 40% through Snowflake’s scalable architecture.

• Improved sales forecasting accuracy by 18% by developing a predictive model using Python and SQL.

• Developed and optimized data pipelines on Azure Synapse Analytics, transforming raw data into actionable insights for improved decision-making.

• Built interactive dashboards in Power BI connected to Azure Data Lake, providing real-time analytics. DATA ANALYST Feb 2015 - Aug 2021

HCL Technologies Hyderabad, India

• Assisted in maintaining and updating SQL databases for reporting and analysis purposes.

• Developed and maintained data models and reports using Excel and SQL to support management decisions.

• Conducted data validation and cleanup to ensure data accuracy and consistency across various departments.

• Implemented advanced calculations, parameters, and LOD expressions in Tableau to build complex, dynamic visualizations, enhancing business reporting accuracy and depth.

• Developed interactive dashboards and reports in Tableau that provided key performance indicators (KPIs) for stakeholders, improving data-driven decision-making and reducing reporting time by 30%. EDUCATION

MASTER OF SCIENCE IN PROJECT MANAGEMENT (DATA ANALYTICS) Sep 2021 - Apr 2023 Northeastern University Boston, MA

BACHELOR OF ENGINEERING IN COMPUTER SCIENCE Sep 2010 - May 2014 Institute of Aeronautical Engineering (JNTUH University) Hyderabad, India

Contact this candidate