Sas Developer Resume Profile
5.00/5 (Submit Your Rating)
FL
PROFESSIONAL SUMMARY:
- 19 years of SAS and Data Modeling experience.
- Six Sigma yellow belt.
- SAS V8 certified.
- Have earned the FLMI and CLU designations.
PROFESSIONAL EXPERIENCE:
Confidential
Sr Data Modeler/SAS Developer
- Use SAS SQL 9.3 for testing and ad hoc reporting.
- Read data from an Oracle data warehouse.
- Design and build repeatable reporting routines using Base SAS, Enterprise Guide, and Statistical and Graphing procedures.
- Use Base SAS Procedures ODS Chart, Map and FCMP procedures hyperlinking and bookmarking to produce reports.
- Create complex queries with large amount of unformatted data.
- Analyze lens wear production data for patterns.
- Responsible for creation of complex data models.
- Provide advice and ideas on how to create new reporting venues.
- Conduct research and recommend solutions.
- Identify opportunities for reporting improvement.
Confidential
Sr Data Modeler/SAS Developer
- Using SAS SQL 9.3, 9.1, 8.0 test and report using SQL for DB2 and Oracle data warehouses.
- Oracle and DB2 database claims data reporting.
- Design, build and maintain ACCESS databases.
- Create ACCESS SQL and EXCEL VBA coding.
- Convert CMS excel data into DB2 compliant tables.
- Create research and analysis documents for the Legal department.
- Create Desktop Scripts to execute SAS batch jobs.
- SME for Hospital Contract Negotiators.
- Analyze historical claims data for patterns.
- Create complex data models for claims.
- Design, Implement, and maintain department website.
- Identify and champion operations processes needing repair and improvement.
- Provide advice and ideas to Programming Consultants.
- Conduct research, recommend solutions and draft non-routine documents and reports.
- Identify opportunities for improvement and lead initiatives to implement improvements.
- Create Programs and Simulations to support all Facility Reimbursement programs.
- Extensive use of SAS, ACCESS, UNIX, EXCEL, VBA, WORD, POWERPOINT, WINDOWS, DB2, ORACLE, IBM DATA STUDION and SQL.
Confidential
Sr COBOL Developer
- Convert mortgage data from foreign systems into Alltel systems.
- Merge the data into existing clients mortgage servicing files using COBOL, Easytrieve, Roscoe, JCL, REXX, TSO, Syncsort, Quickjob, Microfocus Cobol, and other utilities.
Confidential
Sr SAS Developer
- Maintain batch COBOL programs for MEDICARE part B processing.
- Create SAS programs measuring the cost savings of processing changes.
- Lead analyst to repair test region errors.
Confidential
Sr SAS Developer
- Lead SAS report programmer for multiple MIS, DB2, Clipper, COBOL small group insurance management systems.
- Analyzed business and regulatory requirements to develop SAS SQL programs to extract, validate, and calculate required financial, regulatory, and corporate output.
- Lead analyst for batch support.
- Provided JCL, CA-7 and Jobtrac support/programming for multiple systems.
- Streamlined end of day processing and improved efficiency and quality.
- Team Leader, Supervised 34 underwriters.
- Responsible for setting and achieving production goals, quality assurance, authoring performance appraisals, recommending scope and salary increases.
- Underwriter, Approved policies of up to 1,000,000 for small employer and individual health insurance.