SUMMARY

• Insightful, results - driven IT professional, with experience in Value-added Enterprise Data Architecture & Development (ERP, Supply Chain, Retail, Healthcare), Datawarehouse & Data Lake Implementation on Hadoop & Multi-Cloud Platforms, Data Engineering, BI - Analytics , Reporting, Dashboards, Visualizations.
• Versatile, dedicated and hardworking professional well-versed in understanding business requirements and implementing cost-effective solutions through efficient use of technology.

PROFESSIONAL EXPERIENCE

Senior Data Architect / Engineer

Confidential

Responsibilities:

• Strategically design and implement BI Solutions on the Cloud platform as part of the digital transformation project for Confidential separating from their previous owner-HMSHost & hosting their data independently. That includes integration with OLTP & ERP databases (NetSuite Financials, Crunchtime RMS, Oracle HCM) & legacy data warehouses.
• Designing the Data Platform Solution for the Data Integration Hub on MS-Azure and BI-Analytics platform on Oracle Analytics Cloud to deliver Advanced Analytics Dashboards using Machine Learning Algorithms.
• Scope of work: Gathering requirements, business process analysis, blueprinting, designing, testing, and rolling out BI solutions (Operational Dashboards - Sales, P&L, Promotion Analysis, Expense Tracking, Inventory Demand Forecasting, Price Optimization, Market Basket Analysis, Multi-Dimensional Store Clustering) for the end-users.
• Responsible for determining BI / Reporting / Analytics requirements for integrated management information systems across all finance, purchasing, sales, HR, cost, budget & accounting functions. Conduct design thinking JAD workshops for business alignment & executing POC’s with key business stakeholders to capture functional and change management requirements.
• Lead the management information and data requirements gathering initiative by working closely with customers to develop and streamline the Reporting / Analytics capabilities. Ensure that processes are implemented to take full advantage of the capabilities of the systems.
• Data Integration Hub Platform build using Azure Data Catalog, BLOB, ADLS Gen-2 & Azure SQL Datawarehouse.
• Build Metadata Repository using Azure Data Catalog to manage data assets across multiple transaction applications.
• Roadmap to perform Big Data Pipeline operations from ADLS Gen-2, running transformations in HDInsight & loading the transformed data into Azure SQL Datawarehouse and generate insights using Power BI.
• Azure Data Factory for orchestrating Data Pipelines in BLOB, ADLS Gen-2, HDInsight & SQL Datawarehouse
• Datawarehouse Design, Modeling & Development in Oracle Autonomous Datawarehouse (ADW), Star and Snowflake schema design. Implementing Dimensions: Conformed and Slowly Changing Dimensions. Conceptual-Logical- Physical Data Modeling (ERD’s). Development using PL/SQL Scripting, ODI and Oracle Goldengate for ELT processes, SQL Workbench, Oracle Analytics Cloud (OAC) & Oracle Machine Learning Notebook on Exadata Platform for Reporting / Analytics & Visualizations in Oracle Cloud Infrastructure (OCI) and implementing Security.
• Troubleshooting BI tools, PL/SQL performance tuning, analyzing & validating data accuracy & build reconciliation.
• Design and deliver end-user training and training materials. Involved in change management and process improvement discussions to identify and implement streamlined solutions.

Senior Data Architect

Confidential

Responsibilities:

• Solution Architecture, Design & complete life cycle Development & Implementation experience with large scale datawarehouses ( Oracle , SQL Server, Teradata), Relational Databases (OLTP), Big Data - Data Lake on Hadoop (Hortonworks Data Platform)) and Data Lake on Cloud (MS Azure & Google Cloud Platforms)
• Developing Conceptual, Logical, Physical & Semantic information models for strategic initiatives within the context of the Enterprise and Line of Business Information Architecture
• Develop & maintain Enterprise Data Models for Enterprise Class Data Initiatives. Work with DBA's as part of Database Design, Monitoring, Debugging, load testing, troubleshooting, Performance Tuning, scalability, partitioning, design, data backup and archiving strategies of the target DBMS.
• Hands-on experience with ETL tools: Informatica PowerCenter (PwC) & Informatica Big Data Management (BDM) on Hadoop, ELT tool: Oracle Goldengate (change-data-capture) to drive the ETL / Data Pipeline Architecture for Data Ingestion in Loblaw & Shoppers Loyalty Merger Program (PC Optimum).
• Experience with Informatica Data Integration Hub (DIH) between on-premise & cloud platforms (Azure & GCP)
• Hands-on-Experience with Informatica Data Quality (IDQ) & Informatica Enterprise Data Catalog (EDC) for data quality & metadata management activities for on-premise, big data & cloud platform workloads
• Worked on the Customer MDM solution leveraging Informatica MDM. Design the MDM hub conceptual, logical & physical data models in support of a Master Data Foundation Strategy
• Architecting and deploying Data Platforms & BI / Analytics tools to stand up Lower QA / UAT, Production, HA and DR environments. Strong understanding of Servers, Clients, Data Storage, Network, Web and Security components from environment deployment standpoint.
• Working closely with Infrastructure Architect and Designers to perform Capacity Planning
• Promote industry standards, best practices for data modeling within information areas, provide oversight for activities related to data mapping, data profiling / lineage, data movement among interfaces, data cleansing, ETL / data integration (batch, real-time), data transformation, data quality-integrity & metadata management
• Managing and providing technical leadership to the Data Modelers and Developers, performing Design & code reviews, and documentation to ensure high quality solution development and database design
• Architected the integration of Teradata Datawarehouse with SAP and JDE
• Working knowledge of Teradata Retail Logical Data Model (RLDM) & Data Vault Modeling
• Good understanding of Oracle Exadata Architecture and benefits of Exadata over Oracle Database Appliance. Involved in the platform selection and recommendation of SAP platform to run on Exadata Appliance.
• Working knowledge of Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) & Pharmacy Data Model. Understanding of HL7, NCPDP & 834 standards
• Involved in developing ecommerce website, Data Science related activities using Python (Jupyter Notebook)
• Implementing projects applying Agile / Scrum Methodology. Using tool JIRA extensively on daily basis