Jignesh Purabia

Jignesh Purabia

Technical Advisor

Followers of Jignesh Purabia1000 followers
location of Jignesh PurabiaIndia

Connect with Jignesh Purabia to Send Message

Connect

Connect with Jignesh Purabia to Send Message

Connect
  • Timeline

  • About me

    DATA ANALYST @ DCB BANK | DATA ENGINEER | BIG DATA | PYSPARK | AZURE DATA FACTORY |AZURE DATABRICKS| AZURE SYNAPSE ANALYTICS | PENTAHO | IMPALA | PYTHON | TABLEAU | POWERBI | SAS VIYA

  • Education

    • University of Mumbai

      2019 - 2023
      Bachelor of Engineering - BE Information Technology
  • Experience

    • Mira Bhayandar Municipal Corporation

      Jun 2023 - Jul 2023
      Technical Advisor
    • DCB Bank

      Sept 2023 - now

      ✓ Creating Interactive Dashboards Using SAS VIYA:• Connected to various data sources including databases and flat files for data gathering.• Performed data cleansing, transformation, and integration using SAS Data Integration Studio.• Designed and developed interactive dashboards with SAS Visual Analytics, incorporating charts, graphs, and tables to display KPIs. ✓ Writing SAS Code and Macros for Data. Preparation:• Developed SAS code for ETL tasks utilizing DATA steps, PROC SQL, and other SAS procedures.• Created reusable SAS macros to automate repetitive tasks and standardize data processing.• Applied data cleaning techniques to handle missing values, duplicates, and outliers.• Optimized SAS code for better performance and timely completion of data preparation tasks.• Documented SAS code and collaborated with data analysts and business users for requirement gathering and solution delivery.✓ Preparing Data Using IMPALA on Hue Editor: • Connected to Hadoop clusters via the Hue editor for data extraction from HDFS.• Sending reports to the stakeholders by writing the impala queries.✓ Creating Data Pipelines on Pentaho Data Integration Tool: • Designed and implemented data pipelines to automate ETL processes.• Applied data transformation techniques including cleansing, aggregation, and enrichment within Pentaho.• Ensured data integrity and consistency during the loading process to target systems.✓ Monitoring of data pipelines to ensure that every created pipeline is being run properly. Show less • Conducted thorough data cleaning and transformation tasks in Excel, ensuring data accuracy and reliability.• Automated intricate reports using SAS Enterprise Guide, reducing manual effort and increasing report generation efficiency.• Developed and executed macros and scripts to automate repetitive tasks, optimizing workflow.• Successfully managed and processed large datasets, enhancing overall data handling capabilities.• Extracted actionable insights by generating the automated reports , contributing to informed decision-making processes. Show less

      • Data Analyst | Big Data

        Jan 2024 - now
      • Data Analyst Trainee

        Sept 2023 - Jan 2024
  • Licenses & Certifications