Alton Hill Email & Phone Number

Responsibilities:-Obtain working knowledge of the organization and business practices as pertaining to the system.-Migrate and Re-Map Existing Reports from system-Create New Crystal Reports based on business requirements and reporting standards.-Test and Validate Report Data based on business requirements and use cases.-Create and maintain any or all customized data mappings of database fields for reference.-Create and maintain a formula repository with standard business definitions.-Update and maintain a report inventory-Provide support for other IT projects pertaining to system

• Provide IT reporting on Metrics for call center and other IT areas.• Developed reports in crystal Reports XI and SQL queries for call center.• Provided advanced Crystal Reports in support of the CIO for data analysis.• Created Excel Dashboard for CIO departmental analysis. • Performed independent validation and verification against data and ticket information.

Crystal Report XI, Access, Excel development• Managed and maintained Business Objects CMC application in support of service level agreement reporting• Maintained Crystal Reports application not limited to design, implementation and maintenance.• Provided VBA development using Microsoft Access• Interfaced with customer to develop customized reports on customer service statistics and SLA requirements.

ITSolutions (Interactive Technology Solutions), Silver Springs, MDSenior Consultant 2010-Present• Developing Crystal Report Writer XI programs and creating custom reports using oracle relational database management system database. • Using Toad SQL to create sql queries and produce report verifications.• Documented new Crystal Report programs using CMMI(Capability Maturity Model Integration- Level/2).• Saved program versions using Visual SourceSafe.• Participated in discussions with the customer along with assigned Business Analyst to clearly understand reporting needs.

- Crystal Reporting XI - develop new reports and maintain existing reports. Oracle database usage. Mainframe responsibility for resolving production issues of the daily production system. Resolving these system issues sometimes required file creations, estimating resolution time, designing, testing, and implementing mainframe IBM/MVS COBOL/JCL/DB, CICS maintenance.Mainframe Programmer/Analyst with over 15-year’s application development experience. -Strong experience with ENTERPRISE COBOL FOR Z/OS, CICS, JCL,VSAM,FILEAID, MVS - Developed new SQL database and SQL queries, using DTS package(includes vbscript), stored procedures and Crystal reports.-Some Visual Basic coding.

- Administrator for the Mortgage Origination Prymak Application System.- Client - Server Web - based front-end system.- This system provided full featured mortgage loan application solutions for mortgage Lenders using the Evolution ToolKit, along with loan origination Applications.- Modified and created mortgage forms and screens.- Handled any system -related issues and installations.- Programmed system enhancements for new mortgage products.- Provided bank-wide application user support for the Prymak application.

• Support production maintenance of assigned Cobol POD application system. Resolved the error handling of any issues via diagnosis and resolution, including on call rotation.• Supported ReportEdge and Informatter (Metavante's Report Writers) creating numerous reports and files saving the company millions of dollars in savings. Example: Supported the banks REIT(real estate investment trust) project creating reports that saved the bank $2.5 million per year.• Designed CICS COBOL application system to allow the operator to acquire online, all insufficient overdraft funds for a selected account. The operator can also update the fee amount and mark the item with an asterisk to denote paid item. •Using CICS, this was accomplished using the insufficient file input and displaying this information on TSO Screen. The customer’s name and address along with the insufficient fund line items were used by clerks, to mark the line items as paid or not paid for later review via report. • Documented the flow of Application Programs to understand the system.• Responsible for Version control, movement of code and components from deployment area to integration system and production system.Environment: Mainframe (COBOL, CICS, CEDF(Interactive Debugging), VSAM)• Researched and modified CICS system using CICS/VS transaction debugging procedures to determine cause of system problems. CEDF, Transaction Dumps, Compile listings were used to find causes of program failures.

Aa, Data Processing

High School, College Preparatory