SUMMARY

• Over 8 years of experience in Physical database design, Logical database design, Gap Analysis, Data Exports & Imports, Application Support, Performance Tuning, Oracle Tuning & Optimization and Application Development using Oracle 11g/10g/9i, PL/SQL, SQL*Loader.
• Worked as Oracle DBA in production environments specializing in Oracle Performance tuning and SQL tuning and monitoring for high availability of Real Application Clusters (RAC).
• Experience in Data Analysis, Data Modeling, System Design and Requirement Analysis, Asset Management, Business Process Modeling in Finance, Banking, Retail, Insurance industries and Capital Markets.
• Proficient in writing Packages, Stored Procedures, Functions, Cursors, Constraints, Triggers, Indexes (B - tree Index, Bitmap Index), Views, Materialized Views, Database Links, and Export/Import Utilities using PL/SQL, SQL in support of ETL and Business Logic.
• Experience in writingSQL queries, Views, Materialized Views, PL/SQL Procedures, Packages, Functions, Triggers, Cursors, Collections, Ref cursor, Cursor variables.
• Worked on PL/SQL scripts to create and drop database objects including Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Experience with Oracle supplied packages such as DBMS SQL, DBMS JOB, UTL FILE and partitioned large tables using range partition technique.
• Expertise in loading data from flat files to the database tables usingSQL*Loader, External Tables, UTL Utilities.
• Proficient in Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc).
• Proficient in writing and tuning complex SQLstatements, complex joins co-related sub-queries and SQLstatements with analytical functions (Rank, Lead, Lag, Connect by level etc).
• Experience in writing Dynamic SQLStatements using EXECUTE IMMEDIATE and DBMS SQL.
• Extensively worked with Arrays, Records, Dynamic SQL and Exception Handling.
• Experience in developing and executing UNIX Shell Scripts and PERL Scripts and in manipulating files and directories.
• Responsible for Database Cloning, Patch Application, UNIX Shell Scripting, Backup& Recovery and Documentation.
• Experience in installing and configuring Oracle11g grid and Data Guard maintenance in large environments.
• Experience in creating database and database objects such as table, index, table space, rollback/undo segments and views and analyzed relevant objects to collect statistics to tune the system performance.
• Experience in replicating database using snapshots, materialized views, import/export and advanced replication methods.
• Experience in Java build tools such asAntandMaven.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX, Linux, AIX

Middleware SOA Integration Products: JCAPS 6.3 & 5.1.3, eGate SRE 5.x, Glassfish ESB, MTS, IBM MQ Series, BMC PATROL WebSphere MQ 4.1, IBM Websphere MQ Explorer 7.1, MQ Visual Edit 1.6.4.1, Introscope

Languages/Integration: Java, XML, Web Services, JAX-WS (SOAP), JAX-RS (REST), XSD, JIBX

Oracle / Tools: Oracle 11gR2, 10g, 9i, SQL Server 2005 and 2008, Oracle Products:Oracle10g (Grid Control), OEM (Oracle Enterprise Manager), RMAN, OEM 12C, SQL*Loader, Import and Export(EXPdp/IMPdp), ASM, TKPROF, SRVCTL, SQL * Net, Golden Gate.

Web Technologies: J2EE (Servlets, JSP, EJB), JDBC, AJAX, JQuery, JavaScript, AngularJS, HTML, CSS

Testing: Junit, Integration, Regression, UAT and Post-Production Testing

Framework: MVC Architecture, Jakarta Struts 1.1, Spring 3.1, Hibernate 3.1, JSF 2.0, Axis

QualityTools: Win CVS, CMVC, Tortoise SVN 1.8.4, HP Quality Center 10

IDETools: NetBeans 6.9, MEB 2013 (My Eclipse Blue 11.0), WSAD 5.x

Tools: and Packages: Ant 1.7.1, Apache Maven 3.0.5, Log4J, UML, RAD, FTP, MS Visio, BMC Remedy 7.5, Service Now, Requestit, Microsoft Solution Center, JIRA 6.0, Splunk, Atlassian Bamboo 4.3, Altova XML Spy, Access Now

Servers: WebLogic Server 10.3.5, IBM WebSphere Server 8.5 (WAS 8.5), Tomcat Server 7.x, Glassfish V2

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Oracle PL/SQL / UNIX Shell Scripting Developer

Responsibilities:

• Created reporting system including data model and dictionary, ETL, and Web reports.
• Extensively worked with troubleshooting of reporting, and ETL issues with distributed teams.
• Used Knowledge modules such as LKM, IKM, CKM, SKM, JKM and RKM for loading data.
• Utilized variables of ODI in interfaces and packages to perform filtering of data in flat files and then loaded only necessary data.
• Utilized ODI operators for error handling and also monitored the data loading process.
• Experience on ODI operators, Topology and other ODI tools and worked on transformations using ODI designer.
• Worked on migration from OWB to ODI version 12.1, migration from 12.1.3 to 12.2.1 using migration utility.
• Involved in project planning sessions with project managers, business analysts and team members to analyze business requirements and proposed IT solutions.
• Experience in creating executive reports with BI Publisher integrated withOBIEE.
• Strong experience in usingOBIEEAnswers to create queries, format views and charts, adding user interactivity and dynamic content to enhance the user experience.
• Involved in development of jobs in Data Stage 8.5.
• Involved in developingData Stage Designer Server and Parallel jobs for Extracting, Cleansing, Transforming, and Integrating/Loading Data into Corporate Data Warehouse.
• Designed ksh scripts from system admin tasks.
• Installed & configured KVM guests RHEL5 & RHEL6 .
• Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.
• Built complex queries using SQL and designedstored procedures & packagesusing PL/SQL.
• Designed PL/SQL Stored Procedures, Functions, and Packages to implement Business Rules.
• Designed and developed PL/SQL Functions, Stored Procedures, Cursors, Triggers and Packages.
• Involved in day-to-day duties of DBA work like taking backup and recovery of database environment.
• Designed database structures for effective data extraction, validation, run detail notification and error logging.
• DevelopedPL/SQLETL scripts to transfer data across the schemas and databases.
• Involved in development of jobs and scheduled jobs using Autosys for automation.
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server using various FTP batch processes.
• Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
• Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the existing application in the form of flat files and loaded the extracted data into the new proposed application, as a part of migration.
• Developed back-end PL/SQL packages and built UNIX shell scripts for data migration & batch processing.
• Involved in Database Performance Tuning using Oracle Hints, EXPLAIN PLAN, TKPROF, Partitioning and Indexes.
• Designed Korn and awk scripts to analyze security of AIX pSeries boxes.
• Worked on Securing AIX systems and implemented TCP Wrappers and Secure shell.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Handled JSP compilation and worked on remote applications.
• Actively participated in R12 upgrade with 4 member team.
• Provided production support for SOA and Agile Applications.
• Developed Maven Script for the build and dependency process.
• Monitored and scheduled UNIX scripting jobs.
• Mandated version control through Subversion.
• Performed Unit Testing UsingJunit.
• ImplementedLog4Jto trace logs and to track information.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files.
• Created database objects like tables, views, materialized views, procedures and packages using oracle tools like TOAD, PL/SQL Developer and SQL* plus.

Environment: Oracle 10g, 11g, ASM, AIX, Database Control, TOAD, OEM (Oracle Enterprise Manager) 11g r2/12c, Data Guard, Siebel eScript / VB script, SQL, PL/SQL, Shell script

Sr. Oracle PL/SQL Developer

Responsibilities:

• Implemented various customized Oracle reports using different techniques in Oracle SQL and PL/SQL.
• Analyzed and converted application requirements into functional design.
• Performed Unit testing on PL/SQL Packages and procedure, functions according to business requirement.
• Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance.
• Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
• Designed and implemented client-server application using Oracle Forms Builder and using Forms Builder 11g
• Involved in designing complex SQL queries, subqueries and complex joins based on the transformation rules and the STTM document.
• Performed regular database activities such as backup, monitoring, issue resolving through Remedy.
• Created and modified complex functions, stored procedures, packages and triggers by using Oracle PL/SQL based on the business rules.
• Extensively worked on Schema Migration, Database Program Migration, Data Migration from Sybase to Oracle using Oracle SQL Developer.
• Performed tuning using various tools such as EXPLAIN PLAN, DBMS PROFILER, Indexes, Hints etc.
• Worked on Dynamic SQL using EXECUTE IMMEDIATE and DBMS SQL along with Bulk Collect.
• Created Mail Scripts in UNIX to send notification on successful completion or failure of various Interfaces and Jobs, with Customized Subject and Text.
• Designed and developed Oracle Database objects like materialized views, and associated objects like triggers and indexes.
• Involved in data load using PL/SQL and SQL*Loader and cron jobs calling UNIX scripts to download and manipulate files.
• Created trigger events using UNIXand Perl to send email to project managers on high severity issues.
• Developed UNIX scripts for sending mails to the bank and the business team when the external feeds to the bank were received.
• Designed UNIX Shell Scripts to run batch jobs, automated processes, and to automate routine systems administration tasks.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Worked on Table partitioning and Index creation to improve the performance of the query.
• Worked with DBAs regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & Integration Testing of Data Migration process using ETL Methodology.
• Experience in using various Oracle PL/SQL collections, VARRAYS,NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
• Assisted in migrating IVMs and VIOS servers on Power-6 and Power-7.
• Migrated LPARs on IVM and VIOS from local storage to SAN storage including setting up redundancy.
• Implemented security using AFS and SSH on AIX 4.3.3
• Performed VIOS OS updates.
• Performed partitioning of tables in data warehouse environment.
• Managed and monitored the data guard and created core databases
• Restored unknown backup to create new databases for corporate applications.
• Managed tablespaces and other database objects.
• Supported and maintained over 4000 core Databases for CISCO.
• Monitored CISCO databases using OEM.
• Handled PSU and CPU new releases and applied recommended patches.
• Managed RMAN reports and oracle version mismatch.
• Created unit test scripts withJUnittool for covering code in various modules.
• UtilizedLog4J to log various events and exception when performing various transactions by the users for debugging purposes.
• Utilized Subversion/SVNas a version control and source repository system.
• Saved huge development time to the organization by implementing Maven framework.
• Created Oracle objects like tables, types, packages, procedures and functions.

Environment: Oracle 9i/10g, Oracle Forms & Reports 6i/9i/10g, PL/SQL, Java, Servlets, JDBC, J2EE, JSP, HTML, XML, MS Access, MS Excel, C, C++, BEA web logic, UNIX, Perl, Informatica, Oracle APEX, TOAD, SQL*Loader, PVCS, SQL Navigator, Eclipse, OBIEE, Lotus Notes, MS Visio, Clear Quest.

Confidential, Urbandale, IA

Oracle PL/SQL Developer

Responsibilities:

• Gathered requirements and reviewed functional requirements, business flows including application security.
• Involved in full database development cycle of Planning, Analysis, Design, Development, Testing & Implementation.
• Generated and developed reports in production by designing complex PL/SQL Stored procedures, Functions and Packages.
• Worked on TKPROF, EXPLAIN PLAN and Hints for performance tuning.
• Worked on PL/SQL Implicit and Explicit Cursors and used Dynamic SQL.
• Designed customized interactive dashboards inOBIEEusing drill down, guided navigation, prompts, filters, and variables.
• Performed multi-source Extraction Transformation and loading (ETL) into the Repository using Oracle Warehouse Builder (OWB) and ODI.
• Worked with different types of sub queries (Inline, correlated) and used loops to suit the business logic.
• Worked with Bulk Collects to improve the performance of multi-row queries.
• Extensively participated in performance tuning for various oracle based application using various methods like SQL Trace, EXPLAIN PLAN, TKPROF etc.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the Database.
• Designed Entity-Relationship model and other design features.
• Created new End User Layer (EUL) for Oracle Discoverer version 10g (9.0.4).
• Created business areas, complex folders, custom folders, simple folders and reports.
• Deployed reports in Oracle Application Server 10g AS Portal.
• Developed database objects (packages, procedures, triggers, views, etc.) to provide custom functionality within Maximo environment.
• Designed and developed Work Order Detail Report, Load Unbalance, Load Reading and Counter Log, List reports using Oracle reports 10g.
• Developed, deployed and maintained JSP Reports, ST TOOL and RTview.
• Extensively used TOAD and SQL Developer tool for effective application development.
• Tuning of slow running queries and queries consuming excessive resources by providing required hints to the query.

Environment: Oracle 9i/10g, Oracle Reports & Forms 6i/9i/10g, PL/SQL, ERWIN, APEX, PowerBuilder, Java, J2EE, EJB, JDBC, JSP, HTML, XML, MS Access, SQR, MS Excel, C++, Informatica, SQL*Loader, CVS, Lotus Notes, TOAD, Dynamic SQL, Eclipse, Web Logic, MS Visio, UNIX.

Confidential, Chicago, IL

Oracle PL/SQL / ETL Developer

Responsibilities:

• Involved in Design, Development and Support phases of Software Development Life Cycle (SDLC).
• Provided 24hrs production support for the databases.
• Proactively performed database-level performance tuning and proactively monitored database systems to ensure secure services with minimum downtime.
• Managed all database objects in a large mission critical system and provided end to end DBA support system and application side.
• Involved in analysis, design and coding of Oracle processes in PL/SQLto build packages.
• Designed and developed Stored Procedures, Functions, Triggers, Cursors using PL/SQL in Oracle 10g.
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
• Developed Ref Cursors to accommodate the business rules.
• CreatedTables, Views, Materialized views, and constraints.
• Developed Forms (like invoicing, Delivery order) and Reports using Oracle Reports and PL/SQL.
• Customized Customer Transaction Analysis Report to change its layout such as changing size of the fields, adding some extra field into the display, changing the display of the Report. Writing after Parameters Triggers for the Validation of the data.
• Created various custom reports like Transaction Aging Report, Credit Card Transaction Report, Active Invoice Register Report, Account Balance Consolidation reports and others using Reports Builder 9i.
• Customized Form filed like enabling, disabling form filed and incorporating oracle alerts using Form Builder 9i.
• Created (or edited existing) Informatica mappings and sessions to accomplish data migrations from various sources such as Oracle, SQL Server 2000, DB2 and flat files and loaded into Data Warehouse.
• Developed ETL scripts using SQL Loader for transferring flat files into database tables.
• Proposed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Liable for development and testing of conversion programs for importing data from text files into Oracle database utilizing SQL *Loader.
• Involved in Database Performance Tuning using Oracle Hints, EXPLAIN PLAN, TKPROF, Partitioning and Indexes.
• Handled errors using Exception Handling extensively for the ease of debugging and displayed the error messages in the application.
• Developed grouping report and matrix reports using oracle reports builder 9i.
• Enforced need of regular data purging processes from production, design and development, to deployment.
• Liable for two critical online applications database’s performance which had a huge business/revenue impact.

Environment: Oracle 10g, SQL, PL/SQL, VBA, Java, J2EE, SQR, HTML DB, JSP, Lotus Notes, HTML, DataStage, XML, MS Access, MS Excel, TOAD, PRO*C, OWB, UNIX Shell Scripting, SQL*Loader

Confidential, Union, NJ

Oracle PL/SQL / ETL Developer

Responsibilities:

• Responsible for database administration for a large and complex database system using Oracle6 and Oracle7, IDMS, IDMS/R and DB2.Responsibilities included performance tuning, database design, data modeling, database installation, technical support, and investigation of new technologies.
• Developed ER diagrams, physical and logical Data Models using MS Visio and Ewin.
• Developed PL/SQL Procedures, Functions, Cursors, and Packages using SQL Developer, TOAD and Oracle 10g.
• Developed PL/SQL Views and Materialized Views with fast and incremental Refresh Rates using Oracle TOAD.
• Installed Oracle DB 10g, 11g RDBMS, RAC on ASM and applied Oracle critical patch updates, Implemented and Managed Data Guard, database Replication, Backup and Recovery support and performance tuning.
• Migrated Non-ASM databases to ASM environment for high availability using RCONFIG.
• Worked on troubleshooting RAC and implemented ASM features.
• Applied necessary patches during installation and also in upgradation of databases.
• Resolved the conflicts between the target and source database in Golden gate.
• Used data pump for schema refresh, and RMAN for database refresh and for backing up databases.
• Performed cold backup for a very huge 15-Tb Database.
• Performed user management, table space management, session management, undo management issues.
• Managed space issues in the database level for table space and regular file system cleanup at UNIX level.
• Generated AWR, ADDM and ASH reports for database issues.

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, EXADATA X2-2, ASM, AIX, Golden Gate, Database Control, TOAD, Tivoli