Consultant Resumes in US-Missouri-St. Louis: David

Consultant Resume

Contact Candidate

Name:

David

Location:

US-Missouri-St. Louis

Experience:

10+ yrs

Willing to Relocate:

Willing to Travel:

Yes

Most Recent Job Title:

Consultant

Personal Website:

Objective:

Results oriented BI Professional with expertise in business analysis, systems development and strategic business process engineering utilizing Microsoft BI technologies.

Seasoned Applications Architect with excellent relationship management skills, hands on technical perspective, experience supporting management initiatives across multiple industries, and an entrepreneurial mindset that promotes new synergies in pursuit of corporate mission and business growth.

Resume Text:

Let us help you find a job, submit your resume now.

.....Begin Resume Preview.....

r 2005 Analysis Services (SSAS) / SQL Server 2005 Reporting Services (SSMS) / Microsoft Office SharePoint Server 2007 (MOSS)/ Microsoft Office (MSO) / Microsoft Visio / MS SQL Server 2005 Business Intelligence Development (BIDS) / Windows / DOS / NT / Win2000 / Windows XP / Vista / WinServer2003 / Active Directory / IIS / Novell / AS400 / RS6000 / AIX / DGAviion / SQLServer2000 / Kofax Ascent / Optical / Microfilm storage systems / Centura SQL / SCSI / Outlook / FoxPro / Dbase / Access / Word / Excel / PowerPoint / Project / Visio / ACT / LaserFiche / Erwin Script / FTP / TCP/IP

SetFocus, LLC. Parsippany, NJ 2008-
MASTER’S PROGRAM – BUSINESS INTELLIGENCE
• BI - Implemented a Labor Analysis Business Intelligence solution for a fictitious national construction company.
• ETL - Existing data from diverse data sources were consolidated into a uniform SQL Server 2005 database. SQL Server Integration Services was used to define imports of the data, transform the data (cleaning), build scheduling packages, to define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send ETL progress emails.
• OLAP - Created multiple cubes, dimensions and business critical KPIs using SQL Server Analysis Services representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance. Created several MDX queries according to business requirements.
• SSRS - Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services.
• MOSS - Implemented business intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership.
• MSPPS - Created score cards with executive summary dashboards using MS Office Performance Point Server 2007 Dashboard Designer that display performance monitoring measures for sales, sales trends, and book return rates for a fictitious book publisher deriving data from a SQL Server 2005 OLAP data source and deployed them to SharePoint sites. The dashboards also contain drill-down capabilities to view book sales by book category and customer, through summary reports and sales trend charts.
• MSO - Created score cards with advanced set of dashboards using MS Office Performance Point Server 2007 Dashboard Designer that feature executive summary measures for revenue, overhead costs, material purchases, labor and profitability trends for a fictitious construction company extracting data from a SQL Server 2005 OLAP data source and deployed them to SharePoint sites. The dashboards also contain pages to view performance by employee, by region, and by quarter enabling end-users to make filter selections.

PROFESSIONAL EXPERIENCE HIGHLIGHTS

HILLTEC SYSTEMS SERVICES Chicago, IL 2002-2008
Consultant (Selected Projects)
BUSINESS DEVELOPMENT - Successfully initialized, established and grew PenDrive LLC. Created strategic infrastructure to launch technical product line distribution including business plan, incorporation, corporate strategy, process documentation, accounting procedures, web site design, client presentations, pricing structure, order fulfillment, marketing, sales strategy and information technology.

SUPPLY CHAIN MANAGEMENT – Translated Owner’s Vision to Reality with professional services relative to business and computing infrastructure to grow into a national expediting and logistics company. Elements included owner vision to corporate strategy transition, process consultation, expeditor relations, order fulfillment, marketing materials development, and new technology assessment/integration.

CHANNEL MANAGEMENT - Established $16MM dealer channel for Document Management/Workflow product line. Mentored 166 account representatives and sales managers in Document Management Solutions Development and relationship management. The Product offered Sarbanes/Oxley compliant Electronic Document Management technology relative to Capture, Authoring, Indexing, Archiving, Web Retrieval, and Retention in Municipal, Law Enforcement, Financial, Legal, Education, and Manufacturing industries.

EASTMAN KODAK (BELL & HOWELL Imaging Solutions Division) 1992-2002
Chicago, IL
APPLICATIONS ENGINEER (1997-2002)
Achieved $8MM to $12MM estimated annual sales revenue as instrumental team member, delivering IT solutions to meet business document management needs.
DATABASE
• Naviquest Development Team - Business Intelligence functional role. Responsibilities within the project team included: Managing the IIS server, SQLserver Administration, Database Analysis, QA lead, oversight on product documentation writer and consultation on business user solution requirements.
• Hands on SQL dba experience was augmented during the process of becoming systems engineering expert on the new product. Used SQLscript to manage MSSQL 2000 database schema, generated Erwin script files, verifying, and editing prior to creating and deploying new applications. Used Source Safe version control, MSI packaging, and ArcServe backup/restore.
• Traveled to client site to troubleshoot and resolve lock-up issues. Using strong SQL troubleshooting skills, determined root cause of metadata corruption within the SQLbase engine. Results: reinstallation of SQL2000, the Naviquest(beta) application and verifying correct metadata loading.
• Developed database schema, performed data conversions (ETL), and prepared report templates.
APPLICATIONS PRESALE
• Highly visible champion of the pre-sales engineering process for ImageSearch product. Worked with up to 9 account managers, national scope. Played integral role in sales process - strategizing with representatives, preparing proposal package quotes, providing crucial interface between sales and technical staffs, and presenting solutions to assist in closing the deal.
• Provided business and technical insights gained from database work connected with installation, configuration, integration, training and technical support experiences.

PROFESSIONAL EXPERIENCE HIGHLIGHTS continued

INSTALLATION & TRAINING
• Installed, integrated, configured, network and standalone document management systems at 150 national and international locations. Used relationship management and technical expertise to create
• Sites ranged from insurance companies (claims handling) to municipal police departments (traffic tickets/accident reports) to healthcare facilities (medical records units) to the federal government (EEOC), and the military (integrating mainframe to populate database for supply function audits).

SYSTEMS SUPPORT ENGINEER (1992-1997)
Department earned $5-$7MM support revenue per year. Performed technical support for databases, systems, networking and reports, working the queue and interfacing directly with customer and development staff on reports of bugs, fixes, upgrades, database conversions, and troubleshooting of archiving products, computer systems, databases and networking technologies (LAN/WAN).
• DATABASE - Developed complex query scripts to create tables, indexes, establish table relationships, stored procedures, and develop formatted reports. SQLtalk scripting, SQL database operations, and Windows server tools were the primary methods of supporting the customer base. SQL used on a daily basis to discover and resolve technical, operational and ETL issues.
• LAN/WAN ADMINISTRATION - Exercised initiative in assuming LAN administration for department concurrent with other roles and duties; capitalized on Novell CNE status to maintain integrity of Windows network and mentor promising technical staff.
• INTEGRATION - Resolved configuration and integration issues, connecting product support to SCSI devices, network interface (including Novell to NT), Optical jukeboxes, and hardware RAID (cat 5).

POSTALSOFT, INC Chicago, IL 1991-1992
PRE-SALE TECHNICAL SUPPORT
• Performed all technical duties for multi-state regional office. Provided technical pre-sale support for mail presort and address cleaning software applications. Installed and maintained systems, trained end-users, assisted sales representatives and maintained email connections for this rapidly growing commercial mailing industry software and support provider.

Education, Certifications, Environments and Packages

Bachelor of Science —Economics / Accounting / Finance IOWA STATE UNIVERSITY, Ames, Iowa

A+, MCP, CDIA+ MCTP(pending), MCDD(pending)

A job posting with Bronze, Silver, or Gold Priority is required to veiw full resumes.
Click here to post a job now.

LUCKYDOGJOBS

The Lean and Mean Job Hunting Machine