Jignesh Purabia

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