ALVIN TOOSE KPOTO

***** **** ** * ******** MN 651-***-**** ad48ul@r.postjobfree.com linkedin.com/in/alvin-kpoto-32a68a16/

SENIOR-LEVEL LEADERSHIP

DATA ANALYTICS ● BUSINESS INTELLIGENCE (BI) ● PROJECT MANAGEMENT ● DATA SCIENCE

Accomplished technology and business leader with an extensive portfolio of success across BI, analytics, software engineering, and project management. Reputation for finely honed decision-making, strategic thinking, and problem-solving skills. Proven history guiding senior management teams as lead software engineer and Data Science architect on mission-critical data systems. Special expertise in the areas of advanced analytics, System Design, process-driven, data warehousing, data visualization, machine learning, and big data. Guide top-performing teams and streamline workflow to enhance efficiency and reduce processing times and costs; deliver innovative solutions to meet changing business needs. Core leadership competencies:

Best Practices – Workflow Streamlining – Software Development Lifecycle – Data Transformation – IT Infrastructure – Oracle BI

Data Integration – Targeted Marketing – Data Security – Requirements Gathering – System Transformations – Road Mapping

Data Architecture Management – Strategic Planning – Project Management – Process Optimization – Capability Planning

Project management/coordinator Business analysis Systems/Technology analysis Business process improvement

Technical Skills:

Databases: SQL Server 208/SSIS/SSRS/SSAS, Oracle 10g, IBM DB2, Teradata, Aqua Data Studio, Power BI, Tableau, DOMO

Programming & Tools: VB.NET, CCL, XML, HTML, T-SQL, PL/SQL, SQL, C++, API.NET, DML, Software & Tools, Visio Professional

FrontPage, Crystal Reports, SQL*Loader, Team Foundation Server (TFS), JIRA, Microsoft CRM, Microsoft Dynamics/Great Plains

Microsoft Server R2, SharePoint, SQL Server, Visual Studio, Power Designer Data Model, Power BI, Tableau, SAS Enterprise Miner Domo, SAP Hana, Amazon AWS, Cloudera Platform, Hadoop Transfer Files System, NoSQL, Advanced Hive, Advance Pig

Advanced HBase, advanced Neo4j, Big Data Architecture, Big Data Management, SAS, R-Studio Programming, MongoDB, Power BI, PowerApps, Eloqua, Azure Government Cloud / GCP/Google Big query to extract data into insight, Strong knowledge of Data Lake, Data Warehouse, BI and analytic capabilities, and concepts. Google Could and Google Query, Looker, Business Insights, Business Metrics, Competitive Analysis, Reporting & Analysis, Storytelling, Alteryx, using Agile frameworks (e.g., Scrum, Kanban, etc.)

Surescripts Corporation

Principal Business Intelligence Reporting and Analytic Enterprise Eng 2021-Current

As an accomplished Principal Business Intelligence (BI) Engineer, I spend most of my time designing, building, and maintaining BI and reporting solutions that enable actionable decision-making. This includes participating in the full systems development lifecycle in an agile environment, from concept to implementation. I am responsible for providing estimates, gathering BI and reporting requirements, profiling data, establishing designs, building queries, and front-end designs, performing code reviews, quality assurance, and deploying solutions.

Collaborating with colleagues to ensure backend data structures and semantic layers are designed properly. You would ensure the reporting solution's quality, reliability, and performance. Another responsibility would be to provide operational support and maintenance on reporting and BI solutions. This would include performing incident and problem management and troubleshooting to resolve research data issues and troubleshooting data and performance issues with queries.

Led support BI tool upgrades, configuration, and troubleshooting. Other important responsibilities of your role include developing and maintaining up-to-date documentation, tracking and responding to ad hoc data extracts, and evaluating the tracking information to propose new reporting solutions that promote self-service and less reliance on IT.

As part of your previous experience, you have led business and technical teams on reporting and analytics for electronic Prior authorization reporting requirements. You have played an important role in managing medical costs and patient care. You have also worked with complex, cumbersome processes and designed and built reporting solutions that help reduce excessive manual or unnecessary work. You have designed and developed a data mart and reporting view for real-time prescription benefit analysis, supporting patient care and cost savings. Lead strategic reporting on electronic prior authorization volumes and transactions for regulatory bodies to streamline operational processes and procedures.

Led reporting and analytics to help adopt automation and interoperability technology into their workflows.

Led reporting and Analysis for Electronic Health Records for EHR and PBM

Design and build technical BI solutions from concept to implementation in an agile environment. Participate in the full systems development lifecycle, including providing estimates, gathering BI and reporting requirements, profiling data, establishing designs, building code, tables, views, queries, and front-end designs, performing code reviews, quality assurance, and deploying solutions.

Collaborate with colleagues to ensure backend data structures and semantic layers are designed properly and fit for purpose.

Ensure overall reporting solution quality, reliability, and performance.

Provide operational support and maintenance on reporting and BI solutions; Perform incident and problem management and troubleshooting to resolve issues.

Research data issues and troubleshoot data and performance issues with queries.

Worked with Big Query and query optimization.

Designed and worked directly with Tableau Enterprise Server, Tableau Prep, and R programming.

Lead Data Analytic Space for Real-Time Prescription, Clinical Direct

Provide thought partnerships in data management and data analytics industry best practices.

Participate in the evaluation of new technologies for continuous improvement.

Comply with data governance policies and standards.

Assist teammates with problem resolution of data and reporting issues; collaborate on developing new solutions.

Strong understanding and experience using Agile frameworks (e.g., Scrum, Kanban, etc.) and coaching effective team dynamics.

Anthem Corporation-Medicare-Government

Manager- Business Information Consultant-Reporting Analytic 2020-2021

Manage and coordinate the revenue and medical cost analysis activities to accomplish the health plan's financial objectives, focusing on data and reporting support for provider collaboration efforts, focusing on behavioral health. Directing and overseeing health plan financial analysis, cost of care analytics, trend analysis, financial reporting, financial operations, cost and budget management and allocation, reporting and delivery of key information to generate cost-saving or revenue enhancement ideas, and achieving financial targets.

Lead the Enterprise Revenue Initiative Premium Optimization Reporting Model and The Med Frail Project Nationwide.

Responsible for serving as an expert in data analysis, reporting, formulating recommendations, and providing guidance to other data analysts. Primary duties may include but are not limited to creating and maintaining databases to track business performance.

Analyzing data and summarizing performance using summary statistical procedures. Developing and analyzing business performance reports (e.g., for claims, provider, utilization data) and providing notations of performance deviations and anomalies.

Create and publish periodic reports and any necessary ad hoc reports. This may require taking business issues and devising the best way to develop appropriate diagnostic and/or tracking data that will translate business requirements into usable decision support tools. May make recommendations based on data analysis. Providing analytic consultation to other business areas, leadership, or external customers. Data analysis and reporting encompass a much higher level of complexity.

C H ROBINSON CORPORATION, Minneapolis, MN 2019 - 2020

Lead Business Intelligence Developer /Power BI Architect

Onboarded to drive and support the BI and analytics platform for information technology, overseeing application design, dashboard analysis, KPI development, and data security/integrity. Designed KPIs, scorecards, and dashboards in Power BI data architecture, cloud, and reporting services.

Created aggregate and data analysis expression (DAX) functions for Power BI users. Identified and resolved high-priority incidents.

Developed and validated reports using approved technologies. Set clear goals for stakeholders and C-suite leadership. Partnered with cross-functional teams to implement and optimize analytics and reporting tools to maximize service levels.

Showcased exceptional ability to develop non-complex, highly functional, user-friendly reports and systems that met business needs.

Resolved an 8-hour lag time by measuring KPIs, assessing dashboards, and providing analyses and recommendations that enabled real-time data, information accessibility, and new product functionality.

Leveraged deep conceptual and technological understanding of contemporary architecture concepts, industry trends, and best practices, offering the innate ability to assess organizational needs.

TARGET CORPORATION, Minneapolis, MN 2016-2019

Lead Enterprise Data Science, Analytics & Business Intelligence

I administered and directed multiple projects related to descriptive and predictive analytics, C-level reporting, and financial retail services. These projects involved collaborating with IT security teams to enhance users’ access and security across the reporting platform, managing controls and monitoring mechanisms for financial and collection compliance tracking, and strategizing data and processes from the source system to the data warehouse to report to Tableau and Domo. Additionally, I collaborated with business leaders to streamline business processes and workload by automating reporting solutions using Power BI, Tableau, SSRS, .NET, SAS, and Domo. I also cultivated vendor relations.

As a lead developer and consultant, I championed the execution of 20 migration projects and 16 objectives and key results (OKR), focusing on reporting dashboards, credit transaction disputes, large cash transactions, and bankruptcy information. These projects yielded several positive outcomes, including validating transactions over $5K, resolving the measurement of guest priority call routing, enabling the transformation of the closed-loop gift card issuance dashboard report, and providing TRIM Financial Transaction and Summary, which helped identify trends among network, vendor, and product types that may impact future recovery operations. These dashboards are extremely useful for the team, as they help identify account-level detail and vendor performance that was not readily available before. They have eliminated a lot of manual work and made the process more streamlined.

ALVIN TOOSE KPOTO – PAGE 2 Ramsey, MN 55303 651-***-**** ad48ul@r.postjobfree.com linkedin.com/in/alvin-kpoto-32a68a16/

Professional Experience Continued…>

DITECH FINANCIAL LLC, St. Paul, MN 2015-2016

Business Intelligence Lead Developer/Manager

I supervised a team of 12 business analysts and developers to ensure successful delivery of high-level engagement projects, which required data mining, analysis, and reporting/dashboard development. I also performed data analysis to identify relevant trends and data quality issues, formulated recommendations to leadership, and delivered presentations to senior management to monitor project status. Additionally, I served as a subject matter expert for internal clients, performing analyses and designing visual reports. I conducted all aspects of training, mentoring, coaching, and team development.

Furthermore, I evaluated systems and identified infrastructure constraints and friction points, and implemented changes to optimize efficiency. I also revitalized business analytics and reporting platforms, improved existing reports, and monitoring functions that enabled low- and high-level reporting tools.

WELLS FARGO CAPITAL MARKETS, Eagan, MN 2009-2010 & 2014-2015

Analytics Consultant ● 2014-2015

I consulted with clients in capital markets to understand their business requirements and needs for complex analysis designs and recommendations.

I managed the design of statistical and financial analysis, predictive modeling, process documentation, and comparative analysis. I interpreted the results and recommended solutions to increase revenue, reduce expenses, and maximize operating efficiency. Additionally, I streamlined data issues to provide solutions and benchmarks for loan borrower processes.

I stayed up-to-date with all the latest trends in North America, and I readily implemented industry best practices, including document principles, policies, standards, and governance processes, while considering security, performance, scalability, and reliability.

Contractor-Application System Engineer - Business Intelligence ● 2009-2010

Supported SQL Server database engine, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS) projects to completion. Formulated solutions based on functional specifications, administering the build, testing, deployment, and maintenance lifecycle. Designed database using SQL Server Management Studio, implementation, and support functions, administering security implementation and backup management. Designed, tested, implemented, and maintained efficient ETLs using control and data flow translations and multi-dimensional cubes from various input sources to serve output analytics and reporting needs.

Developed vast knowledge of data warehousing and other BI software concepts and products.

Showcased expertise in working with complex architecture frameworks to support this organization, which has multiple business units, geographic areas, and systems footprint across numerous technologies.

DELL CORPORATION, Eden Prairie, MN 2010-2014

Advisor Business Intelligence Developer

I have created tools using the Microsoft BI stack, such as Visual Studio.net, SQL, SSAS, SSIS, SSRS, and MS SharePoint. I have established standards and best practices for data warehousing, SSAS, and BI development throughout the SDLC. I have overseen all aspects of data architecture, software development methodology, and reporting. I have conducted technical reviews and code walkthroughs. I have led the implementation of Microsoft Analysis Services and collaborated with stakeholders to prototype, refine, test, and debug solutions. I have also managed and mentored junior programmers and developed test plans, including individual unit test plans and system test plans. Lastly, I have designed relational and multidimensional data marts, web interfaces, dashboards, and scorecards using online analytical processing (OLAP) to improve organizational reporting and analytics.

Early Roles: Senior SQL Server Database Administrator for Educational Credit Management Corp., Senior Programming Analyst at East Jefferson Hospital. SQL Software Engineer/DBA at Cerner Corporation and SQL Database Administrator at Radiant Global.

EDUCATION & TECHNOLOGIES

Master of Data Science ● University of St. Thomas, Minneapolis, MN

BSc, Administration Management: Management Information Systems (MIS) ● Alabama A&M University, Huntsville, AL

Python Certification Training for Data Science

Contact this candidate