Pratik Agaz

About Pratik Agaz

As a Senior Consultant at EY, I am currently working in digital transformation in lending platform for one of a banking client. I have also had an opportunity to work with Data and AI team previously when I joined EY where I have worked on creating Data dictionary of reporting requirements, drafting the technical architecture diagram, drafting of data model and data quality for ETL process for 2 major banking cleints.Prior to joining EY, I was a Business Solutions Analyst at Deloitte and a Business Analyst at Lentra, where I gained valuable experience in business impact analysis, business continuity planning, data center migration, API integration, and SSO integration. I have a strong background in agile methodologies, requirements analysis, and functional requirements, as well as a Master of Business Administration in Information Technology from Symbiosis Institute of Computer Studies and Research. I am passionate about leveraging data and technology to solve complex business problems and provide value to customers and stakeholders.Currently having 6 years of experience

Experience

1. Senior

   EY

   May 2023 — Present · Mumbai, IN

   Project Description: Datamart, Data Migration, Digital TransformationAs a Technical Business Analyst, I worked in a project for creating a DataMart which extracted data from Internal source system like SFTP (Simple file transfer protocol) and data lake which includes centralized repositories. The SAAS data migration included historical data, and further data was pushed in to On-Prem database and simultaneously on AWS to access the data for end users.• Created a Data Dictionary from source system requirements, detailing data elements and their definitions to ensure clarity and consistency.• Leveraged AWS, Dremio, Cloudera, and MySQL for in-depth data analysis and to validate field definitions, ensuring accurate and comprehensive insights.• Developed a Data Architecture Diagram based on technical team inputs to illustrate the detailed data transformation process.• Developed a high-level design and logical data model based on the data structure.• Compiled a Business Requirements Document (BRD) outlining all functional and non-functional requirements and prepared for accompanying release documentation.• Participated in UAT testing to ensure data accuracy and consistency, verifying that data points align with specified requirements and business needs.• Involved in business proposal outlining project objectives, deliverables, and strategies to address client needs and drive business value.

Education

• University of Mumbai

  Bachelor's degree, Computer Science

• Symbiosis Institute of Computer Studies and Research

  Master of Business Administration - MBA, Information Technology

  2018 — 2020