Scott D. Banister
9625 Mission Gorge Rd
Santee, CA. 92020
[Send email to request phone number] 69.8419
Scott_Banister@yahoo.com
Education:
University of Washington
BS in Electrical Engineering
Professional
Summary:
Over 15 years of IT experience with a strong background in business analysis and
development utilizing SQL Server 2005 in both OLTP and OLAP environments. Adept
at interfacing with end users to gather requirements and produce functional
requirements.
Technical
Summary:
Development Tools: Microsoft SQL Server 4.21 – 2005 including SSIS, SSRS, SSAS,
Visual Basic.net, C#, ASP.NET 2.0, Crystal Reports, MS Access, Microsoft Visual
Basic 6, Erwin Database Modeling
Software Development Methodologies and Techniques: Agile, SCRUM, SDLC Processes,
use cases, context flow diagrams, database normalization, user interface design
and usability, UML.
Experience:
June 2009 Cal Pass
To Current San Diego, CA
SENIOR ETL DEVELOPER
• Responsible for the design and implementation of SSIS ETL packages to load
student information from California’s K-12 school systems.
• System loads 250M student grade records from various school districts and
places the data into a dimensional model
May 2008 Otay Water District
To September 2008 San Diego, CA
PROJECT MANAGER
• Responsible for requirements gathering, interfaced with members of various
functional units, including creating a user needs and requirements document and
functional specification.
• Responsible for the design, development, and integration of the district’s
automated meter reading system.
• Built SSIS packages for the ETL to move data between the hand wand system to
the district’s ERP package and billing system.
• Built and designed the integration between the District’s back office system,
Eden, and the district’s bill print and web hosting vendor.
• Developed SSIS packages to manipulate the XML from the ERP vendor to the web
hosting vendor.
• Met with end users and business owners to gather requirements for new reports,
and enhancements to existing reports in SSRS and converted some legacy Crystal
Reports to SSRS.
• Conducted data research to answer end-user inquires to verify reports.
January 2007 Union Bank
To April 2008 San Diego, CA
SENIOR BI CONSULTANT
• Responsible for requirements gathering, and user needs analysis for
integrating the GL data into Union Bank’s warehouse.
• Worked with various financial groups in the organization, on security issues
for the data.
• Worked on Mpower, the Bank’s retail data warehouse. It is 7TB of data, and is
reported to be in the top 20 databases by size in the world.
• Developed SQL stored procedures for ETL jobs. The system loads data from 100
other systems, and presents Union Bank’s management with a complete drill down to
almost all of the bank’s transactional data.
• Designed and implemented tables in this system with hundreds of millions of
rows. Experienced in issues associated with VLDBs.
• Built stored procedures to load and transform data from various systems into
the Mpower database.
• Responsible for system analysis and design for several payroll bonus reports
using SSRS in SQL Server.
• Was responsible for the overall architecture for SSIS and how it was
implemented in ETL jobs.
• Produced ad-hoc queries and data analysis on cubes built in SSAS.
January 2000 GF Capital Advisors
To December 2006 Phoenix, Arizona
PROJECT MANAGER
• System architect of their investment analysis system with five team members
reporting to me.
• Designed, developed, and architected the DW/BI solution from the ground up.
• Managed a staff of developers, testers, and business analysts.
• The system takes in stock market price and fundamental data, and produces
complex studies on trading ideas.
• Assisted traders to create complex data jobs to back test their investing
ideas.
• System performs over 1,000 custom stored procedures a night. A complex batch
structure exists in SQL Server Integration Services to load its data.
January 1999 Arizona Public Service
To December 1999 Phoenix, AZ
SR. SQL DEVELOPER
• Technical lead on Oasis, the power control and reservation system for Arizona
Public Service. Oasis controls Arizona’s transmission level power grid system.
It plans and reserves line space between the major electrical producers and
utilities.
• Developed its Audit system, capacity constraints, and its power planning
system exports.
• Wrote custom stored procedures to implement the inherent complex logic in the
system.
1998 Intel
Chandler, Arizona
SYSTEM ARCHITECT
• Worked on the Caps system. It is a MRP type planning system specific to
Intel’s manufacturing needs.
• Technical system architect. I oversaw a development team of 5 developers.
• Development was a 3 tier application using MTS 2.0 in the middle tier.
• Development lead and System Architect bringing best practice information on
n-tier development to their IT group.
1993 Microsoft
Redmond, Washington
Senior Developer
• Project MsProduct: MsProduct is a large scale OLTP application and it is the
central repository of product manufacturing and SKU information at Microsoft.
• Dev lead for the pricing subsystems with 3 developers reporting to me.
• Overall coding standards, code reviews, as well as technological direction.
• Project msBudget BWB is Microsoft’s worldwide budgeting tool and is used to
set Microsoft’s budget for the next year. It is a series of approximately 50
screens that Microsoft’s management uses to enter expected revenue and expenses
for the next fiscal year.
• Built and designed the ETL both to and from SAP R/3 using BCP.
• Designed and planned the system’s concurrency issues. It has over 5000 users
and an average of 500 concurrent users during the budgeting season.
• Worked on extending the system’s complex application topology that uses
replication to several area servers around the world, and consolidates
transactions to a data warehouse in Redmond.
• Responsible for front end development for the 1999 Fiscal year using VB 6.0.
• Responsible for the design and implementation of automating the costing of
telephone support to the various product units.
• Project Dup Remover: Duplicate remover is an application that sweeps
Microsoft’s Beta ordering system, looking and repairing duplicate shipping
information.
• Dup Remover’s saved approximately 150 CD kits per day from being shipped
redundantly.
• Responsible for coding, development, and test.
• Worked with end users for usability, and business requirements.
|
