SUMMARY:

• Around 11 years of diversified experience in Application Development, Support and maintenance Database solutions.
• Expertise in all phases of the Software Development Life Cycle including analysis, Physical and Logical design, code Development, testing, implementing and maintenance.
• Expertise in using Oracle 11g/10g /9i /8i databases.
• Proficient with SQL, PL/SQL, Stored Procedures, Functions, Packages, Database Triggers and Indexes.
• Experience in Development and Testing of Oracle Forms and Reports Including Customizations to existing Forms/Reports.
• Strong in using tools such as PL/SQL developer, Toad SQL*Loader and SQL*Plus.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Knowledge on DBA activities such as Performance Tuning, Backup and Recovery.
• Creating scripts for Create, Alters and Data Modifications.
• Experienced in Development analysis, design, programming and testing the business application.
• Expertise in database normalization by providing proper Primary Keys, Constraint Keys, Indexing, Foreign Keys, Stored Procedures, Triggers, User Define Function and Views.
• Worked on 24*7 environments to provide Production Support.
• Expertise in computer Development validation testing
• Good knowledge on different domains like Development, Pharmaceutical and banking
• In addition to excellent technical abilities possesses strong written and communication skills, analytical and interpersonal skills.
• Good team spirit and organized working habits with a willingness to learn new concepts

TECHNICAL SKILLS:

RDBMS: Oracle PL/SQL, Oracle 8i/9i/10g/11g

GUI: Oracle developer (forms and reports)

Other Tools: TOAD, SQL Navigator, SQL *Loader

Languages: C, Pro*C

Scripting Languages: Shell Scripting

Packages: Microsoft Office

Operating Systems: Windows XP/7/8, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Senior Support Engineer

Responsibilities:

• Addressing all the technical and functional issues(L2/L3) raised by the business users
• Addressing scheduled job failures/Data analysis to investigate the job failures
• Addressing root cause analysis of the data issues raised by users and its fixes
• Involved in the change management activities like creation/ implementation.
• Involved in the release activities like implement/migrate new changes and bring back the applications online
• Involved in the root cause analysis for the code bugs and its fixes permanently.
• Involved in the Confidential integration testing
• Involved in the disaster recovery activities and testing
• Diagnosing/Solving Application issues as per the alerts from monitoring tools
• Involved in the preparation of KeDB (Knowledge error database) documents for the repeated issues
• Coordinating with the Teams like Citrix, DBA, Network, Dev as required.
• Responsible for the on time Risk reporting to meat SLA
• Coordinate with Incident management in case of high priority(P1/P2) issues

Environment: SQL, PL/SQL, UNIX

Confidential

Senior Oracle developer

Responsibilities:

• Understanding the warehouse/Distribution Center functionality
• Understanding the process flow of current applications and existing jobs
• Preparation of functional specification document as per the business requirement
• Created/Modified Tables, Indexes, Constraints, Oracle PLSQL scripts, Procedures, functions triggers as per the business requirement/functional specifications
• Created/ Modified Oracle Forms as per the business requirement.
• Created/ Modified Oracle Reports as per the business requirement.
• Created/ Modified Unix Shell scripts as per the business requirement.
• Also responsible for unit/Integration testing and documentation.
• Coordinate with offshore team to complete Development /testing on time as per timelines.
• Tracking the new changes in the Development tracker
• Involved in the integration testing and fixes
• Involved in the production migration/implementation of the new Development
• Involved in the hyper care activities after production migration
• Provided knowledge transfer to the support team on the new changes
• Familiar with Redwood job scheduler.

Environment: Oracle 9i, SQL, PL/SQL, Oracle Forms/ Reports, Unix, Toad, Redwood

Confidential

Support Analyst

Responsibilities:

• Addressing all the technical and functional issues(L2/L3) raised by the business users
• Involved in application admin activities like User management, start/stop app/web servers
• Diagnosing/Solving Application issues as per the alerts from monitoring tools
• Involved in the configuration changes for the applications like Labware Lims and Discoverant applications
• Involved in the database fixes/bug fixes as required
• Involved in the planned and unplanned outage activities like implement/migrate new changes and bring back the applications online
• Casual analysis to identify the problem for unplanned outage and provide the permanent solution
• Involved in the root cause analysis for the bugs and its fixes permanently.
• Involved in the Create/Execution of the validation test case documents(II,IQ,OQ,PQ) for RFCs
• Involved in the preparation of KeDB (Knowledge error database) documents for the repeated issues
• Coordinating with the Teams like DBA, Unix, Network teams as required.

Environment: SQL, PL/SQL, UNIX

Confidential

Senior Process Associate

Responsibilities:

• Addressing all the technical and functional issues raised by the business users(L2 and L3 issues)
• Worked as a team to fix the bugs/CR permanently
• Worked for the database fixes as required
• Monitor Job schedules
• KeDB(Knowledge error database document) preparation for the repeating issues
• Create and execute validation test case documents like II, IQ, and OQ, PQ for RFC Migration etc.
• Reporting and resolving deviations
• Coordinating with Citrix, DBA, Network and server teams
• Coordinating with vendor of the applications as required

Environment: SQL, PL/SQL, UNIX, Peoplesoft

Confidential

Developer

Responsibilities:

• Analysis of functional requirements and designing the Development as per the requirements given.
• Coordinating with team members in business requirements analysis, Development analysis, design and Development of the application.
• Preparation of Program specification and Technical specification documents.
• Involved in writing PLSQL stored procedures, functions and packages.
• Created/Modified existing Pro*c programs for validation.
• Involved in preparing the database scripts for production issues.
• Involved in Preparing unit Test scripts
• Involved in production migration

Environment: SQL, PL/SQL, PRO*C, Forms 3.0, UNIX tial

Confidential

Developer

Responsibilities:

• Involved Preparing Program Specifications as per business requirement document
• Created database objects such as tables, views, synonyms, indexes, sequences and custom package packages tailored according to business requirements.
• Involved in writing PLSQL stored procedures, functions and packages.
• Involved in Confidential of PRO*C programs for data validation and processing.
• Involved in Unit Testing and Confidential Testing and prepared Test cases.
• Involved in production migration
• Involved in Hyper care or bug fixes in production

Environment: SQL, PL/SQL, C, PRO *C, Forms 3.0, UNIX