SUMMARY:

• A competent professional with around 9.8 years of experience in banking domain, Airline domain, Manufacturing & retailing domain as Advance Oracle PL/SQL developer, Application Developer, Support and maintenance lead, Development lead.
• Skilled with the Software Development, Unit Testing and processes Implementation Life Cycle, analyzing User Requirements based on the Business Requirement Documents/Functional Specs.
• Skilled in Requirement gathering, Code development, Unit test Cases, tracking, Technical documentation and preparation of Traceability Matrix using MS tools (Word, Excel).

TECHNICAL FORTE:

Management Tools: HP ALM tracker, Remedy

Database: Oracle 9.0, 10G, 11G, 12C

Environment: Web based, Windows Based

Operating Systems: Win 2000/2003/2008 , Win XP, Win 7, Win 8

Skills: Performance Tuning (5 years), PL/SQL development (9 Years), Advance PL/SQL, SQL (9 Years), Basic Unix (2 Years), AWS dynamo DB (1 Year), NOSQL, ASP (2 Years), JavaScript (2 years), VBScript (2 Years), COM components (3 Years)

Other Tools: Toad, SQL developer, PL/SQL developer, Putty, Filezilla, Android simulator.

EXPERIENCE FORTE:

Confidential, Houston, Texas

Sr Software Programmer

Environment: windows based .Net application and Oracle database, Web services & ESB, Android Apps.

Tool: Toad, PL/SQL developer, SQL developer, ALM, HP BMP monitoring, SVN, PVCS, GIT

Core Technology: Oracle PL/SQL, SQL, UNIX, Advance PL/SQL concepts, Performance tuning, AWS basics

Responsibilities:

• Gather requirement from BA design technical FDD.
• Design code and plan for releases.
• Handle critical production issues regarding performance.
• Handle and coordinate release development chain.
• Present new features or search new features in new versions that help in improvisation and innovation
• Develop and tune PL/SQL codes and review developed code from team.
• Take ownership of project release from database technical side, act as Database Lead for entire team.
• Work with development team for new request, Perform performance testing on written code.
• Communicate with DBA regarding AWR reports & performance tuning of objects.
• Report to Lead & Manager.
• Taking initiative & drive most of the production issues & development calls.
• Monitor database health from EM browser and raise flag in case of issues.
• Approve deployment scripts after verifying in terms of performance and standards.
• Work on AWS Athena and Dynamo DB for upcoming projects
• Designed code to convert all database tables to partitioning in online mode
• Designed code to auto maintenance of partitions to move 6 - month older partitions to archival disk.
• Tuned and boost entre database performance by restructuring all tables with minimum downtime and new enhanced features of oracle.
• Reduced database size from 20TB to 1.5TB after re-structuring, its combine efforts of 2 years for Partitioning and re-structing project, this helped to reduce cost, increase performance, more manageable in crisis and recovery.
• Designed many processes for auto maintenance for DBA team.
• Promoted to Lead position in Confidential .

Confidential

Sr. Software Programmer

Environment: windows base

Tool: Toad, PL/SQL developer, SQL Developer.

Core Technology: Oracle PL/SQL, SQL, UNIX, Performance tuning.

Responsibilities:

• Handled reporting database named as ODS which is use by BO to pull out report.
• Developed new PL/SQL code for sync activity between transactional databases to reporting database.
• Understand user requirements and work on those requirements with proper specification doc.
• Handle data related issues.
• Maintained code versioning in PVCS related to ODS.
• Main gate keeper for ODS code deployment related to Database.
• Worked with other team members of other projects to accomplish new enhancements.
• Communicate with BA & Testing team during requirement gathering & Quality testing.

Confidential

Environment: web based

Software Programmer

Tool: Toad, Putty, Oracle PL/SQL developer

Responsibilities:

• Main source or point of contact of SBI and All Associate banks.
• Distribute all support related activity.
• Major role in PL/SQL development. To minimize Application work load.
• Designed Payment related procedures in PL/SQL.
• Given several presentations to clients like SBBJ, SBM etc.
• Handled Month end processing of all pensioners of SBI.
• Handled sixth pay commission of most of states and disburse their dues via PL/SQL developed project.
• I did standardize process by adding several check lists for do’s & don’ts in SBI before month end processing
• Interact with client directly understand their needs and get IR to be created for this request.

Confidential

Software Programmer

Environment: web based

Tool: Oracle PL/SQL developer, Toad, SQL Developer

Core Technology: Oracle PL/SQL, SQL, ASP, VB, JAVA scripts, COM components

Responsibilities:

• Managed 10 Team members.
• Understand Client requirements & IR creation.
• Scheduling project flow and develop Web base application, PL/SQL procedures with team.
• Work on site with clients
• Gather client requirements and work on the spot.
• Drive client call and handle their needs.
• Work on web & database technologies and take responsibility of integration of entire application.