Román Hernando Carnicero

Developing ETLs with SQL Server Integration Services(SSIS)/SSMS, maintaining the current SSIS ETL/SSMS (bugs correction, tuning …).Providing SQL Server DB Server management (locks, memory use, processes…). Performing DWH Design, data models/ETLs development to populate dimensional/tabular models. Working on the presentation/data model layer to prepare the data for consumption(PowerPivot models) Skills Used: SQL Server, SSIS, Excel, PowerPivot, Data Modeling,ETLs..

Developing ETLs with SQL Server Integration Services(SSIS)/DataStage. Adapting, Tuning and solving daily issues of the existing ones. In order to provide quality information DB development with SQL Server (DB models,DDL,scripting...), and query optimization working at the highest detail level dealing with performance issues. Giving guidance to other areas on best practices and technical solutions,Generating proper documentation/analysis for the current existing ETL/SQL ...

Working on the IT Department, on the DB/BI Area, performing from Analysis to DB development activities, plus giving guidance to the area external personal,resources Reports development, adaptation and solving daily issues of the existing Reports (SSRS) for business related changes(along with the stakeholders). DB development and query optimisation (T-SQL) for ETLs/Reports/ Apps related scripts (SP,functions...). Development of ETLs with Integration Services Packages/SSIS and C# ...

Carried out several projects with a high database degree of activity(MS SQL Server) : performed the DBs porting and the integration of an industrial production ERP (ASPROVA), the debug and extension of CAM applications (.Net, mostly C#). Furthermore, took care of the ERP incidences and undertook development of required new forms/reports (VB) and Business Intelligence Reports.

Development of a distributed solution to solve the Frequency Assignation Problem (FAP) in GSM networks: Developed and Optimized Evolutionary Algorithms ( GRASP) providing a competitive real solution in a limited time period(chiefly C++), undertook the Parallelization of the developed applications with Gridway(Grid Computing). Last but not least conducted a statistical study and analysed the ensuing results for paper publication.

I made part of the IT Department and more specifically of the DBs-orientated branch. I basically carried out DB tuning and development related activities(mostly MS SQL Server): implementing optimized SQL Scripts/SP/Functions/Jobs, mainly for ETL in big sized DBs; took care of DBs everyday maintenance, form development...

Operating Systems: Windows, Unix Databases: Oracle, SQL Programming languages: C/C++, Java, C#, .Net Coursework Highlights: Parallel Algorithms, Parallel and Distributed Programming, Vectorial Architectures, Database Management, Operating Systems Principles, Operating Systems Administration

On the Region top 5 Students of my Degree