Tek07631

Business Analyst - 9 + Year


MBA

Highlights

My core competency lies in the oil and gas sector with clear understanding of petroleum upstream, midstream & downstream sector. I have a very good understanding of refined products, market and economics of refining business, product trading along with indicators affecting price dynamics, trade in international market, supply and demand balances. Besides, I also lead a team to scope, develop and deliver research reports and BI applications built on enterprise applications such as Microsoft Excel, Power BI, and QlikView.


Skills
Other Skills
  • Project management
  • Team management
  • Stakeholder management
  • Database management
  • Data analysis & modeling
  • Secondary research
  • Competitive analysis
  • Benchmarking
  • Proficient with MS Office applications
  • Basics of SQL & Python PowerBi
Projects

Project 1 Downstream - IT Industry

    Global crude balances data model and visualization tool built on Power BI [WIP]

     



    Objective: To create a market intelligence tool by leveraging information captured in the in-house global refinery database and datasets from various databases available in Springrock, Petrologistics, Energy Aspects, JODI, IHS Edin, Cargo tracking databases such as Kpler, Clipper and Llyods.



    Approach:




    • Co-ordinate with Client and internal BI tool development team to understand the requirement. Create scope document and detailed requirement of the project. Share with the internal team and support them for any clarifications required on the business and oil & gas technical aspect of the project.



    Excel based data model for deriving Forties, Urals refining margins for a hypothetical refinery located in NWE 



    Approach:




    • Create a refinery margins model for a hypothetical refinery situated in NWE by factoring in different refinery configuration, refining yields, and crude slate. Feedstock cost and product prices are retrieved from Platts daily assessments. Product crack spreads and essentially refining margins are calculated and represented in a structured format for daily consumption.


Project 2 Mid-Downstream - IT Industry

    Weekly news report

    Objective: To capture information and summarize top news in the mid-downstream sector. Approach:

    Initially scoped major sources available in the market. Co-ordinated with the client and proposed a structure for the report. Made trial runs and received good feedback from the client


Project 3 - IT Industry


    • Visit to client site, in Norway, for gathering business requirement and then scoped, initiated and developed products to align with company’s digitalization efforts.



    Key achievements:




    • Promoted from Business analyst to Senior Business Analyst in a short term of one year, compared to team average of at least two years.

    • Part of a team of 5 people in 2017 for renewing contract with the client for next seven years.


Project 4 - IT Industry

    Roles and responsibilities:




    • Was a project engineer in the IBM WebSphere portal team which provided production support for an Insurance company based in the US.

    • To provide assistance to end users while also identifying any issues in production. To ensure stability of business- critical application processes and associated application infrastructure and acting as the first line of support for production and business applications.

    • Responded to client needs by evaluating requests via telephone at a rate of 10-20 calls per shift.


Awards
  • Awarded Best Analyst in company’s recognition programme under excellent client support category.