SKILLS:

Experience in: mainframe products SAS, SQL, TSO, JCL, CICS, DB2, RACF, Platinum.

Experience in: PC software products and systems Microsoft Office, UNIX (Korn, Bourne, Bash, and C shells), SSH Tectia Client,, DB2, PC SAS, SQL, AQT (similar to T - SQL), Attachmate Reflection (FTP Client, Visual Basic Script, etc.), XML, HTML, CSS, UltraEdit, Confidential Link; flat file formats - Commonline 4,5, CAM., Excellent written and verbal communication skills.

EXPERIENCE:

Confidential

SAS Programmer

Responsibilities:

• Fulfill SAS requests from Default Prevention, Skip tracing, and Receipts Operations.
• Suggest and help implement process changes, through interaction with IT, to ultimately improve cost effectiveness.
• Provide mentoring support for those less experienced in SQL and SAS to rectify coding issues - suggest techniques to solve same.
• Update data warehouse adding tables, indexes, attributes. Train others in the process.
• Develop new production techniques with an emphasis on improved efficiency to make the best use of CPU time.
• Review existing SAS production programs to ensure efficiency and effectiveness.
• Analyze requests for statistical data, account listings and other forms of informations.
• Determine what resources are required to complete the request.
• Translate the request into a set of SAS and SQL instructions and conditions that the SAS system can process.
• Verify the accuracy of the results before they are sent to the requestor.
• Track progress of projects and report any changes in expected dates of completion to the supervisor or requestor.
• Provide times spent on projects for cost estimates for Marketing Reps.
• Analyze and develop statistical data.
• Quality control check all output developed or programmed.
• Take necessary steps to access resources needed to perform all duties assigned.
• Develop and maintain statistical programs for the Loan Guaranty Services area on a weekly basis.
• Analyze all test output to correct coding problems and input data.
• Perform special projects assigned by upper management.
• Analyze requests to create Visual Basic scripts to perform online updates of multiple accounts in the Confidential system and the Confidential system.
• Determine transactions and update authorities required to complete request. If any are unavailable, take necessary steps to gain access to them.
• Determine time necessary to complete request, based upon priority level, available resources, and volume of accounts updated.
• Translate request into a set of instructions and conditions that the Visual Basic system can process.
• Include in script a feature to create an error log file of all accounts not updated successfully.
• Verify the accuracy of the update procedure used in the Visual Basic script before it is executed.
• Execute the Visual Basic script to perform requested account updates.
• After execution, provide a copy of the error log to requestor.
• Crystal Reports administrator developed custom reports, maintained department access, etc.

Management Analyst (BA)

Confidential

Responsibilities:

• Represent Loan Guaranty Services interests in issues that relate to Confidential programming or system processes, which requires extensive interaction with IT - Core Systems Development and IT-Application Development departments.
• Maintain a current, thorough knowledge of existing edits within the Confidential system that affect activities performed within Confidential (loan guaranty processing, eligibility verification, data reporting, etc.). A substantial understanding of approximately 300 Confidential modules required.
• Provide Business Group approval for all change requests affecting Confidential and related business requirements and user specifications.
• Perform final review and provide ultimate approval of all change requests prior to their migration into the production environment.
• Develop business requirements detailing programming changes affecting Confidential .
• Provide IT-Core Systems Development group with detailed explanation of programming changes being requested for modules administered by Confidential -- administering intensive program and/or process research to determine the ramifications of the proposed changes.
• Check user specifications to verify that IT-Core Systems Development has accurately conveyed the requested change. Revise and correct them as necessary to meet objective; provide final approval of user specs as appropriate.
• Research and correct accounts via Data Change Request process through IT; i.e., review accounts and specifically indicate to IT the appropriate Confidential attributes that need to be changed, added, and/or deleted - or, identifying a specific data row on the Confidential database that should be added or deleted.
• Research system-related questions and issues and determine appropriate response or appropriate corrective action to units within Confidential, Education Services, or Remote Client Services.
• Research errors affecting the Confidential database that result from to system edits, transmission errors, or staff error.
• Study and recommend enhancements for loan guaranty processing.