SUMMARY

• Developed database design (logical and physical models) by understanding relational database concepts such as indexes, primary and foreign keys and constraints.
• Solid experience of creating PL/SQL Packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Ability to develop UNIX shell scripts in applications that schedule, validate flat file data, Execute SQL, achieve files or FTP files.
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Table Partitioning, Trace utility, TKProf, DBMS PROFILER & DBMS STATS.
• Experience in creating SQL* loader scripts to load data from flat files into the database and also creating External Tables to manag e data which is store at the OS level.
• Effectively made use ofIndexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
• Worked on Forms and reports using Oracle Forms/Reports Builder 11g.
• Implemented features including Materialized views, Autonomous Transactions, Coding Dynamic SQL Statements.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Experience in using Automation Scheduling tools like Autosys, CA7, OPC/TWS and Control - M.
• Involved in various phases of Agile as methodology in which we used Scrum as architecture design and development.
• Monitor and execute Mainframe batch cycles and maintain priorities on local and remote systems to ensure successful completions.
• Performed various roles during my career in Mainframes as a specialist in most of the Mainframe server system performances (Z/OS Upgradation, Disaster Recovery and Service Delivery) and also in Maintenance & resolving production fixes.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.

TECHNICAL SKILLS

• SQL
• PL/SQL
• Oracle 10g/11g/12c
• DB2
• UNIX
• Shell Scripting
• Performance Tuning
• Core Java
• SOAP UI
• TOAD
• ETL Concepts
• Erwin
• JIRA
• ALM
• Sub Version winCVS
• Splunk
• Confidential Cognos programming
• SQL*Loader
• JCL
• CICS
• IDMS
• IMS
• Netview
• Omegamon
• COBOL
• FileZilla
• WinSCP
• OS/390 z/OS
• MS Windows NT 4.0/XP/ Win 7
• Linux
• OpenVMS
• Unix
• Solaris.

PROFESSIONAL EXPERIENCE

Oracle PL/SQL Consultant

Confidential, Monroeville, PA

Responsibilities:

• Preparing project-phase plans and implementation schedule, plan and conduct meeting and workshops relative to the project plans, and communicate day to day project status to all levels of management
• Created Stored Procedures for Batch Processing and also involved in moving large data using Bulk Insert forall methods.
• Analyzed data integrity problems and provided assistance in giving solutions.
• Responsible for troubleshooting, debugging, problem solving and tuning for improving performance of the backend application programs
• Involved in coordinating onsite and offshore communication / meetings.
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data usingPL/SQLProcedures.
• Developed unix shell scripts to load data into database and also automate backend jobs.
• Debugging the scripts and jobs in Production environment written in Shell.

Oracle database developer

Confidential, BOSTON, MA

Responsibilities:

• Involving in the estimations for the project, perform analysis on the business requirements and prepare High Level Design and Low Level Design
• Create the technical design document and convert them into technical specifications.
• Configured and designed Entity Relationship Diagram (ERD) with Data Design team to illustrate the logical structure of the database.
• Involved in performance tuning - analyzing query plans and query tuning.
• Designed and modified database tables, keys, indexes, views, type objects, grants, triggers, Exception handling methods, Packages, Functions and Procedures etc.
• Partitioned tables using Range partitioning, List partitioning and created local indexes to increase the performance and to make the database objects more manageable.

Senior System engineer

Confidential

Responsibilities:

• Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic,pl/sqltables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
• Created various SQL and PL/SQL scripts for verification of different functionalities.
• PerformedSQLandPL/SQLtuning to improve the performance with the help ofSQLTrace, Explain Plan, Indexing and Hints Created TRIGGERS to Audit the changes to data in main Tables.
• Involve with Business Analysts and Front-End (JAVA) users to develop the Application and fix the bugs.
• Replaced time-consuming manual processes with neat automated solutions.

System engineer

Confidential

Responsibilities:

• Responsible for Analysis, Design, Coding, Debugging and Deployment.
• Experienced in troubleshooting traditional export/import and data pump export/import.
• Worked on minimizing CPU overhead by TuningSQLStatements, Tuning Subprogram Invocation and Tuning computation-intensivePL/SQLCode
• Involved in writing complexSQLQueries to implement the business requirements
• Created UNIX shell scripts to automate manual processes.
• Involved in writing complexSQLQueries to implement the business requirements
• Worked on SQL*loader to load data into database.
• Performed SQL and PL/SQL tuning and Application tuning.
• Provided timely technical resolutions for defects for production environment.

System engineer

Confidential

Responsibilities:

• Handling Mainframe Batch job abends and identtify delays in critical batch.
• Perform analysis and investigation of logs, trends, alerts, notifications.
• Well experienced in performing HMC activities such as activating/deactivating Lpar, TIME change, Standalone dumps, handling hardware messages.
• Perform scheduled/unscheduled IPLs using HMC(Hardware management console).
• Mainframe system maintenance activities.