SUMMARY:

• Superior data analysis and reporting skills with a background developing, maintaining and supporting business critical and compliance driven reports utilizing both SSIS and SSRS packages.
• In - depth understanding of SQL queries and SQL servers with a background designing, implementing, debugging, optimizing and maintaining SQL server databases and database objects.
• Skilled in collaborating with executives, vendors and development teams to monitor and enhance the capacity and performance of the database while ensuring reports are continuously tuned to meet acceptable system performance thresholds.

TECHNICAL SKILLS:

Technology and Tools: Windows 9x, XP, 7, 8 | Windows Server 2000, 2003 Enterprise x64, 2008 R2 | T-SQL | MS Office, Project, Exchange | Robocopy | XXCopy | Veritas Backup Exec | Active Directory | SharePoint | Crystal Reports | Visio | SQL 6.5, 2000, 2005, 2008 | MS Access 97, 2000, 2003 | Remote Desktop | VNC | DameWare | Citrix | VPN

New Horizons Computer Learning Center: Querying Microsoft SQL Server 2000 with Transact-SQL | Administering a Microsoft SQL Server 2000 Database | Programming a Microsoft SQL Server 2000 Database

Pragmatic Works: SSIS 2005 | SSRS 2008 | SSAS 2008

PROFESSIONAL EXPERIENCE:

Confidential - irvine, ca

Database administrator

Responsibilities:

• Designed numerous executive SSIS packages for measuring profits and detecting issues including:
• WIP report - Weekly loop through all location databases to compile a list of billing metrics.
• COD from JDE - Nightly report comparing JDE database of record against LIMS.
• BP KPI - Quarterly loop through select location databases to gather data and perform calculations based on contractual requirements from BP.
• Central Client Sales - Report run on the first day of each quarter, which aggregated sales across multiple locations based on client code.
• Monthly QC - Monthly report compiling manual corrections to test results and explanations, for select locations.
• LabDetailSalesByMethod - Monthly loop through all location databases to compile list of billing metrics.
• Lost Rush Revenue - Monthly loop through all location databases to collect a list of revenue missed due to missing ‘rush’ deadline on tests.
• LIMS to JDE - Quarterly report that compiled data that was missed by JDE accounting reports.
• Developed multiple SSIS packages that monitored a unified data layer and updated LIMS to indicate work file and test result availability from additional LIMS system. The process ran every 15 minutes during 17 hour period (6 AM - 11 PM MDT) to cover business hours across all US time zones. Also developed the Nashville Exxon quarterly contractual report. The report was put into an Excel file on the network, with a link to file and email and was sent to the Nashville lab director.
• Migrated 21 SQL servers to new domain to ensure a smooth technology integration following corporate acquisition.
• Moved 18 SQL databases from individual servers to a 64-bit cluster server. Applied transaction logs to bring up to date and reapplied transactional replication.

Confidential - anaheim, ca

Database administrator | integration engineer

Responsibilities:

• Project Manager on the full project life cycle for 7 large-scale security implementations. Researched and ordered parts for Engineering group, communicated with customers regarding project timeline and schedules and oversaw construction phase.
• Upgraded Boeing Access Control system consisting of O/S, database, application and hardware with zero business disruption. Selected to create a unique interface from HR system to SQL Access Control database. Created a system, which queried new employees and auto assigned card type, access level based on business rules and automatically invalidated access card upon employee termination
• Planned and directed the upgrade of the existing Disneyland Resort Access Control system. The implementation was completed within 60 hours with no issues or business interruption.

Confidential - anaheim, ca

Assistant manager - access control | project assistant

Responsibilities:

• Migrated 7 vendor systems into a centralized Access Control system. Project lead on transferring divisional hardware onto the new system for access to the resort, ride control rooms and administration buildings. Met with various lines of business to define business requirements and oversaw vendor throughout the installation. Ensured all new locations were set up with system, access levels and .
• Contributed to the interface between SAP and Access Control system. Collaborated with HR to implement business logic into auto assignment of access levels and privileges associated with ID card.
• Created a Microsoft Access distribution system to more effectively manage the annual parking distribution process. The Access database provided the ability to search employee status for quick and accurate distribution of parking stickers.
• Developed an Microsoft Access database which processed approximately 10,000 employees hired at off-site employment fairs. The database was integrated into the Access Control system for immediate ID card issuance.