Vijayasekhar Chengalrayappa

Contact# +1-980-***-****

Visa Status: Green Card Holder

Profile

15+ Years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.

Extensive experience with analysis, design, development, customization and implementation of software applications.

Proficient in analyzing and translating business requirements to technical requirements and architecture.

Strong database skills like IMS, IDMS, DB2, TERADATA, Vertica and Hadoop/Hive, SQL server and Eazytrieve Programming and development knowledge.

Experience in using the tools like IBM Data stage, Informatica (Power center), Talend Data Integration 7.x, HP Dialogue Exstream, Coolgen and other IBM Mainframe tools like File-aid, Xpeditor, Panvalet, Pegasys, Spufi.

Experience in leading and managing teams. Handled multiple roles – Project Lead, Software Architect, and Developer.

Executed software projects for Automotive, Healthcare, Retail and Insurance industries

Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Educational Qualification: Masters(MTech) from Birla Institute of Technology

Skill Set

Languages: IBM Mainframes/Cobol, Eazytrieve, Python, AWS, Focus and CICS.

HDBMS: IMS (Information Management System)

NDBMS: IDMS (Integrated Database Management System)

RDBMS: DB2, TERATADA, VERTICA, Oracle, Hadoop (Hive) and SQL Server

Tools: IBM Data stage, Informatica (Power center), Talend, HP Dialogue Exstream,

Coolgen, Cognos, File-aid, Xpeditor, Panvalet, Pegasys, Spufi, Rexx.

O/S: OS/390, UNIX, Windows NT/2000 Server

EAI: WBI (Web Sphere Business Integrator)

Processes: IBM’s QMS (Quality Management System)

Certifications:

PMI Certified PMP

IBM Certified Application Developer – Cloud Platform V2

Teradata 12 Certified Professional

Teradata 14 Certified Professional

IBM Accredited Senior IT Specialist

IBM Leader Readiness Program

AWS Certified Solutions Architect – Associate

Microsoft Technology Associate: Introduction to Programming using Python

Awards:

Bravo Award from Nationwide Customer, IBM, Columbus, OH

Certificate of Excellence from Nationwide Customer, IBM, Columbus, OH

Hard work & Dedication Award for successful implementation of 3D Vision Interfaces at Mervyns’ from Syntel India, Mumbai, India.

Excellent Service Award from Syntel India, Mumbai, India

Professional Experience

Oct. 2021 – Till Date, Senior Application Developer, CVS Health, Richardson, Texas

As a Senior Application developer, responsible for Analysis, design, development, testing and implementation of the solutions for BI area of CVS Health PBM Application for PHI and Financial information of end users.

Responsible for development, testing and implementation of BI software applications mainly deal with Unix, Teradata,Informatica and IBM Mainframes(COBOL,DB2,JCL). Also, responsible to improve data reliability, efficiency and quality of the CVS Health client applications i.e. PBM Datawarehouse for CET PAL Audit extractions.

Works with data and analytics experts to strive for greater functionality in the data systems and builds the process required for optimal extraction, transformation, and loading (ETL) of data from a wide variety of data sources using SQL Server and Informatica power center.

Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Plays a key role in maintaining optimal data pipeline architecture by using the domain expertise, technical knowledge, analytical, critical thinking and problem-solving skills gained during the tenure.

Responsible for Incident handling, Problem Ticket Handling, Participating RCA (Root Cause Analysis), Implementation of permanent fixes and Application monitoring and System check of the CVS Health PBM applications related to Unix, Informatica and Teradata technologies.

Additionally, provides active support and resolution for User Acceptance Testing, Operational Readiness testing, any business impacting production issues and outages.

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

Environment: UNIX, Informatica,Teradata and IBM Mainframes(COBOL,DB2,JCL).

Oct. 2019 – Sep. 2021, Senior Application Developer, FCL, Saskatoon, Canada

As a Senior Application developer, responsible for Analysis of defects raised from implementations of the various projects, design, development, testing and implementation of the solutions for BI area of our IBM Canada customer i.e. FCL (Food co-op Limited), Saskatoon, Canada.

Responsible for development, testing and implementation of BI software applications mainly dealing with Unix, Teradata, Informatica, SQL Server and Python. Also, responsible to improve data reliability, efficiency and quality of the FCL client applications i.e. ECOMM platform and it’s sub-applications like OMS (Order Management System).

Responsible for fixing bugs in the backend IBM Mainframes applications which involve COBOL, DB2 and VSAM.

Works with data and analytics experts to strive for greater functionality in the data systems and builds the process required for optimal extraction, transformation, and loading (ETL) of data from a wide variety of data sources using SQL Server and Informatica power center.

Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Plays a key role in maintaining optimal data pipeline architecture by using the domain expertise, technical knowledge, analytical, critical thinking and problem-solving skills gained during the tenure.

Responsible for Incident handling, Problem Ticket Handling, Participating RCA (Root Cause Analysis), Implementation of permanent fixes and Application monitoring and System check of the FCL applications related to Unix, Informatica, Teradata, Python and SQL server technologies.

Additionally, provides active support and resolution for User Acceptance Testing, Operational Readiness testing, any business impacting production issues and outages.

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

Environment: UNIX, Informatica, Teradata, IBM Mainframes(COBOL,DB2,VSAM,JCL), SQL Server and Python.

March 2014 – Sept.2019, Senior Application Developer, DirecTv, California, US

As a Senior Application developer, responsible for Analysis of defects raised from implementations of the various projects, design, development, testing and implementation of the solutions for BI area of our IBM US customer Directv, California.

Responsible for development, testing and implementation of BI software applications mainly deal with Unix, Hadoop, Hive, Informatica, Teradata and Vertica technologies. Also, responsible to improve data reliability, efficiency and quality of the AT&T client applications i.e. Product Management and it’s sub applications like DirecTV monitoring system (Setup box information) and Audience monitoring system(viewership).

Works with data and analytics experts to strive for greater functionality in the data systems and builds the process required for optimal extraction, transformation, and loading (ETL) of data from a wide variety of data sources using SQL server and ‘big data’ technologies. .

Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Plays a key role in maintaining optimal data pipeline architecture by using the domain expertise, technical knowledge, analytical, critical thinking and problem-solving skills gained during the tenure with DirecTv.

Keeps the data separated and secure across national boundaries through multiple data centers and Cloud regions by putting various layers of protection or by using Data Masking Algorithms.

Responsible for Incident handling, Problem Ticket Handling, Participating RCA (Root Cause Analysis), Implementation of permanent fixes and Application monitoring and System check of the DirecTv applications related to Hadoop, Hive, Informatica, Teradata and Vertica technologies.

Works with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.

Additionally, he will be providing active support and resolution for User Acceptance Testing, Operational Readiness testing, any business impacting production issues and outages.

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

Environment: UNIX, Informatica, Teradata, Hadoop, Hive, Vertica, Cognos and SQL Server.

June 2013 – March 2014, Associate Project Manager, Maersk Line, Demark

Maersk Line, the global containerized division of the A.P. Moller – Maersk Group, is dedicated to delivering the highest level of customer-focused and reliable ocean transportation services. My role is as follows:

Responsible for leading the team and helping the team in technical aspects related to Mainframe and Teradata technologies related to Teradata and MSBI Applications of Maersk Line, Denmark.

Responsible for maintaining the co-ordination between on-site (Denmark) and off-shore teams.

Responsible for translating customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Responsible for assisting the Project Manager in forecasting the budget and resource allocations appropriately.

Responsible for approving the timesheets and billing related requests on behalf of Project Manager.

Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: IBM Mainframes, Teradata, MSBI (SSIS, SSRS, SSAS with MDX) and MPP (Microsoft Project Profession).

Dec 2012 – June 2013, Senior Software Engineer, Marsh, London, UK

GIS (Global Information System) Accounting is responsible for tracking all of the fiduciary receivables and payables for Guy Carpenter in USA and Marsh in the UK. The GIS Accounting System facilitates tracking and processing of information related to clients’ and markets’ premium and loss transactions: recording receipts, applying cash, creating disbursements, maintaining account balances, recording collection efforts, customizing statements, printing reports, etc. My role is as follows:

Responsible for Analysis, design, development, testing and implementation of GIS software Applications mainly IBM Mainframes like COBOL, DB2, VSAM, IDMS, Teradata and ORACLE applications. .

Responsible for leading the team and helping the team in technical aspects related to IBM Mainframe, Teradata and ORACLE technologies related to Marsh Insurance, London, UK.

Utilize in-depth knowledge of functional and IBM Mainframe Technical experience in conjunction with industry and business skills to deliver solutions to customer.

Investigated causes of SLA non-conformance with profilers, Oracle traces and SQL-LAB.

Environment: IBM Mainframe (COBOL, VSAM, DB2, IDMS, Teradata, JCL) and ORACLE.

June 2012 – Sept. 2012, Senior Software Engineer, Wintek Solutions, Columbus, OH, USA

Limited Brands, Inc. operates as a specialty retailer of women’s intimate and other apparel, beauty, and personal care products and accessories primarily in the United States and Canada. The company, formerly known as The Limited, Inc., was founded in 1963 and is headquartered in Columbus, Ohio. My role is as follows:

Responsible for development, testing and implementation of EDW software Applications mainly deal with UNIX and Teradata Applications.

Work with Business Analysts and Designers in translating business requirements into System requirements.

Written several UNIX Scripts for Teradata BTEQ scripts to implement the business logic.

Worked exclusively with the Teradata SQL Assistant to interface with the Teradata

Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee the acceptance and dissemination process.

Environment: UNIX, NCR Teradata 12, BTeq, Mload, Fast Load, Tpump, Informatica, Teradata SQL Assistant

Feb. 2003 – Jun 2012, Software Developer, NATIONWIDE, Columbus, OH, USA

Nationwide is one of the largest insurance and financial services companies in the world and it provides a full range of products and financial services that include Auto, Fire, Life, Health, and Commercial Insurance; Administrative Services, Annuities, Mutual Funds, and Retirement Plans. My role is as follows:

Responsible for Analysis, design, development, testing and implementation of Billing-Output software Applications mainly IBM Mainframes like COBOL, DB2, VSAM, CICS, IBM Data stage,HP Dialogue tools and Teradata applications.

Worked on loading of data from several flat files sources to staging area using IBM Mainframes with Teradata MLOAD, FLOAD, TPUMP and FASTEXPORT Utilities.

Worked on Tuning, and troubleshooting Teradata system at various levels

Written several Teradata BTEQ scripts to implement the business logic.

Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Utilize in-depth knowledge of functional and IBM Mainframe Technical experience in conjunction with industry and business skills to deliver solutions to customer.

Environment: IBM Mainframe (COBOL, VSAM, DB2,CICS, JCL), IBM Data stage TX and HP Dialogue, Teradata.

Achievements: Received a BRAVO Award from NW Project Manager for dedication and hard work shown in resolving the issues during implementation of various projects.

Training:

Project Management at IBM India

IBM Leader readiness Program.

IBM Accredited Senior IT Specialist

Teradata DBA

Informatica CAI Course completion at IBM India

Informatica B2B Course completion at IBM India

Contact this candidate