SUMMARY:

• An Assertive professional with over 4 plus years of IT experience handling all phases of SDLC like analysis, design, development, implementation and deployment of large software products in both Client/Server and Web Server Environment.
• Experience in Design, Development, and Enhancement and Maintaining applications in Oracle 9i/10g/11g/12c using SQL, PL/SQL.
• Expertise in Database Design, Development, and Enhancement and Maintaining using Oracle 12c/11g/10g/9i/8i, Web deployment, PL/SQL Forms 10g/9i, Oracle SQL Loader in Windows and UNIX environments.
• Proficient in PLSQL programming, designed and developed Stored procedures, Functions, Triggers, and Packages to provide database access and manipulation functionality
• Developed and Automated batch load process using SQL*Loader, Shell scripts and Crontab
• Used oracle features like Collections, Ref cursors, Analytical functions, Global temp tables, External tables and Materialized views
• Expertise in database performance, data warehouse, ETL, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers, interfaces and data conversion using PL/SQL, SQL*plus, TOAD, and SQL developer & full suite of Oracle Tools including development and customization of Oracle Developer (Reports & Forms) and Oracle discoverer.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g/12c, MySQL 5, MS SQL SERVER 2005/2008, DB2/UDB, SAP Tables and MS Access

Other Technologies: HP Project and Portfolio Management (PPM), HP ALM/QC, Oracle E - Business Suite 12, Oracle Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM)

Programming Languages: SQL, PL/SQL, Unix shell scripts, SAS, C/C++/C#, Perl, XML, HTML, VB.NET

ETL Tools: IBM Info Sphere Data Stage, Informatica

Data Warehousing: Star & Snow-Flake Schema Modeling, Erwin, Sybase Power Developer, SSIS, SSRS, OWB, ODI

Dev. Tools: Windows/Linux/Mac OS Environment, Eclipse, Git, XCode, Subversion (SVN), CVS, ClearCase.

Tools: TOAD, SQL*PLUS, SQL Developer, SQL*Loader, Crystal Reports, Forms 6i/9i/10g, Reports 6i/9i/10g, Work Flow Builder and XML Publisher.

PROFESSIONAL EXPERIENCE:

Confidential , Rochester, NY

Oracle PL/SQL Developer

Responsibilities:

• Working with Oracle support for resolution on Workflow Mailer issues.
• 24x7 Production support of Oracle Applications Administration.
• Experience in various Oracle Financial applications like PeopleSoft, Oracle EBS etc.
• Worked in various financial modules like Oracle Assets, Oracle General Ledger, Oracle Payables, Oracle Receivables and Oracle Cash Management.
• Scalability/HA solutions included Oracle RAC, implemented and supported Share plex for Data replication, supported Oracle Golden Gate Replication and Active Standby(11gR2).
• Maintained users, roles and privileges in Oracle database for the development team.
• Created various database objects like tables, views, materialized views, procedures, functions and packages using oracle tools like Toad, SQL Developer and SQL* plus.
• Extensively used bulk collection in PL/SQL objects, partitioned the fact tables and materialized views for improving the performance.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Transferred SQL and Korn shell programs into ODI and created data extracts.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Involved in Importing and exporting the Tables, Users, and Schemas.
• Designed DW tables, scripts, ETL maps and ODI Extracts, Configured ODI modules and ETL tools and supported accessible applications, and Documented and maintained ETL specifications and processes.
• Experience with custom development of data warehouse, operational data store, and OLTP systems.
• Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Database Triggers.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.

Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, CVS, TOAD, UNIX, Shell scripting.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Involved in development, maintenance of Triggers, Joins, Cursors and Views.
• Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
• Created Shell scripts to access data and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Developed UNIX Shell Scripts. Customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g.
• Optimized the performance using PL/SQL table types and record types.
• Did SQL and PL/SQL programming for ODI and oracle.
• Developed AR Credit memo and AR Customers forms.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Analysis and generation of mainframe commands to add users to missing mainframe groups as well as analysis of RACF permission sets and reporting of access that users may lose based on the cleanup process.
• Played a key role in designing the dimensional modeling of star schema for the enterprise data ware house of ODS.
• Participate in upgrading Oracle database(s) and Oracle Warehouse Builder to Version 11.2.0.4
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Developed the code using Core Java Concepts Spring Framework, JSP, JavaBeans, Web Services, Java Script, XML and HTML.
• Developed views and controllers for client and manager modules using Spring MVC and Spring Core.
• Designed static and dynamic web-pages using HTML, CSS, java script, jQuery. Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client.
• Wrote SQL queries to developed test data for use during test execution.
• Perform Inbound Interface by creating Temporary tables, then Validate data and then Load into Interface Tables by using SQL Loader.
• Worked on MS Access to Oracle 10g database conversion including tables, queries, standard procedures, forms and triggers.
• DataStage jobs were scheduled, monitored, performance of individual stages was analyzed, and multiple instances of a job were run using DataStage Director.

Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g,CVS, TOAD, UNIX, Shell scripting, HP PPM, Oracle Warehouse Builder 11.2.0.2, Subversion (SVN), CVS, Perl.

Confidential, Miami, FL

PL/SQL Developer

Responsibilities:

• Built analysis model using SQL, R and VBA. Designed database structure, backend code connection and statistic model in R.
• Analyzed the databases for data issues. Some of these issues included: linear referencing of pipeline data, looking for gaps, anomalies, etc.
• Converted custom forms using Forms in Installed base for global update of instance.
• Worked with business analysts for formulating the ER diagrams and data flow diagrams.
• Interaction with client / business teams for clarifications / updates.
• Developing Sql Loader to insert bulk data into staging tables from flat files.
• Participated in developing a Data Warehouse using Oracle Warehouse Builder. Created universes and business objects using SAP Business Objects. Wrote ETL using Oracle Warehouse Builder.
• Involved in Extraction, Transformation and Loading of data and store the data into staging tables for further various analyses.
• Was responsible for testing the integration of Intrepid Asset Management solution with SAP Linear Asset
• Customized the reports for Financial Module (GL, AP, and AR) using Report Builder.
• Involved in database development by creating PL/SQL functions, procedures and packages
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity
• Developed Triggers for inserting/updating of tables
• Developed optimized PL/SQL API using Collections, Bulk Collect, Result Cache, Materialized view, Pipelined, Java Stored Procedure, External Procedure, various DBMS and UTL package.
• Used inner joins, outer join, union, union all and sub queries for filtering the Data
• Created views to analyze complex queries
• Tuning SQL and PL/SQL code using Statistic Collection, Oracle Hint, Table Partition, Parallel, TKPROF, Explain Plan and Automatic SQL Tuning techniques.
• Involved in generating Web Base Reports for Clients

Environment: SQL Server 2005/2008, Oracle 10g, Oracle Forms 9i/10g, Reports 9i/10g, IBM Web Sphere Data stage and Quality Stage, Cognos 8 BI, Sybase TOAD, Crystal Reports, Erwin, Forms and Reports, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.
• Designed database structures for effective data extraction, validation, run detail notification and error logging.
• Used SQL* Loader and PL/SQL stored procedure for data conversion and interfaces processes.
• Designed and developed PL/SQL functions/ stored procedures/ cursors/ triggers/ packages.
• Assisted in day-to-day duties of DBA work like taking backup and recovery of database environment.
• Performed several Automations written in Perl-DBI/DBD and UNIX Shell scripting in an Agile environment.
• Involved in data loading using PL/SQL and SQL*Loader and cron jobs calling UNIX scripts to download and manipulate files
• Analyzed C/Java sources to gather business rules for the application and converted them into/SQL codes
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle

  Form Builder 6i.

• Used Perl to implement reports and new features in the Web GUI.
• Involved in writing complex/ad-hoc queries to generate reports as per client request as a part of production support.
• Generated Matrix Reports for business operations, status and Asset Management reports using Oracle Reports 6i
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
• Involved in fine tuning and optimization of different SQL queries to insure faster response time.
• Assisted in designing End User Layouts (EUL’s) for Oracle Discoverer Reports based on the user/client requirements.
• Resolved Priority Production Support Issues and Defect Fixes.

Environment: Oracle 9i/10g, Forms 6i/10g, Perl, UNIX, shell script, SQL*LOADER, TOAD, SQL*Loader, Toad.