Amirtharaj D.

Amirtharaj D.

Senior Data Engineer

Chennai , India

Experience: 19 Years

Amirtharaj

Chennai , India

Senior Data Engineer

34698.6 USD / Year

  • Notice Period: Days

19 Years

Now you can Instantly Chat with Amirtharaj!

About Me

  • Overall 18+ years of experience in IT industry with AWS Cloud Exposure, Big Data, Technologies, Data migration (Data pipeline, Data Layer), Query optimization, Legacy modernization, Application Development, production support.
<...

Show More

Portfolio Projects

Description

Employer

DXC Technologies

Customer

Lloyds Insurance

Period

Oct 2020 – Till Date

LOB

Insurance

Description

Lloyd’s is an international insurance marketplace. The insurance and reinsurance transacted at Lloyd’s is primarily for large, specialist risks which most insurers elsewhere in the world are unable or unwilling to cover.T his half day, foundation level program will provide delegates with a sound level of understanding of the function of insurance and an overview of the various organizations which are part of the Lloyd’s insurance market.

The program will also highlight the various lines (classes) of business which are transacted in the Lloyd’s market and the methods by which suitable insurances are set up.

Role & Responsibilities

As a Data Analyst, used to created AWS GLUE job setup and Migrate data from different data source to redshift, Create AWS glue catalog with crawler table definitions pointing S3 and few with multiple data sources, configured for getting updates as different versions. Prepare & schedule Glue job as time & event triggered. Used to get notification through SNS by setting up cloud watch monitor for failure in production and fix it on-demand. Create jobs in AWS Glue using Glue Data studio also in hybrid mode, Customize and transform code to Redshift from S3, create metadata Entries using crawlers connected to S3 bucket. Setup notification in CloudWatch for the job failures, schedule job as time trigger and event trigger.

Tools & Technologies Used

AWS GLUE, AWS Athena, Redshift, SQL Workbench Cross platform query tool, Cloud watch

Show More Show Less

Description

Employer

DXC Technologies

Customer

Dominion Energy (Earlier SCANA Corporation, SC, U.S. A

Period

Sep 2016 – Oct 2020

LOB

Energy & Utility

Description

A Fortune 500 company, Dominion Energy is a Utility company based in U.S covering 7 states involved in Generation, Transmission & Distribution of Electricity & Gas to Industrial, Commercial & Residential customers. Initially worked in AMI (Automated metering Interface) to roll out all meter with smart meter. SCANA Corporation was using Teradata as DWH tool, Teradata SQL Assistant tool used to do analysis on data and generating report. SQLSERVER from which the data will be migrated to Teradata as per the purge criteria. We have replaced the Teradata DWH with the Hadoop HDFS. Created similar scripts shell scripts and scheduled in oozie. The same data will be migrated to HDFS using SQOOP as data ingestion tool to extract data from SQLSERVER. The Teradata tables are created in the HIVE metadata repository.

Role & Responsibilities

Module Lead & Individual Contributor, for 6 members team in AMI Module, Created SQL stored procedures in SQL Server to report the progress of the meter replacement. Also send reports to user and on-demand details to manufacturers. Delegate and cascade Task among team members for creating scripts.

Involved in writing query & query optimization in HIVE to send from OLTP data to HDFS. Created shell scripts for data migration and scheduled in OOZIE

Tools & Technologies Used

Hadoop, HDFS, Map Reduce, HIVE, Sqoop, Linux, Microfocus, SQL Server, Python Programming, TFS, CA workload for automation, OOZIE, GIT Libraries, AWS EMR

Show More Show Less

Description

Employer

DXC Technologies

Period

Apr 2015 – Aug 2016

Customer

FORD NA

LOB

Manufacturing

Description

Order Management System: Deals with creation and updating of the order based on the purchase order received and deals with payments for the orders. Entire life cycle of the order will be managed here for spares. Also provide Production support for the OMS ford NA.

Ford Incentives: VINCENT is a system that administers and manages all aspects of vehicle incentives. Although most incentive programs are designed to encourage customers to buy our products, some programs are designed to encourage dealers to order and stock vehicles.

The VINCENT system is comprised of on-line applications, an overnight batch process and a payment system. VINCENT interfaces Ford Credit and certificate vendors taking feeds or using their databases as master files.

Role & Responsibilities

Developed COBOL DB2 programs. Facilitate sprint planning, daily scrums, retrospectives, stakeholder meetings, and software demonstrations. Work closely with project owner in backlog management and continuous delivery of features.

Educate and reinforce scrum methodology and agile framework to team members and key stakeholders. Direct and lead development team from project initiation through delivery of final product. Prepare metrics from Rally tool for burn down report.

Facilitates scrum team to agree DOD for the different stages on sprint.

Tools & Technologies Used

COBOL, DB2, IMS DB/DC, CICS, JCL, RALLY 2.0, Ezytrive, Endevor, Data Studio, CICS Explorer

Show More Show Less

Description

Project Title

My HR Time Keeping, South California, U.S. A

Employer

DXC Technologies

Customer

Kaiser Permanente

Period

Oct 2011 – Oct 2012

LOB

Health Care

Description

My HR Time keeping is a HR application. Collecting the time Entries of non-prompt employees of KP. This system will collect the time entries from IVR boxes from various locations and consolidate the time with all the additional pay and taxes applicable to corresponding region and shift timings they worked and approve the timecard before sending those to People soft for payroll generation.

This payroll generation is Bi-weekly process and it’s having daily, hourly and monthly jobs to be monitored and enhancements in parallel

Role & Responsibilities

Module Lead had ownership of smooth running of jobs and delegating the Enhancement work to team member to Deliver it on time. Make sure the payroll generation properly for the bi-weekly SCAL & NCAL region. Enhancing and bug fixing of salary related issues based on the incident logged.

Solution Environment & Tools

IBM Mainframe, Platinum for DB2, Abend-aid, File-aid, Endeavor, Change Management, Adv Gen (Case Tool), Endeavor (Configuration management tool), Xpeditor (for debugging), Abend-Aid, File-Aid, Platinum (for DB2), DB2 Connect, Query Management Facility (QMF), Microsoft

Show More Show Less

Description

Employer

TCS

Customer

JCPenney Corporation, Minneapolis, U.S. A

Period

Mar 2009 – Oct 2011

LOB

Retail

Description

Finance Payment and Procurement Portfolio: JCPenney, a general merchandise & apparel retailing giant offers a wide array of national, private and exclusive brands, with commitment to providing customers with style and quality at smart prices. The Finance, Payment & Procurement Portfolio is comprised of a group of applications designed to support and promote the effective and efficient management of Corporate Operational and Financial objectives. This Portfolio is used across all Business lines in Merchandising and Finance. The Applications are used to capture, track, compute and report operational activities across the business and are used to support decision making by the Stakeholders & Clients.

Role

As a Tech lead, Leading Enhancement and production support of FPP application, prepare shift roaster, Ensure Escalation procedure, manage deliverables, Defect Prevention, SLA monitoring, Metrics & Initiate bridge calls during crisis. Participate in CAB meeting for change approval.

Tools & Technologies Used

IBM Mainframe, Softech, Platinum, File-aid, Endeavor, Change Management, CICS, MS-Office, J2EE, DB2Connect V8.1 and Oracle Client, WebSphere Application Server V6.1, Teradata, DB2 Connect, DYL280, Ezytrive

Show More Show Less

Description

Employer

TCS

Customer

Target Corporation, Minneapolis, U.S. A

Period

Jun 2008 – Mar 2009

LOB

Retail

Description

CA-Gen rewrite for Supply Apps: Target has many of its legacy replenishment, pricing and planning systems written in the ADGEN technology. To achieve scalability in terms of technology to support the business growth envisioned, Target has decided to do away with ADGEN and rewrite these applications in new technologies viz. J2EE/SPRINGS. The supply CA Gen sunset program will support Target’s growth by ensuring infrastructure is maintainable while reducing TTS operational costs. This will be accomplished by eliminating outmoded CA Gen from Target Supply applications.

Role & Responsibilities

Team Member, Rewrite Cobol programs in CAGEN(Coolgen) and testing those with stored procedures setup by passing inputs manually.

Tools & Technologies Used

IBM Mainframe, Platinum for DB2, Abend-aid, File-aid, Endeavor, Change Management, Adv Gen (Case Tool), Endevor (Configuration management tool), Xpeditor (for debugging), Abend-Aid, File-Aid, Platinum (for DB2), DB2 Connect, Query Management Facility (QMF)

Show More Show Less

Description

Project Title

Pharmacy Receivables SOX Remediation (Target – Finance)

Employer

TCS

Customer

Target Corporation, Minneapolis, U.S. A

Period

Nov 2007 – May 2008

LOB

Retail

Description

Target Corporation is a general merchandise retailer in the USA. The principal operating strategy is to provide exceptional value to American consumers through multiple retail formats ranging from upscale discount and moderate-priced to full-service department stores. Target is an upscale discount chain with stores across the country, providing quality merchandise at low prices.

The completion of this project PRSR will achieve the following business goals:

  • Eliminate SOX deficiency for general ledger to subsidiary Pharmacy Accounts Receivable ledger differences
  • Balance all subsidiary ledger (AR) activity to general ledger activity, resulting in a reconciled sub-ledger (AR) and general ledger.

The above business goals will be achieved by introducing one new Reference table to keep track of changes in pharmacy unapplied cash table and adding two new columns in pharmacy unapplied audit table.

Role & Responsibilities

Team Member, Enhance/Develop mainframe and coolgen application programs and DB activities also used to prepare Ezytrieve Reports.

Tools & Technologies Used

IBM Mainframe, Platinum for DB2, Abend-aid, File-aid, Endeavor, Change Management, Adv Gen (Case Tool)

, Endevor (Configuration management tool), Xpeditor (for debugging), Abend-Aid, File-Aid, Platinum (for DB2), DB2 Connect, Query Management Facility (QMF)

Show More Show Less

Description

Employer

TCS

Customer

Target Corporation, Minneapolis, U.S. A

Period

Mar2007 – Oct2007

LOB

Retail

Description

With the opening of a Target Food RDC, random weight items will be processed through Target RDCs for the first time, requiring changes to systems. Random weight product includes items such as t-bone steaks, bone-in roasts, turkeys and deli meat. The invoices for these items must be paid based on the actual weight received at the DC and not the item VCP on file. Since the actual weight of each carton will vary, the DCs will not hold inventory at the actual case weight for random weight items. To maintain a more accurate financial and unit inventory visibility for these items, changes would be required to several Target systems. The current systems were built with the assumption that the case-pack will be a whole number, and that it will be consistent over time.

Role & Responsibilities

Team Member, Enhance / Develop mainframe and coolgen application programs and DB activities also used to prepare Ezytrieve Reports.

Tools & Technologies Used

IBM Mainframe, Platinum for DB2, Abend-aid, File-aid, Endeavor, Change Management, Adv Gen (Case Tool)

, Endeavor (Configuration management tool), Xpeditor (for debugging), Abend-Aid, File-Aid, Platinum (for DB2), DB2 Connect, Query Management Facility (QMF).

Show More Show Less

Description

Project Title

Target – Project Access

Employer

TCS

Customer

Target Corporation, Minneapolis, U.S. A

Period

Jun 2006 – Feb2007

LOB

Retail

Description

The Project ACCESS will support the ability to process two new tenders RED vantage and WIC EBT, and automatically handle the Approved products list from Texas.

This project translates Daily Sales Audit (DSA) to accept two new tender types of RED vantage card and WIC EBT card. The RED vantage card will simulate the process of an existing Debit card and check process, and the WIC card follows the process of an Electronic Benefits Transfer (EBT) card.

This project also automates the process of accepting the Approved Product List (APL) from Texas State Government for WIC EBT card to make it available at the POS.

Role & Responsibilities

Team Member Enhance mainframe and coolgen application programs and DB activities.

Tools & Technologies Used

IBM Mainframe, Platinum for DB2, Abend-aid, File-aid, Endeavor, Change Management, Adv Gen (Case Tool), Endeavor (Configuration management tool), Xpeditor (for debugging), Abend-Aid, File-Aid, Platinum (for DB2), DB2 Connect, Query Management Facility (QMF)

Show More Show Less

Description

Project

Freescale Semiconductors (Motorola).

Employer

L&T Infotech

Customer

Freescale Semiconductors.

Period

May2004 to May2006.

LOB

Sales & Marketing, Logistics

Description

This project is executed for Freescale Semiconductor (Motorola) a Semi-conductor manufacturing giant headquartered in Phoenix, USA with users of the system all over the globe.

There were four main modules viz. Demand Management, Inventory, Logistics, and Finance. Demand Management module mainly deals with Order Processing. The production support and application maintenance is accomplished in a typical onsite-offshore model. Production problems (Break fix) are recorded in a custom-made web site that is monitored round the clock. Time to respond and Time to fix production problems are bound by Service Level Agreements (SLAs). Time to repair problems range from One hour for critical stop problems to 8 hours for low impact problems. Work Requests are enhancement/ modification requirements that are worked on by Subject Matter Experts at offshore.

Role & Responsibilities

Team Member, created stored procedures using Coolgen code and COBOL-DB2 programs, Generate PO on-demand for users

Tools & Technologies Used

  • Cool Gen, Endevor, File Aid, SPUFI, Xpeditor , Platinum , CEACCESS , IMS COPE, Remedy, PTS.COBOL, JCL,DB2

Show More Show Less

Description

Customer

United Services Automobile Association.

Period

Sep2003 to Feb2004

LOB

Insurance

Description

The “Old” to “New” conversion routines will be implemented to convert the loss reports from the legacy claims database to ARP-Claims database. The “Old” to “New” conversion routines will be designed in such a way that they can run in batch or on-line modes. Batch cycles will be used to handle conversion of large numbers of losses. The on-line mode will be used to handle single loss conversions. Single loss conversions will be needed when a user needs to review loss data for a loss report that has not been processed through the batch processes. The conversion routines will also be used when a loss in the old format is restored from tape archives.

Role & Responsibilities

Newly developed IMS-DB programs to transform the structure of data collected in Master craft tool using Pearl C program.

Tools & Technologies Used

Mainframe, JCL, IMS-DB, Data Vantage, SPUFI, File-Aid, Librarian.

Highlights

  • Attending meetings and discussions with clients for requirements gathering.
  • Preparing design specs and process related documents.
  • Preparing test data and documents.
  • Successfully mapped data between IMS-DB and C++ structures.
  • Developing new programs in IMS-DB with different Get function codes and command codes.
  • Ensuring quality standards and guidelines in the project
  • Stick with deadlines and implemented successfully.

Show More Show Less