Mohan Mathews

About Mohan Mathews

I am a dependable Solutions Architect with 20 years of Information Technology experience focussing on Data Engineering, Data Warehousing and Analytics, possessing strong problem-solving and critical-thinking skills, topped with a pinch of empathy.•Led RapidStarts, Workshops and Training Sessions on all aspects of the Databricks Lakehouse Platform with an emphasis on Data Engineering, SQL Analytics, Data Governance; Collaborate with internal SME, Product and Engineering teams; Trusted advisor to customers•Conducted Technical Demos of Opera’s proprietary ETL/Analytics platform Signal Hub; Technical Liaison between Sales and Product/Engineering team•Architected Proof of Concept Solutions to solve customer requirements;•Seasoned Data Modeler with Data Warehousing background, translating requirements to Conceptual, Logical and Physical data models•Delivered database solutions on Cloud Platforms using Google Cloud SQL and Amazon RDS•Presented Solution briefs at leading Retail and Healthcare corporations; Assisted Sales team with RFP’s•Sophisticated knowledge designing and developing performant ETL jobs in traditional RDBMS, on-premise Hadoop/YARN and AWS EC2/EMR/S3 environments•Broad experience working with data sources such as Avro, Parquet, ORC, JSON, flat files and relational database structures on various environments, including Netezza, DB2 UDB, Oracle, SQL Server, HDFS, S3, Cloud Storage•Competent in several RDBMS and cognizant of SQL tuning techniques using CTE, Partitioning, Indexes to support Business Intelligence Tools, Reports and Dashboards•Specialties:Customer SuccessData WarehousingETL Scalable DesignData ArchitectureData ModelingSQL (for BI)•Learning:AWS Solutions Architecture, AWS Glue, AWS RedshiftGCP Cloud Architecture, GCP BigQuery, GCP Cloud SpannerAzure FundamentalsSpark SQL• ToolsCloud:AWS: S3, RDS (MySQL), Redshift Spectrum. GCP: Cloud Storage, Cloud SQL (MySQL)Big Data: Hadoop 2, Apache Hadoop YARN, Apache Impala/Hive LLAP/Hue, Amazon EMR, Amazon S3ETL:IBM InfoSphere DataStage 8.7/8.5/7.5.x; Informatica PowerCenter Advanced Edition 9.1CDC:IBM InfoSphere Change Data Capture for z/OS, CDD Microsoft SQL Server 2008 R2 SP1, CDD AIX6 Data Modeling:CA ERwin® Data Modeler, Microsoft Visio, Resolution XCaseProgramming:SQL, T-SQL, PL-SQL, Shell scripting, Python(basic)Databases:MySQL 5.7, Microsoft SQL Server 2014, Oracle 10g, IBM DB2 UDB 9.1, IBM Netezza 7

Experience

1. Lead Delivery Solutions Architect

   Databricks

   Feb 2025 — Present · Boston, MA, US

   Technical Leader in Delivering Solutions at Financial Services Customers

Education

• University of Madras

  Bachelors, Computer Science and Engineering

  1997 — 2001

• St. Johns Besant Nagar Chennai

  CBSE 12th Grade AISSE, Science, Computer Science, Mathematics

  1986 — 1997

• Binghamton University

  M.S, Computer Science

  2001 — 2005

Skills

• Data Warehousing
• Db2
• Offshore Management
• Data Modeling
• Microsoft Sql Server 2005/2008
• Datastage
• Oracle 8i/9i/10g
• Microsoft Sql Server
• Ibm Aix
• Sdlc
• Solution Architecture
• Oracle
• Aix
• Data Analysis
• Db2/Sql
• Version Control
• Ca Erwin® Data Modeler
• Functional Specifications
• Data Integration
• Pl/Sql
• Etl
• Data Cleansing
• Incident Management
• Unix Shell Scripting
• T-Sql
• Data Mapping
• Shell Scripting
• Change Data Capture