Summary
Overview
Work History
Education
Technicalskillset
Timeline
Generic

Nilesh Naik

Tracy

Summary

A passionate, result oriented professional with over 20+ years of experience (including 11 years experience at Apple) in Business Intelligence, Data Analysis, Data Warehousing, Data Integration, Data Engineering, and Visualization. Highly proficient in analyzing and translating business requirements into technical specifications to support diverse business functions with their data needs. Helped organizations achieve tremendous business value through Data and Analytics solutioning. Excellent communication and interpersonal skills.

Overview

23
23
years of professional experience

Work History

Senior Business System Analyst

IBM
12.2022 - Current
  • Under CERP (Reporting and Analytics) analytics program at Google, partnered with Corporate Finance, YouTube, Fitbit, Google Cloud, Devices and Services teams to provide analytical, reporting and data visualization solutions
  • For Data Security Framework (DSF), collaborated with partners to secure enterprise data as per Google’s data policy and steered it to completion
  • Collaborated with Google’s Finance Team for requirements gathering and analysis of use cases and data integration
  • Designed and developed BI Solutions using ETL pipelines, Big Query, PLX, Tableau, Data Studio, Looker
  • Empowered internal customers with data analysis and visualization
  • Determined feasibility to adopt DSF for data security
  • Provided Tableau Desktop and Data Studio training to partners and mentored other engineers and BSAs
  • Streamlined reporting and data governance process
  • Partnered with different teams to design and develop data cuts to secure enterprise data with the DSF
  • Ensure Business Data accuracy, fidelity, and completeness
  • Biq-Query data optimization and performance tuning
  • Developing visual reports, KPI scorecards, and user-friendly dashboards using Looker.

Senior Business System Analyst

HCL Inc, America
06.2020 - 11.2022
  • Under CERP (Reporting and Analytics) analytics program at Google, partnered with Corporate Finance, YouTube, Fitbit, Google Cloud, Devices and Services teams to provide analytical, reporting and data visualization solutions
  • For Data Security Framework (DSF), collaborated with partners to secure enterprise data as per Google’s data policy and steered it to completion
  • Collaborated with Google’s Finance Team for requirements gathering and analysis of use cases and data integration
  • Designed and developed BI Solutions using ETL pipelines, Big Query, PLX, Tableau, Data Studio, Looker
  • Empowered internal customers with data analysis and visualization
  • Determined feasibility to adopt DSF for data security
  • Provided Tableau Desktop and Data Studio training to partners and mentored other engineers and BSAs
  • Streamlined reporting and data governance process
  • Partnered with different teams to design and develop data cuts to secure enterprise data with the DSF
  • Ensure Business Data accuracy, fidelity, and completeness
  • BIG-Query data optimization and performance tuning
  • Developing visual reports, KPI scorecards, and user-friendly dashboards using Looker.

Finance Business System Analyst 4

Apple Inc
04.2016 - 02.2020
  • Partnered with finance teams to design and develop E2E BI solutions using KNIME, Alteryx, Power BI, Teradata, Business Objects, Tableau and Python to streamline data Induction and reporting
  • Worked with stakeholders in defining the source of truth for data and making sure the data fidelity is high
  • Streamlined rebate calculation process to avoid over payment of $0.3M-$0.7M for APAC region
  • Built invoice and discount tracker which helped to yield discount of $3M-$5M per quarter globally
  • Worked with Data Science team to build models and cater to their data requirements
  • Implemented Essbase reporting solutions for CEO and CFO staff
  • Recipient of Best Global Performer Awards for three consecutive years in the finance team
  • Collaborate with Regional team for data solutions
  • Data integration from different systems like SAP, SAP HANA to data warehouses
  • Propose and implement E2E data solutions
  • Led business users training and Reporting office hours
  • Partnered with data scientist to understand data requirements and solutioning
  • Provided data insights to business stakeholders.

Principal Consultant

Wipro Limited
09.2003 - 04.2016
  • Worked as Business Intelligence Engineer for Apple’s Finance Business Intelligence team
  • Worked as a liaison between Apple’s IT team and Finance team for data induction and integration.
  • Evaluated business processes, identifying inefficiencies and recommending targeted improvements.
  • Built strong relationships with clients, fostering long-term partnerships and repeat business.
  • Increased client satisfaction by providing tailored consulting solutions for their specific business needs.
  • Conducted workshops and training sessions to improve employee knowledge of best practices.

Web Developer

School Net India Ltd
03.2001 - 09.2003
  • Worked with the business team for project requirement gathering
  • Prepared technical design document and worked on its module development.

Education

Technicalskillset

Teradata, MySQL, MS SQL Server, DB2, Oracle, Big Query, Google PLX, Amazon Redshift, Erwin, Tableau Desktop (multiple versions), Tableau Server administration, Business Objects (5.x, 6.5, XIR2, 3.1, 4.1, 4.2 and 4.3), Data Studio, Power BI, PLX dashboards, Amazon Quick Sight, Essbase, Looker, Informatica, KNIME, Alteryx, PL/SQL, Python, Google PLX workflows, Tableau Prep, Custom data security for Tableau, Business Objects, Google Data Security Framework, Python, PHP, SQL, SAP: FICO and MM Modules, HANA, BPC, Git, Control M, Jenkins, Cron, Clarinet, Jira, Google g3doc, Google Taskflow, Connect Me, GCP, AWS, Data science (linear and logistic regression)

Timeline

Senior Business System Analyst

IBM
12.2022 - Current

Senior Business System Analyst

HCL Inc, America
06.2020 - 11.2022

Finance Business System Analyst 4

Apple Inc
04.2016 - 02.2020

Principal Consultant

Wipro Limited
09.2003 - 04.2016

Web Developer

School Net India Ltd
03.2001 - 09.2003

Nilesh Naik