Amit Pathak Email & Phone Number

Chicago, Illinois, United States

Client : BaxaltaProject: BioVision/ M&A Integration• Baxalta Inc. has spun-off from Baxter and there is a need to provide the global planning and forecasting solution and for the same Bio-Vision DWH has been establish, which gets the data from various sources and provide the functionality for planning the Operational expenditure, based on the latest view of Actuals provided the guidance for forecasting and various intuitive DSS reports which helps the management to take the informed decision.Shire Plc has recently acquired the Baxalta Inc in 2016.Post M&A, data integration and synergy issues have always been a prime concern. Shire wants to forecast the sales data in real time and accurately for the BioVision specific product and wants to create synergies with the existing processes of Shire.

Thimphu, Bhutan

Client : Royal Govt. Of BhutanProject : Electronic Government Interoperability Framework (e-GIF)• Royal Government of Bhutan (RGB) embarked on journey of networked government through initiative of Electronic Government Interoperability Framework (e-GIF). The-GIF, in the broad sense, is government enterprise architecture to define technical standards and best practices to enable ICT systems to better integrate and interoperate across the Royal Government of Bhutan (RGoB). In this project client wishes to provide the Consulting Services for Development of Current (As-Is) and Target (To-Be) Architecture for Electronic Government Interoperability Framework (e-GIF) in accordance with defined requirements. As a part of the project Business data hub and Vehicle data hub has been conceptualized which help the RGoB to provide a highly connected and networked government, which allows seamless exchange of information and services among government agencies, businesses and citizens. eGIF project has got the Open Group Award for Excellence in Enterprise Architecture in 2017.

Hyderabad, Telangana, India

Client: Government of Andhra PradeshProject : Andhra Pradesh State Enterprise Architecture (APSEA) / e-PragatiThe APSEA is a pioneering initiative by the State Government of AP. I worked as a data architect of the Project. AP is the first state in India working toward a state-wide enterprise architecture, aimed to achieve its vision of Connected Government. The project approach and priority areas were endorsed on the 8th of January, 2015 at a meeting with Chief Minister Chandrababu Naidu. e-Pragati project got the Open Group Award for e-governance Enterprise Architecture in 2017.

Client : CITI BankProject: Genesis Genesis is a program, which come into existence when US government has bailed out the CITI bank and asks then to provide the report of contracts, position and balances and known as Enterprise contract, Position & balance warehouse and was implemented for only Northern America region. Later on it was extended to EMEA, APAC and LATAM region as well. Genesis is a data warehouse which keeps the common pool of contracts, positions & balances and complemented by the Sources of the reference data (for value standardization), which will ensure consistency of information in order to improve Reporting and Analysis.

Client: WalgreensProject: 340B Data martIn support of our commitment to efficient healthcare delivery, I spearheaded the development of a solution specifically designed to manage inventory received through the government's 340B program. This program provides discounted medications to qualifying healthcare providers. My contributions included:Automated Inventory Management: Implemented a solution to effectively track and manage 340B program inventory, ensuring accurate stock levels and streamlined operations.Enhanced Billing Efficiency: Developed an automated invoicing system for 340B-related inventory, resulting in faster processing times and improved financial management.Patient Eligibility Verification: Integrated a patient eligibility check within the solution, guaranteeing compliance with program regulations and optimizing resource allocation.

Noida, Uttar Pradesh, India

Client : QANTAS AirwaysProject : Enterprise Data WarehouseIn a drive towards IT modernization and supply chain efficiency, Qantas phased out its mainframe system and implemented a new Enterprise Data Warehouse (EDW). Insights from EDW has helped to reduce inventory levels and optimize logistics, ultimately improving supply chain efficiency by 43%.

Indianapolis, Indiana, United States

Client: Eli Lilly & Co.Project: Enterprise Retirement TeamLed Eli Lilly's Data Strategy Transformation. Implemented a cost-effective data archiving solution that adheres to all regulatory compliances. Successfully transitioned Eli Lilly's data strategy from decentralized to a centralized model. This initiative improved data accessibility, governance, and compliance.

Client: QANTAS AirwaysProject: Qantas Engineering Data Warehouse (QEDW)It was an enhancement/support project in which QEDW system receives feeds from 15 different legacy systems, store the data in staging tables and store the measures in QEDW. These feeds were loaded into staging tables and eventually into Data Warehouse using (Unix Shell Scripts, Tivoli, DataStage and PL/SQL codes). Business Reporting is done using Oracle Reports and Oracle Discoverer reports.

Noida, Uttar Pradesh, India

Client : Agilent TechnologiesProject: TC Data ArchivalResponsibilities:• Designed Archival Strategy & Project Plan: Developed a comprehensive strategy for archiving TC data and created a clear roadmap for project execution.Automated Data Extraction & Loading: Created efficient PL/SQL scripts to automate data extraction from the operational database and load it into archival tables based on defined criteria.Streamlined Server-Level Archiving: Wrote UNIX shell scripts to automate file archiving from the production database to the archival database, ensuring efficient data transfer.Project: Columbo-Comet IntegrationStreamlined Operations: Consolidated Columbo and Comet applications after in-depth user needs analysis and feasibility study.Seamless Integration: Designed and developed the integrated application, ensuring smooth data flow and optimized workflows.Improved Performance: Implemented stored procedures and conducted performance tuning for a faster and more efficient system.

Master Of Business Administration - Mba

International Relations & Change Management, International Immersion

Executive Education

Bachelor'S Degree, Computer Science