SUMMARY

• 12 years’ experience in relational database development, for creating complex database queries, triggers, views, materialized views, types, global temporary tables, Constraints, Indexes, Views, Packages, Stored Procedures, Cursors and Functions using PL/SQL in Oracle databases (8i, 9i, 10g,11g and 12c).
• 10 years’ experience of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• 8 years’ experience in SQL and PL/SQL performance Tuning - Cost-Based Optimization (CBO) using tools such as SQL Developer’s Explain Plan, DBMS XPLAN in SQL*Plus, Oracle Hints and The SQL Tuning Advisor.
• 7+ year’s experience building J2EE applications, Desktop Application and Applets using Java, implementing UI components to create interactive graphical user components using Swing Components ( menus, button, labels, text fields, combo boxes, layout managers ), JDBC, JPA, JSP, Servlets, JavaScript, CSS and Struts, REST, SOAP).
• Experience in modeling complex web application using ArgoUML, Microsoft Visio and UML Designer. Strong experience in class diagram, sequence diagram, component diagrams and activation diagrams.
• Strong Programming Skills in designing and implementation of multi-tier applications using Java, J2EE, JDBC, JSP, JSTL, HTML5, Struts, JavaScript, Servlets, JavaBeans, CSS, EJB, XSLT, Jython.
• Experience in working with IBM WebSphere Portal/Application Server, BEA Web Logic, Glassfish and Apache Tomcat5x application servers.
• Expert in agile and waterfall project management methodologies. Currently completed five sprints in three months with the following deliverables; three working software components and five production system enhancements.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Oracle 12c SQL new features; Identity Columns, Extended String Datatypes, Top N queries using FETCH FIRST and OFFSET, Invisible Columns, Handling default columns in Oracle 12c.
• 12 years’ experience in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS,TOAD and SQL*LOADER and SQL Developer
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Working Experience in Oracle APIs for Oracle Advanced Queuing and Oracle Streams.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• 12 years’ experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE, DBMS XMLGEN, DBMS XMLDOM and etc.
• Working extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• 5+ years’ experience using ETL tools such as Oracle Data Loader and Talend Open Studio
• Experience in Java design patterns such as Singleton, Data Access Objects (DAO), and Business Delegate.
• 8+ years’ experience of writing technical documentation and training users from different departments on use of reporting tools like Oracle Discover, Microsoft SQL Server Analysis Service and excel to reduce dependence to developers.
• 8 years’ experience on User Interfaces (UI) development, designing Oracle Forms, Oracle Reports for Banking and Finance system interfaces, developing forms event triggers and forms graphics and images integrating real time user events.
• 12 years’ experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• 7+ years’ experience of ERP Systems . Installation, configuration, and customization of Oracle E-business Suite 11i &12; Setup of Oracle General Ledger (GL), Account Payables (AP), Inventory Management (INV), Cash Management (CM), Assets (FA) and Purchasing Module (PO).
• 5+ years’ experience using ETL tools such as Oracle Data Loader and Talend Open Studio
• 3 years’ experience on automotive marketing software.
• 8 years’ experience building financial reports: Balance sheets and Income Statements; using Oracle Business Intelligence - Discoverer and BI Publisher to deliver up to date financial information which enable user to get all the time sensitive information at one place to facilitate informed decisions making.
• 3 years’ experience in Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g: installation, setup and configuration of repository using relational databases, text files and xml data sources.
• 7 years’ experience using XML for data transfer and processing, converting data from relational databases (Oracle and MS SQL Server) and text files to XML document .
• Highly competent in gathering user requirements and converting them into software requirement specifications.

TECHNICAL SKILLS

Languages: PL/SQL, Java, Jython VB.Net, C++ and T-SQL

Databases: Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008 , MS Access 97/2000/2007/2010 and .MySQL 5.0

Web Technologies: PHP, Servlets, JSP, Struts, JavaScripts, VBScripts,HTML, HTML5 and XML

Operating Systems: Windows Xp, Windows Server 2003, Windows 7, Linux (Redhat, Ubuntu and Centos) and Unix (HP-UX, AIX, SPARC Solaris).

ETL Tools: Talend Open Studio and Oracle data Loader

Oracle/SQL Server database’s tools: Toad for Oracle, SQL Developer, Enterprise Manager, Profiler, Query Analyzer, SQL Server Management Studio

Software Applications tools: MS Visual Studio 2010, Dreamweaver, Fireworks, and NetBeans IDE 7.2

Reports: Oracle Reports Builder, BI Publisher, Oracle Discoverer and SQL Server Reports

Web Servers: IIS 5.0, Apache Tomcat, Glassfish, WebLogic

PROFESSIONAL EXPERIENCE

Confidential

Software Developer

Responsibilities:

• IRS Project Re-Write creating and Testing Stored Procedure Through REST Call -Testing Cases
• Create Oracle REST prototyping to develop proof of concept for IRS Project Re-Write Requirements using Oracle REST Data Service.
• Developed the Nested Group Management Driver to maintain nested group memberships in the IDSOWN database.
• Enhancement of existing DIR drivers by adding new attributes. (IdmDataStore).
• Creating Endpoint REST Client for AirWatch devices information to populate databases tables.
• Creating Endpoint REST Client for Duo devices information to populate databases tables.
• I have enhanced the view provided for the Nexus Vaccine Manager application, so they can more easily correlate patient and employee data.
• I designed a mechanism to allow professional photographs for staff f to be incorporated with IDCard photos.
• I have spent hours being trained on how to make changes to the Role Mapping tables in 4IDMOWN for both MiChart and IRS appointments.
• I have paid close attention to Steve's training materials and have even found mistakes that he has corrected.
• I discovered an error in the IDSOWN database where the middle names of purged users were not being copied to purged user from idm user and corrected the trigger,
• I have been doing all the database work for the IRS Replacement project, including working with Ross on the REST interface.
• I have been working on the EMPI Replacement project on database and vault attribute integration.
• Automating data collection for Airwatch and DUO using a REST client to collect the data and store it in IDSOWN and uses OAUTH as the authentication mechanism.

Confidential Ltd Aug-20 16- Apr-2017

Software Developer

Responsibilities:

• Development of new process using database development tools “Oracle PL/SQL” to create a report identifying incorrect names and make recommendations for a new name.
• Development of new bulk load process that change names based on an input file
• Enhancement of Provider Enrollment Wizard - Task panel finish logic
• Enhancement of Provider Change Wizard - Demographics panel.
• Production Base Support (defect fixes and enhancements) for providers and practitioner’s management system

Environment: PL/SQL, Java, Jython, JSP, Servlets, Oracle database 11g, Eclipse IDE, Oracle SQL Developer, Toad for Oracle, Window Windows 7 enterprise edition, Linux

Confidential

Software Developer/Software Engineer

Responsibilities:

• Data analysis
• Designing and Creating Database objects.
• Developing process workflow processing for vehicle sales and registration using PL/SQL to facilitate weekly reporting to GM (Developed more than 40 stored procedures and functions)

Environment: Oracle SQL Developer, Toad for Oracle, PL/SQL, Java, C++, JSP, Servlets, Struts, Oracle database 11g, Eclipse IDE, Window Windows 7 enterprise edition, Linux and Talend Open Studio for Data Integration.