We provide IT Staff Augmentation Services!

Analytics Manager Resume

Austin, TX

SUMMARY:

  • Confidential has led over 20 enterprise - level projects focused on public- and private-sector data sources.
  • As an experienced team manager, his approach maximizes his teams’ business insights and operational consistency.
  • Experienced Database Developer and Statistical Analyst
  • R, Microsoft SQL Server
  • Python (pandas, numpy, scipy, scikit-learn), Oracle PL/SQL, Teradata, MySQL, Business Objects, SQL Server Integration Services (SSIS)
  • Maple, Mathematica, SPSS, MATLAB Creative Designer that Excels in Flexible Solutions and Persuasive Client Presentations.
  • Creation of complex deliverables including visualizations, requirements traceability matrices, database design and documentation.
  • Establishing the reliability of the data, applying the relevant business rules and relentlessly improving data quality
  • Strong experience applying machine learning algorithms within the Enterprise Data Warehouse (EDW) environment, including Gradient Boosted Models, Mixture Models (Expectation/Maximization), Regularization Paths, Support Vector Machines, Random Forests, etc.
  • Knowledge Worker Equally Comfortable Dealing with Technological or Traditional Challenges
  • Accustomed to working within extreme IT security constraints and demanding customer relationships
  • Rich verbal and written communication skills to break down complex topics and efficiently summarize issues
  • Flexible Data Science skill-set that incorporates Database Administration (DBA), software development and statistical analysis.

WORK HISTORY:

Analytics Manager

Confidential, Austin, TX

Responsibilities:

  • Created an association rules procedure (a priori algorithm) to mine large-scale survey of customer perceptions. Of 400 questions for 12,000 respondents, procedure detected 5 response combinations that motivated customer purchasing decisions in ~80% of cases. Findings from the study supported annual strategic and creative media planning
  • Created a framework to select an optimal basket of test markets for a digital pilot program. The process evaluated 100+ markets’ revenue growth and competitive conditions to Confidential across 60 measures of similarity.
  • The selection formula maximized the statistical independence of the markets while minimizing their variance to the national totals.
  • Created an ETL process to integrate data sources representing 20 distinct media channels (e.g. National Broadcast, Cable, Syndication, etc.).

Senior Statistical Analyst

Confidential, Austin, TX

Responsibilities:

  • Led data integration and credit model development for online lender using MySQL, R and SAS.
  • Project included creating an Extract/Transform/Load (ETL) process to load 1 terabyte of files from 5 credit bureau sources.
  • The final implementation partitioned the data into 5 sub-populations, applied a custom L1 regularization path algorithm for each group, and produced granular diagnostic output across the entire path.
  • Developed User Activity DataMart. SSIS package automated activity logs ETL, generated a synthetic user key to track actions across source data and structured data for time series analysis.

Director, Data Science

Confidential, Hartford, CT

Responsibilities:

  • Implementation of Stochastic Boosting (ADA.M1 Algorithm) to optimize flag-based auditing procedure applying over 30 filters.
  • Boosted tree-based ensemble reduced time to output by 25 hours; a 50% increase in performance.
  • Development of ensemble learning techniques, including Hierarchical Mixtures of Experts (HME).
  • Performed all Database Administration tasks for 3 terabyte pharmacy claims server.
  • Responsibilities included all Extract/Transform/Load (ETL), development (T-SQL), maintenance (SSIS), ad hoc reporting, and tuning.
  • Design and implementation of case management data model and operational reporting solution, including ETL into Oracle DataMart.
  • Data model successfully integrated client’s operational activity data with case history information and was based on a source of 230 dimensional tables.

Applied Analytics Analyst

Confidential

Responsibilities:

  • Led migration of mainframe SAS/DB2 Encounter Reporting System (ERS) to SAS/Oracle EDW solution.
  • Responsibilities included development of views, testing, SQL Development Standards Guide and Extract/Transform/Load (ETL) documentation.
  • Delivered SAS OLAP cube to automate data profiling review and analysis.
  • Led migration of SAS Hospital Administrative Profile System to SAS/Teradata EDW solution.
  • Completed this project without access to the original data source.

Senior Health Data Analyst

Confidential, Houston, TX

Responsibilities:

  • Re-engineered specialty benefits dashboard review process for national health plan.
  • Objectives included replacing manual QA process with Multivariate Analysis of Variance (MANOVA)-based stored procedures.
  • Led statistical analysis of specialty benefits utilization including custom metrics for radiation therapy, general utilization and provider quality.
  • Using T-SQL and SQL Server Reporting Services (SSRS), created Ad Hoc and Scheduled Reports.

Health Data Analyst

Confidential, Austin, TX

Responsibilities:

  • Developed T-SQL scripts to execute ad hoc and automated reporting requests from the company’s health data warehouse.
  • Negotiated business requirements, functional design and user acceptance testing to enhance operations of government programs, claims processing and enrollment departments.
  • Using SQL Server Reporting Services (SSRS) and Microsoft Visual Studio, built self-service tools for business stakeholders to design and export custom reports.
  • Supplied Provider Quality Reporting Initiatives (PQRI) and other analyses using R, Minitab and SAS.
  • Led a cross-functional team with Billing Specialist, Claims Analyst and Medicare Business Analysts to complete major Medicare compliance report. Work product included negotiating criteria for 18 utilization categories; all SQL development; and data analysis of utilization by region.

Business Analyst

Confidential, Austin, TX

Responsibilities:

  • Subject Matter Expert (SME) for the HIPAA Privacy Rule, Security Rule and Transaction Code Sets Standard. Trained representatives of Medicaid fiscal agent contractor under state-mandated Corrective Action Plan (CAP). focused on the protection of electronic Protected Health Information (e-PHI) and employee-monitoring strategies.
  • Prepared financial analyses for changes to medical billing procedures and state funding regulations, including the Confidential and National Provider Identifier ( Confidential ) projects. Identified key Medicaid providers most likely to experience billing difficulties and helped coordinate outreach efforts.
  • Leveraged legal and data analysis skills to help implement cost-saving initiative with 3rd party contractor. Initiative involved identifying complex criteria to produce 80,000 Medicaid clients having annual claims in excess of $1.5b. Ran extensive queries on Texas Medicaid data warehouse and served as the data SME for the project.

Hire Now