Mario Olivares
Happy Valley,Oregon
Summary
Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Overview
14
14
years of professional experience
Work History
Data Analyst
Multnomah County
06.2016 - Current
- Design, develop, and maintain complex small/independent databases for systems focusing on specific areas; design, write, and test queries in order to access databases and prepare standard and ad hoc reports to meet specified needs
- Serve as liaison with outside agencies and services providers on data analysis, reporting issues, and needs; determine needs and design reports or other methods to meet needs; provide technical assistance to outside agencies/contractors on automated data systems
- Collect, compile, extract, and organize complex information and data from multiple systems into a variety of summary and detailed executive management reports and/or presentations
- Design quality assurance management reports that include analysis of internal business/program operations as well as contracted vendor services; analyze, evaluate, and recommend modification to operating methods and procedures as they relate to departmental operations and goals; make recommendations based on research and analysis
- Perform difficult statistical or analytical studies involving complex data and records using mathematical modeling, matrix algebra or linear, multiple and logarithmic regression as needed to support assigned functions
- Develop written documentation, internal operating procedures, and end user manuals and instructions on independent department-specific data systems; develop and conduct user training sessions; provide ongoing technical assistance to system users
- Analyze information needs of multiple users to assist in determining appropriate system structures and prepare system and report specifications
- Investigate and resolve data, reporting, and system inconsistencies; develop and implement work flow, data entry, collection, and reporting procedures
- Assist in the review, development, and installation of major department-specific information systems
- May serve as an integral member of a research or study team
- Perform other duties as assigned
- Perform the full range of duties, working independently, applying well developed subject knowledge, and exercising judgment and initiative
- Receive occasional instruction or assistance as new or unusual situations arise
- Fully aware of the operating procedures and policies within the work unit
- Work is reviewed based on compliance, appropriateness, and effectiveness in meeting goals and deadlines
- Receive direction from manager or staff.
SUN Program Coordinator
Metropolitan Family Services
09.2012 - 01.2016
- Develop and create after school activities for high poverty and at risk youth
- Developing and implementing programming within Centennial School District, specifically to Lynch Meadows Elementary
- Collaboration with district officials, principals, teachers, federal grants designee and community agencies when implementing, funding and coordinating new programs or activities
- Created SUN wide soccer league for families and participants, as well as coordinate times, volunteers, locations and scheduling
- Also created, implemented and oversaw other various community activities such as Community Cup and Turkey Cup
- Created and implemented such educational school programming and academic enrichments such as AKA Science, Mad Science, ZAP, Multnomah County Library
- Directly hire new staff including facilitate interviews, reference checking, and scheduling
- Directly supervise SUN staff such as teachers, after school providers, activity leaders, volunteers and Ameri Corp staff
- Collaborate with school officials and faculty in creating wrap around services for underrepresented families
- Develop and create safety planning surround day to day activities included implementation of policies and procedures
- Knowledgeable of such computer data systems such as Service Point, Microsoft programming and
- Experience in grant reporting and writing.
Youth Education and Prevention Specialist and Legal Advocate
Clackamas Women's Services
11.2009 - 09.2013
- Travel around Clackamas County giving sexual and domestic violence presentations to schools and other collaborating institutions
- Empowerment, advocacy and support for survivors of domestic violence and sexual assault
- Working with community partners to further support survivors such as DHS, Legal Aid, Impact Latino, Catholic Charities and crisis needs
- Providing assessments, needs assessments, facilitating allocation of essential resources (housing, shelter, legal, ect)
- Provide translation services for participants including legal translation, accompaniment to court, navigating the legal system by translation of court orders, stalking orders, restraining orders, ect
- Providing support to populations served by Clackamas Women's services
- Provided community outreach for youth in public education systems in Clackamas County by providing presentations, youth mentoring, and serving on various school councils and coalitions
- Implementation of curriculum based group work with at-risk youth in public schools throughout Clackamas Co
- Implementation of collecting data and inputting pre/post data from outreach work into ALICE statistical software; present findings to Executive Director of CWS and other board members
- Presentations (Domestic Violence, Sexual Assault, Healthy Relationship) to schools county wide
- Highly organized, works very well independently
- Conduct intake and document statistics into ALICE.
Education
Bachelor of Science - Sociology
Eastern Oregon University
La Grande, OR06.2009
Skills
- Requirements Definition
- Data Validation
- Data Formatting
- Process Improvement
- Database Maintenance
- Project Management
- Data Exports
Degree
BS
Timeline
Data Analyst
Multnomah County
06.2016 - Current
SUN Program Coordinator
Metropolitan Family Services
09.2012 - 01.2016
Youth Education and Prevention Specialist and Legal Advocate
Clackamas Women's Services
11.2009 - 09.2013
Bachelor of Science - Sociology
Eastern Oregon University