Name: 	- Noel Samuel	 	
Contact No: 	- +91 9922137457	 	
Email ID: 	- noel.samuel30@gmail.com	 	
 	
Permanent Address: 	- 64, New Gandhi Layout, Behind Jaffar Nagar, Nagpur	-440013.	 	
 	
 	CAREER OBJECTIVE:	 To secure a challenging position in a reputable organization 	
to expand my learnings, knowledge, 	and skills. Secure a 	
responsible	 career	 opportunity to fully utilize my training and skills, while making a 	
significant contribution to the success of the compa	ny.	 	
 
 	
WORK EXPERIENCE AND RESPONSIBILITIES:	 	
 
 	
    	Company Name: 	- Larsen and Toubro Infotech	 	
    	Designation:	 - Senior Data Engineer	 	
Duration:	 - Nov 02, 2021 to	 Present.	 	
 
	 Cognos	-PBI Migration	| Power BI	 Consultant.	 	
Domain:	 Manufacturing	 	
Client	: Scania	 	
Project 	Description	: Objective  was  to 	do  a  lift	-shift  of  all  Cognos  report  to  Power  BI.  Data 	
Source used was Tabular model and connection method used was Live connection.	 	
Tools: 	Microsoft Power BI, SQL Server, 	Oracle SQL Developer, SSAS Tabular	 	
Responsibilities:	 	
 	
 Created Tabular model in SSAS.	 	
 Analyzed Cognos&rsquo; Reports.	 	
 Understood model of Cognos Reports using Framework Manager.	 	
 Established connection with Data Source in Analysis Services.	 	
 Created calculated column and measures in SSAS.	 	
 Installed 	different drivers of 32	- bit and 64	-bit for Oracle Connection.	 	
 Installed various version of Visual studio with correct version.	 	
 Solved issues related to connection in Visual Studio.	 	
 Created report wireframe for Power BI Reports.	 	
 Helped in creating Power BI	 Report theme.	 	
 Developed more than 20	 reports in Power BI which was migrated from Cognos.	 	
 Created job in Database server to refresh the Analysis server model.	 	
 Connected to Analysis server to PBI for creation of reports.

Company Name:	 - Nice Software Solutions. 	
Designation:	 - Power BI	 Consultant.	 	
Duration:	 - June 03, 2019 to	 Sep 06, 2021.	 	
 
	 CWG Dashboard	| Power BI	 Consultant.	 	
Domain:	 OTC 	Process/Brewery	 	
Project 	Description	: Objective  was  to  bring  all  the  repo	rting  of  zones  under  one  common 	
dashboard and bringing in new visibility for the stakeholders.	 	
Tools: 	Microsoft Power BI, SQL Server, SharePoint, Excels	 	
Responsibilities:	 	
 	
 Hands	-on exp	erience in creating Power BI	 reports.	 	
 Understanding business requirements for different zones and implementing the same in the 
reports.	 	
 With the help of bookmark and selection panel created toggle	 switch.	 	
 Experience in using Power Query editor, used functi	ons like split, group by, data	 type 	
change.	 	
 Experience in using advance	 editor.	 	
 Knowledge of using RLS and giving access to specific	 users.	 	
 Connected to data sources such as excel, sql server, azure sql database, sharepoint,	 power 	
bi dataset,	 dataflow.	 	
 With the help of python connected to data source in Power	 BI.	 	
 Used R script visual to plot graphs in Power	 BI.	 	
 Handled Azure for uploading data in blob storage, used data factory for importing data and 
create database based on excel file.	 	
 Strong planner an	d organizer with demonstrated ability to lead small to large size teams; 	
resource and effort estimation for projects.	 	
 Implemented Panel Selectors in the project with the help of Bookmark.	 	
 Created DAX to generate computed columns and measures using function	s like FORMAT, 	
RELATED, CALCULATE, SELECTEDVALUE.	 	
 Created landing page with the help of page navigation and	 buttons.	 	
 Created usage report to check how many users are accessing the report with data flow	 as the 	
data	 source.	 	
 Toggle button created to see Month	ly and Weekly view with bookmark &amp; selection	 panel.	 	
 Successfully worked on Azure SQL DW, integrating the same with Power BI.	 	
 Created complex reports using data source as Azure SQL Database server.	 	
 Knowledge on creating Azure DB servers and configuration 	settings.	 	
 Strong planner and organizer with demonstrated ability to lead small to large size teams; 
resource and effort estimation for projects.	 	
 Creation of SOP&rsquo;s, use cases, and Software Requirement Specification (SRS) document.	 	
 Extracting data from datab	ase with the help of SQL.	 	
 Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations.	 	
 Worked on Custom Visualizations like multi slicer and Hierarchy slicer.	 	
 Successfully connected Azure SQL Database to Power BI.

	 Usage Metrics Report	| Power BI	 Consultant.	 	
Domain:	 OTC	 	
Project 	Description	: Report  to  understand  adoption  of  the  reports.  Report  created  to  understand  how 	
many users are using the report. Analysis to check which users are super users. 	 	
      	Too	ls: 	Microsoft Power BI, DataFlow	 	
Responsibilities:	 	
 	Calculated week on week views and viewers of the report	.  	
 	Imported data from 	Data Flow	. 	
 	Week on week percentage change.	 	
 	Created waterfall chart to show initial number of users and total number of users	. 	
 	Us	ed Top N filter selection on visual to display 	top users of the report.	. 	
 	
 	
 	
	 Nice Imports	| Power BI	 Consultant.	 	
Domain:	 Shipment Industry	 	
Project 	Description	: Business related to shipment of paper and pulp. Industry focusing on recycle and 	
reuse any grade of paper. Project that gives deep insight into the importing business performance w.r.t. 
country wise order count, order count by port, country wise revenue ge	nerated. 	 	
      	Tools: 	Microsoft Power BI, Azure	 	
 
 	
Responsibilities:	 	
 	Created and configured Azure SQL server, DW and tables. 	 	
 	Imported data from MS Excel, MS Access and CSV to Azure SQL DW.	 	
 	Integrated Azure with power BI and generated reports as per the re	quirement.	 	
 	Created Different Visualization with dynamic targeting.	 	
 	Implemented Panel Selectors in the project with the help of Bookmark.	 	
 	Created DAX to generate computed columns and measures using functions like FORMAT, 
RELATED, CALCULATE, SELECTEDVALUE.	 	
 	Created DAX expressions to calculate no of Split invoices, percentage of split invoices.	 	
 	Generated computed tables in Power BI using DAX.	 	
 	Created multiple dashboards such as Summary, Shipment Details and Customer Details 
with each navigation with the help 	of Bookmarks.	 	
 	Imported custom visualization from Power BI marketplace and used it in the report.

	 Pharmacy	| Power BI	 Consultant	 	
Domain: 	Pharma	 	
Project  Description	:  The  Power  BI	-based  solution  will  show  data  based  on  Sales,  Field  Activity  and 	
Market	 for field	-based users which can be access from mobile device	.  	
Tools: 	Power BI (Mobile + Web) and Azure	 	
Responsibilities:	 	
 	Involved in understanding the business requirement	 	
 	Used Azure SQL DWH and Blob storage to store data. 	 	
 	Created dashboards from 	reports as well as from the insights	. 	
 	Created customize tooltip.	 	
 	Bookmark the pages and link it to button or image etc. from action property.	 	
 	Used chicklet slicer for metric selector.	 	
 	Implemented all types of filters visual, page level and report level.	 	
 	Im	plemented prompts using parameter.	 	
 	Worked on row level security for customized access.	 	
 	
	 Banking	| Power BI	 Consultant	 	
Domain: 	Banking	 	
Project  Description	:  Client	 is 	the	 leading  credit  card  provider  that  gets  thousands  of  credit  card 	
applicants every year. B	ut in the past few years, it has experienced an increase in credit loss.	 With the 	
help of predictive analysis using Python in Power BI the client wants to mitigate risk by acquiring the 
right customers. Used Python script editor to import .csv file into Po	wer BI. 	 	
Tools: 	Microsoft Power BI And Azure	 	
 	
 
Responsibilities:	 	
 	Worked on predictive analysis and linear regression to understand credit score of 
customers.	 	
 	Installed various libraries such as Anaconda, Matplotlib and import os.	 	
 	Created Azure 	Datafactory to integrate cloud	-based platform for data	 from and to on	-	
premise, on	-cloud, and hybrid sources and destinations. 	 	
 	Imported .csv file with the help of script editor into Power BI.	 	
 	Used grid and graph combination to display customer against thei	r details.	 	
 	Used various graphs to precisely display which 	the right customers are	 having good credit 	
score.	 	
 	Plotted graphs by using Python language against various metrics.	 	
 	Used checklist slicer for metric selector.	 	
 	Implemented all types of filters visual,	 page level and report level.	 	
 	Published the report on Power BI service and gave access to various users.

Company Name: 	- Excellon Software. 	
Designation: 	- BI 	Consultant. 	 	
Duration: 	- Aug 03, 2015 to July 25, 2017.	 	
 	
Place: 	- Nagpur	 	
 	
 	Creation of Power BI 	reports.	 	
 	Monthly update of the reports.	 	
 	Maintaining the reports and dashboards at service level.	 	
 	Sharing the reports with the end users.	 	
 	Giving access of the reports to different users.	 	
 	Creation of SOP&rsquo;s.	 	
 	Giving training to new joiners.	 	
 	Used visuals like m	ap, water gauge, table, matrix, bar chart.	 	
 	Sending monthly and billing reports to client.	 	
 	Creation of user guides for solving particular issues and sharing it with team.	 	
 	
 	
Working Exposure: 	- 	
 	
 	Good amount of exposure in Power BI, Azure Dev	 Ops.	 	
 	Experience 	of working in agile	 methodology.	 	
 	Exposure in handling ad hoc	 requests.	 	
 	Handled a team of more than 3 people to deliver power bi	 projects.	 	
 	Played a role in automating the process of DB refresh and Power BI schedule	 refresh.	 	
 	Created management view for 	mobile for super uses of the	 report.	 	
 
 
 
 
 
 
 
 
 
 
Power BI, SSAS, Tabular, Live Connection, #power bi, #sql, #analysis #oracle oracle

EDUCATIONAL QUALIFICATIONS: 	- 	
 
 	
Course	 	Year of Passing	 	Name of the 
Institute	 	University/ Board	 	
MBA (Operations+ 	
Marketing)	 	2018	-20	19	 	RCOEM	 	RTMNU	 	
B.E (Computer Science 	
&amp; Engineering)	 	2010	-2014	 	G.N.I.E.T	 	RTMNU	 	
 
 	
COMPUTER LITERACY:	 	
 	
 	Microsoft Power BI test by	 LinkedIn.	 	
 	Certification of Power BI by Leanardo	 Karpinski.	 	
 	SQL. (Certification from	 Unisoft)	 	
 	MS	-Excel.	 	
 	Google Digital Unlock Certification.	 	
 	Google Analytics Beginner Certification.	 	
 	Google Analytics 	Advanced Certification.	 	
 	HTML.	 	
 	
PERSONAL DETAILS:	 	
Father&rsquo;s Name: Lucas 
Mother&rsquo;s Name: Mercy 
Date of Birth: 30/09/1992 
Gender: Male.	 	
Nationality: Indian.	 	
Languages Known: English, Hindi, Marathi, Telugu.	 	
Permanent Address: 64, New Gandhi Layout, Behind Jaffa	r Nagar, Nagpur	-440013.	 	
 	
DECLARATION:	 	 	
I, the undersigned hereby declare that the above information is true to the best of my knowledge.	 	
 	
Place:	 	Date:	 	
Business intelligence, azure, sql, data analytics, computer science, data modelling, data wareshousing