Vijay Bhalani
Missouri City, TX ***** 860-***-**** **************@*****.***
Summary
Senior Data Engineer with 10+ years of experience architecting scalable data pipelines and real-time analytics. Expertise in Databricks, AWS, Python, and SQL to drive robust data processing and secure workflows. Led cross-functional teams to innovate enterprise data integration solutions that enhance operational insights and efficiency.
Skills
•Skills: Team Player, Time Management, Adaptability, Critical Thinking, Stress Management, Decision Making, Problem Solving
•Data Engineering/Programming Framework: Power BI, TIBCO Spotfire, AWS, Azure, SAP, Tableau, Visio, Teradata, VBA, Data Analytics, Snowflake, IBM DataStage, Server Configuration, Python, HTML, JavaScript, MS SQL, Oracle 11g/12g, C++, R Programming, JIRA, MatLab, JSP, Kubernetes, Docker, Kafka, Hadoop, Informatica, Scrum, Agile, Matillion, Web Services, XML, Windows, MacOS, UNIX, Microsoft Suite / Office 365 Databricks, PySpark, Spark SQL, Azure Data Factory, Logic Apps, Function Apps, DAX, Presto, Kinesis, Airflow, Braze, Amplitude, Flink, Fivetran, dbt, CI/CD, data modeling, database design
•Oil & Gas: AFE Navigator, Decline Curve Analysis (DCA), Pressure Transient Analysis (PTA), Nodal Analysis, SCAL, FracFlow, Petra, IHS Enerdeq-Powertools-Markit, DrillingInfo (Enverus), Eclipse, MBAL, Reservoir Grail, Cervart, OpenWells, WellView, PHDWin, Aries, QLS, Petrel, Fekete Harmony
Experience
AksharIT Solutions LLC Jan 2022 - Present
Sr. Data Engineer Houston, TX
•Developed a real-time production intelligence system using Power BI, processing minute-by-minute updates for 10,000+ wells; established seamless data ingestion from Snowflake and production systems, aligning with scalable data processing and integration best practices.
•Architected a Python-based production forecasting solution (2,000+ lines) with massively parallel processing, calculating 50-60-year monthly forecasts for thousands of wells; streamlined integration between Spotfire and OFM with automated error handling and dependency management.
•Implemented production data processing on the Databricks platform using PySpark, enabling distributed computing and advanced analytics workflows that support real-time and exploratory data analysis.
•Led and mentored a multi-disciplinary team to enhance productivity and develop scalable applications, reinforcing best practices in data engineering and workflow automation.
•Designed and implemented data solutions in Snowflake to improve accuracy and security, reducing data errors by 50% and improving query performance by 40% while executing ETL processes moving over 1TB of data per day.
•Optimized ETL pipelines, achieving a 25% reduction in processing time by designing and deploying cloud-based data workflows that align with modern data engineering practices.
•Developed and orchestrated complex ETL workflows leveraging Azure Data Factory, Logic Apps, and Function Apps to automate data ingestion from multiple time series sources, reducing manual processing by 60%.
•Enhanced infrastructure reliability by executing projects with budgets >$3M, migrating server sites and applications to modern platforms, and streamlining server configuration and performance tuning.
•Analyzed data using Python libraries such as Pandas and SciPy, building data pipelines and visualizations that identify trends and support data-driven insights.
•Collaborated with development teams to integrate DevOps practices through Azure DevOps CI/CD pipelines, standardizing deployment procedures and improving system reliability.
•Led the migration of over 5TB of legacy data to Snowflake, ensuring seamless, downtime-free transfer and reinforcing robust data ingestion and transformation protocols.
•Engineered comprehensive DataStage workflows to extract, transform, and load data from heterogeneous sources into enterprise data warehouses, enforcing complex business rules for data validation and enrichment.
Iskandia Energy Operating Inc. Mar 2017 - Dec 2021
Reservoir Data Modeling Engineer Houston, TX
•Led a cross-functional team to extract value from decade-old inactive wells, saving $3.5MM in bond money and effectively meeting regulatory obligations with data-driven insights.
•Directed technical and financial evaluations for oil and gas acquisition targets, developing financial models to analyze reserves, production, and economics that supported strategic acquisitions.
•Developed advanced time series models using historical production data spanning 50-70 years; implemented statistical forecasting and trend analysis to inform optimized field development decisions.
•Engineered comprehensive 3D reservoir simulation models for waterflooding and chemical injection programs, increasing data accuracy by 25% and improving retrieval times by 20%, thereby optimizing multi-million dollar field initiatives.
•Led the end-to-end development of Cervart, a custom reservoir modeling software, to produce holistic field representations that enhanced production forecasting and recovery planning.
•Integrated disparate data sources—including internal production systems, financial accounting tools, and government databases—using SQL and Python; designed scalable Snowflake solutions for real-time analytics, boosting data retrieval speed by 300%.
•Collaborated with external partners to implement a DSPA mobile solution, replacing manual spreadsheet-based data collection; integrated infrastructure with central servers to automate data validation and ensure high integrity.
•Utilized ReservoirGrail for detailed fluid flow modeling and pressure analysis, supporting strategic decisions for secondary and enhanced oil recovery operations.
•Optimized query performance by 40% in Snowflake through the application of indexing strategies and advanced query tuning techniques.
•Designed and implemented a real-time, relational data architecture framework that increased data efficiency by 43%, underpinning data-driven decision-making.
•Optimized enterprise ETL pipelines with Informatica, Matillion, and Talend using advanced SQL techniques to transform raw data into actionable business insights.
Tiandi Energy LLC. May 2014 - Mar 2017
Data Analytics Engineer Houston, TX
•Project Leadership: Successfully led and delivered projects with budgets over $500K, overseeing development programs for 1200+ wells across Eagle Ford, Marcellus, and Bakken unconventional shale plays.
•Enterprise-Wide Data Integration Platform: Developed unified system consolidating information for 6,500+ wells across all business units, eliminating data silos and inconsistencies. Created cross-functional Ul with JavaScript, Python, and HTML featuring role-based access controls to maintain a single source of truth while enabling appropriate data visibility throughout the company.
•Agile Leadership: Established team-level cadence and drove ceremonies including Sprint Planning, Daily Scrum, Sprint Retrospectives, and backlog refinement.
•Enterprise Reporting Solution: Built a Tableau reporting module connecting data from all business units through Oracle and MS SQL, enabling transparency, analysis, and performance evaluation.
•Scalable Data Modeling: Designed and implemented a scalable data model supporting a 50% increase in product catalog size and improving system performance by 35%.
•System Monitoring: Developed and maintained data warehouse monitoring and alerting solutions, resulting in 30% reduction in system downtime.
•Cloud Integration: Integrated Snowflake with data lake solutions using Apache Spark to support advanced analytics, reducing data processing time by 50% for large datasets. Developed and optimized numerous stored procedures, functions, and SQL queries in Snowflake, resulting in an enhanced report generation process that saved 20 hours of work weekly.
Mire & Associates Inc. Mar 2014 - May 2014
Business Data Analyst Houston, TX
•Analytics Tool Development: Developed a data analysis and grading tool using VBA & PowerBI that used classical reservoir engineering techniques to identify and rank drilling & workover potential to maximize ROI.
•Investment Analysis: Evaluated Oil & Gas properties through analysis of publicly sourced data including financial documents and 10-K reports, assessing investment risks, corporate structures, and potential valuations.
•Process Automation: Designed and implemented workflows to automate manual processes for evaluating acquisition & divestiture, drilling & completion targets, and workover opportunities.
•Economic Modeling: Generated economic model scenarios for project evaluations and feasibility of new drill and recompletions.
•Developed & Implemented dataflow models to track and update the changes occurring like drilling, new completions, stimulation or fracturing in various external data-sources throughout the lifecycle of the well.
Education
University of Southern California
Aug 2013
Master of Science, Petroleum Engineering
University of Mumbai
May 2011
Bachelor of Engineering, Chemical Engineering
Certifications
•Professional Scrum Master Level I: Scrum.org
•Project Management Certification: Google
•Certified Project Management Professional (PMP)*: PMI (In Progress)