Christina Gonzalez

San Antonio Texas *****

210-***-****

ad4cgn@r.postjobfree.com

Professional Summary

•IT Professional with 10+ Years of real world integration, implementation, development, and support maintenance experience.

•5+ years of experience in Business Intelligence and Analytics Development, Implementation and Administration experience using SQL and IBM Cognos

•5+ experience with SQL Servers and Oracle.

Technical Skills and knowledge

•Business Analysis (7 years)

•Cognos (10+ years)

•Crystal Reports (5 years)

•SQL (5 years)

•Visual Basic (5 years)

•Oracle 10G (4 years)

•Microsoft Sql Server

•Windows 7 (10+ years)

•Active Directory (10+ years)

•Server (7 years)

•Switches (5 years)

•Computer Hardware (10+ years)

•Computer Repair (7 years)

•CRM (2 years)

•Workflow Management (2years)

Professional Work Experience

Currently working at the IRS

October 2023 - Present

IT Specialist Data Management

Performing routine assignments. Maintain database operations. Assisting in returning disrupted database systems to normal operations. Creating reports and manipulating data in response to customer requirements. Updates user manuals authentication procedures, installation procedures,

systems administrator and related IT security features. IT principles methods policies and regulations data management sufficient to perform work assignments such as those listed the work requires knowledge of skill in applying backup and recovery procedures operating systems and platforms used in customer organizations and commonly used query languages such as SQL. As well as applying data management concepts and methods IT security principles the IRS operating environment communications and analytical methods and technical documentation procedures. Executing variety of database utility functions to assist customers in accessing databases using interface methods to update user manuals and technical documentation. Data storage technology and operating systems commonly used platforms and Backup recovery procedures

DISA - San Antonio

IT Customer Support Specialist March 2022 - April 2023

Tier 1 Service Desk, Team 1, as an IT SPECIALIST (CUSTSPT), GG-2210-7, step 01

●Troubleshoot printersServes as a technical analyst and primary customer liaison with responsibility for resolving difficult customer problems involving integration or configuration issues of a wide variety of applications, and desktop configurations.

●Provides technical advice and assistance to include troubleshooting, diagnosing and resolving customer application problems in response to reported or observed incidents and ensures critical business activities are carried out.

●Researches, evaluates and provides feedback on problematic trends and patterns in customer support requirements for new or modified systems and services based upon an analysis of business needs and practices.

●Reviews, validates and standardizes problem resolutions for inclusion in the problem resolution database.

●Applies information security/information assurance policies, principles and practices in the delivery of customer services.

Centre Technologies - San Antonio, TX November 2017-December 2018

Technical Support

●Project lead for projects.

●Troubleshoot user computer systems via social media remotely. Configure network WIFI via track viewer.

●Installation of PC drivers for sound, printers and scanners. Installation of Microsoft Office repair software. Review computer task processes.

●Add and remove various software. Install windows updates and increase virtual memory. Repair and troubleshoot windows operating systems.

●Conduct backup of computer windows system. Review antivirus software and quarantine viruses

●Reinstall IE browser and clear cached memory

VA - Laredo, TX March 2013 to February 2014

IT Specialist

●Resolving customer related software and hardware problems accordance with established policies and procedures;

●Responsible for diagnosing and/or resolving problems

●response to customer reported incidents via trouble tickets

●Escalating problems to the Lead or Supervisory IT Specialist as appropriate

●Overseeing Help Desk activities

●Configuring devices and software applications following established procedures;

●Provides account management support, client connectivity support and client application support for various devices; and remains current with changing IT technologies via sponsored VA training and/or through personal education.

CVI Melles Griot - Albuquerque, NM May 2011 to May 2013

Sr. Business / Report Analyst

●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 Hospital /CareTech Solutions, Findlay OH 12/2008-01/06/2010

SQL Report Analyst

●Used Meditech Depository with BVHS

●Experience with the medical records department creating reports, crystal reports for SQL queries for the medical records department.

●I also created a performance appraisal for the doctors

●Medical records out of the system so they can use diagnosis, submit diagnosis issue, diagnosis for patients

●Use the number of patients that visit the doctor, number of visits that visit the doctor on during their hospital care, during the patient care at the hospital.

●I retrieved Patient information from the System (EMR)

●Contain a patient's medical history, diagnoses, medications, treatment plans, immunization dates, allergies, radiology images, and laboratory and test results.

●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 the Meditech System to verify data during the retrieval data process.

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

●Responsible for 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. Workflow management.

●Strong interpersonal skills – must be able to work effectively as part of a project team and foster team cooperation. Demonstrate technical leadership.

●Experience managing timelines and tasks 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-effective

●Skilled using Tableau using cross joins in sql database exporting into excel as well as using pivot tables. Using a foreign key in driving worksheet in excel

Skills Used

●SQL, Cognos 8, MS Office products, Active Directory, Printers, copiers, various software.

Education

●Bachelors of Science and Information Technology in IT 1998 to 2001

●University of Phoenix - Chula Vista, CA

Contact this candidate