About Me
My name is Nishant Dwivedi
I am a Aspiring Data Scientist skilled in achieving operational efficiency with over 3 years
of experience in Business Intelligence, ETL & Data warehousing applications with 2+
years of experience in implemen...
Please find my contact information at the bottom of this letter, as well as on my enclosed
resume. I appreciate your time spent reading this letter, and look forward to
connecting in the future.
Sincerely,
Nishant Dwivedi
Skills
Software Engineering
Data & Analytics
Development Tools
Programming Language
Web Development
Database
Operating System
Others
Positions
Portfolio Projects
Company
Individual Stats Dashboard
Description
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.
Show More Show LessCompany
Brilliant Factory GE’s Brilliant Manufacturing Software Suite
Description
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:
- Developed rich visualisation dashboards using Tableau Desktop etc. and prepared user stories to create compelling dashboards to deliver actionable insights.
- 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.
- Adding or removing a user in Tableau Server to a publisher role or a interactive role for a particular workbook.
- Monitoring one dashboard which includes the details of all the project related activities, Jobs running from source to mirror layer then to Tableau.
- Provide Product Demos/Presentation to client on a weekly basis.
- Generate reports using Excel and Greenplum data base.
- Transformed reports from Aegis Test Reports (Oracle based DB) to Tableau.
Show More Show Less
Skills
Data Visualization SQL TableauCompany
General Electric (GE) – Plant Score Card
Description
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:
- Developed rich visualisation dashboards using Tableau Desktop etc. and prepared user stories to create compelling dashboards to deliver actionable insights.
- Generate reports using Excel and TERADATA.
- Migrated Previous Excel base application reports Dashboards to Tableau platform.
- Worked on Adhoc reporting and develop interactive dashboards with rich visualisations showing KPI’s.
- Develop and documented technical glitches, system designs, performance test results, and other technical aspects of implementation
- Provide Product Demos/Presentation to client on a weekly basis.
- Made 8 dashboards which were presently there in EX
Skills
Data Visualization SQL TableauCompany
Diligenta - UK Based subsidiary of TCS
Description
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
Show More Show LessTools
Tableau