SUMMARY

• 11+ years of professional experience in Design and Development, System Analysis, Enhancement and service Support Projects for Insurance, Sub - Servicing Mortgage Banking, Time Share,Travel and Hospitality Industry and Fleet services domain applications in Oracle 10g/11g using SQL, PL/SQL in Windows 9x/2000/XP and UNIX environments. Knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
• Excellent exposure to SQL, Oracle PL/SQL as primary skill and UNIX shell scripting
• Extensive experience in Database query tuning, Performance tuning using Explain Plan, AWR report, SQL Hint and troubleshooting Oracle Application issues.
• Experienced in requirement analysis, design, and coding, testing, implementing and executing projects.
• Expertise in creating stored procedures, Packages, Triggers and Functions. Strong knowledge in cursor management and exception handling, PL/SQL logging.
• Expertise in Developing Views, Materialized views, DB link, Bulk Collect, FORALL clause, REF cursor, SQL Loader, Analytical functions, Hierarchical function, Dynamic SQL, Execute immediate etc
• Used Oracle Analytical functions like rank(), Lag(), Lead(), row number(), dense rank(), lstagg(), ntile(), pivot() etc
• Have good exposure to software tools like Toad, PL SQL Developer, SQL*Loader, Mercury Quality Center, SVN, Autosys
• Have worked on Smartview, Ingress database and OSQ language.
• Excellent team player and proven track record working in various team sizes performing cross-functional roles.
• Excellent in problem solving, project management, good leadership skill and organizing and prioritizing the tasks.
• Designed and deployed UNIX shell script to automate Oracle Jobs using PL SQL procedures.
• Substantial knowledge on Advance PL/SQL.
• Provided 24X7 supports for any production issues.
• Ability to quickly learn programming languages and other applications/software.
• A capable and resourceful team member who also possesses excellent written and verbal communication skills

TECHNICAL SKILLS

Development Technologies: PL/SQL, SQL, DIBOL, UNIX Shell Scripting

Operating Systems: Window 9x/2000/XP, UNIX SUN Solaris 10

Databases: Oracle 10g/11g/12c, Ingress, Essbase

Tools: Putty, DB Visualizer 7.0.7, PL/SQL Developer, SQL Developer, Toad, Editplus, Assyst, Microsoft Visio, Autosys, Remedy, Smartview, Tortoise SVN, VSS, SCCS

PROFESSIONAL EXPERIENCE

Oracle PL/SQL Developer

Confidential, Hartford, CT

Responsibilities:

• Responsible for requirements gathering from Clients and implementing the back-end changes in existing products and in designing the database.
• Develop PL/SQL, Stored subprograms, package, function, Cursors and Triggers.
• Involved in Performance tuning of complex queries using Explain Plan and AWR report and indexing strategy.
• Optimizing query by based on the Explain Plan generated .
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Developed objects like Partitions, Materialized views, Views, Indexes.
• Relational database activity such as indexes, primary and foreign keys, and constraints
• Dynamic Sql, and BULK COLLECT and FOR ALL, SYS REFCURSOR, SYS CONTEXT
• Review of code changes, test procedure, test plans and other deliverables.
• Develop UNIX Shell scripts as per user requirements and to automate the processes.
• Created scripts for load data using SQL * Loader.
• Monitoring job using Autosys utility, fixing any job failure.
• Involved in DBA activities.
• Test case/data preparation, execution and verification of the test results. Resolving defects reported during QA and UAT testing.
• Develop various business reports.
• Provided support for one of the file transfer migration project from RAFT (Random Access File Transfer) to MFT(Manage File Transfer)
• Providing 24X7 supports for Production issues.

Environment: Oracle 11g/12c, PL/SQL, UNIX Shell Scripting, Mercury Quality Center, Tortoise SVN, PL SQL Developer, Toad, Autosys, Putty.

Oracle - Data Analyst

Confidential

Responsibilities:

• Developed complex SQL script to generated OPS report metrics using analytical functions like rank(), row number(), dense rank(), lstagg(), ntile(), pivot() etc.
• Using with() clause for writing complex queries.
• Developed Script for spooling of data and generate the reports.
• Develop PL/SQL, Stored subprograms, package, function, Cursors.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Develop DOS Shell scripts as per user requirements and to automate the processes.
• Test case/data preparation, execution and verification of the test results. Resolving defects reported during QA and UAT testing.
• Involved in Production deployment activities and providing support during implementation.
• Review of code changes, test procedure, test plans and other deliverables.
• Develop queries for various business reports.
• Maintaining code version using SVN.

Environment: Oracle 11g, PL/SQL, Excel VBA Code, SQL Developer, Tortoise SVN, Toad, Excel

Onsite Team Lead- Oracle PL/SQL Developer

Confidential

Responsibilities:

• Follow the complete SDLC life cycle of the project.
• Involved in the initial discussion of the projects to gather requirement and proposed solution during JAD and JRP’s
• Performing Impact analysis and estimation for the projects depending on the requirement gathered.
• Develop code in PL/SQL, Stored subprograms, package, function and Cursors.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Created SQL*Loader scripts to load data into temporary staging tables
• Wrote extensive Exception handling procedures to handle exceptions.
• Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes.
• Prepared High level and Low level designed documents in MS word and Flow diagram using MS Viso,
• Review of code changes, test procedure, test plans and other deliverables.
• Develop UNIX Shell scripts as per user requirements and also to automate the processes.
• Test case/data preparation, execution and verification of the test results. Resolving defects reported during QA and UAT testing.
• Maintaining code version using SVN.
• Develop various business reports.
• 24x7 support on production issue

Environment: Oracle 10g, PL/SQL, UNIX Shell Scripting, Mercury Quality Center, PL SQL Developer, Toad, Putty, VSS, Assyst, SVN, DB Visualizer, Microsoft Visio

Offshore Team Lead- Oracle PL/SQL Developer

Confidential

Responsibilities:

• Follow the complete SDLC life cycle of the project.
• Involved in the initial discussion of the projects to gather requirement and proposed solution during JAD and JRP’s
• Performing Impact analysis and estimation for the projects depending on the requirement gathered.
• Develop code in PL/SQL, Stored subprograms, package, function and Cursors.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Created SQL*Loader scripts to load data into temporary staging tables
• Wrote extensive Exception handling procedures to handle exceptions.
• Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes.
• Prepared High level and Low level designed documents in MS word and Flow diagram using MS Viso,
• Review of code changes, test procedure, test plans and other deliverables.
• Develop UNIX Shell scripts as per user requirements and also to automate the processes.
• Test case/data preparation, execution and verification of the test results. Resolving defects reported during QA and UAT testing.
• Maintaining code version using SVN.
• Develop various business reports.
• 24x7 support on production issue

Environment: Oracle 10g, PL/SQL, UNIX Shell Scripting, Mercury Quality Center, PL SQL Developer, Toad, Putty, VSS, Assyst, SVN, DB Visualizer, Microsoft Visio