Experience

ENS

• South Africa
• Law Practice
• 700 & Above Employee

• Business Intelligence Analyst

  • Jul 2015 - Present

  System Analysis and Design:o Assist in determining requirementso Design reporting interfaceso Design standard reportsSystem Development:o Develop ad-hoc data extracts using Business Objects, SQL, SQL Server Integration Services and SAS (analytics)o Develop front end systems based on requirement specificationsSystem Implementation:o Ensure accuracy of extracted data prior to sending the results outo Implement new solutions including ETL projects, Business Objects Reports, Analytics and SQL extractsSystem Testing and Quality Assurance:o Perform testing to ensure information meets the requirements and accurately reflects the data of the source systemo Ensure the output data is accurateo Liaise with applicable people to ensure source data discrepancies are rectified.Support and Training:o Provide reports as requested by practitionerso Give day-to-day support and training to internal clients on: Business Objects report, data definitions on extracted data and data definitions of available dataSystem Maintenance:o Perform tests to ensure the warehouse and source system data remains alignedo Monitor system performance and exceptionso Attend to technical problems experienced on reporting systemsAdministration:o Ensure system documentation is in placeo Manage all aspects of scheduled reportingo Administer security on reporting systemso Co-ordinate provision of Performance Enhancement Discussion documentationo Idu support



Metropolitan Health Group

• South Africa
• Health, Wellness & Fitness
• 700 & Above Employee

• Business Solutions Modeller

  • Oct 2014 - Jun 2015



Sanlam

• Financial Services
• 700 & Above Employee

• BI Analyst

  • Sep 2012 - Sep 2014

  • Analysis and documentation of changes required to systems (functional and/or technical specifications)• Interpretation of specifications received (includes data models), if applicable• Updates of data model documentation• Assessing feasibility & impacts• Advising & recommending on appropriate solutions• Communication with clients in terms of requirements• Recommendations and cost / man-day estimates for implementing changes• Develop and maintain DataStage jobs.• Design, develop and maintain Business Objects Universes and Web Intelligence (Webi).• Implementation of changes into the production environment, as part of the change management process• Publishing of documentation as required to a central point• Problem solving and user assistance for own systems supported (functional, not technical)• Provision of hands-on training for own system and changes being implemented • Ensure to adhere to SLA in order to deliver to the client of the task is.Management of own time and delivery of tasks according to deadlines



PPECB

• Import & Export
• 300 - 400 Employee

• BI Data Analyst

  • Apr 2011 - Apr 2012

  • Ensure the BI meets service level requirements or agreements by ensuring accurate, reliable and timely reports are sent to customers.• Monitor business use and performance of the BI and provide feedback to IT manager and Programme managers.• Develop, manage, schedule and document BI operations and tasks, including extraction, movement, and loading, archival and aggregate table creation.• Development of OLAP Cubes• Maintaining existing and developing new Cognos reports• Maintaining existing and developing new SSRS reports• Design of SQL queries for ad hoc information extracts• Manage requests for changes and prioritize work based on business needs.• Extracting data from transactional systems and feeding it in real time to a data warehouse is a finely tuned process• Work with ETL architecture and monitor BI data usage, capture and maintenance of reporting metrics.• Assisting Project manager with project plan and project documentation



PBT Group

• South Africa
• IT Services and IT Consulting
• 200 - 300 Employee

• BI Business/Data Analyst

  • May 2010 - Apr 2011

  • Liaise with client to gather business rules • Liaise with Architect and Source system owners to ensure that solution meet design specification.• Gather information across all business units.• Assist project team with planning and estimation. • Identify and escalate risks, scope changes, issues and their impacts.• Report scope changes to project manager and facilitate meetings to resolve risks and issues.• Analyze data content in order to map to the solution• Perform data analysis, assist with data models and provide mapping sheets and transformation rules.• Develop prototypes (SQL) for the purpose of data integrity checking and ensuring that business rules can be applied• Provide business functional specification to developers• IAT document and test plans• Responsible for iteration documentation



Faritec

• IT Services and IT Consulting
• 1 - 100 Employee

• CW Systems Analyst

  • Apr 2008 - Apr 2010

  Duties (for Vodacom Billing Dept.)• Liaise with various Business Analysts • Gather requirements to draw business rules documentation(s) • Be the intermediary between Business and Development functions Manage the risks • Gathering business information from business representatives. • Improve business processes • Analyze data• Mapping • Prototype • Ensure solutions meet design specifications Duties (for Vodacom Billing Dept.)• Liaise with various Business Analysts • Gather requirements to draw business rules documentation(s) • Be the intermediary between Business and Development functions Manage the risks • Gathering business information from business representatives. • Improve business processes • Analyze data• Mapping • Prototype • Ensure solutions meet design specifications



Altech ISIS

• South Africa
• IT Services and IT Consulting
• 100 - 200 Employee

• Application Support Analyst

  • Jul 2005 - Mar 2008

  Duties• Windows NT, Windows 2000, UNIX operating systems • Writing SQL database queries/ scripts (Oracle database) • Operating Web and Delphi based GUI applications • Monitoring/support/fault administration of IT applications• On line monitoring of ISIS applications running on Windows NT, Windows 2000, UNIX operating systems and Oracle databases in a production environment • Providing operational support for ISIS applications running in a production environment to ensure service is provided within customer SLA • Logging change controls,• Error monitoring, logging, investigation and resolution on ISIS applications • Liaising with customer representatives during problem resolution • After hours operational support for ISIS applications running in a production environment (stand-by). • Routine maintenance on ISIS applications