Tarun Agarwal

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.