Data Project

PROFESSIONAL OVERVIEW

Established technical professional with 8+ years of experience across the manufacturing and health insurance industries in various application development roles.

Primary focus on Mainframe development utilizing COBOL, VSAM, JCL, CICS, MQ, and ESP.

Secondary focus on Database development and design utilizing Teradata, DB2, IMS, Oracle, and SQL Server.

Excellent team player capable of working cross-functionally across multiple domains, while also maintaining the ability to take multiple tasks and run with them independently.

TECHNICAL SKILLS

Programming Languages: COBOL, REXX, C, SAS

RDBMS: DB2, IMSDB, Oracle Teradata

Analytical Tools: Tableau

Operational Tools: CA7, MQ, Endevor, ESP, RTC, HP Service Manager, HP QC

PROFESSIONAL EXPERIENCE

SDLC Partners

Highmark Health Solutions

Mainframe Developer/Consultant (February 2018 – Till date)

EDW (Enterprise Data Warehouse) – Data Management, Data Security, Data staging, and Data Integrity

Built, tested, reviewed and deployed scalable, highly available and reliable software products using SQL queries on Teradata and Mainframe

Implementing the new database designs to provide better results by considering various parameters like Indexes, Skew factors from Database side.

Working on Terada utilities which will provide the better results on exporting and importing data from various files systems and loading into the target database.

Identified and re-designed PI (Primary Indexes) to reduce HOT AMP operation

Implemented JI (Join Indexes) and AJIs (Aggregated Join Index) appropriately resulted in better execution plan, response time and better savings in CPU and IO.

Executing the various query explanation plans and compare with existing database designs

Configured metadata objects (Subject Area, Table, Column, and PPI’s) and various servers from database side.

Data cleansing, Data modelling, Data validation and Data classification using SQL

To lead, train and manage offshore developers to complete quality work with given timelines

Developed various Inbound and Outbound processes to receive/transmit data after transformation using business rules

Attended daily stand ups and created stories and tasks for each sprint

Client engagement for Integration and UAT testing

To improve performance of existing system by identifying bottle necks and fixing issues

To document the reports and logs so those could be used in future for similar issues

Tata Consultancy Services

Fiat Chrysler Automobiles (FCA)

Application Development Consultant (January 2016 – February 2018)

Applications support and development, implementation and release management.

Gathering requirements from business and validating the requirements with Subject Matter Experts (SME) in providing design documents.

Preparation of low-level design and unit test case documents.

Development of the application based on requirement and design documents that are approved by Fiat users.

Unit testing of developed code and capturing the results in unit test results document which is submitted to users for approval.

Deployment of the code into Chrysler test environment for User Acceptance Testing (UAT).

Fixing bugs created in system testing and UAT.

Defect logging: Log design, coding and testing defects in defect Logger for quality purpose.

Weekly status call conducted to discuss day-to-day status updates and reviewing the current business issues with ICT and business.

Tata Consultancy Services

Fiat Chrysler Automobiles (FCA)

Application Development Analyst (September 2010 – December 2015)

Project: Design and Development of e-Logistics Extended Enterprise Network and Shipment Tracking Analysis & Reporting System for Fiat Chrysler Automobiles, Pernambuco, Brazil

Requirements study, system design, application development, implementation, testing and release management.

This project is designed to enable track and trace of inbound transportation for the FCA Pernambuco plant.

Implementation of the eLEEN and STARS systems will accurately capture the movement of product from suppliers to the plant. These systems along with their associated processes will assist in the selection of the best providers, while generating electronic load tendering and track/trace functionality to execute the optimized shipment with the select carrier.

Discussions with Fiat & Chrysler Subject Matter Experts (SME) based on the System Requirements Document to cover the functionality, technical issues and scope of work. Estimation of the software development effort.

Analysis and evaluation of alternatives to formulate the mode of implementation of the system.

Process Improvement Implementations involved following the industry standard process for improving the process like developing all project related documents and updating the Transition Handbook for all the changes being made to the application as a part of the project.

EDUCATION

Bachelor of Technology in Electronics and Communications Engineering

Anna University, Chennai, India

Graduated in June 2007

Aggregate of 83%

Contact this candidate