About Me
- Around 6.11 Years of experience in PL/SQL ProductionSupport and Development of web-based applications using Oracle 10g / 11g
- Good experience in writing co...
- Good experience in writing complex SQL queries, PL/SQL stored procedures, functions, packages, cursors, views and triggers
- Knowledge in writing codes for Performance Tuning
- Good work experience in tools like Control-M, Autosys, Aqua Data Studio, SQL Server Management Tool, TOAD, SQL Developer, MITTS, BMC Remedy, Putty, WinSCP
- Extensive experience in Production Support Environment
- Proactively and Independently working on resolving issues
- Providing support to clients on 24/7 basis
- Proactively resolving batch job failures
- Possessing good project team work, communication and interpersonal skills
- Holding Business (B1) Visa
Skills
Software Engineering
Database
Operating System
Others
Web Development
Programming Language
Positions
Portfolio Projects
Company
Harmony
Role
Analysts (Non programmer role)
Description
- Worked on Oracle Tables, Views, Constraints, Synonym, Sequence, Procedures, Functions, Packages, Cursors and Performance Tuning
- Providing Support in L2 & L3 levels
- To meet Client's SLA depending on priority of issues
- Monitoring loading of feeds and matching logs till completion of breaksheets
- Responsible for Holiday Processing of feeds and swifts on any region holiday
- Investigating true/false breaks participating in breaksheet(s)
- Monitoring Control - M jobs, SRS tickets & Job and System Alerts
- Providing permanent or temporary fixes for job failures
- Providing support on 24/7 basis
- Responsible for working on SRS tickets and completing it on SLAs defined
- Performing testing of new feed-breaksheet mapping and prepare test cases
Tools
Data studioCompany
Mortgage Bankin
Description
- Worked on Oracle Tables, Views, Constraints, Synonym, Sequence, Procedures, Functions, Packages, Cursors and Performance Tuning
- Worked on Hive queries and transferring files using Sqoop
- Providing Support in L2 & L3 levels
- To meet Client's SLA depending on priority of issues
- Responsible for scheduling jobs and monitoring the log files
- Monitoring Control - M jobs, Jira tickets and Job Alerts
- Providing permanent or temporary fixes for job failures
- Writing batch scripts for generating reports and sending to end users through jobs
- Providing support on 24/7 basis
- Responsible for working on Jira tickets and completing it on SLAs defined
- Implementing ITSM for Production Code fixes and Control - M deployment
- Performing Unit Testing and preparing documents for the same
- Syncing the lower environments with the current Production scripts
- Responsible for completing EOM activities spanning from BD-2 to BD+8
Tools
ToadCompany
Soho-AM
Description
- Worked on Oracle Tables, Views, Constraints, Synonym, Sequence, Procedures, Functions, Packages, Cursors and Performance Tuning
- Providing Support in L1& L2 levels
- To meet Client's SLA depending on priority of issues
- Responsible for scheduling jobs and monitoring the log files
- Monitoring Control - M jobs, MITTS tickets and Job Alerts
- Providing permanent or temporary fixes for job failures
- Writing batch files for transfer of files through jobs
- Providing support to clients on 24/7 basis
- Providing On-Call support in Weekends
- Performing Unit Testing and preparing documents for the same
- Refreshing the test environment with the current Production data
Skills
SQL Server 2000Tools
SQL Developer