Jerry Adcock - BI

Vancouver, WA *****

 360-***-****

dg9xdb@r.postjobfree.com

SUMMARY

Highly motivated Business Intelligence Professional using SQL Server 2005 and Microsoft Technologies. Experience manipulating various data sources to support Senior Management decisions. Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision. Vast experience at technology and managerial duties and positions with the ability to quickly adapt to new environments and challenges.

http://www.linkedin.com/pub/jerry-adcock/10/626/a20

TECHNICAL SKILLS

Microsoft Technologies:

SQL Server 2005 Integration Services, SQL Server 2005 Analysis Services, SQL Server 2005 Reporting Services, Microsoft Office SharePoint Server 2007, Microsoft Performance Point Server, Microsoft Visio, Visual Basic, C/C#

Databases:

MS SQL Server 2005, Alpha5, Access, Informix, FoxPro, DB III & IV

Software:

SQL Server Business Intelligence Development Studio

Query Languages:

T-SQL, MDX

CompTIA Networking+ Certification: 233759648

PROFESSIONAL EXPERIENCE

SDS Vancouver, Inc. Vancouver, WA 5/03 - Present

CTO/Network Engineer/Software Engineer

• Built and grew successful business, providing top quality service that earned a solid reputation for excellence and results; ranked in Top 20 IT providers by Vancouver Business Journal.

• Delivered key benefits to long-term primary clients, including complex services for a medical clinic that enabled cost savings that represented nearly 80% of the budget.

• Optimized ability to serve clients thoroughly and advanced business opportunities by independently learning Windows Server 2003 and Exchange Server 2003, which proved invaluable with multiple clients.

Subterranean Data Services, LLC, Lewiston, ID & Vancouver WA 5/93 - 5/03

Vice President Sales/Engineering

• Managed office activities, overseeing 2 employees and 6 contract workers. Maintained books and collaborated with local banks to obtain financing. Conducted surveys and called on potential clients.

• Developed enterprise from original conceptual position to a product-based company with a dynamic sales and marketing plan. Redirected focus to more commercially viable online backup market.

• Advanced business success by proactively building company’s reputation as the market leader for the Vancouver/Portland area.

Adcock Air Drilling Services, LLC, Lewiston, ID 5/93 - 11/00

General Manager

• Improved quality, efficiency and cost effectiveness of tools through diligent research of materials and subsequent utilization of H-13 steel which produced tools/components that lasted 400% longer in the field and cost 30% less to heat-treat.

• Overhauled business operations for sister company, Murphy-Adcock Drilling: recovered over 97% of past-due invoices, organized and computerized office, and ensured proper documentation of both financial and manufacturing-related information.

• Oversaw day to day operations, including payroll, mobilization and de-mobilization of drill rig and support trucks, inventory, quality control, facility and fleet maintenance and accounting.

EDUCATION

SetFocus, LLC. Parsippnay, NJ 8/09 – 10/09

Business Intelligence Master’s Program (400 hour program)

• Implemented a Labor Analysis Business Intelligence solution for a fictitious national construction company.

• Existing data from diverse data sources were consolidated into a uniform SQL Server 2005 database. ETL capabilities of SQL Server Integration Services were used to define imports of the data, build scheduling packages, to define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails.

• Created a number of 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.

• 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.

• Implemented business intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership.

• 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.

• 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.

• Key product areas utilized also include data modeling, SSRS report subscriptions and data driven subscriptions, SSAS analysis services processing tasks, cube processing options and roles

University of Idaho Moscow, ID

Bachelors Degree, Computer Science Major Business Administration Minor

Published several articles on data security and protection for Vancouver Business Journal, Vancouver WA.

Faculty instructor for Lorman Education Services, presenting seminars on data protection and computer and network security.

TECHNICAL SKILLS

High-level Languages

C++ • Pascal • Visual Basic • Delphi (Pascal IDE) • COBOL • PL/1 • Fortran • C#

Database Applications

Access • MySQL • SQL Server • DB III, IV • Alpha 4/5 • FoxPro • Paradox • Informix

Assembly Languages

8086 • 80x86 • 8051 • 8031 • 8035 • 6502 • 6504 • Z80 • Z8000 • PLC

Operating Systems

Windows Server 2003 • Exchange Server 2003 • Windows Vista • Windows XP

Web

PHP • HTML • CSS • Java • Visual C • Alpha5

PERSONAL REFERENCES

Available on request.

Contact this candidate