SUMMARY:

• 10 years of professional experience in Design and Development, System Analysis, Enhancement and service Support Projects for Investment Bank and Insurance domain.
• Experience in Design, Development, and Enhancement and Maintaining applications in Oracle 9i/10g/11g using SQL, PL/SQL in Windows 9x/2000/XP and UNIX environments. Knowledge in Oracle Architecture, Data Dictionary, AWR, ASH report and DBMS Packages.
• 1 year experience in Hadoop developer has strong Background with File distributed system in Big data. Understand the complex processing needs of big data and has experience developing code and modules to address those needs
• Excellent exposure to Oracle PL/SQL as primary skill and Unix Shell Scripting
• Experienced in requirement analysis, design, and coding, testing, implementing and executing project.
• Excellent team player and proven track record working in various team sizes performing cross - functional roles.
• Extensive experience in Database query tuning, Performance tuning and troubleshooting Oracle Application issues.
• Designed and deployed UNIX shell script to automate Oracle Jobs using PL SQL procedures.
• Expertise in creating stored procedures, Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Expertise in Developing Views, Materialized views, DB link, Bulk Collect, For All clause, REF cursor, DBMS packages, SQL Loader, Analytical functions, Hierarchical function, Dynamic SQL, Execute immediate
• Substantial knowledge on Advance PL/SQL.
• Have good exposure to software tools like Toad, PL SQL Developer, SQL*Loader, Mercury Quality Center, SVN, Control-m
• Good Knowledge of Data warehouse environment such as star schema.
• Provided 24X7 supports for any production issues with Batch systems scheduling and processing.
• Ability to quickly learn programming languages and other applications/software.

SKILL:

Operating System & Environment: Window 9x/2000/XP UNIX SUN Solaris 10

Big Data: PL/SQL, SQL, Basic Core Java Hadoop, HDFS, Hive /Impala

Scripting Language: UNIX Shell Scripting

Database: Oracle 9i/10g/11g

Special Software: Toad, SQL*Plus, PLSQL Developer, Mercury Quality Center, Crystal Report 8.5, STAFFWARE

Version Control: Tortoise SVN, VSS

EXPERIENCE:

Confidential

Lead Oracle Pl/SQL Developer

Responsibilities:

• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.
• Develop PL/SQL, Stored subprograms, package, function, Cursors and Triggers.
• Involved in Performance tuning of complex queries and indexing strategy.
• 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.
• 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.
• Created scripts for load data using SQL * Loader.
• Mentored other individuals to develop their career continuously.
• 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.
• Providing 24X7 supports for Production issues.

Technologies: Oracle 9i/10g/11g, PL/SQL, UNIX Shell Scripting.

Special Software: Mercury Quality Center, Tortoise SVN, PL SQL Developer, Toad, Control-M (Application View)

Confidential

Oracle Pl/SQL Developer

Responsibilities:

• Develop PL/SQL, Stored subprograms, package, function, Cursors and Triggers.
• Involved in Performance tuning of complex queries, analyzed and computed statistics to improve response time for queries
• Worked on Database design documentation.
• Involved in Production deployment activities and providing support during implementation.
• Review of code changes, test procedure, test plans and other deliverables.
• Test case/data preparation, execution and verification of the test results.
• Resolving defects reported during QA and UAT testing.
• Involved in DBA activities.

Technologies: Oracle 10g, PL/SQL, ASP, Forms 6i and Reports 6i

Special Software: PL SQL Developer, Toad.

Confidential

Oracle Pl/SQL Developer

Responsibilities:

• Developed PL/SQL, Stored subprograms, package, function, Cursors and Triggers.
• Worked on high level and low level design documentation
• Actively was part of production deployment activities and validation.
• Involved in DBA activities.
• Performed Unit testing and System-Integration testing, provided support during QA and UAT testing.
• Provided support for Production issues.

Technologies: Oracle 10g, PL/SQL, ASP.NET

Special Software: Mercury Quality Center, PL SQL Developer, Toad, STAFFWARE, VSS

Confidential

Team Member

Responsibilities:

• Developed PL/SQL, Stored subprograms, package, function, Cursors and Triggers.
• Involved in Database documentation and design.
• Involved in Production deployment activities and providing support during implementation.
• Involved in DBA activities.
• Performed Unit testing and System-Integration testing, provided support during QA and UAT testing.

Technologies: Oracle 9i, PL/SQL, ASP

Special Software: PL SQL Developer, Toad