Data Analyst Power Bi

Rushikesh Ambati

Data Analyst

*************@*****.*** LinkedIn 802-***-**** Nashua, NH

Data Analyst with 8+ years of expertise in SQL, Python, R, Power BI, Tableau, and Snowflake, driving reporting, automation, and analytics across financial and business domains. Proficient in creating 40–80+ monthly reports, building ETL pipelines with SSIS, Informatica, Alteryx, and Airflow, and applying automation tools (UiPath, RAG) to reduce manual effort by up to 40% and save 15–20 staff hours weekly. Skilled in advanced statistical techniques, predictive modeling, and KPI dashboarding that improved leadership decision-making speed by 25%, while ensuring 98–99% reporting accuracy through audits, validation, and data quality monitoring. PROFESSIONAL EXPERIENCE

Data Analyst FIS Global Jul 2024 – Present

• Produced 80+ financial and operational reports each month using SQL, T-SQL, and Excel (Power Query, Macros, Advanced Formulas), aligned with compliance requirements.

• Implemented workflow automation with UiPath, SQL scripting, Excel macros, and Airflow scheduling, reducing manual effort by 35% and saving 15 staff hours weekly.

• Designed Power BI and Tableau dashboards with DAX measures and KPI tracking, enabling anomaly detection and cost trend visibility for executives.

• Created 25+ Python (Pandas, NumPy, SciPy) and R scripts for cleansing, validation, and mining, integrating results into pipelines via Alteryx, Informatica, and Python ETL.

• Applied variance and trend analysis to uncover hidden patterns, and conducted predictive modeling to deliver actionable insights that drove cost optimization initiatives.

• Monitored data quality in Snowflake and multi-source systems with audits, discrepancy checks, and error detection, maintaining 98% reporting accuracy.

• Deployed RAG solutions on Azure and AWS to integrate LLMs with enterprise datasets, automating query responses and reducing research time by 30%.

Data Analyst Symtrax Jun 2023 – Jun 2024

• Delivered 40+ recurring reports with SQL, Snowflake, and Excel (Macros, Power Query), reducing reporting effort by 35% through SQL automation and SSIS.

• Built Tableau and Power BI dashboards with advanced DAX queries, accelerating stakeholder decision-making by 20%.

• Extracted and transformed datasets with Python (Pandas, Matplotlib, Seaborn), R, and Alteryx; integrated into Informatica and Python ETL pipelines, improving reporting accuracy by 25%.

• Performed forecasting, variance evaluation, and correlation analysis with data mining techniques, surfacing opportunities for efficiency and cost reduction.

• Established continuous data quality monitoring with discrepancy resolution and governance controls to ensure reliable analytics. Data Analyst DXC Technology Dec 2015 – May 2023

• Generated 50+ client and operational reports monthly with SQL, T-SQL, and Excel (Macros, Power Query), meeting SLA and compliance standards.

• Streamlined workflows with VBA, SQL, and Excel Power Query, decreasing manual effort by 40% and saving 20 staff hours weekly.

• Built executive dashboards in Power BI and Tableau with DAX, boosting decision-making speed by 25%.

• Developed 25+ Python and R scripts for extraction, validation, and transformation, enhancing dataset accuracy by 25%.

• Applied statistical modeling, variance assessment, and performance trend evaluation to enterprise datasets, identifying cost optimization opportunities.

• Maintained ETL pipelines in SSIS, Informatica, Python ETL, and Airflow, increasing reporting efficiency by 30%.

• Automated ad-hoc reporting with UiPath, enabling rapid delivery of executive requests.

• Maintained 99% reporting accuracy through data auditing, error detection, and governance processes. EDUCATION

BE in Information Technology, JNTUH College of Engineering Hyderabad, INDIA Aug 2004 – May 2008 TECHNICAL SKILLS

• Programming Languages & Libraries: Python (Numpy, Pandas, Scipy, Matplotlib, Seaborn), R

• Databases & Querying: SQL, T-SQL, Snowflake, Excel (Advanced Formulas, Power Query, Macros)

• Cloud Platforms: Azure, AWS, GCP, RAG (Retrieval-Augmented Generation)

• Business Intelligence & Visualization: Power BI, Tableau, Dashboard Design, KPI Tracking, DAX Query

• ETL & Automation Tools: Alteryx, SSIS, Informatica, Python ETL, UiPath, Apache Airflow, Ad-hoc Reports

• Data Analysis & Transformation: Data Validation, Data Cleansing, Data Mining

• Data Quality & Integrity: Data Auditing, Error Detection, Discrepancy Resolution, Accuracy Monitoring

• Analytical Techniques: Variance Analysis, Trend Analysis, Predictive Analysis, Cost Optimization

Contact this candidate