AAO BI Resume

Alistair A. Ottley Colorado Springs, CO 80919 719-***-**** abqrc8@r.postjobfree.com www.linkedin.com/in/aaottleySummaryA highly motivated Business Intelligence Professional, using SQL Server 2005/2008 and other related Microsoft BITechnologies. Diverse 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 minimaldirection and supervision.Technical SkillsMicrosoft BI Technologies: SQL Server 2005, 2008, 2008 R2 Integration Services (SSIS) SQL Server 2005, 2008, 2008 R2 Analysis Services (SSAS) SQL Server 2005, 2008, 2008 R2 Reporting Services (SSRS) MS Office SharePoint Server 2007 (MOSS/SP) MS Performance Point Server 2007 (PPS)Databases and Query Languages: MS SQL Server 2005 and 2008 T-SQL and MDXSoftware: SQL Server Business Intelligence Development Studio (BIDS) Microsoft VisioConsultant for Hewlett Packard Colorado Springs, Colorado June 2010 PresentSQL Server Database Developer and Report Writer Designed and implemented numerous databases, tables and requisite relationships and stored procedures to support hardware issue tracking and management reporting. Developed SQL Server Integration Services ETL packages to extract, cleanse, validate and consolidate data from SharePoint lists and other external database back ends. Designed and developed numerous T-SQL scripts, stored procedures and user defined functions to gather and prepare data sets for the many authored reports. Parameterized reports use T-SQL queries to populate parameter lists. Developed numerous daily, weekly and monthly summary and detail reports to support management reporting requirements and to improve timely and accurate reporting utilizing SQL Server Reporting Services and a centralized Report Server. Created scorecard reports using report parts and sub reports. Reporting requirements include parameterized, cascading parameter, drill down and drill through reports. Many reports were set up to use subscriptions for automated execution and delivery. Maintained all of the SQL Server databases and DB permissions; maintained all Report Server objects and permissions. SetFocus, LLC. Colorado Springs, Colorado August 2009 October 2009Business Intelligence Master s 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.Other Professional ExperienceVerizon Telecommunications, Colorado Springs, Colorado 2006 - 2007Support Analyst/Programmer-Analyst Worked closely with eight other team members to maintain and modify the processing of raw billing and marketing data for entry into a centralized data warehouse. Analyzed and successfully redesigned and implemented a mainframe front end for third party marketing data, eliminating unnecessary CNTL member modifications for e-mail notifications, error notifications and FTP data transmissions all reducing manual intervention significantly, as Vendor providers and FTP targets changed. Analyzed and designed a complete rewrite to a manual ETL process to improve MS SQL DTS package and Teradata SQL procedure processing times, reducing machine load and processing time by 30%. Automated entire job streams by processing UNIX based BTEQ scripts into parallel ESP and ESP/X scheduled jobs. Correctly identified and migrated numerous production Teradata database tables to a new production database, working with several DBAs to design and create the new production environment, modifying numerous BTEQ scripts to reference the new DB table design, testing and installing the modified scripts and ESP/X jobs and coordinating the final cutover into production.MCI (MCI Worldcom), Colorado Springs, Colorado 1998 - 2006Support Analyst/Programmer-Analyst Consulted and worked with business analysts, marketing personnel, technical analysts, QA testers and implementation personnel to enhance and improve the efficiency, productivity and the system functionality of various marketing system data feeds and processes. Analyzed, designed, developed and implemented numerous enhancements to several processes, extracting and transforming additional data elements from numerous ADABASE and DB2 data sources, supporting the requirements of expanding business requirements and practices. Integrated existing application functionality into an On-line Lead Database system, from other antiquated, disparate and obsolete marketing systems, incorporating appropriate data transformations and business logic. Monitored, maintained and modified, dozens of daily, weekly and monthly mainframe job streams that support several downstream feeds to UNIX and Sybase midrange processing platforms. ABENDs were analyzed for cause and appropriately modified to eliminate future occurrences.EducationSetFocus Parsippany, New JerseyBusiness Intelligence Master s Program Graduated with Distinction, GPA: 93/100Pace University Westchester, New YorkBachelor of Business Administration, Management Information Systems Magna cum Laude, Overall GPA: 3.65/4.00KEYWORD SUMMARY Cubes, Dimension Tables, Fact Tables MDX - Multi-Dimensional ExpressionsTelecommunications Dimensional Modeling, Unified Dimensional T-SQL - Transact SQLMarketing Modeling-UDM SQL - Structured Query LanguageBilling QueriesCustomer Quality ETL - Extract, Transform, Load KPI - Key Performance Indicators PPS - PerformancePoint ServicesAnalysis, Design, System Analysis SP - SharePoint ServicesSDLC - Systems Development Life Cycle SSIS - SQL Server Integration Services MOSS - Microsoft Office SharePoint Services SSAS - SQL Server Analysis Services WSS - Windows SharePoint ServicesOLAP - OnLine Analysis Processing SSRS - SQL Server Reporting ServicesOLTP - OnLine Transaction Processing Report Server Excel Services Pivot TablesBI - Business Intelligence SQL Server Database Management SystemDW - Data Warehousing DBMS Visio Relational Modeling BIDS,-Business Intelligence Development Studio Database Design