KHURRAM KHAN Data Engineer 516-***-**** ad304n@r.postjobfree.com

Summary: I have been in the technology field for more than 17 years and began my career in the field of Data Warehousing. Since then I have worked as a Data Warehouse Architect, Applications Administrator, Systems Integrator, Data Engineer, BI Architect, Enterprise Architect and Solutions Architect having worked in various different sectors such as Defense, Healthcare, Pharmaceuticals, Hospital, Insurance, Entertainment, Retail and eCommerce.

Key Highlights:

Expert level skills in developing architectures for multiple domains, and applications -- infrastructure, Security, and Governance architectures (e.g. MITA).

Experienced in EA modeling like Ardoq, LinIX, Orbus, and collaboration tools like MS 365, SharePoint, Confluence, Jira, etc.

Able to present and communicate complex issues with preciseness, and confidence.

Passion for learning new technologies and a high technical aptitude.

Demonstrable experience in leading technology strategy and solutioning for large entities.

Experienced in Networks, and Intrusion detection tools (Snort).

Diversified experience in implementation of various systems in various sectors such as Defense, Healthcare, Pharmaceuticals, Hospital, Insurance, Entertainment, Retail and Supply Chain Management sectors.

An enthusiastic, project-oriented, team player with leadership skills and with an ability to develop creative solutions for challenging client needs.

EDUCATION/TRAINING/CERTIFICATION

Education:

Masters, Information Systems Engineering, Western International University, AZ, 2015

BS, Bachelor of Science, Purchase College, NY, 2003

TECHNICAL ENVIRONMENT

Developer Tools: Azure (Databricks, Data factory, Data Lake, Logic Apps, Key Vault), Power Suite (Power Apps, Power BI, Power Automate), Business Objects, Report Conversion Tool, Translation Manager, Import Wizard, Crystal Reports, Xcelsius, SAP Cloud, MS BI (SSIS, SSRS, Visual Studio, SSMS), ServiceNow, ABBYY FineReader, dbt, Alteryx.

Internet Technologies: Azure Portal, AWS Console, Confluent Cloud for Kafka, Web Intelligence, MS SharePoint, Salesforce, Alteryx Gallery, Power BI Services

Database: MS SQL Server, Snowflake, Oracle, Teradata, DB2, SAP HANA, Redshift

NoSQL Database: Cassandra, MongoDB, Redis, Couchbase, HBase

Languages: SQL, HTML, JavaScript, HANA XSJS, Python, C#, PowerShell

CI/CD Tools: Git, Bitbucket, GitHub

Container Technologies: Docker, Ansible, Terraform

Operating Systems: Windows, Linux/Unix, MS DOS

MAJOR ASSIGNMENTS

Client: Franklin Templeton, New York, NY Sep 2021 - Present

Role: Data Consultant

Project: Worked for different sales divisions of Franklin Templeton including 401K, Merger Acquisitions, etc. Working on moving Alteryx for on-prem to cloud deployment, set up high availability of Mongo DB. Making sure of administration and architecture for different BI tools.

Responsibilities:

Met weekly with management team to discuss the roadmap, current scenarios, and future planning for many different BI tools that exist at the client.

Assisted in determination of retirement and migration of existing and future state technologies and tools.

Evaluated on prem ETL tools such SSIS/Informatica and Alteryx migration to KNIME/Hevo/Matillion

Created many workflows and apps that integrate with existing technologies such as Power Apps and Power Automate integration with Power BI.

Created various Power Apps applications with complicated filter and drill logic as well as custom input logic using Custom Data Connections (SQL Server) and Data verse.

Installed and Configured and Optimized of MS Gateway for on-prem DB connectivity with Power suite (PBI, Power Apps, Power Automate).

Led the design, development, and implementation of business intelligence solutions, leveraging expertise in Microsoft Power BI, SQL Server, and SSIS, encompassing system analysis, data modeling, report design, testing, documentation, training, and ongoing support.

report and dashboard creation, configuration, testing, documentation, implementation, training, production support, and administrative oversight.

Guidance to Jr developers on accessing Azure Data Lake from Databricks, difference between Keys, SAS Token, Service Principal, and Cluster Scoped Authentication.

Designed and delivered clear and concise training materials, workshops, and labs aimed at helping non-technical users understand Power BI functionalities and capabilities.

Created an auditing solution using Power hidden audit logs, setting up ADF ETL pipelines to automate the loads and update Dashboards that captured granular level KPI on Power BI usage.

Created POC for on-Prem .NET apps to be deployed to Azure cloud natively with use of advanced networking techniques and configurations of Gateways.

Demonstrated exceptional command over business intelligence tools including Power BI & Tableau and data platforms including SAP BW on HANA, Hadoop, and SQL Server Master Data, leveraging this knowledge to strategically enhance data-driven decision-making and operational efficiency.

Used Snowpark, created POC for developers to be able to write transformations pipelines using python and run the code on Snowflake's virtual warehouses.

Worked with many different software vendor support such as Microsoft, Quest, Tableau, Alteryx etc. on many ongoing discussion and issues that would arise due to various business units moving from BO or Tableau on to Power BI, from tools as well as varying different database from SQL Server to PostgreSQL, Redshift, Snowflake to many others.

Environment: Azure, AWS, On-Prem, SQL Server, Mongo DB, Oracle

Client: Nexus Brands, Orange, CA May 2021 - Aug 2021

Role: Data Engineer

Responsibilities:

Integrated Power BI with other JavaScript frameworks and libraries to enhance data visualization capabilities and provide seamless user experiences.

Responsible for MDX Expressions, DAX Expressions, Power BI Power Pivot, Power integrated with Share Point and in creating dashboards in Power BI and Tableau visualization tools.

Analyzed the ETL solutions (FiveTran vs Hevo vs ADF), providing Pros and Cons to all tools evaluated, a consolidated roadmap for company development and process simplification.

Set Best Practice for utilization of company reporting Tools; Qlik, Power BI

Guided company developers in Issues that have created roadblocks for major day to operations in various Azure areas, such as custom ADF pipeline. development for REST APIs, Azure functions, Azure KeyStore, and other Azure capabilities.

Exhibited skillful creation and robust support of Python code, enriching data processes, analysis, and automation within the BI framework.

Created visually appealing and insightful reports and dashboards using Microsoft Power BI, translating complex data into actionable insights.

Provided POC on Snowflake vs Azure for Nexus Data Warehouse, providing the Pros and Cons.

Created ETL processes via SSIS to integrate data into Vendor Portal applications from client platforms with stored procedures, functions, and triggers, and implemented web services and API's.

Client: City of Hope, Duarte, CA Jul 2017 - May 2021

Role: Sr Solution Architect

Responsibilities:

Responsible for met with key customers (Finance, Billing, Research, Foundations etc) and stake holders to understand their Analytics needs as well as developed various plans and hands-on development to create the desired KPIs over various reporting tools, infrastructure, and database platforms.

Worked with team of developers to create a Ultra-fast Document retrieval application built over Kafka/Faust/Python and utilized Ansible playbook for deployment and Docker as the container technology for deployment.

Created POC over DBT for fast data transformation, and organizations of the various Data Marts.

Created of custom web app (C# .NET Core) for finance department to keep track of their Cost Center and tasks.

Led the end-to-end design and execution of a strategic Power BI solution, seamlessly integrating data from disparate sources including flat files and SharePoint.

Created POC on utilization of Azure Data factory and how Azure Databricks fits into the ecosystem.

Developed and guided team on how to ingest and transform data using PySpark and Azure Databricks.

Created POC on how to connect to Azure Databricks from Power BI to create reports.

Developed complex data models and structures in SQL Server, ensuring data integrity, performance, and scalability.

Set up a gateway, configure clustering, integrate SQL Server, Redshift, MongoDB, and Oracle data sources seamlessly, and enhance the BI system overall.

Improved the BI landscape by using AI-powered Power BI to resolve issues, harmonize data from several sources SQL Server, and Redshift, optimize the Gateway, implement clustering, and advance the overall system.

Wrote multiple C# Program including one which performed multiple file conversions, from SQL Server unstructured RTF data to convert into different file formats (word, and pdf) and then dynamically distribute out to desired directories UTF format.

Investigated of Legacy Database (Sunquest Cache) over UNIX AIX kernel and devise a project plan for the conversion of the legacy database and reports.

Developed and implemented Python scripts and modules within JavaScript applications to enhance functionality and streamline processes.

Automated multiple process and utilities to improve data deliver, among the notable, Wrote PowerShell microservice module service to automate OnBase document conversion on-demand and in Real-Time.

Developed POC to compare ABBY OCR solution vs Google Vision vs Azure Computer Vision.

Clustered ABBYY FineReader Server 14 to automate process OCR of clinical documents.

Environment: Azure Cloud, SSIS, Alteryx for ETL, EMR Data Lake, C# .NET Core, SSRS, SQL Server, Redshift, Power BI, Kafka, Python, Faust, Ansible, Docker

Client: Arc Light, Hollywood, CA Mar 2017 - Jul 2017

Role: Cloud Solutions Architect

Client: CenturyLink Cognilytics, LA May 2016 - Mar 2017

Role: Sr Lead Architect

Client: Raytheon, Tucson, AZ Jun 2010 - May 2016

Role: BI Architect/ DW Developer

Client: Raytheon, Tucson, AZ Jul 2009 - Jun 2010

Role: BI Developer

Client: 7-Eleven, Lynbrook, NY Aug 2006 - Jun 2009

Role: Report Developer

Contact this candidate