Ernesto Arce Jr.

• Responsible for delivery of business intelligence (BI) information to the entire organization, including the collection and assessment of business requirements, technical specifications, and the subsequent development of data-centric solutions. • Developed and/or maintained reports, dashboards, data integration solutions (including ETL/ELT design and architecture), and database applications that support operational analytics reporting or data processes. • Performed complex data analysis, results interpretation, and report preparation of monthly contractual report deliverables and ad-hoc data requests. • Provided technical support for production systems. • Performed project management activities that include producing work breakdowns and task estimates (scoping and tracking activities). • Collected and translated business needs into business and system/technical requirements documentation. • Learned emerging technologies and systems of need for SOA PAX initiatives that benefit the California Health Care Options Project (CAHCO). • Recommend improvements to reporting methods, business processes, or data processes that would enhance data quality, process efficiency, or delivery of solutions. • Designed and implemented scalable, real-time data pipelines using SSIS, Azure Data Factory, Azure Synapse Analytics, or Databricks for Azure, processing 20 terabytes of data daily. • Migrated on-premises data warehouse to Microsoft Azure, reducing query times by 40% and storage costs by 30%. • Automated ETL workflows using Azure Data Factory, Azure Synapse Analytics, or Databricks, increasing efficiency and reducing manual intervention. • Collaborated with cross-functional teams to define data requirements, improving data accuracy and reporting capabilities. • Optimized existing data pipelines, improving performance by 45%.

Served as a Data Architect/Engineering consultant to the following companies. Kforce • Architected and optimized PostgreSQL databases for mission-critical applications, achieving 99.99% uptime. • Designed and implemented database schemas, ensuring high performance and scalability for transactional and analytical workloads. • Conducted performance tuning and query optimization, reducing execution times by 45% • Led database migration projects, including upgrading PostgreSQL versions and transitioning from other database platforms. • Established backup and disaster recovery strategies, minimizing data loss risks and reducing recovery times. • Collaborated with development teams to implement best practices for database design and query execution. Coretelligent • Provided guidance and technical oversight, brainstorm solutions, conduct architecture and design reviews to support internal teams as well as end clients. • Led the design of integrated solutions using Azure and Power Platform. • Served as subject-matter expert (SME) to assist projects on technical matters and address the needs of the client and other stakeholders • Maintained and managed knowledge bases for Platform Architecture, Solution Design, and key design decisions. • Presented technical solutions, guidance, governance and participated in architecture and design reviews. Kansys Staffing (Ferell Gas) • Designed and implemented end-to-end data warehouse solutions tailored to client needs, utilizing Snowflake, Oracle, SSIS. • Conducted data warehouse assessments and provided actionable recommendations to enhance performance and scalability. • Collaborated with stakeholders to identify business requirements and translate them into technical solutions. • Optimized ETL processes, reducing data processing times by 45%. • Ensured compliance with data governance and security standards across all projects.

• Serve as the Lead Data Warehouse Architect for FRCSW COE for corporate reporting. • Modeled in Kimball's methodology using the Project Lead's requirements. Design/modify logical and physical dimensional models using Erwin. • Prepare and document standards and procedures for dimensional data modeling and naming conventions. • Perform a variety of activities including data modeling and documentation, database design tasks and data and system analysis, data queries and database design tasks with a team with various skills. These efforts include, but not limited to, capturing and developing data requirements, database design support, data modeling interpretation, application design and prototyping solutions. Perform data modeling and subject matter support to ensure data specifications and requirements to meet long-term needs. This includes analyzing and defining data requirements and specifications. • Create data models using industry's best practices and standard processes to ensure high quality data to reduce redundancy and support efficient reporting. • Develop and maintain data standards, process documentation and templates that assist in a common understanding of data models and data marts and the processes that involve in developing them. • Support data standardization efforts including best practice standards, naming conventions, and synchronization of shared data requirements across subject areas throughout. • Work within the team to assist in the design of the overall ETL data warehouse architecture: Understanding of ETL strategy, staging databases and data quality. • Support database development including the build and maintenance of stored procedures and advanced SQL/PLSQL techniques. • Extensive working knowledge of current SAP Business Intelligence tools, Oracle SQL and PL/SQL and databases, Toad, Erwin, and Kimball Methodology.

The Bachelor of Science in Computer Science is designed to graduate a computer-science professional whose diverse practical and theoretical knowledge will guide the future of programming and networking in business and industry. Objectives of the program are to ensure competencies at complex levels of programming, network administration, database management, and client interface. Computer Science graduates are employed in entry-level to mid-level positions as software developers, network administrators, web developers, computer programmers, project managers, systems analysts, and future entrepreneurs.

This program of study is directed toward developing problem solving skills. In conjunction with the understanding of computers and computer systems, these skills will enable a graduate of the program to apply his or her knowledge to finding solutions to problems that arise in the science, business, industry, government, and education sectors. The objectives of the program are as follows: to provide a solid foundation of knowledge about computers and to facilitate thinking that will permit continuing growth on the part of the graduates. Graduates are employed in entry-level positions as web developers and as computer programmers.