Looking for a job

Amit Jain

@amitjainsg

Message

Experienced Data & Analytics Solutions Architect with 21.5 years in the field.

Singapore

Message

What I'm looking for

I seek a role that fosters innovation and collaboration, allowing me to leverage my extensive experience in data architecture, data engineering, data warehousing and analytics to drive impactful solutions.

I am a seasoned Data & Analytics Solutions Architect with over 21 years of experience, including 16.5 years in consulting roles at top global firms. My expertise lies in designing and implementing complex data platforms and analytical applications. I have successfully led numerous large-scale projects for Fortune 500 companies across various industries, including Banking, Insurance, Telecom and Higher Education.

Throughout my career, I have demonstrated strong leadership and mentoring abilities, guiding high-performing teams from diverse backgrounds. My technical skills encompass enterprise data architecture, data engineering, and governance, along with proficiency in various programming languages and cloud platforms. I excel at communicating complex technical concepts to both technical and non-technical stakeholders, ensuring alignment and understanding across all levels of an organization.

Experience

Work history, roles, and key accomplishments

Current

Associate Director, Architect

Current

National University of Singapore

Jun 2020 - Present (5 years 1 month)

Led data architecture within NUS IT's Data Management practice, contributing to the Enterprise Architecture Group and providing advisory services. Designed and implemented a cloud enterprise data platform on Microsoft Fabric and an Enterprise Data Model, while establishing and promoting data architecture and ETL design standards.

Microsoft Fabric ETL Data Architecture Cloud Platforms Data Management Vendor Management Team Leadership

Principal Technical Consultant

Aptitude Software

Nov 2016 - Present (8 years 8 months)

Served as a Data Architect and ETL consultant, implementing Aptitude solutions for IFRS-compliant accounting. Advised on data requirements, modeled financial data marts, and created interface specifications for data feeds.

Aptitude Studio IFRS ETL Data Architecture Data Marts Technical Reconciliation

Senior Solution Architect

Just Analytics Pte. Ltd.

Oct 2013 - Present (11 years 9 months)

Led projects as a BI&DW solution architect, overseeing the delivery of packaged and bespoke BI&DW solutions. Responsibilities included requirement analysis, functional specifications, solution architecture, data modeling, and project management.

Solution Architecture Data Modeling Project Management Functional Specifications Source System Analysis

Assistant Consultant

TCS APAC Pte. Ltd.

Nov 2010 - Present (14 years 8 months)

Worked as a Data Architect, Database Lead, and Functional Analyst for client projects, including Deutsche Bank and Allianz Insurance. Designed and deployed normalized data models, developed solution architectures, and led development and testing of data replication and transformation components.

Data Architecture Database Design Replication SQL

Senior Technical Consultant

Oracle Corporation

Jun 2009 - Present (16 years 1 month)

Served as an ETL Lead for an Enterprise Data Warehouse project for the Media Development Authority of Singapore. Responsible for ETL architecture, batch design, and development of data warehouse components including database objects, ETL mappings, and PL/SQL code.

ETL Data Warehouse Oracle Warehouse Builder Pl SQL Batch Design Data Mapping

Senior Technical Associate

Tech Mahindra Ltd.

Oct 2007 - Present (17 years 9 months)

Acted as a Technical Architect and ETL Design Lead for an Enterprise Data Warehouse for Starhub Ltd. The role involved specifying technical architecture, data model design, and leading the team in functional and technical ETL design.

Technical Architecture ETL Data Warehouse Data Modeling Informatica Team Leadership BSS Transformation

Senior Software Engineer

Cambridge Technology Enterprises Ltd.

Jan 2007 - Present (18 years 6 months)

Led BI&DW development for Hills Pet, Inc., a subsidiary of Colgate-Palmolive Inc. Focused on creating a Business Intelligence and Data Warehouse solution.

Oracle Warehouse Builder Oracle Discoverer Business Intelligence Data Warehousing ETL

Staff Consultant

Oracle India Pvt. Ltd.

Aug 2006 - Present (18 years 11 months)

Worked as a BI&DW technical consultant on projects for Oracle's North America consulting business. Developed a custom data warehouse for AC Nielsen and created End User Layers and Discoverer workbooks for American Express Ltd.

ETL Oracle PL SQL Financial Reporting Data Warehouse End User Layers

Systems Developer

Global Sources Pte. Ltd.

Jan 2006 - Present (19 years 6 months)

Provided production support for the Enterprise Data Warehouse, implementing change requests through ETL mapping modifications and BI report development. Responsible for QC scripts, debugging, performance tuning, and testing of EDW components.

ETL BI Reporting QC Scripts Performance Tuning Unit Testing UAT Data Quality

Staff Consultant

Oracle Solution Services (India) Pvt. Ltd.

Dec 2003 - Present (21 years 7 months)

Worked as a technical consultant on multiple projects, including custom data warehouses and application upgrades. Responsibilities encompassed functional specification, technical design, development, testing, and solution packaging.

Technical Consulting Data Warehousing Oracle Warehouse Builder Oracle Discoverer Oracle Designer

Education

Degrees, certifications, and relevant coursework

Singapore Management University

Master of IT, Business Analytics

Completed a Master of IT in Business Analytics (MITB - Analytics) program. The curriculum focused on developing skills in data analysis and business intelligence.

Madurai Kamaraj University

Master of Computer Applications, Computer Applications

Obtained a Master of Computer Applications (MCA) degree. This program provided a comprehensive understanding of computer science principles and applications.