Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Fabian Julian

Milton,Ontario

Summary

12+ years of experience in Pharma, IT Services and Infrastructure Industry as Business & Data Analytics Lead, Resource Management, Data Modeller, Process Analyst & Power BI Developer, technical Consultant and Data Management.

Overview

22
22
years of professional experience
1
1
Certification

Work History

Data Analytics Lead

Abbott Diagnostics
11.2020 - Current
  • Led the development of reporting solution suite for Global Transfusion marketing Team using PowerBI.
  • Elevated collective intelligence of organization by connecting the dots across market condition, current & potential competitors, industry trends, customer behaviours and sales of products and services.
  • Designed and led primary data collection using tools like questionnaires and surveys using Qualtrics, synthesized results to automated PowerBI dashboards using API end points.
  • Responsible for annual market model update requiring interpreting sales and financial data, analysis and synthesis of results using BI tools and provided customized periodic reports.
  • Owned annual update and publication of business Factbook for Transfusion medicine division.
  • Identified and implemented process improvement opportunities by automating reports using VBA and resulting in 99% reduction in turnaround time.
  • Awarded under the “Creating Impact on Budget” category for optimizing resources to capture Data/Insights for a creative breakthrough campaign.

Sales Specialist

Home Depot
03.2019 - 11.2020
  • Demonstrated expertise in assisting customers utilizing strong product knowledge to provide personalized recommendations and solutions tailored to customer needs and preferences.
  • Consistently met and exceeded sales targets by employing sales techniques such as upselling, cross-selling and product demonstrations.
  • Part time

Marketing & Research Analyst

Abbott Diagnostics
10.2018 - 03.2019
  • Supported Global Core Marketing Team with data analysis, developed BI solutions and provided strategic reports.
  • Create and Standardize Dashboards using Power BI (Business Intelligence Tools). Acquiring data from primary (Salesforce) or secondary data sources, maintaining databases & reports (daily/weekly/monthly).
  • Locate and define new process improvement opportunities. Ad hoc queries, report writing and presenting finding to various internal, external stakeholders and business partners.

Sales Specialist

Home Depot
03.2018 - 09.2018
  • Part time

Data Analyst

DXC [Hewlett Packard Enterprises]
04.2017 - 12.2017
  • Optimized cost savings up to 15% in 7 months by Designing, implementing efficient & accurate reporting systems, dashboards, templates utilizing VBA modules and Excel-based solutions across teams (especially for Sales and Banking Modules) replacing manual processing.
  • Designed and implemented QlikView dashboards & Power BI to consolidate various business function information (risk, time, productivity, cost) from Salesforce and Datawarehouse to enable data-based decision making.
  • Managed Client projects end to end from requirement collection to creation of Power BI reports and Dashboards.
  • Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies using SSAS.
  • Performed analytics on data to identify root causes, patterns, trends and represented Key indicators as Dashboards and reports for project management office and senior management.

BI - Data Project Lead

Wipro Technologies
01.2016 - 01.2017
  • Project Lead for Report / Analytics Automation Project (MIS) for Pharmaceutical industry. Responsible for the Report/analytics automation project for Wipro Technologies (for Takeda – Pharmaceutical Account) in-scope of ITIL process.
  • Designed and implemented relational database management systems (RDMS) using SQL Server, ensuring data integrity, security, and performance optimization.

Consultant

Sutherland Global Services
09.2015 - 12.2015
  • Senior technical consultant for Microsoft Consumers from United States and Canada.
  • Trained in Microsoft Operating systems (installation, troubleshooting, Knowledge Base), Microsoft Office suites, 365, Store, Email voice & support.
  • Recognized for excellence in Troubleshooting complex scenarios and quality customer service support.

Marketing Analyst

Precision Services Ltd.
08.2010 - 06.2015
  • Responsible for Marketing Research, Installation and Promotion of the brand.
  • Utilized Google Analytics to track, promote and interact through company website.
  • Designed and implemented efficient inventory and daily, monthly and quarterly reporting systems, dashboards in Tableau, templates utilizing Ready Inventory tools and Excel based solutions.
  • Developed different type of reports including Sales Report, Accounting Statement Report, Employee census report, Benefits statements report, Billing report using SSRS & SQL Server 2008.
  • Ensured accurate documentation of all projects, bills & vouchers.

Senior Consultant

Siemens Information Systems
08.2006 - 06.2010
  • Managed Utility management services (Electricity and Water) from managing data inflow, outflow requests, customer support and field management in SAP for Siemens Energy Services to British Consumers.
  • Identified key areas of process improvement and ensured automating using simple Microsoft automation tools.
  • Designed, Developed and automated tools for multiple process flows thereby FTE’s savings for the organization.
  • Developed Web tools (using Java, J2EE, Servlets, HTML & SQL) for employee productivity and internal Employee engagement activities. As subject matter expert trained and certified trainee for the process.

XML Analyst

Scientific Publishing Services (P) Limited
01.2004 - 01.2006
  • Involved in analysing and fine-tuning XML to E-Journals using XLS Stylesheets.
  • Wrote and automated tools and scripts to increase departmental efficiency and automate repeatable tasks.

Education

Master’s Degree - Information Technology

University of Madras
Chennai
01.2009

Skills

  • Power BI Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service, Power BI Mobile App), MS BI (SSAS, SSIS, SSRS 2008), ETL Packages, Office suite (Word, Excel, PowerPoint, Visio, Outlook), Office 365, Salesforce CRM, MS SQL Server 2008R2, 2012, 2014, VBA, MDX, DAX, SQL, Python (Intermediate), Jira, Photoshop, InDesign, Adobe Acrobat Professional, Py spark, Scala, Hadoop, Databricks, ADF, Snowflake

Certification

  • ITIL (Information Technology Infrastructure Library) V3 Foundation, Certified on 10 April 2016; Licence no. 5657587.20523162
  • Big Data Hadoop and Spark Developer, Certified August 2019, Credentials ID: 1342737

Languages

English
Professional Working

Timeline

Data Analytics Lead

Abbott Diagnostics
11.2020 - Current

Sales Specialist

Home Depot
03.2019 - 11.2020

Marketing & Research Analyst

Abbott Diagnostics
10.2018 - 03.2019

Sales Specialist

Home Depot
03.2018 - 09.2018

Data Analyst

DXC [Hewlett Packard Enterprises]
04.2017 - 12.2017

BI - Data Project Lead

Wipro Technologies
01.2016 - 01.2017

Consultant

Sutherland Global Services
09.2015 - 12.2015

Marketing Analyst

Precision Services Ltd.
08.2010 - 06.2015

Senior Consultant

Siemens Information Systems
08.2006 - 06.2010

XML Analyst

Scientific Publishing Services (P) Limited
01.2004 - 01.2006

Master’s Degree - Information Technology

University of Madras
Fabian Julian