• Provided cloud migration solution for migrating on-prem data warehousing platform to Snowflake• Designed and built data warehouse in Snowflake• Built dimension data model in Snowflake• Migrated on-prem data using AWS Storage Gateway into Snowflake Data Warehouse• Designed end to end Python framework to reengineer existing data pipelines into Snowflake• Designed and implemented Airflow Orchestration and dynamic Airflow DAG generation• Developed end to end data pipelines in Snowflake for regular data loads• Implemented data masking policies, data migration process across layers, data shares etc• Built Liquibase and Terraform DevOps pipelines for Snowflake objects deployment• Built Azure DevOps pipelines to deploy Python Scripts• Implemented RBAC access controls for Snowflake• Performance tuning of data pipelines, SQL queries and virtual warehouses• Implemented DR (Disaster Recovery)• Built BPC and Run Control Process• Designed and implemented a process for checks and balances

Snowflake Cloud Migration• Provided cloud migration solution for migrating on-premises data warehousing platform to AWS Snowflake.• Built data model in snowflake.• Migrated on-premises data from data warehouse to Snowflake.• Modernized existing Informatica workflows.• Built end to end data pipeline in Snowflake.• Performance tuning of data pipelines, SQL queries and virtual warehouses.Building Data LakeTechnology Used : HDFS, Hive, Sqoop, Spark Scala, Python, MongoDBRoles & Responsibilities• Designed and implemented data models for Ingestion, Confirmed and Curated layers of data lake.• Designed and built ingestion framework to ingest data from RDBMS source systems into data lake.• Designed and built ingestion framework to ingest data from edge node into data lake.• Designed and built SCD1, SCD2 framework to source data from ingestion layer and process it and load it in confirmed layer.• Built end to end data pipelines for Ingestion, Confirmed and Curated layers for various subject areas.• Designed and built framework for sourcing data from MongoDB Rest API Webservices into RDBMS databases.• Designed and built framework for sourcing data from data lake into RDBMS databases.

Technology used : Oracle Exadata , Informatica, PL/SQLWorked as Senior Data Architect /Solution Architect for GIS LOB for collecting and processing of data for building Operational Data Source, providing data for major corporate web-application, building various data mart for reporting for meeting various compliance and regulatory requirements of the organization.Roles & Responsibilities• Designed and implemented Databases for various layers - Staging, ODS, Core, Snapshot, Review in ORACLE EXADATA.• Designed operational data model for ODS layer.• Designed transnational data model for web application.• Designed dimensional data modes for various data marts for reporting.• Designed various data marts for reporting.• Designed database for Auditing.• Designed end to end ETL (Informatica, PL/SQL) Architecture from Source systems – Staging – ODS – Core- Snapshot – Review -Reporting layers.• Build various process flows for various business functionalities and presented to stakeholders.• Designed Data Architecture for various access reviews (Database Reviews, Active Directory Groups Membership and Permission Reviews, Network File share reviews, Quartz Reviews, Bloomberg Books Reviews. Regulated Applications Reviews. Routine Employees & contractors Reviews)• Designed various functionalities like Reassignment, Proxy, Email Generation, Revocations for access reviews.• Designed Data Moving Strategy to move data into historical schema.• Providing technical solutions to various problems/issues in ETL.• Fine tuning of SQL Queries and optimization.• Designed and Implemented various Oracle features (External tables, exchange partitioning, Materialized view with logs, Partitioning and sub-partitioning etc.)

Business Objects Project – GSK ( Glaxo Smith Kline), Raleigh, NCWorked as Business Objects Architect/ infrastructure manager to manage BO infrastructures for which user groups are spread across the globe. Managing multiple versions of BO environments for various business groups across the globe with a team of 6 people. Roles & Responsibilities• Administration of BO servers in multiple versions (XI R3, XI R2, & 6.5.2)• Installation of Services Packs and Fix packs (BO XI R 3.1 -SP2 & Fix Pack 2.1, BO XI R2 - SP5, SP6 and LA Fixes etc.)• BO 6.5.2 to BO XI R 2.0 migration• Installation and Configuration of the BO servers.• Migrated BO objects, Troubleshooting migration issues• Configuring and managing security• Development of BO universes and reports• Technical Support of BO servers.• Defining the service strategy with a focus on how this service fits with other Business Intelligence services.• Liveoffice deployment, Xcelsius dashboards deployment and & support• Developing and reporting service metrics.