SUMMARY:
Laurie Carranza is a degreed professional with sixteen years of experience using SAS tools. As a programmer, she can analyze processes and data to develop reports to satisfy client reporting needs. Laurie has experience developing ad hoc reports and databases on both the mainframe and server. She has excellent communication skills and a strong ability to multi-task. She has managed a programming staff.

SKILLS:
SAS (Enterprise Guide, Web Report Studio, Management Console, Information Maps, BASE SAS), SQL, JCL, Argos, VSAM, COBOL, UNIX Shell, TSO, CICS, SAS-ITSV, PeopleSoft, Microsoft Office 2007 (Outlook, Excel, Word), Access, Mantis, DB2, ROSCOE, DADS, REXX, Windows XP, S1032, DBASE II, FORTRAN, RPG II

EDUCATION:
A.A.S. Computer Programming

SUMMARY OF EMPLOYMENT:

03/2011- Present Confidential - San Antonio, TX
Senior Application Programmer Analyst
Generate, test and debug ad hoc SAS programs and SAS Macros for the Institutional Research and Finance departments using SAS Enterprise Guide, Base SAS and SQL. Extract student data to generate Argos/Excel reports and import them into SAS Enterprise Guide and create SQL and SAS code to manipulate data and results for third-party vendors. Use Bannerdata to validate Student and Finance computed results. Provide technical assistance and logical methodologies to programming and non-technical staff. Meet with various levels of users to plan requirements and timelines for projects. Support District and college-level personnel on reporting and SAS server administration issues. Run ad hoc and timely reports.

02/08/2010- 08/30/2010 Confidential - San Antonio, TX
SAS Programmer
Generate, test and debug SAS programs and SAS Macros for the Finance and Acquisitions department using SAS Enterprise Guide, Web Report Studio, Base SAS and SQL against RDSMS files.Use Banner/Titan data to validate computed results. Provide technical assistance and logical methodologies non-technical staff. Meet with various levels of users to plan requirements and timelines for projects. Support college-level personnel on reporting issues. Communicate with third-party vendors on application and system issues. Run timely and ad hoc reports. Prepare reports to run for five colleges. Improve documentation for team programs and processes. Provide SAS Server Administrator support to District IT personnel. Provide detailed documentation to users to educate them on their reporting processes.

05/2006- 01/08/2010 Confidential - San Antonio, TX
Lead Senior Application Programmer Analyst
Generate, test and debug SAS programs and SAS Macros for the Finance and Acquisitions department using SAS Enterprise Guide, Web Report Studio, Base SAS and SQL. Plan and coordinate projects. Use Banner/Titan data to validate computed results. Provide technical assistance and logical methodologies to programming and non-technical staff. Distribute and prioritize the report-generation workload and other duties to the programming staff. Knowledge of relational database systems (RDBMS) and structures.Reviews designs for compliance/feasibility within the database system. Plan requirements and timelines for projects.Coordinate and deliver finance data to the Integrated Postsecondary Education Data System (IPEDS) and student data to the San Antonio Education Partnership. Write the Strategic and Operational Plan and the budget for the Reporting Team. Evaluate programming staff. Run timely and ad hoc reports. Improve documentation for team programs and processes. Provide detailed documentation to users to educate them on their reporting processes. Set up logon ids,permissions and data/file security for new SAS users via SAS Management Console. Coordinate upgrades of SAS servers and train server concepts to new server administrator. Monitor and purge system logs for maximum space utilization. Communicate with SAS Technical Team to resolve major system issues. Enhance variable and report level security via stored processes or SAS Management Console. Work weekends as needed.

04/2005- 04/2006 Confidential - San Antonio, TX
HRMS Analyst
Audited the HRMS database for corrupt and missing information using Access, Excel and Peoplesoft..Assured that data entered complied with all state Human Resources laws in the United States and Canada. Setup logon ids and determine security levels for PeopleSoft users. Served as the liaison for branched Human Resources personnel to maintain data for more than 5,000 employees.Ran timely and ad hoc reports.Communicated with the Social Security Administration and internal customers to assure data integrity. Setup course codes, instructor tables, and pay calendars.

06/04-03/05 Confidential - Vacaville, CA
Assistant Manager
Collected and reported money on a bi-weekly basis from telephony equipment, vending machines, and children's entertainment rides from shopping malls in Northern California. Assured staff adhered to company dress codes, policies, schedules and customer-service expectations. Confirmed entertainment rides/equipment were safe according to O.S.H.A. standards. Deposit money in business accounts.

09/02-06/04 Confidential) - Tumwater, WA
Customer Service Representative
Received high volume of calls from wireless customers.Answered questions according to client/company expectations.Accurately and reliably completed electronic forms to order phones.Participated in training to maintain a high of product knowledge and presentation skills. Troubleshoot cellular hardware functions. Take equipment orders and confidential payment information with DOS-based and Window systems. Worked with the Information Technology liaison to rewire PCs, install and re-image system software and screens.

01/02-04/02 Confidential - Irving, TX
SAS Programmer
Generated SAS and SAS Macros to develop selection strategies and validated other code to market cardholders for direct mail delivery. Executed campaigns with strict deadlines. Confirmed execution phases were in compliance with Citi-sanctioned audit procedures. Complied with federal and corporate information security regulations.Used business and technical knowledge to recommend process flow improvements and strategies to comply with business requirements and security guidelines.Confirmed cardholder information with TSO tools. Update customer service screens for customer service representatives.

05/98-09/01 Confidential - San Antonio, TX
I/T Systems Programmer

Developed, tested, coded, and debugged SAS, SAS Macros and JCL programs for the charge back applications that included the CICS, TSO, batch, DASD, tape, and IMS products. Produced and maintained interface files and submit them to the Senior Financial Office to create a usage bill for internal customers. Used the CA-MICS and in-house software to retrieve charge back SMF data.Created ad hoc programs that reported specific megabyte and/or CPU time usage.Also created ad hoc reports for the Capacity Planning team.Transferred programs and data to other environments via NDM transfer utility. Converted charge back programs from reading CA-MICS to SASI/T Service Vision. On-call duties were required.

02/90-04/98 Confidential - Austin, TX
Lead Programmer Analyst
Generated, tested and debugged SAS and SAS Macros, Mantis, and JCL programs for the Project Management System, Employee Leave System, Hearings Tracking System, Correspondence Tracking System and other Mantis applications.Supported all tax and financial systems. Provided Natural, SQL, and DB2 support for the Employee Training System. Generated SAS reports and RPF menus.Planned and coordinated programming projects.Provided technical assistance to programming staff.Served as a project manager for personnel and financial systems.Supported the Human Resources Information System (HRIS) and the Uniformed Statewide Payroll System (USPS).Provided VSAM primary support.Generated certified open-record reports for all state taxes.Attained the highest data security access in agency for last two years.On-call duties.

01/87-02/90 Confidential, San Antonio - S.A, TX
Programmer Analyst
Assisted in defining and analyzing problems.Maintained HRIS, payroll, personnel and scientific applications using COBOL.Developed new systems.Documented programs.Assisted personnel in analyzing and defining problems for computer solutions, methods of approach, selection or modifications of programs and in correction program errors.Coded S1032 (RDBMS) algorithms for clinical trials.Converted update and batch programs from DEC-20 COBOL to VAX COBOL.