Anuj Aggarwal

Anuj Aggarwal

Software Engineer

Followers of Anuj Aggarwal1000 followers
location of Anuj AggarwalBengaluru, Karnataka, India

Connect with Anuj Aggarwal to Send Message

Connect

Connect with Anuj Aggarwal to Send Message

Connect
  • Timeline

  • About me

    Oracle SQL & PLSQL Developer With 11 Years Of Experience

  • Education

    • Haryana Engineering College, Jagadhri

      2009 - 2013
      Bachelor of Technology (BTech) Computer science & engineering 70.1%
    • DAV Public School, Yamunanagar

      2003 - 2009
      Secondary Education CBSE
  • Experience

    • Eka Software Solutions

      Oct 2013 - Jul 2015
      Software Engineer

      Product Domain - Commodity Trading & Risk ManagementTechnologies I worked on:1. Migrated business data using ETL tool - PDI (Pentaho Data Integration)2. Wrote DB scripts in Oracle SQL & PL/SQL using TOAD3. Generated reports using SAP's Crystal Reports 2010

    • Fidelity Investments

      Jul 2015 - Aug 2017

      Product Domain - US Health CareWorked on Health & Other Benefits System (HOBS), a record keeping system for Health & Welfare (H&W) Business. HOBS is a customised version of Oracle Advanced Benefits (OAB), which is an application that comes under Oracle Human Resource Management System (HRMS, a major component of Oracle E-Business Suite). It manages non-monetary privileges/benefits (life insurance, medical claims etc.) provided by employer to employees.OAB is a combination of Benefit Structure, Life Events, Eligibility, Enrolment, Defaults, Electability, Coverage, Premiums & Rates, Certifications, Extracts.1. Fast Formulas / RulesInvolved developing, configuring, testing, & tracing Rules (decisionmaking Subprogram (Function, Procedure, Package) written in SQL & PL/SQL) which can be configured with any OAB component.2. AAM (Advanced Account Management)Implemented the complete AAM project using AGILE Scrum Methodology (an enhancement for OAB), which validates SSN's benefit structure. Show less

      • Software Engineer

        Dec 2016 - Aug 2017
      • Associate Software Engineer

        Jul 2015 - Dec 2016
    • Deutsche Bank

      Aug 2017 - Jul 2019
      Senior Analyst

      Product Domain - Investment Banking1. dbPalaceBank's strategic platform for Risk and P&L, with built-in upstream system for Balance Sheet (Valuation Data), Market Data (FX Rates) & Attribution Attributes.2. MCC (Market Conformity Control)Framework to control 'Off-Market' transactions.The team monitors cash & derivative trading activity/transactions that pursuant to German Law (in line with market conditions). The scope of monitoring is global and covers a wide array of products, businesses, trading desks and capture systems. Show less

    • JPMorgan Chase & Co.

      Jul 2019 - Jun 2021
      Associate

      Work in regulatory reporting where data & reports are submitted to regulators across multiple countries, which help them to evaluate bank operations & it’s overall health.

    • Wells Fargo

      Jul 2021 - now
      Senior Assistant Vice President
  • Licenses & Certifications

  • Honors & Awards

    • Awarded to Anuj Aggarwal
      Spotlight Award - Dec 2024 Spotlight award for Axiom Singapore & Frankfurt delivery.
    • Awarded to Anuj Aggarwal
      Spot Award - Jan 2018 Spot award
    • Awarded to Anuj Aggarwal
      Certificate of Appreciation Fidelity Investments Jan 2017 Team award is in recognition of the team going over & beyond by exhibiting ownership, hard work & commitment while developing the H&W Advanced Account Management System. This was the first time within the H&W space that a project was being executed completely using the Agile Scrum Methodology.The team did a great job adopting to Scrum & delivering incrementally. In fact the business team felt the team had implemented faster than anticipated & in higher quality. They did an excellent job in… Show more Team award is in recognition of the team going over & beyond by exhibiting ownership, hard work & commitment while developing the H&W Advanced Account Management System. This was the first time within the H&W space that a project was being executed completely using the Agile Scrum Methodology.The team did a great job adopting to Scrum & delivering incrementally. In fact the business team felt the team had implemented faster than anticipated & in higher quality. They did an excellent job in analysing the requirements & building the validation framework. Congratulations to the entire team on a job well done! Show less
    • Awarded to Anuj Aggarwal
      Certificate of Appreciation Fidelity Investments Dec 2016 Team award is in recognition to the BenRules team's excellent work during the NGRC (Northrop Grumman) implementation. This year the team has developed 200+ client specific & 50+ standard Rules for NGRC implementation. They have also supported AE (Annual Enrolment) for all the clients with no major issues & very less rework. Overall this team was involved in almost 1400+ Rules this year. Congratulations on a job well done!