SUMMARY:

• 11 years of Experience in Development and Production support in IT.
• Experienced in Telecom, Banking, Healthcare and Manufacturing /Supply Chain domain As Oracle Developer with expertise in SQL, PL/SQL, Oracle 9i - 10g-11g, UNIX and Shell Scripting
• Expertise in Tools such as SQL Developer, TOAD for Oracle SQL.
• Expertise in database replication tool Attunity Replicate
• Experienced in incident management in L2/L3 support and maintaining SLAs and reporting metrics to stakeholders.
• Coordinated release management with Server management, DBA and Development teams.
• Proficient in PL/SQL Procedures, Functions, Triggers, Packages, Views, Materialized Views, SQL Queries, fine tuning of Queries using Explain Plan and unit testing
• Expertise in UNIX Shell Scripting
• Exposure in ETL
• Experience in OLTP process.
• Experienced in job scheduler: Autosys.
• Extensive knowledge in developing complex systems, maintenance, and support
• Ability to define project scope and estimate.
• Vast experience in RDBMS - Oracle, MySQL database.
• Keen focus on performance tuning, testing, versioning and quality assurance using tools Mercury QC, SVN, PVCS, ClearCase.
• Demonstrated ability to effectively understand and translate business requirements into technical solutions
• Basic knowledge in Python
• ITIL Foundation certified
• Experience in Agile environment

TECHNICAL SKILLS:

Languages: Oracle PL/SQL, SQL,UNIX Shell Scripting

Expertise in: Incident Management, Request Management and Change Management.

Operating systems: UNIX, MS-Windows.

Database: Oracle 11g-10g-9i

Tools and Software used: Toad, Mercury QC, Autosys, Tortoise SVN, SQL Developer, ClearCase, CA Unicenter, MS Office Tools, Attunity Replicate

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Senior Database Developer

Responsibilities:

• Oracle Database developer
• Onsite coordinator and Lead
• Prepare project planning and implementation schedule
• Active involvement in performance tuning of applications.
• Review code
• Coordinate SIT and UAT activity
• Involved in providing application support and maintenance activities like coordination with Operations in distributed environments.

Confidential, Houston, TX

Senior Database Developer

Responsibilities:

• Oracle Database developer
• Ensured end-to-end delivery of modules related to products like Equities, OTC, Repo, AFS/HTM and TCP for ALGD (Alternate Loss Given Default), RWA (Risk Weighted Asset) calculation
• Effective interaction with business analysts and end-users to gather requirements for risk calculation methodologies across multiple products and delegated them to the team through design sessions with appropriate guidance and mentoring.
• Responsible for seamless releases spanning across multiple quarters by preparing effective and robust implementation and failure/rollback plans.
• Ensured on-time delivery of projects to the end-user with 100% code coverage, unit testing and integration test results.
• Active involvement in performance tuning of applications.
• Involved in providing application support and maintenance activities like coordination with Operations in distributed environments.

Environment: Oracle 11g, UNIX

Confidential, Winston-Salem, NC

Team Lead, Database Developer

Responsibilities:

• Provide IT Support for Supply Chain Applications include on-call support.
• Fix production issues on priority basis.
• Root Cause Analysis of production issues and providing temporary and permanent fixes for data as well as program.
• Develop PL/SQL Procedures, Functions, Triggers and Packages to implement business requirements.
• Working as a Technical Lead and Programmer for Supply Chain Activities.
• Incident management, Request management and Change management - CA service desk, Mercury QC and HP Project Portfolio Management.
• Handling job schedules and dependencies using Job Scheduler: CA Workload ( Autosys)
• Understand requirements through regular interaction with business analysts and end users at client’s office.
• Identifying areas of system enhancement and submitting the business proposal to customers.
• Clarifying the issues of the team members and help them in the proper execution of the project
• Providing Supply Chain training sessions to new team members.
• Providing UNIX/PLSQL training sessions to new team members.
• POC for SOX tasks .

Environment: Oracle 9i, UNIX

Confidential, Fairfield, CT

Team Lead, Database Developer

Responsibilities:

• Deployment of Oracle PL/SQL codes to UNIX box and scheduling jobs.
• Analyze and debug PL/SQL code as part of support activity.
• Lead Data migration project of content management system from PL/SQL database to MySQL.
• Worked as Technical Lead and senior database programmer for content management system product.
• Requirement gathering, analysis, and estimation after conducting the feasibility study and Impact Analysis.
• Analyzing and designing database objects like tables and stored procedures based on requirements.
• Conducting Code reviews, Unit testing and load tests.

Environment: Oracle 10g/11g, UNIX

Confidential, Albany NY

Software Engineer - PL/SQL Developer

Responsibilities:

• Worked as senior database developer
• Oracle PL/SQL Procedure, Functions, Package development
• Providing support to handle fin close every month
• Handling the Bill-Correction and Profile-Correction
• Responsible for Profile correction automation task - which saved 60 man hours every month
• Handling the quality-related procedures updating ClearQuest and ClearCase.

Environment: Oracle 10g, Windows, AIX

Confidential

Database Developer

Responsibilities:

• Handling Customer profile reconciliation analysis
• Developing test automation scripts in Oracle PL/SQL and Review of test queries and results
• Writing SQL queries to analyze data consistency
• Data analysis to make sure the logical and physical conversion of data is correct.
• SPOC of Quality processes in the project.

Environment: Oracle 10g, Windows, AIX

Confidential

Support Analyst

Responsibilities:

• Analyze and debug complicated PL/SQL procedures for permanent fix job failures.
• Code PL/SQL procedures, functions, packages etc. as part of enhancement requirement.
• Batch job monitoring to ensure the critical feeds are sent on correct time
• User query handling and Fixing bugs and enhancements.
• Coordinating release and testing team along with production team. Environment WSAD, UNIX, and Windows

Environment: Oracle 9i, HP-UX