Solution Architect Data

JATIN SHAH

Dallas Metroplex 469-***-**** ad5pwk@r.postjobfree.com LinkedIn GitHub

Enterprise/Solution Architect

Enterprise Architect who blends solution architect, data architect, and hands-on software engineering expertise with business and people acumen to turn ideas into profitable successful delivery. Delivers significant value to Enterprise. Experience

Consulted with 50+ fortune 1000 companies & traveled 10+ countries across the world for implementation.

Domain Expertise: Data Management – Delta Lake/Data Lake, Cloud & Digital Transformation, Integration, Analytics and Data Governance and Security.

Public Cloud: Microsoft Azure, Amazon Web Services (AWS), Google Cloud (GCP), Hybrid/Multi-Cloud

Enterprise architecture & concerns: Sizing, scalability, performance, availability, reliability, security, etc.

Big Database: Databricks/Spark, Snowflake, Kafka, Cassandra (NoSQL), Hadoop - HDFS, Hive, HBase, Impala, Kudu, Drill

Relational Databases/Datawarehouse: Azure SQL, Azure Synapse, Databricks SQL, Snow SQL, Oracle, SQL Server, DB2, MySQL, Vertica, Netezza

Programming: Java, Python, Scala, PHP, .NET, C#, Shell Scripting, NodeJS, J2EE

BI/Analytics: Microsoft Power BI, Tableau, Qlik, Spotfire, Crystal Reports

Web Technologies: REST, JSON, AJAX, HTML, JavaScript, SOA, SOAP

Technologies: Kafka, Data Integration, Data Warehousing, Dockers, Kubernetes, Mongo, Redis, WebSphere, Tomcat, JBoss, Application Integration, Spring/Hibernate/MVC, Queueing - JMS/MQ Series, Storage & Archival Strategy, JDBC/ODBC, EJB/CORBA/COM+, Active Directory, Kerberos & GPU, Mainframe, MLOps, LLM

Development Tools: IntelliJ, Eclipse, Visio, DB Visualizer, Visual Studio, Visual Code, Informatica, SSIS

DevOps: Kubernetes, Dockers, Vagrant, Git, Terraform, Ansible, Jenkins, Chef.

Methodologies: Microservices, Distributed Systems, Clustering, UML, Object-Oriented, Design Pattern, Containerization, Security

Business Module: SCM, CRM, ERP, Digital Marketing, HRMS, BPM, KM, CMS, DMS, Finance.

Verticals: Health Care, Insurance, Technology, Retail & Consumer, Transportation & Hospitality, Energy/Oil & Gas, Financial & Telecommunications.

SaaS Applications: Azure DevOps (ADO), Salesforce, Workday, SAP, ServiceNow, NetSuite, Peoplesoft, Office 365, Jira, Slack, Facebook, X (previously Twitter), etc. Awards and Recognition

MapR Star Award Cloudera Certified Awarded as the Best Solution Architect of the Year at Kana Software. PROFESSIONAL EXPERIENCE

Fusion Consulting (On-Site) July 2023– March 2024

Sr. Data & AI Leader

Client: J&J and Carilion Clinic

Technologies: Azure Databricks/Spark, Delta Lake, Azure Cloud, AWS Cloud, Azure Data Factory (ADF), Azure Storage

(ADLS), Power BI, Event Hub, Kafka, GitHub, Terraform – Infrastructure as Code, Amazon S3, Tableau. Fusion is a data & analytics consultancy firm primarily focused on data & analytics on cloud for healthcare. Key Responsibilities:

• Leading architecture design consulting for cloud migration of on-premises data platform to Databricks and Snowflake

• Involved in data governance of PI/PII/PCI attributes, data security, and compliance needs.

• Developing Accelerators to accelerate data migration and development lifecycle.

• Perform the right prioritization of delivery buckets to align with business insights value. Jatin Shah

• Leading a technical team of Data Engineer, BI Developer, Scrum Master, Cloud Architects, and DBAs

• Interact and manage client business and IT executive, leadership, technical, and stakeholders.

• Contribute to analytics proposals by designing technical solutions to solve complex business problems.

• Create technical papers, knowledge best practices, and case studies for the Analytics Center of Excellence.

• Developing and Designing Accelerators:

o Infrastructure as Code (IaC) on Azure/AWS Cloud

o Cloud Migration to Databricks

o Databricks end-to-end solutions including real-time data ingestion and using AI/ML o FHA Dashboard on Power BI and Tableau

AI/ML Use Cases - Drug Costs Analysis, Social determinants of health (SDOH) Vizient Inc. (Hybrid) Aug 2020 – May 2023

Lead Enterprise Data Architect

Technologies: Azure Cloud, AWS Cloud, Databricks – Data Lake & Data Science, MDM, Data Governance, Azure Purview, Azure Synapse, Snowflake, Azure Data Factory, Azure SQL, Azure Data Lake (ADSLv2), Vertica, Oracle Exadata, Redpoint, MSSQL Server, Qlik Replicate, QlikView, Python, Anaconda, Jupiter notebook, Pulumi, .NET Core, Salesforce, Workday, SAP, CI/CD - Azure DevOps, Power BI and Tableau, Alteryx & Paxata. Key Responsibilities:

• Designing, Recommending, documenting, and sharing the architectural vision across organizations. Including reference architecture, architecture guidelines, current state & future state architecture, and business & technical capabilities mapping.

• Promoting design and engineering practices ensures that common technology, design practices, and infrastructure are used and facilitates the reuse of code, components, and proven patterns; influences common modeling, design, and coding practices.

• Participate in decisions regarding data warehouse, data lake/delta lake, data mesh & data fabric solutions.

• Collaborate with various business and technical stakeholders to understand their requirements, priorities, and pain points. Recommend new solutions or transform existing products & architect solutions to work for their department. I recommend databases, data storage solutions, data integration platforms, and data science – AI/ML frameworks.

• Reviewing requirements with business analysts to ensure architecture is done according to standards / best practices.

• Involved in data governance of PI/PII/HIPPA attributes, data security, and compliance needs.

• I worked with a team of 18 solution architects (product level) and oversaw the development and implementation of a cloud-based application, data science - AI/ML models, analytics dashboard, and data analytics solution.

• I also participate in implementing & executing data management solutions like defining data domains, designing data models - star/snowflake schema, schema versioning using Redpoint, and data replication tools like Qlik Replicate, Data Quality using Alteryx /Paxata, etc.

• Implementing BI Platform for Azure Power BI and supporting existing BI platform Tableau and Qlik View Projects:

• Data Governance and Data Catalog using Microsoft Purview & various data sources – Worked on full implementation cycle for about 2+ years even before Purview was released by Microsoft.

• Designed Azure Purview REST API for importing and synchronizing data & metadata with Azure Purview.

• I also participated in evaluating Data Governance Collibra, Alation, Atlan and Databricks - Unity Catalog.

• Benchmarking Big Data platforms like Snowflake, Databricks and Azure Synapse for proper warehouse selection based on the use case.

• Involved in migration of Big Data Platform (BDP) - Cloudera (Hadoop) to Delta Lake on Azure Cloud using Databricks.

Jatin Shah

• Designing Modern Data Architect using Databricks, Starburst – Presto (Data Mesh) and Snowflake.

• Migrating Data Pipeline from SSIS to Azure Databricks & Databricks Notebooks.

• Involved in designing/implementing Master Data Management (MDM) using Tibco EBX – product master.

• Digital Transformation of ERP from Oracle Exadata to Azure Synapse using Azure technologies

• Digital Transformation of Internal Analytics (from VMWare to Azure) – Using Azure SQL, Azure Data Factory

• Digital Transformation of SG2 to AWS – S3, Gule, Redshift, Athena AI/ML Use Cases - Vizient risk models (length of stay, mortality & cost), Supply-demand forecasting, Sg2 Clinical demand forecasting, Viz Match – Product matching application, Product classification, Pharmacy categorization etc. ITMiracle (Remote) April 2020 – Aug 2020

Solution Architect

Client: Chase Bank

Migrating Chase Bank Credit Card data from Hadoop to AWS Ecosystem - Amazon EMR, AWS S3, AWS Lambda, AWS Glue, Amazon Redshift, Amazon RDS, Amazon Athena

DataStax (Hybrid) Oct 2018 – April 2020

Data Architect

Technologies: Cassandra, Spark, Kafka, DataStax NoSQL, Graph Database, Snowflake, AWS, Azure, GCP, Solr Clients: BNSF, Walmart, iHeartRadio, Pioneer Natural Resources, Neiman Marcus, Epsilon, Toyota, Dell, American Airlines, FedEx, TI

Participated in designing real-time IoT solutions using Cloud, Cassandra, Spark and Solr. Deliver large-scale, multi- data center enterprise solutions as a member of the pre-sales team for a big transportation customer.

• Enabled enterprises to modernize, transform, and achieve efficiencies. Structured and estimated projects with limited information and a short time frame to compete successfully with other providers.

• Brought an organized framework to proposal development to improve and accelerate the process. Contributed to 7-10 proposals/RFI annually for projects ranging from $200K to $2M per year subscription, focusing on feasibility, profitability, and customer success.

• Delivered big visions and elegant solutions from a complex environment of multiple stakeholders, teams, and brands. Made the right calls on reference architecture, emerging technologies, and deployment methods.

• Exceeded an annual quota of $1M per year subscription. MapR (Hybrid) Oct 2016 – Sept 2018

Sr. Sales Engineer/Solution Architect

Technologies: AWS/Azure Cloud, Hadoop, HDFS, Map Reduce, Security, Spark, Kafka, HBase, HDFS, Hive, Drill, Elastic Search, Data Management – MDM, Governance, Auditing, Lineage, etc. Clients: Anadarko, Acxiom, Ericson, Harland Clark, Walmart, American Express Enabled enterprises to modernize, and transform, by educating big data technology vision, hardware sizing of projects & cloud migration plan. Performed software development, contributed to proposals, and provided technical leadership to business partners.

• Provided technical expertise for building a Demo, POC, and Sample Starter project templates including documentation & conducting workshops.

• Closed one of the biggest deals in the history of the company & played a major part in winning customer confidence by guiding them in every phase of POC.

• Participated as Technical Sales leader to sell MapR big data solution called “Converged Data Platform” which includes Distributed Streaming, Tables, and File Systems on one platform. This includes conducting workshops, discovery meetings, proof of concept (POC) & big data architecture discussions. Jatin Shah

• Assist in migrating data using ETL tools like Python, and Java programming language and using Informatica, SSIS, etc.

Cloudera (Hybrid) Jan 2016 – Sept 2016

Sr. Sales Engineer/Solution Architect

Technologies: AWS/Azure/GCP Cloud, Hadoop, HDFS, Map Reduce, Security, Spark, Kafka, HBase, HDFS, Hive, Impala, Flume, Solr Search, Cloudera Search, Cloudera Navigator, Data Management – Auditing, Lineage Clients: CenturyLink, Sabre, Neiman Marcus. MoneyGram, Bodycote, GameStop, Pioneer natural resources Delivered evangelizing of the Cloudera brand in the Texas region by conducting various meetups, workshops & educational sessions. Provided architectural and development guidance, assessed technologies, and recommended migration plans.

• Selling Cloudera big data solutions that include data lake, IoT, and Data Science platform; big enterprises (10+ Billion)

SnapLogic March 2013 – Dec 2015

Sr. Sales Engineer/Solution Architect

Technologies: Software as a Service (SaaS) API integration: Workday, CRM - Salesforce/ERP – SAP/ NetSuite, Service Now, social media -FB, LinkedIn, Twitter, Accounting-Zora and many more. Database: SQL Server, Oracle, Couchbase/CouchDB. Data Integration: ETL, EAI, ESB., REST/SOAP, SSO, Active Directory APIs. Cloud: AWS, Azure. Big Data: Hadoop (Cloudera), Red Shift, Snowflake, Netezza, etc. Worked closely with various customers to understand requirements, design, and develop Integration solutions on Cloud & on-premises for SaaS applications & Databases. Provided architectural and development guidance, assessed technologies, and managed project timelines and deliverables.

• Taking Customer Speed to Market to deliver integration to various data sources in real-time & providing business value in real-time.

• Participated in various conferences & VC funding representing SnapLogic.

• Executed Proof of Concept (POC), Pilots, and after-sales hand interactions for customer's success using SnapLogic to Customer’s ensure ROI.

Composite Software Aug 2011 – March 2013

Sales Engineer/Solution Architect

Technologies: SQL-99, SQL Scripts, MDX, OLAP, Oracle, SQL Server, MySQL, DB2, Teradata, Vertica, Cloudera/Hadoop, CouchDB, AJAX/JSON, HTML, JavaScript, XML, XQuery, Java, .NET, REST/SOAP Web Services, Business Object, QlikView, Crystal Reports, Jasper Reports Cognos and MicroStrategy Led the development team to deliver technology projects for a telecommunications client. Provided architectural and development guidance, assessed technologies, and managed project timelines and deliverables.

• Enhanced client revenue generation by producing an improved e-commerce solution. Used SOA framework for architecture and design and led the team to develop a sales application and Order Entry Database to support online product sales.

• Architected and designed a new web-based processing model for Telemarketing Order Entry Services (TOES). Nice Systems April 2008 – July 2011

Solution Engineer/Solution Architect

Provide custom solutions to Clients & Presales Team. Integrating various Phone/Email/Chat/VoIP to Workforce Products from IEX Nice.

Measuring application performance by Profiling & Load Testing Real-time J2EE Applications using Your Kit & Simulators.

Jatin Shah

Kana Software, Inc. Nov 2000 – March 2008

Principal Solution Architect

Technologies: Java/J2EE, EJB, AJAX/REST, HTML, JavaScript, IBM WebSphere, Oracle, DB2 and SQL Server.

• Designed and implemented enhancements for 3-tier CRM, Contact Center, Marketing, and Analytics Application.

• Performed full software development lifecycle (SLDC) using various Java/J2EE technologies: Webservices

(axis2), SOA, JAXP, JAXB, XML, XSLT, JMS, AJAX, Struts, Spring, Hibernate, JDBC, JNDI. Innovative System/Duracell Aug 1998 – Nov 2000

Senior Developer/Oracle DBA

Designed and developed a product like Web-Based Claims Management, Web-Based Store, and DNS Provisioning System for Raytheon. Oracle DBA & Data Warehouse maintenance including ETL & Java Programming. EDUCATION

MS Computer Science, University of Bridgeport, CT (Finished 30 credits, did NOT graduate) 1997-1998. BS Electronics, Bharati Vidyapeeth’s College of Engineering (Pune University), India 1993-1996. Diploma in Electronics, Shri Datta Meghe Polytechnic, Nagpur 1990-1993.

Contact this candidate