Amit Jain, Developer in Singapore, Singapore
Amit is available for hire
Hire Amit

Amit Jain

Verified Expert  in Engineering

Database Design and Programming Developer

Location
Singapore, Singapore
Toptal Member Since
January 16, 2023

Amit is a data and analytics professional with 19 years of experience in architecture, design, and delivering data and business analytics solutions for global Fortune 500 companies. He has worked across banking, insurance, telecom, gaming and attractions, government, B2B eCommerce, life sciences, and higher education industries.

Availability

Part-time

Preferred Environment

Oracle Database, Microsoft Power BI, Data Architecture, Data Engineering, Data Modeling, Data Warehousing, Data Visualization, ETL Implementation & Design, Master Data Management (MDM), Azure PaaS

The most amazing...

...data models I've designed were for a leading university's admissions, scholarships, and financial aid applications and processing systems.

Work Experience

Data Architect

2020 - PRESENT
National University of Singapore
  • Acted as the data architect for the modernization of the university's admission, scholarship, and financial aid application systems, including designing the normalized data models from scratch.
  • Conceptualized, designed, and implemented an enterprise operational data store (ODS) to meet the transactional data needs of various downstream information systems from other enterprise business applications.
  • Specified the ETL framework components and design for the enterprise data warehouse of the university.
Technologies: Oracle Database, SQL Server 2017, Informatica ETL, erwin Data Modeler, Data Architecture, Business Analytics, Database Design, Database Programming, Data Engineering, Data Modeling, Data Visualization, Data Warehousing, ETL Implementation & Design, Master Data Management (MDM), SQL, Data Analysis, Data Analytics, Data Warehouse Design

Undergraduate Admissions System

https://www.nus.edu.sg/oam/apply-to-nus/application
The undergraduate admissions portal of the National University of Singapore. I was the data architect for the project and was in charge of designing the normalized data model, the data flows, and the data integration interface specifications for the application system.

Languages

SQL, Python 3

Paradigms

ETL, ETL Implementation & Design, Business Intelligence (BI), Database Design, Data Science

Other

Data Engineering, Data Modeling, Data Warehousing, ETL Development, Data Warehouse Design, Data Architecture, Business Analytics, erwin Data Modeler, Data Analysis, Data Analytics, Data Visualization, Azure SaaS, Exploratory Data Analysis

Platforms

Oracle Database, Azure PaaS, Denodo, Oracle Data Integrator (ODI)

Storage

Master Data Management (MDM), Oracle SQL, Oracle PL/SQL, Database Programming, SQL Server 2017, Azure SQL Databases, Data Integration

Tools

Microsoft Power BI, Informatica ETL, Informatica Master Data Management (MDM), Oracle GoldenGate

2013 - 2016

Master's Degree in Information Technology

Singapore Management University - Singapore, Singapore

2000 - 2003

Master's Degree in Computer Science

Madurai Kamaraj University - Tamil Nadu, India

JUNE 2022 - PRESENT

Microsoft Certified: Azure Database Administrator Associate

Microsoft

APRIL 2022 - PRESENT

Microsoft Certified: Azure AI Fundamentals

Microsoft

MARCH 2022 - MARCH 2023

Microsoft Certified: Power BI Data Analyst Associate

Microsoft

FEBRUARY 2022 - PRESENT

Microsoft Certified: Security, Compliance, and Identity Fundamentals

Microsoft

FEBRUARY 2022 - PRESENT

Microsoft Certified: Azure Fundamentals

Microsoft

JANUARY 2022 - PRESENT

Microsoft Certified: Azure Data Fundamentals

Microsoft

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring