Data Sql
Resume:
Olivia Gonzales
Member, American Mensa
**** **** ***** *** *** D, Alhambra, CA
**** **** ******* ***** *** 2, Anaheim, CA
******.*****@*****.***
http://www.linkedin.com/pub/olivia-gonzales/5/338/69a
https://www.facebook.com/olivia.manto.1?fref=ts
Summary: Nine years - SQL Development and Data Warehouse Analysis. Expert
in SSRS, SQL, Crystal Reports, MS Access, MS Office. Experienced in SSIS,
MDX Querying, VBA Programming.
WORK EXPERIENCE
IT DataWarehouse Analyst /Adhoc Report Writer
11/2012 -9/2013 Wellpoint
. SQL Development - SSRS, SSAS MDX Query - ( OLAP)
. Crystal Reports, Business Analysis, Documentation, Data Validation
. Analyzes/Recommended query design for SSAS Cube Development
. Adhoc Reports ( Claims, Authorizations, Hedis project)
Senior Analyst/SQL/SSIS Developer ( Contract)
05/2012 - October 2012 Optum RX, Costa Mesa, CA
. Business Technical Documentation
. SSIS/SQL Development - Call Center and Pharmacy Data, Prior
Authorization
. Documented process for existing SSIS package, re designed SSIS
packages.
SSIS / Data Warehouse Analyst ( Contract )
11/2011 - 03/2012 HealthCare Partners, Torrance, CA
. SSIS, ETL, HL-7 conversion by CALINX.
. Documented process for existing SSIS package, re designed SSIS
packages.
. Pharmacy and Laboratory Data from different providers.
. Data Analysis, Data Cleansing, Deduplication, Validation.
ETL / SQL Developer ( Contract, 1099)
7/2011 - 10/2011 Pasadena Water and Power, CA
. Designed SQL ( Oracle and MS SQL) codes for - Settlement and Usage of
Energy
. Designed ETL processes via SSIS for several databases - Sybase,
Oracle, SQL Server.
. Worked with project teams to integrate change management activities
into the overall project plan.
. Provided workflow diagram in Visio.
. Project is about reconciliation of data on bought and sold energy.
Amalga Business Intelligence Analyst / Clinical Data Analyst (Contract)
10/2010 - 06/2011 Providence Health & Services, Burbank, CA
. Designed adhoc clinical data reports based on cubes, functions, and
views. Documented, conceptualized with executives/users regarding
data content and report format. Data mined for research studies like
the Heart Failure Analysis, Pharmacy Audit, etc.
. Performed PP7 testing for Meditech. Analysed Meditech Camis and
Magic.
. Performed QA on peer's codes, provided support and shared knowledge
with peers.
. Analyzed and documented data feeds from source clinical,
administrative, and quality systems.
. Assisted with the validation and analysis of HL7 data feeds to be
deployed in Amalga.
. Designed, coded, tested, documented data parsers and implemented new
features on the Amalga
platform.
. Contributed to best practices and Amalga implementation standards.
. Tools used: SSIS, SSRS, SQL, Meditech Camis, Focus and Magic
Databases. Trained in Amalga, C#, HL7 ( Calinx).
. Conducted readiness assessments, evaluate results and present
findings in a logical and easy-to-understand manner.
SSRS Developer/ Informatics Specialist (Contract)
04/2010 - 09/2010 Scan Health Plan, Long Beach CA
. Developed SQL Codes for data extraction on insurance claims, pharmacy
and clinical data.
. Developed Ad-Hoc SSRS Reports.
. Gathered information from users for a variety of projects.
Data Warehouse Analyst / Report Writer
11/2007 -11/2009 AIDS Healthcare Foundation West Los Angeles, CA
. Data Analysis, Data Mining, ETL of Medicare Data to and from CMS,
. Crystal Reports, MS Access Reports Development.
. Transformed SAS programs to SQL Scripts.
. Worked with Ezcap Database. Data Reconciliation, warehousing.
. Wrote and executed customized SQL code for ADHOC REPORTS.
. Ensured data integrity by trouble shooting, researching and resolving
eligibility
discrepancies in multiple systems and assisting other
departments in resolving member
issues.
. Ensured appropriate letters are created based on the reconciliation
of daily, weekly and
monthly data submitted and/or received by the Centers for
Medicare & Medicaid Services
(CMS) and mailed in accordance with CMS guidelines and
deadlines.
. Created and managed reporting on eligibility and enrollment.
. Assisted with projects in the Enrollment Department.
. Debugged, maintained existing codes. SQL Query Tuning
. Qc'd and improved codes for automation of data loads, transfers,
and validation steps.
. Maintained current documentation for all primary and backup
responsibilities in an
electronic filing system.
. DTS, SQL stored procedures development, MS Access Visual Basic
programming.
. Visual Basic Application, Database backend development - triggers,
views, database
design.
. Attended meetings, telephone conferences.
. Supported users by troubleshooting codes, programs.
. Projects : MMR, TRR, LIS, Hedis, Claims, RAPS files.
Data Warehouse Analyst/Report Writer (Contract)
06/2008 - 05/2009 Kaiser Permanente, CA
. Developed SSIS, Triggers, Stored Procedures, Functions for Reporting
purposes
. Maintenance of Data Warehouse, User Rights. Data Mining, Reporting,
QC of Data
. Developed/Maintained of Data Warehouse Reporting Database for the new
online
application system for Individual Health Plans.
. Developed Crystal Reports, Business Objects. Database includes SQL
Server 2005 and
Oracle.
. Developed codes for automation of data loads, transfers, and
validation steps.
. Corresponded with Business Analysts for requirement gathering.
. Collaborated with database administrators, application developers,
and business users in
order to ensure business requirements meet expected results.
. Solved data and schema problems.
. Worked closely with all levels of end-users to gather, document and
develop reports
including recommending options and output formatting.
. Analyzed report requests, documents report requirements, and
designs/develops
standard and ad-hoc reports using a variety of reporting tools.
. Understood business processes/rules and how to supply information
that reflects
measurement of those processes.
Programmed in SQL to perform data query, reporting and data load
functions.
. Provided workflow diagram in Visio.
SQL Developer / Analyst (Contract)
6/2007 - 10/2007 Northrup Grumman through an agency ( contract), El
Segundo, CA
. Data Analysis, Data Mining, Data Architecture, US NAVY DATA.
. ETL of Depot Data, Supply and Inventory Data.
. Attended meetings with Boeing personnel.
. FoxPro, MS Access, SQL stored procedure and functions, Toad for
Oracle.
. Database backend development - triggers, views, database design, data
loads, transfers
and validation steps.
. Designed data flow process from US Navy Data to Northrop Grumman
Database.
. Developed documentation for the procedures.
Crystal Reports Developer (Contract)
3/2007 - 6/2007 Pacific Life Insurance (Contract), Newport Beach, CA
. Defined, designed process according to high level and detailed design
for the generation
of reports through user interfaces and back-end triggers.
Gathered Business Analysis
requirements; Reviews Data Schema, defined database elements,
designed Crystal
Reports, develops SQL queries, stored procedures and triggers.
. Provided workflow diagram in Visio.
. Documented business requirements and design.
Programmer/ Database Analyst / Reports Designer (Contract)
4/2006 - 11/2006 AppleOne Corporate (Contract), Glendale, CA
. Contract Job. Developed stored procedures, functions, ad hoc sql
scripts, designed
Microsoft Reporting Services Reports. SQL 2005, SSRS, VBA
. Database backend development - triggers, views, database design.
Programmer / Database Analyst (Contract)
4/2004 - 3/2006 Boeing (Contract), Long Beach, CA (through an agency)
. Oracle PL SQL / Crystal Reports/ VB Programming - C17 Projects.
Created database for
technical specs / data of manuals for airplanes.Designed
Crystal Reports based on
database created. Experience in Toad for Oracle.Edited DTD /
SGML for existing
technical books.
. Database backend development - triggers, views, database design.
SHORT COURSES:
. 2009, West Los Angeles College:
Medical Billing and Coding Introduction and Terminology
. 5/2001 Cal State, Los Angeles, CA
Oracle PL/ SQL Short Course
. 5/2000 UCLA extension, Los Angeles, CA
MS Access VBA Programming
4 Years - University of Santo Tomas, Manila - BS Mathematics
Skills: Crystal Reports, Reporting Services, SQL, MS Access,
MS Excel, MS Office- Word, Powerpoint, Outlook, Oracle PL/SQL,
SAS, SGML / DTD, SPSS, SQL Server, Visual Basic, Toad for
Oracle. Adept Editor, SSRS, SSIS, Visio.
References
https://www.us.mensa.org/AM/Template.cfm?Section=Login
Username: ******.*****@*****.*** Password: troyski
Contact this candidate