SUMMARY

• An Oracle Certified Senior Developer with 15 years of experience in the analysis, design and development of software solutions using the Oracle Relational Database Management System (RDBMS).
• Over 5 years of experience working as a Technical Lead on multiple projects.
• Experienced in Oracle Forms and Reports development, PL/SQL development and ADF development as well as oracle database administration 8 - 12C.
• Experienced in all phases of the Software Development Life Cycle (SDLC) and in numerous software development processes and methodologies.
• Experienced implementing oracle database security to include data masking, encryption, password hashing, and Data/System Auditing.
• Expertise in client/Server as well as multi-tier system architectures.
• Skilled at working in small and large teams, onsite and offshore.
• Managed teams implementing AGILE Scrum, waterfall and extreme programming and well as architecting mid-size to large software solutions.
• Adept in strategic and innovative system designs and very proficient in working with large databases and complex data structures.
• Experienced designing and developing shell scripts for business processing automation and batch jobs.
• Skilled working independently as well as working with teams from all organizational levels and backgrounds. Excellent written and verbal communicator, great inter-personal skills and able to adapt quickly to new technologies and environments.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, Java, C, C++, C#, Swift, Assembly Language, Groovy, Unix Shell Scripting

RDBMS: Oracle Database Server 8-12C, Microsoft SQL Server, Oracle, MySQL, Firebird Database Server

Application Development Tools: Oracle PLSQL Developer, Developer 2000, Oracle Forms Developer, NetBeans IDE, Oracle Reports Developer, Oracle JDeveloper, Oracle Project Builder, TOAD, Oracle SQL Developer, SQL Navigator, Embarcadero Rapid SQL, Quest Code Tester, Oracle Project Builder, Oracle Designer, SQL*PLUS, ISQLPLUS, Microsoft Visual Studio.

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Senior Oracle Developer

• Reviewed business initiative, business requirements and designed technical specifications accordingly.
• Reviewed raw files and developed workflows for Informatica processes
• Designed and developed logical and physical database models, created database objects to include tables, views, indexes, object types, constraints, collections etc.
• Developed complex database packages for manipulating large datasets while applying complex business rules and validations
• Developed data mapping criteria, data translational entities and designed specification for advanced data replication.
• Enhanced the database coding standards as well as define reusable software components and libraries across the platform.
• Coordinated quality assurance activities and designed test-cases for the newly developed modules as well as enhanced existing modules.
• Conducted code review sessions and monitored data transfer from files to staging and actual production tables.

Tools & Technologies: TOAD 12.8, PL/SQL Developer, Oracle Database Server 11g, Microsoft-Visual Studio, HVR. Sharepoint, Microsoft Visual Studio, TFS.

Confidential, San Mateo, CA

Solution Architect

• Collaborated with product owners to define and document the functional and technical requirements of the Velex Vehicle Diagnostics System.
• Designed and developed the conceptual and logical database model from scratch.
• Developed the database, oracle forms and reports coding standards as well as define reusable software components across the platform.
• Developed PL/SQL packages for efficiently storing and retrieving large data sets. Implemented diagnostic algorithms with the combination of database packages, Object Types, Triggers, Procedures, functions and collections.
• Developed Oracle Forms and reports application using the Headstart library and designing sharable and reusable objects.
• Designed and developed complex menu modules as well as defining programmatic data sources using REF Cursors and PLSQL/Java database subprograms.
• Developed and defined reusable library components, record groups and a global application error handling mechanism
• Installed and configured Oracle WebLogic Server 11g and configured multiple forms and reports services for the development, staging and production environments.

Tools & Technologies: Oracle Forms & Reports 11g, Oracle database 11g, TOAD, PL/SQL, Oracle WebLogic Server 11g, Android Studio 2.0, Oracle JDeveloper/ADF 12C, XCode, Bluetooth 4.0 Low Energy, Windows 2008 Server

Confidential, San Mateo, CA

Sr. Software Architect

• Designed and developed security solutions and enhancements such as encryption and password hashing in accordance to federal regulations.
• Implemented Oracle Eloqua web services. Developed Eloqua data conversion and transfer programs implemented in PL/SQL and C#.
• Developed database packages to manage and automatically refresh millions of employees and employer records. Implemented modules using the BULK API 2.0 and Eloqua MAIL API.
• Worked in the Core Team. Managed a huge set of complex PL/SQL packages, administered Oracle 11g and 12c non-production databases.
• Worked independently and collaboratively across teams. Contributed to architectural design sessions, recommended strategic system designs, conducted series of system and database performance bottleneck analysis. Tuned database and complex queries, re-designed and developed multiple subsystems
• Managed and implemented all mid-size and large projects efficiently and successfully

Tools & Technologies: Oracle database 11g & 12C, TOAD, PL/SQL, TFS, RedHat Linux Enterprise, Oracle Eloqua. SQL Developer, SQLPLUS

Confidential, Carlsbad, CA

Senior Oracle PL/SQL Interface Programmer

• Worked independently and collaboratively to analyze and understand project goals and requirements.
• Reviewed in details project technical specifications as well as project plans and deliverables.
• Developed (RTM) Requirements Traceability Metrics and for measuring from multiple lifecycle entry points.
• Developed Modules in PL/SQL and Java for data extraction, transformation and synchronization from upstream systems.
• Implemented advanced PLSQL and Java concepts such as bulk collection and binding, PL/SQL and Java database interfaces, and advanced data structures such as collections and associative arrays.
• Worked with IT department to understand and support critical central product systems (REFCO), the business processes and the standards.
• Was involved in all phases of testing including content testing, system integration testing, Unit and Acceptance Tests.
• Conducted forensics and analysis of complex issues surrounding product systems and the relevant interfaces.
• Developed database reports for Business users and IT reps for data flow tracking and auditing.

Tools & Technologies: Oracle database 11g, TOAD, PL/SQL Developer, XI integration platform, Windows 2008 Server and Oracle JDeveloper, Netbeans.

Confidential, Torrance, CA

Oracle Forms & Reports Engineer

• Managed and coordinated offshore development and quality assurance teams. Worked closely with other teams to meet project timelines and ensure effective and efficient delivery of software solutions. Triaged and delegated tasks to team members and performed performance appraisals from time to time.
• Planned and coordinated software delivery in accordance to Agile SCRUM regulations. Managed software designs, product backlogs, and analysis of team’s productivity level using software applications/tools such as JIRA, SQUISH, Velocity-Time Graphs, SCRUM retrospection etc.
• Analyzed programming methodology, development processes, delivery processes, and quality assurance procedures. Examined the adherence to Service-Level Agreements (SLA), Conformance to Change Management processes, HIPAA regulations, etc., while suggesting and implementing steps and processes for improvement.
• Performed several software production support activities which included System Analysis, troubleshooting, bug fixes, application tuning, and enhancements.
• Designed and developed sub-systems around existing systems and infrastructure.
• Developed and Modified PLSQL and Java Applications.
• Managed existing and new Software Applications built on Object and Service Oriented Architecture.
• Built new software modules in Java such as database procedures. Developed JSPs, Servlets, JSFs and Oracle Application Development Framework (ADF).
• Developed and designed complex software solutions utilizing XML, JavaScript, and Enterprise java beans.
• Developed and analyzed Web Services Modules using Oracle JDeveloper Studio.
• Performed Data Analysis and Create Database Designs.
• Set up Webutil on the Oracle Application Servers 10g.

Tools & Technologies: Oracle Forms & Reports, Oracle Designer, Oracle Application Server 10G, Oracle Database 10G, TOAD, SQL Developer, SQUISH, JIRA, PL/SQL Developer, Unix Sun Solaris, Oracle JDeveloper 10G, Oracle Glassfish Server.

Confidential, Long Beach, CA

Oracle Forms Migration Engineer

• Migrated all Oracle Forms and Reports Modules completely and successfully
• Integrated Oracle Forms and Reports Services to generate reports from within
• the MP5i application
• Set up Oracle Application Server for Web Forms Deployment
• Analyzed, troubleshoot, debugged and reviewed extensive code and complex forms and PLSQL Codes.
• Built programs to extract, transform and load data from SQL Server to Oracle Database Server 10g

Tools & Technologies: Oracle Forms & Reports 6/6i, Oracle Developer Suite 10G, Oracle Application Server 10G, PL/SQL Developer, Forms Migration tools, Unix Sun Solaris, SQLPLUS.

Confidential, Scotts Valley, CA

Technical Lead/Oracle Forms/PLSQL Developer

• Was fully involved in analysis and setup of the database and application standards.
• Developed templates for Web Forms and Reports, Menus, Object and PLSQL Libraries.
• Developed all of the Authorization Web Forms and Reports following technical specifications.
• Set up development, test, quality assurance and production environments.
• Configured Oracle Application Server, Oracle Forms and Report Services for the various environment related business processes.
• Developed complex PLSQL packages that served as Application Programming Interface for Web Forms and Reports where all validations, authentications and business logic were embedded.
• Developed complex PLSQL Packages and Libraries utilizing PLSQL Table of Records, Cursor Variables and Transactional Triggers.
• Created complex Paper and Web Reports which executed on the Report Server remotely displaying in web browsers in several formats like HTM, PDF, XLS, and XML.
• Set up Remote Printing options and automated report distributions using Oracle Remote Report Printing Utility (ORARRP).
• Created OC4J (Oracle Containers for Java) Instances, Application file directory structure and shell scripts to automate several processes in accordance to standards and/or requirements.
• Tested and deployed on Oracle Application Server.

Tools & Technologies: Oracle Forms & Reports 6/6i, Oracle Developer Suite 10G, Oracle Application Server 10G, Oracle Discoverer, PL/SQL Developer, Forms Migration tools, Oracle JDeveloper. Oracle Designer, Headstart and CDM RuleFrame.

Confidential, Burbank, CA

Technical Lead/Oracle Forms Migration Engineer

• Configured and setup Oracle Application Server Forms and Reports Services.
• Coordinated and documented test phases and activities which included unit testing, user acceptance testing (UAT) and documentation of production specific modifications in accordance to SOX.
• Migrated individual Forms and Reports, identified issues with PLSQL versions, upgraded obsolete PLSQL codes, and migrated Database PLSQL packages
• Enhanced PLSQL Packages analyzed execution codes and explain plans, tuned and optimized SQL statements and stored programs.
• Setup Webutil and ORARRP for client to server integration, File Upload, Import/Export Data Options, Extraction and Transformation.
• Tested and deployed application modules on Oracle Application Server 10g
• Monitored the application and provided post implementation production support and maintenance

Tools & Technologies: Oracle Forms & Reports 4.5, Developer 4.5, Oracle Developer Suite 10G, Oracle Application Server 10G, PL/SQL Developer, Forms migration assistance

Confidential

Oracle Forms/Reports Developer

• Gathered requirements, analyzed existing systems and created project plans.
• Created Data Models, Databases, Roles, Privileges, Database Objects and PLSQL Procedures respectively.
• Developed complex PLSQL application code, constraints, object and entity-relationship to reflect business logic and enforce referential integrity.
• Partitioned PLSQL application logic systematically between the database servers and application servers to increase performance.
• Developed browser enabled GUI with predefined menu options. Created PLSQL Programs for validation and authentication constraining users to comply with business rules and ethics, enhance performance and increase security.
• Deployed completed applications on Oracle Application and Database Servers 10g.
• Coordinated with Business Analysts and Application Users for Quality Assurance and Users Acceptance tests.
• Supported the Production Systems, modified and maintained the Application Code.

Tools & Technologies: Oracle Forms & Reports 6/6i, Developer 2000, Oracle Developer Suite 10G, Oracle Application Server 10G, PL/SQL Developer, Microsoft Access, Microsoft SQL Server

Confidential

Oracle Developer

• Participated in the complete developmental cycle of the Velex Licensing Application.
• Fully participated in Seminars and Meetings, conducted interviews with users, analysts and management to routinely apply and conform to business rules, logic and standards throughout the developmental life cycle.
• Developed and worked with the Database Administrators to create and develop the Databases and Database Models.
• Created Database Objects, Developed complex Oracle Forms Modules, PLSQL Procedures, Triggers and Packages
• Designed a Software Change Management Process.
• Developed Bar-coded Reports, Certificates, Financial/Management Reports which included Graphs, Calculated Fields, Cross-tabs, Sub-reports.
• Migrated the entire application to Oracle 9i database and Application server 9i Upgraded and enhanced PLSQL codes to support the new web environment.
• Provided production and development DBA support.

Tools & Technologies: Oracle Forms & Reports 6/6i, Oracle Forms Service, Oracle Report services, Oracle Developer Suite 10G, Oracle Application Server 10G, PL/SQL Developer, Microsoft Access, Microsoft SQL Server