VENKATSAI MANDAVA
Windsor,Canada
Summary
At Mastercard, I spearheaded the enhancement of ETL pipelines, boosting efficiency by 25% and integrating cutting-edge Snowflake data warehousing. My collaborative efforts in developing the Consumer Clarity and Merchant Fraud Insights products underscore my adeptness in Python and SQL, alongside my strong problem-solving and communication skills.
Overview
2
2
years of professional experience
Work History
Data Engineer
Mastercard
NORTH YORK, Canada
09.2022 - Current
- Designed and optimized ETL pipelines to process and transform large-scale data across multiple stages, improving processing efficiency by 25%.
- Managed data storage solutions using Azure Blob Storage, ensuring secure and efficient file handling.
- Utilized Snowflake as the primary data warehouse to support analytics and reporting for multiple projects.
- Automated ETL workflows and deployments using Jenkins, reducing deployment time by 30%.
- Developed Power BI dashboards to present actionable insights to stakeholders, enabling proactive decision-making.
- Maintained code repositories in GitLab, ensuring streamlined collaboration and version control.
- Key Projects:
- 1
- Consumer Clarity Product.
- - Played a pivotal role in designing data pipelines for Consumer Clarity, a Mastercard product that empowers customers with detailed insights into their credit card transactions.
- - Integrated machine learning models to detect anomalies in transactions, enhancing fraud detection and transaction validation capabilities.
- - Improved transaction processing efficiency by leveraging Snowflake's scalable architecture and advanced query optimization features.
- - Enabled real-time data visualization via Power BI, allowing financial institutions to offer detailed transaction breakdowns to their customers.
- 2
- Merchant Fraud Insights.
- - Contributed to the development of Merchant Fraud Insights, a tool designed to help merchants identify and mitigate fraudulent activities in real time.
- - Designed and implemented robust ETL pipelines to ingest and analyze merchant transaction data across multiple regions.
- - Enabled the creation of detailed fraud patterns and predictive insights by integrating large-scale data analytics with machine learning models.
- - Collaborated with cross-functional teams to ensure seamless data integration and the delivery of actionable fraud detection insights for merchants.
Education
Bachelor of Technology - Electronics and Communication Engineering
KL University
Andhra Pradesh, IndiaSkills
- Snowflake Data Warehousing
- Azure Blob Storage Management
- ETL Pipeline Management with Jenkins
- Python and SQL Development
- Reporting Tools: Power BI
- Version Control: GitLab
- Cloud Platforms: Microsoft Azure
- Problem-Solving
- Collaboration
- Communication
- Time Management
- Data warehousing
Hobbies and Interests
- Data Science and Machine Learning
- Innovations in Financial Security
Languages
English
Professional
Telugu
Native/ Bilingual
Timeline
Data Engineer
Mastercard
09.2022 - Current
Bachelor of Technology - Electronics and Communication Engineering
KL University
Similar Profiles
Vishal AmbhoreVishal Ambhore
Big Data Hadoop Developer at MastercardBig Data Hadoop Developer at Mastercard
Niall McLoughlinNiall McLoughlin
Customer Technical Analyst II at MastercardCustomer Technical Analyst II at Mastercard
Sunil BanyalSunil Banyal
Software Engineer II at MastercardSoftware Engineer II at Mastercard