- Proactive, dedicated, business - savvy and responsible team player with hands on experience in software Development.
- Experience in Pl/Sql, sql on Oracle, MySQL and sql server Database.
- Experience in Shell Script on Linux Platform.
- Experience in Reporting and Reconciliation on BI Publisher, Jasper Studio and Intellimatch.
Language: Sql, Pl Sql
Database Query Language: Sql
Scripting Language: Shell Script
Tools: Japer studio(6.2.0) for Reports, Intellimatch(9.1 version ) for automatic reconciliation, BI publisher, sql yog, sql developer
Operating System: Windows & Linux
Revision Controllers: SVN
Database: MySQL, Oracle,Postgres,sql server
Senior software Developer
- Gathered business requirements, individually handle and deliver them to business teams. And convert them into procedures, queries, reports or data reconciliation as per requirement for Confidential Project.
- Actively supported Business users for change requests and provide support to team members.
- Daily reconciliation of Confidential bank data on intellimatch tool and creating several reports based on result on BI publisher and jasper.
- As Confidential converts into Confidential, support the team in migration of oracle database on flex cube Build multiple complex queries, procedures, reports and script.
- Created and Developed shell scripts to call procedures, to create and copy dumps on servers or on mails, to insert data into tables and to enrich the data and to schedule automatic jobs.
- Optimized performance of queries, debugging and exception handling of procedures.
- Developed cash recons and worked on file formats, matching, job scheduling and reports delivering using all modules of intellimatch.
- Developed procedures, triggers, queries on MySQL, sql server and oracle database.
- Database handling, database design, API’s optimization, Connection handling at application end.
- Development of Pl/Sql stored procedures, Triggers, Queries and its implementation according to the requirement at the front end application.
- Optimization of queries, execution of procedures at application end using c++ API’s of My/Sql and oracle database.
- Design a utility (script file) using shell scripting on Linux.
- Delivering cash reconciliation and jasper reports to business teams.