PROFESSIONAL EXPERIENCE:

Confidential

• 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