Career Summary
I have 1 yr ofsaa technical experience.
• I have Total 6.3 years of experience.
• I have worked in Mainframe COBOL ,ORACLE SQL, PLSQL, UNIX Development and Enhancement for 2.3 Years (15-Mar-2016 to 19-Jun-2018).
• And total 5.3 years’ experience in Oracle PLSQL, SQL development and Enhancement.
• Currently working with Bahwan CyberTek as Senior Software Engineer1 (Oracle PLSQL, SQL) from 22th Oct to till date.
• Worked with Dell international services India pvt ltd as Software Engineer-1 (Oracle PLSQL, SQL) from 24th Jun 2019 to current.
• Worked with US based IT company PMAM It services ltd, as a Technology Specialist (Oracle PLSQL, SQL) from 20-Jun-2018 to 31st May 2019.
• Worked with Cedge Technologies Ltd (Joint venture of SBI and TCS) as an Assistant System Analyst (Oracle PLSQL + Mainframe COBOL + UNIX) from 15-Mar-2016 to 19-Jun-2018.
Key Responsibilities
• Worked on to make cursor, Function, Procedure and Packages etc.
• Needs to work on COBOL development and some Unix scripting.
• As per requirement done bulk update thru cursor.
• worked on ORACLE SQL joints, mostly Equi join or inner join.
• Also used wm_concat, Extract value, Dbms_lob functions in daily routine.
• Worked on Join, Views, Union , Union All , Minus , Constraint Etc...
• Hands on experience on Composite data types, scalar, reference, lob data type.
• Hands on experience on composite data type Associated Array, Nested table, V array .
• Bulk collect has also used to extract large data.
• Wrote test cases and performed Unit testing.
• Updated Python for making rule for Policy document generation.
• Worked on code fix in PLsql, root cause, analysis, escalation etc.
• Procedure , function , package corrected as per requirement .
• Enhancement in code level , including whole procedure write as per requirement .
• As per business requirement written sql script , modified existing big sql script.
Software Proficiency
ORACLE PLsql, SQL, Basic Unix, Python .
Mainframe COBOL, JCL, DB2
Tools
• BANCS-24 software UI Application.
• GAMA (Global Account Management Admin) UI Application.
• DSA (Data Steward Application)UI Application.
• Argo PI UI Application.
• EWS (Early signal warning) UI Application.
• Oracle DB version 12c .
• SQL Developer tool, SQL Plus, PUTTY, Toad etc. Database
• Notepad++, Edit plus++ etc.
• SFTP , Task scheduler .
• BN COMPARE, VI Editor, Excel, Web Services, Soup UI
• Service Now Ticket System
• Microsoft teams, Skype, Zoom etc.
• Gitlab, Rapid deployCode Deployment Application