Sophia Braga Page *

SOPHIA BRAGA

acxb7p@r.postjobfree.com I 518-***-**** I NISKAYUNA, NY

BUSINESS INTELLIGENCE AND PROJECT MANAGEMENT PROFESSIONAL Highly motivated business intelligence (BI) professional with 17 years of IT practice and extensive experience in designing, leading and implementing a broad range of BI and data management initiatives. Effective in communicating with various levels and roles in the organization. Business Intelligence and Data Warehouse Data Quality Improvement and Governance IT Project Management Business Analysis

Data Mapping and ETL Development Data Analysis and Visualization SQL and Database Programming Report and Dashboard Development PROFESSIONAL EXPERIENCE

Excelsior College Albany, New York 11/2008–09/2016 Executive Director of Business Intelligence (BI) 01/2014-09/2016

Directly supervised a high-performing team of BI and data warehouse developers. Provided staff development and coaching.

Executed projects with varying sizes and scope. Experienced in project management, business analysis, and managing user/stakeholder/team expectations.

Delivered BI projects and requests according to schedule and customer satisfaction - consistently met the 90% quarterly goal for completing projects on time.

Collaborated effectively with business leadership to ensure that BI/DW systems effectively support the organization's decision-making and analytics requirements.

Led the delivery of an executive-level performance management dashboard using a data visualization tool (QlikView).

Initiated the project for retiring a legacy reporting tool (Oracle Discoverer) and the development of an enterprise data warehouse project charter.

Architected the design and expansion of the existing QlikView and data warehouse (DW) environment according to best practices. Led technology tool evaluations and managed vendor relations.

Established internal development standards, and testing and code deployment practices for reports and dashboards.

Senior Business Intelligence (BI) Developer 11/2011–12/2013

Directed the gathering of functional and technical requirements, business analysis, data mapping, dimensional modeling and development of ETL procedures in implementing a data warehouse that facilitated the analysis of daily student behavior using SQL and Oracle Data Integrator 11g. Acted as liaison with stakeholders throughout the project lifecycle.

Led a data management initiative through the identification of data stewards (people), establishment of data governance rules (process) and procurement of a technological solution

(tool).

Developed reports and dashboards using Oracle Discoverer and data visualization tool

(QlikView) that improved business productivity and inform decision-making.

Acquired strong familiarity with statistics or use of statistical applications such as R as a result of numerous collaboration with data analysts and higher education analytics partners. Sophia Braga Page 2

Business Intelligence (BI)/Applications Developer 11/2008-10/2011

Implemented a data store that enabled analysis of student persistence and other pertinent student behavior and demographic variables, using SQL and PL/SQL programming.

Led a group evaluation and vendor selection of a data extraction-transformation-loading

(ETL)/ELT tool called Oracle Data Integrator 11g.

Designed and developed a data mart that provided actionable information in tracking instructor activities in Blackboard, piloted using Oracle Data Integrator 11g. Parsons Child and Family Center Albany, New York 05/2003-11/2008 Oracle Programmer

Developed, maintained and supported a custom-built software (Parmenu) using Oracle Forms, Oracle Reports, PL/SQL and SQL. Strong familiarity with HIPAA regulations.

Delivered dashboards and charts, as requested by program directors, using Oracle Discoverer and MS Excel spreadsheets that provided data on the effectiveness of each program.

Administered Oracle Discoverer and the creation and maintenance of underlying database structures.

Served as a data warehouse liaison for the Office of Child and Protective Services (OCFS) by customizing Cognos Impromptu reports.

Oracle Systems Inc. Makati, Philippines 07/2000–07/2001 Technical Consultant

Contributed in an Oracle Programmer capacity as part of a large and multinational technical implementation team tasked to customize Oracle Applications 11i for the Asian Development Bank.

Created data loading routines to facilitate the conversion from legacy Human Resource (HR) system to Oracle Human Resource Management System (HRMS) using SQL and PL/SQL. Ingenium Technology Inc. Makati, Philippines 06/1998-06/2000 Oracle Programmer

Developed new software and customized software packages, depending on client needs, using SQL, PL/SQL, Oracle Forms and Oracle Reports.

Provided technical support for various clients in the life insurance and pre-need industries. EDUCATION

Bachelor of Science, Computer Science, 1998 • University of the Philippines-Los Baños, Laguna, Philippines

Certificate in Project Management, 2012 • Excelsior College (Center for Professional Development), Albany, New York

TECHNOLOGY SKILLS

Proficient in SQL, PL/SQL, Oracle database, SQL*Plus, PL/SQL Developer, TOAD, Oracle Data Integrator, Oracle Data Modeler, QlikView, Oracle Discoverer, Oracle Forms, Oracle Reports, MS SQL Server, HTML5, Innotas, SharePoint, MS Project, Visio, and MS Office applications CONFERENCES AND PROFESSIONAL ORGANIZATIONS

The Data Warehouse Institute (TDWI) Conference, 2015 Qlik World Conference, 2014 Bishop House (Management Training), 2013 Kimball University (Data Warehouse), 2011 Gartner Business Intelligence Summit, 2010 Higher Ed Data Warehouse Group, 2010

Contact this candidate