PERCEO LEMOS
3266 Kimber Ct., 128
San Jose, CA 95124
Home: (408) 723-2810
Cell: (408) 507-1916
lemosperceo@yahoo.com
OBJECTIVE
To obtain a challenging position within Information Technology that would take advantage of my extensive programming and communication skills to ultimately satisfy the technology needs and requirements for department managers and end users.
SKILLS SUMMARY
Databases
MS SQL Server 6.5/7.0/2000, MS Access
Computer Languages Visual Basic, VBScript, Perl Scripts, SQL, Basic Regex knowledge, Python
Operating Systems Win NT 4.0/2000, Windows 98/ME, MVS, TSO
Applications Visual Basic, MS Access, SQL Server, Crystal Reports
Languages English, Portuguese, Spanish, German
WORK EXPERIENCE
2004 - Present SENIOR SYSTEMS ANALYST / DATA ANALYST
IRONPORT / TTI International, LLC
San Bruno, CA
Detailed analysis and threat assessment of illegitimate email (Spam and Phishing) traffic.
Creation and testing of heuristics rules to capture illegitimate email traffic: Use of regular expressions and Perl scripts
Use of MySQL and Unix Shell Scripts queries to generate reports for QAing of message influx.
Development of several MS Access applications that support daily routine.
Awarded the best SpamAssassin rule writer in the Security Operations Team
SenderBase Customer Support through ticketing systems
Develop and support custom accreditation systems and reports and monitor performance
Develop and maintain the companys website with customer secure access using JavaScript, XML and HTML
Translate software and website into Portuguese and Spanish
Analyze user and market requirements to translate existing computer systems and design new systems to meet current or projected needs
Develop SQL transactions (programming) to generate automatic reports and update tables
2003 2004 CONSULTANT SYSTEMS ANALYST
(UNDP Project) - Brazilian Institute of Environment - IBAMA
Brasilia, DF, Brazil
Implemented VB functions and procedures to extract information from different databases as a summary of critical activities of Environmental Monitoring (EM)
Assisted the development and implementation of EM Operational Indicators in Oracle to monitor expenses for Self Sustained Development of the Amazon Region
Developed VB procedures with MS Access for EM Strategic Planning
Designed MS Excel based reports (graphics and tables) to summarize EM operations budget
Designed and implemented VB applications with MS Access for incoming telephone call monitoring, IT equipment maintenance control, and employee timesheets.
Implemented system auditing for budget management.
2002 INFORMATION CONSULTANT
Ministry of Agriculture, Livestock and Food Supply
Brasilia, DF, Brazil
Designed and coded three prototype VB applications with MS Access.
Developed MS Excel reports for department budget control (Audit)
1997 2001 SYSTEMS ANALYST
GEAP Social Security Foundation
Brasilia, DF, Brazil
Developed a complete Data Warehousing solution for processing of health insurance claims and premiums. The system collected data from database of performed health care services and patient payroll database for billing output and for the expense distribution workfile (EDW)
Implemented the original design of Health Insurance Claims system in MS Access and the later migration to MS SQL Server 6.5/7.0 with Visual Basic applications
Wrote SQL transactions (programming), stored procedures, triggers and data transformation scripts
Implemented code integration, code testing procedures, and applications for data validation and evaluation
Worked closely with management and users to develop and/or modify existing reports using Seagate Crystal Reports. Created and modified hundreds of reports for Finance, Operations and Management.
Converted applications from Visual Basic to Web environment, using ASP and HTML, as well as JavaScript and VB Script for validation of user entered requests.
Wrote functions to perform system auditing for health claims and premiums.
Implemented Extracting, Transforming and Loading (ETL) data from source systems into the data warehouse
1995 1997 SYSTEMS ANALYST
Odebrecht Group
Brasilia, DF, Brazil
Implemented and managed a complete MS Access based system for the company contact database. The system generated faxes, initiated phone calls, printed labels and letters based on templates.
Performed research and data gathering to produce company proposals and presentations to buy national telephone infrastructure.
1993 1996 PROGRAMMER ANALYST (CONSULTANT)
WF COM REP LTDA/PADRΓO iX SISTEMAS ABERTOS
Brasilia, DF, Brazil
Prepared pre-sales presentations of the company products.
Worked on BRS/Search in UNIX, Solaris and HP-UX environments.
Converted data from several different databases to the BRS/Search engine to build a sample so the clients could have a better idea of how it would work on their systems.
1989 1992 PROGRAMMER/SYSTEMS ANALYST
Bayer S.A.
Rio de Janeiro, RJ, Brazil
Implemented database applications of user training and hardware maintenance.
Provided support for IBM Mainframe Network. (MVS, TSO and IMS)
EDUCATION
1992 Bachelor of Arts in Psychology
1989 Bachelor of Science in Mathematics
Fluminense Federal University, Niteroi, RJ, Brazil
|
