Data Analyst Administrator

RANTHO SEHLABANE NAPHTALY

Alexandra, Johannesburg 2090 • 060-***-**** / 081-***-****

adogdj@r.postjobfree.com • linkedin.com/in/ranthonaphtaly/

Contributions Administrator Junior Data Analyst Data Administrator

PROFESSIONAL SUMMARY

Contributions Administrator with over 2 years of experience in contributions administration, data analysis with Python (Pandas), data visualization and SQL database querying across diverse industries. Adept at consistently identifying and providing analytical needs of companies through prolific data analysis and SQL data warehousing. Proficient in creating databases, writing scripts to query the database, data reconciliation, visualizing findings to give feedback about the data on systems. Seeking to join a reliable organization on entry level roles and utilize my skills and knowledge to grow while adding positive value to the organization.

Core Competences and Skills

• Extract, Transform and Load (ETL) • Organized and Detail Oriented • Presentation

• Communication • Data reconciliation • Analytical

• Querying Data with Transact-SQL • Python programming • Advanced Excel

EDUCATION

Bachelor science in Mathematical Sciences (Computer Science and Statistics), University of Limpopo, 2017.

National Senior Certificate (Matric), Tenyane Secondary School, 2013.

PROFESSIONAL EXPERIENCE

Eskom Pension and Provident Fund 01/2019 – 01/2021

Contributions Administrator

Accountable for member contributions collections, extraction, transformation and loading of data into various databases.

Facilitated Fund valuation through various data script execution and ensured fund pension benefits statements are accurate and data quality for the entire fund.

Assisted various business units to understand their data requirements with objective of ensuring a matched data source within various systems and unclaimed reconciliation process from a data analysis perspective.

Compiled fund membership, analysis, and visualization data of member contributions. Conducted statistical data analysis, data reconciliation and data warehousing with SQL server.

Assisted in loading, preparing, manipulating, model and analysed data. Ensured joining, merging, reshaping of data using python (Pandas).

Ensured fund pension benefits statements are accurate, assist with monthly contribution reconciliations for the fund

Maintained member data, preparation of monthly reports and attended to all data processing related queries

Assisted various business units to understand their data requirements with objective of ensuring a matched data source within various systems

Actively assisted Client Services, the Call Centre, Claims team, employers and external service providers to resolve queries

Recorded all appropriate member notes on member's Everest record and attached all email correspondence to the member's record.

TRAINING AND PROFESSIONAL DEVELOPMENT

Investment Fundamentals, Johannesburg School of Finance

Accelerate Your Business Success, Key steps Corporate Training .

Data Analyst with Sql Server,Datacamp.Com

REFERENCES

Available on Request

Contact this candidate