Data Project

Grace Gumaru

OBJECTIVE

Analyst and project management/coordinator position where I can effectively utilize my skills.

SUMMARY:

Proficient in project management and coordination driving projects deliverables successfully and on time. Knowledgeable in all stages of project development life cycle, involved in project procurement management by establishing, maintaining and closing relationships with the client.

Knowledgeable of healthcare technology developments, data quality assurance and governance, data analysis, Data Warehouse concepts and application.

Excellent customer relations and communication skills, both verbal and written.

Excellent working relationship with clients, developers, subject matter experts as well as senior management.

Well-organize in assisting project management and organization, detail oriented in tracking tasks at various levels.

Remarkable ability to work on own initiative within established guidelines.

SKILLS

Databases: Netezza Data Warehouse appliance and Analytics Platform, Aginity workbench for IBM PureData/Netezza, Cache’, MS Access, Oracle, Intersystems Ensemble 2010 to 2013 (Studio, Terminal) Languages: SQL, Java Script, Object Script (MDX) Operating Systems: Windows 95/98/2000/XP/Vista/NT, Unix, AIX Project Management: MS Office Suite (Microsoft Project, Microsoft Word, Microsoft PowerPoint, Microsoft Excel), MS Project, MS Sharepoint, Agile Project Methodology, SCRUM, SDLC Business Modeling Tools: MS Visio ETL: Informatica Powercenter9x Data Quality Tools: Informatica Developer 9x and 10.2/ Analyst/ IDQ, IBM Information Analyzer and Infogix Reporting Tools: Crystal Reports, Tableau Business Intelligence, Information Advantage DecisionSuite, Oracle Discoverer, Active Reports Others: Application Program Interface (API), HTML, CSS, API, SSO, CM ticketing systems (JIRA), Code Deployment Systems

EXPERIENCE

MBI Solutions – San Francisco, CA June 2014 –current

(BlueShield of California –Analyst/ Project Management- Project coordinator)

Projects: P360, Provider BOR, Clinical BOR, Claims BOR, BIS Analytics Presentation Reporting)

BOR (Book of Record) - this initiative is to create companywide SSoT (Single Source of Truth). This enterprise solution collects and merges all information from various BSC Systems such as Oracle, Netezza, Flat file, pipe delimited file, Access DB, Excel, etc. and make it available uniquely from one logical location.

Successfully managed and supported development day to day key participants’ responsibilities and key deliverables from conception to delivery using Agile Project Methodology- SCRUM implementation.

Successfully coordinated all aspects of development of various development initiatives through strategic business planning aligning business goals with excellent technology solutions. Includes managing developers utilizing and leveraging internal APIs for productivity where a complete systems Development Life Cycle (SDLC) is implemented.

Successfully managed, coordinated, and engaged Business/Analytics users making sure business requirements and integrity are being met. Initiative incudes analysis of source details, map, and validates STTM (Source-To-Target Mappings) of data including business rules for HealthCare data processes ensuring data quality.

Managed and supported development of Low Level Design (LLD), Technical Documentation for the project deliveries, development of test plan and automation/execution, development of BOR Run Book for MPP (Massively Parallel Processing) identifying load plan, task and execution, and developed project closing ‘Delivery’ documentation for various BOR initiatives.

Involved in project procurement, reviewing vendor contracts, and interface closely with industry experts thoroughly identifying business needs to fulfill business agreements.

Pieran Healthcare Technologies - Phoenix, AZ March, 2011 –May, 2014

(Indian Health Services - Business Intelligence Analyst/Project Coordinator)

Managed and supported development team offshore to provide end to end solutions to the client’s needs.

Integrated data from various sources to develop cubes representing relational and multi-dimensional view of data for DeepSee Reports.

Developed KPIs, Pivots, Charts, Scorecards to manage patients and providers productivity.

Involved in project procurement, reviewing vendor contracts, Interface closely with business users and hospital SMEs identifying business needs.

Prepared Business process models; used Visio to create use case diagrams.

Designed mockup screens to communicate visual data flow to the end users.

Successfully implemented a web-based system of securing certification of NCQA (National Committee for Quality assurance) for DCP Providers and American Board of Internal Medicine. Development utilized HTML, CSS, and JS (Java Script).

Implemented GPRA (Government Performance and Result Act) Trend Analysis certification in addition to NCQA using SSO to the certification system.

HighGround Technology -- Scottsdale, AZ December, 2004- February, 2011

Project Management/ Data Quality Analyst

Managed projects and schedules, managed day to day key participants’ including offshore participants’ responsibilities and key deliverables, performed project progress and status reporting. Successfully managed stages of project development life cycle

Oversaw compliance of data flows against Data Quality standards.

Supported data profiling solutions, run analysis jobs and view results, create and manage Data Quality controls using IBM Information Analyzer, Informatica Analyst/IDQ, and Infogix.

Accurately and articulately conveyed all data information to programmers; reviews all data fields for accuracy.

Reviewed, analyzed, and ensured the quality assurance of data loaded into the system.

Documented and reported data quality goals and standards.

Provided progress reports of data quality for executives to show quality and trends.

Logged defects discovered during data testing and evaluation in the project tracking tool.

The Dial Corporation/ EDS Corporation -- Scottsdale, AZ August, 1998- October, 2004

Data Quality Analyst/ Technical Specialist

Provide profiling, cleansing and validation reports in preparation for data migration using both new and reusable IDQ templates to ensure data quality control; thus, responsible for information and data research of data integrity issues across company’s business units.

Analyze and identify data profiling results and propose resolutions and recommendations of Data Quality problems.

Develop and publish metrics capturing Data Quality trends to warrant quality controls and quality assurance programs are working.

Supported data Standardizing and loading using ETL software and custom SQL.

Involved in the implementation of Document Management System Project (Documentum) that includes data requirement gathering and functional documentation.

Developed ad-hoc reports across business units incorporating extensive data research and data analysis utilizing various querying tools.

Developed Data Dynamic Reports utilizing Active reports for the R&D Documentum Project and Oracle Discover Report in the DataMart.

Primary analyst providing training, administration and support of over 180 Oracle Discoverer users in all the environments where the tool is being implemented and utilized.

Wells Fargo Bank/DMS Services/AirTouch Cellular – Scottsdale, AZ July,1996–July 1998

Report Analyst

Project scoping and definition.

Query design for reporting analysis, maintenance, and support.

Ad-hoc queries and custom reports development and enterprise report administrator.

Finnish International Development Administration July,1990-July,1996

Project Liason

EDUCATION

Bachelor of Science in Engineering, (Civil and Structural discipline) Manila Philippines

Professional Trainings:

•Netezza Platform; Ensemble – Cache and DeepSee Developme;TDWI Data Modeling: Data Warehousing Design and Analysis Techniques; DWI Data Warehousing: Data Cleansing;Oracle 8i Application Development

Contact this candidate