Shibi Prabhu
Dindigul,TN
Summary
Results driven Integration Engineer at Omnicom with expertise in data integration and analytics. Skilled in SQL and Python, I excel at designing efficient pipelines and automating processes, enhancing data delivery speed. Proven ability to collaborate cross functionally, translating complex requirements into actionable insights, while optimizing performance and ensuring data integrity.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Integration Engineer
Omnicom
07.2024 - Current
- Pipeline Development: Design, develop, and deploy complex end-to-end integration pipelines using SnapLogic iPaaS to connect multiple source systems.
- Data Orchestration: Extract data from various sources (Salesforce, SAP, Greenhouse, CultureAMP etc.) and land it efficiently into endpoints like Azure SQL and Blob storage.
- Transformation & Mapping: Perform complex data transformations, ensuring that data is cleaned, formatted, and mapped correctly to meet target schema requirements.
- Discovery & Architecture: Participate in the initial project discovery phase to understand data structures and business logic before building technical solutions.
- Automation: Automate routine integration tasks, monitor pipeline health, and streamline internal workflows.
- Performance Optimization: Monitor and tune pipeline performance to ensure high-speed data delivery and minimal latency.
- Cross-Functional Collaboration: Work closely with Data Analysts and Business stakeholders to translate requirements into Dashboards (Power BI) and actionable data sets.
- Troubleshooting & Support: Act as the subject matter expert for integration errors, providing root cause analysis and resolution for pipeline failures in production.
Data Analyst
Ernst & Young
09.2023 - 03.2024
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Used statistical methods to analyze data and generate useful business reports.
- Utilized data visualization tools to effectively communicate business insights.
- Identified patterns and trends in large data sets and provided actionable insights.
- Assisted with creating data cubes improve data analysis.
- Developed Excel VBA scripts to automate most of the manual process
Web Content Writer
CheggIndia
07.2020 - 12.2020
- Developed and edited informative, highly engaging, concise content for company websites and social media platforms customized for target audiences and company campaign objectives.
- Researched to develop thorough understanding of unfamiliar topics, competitors, industries and processes to present fresh, new angles and ideas within written content.
Education
Master of Computer Applications -
RVS College of Engineering
Tamil Nadu, India04-2023
Bachelor of Arts - English Literature
PSG College of Arts And Science
Tamil Nadu, India04-2019
Skills
Data Integration
Data Manipulation
Data Analytics
SQL
Python
Certification
Alteryx Designer
Analyzing and Visualizing Data with Microsoft Power BI
Salesforce Administration
Timeline
Integration Engineer
Omnicom
07.2024 - Current
Data Analyst
Ernst & Young
09.2023 - 03.2024
Web Content Writer
CheggIndia
07.2020 - 12.2020
Master of Computer Applications -
RVS College of Engineering
Bachelor of Arts - English Literature
PSG College of Arts And Science