GEs Brilliant Manufacturing Software Suite, powered by the Industrial Internet, provides critical manufacturing analytics for production efficiency, execution and optimization. The healthcare products(X-ray machine, Surgical equipment etc) which are produced by GE went through certain number of tests and analysis after their production. The data then was saved in Green plum data base after a series of ingestion and ETL process, as a Tableau Developer I analysed that data and created logical dashboard giving useful insights about the products and their parts their efficiency, agility etc. Also taking care of some of the support roles for this project which includes.

POC name was Plant Scorecard: In this POC we measured the supply chains ability to ship on time, based on inventory. Did sentiment analysis of the customer with respect to a particular primary cause. Analysed the comments the customer gave after not liking the shipped product. Also Calculated SCOT (Shipment-Complete-On-Time) for a product/Item delivered to customer from inventory. Compared the timeline of ordered VS shipped quantity. These reports were previously made on excel and customer used to view them on excel based application with its limitations. We implemented and transformed the same in Tableau using Excel and Teradata as the data source.

The primary objective of this project is to capture different Customers, Policies, Claims Agents, Products and financial related data from Oracle database and various flat files. Extracted Transformed Loaded data in to data warehouse using Informatica Powercentre and generated various reports on a daily, weekly monthly and yearly basis. These reports give details of the various products of Allstate Insurance products that are sold. The reports are used for identifying agents for various rewards and awards and performance, risk analysis reports for Business development Managers.

Some of the Key projects that I

have worked on are..

1) Individual Stats Dashboards Creation of more than 25 Individual dashboards which Show Monthly Performance (Billings, Invoicing, shifts booked,) of Consultants using User Level Security for 350+ users.

2) CFO Dashboard Developed CFO dashboard for one of the biggest Pharmaceutical Company in the World. The dashboards contained KPI’s such as Sales, Budget, Margin, and EBIDTA & Expense

3) Plant Scorecard It was a POC to measure Supply Chain’s Ability to ship products on time. Depicted some key KPI’s such as SCOT- Shipment completed on time, did sentiment analysis of the customer. Converted all old excel reports to Tableau in this POC.

Project Summary (Agile Based): Brilliant Factory GE’s Brilliant Manufacturing Software Suite, powered by the Industrial Internet, provides critical manufacturing analytics for production efficiency, execution and optimization. The healthcare products(X-ray machine, Surgical equipment etc) which are produced by GE went through certain number of tests and analysis after their production. The data then was saved in Green plum data base after a series of ingestion and ETL process, as a Tableau Developer I analysed that data and created logical dashboard giving useful insights about the products and their parts their efficiency, agility etc.

Also taking care of some of the support roles for this project which includes.

My Main roles and responsibility here were:

1. Developed rich visualisation dashboards using Tableau Desktop etc. and prepared user stories to create compelling dashboards to deliver actionable insights.
2. Providing support to self-service users to be able to view these reports and also for some of them to re-create the same according to their usage.
3. Adding or removing a user in Tableau Server to a publisher role or a interactive role for a particular workbook.
4. Monitoring one dashboard which includes the details of all the project related activities, Jobs running from source to mirror layer then to Tableau.
5. Provide Product Demos/Presentation to client on a weekly basis.
6. Generate reports using Excel and Greenplum data base.
7. Transformed reports from Aegis Test Reports (Oracle based DB) to Tableau.

POC Summary: POC name was Plant Scorecard: In this POC we measured the supply chain's ability to ship on time, based on inventory. Did sentiment analysis of the customer with respect to a particular primary cause.

• Analysed the comments the customer gave after not liking the shipped product. Also Calculated SCOT (Shipment-Complete-On-Time) for a product/Item delivered to customer from inventory.
• Compared the timeline of ordered VS shipped quantity.
• These reports were previously made on excel and customer used to view them on excel based application with its limitations. We implemented and transformed the same in Tableau using Excel and Teradata as the data source.

My Main roles and responsibility here were:

1. Developed rich visualisation dashboards using Tableau Desktop etc. and prepared user stories to create compelling dashboards to deliver actionable insights.
2. Generate reports using Excel and TERADATA.
3. Migrated Previous Excel base application reports Dashboards to Tableau platform.
4. Worked on Adhoc reporting and develop interactive dashboards with rich visualisations showing KPI’s.
5. Develop and documented technical glitches, system designs, performance test results, and other technical aspects of implementation
6. Provide Product Demos/Presentation to client on a weekly basis.
7. Made 8 dashboards which were presently there in EX

Project Summary: The primary objective of this project is to capture different Customers, Policies, Claims Agents, Products and financial related data from Oracle database and various flat files. Extracted Transformed Loaded data in to data warehouse using Informatica Powercentre and generated various reports on a daily, weekly monthly and yearly basis. These reports give details of the various products of Allstate Insurance products that are sold. The reports are used for identifying agents for various rewards and awards and performance, risk analysis reports for Business development Managers

This Company is into Transportation of goods in Thailand, its IT service is taking care here in India. I Took 6 months of data from the client and created a POC with 6 Tableau Dashboards, showcasing the 1) On time Delivery of shipments. 2) Change in performance in wrt delivery of materials. 3) Freight Analysis and Shipment by Freight 4) Fleet Utilization. 5) Cycle time.

RBL is one of the clients of CRG and I was deployed here from 11th November onwards mainly due to demonetization coming into the picture there was a sudden requirement of extra Tableau resource in this bank. This bank does its reporting in Tableau and sources of data is basically excel and SQL server.

Sun Pharma was the one of the major clients of CRG, I worked there from December till my last day in CRG. It is the largest chronic prescription company in India and a market leader.