Prafulla Kharwadey	 &ndash; Spot 	fire BI 	architect	             	          	          	  	
 	
 	 	
 
Professional Summary	:  	 	 	 	 	 	 	
 
&bull; 	Lead/Architect/Management experience for handling various customer projects.	 	
&bull; 	12 yrs 	Working 	knowledge of 	Spotfire	/ PowerBI / Tableau / 	Google cloud / 	AWS 	 	
&bull; 	Working  knowledge  of  data  science  concept  including  linear/log  regression,  multivariate  linear  regression 
using r and TERR. 	 	
&bull; 	ETL tools like SSIS. 	 	
&bull; 	10	+ years  of 	IT 	experience  in	cluding	 Architecture	, Technical  Leadership	, Software 	programming  and 	
Development	, Migration	 and 	Support using	 Microsoft 	technologies. 	 	
&bull; 	Expertise  in  web  applications  using 	ASP.NET	, C#	, VB.NET	, JavaScript	, JQuery, 	Web	-Services	,  WCF	 and 	
Design Patterns.	 Expert in MS SQL Database design, architecture, programming	 	
&bull; 	Full  life	-cycle  development  experience  including  design,  development,  testing,  documentation,  on	-site 	
implementation and user training. 	 	
&bull; 	Significant exposure to 	Agile Methodology	, Scrum,	 Proposal and Estimation 	processes.	 	
&bull; 	Good 	project	 leadership skills and invariably meets client expectations	. 	
&bull; 	Excellent written and verbal communication skills.	 	
&bull; 	Domains experience in 	Manufacturing / Retail / Supply chain management / Finance	 / Service	 /Logistic	  	
&bull; 	Got UK Excellence Award from FUJITSU, UK	 	
&bull; 	Technical write up via blog	ging 	 (www.sqlwebmentor.blogspot.com	, www.mydotnetcoding.blogspot.com	, 	
www.qlikviewmentor.blogspot.com	). 	Got Editor Choice award by 	www.dotnetspider.com	 	
&bull; 	Valid work permission H1B, USA	 	
Skills Summary	: 	
 
Category	 	Major Skills 	&ndash; Primary	 	Minor Skills 	&ndash; 	
Secondary	 	
Domains	 	Manufacture, Retail, Supply chain Management, 
Finance [Share],	 Localization	 	 	
BI/Analytics Technology	 	Power BI	, Tableau	, Spotfire	, TIBCO Spotfire Server 	
Administration	, TIBCO Spotfire Automation	, 	
Customization programming	, Qlikview, SSIS	,SSRS	 	
JSVIZ, 	D3 Charts	 	
Programming Skills	 	
 	
AngularJS, ReactJS, 	python, 	SSIS	, Dot Net 1.1, 	
2.0,3.5, C#, VB.NET, ASP.NET, ASP, JavaScript, 	MS 	
SQL, UML, 	Generics	, LINQ	,   Web Services, Ajax, VBA	   	
VB, WCF,  WPF, WWF, 
SSMA	 	
AWS	 	Redshift, Hive, RDS, Lambda, Glue	 	 	
Virtualization	 	Denodo	 	 	
Tools &amp; Techniques	 	MS Projects 2000, VISIO 2000 , UML	 	 	
Databases	 	SQL 2000, SQL 2005,	 SQL 2008	 	MS Access	 	
ETL	 Tools	 	SSIS	 	 	
Operating Systems	 	Windows 2000, XP, 2003

Educational 	Qualification	: 	
 
BE in 	Electronics and 	Telecomm. Engineering	  	
 
Employment History:	 	
Employer	 	From	 	To	 	Designation	 	Area	 	
Confidential	 	Mar 2021	 	Till date	 	BI Architect /Tech 
Lead	 	
Power BI, Spotfire, Google cloud, 
SQL	 	
ATOS 	SYNTEL, 	
USA	 	FEB 2020	 	Mar 2021	 	BI Architect /Lead	 	Spotfire, 	Power Bi, 	Google cloud, 	
SQL	 	
Asurion	 	Feb 2017	 	JAN 2020	 	BI Architect	 	Spotfire, Power BI, Tableau,  AWS, 
AngularJS, Data Science, R, Python	 	
Johnson and 
Johnson, USA	 	Jan 2015	 	Feb 2017	 	BI Architect	 	Spotfire/Tableau, DotNET Bootstrap, 
SSIS, SQL	 	
TIBCO Software	 	July 2011	 	Dec 2014	 	Technical Lead / BI 
Architect	 	
Spotfire, Analytics, 	Presales, 	
consulting, education and training, 
competency building and resource 
management, delivery, R&amp;D	 	
 
 
Projects	:  	
 
Customer	 	FEDEX, Pittsburg, USA (ATOS SYNTEL)	 	
Period	 	Feb 2020 to 	till date	 	
FedEx	 Corporation is an American multinational delivery services company	.   Fedex Ground in pittsburg is one 	
of the biggest BI 	clients	 consuming Spotfire extensively for reporting and analytics	. It&rsquo;s been used in various 	
departments like Linehaul, purchase etc. 	Fedex	 was moving from SQL server to GCP.  Reporting technology is 	
getting migrated to newer version of 	Spotfire	 in cloud.	 In continuation Spotfire is being migrated on Power BI	 	
BI Admin/	Architect	 (Spotfire/ Power Bi/GCP)	 	
&bull; 	Spotfire to power BI migration.	 	
&bull; 	Power bi report 	development, 	support,	 and admin activities.	 	
&bull; 	Manage team, scrum, pi planning in agile way.	 	
&bull; 	Spotfire 	infrastructure build 	into	 GCP. 	 	
&bull; 	Maintain 	Spotfire	 infrastructure and 	environment.	 	
&bull; 	Business requirements	 documentation	, relational database design, progr	amming, testing, implementation.	 	
&bull; 	Working  closely  with  Customer  to  identify  the  technical  approach  to  be  used  and  the  deliverables  to  be 
furnished at the completion of the project.	 	
&bull; 	System Administration (includes site creation, server maintenance/Upgrades/patches).	 	
&bull; 	Change  management	 and 	Monitor  server  activity/usage  statistics  to  identify  possible  performance 	
issues/	enhancements.	 	
&bull; 	Partner with the business to design tableau KPI scorecards &amp; dashboards.	 	
&bull; 	Performance  tuning 	and 	Create/Manage  Groups,  Workbooks  and  Projects,  Database  Views,  Data  Sources, 	
and Data Connections.	 	
&bull; 	Proactively communicate with the Customer/Stakeholders to resolve issues and get work done.	 	
&bull; 	Set up a governance process around Tableau dashboard processes.	 	
&bull; 	Handles new report/ Adhoc report development.	 	
&bull; 	Handles support activities and data quality issues for preexisting projects.	 	
&bull; 	Architect BI solution using Spotfire/Tableau and SQL database.	 	
&bull; 	Perform various RnD related to 	Spotfire,	 JSViz and D3 charts. 	 	
&bull; 	Propose various 	approaches	 and 	solutions	 based on PoCs.

Technologies	 	Spotfire ,Power BI,Tableau,Dot Net/AngularJS, 	Redshift, 	Hive, RDS, 	SQ	, Python, 	
Lambda	 	
 
 
Customer	 	ASURION, Nashville, USA	 	
Period	 	Feb 2017 	to JAN 2020	 	
ASURION is mobile insurance company and is one of the largest in USA having more subscriber than Netflix in 
USA and across.	 Asurion is one of the biggest client consuming spotfire 	and power BI 	extensively for reporting 	
and analytics	. It&rsquo;s been used in various 	departments	 like SCM, mobility, product etc.	 Asurion 	was moving	 from 	
SQL server to AWS.	 	
Reporting t	echnology is getting migrated to POWER BI. I have good knowledge of 	Tableau/	Spotfire	/POWER BI 	
mobile APP, Admin activities, deployment process	. I am handling BI stack including Tableau, spotfire and 	
power bi.	 	
 
BI 	Admin/	Architect	/UI expert using .Net/ 	AWS 	(Spotfire	/Tableau/Power Bi/AWS	) 	
&bull; 	Architect BI solution using 	Spotfire	, P	ower BI	 , Tableau 	and SQL database	. 	
&bull; 	Migration form older version to newer one.	 	
&bull; 	Manage team, scrum, pi planning in agile way.	 	
&bull; 	Handled 	tableau/ 	spotfie /POWER BI 	admin activities involving 	. Handles adhoc report requests.	 	
&bull; 	Created reporting portal using Dot Net and AngularJS.	 	
&bull; 	Created  various  inhouse  applications  that  needs  user  inter	face  using  DotNet  and  angul	arJS  for  various 	
departments on request basis.	 	
&bull; 	Propose  various  approach  and  solution  based  on  PoCs.  Directing  the  strategic  plan,  development  of 
business  requirements,  development  of  functional  and  program  specifications,  relational  database  design, 
programming, testing, implementation and documentation for applications	 	
&bull; 	Working  closely  with  Customer  to  identify  the  technical  approach  to  be  used  and  the  deliverables  to  be 
furnished at the completion of the project.	 Follow development schedule 	to ensure that timely delivery.	 	
&bull; 	Perform User Management Administration for 	spotfire	 / Power BI	 	
&bull; 	Handles  support  activities  and  data  quality  issues  for  pre	-existing  projects  and  c	reate	d datamarts  using 	
redshift, hive	(AWS migration)	, S3, AWS lambda and glue, written python program	 	
&bull; 	Forecasting model for Salvage value for mobiles using Multivariant Linear Regression using R language	 	
Technologies	 	Spotfire	 ,Power BI	,Tableau,Dot Net/AngularJS	, Redshift, Hive	, RDS, 	MS SQL	,Pyth	on, 	
Lambda	 	
 
 
Customer	 	VISTAKON, Johnson &amp; Johnson USA	 	
Period	 	Jan 2015	 to 	Feb 2017	 	
Vistakon is a contact lens manufacturing unit of Johnson &amp; Johnson	. Engineering division of Vistakon works on 	
the various lines implementing new designs, using new materials and new machines.	 	
 
The need was there to build an analytical solution to collect all the line lens/lot relevant and actionable data 
back to users to continuously improve the designs and product yields by evaluation the collected data.	 	
 
It&rsquo;s a data collection process that continuously pulls and gathers data, churn it, and transform it and bring 
back meaningful defect lens information that is an actionable insight for continuous improvement in machine, 
design, production line and proces	s. 	
BI 	Architect	 (Spotfire/Tableau	) 	
&bull; 	Architect BI solution using 	Spotfire/Tableau	 and SQL database and SSIS ETL tool	 	
&bull; 	Perform various RnD related to 	Spotfire	 , JSViz 	and D3 charts. 	 	
&bull; 	Propose various approach and solution based on PoCs. 	 	
&bull; 	Directing  the  strategic  plan,  development  of  business  requirements,  development  of  functional  and 
program  specifications,  relational  database  design,  programming,  testing,  implementation  and

documentation for applications	 	
&bull; 	Working  closely  with  Customer  to  identify  the  technical  approach  to  be  used  and  the  deliverables  to  be 
furnished at the completion of the project.	 	
&bull; 	Follow development schedule 	to ensure that timely delivery.	 	
&bull; 	Perform User Management Administration for 	Spotfire and Tableau	. 	
&bull; 	Handles adhoc report requests.	 	
&bull; 	Handles support activities and data quality issues for preexisting projects.	 	
Technologies	 	Spotfire Tableau	, Dot Net with bootstrap,	 D3 Charts	, SSIS	, MS SQL	 	
 
 
Customer	 	P&amp;G USA	 	
Period	 	Dec	 20	12 to 	Dec 2014	 	
Procter &amp; Gamble Co.,	 also known as	 P&amp;G	, is an American	 multinational	 consumer goods	 company. P&amp;G is 	
one of the biggest client for Spotfire and implemented around more 	than 50	 Spotfire analytical 	projects 	
/applications of various scale.	 	
Solution Architecture for Review and Technical assistance for more than 40 Spotfire solutions	 	
Roles and responsibilities as 	Technical Leader / Solution 	Architect	 	
&bull; 	Defined standards and process for Solution Review	 	
&bull; 	Defined standard for best practices in terms of usability and data design.	 	
&bull; 	Participate in architectural discussions of project design and provided guidance to various project teams.	 	
&bull; 	Working  closely  with  Customer  to  identify  the  technical  approach  to  be  used  and  the  deliverables  to  be 
furnished at the completion of the project.	 	
&bull; 	Architect, Design	 to ensure that timely delivery.	 	
&bull; 	Consulting  and  mentoring technical  resources  concerning  methods,  procedures,  and  standards  to  be  used 
during design, development, and unit testing phases of system development projects.	 	
&bull; 	Schedule/conduct	 series of 	quality reviews for Spotfire project 	to give Go/No	-Go decision 	before it goes to 	
production  making  sure  projects  are  as  per  defined  standards  across  P&amp;G,  best  suited  from  performance 
perspective.	 	
&bull; 	Assists and guide project team for performance improvement.	 	
Technologies	 	Spotfire, MS SQL, SSIS, Custom D3 charts	 	
 
 
 
 
TIBCO Spotfire	 as a role of Technical Lead	 and Architect	 	
 
I have h	andled	 (designed, architect) for 	various	 Spotfire BI projects with a team of 8 resources and took part 	
in almost all areas like Presales, consulting, education and training, competency building, delivery, R&amp;D. 	 	
 
Period	 	July	 20	11	 to 	Dec 2012	 	
Clients	 	Responsibility	 	
Garuda Airlines (Indonesia)	 	Spotfire Custom Datasource for 	Amadeus 	Webservice in spotfire	 	
Novartis Support  (UK)	 	Technical Support at Architect level.	 	
TSMC, Pareto Chart 
(TAIWAN)	 	
Architect design for custom Chart, development, design, manages in spotfire 
using spotfire API SDK.	 	
AstraZeneca (	UK	) &ndash; Gantt 	
Chart	 	
Custom Gantt Chart development, design, manages in spotfire using spotfire API 
SDK.

Credit Agricole, DBS 
(Singapore) , SHB(Saudi 
Arabia), AIMCO (CANADA), 
Reliance, Genpact (INDIA), 
HP (INDIA) etc.	 	
Client  Interaction	 	
Requirement Gathering	 	
Lead and Architect	 	
Review 	 	
Estimation/scheduling	 	
Technologies	 	Spotfire, MS SQL, SSIS,	 Custom 	D3 charts