SUMMARY:

• Seeking a challenging position where my twenty - six years of programming, analysis, financial, and statistical experience will make a significant contribution to the organization.
• Work towards expanding my understanding and responsibility in the operation and management of the business.
• Leverage my SAS Business Intelligence experience in providing timely and meaningful data to the organization.

TECHNICAL SKILLS:

• SAS (26) Includes base and macro language in batch/interactive on Unix, PC, and Mainframe. Multi-dimensional modeling. ETL activities from most formats. 13 years with Version 9. Base, OLAP Studio, Metadata Server, Management Console, Web Report Studio, Information Delivery Portal, SAS OLAP Server, Web OLAP Viewer for Java, Data Integration Studio, MDX, SAS Stored Process Server. Extensive experience with SAS SQL, Report, ODS, AF, SCL, Graph, STAT, EIS, AppDev Studio, IntrNet, MDDB. Treasurer/presenter - North TX SAS User Group.
• Java (13) Certified Java Programmer Platform 2 (8/25/2001). Experience with JBuilder, RMI, EJB, JSP, servlets, JavaScript, along with HTML, AJAX, JAXP, SAX, DOM, JDOM, XML, XSLT. Member of the JavaMug and Java Web Services user groups/workshops.
• R(1), Python(1), MS Power BI(1), Oracle (PL/SQL,SQL*Plus/SQL*Loader/Toad (8)), SQL(16), Visual Basic (6), Netezza(4), Trillium(2), SQL Server (6), ksh(9), csh(4), sh(3), Powershell (2), DB2 (2), Cobol (3), SAP(1), PERL(3), FTP/SFTP scripting (13), Sharepoint (2), Excel/Word/Access (16), C/C++ (2), PowerBuilder (1), Lotus (5), dbase III+ (2), Paradox (1), Fortran (1), Assembly (2).
• PLATFORMS (Years)
• Unix (19), PC (26, on various operating systems) MVS/TSO/ISPF/JCL (13)

WORK EXPERIENCE:

Confidential

Data Support Programmer/Analyst

• Manage, assemble, cleanse and prepare data for scoring model development. Streamline and automate model data procurement processes.
• Produce/distribute data repositories, analytical datasets, reports and dashboards on commercial loan and lease portfolios.
• Work with risk and business analysts to design, develop, and deliver reports/analytic datasets using both base SAS and the SAS Enterprise Business Intelligence Suite of tools including SAS GRID. Create compliant and auditable business processes to support on-going reporting and analytic requirements.
• Work with IT to collect correctly defined risk/business data using SAS tools for efficiency.
• Worked as an Oracle developer on a Unix platform in all aspects of ETL, standardization, database design in support of Marketing and Analytics (scorecard) groups. Bridged/eased the gap between Oracle and the main clientele of SAS users.
• Standardize business rules and table schema in the Oracle and SAS environments.
• Used ksh, sql*ldr, sql plus, Trillium, Control-M, Datafuse, ftp, sftp, and wget to automate processing and data feeds.
• Worked with automating/synchronizing (the Unix Oracle environment with the SAP CCS/BW environments.
• Created best practices standards for SAS pass thru querying into Oracle.
• Created a MS Access/VB client application to enable Marketing analysts to live update production Oracle tables with appropriate audit, control, edit, security, constraint, index, keys, and trigger attributes to eliminate a manually intensive process plagued with issues, risks, problems, and missed deadlines with a enterprise critical process.
• Redesigned an existing database that would be properly normalized and generalized to making adding data feeds a “none event”.
• Generalized and automated additional vendor response processing of door-to-door and telemarketing processing. Setup and automated sftp services and processes. Supported several SAS groups with questions/issues. Extended the functionality of an existing SAS SCL/AF application by utilized PowerShell 2.0.

Contract Data Scientist

• Designed and developed a prototype database schema with ETL in Microsoft Access which defined several fact tables that would then be used for reporting/analytics/modeling.
• Also used Microsoft VBA, Power BI, R, and Visio to plan and develop this internal solution.

Programmer/Analyst

• Worked on refactoring, generalizing, and adding some additional standards to an application in the first stages of development.
• Pushed down current SAS 9.2 AIX Unix platform business rules into native IBM Netezza in-database SQL to maximize processing from the GUI front-end parameters that define what data and/or reporting requirements are being requested from different roles of users.
• Designed and implemented the security model in Windows, Linux, and Unix.
• Optimized processing which is commonly in the billions of rows.
• Adding generalized error-trapping procedures to enforce a robust level of processing that will be easily maintainable. Utilized compiled macros to hide the implementation and access to sensitive data requirements.

Contract Model Data Support Programmer/Analyst

• Manage, assemble, cleanse and prepare data for scoring model development.
• Streamline and automate model data procurement processes.
• Produce/distribute data repositories, analytical datasets, reports and dashboards on commercial loan and lease portfolios.
• Work with risk and business analysts to design, develop, and deliver reports/analytic datasets using both base SAS and the SAS Enterprise Business Intelligence Suite of tools including SAS GRID.
• Create compliant and auditable business processes to support on-going reporting and analytic requirements.
• Work with IT to collect correctly defined risk/business data using SAS tools for efficiency.

Programmer/Analyst

• Worked on developing a process based on an existing Excel spreadsheet.
• Moved the presentation and controlled input into HTML and using AJAX to connect to SAS Stored Processes Web Application on Linux to apply business rules, recalculation, versioning, undo functionality, and audit trails.
• Spin versions of the legacy formatted spreadsheet out to the WebDav Content server as required for ultimate consumption by an executive committee.
• Consulting group on Multi-Dimensional modeling, Web Report Studio, OLAP Studio, MDX, and the SAS 9.2 Business Intelligence platform are just some components utilized.

Programmer/Analyst

• Worked on developing, enhancing, and automating marketing ETL, reporting and analyses using SQL Server, SAS, MS Access, SFTP, and VB.
• Turned a very manual desk into almost no manual intervention necessary.

Programmer/Analyst

• Enhanced, maintained, and automated an internet website that delivered a dashboard, lookup, and drillable reporting on prescription data for internal and external clients.
• Migrated from v8 to v9 BI platform. Used OLAP Studio, Metadata Server, Management Console, Web Report Studio, Information Delivery Portal, OLAP Cube Studio, Web OLAP Viewer for Java, and DI Studio.
• Masked the v8 functionality in v9 while supporting the older platform until cut-over. V8 platform supported included MDDB, JSP, HTML, Java, XML, web services, and custom SAS Java classes on an Apache/Tomcat/Linux platform to present SAS IntrNet/OLAP applications to 600+ internet users. Streamlined the ETL process with DI Studio and Schedule Manager.

Programmer/Analyst

• Worked on easing contention issues on backend Unix processes on .Net web SAS IntrNet applications.
• Modified SAS file layouts for the interfaces with the vendor software upgrade of Sungard OmniPlus 5.5. Tuned common Unix architecture macro modules for automation across platforms (dev, qa, prod) and to dynamically query the environment to eliminate the need for hard codes.
• Used Version 9 Base, Metadata Server, Management Console and Data Integration Studio. in preparation for the SAS version 9 conversion. Defined the metabase for the version 9 BI platform.

Programmer/Analyst

• Chief developer on the Basel II initiative for the current data repository.
• Automating the sourcing of People Soft GL hierarchy tables in Unix to standardize reporting.
• Automated/ enhanced an existing enterprise status report application. Enhanced HTML/JavaScript/scripts to the intranet web server.
• Created control/exception reports to add to application robustness.
• Developed and supported OLAP cubes with their corresponding web applets. Used SCL/AF/IntrNet/EIS to create/mod several intranet applications.
• Used SQL to perform Cartesian joins for weighted average rankings for a matching routine.
• Worked with the Data Warehouse team on the schema design. Performed/coordinated/resolved annual web DR/COB/Hack for the intelligence platform. Advised on SAS Credit Scoring to a sister group.

Programmer/Analyst

• Enhanced the Inventory and Costing (ITC) system in support of Confidential ’s Financial Control department.
• This already mature production application is an assortment of COBOL and SAS with intermittent calls to DB2 and IMS on MVS/TSO. Modified program logic and file layouts to allow for greater precision and definition of current and future corporate operating unit product flows.
• Other tools utilized were Sync sort, File Aid, DB2’s QMF, and ESP.

Programmer/Analyst

• Worked on rewriting a static production reporting subsystem that sends daily output to remote printers with a DHTML web application using SAS/ODS/EIS/MDDB, Java, Javascript, DOM, XML, XSLT, and JSP/servlets.
• Automated and validated system feeds compared to People Soft General Ledger for money costing system.
• Rewriting an MS Access database to be a full functional JSP/Servlet web application to alleviate the maintenance, synchronization, and connectivity issues prevalent in the current application design.

Programmer/Analyst

• Worked on the automation of mainframe, unix, and PC based Accounting Reconciliation applications /spreadsheets to increase productivity, efficiencies, auditory controls, reporting, and accuracy within the reconciliation group.
• Development mainly focused on the external feeds into a SQL Server database with a Visual Basic interface.
• Contributed to all aspects of the application’s design from data sourcing, business rules definition, and client presentation to the project planning, documentation, testing, and contract staffing.
• Performed ad hoc and special project requests for internal and external departmental management. Investigated SAS Enterprise Miner.

Programmer/Analyst

• Enhanced and automated a customer delinquency intranet-based report.
• Enhanced the loss customer profile process.
• Helped redefine existing customer statuses and converted existing reporting applications after conversion from an in-house system to DSI Infolease, a relational database, which fed the SAS data warehouse. Utilized SASv81, Macro Language, ODS, and ftp scripts in Unix.

Programmer/Analyst

• Developed advertising campaign effectiveness analyses using SAS V8 on NT (with remote connectivity to multiple Unix environments), SAS 6.12 in Unix, and SQL in Oracle and SAS.
• Used Macro Language to streamline existing code maintenance. Created and documented pseudo-production job streams for specific long-term campaign tracking. Enhanced and automated the customer Winback process.
• Utilized ftp scripts and remote shell invocations. Helped determine Oracle table modifications. Coursework in C and Java 2.
• Confidential

Programmer/Analyst

• Developed commercial truck, equipment dealer, and manufactured homes relationship tables using statistical models utilizing SAS in a Unix server environment.
• These tables allowed for dealer profitability, demographic, and product profiling analysis by other analysts that had no previous credible key.
• The creation of this tool was accomplished by using Proc SQL to perform Cartesian products with scoring logic, several data scrubbing techniques.
• Developed dealer retention production reporting processes for several divisions. Supported and enhanced dealer financing contest. Also, a member of the Structured Development Life Cycle committee that standardized processes, data paths, macros, and naming conventions used in the creation of the SAS Data Warehouse.
• Utilized Visual Basic, MS Access, ftp scripts, and FrontPage to automate processes, reporting, and the loading of HTML to an intranet web site. Course work in C++.

Suite Programmer/Analyst

• Contractor. Developed ad hoc and production SAS reports for Accounting, Finance, Credit, Information Technology, and Equipment departments.
• Also, created reports and files for external users such as Confidential.
• Introduced SAS data scrubbing techniques utilized in merging data from purchased companies’ customer and vendor files into the JD Edwards master files to avoid duplication.
• Created files to load into the production General Ledger to by-pass manual entries.
• Utilized SAS macro language and Proc SQL along with other procedures in a MVS/TSO/ISPF environment.
• Read IDMS Culprit extracts as well as internal and external SAS data sets.

Suite Programmer/Analyst

• Contractor. Developed ad hoc and production reports for Medical, Provider Relations, Administrative and Member Services.
• Information provided was relevant for contract, legal and regulatory compliance. Mainframe SAS, Flatfiles and Legacy data were downloaded into PC SAS, Access, and Excel to provide raw and analyzed data to the end user.
• Created reporting templates for the novice to perform end user reporting.
• Performed local training and support for the North Texas IT community in MF/PC SAS, MVS/TSO/ISPF and statistical/financial analysis.
• Interfaced with internal/external systems, applications and end user personnel. Completed a PowerBuilder course.

Programmer/Analyst

• Developed a production SAS job stream to report the mainframe computer resource consumption of all divisions. Worked in IT supporting Accounting on defining specifications for current and future chargeback reporting needs. Created custom and ad hoc reports for specific information needs of different divisions.
• Interfaced with Financial Accounting hierarchy tables in the reporting process. Utilized SAS 6.08 macro language, MICS databases and compiled format libraries to create performance minded SAS programs.
• Determined where invalid transactions and applications should be applied. Created technical documentation on several aspects of the billing process. Used NDM and FTP to transfer data between many of the Nations images. Created download files for end-user reporting. Used TSO/ISPF/MVS/ESA/JCL.

Programmer II

• Developed and maintained monthly and ad hoc SAS reports for all departments of Confidential which interfaced with virtually all aspects of the Finance Company including life/health insurance, commercial/consumer loans, investigations, credit card, the auto club, mortgage and commercial/consumer trucking divisions.
• Created a mail merge program for a mass mailing from the United States Truckers Association database.
• Frequently interfaced with Associates Information Services concerning production-reporting requirements.
• Utilized SAS to create exception reports to audit existing databases for integrity.

Billing and Service Analyst.

• Computer Resource Billing System Administrator and Analyst for Information Services.
• Charged, budgeted and projected the mainframe environment. Performed financial analysis and projections concerning computer resource chargeback for all levels of management and regulatory agencies.
• Frequently interfaced with Accounting regarding chargeback, which feed the General Ledger.
• Coordinated the modifications, updates and testing of chargeback for all mainframe and system applications. Performed and presented statistical analysis regarding the mainframe computer services provided by the service company.

SAS Programmer II.

• Worked in the Statistics Department on production and ad hoc reporting requirements.
• Developed a SAS/AF application for tracking the changing bank and savings and loan institutions represented in the market place do to mergers and closures.
• Developed ad hoc reports for statisticians and economists.

Business Analyst

• Worked in the Accounting department as the main IT resources for programming, reporting, and PC support. Performed the corporate budget, cash flow, and short/long term debt analyses.

Responsibilities:

• Computer Operator. Worked in the Academic Computing Center performing console, PC lab, and printer functions.