Ellen Cain Email and Phone Number

Workday Reporting and Dasboarding Team Lead

undertakes data gathering, statistical calculations, and econometrics work serves as data analyst for the IMF's Human Resource systems and processes transformation project

Served as project analyst to multiple project teamsDeveloped data solutions and assisted in testing/debugging of SQL scripts and SAS Programs/Macros to ensure data integrityPerformed SAS/SQL/analytical programming, data management, development of macros, quality control and reporting for research projects and clinical trials

Provided technical expertise to CCG clients utilizing a variety of reporting techniques Worked with different database technologies and integrated data from various sourcesAnalyzed data, system, and measures to support the establishment of a next generation Anti-Money Laundering detection application for one of CCG's clients. Worked with the ETL, application development, and software quality management teams to (a) map the application's data attributes and (b) document business… Show more Provided technical expertise to CCG clients utilizing a variety of reporting techniques Worked with different database technologies and integrated data from various sourcesAnalyzed data, system, and measures to support the establishment of a next generation Anti-Money Laundering detection application for one of CCG's clients. Worked with the ETL, application development, and software quality management teams to (a) map the application's data attributes and (b) document business and testing requirements Show less

Created and managed forecast models and stored procedures for various media tactics using TimeTrends Forecast System, SAS JMP, and SQL Server Managent Studio. Provided forecasts and actual vs forecast variance analysis for media tactics such as direct mail and shared mail.

Provided analytics (data mining, predictive models, automated data reports, and other data driven decision support services) to support a $13 Mn grant-funded project from the Center for Medicare and Medicaid Services. LIGHT^2 aims to demonstrate innovative ways to deliver better patient care at lower costs to approximately 10,000 beneficiaries.Interfaced with data marts through SQL Server Management Studio, COGNOS data cubes, SAP Business Object and Electronic Medical Records on a… Show more Provided analytics (data mining, predictive models, automated data reports, and other data driven decision support services) to support a $13 Mn grant-funded project from the Center for Medicare and Medicaid Services. LIGHT^2 aims to demonstrate innovative ways to deliver better patient care at lower costs to approximately 10,000 beneficiaries.Interfaced with data marts through SQL Server Management Studio, COGNOS data cubes, SAP Business Object and Electronic Medical Records on a daily basis, transforming big data into meaningful and actionable sets of information.Conceptualized, designed and ensured smooth implementation of a secure web-based program management and dashboarding tool that automates member deactivation, member enrollment and calculations of healthcare metrics. Programmed the SQL codes that were imbedded in php codes. Show less

Provided technical assistance for event and program management, report generation, database management and statistical analyses

Rendered technical inputs on the design and implementation of an enterprise-wideperformance dashboard to (1) to track incidents and service requests, (2) facilitatemore objective performance assessments and (3) improve organizational processes

Delivered a comprehensive competitive analysis of Shelter competitive strengths vs its competitors highlighting comparisons of key marketing strategies.Generated adhoc data reports using SAS and SQLEngaged in brainstorming and idea generation for predictive modeling (e.g.,predictive model for inspection reports and generation of sampling data)

Conceptualized and developed a performance dashboard for the InformationSystem/Human Resource Department that allowed users to deliver on service levelagreements individually and as a teamManaged a team of IT specialists assigned to work on the project; project delivered ontime and on budgetAuthored the Performance Dashboard’s Administrative and User’s Guide

Designed and analyzed Service Satisfaction and Occupational Status surveysProvided (a) front office services to more than 3,000 students and over 10,000 activeemployers and (b) staff support for various career events and workshopsManaged an online jobs boards and department website on a daily basis ensuring thatinformation are accurate and updated

Developed a database of industry indicators, demand-supply regression models andpredictive business cycle models for the real estate industry, allowing management to (a)reference investment decisions on more rigorous analysis of the market, (b) mitigate risks,and (b) identify opportunitiesManaged four major projects simultaneously at any given time including full feasibilitystudies/financial modeling for infrastructure projects and preparation of biddingdocuments for… Show more Developed a database of industry indicators, demand-supply regression models andpredictive business cycle models for the real estate industry, allowing management to (a)reference investment decisions on more rigorous analysis of the market, (b) mitigate risks,and (b) identify opportunitiesManaged four major projects simultaneously at any given time including full feasibilitystudies/financial modeling for infrastructure projects and preparation of biddingdocuments for land acquisition initiativesConsistently attained above average performance evaluations and performancebonuses and promoted to second tier manager within a relatively short period Show less

Fellow (2008 – present) |Ad hoc Program Officer (2002 – 2009)|Research and PublicationsAssociate (2000 – 2002) | Media Department, Media Assistant (1998 – 2000)Elected as one of the youngest Fellow in a roster consisting of the Philippines’ prominenteconomists, academicians, business practitioners and media personalitiesServed as project manager, economic analyst and media officer on FEF’s efforts to pushfor good governance and market-based policy… Show more Fellow (2008 – present) |Ad hoc Program Officer (2002 – 2009)|Research and PublicationsAssociate (2000 – 2002) | Media Department, Media Assistant (1998 – 2000)Elected as one of the youngest Fellow in a roster consisting of the Philippines’ prominenteconomists, academicians, business practitioners and media personalitiesServed as project manager, economic analyst and media officer on FEF’s efforts to pushfor good governance and market-based policy reformsAttended international internships, leadership trainings, conferences and networkingactivities (e.g., Germany, United States, Australia, Malaysia) Show less

provided technical assistance in the review and review and analysis of ADB's lending policies to member countries

Research Assistant: provided technical support to a World Bank funded research paper on Infrastructure Development in the Philippines (July 2004-September 2004)Teaching Assistant: co-taught basic economics (micro and macro) to college students for two consecutive semesters