Senior Data and Business Intelligence Analyst

• May 2022 - Present

SSIS Technical Consultant

• Oct 2021 - Jun 2022

Senior Data Analyst

• Feb 2018 - Feb 2019

Collate and Analyze business data SQL Database server management SQL Database query development Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server. Enhancing and deploying the SSIS Packages from development server to production server Created Dax Queries to generated computed columns in Power BI. Performed advanced data query operations through the DAX, Python and PowerBI for generating ACFI reports and financial overview for business owners. Interpret data from core business processes into robust dashboards and reports Constantly evaluate data migration needs and implement as required using several tools such as Microsoft SSIS, MySQL Workbench and dB Forge for MySQL. Process data analysis, mapping and integration with other tools such as python and C# Performance tuning and Query Optimization. Utilize SQL Reporting Service to generate reports for business optimization Formulate Business Intelligence algorithms for data utilization Administer SQL Database and related components Report business data based for all internal systems Participate in the configuration and roll out internal ESB Show less

IT Systems Analyst and Business Support Analyst

• Nov 2015 - Aug 2017

Utilized Product Life Cycle Development processes to ensure adherence to project schedules and budgets. Analyzed system vulnerabilities and collaborated with IT and business teams to eliminate vulnerabilities in support of internal and external audits. Formulated, defined and documented system specifications. Defined application problems by consulting with clients to evaluate procedures and processes. Developed solutions by preparing and evaluating alternative workflow options Utilized Product Life Cycle Development processes to ensure adherence to project schedules and budgets. Analyzed system vulnerabilities and collaborated with IT and business teams to eliminate vulnerabilities in support of internal and external audits. Formulated, defined and documented system specifications. Defined application problems by consulting with clients to evaluate procedures and processes. Developed solutions by preparing and evaluating alternative workflow options

IT Specialist and Support

• Dec 2014 - Nov 2015

Provided base level IT support to company personnel. Resolved customer complaints and concerns with strong verbal and negotiation skills. Displayed courtesy and strong interpersonal skills with all customer interactions. Built and maintained successful relationships with service providers, dealers and consumers. Researched issues on various computer systems and databases to resolve complaints and answer inquiries. Assisted in the post-implementation troubleshooting of new applications and application upgrades. Show less

EMV Card Data Operations and Support/Software Engineer (Assisting Supervisor)

• Feb 2010 - Jul 2014

 To research and analyse system program and process needs through collaboration with other IT units.  System analysis (Identify technology limitations of existing card data operations systems and associated processes, procedures, and methods).  System design (create system blueprint and use cases for modelling a workable solution)  To develop applications that meet business needs and customer specifications.  Maintain in house production systems (Develop, manage, and support the various manufacturing automation applications)  Implement and execute periodic system review with respect to VISA, VERVE, ISO, PCIDSS and MasterCard specifications.  Utilise C#.Net, Java, Python, SQL/PL, HTML with CSS amongst other programming skills on a regular basis to debug existing system lapse as well as writing upgraded solutions.  Create and update user documentations for in-house technical use and end-user (customer) purpose  Troubleshoot system issues.  Carry out other card data operations activities. Show less