TECHNICAL SKILLS:

SKILLS: UNIX (2 years), Mainframe JCL, Utilities (19 years), Business Process Analysis (19 years), SAS (2 years), Business Requirements (19 years), Production Support (19 years), ETL (5 years), Data Warehousing / Business Intelligence (6 years), Microsoft Office (15 years), Project Management (3 years), Technical Analysis (19 years), Data Analysis (15 years), Re - engineering (19 years), Quality Assurance / Testing (19 years) Business Analysis, Workflow Analysis, Technical Analysis, Application Re-engineering, Systems Integration, Performance tuning, Requirements, Design, Development, Testing, Project Management

SOFTWARE: COGNOS, MICROSTRATEGY (exposure), PEP+, SYSTEMATICS, WARRINGTON, DATA- LINK, MSA, Action 2000, in-house data delivery system, in-house GL systems, AZ AHCCCS, medical/dental insurance claims software and numerous other types of application software.

WORK EXPERIENCE:

Quality Assurance Analyst

Confidential, Phoenix, AZ

Responsibilities:

• Perform QA testing for Recipient application for Medicaid and state programs; work on 1095B and EDI processes, web to mainframe interfaces.
• Monitored batch run using scheduling software.

Tools: used: ALM, CICS, WEB, EDI, Windows Desktop tools, Batch MVS JCL, Control - M, Ultra-edit

Other Tools in use: .NET, XML, VISIO

Quality Assurance Analyst / Business Analyst

Confidential, Phoenix, AZ

Responsibilities:

Tools: used: SQL Server; VISIO, MS Desktop

Other Tools in use: SSIS, SSRS, .Net development

Responsibilities:

• Captured requirements for conversion of numerous desktop procedures with manual hand-offs to single web based solution (.NET, SQL Server)
• Recommended standardization across state districts
• Recommended single technical solution for multiple similar but currently different program solutions including TANF, AZEIP, DDD, AHCCCS.
• Suggested solutions along business process lines vs. current departmental or legacy application lines
• All systems were .Net and SQL Server based.

Technical Data Analyst

Confidential, Tempe, AZ

Tools: used: CONNEXION, JCL, File-AID, Ultra-Edit, Sharepoint document management and workflow

Responsibilities:

• Perform quality assurance testing and complete documentation for EDI / NACHA payment file conversions from one mainframe platform to another for 20 business customers.
• Work with programmers to resolve file errors and correct documentation.
• Identified requirements gap around customer setup requiring additional requirements specification and management of previously converted customers

WCC Rule Writer

Confidential, Phoenix, AZ

Tools: Used: Excel, MF JCL, File-Aid

Other Tools in Use: SAS

Responsibilities:

• Rule writer for in-house business application.
• Rules determine which recommendations customer service reps will see, what automated actions will be applied to credit cases, and whether cases are eligible for automatic dialing for credit extension offers or not.
• Identified error in current processing rules related to credit extensions
• Recommended consolidation of ownership (Domestic and International rule sets)

Programmer Analyst

Confidential, Phoenix, AZ

Other Tools used: SAS Enterprise edition, SQL Server, Easytrieve Plus, MF JCL

Responsibilities:

• Develop ad hoc reporting for complex capture data (CAPN) utilizing EASYTRIEVE Plus, SQL Server and Enterprise SAS against SQL Server Warehouse.
• Correct current reporting; added process enhancements and new data sources.
• Worked with auditors to balance inputs to reporting
• Identified significant error: credits incorrectly being reported as debits (POS Returns)

Developer

Confidential, Glendale, AZ

Tools: Used: Microsoft Excel, Visio for Analysis, Extreme Dialog

Other Tools in Use: AS400, JCL, File-AID

Responsibilities:

• Service Catalog - worked to standardize naming conventions for ordering software
• Worked with users to identify reason for high salesforce compensation: determined users had the ability to enter an existing customer as new by using a different software system thereby increasing compensation from 3% for existing customers to 8% for new.
• Recommended consolidation of software products to single solution.

Lead Programmer Analyst

Confidential, Phoenix, AZ

Tools: Used: COGNOS, UDB, MF JCL, SAS, VISIO, Windows Desktop, In-house PM Solution, UNIX

Other Tools In Use: Lotus Notes, VB6, JAVA, Excel

Responsibilities:

• For Risk data warehouse using SAS ETL and Java front-end, resolved 60+ data quality errors through data analysis, code modification, correction of incorrect data\
• For Risk data warehouse - consolidated code base for 3 environments by moving all environmental parameters to Unix scripts and out of code, improved release process
• For International Risk data warehouse added new product reporting for Installment Loans
• Modified ETL code and Unix scripts to allow addition of new markets without code changes
• Reduced COGNOS' cube build time by 75% (from 3 days to 1 day) by reorganizing cube structures, implementing views, removing redundant objects.
• Revised ERD currently in use to improve data clarity, revised dimensional data
• Standardized metrics naming across reports
• Owned VB application, re-designed to web solution for architectural compliance.
• Eliminated email and manual hand-offs with design for web based processing including centralized SFTP solution, sweep process to pull in files for processing and backup and zip those already processed

Programmer / Analyst

Confidential, Tempe, AZ

Tools: used: HTML, CSS, MQSERIES, CICS, MF JCL, MS Desktop, Librarian or Eclipse

Tools: in Use: Java, Custom Map generator for creating CICS MAPS from HTML

Responsibilities:

• Analyzed role based security for finance systems, code did not execute as documented, discussed with PM; new code corrected to meet previously documented functionality
• Used MQSERIES for inter-system communication between CIF and other back-end systems
• Documented custom interface for front-end JAVA web based system to back-end CICS web Services

Programmer / Analyst

Confidential, Phoenix, AZ

Tools: Used: File-aid, CICS, Change-man, Panvalet, Lotus Notes, Project Work Bench, SPUF, QMF, Xpediter, MF JCL, MS Desktop

Other Tools in Use: JobTrac

Responsibilities:

• Re-architected existing store, transmit and retrieve, split application (STARS) for reduction in problem tickets from several hundred a month to two or three caused by third parties
• Trained offshore and onshore personnel on production support procedures for turnover of support.
• Technical Lead for implementation of new product using third party processor
• PM to bring same new product in-house, (23 groups including both business and technical involved); Travel product did not go live due to change in market conditions

Programmer / Analyst

Confidential, Albuquerque, NM

Tools: in Use: File-aid, CICS, Librarian, SPUFI, QMF, Xpediter, MF JCL, MS Desktop

Responsibilities:

• Wrote the integration for new Dental eligibility to existing medical eligibility system
• Retained after contract loss to complete design / coding work

Programmer / Analyst

Confidential, Phoenix, AZ

Tools: in Use: File-aid, CICS, Panvalet, SPUFI, QMF, Xpediter, MF JCL, MS Desktop, VISIO

Responsibilities:

• For a company processing large volumes of pharmaceutical information did performance tuning.
• BI application was written on mainframe for mainframe data warehouse and utilized CICS transactions as capture for reporting criteria.
• Corrected all outstanding logic errors
• Began working with database personnel to fine tune batch processing performance.

Programmer / Analyst

Confidential, Phoenix, AZ

Tools: used: Micro-Focus Cobol

Responsibilities:

• Implemented a PC Based tool, MICRO-FOCUS, to emulate a CICS environment; then used it to develop a generic table handling application for CICS.

Programmer / Analyst

Confidential, Phoenix, AZ

Tools: used: CICS, ADABAS, JCL, File-aid, MS Desktop, Visio

Responsibilities:

• Wrote new medical insurance eligibility system using CICS, COBOL, ADABAS; integrated to existing state eligibility support systems.

Programmer / Analyst

Confidential, Phoenix, AZ

Tools: Used: CICS, Xpediter, File-AID; MS Desktop

Responsibilities:

• Designed and developed CICS/COBOLII/DB2 programs to automate entries to GL application.

Programmer

Confidential, Phoenix, AZ

Tools: used: File-aid, Xpediter, MVS JCL

Responsibilities:

• As a team member, implemented a payment by phone system. Improved application performance though
• VSAM performance tuning; instructed team members on VSAM tuning.