PROFESSIONAL SUMMARY

• Confidential is an experienced Information Technology professional in the Government, Insurance, Banking, Marketing, Health Care, and Hygiene Services industries. He has a broad-based skill set that includes Business Intelligence, Project Management, and Software Development. He has managed large and small projects covering many services including custom application development, network rollout, customer service help desk, technical help desk, computer and network operations and billing. Scott has developed custom e-Commerce websites and brochure-type websites.
• He is a highly effective technology professional who is innovative, profit-oriented, and performance-driven. Scott has strong leadership, management, problem solving, and customer-service traits. Scott is also effective at new strategy development and continuous improvement of current methods. He is an action person with a proven record of results. He adjusts to change easily and has outstanding communication and people skills.

SKILLS SUMMARY

Languages T-SQL 8 , DDL 8 , DML 8 , VB.NET 3 , VBA 3 , JavaScript 3 , VBScript 3 , HTML 3 , CSS 2 , COBOL 2 , JCL 2 , ALC 2 , CICS 1

Design Tools MS Visual Studio 2008 3 , MS Visual Studio 2005 4 , MS DTS 3 , MS SQL Server Integration Services 6 , MS SQL Server Management Studio 6 , MS SQL Server Reporting Services-2005/2008 6 , Macromedia Dreamweaver MX 2 , PaintShop Pro 2 , Photoshop 1 , Macromedia Flash MX E , Crystal Reports E , Microsoft SQL Server Analysis Services E , DataFlux E

Office Tools MS Word 12 , Excel 12 , MS Project 10 , PowerPoint 5 , MS FrontPage 3

Operating Systems MS Windows 3.1, 95, 98, ME, 2000, XP, 2003, Vista, 7, 8 15

Databases MS SQL Server 8 , MS Access 8 , VSAM 2 , MySQL 5

Servers MS IIS 5 , Active Server Pages ASP 5 , ASP.NET 3

ERP MS Dynamics GP v9.0 3

Professional Experience

Confidential

Position Title Sr. Database Developer

Tools Utilized MS SQL Server 2008, T-SQL

• Application Summary: Anti-Money Laundering Analysis
• Project Summary: Analyze bank data for Anti-Money Laundering activities
• Responsibility Summary: Develop ETL for approximately 60 data sources. Used BCP to load data. Data migrated to Analysis database using PFGs migration process. Design and develop Scorecard system for the clients. Created over 50 sets of criteria used to score each client.

Confidential

Position Title Sr. Consultant/Project Lead

Tools Utilized MS Word, MS Excel, MS PowerPoint, SQL Navigator

• Application Summary: iHub is a centralized data store for multiple systems of record SOR within the Wholesale Technology Group.
• Project Summary: Develop Business Requirement Definitions BRD to onboard SOR data and map that data to an integrated database.
• Responsibility Summary: Work with client partners and other consultants to develop, document, and train on the process to develop the BRDs. Lead consultants in designing the process and in developing BRDs.

Confidential

Position Title Sr. Database Developer

Tools Utilized MS SQL Server 2008, T-SQL, MS SSIS

• Application Summary: The CCA project gathers credit information from various sources in the bank into a centralized database.
• Project Summary: Develop a web-based application that collects information from multiple systems and consolidates that information to provide a complete view of client companies.
• Responsibility Summary: Work with Project Managers and team members to document and load ETL data from multiple source systems to one consolidated system.

Confidential

Position Title Sr. Database Developer

Tools Utilized MS SQL Server 2008, T-SQL, MS SSIS

• Application Summary: The GLUE application facilitates information sharing among Wells Fargo's ERP systems.
• Project Summary: Develop a web-based application that collects information from various ERP systems and consolidates that information for sharing with participating groups.
• Responsibility Summary: Work with Project Managers and team members to turn BRD specifications into the needed database objects, including SSIS packages, tables, indexes, views, and stored procedures.

Confidential

Position Title Sr. Database Developer

Tools Utilized MS SQL Server 2008, T-SQL

• Application Summary: Workflow tracking system.
• Project Summary: Develop a workflow tracking system used to determine if foreclosed mortgages were processed correctly.
• Responsibility Summary: Generate reports using complex queries. Analyze data to understand structure, anomalies, and errors. Report analysis findings to development team for correction. Use analysis findings to develop code that matches user requirements. Assist other reporting developers in understanding the data and writing better queries. Assist the application developers in writing the SQL needed for the application, including SELECTs, UPDATEs, INSERTs, table creation, trigger creation, etc.

Confidential

Position Title Sr. Database Developer

Tools Utilized MS SQL Server 2005, T-SQL, MS SQL Server Reporting Services 2008, MS SSIS

• Application Summary: The Metrics and Reporting team provides reports and data analysis to various departments in the Open Systems Server Delivery team.
• Project Summary: The Metrics and Reporting team uses Microsoft technology to implement their solutions.
• Responsibility Summary: Monitor jobs to ensure successful completion and troubleshoot and fix failed jobs when necessary. Work with Project Managers and team members to turn reporting requirements into production reports. Use complex expressions to calculate, group, filter, parameterize, and format the contents of reports. Develop stored procedures to extract and aggregate data for SSRS reports. Create new SSIS packages and jobs to extract and load data for new reports.

Confidential

Position Title Business Intelligence Developer

Tools Utilized MS SQL Server 2008 R2, T-SQL, MS SQL Server Integration Services, Microsoft SQL, Power Pivot,

Server Analysis Services

• Application Summary: Data Warehouse and Reporting using the Kimball Methodology for the data warehouse and Power Pivot for report presentation.
• Project Summary: Technekes provides a data warehouse for the USGA for its membership system.
• Responsibility Summary: Develop and enhance a data warehouse and associated reports used to manage and monitor the USGA's membership system. Work with the sales team and client to define reporting requirements and turn those requirements into production reports. Develop database objects, including stored procedures, views, functions, tables, and SSIS packages to extract, transform, load, and aggregate data for Power Pivot and ad-hoc reports.

Confidential

Position Title Lead Database/Reporting Developer

Tools Utilized MS SQL Server 2008, T-SQL, MS SQL Server Reporting Services 2008

• Application Summary: Data Warehouse and Reporting
• Project Summary: The Reporting Team develops and maintains a data warehouse and reports for Titanium's systems.
• Responsibility Summary: Lead the reporting team in developing and enhancing a data warehouse and associated reports used to manage and monitor client work. Work with the Business Project Management Office BPMO and end users to define reporting requirements and turn those requirements into production reports. Use complex expressions to calculate, group, filter, parameterize, and format the contents of reports. Develop database objects, including stored procedures, views, functions, and tables to extract and aggregate data for SSRS and ad-hoc reports.

Confidential

Position Title Consultant/Sr. Database Developer

Tools Utilized MS SQL Server 2005, T-SQL, MS SQL Server Reporting Services 2008

• Application Summary: The Smart Grid Systems team is responsible for the implementation of the Smart Grid for Duke Energy.
• Project Summary: This project tracks the rollout of AMI capable meters.
• Responsibility Summary: Work with business users and the project team to define reporting requirements and turn those requirements into production reports. Use complex expressions to calculate, group, filter, parameterize, and format the contents of reports. Develop stored procedures to extract and aggregate data for SSRS reports.

Confidential

Position Title Sr. Database Developer

Tools Utilized MS SQL Server 2005, T-SQL, MS SQL Server Reporting Services 2005, MS SSIS, MS Access

• Application Summary: The Metrics and Reporting team provides reports and data analysis to various departments in the Distributed Systems group.
• Project Summary: The Metrics and Reporting team used Microsoft technology to implement their solutions.
• Responsibility Summary: Converted the reporting database from SQL Server 2000 to SQL Server 2005, including all tables, views, stored procedures, functions, and jobs. Re-wrote the DTS packages in SSIS. Implemented new schemas, roles, and synonyms to facilitate security in the development and production databases. Monitor jobs to ensure successful completion and troubleshoot and fix failed jobs when necessary. Work with Project Managers and team members to turn reporting requirements into production reports. Use complex expressions to calculate, group, filter, parameterize, and format the contents of reports. Develop stored procedures to extract and aggregate data for SSRS reports. Create new SSIS packages and jobs to extract and load data for new reports.

Confidential

Position Title Sr. Database Developer

Tools Utilized MS SQL Server 2005, T-SQL, MS SQL Server Reporting Services 2005, MS SSIS, MS Access

• Application Summary: Technekes provides data-driven marketing programs, execute lead generation actions, qualify prospects, and implement customer relationship programs to maximize profitability for their customers.
• Project Summary: Technekes uses Microsoft technology to implement their solutions.
• Responsibility Summary: Work with Account Managers and Technical Leads to turn reporting requirements into production reports. Use complex expressions to calculate, group, filter, parameterize, and format the contents of reports. Develop stored procedures to extract and aggregate data for SSRS reports.

Confidential

Position Title Director of Information Systems

Tools Utilized MS Dynamics GP, Scribe, MS Dynamics Integration Manager, SQL Server 2000/2005, T-SQL, SQL Server Management Studio, HTML, ASP.Net, VBScript, MS Windows 2003, IIS 6, MS Project, MS Office

• Application Summary: Swisher Hygiene provides hygiene services to commercial facilities.
• Project Summary: Swisher implemented the Microsoft Dynamics GP Great Plains ERP system including Field Service, Purchasing, Inventory, AP, AR, GL, and Collections. Prior to the Dynamics GP implementation, Swisher utilized a custom windows application on a FoxPro database and a SQL Server based reporting portal to manage their business.
• Responsibility Summary: Planned, coded, and executed the conversion of customers, contracts, accounts receivables, and the item master from the legacy system to the MS Dynamics GP system. The conversion was handled using extensive MS SQL Stored Procedures, Scribe, and Integration Manager. Designed, developed, and implemented numerous reports using stored procedures and MS SSRS. Lead a team of developers, DBAs, and support desk professionals in the enhancement, testing, implementation, and support of the MS Dynamics GP system. Responsible for maintaining a series of DTS packages critical to the Swisher Reporting Portal. Tuned the DTS packages that resulted in a decrease in execution time from over 12 hours to 6 hours. Provided ad-hoc and new reports using stored procedures, user defined functions, and MS SSRS. Designed, developed, and implemented a website used to track sales to the national accounts customers large chains . This included a new SQL Server Database and an ASP.NET website written in VB.NET.

Confidential

Position Title Owner/Developer

Tools Utilized HTML, CSS, ASP, VBScript, JavaScript, MySQL, MS Access, MS Windows 2000, IIS 5/6, MS Project, PaintShop Pro, Photoshop, MS Office

• Application Summary: ClickAMemory.com provides a quick, easy, and cost-effective way for photographers and small businesses to display and sell their products online.
• Project Summary: ClickAMemory.com developed an online broker service allowing its customers to display and sell their products online. A customer can setup and customize their store within minutes. This service virtually eliminates the time and start-up costs associated with setting up an online store. Click-A-Memory also provides custom website development and hosting.
• Responsibility Summary: Web-based project using a standard development life cycle. Planned and executed the entire life cycle of the project including developing the Project Plan in MS Project designed, coded, tested, and implemented the solution and worked with customers and vendors. Also developed database-driven and brochure-type websites for clients and provided website hosting services. Developed the custom websites using ASP, HTML, CSS, JavaScript, and PaintShop Pro and Photoshop. Developed the database driven sites using JScript, ASP, MS Access, and MySQL.

Confidential

Position Title Partner/Developer

Tools Utilized HTML, CSS, ASP, VBScript, JavaScript, MS Access, MS Windows 2000, IIS 5, MS Project, PaintShop Pro, MS Office

• Application Summary: NewAirFilters.com provides residential and commercial customers with an easy way to order air filtration products online.
• Project Summary: NewAirFilters.com recognized an opportunity to provide customers with an easy, cost effective way to order air filtration products online. Many of NewAirFilters.com's products are not available in home improvement stores.
• Responsibility Summary: Web-based project using a standard development life cycle. Planned and executed the entire life cycle of the project including developing the Project Plan in MS Project. Evaluated, recommended, enhanced, implemented, and maintained an eCommerce package and company's website.