|
|
Title: |
Application Developer
|
Location: |
US-California-Los Angeles
|
Work History: |
Programmer Analyst
Hess & Associates * Los Angeles, CA * 2005 to Present
• Development using Visual Basic 6/VB.Net/Oracle for payroll system for the City of Los Angeles – PAYSR which handles the payroll for over 40,000 employees
• Used Toad For Oracle and Embarcadero Rapid SQL 7 for PL/SQL development of stored procedures, functions, triggers and packages combined are used for backend data validation, audit trails and data manipulation, including cursors to update ledger records.
• Developed screens for managing and calculating employee deductions, utilizing backend validation rules to enforce correct rules for deductions for corresponding unions.
• Developed Position Reporting screens. Provided customizable grid views for departmental budget and staffing analysis, breaking down data to employee, job title and salary
Programmer Analyst
JoeBarter.com * Pasadena, CA * 3 Month assignment in 2006
• Used stored procedures and functions to SELECT time remaining in online auction from SQL Server 2000 backend used by all postings to the site
• Created detailed user form for analyzing client requests for over 600 small business websites’ development, also provided upload to server field for users sending samples to developers.
Database/Systems Developer
Women’s City Club * Pasadena, CA * 2003 to 2005
• Developed web based scheduling system for banquet hall management for over 6 different locations based on PHP, Apache Server and MySQL.
• Created customer management system used for non-profit fundraising (over 500) and net $15,000 in April 2005 event.
|
Skills: |
• Visual Basic 6 Development for 3 tiered Payroll/HR System with Windows Server hosting VB application, connection to Oracle Database on IBM Servers with client access to application through Citrix Server. Used grids, forms and reports to display records and allowed for customizable field order, queries based on user input parameters. Participated and lead in weekly analysis meetings with users and their liaison.
• Visual Basic .Net Analysis and Design of web and Windows projects with SQL Server 2000, Oracle 9i and Access databases and ADO.Net backend, including Automation of MS Office Applications for report printing (Word, Excel, Access), Oracle Reports and Crystal Reports. Developed SQL Server function to get time difference and display as time remaining for EBay type auction. Created Web Form to upload user files to Web Server.
• Oracle PL/SQL Developed stored procedures to update ledger records using cursors. Developed package and rules for backend data validation while tuning query for fastest results possible. Developed functions used to determine an employee’s retirement, health, dental deductions on a paycheck.
|
Education: |
Bachelor’s of Science in Computer Information Systems
Graduate of the Fall 2005 Class at Mt. Sierra College, Monrovia CA. Cumulative GPA of 3.33
|
Endorsements
|
 |
Fernando has received 0 endorsements.
|
Fernando has endorsed 3 Members.
|
|
|
| |
Rank |
Title |
Location |
Status |
Actions |
|
5.231 |
Systems Administrator |
US-California-San Francisco |
 |
Details
|
|
|
5.231 |
Hetergenous System Administrator |
US-California-Silicon Valley/San Jose |
|
Details
|
|
|
3.469 |
Entry Level Developer |
US-California-San Diego |
|
Details
|
|
|
|
|
Public Messages
|
|
| From |
Date |
Message |
No public messages. |
|
|
