Enterprise Data Architect & AI Strategist

SYED A. AHAMED

ENTERPRISE DATA ARCHITECT & AI STRATEGIST

713-***-**** • *******@*****.*** • US Citizen

PROFESSIONAL SUMMARY

Accomplished Enterprise Data Architect and AI Strategist with 20+ years of experience empowering Fortune 500 and public sector organizations to unlock the full potential of their data assets. Deep expertise in Enterprise Data Architecture, Engineering, MDM, and AI/ML solutions across Oil & Gas, Energy, Telecommunications, Manufacturing, Transportation, and U.S. Public Sector. Snowflake SnowPro Core Certified and Informatica PowerCenter Certified, with proven ability to deliver large-scale data modernization, governance, and cloud migration initiatives. KEY EXPERTISE

Cloud & Data Platforms Snowflake (SnowPro Core Certified), Databricks (Certified Data Engineer Associate), Microsoft Fabric

Data Integration / ETL Informatica IDMC/IICS, PowerCenter (Certified), Azure Data Factory, SSIS, DBT, Apache Airflow, FME, Matillion

Databases Oracle, SQL Server, PL/SQL, T-SQL, SQL*Loader, SnowSQL Languages & Tools Python, SQL, PL/SQL, Unix Shell Scripting Data Architecture Enterprise Data Architecture, Data Lakehouse, Data Warehouse, Data Lake, Data Modeling MDM Informatica MDM, Informatica MDM SaaS, IDP, IDQ — Master Data Management AI / Machine Learning Python, Supervised & Unsupervised Learning, Ensemble Methods, Neural Networks, NLP, Computer Vision

ERP & CRM Enterprise ERP (Tyler Munis), Oracle EBS (Financials, Manufacturing, HR), Tyler CAMA, Siebel Project Management Agile, SAFe, Stakeholder Engagement, Governance Frameworks CERTIFICATIONS

Snowflake SnowPro Core Certified

Databricks Certified Data Engineer Associate

Informatica PowerCenter Certified

Post Graduate Certificate in Artificial Intelligence & Machine Learning — University of Texas, Austin PROFESSIONAL EXPERIENCE

CONSEGNA TECHNOLOGIES Aug 2014 – Present

Enterprise Data Architect / Engineer

Key Clients: Treaty Oak Clean Energy (Austin, TX) • Encino Energy (Houston, TX) • Cook County (Chicago, IL) • US Xpress

(Chattanooga, TN)

Informatica Stack Leadership: Architected, designed, and administered Informatica PowerCenter, IDMC/IICS, and MDM for enterprise data engineering, integration, transformation, and master data management.

Snowflake Platform Setup, Development & Administration: Delivered full-lifecycle Snowflake engagements across energy, transportation, and public sector clients — covering environment setup and schema design, enterprise RBAC with custom role hierarchies, pipeline development using Streams, Tasks, and Dynamic Tables, Notebooks, REST API and Partner Connect integrations, and ongoing administration including query tuning, resource monitoring, and cost governance.

Databricks Architecture & Development: Architected a Databricks Lakehouse for Treaty Oak Clean Energy, implementing a Bronze-Silver-Gold medallion architecture across SCADA, financial, and operational data sources; built ETL/ELT pipelines using Delta Live Tables to automate ingestion and transformation, supporting energy production analytics and financial reporting.

Informatica MDM OnPrem and SaaS: Designed and architected end-to-end implementation of Informatica MDM On Prem and SaaS, establishing master data management for Well, Wellbore and Customer domains. Configured business entity models, match-merge rules, and data stewardship workflows within the SaaS environment, enabling Encino’s upstream operations team to maintain a single, authoritative source of truth for critical asset data without on-premise infrastructure overhead. Performed upgrade of MDM On Prem to Informatica IDMC SaaS.

Governance & Data Quality: Defined data readiness metrics, escalation frameworks, and quality standards to ensure integrity across legacy-to-modern migrations.

Project Leadership: Drove end-to-end project management: best practices, standards enforcement, stakeholder engagement, rollout planning, and data quality assurance across the full data lifecycle. ENERGY TRANSFER INTERSTATE HOLDINGS Nov 2010 – Jan 2014 Data Integration Architect / Lead Specialist

Pipeline Merger Integration: Merged Transwestern and SUG pipeline data by redesigning database structures and ETL processes, migrating from Informatica to SQL Server Integration Services (SSIS).

Gap Analysis & Re-architecture: Evaluated existing Informatica ETL solutions, identified gaps, and re-architected processes within the SSIS/SQL Server ecosystem to improve maintainability and performance.

BI & Reporting Support: Provided data resolution and issue support for redesigned BI and reporting solutions, ensuring uninterrupted business operations.

NATIONAL OILWELL VARCO (NOV) Aug 2009 – Nov 2010

Senior MDM Architect

MDM Framework: Established enterprise MDM processes and technology architecture aligned with corporate data governance policies.

Data Standards: Defined and enforced data quality standards and compliance measures for the MDM team.

Integration Projects: Managed multiple integration projects loading data into Corporate Finance, Manufacturing, and Distribution systems under strict MDM governance rules.

ETL & MDM Deployment: Architected and deployed MDM and ETL solutions using Informatica PowerCenter 8.6.2, IDQ, and SSIS, meeting aggressive timelines for Oracle EBS cutover.

Informatica Administration: Managed Informatica servers including security, migration, and development standards across the MDM team.

ENERGY TRANSFER COMPANY Jun 2008 – Jul 2009

Data Integration Architect

ETL Modernization: Replaced Informatica-based ETL solutions with SSIS to eliminate licensing costs following spin-off from Panhandle Energy.

Architecture & Development: Re-architected and redeveloped ETL workflows adapted from Informatica to the SQL Server/SSIS ecosystem.

Production Deployment: Deployed SSIS ETL solutions under aggressive timelines, ensuring a successful, cost-saving cutover from Panhandle Energy systems.

PANHANDLE ENERGY Apr 2006 – Apr 2008

Data Warehouse / Data Integration Architect

Data Warehouse Build-Out: Architected, modeled, developed, and managed a business analytics data warehouse from the ground up.

ETL Design: Designed and developed ETL processes using Informatica PowerCenter to extract and load data from source applications into the warehouse.

Platform Upgrade: Upgraded Informatica servers and migrated workflows from version 7.1.2 to 8.1.1, ensuring continuity and compatibility.

Issue Resolution: Collaborated with business stakeholders to diagnose and resolve production data issues. GE RAIL SERVICES Oct 2005 – Mar 2006

Integration Architect — Informatica

CRM-Legacy Integration: Designed and developed the data conversion process between Siebel CRM and AS/400 to consolidate billing information and eliminate data discrepancies.

ETL & Messaging: Executed data conversion using Informatica, PL/SQL for Oracle operations, and MQ Series for inter- system messaging.

Offshore Team Leadership: Led and optimized an offshore development team operating on a 24/7 project cycle to meet aggressive delivery milestones.

AT&T WIRELESS Jan 2004 – Oct 2005

Technical Lead — Informatica

Billing Data Migration: Designed and developed billing data conversion from Cingular and AT&T Wireless systems into Siebel CRM, delivering $1M+/month in savings.

ETL & Integration: Implemented ETL using Informatica, PL/SQL for Oracle operations, and Siebel EIM for data import.

Performance Optimization: Tuned Informatica jobs and PL/SQL procedures, achieving 25–75% faster processing times.

EXXONMOBIL Dec 2002 – Jan 2004

Consultant — Data Warehouse ETL

ETL Design: Designed and executed ETL processes using PL/SQL and complex SQL to extract data from SAP and other sources, transforming and loading into an Oracle Data Warehouse.

Data Operations: Managed data loading and extraction pipelines using PL/SQL, Korn shell scripts, and Mainframe OPC scheduling.

Stakeholder Collaboration: Partnered with business leaders across North America to resolve data reconciliation and storage issues.

ARTHUR ANDERSEN, LLP Mar 2000 – Aug 2002

Senior Systems Engineer / Manager

Key Clients: HP • HEB • Metro Houston • Reliant Energy • Sterling Bank • US Liquids • Enron

Data Conversions & Integrations: Designed databases, user interfaces, and integration solutions for Fortune 500 clients across diverse industries.

Business Development: Developed and presented proposals for prospective and existing clients, driving new business relationships.

Mentoring & Recruitment: Led recruitment efforts and mentored employees and contractors to build high- performing technical teams.

EDUCATION

Deakin University Melbourne, Australia

Master of Science in Data Science (Expected 2027) — Machine Learning, AI Applications, Data Analytics University of Texas Austin, TX

Post Graduate Certificate — Artificial Intelligence & Machine Learning Osmania University Hyderabad, India

Bachelor of Commerce — Commerce & Business Administration TSH Polytechnic — Dept. of Technical Education Tamil Nādu, India Diploma in Computer Science & Engineering — Computer Science OTHER INTERESTS

Digital Entertainment • Acting • Creative Writing (Screenplays) • Filmmaking & Video Editing • Entrepreneurship in redefining established industry business processes

Contact this candidate