Johnson & Johnson

I worked on the migration of commercial and consumer data from Oracle DB at Johnson & Johnson to the Azure cloud using Kenvue. This involved restructuring database tables to optimize data storage and accessibility. As part of this migration, I developed a new dashboard using Power BI to visualize and analyze the migrated data, enhancing business insights and decision-making capabilities.

Subsequently, I transferred the database from Azure Synapse to Snowflake to further improve performance and ensure data continuity. This transition involved optimizing data processing and query performance, leveraging Snowflake's capabilities for efficient data warehousing and analytics. The migration to Snowflake resulted in enhanced data scalability, reliability, and accessibility, supporting critical business operations and strategic initiatives

META (Facebook)

In the Meta project, our primary focus was to enable business partners to leverage the META platform for targeted advertising campaigns. We facilitated customer reach, response tracking, and provided tools for effective business marketing. By integrating business partners onto the META platform, we aimed to optimize customer engagement, enhance response rates, and empower businesses to market their products and services more effectively to their target audiences. This involved implementing analytics and reporting features to monitor campaign performance, measure customer interactions, and improve overall marketing strategies for our business partners.

I worked on the reconstruction of the Small Business Group (SBG) pipeline, focusing on optimizing code readability and reducing execution time. This involved streamlining and refactoring the existing pipeline codebase to improve performance and efficiency.

As part of this project, I validated Hive tables to ensure data accuracy and consistency, resolving any discrepancies or errors that impacted reporting and analytics. Additionally, I addressed issues in Tableau dashboards by identifying root causes and implementing necessary fixes to enhance data visualization and reporting capabilities for stakeholders. This work contributed to a more robust and reliable data infrastructure supporting business operations and decision-making within the SBG.

Tata Consultancy Services

I embarked on my professional journey at Tata Consultancy Services (TCS) as a SQL Developer, where I collaborated closely with a leading UK Banking and Financial client. In this role, my primary responsibilities centered around database maintenance, performing CRUD operations, and conducting rigorous validation of database tables to ensure data accuracy and efficiency.

As I gained proficiency in database management, I transitioned to a Data Analyst position, leveraging tools such as Excel, Tableau, and SQL to develop dynamic business dashboards and reports. This phase of my career deepened my interest in emerging cloud technologies, prompting me to pursue further learning in AWS and Azure alongside on-premises technologies like Hadoop, MapReduce, and Hive.

Motivated by my growing expertise in cloud platforms and big data technologies, I subsequently transitioned to a Data Engineer role. Here, I architected and optimized robust data pipelines using AWS, Azure, and Hadoop technologies, enabling scalable data processing and advanced analytics capabilities.

Throughout my tenure at TCS, I demonstrated a strong commitment to driving innovation and leveraging cutting-edge technologies to deliver impactful solutions that meet business objectives and drive operational efficiency.

Sample Dashboard Reports

Here is a collection of Tableau and Power BI dashboards that I developed during my time at the University of Cincinnati as part of my curriculum and various projects

• View Projects