KWABENA YEBOAH BOATENG
IT professional with extensive years of experience business and Data analysis in fields such as Healthcare analytics and Business Intelligence, Proficient knowledge in statistics, mathematics and analytics. Excellent understanding of business operations and analytics tools for effective analysis of data. Seeking to utilize my skills, abilities, teamwork and excellent organizational and problem-solving skills to achieve growth.
·Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix
·Data Dictionary: Oracle, MySQL, MS SQL, SQLite, PostgreSQL
·Databases: MS SQL Server 2008/2012, MySQL 5.2, 5.7, Oracle 10g, 11g, 12c, DB2, SAS
·ETL/Other Tools: SAS Base 9.x, SAS Enterprise Guide, SSIS, Erwin Data Modeler
·Querying Tools: SQL Management Studio 2008/2012, SQL Plus, SQL Developer, Toad
·Querying Language: SQL, PL/SQL, TSQL
·Business Intelligence Tools: Tableau 9.2, 9.3, 10.4, Excel and PowerBI, SSRS, MicroStrategy
·Data Integration: Tableau with Redshift, Hadoop, Cloud Platforms
·Experienced Architecting Big Data platforms using Apache Hadoop, Cloudera, Hortonworks and MapR distributions.
·Strong knowledge of cloud data processing architectures.
·In-depth knowledge of popular database and data warehouse technologies from Amazon, Google, Microsoft Azure SQL Data Warehouse, Teradata, Redshift, BigQuery
SUMMARY OF QUALIFICATIONS
·Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).
·Strong ability to write SQL queries using PROC SQL.
·Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
·Experience with DATA MINING.
·Knowledge of healthcare information systems, experience with Practice Management software and HIPAA Guidelines.
·Identified issues when reports are created from several and complex data sources.
·Experience in data scrubbing and cleansing.
·Exceptional organizational and time management skills and the ability to work independently.
·Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
·Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
·Good knowledge of portfolio analysis, management and customer segmentation.
·Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
·Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.
·Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.
·Excellent knowledge and exposure on the Medicaid Drug Program.
·Knowledgeable and experienced in pharmacy practice, pharmacology and prescription drugs and efficacy.
Hackensack Meridian Health, Hackensack, NJ (Remote Contractor: Swiftlearn IT Solutions)
BI Developer / Tableau Developer
August 2017 – Present
·Developing SQL queries that were highly tuned using concepts like CTE, Partition, cast, and volatile tables
·Developing complex PROC SQL queries within SAS environment using advanced SQL concepts like aggregate functions, Group By, string Functions
·Created drill through reports and dashboard using tableau
·Developing reports, dashboards using Tableau for quick reviews to be presented to Business and IT users
·Extensive experience in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard
·Harmonizing disparate data sources for use in tableau by leveraging data blending
·Writing queries to fetch data from different tables using JOINs, Sub-queries, Correlated sub-queries and derived tables on Teradata platform
·Developing prescription and usage reports in tableau for the pharmacy unit.
·Incorporating pharmacy best practice in developing analytics applications for the pharmacy unit
·Creating dashboard by leveraging techniques such as parameters, sets, groups and calculations for a granular and drill-down perspective of the reports
·Gathering data from different data sources like MySQL, Oracle and SQL Server
·Creating calculated fields, mapping and hierarchies
·Experience in creating a dual-axis bar chart with multiple measures
Kmart Pharmacy – Sebring, FL (Contractor: Swiftlearn IT Solutions)
ETL / BI Developer / Tableau Developer
July 2013 – June 2017
·Possess good Analytical and Documentation skills and ability to perform as in a Team Environment
·Involved in Production Support and troubleshooting data quality and integrity issues
·Data mapping from source to destination/target databases
·Maintained Data consistency and database integrity
·Responsible for interaction with business stakeholders, gathering requirements and managing the delivery
·Migrated Coram Data to the Kmart Health Network using SSIS
·Created functions and procedures to enhance and smoothen the process of data migration
·Developed scenarios for Unit testing and Integration testing
·Connected Tableau server to publish dashboard to a central location for portal integration
·Participate in cross-functional task forces to identify and document functional or reporting Processes and Requirements
·Gather, analyze, and document data requirements for projects of medium to high complexity
·Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using SQL Server Management Studio, MS Access, MS Excel
·Created new database objects like Tables, Procedures, Functions, Indexes and Views
·Performed numerous data manipulation language or queries using SQL for analysis
·Conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility
·Participate in the analysis of client business processes and functional or reporting requirement
IntraHealth Group – Atlanta, GA (Contractor: Swiftlearn IT Solutions)
ETL / BI Developer
August 2009 – June 2013
·Coordinates financial analysis functions, including data mining, due diligence within multiple systems (Great Plains, Athena etc..)
·Provides statistical analysis and reporting needed for physician compensation model calculations. Formulates financial planning activities, including annual operating budget preparation and rate development
·Manages financial analysis and ad hoc reports for corporate office and physician constituencies as needed
·Reviews financial statements preparation to include assisting in preparing schedules for presentations to executive management and the Members
·Collaborates with Revenue Cycle team to improve Case Mix, Diagnostic Group Resource (DRG), and accuracy of physician documentation
·Identify and provide solutions for data integrity issues. Work with operational departments and Information Technology to ensure data consistency and accuracy
·Review mapping and assignment of General Ledger mapping logic
·Maintains statistical reporting packages
·Maintains the strictest of confidentiality
·Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data
·Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different SQL Server databases and load data into Data Warehouse
·Optimize load performance while loading bulk data into Data Warehouse and monitoring fact tables and dimensional types.
·Utilize SISS for ETL data modeling, data migration, and analysis
·Prepare high level analysis reports with Excel
·Provides feedback on the quality of data including identification of billing patterns and outliers
·Analyze and Assess invalid and missing data in the Claims Data
·Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts
·Documenting the extent to which data fails to meet threshold reporting requirements
Florida Agricultural and Mechanical University
Doctor of Pharmacy 2006
University of North Florida
Bachelors of Science Biology 2001
Florida State College at Jacksonville
Associates of Arts 1999
Associates of Science IT 1999