Donald G. McClary
Resume 03/09/2012
ph 630.853.5834
dmcclary60@gmail.com
Objective
Business Intelligence, Data Warehouse, Data Architect, SQL Server, MS Access, Reporting, VBA, Quality Assurance
Qualified By
· Over 23 years of operational experience in several industries with 13 years of Technical Infrastructure Development for business focused on Operations, Accounting, Marketing and Sales.
· ETL - Key role in bridging systems and centralizing data flows from multiple platforms during transitions from Acquisition Mergers and Buyouts. Excel, Access, Oracle, AS/400, Flat files, etc.
· Requirement gathering with responsibilities working with business units to define the audience and provide solutions for business logic, financial analysis, audits, call center support, account management systems, customer retention profiling and trending analysis, SLA reporting and presentation, scheduled automation. Life cycle program development, testing and implementation.
· Relational Database Developer - SQL architect experienced with DDL, views, triggers, stored procedures, DTS packages and scheduled jobs for maintenance, T-SQL, and reporting. User administration and security role planning and development.
· 11 years Enterprise Client Server Application Development in MS Access using ODBC data linking to Oracle, Sharepoint, SQL and AS400. VB, VBA development and scripting automation.
· 3 years Internet/Intranet client server development and enhancement with ASP.NET, VB.NET, HTML, XML and Java Scripting, 2.0 .NET framework.
· Tools/systems: SSMS, Visual Studio, BIDS, SSIS, SSAS, SSRS, MS Access, MS Office and MS Project, Sharepoint, Corel Draw, Photoshop,
Experience
Current:
ñ Studying for MCTS certification 70-448 Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Blog- http://70448mcts.blogspot.com/
ñ Gorilla Style Custom Apparel – Chicago, IL. Urban Custom Apparel, Signage and Banner Shop. Setting up web based storefront for e commerce. Visual Studio express 2011, Corel Photo paint, CSS, XML and HTML. Project start 10/12/2001. Using Volution hosting. Current demo at www.gorillastylecustom.com .
ñ Doing Click through work flow analysis. Examining css, image file and javascript structure for. Training on the Voultion 2011 store front management system. Inventory, content, marketing, tracking and dashboard systems.
ñ Home of Our Own – WSFC (West Suburban Fellowship Club) – Naperville, IL. Effort to raise funds to purchase club property. Designed custom database in MS Access to manage pledges, accounting, monthly mailings, goals, progress tracking and reporting. Import tracking history data from excel. MS Access, VBA, Excel
6/2008- 2/2010 Keylimetie, LLC. Downers Grove, IL. .Net web development and web hosting outsource company. Client representative for Auto Club Group AAA (Covering 6 states in the Midwest) Managed style and functional integration of legacy applications and pages to roll out of new website. Managed client monthly email campaigns, Quality Assurance for appearance and functionality in client's website. Internal processes. Tools/Systems: MS Visual Studio, MS Access 2007, Sharepoint, FileZilla, Photoshop, MS Office; Imacros, CSS, HTML, ASP.NET, JavaScript, VB, VBA, HTTP headers, fire bug. Major Accomplishments
· Managed work flow, automation system, deployment packages and execution of changeover launch for client's new website to integrate with national products and 3rd party vendors. Created automation using a combination of Imacros and MS access to load 1,000's of domain pointer changes in seconds into national's client management interface.
· CSS restyling to match existing and on going national products and travel booking apps to new site.
· Assisted in debugging 3rd party code in new site for functional and security failures using HTTP headers.
· Helped to develop process and standards in Quality Assurance for appearance and functional testing in various clients’ websites across major browsers Firefox, IE, Safari, etc.
· Updated content on various clients’ sites as needed. Identified and scoped out visual and functional weaknesses in client's sites as requested.
· Developed process, templates, assembly and QA for monthly membership HTML email campaigns across 6 states.
· Co authored functional specification and use case for the development of an in house client defect tracking system. It was an option to replace Sharepoint witch was our customer portal and project/defect management system at the time.
7/2005-11/2007 Shared Technology Inc. / United Asset Corporation. Naperville, IL Texas based with office in Naperville, IL. Telecom Maintenance Company System Support Engineer Data Architect. Develop mission critical applications for call center, finance and customer support. Main system is Oracle: primary focus managing data that doesn’t fit anywhere else and centralizing all major platforms to a SQL warehouse for data mart applications. Manager of a lean team of support people and contractors. With UAC report directly to COO. Bought out by STI 2/2007 reporting directly to VP of IT. Tools/Systems: MS Access, ODBC, DAO, SQL2000; views, triggers, DTS packages, scripting, DDL, ASP.NET, Windows Server 2000, VB, VBA, MS Office, Visual Studio.NET 2005, MS Project, Symposium, Unix, Remedy. Major Accomplishments
· Conceived, designed and built a multi-functional centralized operational data warehouse in SQL 2000 dubbed the HUB. The HUB is the backbone for several major service applications and stores. Stored Procedures, DTS, Views.
· Client Profiles MS Access, SQL Server: site contacts, special procedures, vendor contact list, contract and service entitlements, site equipment, PBX and modem info. Daily updates from Oracle, MS Access and Web based applications.
· Vendor profiles “The Vending Machine” in MS Access, VBA and SQL Server: vendor rates, systems types serviced, hours of operation, coverage area. Template for default Vendor list applies to new business based on location and equipment. Automatically loads to Client Profiles. Daily updates from Oracle and users.
· Vendor Feedback system in MS Access, VBA. Allows operators to record positive and negative feedback relating to customer service experience from our vendors.
· AP Invoicing review in MS Access, Excel, VBA, SQL Server. Vendor invoicing for customer service, ties in Client and Vendor Profiles. Daily automated imports from consolidated invoices given from vendor. Developed Daily FTP Export to Oracle.
· Mission Control in ASP.net, HTML, SQL Server: Custom intranet system purchased from NXO transition for managing sales and contract renewals. Retooled ASP.NET and SQL2000 to hold UAC data and operate with UAC business rules. Transitioned backend to integrate with Data Warehouse in SQL 2000. Stored Procedures, DTS, Views
· Daily scheduled Oracle download and sync up with HUB for general info customer contracts, site addresses and vendor addresses. Stored Procedures, DTS, Excel
· Automated data load using DTS in SQL Server 2000 from Symposium (Nortel call center monitoring database) and Oracle tickets for employee report cards and call center performance reports. Excel, VBA
· Constructed Monthly dash board reporting in excel and Power Point for internal and Client Review reporting. Excel, VBA
· Ongoing process to scrub and centralize client lists from various business acquisitions and mergers using. Excel, MS Access and SQL 2000. VBA, DTS, Stored Procedures. Developed and enforced Data flow processes to avoid anomalies moving forward.
6/1999-7/2005 NXO (formally Williams Communications). Naperville, IL Telecom Maintenance Company System Programmer / Process Engineer Data Architect. Support service efforts for high profile clients including HP, Motorola, Owens Corning, Bank of America and Fleet. Custom Management Systems for various SLA contractual metrics. Tools/Systems: MS Access, ODBC to SQL2000, ASP.NET, Java, VB, VBA, MS Office, MS Project. Accomplishments
· Site Master: MSAccess Client with ODBC to SQL Server. VBA. Client Profiles, site contacts, special procedures, contract and service entitlements. Modem info. Bay Face Layout, Port Counts, system locations. Remote service support. Stored Procedures, Views
· HTML Publisher using MS Access and VBA, SQL Server. Daily publication of site profiles in html format from Site Master. Posted to the web for customer and service review.
· BOA Ticket Tracker. Custom MS Access app to bridge multiple client and in house tracking systems required for BOA Service support. VBA, SQL Server, Views.
· Report Warehouse using MS Access and SQL Server backend. Stages, scrubs and calculates daily SLA metrics on service events. Computes custom contract SLA settings by customer. Exception driven reporting system. VBA, Views
· Tailored Client Service Reporting using MS Access, MS Excel and Power Point. Ad Hoc reporting for various support needs. VBA, SQL, Views and Stored Procedures
· Launch Pad. MS Access, VBA, SQL: user specific menu driven report and application delivery system. Provides a user interface for the Report Warehouse. Views and Stored Procedures
· Inventory Management system in MS Access, SQL Server. Cell phone and calling card tracker for Client’s employee orders, delivery and terminations.
· Survey Tool. ASP.NET, MSAccess, VBA, SQL, MS Exchange Server. Daily Email Survey to specific requestor of service call for Client Satisfaction ratings against various components of service. Fluid and Flexible maintenance for a 1-5 ranking or Yes/No questions. Build custom survey’s on the fly for internal and external survey.
Started 11/2004 Consulting Job Fullers Car Wash. IL suburbs Car Wash and Service Freelance Develop a Club Card customer loyalty system. Tools/Systems: MS Access, VBA, ODBC to SQL2000, Views Stored Procedures. Accomplishments;
· Touch Screen application at site POS system for customer loyalty programs.
· Able to create loyalty programs and customize settings including discounts, cost of program, free wash, duration of program.
· Daily audit reporting for usage.
· Customer marketing database for holiday and promotional mailings.
· Transaction tracking and history. Intelligent script display for customer interaction.
2/1997-6/1999 Globetrotters Vacations. Downers Grove, IL Leading Vacation Wholesale Company Senior Manager of Business Strategy Provide decision support to Marketing and Sales, trending and tactical planning, promotional tracking and forecasting. Integrating production and customer data across platforms and develop automation in Access applications to handle new business practices from acquisitions and mergers. System analysis and audits. Tools/Systems: MS Office, MS Access, ODBC to AS/400, Davox Predictive Dialer, VB, VBA, MS Project, MapLinks. Accomplishments;
· Developed business recovery program in MS Access for Hawaii which grossed over $5,000,000 in 12 months. Excel VBA
· Designed several MS Access system audits which: Pinpointed system errors that allowed us to recover over $70,000 lost in transactions. Automated a commission review and adjustment system saving nearly $100,000 annually. Lead a team that provided analysis supporting a $200,000 billing back to a business partner to satisfy contractual performance and profit agreements.
· Created a cutting edge trending and account relationship management system in MS Access taking production feeds through ODBC from AS/400. Excel, VBA
· Successfully managed and administered the installation of a $250,000, Unix based 12-station predictive dialer telemarketing system. Built reservation management application in Access. VBA
4/1994 to 3/1996 and 10/1996 to 2/1997 Hollywood Casino, Aurora, IL Riverboat Gaming. Consumer Marketing Manager Tools/Systems: MS Access, FoxPro, AS/400, FTP, MS Office
· IT position as AS400 computer operator and PC technician. Negotiated position as Database Consumer Marketing after 6 months.
· Monthly database segmentation using FoxPro and AS/400.
· Over two years managing all phases of $1 million dollar consumer marketing direct mail budget for Casino industry.
· Focus on membership rewards, events, sweepstakes and giveaway games
· After several years of independent study in computers and business, marked the first job in career path change from production art and workflow management to computers and business analysis.
3/1996 to 10/1996 Majestic Star Casino, Gary, IN Manager of Database and Consumer Marketing Tools/Systems: MS Access, AS/400, Maplinks, FTP, MS Office
· Ground up development and implementation of player membership program focused on rewards, promotions and tracking. Direct mail, consumer profiling and behavioral patterns.
· Geographical production analysis using Maplinks.
9/1992 to 9/1993 Air Waves. Columbus, OH. A leader in the Heat Applied Graphics manufacturing arena. Manager of Custom Projects Tools/Systems: Adobe Illus, Adobe Photoshop, MS Office
· Managed art staff of 8, departmental budgets, set objectives and team focus.
· Worked with clients to assess needs, provided costing and production delivery quotes.
4/1985 to 9/1992 H. H. Culter's Co. Grand Rapids, Ml A major player in mass production for children’s clothing and sports wear. Assistant Manager Production Graphics
· Managed night staff of 5 and co managed overall staff of 30 creative and production artists.
· Implemented the company’s first Macintosh graphical network with 4 workstations.
· Liaison to business partners such as Disney, Warner Bros., NBA, NFL, etc.
· Followed projects through complete life cycle.
· Played key roles in process development and workflow management as company grew from $80 million to $160 million in annual gross sales.
· Our teams held high honors for exceeding quality standards and revenue expectations from Disney and other partners
Education
EDUCATION / MEMBERSHIP: Ferris State University/Kendall College of Art and Design, Grand Rapids, Ml Bachelor of Fine Arts in Illustration and Design.
· Held several awards for design as well as won positions for public showings.
REFERENCES: Personal and Professional References upon request
