SUMMARY

• Broad experience of 8 years as a Senior programmer, forensic examiner, technician and web developer with excellent logical and analytical skills, enthusiastic, self - motivated, quick learner and team player with excellent communication, easy to work with, dedicated and interpersonal skills.
• Excellent working and conceptual knowledge of Oracle, SQL Server, PL/SQL, TSQL, Developer forms and reports, Stored Procedures, Functions, Triggers and Packages, UNIX Shell scripting, HTML and Java.
• Proficient in writing packages, stored procedures, functions, views and database triggers using SQL and PL/SQL in Oracle. Wrote UNIX Shell scripting to wrap SQL and PL/SQL code, scheduled archive process, report generation and generating interfaces files for third party systems.
• Extensive experience in performance tuning and optimization of SQL statements using explain plan, hints, SQL trace, DBMS SQLTRACE and TKProf. Worked with DBA’s to re-configure and fine tune the development and test databases, also provided guidance and inputs for configuring production database and DBA’s related activities.
• Excellent technical skills with clear understanding of design goals of ER modeling for OLTPand dimension modeling forOLAP.
• Extensive Experience in using various Web Technologies like JSP, JavaScript, Angular JS, JQuery, Bootstrap, HTML5 and CSS3.
• Experience in developing and designing front end, component-based and object-oriented systems for building multi-tier architecture with hands-on development expertise in front end GUI layer.
• Responsible for the whole software development life cycle activities of the system like debugging, testing, and deploying the applications, reviews of gap analyses, functional requirement documents, creation of technical documents, flow diagrams and related test case documents.
• Debugged, analyzed and fixed the issues found when upgrading from Oracle 9i to Oracle 10g and played a key role in production support by performing tests, trouble shooting, bug fixing and scheduling jobs to automate application execution in integrated systems environment.
• Designed, developed and enhanced developer forms and reports as per business functional requirements.
• Worked in fast paced agile environment and makeshift ad-hoc environments.
• Understanding and applying of managerial concepts and techniques in areas such as work planning, project management, delegating, coaching, mentoring and evaluating.
• Develop conversion script to convert non-partitioned high data volume table to Partitioned table and implement for performance improvement.
• Upgrade, maintain and troubleshoot Oracle Forms and Reports
• Resolve issues with Oracle 11g Forms/Reports application, such as workstation using side printers for slip printing and other reported problems.
• Develop a best practice or standards document for Oracle 6i/10g/11gForms/Reports application development.
• Assist in the migration and resolution of issues of the following Oracle 11g Forms and Reports applications to the Oracle Exalogic Servers.
• Customize standard Unmapped Subsidiary Accounts report using Oracle Reports as per the user requirements for General Ledger Consolidation purposes.
• Worked on solving the behavioral difference issues between 10g and 11g forms debugging the errors.
• Design interface programs to facilitate transfer of large volumes of legacy data from flat file to Oracle Apps modules like AP, AR, GL and FA.

TECHNICAL SKILLS

Operating systems: Windows 98/XP/NT/2000, UNIX, Linux, and Sun Solaris 7.

Programming Language: PL/SQL, Oracle SQL PLUS, COBOL, C/C++, C#, Visual Basic 6.0, Java and HTML.

Databases: ORACLE 8, 8i, 9i, 10g,11g, MS-Access, SQL Server.

SQL Utilities: SQL* Loader, TKPROF.

GUI Tool: Oracle Forms and Reports 6i.

Other Tools: MS-Office, MS-Visio, SQL Navigator, TOAD, Rational Rose, LivelinkMigrate Util, Clear Case, MS-Visual Source Safe, Crystal ReportsMercury Test Director, Autosys, UWCC and MS-Share Point Server.

PROFESSIONAL EXPERIENCE

Confidential, NY

Oracle PL/SQL Developer

Responsibilities:

• Worked on Migration of data from Sybase database to Oracle database.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX shell Scriptsper the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Used Various PHP sites (a variety of versions) need to have specific vulnerabilities remediated, as well as apply experience and expertise to see if other vulnerabilities might exist. SQL injection, cross site scripting, etc.
• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Participated in analysis of data structures in both the current Sybase database and the new Oracle system database design.
• Participated in data mapping and defining business rules.
• Worked on preparing a testing and verification plan for the data extract.
• Worked alongside the Transfer & Implementation vendor to address issues in the migration of data to the new database.
• Worked on developing the technical documentation to define the new system database.
• Knowledge in AWR Oracle Report generation from Oracle Instance
• Various procurement and receivables applications like Smart Plant Materials and great plains
• Maintenance of Production Test Databases
• Design and development of many form screens and reports according to business needs
• Performed huge real state arithmetical operations as per the business
• Performed Import Export to SQL Server.

Environment: Oracle 11g, Oracle 12c, SQL*Plus, PL/SQL, SQL, UNIX Shell scripting, Oracle JDeveloper, SQL*Loader, TOAD.

Confidential, Boston, MA

Oracle PL/SQL Developer

Responsibilities:

• Created database objects like Tables, Indexes, and Sequences and Views etc.
• Modified the existing database objects to meet the expanding business requirements.
• Involved in design, development and Modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.
• Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
• Identifying and solving issues caused by plugins or feeds under PHP, MYSQL, MS-SQL HTML, CSS, JavaScript and JQuery Technology.
• Worked with the Database Schema design and normalization for database accessed by the procedural PHP pages.
• Involved in coding of data extraction scripts as per technical specifications
• Worked to translate business information requirements into technical data definitions.
• Worked closely with business analysts to understand and document business needs for decision support data.
• Responsible for writing and modifying shell scripts in UNIX.
• Created shell scripts to pull the data from database and load back into base tables.
• Written UNIX shell scripts and scheduled cron jobs.
• Responsible for creating the technical design document.
• Involved in Development, Testing and Maintenance of the System.
• Responsible for troubleshooting the errors that occurred when the production and testers hit a roadblock.
• Created control files, external tables and used SQL* Loader to upload bulk data into Oracle tables.
• Developed Menus in such way that users can access the forms through menus
• Development of Custom screens using Forms10g based on Stored Procedures to implement complex business functionality, Tab canvases.
• Development of Unix Shell scripts to monitor Crontab jobs, UNIX shell scripts run the stored procedures/functions from UNIX
• Development of code using Packages, Stored Procedures/Functions to facilitate business needs.
• Performed database tuning using EXPLAIN PLAN, TKPROF and SQL TRACE, enabling session specific trace using DBMS MONITOR.
• Developed Object Libraries to maintain standards in the Application.
• Usage of bulk inserts to insert the data into multiple tables.
• Developed Reports10g/9i to meet the business needs.
• Designed a workflow management system to streamline the process.
• Was involved in fast paced Agile environment
• Development of dynamic Reports by using Lexical parameter to run the Generic Reports.
• Using Data mapping tools to transfer data between source databases to destination database.

Environment: Oracle 11g, SQL*Plus, PL/SQL, SQL, UNIX Shell scripting, Oracle JDeveloper, Forms 6i/10g, SQL*Loader, Discoverer, TOAD

Confidential, Beaverton, OR

Oracle PL/SQL Developer/Programmer and Batch Coordinator

Responsibilities:

• Involved in the design and implementation of the process for loading the weekly loads coming from flat files in to staging tables in the Oracle Database using SQL* Loader and also developed a script to load the staging data into the production tables using PLSQL.
• Used Bulk inserts/loads wherever required.
• Created and worked on partitioned tables on very huge data.
• Worked on Oracle Import and Export utilities for data backup to resolve the space issues by exporting the partitions and then truncating the partitions to save the space and importing the partitions back whenever the data is required.
• Developed and maintained UNIX shell scripts to process extracts and loads and assigned them to the crontab for automation.
• Developed a script to run the reports for weekly health checkups, finding free tablespace, weekly production load report, and process adherence reports and tracking table reports.
• Extensively involved in Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Involved in the creation of database objects like tables, views, stored procedures, functions, and packages.
• Created and used Table Partitions to further improve the performance while using tables containing large amount of data.
• Developed PL/SQL packages using Oracle Standard/ Custom Exceptions.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Optimized existing queries for better performance and less impact on database.
• Used Dynamic SQL for interface programs and exception handling routines.

Environment: Oracle 10g/11g, SQL*Plus, PL/SQL, SQL, PHP 5.2, UNIX Shell scripting, Oracle JDeveloper, Forms 6i/10g, SQL*Loader, Discoverer, TOAD, HTML, CSS, Javascript.

Confidential, Lake Oswego, OR

Oracle PL/SQL Developer

Responsibilities:

• Involved in discussions with the business partners and business analysts to understand the requirements and provide data driven solutions.
• Writing Database Programs using PL/SQL based on new Measures.
• Tuning the SQL statements for optimal performance.
• Worked with Global Temporary Tables (GTT) to limit the database touches.
• Creating/expiring Reference Data based on the Design documents.
• Developed Pipeline functions to do ETL operations.
• Benefited with External Tables to load large files into database.
• Experience in writing Materialized Views.
• Designed and maintained Web forms and Banners PHP Coded, implemented upgrades, patches, code releases, and database changes
• Created Function based Indexes to counter full table scans.
• Used System Defined Exceptions and User Defined Exceptions.
• Prepared Patch run scripts, rollback scripts for each Release.
• Worked extensively in developing, deploying, and testing of Oracle packages.
• Used Subversion to maintain PL/SQL code (Code Check-in, Code Updates)
• Participated in Code Reviews of PL/SQL modules.
• Closely worked with Business analysts, data modelers in the design, development of data warehouse/data marts.
• Developed stored procedures and functions using MySQL to support Java Applications.
• Generated Physical Design Documents (PSDD), Process Flow Diagrams (PFD) and Data Model Diagrams (DMD) to document critical aspects of design.
• Worked on Performance Optimization of various modules by tuning the SQL and PL/SQL programs using Explain Plan, Optimizer Hints, SQL Trace, DBMS PROFILER, and TKPROF.
• Provided high level design inputs keeping in mind the strategic objective of the company while implementing ETL solutions for the Decision Support Systems (DSS).
• Worked with other team members to influence software strategies and directions in backend systems.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases Worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, DB links and privileges
• Effectively used Triggers to track the user profile updates and to send the messages to downstream systems
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance

Environment: Oracle 10g, SQL, PL/SQL, TOAD 9.1, UNIX Shell Scripts, SQL*Loader, SQL *Plus, TOAD

Confidential, CA

Oracle PL/SQL Developer

Responsibilities:

• Migrated Informix procedures to the Oracle.
• Migrated java Batchjobs to Oracle
• Coding of Load Module in PL/SQL, Database Package and writing Shell Script to run the Interface as a part of nightly batch process, generate log files.
• Used standard packages like UTL FILE, DMBS SQL, PL/SQL Collections, and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used SQL*Loader for data loads.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 10g.
• Created partitions for parallel processing of data.
• Created Unix processes using with KornShell to run automated and Oracle processes.
• Developed UNIX scripts to create FTP Jobs.
• Maintaining Deamon process in Unix to send error mails if any FTP problems are arising when Data sending to other teams or, another Servers.
• Developed Functional and Technical documents.
• Developed flowcharts using Microsoft Visio 2003.
• Tuned the SQL statements using execution plans generated using TOAD and SQL*Plus.
• Further tuning using Oracle trace and TKRPOF utilities.

Environment: Oracle 10g, AIX 5.3, Windows NT, SQL, PL/SQL, TOAD, Microsoft Outlook, Informix, Java SDK 1.5, Eclipse 3.2.2, Hibernate Tools 3.2 beta9, Maven 2.0

Confidential, Louisville, KY

Oracle PL/SQL Developer

Responsibilities:

• Created thedatabase triggers, Integrity constraintsfor the data validations.
• Involved in understanding theuser requirements, making presentations and technical documentation.
• UsedPL/SQL tablesand records in transaction processing.
• Used theOracle 10g features bulk bind anold bulk collect for performance improvementin batch transaction.
• Usedmulti-table inserts a new feature of Oracle 10gto load data into new application from source systems which reduces table scans andPL/SQL codenecessary for performing multiple conditional inserts compared to previous versions.
• Its main use is for theETL processin data warehouses where it can be parallelized and/or convert non-relational data into a relational format.
• TakingBackup & Recovery of Database Using Logical (Export & Import) & Physical (Online & Offline) Backup.
• Built webenabled applications using Oracle XML packages.
• Worked with Oracle external table’s new feature of Oracle 10gwhich allows Oracle to query the data that is stored outside the database in flat files. They are useful in theETLprocess of Data warehouse and can be queried in parallel.
• Modification of source code for Data Entry forms and Reports
• Usedparametric cursors and ref cursors.
• Worked withmaterialized views.
• Writingshell scripts to automate repetitive tasks.

Environment: Oracle 10g/9i/8i, SQL, PLSQL, SQL*Loader, KORN Shell script, TOAD, and UNIX.

Confidential, North Carolina

Oracle Developer

Responsibilities:

• Involved in analyzing business requirements and designing the functional specifications and translated functional requirements into technical specs.
• Designed and developed the system using Oracle CASE Generation Methodology
• Analyzed and modeled data from Logical to Physical Data models using both DFD and Erwin
• Created SQL and PL/ SQL scripts, calling C external routines from within PL/ SQL for transfer of data between the databases
• Designed and Generated reports using REF cursors
• Integrated and implemented the system & responsible for troubleshooting
• Involved during User Acceptance Testing of the application
• Participated in status meeting and walkthroughs
• Created Stored Procedures, Functions, Packages, Triggers using SQL, PL/ SQL.
• Used Shell Scripts for day-to-day use of queries on Data Dictionary and other common tasks on UNIX.
• Preparing the Program specification for the procedures built, scripts used and tables used. Involved in Testing and Documentation.
• Wrote complex SQL queries, Control files, Procedures, Triggers and PL/SQL Packages used for data validations, error handling and data cleansing activities.
• Designed and developed Library files (PLL) that are commonly used across the application.
• Used SQL * Loader extensively.
• Creation of Users and assign them customized responsibilities.
• Analyzed and fixed the data discrepancies between various systems and identified bad data caused due to the data migration from various legacy systems.
• Involved in design and development phases of Software Development Life Cycle SDLC .
• Involved in uploading historical GL Balances through conversion program for various entities
• Used performance-tuning methods to increase the performance of the oracle database.
• Used oracle application server for building reports over the Intranet
• Created new module using Forms and Reports for number portability module.

Environment: Oracle 9i, PL/SQL, SQL, SQL * Loader, TOAD and Windows NT.