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
Chennai01.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
Similar Profiles
Colby NadeauColby Nadeau
Materials Management, Manager at Abbott DiagnosticsMaterials Management, Manager at Abbott Diagnostics
PETER PETCHERPETER PETCHER
Procurement Specialist at Abbott DiagnosticsProcurement Specialist at Abbott Diagnostics
MOHAN KRISHNA NALABOTHUMOHAN KRISHNA NALABOTHU
Product Transfer specialist at Abbott DiagnosticsProduct Transfer specialist at Abbott Diagnostics
Anand PatelAnand Patel
Senior Technical Support Engineer Level 2 – NSG at SOPHOS INCSenior Technical Support Engineer Level 2 – NSG at SOPHOS INC
Yara AhmedYara Ahmed
Kitchen Staff Member at La ToscanaKitchen Staff Member at La Toscana