Data and Analytics - Lead Capability Architect for Data Engineering, Data Governance, Cloud Data Solutions, Enterprise Data Standards, Trusted Access Platform, AI/ML Governance, Tools Rationalization, Data Consolidations, New Value Products and Enterprise-wide transformation initiatives.

Privacy Program – Data Engineering, Consolidation and Governance Program (CPRA/CCPA/GDPR Data Compliance)Led and driven the Data Governance and Engineering team on the ETL/ELT Design, Development and Data pipeline Architecture building on a large scale cloud migration - On-prem as well as Public cloud (hybrid cloud). Worked extensively on the cloud platforms comprising of Data Lakes, Data Privacy, Metadata management (Data Profiling, Catalogs, Data Dictionaries), MDM, Data Mesh and Data Stewardship.Implementation done using various technologies like AWS (Glue, Redshift, Kinesis, S3, S3 Glacier, Cloudwatch etc.,), Big Data Hadoop, Hive DB, Teradata, SQL Server, Databricks, Python, Apache Pyspark, Query Fabric (Trino/Presto), Kubernetes, Docker, Airflow, MINIO, Alteryx, Tableau, Looker, BTEQ, Spark SQL. Modernized the Data Governance framework using tools such as Apache Atlas, Microsoft Purview, Collibra DGC etc.,

Conferencing Tool – Application Data Engineering and GovernanceMajor Mobile Service Provider – Backoffice Data Engineering and Data QualityData Reliability EngineeringInternet Essentials – Product Development and Application Data EngineeringInteractive Troubleshooting Guides – Automated Workflow Data Development

• Architected the solution design for Workforce Administration Data rewrite from Mainframes DB2 to Oracle• Proposed and implemented the shadow data bases concept to meet the large-scale data volumes and orchestrating the ETL development using Informatica Power Center.• Presented and delivered long-term strategic goals for Application Architecture, Data Analytics, reporting and Data Governance in conjunction with key stakeholders.• Recruited and built the project team from scratch to accomplish successful project delivery at Program level.• Design and development of Data Modelling with Entity-Relationship diagrams and modeled Transactional Databases and Data Warehouses using Power Designer tool.• Development of complex ETL mappings including joiner, sorter, normalizer, update strategy, aggregator, lookup and filter transformations etc. using Informatica Power Center 10.1 to load data from DB2, Flat files to Oracle.• Responsible for the analysis of business requirements and design implementation of the business solution. Analyzed large amounts of data sets to determine optimal way to aggregate data and create report layer on it.• Highly comprehensive analytical reports generated by running SQL queries against current databases to conduct data analysis and profiling using tools such as Toad Data Point and Informatica Data Analyst.• Gathered and analyzed existing physical data models for in scope applications and proposed the changes to the data models according to the Data Standards requirements.• Expert level understanding of using various databases in combination for Data extraction and loading. Enhanced existing ETL transformations and jobs using Informatica.• Development of a Ready-Reckoner tool which provides cognitive services Knowledgebase and content sharing repository for new joiners in the team.

• Orchestration of Data Flow using Tibco Data Processing Tools such as Activematrix Adapter for Databases (ADB), Business Works (BW), Hawk and Administrator.• Involved in upgrading the applications to maintaining near real-time data with Mainframe systems. • Formulated the vendor data re-instatement process for the new route codes in major networks data provisioning applications.• Involved in development of re-sync scripts which is used to sync data between Mainframe and mid-range systems during disaster recovery (DR).• Monitoring and publishing the Fallout records in the Database (processed by TIBCO Bus Services) by manual corrections using SQL queries.• Involved in migration of applications from Solaris to Linux environment.• Administered and configured many TIBCO Business Works (BW) processes and sub-processes as part of the overall migration phase.• Used ADB adapters by configuring them using Designer to interact with the database.• Developed automation scripts/tools to reduce the manual work in start/stop data loading services.• Set up Monitoring process on correcting the corrupted records in the flat files of the network applications which fail due to delimiter discrepancies of the XML records.• Trained and groomed junior data engineers and analysts while onboarding them on the project environment.