• Working directly under Vistara CIIO and CSO.
• Sitting in Vistara HQ Gurgaon to implement Route Profitability Analysis that will help in analysis of flights and performance of old routes, new routes to be opened and other budgeting, forecasting and revenue analysis.
• Data sets include cost and revenue analysis from various sources such as AMADEUS, ACARS, FMS, ODS, SAP, Flight ops, Engineering, IATA messages.
• Working on Project Planning, Technical Design document, Technical Architecture, Vendor Management, Business Data Analysis from above mentioned sources.
• Gathering Requirements from Finance and Commercial Team and liaising with vendor for technology, design, development and implementation of same.
• POC on ETL tools for EDIFACT and IATA message decryption capabilities.
• Planning and implementation documents like RFP, RFQ, RSD, SOW, BRD analysis.

Working directly under Vistara CIIO and CSO. Sitting in Vistara HQ Gurgaon to implement Route Profitability Analysis that will help in analysis of flights and performance of old routes, new routes to be opened and other budgeting, forecasting and revenue analysis. Data sets include cost and revenue analysis from various sources such as AMADEUS, ACARS, FMS, ODS, SAP, Flight ops, Engineering, IATA messages. Working on Project Planning, Technical Design document, Technical Architecture, Vendor Management, Business Data Analysis from above mentioned sources. Gathering Requirements from Finance and Commercial Team and liaising with vendor for technology, design, development and implementation of same. POC on ETL tools for EDIFACT and IATA message decryption capabilities. Planning and implementation documents like RFP, RFQ, RSD, SOW, BRD analysis.

Client Handling, Variance calls, Requirement Gathering, Use / Test case analysis. Redshift database backend development activities for Tableau reporting. Crontab and Windows Scheduling for Python scripts. Various sources such as SQL Server, Salesforce, Oracle, SAP. Converting source data to csv files in S3 buckets and thereafter loading into Redshift database. Basic Linux and Python scripts creation and Crontab scheduling. Other techs include MongoDB api and database, GreenPlum.

This is one of the biggest health care providers in Europe. Implemented / developed open-emr (electronic medical record) backend database tables for entire doctor-patient healthcare landscape tracking. Application for diagnosed patient daily activities which concerned various diseases. Backend table and ETL job creation.

Data Correction project for various divisions of Reliance Petro-Chemicals, hydrocarbons, Hardware Division, Jio Telecom, Human Resource. Worked as Tech Lead for Reliance Data Quality Project – Analytics Team. Client interaction and requirement gathering meetings, calls. Business / Tech suggestions, sign-offs, requirement analysis, tech analysis. Escalation Handling, Configuration Management, Team Tracker.

The SLB-Reporter as an application was being used by various teams, field users working world wide as well as helpdesk information engineers to create/resolve tickets, share the knowledge collaborate and share content. There were around 20 applications and 65 subject Areas which we supported and due communication to client manager and all the third parties was involved in case of production issues. Many major and minor enhancements and support tickets. Production, Data Quality and Performance Follow ups were a part of daily tasks. End to End Implementation of 2 Subject Areas - Data Reservoir and Global Compatibility Ratio was done as a part of this L3 Team. Worked on the business requirements and converting it into technical design (HLD to LLD). Designed ETL processes using Informatica tool to load data from various source systems (flat files and relational database) into the target Oracle 11g database, database analysis. Transformations like Joiner, Aggregate, Expression, Filter, update Strategy and Lookups required for Data Extraction, Cleansing, Loading into OLAP database as per the business requirements. Autosys job creation, schedule / monitor the jobs, send the messages in case of process failures. Worked as a sole resource for Essbase Support in my project. Peer review and testcase validations, Unit testing, integration testing & End-to-End testing. Resolution of incidents, loading errors and responsible for communicating with the Client manager and server hosting/Operation support vendors in case of production load failures. End to End Implementation of 2 Subject Areas using - Informatica mappings / workflows, Bash Scripting, Oracle Database, Autosys jobs. Data Quality, Performance and Production Follow ups. ALM Ticketing Tool, Dashboard, Share-point and Daily trackers. Client Interaction and understanding Business Requirements.

Numantra Project 3)

Philips USA (Healthcare Domain)

August 2018 – April 2019

Client Handling, Variance calls, Requirement Gathering, Use / Test case analysis.

Redshift database backend development activities for Tableau reporting.

Crontab and Windows Scheduling for Python scripts.

Various sources such as SQL Server, Salesforce, Oracle, SAP.

Converting source data to csv files in S3 buckets and thereafter loading into Redshift database.

Basic Linux and Python scripts creation and Crontab scheduling.

Other techs include MongoDB api and database, GreenPlum.

Numantra Project 2)

Medtronic Europe

June 2018 – November 2018

This is one of the biggest health care providers in Europe.

Implemented / developed open-emr (electronic medical record) backend database tables for entire doctor-patient healthcare landscape tracking.

Application for diagnosed patient daily activities which concerned various diseases.

Backend table and ETL job creation.

Numantra Project 1)

Reliance Analytics - Data Quality Reporter.

October 2017 – August 2018

Data Correction project for various divisions of Reliance Petro-Chemicals, hydrocarbons, Hardware Division, Jio Telecom, Human Resource.

Worked as Tech Lead for Reliance Data Quality Project – Analytics Team.

Client interaction and requirement gathering meetings, calls.

Business / Tech suggestions, sign-offs, requirement analysis, tech analysis.

Escalation Handling, Configuration Management, Team Tracker.

Capgemini Project 1)

Schlumberger Reporter – L3 Team

July’15 – September’17

The SLB-Reporter as an application was being used by various teams, field users working world wide as well as helpdesk information engineers to create/resolve tickets, share the knowledge collaborate and share content. There were around 20 applications and 65 subject Areas which we supported and due communication to client manager and all the third parties was involved in case of production issues. Many major and minor enhancements and support tickets. Production, Data Quality and Performance Follow ups were a part of daily tasks.

End to End Implementation of 2 Subject Areas - Data Reservoir and Global Compatibility Ratio was done as a part of this L3 Team.

Sub Project 1)

SLB Global Compatibility Ratio.

April 2017 – June 2017

(3 Months)

Due to SAP ITT and Data Lake Migration many subject areas were pushed out of their legacy systems like SIEBEL, CRM and LAWSON) to get integrated into one, thus putting legacy systems and bringing uniformity across all applications. This Subject Area was developed from scratch and kept a track of all the vendor orders, orders completed, machines available and their location, global compatibility of machines with location and country constraints, trackability and various other things.

Technical tasks included creation of - 20 mappings/workflows, 22 Autosys jobs, 22 bashes, 21 database tables and mat views. Other tasks involved source and firewall port checking, OBIEE report validations, QA testing and Prod feasibility assurance.

Sub Project 2)

SLB Data Reservoir.

Dec 2016 – Mar 2017

(3.5 months)

This Subject Area helped in tracking the rigs, wells and machine statuses. The old legacy sources EMCC and EOMR were getting decommissioned hence a new subject area with advanced functionality was a dire need.

Technical tasks included creation of - 14 mappings/workflows, 16 bashes, 16 Autosys jobs, 15 database tables and mat views, OBIEE rpd creation along with security and hierarchy.

Sub Project 3)

SLB HFM Finance.

May 2015 - July 2015

(3 months)

This Subject Area keeps a track of all the internal revenue that the client generates along with keeping track of the forecasting, planning, trailing and actual profit generated. We were given a task of modifying this Subject Area to include larger no. of accounts and geographies. Implemented the accrual, deferral and invoices maintenance mechanism.

Technical tasks included ETL / Database / Autosys Job development. OBIEE reports and rpd development. Creating materialized views, data compression, performance upgrades. Validation and Environment upkeeping activities. Enhancements / Anomalies for addition of Accrual / Deferral revenues. Data Quality and Production follow-ups.

Capgemini Project 2) Schlumberger Reporter Migration

Oct 2014 - May 2015

(8 months)

The Project was aimed to convert the costly windows server into budget friendly LINUX servers for the L3 development team. The Informatica power centre was upgraded from 8.6 to 9.5. This involved complex scenario testing and data validations.

Server changed from Windows to Linux and Informatica 8.6 to 9.5 upgrade.

Immense Data Validation Tasks (involved Informatica, Unix Bash Scripting and Autosys. Validations of environment, server and configuration/feasibility level.)

Client Interactions for sign-offs and understandings.

Peer review and validations and integration / end-to-end testing.