EMEM UMOH
Annapolis,MD
Summary
Experienced business intelligence Professional with 8+ years in consulting, Tableau, SSIS, SSRS and SAS VA development. Proficient in data visualization, SQL/T-SQL queries, and Alteryx, with skills in system performance analysis and dashboard creation. Demonstrating strong analytical, problem-solving, and conceptual skills alongside proven leadership and collaboration abilities. Skilled in data usage and governance framework. Excels in delivering high-quality solutions tailored to clients' needs. Passionate about leveraging data to drive actionable insights and enhance organizational decision-making processes. With a track record of success, adept at navigating complex data landscapes to extract valuable insights and optimize performance. Committed to staying abreast of emerging trends and technologies in data analytics to continuously improve service delivery and provide innovative solutions to clients. Proficient knowledge of agile and scrum methodologies and working with healthcare records.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Tableau Developer
Penn Foster Group
03.2022 - 01.2024
- Performed installation, migration and upgrade of Tableau Servers and Desktops under high availability scenario
- Performed performance analysis of existing Tableau Servers and make best practice recommendations
- Performed day to day administration of Tableau Servers
- Provided periodic reports on Tableau Server usage
- Publish Tableau workbooks and data extracts
- Configure and maintain Active Directory integration with Tableau Server
- Managed sites and projects of Tableau Servers
- Configured and managed project permissions
- Produced dynamic data visualizations in Tableau, utilizing relational and aggregate data sources to deliver insightful analytics and drive informed decision-making
- Created views using SQL and connected Tableau to custom SQL queries for data modelling and integration
- Perform Data validation and manipulation using SQL Queries in MySQL management studio
- Designed and developed interactive dashboards and reports using Tableau to visualize key performance indicators (KPIs), metrics, and trends
- Ensure the dashboards are user-friendly and provide actionable insights
- Independently perform more complex analysis for a wide range of requests, using data in different formats and from various platforms, and identify behavioral data and patterns
- Coordinate and independently develop BI content (reports, dashboards, scorecards, more complex analytic solutions) using Tableau
- Connect to different data sources to provide data necessary to effectively make business decisions and measure goal attainment and overall performance
- Designed, developed, conducted unit testing, and maintains complex SSRS and PowerBI reports for scalability, manageability, extensibility, performance, and for re-use
- Conduct User Acceptance testing for reports and Dashboard on PowerBI between the DEV and PROD environment
- Configuring connections between Databricks and Power BI to enable seamless data access and visualization
- Contributed to project charter and/or agile scrum team plans, work assignments, target dates/sprints, and other aspects of assigned projects and product team tasks
- Documented and communicated the changes and process during development
- Participated in a data source migration project from Salesforce to data bricks in PowerBI
- Conducted rigorous testing of the migration process to ensure data accuracy, completeness, and consistency
- Performing validation checks and reconciliation between the data in Salesforce and Databricks to verify the integrity of the migrated data
- Designed data models and datasets in Power BI to consume the migrated data from Databricks
- Experience in Data Management and Data Engineering projects
- Managed sites and projects
- Configured and managed project permissions
- Utilized in this role data management, analysis and visualization tools
- Implemented Change Data Capture in the database environment to capture and track changes made to data, enabling real-time data integration, analytics, and decision-making
- Thoroughly test the CDC implementation to verify its functionality, performance, and reliability
- Validate that change data is captured correctly and propagated to downstream systems accurately
- Analyze key performance indicators (KPIs) and metrics to measure and track the realization of benefits
- Created dashboards that comprise of multiple knowledge objects and turn it into a visualization for a better understanding
- Implemented cost, benefit and risk analysis associated with the proposed product/services and recommend alternatives for solutions throughout the product life cycle
- Collaborate with stakeholders to define project scope, objectives, and success criteria, ensuring alignment with business goals
- Publish tableau dashboard to the server for users to have access based on their permissions
- Create automated workflow that helps to streamline processes
- Applied Level of Detail functions for data manipulation and calculations for most reports
- Used Tableau Prep for Data Shaping and transformation
- Manage projects from initiation to completion state and Preparation of project estimates
- Leverage REST APIs to interact with Azure Cloud Storage and to automate data refresh
- Used REST APIs to manage metadata associated with data sources stored in Azure Cloud Storage
- Developed a comprehensive Performance student retention dashboard using Tableau, resulting in a 25% increase in sales visibility and improved decision-making for marketing and sales teams
- Implemented a data warehouse solution using Kimball methodology, resulting in improved data consistency and accuracy across the organization
- Optimized ETL processes for a customer data integration project, leveraging Erwin, snowflakes tool, reducing processing time by 25% and improving data quality
- Successfully installed, maintained and carried out administrative duties on the Alteryx platform
- Administer user accounts, roles, and permissions within the Alteryx platform
- This includes creating and managing user accounts, assigning appropriate roles and permissions, and ensuring compliance with security policies
- Manage the overall configuration, setup, and maintenance of the Alteryx platform, including server installations, security governance upgrades
- Used Alteryx to transform data into actionable insights that ensure data accuracy
- For example, to determine customer behavior and track year to year performance
- Used Alteryx related to data preparation, blending, analysis, and automation for some projects
- Monitored the performance of the Alteryx platform and optimize configurations to ensure optimal performance and scalability
- Identify and resolve performance bottlenecks and issues proactively
- Continuously stay up to date with industry trends and best practices related to data analytics and workflow automation
- Identify opportunities for process improvement and innovation within the Alteryx platform
- Used Databricks to write queries, run analysis, and visualize results in real-time
- Created views in data bricks to connect to Tableau Desktop and online as a data source for reporting and visualization to aid performance optimization
- Analyze website performance to help with student retention plan
- Data Migration and QA comparing Dev to Prod for data accuracy after migration
- Data usage and quality, Also ensured data accuracy in this role
- Designed and implemented Course evaluation Dashboards using PowerBI
- Crafted customized dashboards aligned with organizational metrics, integrating bespoke visuals tailored to specific business requirements, enhancing clarity and usability
- Conducted seamless data blending across diverse databases to generate comprehensive reports, prioritizing data integrity and accuracy to ensure reliable insights
- Integrating SAP Business Objects (4.1/4.2) tools with BW Queries and HANA views
- Implementing SAP BOBJ Mobile including mobile enabled WebI reports
- Configure and maintain BO environments
- Recreate Business Object reports in tableau
- Schedule and rerun report in BO
- Collaborate with IT and business teams to optimize BO usage
- Create and schedule reports in webi
- Established robust data validation and extraction routines, bolstering data quality and reliability while streamlining operational processes
- Used Python for scripting and data manipulation
- Design Power BI Dashboards, publish and share to users
- Facilitated seamless connectivity between Tableau, Databricks, and MySQL, optimizing data visualization, querying, and validation processes for enhanced efficiency and effectiveness.
Business Intelligence Developer
Walmart
08.2018 - 02.2022
- Directed Power BI implementation roadmap, aligning it with organizational objectives to ensure seamless integration and maximize value realization
- Analyzed and implemented health-related data collected from various sources such as pharmacies, clinics, and health programs to identify trends, patterns, and insights
- Managed and maintained healthcare data systems, ensuring data accuracy, security, and accessibility for analysis and reporting purposes
- Evaluating the effectiveness of existing healthcare programs and initiatives implemented by Walmart, such as wellness programs, vaccination campaigns, and chronic disease management
- Designed Tableau Desktop dashboards to enable in-depth analysis of organizational metrics, enhancing decision-making processes with actionable insights
- Utilized Salesforce for CRM and data visualization, enriching customer insights and facilitating exploration of business opportunities
- Collaborated with cross-functional teams including IT, finance, human resources, and legal departments to support healthcare initiatives and projects
- Generated reports and dashboards to communicate findings and recommendations to stakeholders within the company, including executives, managers, and healthcare professionals
- Design and develop data models to represent business entities, relationships, and processes in a structured and efficient manner
- Used Alteryx to transform data into actionable insights that ensure data accuracy
- For example, to determine customer behavior and track year to year performance
- Created Dashboard with patient record for our Medicaid clients
- Completed request and project related to SSRS and Tableau reports
- Present recommendations based on thorough analysis and assessment, highlighting the strengths, weaknesses, opportunities, and threats associated with each alternative
- Engage stakeholders in the decision-making process and provide clear rationale and justification for recommended solutions
- Performed comprehensive cost, benefit, and risk analysis and recommending alternatives throughout the product life cycle
- Performed training as needed for users
- Used Alteryx related to data preparation, blending, analysis, and automation for some projects
- Perform data validation using Alteryx as an ETL tool to transform the data
- Established Power BI connection to SQL Server, optimizing data extraction and analysis efficiency to drive informed decision-making
- Automated tasks using PowerShell and integrated Tableau with QuickBooks for comprehensive financial analysis, streamlining processes and improving financial visibility
- Implemented strategies to align Tableau deployment with business needs, ensuring effective utilization and fostering a culture of data-driven decision-making within the organization.
BI Developer
Costco
04.2015 - 08.2018
- Spearheaded the development of Tableau report development best practices, guaranteeing consistency and efficiency across projects
- Leveraged SAS Visual Analytics for robust data exploration and report design, enabling comprehensive analysis and visualization of complex datasets
- Implemented data modeling and ETL processes using Erwin, Alteryx, and Tableau Desktop, enhancing data integration and analysis capabilities for informed decision-making
- Orchestrated user groups and scheduled report instances in Tableau Server, optimizing report delivery and accessibility to stakeholders
- Engineered high-performance visual solutions in Tableau, elevating data presentation and interpretation for enhanced insights and decision-making processes
- Ensured seamless integration and utilization of Tableau, SAS Visual Analytics, and other tools to streamline workflows and maximize the value of data assets across the organization.
Education
Bachelor's Degree - Business Administration
Strayer University, USA
01.2022
Associate degree - Business Administration
Greenwich London College, UK
01.2008
Skills
- Tableau: 202411 , 202334, 202327, 2023111, 2022412, 2022315, 2022218, and 2022123, 20211
- SQL, MySQL, Power BI, Power Query, UAT, DAX, SAP
- Databricks, Spotfire Analytics, Oracle DB, EDI, Epic, Risk Analysis, Cost Analysis, Product life Cycle, Change Request,Backlog refinement, Notepad, PrimeveraP6
- SDLC, ETL, SSRS AWS, Git HUB,Azure Cloud,REST API
- Snowflakes, Microsoft 365,Microsoft Dynamics,Windows, Linux, Microsoft Intune,Agile, Waterfall, User
Certification
- Tableau Certified
- PMP Certified
- [Area of certification], [Company Name] - [Timeframe]
Timeline
Tableau Developer
Penn Foster Group
03.2022 - 01.2024
Business Intelligence Developer
Walmart
08.2018 - 02.2022
BI Developer
Costco
04.2015 - 08.2018
Bachelor's Degree - Business Administration
Strayer University, USA
Associate degree - Business Administration
Greenwich London College, UK
Similar Profiles
Sean P. ReillySean P. Reilly
Student Advocate at Penn Foster GroupStudent Advocate at Penn Foster Group
Felicia ArtisFelicia Artis
Admissions Specialist at Penn Foster GroupAdmissions Specialist at Penn Foster Group
Toni McConnellToni McConnell
Team Support Specialist/Interim Team Lead at Penn Foster GroupTeam Support Specialist/Interim Team Lead at Penn Foster Group
Talmage MitchellTalmage Mitchell
Sales Development Representative at Penn Foster GroupSales Development Representative at Penn Foster Group
Dominique ScurryDominique Scurry
Lead Teacher at The Learning Tree Day Care CenterLead Teacher at The Learning Tree Day Care Center