Software Development Resume Profile

Summary

Worked on various phases of Software Development Life Cycle SDLC supporting project LLD, HLD, BRD requirements as well as designing, Coding, Testing, Quality assurance and implementation of complex projects/programs
Substantial development experience in creating Procedures, Packages, Functions, Triggers and databases complicated technical objects using SQL, PL/SQL as well as enforcing data integrity via integrity constraints database triggers
Experience in Performance Tuning SQL Statements and Procedures for the maximum efficiency in various schemas across large complex Oracle/PLSQL databases.
Expert in major/minor release planning, execution and post change analysis of Software and Apps Databases implementations
Team player with excellent communication skills and proven track record of supporting global team working in cross-functional matrix environment

SKILL SET:

Operating Systems	RHEL Linux, UNIX, SOLARIS, AIX and Windows 95/98/ME/NT/2000/XP
RDBMS	Oracle8i/ 9i/ 10g/11g , Sql Server 2000,Access
Languages	SQL, PL/SQL, C, UNIX Shell, VB,VB.net
Tools	SQL Loader, TOAD, PL/SQL Developer, SQL Navigator, Forms and Reports , Tableau
Tuning Tools	EXPLAIN PLAN , SQL HINT ,Index
Database Modeling	TOAD, ER-Diagram, Erwin and MS Visio
BI, ETL and DW	Informatica, Power Center, Business Object
Version Control	Clear Case , SVN
Network Protocols	ODBC, TCP/IP, HTTP,FTP, SMTP
Web Tools	HTML, XML,ASP, Vb script

PROFESSIONAL EXPERIENCE:

Confidential

Role: Senior Application Developer

Health Compliance: - All the SSH keys for different application and their corresponding host servers registered in UKM Universal Key Management Database. Deutsche is looking for their unauthorized access of SSH keys with their NON Prod servers and sending the alerts to their corresponding application's ITPM Who manage that particular application and requested to remove the unauthorized access. So that's how auditors can keep eye on each and every application and their corresponding servers.
Responsible for designing the Reporting database model by collecting all the required information from the source data.
Developed the PL/SQL Scripts to load the data systematically from one schema to another schema.
Developed the SQL LOADER Scripts to load the source data from files landing Zone to the staging schema more efficiently.
Responsible for validate the data and generating the report.
Scheduled the pl/sql scripts using scheduler tool CONTROL M .
Responsible to collect the audit requirement and design the schema to provide the solution for their requirement.
Extensively work on PL/SQL Objects like stored Procedure, Functions, Triggers, views.
Developed Reporting Model to work as an interface for other applications.
Worked on Performance Tuning using Indexes and SQL Hints.
Handled the bulk of data and segregate the required data in staging schema.

Environment: Oracle 11g, TOAD, SQL PLUS, SQL Developer, SQL LOADER, Win SCP, Putty, Control M Job Scheduler , MS VISIO, Tableau.

Confidential

Role: Senior Application Developer

Oracle Financial Services Software OFSS is a major part of Oracle Financial Services Global Business Unit. Its portfolio of offerings include Oracle FLEXCUBE, a complete banking product suite for consumer, corporate, investment, private wealth management, mobile and internet banking, consumer lending, asset management, and investor servicing, including local and cross-border payments across channels and networks.

Confidential

Responsible for Application Production Support 24 X 7 on-calls.
Create necessary deployment instructions Release process for System Administrator to deploy from DEV to QA/Test and then Production.
Troubleshoot code defects JIRA in the development, test and production environments and implement appropriate solutions.
Responsible to handle production support issues through an established Virtual ticketing process.
Developed functional and technical design and documentation of Oracle Applications dependent data conversions, interfaces, custom reporting, and custom applications.
Work with BO team to develop reporting solutions on top of these frameworks to provide adequate analytics and data reconciliation between many complex data sources.
Analyze and document root cause of defects or production support issues and implement appropriate solutions using own judgment.
Worked with SCM Team in release process after tagging the updated units in clear case and verified the release before handed off the system to USER.
Worked with project team to understand business process and workflow and translating them into system requirements.
Develop, design and troubleshoot various new and existing functionality in modules LS, LD, LT of Flex cube to book the loans.
Create and maintain queries using PL/SQL, and Linux scripting as required.
Participated in all phases of software development/implementation life cycle including functional analysis, development of technical requirements, coding, testing, deployment and support.
Experienced in using tools like TOAD, SQL PLUS, Putty, Exam diff, PL/SQL Developer, SSH Client, Auto sys, Clear Case, LMS Login Management System for design and development.
Ability to use all available tools including Oracle Forms and Reports.
Estimate the level of effort required to deliver assigned tasks.

Environment: Oracle 11g, TOAD, SQL PLUS, PL/SQL Developer, Exam diff, SSH-client, Putty, Auto sys Job scheduler, Resolve IT, Clear Case, SVN,LMS

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship