Mo Norasti

Master's

Computer Science

ThoughtFocus

Senior Engineer

- Working at ThoughtfFocus for multiple projects as Senior Engineer lead. Some of the projects are for California State University (CSU). CSU is a public university system in California with 23 campuses and eight off-campus centers enrolling 484,300 students with 26,858 faculty and 25,305 staff. CSU is the largest four-year public university system in the United States. Working as a Business Analyst with multiple campuses, California State University Fullerton, Dominguez Hills, San Bernardino, San Jose State University, Calstate LA, and - Work with project managers, establish and manage the software development lifecycle (SDLC) for IT - May develop work plan timelines and manage workflows to meet project timeframes - Develop or assist project managers in developing implementation plans, including the scheduling of project milestones - Meet most of the milestones ahead of time based on the project plan - Work with users and the development team to propose and develop technical solutions to business challenges - Follow all project management framework standards, procedures, and documentation - Contribute to Change Management process improvement initiatives - Experience in requirement gathering, POC (proof of concept), design, development, Testing, and Implemented Data Warehouse projects inclusive of cube build - Work closely with clients, business users, the testing team, and the technical team to analyze the technical constraints, issues, and risks - Build templates and dashboard for customized views of the data specific to each group and line of business - Incorporate and unify my team's member's daily tasks to satisfy the deliverables - Support and maintain the project 24 by 7 and 7 days per week - Good Understanding of ODI Navigators like Designer, Topology, Operator, and Security Navigator - Good experience in Deploying Scenarios from one environment to another environment - Extensive experience in developing load plans, packages, and scheduling - Resolve issues and bug fixes to make sure daily loads run efficiently - Develop several Interfaces, Packages, Procedures, and Scenarios in ODI to convert legacy system jobs in Data Stage to ODI for extracting, cleansing, loading, transforming, and integrating data into the data warehouse - Design and Develop IBM Data stage Jobs to Extract data from heterogeneous sources, apply to transform logic to extract data, and Loaded into Data Warehouse Databases - Strong SQL, PL/SQL, ETL/ELT knowledge - Work on Peoplesoft objects to build the warehouse - Develop Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL to move the change data across multiple environments using DB links - Data warehouse design-multi-dimensional modeling for Subject areas such a Facts/Dimensions/Aggregates tables - Perform Installation and configuration of Oracle Business Intelligence Enterprise Edition 12c - Configure security settings (groups, roles, access/query/report privileges) and scheduling - Upgrade OBIEE 11g content (RPD and Catalog) to OBIEE 12c - Develop dimensional modeling for new and modified star schemas - Experienced with best practices of creating a physical, business model and presentation layers in OBIA SIA, HR, and Finance model - Develop reports with OBIEE for dashboards in various subject areas - Design and developing of reports/charts/dashboards/ based on requirements - Create Data and Object-level Security to facilitate the right access to the right users - Develop the jobs at the server level and agents to clear the OBIEE cache - Extensively use the multi-user environment for development and version control - Build, and publish customized interactive reports and dashboards, report scheduling using the Power BI server - Work on the administrative side to resolve the OBIEE server issues - Implement the Procurement and Spend analytics out of the box model and customization and fine-tune the data extraction - Developing queries in Google Cloud Platform Bigquery to feed the data sources in Power BI - Develop reports with Oracle Visual Analyzer - Create data set based on user requirements in Oracle Visual Analyzer - Convert legacy systems to new enhanced model (Oracle Visual Analyzer - Create test cases for various reports - Test developed reports and found out the problems and anomalies in report data - Real-time analytics dashboard - Work on different tool stacks in GCP to get data from Peoplesoft source and load it into Cloud Storage and display data in Power BI - Work on different tool stacks in AWS to get data from Peoplesoft source and load it into S3 buckets and analyze in Athena - Develop the PBCS package and automate the process to publish the output to the Cloud