AMAN JAIN

Experience

• 

  NTPC

  Jun 2013 - Jul 2013

  Operations Engineer Trainee

  •I worked as a trainee engineer on a Power Plant Management gaining a hands-on experience in the field of power systems.•The project covered the various processes that take place in the generation of thermal power on a practical scale as well as how the distribution of electricity is done.•Examined the working of various substation equipments and protection systems.

• 

  Power Grid Corporation of India Limited

  May 2014 - Jul 2014

  Operations Engineer Trainee

  Study of various equipments of GIS Substation used in Power Transmission Operation, Maintenance and Testing activities.

• 

  Tata Consultancy Services

  Sept 2015 - Jun 2019

  Information Technology Analyst

  - Responsible for Implementing different Client Requirements along withRequirement Analysis and generating Business Report for the same.- Provided a secure environment while allowing one to build, test, maintain, anddeploy business applications in an automated manner using in-house applicationprovided by UNISYS.- Owning the complete responsibility of implementing New Client Requirement inassigned portfolios by various SAS Functions and Procedures.- Writing SQL Queries to fetch required data from Teradata tables as perrequirements.- Imported data from MS-excel to SAS data set & performed Data validation & DataManipulation by SAS Functions and other tools.- Used SAS/SQL for combining, creating & eliminating the duplicate data of differentfiles.- Worked on dev requests, data requests, system incident request, defects,incidents etc. on ServiceNow to ensure smooth testing and delivery of severalprojects.- Produced customized reports for Performance Optimization by using variousprocedures.- Adapted Agile methodology, KANBAN & SDLC model and delivered projects onseveral sprints with adequate use of JIRA tool.- Implemented various models in a fully automated system (SAS & SQL) forvalidation (standard statistical, logical and accuracy tests) working on total assetsof 500 billion GBP and 20 million customers thereby, resulting in ~70%reduction in turnaround time.- Significant client exposure while engaging with multiple functional platforms. Show less

• 

  EXL

  Jul 2019 - Mar 2021

  - Analysis performing on Insurance domain data for the US client and creating dashboards in Power Bi.- Developing different campaigns to strategize on the data provided by the client and improve existing methods using SAS macros.- Owning 40+ Billing & Operational reports and automate them to be executed on daily frequency.- Extracted data from various data sources and build a bridge between SAS and Hadoop in order to use the output datasets for visualization.- Extensive use of SQL queries to modify, fetch and manipulate data from the server.- Working in Agile methodology and supporting onshore team in any way possible.- Working on Migration project for SAS towards cloud based platform using Pyspark. Show less

  • Lead Assistant Manager

    Jan 2021 - Mar 2021

  • Assistant Manager

    Jul 2019 - Dec 2020
• 

  Accenture

  Apr 2021 - Nov 2023

  Custom Software Engineering Team Lead

  > Generating Regulatory Reports for client Natwest Bank, reporting RWAs for Personal Loans, Home Loans, Credit Cards, Current accounts for the UK retail market.> Generating IFRS9 reports & disclosures, reporting ECL (Expected Credit Loss) by various sectors (wholesale, retail) and splits (agriculture, real estate, power utilities).> Mentoring a team of 5 people, and taking end-to-end ownership of projects to deliver before deadlines.> Using SAS coding techniques (macros, loops, rank ordering etc) to generate multiple metrics for various regulatory reports.> Develop complex SQL queries for ETL processes to modify, fetch and manipulate data from server for client needs and project requirements.> Provide full cloud, AWS, S3, Athena and Unix script support for design and architecture changes to ATLAS platform during their on-going AWS migration.> Working in Agile methodology to create user stories, sprints, and implementation of SDLC lifecycle process which includes requirement gathering, development, testing and post implementation support. Show less

• 

  Bank of America

  Nov 2023 - now

  Manager

  > Working in fraud analytics team within BFSI domain and first hand experience working in product based industry.> Perform complex analysis and/or modeling to identify patterns of fraudulent transactions and to prevent fraudulent usage of various verticals within banking sector.