Dennis

Dennis

Data Analyst
Kenya
English

About Me

A highly accomplished and result-oriented Business Data Analyst professional with over 4 years of extensive experience in Business Data Analytics - document business requirements, functional improvements, and a proven ba…

Experience

Data Analyst/Scientist

Smart Data Analytic | Dallas, Texas(Remote)
Apr 2019 - Present · 7 years 3 months

Performed data collection, data cleaning, and data preprocessing tasks to prepare datasets for analysis.
Communicated complex technical findings and insights to non-technical stakeholders effectively.
Built databases and validated their stability and efficiency.
Responsible for data modeling, data scheduling.
Explored and analyzed large datasets using Python, Pandas, and SQL to identify trends, patterns, and outliers.
Utilized Python libraries like Scikit-learn and TensorFlow for model training and valuation.
Created interactive and informative data visualizations and dashboards using Tableau to present insights and findings to stakeholders.
Fine-tuned models for optimal performance and interpreted models results.
Developed custom data visualizations using Python libraries like Matplotlib and Seaborn.
Used Alteryx to automate data extraction, transformation, and loading (ETL) processes.
Cleansed and preprocessed data to ensure data quality and accuracy.
Collaborated with cross-functional teams, including data engineers, analysts, and business stakeholders, to understand data requirements and business objectives.
Created program views, functions, and stored procedures.
Wrote optimized SQL queries for integration with other applications.
Designed database tables and dictionaries.
Developed scripts, procedures, and triggers for application development.
Maintained data quality and backups.
Communicated effectively in both a verbal and written manner to client and offshore team.
Completed documentation on all assigned systems and databases, including business rules, logic, and processes.
Determine changes in physical database by studying project requirements.
Developed intermediate business knowledge of the functional area and processed to understand the application of data information to support business function.
Facilitated gathering moderately complex business requirements by defining the business problem.
Maintained and assists in the development of moderately complex business solutions, which include data, reporting, business intelligence/analytics.
Responsible for working closely with various stakeholder’s groups to build business requirements and functional design documents.
Facilitated the communication between various functional teams and the vendor to determine the application problems, remediation approaches, and the implementation path.
Provided the management with a dashboard that searched across multiple transactional data sources to see information relevant for the client.
Converted complex data from multiple sources into meaningful and easy to understand formats for various stakeholders.
Use different methodology to prioritize and create roadmaps for projects based on Business requirements and goals and participated in scrum sessions.

Data Analyst/Scientist

Smart Data Analytic
Apr 2019 - Present · 7 years 3 months

Performed data collection, data cleaning, and data preprocessing tasks to prepare datasets for analysis. Communicated complex technical findings and insights to non-technical stakeholders effectively. Built databases and validated their stability and efficiency. Responsible for data modeling, data scheduling. Explored and analyzed large datasets using Python, Pandas, and SQL to identify trends, patterns, and outliers. Utilized Python libraries like Scikit-learn and TensorFlow for model training and valuation.

Data Analyst

Globilink Solutions Limited| Kisumu, KE
Jan 2018 - Mar 2019 · 1 year 2 months

Identified and analyzed cross functional requirements for cross agency system and data integration.
Participated in daily defect meeting calls and coordinated the user-acceptance testing efforts with the business users.
Analyzed and evaluated data/information gathered from multiple sources and reconcile/address conflicts or business issues.
Designed and developed a series of complex business intelligence solutions via business objects (designer, desktop intelligence, and web intelligence).
Managed the complete product lifecycle from requirements gathering to prioritization to product release.
Provided management, direction, and administration for the collection, validation, holistic analysis and reporting of program data.
Reviewed Business requirements and prepared the dashboards as per the requirements.
Handled large amount of data and worked on Database development while migrating from MS Access to SQL Server Database.
Collected, analyzed, and reported data from various internal systems with the end goal of a renewal quote to the customer.
Responded to new requests including understanding the customer objectives and processes, reviewing, and refining requirements, and communicating estimated timeline for completion.
Responsible for gathering business and technical requirements, source system analysis, gap analysis, data profiling, requirements documentation for report development.
Managed end to end complex data migration, conversion, and data modelling (using SSIS, SQL), and created visualization using Power BI to develop high quality dashboards.
Monitored project progress by tracking activity, resolving issues, publishing progress reports and recommending actions.
Analyzed requirements and document functional and business user requirements to assist in the design of applications.
Wrote business requirement and design specification for a system enhancement using requisite pro document template.
Provided data mapping, user interface specifications and processing logic per business requirements to the developers.
Responsible for testing system configuration and validation of business requirements.
Provided guidance and furnished solutions to program managers, project managers, and technical lead on documentation procedures and development.
Redesigned business processes by building several MS access databases to help automate manual processes, meet legal requirements, and track data.
Performed analysis of current system and data, gathered business requirements through interviews, and developed solutions and recommendations for a new database with additional functionality.

Data Analyst

Globilink Solutions Limited
Jan 2018 - Mar 2019 · 1 year 1 month

Identified and analyzed cross functional requirements for cross agency system and data integration. Analyzed and evaluated data/information gathered from multiple sources and reconcile/address conflicts or business issues. Designed and developed a series of complex business intelligence solutions via business objects (designer, desktop intelligence, and web intelligence). Managed the complete product lifecycle from requirements gathering to prioritization to product release.

Skills

Business Intelligence Business Development Creative Thinking Project Management Relationship Building Troubleshooting Microsoft SQL Server Linux Systems Microsoft Office MS Word Advanced Excel PowerPoint SQL Power BI Microsoft 365 SharePoint SSAS Python Alteryx Data Analysis Data Visualization Cloud Spice Works Predictive Analytics Data Cleaning Data Preparation Data Exploration Dashboards Reports Strategic Planning Collaboration Teamwork Interpersonal Skills Problem Solving Leadership Pandas Scikit-learn TensorFlow Tableau Matplotlib Seaborn ETL Data Modeling Stored Procedures Database Design SQL Queries Data Quality Backups
Report this Profile?