Summary

Confidential is a seasoned software developer with eight years of experience in the IT industry. He has worked extensively in all areas of software development life cycle as well as testing and executing deliveries and supporting global customers. He has been extensively involved in requirements gathering, analysis, design, systems development, testing application, data migration, data extraction, data load, reporting, application maintenance, application production support and release management. His expertise lies in design and development on Oracle SOA Suite 11 Weblogic, ADF, BPEL, OSB . He has extensive experience in using PL/SQL Oracle 11g/10g/9i, /Java Oracle-object , XML XSD, XSLT, XQuery, XPath . He has strong background in developing stored procedures, database triggers and packages using PL/SQL as well as OSB and BPEL workflows. Miguel also has experience in DBA activities like Database Design using Power Designer Tables, Views Constraints and in Performance Tuning. He has been involved in project initiation, project planning, project scheduling tracking, reporting, configuration etc. Miguel has excellent communication and inter-personal skills.

TECHNICAL SKILLS:

• Oracle Package: Oracle SOA Suite 11 Weblogic, ADF, BPEL, OSB .
• Languages: SQL / PL-SQL, C , Java, PHP, Python, XML XPath, xQuery, XSLT, XSD, BPEL .
• RDBMS: ORACLE 9i, 10g, 11g , PostgreSQL, DB2, MySQL, Microsoft SQL, Sybase.
• Project Management Tool: Microsoft Project, Microsoft Office.
• Case tool: Power Designer 15, Erwin, JDeveloper, Microsoft Visio
• CM Tool: CVS-Tortoise, Microsoft Visual Sourcesafe
• Operating Systems: Linux Ubuntu, Fedora , Windows.
• IDEs: JDeveloper, Eclipse.
• Utility: SQL Loader, TOAD 9.x.

PROFESSIONAL EXPERIENCE:

Confidential

Lead Programmer Analyst

Responsibilities:

• Developed the application using the Oracle SOA Suite 11g using OSB and BPEL.
• Developed orchestrations using predefined mappings between CBS and Siebel CRM, using synchronous services using OSB ECLIPSE OEPE and BPEL JDeveloper . The previous mappings were re-analysed and corrected on the go.
• Was responsible for the design of the Oracle database model using Power Designer 16.
• Created Mock Web services with Soap UI.
• Developed PL/SQL Functions to make strings analysis.
• Did the Weblogic configuration to work with AS400 platform.
• Used Eclipse SVN plugin client to manage program versioning.
• Configured and maintained the development environment SOA Suite Server and Database servers over Linux Centos 6 .

Environment: Oracle Suite SOA 11.1.1.5, Oracle 11g, PL/SQL, Eclipse, JDeveloper, Weblogic, DB2 7 on AS/400, JDBC, Tortoise CVS, UNIX, SSH Client.

Confidential

Programmer Analyst

Responsibilities:

• Did the full analysis- high and low level design, coordination, programming, testing, maintenance, supporting and documentation for the Security Manager Centre System.
• Responsible for detailed design for Software Development request.
• Designed the physical and logical database models for the application in Power Designer.
• Wrote complex queries to make views to be used by web services.
• Developed the application in CakePHP, MySQL.
• Developed SOAP and REST web services to expose functionality.
• Configured the Linux development environment server.

Environment: Power Designer, MySQL, Apache, PHP, Linux

Confidential

Lead Programmer Analyst

Responsibilities:

• Did the complete SDLC - analysis, coordination, designing, programming, testing, maintenance, supporting and making manuals for backend business processes.
• Used SOA Suite 11.1.1.2 ADF, Weblogic, BPEL , PL/SQL, Oracle11g, XML XSD, XPATH , HTML, Active Directory, Java 1.6 for development.
• Used hierarchical queries to retrieve parts of the Siebel organizational chart, and its own hierarchical organizational charts.
• Used PL/SQL composite data types, built in packages of PL/SQL like DBMS SMTP, DBMS HTTP.
• Wrote complex front end queries to display data on front end screens. This data was obtained from the Oracle database using PL/SQL, complex queries and procedures.
• Configured Weblogic to connect to Televisa's Active Directory service.
• Created DB Links to interact with other Oracle databases in the distributed database system.
• Carried out enhancements to improve the application's performance and configurability.
• Created technical specification document and designed document for various PL/SQL modules based on the functional specification. Used Visio to draw the data-flow.
• Involved in the design, development, testing, production release and user training.
• Used TortoiseCVS client to manage versions of programs.
• Unit Tested the PL/SQL Modules. Prepared Unit Test Cases for the designed modules.
• Involved in the design and review of UML Documents like USE cases, sequence, communication, deployment diagrams etc.

Environment: SOA Suite 11.1.1.2 Weblogic, ADF, BPEL , PL/SQL, TortoiseCVS, XML, Java, Oracle 11g, Active Directory, Java 1.6, LINUX, Siebel CRM, 3rd party applications exposing web services.

TV Advertising orders processing Unified Orders

Confidential is a system to receive all types of television advertising orders made by marketing, sales teams and agencies to be corrected by traffic area , authorized special prices and discounts , billed, programmed and transmitted on the different TV channels.

Responsibilities:

• Responsible for entire SDLC - analysis, coordination, designing, programming, testing, maintenance, supporting and making manuals for backend business processes.
• Created technical specification document and designed document for various PL/SQL modules based on the functional specification. Used Visio to draw the date-flow.
• Developed the application using the Oracle SOA Suite 11.
• Used PL/SQL composite data types built in packages of PL/SQL like DBMS SMTP.
• Used transactions to manage exceptions, logs and rollback events.
• Wrote complex front end queries to display data on front end screens. This data was obtained from the Oracle database using PL/SQL, complex queries and procedures.
• Created DB Links to interact with other oracle databases in the distributed database system.
• Used different Weblogic adapters to connect it with FTP servers, Microsoft SQL server, DB2 and Oracle databases.
• Unit Tested the PL/SQL Modules. Prepared Unit Test Cases for the designed modules.
• Involved in the design, development, testing, production release and user training.
• Used TortoiseCVS client to manage versions of programs.
• Involved in the design and review UML Documents like USE cases, sequence diagrams, deployment diagrams etc.

Environment: Oracle 11g, SOA Suite 11.1.1.2, PL/SQL, Weblogic, Windows 2008 Server, Linux, Active directory, 3rd party applications exposing SOAP web services, Java 1.6, HTML, XML XSD, XPATH, Xquery, XSLT .

Confidential

Translation of ERP reports from Spanish to English AR, GL modules .

Responsibilities:

• Worked on Oracle Reports and Discoverer 4.0.
• Modified Pl-SQL store procedures and functions to translate on the fly some words and phrases in English.
• Translation of different reports made in Oracle reports and discoverer.

Environment: PL/SQL, Oracle9i, Oracle Reports, Oracle Discoverer 4.0, Oracle EBS.

Confidential

Oracle SOA Programmer

Analysis of Inventory in movement

Confidential is the biggest bakery in the world. The project was made to make an analysis of the products that were not in the enterprise facilities but in transit for sales. The need was to know the amount of product in pieces and value in transit, to make better plans for production and know the value of the stock in movement , all in real time.

Responsibilities:

• Designed XSD schemas.
• Coded the application using the Oracle SOA Suite 10g/11g.
• Programmed Oracle Triggers, stored procedures and Cron tasks.
• Orchestrated BPEL flows.
• Programmed HTML messages.

Environment: Oracle SOA Suite 10g/11g installed on Windows Server 2003 ADF, BAM, BPEL, ODI, Weblogic/OC4J , Oracle 11g, Cron.

Confidential

Programmer Analyst

IT support and development.

Grupo Salinas is one of the well known Mexican IT enterprises. This project was for the support department and logistics area to automate the appliance stores supply.

Responsibilities:

• Was assigned new requirements to be programmed either in database or in .Net.
• Wrote PL/SQL stored procedures.
• Coded the Tibco work flows.

DTS's programming to migrate information between several different databases.

Environment: Oracle 9i, 10g, DB2, SQL Server, ASP .net 2.0, Tibco.

Confidential

DB Architect

In-house development applications.

IFE is the government institution to organize federal presidential elections. This project was to help to design database models for the different projects needed in order to organize the presidential elections.

Responsibilities:

• Documented the current database schemas either in Oracle or PostgreSQL using Erwin4.0.
• Created DDL scripts to make database modifications according to new requirements.
• 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 the Oracle PL/SQL and PostgreSQL stored procedures.
• Loaded data using SQL Loader.
• Coded Linux Shell Scripting to automate some tasks using Cron.
• Used dynamic SQL with 'execute immediately' feature.

Environment: Oracle 11g, PL/SQL, PostgreSQL 8.0, Erwin 4, TOAD 9, Python, Linux CentOs.

Confidential

Lead Programmer Analyst

Marketing and Sales Quotation System Televisa Local

Confidential Local helps the Sales and Marketing departments to estimate the cost of a television advertisement campaign.

Responsibilities:

• Programmed the complete web application in ASP.Net 2.0.
• Wrote complex queries in DB2, to get the prices of advertisements considering different factors like time, schedule, special dates, special clients, discounts, etc.
• Wrote store procedures to create text plain orders based in the orders created on the system to send them through third party system to production.
• Designed the Conceptual and Physical database model in Power Designer.

Environment: DB2, Power Designer, ASP.Net 2.0, C , IIS, Windows Server 2k3.