Data Analyst Analysis
Resume:
GINA ROPER
Denver, CO *****
Email: *****.*******@*****.***
PROFESSIONAL SUMMARY
Bringing over 15 years of extensive expertise as a Business and Data Analyst, I possess a versatile skill set encompassing SQL, MS Office Suite, Tableau, and Oracle. My proficiency extends to report writing and development, leveraging SQL, Tableau, Business Objects, MS Access, Excel, and Crystal Reports. Throughout my career, I have excelled in adapting swiftly to new environments, refined through diverse consulting engagements. With a background in consultancy, I have delivered top-tier IT services to enterprise- level organizations. My expertise spans data analytics, reporting, report development, database creation, management, and administration, alongside application development and quality assurance. TECHNICAL SKILLS
Tableau Desktop, Tableau Server
MS SQL Server Management Studio (SSMS)
Toad Data Point 4.0, MS Office Suite, MS Office 365
MS SQL Server 2016, Open Wells, ANORM, TIBCO Spotfire 7.9
SharePoint, DDL/DML, HTML, ODBC
Oracle SQL Plus, SQL, T-SQL, Business Objects
Teradata SQL Assistant V13.10, Crystal Reports for Visual Studio .NET
Visio Professional, Visual Source Safe
VBScript
Advanced Excel functions including VBA coding, pivot tables, formulas, vlookups, charts
Advanced MS Access skills including VBA coding/modules, forms, reports, queries, tables
Experienced in Agile Methodology, including Scrum and Kanban frameworks
Proficient in Relational Database Management Systems (RDBMS) principles and practices
Familiarity with SSRS, SSIS, ADO, DAO, JavaScript, Tableau Prep (ETL), Power BI, Python PROFESSIONAL IT EXPERIENCE
Office of the Colorado State Public Defender (REMOTE) Denver, Colorado Business Analyst II (Contract) 5/2023 Present
Responsible for preparing and delivering spreadsheets to Office Managers, outlining network and Dropbox folders for review to facilitate pre-migration cleanup prior to transitioning to Panzura.
Develop VBA coding to automate the generation of multiple Excel sheets containing lists of network and Dropbox folders for Office Managers to utilize during cleanup before the system migration. This entailed parsing columns of data, establishing hyperlinks for navigating to specific folder locations, integrating VLOOKUP functions to retrieve additional data, and formatting the sheets and data accordingly.
Manage the organization of network and Dropbox folders, ensuring their cleanup and readiness for the system migration to Panzura, thus facilitating a seamless transition.
Collaborate with the Project Manager to ensure a seamless rollout process for the system migration.
Develop Windows scripts and VBA coding to improve process efficiency, automating the renaming and formatting of folders/files to maintain naming convention consistency. Additionally, implemented scripts to automatically generate log files documenting any changes made to the folders/files.
Collaborate with the Project Manager on a phased approach, starting with one office and expanding to other locations in preparation for the system migration.
Met with Office Managers and the Project Manager to facilitate effective communication and decision- making.
Possess a strong background in technical organization, adept at gathering requirements, and skilled in outreach and coordination at various hierarchical levels.
Demonstrate technical expertise in handling file server and Dropbox operations and conducting thorough validation procedures.
Instrumental in project success through keen attention to detail and precise coordination. GINA ROPER
Denver, CO 80207
Email: *****.*******@*****.***
ARPC – Air Reserve Personnel Center/DOD at Buckley Space Force Base (REMOTE) Aurora, Colorado Workforce Manager Analyst (Contract) 6/2019 7/2022
Designed, developed, and managed Tableau Workforce Management Reports and Data to support the operational needs of Directorates and Staff.
Implemented and maintained a variety of dashboards using Tableau Desktop and Server.
Automated the process for generating Promotion Board statistics, improving efficiency and accuracy.
Standardized existing data reports and created new reports to support improvement initiatives.
Improved processes through automation using SQL Server Management Studio (SSMS) and SQL queries, tables, stored procedures, MS Excel including pivot tables, formulas, vlookups, charts, and VBA coding.
Adhered to Agile methodology in project management.
Provided backup support to DPX DBA as needed.
Surgical Management Professionals (REMOTE) Denver, Colorado Sr Managed Care Analyst (Contract) 4/2018 10/2018
Conducted initial and renegotiation data/model analysis to inform business decisions.
Developed and managed Access, Excel, and SQL databases to track business performance.
Created periodic reports and ad hoc reports for claims data, provider data, and member data, and provided recommendations, as necessary.
Designed and maintained the Project Management spreadsheet to monitor progress and meet deadlines.
Responded to leadership's requests for ad hoc reporting and analyzed claims, provider, and utilization data to evaluate business performance.
Devised best practices and decision support tools to address business issues and translate requirements into actionable data.
Created and managed SharePoint sites for all facilities to improve collaboration and information sharing.
Provided support to AR Staff and assisted administrators with questions and projects as assigned by Administration.
Anadarko Petroleum Denver, Colorado
Data Analyst (Contract) 1/2017 11/2017
Designed, developed, and managed MS Access databases linked to SQL Server or Oracle through ODBC.
Built advanced Excel spreadsheets, including pivot tables, formulas, vlookups, charts, and VBA coding.
Automated processes and improved efficiency by writing VBA code and macros for MS Access and Excel.
Created user-friendly front-end interfaces for databases to streamline and automate processes.
Provided operational performance data through summary statistics in MS Excel.
Conducted user requirement analysis to guide database development and changes.
Utilized tools such as ANORM, Open Wells, TOAD Data Point, and Teradata to analyze data and make informed decisions.
Sabbatical 6/2015 12/2016
GINA ROPER
Denver, CO 80207
Email: *****.*******@*****.***
Anthem/WellPoint, Inc. (Remote) Denver, Colorado
Sr. Operations Business Information Analyst II 5/2008 5/2015
Developed and managed MS Access databases linked to SQL Server to analyze claims, utilization, provider data, and pharmacy POS data.
Utilized T-SQL to create stored procedures and provided operational performance data through MS Excel summary statistics.
Conducted user requirement analysis to guide database development and changes.
Generated claim detail invoices, summarized ineligible beneficiary invoices, and submitted data to CMS for outstanding claims.
Automated processes by creating user-friendly front-end interfaces for databases and writing VBA code and macros for MS Access and Excel.
Provided periodic reports, ad-hoc queries (SQL), ad-hoc reports, and Business Object reports for management.
Submitted necessary data to IT and provided process documentation and user training.
Made recommendations for tracking data and provided enrollment and claim data reports to executives and staff.
Familiar with Teradata SQL Assistant 12.0 & 13.10. Xcel Energy Denver, Colorado
Database/Report Developer, Contract 2/2008 3/2008
Designed and developed advanced Excel reports, including pivot tables, formulas, vlookups, charts, and VBA coding.
Automated Excel reports tracking and forecasting gas measurements through VBA code and macros.
Extracted data from SQL Server and populated Excel reports using VBA code, SQL, and stored procedures.
Provided user training and wrote documentation for new reports.
Conducted data analysis to inform business decisions. EDUCATION & TRAINING
Microsoft Certified Technical Education Center Denver, Colorado Programming a SQL Server 2000 Database, Certificate Received TEK Systems TEKnology Learning Labs Denver, Colorado Programming with Microsoft Visual Basic .NET, Certificate Received Oracle University Englewood, Colorado
Oracle 9i Intro to SQL, Oracle 9i DBA Fundamentals I & II, Certificate Received Oracle 9i Database Performance Tuning ed 1.1, Certificate Received Sybase Denver Learning Center Greenwood Village, Denver, Colorado Fast Track to Adaptive Server Enterprise, Certificate Received CCTI Denver, Colorado
Introduction to HTML, Advanced HTML, Certificate Received National American University Denver, Colorado
College Coursework
Contact this candidate