SUMMARY

• 15+ years of extensive experience in Analysis, Design, Development, testing, Implementation and Production Support of Business Applications Software in Financial, Securities, Insurance, Healthcare and Retail domains.
• 2 years of experience in Hadoop ecosystem. Interested in pursuing Hadoop Developer position in Big Data.
• Certified as a Cloudera Developer for Apache Hadoop (CCDH) - CDH Version 5.0.
• Excellent knowledge on Hadoop Architecture and ecosystems such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and Map Reduce programming paradigm.
• Experience in migrating the data using Sqoop and Flume.
• Good knowledge of Data warehousing concepts and ETL processes.
• Good knowledge of Data Integration tool Talend for Big Data.
• Knowledge of installing, configuring, debugging and troubleshooting Hadoop clusters.
• Proficient in unit, system, regression, QA testing and preparing SDLC documentations.
• Responsible individual who is able to work independently or lead or in a group/team setting to meet deadlines while handling multiple assignments under pressure.
• Quick learning skills and effective team spirit with good communication skills.
• Strong analytical and Problem solving skills.

TECHNICAL SKILLS

Operating Systems: Z/OS, LINUX, MVS OS/390, MVS OS/370, ES9000, UNIX, VMS and WINDOWS.

Software: HADOOP,HDFS,MAPREDUCE, PIG, HIVE, HBASE, OOZIE, HUE, FLUME, SQOOP, ZOOKEEPER, JAVA, TERADATA, EXPORT/LOAD UTILITIES, COBOL/COBOLII/ENTERPRISE COBOL V4.1, DB2/SQL V8.1, DB2 STORED PROCEDURES, CICS, IMS DB/DC, BMS, PAINT, VSAM, JCL, PLATINUM TOOLS, DB2 UTILITIES, COMPAREX, DYL-280, Confidential UTILITIES, PANVALET, UDB, MQSERIES, FILEAID, EASYTRIEVE, TSO/ISPF, EXPEDITOR, CHANGEMAN, LIBRARIAN, ENDEVOR, SPUFI, QMF, SYNCSORT, FTP, VPN, NDM, FILEMASTER, CA-1, SAS, SMARTTEST, INTERTEST and IDCAMS.

PROFESSIONAL EXPERIENCE

Confidential

Hadoop Developer

Responsibilities:

• Created Hive tables and HQL queries according to business requirement.
• Extended Hive and Pig core functionality by writing custom UDF.
• Involved in loading data from LINUX file system to HDFS.
• Used PIG Latin and PIG scripts to process data.
• Experienced in importing and exporting data into HDFS and assisted in exporting analyzed data to RDBMS using SQOOP
• Loaded data from Hive into HBASE NOSQL column oriented database.
• Created shell scripts.

Environment: Java, Map Reduce, HDFS, PIG, PYTHON, HBASE, HIVE, IMPALA, FLUME, SQOOP, YARN, CLOUDERA, LINUX scripts.

Confidential

Senior Technical Consultant

Responsibilities:

• Attended the end client’s meeting to support the Account Manager for technical aspects.
• Represented the Billing team for internal intra-department meeting to resolve any issues aroused.
• Lead an offshore team for the systems development and support and provided the technical education to all members in the team.
• Production support during batch cycles.
• Resolved client’s billing issues and recreated the files when requested.
• Supported the internal audit team for any client’s external audit.
• Helped the Account Managers for all their queries and created ad-hoc reports.
• Used ENDEVOR change management to develop, maintain and move all components into the production.

Environment: TERADATA SQL ASSISTANT, TERADATA EXPORT/LOAD UTILITIES, DB2, COBOL, CICS, VSAM, JCL, Z/OSFTP, ENDEVOR, FILEAID, PLATINUM TOOLS, XPEDITOR, FILEMASTER, IDCAMS, TSO/ISPF, SYNCSORT.

Confidential

Senior Technical Consultant

Responsibilities:

• Attended technical design meetings with project managers and involved in designing its architecture.
• Developed technical specifications for each component in this project.
• Lead a team of three developers for this project.
• Used SWIFT 202,103,900,910 formats for financial transactions involved.
• Used XML tags to enclose SWIFT messages as per GMA standard.
• The XML messages are then sent to Money Transfer system using MQ technology.
• Developed online screens using CICS/DB2.
• Developed DB2/COBOL/IMS programs for constructing messages and parsing incoming messages from other systems via MQ.
• All development processes are automated using Internal Reader, CICS Interval Control and in-house Job Scheduling software (PICS).
• Involved in unit, system testing and supporting UAT.
• Used ENDEVOR change management to develop, maintain and move all components into the production.
• Involved in production migration and on-call support.

Environment: ENTERPRISE COBOL 4.1, CICS, DB2 v8.1, VSAM, JCL, Z/OS, MVS/ESA, ENDEVOR, FILEAID, PLATINUM

Confidential, New Jersey

Senior Programmer Analyst

Responsibilities:

• Arranged and attended user meetings and confirm the functional requirements.
• Developed Technical Design and arranged peer review meetings for design approval.
• Developed COBOLII/DB2/CICS programs, JCL, PROCS, CONTROL CARDS and COPYBOOKS.
• Used EZTRIEVE, SAS, FILEAID, SYNCSORT and FILEMASTER for various billing file manipulations.
• Handled a team of 3 members from offshore as a team leader for UHG billing file changes.
• Developed FTP/VPN and NDM jobs for billing file transmission to clients.
• Created unit, system, regression test plans and executed.
• Coordinated and assisted QA and UAT teams for testing and approvals.
• Created ENDEVOR packages to move all mainframe components to production.
• Production support and on-call support during weekends on rotational basis.
• Followed full SDLC process and created technical Design, Code Review, test plans, QA gates and Checklist documentations including getting approvals.
• Created change control documents.
• Fixed various production problems, re-created billing files and re-transmitted to clients.
• Closely worked with team members and other support groups to nail down any technical issues.

Environment: COBOL II, CICS, DB2, VSAM, JCL, Z/OS, MVS/ESA, ENDEVOR, FILEAID, XPEDITOR, FILEMASTER, INTERTESTFILEAID, IDCAMS, TSO/ISPF, SYNCSORT, FTP, NDM, MQSERIES and TEREDATA.

Confidential

Senior Programmer Analyst

Responsibilities:

• Analysis the existing system and prepared system modification design document.
• Prepared resource estimation.
• Document the programs, JCLs, PROCs, DBRMs, copybooks affected by new changes.
• Extract data from DB2 database using Batch COBOL and JCL.
• Developed new DB2/COBOL II batch programs.
• Developed new online screens using CICS II/COBOL/VSAM for new deal tracking functionality.
• Modified both batch and online programs involving CICS/COBOL II/DB2/VSAM/IMS D/C.
• Used FILEAID, SYNCSORT and EZTRIEVE to create test data.
• Setting up JCL, PROCs for both test stream and production environments.
• Used SMART TEST for program debugging and PAINT software for CICS online screens.
• Involved in unit, system and UAT testing with test plan preparation.
• User demonstration of new functionality and user manual.
• Used CHANGEMAN to migrate the mainframe components to production.
• Problem fixing and production support including on-call.
• Followed SDLC process and documentation on various stages of projects.

Environment: COBOL II, CICS, DB2, VSAM, IMS/DC, JCL, CHANGEMAN, FILEAID, SMARTTEST, IDCAMS, TSO/ISPF, SYNCSORT, PAINT

Confidential, New York

Senior Programmer Analyst

Responsibilities:

• Analysis the downstream systems and prepared functional requirements for disbursement and buy/sell processing.
• Attended user meetings for requirement gatherings and follow up.
• Developed batch programs using COBOL II/ DB2 for unit value calculation, fund processing, buy-sell and account balance summary.
• Developed Annual Statements for policy holders.
• Created ad-hoc reports using DB2/COBOL II/VSAM for premium processing, excess interest and fixed fund recap.
• Modified both online and batch downstream programs for interfaces using CICS/COBOL II/ DB2/VSAM.
• Used different utilities to extract data and test data preparation.
• Used EXPEDITOR to trace the program bugs both batch and online.
• Used CHANGEMAN to move the components to production.
• Involved in unit, system and regression testing using manual testing process.
• Production support.

Environment: COBOL, CICS, DB2, VSAM, JCL, CHANGEMAN, FILEAID, XPEDITOR, IDCAMS, TSO/ISPF, SYNCSORT, QMF, SPUFI

Confidential

Senior Programmer Analyst

Responsibilities:

• Meeting user community and gather requirements.
• Developed data flow diagrams and Use cases for different functionalities using VISIO.
• Developed DB2 stored procedures to get data from DB2 tables and called by Java applications.
• Developed COBOL/DB2 programs for data extract and created reports.
• Attended every day team meeting for progress of project.
• Created master test plan for both web applications.
• Involved in System and UAT testing for screen design and its core functionality.
• Involved in user training and created user manual.

Environment: DB2 STORED PROCEDURES, USE CASES, VISIO, SPUFI, QMF, COBOL/370

Confidential

Technical Consultant

Responsibilities:

• Involved in solving critical issues by new system design and enhancing existing systems.
• Solved critical ABENDS.
• Developed front end applications using CICS and BMS macros.
• Developed batch and online programs using COBOL II, CICS and VSAM.
• Used CHANGEMAN as library management system.
• Involved in production support.
• Involved in unit, system and UAT testing assisting the test team.

Confidential

Technical Consultant

Responsibilities:

• Developed system design document for Item conversion project.
• Re-wrote existing system and improved the performance of the system drastically.
• Solved critical ABENDS and worked on enhancements as and when required by the client.
• Developed COBOL II/DB2 programs to load data from flat files to DB2 tables.
• Converted IMS/DB to DB2 database using JCL and DB2 Utilities.
• Monitor the jobs during data load on weekend nights.
• Coordinated with operations and scheduling during item load process.
• On-call production support.

Confidential, New Jersey

Technical Consultant

Responsibilities:

• Participated in design and program specifications.
• Developed COBOL /DB2 modules for Pension Administration system using SPUFI, QMF and PLATINUM for viewing and analyzing.
• Created delinquency report using COBOL/DB2.
• Created ad-hoc reports using DYL-280.
• Developed JCL, PROC and copybooks for new batch programs.
• Created and applied test cases on batch environment.