Pruthak Brahmbhatt Email & Phone Number

West Berlin, New Jersey, United States

• Collaborated with engineering teams to design and develop Python-based ETL processes for data mapping and transformation.• Managed the full lifecycle of the Learning Management System (LMS), including system configuration, user setup, and ongoing system administration to ensure smooth functionality and user experience.• Integrated SQL, R, Python, and Excel functionalities into the Learning Management System (LMS), enabling advanced data analysis and reporting capabilities for course performance, learner progress, and engagement metrics.• Migrated data between HDFS and AWS S3 and optimized AWS Glue and Lambda jobs for data integration.• Developed Spark and Python-based data pipelines to load and transform data for analytics using Redshift and PostgreSQL.• Performed tuning on Spark jobs, scheduled jobs using CTRL M, and deployed clusters on AWS EMR.

Kitwe, Copperbelt Province, Zambia

• Designed and implemented Oracle DB changes, building PL/SQL packages, procedures, functions, and views to support new business rules and integrate new source systems.• Performed SQL tuning and data modeling using Erwin 9.5, creating conceptual, logical, and physical data models while considering partitioning management options.• Enhanced LMS application and Moody’s Risk Origin Application, developing and modifying BIRT reports and implementing Oracle VPD rules.• Contributed to rewriting the LMS application in the Hadoop ecosystem by creating Hive partitioned external tables, writing Sqoop queries, and developing PySpark jobs for data processing.• Built and enhanced Oozie jobs, monitored them via HUE, developed Impala views, and gained experience with distributed data streaming using Kafka and NoSQL databases like MongoDB.• Successfully created data pipelines for migrating data from Oracle to SQL Server Management Studio (SSMS) and facilitated the migration of stored procedures for further investigation and analysis. Built dashboards in BI tools such as PowerBI and Tableau.• Collaborated directly with the CEO of SupaSave supermarket to discuss and develop strategic business ideas, demonstrating excellent communication and interpersonal skills to effectively convey and implement innovative strategies.• Designed PL/SQL packages and functions to support Oracle DB changes for new business rules.• Migrated data from Oracle to SQL Server, developed Hive partitioned tables, and created PySpark jobs.• Built dashboards using PowerBI and Tableau, and developed distributed data processing using Kafka and NoSQL databases.

Kitwe, Copperbelt, Zambia

• Analyzed Oracle and Informatica requirements, enhancing workflows and Oracle packages.• Designed new logistics data models, performed data migration, and developed BI dashboards for transportation optimization.• Performed analysis and design of Oracle and Informatica requirements. Enhanced ADS Loader workflows for various vendors by making changes to Informatica mapping, session and Oracle package/procedure/functions.• Providing support to ETL jobs in system/integration/UAT environments. Carried out design, construction, review and defect analysis activities to Oracle Loader and data movement packages.• Performed data modeling to setup new logistics order load using Oracle logistic transportation management tool. Involved in the creation of database from scratch for Tables (including Order tables, Customer Tables, Vehicles Table, Finance management tables, Cash flows and Inventory management), Views, Stored procedures, Functions, Packages and Indexes.• Performing data migration activities by applying various DMLs to sync up current data to support new business logic on any key attribute. Prepared visuals and dashboards using BI tools for management to view and build better business strategies to optimize budget and seamless transportation.• Collaborated directly with the CEO of Nico Coutlis Transport to discuss and develop strategic business ideas, demonstrating excellent communication and interpersonal skills to effectively convey and implement innovative strategies.

Ahmedabad, Gujarat

• Developed and optimized Hive and Spark scripts for data processing, integrated 20+ data sources, and contributed to backend development using Python and Flask.• Reduced cart abandonment rate by 8% through PHP Laravel development and implemented ETL processes for data extraction.• Optimized Hive and Spark scripts fetched data from Teradata to Hive and HDFS using TDCH and loaded data of various formats to HDFS.• Integrated over 20 data sources, developed Python modules for handling different file formats, and contributed to database design and schema development for MySQL, Cassandra, and MongoDB.• Developed Python workers for ETL processes, designed and implemented backend functionalities for RESTful APIs using Django, Flask, and Tasty-pie, and created shell scripts to automate production deployment.• Additionally, as an entry-level PHP Laravel web developer, contributed to reducing the cart abandonment rate by 8%.

Master'S Degree, Business Analytics, 3.89

Data Analytics For Business Decision Making, Data Science, 3.69 Gpa

Online postgraduate - Ontario college graduate certificate

Bachelor Of Technology - Btech, Information Technology, B