Jimit Mehta Email & Phone Number

Dallas, Tx, Us

Frisco, Texas, Us

• Implemented Personalized Recommendations and comprehensive risk management program to minimize risks and loss for a clothing retailer in Python, recommendations led to increased customer satisfaction. • Applied Association Rule mining on a large customer data using SparkML to discover patterns for products which are bought together, results pushed to customers by campaigns which helped increase in sales by 10%. • Extracted and analyzed transactional data to identify the time when people often make purchases, number of items each member buys and top 10 purchased items using Scala Script to derive actionable insights. • Conducted in-depth compliance and credit risk analysis for ecommerce financial data to ensure regulations and recommended risk ratings to improved operations and minimized risk exposure.• Designed and Implemented web microservice to collect data from Spark, convert data in JSON format into Avro then feed into Kafka and land data in Snowflake on AWS. • Designed Rest API using Scala, which makes data stored in Snowflake accessible to the different target systems as well as Tableau / D3 visualizations. • Developed tier calibrator tool using time series statistical model in Spark to observe member migration and threshold with most incremental points by stimulating new program which could increase revenue by 25%.• Implemented Sales Diagnostic Tool in Python using Pandas and NumPy libraries to get quick to market insight and recommend multiple modules to bring actionable insights to the company’s marketing efforts. • Developed Docker images for spark applications and used Jenkins pipelines to build, deploy and test spark jars on Kubernetes cluster which reduced deployment timeline to production by 30%. • Built event-driven data pipeline in Scala that gathers high volume and velocity data in terabyte from Spark to Snowflake DB.

Frisco, Texas, Us

Frisco, Texas, Us

• Full life cycle of Data Lake, Data Warehouse with Big data technologies like Spark, Hadoop, Cassandra and developed enhancements to MongoDB architecture to improve performance and scalability and worked with MapReduce frameworks such as Hadoop and associated tools (pig, Sqoop, etc.) • Created BigQuery authorized views for row level security or exposing the data to other teams.• Cloud migration using AWS with on - premises clusters to cloud Snowflake clusters. • Design and implement secure data pipelines into a Snowflake data warehouse from on-premises and cloud data sources. • Developed a common framework using spark to ingest data from different data sources (Teradata to S3 and S3 to Snowflake etc.,) • Enhance the existing product with newly features like User roles (Lead, Admin, Developer), ELB, Auto scaling, S3, Cloud Watch, Cloud Trail and RDS-Scheduling. • Implemented smart ingestion application in python for migrating the data into Data Lake. • Built ETL pipelines on snowflake and the data products are used by stakeholders for querying and serve as backend objects for visualizations. • Developed Spark scripts by writing custom RDDs in Scala for data transformations and perform actions on RDDs.• Developed installer scripts using Maven, Python for various products to be hosted on Application Servers. • Developed Pom.xml files for Maven build scripts. • Strong working experience in Perl Script, Shell Script, JIRA, Code Coverage, Ant, Maven, Build and Release management, Change Management, Process Engineering, Application Packaging and Web Programming. • Performed advanced procedures like text analytics and processing, using the in-memory computing capabilities of Spark using Scala.• Collaborated with different teams on ETL (Extract, Transform, Load) tasks and verifying pipeline stability. • Created PySpark and SparkSQL code to process data in Apache Spark on Amazon EMR and conduct the required transformations depending on the STMs developed.

Mumbai, Maharashtra, In

• Translate business and data requirements into Logical data models in support of Enterprise Communication Data Model, OLTP, OLAP, Operational Data Store (ODS) and Analytical systems. • Implemented Core Framework leveraging Spark that can handle the whole pipeline in one Config(json). • Implemented optimal solutions for migrating the data into Data Lake. • Developed Kafka producer and consumers, HBase clients and Spark jobs along with components on HDFS, Hive. • Excellent knowledge on AWS services (S3, EMR, Athena, EC2), Snowflake and Big Data technologies. • Worked on Dimensional and Relational Data Modelling using Star and Snowflake Schemas, OLTP/OLAP system, Conceptual, Logical and Physical data modelling using Erwin. • Worked with building data warehouse structures, and creating facts, dimensions, aggregate tables, by dimensional modeling, Star and Snowflake schemas. • Worked on analyzing source systems and their connectivity, discovery, data profiling and data mapping. • Created Hive tables, developed and modified HQL queries to solve the issues reported by QA.• Updated Python scripts to match training data with our database stored in AWS Cloud Search, so that we would be able to assign each document a response label for further classification. • Involved in Database using Oracle, XML, DB2, Teradata 14.1, Netezza, SQL server, Big Data and NoSQL based MongoDB and Cassandra. • Developed Kafka producer and consumers, HBase clients and Spark jobs along with components on HDFS, Hive. • Applied various machine learning algorithms and statistical modeling like decision tree, logistic regression, Gradient Boosting Machine to build predictive model using scikit-learn package in Python • Implemented dimension model (logical and physical data modeling) in the existing architecture using ER/Studio and developed, managed and validated existing Data Models including Logical and Physical Models of the Data Warehouse and source systems utilizing a 3NFmodel.

• Designed and developed rotating MPPT Solar Panel using PIC Controller resulting in 35% increase in power yield.

Mumbai, Maharashtra, In

• Designed User Interface for an IOS application to control home electronic devices using CommandFusion.• Developed embedded software for IR, RS232 and IP based devices for Home Automation using AMX Controller.• Designed File Management System based on RDBMS to optimize client management by converting data stored in physical files into digital form.

Master Of Science - Ms, Itm

Bachelor’S Degree, Electronics And Communications Engineering

Information Technology