SUMMARY

• Over 11 years of diversified experience in Application Development, Support and maintenance Database solutions.
• Expertise in all phases of teh 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 wif 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 teh 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 system analysis, design, programming and testing teh 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 system validation testing
• Good knowledge on different domains like Retail, 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 wif 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

Lead/Senior PL/SQL Developer

Environment: Oracle 11g, SQL, PL/SQL, UNIX

Responsibilities:

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

Confidential

Senior Orcle PL/SQL Developer

Environment: Oracle 11g, SQL, PL/SQL, UNIX

Responsibilities:

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

Environment: Oracle 10g, SQL, PL/SQL, Oracle Forms/ Reports, Unix, Toad, Redwood

Confidential

Senior PL/SQL Developer

Environment: Oracle 10g, SQL, PL/SQL, UNIX

Responsibilities:

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

Confidential

Senior PL/SQL Developer

Environment: Oracle 9i, SQL, PL/SQL, UNIX, Peoplesoft

Responsibilities:

• Clinicopia Forecasting - a comprehensive clinical demand management system
• Clinicopia Supply Management - end-to-end inventory tool dat covers supply planning, manufacturing, randomization, packaging, release and distribution
• Clinicopia Labeling - clinical label translation, design, approval and printing
• Clinicopia Process Execution - manufacturing and packaging instructions, resource planning and electronic batch records
• Addressing all teh technical and functional issues raised by teh business users(L2 and L3 issues)
• Worked as a Development team to fix teh bugs/CR permanently
• Worked for teh database fixes as required
• Monitor Job schedules
• KeDB(Knowledge error database document) preparation for teh repeating issues
• Create and execute validation test case documents like II, IQ, and OQ, PQ for RFC Migration etc.
• Reporting and resolving deviations
• Coordinating wif Citrix, DBA, Network and server teams
• Outage application support
• Coordinating wif vendor of teh applications as required

Confidential

Senior PL/SQL Developer

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

Responsibilities:

• Analysisof functional requirements and designing teh system as per teh requirements given.
• Coordinating wif team members in business requirements analysis, system analysis, design and development of teh 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 teh database scripts for production issues.
• Involved in Preparing unit Test scripts
• Involved in production migration