Architected event-driven data pipelines for the advertising attribution platform using CDC ingestion, Kafka event streams, and Flink stream processing, delivering analytics-ready datasets into Snowflake for real-time campaign performance insights.

• Sentiment Analysis of 6000+ tweets and mails to identify wedge-driven sentiment from Boston Bombing data

• Content Analysis and data coding of 3000+ Phishing mails to decipher risk communication patterns

• Running statistical analysis using regression model on the filtered data to understand the behaviour regarding different phishing mails.

• Interacted with mutiple stakeholders to gather and analyse end user requirements

• Developed SQL queries, joins and procedures to extract, transform and validate between source and target in Oracle database

• Designed test strategy, test plan and test cases using HPQC for system testing, regression testing and System integration testing.

• Identified and removed unwanted data, optimized queries and procedure to improve system performance

• Coordinated with multiple stakeholders (client, development and support teams) and resolved conflicts and open items on daily basis.

• Led team of four associates in finance modules of data migration requirement.

• As a SME(subject matter expert) for Financial Reconciliation activity, audited test techniques implemented across various modules.

• Performed end-to-end test management and defect management.

Key Competencies and skills learned

• Team Management

• Customer Management

• Business analysis

• Software Development Life Cycle

• Knowledge Transfer Process

• Quality Assurance