CHRISTINA S. GONZALEZ

***** ******** ***

La Feria, Texas 78559

956-***-****

Email:acn6tr@r.postjobfree.com

PROFESSIONAL SUMMARY

I have 12 years experience as an IT Professional. I have 6 years working

as a Programmer/Analyst with extensive experience working with Crystal

Reports, Cognos 8 Frame Work Manager, Cognos 8 Reports Studio, Cognos 10,

Oracle 10g, Visual Basic, Access, and SQL Server 2008 R2. I have experience

working SSIS packages. I have implemented EDI hierarchical structures and

revised network topology diagrams. I have created databases using MS

Access and SQL Server Enterprise Manager. Maintained ERP applications and

provide support desk support.

TECHNICAL SUMMARY

Languages/Tools: TOAD and Oracle, PL/SQL, VBA, Cognos 8, HTML, Cognos

Powerplay, CognosTransformer, Cognos Report Studio, Cognos Framework

Manager Data Modeling, SQL Server 2008, SSIS, Oracle Toad, MS Excel, MS

Office, MS Outlook, MS PowerPoint, MS Project, ODBC, Veritas Backup

Exec, Visual Studio, Visio

Databases: Oracle 11g, Oracle 10g, MS SQL Server 2008,, Oracle v8

Environments: Active Directory, Windows NT, Windows 95/98/2000/XP,

Cisco, DHCP, DSL, Ethernet, FTP, HTTP, LAN, Netware, T1, TCP/IP, Token

Ring, WINS, Wireless

CVI Melles Laser Griot, Albuquerque NM

Sr. Applications Systems Analyst

05/2010 - 5/2012

Responsible for supporting users in the use of application software

including ERP Systems and Cognos 8 Report Studio, and Cognos 10 Report

Studio reports. Proficient in IBM Cognos 8 and IBM Cognos 10 Framework

Modeling concepts. Experience with multi-level reporting such as drill-

thru's and crosstab reports and provided user selected report sorting

options to reports for extensive flexibility to users. Efficient reporting

to executive upper management using multiple ERP data imports to deliver

sales and revenue. Assisted end users to help provide system information to

business related issues. As well as other software and web browsers to

provide faster access to reports with IBM Cognos Connection. Responsible

for Business Intelligence development and maintenance design architectural

modeling by identifying and defining business rule requirements to apply

to new models. Develop, implement, and support projects to resolve and auto

mate business needs.

Resolves internal database and interface issues using Request Tracker

Plans and directs activities to develop new or revised report formats,

utilizing knowledge of principles and techniques of information and

documents management, vital records protection and cost-control practices

Coordinates activities of personnel engaged in report analysis, such as

determining the necessity of the report, simplification of the report

format, increasing content effectiveness and reduction of processing costs

I have experience with Cognos report writing, ERP systems and experience

working in a manufacturing environment.

I have experience with developing SSIS packages using SQL Server 2008 and

Oracle CRM.

BHVS/CareTech Solutions, Findlay OH

12/2008-01/06/2010

SQL Report Analyst

Responsible for maintaining SQL Server Database. Retrieve and populate data

using T-SQL statements.

Use various methods of reporting such as Crystal Reports XI and 2008,

Access Reports and creating queries to enhance reporting methods. Use

Meditech System to verify data during the retrieval data process.

Use DTS Packages in SQL Server to import data and extract data.

Responsible creating table joins and understanding SQL Server database

structures. Familiar with working with SQL Query Analyzer, SQL Enterprise

Manager able to clearly understand business needs and translate these into

reports: both accurately fulfilling the requirements of report

specifications, and identifying useful additional data during the process

and providing feedback to the specification owner.

Develop Reports using Microsoft SQL. Experience in development of complex

Reports (ex: drill down Reports). Create stored procedures and general SQL

queries. Develop complex SQL queries (ex: using various joins and sub-

queries). Utilize scripting tools. Business Analyst for Meditech Data

Repository Application. Experience and understanding of SQL Queries.

Overall working knowledge of installation/maintenance of SQL Server, be

able to use complex expressions to calculate, group, filter, parameterize,

and format the contents of a report (Crystal Reports, Access) Strong

analytical and problem-solving skills. Strong interpersonal skills - must

be able to work effectively as part of a project team and foster team co-

operation. Demonstrate technical leadership. Experience managing timelines

and task priorities.

Stays current with rapidly changing technology and applies it to business

needs. Able to effectively communicate technical information to both

technical and non-technical personnel. Experience with Microsoft Access

Databases. Used SSIS as a development reporting tool, depending on IT

management decision, cost-effectives may apply.

MetoKote Corporation, Lima, OH

02/2008 - 08/2008

LAN Support Technician.

Responsible for maintaining computer systems and maintain software

certification. Experienced using

Active Directory to provide account access for users. Responsible for

trouble shooting PC's and answered helpdesk calls, used remote access

software. Resolve trouble ticket issues with various vendors

Responsible for the support and maintenance of in house computer systems,

PC's and peripherals including installing, diagnosing, repairing,

maintaining and upgrading all hardware and equipment while ensuring optimal

workstation/network performance.

Troubleshoot problem areas in a timely and accurate fashion and provide end

users training and assistance, where required.

Identify and deliver required hardware service levels according to company

policies

Liaise with and provide training and support to end users and staff on

equipment operations and other issues

Liaise with and provide training and support to end users and staff on

equipment operations and other issues

Install, configure, test, maintain, monitor and troubleshoot end user and

network hardware, PC's, peripheral devices, printing/scanning devices,

wireless equipment, presentation equipment and other products.

PROFESSIONAL EXPERIENCE (continued)

G.S.W. Manufacturing Inc., Findlay, OH

07/2000 - 10/2006

Network Administrator

Performed support and research activities for the IS department under the

direction if the IS management staff through the following duties.

Participated in technical projects such as writing equipment specifications

or developing computer programs for SQL Server, Oracle and MS Access

applications.

Programmed any approved changes to software using VB programming and ProIV

programming, to further end user abilities to perform job functions.

Skilled working with ODBC connections, importing and exporting data from

various data sources and creating databases for specified projects using MS

Access and MS SQL Server Enterprise Manager.

Extensive experience developing DTS Packages using MS SQL Enterprise

Manager and various query wizards.

Proficient using SQL Visual 2005 programming and populated the Access forms

using ODBC connections. Experience using SQL Views, SQL Queries and enable

design changes specified databases such as the company internal sales

quoting database.

Experience with writing SQL statements and logic to automate data for

company internal database applications

Prepared support documentation for end user program applications.

Assisted analyzing database performance and optimized as needed for company

ERP application

Experienced with working with Cognos Report Writer, creating sub reports,

queries, calculation, inserting functions, filtering and sorting data in

Cognos. Designed and created catalogs.

Troubleshot various Cognos Reports with the company. Familiar with working

with Simple Lists, Text Frames, List Frames, Cross Tab Reports and Form

Frames.

Skilled using Cognos Transformer, building simple cubes, administrating

Cognos Web portal accounts and compiling cubes for various departmental

needs.

Maintained and troubleshot 8 network servers and PC's.

Administered user accounts, Windows 2003, Windows 2000, SQL Servers and e-

mail accounts on the Microsoft Exchange server.

Managed and secured server backups and restore functions.

Participated in the implementation of EDI hierarchical structures.

Revised network topology diagrams maintaining appropriate changes.

Assisted staff to diagnose and solve computer equipment problems. Repaired

and troubleshot computer systems and peripheral components on an as needed

basis at all locations.

Assisted in consultation with other management staff to maximize efficiency

through computerization.

Proposed views to implement the automation of new technology to suffice

business needs such as upgraded Windows NT servers to Windows 2003 Active

Directory for example.

Recommended hardware and software use for organizational needs.

Contributed in company quarterly physical inventory, compiled information

for variance reporting.

Insured compliance of software licenses and tracking of software

documentation. Conducted periodic audits of software utilization.

Trained employees on software and work flow enhancements for better

efficiency such as implement the latest Microsoft Office Suite for example.

Maintained the highest needed level of security for network access and

software operation.

Developed corrective and preventive actions.

Responsible to identify, collect, index, file, store, maintain, dispose and

ensure company records are readily retrievable and protected from damage.

Experience troubleshooting bar-coding and scanning system, such as assuring

that the correct data is imported correctly into company ERP application

PROFESSIONAL EXPERIENCE (continued)

United States Border Patrol,

San Diego Sector, CA 09/1998 - 03/2000

Computer Specialist

Used mini-computer applications include administrative systems to support

Sector operations with data transfer between the Dell Pentiums and

networked PCs.

Micro applications were developed for Dell PC's and networked computer

using software applications Windows 95, Microsoft Office 97.

Lotus applications, created databases using Access applications.

These duties included systems configuration, installation of hardware and

new software releases, disk management, performance monitoring and system

tuning, maintenance of security profiles, backup and archive, software

development including testing and debugging and software implementation.

Served as technical advisor to various special interest user groups such as

Access 97 and Microsoft Office applications, Visio 4.0, MS Project 4.0,

Borland C++ programming languages and assisting databases to Oracle 8.0

applications.

Worked on projects identifying requirements for software databases

application and have experience working on such projects as Y2K systems

analysis and assisting users for video teleconferencing.

Maintained national programs and county applications associated with the

Immigration Naturalization Service.

Worked closely with contract hardware technicians and users in developing

information requirements, test data and implementing systems.

Performed application system performance evaluations;

Reviewed reported system problems, both hardware and software; verified

thee problems and formulated unique approaches and methods which effect

timely results.

Directed software maintenance and change control and evaluated and

recommended changes to software operations.

Designed system audit routines to test data system integrity and to ensure

the accuracy and reliability of the information resources of the system.

Conducted user training sessions at Sector Headquarters and remote sites

for both I&NS mainframe databases and their access techniques, and for

local micro and mini applications.

Prepared project reports and documentation describing information

requirements, user guides, software-programming techniques, logical view of

the systems database, and equipment modification requirements required to

achieve system performance levels.

United States Border Patrol (Anti-Smuggling Unit), Chula Vista, CA

09/1997 - 09/1998

Transportation Assistant (40 hours per week)

Transported undercover vehicles from station to Sector garage, electronics

branch for radio repairs and/or commercial repair facilities.

Prepared and reviewed various vehicle reports using computer software, such

as (daily weekly, and monthly) and correspondence to the Patrol Agent in

Charge of reporting the status of the vehicle fleet assigned to the

station.

Reconciled reported mileage, reported gasoline usage and gas credit card

receipts to assure all information was properly reflected on Form G-205,

was internally consistent and was consistent with previously reported

figures.

Incumbent independently researched and determined the availability and

sources of required items completing appropriate forms and using the

following procurement sources: Open market and GSA contracts through

established procedures, purchases or ordered vehicle parts locally and/or

through GSA contracts.

Incumbent will act as liaison between station personnel and sector garage

mechanics, Fleet Manager, Transportation Operations Specialist, procurement

personnel, electronics branch personnel, and commercial vendors.

EDUCATION

University of Phoenix

Bachelors of Science and Information Systems, 04/2001 GPA is 3.19

TRAINING

Prior Military - U.S. Veteran

Business Application Software Certificate 1996,

Trained in Video teleconferencing 1999.

Trained in Maintaining and Troubleshooting Computers - September 2000

Trained in ProIV programming language, El Segundo, CA - April 2001

Office of Information Technology Certificate, Department of Education Ohio

- 2002

Cognos Impromptu Advanced Report Building 7.3 - 2006, Cognos Impromptu

Administration 7.3 - 2006

Medical Terminology Findlay, OH Millstream Adult Education 1/2009- 2/2009

ICD-9-CM Coding Findlay, OH Millstream Adult Education 3/2009 - 4/2009

CPT/HCPCS, Coding Findlay, OH Millstream Adult Education 5/2009 -6/2009

Medical Billing, OH Millstream Adult Education 10/2009 - 12/2009

Intermediate Crystal Reports 2008, Webucator 5/2009

Advanced Crystal Reports 2008, Webucator 5/2009

Cognos 8 Framework Manager Data Model 7/2010

Cognos 8 Report Studio 7/2010

Cognos 10 Framework Manager - 4/2012

In-Active Security Clearance (confidential)

AWARDS

Outstanding Performance United States Border Patrol, 1998

Show of Appreciation United States Border Patrol, 1998

Executive Correspondence Letter United States Border Patrol, 1998

Army Lapel button, National Defense Service Medal, Army Service Ribbon,

Overseas Service Ribbon and Marksman Marksmanship qualification Badge.

Other Information

Speak some Spanish/very knowledgeable

Have had background Security Clearance (Level - Confidential)

Ability to read, analyze, communicate and interpret common scientific and

technical journals, financial reports, and legal documents.

Ability to respond to common inquiries or complaints from end users or

management member.

Ability to effectively present information to top management, public

groups, and/or boards of directors. Ability to work in a multi-cultural

organization. Ability to manage multiple projects.

Contact this candidate