Jhon Smith Email and Phone Number

Management of three key areas: systems infrastructure and communications, development and support.Reporting to company DirectorsCurrent Web project (up to 20,000 users), ASP.net Websites, Hyper-V, Load Balancer, IISGathering Requirements, Business CaseMicrosoft Tech. (VB / C# / ASP.net /SQL server/ SQL Server Analysis Services)Designed Application / DB / tables / Views / SP / BackupsReporting & BI: Qlikview, ,Crystal Reports, KPIDesigned infrastructures, Test performance

Freelance. (Configuraciones Integrales S.L., Murcia)http://www.configuraciones.net/wordpress/ http://www.vedoque.com/ (1 Oct – 31 Dic) Project for bespoke ERP(VS2010 C#, Sqlserver, LINQ, Entity Frameworks)Developed modules for ERP focus in small companies (invoices, sales orders and stock management, reporting anddashboard)(1 Jun 2012 – 15 Sep 2012) Project for Licour Store(VB.net 2010, SqlServer 2008 r2, crystal reports, qlikview 11)Designed and Developed a Picking System in real time with forklift and touchscreen, relays, lasers ms7820Metrologic for Warehouse control. Working in time real, walking optimising the shortest path, checking the referenceand stock in real time, controlling with sound and light signals controlled from the terminal relays. Centralizedmonitoring system for all Forklift to know exactly the position, status and sends orders of working. Receivinginformation of all orders and pending delivery routes, and preparing the information for billing and accounting.

Forte Group (Alicante, Spain) www.forte.esFHT is a leading business group in Spain, consisting of 5 companies, 12 factories and 5 trade delegations in Spain and Algeria, with a turnover of 200 Million Euros. With a view to expanding into North African and South American markets. Main sectors: civil construction, industrial buildings and urbanistic constructionDesigned the complex algorithms, data structure and storage, and supercomputing for the Ben Arabi supercomputer, one of the four largest supercomputer in Spain.(VB.net, C,C#) Designed and Developed a system for the construction of contention walls for motorways and railway lines. (C#, SQLserver 2k5, Crystal Reports)Designed and Developer warehouse system for the ERP (VB.net 2k5, SQL server 2k8 R2)Designed and Installed DB in SQLserver over win 2008 R2 for Electronic Invoice. (Tomcat, sqlserver, DB2, VmWare Sphere 4.5, Readsoft, OCR)Remodeled several programs in C# for complex engineering structures (C#, Crystal Reports).Developed dashboard for RRHH, Cost Control, Budget. (T-sql, sqlserver, DB2, Crystal Reports)Developed departmental reporting. (Qlikview 7.5, Qlikview Q10)Joined and Transformed of Data Marts, Files and DB into main corporative DB. (DB2, SQL server 2000 & 2008, Files, AS/400, WinServer, Linux)Designed an integrity test benchmark for all DB.Cost saving by implementing a virtualised infrastructure and Data Centre consolidation.Designed and migrated new infrastructures and communications to create a single corporate Network.

Fripozo S.A. and ELPOZO S.A. (Murcia, Spain) www.fripozo.com www.elpozo.comFripozo S.A and ELPOZO are members of Fuertes Group a leader in several sectors in Spain, with a turnover of 1500 Million Euros. Within Fuertes Group, Fripozo S.A. is the leading company in technology and innovation and was the first company of the group to implement SAP in 2005.Administered and Improved the heavy main Informix database: chunck, dbspaces, tables, index, views, performance,security, backup, scripts. (Unix & Win)Developed different modules for all departments (ERP for financial, marketing, commercial, production, logistic,quality, RRHH) (VB.net, Informix, 4gl., Crystal reports)Designed a performance bench for SAP (Oracle) and Informix ERP.Developed an intelligent software system to minimise the cost per hour per worker optimising the shortest path withinlarge scale cold store facilities at -25ºC. (VB6, citrix & Ifx DB, Crystal Reports).Designed and Developed an intelligent software for robots working at -25ºC for picking. (VB.net. tcp/ip, citrix)Designed and Developed a online communication for SAP and old ERP based on unix mp/ras, SFTP, TPC/IP socket,unix C K&R, SAP R/3, .net, ETL sunopsis, Oracle DB, Informix DB, DB Access, 4gl.Designed and Developed a SAP R/3 WM application in VB6 with RFC and Crystal Reports X.Designed and Developed dashboard. (financial, marketing, commercial, production, logistic, RRHH) (Crystal reports)Migrated all projects from VB5 into VB6, Agile environment.Migrated the logistic system from VB6 into VB.net & Crystal Reports X, Agile environment.Managed of full cycle life for Logistic, warehouse and Production Planning (vb.net, 4gl)Designed and Developed a system to maximise the good transported in limited spaces by boat.Team Lead in SAP project (PP, MM, WM).Designed unit testing & integration testing for migration into SAP for PP, MM and WM modules.

(VB6, DB access, Crystal Reports, VSS, Informix DB, 4gl)Designed a system for logistic, warehouse, picking, Production Planning (VB 5.0, Agile )Designed unit testing & integration testing.Co-Designed the methodology of developing desktop client server applications, using n-tier (5).

Analyst / Developer (VB basic 5, DB access , Delphi, Cristal Reports, Borland C++)Main activities / responsibilities Designed and programmed of a full system for a chemical industrial and clinical analysisDesigned and programmed history clinic for dentist center and hospitals.Designed a laboratory with PLC, sensors and computerDesigned and programmed of system computer for Standard EN-45.001 and I.S.O 14.000