Amir Baig

About Amir Baig

Accomplished Digital Transformation Professional with a robust history of spearheading enterprise-wide initiatives that have significantly enhanced operational efficiency, data utilization, and customer engagement.* Adept at fostering a cloud-first culture, introducing new digital tools and increasing engagement rate in digital change efforts, positioning organizations at the forefront of their industries through innovative technology adoption and process optimization.* Collaborate with cross-functional teams to drive digital innovation and process improvements.* Senior Data Architect helping Fortune 500 companies in keeping their data rightly architected, modeled, secured and highly available in most efficient, optimized and cost-effective manner.* Experienced in Data modeling, data warehouse design, business intelligence focused solutions on various platforms including Snowflake, Azure Synapse, Oracle / SQL Server / SSAS.* Served variety of industries including Oil & Gas, Pipelines, Engineering, Energy Trading, Utilities, Shipping, Electric Power, Healthcare and Consulting Services etc.* Proficient in database design, installation, configuration, production support, backup and recovery in SQL Server 2005/2008/2012/2014/2016 & Oracle 9i/10g/11g/12c.* Helped Development Teams in Performance Tuning using SQL Server Profiler, Query Analysis, Index modification & Addition, SQL Server Tuning Advisor.* Resolved ORACLE Performance related issues using ASH analytics, AWR reports, ADDM in 12c cloud control.* Trained a number of technology consultants in Databases & SQL tuning.* Excellent communicator between technical and business units with ability to translate complex data concepts into easily understood terms. Self-directed, flexible, confident and ready to take new responsibilities.Areas of Cloud Data ArchitectData Engineering & Business Analytics LeadData modeling / Data warehouse design & tuning; SnowFlake Architect / NetezzaAmazon web services Azure Synapse / Azure Data FactorySQL Server DBA DBA 7.3/8i/9i/10g/11g/12cOracle/SQL Server to MySQL / PostGres conversionVMware / vShpere / vMotion / vCenterSQL Server Failover Clusters / Avaiability groupsSSRS / SSAS / SSIS UNIX Shell Programming, sed, awk; ORACLE / SQL Server Performance Tuning; HA / Disaster Recovery Planning & Implementation; AIX/Sun Solaris/HP-UX/RH Linux;

Experience

1. Principal Data Architect

   WM

   Aug 2019 — Present · Houston, TX, US

   Part of the team of Senior Data Architects that led the Digital Transformation initiative at WM. Moved from On-prem Nettezza datawarehousing environment to Snowflake. Guided Migration teams to move data integration processes from Informatica to Mattilion platform. Built data architecture standards and made sure that they are being followed by multiple teams across the enterprise. • Led a team of twelve data engineers building data integration processes for customer data using Matillion, DBT,Informatica, Aurora ( Postgres ), DynamoDB, Salesforce, Snowflake in AWS environment.• Provide technical guidance and direction defining the data architecture strategy for many projects. Worked with senior management, technical teams in order to determine data requirements and best practices for advance data integrations across different systems within enterprise.• Able to deliver data management vision, goals, priorities, design principles and operating policies in support of the business goals of the organization.• Solid experience translating business requirements into conceptual, logical and physical data models.• Vast experience in Extraction, Transformation and load ( ETL/ELT ) strategy, design and implementation.• Experience in normalized Modeling and DW dimensional modeling techniques e.g. Star/Snowflake schemas. • Guiding ETL developers in re-designing the data warehouse load process in fast & efficient manner.• Built Business Intelligence & Data Engineering teams by interviewing many candidates having the right set of skills including Advanced SQL, Matillion, Informatica, SSIS, ETL, Data-modeling, SSAS, SSRS etc.

Education

• Stanford University

  Certificate, Advanced Project Management

  2008 — 2008

• Wayne State University

  M.S., Computer Science

  1990 — 1993

• NED University of Engineering and Technology

  B.E, Computer Systems Engineering

  1983 — 1989

Skills

• Linux
• Unix Shell Scripting
• Amazon Web Services (Aws)
• Microsoft Sql Server
• Performance Tuning
• Windows
• Ssrs
• Oracle
• Requirements Analysis
• Ssis
• Pl/Sql
• Sharepoint
• Business Analysis
• Databases
• Etl
• Agile Methodologies
• Sqoop
• Database Administration
• Integration
• Business Intelligence
• Hive
• Software Engineering
• Big Data
• Erp
• Project Management
• Database Design
• Cloud Computing Iaas
• Sql Tuning
• High Availability
• Hadoop
• Sdlc
• Apache Pig
• Software Development
• Pmp
• Hbase
• Solaris
• Disaster Recovery
• System Administration