Ash Khan Email & Phone Number

New York, Ny, Us

Us

● Designed Data models Conceptual, Logical, Physical) to align with Data Mesh architecture for distributed processing, management and governanmce.● Performed Data profiling of multiple system data for Trading, Fixed Income, Markets using SQL and Python scripting.● Developed end-to-end Data Flow (DFD) between Raw, Bronze, Silver and Gold layers of Medallion.● Administered and support ER/Studio repository, ERWin Model Mart and PowerDesigner Repository● Developed Data Flow, STTM document for Data integration process to populate snowflake DW● Modeled end-end-to design for Capital Market Income Forecasting (CMIF) reporting system.● Built Broker Dealer reporting system for Data Warehouse and analytics using Data Mesh design.Utilized Snowflake Data share to deploy Conformed dimension(s) across domains in the Data Warehouse● Designed Star and Snowflake schema pattern to deploy to target Data Warehouse on-premises and cloud (AWS, Azure, GCP)● Performed gap assessment of Data Modeling tools including ERWin, ER/Studio, PowerDesigner.● Generated Data Dictionary of SQL Server and Snowflake database across domain applications.

New York, Ny, Us

● Upgraded Logical/Physical model from Oracle Data Modeler to Erwin and ER/Studio● Converted data models from ERWin to ER/Studio to facilitate Oracle RDBMS application migration●Translated Business Requirements to Conceptual and Logical Data Models for MEDS (ODS repository)● Assessed Current MEDS (Canonical Data Model) and provided Future state with GAP analysis● Build Data flow mapping from source to target system (STTM) and generated DML as output for deploy● Performed Forward Engineering from Logical to Physical model using ERWIN 9.8, 7.2 and Snowflake● Reversed Engineered Source Database schema into Physical Data Model Using ERWIN Data Modeler● Developed Data Dictionary into Website, PDF format from Production Data Model● Generated DDL and DML scripts (SnowSQL, SQL, PL/SQL) from ERWIN Physical Model for implementation into Physical Database and deployed Database in AWS.● Published various Data Models in ER Diagram format and Solution Architecture in UML syntax.● Created On-Demand List Reports (HTML, PDF) to capture an inventory Model Entity-Attributes● Performed data analysis and profiling using Oracle SQL Developer and Data Modeler, SnowFlake Light● Evaluated various Data Modeling tools such as ERWIN, ERStudio, Oracle Data Modeler as part of POC to assist with Purchase.● Designed a Physical Data Model in ERWin to set off a skeleton for a custom database to support a Metadata driven ETL/Data Integration processes with in AWS infrastructure.● Applied data governance best practices end to end (e.g., code documentation, metric definitions, table metadata, data quality checks) by design a in-house Metadata Catalog model and application.● Generated Dimensional Data Model to implement in a Data Warehouse using Star and Snowflake schema.

New York, New York, Us

- Designed an end-to-end process from data fetching, staging, mastering, warehousing to deliver business Replaced an existing Talend MDM system with in-house Data Mart/Warehouse using Microsoft technologies.- Enhanced the Data Mangement system to serve multiple lines of businesses: Demand Generation, Conference, Finance and Accounting, Aging Collection, etc.- Streamlined the DataMart layer to present data to reporting layer based on TIBCO SportFire and Microsoft SSRS for presentation to user- Developed multiple data extracts to feed operational source system to complete data flow to support essential business processes.- Built Enterprise Data Management team consisted of developers versed in multiple tecnologies- Worked with Off-shore team on a 24 hour/daily basis to consistently support and enhance the EDM system.- Co-ordinate work items with Technology and business team to replace major project goals.

London, Uk, Gb

San Francisco, California, Us

Zurich, Ch

New York, Ny, Us

Design, Developer, implement Data Warehouse supporting Business Intelligence group.

- Design, analyze and develop data platform for mobile content deliver application- Design and develop reporting solution capturing User analytics, marketing and financial data analysis.- Support and enhance application data environment as per business requirement.

- Administer and maintain existing SQL Server Databases systems- Provide developmental support on SQL Server Database applicaiton- Design a new Database platform on SQL Server 2008 as part of technology migration effort.- Administer, maintain and provide support to MySQL Databases- Build a Database Services team as a part of Web Engineering team

Lyndhurst, Nj, Us

- Designed a 3-tier Award Redemption website for external customer base in VB.NET 2008, T-SQL and framework 2.5. - Designed an ETL process in SQL SERVER Integration Service 2008 and T-SQL to export data to Oracle 10g ODS from various sources such as FTP, FTPS, HTTP, HTTPS site.- Developed a framework in T-SQL 2008 and VB.NET 2008 to support existing/new ETL pipe from any sources. - Designed Data Model in SQL SERVER 2008 Database to leverage eligibility information in CRYSTAL REPORT 10.- Upgraded SQL Server 2005 Database to SQL Server 2008 using script and export/import.

- Coordinated an implementation of Data Model using T-SQL with development team of 4 and functional team of 2.- Designed a Data Architecture for End-to-End Procurement Application for New York City Contract Service agency to be developed in SQL SERVER 2005 and T-SQL database.- Developed a Data Mapping process from EDC front-end to CRD Data Warehouse for Clinical Management system using VB.NET 2005, SQL SERVER 2005 and T-SQL for Merck & Co.- Managed a team of 1 analyst and 3 developers and coordinated with client middle management team.- Designed ETL process in SQL SERVER IS 2008 to populate E2E Data Warehouse from financial data from FMS.- Designed ETL process in T-SQL 2005 and VB.NET 2005 to exchange legal information between E2E Data Warehouse in SQL SERVER (T-SQL) and LawManager.- Converted DTS to SQL SERVER IS to import vendor information from VendorSource into E2E Data Warehouse in SQL SERVER 2005 (T-SQL) to Bam CRYSTAL REPORTS.

Paris, Fr

- Collected Requirements from End Users to develop reports through technical team, QA reports and deliver it to end users.- Coordinated between multiple technical team to manage ETL, Data Warehouse, Reporting application and T-SQL code.- Managed a reporting team of four to deliver statistical reports various group using T-SQL and CRYSTAL REPROTS 10.- Automated a manual reporting process in CRYSTAL ENTERPRISE 10 and VB.NET 2005 utility to deliver accurate statistics to marketing and Advertising timely.- Worked with DBA to migrate a SQL SERVER 2K data warehouse to SQL SERVER 2005, CRYSTAL REPORTS 10 to MS REPORTING SERVICE 2005 using T-SQL and DTS to SSIS.- Managed a Data Warehouse and ETL in SQL SERVER SSIS 2005 and T-SQL to support a reporting Intranet and Marketing, Financial and Sales reports.- Developed Statistical Cube using SQL SERVER 2k ANLYSIS SERVICE and T-SQL for on-demand marketing report.

Herndon, Virginia, Us

Us

New York, New York, Us

New York, Ny, Us

Stamford, Ct, Us