Home

Nagul Shaik - Data Modeler/Data Architect(Healthcare)

[email protected]

Location: San Francisco, California, USA

Relocation: yes

Visa: H1B

Professional Career I have 14+ years of hands on experience in Information Technology (IT) as Data Warehouse Architect, Data Architect, Sr. Azure Data Modeler, Sr. Data Engineer and Business Intelligence Architect in heterogeneous business organizations like California Department of Health Care Services, County of Santa Clara Health System (CSHS), County of Santa Clara Public Health Department (PHD), The University of Texas System (UT Austin), North Carolina State Department of Transportation (NCDOT), Pharmaceuticals, Banking, Finance, Manufacturing and Telecommunications. Technical skills in a glance: Proficient in System and Software Development Life Cycle (SDLC) methodologies Agile, Scrum, Kanban and Iterative. Experienced in TOGAF and Zachman Enterprise Architecture (EA) frameworks. Hands on experience in relational and multidimensional data models design life cycles. Have good experience and knowledge in data conversion life cycle. Well versed in normalization (1NF, 2NF and 3NF) and de-normalization techniques for optimum performance in relational and dimensional database environments. Experienced in designing Entity Relationship Diagrams (ERD) and conceptual, logical and physical data models for OLTP and OLAP systems using data modelling tools like Erwin, DbSchema, ER Studio, SAP Power Designer and Infosphere Data Architect (IDA). Experienced in designing OLAP systems using Kimball, Inmon and Data Vault methodologies for Business Intelligence (BI) projects. Hands on experience in designing OLAP systems using Star and Snowflake schemas. Have hands on experience and solid knowledge in data extraction, data transformation, data profiling, data analysis, data discovery, data masking, data governance, data cleansing, data scrubbing, data validation, data wrangling and Metadata maintenance for Data Warehouse (DWH), Master Data Management (MDM) and Data Conversion (DC) projects. Well proficient in Metadata Management (MM), Reference Data Management (RDM) and Test Data Management (TDM). Good experienced in ETL, ELT, Data Transformations and Source to Target Data Mapping concepts. Experienced in creating and maintaining Slowly Changing Dimensions (SCD) and Change Data Capture (CDC). Expertise in Extract Transform and Load (ETL) techniques using Pentaho Kettle, Informatica, SSIS and Microsoft Data Transformation Service (DTS). Have good experience with data profiling tools like Alteryx, Trillium and Informatica Data Quality (IDQ). Worked with Child Welfare Services (CWS) and Case Management System (CMS). Having very good experience in Health Level Seven (HL7) and FHIR messaging specifications and standards. Having hands on experience in EMR/EHR applications like Epic Clarity and Epic Caboodle. Solid knowledge with Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications. Experienced in data mining, designing OLAP, ROLAP and MOLAP databases. Hands on experience in Data Governance and Data Stewardship policies. Solid knowledge in No SQL data models and databases Mongo DB, Greenplum, HBase, Couchbase, Cassandra and Amazon DynamoDB. Good knowledge and experience in cloud technologies like Azure Purview, Azure Data Lake Store, Azure Data Factory, Azure SQL DB and Azure Synapse Analytics (SQL DW), Snowflake cloud data warehouse, AWS Redshift, AWS RDS and Google Cloud Platform (GCP). Having exposure to big data technologies Hadoop and Spark and extensive experience in both batch and stream processing using Lambda and Kappa architectures. Having good knowledge in IBM Mainframe systems, Adabas (Natural) databases. Good in creating Ad-Hoc reports, Indexes, Stored Procedures, Triggers, Functions and Packages. Having good experience in writing SQL queries to perform end-to-end ETL data validations and solid hands-on experience in Quality Assurance (QA) techniques, performed User Acceptance, Unit, System, Manual, Automated and ETL Testing s. Good knowledge and experience in Microsoft Power BI and Tableau tools, created dashboards, score cards and reports. Having good knowledge and experience in Windows, UNIX and Linux operating systems. Quick learner, self-motivating and enthusiastic to work with new technologies and new people. Possessing excellent verbal and written communication skills. Education qualifications: Bachelor of Technology in Electronics and Communications Engineering. Core technologies and tools: Data Modeling Tools Erwin 9.6, DbSchema 9.9.2, SAP Power Designer 16.5, ER/Studio 19.1, Infosphere Data Architect (IDA), Oracle SQL Data Modeler, UML and Microsoft Visio 2016. ETL Tools Pentaho Data Integration (PDI), Kettle, Informatica 9.5, SQL Server Integration Services (SSIS), Ab Initio, OBIEE, IBM Data Stage. Data Quality Tools Informatica Data Quality (IDQ), Data Quality Services (DQS), Dataflux, Trillium, IBM InfoSphere Quality Stage and IBM Info Sphere Information Analyzer, Query Surge 4, HPQC-ALM. Database Tools Azure SQL DB, Azure Synapse Analytics (SQL DW), AWS Redshift, Postgresql, SQL Server Management Studio (SSMS), Microsoft SQL Server 2012/2016, Toad for DB2, Oracle SQL Developer 4.1, Hadoop, Spark, SAP HANA, Db Visualizer Pro 9.2, Oracle 11g/10g, IBM DB2, Teradata, MS Access, IBM Mainframe and Adabas (Natural). Reporting Tools Power BI, Tableau, Looker, SQL Server Analysis Services (SSAS), TIBCO Spotfire, Cogno s, Qlik Sense, Qlikview and Crystal Reports. Programming Languages ASCII-SQL, PL/SQL, SnowSQL (CLI), Python, XML, XSD, WSDL, NIEM schema, HL7, FHIR, SAS, Spark SQL, R Studio, HTML. Project Tracking Tools Microsoft 365 Apps for Enterprise, Microsoft Office Suite 2016, JIRA, Azure DevOps, SVN Version Control, Visual Studio Code, GitHub, Team Foundation Server (TFS), IBM Rational Clear Case and Clear Quest, Prefect, DBT, Alladin. Operating Systems Microsoft Windows (10, 8), NT/2000/Vista, Unix, Linux. Professional experience: UCSF Health (Canopy Health) San Franscisco, CA Role: Data Warehouse Architect/Sr. Data Engineer Dec 2023 Present UCSF Health (Canopy Health) is the Bay Area s health network that connects the best doctors and hospitals in the Bay Area. Responsibilities Interacted with project management team to gather and document business requirements for the Enterprise Data Warehouse (EDW) project. Designed project architecture and ETL data flow diagrams using Microsoft Visio tool and reviewed with project team. Designed Business Process Diagrams (BPD) using Microsoft Visio tool. Designed Entity Relationship Diagrams (ERD) using DbSchema tool and reviewed with project team. Worked in Master Data Management (MDM) project and integrated master data from various source systems. Performed Data Analysis and Data Profile on source tables data to understand business logic. Identified Critical Data Elements (CDE) for the Enterprise Data Warehouse (EDW) project. Defined Grain, identified Dimensions and Measures for Hospital Billing (HB), Professional Billing (PB) and Claims subject areas in an Enterprise Data Warehouse (EDW) project. Created data modelling design specifications document for dimensional data models. Created naming standards document for logical and physical data models. Designed Conceptual Data Model (CDM), Logical Data Model (LDM) and Physical Data Model (PDM) using DbSchema 9.9.2 tool and reviewed data models with project team. Designed dimensional data models using Slowly Changing Dimensions (SCD) and Conformed dimensions. Conducted data model review sessions with Business architect team. Worked on multiple data marts in Enterprise Data Warehouse (EDW) environment. Worked on Metadata Management across heterogeneous models. Generated business glossary, data dictionary and HTML documents from data models. Created business and data quality rules to maintain high quality data in target tables. Created Source to Target Mapping (STTM) documents with data transformation logic. Created Business Intelligence (BI) reports and performed multidimensional data analysis using Microsoft Power BI and Looker BI tools. Created STG, DEV, TST and PRD databases and table definitions. Tested and documented Unit and System testing test cases. Performed data validation techniques on target database to measure data accuracy and data quality. Worked with DBA team to deploy Physical Data Model (PDM) DDL into PRD databases. Environment: DbSchema 9.9.2, Erwin 9.6, Azure Synapse Analytics, Azure Purview, Azure SQL Database (Azure SQL), Microsoft Azure DevOps, SQL Server Management Studio (SSMS) 20.1, Microsoft Visual Studio (SSIS), Power BI, Tableau, Redgate tool suite, Health Level Seven (HL7), FHIR, Epic Clarity, Epic Clarity Data Dictionary, Epic Caboodle, QNXT, HIPAA, Snowflake Cloud Data Warehouse, SQL, Visual Studio Code, Git, GitHub Desktop, Agile, Confluence, Alladin tool, Microsoft Visio tool, Microsoft 365 Apps for Enterprise, Microsoft Project 2016. California Department of Health Care Services Elk Grove, CA June 2021- Nov 2023 Role: Sr. Azure Data Modeler/Sr. Data Engineer California Department of Health Care Services provides care that includes medical, dental and mental health services to California s incarcerated population at all 34 California Department of Corrections and Rehabilitation (CDCR) institutions statewide. Responsibilities Identified source systems (SOMS, CERNER, Dentrix), tables and desired data elements for reports. Performed data analysis and data profile to get insights of source systems data set. Created data model objects and Azure Synapse services naming standards document. Designed Conceptual Data Model (CDM), Logical Data Model (LDM) and Physical Data Model (PDM) using ER/Studio tool and reviewed data models with project team. Updated table and column definitions in data model and generated data dictionary document. Generated data model DDL and deployed into Dev, Stage, UAT and Prod databases. Created Extract, Transform and Load (ETL) data flow diagram between source and sink databases. Created Source to Target Mapping (STTM) document with data quality and data transformation rules. Created reference tables with reference data, conformed dimensions, Slowly Changing Dimensions (SCD) and different type s fact tables. Created Extract, Transform and Load (ETL), unit and system testing test cases and test plans. Developed SQL queries and verified data in dimension and fact tables to make sure data is accurate with high quality. Environment: ER/Studio Data Architect 19.1, Azure Synapse Analytics, Azure Purview, SQL server 2019, Visual studio 2019, SQL Server Management Studio (SSMS) 18.9.2, SQL, Visual Studio Code, GitHub, Agile, Microsoft office 365, SOMS, CERNER, Dentrix. County of Santa Clara Health System and County of Santa Clara Public Health Department (PHD) San Jose, CA Oct 2018 May 2021 Role: Data Warehouse Architect/Sr. Data Engineer The County of Santa Clara Health System is local healthcare safety net and provider of comprehensive care, service and program to the residents of Santa Clara County. The Health System includes the Public Health Department, Behavioral Health Services Department, Santa Clara Valley Medical Center hospital and clinics, O'Connor Hospital, St. Louise Regional Hospital, Emergency Medical Services Agency, Custody Health Services Department and Valley Health Plan. Santa Clara County health officials dedicated to the health and well-being of all communities of County. Responsibilities Worked with end users (Epidemiologists) team to get business requirements, use cases, prioritize project goals and maintain project tasks traceability matrix. Thoroughly understood PHI and HIPAA rules and regulations to meet organization compliance and patient data privacy requirements. Interacted with multiple SME s to understand source system business process. Designed data warehouse project Data Flow Diagram (DFW) using Microsoft Visio tool. Identified EMR, Epic Clarity, Epic Caboodle source systems and performed data discovery, data analysis and data profiling for Hospital Billing (HB), Professional Billing (PB) and Claims data. Worked with department of family and children s services IT systems Child Welfare Services (CWS) and Case Management System (CMS). Designed Raw Vault (RV) and Business Vault (BV) data models using DbSchema tool for patients, encounters, providers, procedures, medications, labs, vitals, problem list, diagnosis, claims, coverage, enrollment, member, pharmacy subject areas. Generated DDL script and forward engineered Raw Vault (RV), Business Vault (BV) and Star schema data models into target databases. Designed Star schema data model using Erwin tool for billing, payment and insurance (VHP, SCFHP, Medicaid/Medi-Cal and Medicare) subject areas. Defined and maintained Raw Vault (RV), Business Vault (BV) and Star schema data models metadata, business and technical glossary, data dictionary and User Defined Properties (UDP). Reverse Engineered (RE) Epic Caboodle data model using ER/Studio tool. Heavily worked with Health Level Seven (HL7) and FHIR messaging specifications and standards documents to identify mapping for EMR/EHR data elements like patients, encounters, vitals, labs, diagnosis, problem list and claims. Created ETL transformations to move data from HL7/FHIR applications to SQL server database. Developed ETL process and loaded data from source and stage systems into target systems using Lambda architecture. Designed and developed Azure Purview, Azure Data Lake Store (ADLS), Azure Data Factory (ADF), Azure SQL DB and Azure Synapse Analytics services. Reviewed Epic Clarity compass comparison document and updated Raw Vault (RV), Business Vault (BV) and Star schema data models. Designed and deployed Data Vault (DV) security model. Created and maintained reference data tables on target database. Good knowledge in HIPAA policies, data privacy and California retirement pension policies. Worked with health care, payers, insurance and pension data to design Enterprise Data Warehouse (EDW) projects. Prepared, created and executed Unit and System test cases for HUB, LINK and SAT (Satellite) tables. Environment: DbSchema 8.2, Erwin 9.6, ER/Studio, Microsoft Visual Studio (SSIS), Microsoft Azure DevOps, Power BI 2.81, Tableau 2018.1, Looker, IBM Mainframe, Adabas (Natural), Redgate tool suite, Health Level Seven (HL7), FHIR, CCWIS, Epic Chronicle, Epic Clarity, Epic Clarity Data Dictionary, Epic Caboodle, QNXT, HIPAA, Data vault Builder, Snowflake Cloud Data Warehouse, Lambda, Team Foundation Server (TFS), SQL, PL/SQL, Unix, Linux, UML, Visual Studio Code, GitHub, Agile, Prefect, DBT, Alladin, Microsoft Visio 2016, Microsoft Project 2016, Microsoft Office Suite 2016. The University of Texas System (UT Austin), Austin, TX Apr 2017 Sep 2018 Role: Data Warehouse Architect/Data Engineer The University of Texas at Austin is a public research university, it is a flagship institution of the University of Texas System (UT System). UT Austin is one of the most selective universities in the region and consistently ranked among the country s top public universities. It is a major academic research institution in Texas State. It also offers innovative programs for promoting academic excellence and leadership development. Responsibilities Coordinated with business architect team and IRRIS (Institutional Reporting, Research and Information Systems) team to get high level business requirements. Designed Star schema data marts and designed dimensional logical and physical models using Kimball and Data Vault methodology. Worked with IBM legacy systems in application and data modernization projects. Validated source data to identify data anomalies, data redundancy and understand data quality. Worked with Collibra Reference Data Accelerator to create reference data. Designed conceptual, logical and physical data models using Erwin v9.6 tool. Involved in Star and Snow flake schema for dimensional data models. Maintained different versions of data models using Erwin Mart feature. Designed data models for Master Data Management (MDM) project. Worked with big data technologies Hadoop, Spark implementation team. Designed Data Lake centralized repository system to store structured and unstructured data. Designed Data Lake system using Data Analytics as a Service (DAaaS) model. Designed dashboards, scorecards using Power BI tool. Created data base objects like Indexes, Views, Stored Procedures and Tablespaces. Reviewed business user reports and cubes using Cogno s Power Play studio tool. Environment: Erwin 9.6, ER/Studio, Oracle SQL developer data modeler 4.0, Oracle11g, Oracle Exadata X6, Azure SQL DB, Azure Synapse Analytics (SQL DW), Snowflake Cloud Data Warehouse, Hadoop, Spark, Legacy IBM Mainframe System, Adabas (Natural), FASET System, SIS System, IBM Data Stage, IBM InfoSphere Quality Stage, Oracle SQL, Collibra, Lambda, Power BI, Tableau and Cogno s Power Play Studio, Looker, JIRA Software, Agile, Unix, Linux, SQL, PL/SQL, Visual Studio Code, GitHub, UML and Microsoft Visio 2010, Microsoft Project 2010, Microsoft Office Suite. Pharmaceutical Product Development (PPD Inc.), Morrisville, NC May 2015 - Mar 2017 Role: Sr. Data Architect/Data Engineer Pharmaceutical Product Development (PPD) is a global Contract Research Organization (CRO) providing discovery, development and post-approval services for pharmaceutical, biotechnology, medical device, academic and government organizations. PPD is mainly known for conducting drug development for its clients, it also invests in developing new products through its compound partnering program. Responsibilities Accumulated data model business requirements, documented functional and technical specifications. Designed Conceptual Data Model (CDM), Logical Data Model (LDM) Entity Relationship Diagrams (ERD) using Erwin tool. Transformed logical data model into physical data model using Infosphere Data Architect (IDA) tool. Compared data model to database physical schema using compare feature in Infosphere Data Architect (IDA) tool. Generated physical data model from database by using reverse engineering feature in Infosphere Data Architect (IDA) tool. Documented design specifications of data marts, data warehouse logical and physical data models. Created and maintained Reference Data tables in clinical trials data environment. Enforced enterprise naming standards and data type standards in logical and physical data models using Infosphere Data Architect (IDA) tool. Hands on experience in maintaining and working on different versions of data models in a team environment. Designed Slowly Changing Dimension (SCD) tables. Created Source to Target Mapping (STTM) document for ETL development. Deployed Physical data models in target database and also deployed in virtualization environment using Db Visualizer Pro tool. Designed and created reports using Power BI tool. Designed and updated metadata for Data Lake model. Executed data definition and data manipulation operations for data analysis. Created query pairs in Query surge tool to test data in virtualization layer. Used Informatica Data Quality (IDQ 9.5.x) tool for data verification and data cleansing. Developed mappings using Informatica Data Quality (IDQ 9.5.x) transformations. Worked with IBM legacy systems in data platform modernization project. Executed Inserting, Updating and Deleting (I, U, D) test case against target database. Exported and prepared detailed unit and system test execution, bugs and defect reports using HPQC-ALM tool. Environment: Erwin 9.6, Infosphere Data Architect (IDA), Oracle SQL developer data modeler 4.0, HPQC 12, Query Surge 4.0, Oracle11g, Oracle Exadata X6, Teradata12, Hadoop, Spark, IBM IMS database, Postgre SQL, MS Azure SQL server, SAP HANA, Informatica Powercenter 9.5, Oracle SQL developer 4.1, Db Visualizer Pro 9.2, Power BI, TIBCO Spotfire, Collibra, CTMS system, Spark SQL, Oracle Clinical system, Health Level Seven (HL7), FHIR, SQL, PL/SQL, Python, R Studio, Unix, Shell script, Cisco Tidal scheduler, Microsoft office suite 2013. North Carolina State Department of Transportation (NC DOT) Raleigh, NC Nov 2014 May 2015 Role: Data Architect/Data Engineer The North Carolina Department of Transportation (NCDOT) is responsible for issuing driver licenses, building, operating, repairing highways and maintaining different modes of transportations across North Carolina State. Responsibilities: Interacted with the project architect team on regular basis to gather requirements and discuss project milestones. Created Entity Relationship Diagrams (ERD), Functional Diagrams and Data Flow Diagrams (DFD s). Created Logical and Physical data models using Erwin and Power designer tools. Document Mater Data Management (MDM) Master Data Services (MDS) model standards and naming conventions. Designing Enterprise Information Management (EIM) Logical data model using Erwin tool and deploying Physical data model on target database. Worked in customer and product Master Data Management (MDM) projects. Deployed Master Data Services (MDS) model on target database. Creating XML, XSD, WSDL and NIEM schemas for Service Oriented Architecture (SOA) services. Heavily worked on data validation and Data quality methods, performed data profiling using SQL and other methods. Worked with Data Quality Services (DQS) tool to create data quality rules. Performed data stewardship roles like Implement data standards, create metadata and manage databases. Maintained security and data integrity of the database. Executed complex queries on source and target data base for data analysis and data validation. Involved in the maintenance of the database. Document the conversion processes, ensuring data accuracy and Integrity. Heavily used data conversion process techniques and methods to move data from legacy systems to SQL server database environment. Worked with the business in helping define & develop business rules, value maps, source to target data mapping documents and assisting ETL development team in development activities. Environment: Erwin 9.5, ER/Studio, Oracle SQL developer data modeler, SQL server 2012, Teradata, Postgresql, Oracle10g, SAP HANA, MS Azure SQL server, SQL BI, Data Quality Services (DQS), IBM Data Stage, SQL server management studio 2012, Spark SQL, R Studio, MS Visio, SQL, PL/SQL, Python, XML, XSD, WSDL and NIEM schema, Agile, Unix, Microsoft Excel, Access 2010. John Deere Moline, IL Jun 2014 Nov 2014 Role: Sr. Data Modeler/Sr. Data Analyst John Deere & Company is an American corporation, it manufactures agricultural, construction and forestry machines, diesel engines, transmissions used in heavy equipment s and lawn care equipment s. John Deere also provides financial services and other business activities for customers. Responsibilities: Interacted with the business users on regular basis to consolidate and analyze project requirements. Created conceptual, logical and physical data models using Infosphere Data Architect (IDA) tool. Used Normalization methods up to 3NF and De-Normalization techniques for effective performance in OLTP systems. Enforced Referential Integrity (R.I) for consistent relationship between parent and child tables. Generated Data Definition Language (DDL) script from physical data model using Infosphere Data Architect (IDA) tool. Extensively used Infosphere Data Architect (IDA) tool to create web reports from models. Reverse Engineered (R.E) target databases, identified new data elements in the source systems then added new data elements to the existing data models Compared data with original source documents and validated for Data Accuracy. Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various targets. Worked with Data Stewardship team to maintain data standards, performing data profiling operations against databases. Developed Data Migration and Data Cleansing rules for the integration architecture (OLAP, ODS, DW). Experienced in development of ETL mapping and scripts. Heavily used Pentaho Data Integrator (PDI) and Informatica Powercenter for migrating data from legacy database to new database. Environment: Infosphere Data Architect (IDA), Power designer 16.5, IBM DB2, Teradata, Oracle10g, PostgreSQL, SQL server 2012, MS Azure SQL server, SAP HANA, Informatica Powercenter 8.6, Pentaho Data Integrator (PDI), IBM Data Stage, OBIEE, Visual studio, Crystal reports, SQL server management studio 2012, Informatica Data Quality (IDQ), Trillium, Spark SQL, R Studio, SQL, PL/SQL, Unix, Linux, Toad for DB2, Scrum, Microsoft Excel, Access 2010. JP Morgan Chase Columbus, OH May 2011 - May 2014 Role: Data Modeler/Data Analyst JP Morgan Chase is an American multinational banking and financial services holding company. It is the largest bank in United States. It is a major provider of financial services and it also providing services in investment management, wealth management, asset management and treasury and securities services. Responsibilities: Demonstrated strong analytical skills in identifying and resolving data exchange issues. Used E.F Codd s Normalization methods1NF, 2NF, 3NF and De-Normalization techniques for effective performance in OLTP and OLAP systems. Designed data models in Dimensional Modeling (D.M) environment. Have deep understanding of Know your Customer (KYC) procedures and standards. Executed user acceptance testing for Know your Customer (KYC) applications and KYC project s. Worked with Anti-Money Laundering (AML) partners and AML advisory team. Designed CDM, LDM, PDM data models for AML applications. Reviewed KYC documentation, worked as liaison between business and compliance AML teams. Created relational data models and populated reference data. Developing normalized Logical and Physical database models to design OLTP system for enterprise applications. Performing Forward Engineering (FE) operations to create a Physical data model with DDL that best suits requirements from the Logical data model. Developed data mapping, data governance and transformation and cleansing rules for the Master Data Management (MDM) Process. Executed enterprise data governance strategies in line with the organization s business strategy and objectives. Extensively used data quality tools to maintain consistent data. Convert data from multiple sources and run validation test on converted data. Thorough understanding and experience with the entire data migration process from analysis of existing data, cleansing, validation, translation tables, conversions and subsequent upload into new platform. Environment: CA Erwin 9.5, Power Designer 16.5, Oracle10g, SQL server 2012, PostgreSQL, IBM IMS database, IBM DB2, Teradata, Informatica Powercenter 8.6, OBIEE, Visual studio, SQL Server Management Studio (SSMS) 2012, Trillium, Informatica Data Quality (IDQ), IBM discovery, R Studio, Toad for DB2, SQL, PL/SQL, Unix, Agile, Microsoft Office suite. N.C.E.T, India June 2007 - Aug 2009 Role: Database Analyst Responsibilities: Generated Data Dictionary (D.D) using Erwin tool. Developed and executed SQL scripts to validate data in target databases. Performed data quality comparison between development and virtualization environment using Query surge tool. Conducted meetings with DRB team to review metadata documents. Executing Unit and System testing test cases for Dimensional and Fact tables using HPQC- ALM tool. Environment: CA Erwin tool, SSMS, SQL, HPQC- ALM tool, Microsoft Office, Windows. Keywords: quality analyst materials management business intelligence database active directory rlang information technology microsoft mississippi procedural language California Delaware Illinois North Carolina Ohio Texas Utah