Umair Mansoob

About Umair Mansoob

Senior Data Architect with 19+ years of experience designing and delivering scalable, high‑performance data solutions across Snowflake, AWS Redshift, Oracle, and SQL Server environments. Adept at leading end‑to‑end data architecture initiatives that optimize analytics capabilities, improve data quality, and support strategic decision‑making across large, complex organizations.Certification and Education:SnowPro Core Certified Boomi Certified Integration Developer Oracle Database 11g Data Warehousing Certified Implementation SpecialistOracle Database (12c to 7.3) Administrator Certified ProfessionalB.S in Computer Science from Northeastern Illinois UniversityM.S in Information Systems from DePaul UniversityDatabases: Snowflake, Redshift, DataBricks, Oracle, SQL Server, MySQL, PostgreSQL ETL Tools / Utilities: Attunity, Fivetran, Matillion, MuleSoft, Informatica, DBT, Boomi, Alteryx BI Tools: Tableau, Power BOI Looker, Business Objects, Alation Data: Data Warehousing, Data Lakes, MDM, ODS, AI, ML Professional Summary:Designed and architected scalable data platforms—including data warehouses, operational data stores (ODS), and data lakes—for financial and healthcare enterprises using Snowflake and AWS Redshift.Led strategic proof-of-concept (PoC) initiatives for modern data tools such as Snowflake, Redshift, Fivetran, and DBT, evaluating emerging capabilities and delivering actionable recommendations to stakeholders.Lead implementation of MDM solutions for key domains like supplier, Customer, Contact and product. Developed and executed robust ETL/ELT frameworks across diverse data architectures, including 3NF, staging layers, dimensional modeling (star schema), data marts, and ODS environments.Advised executive leadership on cloud technology adoption, providing assessments on cost efficiency, scalability, performance optimization, security posture, and long-term viability.Established comprehensive data lifecycle policies for cloud-based data platforms, leveraging storage tiering and archiving strategies to ensure regulatory compliance and retention optimization.Directed the design and rollout of BI dashboards and reports using Tableau and Power BI, significantly improving data accessibility and driving informed decision-making.Partnered with leading technology vendors—including AWS, Snowflake, Attunity, Google, Oracle, Informatica, and Tableau—for licensing negotiations, feature enablement, and strategic alignment.

Experience

1. Senior Data Architect

   AbbVie

   Mar 2026 — Present · Chicago, IL, US

Education

• Northeastern Illinois University

  Bachelor's Degree, Computer Science

  2001 — 2006

• DePaul University

  M.S, Computer Science

  2007 — 2008

Skills

• Cloud Architecture
• Databases
• Goldengate
• Disaster Recovery
• Software as a Service (Saas)
• Oracle Rac
• Business Intelligence
• Oracle Cloud
• Performance Tuning
• Data Warehousing
• Infrastructure as a Service (Iaas)
• Etl
• Data Guard
• Cloud Computing
• Cloud Migration
• Data Modeling
• Platform as a Service (Paas)
• Data Governance
• Pl/Sql
• Database as a Service (Daas)
• Exadata
• Database Administration
• Sql
• Database Design
• Cloud Security