Data Architect

CAREER HIGHLIGHTS

Senior Data Management with broad expertise Data Science, with an emphasis on Data Analysis, Data Manipulation, Data management and Big Data analysis in Oracle, Microsoft SQL Server, Teradata or DB2 databases using SAS, Tableau, Power BI, Phyton and Data Engineering tools.

PROFILE

Enterprise level experience in design, implementation and management of EPIC – Electronic Health Records Management system in leading Healthcare Providers: World Health Organization, Kaiser Permanente, and Pacific Dental Services.

Enterprise level experience in Health care reporting systems using EPIC, Clarity and Chronicle data sets.

Enterprise level experience in design and implementation of Database Management System (DBMS)

Enterprise level experience in design, implementation, governance and migration of DBMS

Enterprise level experience in design and Data Management Platforms

Enterprise level experience in design, implementation of Data Management in Microsoft Front and backend.

Enterprise level experience in design, implementation of Data management in Oracle/DB2/Terad Database

Enterprise level experience in design, implementation of Tableau, SAS & Power BI Business Intelligence tools

Build strong client relationships through communications and service

PROFESSIONAL EXPERIENCE

Kaiser Permanente Hospital Foundation

Sr. Data Consultant (Data Scientist) Present

Architect implement and support of database solutions based on Microsoft and Oracle products (Microsoft SQL Server & Oracle Platforms) using Chronicle, Health and EPIC data.

Architect implement and Tableau and Power BI as a Business Intelligence & Data management tool.

Architect and design Interactive and Click-able Dashboards

Directs the development of outcomes and process measures, including technical specifications, to enable population measurement, guideline implementation, and evaluation.

Builds and maintains complex statistical SAS routines using macros, vendor software, and software written by self and others.

Tests and maintains data integrity across multiple databases (internal SAS, DB2, VSAM, PowerBI, Tableau, Teradata, Exadata, Oracle; external: Adobe, Excel, SAS parsing routines, COBOL and Phyton).

Builds sophisticated statistical models and forecasting tools using these databases.

Designs menu systems that are effective and user-friendly.

Develops reports with accurate, easy to read, useful information that satisfies the client's needs.

Mechanics Bank

System Admin (Database SME) 2015-2016

Architect, design and implement technologies in support of the “run the bank” and “change the bank” Data and Database management operations

Support “run the bank operations: ensure smooth operations of the legacy bank resources and technologies

Innovate “change the bank” operations:

oArchitected and implemented SharePoint with Power BI capabilities

oArchitected, implemented and supported SQL Server with always-on Capabilities.

oDesigned and Implemented SQL Server in a centralized environment with High Availability and fault-tolerance features enabled

Leads, makes significant contributions, and/or provides technical leadership to high visibility projects to identify and resolve issues of strategic importance to the organization. Interfaces regularly with senior management to produce timely and valuable results.

Builds sophisticated statistical models and forecasting tools using these databases.

Designs and enhances databases.

State of California

Lead System Software Specialist (Database Management) 2014-2016

•Architect and Implemented SQL Database Management System in California State Lottery (CSL) and Victim Compensation & Government claims board (VCGCB)

•Architect new Database Management System in Hybrid environment in California State Lottery & Department of Child Support Services (DCSS)

•Migrate 2007 and 2010 SharePoint to 2013/2016 and SharePoint Online in CSL, VCGCB and DCSS.

•Created SharePoint farm, web application, site collection, sites, subsites, libraries, lists, forms and content, disaster recovery and high availability

•Upgrade SQL server from 2003/2005/2008R2 to 2012

•Recreate custom software to support the internal business intelligence.

•Established processes, procedures and mechanics following best practices

.

HP/Dell/Blue Shield of California/Gap Inc.

Data Analyst/Scientist 2012-2014

•Architect and Implement Power BI and SSRS environment – GAP Inc and Blue Shield of California

•Architect and Implemented SCCM for Steol Rives LLC, Blue Shield of California and Gap Inc.

•Migrate end user OS to windows 7 and upgrade Server infrastructure to Windows Server 2012 R2 – Gap Inc. HP (for Bank of America), and Blue Shield of California

•Create governance and standardized IT practices – Gap Inc., AAA Insurance, Bank of America, and Blue Shield of California

•Analyze data to facilitate diction making (Gap, HP & Dell) using SAS and SQL scripts and codes.

United Nations

Sr. Data Management Consultant 1997-2012

•Architect EPIC as an Electronic Records Management System.

•Architect Database Management Systems to store Data for millions of clients in EPIC.

•Architect SAS as a Data Management tool to facilitate Insight Driven strategies

•Create dashboards, reports and automated alerts to improve healthcare quality and efficiency.

•Implement best practice and standardized operations in all United Nations office around globe.

•Perform regular upgrade, migration, and maintenance plans to address complex environments in 112 member countries where United Nations had presence.

•Manage annual IT budget

EDUCATION

•Doctor of Business Admin. (Data Analytics) Grand Canyon University, Phoenix, Arizona-USA, Current

•Master of Business Administration (IT) California State University, Carson, California-USA

•Bachelor of Science, California State University, Turlock, California-USA, 2011

•Master of Computer Sciences, Preston Institute (Not Accredited in USA), Pakistan, 2003

•Master of Business Administration, Preston University (Not Accredited in USA), Pakistan, 2001

•Bachelor of Computer Sciences, Kabul University, Kabul, Afghanistan, 1997

TRAINING

•SAS Base Programming

oBase Programming, I - Essentials,

oSAS Programming II – Data Manipulation Techniques

•SAS Advanced Programming

oSAS Programming III – Advanced Techniques and Efficiencies,

oSAS SQL Language,

oSAS Macros & Graphs

•SAS Grid and Business Intelligence

•Oracle Database Developers Track (Oracle Database 12c)

oIntroduction to Experienced SQL Users,

oDevelop PL/SQL program units,

oPL/SQL Fundamentals,

oSQL Tuning for Developers.

•Completed Database Training Academy Certified Database Administrator

oSQL Server - Transact SQL [70-461],

oSQL Server Administration [70-462],

oData Warehousing Implementation [70-463],

oOracle 11g Database administration and SQL, PL/SQL)

Scaled Agile Framework (SAFe) Agilest and Advanced Scrum Master

Contact this candidate