Ryan Blanchard

 Developer Details Full Name:Ryan M. Blanchard Cell:076 - Email- Nationality:South African Citizen ID Number:- Current Proficiencies LanguageLast UsedLanguageLast Used VB.Net2018 SSIS (Integration Services)2017 ASP.Net2018SSRS (Reporting Services)2018 WCF 2015 SSAS (Analysis Services)2017 C#2018Microsoft Access2017 MS SQL Server2017 Qlikview2011 Oracle (with PL/SQL)2017RM COBOL & Micro focus COBOL2005 VB62017MySQL2017 Skills Chart Databases Years of Experience Level of Skill *MS Access 6 5 COBOL IDMS 7 5 Informix 1 3 *Oracle 5 4 *SQL Server 6 5 *MySQL 2 3 Languages *C# 8 5 *VB.Net 5 5 *ASP.Net 3 4 *Visual Studio- *MS Access (VBA) 5 5 *PL/SQL 6 4 *T-SQL 6 5 *Reporting Services 3 5 *Integration Services 3 5 *Analysis Services 3 4 Master Data & Data Quality Services 1 3 Crystal Reports 3 4 Dev Express 3 4 Telerik 1 3 C 1 2 COBOL (Microfocus, RM, Acu) 7 5 FlexGen (RAD) 4 3 * = Current Employment History (Positions Held from current to oldest) Senior .Net DeveloperSep 17 – Aug 18 Enterprise Solutions 365 – Contract Position Duties:Software solutions development Application Infrastructure Mapping/Investigation Lead Developer (Team of 4) Business Analysis Tasks Requirements Gathering Business Specifications Technical Specifications Development Lead Tasks System Design and Development Sprint Planning Intern / Junior Developer mentoring Testing and Training at Client site Technology Used SQL 2008 – 2016) – SSIS, SSRS, T-SQL Power BI – Limited Exposure (Some minor reporting) .Net C#, VB, WPF, MVC MS Access Nop Commerce mvc framework (Kendo UI) Non ERP Developer / SQL DBA / Central Application SupportSep 15 – Aug 17 Vivo Energy (South Africa) – Contract Position Duties:Software solutions development Application Infrastructure Mapping Operational Database Management Capacity Management Application Management and Support Topdesk Support across 16 countries in Africa and Europe Continuous Service Improvements to Database, Apps and Process Oracle DBA assist and standin Documentation and policy draft (Change management, PMO) Data Transfer between various systems, clients and vendors Load, analyse and clean source data on a daily basis. Development of new industry and client dashboards Rollout and training of new solutions across countries Technology Used SQL 2008 – 2014 (DBA) – SSIS, SSAS, T-SQL .Net C#, VB MS Access Excel VBA GoAnywhere MFT Powershell Oracle Windows 8,10 2008, 2012 (System Adminstration) AWS JDE Top Desk Solarwinds MySQL DeveloperJun 15 – Sep 15 Accpick Duties:Import of Source Data from various propriety client Systems. Load, analyse and clean source data on a daily basis. Development of new industry and client dashboards PHP frontend, MySQL and linux backend. Including stored procedures and replication. Development of integrated online and mobile Point of Sale system. Support and maintenance of propriety accounting system in Flagship. Custom development and enhancements to propriety accounting system Technology Used MySQL PHP Linux Cloud based Virtual Servers (Linux Ubuntu / CentOS) Senior Application Development SpecialistFeb 14– May 15 Provincial Government WC – Transport and Infrastructure (Contracting through Paracon) Contract Duties:Import of Source Data from various internal Systems. Load, analyse and clean source data on a daily basis. Development of new Personalised Number Plate Administration (NPAS) system. C# windows forms frontend, WCF web service and Oracle database with PL/SQL packages and procedures. Powershell script to import vehicle stats at weighbridge sites in Excel to Oracle database. Support and Maintenance of current NPAS system. Development of mobile Borrowpit Equipment Status application in Xamarin. Technology Used Oracle 10G/11G RDBMS, PL/SQL, Oracle Server Pages. C# Forms development, WCF Basic Powershell scripting Data Matching and validation Owner / Developer / AnalystNov 12 – Dec 16 Twenty12 Major Clients:Prodigy Finance Global MBA Student loan financing and investor platform.(London) Redevelopment of monthly statement cycle and investor payment process. (Access 2012 VBA) New application to handle student payments from bank statements (.Net C#) SQL Azure database to facilitate integration of various departments spread across different areas of the world. Various automation and VBA macro development in Excel and Access (http://www.prodigyfinance.com) Emerge Technologies U.S. manufacturer of retractable multimedia and computer cables (Texas) Maintenance and development of the company’s product catalog (Asp.Net and DNN) Ecommerce platform evaluation of various asp and php based platforms for consumer targeted sales Maintenance of shipping coordinator system, rewriting the import facility in SSIS Development of Product development workflow process on sharepoint online (Office 365) Additional support and ad hoc office automation development (http://www.myretrak.com) Performasys Custom application development, network monitoring and support (Washington USA) Remote support of various clients, and web applications Take on various over flow development work on new dashboard product (http://www.performasys.com) Other Projects: MS Access automatic upgrade automation, and function development. (www.vizibill.com.au - Austrailia) SSRS reporting on on companies calls, with PDF export. (www.vizibill.com.au - Austrailia) Formatting and printing reports in Excel from MS Access DB (USA) Developing Risk Analysis Survey tool in MS Access (www.vivoenergy.com – Africa) [Repeat project to additionally create a migration tool for this project] Support and enhancements of various ASP.Net websites using DotNetNuke Data Analysis dashboards using Telerik Charting Components. SQL Database Maintenance, Query writing Technology Used ASP.Net C#, VB SQL Server 2008/2012, Stored Procedures, functions, views. SQL Azure Reports using SSRS, Crystal Reports, ASP.Net and telerik controls, Qlikview SSIS, custom import scripts Excel, Access, VBA BI SQL DeveloperJuly 12– Nov 12 Old Mutual (Contracting through Paracon) Short Term Contract Duties:Import of Source data from various internal Systems: Load, analyse and clean source data on a daily basis. SSIS, SQL Server. Development of matching rules to match source data in recon process. Matching in SQL Procedures as per business defined rules. Development of statistical reporting on daily recon procedure and matching stats using views and Excel Pivot Tables. Ad hoc development and support around once off reports, data fixes, data extracts. Started building automated front end for daily data loads and rule matching procedures in SSIS, TSQL with a basic MS Access front end. Technology Used SQL Server 2005, stored procedures, functions, views. SSIS Excel Pivots Access Senior .Net DeveloperJuly 11 – June 12 Shell (Contracting through Paracon) Short Term Contract Duties:Development of: Fuels Pricing System used in Central African Countries in ASP.Net and SQL Server. Greenlight, a management KPI dashboard used in all African Countries. AppsMaster, A software repository/knowledge base of all African in house and 3rd party software. Assisted and supported various projects and applications. SQL Server, ASP.Net, VB6, Oracle, SSIS, SSRS. Various other development and automation tasks to assist the divestment team, or reproduce basic functionality of existing systems for divested Countries. Technology Used ASP.Net / VB.Net / C# VB6, VBA SQL Server 2008/2008 R2 including stored procedures SQL Integration Services, Reporting Services Oracle and PL/SQL Excel, Access, Word Business Intelligence ConsultantMay 11 – June 11 36 Boutiques (Contracting through 3fifteen) Short Term Contract Duties:Development of FashionDB to feed online website with Fashion merchandise. ETL of Stock sheets into Fashion DB using SSIS and stored procedures. Development of Data warehouse. ETL of products from FashionDB using SSIS and stored procedures. ETL of sales transactions from O-Centric (Web frontend developed) and Bookmaster (COBOL based warehousing system). Sales reports developed in SSRS. Technology Used SQL Server 2008 R2 including stored procedures SQL Integration Services, Reporting Services Business Intelligence ConsultantJan 11 – Apr 11 Business Intelligent Duties:Development of various BI solutions in Qlikview. Using SQL Queries, SAP Connectors as well as various other methods of ETL'ing Data into Qlikview analysis models. Technology Used Qlikview SAP BW – Data extraction SQL .Net Developer / SQL Developer Ford Motor Company of South Africa Nov 10– Jan 11 Short Term Contract Duties:Support of various manufacturing and HR systems in VB6, VB.Net and ASP on SQL Server 2005/2008. Development of a telephone call management and reporting system using SQL Server 2005 database with SSIS, and stored procedures/functions for data extraction from the Cisco IP phone system. Reporting done in SSRS and ASP.net. Conversion of an Employee Benefits HR system from Access into SQL Server and ASP.net with Reporting Services reporting, and SSIS data imports and exports. Technology Used SQL Server - Integration Server and Reporting Server ASP.Net VB. Net VB6 PL/SQL DeveloperOct 09– Apr 10 Infomet Contract Duties:Development of PL/SQL ETL packages to load various banking systems into a generic business database for Client Profiling (Investec) and Risk Management (Nedbank). Assisted with the development of various reports and cubes that reported on the data that had been loaded into this generic business database. Technology Used Visual Studio 2008 Oracle (PL/SQL) SQL Server - Analysis Server and Reporting Server C# Dev Express Components VB.Net / Crystal Reports Analyst DeveloperSep 07 – Sept 09 Provincial Government of the Western Cape (e-Innovation) Contract Duties:Development of various HIV, TB related reporting for the first TB/HIV integrated clinical management system. Ongoing development on the award winning Primary Health Care software suite. Technology Used Visual Studio 2003 / 2005 Oracle (PL/SQL) SQL Server Crystal Reports VB .Net DevExpress Components GUI Components Reporting Charting Residential Rental AgentMay 07 – Sept 07 Wendy Machanik Properties (Sea Point, Cape Town) Commission Only Duties:Manage portfolio of current rental properties and tenants. Solicit and Market new rental properties and match to tenant list. Developed Properties/Tennant database and matching application in VB .Net and Crystal Reports, to streamline my matching and marketing process with basic CRM functionality. Technology Used Visual Studio 2005 SQL Server 2005 (Express) Crystal Reports VB .Net Microsoft Access Analyst ProgrammerJul 06 – May 07 Expecton (Pretoria) Package Duties: Development of mobile cash collection system using CE based PDAs, Woosim bluetooth hand held printers which integrated into the main SQL Server based Policy management system. Maintenance and enhancement of the main Policy Management System (Visual Studio 2003 / 2005 VB, ASP and Crystal Reports, VB6). Research and development of new systems to aid the finance and sales departments. Client support and installation (Remote and on site). Technology Used Windows CE SQL Server CE / 2000 Visual Studio (2003/2005) ASP .Net VB .net Crystal Reports Infragistics Web Components VB6 Support Consultant / MS Access DeveloperApr 05 – Jul 06 Greatsoft (Cape Town) Duties: Sole responsibility of support maintenance. Enhancements of 4 Company Secretarial Software Packages & Financial Packages. Technology Used Visual Studio 2005 Access 97 SQL Server Crystal Reports 8 VB6 VB .Net ASP .Net Analyst ProgrammerJun 04 – Mar 05 Intimate Data (Cape Town) Contract Duties: Responsible for the development of the National address database to supply marketing & statistical data to clients. Client Liaison & Follow Ups. Technology Used COBOL Micro focus SQL Server Access VB6 Analyst ProgrammerFeb 01 – Jan 02 Shoprite Checkers (Cape Town) Contract Duties:Responsible for branch support of back office software. Developing the branch Price Information Circular. Client Liaison. Technology Used COBOL Micro focus FlexGen UNIX TCP/IP FTP C Informix / Oracle Analyst ProgrammerJan 98 – Jan 00 MB Computer Systems (Harare, Zimbabwe) Duties:Development of tailor-made solutions using various COBOL packages, databases & networks, as well as hardware. Technology Used FlexGen UNIX COBOL - RM, Micro focus & Acu Sco Xenix Programmer & Support ConsultantJan 96 – Dec 97 Reliant Computers (Harare, Zimbabwe) Duties:Responsible for support & development of financial packages. Custom solutions (software / hardware / networks) for clients. Technology Used COBOL – RM, Micro focus & Acu VB 4/5 Crystal Reports Sco Xenix UNIX Oracle Crystal Reports 2 Contactable References Gabriel Le RouxES365 / Vivo / Shell083 - Warren Holl Shell / Vivo021 - Rory Bosman3fifteen082 - Nick BellBusiness Intelligent- Rob CrothalFord- Jacques De VilliersPGWC- Unconfirmed Client References (I have not asked them if they would mind providing a reference) Sam Straub Performasys (USA)--Billy ScullionEmerge (USA)- Product-Aaron FuchsProdigy Finance(RSA)- Product-Gilbert SevereVivoEnergy (Mauritius)- HSSE- Education Institution: John Orr Technical High School Highest Grade Passed Grade 12 (N3) Year of Final Grade completed 1995 Tertiary Education Institution: C.F. Tully Associates (Harare, Zimbabwe) COBOL Programming Diploma Year of completion 1996 Other Courses Institution:UNISA (Current – 1st Year) BATCHELOR OF SCIENCE in INFORMATICS Subjects – Intro to Programming (C++) Human Computer Interaction Business Management Financial Accounting Institution:Dakota Training (2000) Delphi and Oracle Programming Institution: Shoprite – In-house Training (2001) UNIX Scripting Institution: Microsoft: Touchdown Program (2005) (Pre-Launch Developer Training Sponsored by Microsoft) Visual Studio 2005 (VB & ASP) SQL Server 2005 Windows Vista Institution: SAS Data Management (2010) Prog I and Prog II Institution: Qlikview (2011) Model Design Model Development