RAJARAM PARAB

• Designed, developed, and maintained ETL processes using Talend to extract, transform, and load data from various sources into BigQuery on Google Cloud Platform.
• Implemented robust data pipelines using Google Cloud Dataflow to process and analyze large volumes of data efficiently.
• Managed and optimized BigQuery data warehouse to ensure high performance and scalability for complex analytics queries.
• Utilized Google Cloud Functions to automate data processing tasks and streamline workflows, resulting in improved efficiency and reduced manual effort.
• Implemented and configured Apache Airflow on Google Cloud Composer for orchestrating and scheduling data workflows, ensuring reliability and consistency.
• Leveraged Google Cloud Storage for storing and managing large datasets in a cost-effective and scalable manner.
• Provided training sessions on Python programming language to team members to enhance their technical skills and productivity.
• Mentored junior analysts, fostering professional development while enhancing overall team performance.

• Part of Small Scale Automation (SSA) team, using Python for automation which reduce Man-hour and increase productivity.
• Create and manage dashboards to report weekly metrics and other various reports according to Business requirements.
• Fulfilling data requirement of internal stakeholder by writing SQL Queries using ETL management tool and Amazon Redshift Data Warehouse.
• Dashboarding using Power BI and Amazon Quicksight to provide reports as per business requirements.
• Providing support as BIE/BA, managing requests queue and delivering for WBR/metric additions/changes from Ops teams.

As a Deputy Engineer in PSU, was Involved in various activities demonstrating Good Leadership, Communication, Analytical and Presentation Skills.

• Getting better insights about Root Cause for Defect from data and informing relevant Team for improving quality of the Product.
• Creating and Maintaining Daily/Weekly/Monthly report of defective product in MS Excel.
• Analyzing created report and generated report (from Electronic Device which stores Sensors Data) to find Root Cause of failure of product, Most frequent failed Sensors etc.
• Working directly with Stakeholders/Customers for completion of activities.

• ITSM Data Analysis - ServiceNow Tickets Data Gathering, Analyzing Data to get insights of data using MS Excel - PivotTables and Python - Pandas.
• Getting information such as Frequent issues, Team-wise Resource Productivity and individual Productivity, Mostly affected CIs etc.
• Transforming Analyzed Data into Presentable form for getting better insights.
• Application Steward for fixing issues on priority for Web based/Desktop Applications.
• Incident Management, Request Fulfillment, Change Management and Incident Resolution within SLA.
• Understanding business requirement and making necessary changes and modification on functionality of application.