Amit Khanna

Developed a comprehensive migration strategy from SQL Server to Azure SQL and Cosmos DB for the UPS Boss 2.0 Modernization project. Designed the target data architecture, ensuring alignment with business objectives, scalability, and performance goals.

Strategized and executed comprehensive plans for migrating legacy production databases to cloud platforms, successfully transitioning from MS Access to Azure SQL and Sybase to Azure SQL. Spearheaded the design and development of a cutting-edge cloud data warehouse, encompassing advanced data pipelines, a comprehensive data semantic layer, and visually appealing reporting dashboards.

Established and led high-performing DB Services and Analytics teams for AON Risk Services NA Account, providing data solutions to application maintenance and development teams. Developed comprehensive data architecture for a wide range of domain-specific data products and applications within the AON Risk Services Business Unit.

Executed a 2-year program to consolidate 10 data center locations and modernize the data infrastructure through the deployment of Aon private cloud environments. Pioneered the formation of diverse global teams for Managed Data Services and a Data Center of Excellence (COE), ensuring seamless database infrastructure availability and top-tier DB support.

Modernized a legacy batch data warehouse into a near real-time data warehousing solution, reducing latency from T+1 to 15 minutes. Gathered data from 45 OLTP upstream source systems and loaded it into SQL Server and then into ParAccel MPP, Column Store Database to perform real-time aggregations on big data.

Implemented streamlined business processes within the new MPAS+ framework, reducing average user transaction time by 30% and improving overall user satisfaction ratings. Designed databases, created mappings, and developed ETL packages for the migration of IBM Mainframe VSAM Files to SQL Server.

Contributed to database programming tasks and supported various data-related initiatives within the organization. Assisted in the development and maintenance of database systems.

Performed database programming duties, contributing to the efficiency and functionality of the company's data systems. Played a significant role in the database team, recognized for outstanding contributions.

Completed a Master of Computer Applications degree, focusing on advanced topics in computer science and software development. Gained expertise in various programming languages, algorithms, and data structures.

Obtained a Bachelor's degree in Information Technology, building a strong foundation in IT principles and practices. Developed skills in system analysis, database management, and network administration.