Prem Gupta

Experience

• 

  BSD Intotech

  Jul 2011 - Jan 2014

  Software Engineer

  Worked as a software developer . Good exposure to C#, VB.Net, Oracle 10 and SQL Server.

• 

  Cognizant

  Jan 2014 - May 2019

  • Senior Developer

    Apr 2016 - May 2019

  • Programmer Analyst

    Jan 2014 - Apr 2016
• 

  Tata Consultancy Services

  Jun 2019 - Jun 2024

  Data Architect / Team Lead

  • Over 11+ years of extensive experience in IT industry in the areas of analysis, design development in client server and cloud environment. • Worked as ETL Architect and Team Lead- Techno Functional Role.• Microsoft certified Azure Data Engineer• Possess sound knowledge in SQL Server, Oracle, PLSQL, TSQL, SSAS and SSIS, SAP BODS, Power BI and Azure data factory.• Delivered 8+ Data warehousing projects and worked on all the phases of development. • Developed and modified queries, programs and stored procedures to support standard and ad hoc reporting.• Expertise in data warehousing applications design and development and post implementation support and maintenance.• Good exposure in data warehouse development life cycle, gathering requirements and analysis, dimensional modeling, and implementation of STAR, Snowflake schemas and slowly changing dimensions.• Proficiency in Performance Tuning and Query Optimization. Good Exposure to overcoming ETL architecture related challenges • Possess strong analytical skills, enabling me to visualize, articulate, and solve both complex and straightforward problems• I excel in communication and have the ability to actively engage in cross-team discussions. Show less

• 

  Capgemini

  Jun 2024 - now

  Data Modeler Architect

  Data Modelling, Data Architect