Post Job Free

Resume

Sign in

Software Engineer Pl Sql

Location:
Katy, TX
Posted:
April 09, 2024

Contact this candidate

Resume:

Professional Summary

Technical Skills

Professional Experience

RAGHAVA SREENIVASAN

Katy, TX 77494 713-***-**** ad4vua@r.postjobfree.com WWW: linkedin.com/in/raghava-sreenivasan-183b9b295 Software Engineer with over 20 years of hands-on experience in building leading-edge technology. Experience in full Software Development Life Cycle SDLC using Agile/Scrum methodology. Development Lead, DevOps Lead, Release Management Lead, Testing Lead, Site Reliability Engineer SRE Lead and Operate Lead Expertise with a team spread across three time zones. Expertise in migration from monolithic to microservices architecture using REST API and Spring Framework.

ETL development expertise using Informatica and Java. Experience in designing automation framework using Python, ReactJS and Shell Scripting. Expert in Oracle PL/SQL, package procedures, functions, triggers and SQL tuning. Programming: Python 3.11, Java 8, Spark, GWT

2.8.2, ReactJS, JavaScript, HTML, CSS, UNIX

Shell, Hive SQL, Impala SQL, Sqoop, PL/SQL

ETL: Informatica 9.1, Ab Initio 3.5.3.2

Environment: Linux, Cloudera Hadoop, UNIX,

Windows, Gaia Cloud (Private)

Web Servers: Apache 2.4.41 and Tomcat 8.5.51

Data Modeling: ODS, Star-Schema, Snowflake

Database: Oracle 19c/11g/10g/9i/8i/7.x, Oracle

Exadata, DynamoDB, HBase

Operating System: Linux, Unix, Windows

Cloud Platform: Amazon Web Services (AWS)

Containerization Tools: Kubernetes, Docker

Other Tools: Terraform, Ansible, Kafka, Swagger,

Dynatrace, Grafana, Cloudera Manager, IntelliJ,

Eclipse, Jenkins, Hue, TOAD, Control-M, Visio,

Erwin, Git, SVN, MS-Office suite

Nov 2018 - Feb 2024

Houston

DevSecOps / Site Reliability Engineer Lead

JPMorgan Chase

Liquidity Risk SRE Lead for Multi Framework Big Data ETL pipeline built on Ab Initio Kubernetes containers and ETL pipeline built on Kafka, Java and Spark. Performed analysis and monitoring using Splunk, Dynatrace and Grafana to identify issues and improve the performance of software systems

On-premises Hadoop environment to AWS migration using Git, Ansible, and Terraform. Led Jules continuous integration CI and continuous deployment CD ETL pipeline automation. Automation brought down deployment release time by 30%. Sonar and Black Duck scans were part of CI/CD pipeline to detect flaws, bugs and security vulnerabilities.

Liquidity Risk Site Resiliency lead for semi-annual application and data center flip. This exercise has been handy in handling real disaster recovery scenario and meet RTO. Release management Lead: Led production releases using Jules pipeline. Swagger to deploy, execute microservices API services and monitor run history Oracle PL/SQL Development and performance tuning

Responsible for Liquidity Risk Infrastructure stability, availability, and performance of the physical and virtual resources.

Responsible for meeting consumer SLAs and meeting Operation Team's user experience. Environment: Amazon Web Services (AWS), Terraform, Ansible, EKS, EC2, S3, RDS, Lambda, CloudWatch, Swagger, Dynatrace, Cloudera Hadoop, Grafana, Spluk, Kerberos, Linux, Kafka, YARN, Spark, Python, Spark, Impala, HDFS, PL/SQL, Route 53, Control Tower, Lambda, Dynamo DB, Ab Initio, Java, HBase, HDFS, Hue, TOAD, S3, Git, Oracle, IntelliJ, Jules/Jenkins Feb 2016 - Oct 2018

Houston

Software Development Lead

JPMorgan Chase

Big Data vendor platform evaluation - Big Data ETL process Proof of concept to ultimate build-out. Design, develop, and maintain data pipelines for large-scale data processing using Hadoop and Kafka. Monolithic to microservices framework conversion using REST API and Spring Framework. Reconciliation reports between Big Data and Oracle Exadata. Oracle PL/SQL development and performance tuning.

Environment: Hadoop Cluster, Cloudera, Kerberos, Linux, Kafka, YARN, Java, Python, JavaScript, Splunk, HTML, CSS, Spark, Git, PL/SQL, HBase, Hive, Impala, HDFS, Oracle, IntelliJ, Hue, TOAD Feb 2013 - Jan 2016

Houston

Risk DB Performance Management Lead

JPMorgan Chase

DB Performance tuning across 40+ applications leading to overall SQL Query performance improvement anywhere from 15% to 80%.

DB Performance reporting UI buildout: report compare query disk read, write, buffer usage, historical query performance trending.

Database Refresh Tool DaRT: Metadata driven oracle Database refresh tool buildout to copy data to different environments saving enabling environment timeline by 70%. Environment: Oracle, Java, GWT, JavaScript, HTML, CSS, Linux, PL/SQL, Python, SVN Apr 2008 - Feb 2013

Houston, TX

Market Risk ETL Development Lead

JPMorgan Chase

Led design and development of Informatica ETL workflows to load 200+ source systems into ODS. Unix to Linux server migration and Informatica 9 upgrade lead. Environment: Informatica, Oracle, PL/SQL, Linux, TOAD, SVN Apr 2006 - Apr 2008

Houston, TX

Software Engineer

JPMorgan Chase

Education

Certifications

Supported Credit Risk Informatica ETL ODS workflows. Environment: Informatica, Oracle, PL/SQL, UNIX, TOAD, SVN Oct 2004 - Apr 2006

Houston, TX

Programmer

Ajilon Consulting

Data Warehouse project at JPMorgan Chase.

Environment: Informatica, Oracle, PL/SQL, UNIX, TOAD, SVN Programmer Analyst Oct 1995 - Jun 2004

Various - Consulting

UI and Data Warehouse projects for various clients like GE Appliances (1995-1998), Kodak (1998-2002) and Xerox (2002-2004).

Environment: UNIX, Visual Basic, JavaScript, HTML, Oracle 7.3.4/8.1.7/9.2.0.4, PRO*C, PL/SQL, Stored Procedures, Triggers, SQLLOADER, UNIX Scripts, INFOREPORTS, Maestro Job Scheduler, Oracle Express 6.2, Express Batch Manager 6.2.0.1, Oracle Sales Analyzer 6.2.1, Erwin 1995

Miami, FL

MS: Electrical Engineering

Florida International University

Certified Professional in Python Programming 1 (PCPP1) https://www.credly.com/badges/901dbc10-b772-472e-b755-522d183ce0ad/public_url AWS Certified Solutions Architect – Associate

https://www.credly.com/badges/43127337-ffcd-41eb-8ea5-84006d830ae5/linked_in_profile



Contact this candidate