Gina R.

Data Analyst

645 dollar
Freelancer
24 years
Denver, UNITED STATES

My experience

More

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
More

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   
More

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
More

-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.
More

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.
More

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.
More

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.
More

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.
More

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.
More

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.
More

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.
More

KSG ENTERPRISESJanuary 2001 - March 2004

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

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.
More

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''.
More

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.
More

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.
More

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.
More

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 ,

My stack

Business Intelligence

Business Objects

Databases

Stored Procedure, Sybase, Microsoft SQL Server, Transact-SQL, Oracle 9i, Database Administration, Oracle

Others

Project Management, Supervisor, Data analysis, Quality Assurance, Technical Support, Data entry

Languages

HTML, VBA, XML, SQL, VBScript, Visual Basic, Korn Shell, ODBC, T-SQL

IT Infrastructure

Novell Netware

Application servers

Microsoft SharePoint

Computer Tools

Microsoft Excel, Microsoft PowerPoint, Microsoft Word

Other

responsible for desktop user, quality training and training, model analysis, managed SQL queries, full cycle design, exceptional support, database development & administration, conducted thorough analysis, administrative experience, VBA skills, VBA Excel programming, Treasury management, Teradata SQL Assistant V13.10, Technical Troubleshooting, TIBCO Spotfire Analytics Server, Sybase Central, Sybase Adaptive Server, responsible for maintaining company Production Calendar, Responsible for data extraction, Responsible for designing Excel, Responsible for taking business, Responsible for writing and managing, Responsible for REO reports, Strong management, Report development, ORACLE QA, Portfolio Administration, Data Transformation Services, User Training, database development, SQR, DDL, user support experience, responsible for the maintenance and administration, Corel Paradox for Windows, BOSS Scheduler, Business Owner, DBA Consultant, Database/Report Developer, Familiar with Teradata SQL Assistant, Litigation Support / Database Applications Programmer, NT Network Administration, QC/Reporting Analyst, Senior Financial Business Analyst, Sr Managed Care Analyst, Database Consultant, Database design/maintenance, Informix-SQL, Maintained Project Management, Oracle SQL *Plus, Performed data analysis, C Programming Language, Microsoft Windows, Microsoft Access, Microsoft ASP.NET, Manager, Data Analyst, Microsoft Office, Visual Basic for Applications, Business Analyst, Analyst/Programmer, Seagate Crystal Reports, Microsoft SQL Server 2000, Microsoft Visual Studio.NET, LAN/WAN > WAN, Microsoft Visio, Visual Basic .NET, help desk, RDBMS, Data Access Object, communication skills, MS Visual SourceSafe, trainer, GUI Applications, SQLPlus, Microsoft Outlook, Import/Export, Requirements Gathering, Data Warehousing, Analytical skills, Y2K, Microsoft Publisher, Seagate Crystal, Office management, Application Developer, IT Professional, DML

Technologies

ADO, Software Development

My education and trainings

- American National University1993 - 1995