Master Data Architect
Current- Expert in Data Analysis : Structured Query Language (SQL), MS Office/Excel, Critical thinking, VB.Net Programming, Data visualization, Presentation skills- Change Management and Incident Management- SAP BO Data Services Tool (14.2) for ETL / Migration, Batch Jobs (Scheduled/Real-Time), DMAP Design : Source to Landing, Landing to Staging, Staging to Target Systems Transforms Used (Data Integrator : Pivot, Reverse Pivot, Eff Date, Key Gen, Date Generation Data Quality : Associate, Data Cleanse, Match Platform : Case, Merge, Map_Oper, Query, Row Gen, SQL, Validation)- Product Master Data vs ERP Custom Adhoc Exceptional Reporting- MS Visual Studio.Net for ongoing daily support & maintenance (jobs/watchdog)- Expert Application SQL DBA with insight on transactional & complex tables, SQL writing, views, stored procedures, triggers, alerts, maintenance. logical DB Design, Reporting and the ongoing support to enterprise business applications, Monitor DB Performance & Health by DB tuning used for Corporate Applications.- DSD Data Sync Direct : GS1 UDI Product Publications (DSD -> FDA GUDID), Registrations GS1 UDI / 1WorldSync Data Pool Product Attribute Maintenance (Product Master Attribute Data Management with New GTIN Creation), DSD Finished Goods Sync to SAP/Ship Control Table/Label Data.- SAP Material Management Material Basic View, Additional data, UOMs, Addl EAN, Classification Data Custom transaction codes to view custom tables one or many (zse16n) All Queries in DMO/SCM/QM Space (sq01) iDoc Transactions (SO01) Custom Transaction for Ship Control Table (zipn_rpt) Display Warehouse Stocks of Material (Inventory Status -MB52)- SAP MDG : Product Data Management (Basic Read-Only MM View)- SAP HANA Modeling, Webi Reporting, Tableau 2018.2 Reporting (basic)
