I am a SQL Server Expert with 9+ years of experience. My primary skills include database management and development, performance tuning, BI and data warehousing, statistics, data mining and reporting. I have a Masters Degree in Mathematics, I am very adaptive, I can quickly understand any problems and deliver an accurate solution. My work experience includes several high profile companies in finance & banking, telecommunications, as well as high traffic internet companies, using the mentioned systems and methods on an everyday basis. Client feedbacks: "so, after your first work, our DBs are FLYING!" S.W. - MySQL database performance tuning "You've done a really excellent job. It's a weight off my shoulders and I really appreciate it." C.L. - SQL Server management and optimization
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.
Senior Data Warehouse-Business Intelligence (BI) Engineer/Architect, and Database (RDMBS) Developer/Administrator, with extensive hands-on experience in agile, fast-pace, cross-functional environments. Well-versed in all areas of system development life-cycle for centralized client-server, and distributed, multi-tenant RDBMS platforms; such areas include: data analysis, architecture, modeling, development, testing, implementation, and maintenance. Engineered and implemented transactional (OTLP) and analytic (OLAP) database applications for following industries: Healthcare Practice Management/Electronic Medical Records, Life/Health Insurance, Distributed Marketing Resource Management, On-line Payment Processing, Credit Risk Management, and Corp. Banking. Specializes in scale-up and/or conversion of monolithic client-server database systems into highly robust, scalable, distributed data service platforms, utilizing following architectural practices: Service Oriented Architecture, Software-as-a-Service, and Platform-as-a-Service. Designs and deploys DB applications for dedicated and/or hybrid, Operational and Data Warehouse/Mart systems, incorporating various development stacks, with following technologies: RDBMS (PostgreSQL 9.x, MySQL 5.x, Oracle 10.x, DB2); Data Warehouse (DW)/BI/BigData (Pentaho BI Server 4.x CE, Mondrian 5.x, Hadoop Hive); ETL/DI (Pentaho, Talend, Informatcia, DataStage); Reporting (Pentaho, Jasper); Data Modeling (Erwin, Embarcadero, Toad); Programming (DB: SQL, PL/SQL, MDX, HQL, Shell Script, PHP, Python, Java, HTML, XML); NoSQL DMS (Cassandra 2.x, MongoDB 2.x, Hadoop Hbase); Operating Systems (CentOS 6.x, FreeBSD8.x, Ubuntu 12.x, Fedora Linux 7.x, Solaris 10.x, Windows Server 2003/NT); Backup & Recovery Managers (pgBarman 1.2.x, Oracle RMAN), Load-balancing & High Availability (PosgreSQL Replication Clusters, Oracle RAC, HAProxy); VCS and CI (GIT, Jenkins, Chef); Project Management (JIRA, RedMine)
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!"
Dmitry Savenkov Agency Contractor
I am an experienced software engineering team lead with over 10 years of experience in software development/team leading/tailoring development processes to suit the customer's needs. I have experiene managing projects/building project infrastructures from the ground up. Also, I am fluent in English. I have excellent speaking, writing, and reading skills. My primary strength is being able to find solutions to complex problems (sometimes using non-standard approaches). I am never trapped by dogma that there are a few standard solutions and development processes that could tackle 90% of situations.
SQL Server and ORACLE Senior Data Warehouse and Business Intelligence Specialist • Responsible for developing the data integration platform necessary to support both operational data stores, and the enterprise data warehouse. The volumes and complexity of data are amongst the highest to be found anywhere. • Working with very large (10’s terabytes) 7x24 data environments, Enterprise-class Data warehouse architectures, Real-time and batch-based data integration. • Develop ETLs to load data to Data Warehouse including all stages from technical design to integration testing. • Develop real-time Data Integration components to load data to Operational Data Store. • Development of strategic information management reports. • Conduct peer-reviews of designs and code with other members of team. • Tuning of the Data Integration platform to provide optimal performance under ever-increasing data volumes. • Support of Data Integration platform across multiple production, pre-production and QA environments. • Produce software artefact in line with the specifications and quality criteria identified in each individual assignment. • Translate requirements (use-cases) into detailed and accurate solution design specifications, adequate for software development or customisation of standard software products. • Enforce the implementation of the available architectural blueprints for software solutions including infrastructure related aspects. • Implement change requests for existing applications or bespoke systems and continuously keep technical documentation synchronised and up to date. • Participate in the activities related to the design phase of the usability aspects for the targeted solutions and software products. • Contribute to data modelling design activities. • Contribute to writing handover and operational maintenance documentation. • Working with SSIS, SSAS, SSRS, SQL Server Management Studio, Accurev, Version 1, Test Track Pro, RT, ITS, Golden Gate, Enterprise Architect, Build Management, specific internal tools.
Oleg Lesov Agency Contractor
SoftCube is a reliable partner in business intelligence projects based on Microsoft and QlikView technologies. We really like business intelligence. You will significantly improve business results through right decisions based on business intelligence data
Subhash A. Agency Contractor
Extensiveexperience in Data Modeling/Architecture, Database Administration and Support for ETL, Data-Warehouse / Data-Mart applications using **Microsoft SQL Server**, **Sybase** and **Oracle**. Expert in planning, installation, configuration, managing and upgrading MS SQL Server 2005, 2000, 7.0 and MS SQL Server 6.5. 13+ years of industry-based database administration & development experience with MS SQL Server on Windows 2000 and NT with complete life cycle of projects. Leader of database management team with DBAs in 4 countries (US, Canada, India and Europe) with responsibility of 20+ production, QA and dev databases, managing various projects concurrently, meeting and beating target timelines. Solid logical and physical data modeling skills. Expert in ETL. Very strong Transact SQL coding skills. Extensive experience in designing, developing and implementation and support of robust web based OLTP databases with effective relational database design. Expert in performance tuning, back up and recovery of MS SQL Server and Windows platform. Experienced in setting up and maintaining replication with heavy traffic in OLTP. Experienced in supporting large teams of 30+ developers. Strong technical team leadership and management skills with excellent analytical background, presentation and communication skills. Consistently rated a top performer.
N Ahmed Agency Contractor
Data Rock Stars specialize in: Tableau, Tableau Server, Microsoft BI & Opensource BI (D3JS, Google Analytics) * Tableau * Tableau Desktop * Tableau Server * Tableau Advanced Training * Microsoft SQL Server BI Suite i.e. SSIS, SSAS, BIDS & SSRS * Oracle, PostgresSQL, MySQL * Amazon Web Services (AWS) * Excel reports & custom dashboards * Google Analytics, Adwords API, Maps API
I have comprehensive experience with designing Business Intelligence and analytics solutions, development and support. That includes Business intelligence reporting tools, OLAP data sources, databases and predictive analytics. I specialise in IBM Business intelligence solutions. Specifically I have experience with IBM Cognos BI enterprise and express, TM1, dashboards, complex reports, active reports, metadata modelling and SPSS. My professional skills include. uncovering client needs and recommending appropriate solutions and strategies, analytical thinking, reasoning, developing processes and strategies, accurately completing data research and analysis. I have a pragmatic approach to things, I am highly motivated and can adapt to any situation. I have a very creative mind. I always have a unique perspective when approaching an issue due to my broad range of interests and skills.