Phyllis Beam Email & Phone Number

Applications: Healthcare insurance brokerage, Quotit.com * Design and develop SSIS solutions to import and transform insurance carrier rates and benefits data. * Design and implement SSRS reports based on business user requirements. * Data Analytics group Team Leader assigned to develop Data Warehouse and Analytics solution. * Analyze databases to determine what data is needed for Data Analytics group. * Mentor and manage junior SQL developers for SSIS/SSRS development. * Created SSRS developer guide and trained other developers. * Demonstrated usage of SSRS reports to executives. * Develop SQL schema/stored procedure/triggers/functions for product enhancements or bug fixes. * Review code for co-worker’s changes and test as needed. * Develop enhancements to MS Access applications and provide a user guide document of changes. * Perform Production Release Manager duties and monitor SQL jobs.

Los Angeles, California, Us

Applications: Luxury electric/hybrid car manufacturer * Administer 60+ SQL servers – SQL 2005, SQL 2008, SQL 2008R2. * Administrator and design SharePoint company intranet site containing 20 department sites. * Design and develop SSIS packages for data transformation from car monitoring tool to database. * Automate SQL Backups and job notifications. * Develop reports using SSRS. * Design databases for car monitoring data. * Install and administer MS Project Server company-wide to track projects. * Install and develop BizTalk solutions to receive and send files to vendors. * Manage IT development project and coordinate resources. * Write User Guides for SharePoint site and Reporting Services.

Applications: Manufacturing Logistics and Repairs, Documentation Tracking, Trouble Reporting, Mission Data Tracking * Upgrade SQL 6.5 and SQL 2000(6.5 compatibility) to SQL 2005. * Convert legacy Lotus Notes and MS Access databases to SQL 2005 and ASP .net applications. * Convert legacy trouble ticket application data from Harvest and Clearquest to Serena TeamTrack. * Generate ETL solutions using SSIS for data conversions and workflow processing * Design logical and physical models for OLTP databases for new and converted applications. * Generate SQL Database maintenance plans for SQL nightly database backups and weekly database re-indexing. * Develop and maintain SQL objects for existing and new applications. * Monitor and optimize the performance of the database objects to ensure efficiently running applications. * Develop SQL server administration and SQL development standards. * Perform Project Manager role for SQL 2005 conversion and application conversion projects. * Develop application user requirements and applications design specifications for new and conversion applications. * Develop Test Plans and perform testing for new and existing applications.

Us

TECHNICAL DATA ARCHITECT 5/03-11/2007 Applications: Mortgage related * Design logical and physical models for OLTP databases. * Modify and update legacy database models to meet new and changing business requirements. * Develop and maintain views, stored procedures, functions and triggers for in-house applications and processes. * Manage and maintain database models documentation using Erwin Data Modeler. * Monitor and optimize the performance of the database objects to ensure efficiently running applications. * Generate DTS packages and SQL jobs to perform backend SQL processes. * Converted over 75+ in-house applications to new Single Sign On process. * Provided administrative support for Peoplesoft ERP servers. * Generate SQL Replication processes for data transfer to the ODS system. * Developed “Cool Crowd” website to promote department team spirit. * Developed Data Architect policies and procedures for SQL database objects. * Perform in depth analysis on database object changes to determine impact on other applications and processes. * Administer Cast impact analysis tool for SQL server analysis * Troubleshoot and research production support and development issues. * Maintain all code changes using VSS and Serena code management systems. * Supervise production support trouble ticket completion for Data Architect and Database Admin teams.DATABASE ADMINISTRATOR 11/2000-5/03 (see document for description)SENIOR SOFTWARE QUALITY ASSURANCE ENGINEER 3/99-11/2000 (see document for description).