Sql Server Project
Resume:
Charles Basham
********@**********.***
EMPLOYMENT OBJECTIVE AND FOREWARD
Candidate seeks SAS, SQL development, Senior Business Analyst, Data Analyst, Data Manager, or
Technical Lead position. My recent experiences included primary technical support for a DB2 Information
Security data mart surrounded by SAS programming. I also provided programming support for a RACF
administration tool utilizing REXX and CLIST development. For internal project initiatives, I estimated,
planned, hired, and led contract SAS programmers. Countless adhoc queries, web reports, and Excel
spreadsheets were produced in support of security audit and compliance. Strong mainframe technical and
analytical skills, seasoned with distributed development enables the employer to fill a demanding position.
SKILLS SUMMARY
Programming Languages Utilized: SAS, SQL, DB2 DBA, SQL Server Console Queries, CLIST, REXX,
COBOL/DB2/SQL, CICS, ALC, VB/ASP/SQL Server HTML/JavaScript
Databases Utilized: DB2, MS ACCESS, SQL Server
Software Proficiencies: Word, Excel, Visio, Power Point, Microsoft Project, Microsoft Live Meeting
(global), ChangeMan, Endevor, VRA, SPUFI, TSO/ISPF, FileAid, RACF
File Structures: SAS, QSAM(fixed and variable), VSAM(KSDS, ESDS), TableBase
EXPERIENCE
Bank of America – Addison, TX
August 1999 through August 2010
Information Security Analyst and Technical Lead (SAS, SQL, DB2, DBA, RACF, HTML, VB
Script, and Java Script)
• Authored a 70 page Business Requirements Document (BRD) and facilitated countless
Microsoft Office Live Meetings for a new, custom designed work flow application. This effort
involved managers and leaders from all over the continent. The BRD contained Visio diagrams
of business processes (swim lanes) as well as work-flow diagrams. Later in the project provided
user acceptance test script templates (Excel), education, and planning to ensure a quality
implementation. Developed countless queries in PC SAS / SQL during the development phase
to ensure data integrity. This project was implemented successfully in December of 2009 and
now is considered a best practice application. Daily SQL Server queries were executed and
reviewed for remediation of testing issues. Provided project oversight for this year-long effort.
• Identified mainframe RACF audit issue using data analysis via SQL and SAS. Provided
Excel spreadsheets containing data mining results, and Visio diagrams of the issue and
resolution. Facilitated Live Meetings with corporate headquarters audit staff throughout the
effort. Produced SAS and SQL programming development and support. The issue was closed
out 3 weeks ahead of schedule.
• SAS programming and DB2 Administration utilized for full life cycle development and
support of Information Security data mart. Compliance, audit, and ad-hoc support. Data Step,
Proc SQL, Macros, Proc Report, Proc Tabulate, Proc Transpose, Proc Freq and many SAS built-
in functions utilized for data cleansing, data mining, and joining security application access.
End-to-end support of data gathering, load to DB2, and data extraction / relationship builds.
• Full RACF unload/load to DB2 (IRRDBU00) along with REXX/CLIST/Panel RACF
administration tool developed and supported globally for security analysts world-wide.
Command line RACF administration applied for mainframe security controls.
• Supported and maintained various internal web applications utilizing HTML, Java Script,
VB/ASP and SQL Server
Credit Card Portfolio Acquisitions - Senior Programmer/ Analyst (SAS, COBOL, DB2, REXX, CLIST,
VB)
• Designed, programmed, tested, educated and installed critical SAS reporting application in
the division of credit card portfolio acquisitions. Utilized SAS macros, SAS Data Step, Proc Freq
and Proc Report. Replaced legacy DYL280 components.
• Developed CLIST, SKEL, and REXX components for internal team use, automated batch job
submission
• Full life cycle development of mainframe COBOL/CICS/ DB2 applications including credit
card portfolio acquisition, project billing and time entry, and promotional offers and credit card
production
Internal Business Solutions - Senior Programmer/ Analyst (SAS, COBOL, DB2, REXX, CLIST, VB)
• Technical Support for mainframe CICS/COBOL/VSAM project billing and time keeping
application
• Architected and coded a VB com component interfacing with a mainframe CICS transaction
• Prepared test plans, walk-thrus, and test data for Y2K Readiness Test
• Created personal REXX update utility
EXE Technologies
Sep 1998 – Aug 1999
Senior Programmer Analyst (CICS, COBOL, VSAM)
• Technical Specifications written for mainframe software enhancements in the Supply Chain
Execution industry. Customers included Publishers Clearing House, PepBoys, Metro Richeloue
• Coded, Tested, Implemented various CICS and COBOL batch enhancements
• Provided on-site technical support for customer software installations
• Trained DPPX programmers in basic CICS programming and Endevor
MBNA (now Bank of America)
Sep 1997 - Nov 1998
Contract Programmer Analyst (COBOL II, VSAM, CICS, CLIST, MSACCESS, WORD, EXCEL)
• Full life cycle development methodolgies exercised in software enhancements from business
requirements to code implementation. Tasks included documentation, test plans, technical
specs, coding, implementation plans and post implementation plans
• Performed detailed analysis for Y2K conversions, prepared life cycle methodology
documentation, tested and installed Y2K compliant applications.
• Analysis included detailed data flow diagrams, MS ACCESS utilized for component tracking and
reporting, heavy documentation and communication within multiple departments of company
• Project implementation and verification testing, including Endevor component moves and
production parallel testing
• Prepared and executed batch test platforms, test scripts, test cases, and resolved test cycle
issues
• Created CLIST analysis tool which would scan a cross-reference dataset and prepare a job to
execute a JCL scan. Panels, skeletons, and file-tailoring utilized.
• Created a batch CLIST which would open every VSAM control card and determine the dataset
name inside each member
Fidelity Investments
Feb 1996 - Sep 1997
Senior Programmer Analyst (COBOL COBOL II, DB2, CLIST, PLATINUM, CSF, WORD)
• Programmed enhancements for investment reports including investment summaries, bar charts,
pie charts, marketing incentives communicated on investment monthly statements, government
driven projects like the SIMPLE 401K plan for small businesses
• COBOL II / DB2 batch environment, new modules developed, some enhanced
• CSF development software utilized to format investment reports and other correspondence by
leveraging the use of pie charts, lines, and variable pitched fonts for readablity and
beautification
• Created DB2 Bind and Compile CLISTs including file tailoring, skeletons, and panels
• Created CLIST to read JCL PDS members and automatically build the GDG’s
EDUCATION
AA Temple College, Temple, TX
BA Mathematics, University of Texas, Arlington
Professional SAS Institute courses taken and applied in real-world scenarios:
SAS Programming I, II, and III
SAS Macros
SAS Macros II
SAS Functions
SAS Detail and Summary Report Writing
SAS ODS Intro
System Engineering Development Graduate, EDS
Phase I, Customer Interface Training, OJT
Phase II, Technical Development, COBOL, ALC, CICS, Production Support
Phase III, Real-world programming on large mainframe applications, full life cycle
development
Professional Technical Courses Taken:
DB2
HTML, JavaScript, ASP, VB6
C (4 self-study courses on Unix)
FileAid
Online Xpeditor
ALC/ALC Macros
Contact this candidate