Sammury

• Fifteen years of strong hands-on experience in application development and support, and database administration of ERP systems, including Finance, HR/Payroll, and Student systems for higher education institution. Experience in Oracle database administration, production control, data warehouse, business intelligence, reporting, job automation, and identity management. Experience in different phases of software development cycle including requirements analysis, design, installation, implementation, testing and support.
• Technical expertise in host-based and client/server platforms: Oracle 10g/11g SQL, PL/SQL, SQL Loader, SQL Plus , Oracle Enterprise Manager, RMAN, ETL Oracle Warehouse Builder, Oracle Discoverer, Oracle Forms, Oracle SQL Developer, RMAN, Oracle Identity Management, Cognos, Oracle Application Server/Fusion Middleware, UC4 Applications Manager scheduling system Unix / Linux shell scripts, vi editor, cron, job scheduling, SSH OS/390 mainframe environment COBOL, JCL, CICS, VSAM, TSO, DB2, Focus Microsoft Windows, MS-Office Word, Excel, Access .

WORK EXPERIENCE

Confidential

Database Administrator, Production Control

• Production Control office supports administration of the university's integrated business applications and reporting tools. Banner application, ERP system developed by Sungard, runs in Linux platform, Oracle 11g database and Oracle application server/Fusion Middleware, utilizing SQL, PL/SQL, C, COBOL, Oracle forms. Operational Data Store ODS is the reporting environment for Banner and was implemented using Oracle Warehouse Builder and Oracle Discoverer.
• Provide support in the areas of backup, recovery, and database upgrades on an as needed basis to support high availability of the Banner Production system.
• Installation of different Banner modules, including migration, compilation, database update configuration of database/oracle environment and application server environment
• Application of required enhancements, patches, and releases to Banner and other third-party products that interface with Banner, in accordance to defined timelines
• Cloning and export/import of production database to different database instances to support development, conversion, training, and testing
• Security maintenance and account creation for Oracle database, Banner application modules, and other third-party products
• Administration of ODS utilizing Oracle Warehouse Builder and Oracle Discoverer ensuring the data loads are run on schedule implementation of security policy setup for ODS reporting development of custom ETL and Discoverer end-user layer to support additional reporting requirements by end users.
• Review and deployment of codes, SQLs, and database objects from development to production environment
• Technical support for end-users and developers, investigation and resolution of application issues, including SQL tuning, database/application performance issues
• Performs Banner database failover Data Guard and database recovery RMAN verification process
• UC4 Application Manager formerly Appworx scheduling system administration, including installation, upgrades, account maintenance, jobs/scheduling setup, shell scripts and SQL scripts setup, integration to Banner application gathered user requirements in defining processes to be automated.
• Performed Oracle 11g upgrades from 10g of Oracle databases supporting several products, including Banner, ODS, and UC4 Application Manager
• Implementation and administration of Identity Management infrastructure which automates real-time account provisioning as constituents employees/students are entered in Banner.
• Implemented automated cloning process through UC4 Application Manager, reducing manual efforts involved in cloning Banner database to different environments, like Test and Development instances.

Senior Programmer/Analyst, Administrative Information Systems

• The Administrative Information Systems department of the University Computing Division performs development and support tasks for the university's integrated business applications, delivered by Sungard Finance, HR-Payroll, Student Systems, HR/Payroll . Plus Systems reside in O/S309, and utilizes CICS, JCL, COBOL, JCL, VSAM, CICS, Focus Express.
• The University migrated from its mainframe-based administrative systems Plus to Oracle-based Banner.
• Migration of legacy data into Oracle/Banner tables worked with end-users to define data mapping used vendor-delivered conversion tool that utilizes Oracle forms, SQL Loader and PL/SQL scripts.
• Maintenance and support of the university's administrative systems, including Finance Systems, Human Resources System, Student Systems, Financial Aid and Web for Employees, Students, Faculty, including on-call support of nightly execution of batch processes and upgrades.
• Analysis, application, installation, and documentation of software customization requested by users.
• Application, testing and installation of enhancements, fixes, and regulatory changes from vendor, ensuring that current functionalities and processes are maintained.
• Investigation and resolution of production problems identified by end-users of the administrative systems.
• As a security officer, granting of security access to the end-users of the administrative systems includes analysis and resolution of application security issues.
• Coordination, testing, and execution of year-end processing: W-2 printing, Fiscal Year closing for the Finance Systems, and Calendar year-end processing and tax updates for HR/Payroll.
• Implementation and deployment of Web for Employees. Installation of the back-end components of Employee Self-Service requirements analysis/issue resolution with Human Resources implementation and deployment of the product to all employees
• Extraction of HR data for data warehouse coordinated with HR to identify most-commonly used fields from the HRS database model, created extract program to create flattened' file to be used by CONNX as database view for reporting.

Consultant

Confidential

• Analysis, coding, testing, and deployment of in-house program changes for Year 2000 compliance.
• Application, testing, and installation of software modifications provided by vendor to existing software for enhancement, fix, and regulatory changes.
• Investigation and resolution of production problems identified by users.
• Support of nightly execution of batch programs.

Confidential

• Household Insurance System created a Year 2000 testing team, responsible for testing and certifying its components for Year 2000 compliance.
• Creation and execution of test plans for testing various components of the system.
• Validation of results to ensure that systems' consistency before and after Year 2000.
• Investigation, resolution, and documentation of test results and errors to obtain approval of certification tests.

Analyst, Confidential

• Manila Solution Center was contracted by Andersen Consulting, Chicago to maintain an organization to provide support to the Bill Format components of its Next Generation Billing Project.
• Analysis of Change Request requirements documents and prototype bills and assessment of impact to Bill Format applications.
• Creation of technical and detailed design documentation, and implementation of code changes.
• Coordination of integration testing and validation of results.
• Technical and functional assistance to other programmers.
• Analysis and resolution of system investigation requests defects created from production and product test validation of results.