 Analyze data from variety of source application datasets for collection, transformation, and presentation. Source data extracted and staged into Oracle data warehouse through SSIS package development, including flat files, Microsoft SQL, and other Oracle SQL DB formats. Design data models and SQL code for transforming data into presentation layer. Develop and administer Tableau analytical reports and dashboards. Added process flows, data validations and logging to existing processes to enhance accuracy and timeliness. Built data process package to allow for dynamic looping of multiple sources with different table layouts through a single set of tasks. Source software systems include Epic EMR, HP PM/SM/AM, Lawson Financial, McKesson HPM.

 Expanded and streamlined new and existing business functionalities with data restructuring, software/system upgrades, and process/report development. Reduced auto and manual processing time, distributed work load and accountability, gained stability, and increased accuracy. Collaborated with project, technology, and accounting teams to gather customer requirements, assess and design solutions. Managed team of data analysts, with emphasis on accurate, timely data presented seamlessly to internal and external customer base. Data development, maintenance, and support for multiple global business products in a SQL based environment. Data architecture consisting of database fact and dimension tables and analysis cubes, with reference and staging loader imports, data entry applications, ETL process flows, including EMI, oracle financial integration, and miscellaneous report system exports.