Nasser Mansour Email & Phone Number

Los Angeles, Ca, Us

Pasadena, California, Us

Santa Monica, California, Us

♦ Migrated AWS EC2 SQL Server 2017 Enterprise instance to GCP CE instance.♦ Managed AWS S3 Buckets and EBS storage.♦ Provisioned AWS EC2 and GCP Compute Engine instances.♦ Created BigQuery Javascript UDFs to parse nested JSON data.♦ Created powershell scripts to backup SQL Server databases to and restore from AWS S3 bucket.♦ Worked with the network engineering team to establish site-to-site VPN tunnel between AWS and GCP clouds and validated connectivity.♦ Experienced in connecting to SAP S4 Hana via ODBC for queries and extracts

Santa Monica, California, Us

♦ Developed SSIS custom C# script components to transfer JSON data from RESTful sources such as Square, Narvar, and Zendesk for consumption into SQL Server data warehouse.♦ Managed AWS DMS to support real-time data streaming.♦ Managed AWS EC2 instance as part of a team in support of data warehouse environment.♦ Setup and managed SQL Server database maintenance jobs (MS Tiger Tools).♦ Facilitated migration of BI related code to GitHub.♦ Assisted data team with support and performance optimization for Looker reporting platform.

Camarillo, Ca, Us

Advancing through progressively responsibilities and positions, my 16-year information technology (IT) tenure has led to enterprise-wide content management system (CMS), document management, imaging, and workflow platform analysis, development, configuration, testing, implementation, and administration initiatives. By collaborating with campus-wide subject-matter experts (SME), we align enterprise solutions with administrative and academic requirements, while also partnering with production support teams to identify and resolve system issues. Key Accomplishments:♦ Established comprehensive system testing methodologies, strategies, and plans.♦ Defined end-to-end technical standards, procedures, and documentation for enterprise systems.

Camarillo, Ca, Us

I was selected to hold accountability for enterprise data warehouse (DW)—Blackboard Analytics running SQL Server ’14, entailing:♦ Managing custom data model♦ Configuring permissions ♦ Monitoring ETL processes ♦ Synchronizing DW testing / production environments♦ Performing OLTP / OLAP database backupsKey Accomplishments:♦ Provisioned and managed SQL Server 2014 Enterprise Edition and Tableau Server 10.3.♦ Served as BI SME for all phases of system analysis, design, development, testing, implementation, and administration.♦ Championed adoption of campus BI platform and managed end-to-end implementation.♦ Hand-picked to serve in technical resource and administration role for campus data governance initiative.

Camarillo, Ca, Us

I held accountability for SQL Server instances and 100+ enterprise databases, including configuration, administration, monitoring, upgrade / migration, and backup / recovery functions. The wide scope of my day included:♦ Tuning and optimizing indexes and storage capacity for top performance. ♦ Overseeing test and production environments, including synchronization of schema / data changes. ♦ Utilizing Microsoft SCOM, Red Gate SQL Monitor, and SSMS. ♦ Managing Track It! service request system.Key Accomplishments:♦ Seamlessly implemented 3 SQL Server ’08 Enterprise fail-over clusters for enterprise applications and deployed SQL Server ’12 high-availability (HA) group fail-over cluster instance for private cloud, ensuring web application availability and fault tolerance for myCI portal applications. ♦ Selected to lead technical aspects of campus smartcard / magstripe technology development, integration, and implementation initiative, including related Blackboard Transact System efforts.♦ Utilized SSIS to develop complex ETL packages enabling system integration and process automation.♦ Established best-practice transactional replication and log shipping processes. ♦ Enabled departmental phone charge-backs through development of phone billing application in ASP.NET / MVC.♦ Created T-SQL and PL/SQL stored procedures to support information / query requests and leveraged SSRS / Visual Studio to produce customer reports.♦ Launched and administered Blackboard Connect emergency notification system.♦ Migrated from SharePoint ’07 to ’13, orchestrating all installation, configuration, and content migration.

Camarillo, Ca, Us

Administered SQL Server databases for COTS applications and played integral support role during PeopleSoft Financials / Human Resource Management (HRM) upgrade, working in TOAD, Oracle, PeopleTools, and Data Mover.

Camarillo, Ca, Us

Directed computer support team responsible for 1.3K client computers and distributed peripheral devices; managed Active Directory domain for all classrooms / labs.Key Accomplishments:♦ Defined AD group policies and established automated software deployment processes.♦ Spearheaded analysis, design, and implementation of print and copy billing software, Pharos Off-the-Glass and Uni-Print.

Camarillo, Ca, Us

Provided technical support for hardware and software related issues. Specializing in Dell desktop and laptop hardware.Configured and managed Windows Server 2003 and OSX Servers for campus lab file and print services.Researched and issued recommendations for the design and installation of audio/video equipment and LCD projector systems for classrooms and computer labs.

Los Angeles, Ca, Us

Installed, diagnosed, and repaired Dell/Apple desktop/laptop systems and software.Created custom bootable CD-ROM to repartition and diagnose hard disk errors, read NTFS4 and 5 file systems via DOS.Migrated NT4 workstations from Novell Netware 4 to NT Domain.Created University-wide naming convention for computer and printing equipment.

Master Of Science (Ms), Information Technology

Bachelors, Computer Information Systems