Pawan Rawat

About Pawan Rawat

With 14+ years of experience in IT industry, I am a multi-tasking consultant well-known for successfully taking projects from beginning stages to completion. Experienced in Snowflake data platform setup and on premise to cloud migration. Proficient in DWH development using data modelling techniques & experience of implementing data governance & data lineage requirements. Commended for consistently meeting new technical challenges and finding solutions to satisfy customer needs.TOP CERTIFICATIONS Snowflake Certified Architect Snowflake Snowpro Core by Snowflake OCP for advance PLSQL by Oracle OCA for advance sql by OracleTECHNICAL PROFILE Data Architecture Designs : Data warehouse, Data Lake, Data Lakehouse, Data Mesh Streaming : Kafka Database : Snowflake DWH, Oracle, PostgreSQL, SAP Hana Cloud : AWS Cloud Migration : SnonwConvert Programming : Oracle PLSQL, SnowScripting, SQL, DBT, PG/SQL, Python Data Modeling : Star Schema, Snowflake Schema, Data Vault 2.0. Orchestration : Autosys, Apache Airflow Reporting : MicroStrategy, Crystal Reports, Actuate Reports Code Versioning & CICD : Bitbucket, GitHub, Jenkins DOMAIN EXPERIENCE Payment and Cards ( BNFS ) Treasury Investment (BNFS) Group Insurance ( Insurance )PROFESSIONAL EXPERIENCE SUMMARY Agile based end to end project delivery. Hands on experience on Snowflake, Oracle 19 C, PostgreSQL, SAP Hana. Customer focused sprint planning and implementation. Expertise in Oracle PLSQL programming & performance tuning in Oracle, Snowflake & PostgreSQL. Experienced in implementing EDW layered architecture. Hands-on experience with Data modeling techniques of Snowflake, Star Schema and understanding of Data Vault 2.0. Hands-on experience in migration/development of EDW, data governance, data lineage and platform setup in Snowflake using AWS cloud. Expertise on snowflake concepts like Bulk / Continuous Data Loading, Performance Improvement, Tasks, Streams, Search Optimization, Snowsql, Snow Scripting, UDFs, Procedures, Resource Monitors, RBAC, Snowflake administration etc. Understanding of DBT basics, usage and implementation. Experience in UNIX Shell Scripting and python programming.

Experience

1. Global Data Architect

   Boston Consulting Group (BCG)

   Jan 2026 — Present · Delhi, IN

Education

• B.S.A.I.T.M

  B-TECH, INFORMATION TECHNOLOGY

  2007 — 2011

Skills

• C#
• Mysql
• Ajax
• Sdlc
• Javascript
• Html
• Web Development
• C++
• Unix
• Sql
• Asp.net
• Oracle
• Sap Hana
• C
• Programming
• Databases
• Java
• Pl/Sql