SQL Server
Resume:
Ricardo Gerhard
**** **** **, ***** **********, Florida - US
Telephone: +55-48-984**-****
Email: aczkdn@r.postjobfree.com
Skype: aczkdn@r.postjobfree.com
Married, brazilian, 35 years
Academic Education:
2016
Data Scientist - Johns Hopkins University (in-course)
2011
Postgraduate IT Governance
Entity: Senac
City: Florianópolis, SC, Brazil
Project: Standardization of Process Documentation, Methods and Policies
2008
Bachelor Degree in Information Systems
Entity: Faculdade Cenecista de Joinville
City: Joinville, SC, Brazil
Project: Portal for outsourcing IT services
1998
Technical Degree in Systems Analysis
Entity: Evangelical Institution of Novo Hamburgo
City: Novo Hamburgo, RS, Brazil
Certificates
ITIL Foundation
Microsoft Certified System Administrator 2000/2003
Microsoft Certified System Engineer (ID: 3157309)
Microsoft Certified Trainer 2006/2008
Citrix Certified Administrator for Presentation Server 4
Cisco Certified Networking Associate (CSCO: 10743842)
Qlikview System Administrator
Qlik Sense System Adminitrator
Qlik Sense Data Architect (in-course)
Microsoft Certified Solutions Expert: Data Management and Analytics (in-course)
Courses
Entity: Modulo Education Center
Information Security / ISO 17799 - 2004
Entity: Cisco Systens
CCNA - Preparatory Course - 2002/2003
Entity: Microsoft
Windows NT Administration 4 – 1999
Windows NT 4 Support – 1999
Managing a Network Environment Windows 2000 – 2004
Implementing Windows 2000 Professional and Server – 2004
Basic Concepts of Windows 2000 and Network – 2004
Implementing Windows 2000 Network Infrastructure – 2004
Creating Directory Services Infrastructure for Windows 2000 – 2004
Implementing and Administering Windows 2000 Directory Services – 2004
I Latin American Symposium on Microsoft Security – 2004
II Latin American Symposium on Microsoft Security – 2004
Windows Server 2003 - New Features – 2004
Deploying and Managing Microsoft ISA Server 2000 – 2004
Administration of Microsoft SQL Server 2000 – 2005
Updating MCSA 2000 Knowledge for MCSA 2003 – 2005
Implementing a Database in Microsoft SQL Server 2005 - 2009
Entity: Marisol Calçados Ltda.
Leadership training and self-knowledge - 2004
Entity: Faculdade Cenecista de Joinville
IT Project Management Workshop - 2006
Entity: Datasul Tecnologia
Itil Foundation Training
Entity: Qliktech
Train to Trainer (2012)
Qlikview Developer I (2013)
Qlikview Developer II (2014)
Experience
Qlik Elite Master Reseller - TOCCATO Tecnologia (Feb/2012 to date)
Role: BI Consultant/Technical Support Engineer
City: Florianopolis, SC, Brazil
Role assignments:
- Management of support contracts, service levels, projects and quality of service;
- Implementation of environments with high availability (Brazilian Government, Tractebel, Bunge, Boticário, Grupo Globo, RedBull, etc);
- Main point of contact Qlik USA support;
- Prospecting new clients;
- Support to consulting and commercial teams;
- Consulting Services in infrastructure Qlikview / Semse;
- Instructor Qlikview and Qlik Sense;
- Creator of Qlik Training Academy Toccato;
Main changes: creation of new products and services for the commercial area; Regularization of management system for extraction of information; Unification of credentials with customers; Improvements in SLA;
Projects:
- Development, deployment and training of more than 300 large customers;
- Proofs of concept in projects over 1million;
- +1200 students trained in Qlikview and Sense;
- Increase 5x revenue;
- Recovery of target accounts;
- Integration of solutions with third party mechanisms and IIS;
- Instructor and creator of the TOCCATO Academy training;
- Integration with Netware, Oracle, SAP platforms;
- Development in Nprinting, Expressor, SAP, Workbench, QAP, ASP, QlikView and Qlik Sense solutions
- Creation of packages of specialized consulting services;
- Migrations BO, Tableau, SSRS for Qlikview / Sense;
- Consultant responsible for the implementation of the largest sale of Qlik Sense in Latin America 2016 (Tramontina) and biggest sale Qlikview Latin America 2014 (O Boticário)
AytyCRM (Abril/2011 a Fev/2012)
Role: SQL Developer
City: Florianopolis, SC, Brazil
Role assignments:
- Team leadership in new projects;
- Develop data import and export routines for clients in Latin America;
- Analysis and support of the company's products;
- Product management with analysts and developers at lower levels;
Main changes: agility and improvements of daily routines; Reduction of the time of implantation of new accounts via automation;
Projects:
- Implementation in clients in Mexico, Colombia, Argentina;
- Growth of the size of the clients in 2 times with the same structure;
- SQL, Oracle and MySQL development;
- Agility in development processes;
- Modularization of Java product;
- Reduction of response time to demands;
- Reconstruction of high cost routines;
- Adoption of Scrum methodology and Extreme Programming;
- Extraction generator and dynamic reports;
- Integration with other partners;
Nova Datacenter (Nov/2010 a Mar/2011)
Role: IT Manager
City: Joinville, SC, Brazil
Role assignments:
- Responsible for all management of all teams of the four companies in the group (computing environment, telephony, connectivity and systems;
- Coverage in all basic services, as well as studies of integration between environments;
Main changes: Breaking of myths, redesign of the environment for the coming years, stability of the environment close to 98%; Savings in the acquisition of equipment; Rationing of global telephony expenses with internal projects.
Projects:
- ERP / ECM migration to TOTVs;
- Virtualization of servers;
- Unification of telephony services with cost management;
- Datacenter Migration;
Segware do Brasil Ltda (Oct/2008 a Oct/2010)
Role: Team Leader and Support Analyst III
City: Florianopolis, SC, Brazil
Role assignments:
- Responsible to coordinate analysts level 1 and 2;
- Development of new functionalities;
- Migration databases of third-party software (Mysql, DBIsam, Oracle, SQL, FireBird) to own platform (SQL Server);
- Internal team and customer training;
- Support in proprietary software improving usability, accessibility and reduced attendance;
- Analysis, testing and homologation of new resources for release;
- Creation of deploy routines, enabling the exploration of new clients and the update of 100% of the remote portfolio;
- Exhibitor at fairs and consulting in the segment of the company;
Main changes: exploration of new functionalities; Implementation of continuous improvement methodology; Reduction in the number of services, enabling the company to grow without new hires; Automation of installation processes, updating and maintenance of software; Implementation of change management, release and problems;
Projects:
- Packaging the solution for rapid dissemination and online;
- Stabilization of large clients (+2 thousand sessions);
- Management of releases;
- Delphi environment for Java conversion;
- Member of the change and development committee;
- Adoption of Scrum methodology;
- Automated data extractor;
- Integrations with other platforms;
TOTVs/Datasul S.A (Feb/2007 a Oct/2008)
Role: Team Leader / Support Analyst
City: Joinville, SC, Brazil
Role assignments:
- Responsible for the coordination / support of team of analysts of 2nd / 3rd level Microsoft and management of heterogeneous environments of large clients (hardware / software / telecom);
- Analysis of levels of satisfaction and quality of care of internal users;
- Support and creation of plans of capacity / continuity / projects of migration and technological update of servers using products Windows Server 2K / 2K3 / 2K8, SQL, Exchange, DataProtector, Trend, Citrix, Go-Global, VOIP, Sharepoint, Linux, Cisco, VMWARE;
- Contract management and IT committee participant;
- Support for database teams and integration consulting;
- Internal training in Windows Server 2003;
Main changes: insertion of contracts by scope; Creation of verification routines; Reformulation in the form of monitoring; Creation of routines of process automation and recidivism; Provide the vision of change management and engagement in major maintenance; Team training in Windows Server 2003; Creation of portals and forms of documentation; Reduction of performance problems in critical applications; Cost and benefit analysis in more impactful scenarios;
Projects:
- Move Datacenters (+400 servers);
- Creation project TOTVs Saas, IaaS;
- Upgrade servers Windows Server 2003, Exchange, Sharepoint, Citrix;
- Outsourcing of services to business units;
- Manager of the Systems Committee;
- Manager of the change committee;
- Leadership of servers and help desk teams;
- Creation of team training;
- Stabilization and Progress update;
Microsoft Partner - Integral Informatica Ltda. (Sep/2005 a Feb/2007)
Role: Outsourcing Team Leader / Support Analyst
City: Joinville, SC, Brazil
Role assignments:
- Incident support on client servers with Windows Server 2K / 2K3, SQL, Exchange, Citrix, SharePoint, ISA Server;
- Responsible for the coordination of team and support of analysts of 2nd / 3rd level in charge of managing environments of large clients (Bunge, Amanco, Cargil);
- Migration projects / backup site of large companies in the region for Data Centers with Microsoft / Citrix technologies;
- Projects of portals with Microsoft technology;
- Installation of Citrix and Microsoft servers with high availability;
- Creation of documentation of software and business procedures seeking to reduce work;
- Trendmicro Migration Project;
- Internal training in Windows Server 2003;
Main changes: reduction of unnecessary activities; Creation of work routines and lines; Document generation / site / industry processes to align work with customer needs, reduction of time in service;
Projects:
- Move Bunge (+250 servers);
- Windows Server 2003 migration to clients such as Bunge, Amanco, Cargil (+600 servers);
- Creation and management of services outsourcing services;
- Idealizer of solutions for agility IT services (new product portfolio);
- Update Citrix Presentation Server 4;
- Site Backup Amanco;
- Member of the change committee;
- Team leadership Support, Development and Servers;
- High availability Active Directory and IIS;
Marisol Calçados Ltda. / Marisol SA (Mar/2002 a Aug/2005)
Role: Support Analyst
City: Novo Hamburgo, RS, Brazil
Role assignments:
- LAN / WAN / Hardware / Software / ERP / telecommunication / VOIP infrastructure management with 3Com and Cisco equipment;
- Standardization and automation of the support services, industrial automation of the matrix, as well as subsidiaries;
- End-user support, Microsoft servers, Solaris, Novell, support analysts of the Marisol and erc's group;
- Implementation of policies and standards;
- Coordinator of the Systems and Administrative Committee;
- Citrix and Trendmicro deployment projects;
Main changes: duplication and modernization in the hardware and software in the company; Full park review with implementation of possible security policies; Change in the relationship of areas with IT department; Implementation of corporate culture; Reduction of expenses and attendance in more than 50%; Standardization and automation of software installations.
Projects:
- Coordinator of the services committee;
- Optimization of communication links;
- Unification of the operating environment;
- Integration between remote units and headquarters offices;
- Redesign of the solution acquisition methodology;
Infowork Informatica Ltda. (Nov/1998 a Feb/2002)
Role: Technical Manager
City: Sapiranga, RS, Brazil
Role assignments:
- Responsible for the automation / administration / maintenance of networks of hospitals and health posts. Including Novell Netware 4.x / 5.x workstations and servers, Windows NT4 / 2000, Citrix Metaframe;
- Servicing network maintenance contracts, supporting support analysts and users, as well as messaging, connectivity and internal systems services;
- In charge of developing network designs for 1/2/3/4 layer infrastructure;
Projects:
- Redesign of solutions in hospitals (+100 desktops);
- Stabilization of large customers (hardware and software);
- Optimization of communication links;
- Implementation of access controls, data traffic and hospital management;
Flamiza Imp. Com. Repres. Ltda. (Sep/1997 a Oct/1998)
Role: Technical Assistant
City: Sapiranga, RS, Brazil
Role assignments:
- Assembly / Configuration / Installation of home, small and medium enterprises;
- First technician to install a Microsoft network by the company on clients;
- Installation / configuration / planning of small networks / Windows 9x / NT
- Customer service in the metropolitan area;
Other Works;
- Microsoft Instructor at Alfamídia Processor Ltda (Jun / 2005 to Aug / 2005-POA) administering official Microsoft Windows Server 2003 / XP training;
- Content editor of the site www.juliobattisti.com.br (2006), creating articles Microsoft;
- On-demand client consulting since 2003 with Microsoft, Citrix and Linux technologies.
Complementary Information
Languages:
English: reading, writing and good understanding; advanced diction (studying)
Spanish: writing, diction, reading and regular comprehension
Contact this candidate