PROFESSIONAL EXPERIENCE:

Confidential

IT Manager / Data Architect / Business Intelligence Lead / Enterprise Architect

Responsibilities:

• Lead company’s data strategy, master data management program & data governance policy
• Collaborate with senior staff to create and publish Enterprise Architecture artifacts
• Lead cloud migration initiative (G Suite, ShareFile and Azure)
• Track and influence key company projects for timely completion of the projects
• Lead development of data quality reports and data cleansing
• Ensure organization is compliant with HIPAA, IT Security, CAP CLIA and ISO requirements
• Support business development and marketing departments with data driven analytics
• Lead big data driven clinical support system for genome wide association studies
• Lead IT dept. which consist of 5 small teams (Application Development, Web Development, IT Infrastructure, Bioinformatics and Project Management), total of 16 FTEs
• Worked with IT Infrastructure and DBA to build new cloud (Azure) based data platform for data science and machine learning
• Built Enterprise data models (Canonical, Logical and Physical)
• Lead many ETL, Integration and software development projects

Main technology / tools / standards Used: SQL Server, .NET framework, C#, WCF, WPF, Restful API, TFS, SSIS / SSRS / SSAS, ERWIN, Microsoft Dynamics CRM, Windows Server 2012 / 2016, Microsoft Visio / Office / Project, MySQL, PHP, MongoDB, G Suite, Python, Git, Linux, HPC (High Performance Computing) Cluster, Language R, RHive, Hadoop, Azure PaaS (Azure Web App, Azure SQL database, Azure DocumentDB, Azure Data Warehouse, Azure Data Factory, Azure Machine Learning Data Studio, Azure Site Recovery, Azure Data Lake, Azure Data Factory), TOAD, Oracle, Tableau, PCI DSS, PowerBI

Confidential

DBA lead / Data Architect / ETL Lead / Business Intelligence Lead / IT Manager

Responsibilities:

• Co - lead data strategy for the organization
• Lead development of Enterprise Data Models (Canonical, Logical and Physical)
• Collaborate with infrastructure group on business continuity (RTO, RPO, HA & disaster recovery), consolidation, virtualization, capacity planning and PCI DSS Audits
• Lead completion of many ETL projects (part of implementing new systems), this includes building data quality reports and data cleansing
• Co-Lead development and implementation of Data Governance initiative
• Lead Operational DBAs, made big improvements in stability of the environment
• Lead implementation of new monitoring tools to allow for more proactive DB maintenance
• Co-Lead Master Data Management projects (Dataset includes vendors, customers, stores, fuel products, merchandizing items & GL accounts)
• Created enterprise data architecture artifacts which captured current state and future state
• Co-Lead many data analytics projects (Customers, Merchandising, Marketing & Fuel Analytics), this includes building big data platform and new Enterprise data warehouse.
• Also worked with data scientist group who used machine learning platform
• Co-Lead database developers who worked on agile based software development projects
• Co-Lead development of reports / dashboard platform using SSRS, Tableau and Power BI

Main technology / tools / standards Used: Power BI, TFS, PCI DSS (Data Security Standards), DB2, Windows Server 2003 / 2008 / 2008 R2 / 2012, SAP HANA, SAP Business Objects Data Services, SAP Lumira, SAP Universe, SAP BW, SAP PO, SAP ITSM, Hadoop, RHive, Language R, SQL Server 2005 / 2008 / 2008 R2 / 2012 / 2014, Microsoft Visio / Office / Project / SharePoint, SSIS / SSRS / SSAS, ERWIN, .NET, Tableau, MongoDB, MySQL, Azure SQL Database, Azure IaaS, Oracle, TOAD, XMLspy, Git, Linux, IBM System Architect, HDInsight, PostgreSQL

Confidential

Data Architect / Solution Architect / ETL Lead / Data Modeler / MDM Lead

Responsibilities:

• Co-Lead data modeling (ETL, OLTP & Dimensional) efforts for UCMS (Unified Case Management System) program. UCMS Program includes 7 projects: District, Appellate, e-filing, EDW, e-commerce, e-Interfaces & e-workflow.
• Co-developed current & future state solution and data architecture (and addressed gaps)
• Co-developed data strategy including master data management, data governance and BI
• Lead development of enterprise data warehouse and analytics dashboards including ETL
• Assisted in AMCAD’s business development by providing technical architecture and details
• Lead development of data quality reports and data cleaning efforts (part of data migration)
• Worked with IT Infrastructure on capacity planning and DevOps (using VMWare vDirector), this includes weekly release of AMCAD’s suite of products.
• Lead technical design sessions with data stewards for implementation of Master Data Management (datasets include crime codes, fees, judges, jurisdictions, and case types)

Main technology / tools / standards Used: Windows Server 2008 R2, Microsoft Project / Office / Visio / SharePoint, SQL Server 2008 R2 / 2012, SSIS / SSRS / SSAS, TFS, BizTalk, NIEM, IEPD, ECF 4.0, WCF, PCI DSS, ERWIN, Power BI, Oracle, TOAD, MySQL, PostgreSQL, IBM System Architect, Git, Linux, XMLspy

Confidential

Database Administrator / Data Architect / ETL Developer / Data Modeler / MDM

Responsibilities:

• Plan, develop and implement (including collaborative efforts with vendor) new Enterprise Data Warehouse for the organization (from proof of concept to the final implementation)
• Member of IT leadership team and lead enterprise data strategy / architecture
• Lead database migration efforts for new implementations
• Worked with data stewards and developed data governance plan
• Maintained and sustained 32 database servers containing 109 production databases
• Implemented Master Data Management (datasets include Attorneys, Fees & Crime Codes)
• Developed self-service business analytics models for advance users
• Data profiling and cleansing as per ad-hoc requests by data stewards / SMEs
• Created repository of Enterprise data models (Canonical, Logical and Physical data models)
• Worked with IT Infrastructure on capacity and disaster recovery planning

Main technology / tools /standards Used: Windows Server 2003 / 2008 R2, SQL server 2005 / 2008 / 2008 R2, SQL Server Master Data Services, Microsoft Office / Project / Visio / SharePoint, SSRS / SSIS / SSAS, ERWIN, Power BI, TOAD, Oracle, MySQL, Linux, PostgreSQL, TFS, Git, XMLspy

Confidential

Database Administrator / Data Steward

Responsibilities:

• Database administration and production support of the legacy system
• Create data quality reports for Data Stewards and resolve data quality issues
• Main technology /tools /standards used: SQL server 2005, Windows Server 2003, ERWin, ASP .NET, Microsoft Office / Visio / SharePoint, SSRS / SSIS / SSAS, SourceSafe, PCI DSS
• Summary: Dimensional / transactional data modeling, EDI and Web development, database architecture, API development, database development, ETL development
• Lead development of agency’s first EDI billing software using SOA based architecture
• Lead development of agency’s first true public health enterprise data warehouse
• Co-developed new web based Oklahoma State Immunization Information System
• Added SVS (Smallpox Vaccination System) module to Immunization Information System
• Co-developed PHIDDO (Public Health Investigation and Disease Detection of Oklahoma)
• Implemented emergency communication systems with vendors (PHINMS and OK-HAN)

Main technology / tools / standards Used: ASP.NET/ASP, JavaScript, HTML, SQL Server 2000/2005, TOAD, Oracle 8.0 on Linux & Windows, Microsoft Office / Visio / Project / SharePoint, SourceSafe, Windows Server 2000 / 2003, Active directory, Oracle Reports, SSRS, HL7, EDI, ERWin, VBScript, DTS packages / SSIS, SSAS, XMLspy, PeopleSof