Alok Rajkumar

About Alok Rajkumar

Experienced Snowflake cloud & Google cloud Data Warehouse and BI Architect with expertise in designing, building and deploying data warehouse, analytics and BI solutions, and shaping large reporting and analytics programmers• Certified Google Data engineer & well-versed with relational data warehouse techniques• Extensive experience in Data Modeling, Data Analysis for Online Transaction Processing (OLTP), Data Warehousing (OLAP)/Business Intelligence (BI) applications. Expert in Transactional/Dimensional Data Modeling. Experience in various Health Care, Aviation, Financial, and Banking sectors domains• Knowledge in Data Vault implementation which includes Hub, Links & Satellite module to build the agile data warehousing development• Hands-on experience with different ETL/ELT & BI Tools & technologies with extensive experience in Informatica power center, Data Quality (IDQ), Spotfire, Tableau & worked managing multiple databases like Oracle, Big query, Big table & Snowflake cloud database• Experience in handling clients for requirements gathering and helping to understand about the implementation process using Agile methodologies/ functionality for project delivery and scrum team handling using Jira etc.• Experience in implementing end-to-end data warehousing solutions for the banking and health care domain like Johnson & Johnson, Abbott, Affin, NatWest, Fidelity• Translate Business Requirements to Conceptual and Logical Data Models• Participate in mapping of Logical to Physical Data Models and vice versa• Knowledge of Google Cloud technology and services like Big Query, Big table, Data flow, Data fusion, GCS, Pub-sub, etc.• Plan iterations to fit specific business goals by communicating with stakeholders and clients• Lead standup meetings for teams of 10 people on average to discuss priorities, requirements and progres• Good experience in designing Spotfire & Tableau dashboards/reports with complex, multiple data sources (SQL, Excel, Flat files, CSV files) relational design, and optimizing applications• Expertise in Informatica ETL tools, a complete end-to-end involvement in data gathering data cleaning, data transforming & loading in data cubes/Data warehouse• Experience in software lifecycle involving requirements gathering including Designing, development, testing & implementation• Good understanding of the Hadoop environment with resource management - YARN,Knowledge of Query big data using Hive (HQL) & Structure query language (SQL/Oracle)• Knowledge of a Snowflake cloud database and worked in migrating the end-to-end ETL process

Experience

1. Cloud Database Architect

   HCLTech

   Feb 2024 — Present

Education

• Raj Kumar Goel Engineering College

  Bachelor’s Degree, Information Technology

  2007 — 2011

• Stella maris convent

  High School

  2004 — 2005

Skills

• Pl/Sql
• Informatica
• Oracle
• Requirements Analysis
• Data Quality
• Business Intelligence
• Microsoft Sql Server
• Business Analysis
• Data Modeling
• Oracle Database
• Sql
• Data Warehousing
• Informatica Developer(Idq)
• Extract, Transform, Load (Etl)
• Team Management