Data Analytics Analyst

Marjorie Miranda

Highlands Ranch, CO 720-***-****

Sr. Data Analytics Specialist Data Modeling Data Visualization Reporting

Senior IT Professional bringing multifaceted Data skills specializing in data analysis, and model design. Expertise spans across critical industries such as Sales, Financial Services, Telecom and Mortgage. Demonstrated exceptional ability to manage and interpret complex data systems, OLTP, OLAP, ETL, ELT, with a keen focus on the comprehensive lifecycle from data gathering and analysis to reporting. Adept, methodical approach ensures meticulous attention to detail, while leadership in cross-functional teams highlights capacity to drive continuous improvement through strategic insights and robust technological solutions.

AREAS OF EXPERTISE

Professional

Collaborative Consultative Cross-Functional Communication Leader/Coach Flexible Clear Written/Verbal Communication Manage Competing Priorities Critical Thinking/Problem-Solving Meticulous Attention-to-Detail Solid Work Ethic/Character/Integrity Contracting/Freelance

PROFESSIONAL EXPERIENCE

Sr. Financial Analytics and Reports Specialist Nov 2023 – Present

Development of Analytics and Visualization Reports utilizing Oracle Enterprise Manager

Development of Oracle Enterprise Manager Dashboards and Reports

Sr. Data Analytics and Integration Specialist Apr 2022 – Sep 2023

Charles Schwab Lone Tree CO

Analyzed, modeled, data mapped, developed data migration documents from a Data Warehouse to Salesforce for data transformation and analysis projects in MS Project

Converted legacy Informatica data mappings to facilitate data migration to IICS in a cloud environment

Migrated data to QA/UAT environments utilizing Oracle analytic views and functions to support QA testing

Conducted unit testing and debugging of Source Qualifier analytics functions to help QA

Sr. Data Analyst and XML Analyst Feb 2019 – Apr 2022

Empower Retirement Greenwood Village, CO

Documented full software development life cycle (SDLC), gathered requirements, design, map data, analyze data, in PowerPoint

Queried Oracle Data Views and XML files for the Data Lake, converted data for data cleansing and analysis

Designed and documented Database Objects and code for data normalization and modeling

Sr. Oracle Data and Systems Performance Engineer Jan 2018 – Feb 2019

Raymond James Financial Centennial, CO

Completed data requirements, data analysis, data modeling, data mapping of Oracle Data Integrator processes

For an ELT Financial Trading Data Warehouse/company-wide data store in Agile Cloud environment using multiple computer instances

Queried Linux, Perl scripts to validate and modify combined data files for data transformation and migration

Maintained inter-departmental data structures in an Integrated Cloud environment

Performed data modeling utilizing Erwin; reverse engineered of data for data mapping for analysis

Sr. Data Analyst Telecommunications Sep 2016 – Dec 2018

RevGen Partners Consulting Firm Charter Communications - Englewood, CO

Managed data mapping and analyzed data for statistical evaluations and reporting of Charter Communication’s data

Conducted data mapping, data analysis, cleansed data models and data flow mappings for Oppenheimer Farms

Designed and documented systems and data flow for Janus Henderson Investors

Sr. Data Warehouse Engineer & Data Modeler Sep 2014 – Apr 2016

Bank of America New York, NY

Managed data modeling, mapping, analysis, and report development of database and web Security/Background Screening System

Identify trends and insights utilizing batch commands, Rally with JIRA Agile Methodology to extract deeper knowledge and make predictions.

Analyzed data across multiple database systems for data cleansing and design of topology for star schema

Mapped MongoDB classes, XSDs, JSON, and database data type conversions for data integration

Modeled and documented data mappings that use advanced statistical and ML techniques

Troubleshoot data design to analyzed metadata and document legacy systems

Sr. Data Warehouse Engineer and JIRA Release Lead Apr 2009 – Oct 2014

Credit Suisse New York, NY

Supervised weekly database releases to production environments as Scrum master and Release Lead and coordinated batch process setup and monitoring and report to stakeholders results

Managed data deliverables and models for the Corporate Treasury/Financial System data warehouse

Enhanced and improved data mart modules deliverables

Analyzed complex data mapping for data transformation and data re-classification

Analyzed XML scripts for Control-M Tool and documented process in Excel and PowerPoint

Responsible for the trouble shooting and documentation of production data issues in Confluence

Responsible for the data design of cubes and hierarchy models for the data warehouse file processing

HP Archiving Project Monitoring, Storage and Reporting Feb 2006 – Feb 2009

GE Capital Treasury Stamford, CT

Spearheaded design, modeling of financial monitoring systems with Oracle Enterprise Manager Grid Control 10g Dashboard and Visualization

Enhanced data management and performance dashboards for critical applications such as Bancware, Wall Street Systems and GE Treasury CMS data warehouse

Led analysis, modeling, cleansing and documenting of ETL data transformation metrics

Managed Grid Control Visualization tool for databases storage and systems configurations

Facilitated specialized training on analysis and diagnostics HP tools

Designed and developed automatic reports for HP Archiving

EDUCATION CERTIFICATIONS PROFESSIONAL DEVELOPMENT

Degree: Bachelor’s degree in Business Banking University of Bridgeport CT

Certifications:

Scrum Master Accredited Certification Scrum Institute

Professional Development:

Google Cybersecurity Foundations Course

ChatGPT Prompt Engineering for Analysis

Oracle Cloud Infrastructure Generative AI Professional Prompting

Oracle OCI Cloud Associate, Oracle

Oracle Enterprise Manager 10g Reporting & Dashboard Oracle University

Contact this candidate