Systems Officer Resume Profile
4.00/5 (Submit Your Rating)
IllinoiS
Professional Summary
- Proven contributor to improve processes and bottom-line results.
- Demonstrated abilities in Information Technology, Business Intelligence, Market Research and Actuarial communities.
- Planned and managed multiple projects, program in various languages, performed statistical analysis, developed forecasting methodologies, and document processes
- Managed domestic and off-shore staff
- Excellent communication skills and a team player
Professional Experience
Project Manager/SAS Programmer
CONFIDENTIAL
- Manage a reporting process comprising of more than 60 reports that combines SAS, Excel, Excel macros and pivot tables.
- Developed and implemented process/reporting efficiencies reducing man-hours by 75 .
- Train team members on using SAS and executing processes
- Manage monthly file production
- Designed, developed and built databases used for modeling and reporting
- Developed and Manage multiple validation processes
- Document processes, programs and procedures
- Manage offshore contractors
- Developing QlikView reporting system
SAS Programmer/Systems Analyst
CONFIDENTIAL
- Developed project full cycle plans and managed within budget
- Validated data integrity/accuracy
- Improved and documented existing SAS/SQL programs
- Performed multiple SQL queries including data extractions, joins, updates and edits
- Reduced re-work 85 , saving 15,000, on Pizza Hut project
- Improved on-time deliverables efficiency from 68 to 100 for Pizza Hut project
- Trained and managed offshore staff, implementing designed programs
- Developed ad-hoc reports
SAS CONTRACTOR
Independent Contactor
- Developed and executed periodic specialized reports
- Designed new processes to enhance the efficiency of SAS jobs
- Improved existing processes to increase efficiency and improve time requirements
- Standardized SAS code
- Utilized SAS ETS Forecasting tool to develop marketing trends
- Documented Code and processes
- Wrote technical procedure manuals
- Created a cost analysis on running regressions for PC SAS vs. mainframe SAS vs. EXCEL
Programmer/Analyst
CONFIDENTIAL
- Developed and analyzed statistical SAS reports, including time series, forecasting, and trending
- Provided opinions and analysis on trends, methodologies and reliability
- Developed queries in Business Objects to replace SAS reports
PROFESSIONAL EXPERIENCE continued
Operations Manager,
CONFIDENTIAL
- Bexar is a business intelligence data warehouse system for casualty insurance industry
- Strengthened customer relations through communication
- Led team in developing and managing multiple projects
- Developed and implemented a project tracking/change-control system
- Trained teams and team leaders on data mapping, scrubbing, and warehouse installation procedures
- Developed algorithms for market trends, earned exposures, loss triangles, and various counts
- Documented policies and procedures
Systems Officer/Programmer Analyst
CONFIDENTIAL
- Provided analysis and technical expertise
- Designed and developed ad hoc SAS reportss
- Correlated data from several resources to develop liquidation tracking, trending, and research
- Managed full life cycle of complex projects to enhance business development
- Trained associates on unique SAS procedures
- Played key role in a conversion process from Legacy to Oracle
- Independent Information Technology Consultant CONFIDENTIAL
- Defined and documented existing SAS reports for implementation in ORACLE system
- Reviewed documentation with ORACLE programmers to ensure an accurate understanding of each report and how it was developed
- Provided analytical and technical expertise to management and SAS community
Database Consultant
CONFIDENTIAL
- Built an Excel customer database
- Trained the user on how to utilize different tools to access the database
- Provided instruction on the update process
Assistant Actuary II
CONFIDENTIAL
- Developed market research reports for pricing strategies
- Presented evaluations to the marketing team
- Provided projections and analysis
- Developed and implemented a process for reporting experience to State of Pennsylvania Department of Insurance, including training several associates on method
- Designed and developed supporting report structures
- Trained colleagues in programming in SAS and mainframe utilization i.e. TSO, and ISPF
- Served as liaison to external venders, directed testing and implementation of financial software
- Passed Actuarial Exams 1, 2, 3a, 3c
Actuarial Examiner
CONFIDENTIAL
- Reviewed and documented reinsurance treaties, policy forms, and reserving methodologies
- Tested adequacy of life reserves and determined if reserving methods met with state regulations
Computer Experience
- Programming experience in SAS, PC SAS, SAS Enterprise Guide, SAS ETS, SAS ODS, SQL Server, SQL, SAS AF, EASYTRIEVE, Crystal Reports, TSO, JCL, ISPF, MVS/XE, APL, MINITAB, VBA, UNIX, SQL, PLSQL, QlikView
- Proficient in Oracle, Lotus Notes, Business Objects, and Microsoft Office suite. Visio
- More than 200 hours of programming training on systems such as BASE SAS, SAS SQL, SAS AF, SAS Macros, Advanced Programming, CENTURA, QlikView, UNIX, MARS System, C, ASP.NET2, Oracle and Diversification Facilitation.