Expertise in Designing and developing data processes to extract data from various sources, transform it, and load it into target systems.Proficient in writing complex SQL queries and stored procedures,functions,triggers.Developed Python tools to automate data transforming & file handling & maintaining client data.Experience in Client data onboarding that includes users,products,transactions file and data analysis and load to the Database.Strong expertise in Unix/Linux File handling and scripting and scheduling through cron job.Collaborating with business analysts and stakeholders to gather requirements and understand data integration needs.Conducted code reviews, identified potential bugs, and implemented necessary enhancements to improve application performance and maintainability.Optimized database queries and improved database performance by implementing query optimization techniques.Utilized version control systems (Git) to manage source code, branches, and deployments.Actively participated in daily standup meetings, sprint planning, and retrospective meetings to ensure project goals were met on time.

Experience in automating the Sql Queries through Python, PostgreSQL, Shell Scripting in Unix & Linux Servers (Sequence of query executions used in Operation Team).Expertise in developing Shell programs(.sh) in Unix Server & involved in Migration of Shell programs from Unix to Linux Server.Experience in scheduling jobs in Unix Server to trigger the tasks automatically with the daily/weekly frequencies using cron job.Working knowledge in SQL,PSQL and expertise in manipulating the data using SQL Queries in DB manually or using programs.Familiar with Unix & Linux Server Commands and used on a daily basis.Experience in storing the codes in BitBucket & tracked the process using JIRA.Expertise in handling large amounts of data and performed Data Analysis over Millions of markets by filtering through SQL Queries based on the customer requirements.Experience in writing stored procedures using PLSQL for the ftp process and also minimized the usage of manual query executions in the project using PLSQL.Handled PostgresDB & Good knowledge in PostgreSQL. Worked on E2A loading of data to the tables from flat files from Unix/Linux or local machines.Experience in taking backup of the tables weekly before production runs and managing DB with zero production issues.Experience in troubleshooting a production issue (Severity 1 to 4) and fixing it on time.Experience in executing the process tasks & stored procedures within the specified time given and sent the report to Clients.Created & Tracked the major incidents through ServiceNow and prioritized it based on the severity of the issue & tracked them to completion.Worked in US Shift for more than 3 years to align with Customers & Operations Team.Scheduled team meetings to understand the problem & summarized the Root Cause Analysis (RCA) to rectify the issues.