Resume

Sign in

Sql Server Data

Location:
Ouderkerk aan de Amstel, NH, 1191, The Netherlands
Posted:
February 22, 2018

Contact this candidate

Curriculum Vitae

José Ricardo Correia Teixeira

Juliana van Stolberglaan

2595CK Den Haag

ac4kw0@r.postjobfree.com

SUMMARY

Resident in the Netherlands and available to be reallocated. I speak Portugese (native) and English (fluent). I have over 15 years of deep experience with database administration, design and development. I can perform equally well independently or as part of a team (Waterfall or Agile/Scrum). I take pride in working in focused, detail-oriented manner with an eye for producing high-quality, robust solutions tailored to client requirements and the problem domain.

QUALIFICATIONS

University of Madeira December 2012

Master of Telecommunications and Energy Networks Engineering

Engineering Faculty 1999

University of Porto (FEUP, Portugal)

Partial Masters (Fuzzy Logic), Taught Electrical and Computer Engineering, Branch of Industrial Informatics

Engineering Faculty September 1995

University of Porto (FEUP, Portugal)

Electrical and Computer Engineering: Automation, Control and Instrumentation

DATA-PROCESSING KNOWLEDGE

Languages

Specialist in: T-SQL, SAP HANA, MySQL, VB.NET, VBA

Familiarized with: MDX

Software

Data Base: Microsoft SQL Server (2005 to 2016), SAP HANA, MySQL, Excel power pivot table, Analysis services, Integration services, Reporting Services

Platforms: Microsoft Visual studio (SSAS, SSIS, SSRS, VB.net), Tibco Spotfire, QlikView, Microsoft R server. Microsoft Windows Server (2003 to 2015), Enterprise Suse Linux, Microsoft Windows (all versions)

RELEVANT EXPERIENCE

BI- Data Analytics Specialist

Nov 2015 - present

PDS - Petrotechnical Data Systems

Implemented the Seabed Open Data Model database to in SAP Hana, working in a Scrum team that followed CI method using Jira, Git, Gerrit, Jenkins and Nexus.

I redesigned a geological Clastics database to unify 3 different related data models and created the associated ETL processes.

I have redesigned a complete KPI data model for real-time Oil Drilling analytics to be more flexible, more precise, have better performance and simplify use by the client.

Created a high performance SSIS ETL process to get data from Oracle into SQL server.

Implement productivity reports with statistical process control techniques, statistical comparisons and clustering analysis for drilling optimisation.

Reports on Tibco SpotFire and MS Power BI, with on demand queries across multiples databases, making statistical analysis as control charts and clustering.

Mentoring a junior IT coworker in BI analysis, SQL design and implementation.

Team Leader of Exploration Division

Apr 2014 - Oct 2015

Madeira public administration

Implement ITIL and documenting management process for the maintenance team.

Manage the work of the team, assisting with their development tasks.

Define and implement a dashboard system in SSRS and SSAS to control the data quality and KPI

Define a data mart to change data structure form an event tables structure in a ERP data base to a state day history in the OLAP structure, and extract information from data. Define and implement the OLAP database structure.

Make all ETL processes to transform data and incrementally populate the fact tables and Dimensions. The major processes are implemented in stored procedures and the execution is coordinated with SSIS job scheduled by SQL agent. There are distinct modules to do all work in sequence and with multiple threads processing the cubes and dimensions.

Implement productivity reports with statistical process control techniques, Gantt Diagram and statistical comparisons with others similar processes for management purpose.

Coach a junior IT coworker in BI analysis

IT Engineer

Feb 2012-Mar 2014

Madeira public administration

Developing database for central disk share occupation management.

Compile normalize and geo-reference Madeira governmental data about all networks links, computers and software to make a database and build reports to support major planning decisions.

Integrating data in SQL server with integration Server, Reporting Server and .Net technologies.

Make a salaries data warehouse with ETL process and BI as a proof-of-concept for government administration.

Analyze agile/scrum methodologies, document, plan and make a proposal to adopt these techniques across the department.

Developing BI project for ERP analysis data and reporting to the mechanical maintenance department.

Team Leader of Software Production Division

Nov 2008 - Feb 2012

Department of Information Systems - Education and Culture Regional Secretary (SREC)

Team manager

Provide an analysis and response to the external audit report on the corporate network

Analysis of the survey software at SREC

SQL Performance analysis to identify performance degradation in a production software, including preparation of load tests before production.

Development of a tool for automated analysis of data for managing productivity of support service users

Provide support in preparation of tender documents

Participation in preparing the opinion of SREC on the draft Decree-Law sets out the legal construction of access and installation of infrastructure networks and electronic communication

Preparation and presentation of information sessions on productivity tool

Analysis of several software packages and assess their relevance to the SREC

Technical support in the analysis of large amounts of information to financial management.

Instigation of innovative technical management teams.

Develop a widely used technique (based in excel) for the analysis of large amount of traffic data to support problem identification.

IT Engineer

May 1996- Nov 2008

IGA – Investimentos e Gestão da Agua S.A. (Institute of Water Management)

Participate in SQL data definition and software requirements for a water quality database and laboratory management.

Make a software module to export data in XML format regarding water quality results, make a module for data quality management in laboratory, make multiples reports for data management

Administration and maintenance of the database in SQL server.

Development of multiples software on SQL and Visual Basic .net.

Develop an ETL process do transfer data from Baan ERP to ESRI GIS Database and create the alphanumeric data model to work in GIS

Construct reports integrating other SQL-based databases.

Define and orient the construction of a software for collecting rainfall and flow data treatment integrated with GIS.

Multiples data analyses based on Excel, MS SQL and pivot tables.

FORMATION / TRAINING SQL AND DATA ANALISYS RELATED

Information dashboards constructing

23/11/2013

Moc20480 Programming in HTML5 with JavaScript and CSS3 in Visual Studio

28/06/2013

Moc 10776 Developing Microsoft SQL Server 2012 Databases

21/06/2013

Moc 6232 - Implementing a Microsoft SQL Server 2008 Database

11/04/2011

Moc 6231 - Maintaining a Microsoft SQL Server 2008 Database

10/21/2011

Advanced Techniques of Teamwork

25/11/2010

SQL + BI - Business Intelligence & SQL Server 2008

24/04/2009

2779 - Implementing a Microsoft SQL Server 2005 Database

Microsoft Certified Technology Specialist SQL Server 2005

06/22/2007

M2074 Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000

23/06/2006

Maintaining a Microsoft SQL Server 2005 Database

M2030 - Creating Reporting Solutions Using MS SQL Server Reporting Services

25/11/2005

M2310 - Developing Web Applications Using Microsoft Visual Studio. NET

Older (SQL, ArcGIS AutoCAD, Programming) courses

11/11/2005

REFERENCES

Available on request



Contact this candidate