Amit Jain
Verified Expert in Engineering
Database Design and Programming Developer
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.
Portfolio
Experience
Availability
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
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.
Experience
Undergraduate Admissions System
https://www.nus.edu.sg/oam/apply-to-nus/applicationSkills
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
Education
Master's Degree in Information Technology
Singapore Management University - Singapore, Singapore
Master's Degree in Computer Science
Madurai Kamaraj University - Tamil Nadu, India
Certifications
Microsoft Certified: Azure Database Administrator Associate
Microsoft
Microsoft Certified: Azure AI Fundamentals
Microsoft
Microsoft Certified: Power BI Data Analyst Associate
Microsoft
Microsoft Certified: Security, Compliance, and Identity Fundamentals
Microsoft
Microsoft Certified: Azure Fundamentals
Microsoft
Microsoft Certified: Azure Data Fundamentals
Microsoft