Summary
Overview
Work History
Education
Skills
Timeline
Generic

Prakhar Agarwal

Jersey City,NJ

Summary

Principal Lead Cloud Engineer :

Highly qualified and tenacious individual, armed with diversified skills in Information Technology with extensive experience in Banking and Finance domains including Asset Wealth Management, Regulatory Reporting & Compliance, Investment Banking and Operations having 16+ years of experience leading Transformation and Implementation based programs with Data Intensive structures across cloud platforms. Worked on various migration projects within on prem and from on prem to AWS cloud

Visa status: US citizen

Overview

23
23
years of professional experience

Work History

Senior Cloud Engineer

J P Morgan
06.2021 - Current
  • Housekeeper for engineering processes for JP Morgan’s Public Cloud Development via enforcing industry standards for AWS cloud implementation across various LOBs/functional areas across 10+ applications
  • Worked/hands on in migrating on prem applications to AWS cloud infrastructure with using modern SDLC standards (automation/CI/CD/Infrastructure as code etc)
  • Involve in hiring best available talent across LOBs
  • Leading major program in Asset and Wealth Management space that delivers client insights and features like next best call Factorization, and Retention/Reactivation to firm's Wealth Managers using niche tools and technologies
  • Demonstrated understanding of AWS data migration tools and technologies including Storage Gateway, Database Migration and Import Export services.
  • Good understanding of networking concepts including TCP, VPN, VPC, NAT, Bastion Host, Subnet, DNS, Gateways and Routers.
  • Excellent knowledge of source control management concepts such as Branching, Merging, Labeling/Tagging and Integration, with tool like GIT and TFS that lean on AI/ML
  • Delivered (and continuing to scale up) user solutions that enable them to attain Data
  • Developed and implemented new strategies and policies in collaboration with executive partners to establish and achieve long-term business objectives, providing company with strong and sustainable organizational leadership.

VP-Senior Tech Lead

BoNY Mellon
05.2017 - 05.2021
  • Led major Tech program's cloud migration (over 50 applications) from on prem to AWS cloud which was responsible for firmwide filing of Regulatory Reports including but not limited to CCAR 14Q/M/A, SCCL which consolidates data across various asset classes and LOBs from across bank
  • Used sophisticated tools and platforms like HDFS, HIVE, Sqoop & Python, Pyspark, Kafka, SQL
  • 2 Years of hands on experience in Amazon Web Services including EC2, VPC, S3, EBS, ELB, Cloud-Front, IAM, RDS, Cloud Watch, Lambda.
  • In depth knowledge of Amazon redshift and tuning queries for loading and retrieving data from redshift
  • Delivered a scalable solution for the ever broadening scope owing to newer reports onboarding across regions supported
  • Liaised with Product Managers and other management teams for the delivery plan, operational issues in Production
  • Liaised with Business users and stakeholders to understand pain points and implement plans towards alleviating them
  • Gained expertise on on Axiom SL for 14 series reporting/SCCL reporting
  • Delivered visually appealing and easy- to comprehend Tableau dashboards to deliver reconciliation dashboard between various source
  • Presented Programs on Monthly Steercos to senior management and worked with Program Team to help project governance.
  • Led monthly meetings to coordinate support efforts across multiple departments.

Senior ETL Consultant

Barclays Wealth
01.2014 - 04.2017
  • Delivered Data Analytics and Visualization capabilities in the Client Onboarding and KYC space
  • Delivered a sophisticated code solution and architecture using Informatica 9.6/9.1, MS SQL
  • Server 2012/2008 R2, Oracle 11g, SSIS, DB2 v8.2
  • Composite 6, Rapid SQL, Windows Server 2008
  • UNIX/LINUX, Shell Scripting, OBIEE 11g, Autosys
  • R11,Teradata
  • Built an offshore team ground-up and managed, tracked their deliverables.

KPN Telecom/Barclays/Telstra
01.2001 - 01.2013
  • Performed major Performance improvisations while delivering milestone programs for these various clients as an ETL Consultant(informatica PC, Pentaho
  • Teradata)
  • Increased efficiencies in existing processes, mentored individuals, built visualizations for senior meetings, represented data oriented initiatives
  • Led the data currency of Staging, EDS (Enterprise
  • Data Store), Decision support systems
  • Upstream/Downstream feeds handling, architecture and solution discussions.

Senior ETL Developer Consultant

01.2006 - 01.2010

Education

Operations - Management

Symbiosis Institute
Pune,india
10.2008

Bachelor of technology - Computer

Institute-Uttar Pradesh Technical University
India
06.2006

Skills

  • TECHNICAL SKILLS:
  • DevOps Tools: Ansible,Terraform,YAML,Jenkins
  • Cloud Platform: AWS Stack
  • Scripting Language: Python,Pyspark ,Shell programming
  • SCM tools: Git,svn
  • Databases: Oracle,Teradata,Vertica
  • ETL tools : Informatica,Pentaho,SSIS
  • Visualization Tools: Tableau , Qliksense
  • AWS Cloud skills:AWS S3,RDS,Cloudwatch,Lambda,EC2,EBS,Redshift,Spark on AWS
  • Monitoring/Scheduling : Autosys,Control M,UC4

Timeline

Senior Cloud Engineer

J P Morgan
06.2021 - Current

VP-Senior Tech Lead

BoNY Mellon
05.2017 - 05.2021

Senior ETL Consultant

Barclays Wealth
01.2014 - 04.2017

Senior ETL Developer Consultant

01.2006 - 01.2010

KPN Telecom/Barclays/Telstra
01.2001 - 01.2013

Operations - Management

Symbiosis Institute

Bachelor of technology - Computer

Institute-Uttar Pradesh Technical University
Prakhar Agarwal