User's Cover Picture
User's avatar

Siddharth Poddar

Helping Industry with Data Integration, Data Orchestration, Data Analysis

Message
Intro
Jaipur, India
Data Warehouse Consultant at Jumio Corporation
Studied Software System at Birla Institute of Technology and Science, Pilani
Studied Marketing Management at Sikkim Manipal University
Studied Information Technology at Rajasthan Technical University
Information Technology & Services
linkedin.com/in/siddharth-poddar-6b6aaa25
Joined September 1, 2022

Skills

Languages

English
-
Fluent
Hindi
-
Native or Bilingual
About
• Extensive 9+ years of experience in Data Analysis, Data Integration, Database development, Reporting & customization. • Conversant with all phases of the Software Development Life Cycle (SDLC) especially Agile, and Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing & post-implementation support. • Extensive experience in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System & User-defined Variables for SSIS Packages. • Adept at analyzing, planning, implementing, managing large databases, writing complex T-SQL code, and creating functions and triggers to enhance data manipulation and data consistency. • Experience in the design of tabular cubes for data analysis using SSAS. Strong knowledge of Data Warehouse concepts and technologies such as dimensional modeling, Star and Snowflake Schemas, reporting tools etc. • Highly knowledgeable in Designing, Developing & deploying various kinds of reports using SSRS to visualize relational data. Having expertise in the design of reports and dashboards using PowerBI and Create Measures in Power BI based on the requirement using DAX. • Extensive experience in creating Data orchestration with Azure Data Factory Pipelines & Dataflows and Azure Logic Apps. • Adeptness across ETL, performance tuning, query optimization, database consistency and security, and ensuring rigorous data integrity. • Experience in Visual Studio Team Foundation Server, SVN, GIT.
Experience
User avatar
Jumio Corporation
Jan 2021 – Present
India
Data Warehouse Consultant
• Interfacing with Global customers for gathering business requirements, leading landscape analysis and finalizing configuration, custom developments & functional specifications; contributing to the design, development troubleshooting & debugging of the solutions. • Developed applications and designed processes for transformation and data management from company-wide databases. Maintaining dimensional as well as relational data structures and managing operational data store(ODS) & Data Warehouse. • Implement SQL Queries, stored procedures, packages, triggers, functions, packages, and capacity planning of databases/applications using T-SQL • Developed SSIS packages and ADF (Azure Data Factory) Pipelines to perform incremental data migration and ETL/ELT process to migrate data from heterogeneous sources using hybrid connections such as Azure SQL Server, SQL Server, Blob Storage, Flat files & Third Party connectors (To make a connection with Postgres/ Salesforce and many more). • Using SSRS to deliver enterprise, Web-enabled reporting reports that draw content from a variety of data sources and deployed SSRS Reports in Report Server for multiple end-users. • Developed Tabular cube to provide self-service business intelligence capabilities to end-users. • Worked on Power BI and prepared dashboards to make them more attractive and created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries. • Prepared functional and technical documentation.
Education
User avatar
Birla Institute of Technology and Science, Pilani
Jul 2014 – Jun 2016
M.Tech, Software System
User avatar
Sikkim Manipal University
Jun 2013 – Jun 2015
MBA, Marketing Management
User avatar
Rajasthan Technical University
Aug 2008 – Jun 2012
B.Tech, Information Technology