Mohammmad Yeamin Khan
Dartmouth,NS
Summary
Experienced BI server and application expert also proficient in data analysis and administration with 3 years of experience. Proficient in data mining, modeling, and analysis, including the design and implementation of star schemas for efficient data warehousing models to ensure high level of data availability. Skilled in ETL (Extract, Transform, Load) processes, data manipulation, retrieval, and transformation for uncovering valuable insights. Expertise includes using Python and SQL for statistical analysis and data management. Additionally, well-versed in Google Sheets and scripting, Excel, Tableau and Microsoft BI Stack, Cognos server to extract meta data from various applications for impactful data representation and monitoring. Adept in soft skills, such as effective communication, collaboration, and problem-solving, driving data-driven decision-making. Meticulous, time-conscious, adaptable, and committed to continuous learning.
Overview
9
9
years of professional experience
Work History
BI Application & Server Specialist
CygniSoft
09.2021 - Current
- Managed and administered multiple BI server infrastructure for company, but not confined to them, includes Cognos Server, Data Clarity and Tableau
- Identified and resolved issues that arose within the BI servers and applications promptly
- This included troubleshooting server performance issues, data connectivity problems, and user-reported issues effectively
- Regularly applied patches and updates to our BI applications, including Tableau, IBM Cognos, Data Clarity, ensuring remained secure, updated and well equipped with the latest features to support data administration and visualization
- Ensured that all software components required by company’s BI applications and servers, including databases, middleware, and connectors, were well-maintained and compatible with the latest application versions
- Conducted impact assessments before implementing updates, thus minimizing disruptions
- Scheduled comprehensive data backup and disaster recovery procedures for our BI server applications
- These procedures guaranteed the availability of critical business data and the ability to restore the system quickly in the event of a failure
- Managed user access, roles and security settings within the IBM Cognos Analytics and Tableau, ensuring data confidentiality and access control in accordance with organizational policies
- Collaborated with the data analytics team to develop and modify databases, programs, and electronic tools that facilitated and improved data services
- This included data model enhancements, ETL processes, and reporting solutions
- Offered tier 3 level technical support, working directly with end-users and technical teams to troubleshoot and repair software issues
- Undertook various custom projects related to business intelligence, such as the design and creation of data models, data marts, and data visualization dashboards, aligning them with specific departmental needs.
- Improved data gathering, analysis and visualization procedures with strategic optimizations.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Generated reports, updated spreadsheets and presented results.
- Monitored and optimized SQL server performance.
Data Analyst & Administrator
Softco Vision
06.2018 - 08.2021
- Gathered data from multiple sources, including internal databases, external partners and APIs
- Designed and maintained ETL processes to ensure the accuracy and consistency of incoming data
- Honed expertise in SQL query optimization, achieving remarkable reductions in execution time and streamlining data extraction
- Strategically orchestrated KPI mapping, engineered intricate data models, and creatively designed dashboard mockups for clients
- Informed, data-backed decision-making that played a vital role in reducing operational costs for multiple projects.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Utilized data visualization tools to effectively communicate business insights.
- Participated in requirements meetings to understand business needs.
- Extracted and interpreted data patterns to translate findings into actionable outcomes.
- Upheld security and confidentiality of documents and data within area of responsibility.
- Documented effective and replicable methods for extracting data and organizing data sources.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Provided technical support for troubleshooting analytics and reporting issues.
- Created dashboards to monitor and track key performance indicators.
- Implemented business intelligence solutions to increase operational efficiency.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Generated ad-hoc reports to evaluate specific business requirements.
- Designed and developed data pipelines to acquire, clean and process data.
- Developed and maintained data warehouses and data marts to support business operations.
- Developed and implemented data governance policies and procedures.
- Optimized data access and storage to improve performance of analytics systems.
Data & Power BI Analyst
Kazi IT Centre Ltd
03.2015 - 12.2017
- Empowered data-driven decisions by implementing predictive models with scikit-learn, driving a 15% improvement in forecasting precision
- Fueled cross-team collaboration to pinpoint vital business trends, catalyzing a remarkable 20% surge in customer engagement
- Achieved efficiency gains by optimizing SQL queries, slashing execution times by an impressive 30% while simplifying data retrieval
- Orchestrated strategic data insights through Power BI, mapping KPIs, crafting data models, and presenting compelling visualizations that directly led to a 10% reduction in operational costs
- Engaged in teamwork with developers to integrate data-driven features into web applications, enhancing user experience and increasing user involvement by 15%
- Assisted in the development of a customer segmentation model using Python, contributing to a targeted marketing campaign that boosted conversion rates by 12%.
- Optimized BI reporting capabilities for secure server environment.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Collected data from wide-ranging sources.
Education
Computer Programming
Seneca College of Applied Science
Toronto04.2022
Skills
- Data Analysis and Visualization
- SQL Expertise
- Tableau
- Spreadsheet Mastery and Scripting Expertise
- IBM COGNOS ANALYTICS SERVER and ADMINISTRATION SPECIALIST
- Microsoft Word
- Multitasking Abilities
- Teamwork and Collaboration
- Task Prioritization
Languages
English
Native or Bilingual
Bengali/Sylhetty
Native or Bilingual
Hindi/Urdu
Full Professional
Hobbies and Interests
- Reading Books
- Watching Movies
- Cooking
- Travelling
References
Available on Request
Timeline
BI Application & Server Specialist
CygniSoft
09.2021 - Current
Data Analyst & Administrator
Softco Vision
06.2018 - 08.2021
Data & Power BI Analyst
Kazi IT Centre Ltd
03.2015 - 12.2017
Computer Programming
Seneca College of Applied Science
Similar Profiles
Jonathan LacroixJonathan Lacroix
Tool Room Attendant at CherubiniTool Room Attendant at Cherubini
SHIVAM CHAWLASHIVAM CHAWLA
Dock Controller at ARMOUR TRANSPORTATIONDock Controller at ARMOUR TRANSPORTATION
AHMED SHUAIB THAIVALAPU HANEEFAAHMED SHUAIB THAIVALAPU HANEEFA
Restaurant Supervisor at American Broaster ChickenRestaurant Supervisor at American Broaster Chicken
Christopher FrameChristopher Frame
Automotive Glass Technician and Sales at UniglassAutomotive Glass Technician and Sales at Uniglass
Yash DesaiYash Desai
ETL/Power BI/Application Developer at Avenir Innovation Solutions Pvt LtdETL/Power BI/Application Developer at Avenir Innovation Solutions Pvt Ltd