joshua mubia

Involved in solution scoping sessions to gather requirements, translating business needs into Data Warehouse designs. Conducted data profiling and analysis using Teradata SQL Analyzer, designed logical and physical data models, and oversaw data transformation processes.

Engaged with clients to gather requirements, performed data analysis across multiple sources, and designed dimensional models. Created logical models and documentation, resolved data inconsistencies, and coordinated with DBAs for implementation.

Led data analysis and modeling efforts, translating business requirements into data designs. Developed logical and physical data models, conducted testing, and maintained existing applications while ensuring data accuracy and performance tuning.

Interacted with business users to gather requirements and performed reverse engineering for data marts. Designed conceptual, logical, and physical data models, ensuring adherence to data naming conventions and standards.

Involved in Initial solution scoping sessions with stakeholders to gather and understand requirements. Performed Data Profiling and Data Analysis on source data using Teradata SQL Analyzer. Designed and reviewed logical and physical data models for OLTP and OLAP in compliance with corporate standards.

Involved in interactions with Subject Matter Expert, Project Manager, Developers, and the end-users in various JAD sessions to gather requirements. Developed Business and Subject Area Logical Data Models, Physical Data Models, and Data Flow Diagrams. Extensively used Erwin to design Logical/Physical Data Models and wrote SQL Queries to profile databases.

Interacted with clients to gather requirements in JAD sessions. Performed Data Analysis and generated various reports. Designed a STAR schema for sales data and created Logical Models while documenting all entities and attributes.

Interacted with business users to gather requirements in JAD sessions. Designed and developed Conceptual, Logical, and Physical Data Models to meet reporting needs. Managed the flow of information between departments through relational databases.