Senior Software Engineer

June 2011 - September 2015

Worked as Senior Software Engineer in Consumer Center Banking Project . Consumer Center is customer facing credit card application for the Synchrony Bank merchants care credit card. It’s an OLTP application, using Oracle 11g as database. The consumers are from US. The history data analytics happen on data warehouse build in Teradata DB.

​

Roles:

# Involved in the development of the user statements (eBill Module) & payments processing module this is part of Consumer Center Application on Oracle & tera data data bases using # SQL Plus model mini Database for customer OLTP.

# Schedule jobs in sever using Autosys scheduler and DBMS scheduler.

# Develop ETL workflows using Oracle Data Integrator , PLSQL DB Coding, UNIX shell script & java Handle inbound & outbound transformation using ODI to data warehouse

# Monitor the Production DB Jobs and Unix server batch Jobs daily.

# Do code versioning in Jenkins and deployment using u-Deploy.

# Tune the long running SQL queries using explain plan reports.

# Incident Management - Resolving Incidents tickets and defects with severity 3 and 4.

# Coordinate Release Management with development teams