Software Engineer Data Integration

Omkar Maruti Sutar

Email : ***********@*****.*** Contact : +91-965*******

Expertise : PL/SQL and ETL developer (Immediate Joiner) LinkendIn : https://www.linkedin.com/in/omkar-sutar-0288851a7/ Technical Skills :

Oracle and Postgresql procedural programming

SQL Loader implementation and DBMS

Unix Shell Scripting, Crontab

ETL Job Automation

Data Modeling, Data Cleaning & Processing

Tools used : DBever, Putty, Jira, Data Integration, Microsoft Excel Work Experience

Aurus Tech Private Limited, Hinjewadi - Associate Software Engineer Aug 22 - Present

• Developed and maintained ETL pipelines using Pentaho Data Integration (Kettle) for business- critical reporting and data warehouse applications.

• Reduced the cost involved in running customer reports service by more than 80% by devising an automated system that identified and disabled reports with no usage or empty data.

• Proficient in writing complex SQL queries, stored procedures, triggers, functions, and cursors for business logic implementation and data processing.

• Collaborated with internal teams and clients to gather requirements and ensure accuracy in solution delivery.

• Handled production incidents, monitored job performance, and optimized database and ETL performance.

Pofile Summary :

• Involved in development with all stages of system development Life Cycle

• Design and optimized complex sql queries, Stored procedures, Functions and Packages to improve system performance

• Proficient in writing complex SQL for business logic, data extraction, transformation, and loading.

• Created Dynamic pl/sql scripts to construct and execute sql statements dynamically

• Analyzed Explain plans and restructured sql queries resulting in faster data retrieval

• Expertise in scheduling and automating tasks using DBMS Scheduler

• Involvement in fixing production problems in regards to sql and pl/sql.

• Collaborates effectively with cross-functional teams, including QA, analysts, and client-facing teams.

• Worked on SQL Statements DDL, DML, DCL.

• Worked on SQL set operator, joins, constraints, view, materialized view.

• Skilled in Debugging and testing pl/sql code to ensure accurate and efficient execution. ROLES AND RESPONSIBILITY

• ETL Development & Optimization

• Report Automation

• Job Scheduling & Monitoring

• Incident Management

• Cross-Functional Team Collaboration

• Documentation & Compliance

PROJECTS

1. Reconciliation Report

• Provided transaction-level transparency across POS, Processor, and Aurus systems to help clients validate global sales.

• Implemented logic to categorize discrepancies by Card Type, Transaction Type, etc., enhancing transaction accuracy.

• Technologies Used: Kettle (Spoon), PostgreSQL, Oracle, Crontab, Unix Shell Scripting, AEDTP server. 2. StorePlace Cloud Product

• Developed features for the Virtual Terminal, enabling users to perform operations like Sales, Pre- Auth, Void, Refund, Gift Card Activation, etc.

• Contributed to generating business analytical reports, including daily summaries and trends. ACHIVEMENTS

Employee of the Month - Reconciliation Reports : Recognized for exceptional performance in executing reconciliation report tasks efficiently within production hours

Contact this candidate