“Flight Schedule and Data Analytics” is a project initiated by Airman Flight Training LLC to develop areporting and dashboarding interface and a data integration layer to encompass, collate and harmonize data from variousbusiness areas like eBook Scheduling, Onboarding Training, Ground School, Flight School, Billing & Accounts.Roles & Responsibilities:• Developed comprehensive data models to facilitate efficient data retrieval, storage, and analysis, enhancing the reporting and dashboarding capabilities for business areas including eBook Scheduling, Onboarding Training, and Accounts.• Directed the Data Engineering team, overseeing task coordination and ensuring project outcomes aligned with business goals and met SLAs.• Led ETL operations utilizing Azure Data Factory and Azure Synapse, ensuring high-quality data integration and transformation workflows.• Directed the Data Engineering team, coordinating tasks, and aligning project deliverables with stakeholder expectations and SLAs.• Engaged in active requirement gathering, analysis, and strategic planning to align project outcomes with long-term goals.• Managed stakeholder relationships, ensuring their strong engagement and satisfaction with the delivered solutions.• Designed and implemented data warehousing solutions using Azure Synapse, ensuring adherence to both star and snowflake schema best practices to support complex business intelligence reporting.• Gained hands-on experience with PowerBI, Azure Databricks, managing data within ADLS Gen2 and Blob storage efficiently.• Developed and optimized Azure Data Factory pipelines to support incremental data loading processes.• Authored T-SQL scripts to enhance database functionality, including tables, views, and stored procedures.• Created Spark applications using PySpark and Spark-SQL to refine ETL processes and data analytics.• Utilized Git for source code management, adhered to CI/CD principles for deployment, and used Power BI for reporting.

Description: Unilever, headquartered in London, England, is a leading British multinational consumer goods company and the world's top soap producer. With products available in about 190 countries, Unilever owns over 400 brands and reported a turnover of €60.7 billion in 2020. The company is structured into three main divisions: Foods and Refreshments, Home Care, and Beauty and Personal Care.Roles & Responsibilities:• Led Azure Data Factory ETL operations, streamlining data integration and transformation workflows, while incorporating Azure Synapse for advanced data modeling and analytics.• Managed system migrations to Azure, overseeing daily operations to ensure seamless cloud transitions and optimizing data processing efficiency.• Lead a team, coordinating tasks, and ensuring deliverables met SLAs and stakeholder requirements, with a focus on Azure Synapse integration and dimensional modeling.• Implemented cloud-based architectural designs, enhancing system scalability and integration, with a specific emphasis on Azure Synapse for data warehousing and analytics.• Designed Azure Data Factory pipelines, integrating SQL Data Warehouse and Blob Storage for efficient data processing, leveraging Azure Synapse for dimensional modeling and analytics.• Leveraged Azure Databricks for ETL process enhancement, reducing processing times by 30% and integrating with Azure Synapse for streamlined data processing and analytics.• Pioneered the migration of data workloads to Snowflake, leveraging its scalable compute and storage capabilities to handle high volume and velocity data.• Optimized data integration and transformation workflows for the Snowflake environment, achieving significant improvements in performance and cost savings due to Snowflake's unique architecture.• Designed and Implemented dimensional modeling best practices within Azure Synapse, ensuring optimal performance and scalability of analytical workloads.

Description: Royal Bank of Canada (RBC), Canada's largest bank by market capitalization, serves over 17 million clients globally with a workforce exceeding 89,000. Its Data Quality initiative aims to enhance data accuracy, timeliness, and completeness across all entities.Roles & Responsibilities:• Led data integration projects using Azure Data Factory, transitioning databases to Azure Data Lake and Snowflake, ensuring seamless cloud migration.• Designed database systems within Azure SQL Data Warehouse and Azure SQL, leveraging cloud scalability.• Managed legacy system migrations, maintaining data integrity across business domains during transitions.• Developed ETL processes using Microsoft SQL Server, SSIS, SSRS, and SSAS, setting modern data platform standards.• Utilized Azure Databricks notebooks in PySpark, Scala, and SparkSQL for dimensional modeling in ADLS, boosting warehousing functions.• Enhanced CI/CD pipelines and governance with Azure Purview, automating development and deployment.• Implemented Azure Logic Apps for pipeline outcome notifications, streamlining project management.• Led proof of concept projects for web and REST APIs, enhancing data platforms with analytics and visualization tools.• Promoted innovation by developing reusable code, employing Azure Databricks, and Power BI for efficient data processing and reporting.• Integrated Snowflake into workflows, leveraging its features to improve warehousing and analytics.

Boots Pharmacy UK, a leader in healthcare and pharmacy services, focuses on streamlining operations and enhancing data management.Roles & Responsibilities:• Developed UNIX scripts for automating Informatica PowerCenter workflows, ensuring database health and efficient data integration, critical for maintaining high service standards.• Crafted shell scripts for ETL audit table management, prioritizing data integrity across pharmacy operations.• Optimized Informatica mappings and database designs for scalability, ensuring seamless data flow essential for pharmaceutical management.• Implemented ETL solutions with Informatica PowerCenter, handling diverse data formats and employing bulk processing for large datasets, crucial for inventory and sales data analysis.• Advanced SQL and T-SQL routines improved MS SQL Server's data processing, supporting sales trends and customer analysis.• Transformed Excel and Word documents into XML using Informatica PowerCenter, streamlining regulatory compliance and reporting.• Managed the PowerCenter environment, overseeing user access and system configurations, aligning with operational excellence and security standards.• Led QA and deployment phases, establishing protocols for successful data management initiatives, demonstrating a commitment to accuracy and service delivery.• Integrated Autosys for automated ETL job scheduling, aligning technical processes with business needs, ensuring uninterrupted services.

Employed as an Informatica ETL Developer at Tesco, UK from November 2010 to January 2012, I undertook the following responsibilities:* Developed Stored Procedures, Functions, and Synonyms as per project requirements.* Designed and developed Informatica PowerCenter Mappings, Mapplets, Tasks, and Workflows.* Utilized bash shell scripting alongside PowerCenter pmcmd command for workflow scheduling via Autosys.* Conducted requirement studies and prepared field-level mapping documents for seamless data integration.* Implemented Slowly Changing Dimensions (SCD).