Senior Data Cloud Architect

SANDESH MULCHAND GALA

Data & Cloud Architect

*******.****@*****.*** +91-998*******

Professional summary:

Accomplished Data & Cloud Architect with 18+ years of comprehensive experience in IT domain, parƟcularly in Data engineering, Warehousing and Cloud technologies.

Currently working as a Senior Data & Cloud Architect.

My cloud knowledge base has been built with experience in modernizing exisƟng applicaƟons by migraƟng them to the cloud and architecƟng new applicaƟons in the cloud.

Managed a team of senior data engineers, providing guidance, mentoring, and performance feedback.

Worked as a data champion to understand stakeholder’s data needs and provide soluƟons that meet those needs.

Develop and implement data quality checks and data governance policies to ensure the accuracy and consistency of data.

Detailed knowledge of Scrum with project experience as a Scrum Master/Product owner.

Proven people manager with experience in performance management and technical interviewing to support organizaƟonal hiring.

Technical skills:

Programming Python, Shell scripƟng

Data Ab IniƟo ETL, Hadoop, Hive, KaŅa, SQL, NoSQL, ML, Spark Scheduling Autosys, Control-M, Airflow

Cloud AWS, Kubernetes, Terraform, Monitoring & Observability tools ProducƟvity CI/CD, Scrum, JIRA, Confluence, ServiceNow CerƟficaƟons:

AWS SoluƟons Architect Professional

AWS Developer Associate

CerƟfied Associate in Python Programming

Professional Scrum Master

Oracle cerƟfied SQL developer

EducaƟon:

Bachelor of Engineering in InstrumentaƟon, Mumbai University, 2006 Projects:

OrganizaƟon Nihilent Limited

Project name Nedbank Africa Regions (NAR) Regulatory ReporƟng Generic Business Model ModernisaƟon

Client name Nedbank, South Africa

DuraƟon Jan 2025 to present

Role Senior Data & Cloud Architect

ResponsibiliƟes Understanding Nedbank’s technology landscape and applicaƟons in detail.

CollaboraƟng with business leaders, system architects, product owners and stakeholders to assess requirements and design the soluƟon for NAR regulatory reporƟng for the bank.

SoluƟoning the target architecture for the modernizaƟon journey and presenƟng it to the bank’s technology execuƟves for their buy-in.

Carrying out POC projects where required.

OrganizaƟon J P Morgan Chase & Co.

Project Name 55ip

DuraƟon Jan 2022 – Dec 2024

DescripƟon 55ip is an automated tax technology that provides financial advisors with a tax-smart investment strategy engine. This project includes data delivery for different asset classes, saving advisors Ɵme and helping to drive beƩer outcomes for investors.

Domain Tax Management & Trading

Technologies Python, Airflow, AWS

Role Data Engineering Manager

ResponsibiliƟes Acquired ownership of maintaining the data plaƞorm for a trading applicaƟon with over $43 billion in assets under management.

Translated product feature requirements into data sourcing requirements.

Partnered with external and in-house data owners to provision market reference data (real- Ɵme & EOD batches).

Collaborated with data vendors to track and solve data quality issues.

Conducted code reviews for ETL pipelines for sourcing data.

Maintained the source market reference data for various financial instruments in the North America region from disparate data vendors such as Bloomberg, FactSet, Morningstar, Barra etc.

Helped modernize the applicaƟon by migraƟng the data pipelines from on-premises infrastructure to AWS.

OrganizaƟon J P Morgan Chase & Co.

Project Name Cards Datawarehouse

DuraƟon Dec 2016 – Dec 2021

DescripƟon The project defined rules for the real-Ɵme decision-making process whenever a customer swipes a card. It loads transacƟonal data (batch & real-Ɵme) to the warehouse for analyƟcal purposes. Domain Consumer Banking

Technologies Ab IniƟo ETL, Teradata, Oracle, Hadoop, Hive Role Tech Lead

ResponsibiliƟes Assessed Real-Ɵme acquisiƟon of transacƟon data from card purchases on all channels (POS, online) for JPMCs retail business in the US.

Aided in applicaƟon modernizaƟon to design and introduce Hadoop, Hive, AWS, KaŅa, and CI/CD.

Enabled data delivery and consumpƟon for generaƟng fraud alerts, credit scores, customer offers, payment, and collecƟon reports.

Simulated customer journeys and validaƟng the updates in transacƟon decisioning rules thereby improving customer experience at the Point-of-Sale terminals.

OrganizaƟon Accenture Services Pvt. Ltd.

Project Name NewCo Data MigraƟon

Client Name Vodafone UK

DuraƟon Nov 2012 – Dec 2016

DescripƟon The project aimed to migrate data from distributed legacy systems to an integrated target system for Vodafone’s UK business. The migraƟon to an integrated target improved operaƟonal efficiency, markeƟng, and customer experience for end users. The applicaƟon migrated data for the enƟre customer base for the end client (30+ million) – Prepaid, Postpaid, MVNO etc.

Domain TelecommunicaƟons

Technologies Ab IniƟo ETL, Oracle

Role Development & MigraƟon Lead

ResponsibiliƟes Responsible for data modelling, creaƟng mappings, reviewing, and developing complex code that includes Ab IniƟo, SQL, and Shell scripƟng.

Collaborated as Lead Contributor on the design of the proposed data integraƟon soluƟon involving mulƟple streams and countries.

Responsible for implemenƟng and driving conƟnuous opƟmisaƟon in the development team.

Liaised with different teams and stakeholders to get a clear picture of the requirements and deliverables.

Led the team to complete the development in 55 days ahead of the 70-day deadline.

Led data migraƟon stream for migraƟng Vodafone Post pay and Enterprise customers from Legacy Systems (OldCo) to NewCo.

Resolved complex issues during short Ɵme window of migraƟons.

Reduced execuƟon Ɵme of migraƟon applicaƟon by 40% through opƟmisaƟon techniques and adding parallelism while aligning table keys; received recogniƟon from top management for this.

Managed Ab IniƟo projects including conƟnuous and batch graphs. OrganizaƟon Wipro Technologies

Project Name Client Level Asset Servicing

Client Name Union Bank of Switzerland

DuraƟon Jun 2007 – Nov 2012

DescripƟon The project focused on providing development and maintenance support to a 3-Ɵer payments applicaƟon which is also used by the bank’s other internal applicaƟon as an accounƟng system. It is also used for reporƟng the accounƟng entries further to downstream systems for actual v/s implied reconciliaƟons. The changes to the applicaƟon are made through a quarterly release cycle that strictly adheres to SDLC. It also covers the post-implementaƟon producƟon support (L3).

Domain Investment Banking and Wealth Management

Technologies Ab IniƟo, Oracle, Perl, Shell scripƟng, Autosys Role Developer

ResponsibiliƟes Managed Ab IniƟo projects including conƟnuous and batch graphs which used most of the components available in the library.

Hands-on experience with DML files, XFR files, re-usable components (MPC), DBC files, air (EME) commands, ‘m_’ (co- operaƟng system) commands, graph parameters, project parameters, recovery files, lookup files, start and end scripts, and phased graph execuƟon.

Handled different file formats within the graphs such as XML, fixed length, and delimited.

Performed EME administraƟon including branch creaƟon, tagging, EME & GDE license management, and EME backups.

Contact this candidate