Oracle Java Developer,resume Profile
NY
Professional Summary
Confidential is a seasoned Java/J2EE developer. He has more than 8 years' experience in Information Technology covering architecture, design, development and testing of software applications on both Unix Linux and Windows platforms using Core Java 1.5/1.6 and J2EE technologies like EJB, JSP, Servlets, SOAP and REST Web Services, Java-Script, HTML, XHTML, CSS, XML/XSL/XSD, Shell Scripting, Frameworks such as ADF, client side scripting such as Java Script, JQuery, Reporting tools such as Oracle Reports. Miguel has worked on various application/web servers like Web Logic Application Server 10/8, Tomcat Application Server 5.5. He has expertise in backend programming writing of Stored Procedures, Functions, Packages, Complex Queries and Modeling Databases, using Erwin and Power Designer in Oracle 11g/10g/9i, MS SQL 2005, Sybase, MySQL, PostgreSQL. He also has experience in design development of SOA solutions using Oracle Middleware using BPEL, OSB, SOAPUI. Miguel functional knowledge covers working with sales, marketing, general ledger and media industry. He has excellent communications and inter-personal skills.
Technical Skills
Development Languages: Java 1.5 1.7 , PHP
Server-side Technologies: Java, EJB 3.0, JDBC, Servlets, JSP, J2EE, XML, JNDI, Beans,
IDEs/Environments: JDeveloper, Eclipse, TOAD.
Scripting Language: JavaScript, Linux Shell.
Methodologies: Scrum Agile.
Frameworks: ADF, Struts, JSP.
Database: Oracle9i/10g/11g, MySQL, MSSQL, DB2, PostgreSQL.
Web/Application Servers: Weblogic 10-11, Tomcat 5.0.
Version Control System: SVN, Visual Soursafe.
Design Tools Profilers: UML,Visio, Power Designer, Erwin.
Middleware: Oracle SOA Suite 11 BPEL, OSB
Reporting Tools: Oracle Reports
Operating Systems: Linux, Windows
Experience
Oracle Java Developer Confidential
- Responsible to define and deliver on time the reports considered for the project Mesa de control and code webservices.
- Developed Oracle PL/SQL store procedures and functions to process information used to generate reports.
- Developed java SOAP webservices to expose store procedures and functions.
SOA JAVA Developer Confidential
- Helped to develop a portal to receive technical service orders.
- Developed orchestrations using predefined mappings between CBS and Siebel CRM, using synchronous web services using OSB ECLIPSE OEPE and BPEL JDeveloper . The previous mappings were re-analyzed and corrected on the go.
- Created XSL, XSD and XQueries to develop mappings and data exchange between both systems.
- Developed java classes to analyze strings and invoke webservices.
- Was responsible for design of the Oracle database model using Power Designer 16.
- Created Mock webservices using SoapUI.
- Did Weblogic configuration to work with AS400 platform.
Oracle Java Consultant Confidential
- Designed, developed and implemented an RBAC system/portal to manage users identity.
- Developed the web application using Oracle SOA Suite 11.
- Designed UI based on ADF controls and Business components.
- Set the weblogic configuration, including the distinct JNDI Datasources, ldap, email .
- Designed XSD schemas to interact with third party vendors.
- Programmed hierarchical queries to retrieve parts of Siebel organizational chart, and its own hierarchical organizational charts.
- Wrote complex database queries.
- Created DB Links to interact with other Oracle databases in the distributed database system.
- Involved in design and review of UML Documents like USE cases, sequence, communication, deployment diagrams etc.
Oracle Java Consultant Confidential
- Designed, developed and implemented a portal to receive all types of television advertising orders made by marketing, sales teams and agencies to be reviewed by traffic area , authorized special prices and discounts , billed, programmed and transmitted on different TV channels. .
- Developed the web application using Oracle SOA Suite 11.
- Designed the UI based on ADF controls and Business components.
- Coded Java classes to read Excel formats XLS, XSLX to be used inside BPEL processes.
- Coded web services to expose Oracle DB Functions and Store procedures.
- Set the weblogic configuration, including the distinct JNDI Datasources, ldap, email
- Used PL/SQL composite data types, built in packages of PL/SQL like DBMS SMTP, DBMS HTTP.
- Wrote complex database queries.
- Created DB Links to interact with other Oracle databases in the distributed database system. Involved in design and review of UML Documents like USE cases, sequence, communication, deployment diagrams etc.
- Unit Tested PL/SQL Modules. Prepared Unit Test Cases for the designed modules.
- Involved in design, development, testing, production release and user training.
Oracle Reports Developer Confidential
- Translation of ERP reports from Spanish to English AR, GL modules .
- Worked on Oracle Reports and Discoverer 4.0.
- Modified Pl-SQL store procedures and functions to translate on the fly some words and phrases to English.
- Translation of different reports made in Oracle reports and discoverer.
SOA Developer Confidential
- As SOA developer I worked with the Oracle SOA Suite 10g where the original project was created and then migrated to 11g.
- Orchestrated BPEL task flows.
- Coded Java classes to generate email notifications.
- Designed XSD schemas.
- Programmed Oracle Triggers, stored procedures and Cron tasks.
- Programmed HTML messages.
Programmer Analyst Confidential
- Coded new requirements using .Net.
- Wrote PL/SQL stored procedures.
- Coded Tibco work flows.
- Coded Java classes to be embedded into Tibco work flows
- DTS's programming to migrate information between several different databases.
Backend Developer Confidential
- Help the java programmers to generate and maintain POJOs of the DB structures as well maintained by me, code store procedures, generate python scripts to generate CRON tasks.
- Created DDL scripts to make database modifications according to new requirements.
- Documented the current database schemes either in Oracle or PostgreSQL using Erwin 4.0.
- Created DB Links to interact with other Oracle databases in the distributed database system.
- Wrote complex queries to get data requested by political parties. This data was obtained from the Oracle
- database using PL/SQL, complex queries.
- Coded Oracle PL/SQL and PostgreSQL stored procedures.
- Loaded data using SQL Loader.
- Coded Linux Shell Scripting to automate tasks using Cron.
- Used dynamic SQL with 'execute immediately' feature.
Lead Programmer Analyst Confidential
- As lead programmer help to define the project SIP Sistema de Ingresos Provincia
- Developed the web application using C in ASP.Net 2.0, HTML, Java Script.
- Developed reports in crystal reports.
- Wrote complex queries in DB2, to get the prices of advertisements considering different factors like time schedule, special dates, special clients, discounts, etc.
Java and pl-sql developer Confidential
- My main function as developer was to help the team in activities related to java and oracle database in the different projects I participated.
- Developed the UI using Java Servlets, Java script, HTML.
- Developed backend Java services to migrate data between Sybase to Oracle.
- Wrote complex queries in SQL server 2005 for several projects.
- Used transactions to manage exceptions, logs and rollback.
- Wrote stored procedures in Sybase and PL/SQL Oracle 9i to register money in the ERP and treasury system.
- Used PL/SQL to code packages, store procedures, functions and loaders.
- Designed reports in Oracle Reports and Oracle Discoverer 4.0.
- Tuned queries to speed up reports generation.
- Created Materialized views, normal views, triggers, jobs.
PHP Developer Confidential
- Responsible for entire SDLC analysis, designing, and programming of a webpage used to display reports using mysql, php,
- Apache, HTML, JavaScript.