Jayeshkumar Patel Email & Phone Number

San Diego, Ca, Us

At LPL, this involves defining data principles patterns best practices, structures, standards, quality, integration methods, governance, security, and data strategies that enable data-driven decision making and innovation, using HVR Replication, Kafka, Micro-Services, API, AWS, Oracle, MS SQL Server & Informatica cloud. • Assumed role of Solution architect for data centric project’s including end to end architectural design, Multi-Year Blueprints, CAD - Candidate Architecture design, SAS – Software Architecture Specification & PSS – Platform Solution Specification preparation & collaborated with Tech Lead on SyDD – System design document & maximize data potential. • Identified & defined data design patterns & collaborated with delivery teams to build reusable frameworks. • Responsible for design implementation & maintenance of data architecture with stakeholder & domain teams. • Collaborated with data governance personal to help standardize business vocabulary, align data across domains, design integrated data solutions, and follow enterprise data strategy. • Defined & managed flow of data & dissemination of information within LPL’s technology infrastructure. • Reviewed & approved / rejected all required artifacts for Data Domain, including SAS, PSS, and SDLC review. • Conducted continuous audit of data management System Performance, Scalability & HA – High Availability. • Defined entity based ownership with architectures to show the transformation from Current State to Target State with consideration of key timelines & deliverables. • Assessed data technology needs, analysed existing data structures & design integrated, Secure data frameworks aligned with LPL’s data strategy, identified internal & external data sources & develop data management plans.

Charlotte, Nc, Us

Master Data Hub, Enterprise Data Lake developed using Hive, Oracle, DB2, MS SQL Server, Informatica, Data Virtualization Presto / Trino, Azure Data Factory, Azure Databricks & AWS environment. • Leading architecture & design of cloud based data architecture using Azure Synapse Analytics solutions. • Design & developed Data Lakehouse, database, provide specifications for ETL/ELT mapping & procedures. • Data Lakehouse Platform & Architectures – Apache Hudi & Iceberg, Delta Lake. • Experience with Active-Active, Active-Passive & real time processing data architectures. • Leading participation in POC’s of AWS & Snowflake technologies & practices.

Enterprise Data Lake developed using AWS, Databricks, PySpark, Snowflake, Sqoop, CDP, Hive, NIFI. Design Enterprise Data Platform and lead its implementation to AWS cloud. • Defined & managed enterprise data architecture principles & socialize those principles to Domain teams. • Engaged with domain owners & data governance to define entity ownership clearly & layout the incremental milestone & deliverables. • Defined & enforce processes involved in Data Quality accessibility, Data Accuracy, Data operations, Observability, Data Security, Data Governess & Compliance, Data Testing & Maintenance. • Responsible for data modelling, cleansing, integration, & delivering to business users. • Researched & involved in POC’s of Snowflake cloud Data Warehouse on AWS. • Change Data Capture using AWS Database Migration Service & AWS Schema Conversion Tool. • Design & developed dimensional & relational databases, for pet health care system. • Performed data analysis, source to target data mapping, functional & technical requirements documents. • Provided root cause analysis for problems & performance tuning for long running SQL queries. • Researched & evaluated emerging technologies & made recommendations & solutions to management. • Responsible for Architecture of Data Warehouse project & BI applications on AWS cloud environment. • Designed OLAP out of Cubes, Multi-dimensional & OLAP out of Table, Tabular BI Semantic Model. • Replicated data between homogenous DB’s & Heterogeneous DB’s using AWS Database Migration Service.

Enterprise Data Lake & Business Intelligence Applications developed using, AWS RDS, Dynamo DB, Redshift, JAVA, MariaDB, Cloudera Hadoop & AWS Cloud hosting services.

Stamford, Connecticut, Us

Enterprise Data Warehouse, BI & Advanced Analytics Applications are developed using, test-driven development, Teradata & Oracle Database, MySQL, PL/SQL, ETL–Informatica, JAVA, AWS, Snowflake, BTEQ & TTU, Salesforce, Python, UNIX Shell Scripts–ksh, SVN, Agile & Waterfall Methodology.

New York, Ny, Us

JPMC is a leading financial services firm, a leader in Payment Processing. Provides access to wide variety of Payment Methods, such as Apple Mobile Wallet, Mobile Checkout, credit cards, debit cards, & gift cards. Provides payment authorization, settlement, & various reports to merchant for their transactions.

Jacksonville, Fl, Us

FIS is offering many services to merchant, like Credit Card solutions, Bill payment, Pay by phone, Electronic check conversion, Checks authorisation & collection, that utilising Automated Clearing House (ACH) payment network. This application is developed using, Oracle, PL/SQL, J2EE, XML, Shell Scripts – ksh & SQLJ, MKS.

Tampa, Florida, Us

Wellcare provides Healthcare Insurance to the Medicare & Medicaid customers in the various states. In-house applications were developed using Oracle 9i, PL/SQL, JAVA/J2EE, XML, & UNIX Shell Scripts.

Churchill Insurance provides Car and Home Insurance to the customers. Applications were developed using Oracle, PL/SQL, JAVA, Pro *C, C, HTML, UNIX - Shell Scripts & Oracle Developer 2000.

Master Of Computer Applications - Mca, Computer Science

Master Of Science - Ms