Michael Guerrero Email & Phone Number

San Marcos, Ca, Us

Greater San Diego Area

Greater San Diego Area

• Designed and managed all Oracle databases (8i, 9i, 10g, 11g) and development projects. • Served as Administrator ERP system, Infor Extended Systems (formerly Pointmnan) for all modules (Finance, Sales, Manufacturing/Inventory). Configured system, managed users, and performed all system upgrades.• Worked with finance and network operations groups to elicit detailed program requirements for provisioning and billing systems. • Used Microsoft Project to plan, schedule, and track… Show more • Designed and managed all Oracle databases (8i, 9i, 10g, 11g) and development projects. • Served as Administrator ERP system, Infor Extended Systems (formerly Pointmnan) for all modules (Finance, Sales, Manufacturing/Inventory). Configured system, managed users, and performed all system upgrades.• Worked with finance and network operations groups to elicit detailed program requirements for provisioning and billing systems. • Used Microsoft Project to plan, schedule, and track projects and resources throughout lifecycle. • Developed, maintained, and enhanced provisioning and billing databases using Oracle Forms & Reports 6i and PL/SQL. • Utilized T.O.A.D, SQL*Developer, and SQL*Plus for coding and database access. • Developed custom web-based calendars, dashboards, applications and reporting suite using Oracle Apex. • Programmed scripts to migrate data from 3rd party MySQL to Oracle database• Developed API’s in PL/SQL to interface custom systems with the company’s 3rd party ERP System.• Created basic data warehouse to summarize millions of network traffic records. ETL processes programmed using PL/SQL and user interface programmed in Oracle Apex.• Maintained, enhanced, and upgraded company ERP system, Infor Extended Systems (a.k.a. Pointman). Set up ERP client to be deployed through Citrix.• Migrated Oracle databases from Solaris to RedHat Linux platform.• Developed custom java applications using Eclipse to sync data between local databases and Account, Contact, Product, Saleforce.Com database. • Increased database security by restricting database access through user roles and grants. • Maintained customer facing Coldfusion web-based order entry application. • Enforced business logic through development database triggers. Show less

• Designed database and served as project lead for the Financial Aid system which was purchased by Oracle Corporation for inclusion in their Higher Education product. • Worked closely with Financial Aid Associate Director to translate government, state, and university requirements into detail programming requirements for staff of 5 programmer/analysts.• Wrote SQL*Loader scripts to import data from other campus offices. • Programmed extensively in PL/SQL, Oracle Forms and Reports.… Show more • Designed database and served as project lead for the Financial Aid system which was purchased by Oracle Corporation for inclusion in their Higher Education product. • Worked closely with Financial Aid Associate Director to translate government, state, and university requirements into detail programming requirements for staff of 5 programmer/analysts.• Wrote SQL*Loader scripts to import data from other campus offices. • Programmed extensively in PL/SQL, Oracle Forms and Reports. • Wrote an interface to a 3rd party software package using Oracle DBMS_PIPES. • Provided ad hoc reports using Oracle SQL*Plus with output in ‘csv’ format.• Developed, implemented and maintained new normalized data model using Oracle Designer 2000. • Planned conversion of database from Ingres to Oracle including schema, client based programs and server based programs. • Created Oracle functions, procedures, triggers and packages. • Developed AidLine, a voice response system using Periphonics VPS/SP including C programming interface to database. AidLine provided detailed financial aid information to over 20,000 students. • Developed P.A.I.S. (Preliminary Aid Information System) using Edify Electronic Workforce. P.A.I.S. was implemented statewide and allowed perspective California State University students to obtain preliminary financial aid estimates for Loans, Pell Grant, and State University Grants. • Developed detailed program specifications, test plans, and implementation schedules for various projects. • Verified that all programs complied with federal, state, and university regulations.• Programmed in COBOL and Pascal, Ingres 4GL, and Ingres Report-Writer. • Key team member in conversion from COBOL to Ingres relational database. Show less