Bill Kang

Sr. Oncology Data Warehouse Specialist at Baptist Health South Florida
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Miami-Fort Lauderdale Area
Languages
  • CHINESE Native or bilingual proficiency
  • English -
  • Spanish Elementary proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Duolingo Spanish Fluency: Beginner (Estimated)
    Duolingo
    Nov, 2015
    - Oct, 2024
  • Duolingo Spanish Fluency: Beginner (Estimated)
    Duolingo
    Nov, 2015
    - Oct, 2024

Experience

  • Baptist Health
    • United States
    • Hospitals and Health Care
    • 700 & Above Employee
    • Sr. Oncology Data Warehouse Specialist
      • Apr 2014 - Present

      Data warehouse application design and development with Informatica and metadata tools. Responsible for data warehouse and ETL design, development, and maintenance in Clinical/Financial/Scheduling/Breast Tumor process/Pharmaceutical subject areas at Miami Cancer Center. Worked with various healthcare vendor products, such as Nextgen and Siemens, Invision, ECHO, EPremis, Soarian Financial, Cerner Millennium, and Cache databases. Support various DWH applications in Oncology Analytics, Pharmacy, Patient census, Patient portal, CCDA, Meaningful use, Revenue analysis, charges and claims, security audit, clinical analysis reports, and provide data feeds to Soarian/Cerner/CMS-PQRS/Truven/Influence Health and HealthGrade Marketing applications.. Also perform duties as Informatica administrator, create deployment groups and perform ETL migrations for QA and PROD environments, maintain INFA server operations and management, administer B2B servers, and manage PROD Job schedules. Working with DB2, SQL Servers, Oracle, Sybase databases and Unix servers using tools such as Putty, Edit Plus, Filezilla, Toad for Oracle, Toad Data Point, Oracle SQL Developer, Erwin, ER Studio, and MS Management studio. Also had experience migrating data to Hardoop/MapR\Hive for big data applications.

  • Ace Tech Consulting Services Inc.
    • Consultant
      • Jul 2012 - Mar 2014

      Consultant at Kansas City Southern Railway. Responsible for new Price data warehouse ETL development with DB2 and SQL Server for marketing and financial departments. ; also provided maintenance or enhancements to existing data warehouse ETL processes with Informatica 9.1. Designed and developed MQ interface programs to handle data to and from external SQL Server source. Consultant at Kansas City Southern Railway. Responsible for new Price data warehouse ETL development with DB2 and SQL Server for marketing and financial departments. ; also provided maintenance or enhancements to existing data warehouse ETL processes with Informatica 9.1. Designed and developed MQ interface programs to handle data to and from external SQL Server source.

  • Kansas City Southern
    • United States
    • Rail Transportation
    • 700 & Above Employee
    • Data Warehouse Developer Consultant
      • Jul 2011 - Jul 2012

      Solely designed and developed a data mart with 8 universes; completed for Employee Workforce Management data warehouse. Integrated data sources from DB2 UDB/LUW with high volumes into SQL Server 2008 R2 using Informatica 8.6/9.1 as ETL tool and using Business Objects Web Reporting Services for queries/reports.

    • Consultant
      • Jul 2009 - Jul 2011

      Rail operations management system design and development with COBOL, DB2, VB, Websphere, CICS, BATCH JCL, CNTL-M, MF COBOL, LINUX UDB; Revenue/Financial system conversion from Adabas to DB2. Designed/developed new Financial data warehouses with Informatica 8.6 ETL tool; SQL Server 2008; Infoview with Business Object XE R3.1.

  • Kansas City Southern Railway
    • consultant
      • May 1997 - Jan 2009

      •Served as team lead, application architect, data modeler, business analyst, programmer analyst. •One of the key designers for Management Control System, Responsible for the design and development in various VB/COBOL/DB2/CICS real time processing projects in operations management, billing, EDI, Legacy system conversion (from Adabas to DB2), and JAVA for web user interface. •Designed and developed various JCL batch applications and dashboard Executive Management reports. •Supported in Data warehouse requirements analysis and design, Informatica ETL Mapping, and Business Object reporting. •Designed DB2 to SQL server data conversions for applications using stored procedures, C# and dot net.•Performed many large-scale applications’ requirement analysis, system design, performance tuning, code reviews, unit tests, Integration tests, QA, use case analysis, user acceptance tests, and post-production problem solving. •Prepared project documentations to follow SOX guidelines and established IT standards.•Managed onshore /offshore project development and implemented 4 system merger integrations.

  • BNSF Railway
    • United States
    • Freight and Package Transportation
    • 700 & Above Employee
    • Consultant
      • May 1992 - May 1997

      •Responsible for design and development of various major operational management projects in a sysplex, IMS DC, Natural, COBOL, DB2, EDI environment. •Supported various Service Scheduling projects with interface to billing, crew calling, AEI applications •Responsible for design and development of various major operational management projects in a sysplex, IMS DC, Natural, COBOL, DB2, EDI environment. •Supported various Service Scheduling projects with interface to billing, crew calling, AEI applications

  • State Government of Kentucky
    • Consultant
      • Jun 1990 - May 1992

      •Responsible for various IMS DB/DC, CICS, COBOL, and DB2 projects. •Served as programmer analyst for program development •Served as DB2 DBA for data modeling. •Responsible for various IMS DB/DC, CICS, COBOL, and DB2 projects. •Served as programmer analyst for program development •Served as DB2 DBA for data modeling.

  • Nokia Bell Labs
    • Telecommunications
    • 700 & Above Employee
    • Consultant
      • Jun 1988 - Aug 1988

      •Responsible for Database product evaluations and functional requirement analysis. •Worked with Oracle, Sybase, and Informix products in C/UNIX environment. •Responsible for Database product evaluations and functional requirement analysis. •Worked with Oracle, Sybase, and Informix products in C/UNIX environment.

  • Great Pittsburg Gas Company
    • Programmer Analyst
      • Jun 1985 - Dec 1986

      •Responsible for Utility billing and accounting related project development in Cobol, VSAM and JCL. •Responsible for Utility billing and accounting related project development in Cobol, VSAM and JCL.

Education

  • Iowa State University
    Master of Science (MS), Sociology
    -
  • Southern Illinois University, Carbondale
    MS, Computer Science
    -

Community

You need to have a working account to view this content. Click here to join now