Data Transformation and WarehousingSystem Implementation
About me
An enthusiastic IT professional with five (5) years extensive experience in Data Analysis, Data Extraction, Data Manipulation, Research and Reporting in different Visualisation formats and from various sources. Able to perform multiple duties in business analysis, project or program management, and functional leadership. A wonderful team player who can relate and work efficiently with diverse groups. Proven ability to learn, utilise in-house databases and systems to maintain strategic vision of the organisation and link it with everyday work.
Superpowers
Data AnalysisBusiness IntelligenceSQLData Integration
Skills
Business IntelligenceData AnalysisData IntegrationSQL
Experience
Sep, 2021
Current
data analyst
Information Technology
Data driven solutions
Data Analyst with a proven track record of identifying, evaluating and implementing external services and tools to support data validation and cleansing, resulting in an overall improvement of data accuracy and quality. Developed and maintained benchmarking database for productivity and service quality, ensuring increased performance transparency and best practice support. Liaised with stakeholders to understand data content and business requirements, using tools and techniques to visualise data in easy-to-understand formats. Implemented data analysis, data collection systems and other strategies to optimise statistical efficiency and quality.
Key responsibilities
Gather and document business requirements
Manage new data projects
Develop and maintain benchmarking database
Communicate with stakeholders
Key achievements
20% increase in data quality
25% improvement in data accuracy
15% increase in performance transparency
28% improvement in communication clarity
Jan, 2020
Aug, 2021
data analyst/power bi consultant stefred global
Information Technology
Data-driven solutions
Provided data insights to help business stakeholders achieve their goals, designed SSIS packages to consolidate data, developed SQL queries and stored procedures, created calculated columns and measures using DAX, developed visual reports and dashboards with Power BI, secured reports with row-level security, created dashboards to provide aggregate information, and scheduled reports to run and email to managers.
Key responsibilities
Imported data from SQL Server DB and Azure SQL DB
Partnered with Business analysts and stakeholders
Created SSIS packages to consolidate data
Developed SQL queries and stored procedures
Key achievements
Developed reports and relational models with Power BI Desktop
Created calculated columns and measures with DAX
Secured reports with row-level security
Scheduled reports to run and email to managers
Jan, 2019
Dec, 2019
data reporting analyst stefred global resources
Information Technology
Stefred Global Resources
Delivered high quality data analysis and reporting services to business stakeholders. Utilised SQL Server platform to write queries, develop ETL packages and create precise reports. Led requirements gathering sessions and developed concept dashboards and analytics projects. Participated in touch-point meetings, set up review meetings and prepared status updates.
Key responsibilities
Writing queries and developing ETL packages
Gathering requirements and developing dashboards
Interpreting technical and business objectives
Participating in meetings and preparing updates
Key achievements
Produced accurate, easy to read reports
Translated business questions and needs into queries
Developed BI system for KPIs
Implemented analytics projects
Apr, 2018
Aug, 2018
data analyst intern
Professional services
Provided data analysis expertise to cross-functional teams, collaborating with senior data analysts to gather and clean data from diverse sources, ensuring accuracy and reliability. Performed data analysis on a big dataset to uncover trends and patterns in student enrolment and retention rates. Worked with IT and business stakeholders to identify and resolve data-related issues during integration.
Key responsibilities
Documenting data analysis processes and findings
Gathering and cleaning data
Data analysis on a big dataset
Identifying and resolving data-related issues
Key achievements
Created a knowledge repository
Ensured data accuracy and reliability
Discovered trends and patterns
Resolved data-related issues
Sign in
Enter your email and password to log in
Sign up
Enter your info to sign up
Password recovery
Enter your password to receive a recovery link email address