Summary
Overview
Work History
Education
Skills
Certification
Courses attended
Timeline
Generic
Roshan Ali Syed

Roshan Ali Syed

Bangalore

Summary

Accomplished Lead Data Engineer with expertise in Snowflake and Azure Data Factory, previously at NetApp. Proven track record in optimizing data pipelines and enhancing SQL performance, driving significant improvements in data reporting and analytics. Strong analytical skills combined with effective collaboration ensure successful project delivery and client satisfaction.

Overview

20
20
years of professional experience
1
1
Certification

Work History

Lead Data Engineer

NetApp
08.2023 - 04.2026
  • Summary (Project):
  • NetApp, Inc. is a leading intelligent data infrastructure company specializing in hybrid cloud data storage, management, and security.
  • Finance teams at NetApp are heavily focused on maximizing revenue recognition, ensuring margin targets are met, and limiting economic risk by providing financial forecasting and modeling to support sales and product teams to optimize profitability.
  • Designed and implemented data pipelines for real-time analytics solutions.
  • Scope of the project is to migrate existing on-prem DBs to Snowflake data warehouse (data as service) as main deliverables and to generate the reports using tableau/MS PowerBI w.r.t. Finance and Sales module.
  • Enhanced SQL objects to meet business requests in Snowflake, improving data access and analysis capabilities.
  • Requirements gathering and designing technical documents based on the functional requirements.
  • Coordinated unit testing and data validation, ensuring accuracy of conventional DB source data against DWH data.
  • Performance Tuning – Involved in optimizing the SQLs.
  • Optimized databases for improved performance and scalability, supporting data-driven decision-making.
  • Identified primary client for project. NetApp Inc.

Lead Consultant

KPI Partners India Private Limited
03.2017 - 07.2023

Lead Data Engineer

KPI Partners India Private Limited
03.2022 - 05.2023
  • Summary (Project):
  • Intuitive Surgical Inc. is an American corporation that manufactures robotic surgical systems, most notably the da Vinci Surgical System. Scope of project is to migrate existing Hana Database to Snowflake data warehouse (data as service) as main deliverables and to generate the reports using tableau w.r.to Finance and Sales module.
  • Responsibilities:
  • Developed many SQL objects to migrate it from Hana to Snowflake
  • Requirements gathering, and designing technical documents based on the functional requirements.
  • Co-coordinating with team for Unit Testing & Data validation comparing SAP source system data with DWH data.
  • Performance Tuning – Involved in optimizing the SQLs.
  • Environment: Snowflake, SQLServer &Tableau
  • Period: Mar 2022 – May 2023
  • Client: Intuitive Surgical Inc.

SQL Developer

KPI Partners India Private Limited
09.2021 - 02.2022
  • Summary: As per the requirement, to create, enhance and ingest the data into respective modules.
  • Responsibilities:
  • 1. To Create / modify the new/existing Synopsis queries to develop the PowerBi dashboards.
  • 2. Test code BEFORE and AFTER changes
  • 3. Created new mappings as per client’s requirement to separate a mapping into multiple mappings based on In-scope and out-of-scope sources.
  • 4. Testing the SQL code and deploying the code into respective environments
  • Period: Sep 2021– Feb 2022
  • Client: Syneos Health Care

Snowflake Developer

KPI Partners India Private Limited
01.2021 - 08.2021
  • Summary: This is an automated migration project of Intrado WDMS reporting and DM Digital Media schema from Oracle Database to Snowflake Database through IICS Informatica cloud and totally decommissioning the respective Oracle Data warehouse for the mentioned Schemas and replacing with Tableau as reporting tool via Snowflake tables so that it handles large date with ease.
  • Post implementation of this project on Snowflake, the data is loaded into Snowflake tables by triggering the Informatica IICS mapping tasks and reports are fetched through Tableau.
  • Responsibilities:
  • To Migrate the databases using DB transfer utility built by KPI Partners.
  • 1. To review and update the IICS mappings that are in scope by switching Oracle connection with Snowflake connection.
  • 2. To update Informatica ETL Source queries (Oracle) to make them compatible with Snowflake.
  • 3. To develop the User Defined Functions (UDF’s) and the Snowflake compatible procedures-oriented SQLs (PL/SQLs) as part of the migration of the Oracle UDF’s and the procedures
  • 4. Test code BEFORE and AFTER changes
  • 5. Identify and implement workarounds for the Oracle features that Snowflake does not support and test them.
  • 6. Created new mappings as per client’s requirement to separate a mapping into multiple mappings based on In-scope and out-of-scope sources.
  • 7. Testing the SQL code and deploying the code into respective environments
  • Period: Jan 2021– Aug 2021
  • Client: Intrado Corporation

Lead Consultant

KPI Partners India Private Limited
04.2020 - 12.2020
  • Summary: This is a migration project of HCM Oracle Enterprise Business Solutions to Snowflake cloud and totally decommissioning the OBIEE and replacing with Power BI tools so that it handles large date with ease.
  • Post implementation of this project on Snowflake Cloud, the data is loaded into Snowflake Cloud tables and reports are fetched through Power BI.
  • Responsibilities:
  • 1. To update Informatica ETL Source queries (Oracle) to make them compatible with Snowflake.
  • 2. To develop the User Defined Functions (UDF’s) and the Snowflake compatible procedures-oriented SQLs (PL/SQLs) as part of the migration of the Oracle UDF’s and the procedures
  • 3. Test code BEFORE and AFTER changes
  • 4. Identify and implement workarounds for the Oracle features that Snowflake does not support and test them.
  • 5. Created new mappings as per client’s requirement to separate a mapping into multiple mappings based on In-scope and out-of-scope sources.
  • 6. Testing the SQL code and deploying the code into respective environments
  • Period: April 2020– Dec 2020
  • Client: OnSemi Conductors

SQL developer

KPI Partners India Private Limited
03.2018 - 03.2020
  • Summary: This is a migration project of Oracle Enterprise Business Solutions to Amazon Redshift and totally decommissioning the OBIEE and replacing with Tableau so that it handles large date with ease.
  • Post implementation of this project on Amazon Redshift, the data is loaded into Amazon Redshift tables and reports are fetched through Tableau.
  • Responsibilities:
  • 1. Using Oracle to import source data using SAS code.
  • 2. Analysis of SAS changes or enhancements or variances in existing applications as per business requirement
  • 3. Analysis, design, development and implementation of Change Requests from Business
  • 4. Analyze alerts and report to business partners in case of any discrepancies.
  • 5. Monitor and create daily, weekly and monthly application in SAS.
  • 6. Testing the code and solving the defects
  • 7. Getting UAT Signoffs from the customer
  • 8. Handling Deployment process
  • 9. Following SDLC Agile Methodology
  • Period: March 2018– March 2020
  • Client: Motorola and Hitachi

Lead Consultant

KPI Partners India Private Limited
03.2017 - 01.2018
  • Summary: RevStat System resides on TSO Mainframe with data stored in virtual tape flat files, in PL/1 format and Data is stored historically, as a static snapshot of what was billed/recorded in revenue month and year (goes back to December 2002).The system is run by users using batch job processing , by executing options via customized ISPF menu screens (to process the data and to produce reports or output files).Post implementation of this project on Oracle , the data is loaded into ETL tables and reports are fetched through OBIEE .
  • Responsibilities:
  • 1. Involved in decoding the Mainframe code.
  • 2. Using Oracle to import source data using SAS code.
  • 3. Analysis of SAS changes or enhancements or variances in existing applications as per business requirement
  • 4. Analysis, design, development and implementation of Change Requests from Business
  • 5. Analyze alerts and report to business partners in case of any discrepancies.
  • 6. Monitor and create daily weekly and monthly application in SAS.
  • 7. Testing the code and solving the defects
  • 8. Getting UAT Signoffs from the customer
  • 9. Handling Deployment process
  • 10. Following SDLC Agile Methodology
  • Period: Mar 2017– Jan2018
  • Client: PG&E

Technical/Module/Test Lead

Wipro Technology Ltd.
07.2010 - 02.2017

Module Lead

Wipro Technologies
04.2016 - 11.2016
  • Summary: IRI has their legacy applications developed using PL/1, SAS and GUTS running on Mainframe and consuming about 1460 MIPS. IRI would like to migrate the legacy applications off mainframe to a Linux platform. The Business drivers for this Mainframe migration are High Maintenance cost to run the applications on mainframe. Non availability of GUTS technology resources Re-Platform was chosen as the preferred approach, as end state of moving away from mainframe could be achieved, in addition to containing the risk of migration by executing it phase wise.
  • In Phase 1, PL/1, SAS programs migrated to Micro Focus emulated environment.
  • At end of phase 1, MIPS usage would be reduced to 700 – 900 MIPS usage and at the end of phase-2, there will be no MIPS usage (i.e.) Zero MIPS
  • Responsibilities:
  • As a test lead
  • 1) Designed the test cases from the inputs received from the SME’s
  • 2) Unit testing, System testing, E2E testing
  • 3) Giving support during UAT testing
  • 4) Raising the defects and retesting
  • Period: Apr 2016– Nov’2016
  • Client: IRI
  • Role: Module Lead

Module Lead

Wipro Technologies
11.2016 - 04.2016
  • Summary: Finet is the main core banking application in ANZ. Finet is the core banking application for the following Asia Pacific countries – FIJI, PNG, Cambodia, Vanuatu, Samoa, Tonga, Vietnam (It has two instances of Finet), Kiribati, Solomon Islands and Timor. Finet is deployed in Pacific countries. Finet houses all types of transactions and account-related data for banking customers. It supports both Retail and Institutional functions of banking along with FNS treasury.
  • Responsibilities:
  • As a lead, 1) Designed the solution from the inputs received from the SMEs.
  • 2) Coding, Unit testing, System testing
  • Period: Nov 2016– Feb 2017
  • Client: ANZ
  • Role: Module Lead

Sr. Software Engineer

IBM India Private Ltd.
12.2007 - 06.2010

Technical Associate

Tech Mahindra
05.2006 - 11.2007

Business Associate

Infosys Technologies
11.2005 - 05.2006

Education

B. Tech - Chemical Engineering

Periyar University
Hosur, Tamil Nadu
07.2002

Skills

  • Cloud Database: Snowflake, Azure Data Factory
  • Python (beginner), SQL, SnowSQL
  • Dashboard: Tableau
  • Data Warehousing: Snowflake
  • Data modeling
  • DBMS: Oracle SQL, DB2, Snowflake
  • Operating System: Windows, Linux
  • Data integration tools
  • Version control tools

Certification

  • Scrum Master certification
  • Wipro competency framework in software Testing (UCF 4.1)

Courses attended

  • DBT boot camp
  • Snowflake - The complete master class
  • Snowpark - Data engineering with Snowflake

Timeline

Lead Data Engineer

NetApp
08.2023 - 04.2026

Lead Data Engineer

KPI Partners India Private Limited
03.2022 - 05.2023

SQL Developer

KPI Partners India Private Limited
09.2021 - 02.2022

Snowflake Developer

KPI Partners India Private Limited
01.2021 - 08.2021

Lead Consultant

KPI Partners India Private Limited
04.2020 - 12.2020

SQL developer

KPI Partners India Private Limited
03.2018 - 03.2020

Lead Consultant

KPI Partners India Private Limited
03.2017 - 07.2023

Lead Consultant

KPI Partners India Private Limited
03.2017 - 01.2018

Module Lead

Wipro Technologies
11.2016 - 04.2016

Module Lead

Wipro Technologies
04.2016 - 11.2016

Technical/Module/Test Lead

Wipro Technology Ltd.
07.2010 - 02.2017

Sr. Software Engineer

IBM India Private Ltd.
12.2007 - 06.2010

Technical Associate

Tech Mahindra
05.2006 - 11.2007

Business Associate

Infosys Technologies
11.2005 - 05.2006

B. Tech - Chemical Engineering

Periyar University
Roshan Ali Syed