SUMMARY

• Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Involved in all phases of SDLC (Software Development Life Cycle) from analysis, design, development,testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Have worked closely with end users and development teams translating business requirements into technical specifications and deliverables.
• Experience using Client - Server application development using Oracle 11g/10g, SQL Plus, TOAD, and SQL Loader.
• Effectively made use of Table Functions, Indexes, Analytical functions, Materialized views, Table partitioning, collections etc.,
• Good knowledge on logical and physical Data modeling using Normalization techniques.
• Extensively worked on creating data base objects like tables, views, constraints, user defined datatypes and indexes.
• Expertise in the design and development of SQL and PL/SQL codes through development of stored procedures, functions, triggers and packages to implement the business logic in the database server.
• Experience in advance PL/SQL concepts like Cursors, Materialized views, Nested Tables, Dynamic SQL for DML operations.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shells scripting, SQL, PL/SQL and SQL Loader.
• Hands on experience in database Performance tuning and Optimization using various techniques like Oracle Hints, table Partitioning, Cost based Optimization, Explain plan etc.,
• Experience in SQL*Loader, UTL FILE, Oracle Import/Export utilities, SQL Navigator and UNIX Shell scripting.
• Adept at creating technical reference guides, user manuals and other related technical documentation, including Application Implementation Methodology (AIM).
• Strong understanding of Data models.Experience in supporting the production system and handling day-to-day issues.
• Learning Tableau as part of learning new technologies.

TECHNICAL SKILLS

• Oracle RDBMS,
• Oracle 8i /9i/10g,
• SQL, PL/SQL,
• Tableau,
• OBIEE, JDBC,
• Toad, SQL Navigator,
• SQL Plus, SQL*Loader, JDeveloper,
• Discoverer 4i/9i/10g, Developer 2000,
• BI Publisher and Kintana
• UNIX, Excel,
• WINDOWS family

PROFESSIONAL EXPERIENCE

Confidential

Oracle PLSQL Developer/ Team Lead

Responsibilities:

• Working as a team lead and a PL/SQL developer to deliver Workforce Certification, Engineering & Conductor Certification Projects.
• Extensively worked on creating database objects including tables, indexes, views, sequences, and packages from scratch.
• Worked closely with the DBA team to create Instances, schemas.
• Worked on the idea of 2-factor authentication for dB links by creating one schema where all the dB links will be created and only the grants permissions from that schema to the required scheme is given.
• Worked from Business Requirement gathering, Coding, Testing & Production.
• Architecture the table structures for which ER Diagrams where used.
• Used PL/SQL to get data from PeopleSoft to oracle.
• Used PL/SQL to do the validations and to provide LIRR with a Workforce Certification application that will enable LIRR to comply with CFR 243 mandate.
• Used PL/SQL to effectively report on training requirements by position, as well as the validity and expiration periods.
• Expertise in using Oracle PL/SQL Collections (PL/SQL Table Varray’s), Bulking techniques, Partition utilization to increase performance.
• Worked in Oracle Cursor, Exception Handling, Collections like REF, Nested tables, VARRAYS.
• Used PL/SQL collections, Bulking techniques, Table Partitioning to increase database performance.
• Used PL/SQL to do the validation of screens when entering, editing and deletion of data.
• Created the custom workflow process, which allows users to see the notifications and approve the Pending Position-Qualifications based on User roles.
• Created tree structure of parent & child relationships using PL/SQL.
• Created DB Links to get the data from MDS System to Workforce Certification System.
• Used PL/SQL project is to upgrade LIRR’s existing Engineer and Conductor Certification Access databases to a modern web application with oracle as the backend data repository.
• Used Oracle Encryption/decryption to encrypt and decrypt sensitive data of employees based on User role.
• Used User Role Verification for users to access data as per their Access level.
• Created various Reports in Workforce Certification as well as Engineering & Conductor Certification.
• Created technical documentation for the users providing detail flow of application & data flow.
• Created job sequences and schedules for automation.

Environment: Oracle Developer SQL, PL/SQL, Oracle Reports 10g, D2K, BI/XML Publisher, UNIX, P4V, Team Track, TOAD, Workflow Builder, SQL*Developer.

Confidential

Oracle PLSQL / Applications Technical Consultant/Team Lead

Responsibilities:

• Worked as a technical lead and Coordinated with the off-shore team in understanding the business requirements and delivering the deliverables to the business users.
• Design, develop, and support PL/SQL ETL processes for loading data from external as well as internal systems using SQL Loader and External tables.
• Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Used PL/SQL , created Stored Procedures to delete existing data from the tables before loading.
• Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developer.
• Generated SQL scripts for data validation, data conversion and manipulation and materialized the views for remote instances.
• Wrote conversion scripts using SQL, PL/SQL procedures, functions and packages to migrate data from one database (SQL Server) to Oracle platform.
• Extensively worked on creating database objects including tables, indexes, views, sequences, packages.
• Developed PL/SQL procedures, functions and packages.
• Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.
• Extensively done performance tuning of oracle databases by rewriting optimized SQL queries.
• Worked on Partitioning large tables using rollback tablespace, range partitioning and created indexes on various tables to improve query performance.
• Extensively worked on SQL commands including all DDL (Data Definition Language), DML (data manipulation language), and DCL (Data Control Language) .
• Interacted with Business Analysts and Users for gathering and analyzing the Business Report requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Requirements gathering for the Interfaces and custom programs development through meetings with functional team and business users
• Analysis (Business and Technical) of existing system with objective of improving & optimizing the system performance.
• Handled a project where it involved building a process for BEx Team.
• Worked with the OBIEE team as a functional Resource by validating the data from EBS to OBIEE using SQL Queries .
• Worked on Various OBIEE Reports as part of OBIEE Implememtation.
• Executed queries and reports during Everest Transition Tests and its follow-up with data migration team regarding data discrepancies
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents.

Environment: Oracle Developer SQL, PL/SQL, Oracle Reports 10g, D2K, BI/XML Publisher, UNIX, P4V, Team Track,TOAD, Workflow Builder, SQL*Developer.

Confidential

Oracle PLSQL / Applications Technical Consultant/Team Lead

Responsibilities:

• Serve as technical lead of an offshore team for the design and development of new applications as well as new versions of existing ones written in Oracle PL/SQL.
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Involved in checking the validity and accuracy of the legacy data by writing PL/SQL packages.
• Created new Procedures , Functions, Materialized Views, Packages, Ref Cursors , Dynamic SQL,Table functions as part of Project/Application requirements.
• Extensively worked with Dynamic SQL & Global Temporary Tables .
• Created and modified PL/SQL and SQL*Loader scripts for data conversions.
• Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation and loading of data from source to target.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems ( ETL Operations) using PL/SQL and SQL*Loader .
• Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Tuning of the SQL Queries , which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Developed custom BI Publisher report for Print AR Statements Generation report and Dunning Letters.
• Developed Sales Order Report using XML Publisher.
• Designed and Developed General Ledger, Payables, Receivables and Profitability Dashboards in
• Worked on Multi Organization structure, Multiple Reporting Currencies, Key and Descriptive flex fields, System Administrator.
• Customized the Workflow to add the approval limits over 1million.
• Used SQL*loader program to load the data into Staging tables.
• Worked on the AP Check Printing Report Using BI Publisher.
• Documented all the work using AIM methodology. Created and updated MD70 documents for all the Development work done.

Environment: Oracle Developer SQL, PL/SQL, Oracle Reports 10g, D2K, BI/XML Publisher, UNIX, P4V, Team Track,TOAD, Workflow Builder, SQL*Developer.

Confidential

Oracle PLSQL / Applications Technical Consultant/Team Lead

Responsibilities:

• Lead a team of 6 developers, assigned, advised and analyzed work.
• Mentored junior programmers in Oracle database design and development.
• Developed PL/SQL program for customer conversion from legacy system into Accounts Receivables (AR) by using Customers Interface using TCA.
• Coordinate with the front-end design team to provide them with the necessary stored procedures, packages and the necessary insight into the data.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Cursors, Indexes and Collections.
• Created the materialized views and also created the partitioning tables.
• Fine-tuned the SQL queries using optimizer hints for joins and Explain plan .
• Unit tested all the SQL scripts and PL/SQL packages.
• Analyzed tables and indexes for performance tuning.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions,synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Created PL/SQL Functions, Procedures, and Packages to support reports.
• Involved in analysis, Design, Development phases of the project
• Developed program units for debugging and test the PL/SQL code.
• Performed development of various PL/SQL stored Procedures, Functions, Packages and database Triggers.
• Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Involved in implementing the data integrity validation checks through constraints and triggers .
• Designed INBOUND and OUTBOUND interfaces using PL/SQL .
• Wrote PL/SQL packages for different validations, for processing data in order to create valid POs and Receipt and for populating the PO interface tables and called the seeded import programs to populate the base tables.
• Enabling descriptive Flex fields and key Flex field segments on some forms in Oracle Purchasing Application.
• Requirements gathering for the Interfaces and custom programs development through meetings with functional team and business users.
• Worked with Business analysts to identify, analyze and document business requirements.
• Worked with OBIEE Answers, Intelligence Dashboards in OBIEE 11g. Demonstrated knowledge indealing with various functionalities like prompts, views, aggregates, global filters, guidednavigation, customization, conditional formatting of reports to satisfy the end users.
• Analysis (Business and Technical) of existing system with objective of improving & optimizing the system performance.
• Created Value sets for report parameters and registered in application using AOL.
• Developed barcodes label BI Publisher Reports.
• Customized GL: Journal Batch Summary Report according to business requirement using BI publisher.
• Developed custom layouts for user facing documents like invoice and receipt using BI Publisher.
• Customized AP Invoice on Hold Report, AP Payment Register Report using BI Publisher.
• Created several AP checks using XML publishers check printing functionality.
• Created custom Reports related to Oracle AR module to allow users to get the required invoice, customer and receipt information when required using BI Publisher.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes using Oracle Reports 10g.
• Documented all the work using AIM methodology. Created and updated MD70 documents for all the Development work done.

Environment: Oracle Developer SQL, PL/SQL, Oracle Reports 10g, D2K, BI/XML Publisher, UNIX, P4V, Team Track,TOAD, Workflow Builder, SQL*Developer.

Confidential,

Oracle Applications Technical Consultant

Responsibilities:

• Involved in customer conversion from legacy system into Accounts Receivables (AR) by using Customers Interface using TCA .
• Developed Auto lockbox Receipt Interface program to automate the receipt processing. Loaded the data into AR PAYMENTS INTERFACE ALL. Validated and imported the data into AR base tables.
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
• Created loader file, porting invoices into the AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables using SQL*Loader and then using Payables Open Interface to import the data into the actual tables.
• Loaded legacy Journal Entries in General Ledger (GL) into the custom interface table and developed a validation program to check for valid entries.
• Developed an interface to run the Standard Journal Import Program in General Ledger (GL) to load those valid journal entries into their respective base tables, to integrate it with Oracle Applications.
• Involved in day-to-day maintenance of Account Payables (AP) invoice approval process.
• Designed and developed interface scripts for Account Payables (AP) interfaces such as AP invoice import.
• Worked on Designing, Development and Customization of OAF Pages each of the custom modules and worked extensively on BC4J and UIX components.
• Developed and Customized OAF Pages, LOV’s, Picklist, Regions and Items. Implemented Simple search, Advance search, Smart search and Results based search on certain pages. Created Quick Select and Multi select LOV’s.
• Created and extended various AMs, VOs and EOs as per the requirement. Created Drop down lists and PPRs.
• Created new Pages to add rows and update rows for Custom tables and customized all icons, buttons other images such as logos, arrows, etc.
• Created and customized reports using XML Publisher/BI Publisher in OM, PO, AP, AR, INV
• Developing Custom Interface Programs and XML/BI Publisher reports.
• Developed Reports in Various Models using BI Publisher