SUMMARY:

• SAS Analytics, SAS Analytic Environment Design and Management, Project management, Relationship management, Change management, Communication, Customer service, Facilitation, Technology/Infrastructure Management, Strategic Planning, System Integration, System Support, Gap Analysis, Transition Management, Vendor Management, Team Leadership, Test Environments

TECHNICAL SKILLS:

SKILLS: Project Management Leadership, Organizational Management/Subject Matter Expertise, Excellent Writing Skills, Process Mapping, Expectation Management, SAS Analytics, Project Implementation, Project/Scope Definition & Agreement, Change Control, Data Mapping & Conversion, Systems Integration, Develop Test Cases, User Acceptance Testing, System Support.Business SkillsTrusted Liaison, Bringing Order to Chaos, Initiative, Self Starter, Planning for Results, Build Relationships, Establish Detailed Project Plans, Gap Analysis, Operational Analysis,, Process Development, Project Implementation, Facilitation, Business Process Mapping, Facilitation, Organization, Communications, Manage Execution, Problem Management/Resolution, Requirements Definition

PROFESSIONAL EXPERIENCE:

Confidential - Chicago Illinois

Separation Migration Architecture/Technical Lead

Responsibilities:

• SAS Architect/Technical Lead - Statistical Computing Environment Upgrade
• Assess existing enterprise AS environment with intent to evolve to SAS GRID
• Design and conduct SAS GRID POC for R&D organization with SAS Institute to deploy along-side existing enterprise LSF GRID
• Accommodate multiple versions of SAS(V8.2, V9.1.3, V9.2, V9.3) in the same SAS GRID environment with multiple operating system variants
• Accommodate existing legacy clinical studies and interaction(ETL, etc…) with upstream and downstream SAS consumer and sourcing applications
• Provide findings to executive level
• In concert with POC, provide consulting advisement for physical migration (lift & shift) existing SAS environment from Abbott data center to new Abbvie datacenter
• Using findings and outcomes of POC design and deploy new enterprise level Statistical Computing SAS GRID environment
• Technical lead - CDISC SDTM Federal Mandate
• SAS consulting, direction, coding reviews, project management for the SDTM(Study Data Tabulation Model) FederalMandate project, in accordance with CDISC (Clinical Data Interchange Standards Consortium) accepted protocols.
• Lead SAS Software design, and architecture

Confidential - Chicago Illinois

Application Architect

Responsibilities:

• SAS Fraud Framework
• Member of application integration team. Provide advisement for end to end process flow for claims fraud predictive model development, testing, deployment, version control, and post deployment support
• Developed process and advised on IT support team build-up, define skill set requirements
• EPMA Discovery Analytic Environment.
• Conducted comprehensive assessment of current state, provide advisement for target architecture, products, and predictive model development process
• State Farm enterprise wide predictive model development, deployment, and support assessment and future state advisement
• Megaputer Text Analytics replacement of SAS Text Miner for existing production SAS models and future development environment and integration process
• State Farm Fraud Framework transition to SAS GRID
• Comprehensive assessment of existing environment
• Advisement on architecture for deployment of 4 physical environments into one SAS GRID application, including seamless transition and Disaster Recovery planning
• Enterprise Marketing predictive model transition from DB2 to SAS
• Assessment of existing production scope
• Gap Analysis for platform, IT and business support staff
• Enterprise Wide Operational Analytics Assessment
• Research and advise on Hadoop/SAS integration, transition/deployment,
• SAS predictive model development /Hadoop use case advisement

Confidential - Northbrook Illinois

Sr. Analytic Advisor, Analytic Consulting Services

Responsibilities:

• Analyze prescription benefit data from Oracle, DB2, Teradata, and SAS to build and enhance models to for Pharmacy plan performance for existing clients and new plans for prospective clients
• Lead requirements gathering with internal client facing teams for model building, and enhancements
• Utilize forecasting techniques to estimate the impact of benefit design changes
• Assess and advise on organization for new Teradata Claims database platform
• Business and technical analysis, development, validation for numerous urgent client benefit models and to address changes in mid-contract client requirements (i.e. corporate acquisition, divestiture)
• Design and conduction technical for Business and Analytic analysts prior to on-boarding new Teradata claims and adjudication platforms
• Perform data validation for new Teradata business schema migrated from legacy DB2, and Oracle claims, client, and pharmacy data warehouses
• Working with corporate IT Data warehouse infrastructure team to perform data mapping for new Teradata schema relative to legacy warehouses

Confidential - Milwaukee Wisconsin

Sr. SAS Business Analyst

Responsibilities:

• Working remotely in Milwaukee Wealth Management office for BMO (Montreal), and Harris (Chicago, Phoenix) as well as M&I Bank in Milwaukee.
• Database platforms working with: Netezza, Teradata, SQL Server, Oracle, in addition to SAS Unix repository
• Requirements gathering for M&I Wealth Management portfolio clients missed handled by initial integration project. Assess impact, assemble client household data across BMO, Harris, and M&I platforms to determine campaign strategies for Unica campaign analysis and generation
• Design and build Client Opportunity Model for Harris and M&I platforms to determine potential incoming client cash via direct deposit to alert portfolio managers of potential up sale
• Business and technical analysis, development, validation for numerous urgent client contact analysis to address damage control for missed opportunities or potential loss of high end client business.
• Prospect Contact historical analysis to assess potential monetary gain/loss from acquiring prospect from household and individual perspective
• Trained Harris Business Management organization on understanding and utilizing Prospect Contact Performance Analysis

Confidential - Chicago Illinois

Sr. Business Analyst, Analytic Support

Responsibilities:

• Requirements gathering for Confidential t DNA project to be utilized for pre campaign analysis for immunizations/vaccinations. Confidential t DNA Data Mart is utilized in Confidential t retention, attrition, and new to therapy SAS models, and downstream Unica campaign analysis and generation, as well as Business Objects presentation for post campaign reporting
• Design and build Confidential t DNA data mart utilizing SAS and Teradata toolset. This mart will be exposed to campaign management application (Unica) for pharmacy related campaigns and short lived retail promotions
• Business and technical analysis, design, development, validate, implementation, and support for Teradata/SAS Confidential t DNA Analytic Mart.
• Build Unix(AIX) scripts to execute multistep scheduled SAS jobs in batch mode.
• Collaborate closely with the business users, Architecture team and other application teams to develop nonstandard production processes triggered from Enterprise Data Warehouse with delivery to internal business teams.
• Utilize large scale Teradata/SAS Data Warehouse environment(150 million customers, 1million scripts daily) for Ad-Hoc SAS analytics for Pharmacy and Retail organizations
• Design, develop, and validate Confidential t DNA Data Mart utilizing Teradata and Unix SAS.
• Conduct of DNA Data Mart to analytic user community, Unica Campaign Management team, and Business Objects Development team to understand and use.
• Work closely with both domestic and large off-shore analytic, marketing, and reporting teams

Confidential - Edina Minnesota

Sr. Business Systems Analyst

Responsibilities:

• Senior Business Analyst, Requirements Lead on the RMI-Financial Analysis initiative
• Gather detailed requirements via facilitation of cross functional business areas, subject matter experts, RMI leadership team, and IT groups
• Define and document RMI Financial Analysis related processes
• Assist in the preparation of other project documentation as directed by the Management in accordance with the SA&E methodology
• Analysis, definition, and execution of an interim financial analysis reporting solution used pending completion of the final automated solution
• Research and procure financial resources
• Location selection
• Align calendar of events for building construction and permitting
• Obtain franchise
• Equipment procurement
• Staffing
• Start-up and transition to stable business state

Confidential - Riverwoods, Illinois

Systems Consultant - Data Warehouse Technology

Responsibilities:

• Negotiated/Managed enterprise level SAS software and licensing agreements, including UK affiliate.
• Technical Lead/Architect - Enterprise level SAS Environment design, hardware/software upgrades (2001, 05, and 09).
• Designed/tested/implemented large scale SAS Analytical GRID architecture utilizing SAS GRID software, IBM hardware, and IBM GPFS storage management software (2008/09).
• Technical Lead - UK affiliate SAS Environment redesign, and migration to domestic data center.
• Developed SAS Analytic Warehouse Import/Export procedures to/from corporate Oracle and Teradata Warehouses load procedures
• SAS Analysis to support Corporate Marketing and RISK organizations
• Member of enterprise CRM selection team for campaign processing application. Unica was application chosen primarily due to it’s scalability
• Authored Data Quality Strategy/procedures.
• Initiated and managed user acceptance testing for new releases.
• Design and implement ETL programs and processes.
• Monitor/audit ongoing ETL activities.
• Defect discovery/reporting, and corrective procedure management.
• Assist with data model changes, and table structure integrity verification.

Confidential - Elgin, Illinois

Systems Officer - Data Warehouse Group

Responsibilities:

• Create/verify Data model for enterprise Data Warehouse utilizing SAS
• Utilize SAS to extract, validate, and cleanse warehouse candidate data
• Build monthly processes to extract and propagate warehouse tables
• Generate/execute table load scripts across multiple platforms (MVS, DB2, Oracle, UNIX)

Confidential

SAS Programmer/Analyst - Information Management Group

Responsibilities:

• Data gathering, administration, and reporting support for Credit Risk, Acquisitions, Performance Forecasting, and Account Management business units
• Generate attributes and characteristics for collection score models
• Validate all outsourced scores, and many in-house developed scores
• Design and build new files/tables for SAS Data Warehouse
• Provide monthly production support for SAS Data Warehouse
• Design, execute, and support backup and recovery procedures for SAS Data Warehouse