Developer Data
Resume:
Nishant Dwivedi Technical Lead
Gera Trinity Towers, Tower 1B-404, Kharadi 411014
Email: ac6thr@r.postjobfree.com
Tableau Public Profile: https://public.tableau.com/profile/nishant.dwivedi
LINKEDIN Profile: https://www.linkedin.com/in/nishant-dwivedi-1b511984/
Synopsis:
Business Analyst skilled in achieving operational efficiency with over 3 years of experience in Business Intelligence, ETL & Data warehousing applications with 2+ year of experience in implementation of Business Intelligence (BI) projects, reports & dashboards development in Tableau Software.
Extensive experience in working with various Business Intelligence Data Visualization tools with specialisation on Tableau Desktop and developed plant level dashboards
Sound knowledge of Tableau Desktop, Tableau Server and Informatica Powercenter 9.1.0.
Experience on various phases of SDLC with 2+ yrs. of client conversations, requirement gathering, BRD/FRD documentation, flow charts and use cases.
Developed many Viz's, charts, & dashboard's including Donut charts, line charts, Sankey diagram, charts containing action filters, hierarchal charts, waffle chart, bar charts and many more.
Provided support to self-service users to be able to view and remake the reports I created on TABLEAU.
Made many business dashboards according to the client requirement containing different types of datasets.
Proficient in Migration of Reports from Excel to Tableau and presenting the dashboard using Story Points feature, devoloping Dashboards, delivering KPI and trend information to business lines, sales development, and marketing groups.
Having Good knowledge on Data Warehousing and Business Intelligence concepts with emphasis on Extraction Transformation and Loading data of a business process including requirement Development and Implementation.
Hands on experience in designing and developing Dashboards using source data from disparate systems with understanding of Data Models and ETL procedures.
Extensive experience using Informatica components Designer, Workflow Manager, Workflow Monitor.
Possess excellent communication, interpersonal, analytical, problem-solving and organizational skills.
Technical Skills
1)Reporting Tools: TABLEAU 8.X, 9.X, 10.X, Spotfire, MS-Excel
2)ETL Tools: Informatica Powercenter 9.1.0
3)MDM Tool- Informatica MDM
4)Databases: MS-SQL Server, Teradata, Post Gre, Oracle
5)Scripting Language: Python Basics
6)Domain: Healthcare, Insurance, Banking, Pharmaceutical
7)Hardware/OS: Windows 7, 8, 10, Mac
8)Ticket Monitoring Tools: Manage Engine, Assyst
Career Profile
Company Name: ID Medical Group
Designation: Business Analyst
Period: April 2017 – Present
ID Medical is the UK's leading multidisciplinary healthcare recruiter. Formed in 2002, and now work with over 90% of NHS trusts, in addition to private medical organisations. There offering spans doctors, nurses, and allied health professionals.
My major part of the work here Included Working with Management and Healthcare professionals to develop a reporting solution for Recruitment, Finance and Administration.
Analysing the data gathered from the Doctors, Nurses & AHP’s from their recruitment to working for a hospital.
Creation of more than 25 Individual dashboards which Show Monthly Performance (Billings, Invoicing, shifts booked,) of Consultants using User Level Security for 350+ users.
Made Summary Dashboard for the Managers, Senior Managers & the Directors with different level of USER Filters.
Business Trip:
Visited UK Milton Keynes Office of ID Medical for 2 months on a Business Trip for understanding the business and functioning of the organization also met the key Stakeholders and UK counterparts for better understanding of their requirements and about the business.
My main roles and responsibilities here are:
1) Capture business requirements and analyse as needed to ensure business requirements are exceeded
2) Performed feasibility check working closely with business users.
3) Implementation of user level security for over 350 users on enterprise level Tableau Server on 50 plus dashboards.
4) Analyse data available and effectively create mock reports and dashboards, ensuring information is complete and
Easy to understand and interpret
7)Effectively create dashboards using quick filters, parameters and sets to analyse data more efficiently
6)Participate in walkthrough meetings and provide necessary updates and recommendations to increase project productivity.
Company Name: Corporate Renaissance Group- Mumbai (Experience of Three Different projects in Three different domains)
Designation: Consultant (Data Visualization Services)
Period: October 2016 – April 2017
In this short span of time I have successfully completed one POC for an IT firm named AUTOPLANT and have worked for RBL(Ratnakar Bank) & Sun Pharma as Tableau Consultant in client location,
i)AUTOPLANT: 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.
My main roles and responsibilities here are:
1) Developed POCs by building reports and dashboards using Tableau 9.0/9.1/9.2 to demonstrate quick wins
2) Developed complex calculated fields for the business logic, field actions, sets and parameters to include various
Filtering capabilities for the dashboards, and to provide drill down features for the detailed reports
3) Making Tablet and phone versions of the same dashboards & publishing the same dashboards to the server and scheduling the dashboards according to their importance.
ii)Ratnakar Bank Limited (RBL): 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.
My main roles and responsibilities here are:
1)Making Dashboards of daily cash deposited in the bank and compare the deposits to the previous month.
2)Making Tablet and phone versions of the same dashboards & publishing the same dashboards to the server and scheduling the dashboards according to their importance ranging from 15 minutes of time to 12 hour of time.
3)Doing Twitter analytics of the RBL bank handle in the twitter, doing sentiment analysis of the customer’s words and expressions. Basically the dashboard included sentiments, reach, best time to tweet & engagement rate as some of the parameters.
4)Also was a part of the team who made real time cash deposit dashboard.
iii)Sun Pharma: 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.
My Main roles and responsibility here were:
1)Taking requirement from the stakeholders from the person who are best in the medicine industry and making the reports according to their needs.
2)Making dashboard for the CFO of Sun Pharma’s s depicting many KPI’s such as Sales, Budget, Margin, EBIDTA and Expense. It was one of the highlights of my career till now as I got many appreciations for this one.
3)Making Tablet and phone versions of the CFO dashboards & publishing the same dashboards to the server and scheduling the dashboards according to their importance ranging from 15 minutes of time to 12 hour of time.
4)Provide product Demos/Presentation to stakeholders on a weekly basis.
Company Name: Tata Consultancy Services – Pune
Designation: Systems Engineer and role was Tableau Developer
Period: March 2015 – October 2016
1)Tableau Developer (March 2015 – October 2016)
Project: General Electric (GE) – Brilliant Factory
Domain: Healthcare.
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.
2)Tableau Developer (March 2014 – Feb 2015)
Project: General Electric (GE) – Plant Score Card
Domain: Healthcare.
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
3)Informatica Developer(June 2013 –March 2014)
Job Profile:
1)Requirements gathering and requirement analysis.
2)Extensively used Informatica PowerCenter for loading the data into Oracle Database.
3)Involved in preparation of Low Level Design Documents (LLD).
4)Analysed the sources, targets, transformed the data, mapped the data and loaded the data.
5)Worked on various transformations (Joiner, Sorter, Filter, Aggregation etc.) used in Informatica.
Project: Diligenta - UK Based subsidiary of TCS
Domain: Insurance
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.
Initial Learning Program at TCS
ILP(March 2013 – May 2013)
Completed Initial Learning program in May 2013 with below mentioned modules
1)Informatica Powercenter.
2)SQL.
3)Mainframes - JCL, IMS DB2
Career Achievements
1)Best new comer award given by the Director of the company ID- MEDICAL in Milton Keynes Office.
2) Awarded With Appreciation for Excellent performance in June 2015
3)Pat on the Back award for creating dynamic dashboard for strategy team in January 2016.
4)Awarded for being an active member of the FUN@WORKS team in GE account conducting account level activities and social activities frequently.
5)Got many Medals and Certificate for School level and College level Cricket tournament.
Personal Particulars
B. E. (Electronics & Communication Engineering) from R.G.T.U University (2012)
Schooling (Johnson school, Jabalpur)
10th 2006- 74.6% (2006)
12th 2008- 82.5% (2008)
Date of Birth: 15th September
Father: Kailash Chandra Dwivedi
Languages Known: English, Hindi
I do hereby declare that the particulars of information and facts stated herein above are true, correct and complete to the best of my knowledge and belief.
Place: Pune, India
Date:
Nishant Dwivedi
Contact this candidate