Kenneth Brown Email & Phone Number

Danville, Ca, Us

Fairfield, California

• Responsible for design and development of processes for incremental load of data from production Enterprise Resource Planning and Warehouse Management System applications into a data mart which aggregates data from disparate applications (Apprise ERP) and (Manhattan WMS) and database environments (Progress and DB2 iSeries (AS400)).• Revised design offers considerable reduction in the size of the code base and significant reduction in the time required to perform data extracts. Data extracts can now be performed in one quarter of the time previously required.• Development of a common, shared, Power BI data model which will be the common focus of reporting for new BI reports and dashboards.• Design, development and implementation of operational reporting to ensure consistency between the production ERP and WMS applications.• Current efforts require extensive, hands-on, development using: SSIS, TSQL, Powershell, C# and PowerBI.• Developed numerous Power BI-based reports supporting financial and operational reporting requirements.

San Ramon, Ca

General DutiesDesign, development and management of telecom industry applications, including:• Evaluation and assessment of work requests,• Trouble-shooting of issues and participation in outage resolution,• Coordination between DBAs, operations, offshore development & testing resources, ATT clients, and interfacing applications,• Development of functional and technical designs for development efforts,• Development of ETL packages (SQL Server 2000 DTS through SQL Server 2014 SSIS),• Management and administrative activities, including security audit responses, status reporting, maintenance/upgrade scheduling, etc.Data Warehousing Design & DevelopmentWorking with business and IT personnel, designed, developed and implemented data warehouses for management and operational reporting of wireless phone ordering ‘fallout’. Data extract, transformation and load (ETL) used SQL Server Integration Services (SSIS). Reporting used QlikView and NPRINTING.Architect for AT&T’s mission critical Enterprise Offer Management (EOM) system used to generate customer offers and track offer acceptance/rejection data for all residential wireline customers across the US. In addition to the general duties outlined above, responsible for the extension of EOM to the Southeastern US and implementation of ‘Dynamic Discovery Questions’ (DDQ) to dynamically generate questions during customer contact and obtain additional customer information to improve the quality of offers extended and the offer acceptance rate. Designed and developed a prototype to clarify business requirements and as proof of concept. The prototype was developed using Infor, JavaScript, SQL*Server stored procedures, SSIS packages and database modifications.Based on the prototype’s accepted functionality, documented high-level design and technical requirements for off-shore development and testing staffs’ efforts. Managed DDQ development through user acceptance testing and managed production implementation.

San Ramon, Ca

Developer, architect and lead of a “Quick Hits” team developing numerous business applications for AT&T’s business offices. Documented existing business processes and business requirements. Produced high-level application and database designs and then managed application development in an Agile-style - highlighted by multiple, phased, releases. Developed backend ETL processes supporting scheduled and on-demand processing. Applications developed include:• Third Party Verification – A work-flow application for third-party verification of customer account changes as required per FCC mandate.• End User Returns – A work-flow application to automate the return of wireline customers from other carriers to ATT. • BOSS Commitment & PiN Tracking – A work-flow application to supplement ATT’s Billing Online Support System by tracking and managing work-flow transactions issued by ATT service representatives.• Dish & Cingular Fallout – A work-flow application to track and manage errors in AT&T’s satellite TV and wireless telephony ordering processes.Above applications developed in Visual Basic/SQL*Server/Cold Fusion/SSIS or Java/Oracle/Struts/SSIS.Led efforts to port numerous Microsoft SQL Server DTS packages to SSIS. Provided technical and management oversight to offshore resources and performed DTS-to-SSIS migration and testing of numerous packages.

San Francisco, Ca

Responsible for vendor/budget management and oversight of hardware and ordering/delivery applications for Yellow and White Pages distribution throughout California and Nevada. Responsible for system Y2K compliance. Member of Executive Steering Committee responsible for Local Exchange Competition.

San Francisco, Ca

Worked as an analyst supporting technical auditing of business financial systems with primary emphasis on telecommunications billing systems, including direct billing and invoice-ready billing services.

Redding, Ca

Application developer supporting the resource management, GIS and inventory systems for this large landowner.