Dinesh Kumar

About Dinesh Kumar

Extensive experience in Data Warehousing, Data Modeling, Data Integration, Data Migration, Data Architecture, Data Governance and Analytics. Data Product Architect on Data Architecture, Data Modeling, Data Integration, Data Migration, Business Intelligence and Cloud Data Management using various modelling techniques like Dimensional, Data Vault and Entity Relationship model. Designed components of data architecture, composed of models, policies, rules, or standards that govern which data is collected and how it is stored, arranged, integrated, and use in data systems.Modeled Conceptual data, Logical data, Physical data, Transition, Architecture roadmap. Capability to define the models and standards by which data is sourced, stored, distributed, and governed within an organization. Developed solutions that define the master data (internal glossary of key data items), the reference data (external glossary of standard data items and values) and meta data (the data that describes the data set)Managed the processes and facilitated the production and delivery of Data products to Clients. Identified changes to systems and processed to continually improve the delivery to stakeholders.Collaborated with Research Analysts, Management, and other relevant end users to help deliver seamless execution of processes, the resolution of issues and driven improvements to processes and technology. Facilitated high quality and consistent production of Data products, as well as the delivery of those products to stake holders and business users via data platforms.Got involved in business development activities like creating proof of concepts (POCs), point of views (POVs), assist in proposal writing and service offering development, and capable of developing presentations.Implementation of the Modern Data Landscape comprised of Cloud Data Lake and Data warehouse with Public cloud offerings in Data & Analytics using Snowflake Data Architecture, Database Storage, Cloud Services, Data modelling, ELT using Snowflake SQL, standard DWH and ETL concepts. Data Migration experience from a Legacy DWH platform to a Modern cloud DWH platform. Involved in end-to-end full Data warehousing life cycle architecture implementation. Designed Models in Erwin, Idera Data Architect, MS Visio to coordinate functional model and validations to ensure derived data model provides solution to business requirements. Migrated On premises database to Azure Cloud SQL database using Data Migration Agent. Strong experience in ETL designing Source to Target Mappings.

Experience

1. Senior Data Modeler

   Stratosphere It Services Private Limited

   May 2025 — Present · Chennai, IN

Education

• Bharathidasan University

  Master of Business Administration (M.B.A.), Systems and Finance

  2005 — 2007

• Madras University,Chennai - KCG college of technology

  Bachelor of Engineering (B.E.), Electronics and Communications Engineering

  2000 — 2004

Skills

• Sql
• Business Intelligence Tools
• Data Integration
• Software Development Life Cycle (Sdlc)
• Informatica
• Unix Shell Scripting
• Oracle
• Requirements Analysis
• Obiee
• Microsoft Bi Suite
• Business Objects Data Integrator
• Unix
• Data Modeling
• Teradata
• Business Analysis
• Datastage
• Dimensional Modeling
• Sdlc
• Business Intelligence
• Data Marts
• Data Warehousing
• Etl
• Data Quality
• Olap
• Cognos
• Extract, Transform, Load (Etl)
• Data Warehouse Architecture
• Pl/Sql
• Shell Scripting
• Business Objects