Headline

Business Analyst @ Smartworks | Data Science | Machine Learning | Phyton | Power Bi | Databricks

About

Data professional with 1.5+ years of experience in building data pipelines, transforming raw data into structured formats, and enabling data-driven decision-making. Skilled in SQL and Python, with hands-on experience in ETL development, data modeling, and automated reporting solutions. Currently working at Smartworks Co-working Ltd., where I design and maintain data pipelines, develop scalable data models, and build Power BI dashboards to track key business metrics. My work has contributed to identifying revenue gaps, optimizing operational costs, and improving reporting efficiency. Experienced in working across the end-to-end data lifecycle, including data ingestion, cleaning, transformation, validation, and visualization. Proficient in Power BI (DAX, Power Query), SQL, Python, Advanced Excel, and Power Automate for workflow automation. Have foundational exposure to modern data engineering tools and concepts, including Databricks, Apache Spark, Delta Lake, and Azure Data Factory, with a growing focus on building scalable and efficient data solutions. Strong understanding of business analytics, including variance analysis, forecasting, and trend analysis, with the ability to translate data into actionable insights. Adept at collaborating with cross-functional teams and delivering solutions aligned with business objectives. Certifications & Highlights - Oracle Cloud Infrastructure (OCI) AI Foundations Associate – Certified - Oracle MySQL Explorer – Course Completed - Strong foundation in Artificial Intelligence, Machine Learning, and Generative AI concepts - Passionate about continuously learning and applying modern cloud and data engineering technologies to solve business problems. Currently seeking opportunities to further strengthen my capabilities in Data Engineering, Data Analytics, and AI-driven data solutions while working on large-scale data platforms.

Location

Greater Delhi Area

AI stack

claude

gemini

Work experience

Business Data Analyst at Smartworks, Sep 2024 - Present · 2 yrs 1 mo, Gurugram, Designed and implemented end-to-end ETL pipelines for ingesting, transforming, and validating data from multiple sources, enabling reliable and scalable data workflows. Built and maintained SQL-based data models to support reporting, analytics, and downstream business intelligence use cases. Automated data processing and reporting pipelines, reducing manual intervention and improving reporting efficiency by 80%. Developed a Purchase Order lifecycle data pipeline, integrating vendor and procurement data to enable price variance analysis and trend monitoring. Engineered a BMS reconciliation pipeline to compare system-generated data with contractual agreements and actual consumption, identifying gaps in billing data. Performed large-scale data cleaning, transformation, and validation using SQL and Python (Pandas, NumPy) to ensure data quality and consistency. Built reusable data transformation logic and optimized SQL queries for improved performance and faster data processing. Created and maintained Power BI datasets and semantic models, enabling efficient dashboarding and KPI tracking for business users. Integrated multiple data sources (operational, financial, and IoT-based systems such as BMS/LCS) into unified data structures for analytics and reporting. Worked with Databricks (basic exposure) to understand distributed data processing and modern data engineering workflows. Implemented automated workflows using Power Automate to streamline data refresh and reporting processes. Supported advanced analytics use cases by preparing curated datasets for forecasting, trend analysis, and business insights.

Education

DATA SCIENCE, ANALYTICS LAB

Bachelor of Technology - BTech, Civil Engineering, MDU , ROHTAK