Data Analyst Business Intelligence

Abhisheksingh Rawat

***************@*****.*** +1-469-***-**** NJ, USA. LinkedIn GitHub Portfolio Professional Summary

• 4+ years of experience in Driving operational efficiency and data-driven decision-making through expert management of ETL pipelines, large-scale data migrations, and full-stack analytics solutions. Proven ability to lead complex projects from concept to delivery, translating business requirements into scalable, technical solutions that ensure compliance and accelerate growth.

• Led end-to-end data migration projects, successfully unifying and centralizing over 2 million daily transactions into enterprise data lakes, enabling a single source of truth for global operations.

• Developed and optimized scalable ETL/ELT pipelines using Azure Data Factory, SQL, Python (Pandas), and Airflow, reducing data processing times and improving data quality and accessibility.

• Engineered audit-compliant data solutions and streamlined QA workflows, mitigating risk and ensuring adherence to strict enterprise and regulatory standards.

• Coordinated and aligned global, cross-functional teams to deliver complex data initiatives on time and within scope, effectively translating technical requirements for non-technical stakeholders. Technical Skills & Certifications

Programming Languages: Python, R, SQL, C, T-SQL

Business Intelligence & Visualization: Tableau, Power BI, Streamlit, Advanced MS Excel (Pivot tables, LOOKUP) Databases Data Warehousing: SQL Server (SSMS), MySQL, PostgreSQL, SQlite3, Teradata, Snowflake Data Engineering & ETL: Azure Data Factory (ADF), Databricks, SSIS, Airflow, Data Cleansing, Feature Engineering Frameworks & Libraries: Pandas, NumPy, Matplotlib, ggplot2, Scikit-learn, TensorFlow Big Data & Cloud Technologies: Spark, PySpark, AWS (S3, EC2), MS Azure (Data Lake, Data Factory, Databricks) Development & Collaboration Tools: GitHub, Jupyter Notebook, Jira Methodologies: Agile/Scrum, Software Development Life Cycle (SDLC) Certifications: Azure Data Engineer, Power BI Data Analyst, Salesforce Certified Administrator Work Experience

Community Dreams Foundation, (Remote) USA. March 2025 – Current Business Intelligence Analyst.

• Developed and automated over 9+ interactive dashboards using Tableau and Streamlit, enabling cross-departmental visibility and reducing manual reporting time by 60%.

• Analyzed structured and semi-structured data using Python and SQL, driving insights that led to increase in campaign ROI and a 25% reduction in churn.

• Streamlined ETL pipelines with SSIS, and SQL Server (SSMS), improving data refresh performance by 70% and reducing data latency in daily reports.

• Designed and deployed data models and star schemas across Snowflake and MySQL warehouses, improving query efficiency and enabling real-time analytics across various business units.

• Analyzed over 2K customer feedback reviews to identify key sentiment patterns, increasing classification precision by 18% and enabling data-driven product enhancement strategies.

• Created advanced Excel models using pivot tables, lookups, and macros, enabling finance teams to perform faster scenario analyses and reducing spreadsheet-related errors by 35%.

Bright Mind Enrichment & Schooling, (Remote) USA. August 2024 – March 2025 Data Analyst.

• Engineered Python scripts to automate data quality checks and metadata validation for grant data from 14+ MNC partners, increasing data accuracy and ensuring 100% compliance with strict audit and funding requirements.

• Developed complex SQL queries utilizing CTEs, window functions, and stored procedures to analyze grant fund utilization and media engagement. Translated insights into dynamic Excel dashboards, improving reporting precision by 30%.

• Designed and orchestrated automated data workflows using Apache Airflow (Composer), scheduling and monitoring ingestion and transformation processes. This reduced manual data handling by 70% and ensured reliable, timely data availability.

• Built interactive Power BI dashboards by integrating and transforming multi-format data sources (CSV, Excel, and JSON), enabling real-time monitoring of user engagement and improving stakeholder reporting efficiency by 40%.

• Developed a statistical forecasting model in Python (using Pandas, Scikit-learn) to predict future grant fund utilization trends, enabling proactive budget adjustments and improving financial planning accuracy by 25%.

• Collaborated directly with cross-functional stakeholders and grant managers to gather business requirements, define key metrics, and lead User Acceptance Testing (UAT) for all deployed data solutions, ensuring they met critical business needs. Tata Consultancy Services, India. August 2019 – June 2022 Business Intelligence Analyst.

• Architected and implemented scalable ETL pipelines using Azure Data Factory (ADF) and Databricks (PySpark) to migrate 2M+ daily rental records from legacy SQL Server and REST APIs into Azure Data Warehouse, creating a unified data model for enterprise analytics.

• Enabled a 20% improvement in revenue forecasting accuracy and fleet operations reporting by building a reliable, cloud-based EDW that served as a single source of truth for business intelligence.

• Developed automated Python data validation frameworks that reduced manual data quality assurance time by 70%, guaranteeing 99.5% integrity of data ingested into the data warehouse.

• Translated business requirements into technical solutions by collaborating with product and engineering teams to create data mapping blueprints for integrating complex legacy schemas into a modern Azure environment.

• Enhanced cross-functional transparency and issue resolution by 40% by managing project delivery in JIRA/Confluence, creating epics, and tracking 40+ migration and QA tasks through agile sprints.

• Proactively mitigated project risks by leading weekly stakeholder reviews with business and IT leadership, maintaining a 95% on- time milestone completion rate throughout critical migration phases. Education

Masters in IT & Management, University of Texas at Dallas, TX, USA. (3.9 GPA) May 2024 Bachelors in Computer Engineering, University of Mumbai, India. (3.4 GPA) May 2019

Contact this candidate