Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Suhas Venkatesh

Arlington,VA

Summary

Cloud Data Architect with 16 years of expertise in IT, healthcare, financial services, telecom, manufacturing, and pharmaceutical sectors. Skilled in gathering, storing, and evaluating semi-structured and structured data from cloud and on-premises sources. Experienced in authoring best practices standards and guidelines for data analytics design and development. Proficient in Azure platforms and a range of data tools and frameworks. Assisted multiple enterprises in their digital transformation journey. Strong leadership and cross-functional team management skills. Completed many data strategy implementations with high-performance throughput, data availability, time, cost, and scalability.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Data Solutions Architect

Adventist Health
07.2023 - Current
  • Spearheaded BI migration, resulting in 30% reduction in data processing time for healthcare client, and successfully migrated systems like Cerner and PIC into Azure
  • Redesigned AIDQ Framework with SQL and Pyspark customizations, leading to 20% increase in data accuracy and efficiency based on client requirements
  • Enhanced data governance, standards, and methodology, resulting in 25% improvement in benchmarking performance evaluation, testing, and data security
  • Authored Metadata framework for report generation for external vendors, leveraging Silver Lake DB, resulting in 40% decrease in report generation time.

Data Solutions Architect

Winwire Technologies
12.2020 - 06.2023
  • Initiated and modernized cloud-agnostic metadata framework on Azure Data Factory and Databricks using Pyspark and SQL, resulting in 25% reduction in data processing costs
  • Designed conceptual and logical data models customized to client specifications, optimizing for functionality and cost-effectiveness, leading to 30% increase in data efficiency
  • Implemented customized solutions using Azure Data Factory and Databricks Framework, integrating SQL and Pyspark code to meet diverse client needs, resulting in 20% improvement in system performance
  • Led creation of robust Data Governance Framework, ensuring data precision and consistency, resulting in 35% decrease in data errors
  • Facilitated collaboration with cross-functional teams to align seamlessly with business objectives, resulting in 15% increase in project efficiency.

Data Architect

Raymond James
03.2016 - 12.2019
  • Orchestrated cross-functional team, fostering interdepartmental collaboration and unified efforts in loan servicing and CECL Analytics, resulting in 20% reduction in processing time
  • Strategized and executed successful on-prem to cloud migration, leading to notable 40% increase in operational efficiency and 30% decrease in infrastructure costs
  • Innovated cutting-edge ETL framework, implementing performance tuning techniques to boost data integration processes, resulting in 50% increase in overall processing efficiency and 25% decrease in data errors
  • Devised Azure Databricks Notebooks for efficient JSON file writing for ACS Canonical Model, enhancing data accessibility with indexing, faceting, filtering, sorting, and search features, leading to 30% improvement in data retrieval speed
  • Formulated Azure Data Factory Master/Child pipelines to orchestrate data transformation activities across various domains, culminating in seamless loading into Azure SQL Database, resulting in 25% reduction in data processing time.

Senior ETL Developer

Verizon
11.2015 - 03.2016
  • Led design of File Loading Framework for multiple source files, resulting in 50% increase in performance
  • Designed new ODI interfaces in NBA Cort project, incorporating incremental loading logic and performance tuning strategies
  • Improved load performance by 30% through application of proper Hints, Indexes, and Analysis of master tables, utilizing explain plans to validate cost
  • Improved ODI Package, interfaces, procedures, and variables for Policy Monthly Aggregated Snapshots
  • Collaborated with Clients and End-Users to define solution approaches, resulting in streamlined requirements and improved project efficiency
  • Delivered comprehensive Knowledge Transfer to support team, accompanied by Documentation for enhanced code
  • Provided post-production support for deployed code to ensure smooth operation and timely issue resolution.

Senior ETL Developer

Google
01.2015 - 11.2015
  • Authored ODI ETL for OBIA modules, handling AP, AR, and GL fact data, as well as dimension data loads for SDE and SIL mapping
  • Designed custom ODI procedures to build partitions for incoming data, reducing load times by 60%
  • Optimized load times by 20% through development of customized DRM hierarchical flattening loads, employing SCD2 techniques
  • Managed data loading from diverse sources including Hyperion, DRM, and OBIA data sources.
  • Optimized ETL performance by identifying bottlenecks and streamlining workflows.

Senior ETL Developer

Lead CIGA
11.2013 - 12.2014
  • Analyzed Claim Center source system to comprehend data structure and business rules, resulting in enhanced data integration checks
  • Revamped normalized logical and physical models, incorporating transnational facts, aggregated fact tables, and dimensions
  • Produced ODI Packages and interfaces to efficiently load dimensions and facts from diverse source tables
  • Defined new ODI Package, interfaces, procedures, and variables for Policy Monthly Aggregated Snapshots, improving data processing efficiency.

Application Developer

Oracle
07.2012 - 11.2013
  • Engineered new ODI Package and multiple Interfaces, executing ETL and data Validation for Historical load of Policy and Claims Data
  • Optimized Dashboard/Reports performance through database enhancements, including materialized views, partitions, and index rebuilding, resulting in 30% increase in reporting speed
  • Revamped Data Model for OII 8.0 release based on Business Requirements, enhancing data structure and functionality
  • Enhanced Dashboard/Reports performance and database efficiency by implementing materialized views, partitions, and rebuilding indexes, resulting in 40% decrease in query response time.

Oracle Application Consultant

IBM India
07.2011 - 05.2012
  • Developed new Packages and front-end using PL/SQL, MOD PL/SQL, and Perl programming, automating file loading for transactions into e-hub system
  • Revamped Packages for updating User Validation tables, implementing data validation processes with distinct criteria for various update processes
  • Led FBW conversion project, transitioning new GRA to old GRA in e-Hub, successfully migrating over 100k transactions
  • Collaborated with Business team to gather requirements, providing High-level estimations and converting precise logic into Functional Documentation and Technical design documentation.

Freelance Consultant

STG International
07.2010 - 06.2011
  • Provided classroom training for SQL and PL/SQL for experienced professionals in Oracle 10g/Oracle 11g environment
  • Developed projects in PL/SQL and Java on financial loans and financial accounting systems
  • Provided classroom training for Oracle DBA and OCA and OCP 11g certifications; also included new features in Oracle 11g.

Senior PL/SQL Developer

Wells Fargo, Inc.
05.2009 - 01.2010
  • Implemented new CA Tools interface, interacting with Materialized views via Data pump, facilitating efficient processing of complex materialized views for CA Tools based on various types of wholesale loans specified by business users
  • Created new PL/SQL Packages and Procedures for AU-SU Changes in LNU reports, optimizing performance within architecture framework
  • Developed Stored Procedures, Packages, and Functions for CMS interface using PL/SQL within architectural framework, ensuring streamlined data management and retrieval.

Oracle Developer

US Script, Inc.
04.2007 - 04.2009
  • Coded stored procedures, functions, triggers, and other scripts to determine user Eligibility functionality using PL/SQL
  • Developed custom Loading mechanism for multiple TPAs, enabling loading of Eligibility files in predefined format
  • Contributed to data sourcing and extraction investigation process, collaborating with teams to develop PL/SQL code for data extraction, cleaning, and sorting for flat file generation
  • Enhanced Query performance by utilizing EXPLAIN PLAN, TKPROF, and SQL Trace tuning tools, and implementing table Partitioning techniques, resulting in 30% improvement in query execution time.

Education

Master of Science Industrial Technology -

California State University, Fresno
Fresno, CA

Bachelor of Engineering Electrical and Electronics -

Dayananda College of Engineering, India
Bengaluru, Karnataka

Skills

  • ETL Tools: Oracle ODI, Informatica Power Center 62, Matillion
  • Programming Languages: Python, Pyspark, SQL, PL/SQL, T-SQL, UNIX Shell Script
  • Operating Systems: Linux, Windows, UNIX
  • Cloud Platforms: MS Azure Data Lake, Azure Data Factory, Data Bricks, Azure Synapse Analytics, AWS Glue, AWS Redshift, Logic Apps
  • Big Data: Apache Spark, HDFS, Hive QL, MapReduce, HBase, ELK Stack
  • Data modeling Tool: Snowflake Schema Modeling, ERWIN 60, HANA Modeler 10 SPS 0
  • Database(s): ORACLE 9i/10g/11i/12c, MS SQL Server 2012/2019, Teradata 13/14
  • Cloud Databases: Azure Synapse, AWS Redshift, Snowflake

Websites

Certification

  • Azure DE DP-203
  • Databricks DE

Timeline

Data Solutions Architect

Adventist Health
07.2023 - Current

Data Solutions Architect

Winwire Technologies
12.2020 - 06.2023

Data Architect

Raymond James
03.2016 - 12.2019

Senior ETL Developer

Verizon
11.2015 - 03.2016

Senior ETL Developer

Google
01.2015 - 11.2015

Senior ETL Developer

Lead CIGA
11.2013 - 12.2014

Application Developer

Oracle
07.2012 - 11.2013

Oracle Application Consultant

IBM India
07.2011 - 05.2012

Freelance Consultant

STG International
07.2010 - 06.2011

Senior PL/SQL Developer

Wells Fargo, Inc.
05.2009 - 01.2010

Oracle Developer

US Script, Inc.
04.2007 - 04.2009

Master of Science Industrial Technology -

California State University, Fresno

Bachelor of Engineering Electrical and Electronics -

Dayananda College of Engineering, India

Similar Profiles

CREATE PROFILE
Suhas Venkatesh