Hey there, I’m Farzad Nazemi. I’m a bit of a Nerd and love working with Data.
A highly experienced business and data analyst working with SQL, MS Power Platform and Various Business intelligence Platforms and ETL tools, I am tenacious and focused on delivering solutions for the business through better use of data, acting as a conduit between the business end users, Management, IT and the developers, to enable business transformation, efficiencies and better MIS, resulting in improved business activity and increased revenue and/or cost saving.
I have experience as an Analyst, a Project manager, a Developer and as a Manager which has given me insight into creating and scoping projects, working with end customers in developing solutions and working with other developers to ensure the translation of User Requirements to a meaningful functional requirement spec for the development teams.
In every aspect of my work, communication has always been key, asking the right questions and listening to feedback.
Experience
Company, Johnson Matthey
JM is a people-centric, global leader in sustainable technologies, applying cutting-edge science to build a sustainable future with more than 200 years of history in a diverse range of sectors.
Position, SME
April 2021 - November 2021 | January 2022 - Now
Working Primarily on projects to modernise and replace the business systems and change the current ways of working on a global scale.
Key achievements
Scoping of and developing various PowerApps for a multitude of teams.
First to implement Knime workflows within the business to automate and centralise the business ETL needs.
Legacy system support, including DB2 databases, enabling reporting and making the data available for applications to remove any duplication of work.
Product Enquiry App rewrites for the sales and production teams.
Company, Johnson Matthey
Position, Continuous Improvement Engineer
November 2021 - January 2022
I briefly had the privilege to implement some improvement projects for the CI team
Key achievements
The creation of key reporting views to make useful the raw data from a newly implement an inventory tracking system to allow BI tools to make use of the available data.
App rewrite of a Daily Management application to centralize questions and check lists such as 5S checks, EHS checks, handovers and many more.
Company, Johnson Matthey
Position, PGMR Production Controller
March 2019 - April 2021
Working on the plant to set daily, weekly, monthly and 3 month targets and priorities while also modernising business processes and tools used within the department for material tracking
Key achievements
Implementation of critical forecasts used by other internal customers to allow for effective and informed decision-making.
Setting the scope for JM’s new 3rd Century Refining plants inventory systems.
Implementation and evolutions of Tableau KPIs and Dashboards to streamline ways of working.
Automation of the StockTake reconciliation process to reduce possible areas of human error.
Company, Movianto - (an Owens & minor Company)
Movianto is a company which provide a specialised supply chain solution for the pharma market. Movianto is a part of the Owens & Minor group which is a Fortune 500 company based in Mechanicsville with a mission to connect the world’s leading pharmaceutical companies to point of care in the ambition to increase the quality of patient care.
Position, European Data Transformation Team Leader
July 2017 - November 2018
In charge of a team of 4 (business analysts and data transformation testing specialist), with responsibility for large-scale data migration projects, involving data cleansing, data transformation, and implementation, collaborating with other departments across Europe, as well as external consultants.
Key contact for all related data migration projects with responsibility for the management of risk and sign-off of data prior to uploading into the new system.
Create validation reports to enable improved business processes, together with ongoing support and process improvement activities.
Project management, being a key contact for various projects and providing sign-off and management of risk within projects.
Key achievements
Automation of business processes, enabling mass loading of Master Data using simple forms.
Data cleansing and transformation and migration of master data for new business across EU, verification of data across all EU systems to ensure accurate pricing for customers and correct data loaded, involving 4k Item records, 1k Customer records, and 6k customer pricelist records.
Creation of SQL reports for verification of data. Creation of excel templates to enable easy reconciliation by business personnel.
Reports to enable the mass validation of important tasks and day-to-day operation to increase the quality of master data. (Verification of Item master data to be loaded with correct attributes, Customer data to insure no duplication and related pricing information to ensure customers are charged correctly).
Reporting created to allow reconciliation of Financial system against warehouse system to verify interface is functioning appropriately and accurately reflecting what is shipped against what is billed.
Automation of reports to enable warehouse teams to make more informed decisions.
Company, Movianto UK LTD - (an owens & minor company)
Position, Solutions Business Analyst
August 2015 - July 2017
Identifying and optimising opportunities or issues related to the strategic goals, providing definition, analysis, subject matter expertise, critical thinking, creative problem solving, business-case development, performance measurement and testing for any activity related to a specific strategic goal.
Key achievements
Complete data cleanse of 100k+ customers to remove redundant sites and merge duplicate sites.
Simplified annual customer master data reconciliation process (from a completely manual process) and created SQL queries and excel forms to automated data reconciliation process, cross-referencing registration numbers against external databases and gaining percentage match of address information.
Reconciliation of order data between client systems and internal systems.
Creation of Customer data import for a large client using Data Loaders.
Creation of Macros/Documents to improve day-to-day processes.
Company, Euro electronics (UK) LTD
Euro Electronics is one of the leading digital signage providers having worked with the Dixons Retail group, IKEA, John Lewis, HSBC and more, providing bespoke solutions to meet client requirements.
Position, Technical Manager
June 2014 - December 2014
Undertaking multiple responsibilities, including research and development, technical support, refurbishment of hardware, and customer-facing. Provided onsite support as well as hardware and software testing.
Key achievements
Product research for an emerging market, finding SOCs to update media players for 4K playback.
Onsite support with clients in stores and demoing of products.
Software support.
Skills
Data Analysis
SQL
Team Management
Project Management
PowerPlatform
Knime
Tableau
Advanced MS Excel Knowledge
Advanced MS Access Knowledge
Studied Lean Management & Six Sigma
Interests
Technology
I love to tinker, both with hardware and software
PC Hardware
Its an expensive hobby, specially when building SFX form factor
Science
I’m fascinated by the world and how it works, I studied science and engineering to feed that curiousity
3D Printing
Going from concept to CAD to a real physical object is just cool
Movies
I love good story telling and world building, Alien still holds up
Comics
Spider-Man, Spider-Gwen, The Mighty Thor, My Hero Academia
Music
Billie Eilish, Ed Sheeran, Adele
Sports
I love cycling and climbing
Games
I love the interactive media but I find myself with less and less time to sit down and play
Keyboards
Mechanical keyboards get expensive but considering I need to use a keyboard for my work and at home, it makes sense to invest in something good, I love using Blue keys though they are way to annoying to be used in the office so Reds and Browns are good alternatives