Tarun Agarwal

Tarun Agarwal

Assistant Systems Engineer

Followers of Tarun Agarwal412 followers
location of Tarun AgarwalGurugram, Haryana, India

Connect with Tarun Agarwal to Send Message

Connect

Connect with Tarun Agarwal to Send Message

Connect
  • Timeline

  • About me

    Associate Director/Principal Database Developer at OSTTRA

  • Education

    • Radha Ballabh Inter College, Agra

      1999 - 2001
      10+2 Physics, Chemistry, Mathematics 1st Division

      Completed 10th and 10+2 studies with distinction marks in Mathematics and English.

    • Dr. A.P.J. Abdul Kalam Technical University

      2003 - 2007
      B Tech Electronics & Communication 1st Division

      Activities and Societies: Electronics Students Association Won prizes in C-language programming contests organized at college.

  • Experience

    • Tata Consultancy Services

      Nov 2007 - Dec 2010
      Assistant Systems Engineer

      Worked on 2 major projects as a Developer.1) SBI - Core Banking Solution Architecture & Performance Tuning:Duration: 2 yearsKey skills used: Oracle PL/SQL, Unix Shell scripting, COBOLResponsibilities:• Performance Tuning of PL/SQL (batch), COBOL and Pro-COBOL (real-time) programs.• Identify and then eliminate the unnecessary application-database interactions so as to minimize transaction response time• Investigate and resolve Production issuesAchievements:Winner of TCS Gems - STAR Team Award, received Client appreciation2) Sun Life Financial, USA - Utopia and NB DDS Support:Duration: 1 yearKey skills used: COBOL, JCLResponsibilities:• Development and enhancement of COBOL programs based on business requirementsAchievements:Winner of TCS Gems - On the Spot Award, received Client Appreciation Show less

    • JPMorganChase

      Dec 2010 - Dec 2013
      Applications Developer

      Worked as part of the Chase Card Services - Marketing IT team.Role: Tech Lead / Senior DeveloperKey skills used: Oracle PL/SQL, UNIX Shell scripting, TWS, CyberArk EPV, Subversion, TeradataResponsibilities:• As Tech Lead – Break down work into smaller tasks, distribute among Developers, set milestones and deadlines, prepare high level technical design, perform code-reviews, collect and report on status• As Senior Developer – Design database objects, develop/maintain PL/SQL and Shell script components based on the business requirements; Performance Tuning of Batch programs.• Investigate and resolve Production issues, provide level-2 supportAchievements:• Achieved Subject Matter Expert recognition on given Application• Helped resolve a number of high priority incidents in Production Show less

    • Publicis Sapient

      Dec 2013 - Dec 2015
      Senior Associate

      Worked as part of the IDM Reference Data Dev team for a USA based Asset Management Co.Role: Senior DeveloperKey skills used: Markit EDM (CADIS), MS SQL Server 2012, T-SQL, PERL scripting, Oracle PL/SQL, UNIX Shell scripting, TWS, AccurevResponsibilities:• Create and/or alter Batch processing routines and UI screens using Markit EDM components including Data Porter, Constructor, Rule builder, Matcher, Solutions, Workflows, Pages, Illustrator, Data Manager etc.• Develop Data Model as per requirements, write DDL and DML scripts, maintain PL/SQL and T-SQL subprograms, PERL scripts, TWS jobs/streams definition scriptsAlso worked as part of the Enterprise Data Security team for the same client.Role: Senior DeveloperKey skills used: Oracle PL/SQL, Tableau Software, UNIX Shell scripting, TWS, Oracle Database Auditing, Audit Vault, Database Vault, Transparent Database Encryption, Oracle Data Masking, AccurevResponsibilities:• Develop and maintain PL/SQL subprograms, UNIX Shell scripts, TWS jobs/streams definition scripts for an application that facilitates controlled execution of DMLs to Production tables data in case of emergencies. The application makes use of Secure Application Roles in Oracle.• Enable Auditing of users’ DML activities and drawing reports out of Audit data. Also grant ‘least privileges’ for DDL and DML operations to Applications and individual users on all databases• Build/maintain dashboard reports out of audited data using Tableau Software• Implementation of Oracle Database Vault, Audit Vault, TDE and Oracle Data Masking to efficiently manage and track the access, entitlements and activity.• Proof of Concept / Feasibility studies for new product/solutions to be adoptedAchievements:Delivered Oracle PL/SQL Classroom Training at Sapient, 2015 Show less

    • OSTTRA

      Dec 2015 - now
      Associate Director/Principal Database Developer

      Principal Developer working primarily on Oracle 19c database in MServ MarkitWire team.

  • Licenses & Certifications

    • IBM Certified Database Associate - DB2 Universal Database V8.1 Family

      IBM
      Oct 2008
    • Oracle Certified Associate - PL/SQL Developer

      Oracle
      Jul 2010