Customer Service Sql Server

Ceasar Montez

Phone: 602-***-**** Email: ************@*****.***

EDUCATION: Northern Arizona University, Arizona

Bachelor of Science, Computer Information System (C.I.S.) May 1997

Bachelor of Arts, Business Administration (B.A) May 1997

PROFESSIONAL QUALIFICATIONS

• ACCESS

• SQL

• PeopleSoft 8.9

• JCL

• Unix

• Crystal Report •Sybase/PowerBuilder • Visual Basic

• Data Modeling (Cayenne/ Cool:Gen)

• Mythologies (Y2K, Accenture)

• Cobol

PROFESSIONAL EXPERIENCE

Business Analyst (United Healthcare)- Phoenix, AZ) December 2013 – May 2015

Perform Data Reports from Encounters Team utilizing Claims data and Providers data for Health Care company

Perform reports in FACETS, COSMOS and Diamond claims platform

Create SQL queries in ACCESS, PL/SQL, Sybase and Microsoft SQL server studio

Create and maintain VB scripts to automate process from website HCFA/UB-92 claims.

Completing multiple projects with documentation on MS OneNote

QC data for States and Providers

Help other coworkers solve complex projects that required VB scripts and won numerous awards.

Application Analyst (Consultnet (Abrazo Healthcare)- Phoenix, AZ) September 2013

Create automated tool with ACCESS/Excel Spreadsheet

Create SQL queries tested data.

Add users to Faxcom Software to SQL server.

Perform tape back duties with software printout

Data Analyst (Apex System (Dell)- Tempe, AZ) April 2013 - May 2013

Create Documentation with numerals Reports for Computer Manufacturer Company

Create SQL queries with data range for ticket request.

Create Access Database to filter date requirements.

Create Visual Basic modules to forward emails.

Reporting Analyst (Insperity(Medliance Inc) - Mesa, AZ) August 2012 - January 2013

Create Daily, Weekly, Monthly Cognos Reports for Pharmacy Company

Create SQL queries for ACCESS database to process Daily claims for reports and SQL on MS SQL Server to process data for research.

Applied .net updates to transfer data to SAP CRM database.

Business Analyst (Staffmark (First Service Networks) - Scottsdale, AZ) July 2011 - June 2012

Create SQL queries for ACCESS database to process metrics for financial company with Excel spreadsheet.

Create Visual Basic modules to calculates time and back date it out for weekends.

Create Pivot Charts of complex metrics

Automate process of converting flat file to spreadsheet and ACCESS database.

Create queries using Siebel CRM online software

Processor/Clerk (Robert Half International (Wells Fargo) - Chandler, AZ) December 2010 - February 2011

While Subpoenas Department(Chandler), organized subpoenas into stacks to be separated and responsible for shipping.

Delivered printouts to representatives and organized files to keep track of all subpoenas by account number.

Trained on Wells Fargo(Phoenix) new credit line as sales representatives.

Web designer (Four Winds Weavers Organization – Winslow, AZ) April 2009 - September 2010

Maintain website for non-profit organization to display rugs from visualized paper-based design into Web pages.

Responsible for maintain website for rug orders.

Added menu system that displays many options for product promotions and online marketing campaigns.

System Analyst (Salt River Pima Maricopa Government) December 2008 - April 2009

Applied SQR PeopleSoft 8.9 Query request for Education, Finance, and Payroll departments

Created ACCESS 2007 SQL database to replicate reports from Crystal Reports Business Objects XI database to produce complex reports from PeopleSoft Tables

Test SQL statements for insurance information report on Microsoft 2005 SQL Server and run insurance SQL reports

Created SharePoint page for updating information for projects and responsible for maintaining training documents

Responsible for maintaining all SQR queries and researched to find duplicates SQR queries.

Data Technician (LHR formerly Dunstone Financial LLC -– Phoenix, AZ) July 2007 - September 2008

Created ACCESS 2005 database to filter data from EXCEL to process information for Financial Collection Debt Call Center company.

Applied Crystal Reports Business Objects XI(SAP) to replicate reports from ACCESS database to produce complex reports from Sybase Information System

Applied SQL scripts to ACCESS tool to process information for major Call Center Collection Corporation

Applied VBA to process flat file output from ACCESS 2005 database for month end and daily reports

Automate on ACCESS 2005 Database for daily, month-end, and year end reports.

Run requested SQL queries on Sybase database for customer reports and corporation spreadsheets.

Technical Support (IPOWER – Phoenix, AZ) July 2006 - April 2007

Performed Website technical and sales expertise to customer websites for Internet hosting Company.

Articulated high-tech concepts in a practical fashion effectively to customers and used solid customer service skills to upgrade websites.

Aid end-users in installation of their virtual private server

Design with standards compliant code with emphasis on browser compatibility and search engine optimization

Repair websites using MYSQL and performed backup routines.

IT Consultant (Save America’s Forests – Washington, D.C.) October 2005 - December 2005

Performed Web additions to the non-profit website organization on html.

Tech support for ACCESS 97 database back on-line on network.

Performed research on Google Maps for mapping analytical Amazon project

Assistant Loan Officer (Mortgage Investors Corporation – Phoenix, AZ) July 2003 - March 2005

Applied sales expertise to customers in professional business manner for Mortgage Bank call center.

Data entry of clients customers mortgage interest rates into database and generate sales leads.

Ordered and reviewed credit reports for Mortgage customers to be processed.

Followed-up with processors and customers to ensure timely closings of full life cycle.

Web designer (Four Winds Weavers Organization – Winslow, AZ) March 2001 - March 2003

Created website for non-profit organization to display rugs from visualized paper-based design into Web pages.

Responsible for hosting website on server and maintaining domain

Analyst (Accenture formerly Anderson Consulting – Denver, CO) July 2000 - February 2001

Performed programming skills expertise on VAX/VMS Mainframe for major Health care HMO Corporation.

Performed SQL and Queries on a ACCESS 97 knowledge to create data and test programs

Perform Query research, unit testing, regression testing to make sure the data align using Cognos Powerhouse QUIZ report writer for the COBOL programs.

Applied knowledge of HIPAA federal healthcare laws to mainframe COBOL programs to process healthcare claims, Quality Assessment (QA) procedures with Design 1 software for Eligibility and Balance Act.

Created COM and CMD template to run COBOL II programs with DCL.

Created user interface screen FMS GUI screen to link to COBOL programs and CICS.

Updated Copybooks and Programs using the Configuration Management System (CMS).

Applied knowledge of hardware and software, DOS, Windows9x, and Windows NT to fine-tune satellite and land-line network connections

Programmer (Productive Data Solutions Staffing - Albuquerque, New Mexico) February - April 1999

Applied SQL statements to test two separate DB2 IBM Mainframes and test MS SQL server database.

Performed Data Modeling on a Relational database called Cayenne Ground works Bachman /Cool:Gen (IEF) with State of New Mexico for the Child/Welfare database.

Research data attributes, tested stored procedures, and review flowchart of Microsoft SQL Server tables.

Applied ACCESS tool to create and test database with SQL statements

Programmer (Milestone Consulting - Phoenix, AZ) July 1998 - January 1999

Performed Programming expertise on a VM/ESA IBM mainframe for major credit financial corporations.

Applied Y2K methodologies to COBOL programs for testing, regression testing, and upgrading programs to new format with JCL.

Operated under CMS and XEDIT environment using JCL on a VM/ESA conversational monitor system to Code COBOL II Batch programs.

Applied SPECTRUM Writer tool on mainframe to create data for testing purposes of Y2K compliant programs.

Programmer Analyst (Orthologic Corp.-Phoenix, AZ) July 1997 - April 1998

Performed UNIX expertise to manage UNIX database for Unidata (Pick Information System) for Health Care Manage Care Corporation.

Responsible financial reporting of month end, documents (graphs, charts, analysis), and HICFA insurance claims.

Applied knowledge of Citrix Win frame peer-to-peer network connection hardware and software, Windows NT

Created Managed Healthcare reports using Access forms, SQL adhoc reports, Crystal Reports layout forms report.

Created GUI screen menus for new employees, modified, data entry and maintained employee accounts using Vi Dos command on the UNIX.

Contact this candidate