Brook Bennett Email & Phone Number

Dallas, Texas, Us

SQL Server 2012routine ETL to/from Oracle, Netezza, DB2Create and maintain countless scripts for SSRS reports, SSIS packages and ETLMaintenance and optimization of databases, including adding new fields, tables and indexes as, and optimization to conform to normalization standardsStored procedure creation, including procedures that send e-mails based on conditional rules using STMP; maintenance and optimization of stored procedures for increased accuracy, efficient run time, and reformatting of SQL to conform to standardsJob creation, alteration, monitoring and scheduling for routine execution of SSIS packages and stored proceduresNetezzaScripting for reporting and data extractSSRS reportsCreation, alteration, optimization, and maintenance of numerous complex customized reports for distribution to senior management and clientsDynamic report distribution to targeted audience depending on management levelSSISPackages for ETL to/from raw files, DB2, OracleExcelDynamic complex linked pivot tables with slicersOLAP cubes

Irvine, Ca, Us

• Joined the BI team June 2011, working with Oracle BPM and JBoss• Create, design, implement and maintain SQL Server 2005 (and 2008) databases, stored procedures, views, triggers, jobs, and SSIS/DTS packages, including scheduled data transfers to/from Oracle and queries in Oracle, SSRS reporting• Create, design, implement and maintain programs created in MS Access linked to SQL Server and upsize existing Access databases to SQL Server and/or MySQL• Optimization, customization, and enhancement of existing databases, queries, procedures, and MS Access programs• Meet with upper management and executive teams for detailed project requests and act as an expert to provide information regarding existing MS Access program systems and SQL Server databases used by more than 1000 employees in the US and India• Some advanced data scrubbing and reporting from SQL Server, MySQL, Oracle, MS Access, and DB2

• Alteration and creation of large flat files for barcodes, or encoding for magnetic stripes for gift cards and calling cards for several large companies (Including Macy’s, Nordstrom, Chili’s, Red Robin)• Create new software in VB with ADO.NET linked to MS Access to facilitate conversion of data files received for card encoding and printing equipment• Design card barcode layout to conform to card design using card creation software and wasp labeler• Produce layout templates for various types of large printing equipment to align barcodes accurately for pre-printed uncut sheets

Bachelor Of Science (B.S.), Math

Computer Science

Computer Science

Ba, Spanish