SUMMARY:

• Talent, self - motivated, quality results-driven designs and administrate from scratch and delivered multiple Enterprise Big Data Warehouses to streamline and scale reporting process. Co-manage Agile projects with SLAs among the cross functional teams including client interviewing, negotiating, strategizing plan, resolving concerns, task assigning, evaluating daily tasks for various industries from scratch with minimal supervision. Delivering over 60 custom dashboards that unify business practices, set new meaningful targets for operational metrics, architect intuitive analytic visualization that drive business values, resulting better quality of managed care, such reducing infections, adverse drug effects, and hospital readmit
• Leading by example, coaching associates and synergize cross function teams, operational management to C-level to formulate best in class user experience for single version of truth that is trusted by teams, drive meaningful, targeted quality improvement, contributing toward one goal in unison. Manage customer user experience on applications and expectation with deliverable that enable efficient and effective operations. Lead Agile SCURM meetings. Integrate well using excellent communication skills to manage internationals teams across different time zones, across the globe
• By delivering analytics across analysts, such as Time Series analysis, such as Default, Cash Flow, Drifts, YoY Comparison, AB comparisons, treading & forecasting, classification, clustering, segmentation, association, sequence on the frontlines of operation, as well as to executives in the boardroom, organizations leverage evidenced based visualization to critically evaluate business processes and pursue the exceptional opportunities for best outcomes, and rewarded with financial success and recognitions in a dynamic market
• Crisis events, liked sepsis and infection, are causing complications & deaths at ICU. By devising a bedside alert system based on predictive algorithms and Big Data, it provides early warnings resulting improved patient safety & quality
• Adverse drug effect can cause the diabetic patients seen at a clinic ending up in ER. Architect multi-tenants Population Health solutions with Descriptive Analytics to enable physicians seeing risk patients to be proactive on managed care
• Unsustainable long working hours is causing fatigue to health care workers. Architected a ED admission flow model with KPI allowing Plan-Do-Check-Act Cycle to prevent bottleneck resulting better utilization and accountability
• Successfully leading teams of 10+ talents, managing multiple sensitive projects for a billion-dollar portfolio in a mix of UNIX and Windows systems. Co-authored standards, procedures on Data Quality and Stewardship with Master Data Management. Repeatedly, shorten project cycles over 50% with very limited resources
• About $1 MM worth of assets vanished. After my extensive research, with data mining based on clustering and basket analysis, which is beyond my duty, recovered over $700 K assets
• Reporting data marts were taking unacceptable long wait time. Re-architect the Kimball’s data marts, refactor Inmon’s EDW, on columnar and in memory databases, resulting response time is 70x faster, near 0% on CPU usage
• Delivering drill-down, drill-thru, Data Discovery driven analytic reports that is highly interactive, associative, and visualized with PowerView, PowerPivot, PowerChart that is Qlikview Set Analysis liked which save the company from spending $3 MM on Total Cost of Ownership
• The ETL process recommended by Microsoft Engineer takes a day to completely load the historical data to one Fact table. I re-architected the ingestion using World Class ETL tool executed with power shell and Control-M on the existing hardware and reduced time from 1 day to less than 40 minutes, resulting a 100x faster ETL
• Define global standard for Enterprise Data System implementation. Customize, define access, and distribute data cleansing, aggregating, merging, and copying between worldwide Data Marts from over 20 different data sources

TECHNICAL SKILLS:

Big Data: Had o op, HDFS, HDP, HIVE, HCatalog, PIG, Ambari, SPARK, Cassandra, sqoop, flume, Zeppelin, Kafka, maven, Storm, Talend, Yarn’s CapacityScheduler, Falcon, Zookeeper, Oozie, Ranger, Hortonworks, NiFi, HAWQ

Database Systems: MS SQL Server, AS400, HealthFacts, i2b2, Millennium, Oracle, SAS, Salesforce, Columnar SYBASE IQ, Vertica7, Epic Clarity, Caboodle, Azure BlobStorage, Document DB, Table Store, MPP Greenplum

Languages (3GL/4GL): C, C#, powershell, DAX, MDX, Python, R, SQL, CCL, bash, Java, JavaScript, KRYO

IDE: Discern Visual Developer, Rational ClearCase, git, R Studio, eclipse, and Visual Studio.NET

UNIX Tools: vmstat, sr, swap, iostat, fsstat, netstat, dim stat, vi, chmod, mkdir, top, free, ps, ifconfig

Tools: Word, Excel, MS Office, Visio, Rose, NETMON, PerfMon, traceroute, nslookup, ping, WinDBG, ODBC, SQLdm

Database Tools: Hyperspace, Erwin, Embarcadero ER/Studio, DTS, SSIS, SSAS, SQL Enterprise Manager, SSMS, SQL Profiler, sqlio, Red Gate Idera, DataStage, Qlikview Management Console, JIRA, Infomatica Powercenter

Reporting: Endeca, SSRS, Tableau, QlickView, SAP Business Objects, Crystal Report, Confidential, Cognos, PowerPivot

Network Operating System and Security: Windows Cluster, HP-UX, IBM AIX, Linux, Solaris, VMware, Active Directory, SSL, Cert, Centrex, DHCP, DNS, Kerberos, NIS, ssh, putty, NFS, Section Access

System Tools: Dell and EMC Disk/Server Administrator, Solaris Enterprise Manager

Web Servers: Apache and IIS

PROFESSIONAL EXPERIENCE:

Data (Solution) Architect

Confidential

Responsibilities:

• Manage projects using Agile across functional teams to integrate the internal and external McKesson, Greenway, eClinicalWorks Confidential and Claims Administrator to produce extracts and map data to implement Enterprise Hadoop Data Warehouse structures. The team grow from 5 contributors to over 40 members global team
• Lead evidence based research to build registries for Stroke, Blood Management, Epilepsy, Asthma, Lupus, Behavior Health, with Point in Time reporting, A/B Comparison analytics
• Lead development of Qlikview models and dashboards with Set Analysis, Section Access, near instantaneous response time. Manage Server and Publisher for production and development environments and ETL performance tuning. Schedule Qlik ETL task and trouble shoot failures. Architect User access framework and levels of secure patient information with IIS for intranet and Emory and Morehouse access
• Coach, review, and enhance technical specifications to/from Business Systems Analysts with time/effort estimates to drive success
• Monitor ETL nightly and near real time micro batches of data from Cache AIX server to relational database with custom tables and views. Maintain ssh shell and connections between servers and user nodes. Merge data from different data sources into Cogito for a single version of truth portal with Confidential
• Standardize and supervise Workflow to ensure procedure, process, and policy available to cross teams and populate Enterprise Master Data Dictionary with Data Quality Services and orchestrate with Azure Data Factory
• Installation, configuration, upgrade of different Hadoop eco-system components in the existing cluster creation and removal of nodes with Zookeeper and Ambari. Create IMPALA interactive processing jobs
• Review and oversee the Data Warehouse that address performance requirements, reusability, availability, integrity, security challenges, and business functional requirements for Centralized ETLs
• Design and created over 60 visual analytics over epidemiological, health plan, revenue cycle, ACO, 340(b) medication, Vent, CPOE, SmartText, ED Provider Notes, ED throughput, ED Events, Compliance, Patient Safety
• Using Data Vault 2.0 methodology to ingest Big Data, transform data to build Cubes using cutting-edge Models in Tabular and Multi-Dimensional, and Data Lake, with Master Data Management meta data to clean, to unify, to standardize, to provide analytic platform for Data Discovery with automated reports via Tableau, BO, Power BI
• Hourly batch importing and exporting data from different systems to Hadoop file system using SQOOP
• Stream logs for Metrics Collection and Monitoring with Kafka and SPARK
• Machine Learning with dedicated multi-nodes Spark MLib with 6/2/2 train, test, and validate dataframes, such as Alternating Least Square, Regression, Classification, Clustering export data to JSON. Creating databases, tables and views in HIVEQL, HIVE MetaStore, HAWQ and PIG LATIN for data discovery in Zeppelin
• Schedule and monitor MS SQL Server ETL and maintaining by adding tables, and artifacts to extract HL7
• Orchestrate pipeline and data governance Falcon. Loading logs from multiple sources directly into HDFS using Flume
• Repeated duties are avoided from prior work experience

EDW BI (Solution) Architect Lead, Epic

Confidential

Responsibilities:

• Lead team of 12 scrum meetings with DBA, ETL Architect, Business Analysts, Reporting Architects, SME. Management performance, assign task, and providing training
• Host meetings to gather requirements with C suites, department chair, FV team, Epic TS, Data Couriers, and Application Coordinators on problem resolution covering In-Patient, ED, Out-patients, ADT. Whiteboarding, Negotiate and strategize timeline, deliverables, and several complete life cycle project implementations
• Architect Medicare Part C Plan dashboard for Confidential covering, provider fee-for service, verification calls, provider payment disputed resolution process, Employer Group Plan Sponsors, Enrollment Verification, Star Rating Measures
• Optimize Structured RDBMS and Network model of file system database, Cache for visualization on PowerPivot, and PowerView. Enhance Model’s Interface, specify and standardize Enterprise measures and KPI, publish Models to Sharepoint Dashboard for improve decision-making and operational efficiency. Ambulatory PCMH, Physician Dashboard with Visit, Attending, Referring for all Units
• Harness and share integrated data models and architecture solutions to create insights for critical decisions and drive better outcomes - across all levels in the healthcare enterprise and reaching new level of excellence
• Maintenance, review, architect modeling document metadata, and Knowledge Base Documentation, verify content with Data Steward and Business Owner
• Resolve incidents within service level agreements for On-Premise and Cloud issues related to SQL and NoSQL
• Provide accurate estimates from End-to-End of SDLC. Minimize and escalate project risk. Identifying dependencies. Support platforms from POC development to production
• Administrate Clarity Console for nightly ETL from Cache to Clarity and Data Warehouse with Custom Schema and ETL script. Monitor completion of daily load, work with Application Team to bring new items from INI file to enhance Clarity data model. Applying KB SQL for Clarity data model with Epic Chronicles and advise on custom work bench reporting
• Unit Testing Cache with %UnitTest package on xUnit testing frameworks and working with Hyperspace user interface. Build Meaningful Use database objects, table, view, proc
• Design, Implement, Exception Reports on monitoring AR Days, Write Off, Cash Collection, Denial Resolution, Self Pay, Clean Claim Rate with Epic Resolute
• Upgrade from maven, review job performances and capacity planning of Hadoop clusters
• Importing and exporting data from different systems to Hadoop file system using SQOOP
• Architect high performance and highly scalable data marts, single version of truth warehouse, Caboodle. On-site support for Epic implementation RA/SU, upgrade, and go-lives throughout the organization. Architect, implement, administrate, validate Epic Cadence supports for outpatient scheduling
• Architect storage and archiving strategies for enterprise disaster recovery and data recovery
• Write batch processing MapReduce jobs in Hive, Pig, define job flows in Hadoop using Oozie for data scrubbing
• Repeated duties are avoided from prior work experience

Senior Database Engineer, RnD

Confidential

Responsibilities:

• BI architect for SSAS and ETL from OLTP to data warehouse using SSIS and Centralized ETLs. Develop Agile approach with various teams/customers to assistance them with the system & application's integration, rollout, and awareness training. Provide design support
• Trouble-shoot ETL, security, and resolve priority 1 issues at production by writing patches
• Secure & automate SSIS packages with MS SQL Server Agent Jobs by schedule
• Deploy and configure SSRS for reports based on cube and/or relational sources. Enhance KPI
• Model physical and logical database on Players, Slots, Tables, Campaigns into Star Schema
• Custom architect distribute data cleansing, aggregating, merging, and copying between data marts using DTS and SSIS
• Map schema between the OLTP and OLAP
• Lead Water-fall lifecycle of Internationalizing of data warehouse from Design to Verification
• Design Primary Key, Foreign Key, and Constraints to map to business model for Data Marts
• Design Dimension, Measure Group, partition, aggregation for Confidential cubes. Develop test plan for Unit, System, Backward compatibility, Integration testing, including functional, browser compatibility, performance, installation, load tests
• Work assigned projects (by utilizing various tools), allocate resource, identify risk and emerging issues, and estimated deliverable to internal teams and customers. Execute manual & auto test cases and report software defects in bug tracking system
• Assist with development & identification of process/procedures for hardware and software based systems and application. Prepare project checklist for milestones
• Model business with ER Diagram, mapping of logical model to physical tables. Refractor new architecture to support new requirements. Design cubes & global templates for report generations with Integration, Analysis, & Report Services. Lead upgrade and migration of 7x24 Cluster MS SQL Servers with Replication and Mirroring
• Provide extensive data analysis on business requirement, refractor existing design to support new requirement, translate functionalities to optimized queries and stored procedures, design and implement of working multi-tier casino management system
• Proficient in sqlcmd, VIEWS, and optimize T-SQL with SQL Query Analyzer using index
• Lead on database software development lifecycle from Design to Verification

Adjunct Professor

Confidential, Arizona

Responsibilities:

• Lecture courses Microsoft Official Curriculum, including Programming Microsoft SQL Server Database and C# Programming with Microsoft .NET framework
• Advise in-depth of modern database system and future trends in .NET framework
• Guide, coach, and evaluate student’s projects, assignment, and attendance
• Mentor students with weekly and monthly feedback to drive their strengths and stay on course to graduate