Nolan Steven

34 ST Pauls avenue, unit 1 ST Pauls gardens, Reservoir hills, Durban, South Africa, 4091 [Cell]:- [E-mail]:- NOLAN STEVEN ___________________________________________ Personal Information  Date of birth: 15:03:1987  ID no:-  Language: English  Health: Excellent  Marital Status: Married _____________________________________________________________________ Education [-]: Stanmore Secondary School, Phoenix, Durban [Pass Attained]: Matric Exemption [Subjects]: English, Afrikaans, Mathematics, Biology, Accounting, Geography [-]: Oval International Computer College, Smith Street Durban [Pass Attained]: Diploma: IT-Business Information Systems [Subjects]: ▪ Development Software [1, 2 & 3] ▪ Commercial Programming [1, 2 & 3] ▪ Information Systems [1, 2 & 3] ▪ Strategic Management [3] ▪ Management Fundamentals [1] ▪ Economics [1] ▪ Marketing Fundamentals [1] ▪ Total Quality Management [1] ▪ Small Business Management [1] Work Experience [Temp Position]: Woolworth’s- Gateway [Duties]: Stock Controller Sales Assistant [Time frame]: Jan 2005 – Jun 2005 ____________________________ [Temp Position]: Glenore Café- Glen Ashley [Duties]: Cashier, Driver, Assisted In General Maintenance of Shop [Time frame]: Jun 2005 – Dec 2005 __________________________________ [Permanent Position]: Interactive Solutions [Job Description]: Dialer Database Administrator [Time Frame]: Jan 2009 – Oct 2011 Worked on International, local inbound and outbound sales, customer services. [Permanent Position]: Call Centre International [Job Description]: Dialer Database Administrator [Time Frame]: Oct 2011 – Feb 2012 Worked on International, local inbound and outbound sales, customer services. Database MSSQL [Permanent Position]: Talksure SA [Job Description]: BI, Data & Dialer Manager [Time Frame]: Feb 2012 - Current Worked on Database MSSQL & MySql, For International, local inbound and outbound sales, customer services. Inbound Digital marketing, Call recordings QA, KPI/ KPA. _____________________________________________________________________ Accreditations and Licenses  Drivers License: Code 08 _________________________________________________________________ Skills and Competencies Data reporting: To assist business / department heads Data analytics: Reporting to business owner Data analytics: To increase performance in sales environment SQL & MYSQL: Scripting, Stored procedures & Automation Data profiling Data management Database maintenance and alerts Programming Languages - Visual Basic, SQL, MYSQL Pastel Partner - Accounting System IT & Business Skills: Microsoft Office skills Excel advanced Dialer skills – Real connect, Presence, Amcat, Touch Star, Vicidial, Connex one & TCN API creation between dialing system & Eternal systems Manage dialing rules, regulations & strategies Main Liaison between dialer provider and telecommunications provides Call recording migration Quality checking of calls Current Job description: • • • • • • • • • • • • • • • • • Query writing to extract data for reports using MSSQL. Created stored procedures for reports using MSSQL. Created scheduled alerts in the form of MSSQL jobs Created a daily maintenance plans to back up database to external storage using MSSQL. Created package to import files directly into MSSQL database Assist Junior BI, Data and IT infrastructure team to fix issues with database, such as table locking, improve performance on databases by running monitoring tools, connection timeout issues, poor indexes. Created multiple MSSQL instances for different clients for our operation and product team to store information separately Created MSSQL logins for BI, Data & Dial team based on security level specifications Created data cleaning procedure to clean up client data on a daily bases when file comes through from client SFTP Created SSIS packages to import data, run data against various tables and push results to data and dial to have data ready for production. Created scheduled jobs to update data warehouse with multiple data entry points once information is capture by users of CRM system Generated MSSQL reports from client and production data for Executive team to analyze and make decisions. Created linked server between MSSQL and MySql to run backups from MySql to MSSQL Query writing in MySql. Created procedures to monitor live data counts using MySql Created events to update system configurations at specific days and times Liaised with numerous supplies to get telecommunications & Dialer area issues resolved. ____________________________________________________________________ References: Shaun Samson [Talksure SA] - /- Julian Herman [Realconnect / Connex one] -