MSSQL / ASE Database Administrator/BI/DW available

MSSQL / ASE Database Administrator/BI/DW

available
Profileimage by Anonymous profile, MSSQL / ASE Database Administrator/BI/DW
  • 64-300 Nowy Tomysl Freelancer in
  • Graduation: Bachelor of Commerce / PgDipCom (Information Science)
  • Hourly-/Daily rates: not provided
  • Languages: German (Elementary) | English (Native or Bilingual)
  • Last update: 04.01.2020
KEYWORDS
PROFILE PICTURE
Profileimage by Anonymous profile, MSSQL / ASE Database Administrator/BI/DW
SKILLS
I am a Data Professional with commercial experience in Business Intelligence, Data Warehousing, Database Administration, Database Development, Database Modelling, and Data Engineering. 

My list of experiences include roles that combine Reporting, Database Administration and Data Engineering.
  • MSSQL performance analysis and troubleshooting
  • T-SQL Stored Procedures
  • Building monitoring solutions 
  • Creating static and automated data pipelines to ETL for various reporting databases. (incl Replication)
  • Installation and configuration of SQL Reporting Services
  • SSRS report development and administration
  • SQL/ETL development (Custom scripts, GoAnywhere, Attunity Replicate & SSIS)
  • Building C# application that ingests CSV data and transforms to bulk import point-of-sale format.
  • Report and dashboard development
  • Ad-hoc SQL reporting
  • Power BI reports (desktop and cloud) and dashboards
  • Crystal Reports 2013 development
  • Database Administration of several production and development databases.
  • (SQL Server 2008 R2, 2012, 2017 On-prem & Azure)
  • SQL transactional replication
  • Installation and configuration of SQL Server instances
  • Monitoring and Alerting
  • Performance tuning and maintenance
  • Disaster Recovery
  • Database Security - Active Directory
 
  • Languages: Java, C#, SQL, HTML, CSS, Python, PL/SQL
  • Database: Oracle 10g/11g, MS SQL Server 2008, MS SQL Server 2012, Amazon RedShift, Postgresql, MySQL.
  • Software/Tools: Oracle Data Modeller, Sybase Power Designer, PowerArchitect, PLSQL Developer, Toad, Informatica PowerCenter, Tableau, SAP BOXI, Dynamics CRM, Hyper-V, OBIEE, FitNesse, IIS.
  • Operating Systems: Oracle Linux, Windows Server 2008 / 2012
  • Methodologies: Waterfall, Agile
  • Other: Technical documentation, academic research.
2018 Microsoft Power BI - beginners to advanced 
2013 1Z0-591 – Oracle Business Intelligence 11g Certified Implementation Specialist
2012 Microsoft Sharepoint 2010 Application Development
2012 Microsoft Dynamics 2011 CRM Customisation and Configuration

My personal website can be found at http://rankin.co.nz


PROJECT HISTORY


Mar 2015 - July Oracle Data Warehouse Developer – 
  • Implementation & maintenaince of Oracle PL/SQL Packages handling ETL process.
  • Development of SAP BOXI & Tableau reports and visualisations.
  • Implementation of FitNesse Automated Testing for PL/SQL packages.
  • Implementation of existing PL/SQL packages in Amazon RedShift using views.
  • Design and implementation of ERD data models for BD Ringer and Home Automation systems developed by ServusTech.
  • Performance tuning of SQL queries.



Jan – Mar 2015 Oracle BI Trainer (contract) 
  • Development of 10-hour video training series on OBIEE Reporting & Admin


Oracle BI Developer (contract)
  • Successful transformation of existing repository to extensible format.


Jun 2014 – Dec 2014 Overseas Travel
  • Travelled throughout South East Asia (Cambodia, Thailand, Indonesia)


Jan 2013 – Jun 2014 Web Developer -
  • Procured & deployed infrastructure for web-hosting.
  • Sole Web Designer & Developer in charge of creative & technical.
  • Configuration & customisation of Magento e-commerce platform & WordPress blog.



Feb 2013–Dec 2013 Oracle BI Consultant -
  • Rebuilt Oracle Financial Reports (Essbase/Hyperion Financial Reporting Studio) into OBIEE (Dashboards,Reports & RPD) for NZ Government agency.
  • Building Repository & Cubes (Essbase,OBIEE)
  • Map, monitor & troubleshoot ETL work-flows (Informatica/DAC) for OBIA implementation.
  • Built and configured OBIEE servers for New Zealand office. (Oracle Linux, Oracle 11g DB, OBIEE 11g, Informatica, ODI) which were then deployed Nationwide for use by consultants.
  • Installation and configuration of a Windows Server 2012 machine which incorporated Virtual Desktop Infrastructure, Domain Controller, Remote Desktop Services, and several Hyper-V virtual machines that were used for Oracle demonstration purposes New Zealand wide.


June 2012–Feb 2013 Technical Consultant
  • Oracle DBA – Manukau Institute of Technology (10g/11g/Linux)
  • BI Reporting (SSIS,SSRS)
  • SQL Server 2008 DBA for BMX internal system.
  • Infrastructure (Exchange, IIS)
  • Development of Microsoft Dynamics CRM Customisations (XRM,Plugin,Workflow)
  • Development of CRM Dynamics Portal web-site for Alumni Portal system. (Azure/C#,CSS,HTML)


2011 Test Analyst (3 month contract) - 
  • Daily defect verification, discovery and resolution of existing bugs.
  • Execution of test scripts on new builds of SAP Visual Enterprise Viewer, Author.
  • Acceptance testing for new builds.


2009 Intern Database Developer - 
  • Reverse engineered ERP Database (Microsoft SQL Server 2008)
  • Technical documentation and Data modelling (ERD) for existing and future schemas.
  • Designed and documented a multi-tenant schema for the new SaaS ERP deployment


2008 BI/Java Programmer (contract) 
  • Developed Java/SQL application to perform reporting and back-end queries
  • Developed 10 separate BI reports solely through SQL.
TIME AND SPATIAL FLEXIBILITY
Open
OTHER
http://www.rankin.co.nz
GET IN TOUCH

Message:

Sender: