PROFESSIONAL PROFILE:

Confidential is a self - motivated Oracle/PL SQL developer with 15+ experience in analysis, design and development of complex stored procedures/packages and other database objects. Currently, he is serving as an Oracle PLSQL Developer in a dynamic "Agile" environment for a company that provides al solutions for the insurance industry. Prior to his current role, Confidential worked on a variety of projects in varied domains including Technology, Insurance, Tourism, Retail, Food, Finance and Telecommunication among others.

KEY STRENGTHS:

• Expert in Oracle 10g, 11g, 12c and Forms 4, 6i & 8i
• Excellent Knowledge of Oracle Financials modules
• Excellent in PLSQL (package | procedure | triggers | function) (15+ Years)
• Oracle report (15+ Years)
• Oracle form (15+ Years)
• Oracle Application Framework (OAF) ( 5+ Years)
• Oracle Enterprise Business Suite (EBS) (5+ Years)
• Oracle Discoverer Report (5+ years)
• Oracle BI Publisher (5+ Years)
• Oracle Application Express (APEX)
• Linux/ UNIX/ Solaris (10+ Years)
• Database and query performance tuning and optimization
• Atlassian software (Jira, BitBucket, SourceTree), Git, Agile

EXPERIENCE:

Confidential, Malvern, Pennsylvania

Senior PL/SQL Developer

Responsibilities:

• Serialized Oracle Processes with Dbms Lock to avoid deadlocks.
• Created externally organized tables for customer CSV files to produce reports.
• Developed a function based index to enforce conditional uniqueness on a column.
• Created multiple process to dynamically submit Oracle Jobs to support reporting and emailing requirements
• Increasing customer satisfaction and feedback by 45% points
• Created and Used Java Stored Procedures to send http requests for the interface with Vertex web services
• Ordered the execution of multiple database triggers to resolve inconsistent production data issues eliminating 30% of data base issues that were experienced.
• Created database functions returning object types for use by PHP web pages. This gave 90% of the non-dynamic pages dynamic content with richer customer experience
• Built materialized views based and created pipeline functions to support a data mart.
• Created compound database triggers to resolve a mutating table errors.
• Created pipeline functions to support Apex report providing data to 35% more internal and external staff.
• Worked with the Marketing Department using HubSpot Inbound Marketing software, rewriting internal Oracle PL/SQL applications and batch processes to use HubSpot APIs to send and track customer email.
• Used JSON object within procedure and function to communicate with HubSpot mail server through APIs.
• Built new front end Web reports using Oracle Application Express (Apex) providing data to 35% more internal and external staff
• Built materialized views, data marts, and pipelined functions in support of Apex and Web reports.

Confidential, Castries, St. Lucia

Senior PL/SQL Developer

Responsibilities:

• Created PL/SQL Program to implement Transformation logic
• Created and maintained “CarINV” program to manage fleet of vehicle, track sales and provide BI insight
• Created complex functions and procedure using bulk collect and pl/sql tables to enhance efficiency
• Created and maintained in-house payroll software created using Oracle forms and PL/SQL
• Redesign payroll program by identifying bottlenecks and suggesting and implementing code to increase the efficiency by 30%
• Created all-purpose PL/SQL functions that are used with other applications including Java Apps.
• Provide technical support for OBIEE platform
• Extracted data from different System of Records
• Performance tuning of Oracle PL/SQL programs for ETL activity
• Performed SQL tuning using Explain Plan, Hints and indexes.
• Worked on Packages to know the root cause of Production issues.
• Worked on Dynamic SQL and also created new tables as per requirement.

Technologies: JAVA, PL/SQL, Crystal Report, Oracle, Toad, SQL Load, Oracle 11g

Confidential

IT Manager (Data & Business Analytics)

Responsibilities:

• Managed full SDLC such as requirement gathering, business analysis, system configuration, design testing and support
• Implemented fraud detection program using Java, PLSQL and crystal report resulting in 14% increased revenue.
• Created dashboard and data visualization using python to report analysis
• Developed and Maintained inventory of Technical infrastructure using Oracle PLSQL and Forms
• Wrote complex SQL queries to analyze data consistency
• Implemented and maintained issue log system using intranet
• Data analysis to make sure the logical and physical conversion of data is correct.
• Implemented modules in the integration of Sage Accpac accounting system
• Assisted with Implementation of Routing system using Tablets (Androids) for field contractors
• Agreeing costs, timescales and standards to be met and monitoring these throughout the project

Technologies: JAVA, PL/SQL, Crystal Report, Oracle 11g, Forms 6i, XML, Toad

Confidential

Lead Oracle Technical Application Implementer

Responsibilities:

• Created software (Java/SQL/crystal report) to run audit reports on Cost Control Clerks daily operations
• Created Intelligence driven reports (Food & Beverage, utility etc.) for various Directors and other senior managers
• Supported Oracle Financials and demonstrated excellent understanding of Oracle application's architecture, data structures and functionality
• Involved in developing the custom application in OAF(OA FRAMEWORK) based on purchase order module and using standard Oracle Standard API's to create/update/cancel purchase orders.
• Created Concurrent to perform the data loads and also involved in invoking the workflows through our application.
• Applied key skills in the arears of SQL Tuning/Performance/Query Optimization and ETL
• Created and maintained Key/Descriptive Flex Fields
• Developed various list reports for inventory and shipment tracking.
• Designed workflow based on business processes
• Have Hands On in Reports Creation and Generation through XML Publisher.
• Created new OAF pages which includes custom simple search, advanced search, PPR (partial page rendering) select option, committing data through EO (Entity Objects)
• Involved in the preparing/reviewing the Detailed Design documents and Unit Test Plans.
• Worked on invoking data base objects such as custom PLSQL packages, Functions, Procedures etc. from OAF.
• Created packages, procedures, functions, triggers and used explain plan to guide performance tuning
• Recruit, train and mentor team members.
• Designed, Documented and Developed PL/SQL Packages and functions.
• Extensively worked with Extract-Transform-Load (ETL) patterns and processes
• Created new functionality within oracle EBS
• Created jobs in Oracle EBS (Oracle Enterprise Business Suite)
• Participated in technical research and development to enable continuing innovation within the infrastructure.

Technologies: Oracle 11g, J2EE, PL/SQL, XML, XSLT, XSP, Oracle Application Framework, Toad, SQL Load, Oracle BI publisher, Oracle Report, Crystal Report, Oracle Form 8i, Eclipse, Toad and other

Confidential

Oracle Billing System Engineer and Pl/SQL Developer

Responsibilities:

• Wrote unit test cases and monitored and maintained high levels of data analytic quality, accuracy, and process consistency
• Wrote object types, bulk collect and FORALL insert to load the data using the nested tables.
• Used Merge statement for incremental loads and WITH statement.
• Created packages, procedures, functions, triggers and used explain plan to guide performance tuning
• Wrote pipelined table functions to load the data from one table to another table.
• Developed SQL Loader Scripts to load the data from comma separated file into the oracle table
• Work with QA team to verify/review the test scenarios and test cases
• Worked on creating UNIX shell wrapper to schedule corn jobs that populate the product details into NPI Workspace database.
• Excellent track record of all the deliverables completed on time
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Created partitioned tables and partitioned indexes to improve the performance of the applications.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Created external tables to handle huge volumes of data which is not used frequently.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Worked with sales management team to refine predictive methods & sales planning analytical
• Designed and maintained data warehouse
• Trained and motivated new staff and coordinated activities for same

Technologies: PLSQL, Shell Scripting, VB .NET, crystal Report, Business Object, MS SQL Server, Oracle, Excel, Toad