Rajat Jain

Data Analyst

Xecta Digital Labs•  July 2021 - Present

• Integrated O&G Asset Management(Hess Corp.,Cairn India,Pioneer Natural Resources) − Re-purposed raw SQL data (50k+ wells,5 million+ records) into Mongo DB schema for ingestion into ML(Unsupervised Learning,PCA etc.) and computational models to automate integrated asset management − Constructed dashboards & screens in Power BI to showcase results for maximizing production in current assets

Senior Data Analyst

Seven Lakes Technologies•  June 2020 - June 2021

Product Customization(Exxon):Designed the first bilingual version of Field Data Capture Solution,100+ User Journeys, − Scripted SSIS scripts to move 500+ wells data(-2 Million records) from Argentina to USA database − Tailored UI/UX & customized back-end ; worked with diverse teams (US/Argentina) − Generated 10% additional revenue($250k+) by early implementation(-3 Months) − Technology:SSIS,SQL,IOS SDK,.Net Core API’s • Road-Map Design(SLT): Initiated major product changes for Canada Implementation of Field Data Capture solution − Initiated design of schema for a new database and developed integration scripts for 5 million records − Formalized blueprints for new data connections liaising closely with 5+ client stakeholders & 3+ internal teams (US & India) − Single-handedly reduced Implementation time by 40% (-2 months) leading to -15% incremental revenue ($450k+) − Technology:SSIS,MySQL,PySpark • Product Development(Exxon): Fixed downtime & route optimization issues by employing Cross-Sector Expertise − Developed Dashboards on JOYN analytics and coded prototypes of analytics to optimize routes for 300+ users − Steered Product Development using data analysis of 2+ years of 25k+ Equipment and 300+ users route data − Saved 15% or 1200+ Man hours per week for -700 users and $1.5 Million+/year for -100k equipment − Technology:AWS Lambda,Google Route Optimization Algorithm, AWS Dynamo DB • Product Migration from AWS EC2 SQL Server to AWS Server-less Technologies − Spearheaded Gap Analysis using 3+ years of data to evaluate scope of Product Change for migration to No-SQL Dynamo DB − Designed schema for Dynamo DB for seamless transfer of 10 Million+ records − 80% reduction of operational costs; Migrated two 125+Users size clients from server to server-less technology − Technology:AWS Lambda, AWS Dynamo DB,SSIS, OLAP cube,SQL, PySpark

Customer Support Engineer

Seven Lakes Technologies•  December 2019 - June 2020

• Agile Issue Resolution (Exxon):Provided quick & accurate solutions for daily Data Quality,Data Flow & Product Issues − Leveraged cross-sector expertise to identify 150+ RCA and collaborated with Product team for solution delivery − Designed Programmable Algorithms and adhoc analytic tools to analyze 7 million+ data points from 5000+ users − Increased Product adoption by 30% or 1600+ users by spearheading 15+ deployments & 40+Fixes in 9+Months; − Technology:JIRA,SQL,Python(Panda,Matplotlib),C#,.Net Core API’s,AWS Cloudwatch, AWS S3 • Product Capability Demonstration(Pioneer):Showcased Pump by Exception Capabilities − Collaborated with Sales team for data discovery of client’s 2000+ Wells & 500+ Operators − Successfully demonstrated 5+ field scenarios;SLT was awarded $2+ Million Contract against Microsoft & SalesForce − Technology:Google Route Optimization,AWS Lambda, .Net Core API’s

Data Analyst

Infodat Inc.•  May 2019 - December 2019

• Web App design(Saudi Aramco):Built Conceptual Framework and Automated ETL Process utilizing O&G and IT expertise − Worked single-handed to refine 33000+ Wells with 3M+ data points for Data Scientist to run ML Algorithm − Secured $100k+ POC from Saudi Aramco by orchestrating MVP − Technology:SQL,PySpark, Python(Numpy,Pandas,MatPlotlib),Signal Analysis • Software Product Proof of Concept Development for Live Demonstrations − Analyzed Customer Data and coded layers of analytic in Python Plotting libraries viz. Matplotlib, Plotly − Developed algorithms leveraging PySpark, MySql libraries to organize 7m+ data points of O&G Data − Prepared Dashboards in Power BI with Business Development Team to demonstrate Product Capabilities − Technology:Microsoft Power BI,Python(Matplotlib,Plotly,Geopandas) • ML-based Prediction Algorithm Deployment to Edge Devices − Digitized Pump data from 50+ Wells with 2.4 Million+ Data points for Data Scientist to run ML Algorithm − Deployed App in 1+ Months to Predicted Pump Failures with 98% accuracy;$70k+ contract given by Schlumberger − Technology:Python(Pandas,MatPlotlib),Regression,Decision Trees,K-nearest Neighbors

Software Engineer

Kappa Engineering•  August 2018 - May 2019

• Re-development of Existing Module for cost-reduction(Total S.A. , Shell Canada and Exxon Mobil) − Formulated mathematical model by analyzing Data of 1200+ Thermal Wells and translated it into C++ code(6k+ lines) − Integrated C++ code into existing software architecture(100k+lines of code) and saved costs by 2.5% or $800k/year − Technnology:Microsoft Visual C++, C Sharp,ASP .Net, Kappa(Rubis & Sapphir)