SUMMARY:

• Highly motivated SAS professional with 25+ years of hands - on experience and specialization in SAS (Business Intelligence, Solutions), architecture and installation.Solid working knowledge of architecture, lifecycle and processes.
• Ability to identify and resolve inefficient processes and procedures.
• Specialize in evaluating client needs and delivering the appropriate technology solutions.
• Currently seeking a position which will effectively utilize all skills, certifications and areas of expertise listed below:
• I started my SAS career by creating and distributing KPI'S based on Northwestern Memorial Hospital's patient hospitalizations data as a Confidential .
• After that I worked for Confidential doing studies on mortality and mobility, demographics and hospital.
• Architected the SAS multi-tiered platform used for SAS Financial management and Visual Analytics solution at Wounded Warrior Project.
• Designed data warehouse for Wounded Warrior Project.
• Created best practices, standards for implementing and using SAS solutions
• Experienced in taking claims data and cross referencing it with financial data, and providing ROI at a plan level for Confidential .
• QA ETL processes used in Confidential of North Carolina and Confidential / Confidential new production data warehouse.
• Designed and wrote dynamic Medicare reporting modules used at the Confidential .
• Created code to identify physicians that are out of compliance based on claims data.
• Validated the functionality and accuracy of tools for the newly installed SAS/EBI (Enterprise Business Intelligence Solution).
• Achieved SAS Alliance Partner of the year award 1984 and co-wrote the base SAS Certification Exam
• Mission-driven Change Agent, committed to producing “out of the box” solutions, exceeding all client expectations and service guidelines, communicating the vision persuasively and effectively.
• Recognized as a highly tenacious Information Technology Leader who engages progressive initiatives in government, the legislative environment, and the business community, resulting in maximum viability and performance.
• Conceptualized and established processes, systems, and reporting initiatives to track metrics that deliver scalability and reliability across risk management, security, policy development, enterprise development, strategic planning and implementation.
• Lead internal and external staff for IT, engineering, testing/QA and IT development groups in multiple locations.
• Partnered with senior executive leadership to plan and implement long range policy.
• Innovative leader and negotiator, with a successful track record of communicating goals, mitigating risks, resolving QA issues and successfully navigating tactical challenges organization-wide.
• Although only listed under SAS Institute I have been the SAS Admin for several clients under other duties as required.
• I have a variety of other skills and training in SAS Solutions strictly to have the ability to fill in as needed.

PRIMARY SKILLS:

• SAS Versions 5.18 -9.4
• RDBMS: Oracle, Teradata, DB2, Netezza
• SAS Strategic Performance
• SAS Forecast Studio
• SAS Management Console (Admin)
• SAS Information Delivery Portal (IDP)
• SAS Enterprise Guide
• SAS Data Integration Studio
• SAS Web Report Studio
• SAS Information Map Studio
• SaS Environment Manager
• ActiveBatch
• Quality Assurance
• Business Intelligence
• Data Warehousing
• Enterprise Architecture
• ETL
• Software Optimization
• Enterprise Architecture
• Requirement Analysis
• Business Analytics
• Data Management
• Change Management
• SDLC
• Analytics
• Unix\cubes
• Requirements Gathering
• Visio
• Predictive Modeling
• Databases
• System Analysis
• Data Mining
• Quality Assurance
• Software Development
• Solution Architecture
• SAS 9.1 Enterprise Business Intelligence Solution. (SAS BI/SAS EBI,SMC,FM,FORCAST STUDIO )
• SAS Component: Base, Macros, SQL, OLAP, IMS, WRS, EG,IDP,SPDS, SPDE

TECHNICAL SKILLS:

JCL, Extra, Endeavor, Brio, BI/Query, Toad, PVCS, Microsoft OfficeIn training for Hadoop, Python and R.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Sas Software consultant

Responsibilities:

• reverse engineer the existing SAS environment design Enterprise Data Warehouse write & Implement Architectural Standards assess both existing and new Applications to Design a Transformative Solution work with business units to assess capability, alignment, functionality and requirements
• Create metadata driven processes
• Validate the implementation of the SAS Business Intelligence Platform.
• Create test cases to validate functionality of EBI Tools
• Troubleshoot and resolve configuration issues with SAS EBI configuration.
• Provide optimization recommendation for users and production processes.
• Provided instruction on how to use the following tools
• Enterprise Guide, Info Maps, OLAP Cube, Data Integration, Web Reports, Management Console, BI Portal, Financial Management, Visual Analytics
• Created training instructions for uses of SAS BI tools.

Confidential

Sr. Sas Software consultant

Responsibilities:

• Validate the implementation of the SAS Business Intelligence Platform.
• Create test cases to validate functionality of EBI Tools
• Execute and document results of test cases
• Troubleshoot and resolve configuration issues with SAS EBI configuration.
• Provide optimization recommendation for users and production processes.
• Optimize Oracle extracts, tables and views.
• Provided instruction on how to use the following tools
• Enterprise Guide, Info Maps, OLAP Cube Data Integration, Web Report Studio, Management Console, BI Portal, Forecast Studio
• Created training instructions for uses of all BI tools.

Confidential, Minneapolis, MN

Sr. Sas Software consultant

Responsibilities:

• Supports strategic initiatives across the company by enhancing and evolving the BI advanced analytics capability and ensuring business goals are met
• Designs experiments to learn new insights and correlations to advance operational efficiencies or reveal revenue opportunities
• Manages SAS applications, servers, users, and EBI platform administration, including implementation, configuration, upgrade, migration, maintenance, coordination, problem resolution, testing, usage and performance monitoring and the design/development of system infrastructure
• Conducts one on one sessions with power users (Site Owners), gathers requirements, designs, develops and deploys multiple workflow solutions across the organization
• Coordinates planning phase, implementation, deployment, security and network with IT team specialists

Confidential, Northbrook, IL

Sr. SAS Developer

Responsibilities:

• Rewrote legacy SAS code for retrieval and transformation of claims data from Terada
• Analyzed new requirements and revised code to conform to macro driven architecture.
• Developed new macros for standardization.

Confidential, Durham, NC

SAS developer

Responsibilities:

• Optimized the SAS code used for extracting Medicare and Medicaid Claims and provider data.
• Performed QA of SAS code
• Provided SAS best practices
• Identified and document possible failures in current processes.

Confidential, Riverwoods, IL

SAs Developer

Responsibilities:

• Optimized the SAS code used for calculating refunds and exceptions to payment matching reports.
• Developed ETL code using SAS EG to create SAS Stored Processes, Macros and Programs
• Set up Reporting Standards for the Marketing Risk Control department.
• Identified and documented possible failures in current processes.
• Designed an overall process to capture data transfers from one system to another.

Confidential, Pittsburg, PA

SAs Developer

Responsibilities:

• Objective is to create graphical interface to report sales information and health care reporting.
• Developed ETL code using SAS EG to create SAS Stored Processes, Macros and Programs
• Registered SAS tables using SAS Management Console.
• Created OLAP cubes in SAS OLAP Cube Studio to be used with Information Map Studio used in creating reports.
• Used SAS Web Reports Studio to create reports with filters, drill downs and Confidential prompts.
• Used Information Delivery Portal to surface list reports and drill down reports created in SAS BI Suite.
• Used Enterprise Guide to create Stored Process.

Confidential

SAs Developer

Responsibilities:

• Objective is to create an interactive Medicare/Medicaid Claims reporting system for the Confidential .
• Developed ETL code using SAS DI Studio to create SAS tables and views.
• Registered Oracle tables and views using SAS Management Console and SAS DI Studio jobs.
• Migrated SAS Enterprise Guide code and SAS DI Studio code between DEV, UAT and Production.
• Created OLAP cubes in SAS OLAP Cube Studio to be used with Information Map Studio used in creating reports.
• Used SAS Web Reports Studio to create reports with filters, drill downs and Confidential prompts.
• Used Information Delivery Portal to surface list reports and drill down reports created in SAS BI Suite

Confidential

SAs Developer

Responsibilities:

• Created SAS programs that report on Beer polls
• Created SAS programs for production reporting
• Updated and maintained production SAS programs
• Decoded older SAS program for documentation and correction.
• Documented un-documented processes
• Performed trouble shooting and researched errors in development and production
• Performed data Integration to transform data

Confidential

SAs BI Reporting

Responsibilities:

• Created ETL Process to extract Medical Patient and Provider Data
• Created Prototype ETL and Information map process for production
• Created Information Maps with custom data Items
• Created WRS reports for testing of provider data.
• Created custom reports using Information Maps and Information Delivery Portal.

Confidential

SAs Web Report Studio Consultant

Responsibilities:

• Evaluated requirements and recommended design for interactive reporting mart with architecture team.
• Created ABM data mart SAS Data Integration Studio
• Created WRS reports and OLAP cubes using SAS 9.2 EBI software.
• Created custom reports using Information Maps and Information Delivery Portal.
• Created Static reports, Excel reports and Stored Processes.
• Applied custom security model as required by client utilizing SAS Management Console.
• Used Data Integration Studio for sourcing data

Confidential

SAs Data Modeler

Responsibilities:

• Evaluated requirements and recommended design for interactive reporting mart with architecture team.
• Created customer service data mart using data stage and Oracle.
• Created WRS reports and OLAP cubes for SAS 9.13 EBI software.
• Created custom reports using Information Maps, ODS and Information Delivery Portal.
• Created Static reports, Excel reports and Stored Processes.
• Created migration path/process to moved custom code and metadata from SAS 9.13 to SAS 9.2.
• Created library of macros that could be shared among team members.
• Connected SAS enterprise guide to be server based instead of pc based.
• Automated the process to connect commonly used libraries to enterprise guide.
• Applied custom security model as required by client utilizing SAS Management Console.