SUMMARY

• Extensively involved in various projects related to Data Modelling/Data Architect, System/Data Analysis for Confidential Pharmacy Retail Data Warehousing and maintaining datalake (Azure) Gen1 and Gen2
• Building framework for Data ingestion into Azure Data lake using Hadoop framework
• Guiding team on data ingesting in Azure Data Lake Gen 1 and Gen2
• Map the current data structure to the future state with a realistic transition plan and roadmap that integrates with the strategic objectives of the company.
• Define data/information architecture standards, policies and procedures for the organization, structure, attributes and nomenclature of data elements, and apply accepted data content standards to technology projects.
• Ensure existing data/information assets are identified, stewarded and leveraged across the enterprise.
• Building and Reviewing logical and physical data model
• Building and maintaining data dictionary for the account
• Creation of view scripts for Symantec layer on top of data warehouse for end user.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Reviewing mapping spread sheets for (ETL) team as well as for business users with source to target data mapping with physical naming standards, data types, domain definitions, and corporate meta - data definitions
• Knowledge on data profiling and metadata management
• Providing guidance to Dev Leads,Data Architect,QA Team
• Comprehensive knowledge and experience in process improvement, data extraction, data cleansing, data manipulation.

TECHNICAL SKILLS

Relational DB: Teradata, Oracle

Cloud DB: Snowflake

Data Modelling Tool: Erwin

ETL Tool: Informatica, Abinitio

ELT Tool: ODI

Big Data: Hadoop,Hive,Scoop,data factory

Scripting Language: Python

Open source ETL: Talend

Cloud Experience: Azure,AWS

Delivery Methologies: Agile,Waterfall

PROFESSIONAL EXPERIENCE

Confidential

Senor Data Architect

Responsibilities:

• Extensively involved in various projects related to Data Modelling/Data Architect, System/Data Analysis for Confidential Pharmacy Retail Data Warehousing and maintaining Datalake (Azure) Gen1 and Gen2
• Building framework for Data ingestion into Azure Data lake using Hadoop framework
• Guiding team on data ingesting in Azure Data Lake Gen 1 and Gen2
• Map the current data structure to the future state with a realistic transition plan and roadmap that integrates with the strategic objectives of the company.
• Define data/information architecture standards, policies and procedures for the organization, structure, attributes and nomenclature of data elements, and apply accepted data content standards to technology projects.
• Ensure existing data/information assets are identified, stewarded and leveraged across the enterprise.
• Building and Reviewing logical and physical data model
• Building and maintaining data dictionary for the account
• Creation of view scripts for Symantec layer on top of data warehouse for end user.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Reviewing mapping spread sheets for (ETL) team as well as for business users with source to target data mapping with physical naming standards, data types, domain definitions, and corporate meta-data definitions
• Knowledge on data profiling and metadata management
• Providing technical guidance to Development Leads, Data Architects,QA Team
• POC analysis on Terdata to Snowflake migration

Confidential

Senior Data Architect

Responsibilities:

• Drive the execution of data architecture using industry best practices. Specifically - Provide technical and architectural guidance to teams across all platforms and infrastructures, including promoting adherence to design standards and methodologies.
• Involved in designing and data ingesting activities in Data Lake
• Working with Enterprise Data Architect to understand different data across different brands across Ascena(Lanebrynt,Justice,Ann Taylor,Dressbarn,Maurices) and provide a roadmap for integrating into common framework in Ascena
• Build and maintain metadata repositories, data dictionaries, data lineage tracking and data quality scorecards.
• Architect modular solutions that seamlessly integrate into the enterprise ecosystem and sustain business continuity.
• Responsible for defining the data structures (logical and physical) to support data integrity, performance and recoverability across batch, real-time and near real-time frameworks
• Collaborate with various IT and business analytic teams to develop Big Data reference -- architecture patterns for data ingestion, data processing, analytics and data science solutions.
• Work collaboratively with multiple user groups to assess the analytical needs and identify dependencies across organization and tools to implement an enterprise wide data architecture (and data lake) and support cross domain data integration for reporting, and analytics.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modelling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.
• Convert the Logical models in to Physical models, and generate the delta or forward engineer DDL script, and execute in the database. Creation of view scripts for Symantec layer on top of data warehouse for end user.
• Wide experience on both Developed mapping spread sheets for (ETL) team as well as for business users with source to target data mapping with physical naming standards, data types, domain definitions, and corporate meta-data definitions
• Comprehensive knowledge and experience in process improvement, data extraction, data cleansing, data manipulation