Linda W. Email & Phone Number

San Diego, Ca

• Follow the SDLC methodology to provide analysis; design solutions to meet complex business requirements and technical objectives; develop, test and implement solutions; maintain and support code post release• Provide subject matter expertise on the capabilities/constraints of existing systems and proposed solutions in specific areas of responsibility• Develop and maintain Oracle EBS custom AR, AP and HR concurrent programs and resolve issues• Build and support internal Oracle EBS… Show more • Follow the SDLC methodology to provide analysis; design solutions to meet complex business requirements and technical objectives; develop, test and implement solutions; maintain and support code post release• Provide subject matter expertise on the capabilities/constraints of existing systems and proposed solutions in specific areas of responsibility• Develop and maintain Oracle EBS custom AR, AP and HR concurrent programs and resolve issues• Build and support internal Oracle EBS integrations in order to interface with external applications (CRM, HR, Performance/Learning) • Manage the transactional data flow, including PL/SQL packages, procedures, triggers, cursors, SQL jobs, stored procedures for over 125,000 customer accounts from MS SQL Server Databases into Oracle EBS for the company revenue generating remittance process• Perform monthly cash reconciliation between environments, investigating discrepancies to meet month/quarter/year-end close SLAs to Revenue Accounting team• Provide ad hoc data analysis as requested• Create and maintain custom reporting in Oracle Application Express (APEX) Show less

San Diego, Ca

• Designed, developed, debugged and optimized queries and stored procedures• Investigated and resolved job errors• Monitored daily processes and provided on-call support coverage for production systems• Created and maintained SQL / T-SQL, including tables, stored procedures, functions, synonyms, views• Developed reports for an in-house CRM Application using Coldfusion, SQL and Javascript

San Diego, Ca

• Troubleshoot requests to resolve issues related to SQL Server 2000/2005, Siebel, Unix/Informix, Actuate Reports, Eagle PACE, Eagle STAR, customized off the shelf (OTS) products, and in-house web-applications/utilities• Monitor automated job emails; Repair and restart failed jobs• Query SQL Server through Enterprise Manager and Query Analyzer; Develop SQL scripts and execute stored procedures to update and maintain tables • Query Siebel through Compass Application and SQL Server;… Show more • Troubleshoot requests to resolve issues related to SQL Server 2000/2005, Siebel, Unix/Informix, Actuate Reports, Eagle PACE, Eagle STAR, customized off the shelf (OTS) products, and in-house web-applications/utilities• Monitor automated job emails; Repair and restart failed jobs• Query SQL Server through Enterprise Manager and Query Analyzer; Develop SQL scripts and execute stored procedures to update and maintain tables • Query Siebel through Compass Application and SQL Server; Maintain, update and delete Siebel records• Query Unix-based Informix Dynamic Server (IDS) through ISQL VI Editor and WinSQL; Create scripts and files through VI Editor to insert, update, load, and delete table data; Import data into UNIX through FTP-32 client tool• Develop scripts to produce reports across SQL Server and UNIX/Informix environments Show less

Boston, Ma

• Developed, tested and implemented SQL code to maintain tables for new business implementations on test, staging and production environments• Ran DTS package to import data into Test environment• Built Views, amended Jobs, and ran Stored Procedures for Data Marts• Distilled documents and created Adobe form fields, utilizing electronic signature technology, to be populated during the nightly promissory note creation process • Produced new business implementation documentation of… Show more • Developed, tested and implemented SQL code to maintain tables for new business implementations on test, staging and production environments• Ran DTS package to import data into Test environment• Built Views, amended Jobs, and ran Stored Procedures for Data Marts• Distilled documents and created Adobe form fields, utilizing electronic signature technology, to be populated during the nightly promissory note creation process • Produced new business implementation documentation of standards and procedures• Provided troubleshooting on daily application processes and 24/7 on-call support for promissory note processing Show less