OLAP Job Cost Overview
Typical total cost of oDesk OLAP projects based on completed and fixed-price jobs.
oDesk OLAP Jobs Completed Quarterly
On average, 0 OLAP projects are completed every quarter on oDesk.
Time to Complete oDesk OLAP Jobs
Time needed to complete a OLAP project on oDesk.
Average OLAP Freelancer Feedback Score
OLAP oDesk freelancers typically receive a client rating of 4.70.
Gary Campbell Agency Contractor
I am expert on Oracle-exadata, Infromatica8.5/8.6/9.1(5 DW projects), Obiee11g, PL/SQL, Oracle11g, MSSQLServer 2012/2014 Enterprise(SSIS, SSAS, SSRS), Teradata and I have more than 10 years of experience in Data Warehousing (Banking & Telco), ETL, BI, Analysis, Data Architect, Dimensional Modeling (Star-schema, Snowflake, 3NF), Project Management, Database Design, Database Engineering, Documentation on Business Intelligence Strategic Road map Business Requirements and Technical Feasibility Assessment etc. Technical: I provide BI (DW) Solutions by the followings: .Oracle Flexcube UBS .Data Modeling, .ETL Design, .LDM & PDM, .OLAP, .Source System Analysis .Oracle9i/10g/11g, .Teradata13 .Teradata SQL, Teradata Tools & Utilities (BTEQ, FastLoad, MultiLoad, TPT) .PL/SQL .Informatica8.5/8.6/9.1 .OBIEE .SAP BO .SAP Crystal Report .MS SQL Server 2012 .Linux .Shell script .MS VISIO 2010 .MS Project 2010 Core Banking Domain: 1. Oracle Flexcube UBS release 2. TCS Core Banking Solution 3. BankUltimus Core Banking Solution (Leads Corp.) ETL Development/ETL Design and Data Migration through Informatica/SSIS for Data Warehouse (Bank), Worked division: I) ATM Data II) Card Data III) Corporate Banking IV) Retail Banking Inter-Banking Informatica/SSIS, Sql Server & Oracle BI DW Basel-II projects (Bank) with Data Migration: 1. Bangladesh Bank (Central Bank of Bangladesh) 2. SIBL SKILLS: * Data Vault Design (Components: Hub, Link, Satellite) * Planning & Define Data-mart schema architecture e.g. - Start Schema, - Snowflake, - 3NF Banglalink(Orascom) EDW Teradata Telcom Project Technology:Teradata,Informatica9.1,SAP BO XI,ERwin. * Teradata SQL * Teradata ETL tools & Utilities such as * BTEQ,MultiLoad,FastLoad,FastExport,TPT * Teradata Physical Implementation * Teradata Administration * Data Modeling to build LDM and PDM * Developed standard SQL, PL/SQL code * Query optimization technique * Developed Data summarization & aggregation concepts and scripts * Developed shell scripts (Korn shell) for ELT and BI purpose * Develop ELT process using Informatica9.1 * Developed ELT process for various Operational Data Source (TABS, IVR, LMS, CMS, POS, SALESCOM and forth) of Banglalinks’ Telecom (Orascom) and BI reporting with BI Chain Development. * Design and created ELT standards and procedures * Assisted in architecture design of new data warehouse and ETL/ELT process * Documents all ELT code for the business * Designed and installed test scripts for ELT code * Created Informatica9.1 ELT code from functional and technical specs * Converting Oracle Procedures, Functions into Teradata stored Procedure (SP) and Syntax. * Created FTP scripts for moving source and target files * Tuned SQL statements for end users creating custom reports * Data Migration From Oracle to Teradata. Mappings the following Subject Areas: a) CALL USAGE B) ROAMING C) RECHARGE D) CUSTOMER PRODUCTION E) TABS F) INTERACTION (CALL CENTER) G) IMEI H) LMS (Loyalty Management System) & CMS (Campaign Management System) * Creating WorkFlow and WorkLet and also Managing sessions through WorkFlow. * BI Report (Daily, Weekly & Monthly) CHAIN Development for Banglalink BI Department. . Business Report creating through Teradata, SAP BO. * Developed SHELL SCRIPTS to transfer CSV & SEND EMAIL and for Mappings. * Banglalinks' (Orascom) existing Data Migration from Oracle to Teradata. * More than 1 Terabyte data migrated through Informatica9.1. * Design and develop test plans. Core Divisions: * Core Banking (Source System Analysis): Oracle Flexcube UBS Release(10.5,11.2,12.1,12.2). * Enterprise - Oracle Applications, Oracle Forms, Oracle PL/SQL, Business Analytics * Mata-mart - Oracle, Teradata, MS SQL Server 2012 * Databases - Teradata13.1, Oracle 11g/10g, 9i/8i, SQL Server 2012/2008/2005/2003. * Sector Expertise - Project & Programme Management, Business Analysts (Telecoms, Financial Services & Banking, Utilties, Pharmaceutical, Retail, Hospital) * Business Intelligence & Systemology - SAP BO XI R3, OBIEE, Microstrategy. - Cube and Relational Data Warehousing techniques, OLAP, MOLAP and ROLAP. * ETL - Informatica8.5/9.1, OWB11g, ODI11g, SSIS etc. * Methods and Concepts - Data Modeling (Conceptual, Logical and Physical Relational, ER & Dimensional Modeling. Functional: .Risk Calculation Engine Development .Credit Risk Flow (Functional & Technical) .Market Risk Flow (Functional & Technical) .Operational Risk Flow (Functional & Technical) .Data Migration on ATM data, Card Division Data .Basel II Business requirements – Source system (.GL) To Basel Data Warehouse .Business Analysis . PD, LGD, EAD, RW, RWA calculation .Basel II Business requirements - Data warehouse to Risk Engine .Settings for the Risk Calculation engine .Risk Engine Results layer to Basel II reporting layer .Solution for National Discretions (Central bank Reporting) .Sample Source system , Data Warehouse & Risk Calculation data view
I have been working with 9+ years experience in Business Intelligence & Data Warehouse. Great experience in Database design, ETL processes and documenting business requirements, attending client request and development in ETL and OLAP. - ETL tools: Datastage (Server, Enterprise Edition e MVS), Power Center e Data Manager (Cognos ETL). - OLAP tools: Cognos 8.4, Business Objects (BO), Oracle Discoverer Good skills in development of SAP BW 7.0. I am a certified specialist in : IBM DataStage Enterprise Edition v7.5 - Certified Developer IBM Cognos 8 BI Reports - Certified Designer
I am a veteran in SQL coding, Big Data analytics, data modeling, business analysis, and reporting solutions. I am comfortable in Waterfall or Agile environments and have successfully engineered reductions in data delivery, end user execution, and operational improvements. I have sat in various areas within an organization including IT, Sales, and Finance which gives me a broad vantage of the needs of any company. Moreover, I have a natural passion for driving Big Data solutions and hit the ground running.
I am a multi-dimensional individual with multi-dimensional depth, skills, and experience. I have the unique ability to quickly size up user needs and develop a software tool and/or OLAP cube and/or database solution to meet those needs. I not only architect and design the solution but I also develop and write the code to implement it. Additionally, I can create user documentation for the solution and also create training videos and conduct training online and in person. One manager called me "a one-man coding machine" and declared that "Grant can do it all!"
Software architect and developer with more than 20 years of experience in Microsoft Development, Business Intelligence, database and desktop and web applications. Android development. Software and solution consulting. MCSD. Available for projects/consulting of any size