GetHiredToday

SQL Data Analyst

Posted on: 2019-05-01

An IT professional with 17 years’ experience gained in software and databases development, project management and IT administration. Seeking to utilise my skills and abilities as an SQL Data Analyst.

Soft Skills

Accountable, very organized, patient, solution seeker and a continuous learner.

Technical skills

  • Databases: Oracle, SQL Server, MS Access, MySQL
  • Programming: MVC, C#, VB.NET, VB, PL/SQL, JavaScript, Java, C++, C, HTML, XML, CSS, PHP
  • Project management: Planning, scheduling, change management, risk management, documentation
  • Data analysis: Data collection, cleaning, analysis, Microsoft Power BI

Technical Skills summary

  • 17 years’ experience in SDLC and software projects
  • 4 years in IT administration
  • 6+ years’ experience Microsoft Dynamics AX, 2012 Project Management
  • 5+ years Oracle 10g/9i database using PL/SQLto write stored procedures, functions and triggers
  • 8+ years SQL Server experience
  • 8+ years software development experience (C#, VB, VB.Net, Java)
  • Microsoft Office Suite, Visio

 PROFESSIONAL EXPERIENCE

 Assistant Director, ICT Business Systems (Dec 2017-Jan 2019)

Kenya Urban Roads Authority, Nairobi, Kenya

A Roads infrastructure state corporation with 300+ staff distributed across 10 regional offices

  • Managed all software projects in the organization
  • With a passion for programming and problem solving, developed a roads portal on SQL Server 2012/ ASP.NET Core MVC and used SSRS to create reports informing the business of missing attributes key for government reporting

Chief ICT Officer (Dec 2015-Nov 2017)

Kenya Urban Roads Authority, Nairobi, Kenya

  • Coordinated a cross functional IT operations team

Senior ICT Officer- Information Systems (Jun 2010-Nov 2015)

Kenya Urban Roads Authority, Nairobi, Kenya

  • Managed enterprise wide systems and user specific technical software
  • Successful implemented Microsoft Dynamics AX, 2012 ERP. Managed the project from requirements to post implementation. Lessons learnt in this project led to my growth in leadership, project management and risk management
  • Developed a HR leave module on C#/SQL Server

Team leader- IT Change management (Oct 2008-May 2010)

Telkom Kenya Limited, Nairobi, Kenya                                      

A fixed line telephony provider with 19,000+ employees distributed across the country and a 20+ software development team

  • Measured the impact of business changes in relation to systems within the SDLC cycle

Assistant Manager-Application Systems (Jun 2006-Sep 2008)

Telkom Kenya Limited, Nairobi, Kenya                                      

  • A developer and Supervisor on Oracle/C# platform with Crystal reports
  • A team member in the successful development of an internally developed Oracle/C# ERP
  • Championed the integration of standalone applications, reducing maintenance cost

Senior Systems Analyst Programmer, May 2004-May 2006

  • .NET/Oracle developer
  • Re-engineered the unit system from Oracle 6i developer front end to a web-based application.
  • Designed and developed large relational databases
  • Supported 200+ users in disparate remote locations
  • Developed a complex web based technical System that all fixed line exchanges in Kenya used for provisioning of telephone lines. This included training the users countrywide and supporting the new system.

IT Officer (Sep 2003-Apr 2004)

Petroleum & Industrial Services Limited, Nairobi, Kenya

  • NET/ SQL Server developer
  • Systems administrator

 ACADEMIC AND PROFESSIONAL QUALIFICATIONS

  • Masters-Master of Computer Applications (MCA)-2002

Bharati VidyaPeeth Institute of Management, Shivaji University, India       

  • Bachelors-BSc. Electronics- 1999

 Rajaram College, Shivaji University, India

  • Certifications and trainings: PRINCE2 Foundation, CISA