SUMMARY:

• Over Eight years of professional IT experience in analysis, design and development of software applications involving Mainframe technologies.
• Over five years of experience in Application Development and Maintenance for Banking, insurance and Capital markets and over three years of experience in automobile and auto ancillary industry.
• Worked on different phases of projects involving Implementation, Roll - Outs, Post Go Live support and Development/Enhancements.
• Worked on different software development methodologies like AGILE and other proprietary waterfall methodologies.
• Well versed in functional and technical analysis of business requirement and proficient in managing stakeholder expectations.
• In depth understanding/noledge of Hadoop Architecture and its components such as HDFS, YARN, Job Tracker, Task Tracker, Name Node, Data Node and MapReduce.
• Knowledge of writing Hadoop Jobs for analyzing data using MapReduce, Hive and Pig.
• Knowledge of importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa.
• Strong database, SQL, data analysis and data mining skills.
• System integration experience with setting up interfaces between mainframes and other applications like SAP and RedPraire.
• Experience working with DB2, IMS DB databases with exposure in management of batch and online processes.
• Extensively involved in teh development of application software on IBM Mainframes in MVS/OS390 using COBOL, DB2, JCL, CICS and IMS DB/DC.
• Has considerable exposure to teh various tools like SPUFI, QMF, FILE-AID, XPEDITER, Changeman, CA-Endevor, Fault analyzer and File manager.
• Highly effective communication skills to accomplish decision making, problem solving and meet deadlines.
• Experience of driving complex projects involving teams and partners working across different geographies.

TECHNICAL SKILLS

Architectures: S/390, MVC, Hadoop big data

Languages: Pig, Hive, Hadoop Map Reduce, Pacbase, COBOL, JCL, Easytrieve, CICS, IMS DB/DC, SQL, VSAM and IBM UtilitiesNoSQL

HBASE: RDBMS

DB2, SQL Server: Methodologies & Open Sources Object Oriented Analysis and Design

Other tools: Sqoop, flume, MQ series

OS: OS/390,Ms-Dos, MS-Windows (95, 98, 2000 and XP)

PROFESSIONAL EXPERIENCE

Confidential

Business System Analyst

Responsibilities:

• Gatheird Business Requirements, interacted with teh Users, Project Manager and SMEs to get abetter understanding of teh Business Processes.
• Accountable for managing stakeholders and client relationship in end to end program delivery for mainframes and boundary applications like SAP, Bentley substation, Informatica.
• Responsible for conceptualizing and delivering Business requirement document, Requirement traceability matrix, use cases and Detailed Design requirements.
• Performed business analysis using data mining, data scrubbing using SQL and easytrive.
• Worked with clients to identify analytical requirements and produced ad hoc data and reports
• Presented findings and data to teh team to improve strategies and operations.
• Prepared project reports for management and assisted teh project manager in teh development of weekly and monthly status reports.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Developing and maintaining high level overview of teh project and design flows using MS Visio
• Valuated teh source data from different systems and map teh data into teh Enterprise warehouse.

Technical Skills used on project: Z/OS, COBOL, VSAM, JCL, CICS, Easytrieve, DB2, SQL, VSAM, and IBM

Confidential

Mainframe Developer

Responsibilities:

• Created detailed technical design specification for enhancing teh batch programs, care was taken to re-use most of teh existing components/modules.
• Collaborate with client to identify and clarify technical requirements which involved data analysis.
• Debugging and implementing teh system using IBM Debug tools.
• Involved in preparing test plans for Independent Unit testing and System testing.
• Impact analysis for requirement changes, finding affected list of programs and homogeneous
• implementation.
• Designed and developed modifications to existing screens and batch programs to incorporate new business processes.
• Responsible for correct versioning of code by creating and moving teh requests using Endevor.

Technical Skills used on project: Z/OS, COBOL, VSAM, JCL, DB2, SQL, VSAM, and IBM

Module Lead/Mainframe Developer

Confidential

Responsibilities:

• Designed Technical Specification Documents and Program Specification Documents for various SCM outbound requirements
• Designed and developed new IMS DC screens, batch programs for SCM outbound project.
• Designed and developed modifications to existing screens and batch programs to incorporate new business processes.
• Designed and delivered test strategy, test plan and developed test scripts for SCM inbound and outbound system.
• Anchored and delivered performance testing, system testing for teh SCM inbound and SCM outbound projects.
• Lead integration testing with RedPraire and SAP systems
• Extracted data from various data sources of mainframes systems, imported data from DB2 using SQL and applied Excel functions to transform raw data in business information required for reporting and data analysis purposes
• Tracked, reported and generated metrics through teh different stages of teh project.
• Been part of teh implementation of SCM North America inbound rollout
• Involved in post Go-live support and maintenance.

Technical Skills used on project: Z/OS, Pacbase, COBOL, JCL, Easytrieve, DB2, CICS, IMS DC, MQSeries, SQL, VSAM, Stored Procedures and IBM Utilities

Mainframe Developer

Confidential

Roles and Responsibilities:

• Gatheird and analyzed requirements from teh users for teh merging of teh Renault and Volvo systems.
• Performed Impact Analysis and prepared teh Impact Analysis reports based on teh requirements.
• Developed Program specification documents.
• Designed and developed new IMS DC screens for new orders, documentation, broadcasting, breakdown, etc.
• Designed and developed modifications to existing screens to incorporate teh Renault Truck standards into teh Volvo systems.
• Designed and developed interfacing with teh java-based screens for new orders, documentation, broadcasting, breakdown, etc.
• Assisted team members in debugging teh existing complex codes using Xpeditor.
• Designed and developed batch systems (jobs) to determine quantities of orders, parts, etc. on a nightly basis.
• Designed and developed teh performance testing and independent testing for all online and batch systems.
• Prepared teh data dictionary documents to be submitted to teh DBA to add new fields or to create new Tables.
• Tracked, reported and generated metrics through teh different stages of teh project.
• Involved in System integration test and performance testing of teh modifications.

Technical Skills used on project: Z/OS, Pacbase, COBOL, JCL, Easytrieve, DB2, CICS, IMS DC, MQSeries, SQL, VSAM, Stored Procedures and IBM Utilities

Mainframe Developer

Confidential

Roles and Responsibilities:

• Gatheird requirements from teh users for teh various products (mutual funds, brokerage, etc.) being administered to teh clients.
• Designed and developed new CICS screens for new account setup, account detail maintenance, client detail maintenance, etc.
• Designed and developed modifications to existing screens to incorporate changes such as addition of email address, etc.
• Designed and performed teh performance testing and independent testing for all online and batch systems.
• Designed and developed client notifications such as statements, letters, etc.
• Designed and developed new batch systems to generate lists of accounts/clients to which notifications/tax statements needed to be mailed.
• Performed production support activities including resolving tickets for all projects implemented.
• Worked frequently on Data mining -Legal and Regulatory requests that require data gathering in a very short time.

Technical Skills used on project: Z/OS, Pacbase, COBOL, JCL, Easytrieve, DB2, CICS, IMS DB, REXX, MQSeries, SQL, VSAM, Stored Procedures and IBM Utilities