- * -

Mark Koinange

Indianapolis, IN, *****. Phone: 317-***-**** Email: ad46t8@r.postjobfree.com

PROFILE

A Self driven Business Data Analyst with experience in interpreting, analyzing and visualization data to help business make informed data-backed decisions and solutions. Excellent understanding of business operations and analytics tools such as Tableau Business intelligence solutions, Power BI, Microsoft SQL Server, and a host of other analytical tools to help businesses make important decisions that add value. TECHNICAL SKILLS:

Tableau Desktop and Tableau Server, Tableau Online, Tableau Public, Tableau Reader, Microsoft SQL Server, Microsoft Access, Microsoft Office (MS Word/Advanced Excel/PowerPoint), MS Project, Project Manager, SQL, Alteryx, Tableau, Jira, MS Visio, Microsoft 365: SharePoint, Forms, PowerApps, Planner; MSBI, SSIS, SSAS, SSRS, Google Doc, Google Spreadsheet, & Power BI. SUMMARY:

• Proficient in creating actions, customized relationships, filters, calculated fields, parameters, hierarchies, groupings, sorting, live and extract connections, drill down analysis for preparing worksheets and dashboards in Tableau & Power BI

• Utilized performance-tuning procedures to increase performance by over 50 percent and help make dashboard more visually appealing and user-friendly using Tableau.

• Created an ETL solution that reads data from different files and loads it into SQL Server database then generate visualizations dashboards.

• Maintained security control of the Tableau products and solutions by designing effective authentication measures.

• Use business requirements to build SQL queries that would be used in dashboards to satisfy the business's needs. EXPERIENCE

Smart Data Analytic Plano, TX Jan 2021–Present

Business Data Analyst

Responsibilities

• Provided the management with a dashboard that searched across multiple transactional data sources to see information relevant to the client.

• Eliciting requirements related to the payment system and translating them into technical options and solutions that meet stakeholders’ needs.

• Conducting Gap Analysis to show the current and proposed functionalities of the system.

• Analyzing and documenting business requirement documents (BRD) and functional requirement documents

(FRD).

• Experience with SDLC requirement gathering and deployment using Agile Scrum methodologies.

• Ability to plan and coordinate testing phases including creating and executing Test Scripts/Test Cases and conducting User Acceptance Testing.

• Daily scrum call meetings and participating in retrospectives.

• Conduct interviews with key business users to collect information on business processes and user requirements by interviews and brainstorming.

- 2 -

• Develop Business Requirement Document (BRD), various documents associated with design phase – Software Design Document (SDD), Traceability Document, User Acceptance Testing (UAT) and Use Cases.

• Participate in Daily Scrum sessions.

• Convert complex data from multiple sources into meaningful and easy to understand formats for various stakeholders.

• Manage end to end complex data migration, conversion, and data modeling (using SSIS, SQL), and create visualization using tableau to develop high quality dashboards.

• Update fields and data types and heavily utilized case statements logics for developing business logic.

• Maintaining Traceability Matrix for the current business processes and proposed changes

• Extracting data through SQL query and business intelligence solutions, analyzing and interpreting

• Hands on experience in development of reports and dashboards in Tableau

• Formatting the data by using legends, marks, colors, size, text, and shapes.

• Worked on development Actions with Worksheets and dashboard reports and applied the KPIs.

• Created table charts, filled maps, pie charts, side by sidebars, tree maps, circle views, circle by circle views, packed bubbles, trendlines and heatmaps.

Assures Best Care Inc. Arlington, TX Dec 2018–Dec 2020 Health Analyst

Responsibilities

• Reviewed Business requirements and prepared the dashboards as per the requirements.

• Created Dashboards and Reporting deliverables in Tableau utilizing advanced features, capabilities, and designs.

• Analyzed and designed data in a SQL Server database environment.

• Drove business objectives, initiatives, and priorities that have the greatest potential business impact through using Tableau for data visualization, reporting customization, and operational controls.

• Hands on experience in Power BI reporting and visualization, Data expressions and visualization.

• Involved an 'Agile' development environment where frequent incremental changes and enhancements are required to meet fast changing business needs.

• Handled large amount of data and worked on Database development while migrating from MS Access to SQL Server Database.

• Worked with SOAP, Rest APIs on retrieving Json data using postman service tools. Care One Health Institute Raleigh, NC Aug 2018–Nov 2018 Programmer Analyst

Responsibilities

• Created Dashboards and Reporting deliverables in Tableau utilizing advanced features, capabilities, and designs.

• Analyzed and designed data in a SQL Server database environment.

• Involved in gathering and verifying requirements from Internal Management.

• Broad background in working with data, data sources, data consumers, data quality, data governance and record across business systems and processes.

• Create dashboards for data visualization using Excel, Access, and SQL Server Management Studio. EDUCATION

Business/Data Analytics Course.

Post-Grad Certificate in Procurement and Supply Chain Management 2012 M.S -Physics Sept 2012 to Dec 2015

B. S in Ed – Physics and Mathematics Sep 2004 to Dec 2008 High School Diploma -St Peter’s Seminary Jan 1999 to Dec 2002

Contact this candidate