Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Prasada Tammisetty

Cary,NC

Summary

18 years of experience primarily in Banking and Financial Services, with strong expertise in FR 2052a FED Regulatory Reporting (5G & 6G), Analytics, and Data Governance. Proven track record in the design, development, and implementation of Cloud Data Lake, Data Mesh, Data Warehouse, and Business Intelligence solutions. Possesses strong technical, analytical, and functional skills, with end-to-end ownership across SDLC and Agile methodologies, including requirements analysis, documentation, architecture design, development, testing, implementation, production support, incident management, root cause analysis, and real-time debugging. Designed and delivered cloud-native solutions with a strong focus on engineering excellence, automation, innovation, and cross-team collaboration. Continuously evaluated and adopted new technologies, tools, and working practices, demonstrating agility and a strong learning mindset. Brought a curious, questioning approach to solution design, contributing innovative ideas and improving architectural and operational outcomes. Triaged complex production issues, performed root cause analysis (RCA), and made decisive, data-driven decisions under high-pressure scenarios. Acted confidently in break-glass production incidents, restoring services and minimizing customer impact during critical outages. Designed and implemented scalable solutions using AWS services, including compute, storage, networking, containers, and serverless frameworks. Built and deployed applications using Infrastructure as Code (IaC) tools such as Cloud Formation, Terraform, Ansible, and ARM, ensuring repeatability and compliance. Applied object-oriented principles and design patterns to develop maintainable, extensible, and high-performing applications. Developed and deployed containerized applications, leveraging Docker and Kubernetes, with strong experience deploying workloads on Amazon EKS. Implemented CI/CD pipelines using Jenkins and Git-based workflows, enabling automated build, test, and deployment processes. Collaborated effectively with distributed teams and stakeholders, both in-person and virtually, building trusted and productive working relationships. Worked with enterprise database technologies including Oracle, PostgreSQL, and SQL Server to support transactional and analytical workloads. Defined and implemented cloud reliability, resiliency, and observability strategies, ensuring high availability and performance of Tier-3 critical systems. Established and enforced engineering standards and best practices, contributing to increased engineering maturity and operational stability. Deployed and managed LLM-based solutions, including Retrieval Augmented Generation (RAG) architectures in cloud environments. Built full-stack AI-powered applications, integrating LLMs with backend services and cloud infrastructure. Applied best practices in prompt engineering, data privacy, hallucination mitigation, bias awareness, token usage, and cost optimization. Demonstrated understanding of GenAI modalities, determinism vs. randomness, and agentic behavior in production systems. Developed AI workflows and services using object-oriented Python, ensuring scalability, reliability, and maintainability. Data engineering professional poised to add significant value through comprehensive experience in developing scalable data solutions. Noted for strong team collaboration and adaptability in fast-paced environments. Reliable in driving results with key skills in data modeling, ETL processes, and cloud-based data platforms. Experienced with building and maintaining data pipelines to ensure seamless data flow. Utilizes advanced knowledge of big data technologies to drive data-driven decision-making. Track record of enhancing data architecture for improved performance and reliability. Senior engineering professional with deep expertise in data architecture, pipeline development, and big data technologies. Proven track record in optimizing data workflows, enhancing system efficiency, and driving business intelligence initiatives. Strong collaborator, adaptable to evolving project demands, with focus on delivering impactful results through teamwork and innovation. Skilled in SQL, Python, Spark, and cloud platforms, with strategic approach to data management and problem-solving. Diligent [Desired Position] with robust background in data engineering and proven ability to design and implement complex data pipelines. Successfully contributed to optimizing data architecture and enhancing data processing efficiencies. Demonstrated expertise in big data technologies and proficiency in Python and SQL. Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills. Detail-oriented [Job Title] designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages. Astute [Job Title] with data-driven and technology-focused approach. Communicates clearly with stakeholders and builds consensus around well-founded models. Talented in writing applications and reformulating models.

Overview

19
19
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

SMBC – Sumitomo Mitsui Banking Corporation
Charlotte, NC
11.2022 - Current
  • Designed and implemented cloud-native data platforms across AWS and Azure, supporting analytics, regulatory reporting, and enterprise data consumption.
  • Built and managed AWS infrastructure using EC2, EKS, S3, RDS, DynamoDB, Glue, Lambda, Step Functions, Cloud Watch, IAM, and VPC, ensuring security and compliance.
  • Deployed containerized workloads on Kubernetes (EKS) with automated CI/CD pipelines using Jenkins, Git, and Terraform.
  • Designed scalable ETL/ELT pipelines using Azure Data Factory, Azure Synapse Analytics, and Data Bricks, implementing Bronze/Silver/Gold data layers.
  • Improved pipeline reliability to 99.4% uptime and enhanced performance by 20% through partitioning, tuning, and optimization techniques.
  • Led production incident triage and break-glass support, performing root cause analysis and implementing permanent fixes.
  • Developed Python-based automation tools, reducing manual operational effort and improving delivery efficiency.
  • Implemented data quality and governance controls using Collibra Data Quality and metadata frameworks.
  • Create and maintain data storage solutions including Azure SQL Database, Azure Data Lake, and Azure Blob Storage.
  • Environment: Google Cloud Big Query, GCS Bucket, SFTP Server, Data Flow, Google Cloud Functions, Control-M, Auto Sys, SQL Server, Oracle, Python, Perl, Bash, PowerShell, Incident, Problem, Change Management, Prometheus, Grafana, Logic Monitor, ServiceNow, JIRA, Confluence, CI/CD Pipelines, JSON, Parquet.

Data Engineer

Credit Suisse
Raleigh, NC
02.2014 - 10.2022
  • Strong Hands-on Experience in Various Activities like Control flow logic and conditions (For Each, if, switch, until), Lookup, Stored procedure, scripts, validations, Copy Data, Data flow, azure functions, Notebooks, SQL Pool Stored procedures etc.
  • Create and maintain data storage solutions including Azure SQL Database, Azure Data Lake, and Azure Blob Storage.
  • Design Fabric solutions to support the outcomes required by our clients, whilst following industry best practice approaches (such as Data Fabric, Medallion Architecture etc.)
  • Architected multi-layered data lake zones (raw, curated, serving) using Iceberg’s metadata versioning, ensuring full audit and lineage traceability across business domains.
  • Conducted data profiling and performance tuning for Py Spark and Python-based transformations, ensuring memory-optimized execution in distributed compute environments.
  • Partnered with business intelligence and analytics teams to create domain-specific data marts and optimized schemas for downstream Power BI and Tableau reporting.
  • Performed root cause analysis (RCA) for pipeline failures, data latency issues, Spark job errors, and infrastructure bottlenecks; documented findings and implemented permanent fixes.
  • Perform root cause analysis and implement permanent fixes for recurring issues, Maintain run books, support documentation, and knowledge bases.
  • Integrated Data Bricks notebooks and jobs with CI/CD pipelines using Azure DevOps for automated deployment and version control.
  • Environment: OBIEE, Qlik Sens, Informatica Power center 10.2.0, Informatica cloud (IICS), Azure ADF, IDQ 10.2.0, Informatica MDM, Toad 10.5, Oracle 11G, Unix, Control-M, Data Bricks, Python 3.9, Pandas, AWS S3, Terraform, Docker, Kubernetes (EKS), Jenkins, GitHub Actions, AWS Glue, Airflow, Cloud Watch, Prometheus, SQL, JSON, Parquet, REST APIs, Power BI, Tableau, JIRA, Confluence.

ETL / BI Developer

Balfour Beatty Plc
Basingstoke, United Kingdom
02.2012 - 01.2014
  • Supported large-scale Oracle E-Business Suite R12 enterprise transformation programs.
  • Delivered data integration and analytics solutions across Finance, SCM, HR, and Projects domains.

BI Developer

Shire Pharmaceuticals
Easton, USA
08.2010 - 11.2011
  • Supported validated Clinical Trial Management Systems (CTMS) ensuring regulatory compliance.
  • Built BI and ETL solutions using Informatica and Oracle platforms.

Siebel Analytics Developer

Electronic Data Systems
Preston
11.2006 - 07.2010
  • Delivered enterprise BI solutions across government and commercial clients.

Education

Master of Business Administration and Information Systems -

Madurai Kamaraj University
India
01-2005

Skills

  • AWS & Azure Cloud Architecture (IaaS, PaaS, Serverless)
  • Kubernetes & Container Platforms (EKS)
  • Infrastructure as Code (Cloud Formation, Terraform, ARM)
  • Python programming
  • Big data processing
  • ETL development
  • Git version control
  • NoSQL databases
  • Kafka streaming
  • Data pipeline design
  • Data modeling
  • API development
  • Performance tuning
  • Hadoop ecosystem
  • Data warehousing
  • Spark development
  • Advanced SQL
  • Machine learning
  • Data security
  • Data quality assurance
  • Metadata management
  • Data Engineering, Data Lake & Data Mesh Architectures
  • CI/CD, DevOps & SRE Practices
  • Gen AI / LLM / RAG Solutions
  • Regulatory & Financial Systems (FR 2052a, Payments)
  • Production Support, RCA & Incident Management
  • Cloud Technologies: Azure Data factory, Azure Synapse Analytics, Azure SQL Database, Azure Data Lake, Azure Blob Storage, AWS S3, AWS Glue, EMR, EC2, AWS Redshift, Lambda functions, Cloud Watch and Step function, Azure Cloud-ADF, Synapse Analytics, Snowflake, Data Bricks, GCS Bucket, BIG Query
  • Programming languages: Python, Java, Linux Shell Scripts, C, C
  • Payments and Middleware: SWIFT (SAA, SAG, SNL), FIN, InterAct, FileAct, AMH, ISO 20022 (MX/MT), FED, CHIPS, ACH, IBM WebSphere MQ, Messaging Application Support, Kafka, NICE Actimize (AML) and FIRCO for Sanctions Screening
  • Scheduling: Control-M, Air Flow, DAC and ODI
  • BI & Data Visualization: OBIEE, Google Looker, Tableau and Power BI
  • Big Data: HDFS, MapReduce, Pig, Hive, Kafka, Storm, Sqoop, Spark Streaming, Spark SQL, Zookeeper
  • Data Bases: MySQL Server, Oracle DB, HiveQL, Spark SQL, PostgreSQL, HBase, Mongo DB, Dynamo DB, Aurora, S3
  • IDE Tools: Eclipse, IntelliJ IDEA, Databricks, Anaconda
  • Data Modeling & Governance: Erwin, dbt, Power Designer, Unity Catalog, Data Lineage, Data Quality Frameworks, JIRA, Metadata Management, Collibra DGC, Confluence and HPQC
  • Machine Learning: Google Vertex AI, Azure ML Studio
  • Real-time analytics
  • Scala programming
  • Data curating
  • Continuous integration
  • Linux administration
  • Java development
  • Data integration
  • SQL and databases
  • Database design
  • SQL programming
  • RDBMS
  • Data migration
  • Advanced analytics
  • Relational databases
  • Storage virtualization
  • Risk analysis
  • Business intelligence
  • Data analysis

Certification

  • Google Cloud Certified – Professional Cloud Architect
  • Certified Pega System Architect.
  • Oracle Certified Associate OBIEE
  • C and C++ - Electronics Corporation of India Limited

Timeline

Senior Data Engineer

SMBC – Sumitomo Mitsui Banking Corporation
11.2022 - Current

Data Engineer

Credit Suisse
02.2014 - 10.2022

ETL / BI Developer

Balfour Beatty Plc
02.2012 - 01.2014

BI Developer

Shire Pharmaceuticals
08.2010 - 11.2011

Siebel Analytics Developer

Electronic Data Systems
11.2006 - 07.2010

Master of Business Administration and Information Systems -

Madurai Kamaraj University
Prasada Tammisetty