Senior Oracle Pl/sql Developer/lead Resume
2.00/5 (Submit Your Rating)
PROFESSIONAL EXPERIENCE:
Confidential
Senior Oracle PL/SQL Developer/Lead- Oracle certified PL/SQL developer with 10+ years of development experience
- Development experience includes Oracle database design, development, performance tuning and solution implementation.
- Extensive experience in creating PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Tables, Indexes and Directory mappings
- Used Explain Plan, hints, partitioning and creating indexes to improve the performance of SQL statements
- Experience in advanced PL/SQL concepts like Bulk collect and ForAll
- Experience includes Oracle 9i/10g/11g, Unix shell scripting and scheduling jobs using Control - M
- Experience in developing Unix Shell Scripts for automation of ETL process. Extensively used VI editor.
- Proficient in using Informatica Workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions
- Passionate about Python programming
- Strong domain knowledge in Banking and Financial services with specialization in Asset management
- Worked extensively in Agile development model
- Excellent trouble shooting, debugging and error trapping skills
- End to end understanding of SDLC project life cycle which includes requirement gathering and analysis, design, development, review, testing and implementation of Oracle Database applications
- Excellent communication and interpersonal skills from working closely with business and technology teams
- Managed projects as Team Lead
- Experience in onsite-offshore business model and coordinating with off-shore team
- Exposure on the various project management and quality assurance tools
TECHNICAL SKILLS:
Databases: Oracle 11g, Oracle 10g, Oracle 9i, Sybase, SQL Server
Languages: Oracle PL/SQL, UNIX Shell, Python, PowerBuilder, Java Script, HTML, Core Java, C, C++ IDE Tools Toad, SQL Developer, Rapid SQL, Power Builder, SSRS, Microsoft Visual studio, Informatica PowerCenter
Job scheduling Tools: Control-M
FTP Tools: Reflection FTP client, File Zilla
Version Control Tools: TFS, VSS, PVCS
Operating Systems: Windows NT/2000/XP/7/8/10