Senior Mainframe Developer/Architect

** ***** ** ***** *.T experience (5+ years at onshore)

EXECUTIVE SUMMARY

Around 13 years of development experience in Information Technology industry predominantly on mainframe and Database technologies. Worked in various capacities such as Project Lead, Senior Developer, SME, Database Administrator and Legacy modernization Architect.

Had direct interaction with the Business users and worked together with them in requirement gathering, validate user testing and release planning.

Strong experience in project life cycle, starting from requirement analysis, estimation, design, coding, testing, implementation, and post implementation activities.

Strong exposure in solving escalated issues (technical and design oriented) and identifying appropriate solution thereby saving several millions of dollars.

Having good experience analyzing existing process and identifying areas of the application where the performance can be improved, thereby saving several millions of dollars in infrastructure costs.

Good working knowledge of major Z/OS, Linux, and Zlinux Operating Systems

Strong Knowledge in COBOL, VSAM, JCL, DB2, CICS, IDMS, IMS and Legacy modernization strategies.

Identified DB2 tuning was required and accordingly worked on the construction of DB2 queries to improve the performance of the process.

Designed the solutions from end to end for three Legacy modernization projects from legacy systems to DB2/Modernization and implemented successfully for many failed projects.

Proficient in creating Training Manual & User Guides

Hands-on experience in Data Modelling and performance tools.

Ability to thoroughly design and code system’s functional requirements, and construct with minimal or no defects and implement the same.

Ability to handle multiple tasks and work independently as well as in a team.

Good team player with excellent written, verbal communication and interpersonal skills. Proficient in coding standards, which will result in better performance of the code.

Expertise in manual testing. Working knowledge in Test Management tool Squids.

Open to suggestions and ideas from teammates/seniors. Work with the highest standards of integrity and trust

PROFESSIONAL EXPERIENCE

Total 13 years of I.T. experience on Mainframe and database technologies with extensive proficiency in COBOL, VSAM, DB2, JCL, CICS, Eazytrieve, Sync Sort, DF Sort, IDMS, CA-Platinum, Xpediter, File-ID, SPUFI, Legacy Modernization, Data Technologies, SQL Server, Data Modelling, and Data Administration.

Domain: - Manufacturing services (Ford Motor Company, MI, USA)

Role : Sr. S/W developer/Architect

Company: Cognizant.

1)Project: GOTD – Scheduling Jan 2016 – Till date

Description: Ford Motor Company, is an American multinational automaker that has its main headquarters in Dearborn, Michigan, a suburb of Detroit. It was founded by Henry Ford and incorporated on June 16, 1903. The company sells automobiles and commercial vehicles under the Ford brand, and most luxury cars under the Lincoln brand. Ford also owns Brazilian SUV manufacturer Troller, an 8% stake in Aston Martin of the United Kingdom and a 32% stake in Jiangling Motors. It also has joint-ventures in China (Changan Ford), Taiwan (Ford Lio Ho), Thailand (AutoAlliance Thailand), Turkey (Ford Otosan), and Russia (Ford Sollers). The company is listed on the New York Stock Exchange and is controlled by the Ford family.

GOTD – Scheduling is a project within GOTD (Global order to delivery platform) with the goal to convert legacy systems database using legacy database over to DB2 and SQL server. As part of this project, legacy systems will be converted to DB2/SQL server with microservices and COBOL batch programs. This involves modifying and integrating existing legacy regional systems to global integrated system. Also new GOTD systems aims to improve existing systems scheduling solutions for manufacturing.

Environment: MVS, z/OS, COBOL, DB2 12.0, SQL Server, IMS, IDMS, JCL, CICS, File-AID, SPUFI, ISPF, VSAM, Xpeditor, Abend-AID, Linux, PCF, Alteryx, Qlikview, Java Microservices.

Responsibilities:

Create data mapping documents and database design for existing and new systems used by teams.

Create automated workflows in COBOL, Alteryx, R, Python, Qlikview and Tableau to compare data between legacy systems and new GOTD systems and make sure data is consistent across several systems.

Automate data corrections for any data mismatched detected between legacy & New GOTD systems and report to management for crucial business decisions.

Analyze existing and new systems for performance targets and make sure new systems are meet the performance targets. Saved the company a significant amount of money, about 3-5 million dollars per year in terms of infrastructure costs and legacy modernization improvements, which were highly recognized by Ford management.

Analyze the existing legacy calls and prepare the design document based on the relational database (DB2/SQL server) requirements.

Develop / modify the code as per requirements in DB2/SQL Server stored procedures, COBOL, JCL, Java Micro services, and batch programs to handle new requirements and perform the Unit Testing and compare the results for legacy and new DB2 requirements.

Domain: - Retail (Walmart, Bentonville, Arkansas)

Role : Project Lead/Technical Architect

Company: Cognizant

2)Project: SNE Finance (AP & AR) & DCS2K Migration April 2014 – Dec 2015

Description: The project aims to eliminate DCS2K VSAM files and convert the existing system to the order management DB2 database system. It is a legacy modernization project which failed many times in the past, costing Walmart several millions of dollars.

I worked as part of the logistics portfolio for the DCS2K elimination project, which interfaces with around 11 application systems.

Environment: MVS, z/OS, COBOL, DB2 9.0, IDMS, IMS, Cassandra, Teradata, HBase, Hadoop, R, JCL, CICS, File-AID, SPUFI, ISPF, VSAM, Xpeditor, Abend-AID, Java Spring.

Responsibilities:

Working as the Project lead for SNE Finance (AP & AR) and am responsible for delivering the DCS2K project from the logistics scope nearly 250+ newly developed COBOL components, medication of 800+ JCL batch jobs, 700+ batch programs, 250+ FTP interfaces, 80+ complex permanent scheduling changes, and migration of 5000+ Batch jobs.

Review and Sign-off delivery for deployments under logistics scope.

Prepared data mapping document, Data Model, Database design, data migration, and data validation strategies.

Worked with the Business users in all phases of the project from requirements to implementation. Goal was always to meet client expectations.

Preparation of design documents like SRA (System Requirement Analysis) and TSD (Technical Specification Design) based on business requirements and analysis.

Lead and guide the development team, supporting system build on COBOL, DB2, JCL and CICS technologies and mentor in case of any escalated issues or bottlenecks.

Prepare high-level designs, have meeting with architects and SME’s at onshore.

Prepare low-level design documents: coordinate with offshore for development.

Ensure new system meet performance expectations and provide technical solutions in case of any performance issues including escalated issues.

Implementation of projects, post-production verification, postproduction warranty support etc.

Domain: - Finance, Investment and Wealth Management (Bank of America Corporation, USA)

Role : Senior S/W developer/Technical Leader

Company: Bank of America Corporation.

3)Project: Managed Product Supervision June 2010 – Feb 2014

Description: This is a development project with legacy modernization. The single experience project aims to move away from the product-centric approach to a client-centric process in account management for high-net-worth individuals in USA. It is re-engineering of the existing Z/OS system to the high-end mainframe LINUX system. Also, this project integrates Merrill lynch wealth management system with Bank of America systems. The project supervises entire wealth management products for America's bank and ensures all managed products adhere to the US government's rules, regulations, and contracts. All Financial Advisers and wealth managers of Bank of America for their day-to-day activities use this platform. The corresponding Financial Adviser or Wealth manager will be informed and recommends corrective actions whenever legal rules are violated.

Environment: MVS, z/OS, COBOL, DB2, JCL, CICS, Rational Developer for System Z, File-AID, SPUFI, ISPF, VSAM, Xpeditor, Abend-AID, Java Web & Rest Services (Mainframe Linux).

Responsibilities:

Worked as a technical lead for a small team of 7 people.

Development Home office and Financial Advisor dashboards with supreme performance in DB2 (Native, COBOL and Java Stored procedures).

Understanding the requirements as per Business requirements Design document (BRD) and translate into high level technical and database design.

Worked on to develop COBOL code modules as well as CICS screens.

Reviews and signoff work done by junior developers.

Mentor, support and guide junior developers in case of any escalated technical issues.

Solve any escalated performance or technical issues from the team.

Domain: - Retail Banking (AXA Bank, Europe)

Role : S/W developer

Company: Tata Consultancy Services.

4)Project: Reengineering of Back office & Performance improvement Oct 2007 – May 2010

Description: The project's objective is to migrate all scattered legacy data into a single DB2 Database so that the new application REEBOC application can use it. With the successful completion of this project, all legacy applications were shut down and replaced with newly developed applications.

The project also aims to reduce the CPU consumption of mainframe applications and develop test environments for new applications post launch.

Environment: MVS, COBOL, DB2, JCL, CICS, File-AID, SPUFI, ISPF, VSAM, IMS, Xpeditor, Abend-AID.

Responsibilities:

Worked as a team member on different technical tasks and developed many Input-Output Modules.

Designed and coded the inventory batch module, which critical for the life of this project. The inventory batch module consists of 30000 lines of complex SQL and COBOL codes, excluding called modules. In addition, the batch has a time constraint to complete within 6 hours to calculate entire money within the bank and report to top management. Got handwritten appreciation from IT Director of AXA next to CTO.

Worked as Development DBA and Database Designer for this project.

Responsible for migration, validation, and integrity of data from legacy systems from IMS, IDMS, VSAM, Flat files to DB2.

Played a crucial role in developing, planning, and implementing data migration strategies with advice and inputs from AXA architects and SMEs.

Awards, Achievements and Recognition:

•Scored 25th rank in the Entrance Examination conducted by ANNA University all over Tamil Nadu out of 25000 candidates.

•Cleared national level talent search examination and won scholarships from Indian Government.

•Cleared many DB2 certifications, including IBM DB2 Advanced Database Administration, IBM Data Architect, and IBM Big Data architect, which only very few people in the IT industry can obtain in a lifetime.

•Cleared project + Certification from CompTIA for project management.

•Cleared five master-level certifications from the brain bench, including DB2 OS/390, DB2 UDB, JCL, RDBMS concepts, and Data modeling.

•Received a hard copy written appreciation certificate in person from the IT Director of AXA for my contributions to the Re-engineering of the Back Office Operations project, cost savings and performance tuning for my technical competency.

•Received three silver awards and one bronze award in total as part of Bank of America universal recognition program for every year back-to-back for my contributions to Bank of America in performance tuning and infrastructure & CPU consumption cost savings worth several millions of dollars.

Certifications:

I completed following certifications and licenses.

•Microsoft Certified Professional – Designing Database solutions for SQL Server.

•PMI- Agile Certified Practitioner

•IBM Certified Data Architect – Big Data

•IBM Certified Advanced Database Administrator

•IBM Certified Big Data Architect

•IBM Certified Database Administrator Version 11 Upgrade

•IBM Certified Application Developer

•IBM Certified Database Associate

•IBM Certified Database Administrator Z/OS

•IBM Certified Database Administrator

•IBM Certified Database Administrator

•IBM Certified Web Sphere Studio Application Developer

•Five master-level certifications from brain bench.

•CompTIA Project+

•NCFM in Financial Markets

Declaration:

The above information is true to my best knowledge & belief.

Yours faithfully,

Senthilkumar Mathiyazhagan

adjkeg@r.postjobfree.com

adjkeg@r.postjobfree.com

+1-479-***-****

TECHNICAL SUMMARY

Languages: COBOL, JCL, PL1, CICS, Rexx, Easytrieve, Mainframe SAS, SQL, NoSQL, R, Python, Kafka, Java Spring Boot, Java ( Mainframe).

Database: DB2, VSAM, IDMS, IMS, SQL Server, Cassandra, Hadoop, Hbase

Online Transaction Processing: CICS, REST/Web Services (Both Mainframe & Linux).

Tools and Utilities: Expeditor, File-Aid, Omega Mon, Endeavor, Detector, Strobe, RDX, Dimensions, Platinum, Data studio, DB2 Connect, SQLDBX, DFSSORT, Rational Developer for System Z, CA7, BMC tools, and Performance tuning tools, IBM Big Insights, Alteryx, Tableau, QlikView, Performance Monitoring Tools, Data modeling, Analytics & Visualization tools.

EDUCATIONAL QUALIFICATIONS

MS (Master of Data Science – To be completed within a Month): 2021 (Result 3.9 out of 4.0) Colorado State University, Colorado, USA.

MCA (Master of Computer Applications): 2007 (Result First Class with Distinction) Thiagarajar college of Engineering, Madurai, Tamil Nadu, India.

Contact this candidate