Quantcast

Data Warehouse Business Intelligence Res...
Resumes | Register

Candidate Information
Name Available: Register for Free
Title Data Warehouse Business Intelligence
Target Location US-TX-San Antonio
Phone Available with paid plan
20,000+ Fresh Resumes Monthly
    View Phone Numbers
    Receive Resume E-mail Alerts
    Post Jobs Free
    Link your Free Jobs Page
    ... and much more

Register on Jobvertise Free

Search 2 million Resumes
Keywords:
City or Zip:
Related Resumes

Business Analyst Data Warehouse Austin, TX

Data Warehouse Sql Server Boerne, TX

Business Intelligence Data Analysis San Antonio, TX

Business Analyst Data Entry New Braunfels, TX

Data Scientist Business Intelligence Austin, TX

Data Analyst Business Systems Austin, TX

Financial Data Business Information San Antonio, TX

Click here or scroll down to respond to this candidate
Candidate's Name
PHONE NUMBER AVAILABLEHigh energy results oriented manager and/or technologist with many years of success in managing, sales, marketing, technology, hands-on development, strategic relationships, and corporate expansion for both start-up and established companies in multiple industries.Team development and motivational leadership management style for developing local, dispersed, and virtual teams to meet corporate objectives.Proven ability to build and organize departments in Information Technology and other areas in companies.Possess a very diverse background with finite exposure across multiple industries with technology and management experience in operational shop floor, financial systems, and management, Enterprise (or Active) Data Warehouse architectureBusiness Intelligence, OLAP, integrated web, ETL, databases, all major brandsWeb Design, develop, deploy, administrateQUALIFICATION HIGHLIGHTSManagement and Technical SkillsManagement, various levelsBusiness Intelligence and Data Warehouse/Mart Products, Kimball Specialist (newer theories applied), Business Metrics and Score CardingData Warehouse Architecture, indexing strategy, dimensional management, MS SQL Server, Teradata (least), Oracle, DB2, (all primary), othersConformed EDW Architecture designed to interact with metadata modeling products like Cognos 8/10 Framework Manager efficiently following proven practices concepts for all facets of BITransactional databases and Active Data Warehousing, including integrationWeb Development, front-end, back-end, customer integration, Some Joomla through 1.7, PHP, MySQLJoomla 1.7, 2.5 & PHP, moderateData Manager, SSIS, DTS, ReportNet Framework Mgr, All Cognos 8 and 10 (primary), Essbase OLAP and Reporting, MS BI Suite (not primary), other OLAP products, Training Publication and Instruction (documentation and training), All MS Office (incl. Project), ComShare, Crystal, MS Access (primary), SQL Server (primary), MS SQL Server (primary), Oracle (primary), DB2 (primary), Teradata (primary), as related to specific implementations of BI, Cognos specific training and hands-on modeling and reporting plus 3rd party product integration, i.e. Deltek, SAP BW, othersProject Manager/Program DirectorCorporate Accounting SystemsConsulting, Business Analytics, Proven Practices, StaffingStrategic Relationships/ContractChange Management ProductsAnalysis, Systems, BusinessPlant ManagementRational Unified ProcessPublications for Major Accounting Packages, SAP, JDE, PeopleSoft, Lawson, more, Research and Comparative product analysis through Metagroup (now Gartner)Business SkillsAccounting and Accounting SystemsManufacturing Shop Floor ControlTesting Services (software)Network Management (Routers/Switches, etc)Technology Planning and Budget ControlPlanning, Forecasting and BudgetingSales (software, hardware, publications)P & L ResponsibilityMaintenance (equipment, software, BOM, scheduling, preventive)WarehousingInventory and DistributionSAPMetadata ModelingBusiness Process Management (definition, redesign, mapping)MoreCertifications and Training:All Cognos C8/C10Some Joomla 1.7, 2.5, PHPHyperion (OLAP, Reporting)Cisco (CCNA, DCN (designing Cisco Networks))IBM (Project Management)Tandem (Projects Management, Executive Mgmt, Tech)Drucker Management SeriesTom Peters Excellence ManagementTeleometrics Management SeriesICM Pittsburgh, Assoc. CS, certificate program, BS equivalent (this was a certification program years ago)Cognos ReportNet I (basic) and II (advanced) AuthoringHopkins SalesCognos Framework Manager I and II Advanced Metadata Modeling Cognos DecisionStreamSkillsBench Assessment: PMP/Sigma, score 91%Industries (partial list):Manufacturing Retail Merchandising Web MerchandisingTechnology Research Electric Generation MiningAirlines/Travel Oil/Gas Extraction Casino (Gaming floor) Insurance Publishing ChemicalForecasting/Supply Chain EducationConsulting: Professional Experience: companies belowCompany: Signature B Corporation October 2011  presentResponsibilitiesConformed dimensional models, EDW and Enterprise AppsMetadata models and reportingBusiness Functional Group (silos of data) data warehousing and reporting plus back end BPM, Active Data Warehousing and messagingReduction in development time for modeling and reportingTrouble shooting existing applications, recommend and implement changesTesting and go-live scenariosCompany: Pan American Life Insurance Group Consultant 2012-2019ResponsibilitiesData Warehouse Architect (I lead remote teams for the entire global BI and reporting, I personally do the architecture and modeling)Architect a new EDW/ADW to replace antiquated, non-integrated, failing data warehouses.oConformed dimensional modeloUsing dimensional hierarchiesoConsistent platforms for aggregation across global regions, companies, and product linesoCapability for active data warehousing as well as traditional ETLoMS SQL Server (T-SQL ETL) with Cognos Framework and StudiosCompany: NEC America (National Clients) October 2010  Oct 2011Role: Sr. Consultant (EDW/ADW BI), On DemandClient: Boeing, conversion Oracle to Teradata and C8 to C10.ResponsibilitiesBC/B - Field consulting for all Cognos BI, all databases, 100% travel, from database architecture to ETL to metadata modeling to reportingUniversity of South Carolina  training for Cognos platform for university technical teamBoeing - Cognos DataManager ETL documentation, and specifications related to conversion from DB2 to Teradata (via Ascential or other IBM ETL tools), SQL definition, cube input SQL correction, metadata model SQL conversionBoeing - Report Analysis and development of conversion inventoriesClient: United Health Group, St.Louis, MO Aug 2010  Sept 2010Role: Sr. Consultant (ADW/EDW/BI)Responsibilities:Conversion of DB2 to Teradata in a C8 environment  identification of potential and actual issues as related to Cognos 8 operability.Conversion was to be as is but several tables required alteration for performance to leverage the speed of Teradata.Examples:DB2 had surrogate keys that were not compatible with Teradata. This was corrected through ETL and work to correct Framework was avoided through Framework inheritance capability of the data type.Existing database errors in DB2 with int16 vs int32 were discovered and corrected through ETL.Certain SQL functions syntax varied and these were corrected to use the Teradata SQL set in Framework, just minor differences in syntax.Client: Camber Corporation Honolulu, Hawaii, 1 week assignment July 2010(I was on vacation and extended a week to stay and work with them)Role: Contractor (BI), introduce CognosResponsibilitiesConsulting assignment to analyze tool sets and document alternatives for future current BI development.Database partitioning for performance improvements.Cubes were loading slowly, partitioning on dates resolved the issue.Company: SAIC, New Orleans, LA (Entergy) Jan 2009  May 2010Role: Applications ManagerResponsibilities:Applications Manager for the Entergy BI area for C8  indirect work with DBAs for performance management and data warehouse changes, specific changes to ETL for schedule management by altering the ETL and/or database to fit into the overnight time window for processing with specific emphasis on meeting SLAs related to month end close.Company: IBM/Cognos (National Clients)  On Demand May 2006  Jan 2009Role: Sr. Consultant (EDW/BI)Responsibilities:Principle Consultant working with clients nationally for implementation of Cognos Business Intelligence and Kimball database systems.All facets of C8 BI from ETL to reporting including metadata modeling to both operational data stores and EDW, directly and indirectly working with the underlying database for performance tuning and speed of data delivery to the reporting platform.EDW architecture, ETL, database administration, architecture, tuning, on all major databases to include Teradata, MS SQL Server, Oracle, DB2, othersDelTek Financial and Planning/Forecasting integration and user training for Cognos reporting, medium to very large enterpriseBaaN, SAP Financial integration and business analytics and user training, EssBaseCompany: Ansell Industries (Dothan Alabama, NJ, Global) June 2004  May 2006Role: Sr. Business Analyst, Global BIResponsibilities:Involved with data warehouse design, global business intelligence and reporting software platforms with Cognos BI, Oracle databases and data marts, develop and implement global strategy, data warehouse systems integration, working with the DBA for database efficiency and interaction with C8, load balancing, performance tuning at the database and metadata model levels for sales and marketing, customer service, enterprise planning, supply chain and forecasting, vendor performance, logistics, demand forecasting, KPI integration for scorecards; define and document user requirements to provide global consistency with regional influence to meet specific global and regional operating needs. Americas, Europe and Asia-Pacific Regions in an integrated EDW and C8 environment.Architecture of time series data base, single day interval data warehouse for manufacturing forecasting for global manufacturing, heavy calculations in database and reporting components where users could compare any time interval to any other time interval in a forward (planned demand) and backward (historic actual demand vs historic planned demand) time series database.Consulting, Executives Center for Business IntelligenceClient: OneNeck IT Solutions, Scottsdale, AZ Mar 2004  Mar 2004Role: ConsultantResponsibilities:Evaluation of ETL tools linking BaaN Oracle Tables with Hyperion Essbase, Software Product Selection, and Alternative Strategies in EDW design to manage alternate reporting dimensionsClient: ECBI (New Orleans, LA, self employed) 2/2003  3/1/2004Role: CEOResponsibilities:Further develop best practices and models for providing business intelligence and decision models for senior executives: development of information from internal and external resources for action and decision support, business intelligence, planning (to include plan modification based on events, market and other factors), budgeting (re-budgeting), forecasting, event planning (what if), demographics, BPM, driver-based planning, and other decision-based models using both tangible and assumptive information; results planning and after implementation measurements and score-carding measure results, measure performance against objectives, accounting and auditing data development, almost everything where cost, ROI, profit, performance, and other key measurable or assumptive elements are involved; identify secure computing facilities and outsourcing resources.Client: OneNeck IT Solutions, Scottsdale, AZ June 2002  May 2003,Role: Sr. ConsultantPerformed Sr. Consultant, Project and Program Management, Essbase 6.5, Develop large data warehouse and reporting marts, extracts to Hyperion Essbase for Reports, Analyzer, ComShare, Crystal, Forecasting/Planning, Global Sales Statistics and Reporting, Oracle, BaaN accounting/manufacturing, technical and business processes, testing plans, alternative strategies and EDW performance management for DW/DM and reporting, managed priorities for roll-out, business analysis, large manufacturer, data warehouse development from scratch, cycling data to reporting data marts, full life cycle, data transformation and data translation, SQL, ETL. Worked with and coached senior technical people in data extraction and preparation. Trained internal staff to support the application, trained users, developed both user and technical documentation. I did everything from concept through installation and training.Responsibilities:Evaluate previously failed cubes and failed projects for 2 previous tries involving Essbase, Crystal Reports and ComShare.Install Hyperion 6.n and related products.Prepare a precise solutions document to achieve global sales statistical reporting, business analysisPresent solution to I.T. people and end-users.Develop technical and business processes for data management, load, and reporting systems.Evaluate Hyperion tools, Planning, Reporting, Analyzer, and Excel Add-In to determine best solution.Design and develop the solution using Essbase and related products, design data warehouse and data marts.Develop specifications for data extract and transformation to build dimensionalized data marts, indexing and performance tuning.Develop test plan and test the system.Format and develop all the reports (several hundred worldwide).Install and train users and technical support people.AccomplishmentsThe system was installed and is up and running producing the information required by the end client.Client: US Govt. (Classified) Jan 2002  Jun 2002Role: AnalystResponsibilities:Prepared business model for network, developed both user and technical network security concept, attack/defense strategies.AccomplishmentsThe architecture and technical brief was delivered.Company: Terex Corporation, Earthking/IT Rapid, Westport, CT Jul 2000  Aug 2001Role: Senior Vice President and Chief Technology OfficerTEREX, a construction equipment manufacturer, wanted to start a dot com for aftermarket services and parts. Established IT Rapid Development as a consulting entity co-owned by me and Earthking (the dot com).ResponsibilitiesP&L responsibility.Recruiting and Staffing, Organization.Create and Manage Strategic Relationships, Negotiation, Sales and sales support, Investor Relations and Development.Develop and install technical environment, build computer center.Projects Management.Software Configuration and Change Management.Consulting and Technology Sales.Business Strategy, Essbase, Cognos, Microstrategy, ComShare, enterprise integration software webMethods, PeopleSoft, SAP for enterprise backbone systems.Strategic I.T. planning, budgeting for IT Rapid Services and Earthking.com.AccomplishmentsBuilt fully redundant production and development computer center from scratch, Windows 2000, MS Exchange, Oracle, MS SQL Server, Active Directory.Maintained budget with staffing in fluid environmentStrategic Relationships.Achieved result for Martin Marietta parts sales website.Contracts / Staffing and management, technical staffs, Java, C++, Dreamweaver, VB, Flash, PKS, ComShare.Company: Metagroup, SPEX, Reston, VA and Stamford, CT Apr 1998  Jun 2000Role: Senior Program Director (Software Research)Description:The SPEX unit of Metagroup was charged with critically evaluating enterprise software products and providing our customers with concise side-by-side evaluations of capabilities. Evaluation of products was hands-on. Maintain relationship with parent company investor and sales organization, negotiate performance targets and manage expectations.ResponsibilitiesTrain and develop research staff personnel in the proper ways to look critically at software products.Evaluate enterprise level software products, RDBMS (particularly as related to Data Warehousing and BI), OLAP/BI, ETL, ERP, all major players, i.e. SAP, JDE, Cognos, Essbase covering broad spectrum for specific software spaces, plus Intrusion Detection, Web Dev Tools, RDBMS to include Oracle, Sybase, DBII, MS SQL Server, middleware and reporting tools, web integration, ComShare, BEA, Webshpere, much more, see publications below.Determine what enterprise spaces would be evaluated and the products to be evaluated.Define formats for research documents to be published on the web and in written publications.Design, implement, train, and maintain the automated portions of SPEX research methodologyWork with Metagroup senior sales management to develop programs to out SPEX research at the forefront of the sales agenda.Train Metagroup inside and outside sales people to sell the publications and subscriptions.Complete responsibility for the evaluations of over 200 enterprise level software productsQuality Control.Customer Support.Database Management of research data (back-up and recovery).Produce monthly contribution to inSPEXion Newsletter published to thousands of clients, critical evaluation of newsworthy items affecting our customers.Accomplishments and Software InnovationsIncreased the overall number of technical spaces and provided sophisticated evaluation tool for potential analysts  needed to better evaluate analysts ability to make good judgments and test analytical ability.Invented, developed, and installed COMPASS, an automated OLE Word/Excel system to increase analysts efficiency and accuracy in building the statistical evaluation models for side-by-side comparison of enterprise software products, significantly reduced overall labor and increased accuracy dramatically.Designed and implemented a program for training sales people; increased sales by over 200%Increased sales through training and direct support by over 100%.Increased the number of analysts and provided training and direction regarding the proper way to evaluate software on a critical basis.Increased the number of major software development companies to permit SPEX hands-on evaluation.Helped position SPEX as an industry leader by producing quality results and showing major software developers the importance of being published by SPEX.Worked with and as senior management to evaluate and modify research module content to meet the needs of the marketplace.Published by Metagroup and many major respected IT industry publications and websites (key areas web development, OLAP/BI, RDBMS, accounting systems, network management and security)  see PUBLICATIONS BELOW FOR DETAILS.Company: Buckman Laboratories, Memphis, TN Apr 1997  Apr 1998Role: Product Manager (Associate)Responsibilities:Product manager for the installation of BaaN and Hyperion OLAP/BI systems to utilize the data in the BAAN implementationWork with BaaN Accounting and Financial components to define Chart of Accounts with parent and child dimension relationships for flexible and sophisticated financial reporting, including cost accounting.Take the data for five companies and summarize into the holding company to include inter-company eliminations and full drill down capability to original journal entry level.Work with BaaN Manufacturing and Customer Relationship components to develop detailed executive and field reporting by various dimensions (i.e. product, product class, sub-class, world region, sales region,Involved data encoding and conversion for previous 5 years of legacy data.Produce consolidated financial reporting for the individual companies and the consolidated income statements, change of cash position, and balance sheets, Hyperion Enterprise.Work with corporate accounting management to develop consistent work flows through the BaaN interfaces (various screens, sequences of operations), develop coding models for dimensioning data for downstream reporting and control (Design Process Modeling).Work with manufacturing management and staff to convert manufacturing data to BaaN acceptable formats including the encoding for raw material and finished goods (including lot control) for inventory and sales systems, master scheduling (Design Process Modeling).AccomplishmentsDesigned and implemented data feeds from BaaN for financial information with integration to Hyperion Enterprise.Designed and implemented data feeds from BaaN for implementation of Hyperion OLAP and business intelligence system.Participated in all programs to facilitate decisions on how to best utilize the system to meet specific company needs and maintained the database of open items requiring decisions prioritized by importance for day 1 roll-out.Company: Performance Associates Corporation, Pittsburg, PA Jan 1980  Mar 1996Role: Chief Executive OfficeResponsibilities:P&L, Budgeting, Forecasting.Market, develop, and manage strategic sales relationships with Tandem and Stratus, negotiate development grants and maintain strategic relationships with bank investors and corporate sponsors like Tandem, USAir, Stratus, NCR, and others.Technical Development.Develop and install technical environment, build computer center.Projects Management.Software Configuration and Change Management.Consulting and Technology Sales.Accomplishments and Software InnovationsCollege and User training in various subjects-Accounting-Programming Languages-Systems Analysis-Cognos Framework Manager, Reporting and Analytical tools, integrated 3rd party products-Database design (EDW focus, Kimball)-Hopkins Sales-Fault-tolerant programming-Casino Games dealing, Craps, Blackjack, Roulette, various circus games-Junior Achievement learning classes at the intermediate school level (grades 7 to 9)CAM - Computer Assisted Merchandising - May Company Department Stores system using micro-computers in 14 weeks to prove the viability of the overall CAM concept, and rewritten for Tandem Non-Stop systems. Became an 8-year relationship with May spanning Pittsburgh, St. Louis, and Maryland data centers. CAM became the basis for the state-of-the-art retailing systems and was one of the first systems to quickly process POS transactions linked to a particular sale for delivery of big-ticket merchandise, fashion and assortment, merchandise planning, inventory, open to buy, other metrics. Retail.AirSystem - first to actually put airlines, hotel, and car reservations at the corporate executives desk. Working with USAir seeking capital and grant money to further the concept. Predecessor to web-based travel technologies.ExecuLink (ROLAP)  Invented from C.A.M. (circa 1985)  Using C.A.M., buyers & executives wanted more information about inventory aging, open-to-buy budgets, POs, and POS statistics, particularly after major sales events like the White Sale (a $10,000,000 day) in Pittsburgh alone and holiday sales. Multi-dimensional ROLAP/BI products were not mature. To provide the information, we leveraged the CAM database (relational) to create a central cluster of meta-tag keys (ROLAP) to provide multiple instant views of information. Meeting with the chairman, 1 of his quips was Bruce, if you could develop a system where I can literally hear the cash registers ringing in my office, it would make me very happy. The technology of the day didnt support that, but he had results within 2 hours of store closings every day.

Respond to this candidate
Your Message
Please type the code shown in the image:

Note: Responding to this resume will create an account on our partner site postjobfree.com
Register for Free on Jobvertise