Naveen Kumar R
Hosur, Tamilnadu
Summary
- Having 6+ Years of IT experience in implementation of Data warehousing projects in Cloud & on-prem platforms using Microsoft Business Intelligence tools like Azure Data Factory, Power BI, SQL Server, Informatica Power Centre, Data bricks and Snowflake.
- Worked in Azure data factory (ADF) and Azure SQL Server, Azure Data Lake Store, Azure Blob Storage Account and Power BI.
- Created Azure data factory Pipelines to pull data from Blob Storage account to Azure SQL Data warehouse, Azure SQL Data base and Azure Data Lake storage as a full/Incremental load based on frequency at which the data arrives in to corresponding tables/folders.
- Experience in using various activities present in ADF pipeline like Copy Data, Execute pipeline, Dataflow, Execute Stored Procedure, Get Metadata, Lookup, Web for sending Email, For Each Iterator, If Condition etc.
- Experience in Schedule Trigger and Event based Trigger. Having knowledge on writing the Dynamic content expressions in ADF, which enables to pass dynamic values to parameters at pipeline, datasets and activity level.
- Experience in ETL and ELT processes. Worked extensively on Data Extraction, Transformation and loading from different data sources using ADF.
- Having Good Knowledge in Informatica power centre.
- Having hands on knowledge in data bricks Notebook and widgets, Job creation in cluster.
- Utilized Power BI to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end user to make filters.
- Created interactive and highly informative Power BI reports. Used Power BI to collaborate with different user and stakeholder to work on live data sources.
- Expertise in Azure Data Lake Gen2(Raw and Processed Data).
- Good Knowledge in GitHub Repository in ADF resources from Development environment to Production Environment.
- Having Knowledge in SCD2(Slowly Changing Dimensions).
- Experienced in different environments (Dev, Stage, UAT and Production) configuration.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Programmer Analyst
Bitwise India
Pune
09.2022 - Current
ADF Developer
Ascendency Infosystems Pvt Ltd
Chennai
01.2018 - 09.2022
Education
B.E (Electronic & Communication) -
K.S.Rangasamay college of Technology, Anna University
01.2015
Skills
- Azure Data Factory
- MSSQL Server
- Power BI
- Informatica Power Centre
- Data bricks
- Snowflake
Certification
- Microsoft Certified as Microsoft Azure Fundamentals
- Udemy Certified as Azure Data Factory For Data Engineers - Project on Covid19
- Microsoft Certified as Microsoft data analytics
Projects Handled
- CarMax, CarMax Inc. Is a holding company, which engages in the retail of used vehicles and wholesale vechile auction operator. It operates through the CarMax sales operations and CarMax Auto Finance segments. The CarMax Sales operation segment consists of all aspects of its auto merchandising and service operations. The CAF segment provides vehicle financing to customers buying retail vehicles. Tracks the overall data from the Source Database. Daily data's is applied to Data warehouse via ADF Pipelines.
- MARS PET CARE USA, Mars pet care is a line of pet care products that includes food, treats, and supplements for cats and dogs. The products are designed to provide complete nutrition for pets, with a focus on natural ingredients and high-quality proteins. Mars pet care also offers a range of grooming products, such as shampoos, conditioners, and brushes. Tracks the overall data from the Source Database. Daily data's is applied to Data warehouse via ADF Pipelines. Transformation for Revenue is done through Stored Procedure. EDW Data is pulled in to Data lake storage and gives the Power BI Reports.
- MTO (Ministry of Transport Ontario), MTO is in charge of various aspects of transportation in Ontario, including the establishment and maintenance of the provincial highway system, the registration of vehicles and licensing of drivers and the policing of provincial roads, enforced by the Ontario Provincial Police and the ministry's in house enforcement program(Commercial Vehicle Enforcement). Tracks the overall data from the Source Database. Daily data's is applied to Data warehouse via ADF Pipelines.
Languages
Tamil
First Language
English
Proficient (C2)
C2
Hindi
Upper Intermediate (B2)
B2
Timeline
Programmer Analyst
Bitwise India
09.2022 - Current
ADF Developer
Ascendency Infosystems Pvt Ltd
01.2018 - 09.2022
B.E (Electronic & Communication) -
K.S.Rangasamay college of Technology, Anna University
Similar Profiles
Yash SalunkeYash Salunke
Programmer at Bitwise India Pvt. Ltd.Programmer at Bitwise India Pvt. Ltd.
EMELY SANCHEZEMELY SANCHEZ
Project Manager at Bitwise Industries, Bitwise Tech ConsultingProject Manager at Bitwise Industries, Bitwise Tech Consulting
Kalyani FendarKalyani Fendar
Coordinator - Talent Acquisition at BitwiseCoordinator - Talent Acquisition at Bitwise