Senior SAS Developer/Programmer Analyst

PROFESSIONAL EXPERIENCE SUMMARY:•••••Accomplished software developer/architect with over Eleven years of solid experience in analysis, design, development, testing and implementation of Financial, Semiconductor, Statistical, CRO and Call/Customer Service Center applications.•••••Served, in a lead capacity, on various projects and provide critical oversight, coaching and mentoring leadership to numerous junior, intermediate and peer professionals.•••••Extensive experience in Creating and Manipulating small/medium/large SAS Datasets for subsequent generation of reports, tables, listings and graphs.•••••Experienced in SAS/BASE, SAS/ACCESS, SAS/CONNECT, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ODS in Windows and UNIX environments.•••••Excellent command in producing reports employing various SAS Procedures like Print, Printto, Report, Summary, Freq, Tabulate, Means, Univariate, Rank, SQL, Access, Datasets, Contents, Copy, Connect and various data step statements that includes but not limited to Data _NULL_.•••••Inherit, modify, optimize existing SAS programs and create new programs using the SAS macro facility to improve efficiency of various routines, ease and speed of modification as well as consistency of output result streams.•••••Extensive experience with regression analysis, correlation analysis, analysis of variance, analysis of categorical data and cluster analysis.•••••Extensive experience in RDBMS development including application of various implementations of the Structure Query Language or SQL strings.•••••Extensively develop client-server applications on multiple operating system platforms, i.e., Windows and UNIX operating system environments.•••••Possess excellent communication, problem solving and people skills. Reputed for dedicated teamwork, high-energy with solid work ethic and commitment to achieving various goals and key objectives as set forth by senior management of the company.•••••TECHNICAL SKILLS:•••••Operating Systems: MS Windows XP/ NT / ••••• / •••••, HP-UX, Sun Solaris, AIK, IBM OS/••••• and Mainframe Operating Systems•••••Languages: SAS, SQL, Visual Basic for Applications, korn, perl, awk and sed Unix-shell scripting•••••SAS Tools: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, SAS/STAT, SAS/ODS, SAS/ETS•••••RDBMS: Oracle 8i/9i, Sybase, MS-Access •••••Internet Software: Java script, HTML, Cascading Style Sheets or CSS•••••Other Technologies: MS Office Productivity tools, i.e. Excel, Access, Word and Powerpoint•••••EDUCATION:•••••MS, AgriEconomics, Alabama A&M University, Normal, Alabama
(GPA •••••/•••••)
BS, Agribusiness Economics, Alabama A&M University, Normal, Alabama (GPA •••••/•••••)•••••PROFESSIONAL EXPERIENCE:••••••••••/••••• Present AMERICA ON LINE, Dulles, Virginia
SENIOR ANALYST •••••Work within the Member Service Planning and Research group to provide data analysis support for multiple call-center queues. Core responsibilities include responding to daily data analysis requests from different support-queue managers that seek to actively monitor how best to provide improved member services support for the Online company; extract high-volume members service data from company data warehouse and build predictive statistical models to support Broad Band Tech-support, Narrow Band Tech-support and Billing queues; serves as the lead analyst on a Call Volume Task Force team primarily responsible for tracking, analyzing and monitoring trend of call volumes across call-center queues; provide ad hoc analysis and reporting support to different queue managers within member services department. Analysis tools used include but not limited SQL, the SAS System [ Windows and UNIX operating system environments ], and Microsoft Office Productivity tools, i.e., Excel, Access, Word and Access database applications. •••••Environment: Base SAS (v•••••x, v•••••x, and v•••••x releases), SAS/Access, SAS/Connect, SAS/STAT, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, Sybase, IBM Redbrick, Microsoft productivity tools (Excel, Word, Access and Powerpoint), MS Windows NT/XP professional and different variants of the UNIX operating systems, core Unix shell scripting.
••••••••••/••••• •••••/••••• MODIS IT CONSULTING: FREDDIE MAC, McLean, Virginia
SENIOR SAS DEVELOPER •••••Work within the OFHEO (Office of Federal Housing Enterprise Oversight) data delivery and production support team at Freddie Mac. Charged with troubleshooting various data procurement, processing, analysis, reporting and delivery to OFHEO and internal business areas; monitoring the smooth running of various production jobs and serves as primary liaison and point of contact for the identification and resolution of various data problems and reporting issues; authored numerous SAS (Mainframe and Unix variants), Unix Shell and some rudimentary Perl scripts to solve various production support problems; implemented SAS algorithms to identify, based upon OFHEO defined multiple business rules, mortgage loan level records edit failures and subsequent analysis of the identified data streams; automated Non-Mortgage Instrument data import process and subsequent analysis of data stream for failure of business rules; perform various other ad hoc requests.•••••Environment: Base SAS (v•••••x release), SAS/Access, SAS/Connect, SAS/STAT, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, Sybase, Microsoft productivity tools (Excel, Word, Access and Powerpoint), MS Windows NT/XP professional and different variants of the UNIX operating systems, core Unix shell scripting.••••••••••/••••• •••••/••••• PHARMACEUTICAL RESEARCH ASSOCIATES INTERNATIONAL
ANALYSIS PROGRAMMER II Charlottesville, Virginia•••••Charged with Lead Analysis Programmer responsibilities in ensuring that all of the analysis programming work was done correctly, on-time and within budget for a particular project; provided programming associates with all relevant project information and documentation such that the programmer was designated for the right task; ensured that all work was appropriately quality assured and alerted management with relevant project-specific issues; reviewed clinical study contract, study protocol, project time lines, analysis plan, case report forms and prepare annotated case report forms; extract study specific raw data from dedicated legacy database, wrote various SAS routines to support production of derived SAS datasets and subsequent production of analysis tables, figures and listing as called for in the analysis plan; participate in client multi-discipline data analysis review process and helped prepare final study analysis output to clients.•••••Environment: Base SAS (v•••••x, v•••••x), SAS/Access, SAS/Connect, SAS/STAT, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, Sybase, Microsoft productivity tools (Excel, Word, Access and Powerpoint), MS Windows NT/XP professional.••••••••••/••••• •••••/••••• AJILON CONSULTING: FANNIE MAE CORPORATION, WASHINGTON, D.C.
SENIOR SAS PROGRAMMER ANALYST •••••Charged with conducting impact-sensitivity analysis on how non-occupant co-borrower rule simplification affects back-ratios and scorecard variables for pertinent desktop underwriter [DU] cases. This project entails identification of historical methodology or rules for calculating back-ratios and scorecard variables for borrowers with one or more non-resident co-borrowers; identification of applicable/logical data elements or attributes needed for the analysis, as currently documented in the Fannie Mae Information System [FMIS] Desktop Underwriter [DU] dataset glossary; extraction of data streams, from the Fannie Mae legacy relational data warehouse, i.e., Desktop Underwriter cases and subsequent analysis of extracted data streams to incorporate liabilities and assets, of the non-resident co-borrowers, in the recalculation of key back-ratios and scorecard variables; participated in resolving several ad hoc problems with relative quick turn-around and highly satisfactory feedback from management. Software application usage includes but not limited to the SAS System, Release ••••• [BASE, STATS, GRAPH, ETS, AF, Macro facility], Windows NT Professional, UNIX Operating system, i.e., HP-UX, UNIX Power tools, i.e., korn, bourne, sed, egrep, and awk, Microsoft Office productivity tools, i.e., Excel and Word•••••Environment: Base SAS (v•••••x release), SAS/Access, SAS/Connect, SAS/STAT, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, Oracle •••••i, Microsoft productivity tools (Excel, Word, Access and Powerpoint), MS Windows NT/XP professional and different variants of the UNIX operating systems, core Unix shell scripting, IBM Mainframe.••••••••••/••••• •••••/••••• CAPITAL ONE FINANCIAL, Richmond/Virginia
SENIOR SAS DEVELOPER-ARCHITECT•••••Primarily responsible for the development of next generation multi-tier and platform independent distributed applications in support of multiple customers across different lines of business of the corporation; provided myriad application development support for data analysts, statisticians and business analysts community of Marketing and Analyses sector of the corporation; helped with coaching and mentoring of entry level, junior and peer staff with respect to their respective company specific competency goals; participated in department-wide leadership forums to formulate directives, policies and resource allocation schemes for the company. Software usage included but not limited to the SAS Systems, Windows •••••/XP Professional, MVS, UNIX Operating System, i.e., HP-UX, Unix Shell scripting, i.e., Perl, korn, Awk and Sed scripting, ORACLE database systems, SQL, Microsoft Office/XP Productivity Tools and Outlook, SAS embedded HTML and Java scripting.•••••Environment: Base SAS (v•••••x, v•••••x, and v•••••x releases), SAS/Access, SAS/Connect, SAS/STAT, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, Sybase, IBM Redbrick, Microsoft productivity tools (Excel, Word, Access and Powerpoint), MS Windows NT/XP professional and different variants of the UNIX operating systems, core Unix shell scripting.•••••3/••••• - •••••/••••• INFINEON TECHNOLOGIES RICHMOND, Sandston, Virginia•••••DATA ANALYSIS ENGINEER

Major responsibilities included performing core data analyses and reporting functionality within the Analysis Tools Section of the Product Sustaining Group. Directly responsible for designing, coding and implementation of various data loaders (importers), using the SAS Systems in the UNIX and Windows OS environments, to extract data from different manufacturing scalable databases, i.e., ORACLE DBMS and Generic flat-files; production of summary reports, i.e., statistical descriptive charts and graphs depicting different engineering test parameter distributions and correlation of test parameters to product yields; production of Wafer Maps that depict different fail region latches per chip (Dynamic Random Access Memory or DRAM) locations on wafers; production of pattern recognition data for further rigorous analysis by online test engineers; authored various operating scripts for automation of all data extraction, analysis and subsequent generation of analysis reports for publication on the companys intranet or web-page at regular intervals; responsible for the design and implementation of custom SAS scripts to accommodate specific analysis requirements of in-house engineering customers.
Environment: Base SAS (v•••••x), SAS/Access, SAS/Connect, SAS/STAT, SAS/Graph, SAS/SQL, SAS/Macros, Oracle RBMS, Sybase, Microsoft productivity tools (Excel, Word, Access and Powerpoint), MS Windows NT and different variants of the UNIX operating systems, core Unix shell scripting.•••••5/••••• - 3/••••• CENTRAL FIDELITY BANK/WACHOVIA BANK, Richmond, Virginia
SENIOR FINANCIAL SYSTEMS ANALYST

Major responsibilities included supporting different levels of system related tasks of the Financial Systems Group by accomplishing the development of end-user applications in SAS and/or Microsoft Office Productivity tools, i.e., Excel spreadsheets and Access RDBMS applications; research and settlement of bank-wide General Ledger suspense entries through reconciliation of system rejects; administration of bank-wide General Ledger security access of all users; development of methodology, research, collection, manipulation and analysis of bankcard industry specific data; preparation of daily product specific, i.e., VISA, MASTERCARD, outstanding reports; preparation of monthly and quarterly bankcard products Statement of Income, Comparative Income Statement analysis, Trended Statement of income analysis, Portfolio Performance yields analysis and Delinquency trend reports; Performed complex statistical analyses of data using appropriate statistical methods and tests.•••••Environment: Base SAS (v•••••x), SAS/Access, SAS/Connect, SAS/STAT, SAS/Graph, SAS/SQL, SAS/Macros, Oracle RDBMS, Sybase, Microsoft productivity tools (Excel, Word, Access and Powerpoint), MS Windows NT professional and IBM Mainframe.•••••6/••••• - 5/••••••••••VIRGINIA DEPARTMENT OF CORRECTIONS, Richmond, Virginia •••••SENIOR INMATE POPULATION FORECAST ANALYST•••••Major responsibilities included supporting the statistical forecasting/projection effort of the department by developing methodology, manipulation and analyses of pertinent time-series historical datasets for model input and forecasting from discernible historical pattern. Served as an integral part of a technical and policy consensus groups responsible for generating statistically accurate and defensible State of Virginia Public Safety sector inmate population and new commitment forecasts. Other responsibilities include reviewing, analyses, processing and editing source data for reliability, integrity and validation; provided both technical and functional recommendations for changes in the departmental information systems to appropriately accommodate forecasting needs; performed various complex statistical analyses of data using appropriate statistical methods and tests.•••••Environment: Base SAS (v•••••x), SAS/Access, SAS/Connect, SAS/STAT, SAS/Graph, SAS/SQL, SAS/Macros, Sybase, IBM Redbrick, Microsoft productivity tools (Excel, Word, Access and Powerpoint), MS Windows NT professional and IBM Mainframe.•••••SKILLS: •••••SKILL LEVEL LAST USED EXPERIENCE

The SAS System Advanced Current ••••• years
Unix Shell Scripting Intermediate Current 5 years
VB for Applications Intermediate 3 years ago 3 years•••••AWARDS and PATENTS:•••••- BUSINESS PLANNING EXCELLENCE AWARD - America Online, July •••••
- TECHNICAL EXCELLENCE AWARD - Infineon Technologies Richmond
- U.S. PATENT FILED: TEST SEQUENCE (Actual, Accumulated and
Derivative) LIMITED YIELD CALCULATIONS - Infineon
Technologies Richmond