SUMMARY

• Business & Data Analysis, with Attention to Detail, Providing Thorough, Deep Analysis
• Experience in building dashboard reports by using BI tools (Spotfire, PowerBI, Tableau)
• Expert at MS Excel with VBA macros, pivot tables, power pivot, charts and graphs
• Effective Written and Oral Communicator • Advanced SAS Programmer
• Highly Motivated, Always Professional, Easily Interacts with Senior Management
• Effortlessly Works Side by Side with IT Technical Staff

TECHNICAL SKILLS

• SAS Enterprise Guide, SAS Studio, SAS BASE, SAS MACROS, SQL, Toad, Oracle, Excel
• Excel Pivot Tables, Excel Macros (VBA), Word, Powerpoint, Microsoft Access, PowerBI
• Spotfire, Tableau, Visio, Hadoop, HIVE, Python, LINUX Scripting, JIRA

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Corporate Vice President - Data Solutions

Responsibilities:

• Ability to liaise with business partners and easily translate their KPI reporting needs into actionable data delivery using well developed business and exceptional technical skills.
• Authored modular SAS Macros from team formulated business logic for official active customer inflow/outflow measurements used by senior management to make critical business decisions.
• Produced dozens of additional customer inflow/outflow Excel/Powerpoint reports and charts for Retail Life Quarterly Business and Financial Reporting which enabled senior management to develop appropriate benchmarks and future strategy for continued customer growth.
• Translated 20+ SAS Macros into business requirements documents for same in-force customer inflow/outflow rules to facilitate a self-service dashboard enabling company-wide analysis in order to track customer growth against benchmarks.
• Regular use of Spotfire and other visual analytic tools to deliver targeted insights such as Sales, Attrition Rates and Customer Demographics to business users who do not have the skills or desire to ingest and manipulate vast amounts of complex data.
• Expanded and streamlined (by over 50%) 1st year Whole Life attrition reports and ancillary databases using SAS Software and MS Access enabling Agency staff to target underperforming Agents.
• Implemented Financial "Enhanced Sales Reports" by ingesting Whole Life sales transaction data, summarizing multiple metrics for all 5 Life sub-products into Excel reports adding 15 regrouped data dimensions for those sales metrics, uncovering deficiencies in product coverage or product cost.
• Provided hundreds of ad-hoc analytic reports to key business partners with an average delivery time or a week or less enabling quicker decision making on product, pricing, underwriting and distribution in order to adjust unexpected/unattained results.
• Consistently and expediently delivered cleansed and formatted data extracts to various business departments for SME analytical deep dives enabling enhancements to Life Insurance product features and costs to help the business set better pricing.
• Continuously shared programming, legacy data and insurance knowledge to dozens of colleagues through a shared code library and personally-led data knowledge transfer sessions, ultimately saving the company many hours of re-programming and data re-discovery, facilitating increased productivity.

Confidential, New York, NY

Director of Life Research and Analysis

Responsibilities:

• Maintained, scheduled and validated production SAS programs for profit, risk and propensity scoring of active customer base which triggered appropriate scripts used by service center reps.
• Optimized long running Oracle queries to reduce propensity model scoring run times by 80%.
• Saved Financial Management Customer Relations Management Team countless hours by extracting and transforming Corporate Data Warehouse - atomic Oracle data into more defined dimensional data for statistical model development for Profitability, Propensity to buy and Risk modeling by actuaries.
• Processed dozens of mainframe flat files and produced integrated and cleansed SAS datasets for team statisticians to build attrition and cross-sell models.
• Worked with various New York Life departments to extract and provide data, perform ad-hoc analysis and/or produce reports in various formats including, but not limited to, Excel or Powerpoint for business partner ease of use driving decision making around middle market sales, cross-selling opportunities, direct marketing, attrition rates and pricing tests.
• Daily use of SAS Software, on multiple platforms, for data manipulation, analytical processing and report generation aiding all levels of management and non-management partners.
• Coordinated data enhancements with 3rd party demographic data vendors Acxiom, Donnelley & Claritas to enrich statistician data sets for improved propensity to buy and propensity to lapse predictive models.
• Managed UNIX server space requirements incessantly to ensure processing continued uninterrupted.
• Reduced space usage server interruptions to hours (from days) by creating a one click tracking report using an Excel VBA Macro which quickly allowed our team to identify high space usage users and their folder locations for immediate remediation.