Sql Server Training
Resume:
Blog and Portfolio of Work
Feed on
James Michael ‘Mike’ Bennett
Seattle WA 98121
****.********@*******.***
SUMMARY
Highly motivated Business Intelligence Professional using SQL Server 2005, 2008,2008R2 and other Microsoft Technologies. Experience manipulating various data sources to support Senior Management decisions. A strong team player with excellent problem solving, leadership and communication skills. The ability to collaborate with stakeholders at all levels of the organization. A systems approach to understanding and managing business and technical issues, a win-win philosophy, willingness to accept responsibility, strong work ethic and a sense of humor in the face of adversity.
http://www.linkedin.com/in/jmikebennett
http://www.jamesmichaelbennett.com
CERTIFICATIONS
Microsoft Introduction to Business Intelligence
Microsoft Implementing MS Office SharePoint Server 2007
SetFocus Business Intelligence Master s Program
Return on Investment Methodology Certificate – VNU eLearning (The ROI Institute)
TECHNICAL SKILLS
Microsoft Technologies:
SQL Server 2005,2008 Integration Services (SSIS), SQL Server 2005,2008 Analysis Services (SSAS), SQL Server 2005,2008 Reporting Services (SSRS), Microsoft Office SharePoint Server 2007and 2010, Microsoft Performance Point Server and SharePoint 2010 BI tools, Microsoft Visio, cFactor.
Databases:
MS SQL Server 2000/2005/2008/2008R2
Software:
SQL Server Business Intelligence Development Studio, Microsoft Visual Web Development Studio, Performance Point server designer and SharePoint 2010 Business Intelligence designer. Microsoft Office 2005,2007 and 2010, Team Foundation Server.
Query Languages:
T-SQL, MDX, VB ASPX, SSIS and SSRS Expressions
PROFESSIONAL EXPERIENCE
Senior BI Developer
Client: Big Fish Games
12/2011 3/1/2012Provide BI development and backend systems support for the Financial Systems teamParticipate in the team Agile SCRUM project methodologyDiagnose and resolve daily ETL process issuesDefined developed and deployed process changes and new applications to meet the business needsCreate and Edit reports and documentation
Matisia Inc.
Client: Microsoft
Tier 4 Application Support Consultant
2/7/2011 - 12-20-2011
Provide support activities to the Microsoft IT OSM Services teamDefine, Develop and Deploy a new Services Management Dashboard and associated Data WarehouseProvide at a glance application and Hardware status for multiple mission critical applications inside MicrosoftCollect information from a diverse group of applications
Define, Develop and Deploy new service account tracking systemBuild account information repositoryTrack all access to encrypted passwordsProvide alerts reminding support team of impending expirations
Wicresoft Co.
Client: Microsoft
Tier 3 Support
12-20-2010 – 2/4/2011
Provide Tier 3 ETL support to the Microsoft Zune BI team
Support resolution of ETL failuresProvide super admin support to developersSupport hardware, OS and applications were they impacted ETL
Logic20/20 Consulting
Client: Microsoft
Contract Consultant
9/23/2010 10/15/2010
Database architect involved infrastructure migration for a Microsoft business unit
Migration of SQL 2005 and SQL2008 32 bit databases to 64bit SLQ2008R2Investigated 32/64 bit ETL problems. Participated in defining best fit resolution with the client and implemented changesMigrated and merged SSRS report server and reports from SQL2005 and SQL2008 platforms and resolved migration/conversion errors
Used BIDS to convert 2005 reports to 2008 R2Merged SQL 2005 and SQL 2008 reporting databases into one consolidated databaseRepaired/recreated SSRS reports damaged in the conversation processMigrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform
Resolved significant PPS connection string issues with import processRepaired/recreated PPS reports damaged in the conversation processProvided DBA assistance in SharePoint 2007 to SharePoint2010 conversion
Volt
Client: Starbucks Coffee Company Global Learning-Seattle, WA
Business Manager
2/10 7/16/2010
Manage content and site deployment for new partner information portal
Manage/Create UAT process for new partner portal deploymentProvide technical support for content authorsBuild cFactor usage knowledge base and transfer knowledge to content creators and managersDeveloped long term deployment strategy and methods for new portal users
Defined rapid deployment methods to meet ever changing business needsSuper Administrator for Plateau Learning Management System during FTE Administrators absence
Participate in MyLearning strategic planning sessionProvide tactical support to learning programs
Assure accurate MyLearning implementations of content to meet program stated requirementsProvide Tier support for GTO learning help groupDesign, deploy and maintain all facets of learning needs
Bellevue College Continuing Education
Bellevue, WA
Adjunct Instructor (Part Time)
1/06 – Present
Conduct BI Capstone Certification Project ClassConduct SQL Query Fundamentals ClassConduct Certified Wireless Network Professional Wireless# class. Course provides needed understanding to pass the CWNP first level certification assessmentConduct PC Network Fundamentals classActed as an advisor Project Management group on ITIL course development and deploymentParticipant on Database curriculum advisory group
Infotree Services
Client: AT&T
Contract Consultant
Bothell WA
7/07 9/09
Gathered requirements, designed and developed business automation and reporting for 400,000 plus member organization measuring Compliance, Environmental Health and Safety Training results and Ethical Violations
Defined and Designed ETL process from data warehouse to DatamartDefined Datamart structure and needsDefined report types and needs
Drill Down Reports and DashboardsResponsible for all lifecycle activities of CCR application. Application provided Dash boarding, Dashboard drill down through corporate hierarchy, Tabular reporting by leader/individual, Automated email reminders, Analytics comparing ethical violation rates in groups to compliance training results and other topics
Developed and deployed ETL process from data warehouse to DatamartDeveloped and deployed Datamart structure and tablesDeveloped and deployed report types and web pages
Drill Down Reports and DashboardsActed as a business consultant to IT training, Compliance and EH&S groups in areas of metric selection, success measurements and organizational benefits, performed job role to process role mapping fo r large IT process unification project and associated certification program
King County Elections
Instructor
Seattle WA
6/07 7/07
Taught polling place regulations and skills to King County election workers.Collaborated with King County staff and fellow instructors on content development and improvement.
Award Solutions Inc.
Independent Consultant
Dallas, TX
2/2007Award Solutions is an industry leader in high end training to wireless companies.Consulted on and provided insights and vision in the following areas:
o Improved assessment philosophy and practices
o Providing metrics to customers that support measuring benefits of training
o Measuring student performance to provide continuous content improvement
o Insights into how companies look at training vendors
T-MOBILE USA
Senior Manager Engineering
Learning and Development
Bellevue, WA
10/96 12/06
Directed the training group for a 3,000-person Wireless Engineering and Operations National Business unit; manage a $1.8 million operating budget and a $3.4 million capital budget, supervising up to 11 direct reports.Directed and supervised the development and delivery of learning content targeted at technical teams driven by major engineering projects, career development initiatives and process and business development initiatives.Built and managed relationships between Training Vendors and the company.Supported organizational change, role based training programs, participated in contract negotiations for new technologies including 3G and all aspects regarding training and team improvement.
Traffic EngineerSupervised the network supporting the switching and site development teams serving Oklahoma, Tulsa and Wichita.Managed a $5.5+ million budget.Introduced standardized network performance metrics to the south region and was granted a Peak Achievement award for an analysis program resulting in significant RAN network performance improvement.Reported to Director Development and Operations.
Switching MangerSupervised up to eight located in Oklahoma City, Tulsa and Wichita Kansas.Managed a $750k operating budget and a $1.5 million capital budget. During this time Oklahoma City was the top rated Nortel GSM technical group in North America for two consecutive years (1997 and 1998).Developed and managed deployment of LAN access to Nortel HLRs. Provided multiple users LAN/WAN speed access to Nortel HLRs speeding customer care access and reducing care center hold times.
EDUCATION
SetFocus, LLC.
Business Intelligence Master s Program
Seattle, WA
12/09 3/10 Implemented a Labor Analysis Business Intelligence solution for a national construction company.Existing data from diverse data sources were consolidated into a uniform SQL Server 2005 database. ETL capabilities of SSIS were used to define imports of data, build scheduling packages, define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails. Created cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways – hierarchically and using custom groupings, that the company will use to analyze performance. Created MDX queries according to business requirements.Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.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 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 construction company extracting data from SQL Server 2005 OLAP data source and deployed 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.
Studied and reviewed application of Kimball data warehouse methodology across various industries. Worked with data-handling scenarios, such as multiple hierarchies, data-driven KPI goals, sourced either from dimension attributes or fact tables, handling Type-2 slowly changing dimensions.
Sheffield University
BS Telecommunications
August 2004
PROFESSIONAL AFFILIATIONS
Member, Global Wireless Education Consortium Board of Directors (2-year term) 2006 2006
Member, Bellevue Community College Continuing Education Advisory Board (2-year term) 2006
Member, Nortel Wireless Users Group (1996 -1999)
PRESENTATIONS CONDUCTED Case study: Why T-Mobile Selected Engineering and IT Pro From Books 24X7, SkillSoft/Books 24X7 Conference, 2006 Partnering To Meet Multiple Needs Ericsson Training Users Group Conference, 2006 Rapid ROI With Virtual Classroom Tools, VNU eLearning Conference, 2004 Building A Quality eLearning Program In A Hurry. (Customer profile) and The Good And Bad In eLearning Content. (Content show case), TLM Users Conference, 2004 Partnering With Your eLearning Vendors. (Customer profile) TLM Users Group, 2003
Comments are closed.
Recent PostsThe New Lab – part 2 – Domain Controller
James Michael Bennett © 2012 All Rights Reserved.
© 2012 All Rights Reserved.
Contact this candidate