Vijay

Bhalani

Missouri City, TX *****

860-***-****

ad2cv5@r.postjobfree.com

Summary

Senior Scrum Master with 9 years’ experience and a proven record of delivering complex, high-quality service to diverse clients. Productive team player focused on generating positive results on time and under budget. Firm grasp of proposal development, agile frameworks, infrastructure development, risk mitigation planning, and security planning.

Advanced Power BI Developer & Reporting Engineer with experience in BI tools, relational databases, SQL, data structures, algorithms, and operating systems.

Experienced Systems Administrator & Risk Manager – supported 200+ applications across 600 on-prem and cloud based mixed server environment (Windows/Unix/Linux), for a state agency with emphasis on systems migration, configuration, upgrades and troubleshooting initiatives for better security, integrity, and enhanced IT infrastructure.

7+ years of experience in developing advanced reports and dashboards with 5+ years of strong hands-on Power BI, Spotfire, Tableau experience in creating interactive reports against large datasets. Experienced in data extraction, data modelling, data warehousing and performance optimization.

3+ years hands on experience in Big Data implementation with strong experience on major components of Hadoop Ecosystem ingestion tools like Sqoop, Kafka and Analytic tools like HIVE, PIG, Impala, Spark.

Experience

JANUARY 2022 - PRESENT

Sr. Scrum Master- Cloud Engineer / VDOT, Houston, TX

Delivered successful projects (with budgets >$500K) for interagency clients to decrease web site downtime by more than 25% by migrating server sites and apps to new server and infrastructure. Corrected server configuration problems implemented scripts to ensure smooth server/reboot functioning and assisted with a variety of server configuration & performance tuning.

Led 2 cross-functional scrum teams within the organization to decrease product delivery time by more than 15%.

Directed the implementation and upgrade of old infrastructure (Windows Server 2008) to new (2016 Standard Core & above) and environment for statewide operations. Delivered a major improvement over old infrastructure system that catapulted productivity of apps.

Trained 3 new scrum masters’ and administered Scrum processes, such as sprint planning, sprint reviews, and daily scrums. Evaluated architecture design across the company.

Implemented disaster recovery solutions and achieved 98% uptime for all servers; troubleshoot network and production issues and perform root-cause analysis.

Extensively worked with IBM Datastage Designer and Director to load data from source extract files to the warehouse, Providing the staging solutions for data validation and cleansing with PL/SQL and Datastage ETL jobs.

Resolved a history of problematic network failure by troubleshooting LAN/WAN, firewalls, VPNs, and other network systems connections between various agencies as well as customer service center.

Experience in managing Azure Power BI dedicated capacity and good understanding of management APIs required. Deep understanding of dimensional modeling, enterprise data warehouse and Azure Cloud solutions including Data Factory, Databricks, and Data Lake Storage.

Created multiple TIBCO Spotfire & Power BI Dashboards across different business units. Extended Spotfire functionality using Python, to create action controls/Data Functions for advanced analytics.

Led and trained a 12-person team to continually improve productivity developed scalable applications to improve retrieval and indexing processes.

Facilitated Sprint, Estimation, Retrospect meetings with Business Analysts, Scrum Masters, Product owners and with entire Scrum team; provided support, as needed, for remediation of impediments in support of team commitments.

Implemented data transformation logic using Azure Functions within ADF pipelines; Configured & managed API linked services & conducted performance tuning and optimization of ADF pipelines for improved data processing efficiency.

Ensure all scrum activities are tracked and kept up to date and reported in JIRA.

MARCH 2017 – DECEMBER 2021

Scrum Master / Iskandia Energy Operating Inc., Houston, TX

Led a project with a cross-functional team comprised of operations, geophysics & geology, and regulatory compliance to extract value out of decade old inactive wells saving >$3.5MM in bond money and plugging obligations (W-3X).

Collaborated with product owner to set goals for each project. Provided ongoing professional development on organizational skills and Agile best practices. Helped Product Owner/ Product Managers with prioritization, risk management, and scope management.

Led a team of 15 in development of an online, self-service tool that enabled real-time reporting workflow in Power BI, accessed via Citrix workspace, that housed production data for all the wells in the company (>400 wells and data spanning over last 50-70 years).

Worked in close collaboration with mainframe developers and web designers throughout this $2.5 million, two-year project to build reservoir simulations models for waterflooding and chemical injection program using 3-D modeling and simulation programs like Cervart & ReservoirGrail.

Implemented Data layer for Power BI Reports writing efficient and performant DAX queries; Built visualizations and dashboards on top of the created data layer; Setup and manage deployment pipelines for Power BI reports to automate the release life cycle.

Worked with Snowflake data warehouse; Created snowflake database schemas for several BI solutions.

Ingested data from disparate sources, including but not limited to, internal production reporting system, public government data and paid databases using combination of SQL, Python, and system-specific API to create data views to be used in BI tools like TIBCO Spotfire.

Knowledge of integrating Power Apps with various data sources such as SharePoint, Microsoft Excel, SQL Server, and other cloud-based services.

Experience in integrating Azure Databricks with various data sources and platforms by reading and writing data from and to sources like Azure Storage, Azure Data Lake Storage, Azure SQL Database, Azure Synapse Analytics, or other cloud-based services.

Handled database issues and connections with SQL and NoSQL databases like MongoDB (2.6, 2.4) by installing and configuring various packages in python (Teradata, MySQL dB, MySQL connector, and SQL Alchemy).

Played a major role in creating DevOps pipeline using Azure Automation and PowerShell to automate the deployment of new application versions. Implemented an automated monitoring system for Azure resources using App Service Monitor and Power BI dashboards.

Developed and designed ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing using Talend Big Data, Hadoop, Hive. Well versed with Talend mapping and big data components.

MAY 2014 – MARCH 2017

Scrum Master - Data Analytics Engineer / Statoil Gulf services., Houston, TX

Led 8-person team through creation of projects with budgets over $200K that designed and oversaw development program for over 1200 wells in Eagle Ford, Marcellus, and Bakken unconventional shale plays.

Built an in-house data management & tracking system using combination of applications that housed the well header information for all the assets (more than 6500 wells) in one common UI using JavaScript, Python, HTML that could be used across all departments.

Built a reporting tool (Tableau module) that effectively connected data from all businesses, and piped it through Oracle 12g, thereby allowing transparency, analysis, and performance evaluation.

Migrated Spotfire reports to Power BI Framework, Strong understanding of converting Spotfire calculated columns to DAX statements.

Worked with Product Owner to prioritize product backlog on an ongoing basis to ensure that release timelines are met, and value is delivered to the business.

Established team level cadence and drove team level ceremonies (Sprint Planning meeting, Daily scrum meeting, Sprint retrospective meeting, Sprint review meeting and backlog refinement meeting)

Facilitated daily standups and iteration planning meetings, coordinated retrospectives and demos, and guided work within individual sprints.

Created a reporting tool using SQL & Power BI for the executive team that can parse data in real time from internal data inventory and sources to display 1P, 2P, 3P company reserves as well as projected forecasts calculated based off SEC and PRMS regulations.

Designed, Developed, and support of Data warehousing solutions for Extraction, Transformation and Loading (ETL, Spark) mechanisms as well as installing, configuring, modifying, testing, and deploying applications with Apache Tomcat, and WebSphere.

MARCH 2014 – MAY 2014

Business Data Analyst / Mire & Associates Inc., Houston, TX

Developed data analysis & grading tool using VBA & Power BI, that used classical reservoir engineering techniques to identify and rank drilling & workover potential within new and existing assets to maximize ROI.

Evaluated Oil & Gas properties by parsing and analyzing publicly sourced data like financial documents, 10-K, as well as investment risks, corporate structures, and potential valuation.

Designed and Implemented workflows to automate, partially or fully, manual processes like evaluating A&D, D&C targets, and workover opportunities, utilizing appropriate economic and engineering tools thereby delivering high-quality results that meet clients' needs efficiently.

Designed the workflow to optimize the well models used for production volumes, reserves, forecasting, and secondary/enhanced recovery techniques.

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, stimulations or fracturing in various external data-sources throughout the lifecycle of the well.

Skills

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 • SQL • Oracle 11g/12g • C++ • R Programming • JIRA • MatLab • JSP • Kubernetes • Docker • Kafka • Hadoop • Servlets • Hibernate • Spring • Struts • Web Services • XML • Windows • MacOS • UNIX • Microsoft Suite / Office 365

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

Team player • Time Management • Adaptability • Critical Thinking • Stress Management • Decision Making • Problem Solving

Education

MAY 2011

Bachelor of Engineering in Chemical Engineering / University of Mumbai

AUGUST 2013

Master of Science in Petroleum Engineering / University of Southern California

Certifications

Professional Scrum Master Level I / Scrum.org

Contact this candidate