SUMMARY

• Over seven years of experience as anOracle PL/SQLDeveloper wif excellent noledge on all phases of Software Development Life Cycle.
• Expertise in Client - Server application development using Oracle10g /11g, PL/SQL, SQL *PLUS, SQL Developer, TOAD andSQL*LOADER wif exceptional debugging skills
• Strong noledge and working experience onData flow diagrams, Data dictionary, Database normalization techniques, Entity relation modelinganddesign techniques.
• Good noledge on logical and physical Data Modeling and normalizing Techniques.
• CreatedTables, Views, Constraints, Indexes(Bitmap and Function Based), Table Functions, procedures, explicit cursors, Packages, sequences, Triggers, Table Partitioning, Analytical functions, Materialized Views, Query Re-Write.
• Created multiple PL/SQL Procedures and functions for generating application specific data required for application processing.
• Performed SQL and PL/SQL tuning and optimization using various tools like EXPLAIN PLAN and AUTOTRACE to make the SQL performance better.
• Good noledge and experience in Insurance and Banking Domain.
• Developed Perl script for watching output folders andNDMing the files to destination server
• Created multiple PL/SQL Procedures, functions, Packages, Triggers, Explicit cursors, Indexes, Sequences and complex sub queries for generating app processing details and control reports.
• Good expertise in generating Oracle reports against database tables for ADHOC business requests.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).Good noledge and experience on performance related features such asQuery Optimizer, AUTOTRACE, Execution Plans - EXPLAIN PLAN,TK*PROF and Indexes.
• Experience in coordinating wif DBAs for execution of DDL tasks and supports production installation tasks.
• CreatedShell and PERL Scriptsfor invoking SQL scripts and scheduled them using Job scheduling tools - Autosys and Crontab.
• Excellent communication, documentation skills and strong ability to perform as a part of team.
• Leading, Cooperating & communicating wif other team members for efficient management of work.
• Excellent time management, written, communication skills, decision making, relationship and organizational skills.

TECHNICAL SKILLS

Development: Oracle 11 G SQL and PL/SQL, Unix shell and Perl scripting

Technologies: Oracle 11 G SQL, PL/SQL, SQL*LOADER, TOAD, SQL*PLUS, Oracle reports, Dynamic SQL, Unix Shell (KSH, BASH and PERL) scripting, NDM,SFTP, FTP, Autosys, Crontab, Oracle XML and Perl scripting

Operating systems: Windows, Unix - AIX, Solaris and Linux

Databases: Oracle 11g, SQL*PLUS

Tools: Eclipse, Notepad ++, Ultra edit, HP QC, IBM Rational Clearcase, AFP & BTB viewers and Win SCP

PROFESSIONAL EXPERIENCE

Oracle 11g PL/SQL Developer

Confidential, Jacksonville, FL

Responsibilities:

• Analyzing, designing, developing and deploying new functionality being incorporated.
• Fixing the ongoing items dat emerge out of Production issues/outages/installations.
• Providing UAT support for Testing process of developed application
• Developing Shell Scripts, PERL scripts, PLSQL stored procedures to automate the manual activities.
• Reporting status to Manager and provide 24x5 support. Participate in weekly status calls wif business team and communicate the project status.
• Ensuring all processes, coding and implementation activities are as per standards
• Created multiple PL/SQL Procedures, functions, Packages, Triggers, Explicit cursors, Indexes, Sequences.
• ADHOC reports from the application transaction data (OLTP) for various business purposes. Developed PL/SQL scripts and Complex SQL Queries for 32 ADHOC reports
• Created shell, PL/SQL scripts for generating reports and scheduled them using Autosys and CRONTAB commands.
• Expertise inDynamic SQL, CollectionsandException handling.
• CreatedPL/SQL scriptsto extract data from the database into flat files usingUTL FILEpackage.
• Good Experience inOracle built-in packages like DBMS SQL, DBMS METADATA, DBMS OUTPUT, DBMS UTILITY andUTL FILE and Dynamic SQL.
• Loaded large/big data into Oracle Tables usingSQL *Loader and created oracle procedure and shell script which runs automatically (crontab) to drop indexes while loading BIG data to achieve better performance.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Partitionedthe tables andmaterialized viewsto enhance the performance.
• IncludedPragma Autonomous Transactionto avoid mutating problem in triggers.
• Creation of database objects liketables, views, procedures, functions, triggers and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Developed PL/SQL and shell script for transferring hourly report from UNIX server to Windows system by using advanced Key exchange method in SFTP (secure file transfer).
• Worked on the defects opened by testing team and update the defect status on HP QC accordingly.

Environment: Unix - Solaris, Oracle 11 G SQL, PL/sql, korn shell scripting, NDM, SFTP, HP Quality Center, IBM rational Clearcase, Ultra edit, Capstone engine, SQL developer, SQL*PLUS, Dynamic SQL, SQL*LOADER, CRONTAB.

PL/SQL and UNIX shell scripting Developer

Confidential, Newark, DE

Responsibilities:

• Worked on all phases of the SDLC (Agile environment)from requirement analysis, design, development, testing, implementation and maintenance wif timely delivery. Trained new joiners on Shell scripting and PL/SQL.
• Worked on preparation of Technical and Functional Specifications based on the Business Requirements
• Worked on documenting and estimating the software development effort.
• Participated all the project calls and gather all the requirements carefully and recommend any changes wif the technical and business expertise.
• Scheduled several meetings to discuss and review design/ coded scripts and recommend changes for better enhancements and code optimization/Performance tuning.
• Developed PL/SQL and PERL scripts to transform and load big data to database tables.
• Developed Shell script to automate table load process.
• Developed PERL script to send/mail file statistics to DL (Distribution List) at regular intervals.
• Generated several ADHOC Oracle reports for letter/statement details as per business requirements.
• Worked on autosys to schedule the jobs.
• Coordinated wif DBA for executing data model changes in production environment and tracking the project through post implementation activities.
• Documented all the functionalities, processing steps, defects worked and lessons learnt for easy maintenance of the project.

Environment: Unix - AIX, Oracle 11 G SQL, PL/SQL, Bash shell scripting, NDM, FTP, SFTP, HP Quality Center, IBM rational clearcase, Notepad ++, streamweaver, SQL*PLUS, SQL*LOADER, CRONTAB.

PL/SQL and UNIX shell scripting Developer

Confidential, NC

Responsibilities:

• Worked as a lead developer and implemented dis project wif zero TR count.
• Analyzed and understand all the business requirements of the monthly/yearly reports wif application statistics and transformed into a technical and functional design document
• Analyzed all the functionalities/logs/database tables from where I can gather all the required information for these reports and logged all the details in design document
• Worked on complete data modelling changes - Created multiple tables, constraints, relations to hold specific data.
• Developed script to transform unstructured data to structured data file wif all the required fields and Loaded to database tables by using SQL*LOADER utility
• Created various PL/SQL procedures/function/Explicit CURSORS/Triggers for generating monthly and yearly reports wif business statistics
• Developed Perl scripts tofetch/compute required information from application logs and to generate the data file required for data load.
• Developed Perl scripts for executing plsql procedures for report generations.
• Developed logicfor removing junk characters in data file while loading to database.
• Automated the execution of Data file creation, data loading, Report generation scripts and scheduled autosys jobs.
• Unit tested the code in Development server and was actively worked wif testing team on the functionality testing and data validation
• Worked wif DBA for executing data model changes in production environment and tracking the project through post implementation activities
• Documented all the script usage, Processing steps, lessons learnt and trouble shoot methods for easy maintenance of the project.

Environment: Oracle 11 G SQL,PL/SQL, SQL*LOADER, ETL, Oracle Reports, UNIX shell &Perl scripting, Autosys, SFTP, NDM, HP QC, IBM Rational Clearcase, Win SCP

PL/SQL and UNIX shell scripting Developer

Confidential

Responsibilities:

• Worked on ORACLE Database 11g SQL, PL/SQL, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
• Developed Shell, Perl scripts and stream weaver control cards and scheduled the scripts by using autosys.
• Below are the key responsibilities
• Requirement gathering, Analyzing, designing, developing and deploying new functionality being incorporated in MMS-mail management system.
• Fixing the ongoing items dat emerge out of Production issues/outages/installations.
• Providing UAT support for Testing process of developed application
• Developing Shell Scripts, Perl scripts, PL/SQL stored procedures to automate the manual activities.
• Coordinated wif front end design team to provide them wif the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files.
• Created and modified several UNIX Shell scripts according to the changing needs of the project and client requirements.
• Worked on the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation, extraction and validation.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions, explicit cursors.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Worked on Shell scripts calling PLSQL procedures to dump the data into .txt/.csv files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN.

Environment: Unix - AIX, Oracle 10g/11g SQL, PL/SQL, Bash shell and PERL scripting, NDM, SFTP, HP Quality Center, IBM rational clearcase, Eclipse, Notepad ++, streamweaver, AFP & BTB viewers, SQL*PLUS, SQL*LOADER, CRONTAB.