Nitesh Dugar

About Nitesh Dugar

I would like to express my interest in a position as ETL/ELT Developer for your esteem organization. I have 5 years of work experience in ETL/ELT programming and BI Reporting.Proficient in creating Data warehousing using Star Schema, Snowflake Schema, Fact and Dimension table’s identification.Extensive experience in implementing BI solutions. Proficient in implementing business logic and procedure in backend using stored procedures and user defined functions.Experience in creating Dashboards/KPIs. Created Parameterized reports, Cross-Tab reports,Drill down reports, Summary reports.

Experience

1. Senior Data Engineer

   Salesforce

   Nov 2022 — Present

   Worked on migration from Jitterbit ETL environment to AWSenvironment using AWS redshift, S3, AWS Glue, Step function andEvent Bridge,resulting in cost saving and an increase inperformance.Ingested data from multiple salesforce org using a combination ofSOQL, SQL & Salesforce API using python to create data view to beused in BI tools (Tableau & Tableau CRM).In the data visualization role I had developed multiple TableauCRM dashboards for the Internal salesforce security team.Automated the security process using the ETL, which reduced themanual workload and saved ~18 hours per week.

Education

• Kendriya Vidyalaya

  10th

• JECRC UNIVESITY

  Master of Technology (MTech), Computer Software Engineering

  2012 — 2014

Skills

• Html
• Performance Tuning
• Ssis
• Data Warehouse Architecture
• Databases
• Ssrs
• Sql
• Technical Data Analysis
• Etl
• Business Intelligence
• Analysis Services
• Relational Databases
• Database Design
• Microsoft Sql Server
• Data Warehousing
• Pl/Sql
• Mysql