SUMMARY:

• Analytical consultant, data analyst, with over 15 years of experience in developing models and solutions for the public and private sectors of the United States and Canada, CFA candidate

TECHNICAL SKILLS:

Analysis: Provided data analysis, and statistical consulting in multiple industries, worked with financial, logistical, demographic, healthcare, insurance, billing, and compensation data

Software Skills: PL/SQL, SAS, SAS - DIS, SAS-EG, SPSS, R, Tableau, MS Excel (VBA), Power BI, MicroStrategy, QlikView, Teradata, Automation Anywhere, Python (intermediate)

Reporting & Presentation: Presented data and analytical concepts to all levels of organizations in a variety of contexts and across different disciplines, experienced in building effective visualization, executive reports, and communicating with/receiving guidance from subject matter experts

Project Management: Owned and managed projects from concept inception and scoping to budgeting, change request, presentation, requirement gathering, and deployment using sequential/agile methodology; experienced in guiding analytical teams in implementing analytical solutions, experienced with geographically dispersed team members, will obtain SCRUM and PMP s in the near future

Big Data ( and aspirations): trained in decision analysis and machine learning, used factor analysis and clustering at various projects, active at IBM Big Data University, acquired advanced online for Hadoop, MongoDB, deep learning

Business Analysis: Experienced in gathering analytical/data/BI requirements, meeting facilitation, collaborative conception of analytical projects, and effective communication of insights and products

PROFESSIONAL EXPERIENCE:

Analytical Consultant

Confidential

Responsibilities:

• Developed solution proposals for enhanced data visualizations
• Managed Marriott-Starwood data integration and loyalty analytics reporting

Data Scientist

Confidential

Responsibilities:

• Developed, managed and catalogued multiple ETL processes using SAS DIS, Teradata
• Led exploration and data mining of customer/billing data using rapid predictive modeler, regression analysis of and survival analysis in SAS EG
• Developed automation code for several multi-app processes involving SAP, SAP-BW and Teradata
• Developed code to parse out info from multiple unstructured formats

Data Consultant

Confidential

Responsibilities:

• Project mang: Created a systemic approach to streamlining, extraction, cleaning, translation, and conversion of unstructured data related to single-family and multifamily housing finance data; collected the municipal data on housing development, compiled the industry data on new developments, publicly available mortgage data, and costs estimates from lead engineers
• Explored mechanical and electrical products sales, converted multiple applications into a user-friendly database, and built decision support system to decrease after sale load
• Developed technical documentation for existing procedures
• Analyzed single-family and multi-family residents credit to assess the risk of financing for energy saving projects through clustering analysis

Data Analyst

Confidential

Responsibilities:

• Conducted cluster analysis on pediatric-youth- mental Confidential ts using a host of diagnostics and demographic data in order to identify the super-users
• Built Business Intelligence pediatric healthcare monitoring reports using MicroStrategy, SQL: recognized the issues (decisions at hand) through communication with an expert panel, identified the available data within the massive CIHI data warehouse, built dashboards using MicroStrategy and pivot tables to facilitate data mining by non-experts
• Identified data sources, ran quality control checks, and designed discriminant analysis to compare pediatric health outcomes in different Canadian provinces using SAS and SQL, presented multiple QlikView reports

Data Analyst

Confidential

Responsibilities:

• Analyzed call volumes and distribution, bottleneck points in service processes, mined data about clients, the call loads, and satisfaction/recidivism rates using R, SPSS
• Analyzed the digital adoption of help/DIY pages, traffic analytics, stress factors; formulated strategies to optimize web use and enhance client experience using SAS

Analytical Consultant

Confidential

Responsibilities:

• Designed BI reports and dashboard for sales and advertisement department of a Dubai-based media company using Tableau, presented to executives
• Reviewed alternative Business Intelligence products and supervised a new data/BI department for a Dubai-based media company, aimed at increasing viewership and ad-revenue
• Coached and led a 12-member multi-disciplinary team on re-engineering analytical processes
• Project mang: Setting up data/modeling framework, reviewing technical documentation, and providing program updates to the business line

Data Scientist

Confidential

Responsibilities:

• Designed and maintained ad-hoc Business Intelligence solutions and Key Performance Indicators (KPI) to increase utilization of shared resources among medical staff across several sites using PL/SQL & MS Access & Tableau: KPI, defined by the industry experts, were built after extraction of administrative data (PL-SQL)/ACCESS, data then were uploaded to Tableau where dashboards were constructed
• Designed concepts and deployed multiple benchmarking analyses including access time
• Developed multiple databases to organize large unstructured administrative and medical conditions data and connected them by building a metadata layer
• Built statistical predictive logistic/OLS R models for utilization loads and created user’s guide and developer’s guide as well as monitoring report for the IT implementation
• Created reports and visualizations to explain the accuracy and specificity of the model results to the leadership team and subject matter experts using SPSS and Minitab
• Built Simulation tool using MS Excel pivot tables and MS Visual Basics macros to analyze the service use across multiple departments
• Developed various Demand Management performance measurements by consulting subject matter experts globally and across Canada in areas of medical safety and efficiency
• Led a qualitative analysis of the risk factors of births at home via interviews with neonatal nurses, midwives

Data Consultant

Confidential

Responsibilities:

• Built simulation tools and statistical predictive models to assess the impact of federal cost allocations on local economies and budgetary demands using SPSS
• Provided various statistical consulting from survey sample size calculations to identification, feasibility and validity of simulation studies of energy markets using VB
• Built SharePoint pages necessary to enable cross-department insight sharing; monitored the adaptation of insights by designing surveys and using network traffic analytics

Data and Policy Analyst

Confidential

Responsibilities:

• Provided economic and policy analysis directly to policymakers on a wide range of issues relating to public health, employment and tax forecasts including:
• Data mining the low-income utilization of federal Medicare, using SQL and SPSS
• The impact of state spending on disability programs on employment
• Simulating the budgetary and economic impacts of different designs of tax incentives
• Led a qualitative analysis of motivations behind family decisions and number of children in low income families via field interviews, surveys and literature review