SUMMARY:

• Seeking a challenging position where my seventeen 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 CRM, SAS Enterprise Miner, SAS Credit Scoring, and BI experience in creating meaningful data for the organization.
• SAS (18) Includes base and macro language in batch/interactive on PC, Unix, and Mainframe.
• Experience with SQL, Graph, Report, ODS, AF, SCL, EIS, AppDev Studio, IntrNet, and MDDB. 
• J ava (6) Certified Java Programmer Platform 2 (8/25/2001).
• Experience with JBuilder 6.0, RMI, EJB, JSP, servlets, JavaScript, along with html, JAXP, SAX, DOM, JDOM, XML, XSLT. Member of the JavaMug and Java Web Services user groups/workshops.
• .Net (1), FTP scripting (7), MS Excel/Word/Access (9), Visual Basic 6.0 (3), SQL Server 7.0 (3), Oracle/PL SQL (6), C/C++ (1)
• Others used in the not so recent past: PowerBuilder (1), Lotus (5), dbase III+ (2), Paradox (1), Cobol (3), Fortran (1), and assembly (1).

TECHNICAL SKILLS:

Platforms (Years): MVS/TSO/ISPF/JCL (13) PC (17, on various operating systems) Unix/Solaris (7)

WORK EXPERIENCE:

Confidential, Roseville, MN

Programmer/Analyst

Responsibilities:

• 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 hardcodes.
• Used XML Mapper to define the metabase in preparation for the SAS version 9 conversion.
• Used .Net ASP and C# for the web interface.

Confidential, Irving, TX

Programmer/Analyst

Responsibilities:

• 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.

Confidential, Garland, TX

Programmer/Analyst

Responsibilities:

• Worked on designing, programming, testing, deploying, and documenting all operational and administrative applications using MS Access with Visual Basic to get things up and running for this small start - up company.
• Migrated to a Java/SQL Server 7.0.
• Converting all applications to be web-based using JSP, servlets, JavaScript, Javabeans, JDBC, and RMI with HTML/XML/XSLT.

Confidential, Plano, TX

Programmer/Analyst

Responsibilities:

• Enhanced the Inventory and Costing (ITC) system in support of Frito Lay’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.

Confidential, Irving, TX

Programmer/Analyst

Responsibilities:

• 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.

Confidential, Irving, TX

Programmer/Analyst

Responsibilities:

• 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.

Confidential, Irving, TX

Programmer/Analyst

Responsibilities:

• Developed cash flow analysis with concentration on late fees compared to legal limitations for refunds to truck and equipment customers.
• 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 Confidential Infolease, a relational database, which fed the SAS data warehouse.
• Utilized SASv81, Macro Language, ODS, and ftp scripts in Unix .

Confidential, Irving, Texas

Programmer/Analyst

Responsibilities:

• 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, Irving, TX

Programmer/Analyst

Responsibilities:

• 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 HTMLs to an intranet web site. Course work in C++.