Sr. Applications Analyst
Resume:
CHRISTINA S. GONZALEZ
La Feria, Texas 78559
Email:**********@*****.***
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