
Warren Rocchi
Constable

Connect with Warren Rocchi to Send Message
Connect
Connect with Warren Rocchi to Send Message
ConnectTimeline
About me
SQL Maestro, DevOps Ninja, Data Engineer & Financial Systems Specialist
Education

Microsoft Virtual Academy
2013 - 2016Multiple Courses Computer/Information Technology Administration and Management Microsoft Certified ProfessionalActivities and Societies: Studying, research Warren is an active student within the Microsoft Virtual Academy and uses the courses offered to continually improve his IT education and assist him in attaining further Microsoft certifications. Warren achieved an accolade early in 2014 where he made it into the top 10 students within Southern Africa. He hopes to continue his studies within this framework and make it into the top 10 students internationally.Warren is currently a Silver status student within the framework and continues… Show more Warren is an active student within the Microsoft Virtual Academy and uses the courses offered to continually improve his IT education and assist him in attaining further Microsoft certifications. Warren achieved an accolade early in 2014 where he made it into the top 10 students within Southern Africa. He hopes to continue his studies within this framework and make it into the top 10 students internationally.Warren is currently a Silver status student within the framework and continues to improve his ranking and knowledge on a regular basis. Show less

INSETA (Insurance Sector Education & Training Authority)
2014 - 2014Certificate & Credits Financial & Insurance Services NQF Level 5Activities and Societies: Studying & Research Even though Warren is exempt from having to write his regulatory examinations due to his technical and administrative duties, he opted to do so in order to ensure that should compliancy ever become a requirement it is already met and in a bid to continue building on his previous gained insurance and financial certifications.

ITTI (Information Technology Training Institute)
2013 - 2014MCTS SQL Server 2008 Optimisation & Maintenance Computer/Information Technology Administration and Management Microsoft Certified Technical SpecialistActivities and Societies: Night Classes Warren attended and got his entire Technical core team at CIB to join him in the Microsoft 2008 SQL Server certification course. For some it was their first taste of SQL ever but for Warren it was the next conceivable step after his SQL Server 2005 MCTS though New Horizons.A firm and thorough relationship was formed between ITTI and CIB and after many successful courses CIB regards ITTI as one of its preferred IT education partners

FAISIT
2011 - 2012NQF Level 4/5 Insurance & Financial NQF Level 4/5Activities and Societies: Online courses, exams, lectures Becoming more involved in the business aspects Warren opted to increase his knowledge within insurance. FAISIT provided an excellent course in both basic short term insurance and basic financial knowledge.

New Horizons
2009 - 2009MCTS 2005 Computer Programming, Specific Applications Microsoft CertificationActivities and Societies: Studying, research Warren initially decided to certify the Microsoft route going through New Horizons training centre. He was disappointed to find out that the course he was doing was outdated and due to be deprecated. However he opted to finish the course as can be see under the courses section.

Sandringham High School
1997 - 2001Matric (GDE) Scholar Grades 8 - 12Activities and Societies: 2nd Team Rugby, Tennis, Swimming, Hockey, Athletics, Drama, First Aid Warren attended Sandingham High School from grades 8 to 12, hardly missing a day except for luckily by school policy, Jewish holidays as Sandringham had in the past been predominantly so. Warren enjoyed a steady group of friends throughout his school career, and was an active sportsman until he tore his anterior cruciate ligament in rugby. After that he continued to serve on the sports field but as a medic and first aid administrator. Warren ended off his schooling on a high note passing all… Show more Warren attended Sandingham High School from grades 8 to 12, hardly missing a day except for luckily by school policy, Jewish holidays as Sandringham had in the past been predominantly so. Warren enjoyed a steady group of friends throughout his school career, and was an active sportsman until he tore his anterior cruciate ligament in rugby. After that he continued to serve on the sports field but as a medic and first aid administrator. Warren ended off his schooling on a high note passing all subjects on higher grade with exemption and receiving his second bronze medals in academics.Warren's creative side was allowed to flourish when he was able to choose Art, Metalwork and Technical drawing in Grade 10 and these skills enabled him with his ingenuity and out of the box approach to meeting challenges in his later careers.On his parents advice he also carried on with Maths and Science to ensure that his options were kept wide open later on in life. Show less

Rembrandt Park Primary School
1989 - 1996Grade 7 GDE (half colors academics) Standard 5 (TED), Scholar, Grades 1 - 7Activities and Societies: Scholar patrol, environmental committee, soccer, tennis, badmington, hockey, swimming, art Warren attended his local primary school in the suburb he grew up in. He partook in the many sports the school offered and even at this young age gave of his time in his scholar patrol and environmental committee duties. Warren excelled in academics and started honing in on his creative ability through the fantastic art amenities offered by RPS. Many of the friendships forged in these early years are still rock solid today.
Experience
.webp)
South African Police Service (SAPS)
Jan 2003 - Jun 2008ConstableWarren joined the SAPS as a reservist but quickly found himself working shifts as a permanent force member. Due to his dedication and commitment Warren was approached to become an assistant in the North Eastern Firearms and Tactical Training unit. Here he trained members in firearm competency and hand to hand combat.

Specialised Operations and Risk Consultants
Feb 2004 - May 2004Soldier for hireDrawing on his experience garnered within the South African Police Service, Warren started contracting for SOPRCO who in turn contracted to SBV providing armed vehicular escorting of fidelity services. Warren also provided security services on the then under construction oil and natural gas pump station PSGII being built by Petrofac Lefarge in Russian occupied Tbilisi & Tetrisqaro, Georgia. Armed only with crossbows, primary duties were to maintain a secure perimeter of the construction site. Primary threats encountered were Russian military, Georgian mafia and Siberian wolves. Sometimes all at the same time and mostly before breakfast! Show less

CRU Design
Jun 2004 - Mar 2005Lead Graphic DesignerSynopsisWarren joined a small graphic design agency and their sister company in Mozambique. Much of their business came from the Mozambican Consulate and Edcon Maputo. Warren left Cru Design/Art C in order to pursue a career in IT. He still designs in his free time mainly for personal use, friends and family.Key ResponsibilitiesWarren managed the Johannesburg studio, met with clients and provided art direction for the design team. He would travel to, and work in Maputo as and when business required it. Show less

Art C Limitada
Jun 2004 - Mar 2005Lead Graphic DesignerSynopsisWarren joined a small graphic design agency and their sister company in Mozambique. Much of their business came from the Mozambican Consulate and Edcon Maputo. Warren left Cru Design/Art C in order to pursue a career in IT. He still designs in his free time mainly for personal use, friends and family.Key ResponsibilitiesWarren managed the Johannesburg studio, met with clients and provided art direction for the design team. He would travel to, and work in Maputo as and when business required it. Show less
%20Ltd.webp)
Tial Technologies (Pty) Ltd
Apr 2005 - Oct 2008Software EngineerWarren joined TIAL as a software engineer but quickly found his niche in supporting their flagship package. This is where Warren discovered SQL server and his love affair with the SQL language and managing databases began. Warren's quick learning ability and attention to detail culminated with him landing TIAL's flagship account and becoming Account Executive for TopExec Management Bureau. Warren's employment at TIAL ended in 2008 when he was headhunted and subsequently accepted the challenge at a small Administrator, however he still interacts with TIAL on an almost daily basis and the friendships and relationships he forged in those early years continue to assist Warren's career to climb.Key ResponsibilitiesWarren provided total support for (and for all related facets) TIAL’s short term insurance policy & claimsadministration system, SystemA. These responsibilities included supporting an excel based reporting solution, designing and maintaining complex crystal reports, maintaining, backing up, and replicating SQL databases via MSSQL, setting up and maintaining database & terminal servers through a client server system setup, installing and upgrading SystemA, MSSQL Server, Crystal Reports, MS Office and a variety of integrated applications. Show less

CIB
Nov 2008 - Aug 2015Warren also stepped up to the plate by assuming the IT Manager role (acting) when the urgent need for a leader of the IT Department arose towards the end of 2013. Without any formal IT qualifications, Warren relied on his ability to identify talented individuals, superior delegation and was instrumental in pulling together a broker department and rescuing a failing infrastructure. Warren continued to steadily hold the reigns whilst CIB sought for the perfect candidate to take their IT department forward. Asked why he did not pursue this position for himself Warren admitted that he wanted specialize in SQL server.Key Reponsibilities:All hardware, software networking and communication mediums used by CIB withthe exception of SystemA policy & claims administration system, CubeV3 reporting solution, Ratingengines and their associated databases. Full network Administrator access or can grantaccess to any location on the network via active directory permissions. Show less After starting as a department head within the IT core Warren once again climbed the ranks and his new core responsibilities were to provide stable, reliable short term insurance claims & policy administration systems and databases. Another crucial function that Warren fulfilled to was the continual development and improvement of the Systems, processes, products and offers within the organisation. He achieved this by managing an onsite staff compliment of 10 and several offsite resources. Warren reported directly to his MD and translated business requirements into effective and efficient technological solutions that took the company from strength to strength. Warren also took full advantage of the corporate infrastructure to study further and continue to further his expertise into the DBA and SQL fields.Key ResponsibilitiesDatabase Administration, transfer of data to and from various 3rd party service providers, costing,procurement & budgeting, all automated financial & bulk processes (raising premiums, creating collection files/ACB mag tapes, collection agency submissions, loading unpaids, ad hoc payment runs, increases, renewals (Inflationary increases, changes in cover, M&M devaluation), bulk SMS, emailing, mail merges, SMTP mail & web services). Facilitate workflow of requests via helpdesks, allocate work, designate tasks to staff & on site techs, streamlining processes, reducing and eliminating any bottlenecks. Full, accurate documentation/SOPs of all processes. Maintain servers (Page file, memory allocation, roles, set up as per Microsoft best practices, monitor / resolve capacity issues, Win updates & anti-virus definitions) Provision of highly confidential data for audits. Show less
IT Manager
Sept 2013 - Aug 2015Strategic Systems Manager
Nov 2008 - Jun 2014
%20Ltd.webp)
HostCo (Pty) Ltd
Jun 2014 - Sept 2016Operations ManagerAn integral cog within the upshot of HostCo (Pty) Ltd, from the initial concept Warren not only drew up business plans, built costing models and developed SLA's, but also led a team of experts in their field and fully implemented the infrastructure from beginning to end – This included needs analyses, custom product setup, training, website development, marketing, electronic & physical stationery, HR contracts and staffing issues. HostCo continued to attract more and more new clients and enjoyed a steady growth from inception. HostCo remains to function serving independent intermediaries across Southern Africa that require holistic administration solutions.HostCo was a huge learning curve for Warren, definitely a challenge to the status quo, and although the move from technical and eventually to business through management proved invaluable Warren couldn't help but every now and then to roll up his sleeves and get his hands dirty by thrusting himself into hugely technical tasks with no potential foreseeable solutions. Show less
%20Ltd.webp)
EBSphere (Pty) Ltd
Oct 2016 - Mar 2019Software Consultant & SQL DeveloperHired as a SQL Developer, Warren served as a consultant within EBSphere's K2 support team. Being completely at home in T-SQL and financial services he was based onsite at EBSphere’s largest and flagship client ensuring that business requirements are interpreted into technical specifications; and robust bespoke solutions were implemented with full continuity and scalability. Warren expanded his knowledge into new systems, databases and clients he was exposed to within the employee benefits industry.Key ResponsibilitiesProfiling clients through observation and mapping of processes. Identifying and rewriting inefficient code using advanced SQL functionality and optimisation techniques. Manage code in source safe and redeploy after thorough QA and UAT testing. Develop extensive HTML reporting solutions for client output needs. Show less

Dimension Data
Apr 2019 - Jun 2019Senior Data Warehouse Devops Specialist: Group GIS - EIM PlatformHaving recently joined Team DiData Warren has settled into the swing of things in Group Information Services on the Enterprise Information Platform. His current challenges are to internalise the support of a multi tier data platform whilst simultaneously building it's next gen replacement on SAP S4HANA on SUSE for Linux.

NTT
Jul 2019 - Aug 2020Senior Data Warehouse DevOps Specialist: Group I&T - EIM PlatformWith the mega-merger of Dimension Data, Nippon Telegraph & Telephone and 26 other companies; Warren continued to service Group Information Services on the Enterprise Information Platform. After playing a significant role in the IMO process he continued support of a multi-tier data platform whilst simultaneously architecting its next gen replacement on SAP HANA on SUSE for Linux.Key ResponsibilitiesDevelop and co-ordinate solutions in response to features and stories assigned to the team in a fully Agile environment. Support, monitor and co-ordinate resolutions for tickets, changes, problems and incidents logged to the team. Review and deploy solutions via TFS. Engage with relevant stakeholders obtaining authorization where necessary. Evaluate new technologies and build POCs. Refine backlogs, prepare design specifications and provide detailed solution documentation. Show less

NTT Ltd.
Aug 2020 - Jun 2021On successful implementation and ops handover, Warren once again looked for a challenge, and found it in NTT’s Cloud based Global eCommerce platform. Leveraging off his experience of managing support teams, System and DBA administration, DevOps and superior troubleshooting capabilities Warren started transforming the way the global parts of the team collaborated and worked together. Warren’s efforts were quickly recognized through promotion to senior engineer. Because of the social disconnect within the team caused by remote working, Warren implemented a Team Social Collaboration platform that consisted of fun monthly online social gatherings,celebration of birthdays and cultural events as well as recognition of individual and team milestones.Key ResponsibilitiesDevelop and co-ordinate solutions in response to features and stories assigned to the team in a fully Agile environment. Support, monitor and co-ordinate resolutions for tickets, changes, problems and incidents logged to the team. Review and deploy solutions via TFS. Engage with relevant stakeholders obtaining authorization where necessary. Evaluate new technologies and build POCs. Refine backlogs, prepare design specifications and provide detailed solution documentation. Build, Maintain and Monitor cloud infrastructure components and related services.Respond and manage incidents based on severity and SLA. Essentially ensure business continuity through scalable, robust business solutions with full continuity. Show less
Senior Engineer: Devops Direct
Sept 2020 - Jun 2021Engineer: Direct DevOps
Aug 2020 - Sept 2020

Cobalt Analytics
Aug 2021 - May 2024Data Engineer“Why Cobalt?” Well, we think it’s the perfect analogy for your data. It’s often hidden, relatively useless in the raw form, difficult to control, and even poisonous if used incorrectly. However, when handled by experienced and knowledgeable practitioners, it has practical applications that make it extremely valuable.Colloquially known as Goblin Ore, cobalt can be compared to the mischievous nature of data, and the havoc it can wreak when not controlled.The atomic number of Cobalt (27) is also the International Dialing Code for South Africa, our home country, and one in which mining plays such a vital role. It is commonly stated that data is now the most valuable resource in the world, and South Africa has always been at the forefront of valuable resources Show less

Moyo
Jun 2024 - nowSenior Data EngineerThe extensive footprint of our consulting services team, backed by our vast experience and industry knowledge, is testament to our ongoing commitment to enabling value-adding and industry-leading solutions for our clients.
Licenses & Certifications
- View certificate

Microsoft Certified: Azure Data Engineer Associate
MicrosoftSept 2022 - View certificate

SAFe DevOps (5.0) Certified Practitioner
Scaled Agile, Inc.Nov 2020 - View certificate

Certified SAFe® 5 DevOps Practitioner
Scaled Agile, Inc.Feb 2021 - View certificate

Microsoft Certified: Security, Compliance, and Identity Fundamentals
MicrosoftAug 2021 - View certificate

Microsoft Certified: Azure Administrator Associate
MicrosoftAug 2022 - View certificate

Microsoft Certified: Azure Data Fundamentals
MicrosoftJul 2021 - View certificate

Microsoft Certified: Azure Fundamentals
MicrosoftJul 2021 - View certificate

Microsoft 365 Certified: Fundamentals
MicrosoftAug 2021 - View certificate

Microsoft Certified Technical Specialist - SQL Server 2008: Implementation and Maintenance
MicrosoftJan 2014 - View certificate

Certificate in Graphic Design
University of JohannesburgFeb 2005
Honors & Awards
- Awarded to Warren RocchiProfessional Impressions - Men's winner 2015 CIB Insurance (Pty) Ltd & Professional Impressions Sep 2015 Warren was voted by his peers (fellow managers) as the best dressed male with the most professional impression in the Professional Impressions module Leadership Development Program. This prestigious award came with a professional wardrobe makeover
- Awarded to Warren RocchiLong Service Award CIB Insurance Administrators (Pty) Ltd Oct 2013 CIB Recognised Warren in October 2013 for 5 years of dedicated service to the organisation. The award came with a discretionary bonus and a certificate!
- Awarded to Warren RocchiWood Badge South African Scout Association Jun 2007 The Wood Badge is an internationally recognised qualification and represents the pinnacle of adult leadership within the Scouting fraternity. Being an active leader within the organisation it was a natural progression for Warren attain this acheivement.
- Awarded to Warren RocchiSpringbok Scout Award South African Scout Association Jul 2001 Warren had a lengthy and highly successful involvement with Scout Association South Africa starting out as a cub in 1989 at 1st East Park. He attained his Leaping Wolf in 1994 at 1st Glenhurst and carried on to earn the Springbok Scout award in 2001. He then continued as an adult leader moving to 1st Morningside in 2002 and running the Scout Troop until 2007 where he resigned to concentrate on his professional career. Warren also was the Assistant District Commissioner for Northern District and… Show more Warren had a lengthy and highly successful involvement with Scout Association South Africa starting out as a cub in 1989 at 1st East Park. He attained his Leaping Wolf in 1994 at 1st Glenhurst and carried on to earn the Springbok Scout award in 2001. He then continued as an adult leader moving to 1st Morningside in 2002 and running the Scout Troop until 2007 where he resigned to concentrate on his professional career. Warren also was the Assistant District Commissioner for Northern District and was awarded an honours scarf with gold braiding for long service. Warren is no longer involved in Scouts but was recently honoured by being the guest speaker for the Northern District Annual Patrol Leader's Dinner where he shared his experiences, lessons and enthusiasm for the future with the what he believes will be the next generation's future leaders of business and this country. Show less
Volunteer Experience
Group lead / Presenter
Issued by Data Platform User Group (Microsoft, Bryanston) on Apr 2017
Associated with Warren RocchiReservist Constable
Issued by South African Police Service (SAPS) on Jan 2004
Associated with Warren RocchiTrustee for HostCo (Pty) Ltd Employee Benefit Group Scheme
Issued by mCubed Group on Jun 2014
Associated with Warren RocchiGroup Lead / Presenter / Speaker
Issued by JSQL Usergroup Johannesburg (Microsoft, Bryanston) on Apr 2017
Associated with Warren Rocchi
Languages
- enEnglish
- afAfrikaans
Recommendations

Mack dickerson
Vice-President, Right of WayScottsdale, Arizona, United States
Long n.
Software Engineer with Nodejs/ReactjsHo Chi Minh City, Vietnam
Mostafa toson mba, itil,ssgb
Regional Director @ Quest Egypt | MBA, Business DevelopmentCairo, Egypt
Prakash kumar chaurasiya
💻 Web Designer | WordPress Developer | Content CreatorBirganj, Nārāyanī, Nepal
Honnie edwards
President/Broker Calabash Real Estate LLCChristiansted, St Croix, US Virgin Islands
Renita brown
Account Business Analyst at DXC TechnologyBlythewood, South Carolina, United States
Emilija k.
Cyber Security Analyst | AWS Security | SOCVilnius, Vilniaus, Lithuania
Bella martirosyan
Office Manager / Event ManagerYerevan, Yerevan, Armenia
Yanting cao
Accountant at Christopher Huang CPAs, PLLC(Passed CPA Exam)Greater Seattle Area
Tuấn anh nguyễn
Data Analytics Lead at TechX CloudHanoi, Hanoi, Vietnam
Mohammad shadab
Senior Technical Recruiter at The Judge GroupWayne, Pennsylvania, United States
Burhan doğan
Doğan Enerji Elektrik Saç Köşk Pano ÜretimTürkiye
Oldřich urban
IT Support Leader in Allegro Mall Group for CZ, SK, HU, SI and HR regionsPrague, Czechia
Inbal meir
Tech Project Manager | Customer SuccessTel Aviv District, Israel
Rebecca fairchild
Property Management Professional | Hospitality Expert | Licensed Real Estate Salesperson | Driven & ...Grand Rapids, Michigan, United States
Mylena merlo
Licensing Unit RepresentativeLangford, British Columbia, Canada
Hunter kilpatrick
Architectural Management Systems and Equipment Coordinator at Arvest BankFayetteville, Arkansas, United States
Lee hoverd
Senior First Officer at TUISolihull, England, United Kingdom
Ralf warnatzsch
Alles wird gutWaldbronn, Baden-Württemberg, Germany
Afsar mohammed
Music Composer / Operation ManagerMumbai, Maharashtra, India
...