Profile

Alok Kumar Panjiyar

Senior Analyst @Novartis | SQL | ETL | Data Warehousing & Business Analytics | 3x Dataiku DSS

Alok Kumar Panjiyar is a skilled Data Engineer with around 3 years of experience in delivering Business Intelligence solutions. He has a strong background in ETL Tool development and design, developing scripts, and working on relational databases and data warehouse applications. Alok's exp

Show more

5.2

Years of Experience

Education

gauhati university

Companies

novartis, zs associates, tcs, cec education guwahati, beyond, probyto, indian oil corporation limited, airport authority of india

Reach out to Alok Kumar Panjiyar via Email, InMail and SMS drip

by installing Chrome extension

Alok Kumar's contact details

Email

Email (Verified)

paXXXXXXXXXXXXXXXXXXXXXXom

Email

Mobile Number

+9XXXXXXXXX50

Experience

  • img

    2023 - Present

    novartis

    Senior Analyst

  • img

    2021 - 2023

    zs associates

    Data Engineer

  • img

    2019 - 2021

    tcs

    System Engineer

  • img

    2019 - 2019

    cec education guwahati

    Course Instructor

    working as a Instructor and Teaching assistance staff for Module like Visual Basic , C, C++, Web Development (php, js, HTML , CSS) , Database (MySql) and Basic Computer.

  • img

    2018 - 2019

    beyond

    Freelance

    Working as a contractual employee for beyond consultancy on BMC( Bio Medical waste) leveraging Web and Android based App solution

  • img

    2018 - 2018

    probyto

    Inter Data Analyst

    Completed my two months summer camp and worked on project entitled "Voting System based on BlockChain Technology", which is decentralise, immutable, transparent and the voters records are secured, and all transactions on the Blockchain network is committed in the term of Hash code or a have a digital signature associated with it (cryptographic code). Once the transaction committed on BlockChain can not be altered, which reduces the case of dual voting or vote tempering. The entire architecture work on a concensus algorithm called "prof of work ".

  • img

    2017 - 2018

    indian oil corporation limited

    Student Intern

    During my Internship I worked with Oracle Database and ASP.Net , and as final project I worked on "Student Information Management System", Which was connected to ORACLE Database and Deployed that on Windows IIS Server.

  • img

    2017 - 2018

    airport authority of india

    Data Analyst

    As an Intern I was assigned to a project entitled "Multi-fractal Detrended Analysis of point Daily Rainfall Data".  I worked for the development of the project throughout the internship period, during this internship i have work with the large Data Set (large in volume and highly complex) and applied polynomial curve fitting , and as a final product build a GUI that can predicted the rainfall in a particular station and rate of Rainfall.

Experience

18 Skills

analytics

Business Analytics

business intelligence

Business Intelligence (BI)

Data Engineering

Data Modeling

Data Warehouse

Data Warehousing

Design

Extract, Transform, Load (ETL)

Informatica

Python

RDBMS

Snowflake

SQL

test

testing

Unit Testing

Education

  • img

    2015 - 2019

    gauhati university

    Bachelor of Technology - BTech

    computer science and engineering

Colleagues at novartis

Aarthi Iyer

Foundry Full Stack Engineer

imgPhoneimgEmail

Aayush Arora

Associate Full Stack Engineer

imgPhoneimgEmail

ABHIJIT BORUAH

Data Engineering Manager

imgPhoneimgEmail

Abhijit Thapa

Senior UIUX Designer

imgPhoneimgEmail

Show more

Others named Alok Kumar

Alok Kumar Tripathi

Assistant Manager

 at novartis

Alok Kumar Jain

Product Management

 at novartis

Alok Kumar Patro

Application Engineer III

 at novartis

Alok kumar yadav

QA Automation Engineer

 at novartis

Alok Kumar Gupta

sde 2

 at novartis

Show more

Colleagues at zs associates

Rishabh Jain

Business Technology Solutions Associate

imgPhoneimgEmail

Shivam Mittal

Business Technical Solutions Associate

imgPhoneimgEmail

Sanyam Saxena

Business Technology Solutions Associate

imgPhoneimgEmail

Devashish Anand

Business Operations Associate

imgPhoneimgEmail

Show more

Colleagues at tcs

Chinmaya Jati

Software Engineer

imgPhoneimgEmail

Prasanna kumar Singh

Assistant System Engineer

imgPhoneimgEmail

Md Arman

Systems Engineer

imgPhoneimgEmail

Praveen Jha

Assistant System Engineer Trainee

imgPhoneimgEmail

Show more