Junior SQL DBA

**** *. ******* ***.

Chicago, Illinois *****

708-***-****

*********@*****.***

Diogenes Silva

Qualification Summary

Experienced software developer and database analyst is seeking an opportunity to contribute the analytical, and software application development experience toward the success of a growth-oriented customer centric business. Confident and poised in interactions with individuals at all levels. To be a part of a team, committed to innovation, insight and results.

Government Experience

System/Database Analyst Department of Labor October 2008 – Present

TCE Incorporated – Chicago National Processing Center

 Provide system and management analysis for programs that produce administrative and programmatic information used to make program decisions.

 Access to an Oracle database using TOAD tools to extract additional management information used to assess staff performance and respond to requests and management information from Center Directors.

 Analyze program requirements to develop program or administrative systems including the systems specifications, data gathering, analytical techniques, and systems evaluation methodology.

 Analyze and evaluate the effectiveness of program operations in meeting established goals and objectives.

 Develop ad-hoc queries to access program data, extract and prepare data in a variety of electronic formats for end users, and respond effectively to requests for case, trend, or other program information from senior management staff. Develop and maintain MS Access/2003 Database System.

 Use object-oriented programming languages, as well as client and server applications development processes, multimedia and Internet technology to automate staff functions designed to improve workflow.

 Maintain, and monitor program applications and other related systems.

 Train staff and users to work with program applications and other related systems, and, where necessary, provide assistance in solving computer related problems and issues.

Programmer Analyst Cook County Government June 1999 – March 2007

Management Information System Dept. – Chicago, Illinois

 Applied full life-cycle development methodologies Systems Development Life Cycle (SDLC).

 Experience development and programming in COBOL, VSAM, DB2 and JCL

 Developed MS Access 93/2000/2003 database system, created tables, tables relationships, security, maintenance and indexes.

 Designed forms, created queries, modules, macros, views, procedures and generated reports to retrieve personal information using importing tables from MS SQL Server 2000.

 Responsible for design, development, maintenance and support of VBA backend code in a MS Access applications and modified complex information systems.

 Installed application and provided training throughout Cook County departments.

 Created password security and maintained password security table.

 Transferred and converted files from Text, Excel to CSV format to load tables.

Professional Experience

Programmer/Analyst Plexco/Chevron July 1997 – July 1998

Management Information System Dept. – Bensenville, Illinois

 Created procedures and triggers in an Oracle Database

 Manipulated files using SQL scripts

 Developed financial systems using Oracle forms v3.0, produced financial reports using SQL, PL/SQL in a database v6.x and v7.x Coded, debugged and maintained existing programs and forms.

Computer Operator Chicago Board of Trade May 1996 – July 1997

Data Processing Dept. – Chicago, Illinois

 Performed computer operation supporting functions on Tandem/6000

 Operated, monitored and controlled large IBM 3090’s mainframe computer systems and related peripheral devices.

 Experiences including OS/MVS

 Knowledge of JES2 operator commands, JCL, laser and impact printers

 Responsible for monitoring and responding to information system logged on the Unix system and ensured that production system were active at all times

 Duties included initial program load for the department terminals and trading floor systems

 Performed backups for systems on a daily, weekly and monthly bases

Project Highlights

• Applied full life-cycle development methodologies (SDLC)

• Developed Parking Tickets Database System for the Forest Preserve Police Department using MS Access database to create forms, citations and reports

• Developed Child Support, Public Defender Expert Witness, Human Resources Training program database for the Cook County Public Defender’s Office

• Developed Mailing Processing database system, automated data extract system to retrieve and download information for the Foreign Labor Certification program at the Chicago National Processing Center of the Department of Labor (DOL)

• Developed ad-hoc queries to access program data, extract and prepare data in a variety of electronic formats for end users, and respond effectively to requests for case, trend, or other program information from senior management staff. Developed and maintained MS Access/2003 Database System. Trained staff and users to work with program applications and other related systems, and where necessary, provide assistance in solving computer related problems and issues at CNPC of the Department of Labor (DOL)

• Designed forms, created queries, modules, macros, views, procedures and generated reports to retrieve personal information using importing tables from MS SQL Server 2000 and Oracle Tool.

Additional Information

• American Citizen

• Willing to relocate

• Willing to travel

• Strong ability to make necessary decisions

• Proficient in Spanish and Portuguese Language (Oral, Written)

• Versatile team skills

• Analytical skills of projects

• Ability to multi task

• Time management skills

• Knowledge of MS Office (Word, Excel, Access, VB .Net, ASP, XML, Visual Studio, MS SQL Server 2000/2005, T-SQL, Enterprise Manager )

• Motivated, energetic, and committed to the success of the organization

• Self-starter

• Eager to learn new things

• Strive for continued excellence

• Provide exceptional contributions to customer service for all customers

Educational Information

B.S., Computer Information Systems 1991 – 1995

DeVry Institute of Technology, Chicago, IL

Training

Micro Train Technologies, Chicago, IL 2007 – 2008

• Training experience in MS Windows Server 2003, Visual Studio/Net, ASP, VB/Net Knowledge developing, maintaining relational databases in Microsoft SQL (MS SQL Server 2000/2005, T-SQL, Enterprise Manager) and Oracle database environments extracting data using TOAD.

• Developing MS Access 2003 database systems, including designing forms, queries, tables, modules, macros, procedures and reports

• Training experience in MCSE/MCSA Exchange, MCAD, SQL Server administrator and Oracle database

Contact this candidate