Data Engineer

Ashok Veludandi

Cell: 248-***-**** Email: *********@*****.*** Status: US Citizen

Professional Summary:

●Collaborative as ETL/ELT,Data Engineer,Data modeler/Analyst @18 years of extensive experience design,development & supporting data solutions including data warehouses and data marts-across Healthcare, Banking, Financial Services, and Automotive Domain’s.Proven expertise in cloud data platforms such as AWS (Redshift,EMR, Glue, S3, DynamoDB, Athena, Airflow) and in Big Data frameworks (Informatica PowerCenter/BDM, DataStage,Talend,Alteryx, Spark, Hadoop,Hive and Sqoop).

●Skilled in data validation, process optimization,compliance,issue remediation and enabling advanced analytics. Proficient in Python, PySpark, and Scala for building scalable data pipelines and analytics solutions. Adept at integrating structured and unstructured data into modern architectures that support real time and batch analytics, as well as BI dashboards that drive business value. Strong understanding of data modeling, ETL/ELT processes, and pipeline orchestration.

●Recognized for technical leadership, production support, and mentoring onshore/offshore teams.

●Strong communicator who bridges IT and business stakeholders to deliver solutions that enhance performance, compliance, and data driven decision making.

Core Skills:

●Cloud Platforms: AWS (Redshift, EMR, Glue, S3, DynamoDB, Athena, Apache Airflow, DMS, AppFlow, Secret Manager,subnet, EC2, Jupyter Notebook,lambda,EMR,App Flow, Sagemaker,BigQuery and GCP (knowledge), Azure Data Factory & Synapse.

●ETL/ELT & Big Data: Informatica PowerCenter/BDM,, IBM DataStage, Talend, Alteryx,Spark, Hive, PySpark, NiFi data Flows and informatica IDMC (IDQ/MDM/Data Profiling),Oracle Golden Gate,Fivetran and Informatica Power Exchange.

●Databases: Oracle, SQL Server, Teradata, NoSQL(Dynamo db), HDFS, DB2, Netezza

●Data Modeling :Erwin/Power Designer :Logical/Physical models,Normalization,De-normalization,Star-schema,Snowflake & ETL Data Mapping and Data Dictionaries and Designed 3rd Normal Form Datawarehouses.

●BI & Visualization: Business Objects,Power BI, Tableau, Cognos (Certified)

●Programming: Python & Scala ; System Design : API, integration and scalability

●Workshops:Seminars: Snowflake,SnowSQL, Databricks, dbt (Data Build Tool),Azure Data Factory & Azure Synapse Analytics

●DevOps/Version Control:: CI/CD (Git & GitHub-cloud based Repository), Docker, Kubernetes, Terraform (IaC)

●Tools: Visual Studio &,Pycharm,(IDE),Jira(Tasks), Confluence(Runbooks,dataflow),Opensearch,Jams & Autosys (scheduling)

●Leveraged AI driven Tools (Copilot, Amazon Q,Claude,Windsurf,Perplexity,ChatGpt ) to enhance -Development,Code quality, Test cases and Automation.

Professional Experience :

Availity (https://www.availity.com) Data Engineer/Data Analyst / Business Analyst/ETL/ELT April 2021 - December 2025 Healthcare Domain

●Designed & Optimized ETL workflows in informatica,AWS (Airflow, Glue, Redshift, S3, DynamoDB, Athena, DMS & Sagemaker.

●Authored detailed HLD/LLD architecture, ETL mapping specifications, and DQ/Test templates, and implemented automated DLQ reporting, improving visibility and reducing recurring data defects

●Data Pipelines-Python/PySpark into Redshift-daily/history loads based on Medallion Architecture (Bronze, Silver, Gold layers)

●Built secure REST API endpoints service 10k+ requests (JSON) using PEM Keys,GET and POST in PostgreSQL (CRM).

●Built PySpark(Notebook) reconciliation frameworks invoked rule-based for claims,claimstatus, ERA, and HCSR datasets.

●Designed,Developed,DQ Validation & supported Informatica PowerCenter ETL workflows ensuring 99.9% uptime(on-prem).

●On call production support for AWS hosted Apache Airflow and Informatica PowerCenter applications (real time and batch), collaborating closely with offshore support teams to ensure seamless operations and timely issue resolution.

●Designed,Developed,integrated and supported Member’s (BCBSFL ) data into DataMart & MDM for single source of Truth. Consolidates, de-duplicates,reconciles and enriches data from multiple source systems to produce one master record as per HIPPA.

●Oracle xref tables using Databricks loaded into S3 buckets and into the Redshift cloud data warehouse.

●Managed data analysis and data lake patching processes for healthcare transaction domains (ERA 835, EB 270/271, Claims 837 P/I/D, Claim Status 276/277, HCSR-278 and HL7- Clinical) and member data originating from multiple providers.

●Leveraged the Availity Essentials portal to troubleshoot and resolve data issues while coordinating with both upstream and downstream stakeholders and supporting real time data for https://essentials.availity.com/

●Used Kibana and Grafana to monitor Airflow jobs status and OpenSearch for checking Transactions details Status. Leveraged AI driven tools such as Amazon Q, Copilot, and Claude to build PySpark based data pipelines and optimize SQL queries, improving overall code quality by 35%. Prioritized the Jira backlog and defined actionable plans to ensure timely sprint deliverables,developed reports,dashboard creation,visuals,slicers,drill-through,bookmarks and KPI design & DAX Functions. Tech Stack: AWS Cloud, Informatica PowerCenter, Oracle, SQL Server, Python, PySpark,Git, Github,Jupyter Notebook, Redshift,DynamoDB,Terraform,Databricks,Athena, EMR,EC2, Security Manager, Super Glue,Catalog,Crawler,Apache Airflow,Sagemaker,Power BI,JAMS, Kafka,MQ’s,Golden Gate.Informatica MDM,Jira,Confluence,Data lake,Data Marts and Data lakehouse,JSON, Parquet files, IDMC,dbt,Snowflake-models and Databricks (Delta tables/Autoloader) and Lakeflow Designer. M&T Bank Technical Engineer

October 2019 - April 2021 Credit Risk & Data Engineering

●Designed and developed Informatica BDM/PowerCenter ETL workflows.

●Migrated legacy SQL Server credit risk applications into Cloudera Big Data Platform.

●Conducted data gap analysis across marts and lakes for regulatory reporting.

●Created multi-layered data models for scalable analytics.

●Optimized ETL jobs, reducing batch times by 25%.

●Provided production support and proactive monitoring of Level 1 & 2 batch jobs. Tech Stack: Informatica BDM/PowerCenter, Hadoop (Cloudera), Oracle, Teradata, SQL Server, Hive, BigSQL, Agile/Jira General Motors IT Data Engineer / Technical Lead May 2013 - September 2019 Detroit, MI

Global Warranty, Marketing, and Analytics Programs

●Led migration from SeeBeyond to IBM DataStage 11.3, integrating SAP-IDOC & Oracle data. & GWM.

●Migrated analytics into Hadoop (HDFS, HiveQL), integrating structured/unstructured data.

●Delivered ad-hoc analytics projects (inventory forecasting, dealer optimization, recall effectiveness, risk management) and google Data-cookies and social media files for Market Invest Optimization based on Campaigns run for downstream metrics reports.

●As Team Lead, mentor junior members by fostering growth through guidance, ownership, and feedback rather than direct answers. Tech Stack: IBM DataStage, Informatica PowerCenter, Alteryx, Hadoop, Teradata/Aster, Oracle, SAP-IDOC, JD Edwards, Adobe Analytics, Agile/Jira,NiFi Flow,Talend 5.3/5.4,Apache Hive,Sqoop,HDFS,Autosys. BBVA Compass Bank Sr. Lead Programmer Analyst / ETL Architect/Consultant March 2008 - May 2013 Birmingham, AL

●Designed, developed and deployed multiple applications for banking domains (Data Marts)

●Provided production support ETL loads, tracked SLA issues, and optimized inefficient jobs.

●Developed mappings/sessions/workflow for Datawarehouse project. Tech Stack: Informatica PowerCenter, Informatica IDQ, Oracle, SQL Server, AIX, Solaris,Autosys,SSIS DaimlerChrysler Financial Services ETL Consultant March 2003 - March 2008 Detroit, MI

●Developed maDesigned & developed ETL processes for SPOT (Single Point of Truth) Data Warehouse.

●Created data flow diagrams & ETL mapping specifications for MORIS.

●Supported Dealer Profitability,Truck Finance Data Mart Project, including validation and deployment processes.

●Converted EBCDIC files to ASCII/UTF-8 for downstream Data Marts. Tech Stack: Informatica PowerCenter, Informatica IDQ, Power Exchange,VSAM,Cobol copy books,Oracle, SQL Server, AIX, Solaris. Education

●Bachelor of Engineering (Mechanical) KITS Ramtek, Maharashtra, India

●Post Graduate Diploma (Personnel Management & Industrial Relations) : Kakatiya University, Telangana, India. Certifications & Training

●AWS Cloud (Redshift, EMR, Glue, S3, DynamoDB, Athena)

● Informatica Cloud Integration & Data Quality

●Cloudera Data Analyst & Data Engineer -Training Certificate

● IBM Cognos Certified BI Author

●Talend Studio for Data Integration-Training Certificate

●Python Boot Camp & Cassandra Workshop

●Azure Fundamentals (AZ-900)-Training Certificate

●Workshops: Snowflake & Databricks,dbt, Scala/Python (rockjvm)

● Databricks for Data Warehousing-Aug 2026

● i) Databricks for Data Engineering (ii) Databricks Fundamentals Accreditation/Databricks Fundamentals-Training Certificate

●Workshop Building dbt pipelines with Snowflake Cortex(AI) Recognition : Best Employee Award: IT Department, BBVA Compass.

Contact this candidate