Summary of Qualifications:

• Eight years of referable expertise in Enhancements, Maintenance, Testing, Troubleshooting, Support, Automation Analysis on both UNIX Windows Environments.
• Primary skills in implementing/support on Sybase 12.5, Oracle 9i/10g/11g/12c and UNIX.
• 6 years of experience in SQL and PL/SQL programing, which includes writing Stored Procedures, Functions, Cursors and Triggers. Performance Tuning using Explain Plan, SQL Trace, TKPROF, AWR, ADDM, ASH, Precise i3 and Toad tools.
• Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
• Evaluate all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components.
• Design and implement various structures for all physical objects and recommend changes on applications through efficient statistical structures.
• Monitor and identify specific programming languages and recommend enhancement to all programs and evaluate all software resolution.
• Design and analyze all computer hardware, firmware and embedded systems and prepare and maintain various reports for metrics.
• Collaborate with various departments and perform research on all data processing functions.
• 1 year of experience in SQL server 2005 and 2008 database administration.
• 2 years of experience in Leading, which includes meeting with Business Partners, tracking team members, schedule metrics, supporting team members, team meetings, Stake holders meeting, performance discussion, management decisions, cultural change in organization etc.
• Having exposure to Investment Banking Projects and has substantial knowledge in Securities, Equities, Derivatives, Risk Management, Margin, Trade Capture etc.
• Expertise knowledge in using tools like Control M, Remedy, Toad, Incident, Change Problem Management etc.
• Good knowledge in SQL Query/Performance Tuning.
• Expertise in debugging stored procedures, functions error handling techniques.
• Ability to model, analyze and manage large volumes of data. Also to quickly learn new business and technical concepts in a fast paced service focused environment.

Professional Experience:

Confidential

Production Support Oracle Developer

Responsibilities:

• Involved in Support and worked on enhancements for the Application.
• Requirement Gathering and Review. Interact with business units during the requirement gathering review phase
• Developed and performed the quality assurance activities and unit testing.
• Develop and maintain the documentation to support the team and business.
• Created various SQL and PL/SQL scripts for verification of the required functionality.
• Work closely with architects and designers to deliver high quality software.
• Analyze application problems, recommend and develop solutions.
• Produce and maintain program code and documentation.
• Perform system testing with internal clients.
• Conduct peer reviews with other software developers and architects
• Provide support during various phases of testing as well as production support
• Prepare operations instructions for the execution of various software systems.
• Participate in development stand ups and software demonstrations.
• Review requirements with the users and provides time estimates for task completion.
• Created stored procedures, functions, database triggers, packages, cursors and SQL scripts based on business requirements.
• Developed triggers and shell scripts to load the staging tables.
• Involved in SDLC System Development Life Cycle including system analysis, high level design, detailed design, coding and testing.
• Creation of database objects like Tables, Views, Procedures using Oracle tools like SQL Plus and TOAD.
• Involved in Index Monitoring for identifying the Unused Indexes.
• Creating Index's, passing hints, analyzing the table.
• Creating Cron jobs and shell scripts for running the daily loads/jobs.
• Applying constraints and writing triggers to apply the business rules.
• Involved in handling errors and transaction processing in the procedures.
• Oracle data loading into oracle database from flat files using SQL loader.
• Involved in performance tuning using Explain Plan utilities.
• Involved in analyzing Schema's, Tables and Indexes as part of Optimization.
• Used ETL tool INFORMATICA Power Center for constantly moving the data from source planning system into data warehousing system

Environment: UNIX, Windows 7, Sybase 15, Oracle 10, SQL, PL/SQL, Control M, UNIX, Client Server with TCP/IP

Confidential

Production Support Oracle Developer

• This application enables
• Systematic, portfolio rules-based approach Rules of the Road based on applying margin rates depending on Asset Class Strategy.
• Master Netting: Positions can be traded in PB, Swap, Futures, OTC, CDS under the same margining approach margin based on trades, not product type.
• Relief for aggregation of trade under different Hedged Fund Strategies.
• Web-based reporting full transparency with drill-drown to fullest detail as necessary quick resolution of all issues booking, pricing, and risk analysis.

Responsibilities:

• Involved in Support and worked on enhancements for the Application.
• Involved in writing SQL Queries, PL/SQL programs to meet client requirements.
• Involved in optimizing queries and procedures.
• Handling support issues such as critical batch failures and resolving it on time.
• Gathering change requirement as per the request from Client make code changes, test it and release it into production.
• Coordinating with clients and helping them in resolving critical issues to meet SLA
• Involved in automation of the processes using shell scripts as per the requirement.
• Involved in the maintenance of Database Integrity.
• Requirement Gathering and Review. Interact with business units during the requirement gathering Review phase
• Developed and performed the quality assurance activities and unit testing.
• Develop and maintain the documentation to support the team and business
• Created various SQL and PL/SQL scripts for verification of the required functionality.
• Created Stored Procedures, functions, packages, cursors and SQL Scripts based on business requirements.
• Developed Triggers and shell Scripts to load the staging tables.
• Involved in SDLC System Development Life Cycle including system analysis, high level design, detailed design, coding and testing.
• Creation of database objects like Tables, Views, Procedures using Oracle tools like SQL Plus and TOAD.
• Involved in Index Monitoring for identifying the Unused Indexes.
• Creating Index's, passing hints, analyzing the table.
• Creating Cron jobs and shell scripts for running the daily loads/jobs.
• Applying constraints and writing triggers to apply the business rules.
• Involved in handling errors and transaction processing in the procedures.
• Involved in performance tuning using Explain Plan utilities.
• Involved in analyzing Schema's, Tables and Indexes as part of Optimization

Environment: UNIX, Windows 7, Sybase 15, Oracle 10, SQL, PL/SQL, Control M, UNIX, Data Synapse, Client Server with TCP/IP

Confidential

Oracle Developer

Responsibilities:

• Involved in Support and worked on enhancements for the Application.
• Involved in SDLC System Development Life Cycle including system analysis, high level design, detailed design, coding and testing.
• Creation of database objects like Tables, Views, Procedures using Oracle tools like SQL Plus and TOAD.
• Involved in Index Monitoring for identifying the Unused Indexes.
• Developed Triggers and shell Scripts to load the staging tables.
• Handling support issues such as critical batch failures and resolving it on time.
• Involved in automation of the jobs using shell scripts for Client requests.
• Creating Cron jobs and shell scripts for running the daily loads/jobs.
• Applying constraints and writing triggers to apply the business rules.
• Involved in the maintenance of Database Integrity.
• Involved in handling errors and transaction processing in the procedures.
• Involved in performance tuning using Explain Plan utilities.

Environment: UNIX, Windows 7, Sybase 15, Oracle 10, SQL, PL/SQL, Control M, UNIX, Client Server with TCP/IP

Confidential

Oracle Developer

Responsibilities

• Involved in Support and worked on enhancements for the Application.
• Involved in SDLC System Development Life Cycle including system analysis, high level design, detailed design, coding and testing.
• Creation of database objects like Tables, Views, Procedures using Oracle tools like SQL Plus and TOAD.
• Involved in Index Monitoring for identifying the Unused Indexes.
• Developed Triggers and shell Scripts to load the staging tables.
• Handling support issues such as critical batch failures and resolving it on time.
• Involved in automation of the jobs using shell scripts for Client requests.
• Creating Cron jobs and shell scripts for running the daily loads/jobs.
• Applying constraints and writing triggers to apply the business rules.
• Involved in the maintenance of Database Integrity.
• Developed and performed the quality assurance activities and unit testing.
• Involved in handling errors and transaction processing in the procedures.

Environment: UNIX, Windows XP, Oracle 9i, Oracle Forms 6i, Oracle Reports 6i