Rameshwar Tupe
Summary
Technical and Business Operations Analyst with over 4 years of experience in data warehouse management and optimization. Specialized in Snowflake, Teradata, and Informatica PowerCenter, with a strong focus on developing efficient ETL/ELT pipelines. Automates data processes through Linux scripting and implements data integration workflows to enhance performance.
Overview
4
4
years of professional experience
Work History
Technical & Business Operations Analyst
Amdocs Development Center India LLP
Pune
07.2023 - Current
- Maintained the Enterprise Data Warehouse, ensuring accurate, reliable, and available data for business operations.
- Developed ETL scripts using SnowSQL for Snowflake and Vertica to support data integration tasks.
- Automated ETL workflows using IBM Tivoli Workload Scheduler, improving operational efficiency and reliability.
- Analyzed and resolved ETL and data pipeline issues to ensure smooth and uninterrupted data processing.
- Monitored and supported Infoworks pipelines and performed Databricks transformations, ensuring timely execution and resolving failures proactively.
- Created automated daily monitoring and reporting scripts using Unix shell scripting (FS alerts, bad‑record handling scripts,daily monitoring script, etc.).
- Managed and prioritized ticket queues, resolving customer requests and incidents promptly.
- Debugged and optimized Informatica PowerCenter mappings and workflows.
- Performed system administration and troubleshooting in Linux using PuTTY, MobaXterm, and Xshell.
Software Engineer
Tech Mahindra
Pune
09.2021 - 07.2023
- Utilized SQL, Linux, Unix Shell scripting, TWS, ETL, and Teradata for data transfer between Finance and AOTS systems.
- Monitored SLA jobs in Teradata, Oracle, and Vertica databases, promptly creating trouble tickets for failures.
- Resolved trouble tickets created by Clients and other downstream teams.
- Ensured timely resolution of issues within agreed service level agreements.
- Oversaw ticket queue, assigning tasks to relevant teams to facilitate efficient issue resolution.
- Conducted ticket analysis, service interruption analysis, and triaged issues while coordinating with relevant teams for resolution.
- Assessed server space utilization to optimize performance.
Education
Master of Science - Master of Computer Application
PROGRESSIVE EDUCATION SOCIETYS MODERN INSTITUTE
Pune04.2022
Bachelor of Science - COMPUTER SCIENCE
New Arts, Commerce And Science College
04.2020
HSC - Kukana, india
New English School
Kukana, india04.2017
Skills
- Data integration
- Data warehousing
- Informatica
- MySQL
- Snowflake
- SQL Developer
- Tivoli Workload Scheduler (TWS)
- Mputty
- Operational Efficiency
- Technical support
- AOTS
Project Overview
Enterprise consolidated data ware houses(ECDW)
Supported initiative by ensuring stable 24×7 operations across the ECDW ecosystem, which serves as a central enterprise hub for data ingestion, reporting, and downstream analytics.
Role summary:
As a Technical & Business Operations Analyst, I contributed to maintaining production stability, monitoring data workflows, supporting incident resolution, and ensuring uninterrupted availability of the ECDW environment. I supported automation initiatives, collaborated with cross‑functional teams, and ensured smooth operations across multiple data ecosystems.
Key Responsibilities & Contributions:
- Ensured stable 24×7 operations of ECDW.
- Monitored ETL workflows using Informatica and job schedules via TWS to maintain pipeline health.
- Investigated workflow failures, performed initial RCA, and supported timely issue resolution.
- Managed service requests and change requests with SLA compliance.
- Created automation scripts for FS alerts, health checks and operational tasks to reduce manual effort.
- Delivered daily, weekly, and monthly reports and communicated issues to stakeholders.
- Performed regular system health checks including server status, database checks, and disk‑space monitoring.
- Collaborated with upstream/downstream teams and supported deployments, maintenance windows, and outage activities.
DECLARATION
I hereby declare that all information furnished in this document is genuine.
Timeline
Technical & Business Operations Analyst
Amdocs Development Center India LLP
07.2023 - Current
Software Engineer
Tech Mahindra
09.2021 - 07.2023
Master of Science - Master of Computer Application
PROGRESSIVE EDUCATION SOCIETYS MODERN INSTITUTE
Bachelor of Science - COMPUTER SCIENCE
New Arts, Commerce And Science College
HSC - Kukana, india
New English School