Summary
Overview
Work History
Education
Accomplishments
Timeline
Generic

Anuj Agrawal

North York,ON

Summary

Creative, Curious and Courageous describe me best.

Being a passionate learner, I believe in constantly upgrading and updating with the latest technological trends.
I am a mainframe developer based in Ontario with more than 5 yrs experience In Canada at various onshore client locations and Overall 9 plus years experience in total. I have expertise on IBM Z/OS related technologies.

Overview

7
7
years of professional experience

Work History

Mainframe Developer

Aviva Canda
  • Applied business and technical knowledge to provide quality solutions for business and enterprise software GEAC and SETS having integration with various other applications in Element Fleet
  • It’s expected that processes originating in other applications are also covered while preparing system documents with primary focus on GEAC SETS Process, 1) Requirement gathering, Design, build and maintain solutions to business on Mainframe application which requires knowledge of IDEAL,PDL(GEAC Millennium), COBOL,JCL,CICS,VSAM,REXX,DATACOM & DB2
  • Work with business analysts and understand new features which are getting developed for each release and create end-to-end test cases which are scalable, repeatable, measurable and confirm to acceptance criteria
  • Work in agile team which is responsible for Product Assurance Test on Mainframe platform; Interact closely with technical Product Managers, Scrum teams, and understand product thoroughly with strong quality advocacy
  • Interact with business users & management to discuss on Estimates and project timelines of upcoming enhancements
  • Managing deliverables and interacting with Element project management team to keep track on Application health of overall product
  • Interact with Element SMEs & business team regarding drafted Architecture and Design of development components and ensure acceptance from all stakeholders Test case execution and maintenance Using JIRA,Rally etc
  • Ensure all features are reviewed to check for quality coding standards, optimization and performance tuning before handing over to QA/ Business Test
  • Production Release management, Post production testing and support. Analysis of production defects & work closely with component development team to provide resolution with insightful thoughts and negligible impact. Identify opportunities for continuous system processes improvements/automations from both technical and business perspective and implement them."
  • Solution Environment
  • Mainframe - COBOL, JCL, DB2, CICS, ASSEMBLE, SAS, REXX, MQ series, Assembler Language, File-Aid, XPEDITER, STROBE, MQFTE, FTP, File-AID, SPUFI, SDF II, ENDEVOR, Quick Edit, Teradata SQL assist, IBM Utilities, Sync-Sort, ICETOOL, DFSORT, ZEKE, VSAM
  • IMS, DB2, Teradata
  • Web Technologies: Java, JavaScript, HTML, MQSQL
  • Customer, having total of 9 years 2 Months of work experience
  • Earned admiration for meeting demanding deadlines and delivering critical solutions
  • Involved in conversion of business requirement in to live project using mainframe technologies
  • Self-starter with clear understanding of business needs and possess good communication, leadership & motivation skills
  • Specialized knowledge on Mainframe Technology such as COBOL, JCL, CICS, IMS, and DB2
  • Expertise in Mainframe tools like File-Aid, XPEDITER, STROBE, MQFTE, FTP, File-AID, PLATINUM, SPUFI, SDF II, ENDEVOR, CA7, TIVOLI WORKLOAD SCHEDULAR, Quick Edit, Teradata SQL assist, IBM Utilities, Sync-Sort, ICETOOL, DFSORT, ZEKE, VSAM
  • Extensively worked with DB2, IMS DB, Teradata
  • Intact knowledge in REXX, EASYTRIEVE, XML, and MQSeries
  • Experience in batch job scheduler – ZEKE, CONTROL-M
  • Strong experience in Agile Methodology as well as Waterfall Model
  • Key team player with excellent analytical, problem-solving skill
  • Have good experience in both Insurance, Retail and GE domain projects.

Mainframe DB2 Developer

  • Responsibilities -To modify and make change in Admin tool as per requirements specified -To update queries required to share with HP/Dxc team - To ensure testing of all process chart flows in Content Manager and System Admin tool - To ensure timely and defect free delivery of all modules as specified in BRD
  • Solution Environment
  • Mainframe - COBOL, JCL, DB2, CICS, ASSEMBLE, SAS, REXX, MQ series, Assembler Language , File-Aid, XPEDITER, STROBE, MQFTE, FTP, File-AID, SPUFI, SDF II, ENDEVOR, Quick Edit, Teradata SQL assist, IBM Utilities, Sync-Sort, ICETOOL, DFSORT, ZEKE, VSAM
  • IMS, DB2

Mainframe Developer

Period
10.2016 - 06.2020
  • Developing mainframe functionality to support users for underwriting and claim modules
  • Legacy Application Development and Transformation:
  • Business Requirements Elicitation
  • Conversion of Business Requirements to Technical Specifications like High Level and Low-Level Design Documents
  • Process Flow Design, Development of Data Models, Entity Relationship Diagrams and Plan
  • Impact Analysis; Unit Test Plan and Integration Test Plan creation beneficial to develop/validate/maintain the Application as per the Business Requirements
  • Software Development using IMS database, Mainframe - COBOL, JCL, CICS, Assembler and DB2; Code development for consistent integration across multiple generic applications
  • Supported Broker portal application using following technologies Java, Javascript, HTML
  • Test Plan Preparation; Unit Testing, Integration Testing, Regression Testing; Defects Identification, Debug and Fix; Test Jobs comparison with Production Jobs
  • Supervise and Complete monitor to ensure that necessary delivery details are provided to QA Team for Testing till project hit production
  • Handle Code Walkthrough and Review of Internal and External Quality Assurance in the applications
  • Ensure Complete System Stability by Root Cause Identification of Production Processing Issues and Provide Optimum Solutions by interacting with real Business users
  • Code Deployment to next higher Region and Production Region
  • Manage Job scheduling using ZEKE and Enterprise Job Scheduling using ZENA
  • Performance Improvement:
  • End to End Performance Testing to improvise performance, Live Data load generation and Performance snag diagnosis in business-critical applications
  • Worked on Performance Enrichment of using STROBE
  • Query optimization using various methodologies and minimize database calls
  • Work on Performance Improvement for best Optimal Performance
  • Automation and Scheduling:
  • Automation of various frequent manual activities using REXX
  • Scheduling of the batch jobs in ZEKE scheduler
  • Scheduling of the Enterprise job in ZENA
  • Quality Assurance and Coordination:
  • Backlog management, release and sprint planning, task management and test management
  • Manage requirements, test and defect management processes in a structured approach
  • Ensure the new solutions integration into the IT and business landscape as per the global standards by continuous interaction with IT and business SMEs
  • Develop best standards and practices to maximize the efficiency, effectiveness and overall quality of solution
  • Coordination with legacy application support team for resolution of unknown issues with permanent fix
  • Solution Environment
  • Mainframe - COBOL, JCL, DB2, CICS, ASSEMBLE, SAS, REXX, MQ series, Assembler Language, File-Aid, XPEDITER, STROBE, MQFTE, FTP, File-AID, SPUFI, SDF II, ENDEVOR, Quick Edit, Teradata SQL assist, IBM Utilities, Sync-Sort, ICETOOL, DFSORT, ZEKE, VSAM
  • IMS, DB2, Teradata
  • Web Technologies : Java, Javascipt, HTML, MQSQL
  • Project
  • Hunter Fraud Analysis
  • Customer

Mainframe Developer

Aviva UK
01.2015 - 06.2016
  • To tackle the menace of uninsured drivers and vehicles in United Kingdom, the government has mandated all insurers to send the report to Motor Insurance Database (MID)
  • This project intends to collect all drivers, Vehicles and Policy details downstream to Fraud Inspection, Business Requirement Gathering, Analysis of legacy system and conversation of Business Requirements to technical specifications like high Level and low-level design documents
  • Impact Analysis: Unit Test Plan and Integration of test plan creation beneficial to develop/validate/maintain the application as per business requirements
  • Software Development using Supra and Mainframe DB2, COBOL, JCL, CICS AND activities validation using the plan
  • Solution Environment
  • Mainframe - COBOL, JCL, DB2, CICS, ASSEMBLE, SAS, REXX, MQ series, Assembler Language, File-Aid, XPEDITER, STROBE, MQFTE, FTP, File-AID, SPUFI, SDF II, ENDEVOR, Quick Edit, Teradata SQL assist, IBM Utilities, Sync-Sort, ICETOOL, DFSORT, ZEKE, VSAM
  • IMS, DB2
  • Project
  • Credits Table Enhancement
  • Customer

IBM Content Manager

Aviva UK
04.2013 - 12.2014
  • Is a document depository in Aviva UKGI and Aviva UKHS employees which manages large scale range of documents across the organization
  • Role

Education

TCS Most valuable contributor - Mechanical Engineering

Biju Patnaik University of Technology

undefined

TATA Consultancy Services Canada Inc
01.2022

Bachelor of Technology - undefined

TATA Consultancy Services Ltd
04.2018

undefined

2012

Accomplishments

  • ERP GEAC Application – Application Development
  • Customer
  • Element Corp Inc
  • Period & Location
  • July 1st 2020 - Jan 17th, 2022 Mississauga, Ontario
  • Description
  • Element Fleet runs its Financial ERP application for Account Payables (AP)
  • Account Receivables(AR) and General Ledger(GL) modules on Mainframe based GEAC System
  • The objective of this project is to gather and document complete details of processes, data models, customization that are supporting current business functions un these applications.

Timeline

Mainframe Developer

Period
10.2016 - 06.2020

Mainframe Developer

Aviva UK
01.2015 - 06.2016

IBM Content Manager

Aviva UK
04.2013 - 12.2014

Mainframe Developer

Aviva Canda

Mainframe DB2 Developer

TCS Most valuable contributor - Mechanical Engineering

Biju Patnaik University of Technology

undefined

TATA Consultancy Services Canada Inc

Bachelor of Technology - undefined

TATA Consultancy Services Ltd
Anuj Agrawal