Gina R.

DATA ANALYST

570 euro
Freelancer
24 ans
Denver, UNITED STATES

Mon expérience

Voir plus

Surgical Management ProfessionalsApril 2018 - October 2018

Formulated initial and renegotiation data/model analysis
Responsible for creating and maintaining Access, Excel and SQL databases to track business performance
Responsible for creating and published periodic reports as well as any necessary ad hoc reports for claims data, provider data and member data and made recommendations as needed
Maintained Project Management spreadsheet
Provided Ad Hoc reporting as requested by leadership
Developed and analyzed business performance reports for claims data, provider data, utilization data
Responsible for taking business issues and devising best practices to develop appropriate diagnostic and/or tracking data that will translate business requirements into usable decision support tools
Maintained the SharePoint sites for all Facilities
Assisted and answered questions from AR Staff as needed
Assisted Administrators of our facilities with questions
Miscellaneous projects as assigned by Administration
Voir plus

Anadarko PetroleumJanuary 2017 - November 2017

Responsible for creating and maintaining MS Access Databases linked through ODBC to SQL Server or Oracle;
Responsible for creating and maintaining Excel spreadsheets;
Wrote VBA Code and macros for MS Access and Excel to automate processes in an effort to make users daily work more efficient
Developed front-end user interface for databases in an effort to automate processes and streamline databases for efficiency
Provided summary statistical data utilizing MS Excel for operational performance purposes
Gathered and analyzed user requirements for database development and changes
Utilized ANORM, Open Wells and TOAD Data Point to analyze data
Sabbatical
Voir plus

Anthem/WellPoint, Inc.May 2008 - May 2015

Responsible for creating and maintaining MS Access Databases linked to SQL Server, to analyze claims, utilization and provider data, pharmacy POS data
Utilized T-SQL and created Stored Procedures
Provided summary statistical data utilizing MS Excel for operational performance purposes
Gathered and analyzed user requirements for database development and changes
Produced claim detail invoices for ineligible beneficiaries, provided manager with summary and detail data for ineligible beneficiary invoices, and for purposes of billing Centers for Medicaid and Medicare Services (CMS) for outstanding claims
Posted beneficiary payments to database
Developed periodic reports, ad-hoc queries (SQL) and ad-hoc reports as needed
Submitted necessary data to IT for claim detail data
Developed Business Object Reports for management
Developed front-end user interface for databases in an effort to automate processes and streamline databases for efficiency
Wrote VBA code and macros for MS Access and Excel
Wrote process documentation and provided user training
Made necessary recommendations for tracking data
Provided enrollment and claim data reports for Executives and staff
Familiar with Teradata SQL Assistant 12.0 & 13.10
Voir plus

Xcel EnergyFebruary 2008 - March 2008

Responsible for designing Excel reports, and wrote VBA Code and macros to automate Excel Reports that tracked and forecasted gas measurements; wrote VBA Code/SQL/stored procedures to extract data from an SQL Server, and populate Excel Reports; analyzed data; wrote documentation and trained users on new reports.
Voir plus

-March 2004 - March 2008

Contract:  Database/Report Developer – Xcel Energy, Golden, CO (2/08 – 3/08)
Responsible for designing Excel reports, and wrote VBA Code and macros to automate Excel Reports that tracked and forecasted gas measurements;  wrote VBA Code/SQL/stored procedures to extract data from an SQL Server, and populate Excel Reports;  analyzed data; wrote documentation and trained users on new reports.

Contract:  Application Developer – Health One, Denver PAS, Denver, CO (1/07 – 01/08)

Responsible for designing and maintaining MS Access databases; created and maintained SQL databases; created SQL queries/stored procedures on Oracle utilizing SQL Plus; data mapping and validation of data maps; identified and resolved data quality issues to ensure quality assurance and drive data quality initiatives as instituted by management;  extracted, transformed and analyzed data from databases; conducted thorough analysis of data issues, investigated and reported key findings;  created MS Access databases to detect errors in the data mapping; wrote VBA code to automate reports exported out of MS Access databases; maintained and created reports in Meditech/NPR; wrote and maintained documentation; created and maintained stored procedures/triggers and DTS packages; setup and maintained reports on BOSS Scheduler; created and maintained reports/SQL in Business Objects.


Contract:  Senior Financial Business Analyst – Qwest Communications, Littleton, CO (10/06 – 01/07)
Responsible for creating and generating reports utilizing Crystal Reports;  created and maintained MS Access databases for analyzing data; performed data scrubbing; created and maintained SQL databases, utilizing T-SQL; utilized ODBC; created and maintained DTS packages; wrote a macro for an email received daily which contained data, that needed to be imported into a MS Access database for analyzing, macro saved the company hours of data cleanup; created ad-hoc queries and reports; maintained data on a mainframe.

Contract:  DBA Consultant – Geronimo Financial, Denver, CO (6/06 – 9/06)
Responsible for setting up and maintaining new users on an SQL Server; wrote and managed SQL queries, stored procedures/triggers; utilized T-SQL; created and maintained SQL databases; utilized ODBC with Microsoft Access as a front-end, and SQL Server as a back-end; created and maintained DTS packages; created and maintained company databases; wrote macros and VBA code to export data out of the company’s Portfolio Management Software (Advent), and imported into a MS Access database for data manipulation, data updates, and created company wide reports; performed edits to the company website; trained users.

Contract:  Business Analyst/DBA – InNet, Inc., Centennial, CO (8/05 – 5/06)
Responsible for writing and managing SQL queries; created reports; wrote technical documentation; utilized T-SQL; created and maintained SQL databases; created and maintained DTS packages; interacted with clients;  resolved client issues; assisted and resolved help desk issues; provided documentation and training for clients; responsible for maintaining company Production Calendar;  analyzed data for inconsistencies; created and maintained HTML web pages;  provided QA testing for company applications before being placed into production;  project management which consisted of gathering data, and assisting co-workers and/or clients in preparation for company-wide audit; coordinated and compiled audit documents, performed document edits, and continued follow-up to ensure that all documents were completed in a timely manner.

Contract:  QC/Reporting Analyst – Fidelity Natl Asset Management Solutions, Westminster, CO (4/04 – 8/05)
Responsible for REO reports and queries;  created QC Reports; created MS Access databases; created/maintained SQL databases; wrote VBA code to export data to Excel;  generated month-end REO reports for clients; wrote technical specs for company databases; created views, triggers & stored procedures;  maintained data dictionaries;  analyzed and resolved data integrity issues.

Contract:  Programmer Analyst – PSI Technologies, Denver, CO (3/04)
Analyzed, revised and completed a MS Access Database that was not functioning properly; created new tables, queries, forms and reports; determined table relationships and key field identifiers; maintained data dictionaries; utilized VBA programming.
Voir plus

Denver PASJanuary 2007 - January 2008

Responsible for designing and maintaining MS Access databases; created and maintained SQL databases; created SQL queries/stored procedures on Oracle utilizing SQL Plus; data mapping and validation of data maps; identified and resolved data quality issues to ensure quality assurance and drive data quality initiatives as instituted by management; extracted, transformed and analyzed data from databases; conducted thorough analysis of data issues, investigated and reported key findings; created MS Access databases to detect errors in the data mapping; wrote VBA code to automate reports exported out of MS Access databases; maintained and created reports in Meditech/NPR; wrote and maintained documentation; created and maintained stored procedures/triggers and DTS packages; setup and maintained reports on BOSS Scheduler; created and maintained reports/SQL in Business Objects.
Voir plus

Qwest CommunicationsOctober 2006 - January 2007

Responsible for creating and generating reports utilizing Crystal Reports; created and maintained MS Access databases for analyzing data; performed data scrubbing; created and maintained SQL databases, utilizing T-SQL; utilized ODBC; created and maintained DTS packages; wrote a macro for an email received daily which contained data, that needed to be imported into a MS Access database for analyzing, macro saved the company hours of data cleanup; created ad-hoc queries and reports; maintained data on a mainframe.
Voir plus

Geronimo FinancialJune 2006 - September 2006

Responsible for setting up and maintaining new users on an SQL Server; wrote and managed SQL queries, stored procedures/triggers; utilized T-SQL; created and maintained SQL databases; utilized ODBC with Microsoft Access as a front-end, and SQL Server as a back-end; created and maintained DTS packages; created and maintained company databases; wrote macros and VBA code to export data out of the company's Portfolio Management Software (Advent), and imported into a MS Access database for data manipulation, data updates, and created company wide reports; performed edits to the company website; trained users.
Voir plus

InNet, Inc.August 2005 - May 2006

Responsible for writing and managing SQL queries; created reports; wrote technical documentation; utilized T-SQL; created and maintained SQL databases; created and maintained DTS packages; interacted with clients; resolved client issues; assisted and resolved help desk issues; provided documentation and training for clients; responsible for maintaining company Production Calendar; analyzed data for inconsistencies; created and maintained HTML web pages; provided QA testing for company applications before being placed into production; project management which consisted of gathering data, and assisting co-workers and/or clients in preparation for company-wide audit; coordinated and compiled audit documents, performed document edits, and continued follow-up to ensure that all documents were completed in a timely manner.
Voir plus

Fidelity Natl Asset Management SolutionsApril 2004 - August 2005

Responsible for REO reports and queries; created QC Reports; created MS Access databases; created/maintained SQL databases; wrote VBA code to export data to Excel; generated month-end REO reports for clients; wrote technical specs for company databases; created views, triggers & stored procedures; maintained data dictionaries; analyzed and resolved data integrity issues.
Voir plus

PSI TechnologiesMarch 2004 - March 2004

Analyzed, revised and completed a MS Access Database that was not functioning properly; created new tables, queries, forms and reports; determined table relationships and key field identifiers; maintained data dictionaries; utilized VBA programming.
Voir plus

KSG ENTERPRISESJanuary 2001 - March 2004

Owned and operated a home-based business consisting of selling novelty and gift items on-line.
Voir plus

Dept. of Health & EnvironmentMay 2003 - June 2003

Revised Microsoft Access 2002 Database including form design, GUI, SQL, queries, tables, programming in VBA; provided user support, training and technical writing/documentation for users.
Voir plus

Wells FargoMay 2001 - October 2001

Performed data analysis, data entry, data scrubbing; created ad-hoc queries/reports in preparation of designing a tracking system in Microsoft Access 2000; developed user-friendly data entry forms; created Graphical User Interfaces (GUI); utilized ODBC to various data sources on Oracle and SQL Servers; provided user support, training and technical writing/documentation; designed a Microsoft Access database to internally track Commercial Treasury Management Electronic Product customers being converted from a legacy system to a strategic system called ``EPICS''.
Voir plus

Auraria Higher Ed. CenterJanuary 2000 - May 2000

Performed full cycle design & program of a Microsoft Access 2000 Telecommunications database; provided desktop user support, training and technical writing/documentation.
Voir plus

TIAA CREFAugust 1999 - January 2000

Performed Novell Netware Administration; Database design/maintenance utilizing Microsoft Access; crystal reporting within Microsoft Access; created multiple tables with relationships; performed requirement definitions, data conversions, imports/exports of data and data entry; analyzed requirements and data; provided technical support and training to users; performed software upgrades and maintenance.
Voir plus

Legal Group Tech ServicesMarch 1999 - June 1999

Performed assessment and remediation of Microsoft Access databases and Microsoft Excel spreadsheets for Year 2000 compliance; performed data entry; responsible for desktop user support and training.
Voir plus

Holland & HartMay 1991 - March 1999

Developed and maintained Microsoft Access, Concordance and Folio View databases to effectively support the daily work of lawyers and other staff members; created multiple tables with relationships; performed data conversions, import/export of data, requirement definitions and analyzed requirements and data; created queries with multiple tables; designed reports; worked extensively with Microsoft Access 2.0-2000 and Excel; utilized ODBC, SQL, Paradox and data modeling; maintained databases on a Novell WAN; setup and maintained users on the WAN; solely responsible for the maintenance and administration of an imaging system which consisted of millions of images, retained in two 100-disk jukeboxes; designed and programmed a document assembly system using WinDraft for Windows; assisted with data entry and administrative duties; performed HTML design and maintenance; provided technical support and training to users; technical writing/documentation; performed software upgrades and maintenance; provided backup help desk duties, which included desktop user support and training.
Education and Professional Development ,

Mes compétences

XML, Visual Basic, VBScript, VBA, Transact-SQL, Technical Support, T-SQL, Sybase, Supervisor, Stored Procedure, SQL, Software Development, Quality Assurance, Project Management, Oracle 9i, Oracle, ODBC, Novell Netware, Microsoft Word, Microsoft SQL Server, Microsoft SharePoint, Microsoft PowerPoint, Microsoft Excel, Korn Shell, HTML, DML, Database Administration, Data Warehousing, Data entry, Data analysis, Business Objects, Analytical skills, ADO