SUMMARY:

An accomplished, detail - oriented, full stack business intelligence professional with experience supporting leaders and day-to-day business operations. Have identified ≈$100M revenue opportunities, developed 500+ ETL and reporting packages, generated ≈10,000 user views monthly. Strong experience in data modeling, T-SQL, ETL, data warehousing, data analytics, reporting, performance tuning, and troubleshooting. Proficient in programming using Python, C#, and JavaScript. Experience in AWS, Azure, big data, Spark, Java, and Flask API.

PROFILE OF SKILLS:

• Business Intelligence SSIS / SSRS / SSAS Power BI
• SharePoint Tableau Performance Tuning
• ETL Data Warehouse Cube
• Python SQL C#
• AWS Data Profiling Data Mining
• Troubleshooting Flask API Big Data

TECHNICAL SKILLS:

BI Tools: SSIS, SSRS, SSAS, Power BI, SharePoint, Tableau, Excel, ArcGIS

Databases: SQL Server 2008/2012/2016 , Teradata, DB2, Oracle, Access, MySQL, SQL Lite

Languages: SQL, MDX, C#, VB, HTML, JavaScript, XML, ASP, Java (Android), Python

Big Data: Hadoop HDFS, HBase, MongoDB, Hive, Drill, Zeppelin, Pig, Oozie, Sqoop, Flume, Spark

Other: Jupyter, Azure, AWS, Hortonworks, PuTTy

PROFESSIONAL OVERVIEW:

DSS BI Developer Analyst

Confidential, Dallas, TX

Responsibilities:

• Identified ≈$100M revenue opportunities for 172 Confidential hospitals by system comparison of supply chain, order entry, patient accounting, billing, finance, physician sale, surgery, and radiation. Established pipelines to extract and transform data from various sources including Teradata, DB2, Oracle, MySQL, Azure, Excel, website, and json files. Joined tables through revenue codes, charge codes, billing numbers, item numbers, and patient accounts. Identified data discrepancies by comparing key attributes. Created dynamic reports for managers, system administrators, data analyst, nurses to monitor and correct item charge.
• Developed 11 web tools for pricing markup setting, patient transfer logging, CDI mortality monitoring, and workforce reporting, by integrating SQL Server database, T-SQL, stored procedure, SharePoint, JavaScript, HTML, ASP Control, and SSRS, which enable users not only to view reports, but also to edit contents.
• Developed 6 SSIS solutions to extract semi-structural data (Crystal reports, txt, and Excel files) using C# and regular expression.
• Loaded hospital case data for data warehouses population and cube processing. Optimized existing SSIS packages, stored procedures, and views. Generate SSRS, Tableau, Excel, and Power BI reports.
• Designed, built, and deployed one surgery cube using SSAS and SSIS.
• Monitored web report click events by generating weblogs and reports using HTML, JavaScript, ASP controls, SharePoint, SQL Server, Tableau.
• Automated eMAR Scan reporting process for nurses to improve services, by integrating clinical and pharmacy data.
• Monitoring high cost drug usage to comply with government regulations, by integrating Meditech and Pharmacy data.
• Created dashboard reports to monitor data loading, cube processing, data integrity, report clicks and subscription, by collecting logging and auditing data, combining metadata and aggregated data from key files, tables, and cubes.
• Oversaw 6 SQL Server instances, hundreds of jobs; created and administers 3 SharePoint sites.
• Substantial expertise in troubleshooting ETL job failures, SQL performance issues, SSAS processing, and reporting problems.
• Helped coworkers to learn SQL, to create Tableau expressions, to use web tools, and to troubleshoot problems.
• Extensive Python programming experience in data ETL, visualization, and data analysis, including extracting physician information from public web sites, developing customized ArcGIS tools to generate data-driven pages, loading json review files.
• Developed one Android phone app. Hands-on experience in Eclipse, Java, SQLlite, UI design using XML, and version control.
• Systematic training in big data and Hortonworks Ambari. Hands-on experience in Hadoop HDFS, HBase, MongoDB, MySQL, Hive, Drill, Zeppelin, Pig, Oozie, Sqoop, Flume, and Spark Streaming (with MOOC certificate).
• Hands-on experience and training in AWS IAM, EC2, S3, RDS, and EMR.
• Software installation experience, including installation of SQL Server Management Studio, BIDS, SSDT, Tableau, Power BI, ArcGIS, Teradata SQL Assistant, Virtual Machine, JDK, Anaconda, Eclipse, Jupyter Notebook, Python libraries, Hortonworks, and PuTTy.

Senior Research Associate

Confidential, Dallas, TX

Responsibilities:

• Extracted and loaded research literature data (in XML format) into SQL Server 2008 using SSIS and XSLT.
• Designed a data warehouse for microarray data mining. Built SSIS packages to load gene lists and experimental data into SQL Server database. Implemented Kimball Snow Schema by creating data source view, cubes, and dimensions using SSAS.
• Created data models, schemas, constraints, index, views, stored procedures, triggers, functions, cursors in SQL Server databases. Removed duplicates and cleansed data using T-SQL.
• Conducted research in EMAPII gene; investigated the structure, gene expression regulation of EMAP II gene in cell and mouse models; identified a domain that played critical role in EMAP II aggregation when over expressed; published 4 research papers.
• Generated SSRS reports to visualize data distribution, gene expression patterns for microarray, mass spectrometry; performed data mining to identify patterns and clusters of human gene expression.
• Installed Virtual Machine, SQL Server, Oracle, Toad, BIDS, SSDT, and SharePoint.

Research Associate

Confidential, Detroit, MI

Responsibilities:

• Managed and analyzed microarray data from transgenic models; used Microsoft Access database, Excel and SQL to identify co-regulated genes.

Research Fellow

Confidential, Toledo, OH

Responsibilities:

• Used databases and statistics analysis tools to analyze gene regulation data; presented experimental data in an international meeting.