SIVA SARAN S
Bangalore,Karnataka
Summary
Results-driven Business Analyst with 1.2 years of experience in data management, data ingestion, and data engineering. Expertise in designing and implementing complex data pipelines for data migration, scalability, and data warehousing. Proven ability to optimize processes and deliver data-driven insights for global clients. Recognized for exceptional performance in enhancing business operations through data analysis and engineering solutions, leading to a promotion within a year.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Business Analyst
EXL SERVICES
11.2023 - Current
- Created 15 Source-to-Target Mappings (STTMs) and Unit Testing documents by engaging with clients to meticulously gather and refine business requirements.
- Developed ETL pipelines for data ingestion and storage, reducing processing time by 30% across 5 data sources.
- Migrated complex IBM DataStage jobs to Snaplogic, increasing pipeline efficiency by 25% and automating 90% of scheduling tasks using Tidal, reducing manual intervention.
- Managed Jira for ticket creation, assignment, and sprint reporting, improving workflow efficiency by 20% and reducing ticket resolution time by 15%.
- Optimized SQL query performance, resulting in a 30% reduction in data retrieval time for large datasets.
- Implemented Change Data Capture (CDC) triggers to optimize data handling processes.
- Designed and implemented dashboards in Tableau, improving user engagement and data insights by 40%.
- Utilized Power Query to clean, extract, and transform data, reducing processing time by 30% and improving data accuracy by 15%.Applied DAX measures to enhance reporting and deliver actionable insights.
- Extracted data from AWS S3, implemented AWS Glue pipelines, and streamlined it into Redshift for efficient data warehousing.
- Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.
Education
Bachelor of Engineering - ELECTRONICS & COMMUNICATION
NEW HORIZON COLLEGE OF ENGINEERING
Bangalore, India06.2023
Skills
- SQL
- Python Basics
- Jira
- Tableau
- Jupyter Notebook
- Power BI
- Office Tools
- AWS S3
- Glue
- Redshift
- Azure Databricks
- Data Factory
- Communication
- Requirements gathering
- Team collaboration
Certification
- Snaplogic Certified Enterprise Automation Professional
- Spanish for Beginners
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Telugu
Bilingual or Proficient (C2)
Kannada
Upper intermediate (B2)
Accomplishments
•Migrated IBM DataStage pipelines to SnapLogic, reducing
processing delays by 35 hours weekly and enhancing overall ETL efficiency.
•Troubleshooted timestamp mismatches in data extraction by refining SQL queries which resulted in data extraction as well as a reduction in data processing time by 40% and overall error reduction during migration by 25%.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Software
AWS Redshift
Power BI
Timeline
Business Analyst
EXL SERVICES
11.2023 - Current
Bachelor of Engineering - ELECTRONICS & COMMUNICATION
NEW HORIZON COLLEGE OF ENGINEERING
Similar Profiles
Mohini SinghMohini Singh
Senior Fraud Risk Analyst at Exl ServicesSenior Fraud Risk Analyst at Exl Services
PRIYANSHI TIWARIPRIYANSHI TIWARI
Manager, Credit Risk Management at EXL ServicesManager, Credit Risk Management at EXL Services
Rubi YadavRubi Yadav
Team lead at business operations at EXl ServicesTeam lead at business operations at EXl Services
Vijay Narasimha Reddy ThathireddyVijay Narasimha Reddy Thathireddy
Consultant at Capgemini Technology ServicesConsultant at Capgemini Technology Services
MOHAMED MUEENMOHAMED MUEEN
General Manager - Operations & Sales at Drive XGeneral Manager - Operations & Sales at Drive X