SUMMARY:

• Having 10+ years of software experience in the areas of analysis, design, development, testing, implementation, maintenance and production support of business critical applications.
• Proficient in complete Software Development Life Cycle starting from information strategy planning, requirement analysis, design, development, coding, testing.
• Extensive experience in preparing technical Requirement and Design documents based on business specifications.
• Extensive experience as an Architect, Technical Lead, DB2 Admin, Developer, Tester and Co - ordinator.
• Cloudera certified Apache Spark and Hadoop Developer.
• IBM certified DB2 database administrator.
• Expert on DB2 applications tuning and stored procedures.

TECHNICAL SKILLS:

OS: AIX, Linux, MVS, Z/OS, OS/390, Windows, Mac OS

Big data Eco Systems: Apache Hadoop, Apache Spark, Hadoop 2.x, HDFS, Apache Spark, Map Reduce V2, YARN, HIVE, Sqoop, Flume, Oozie, Scala, Python, Pyspark, PIG, HBASE, AVRO files, Parquet files, Cloudera Impala, HUE

Languages: VS COBOL II, JCL, DL/I, SQL, APS, SAS, Easytrieve, PL/1, VB, HTML, XML, SQL, PL/SQL, Natural, Stored Procedures, Rexx, Clist, Java, Javascript, .NET

Transaction Server: CICS

Database: DB2, Oracle, MySQL, VSAM, IMS DB, ADABAS, IDMS

Database tools: QMF, SPUFI, BMC Catalog manager, BMC Change Manager, Apptune, BMC Mainview, Platinum RC/Query, RC/Update, IBM Data studio.

Version Control Tools: Endevor, Changeman, Librarian, VSS, Documentum

Tools: MFEEE, File Aid, File AID for DB2, File Manager, Platinum, Panvalet, QMF, Intertest, Smartest, Xpeditor, TSO, ISPF, SPUFI, SDSF, CA 7, Jobtrac, DFSORT, Syncsort, TCP/IP Protocols, SDSF, NDM (Connect Direct), HP Quality Center, Eclipse.

Domain Knowledge: Banking, Manufacturing, Telecom

Middle Ware: MQ Series, Gentran, Harbinger, EDI (ANSI X12)

Office Tools: Lotus Notes, MS Outlook

Microsoft Tools: MS Visio, MS word, MS Excel, MS project

Ticket Mgmt Tools: PICCT, USD, Remedy

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

Hadoop Developer

Environment: Hadoop, Apache HDFS, Apache Spark, Scala, Python, Java, Sqoop, Flume, Hive, Map Reduce, YARN, AVRO Files, Parquet files, JSON files, Mysql, PIG, HBASE, Eclipse, Cloudera tools, Impala, Hue.

Responsibilities:

• Ingested data from structured application databases like db2, oracle and loaded data into HDFS using tools like Sqoop and Flume.
• Done Sqoop import from application databases.
• Also done Sqoop import incremental updates.
• Copied data to and from local unix system to HDFS.
• Developed Scala, Python map reduce programs to extract data, transform and store the refined data in partitioned tables.
• Created Hive tables and queries necessary for the business analysis.
• Improved performance of Hive queries by creating and using partitioned hive tables.
• Done joining of disparate datasets, calculated aggregate statistics in Spark framework using Pyspark.
• Filtered, sorted and ranked data using both Pyspark and Scala in Spark environment.
• Worked with AVRO, Parquet, JSON formatted files.
• Extracted AVRO schemas, JSON files from AVRO data files.

Confidential, Phoenix AZ

Application DB2 DBA

Environment: Mainframes, DB2, JCL, VSAM, SQL, TSO, ISPF, Syncsort, CA Log Analyzer, BMC Catalog manager, BMC Change manager, App tune, SQL Explorer, BMC Mainview, IBM Datastudio, DB2 connect, Omegamon, File Aid, Endeavor, QMF, Smarttest, Abend-aid, MoveIT.

Responsibilities:

• Created DB2 tablespaces, tables and indexes using BMC Catalog Manager.
• Altered existing DB2 tables to add new columns and modified existing column attributes.
• Configured and setup DB2 Connect to connect to mainframe databases.
• Used utilities like LOAD, UNLOAD, REORG, RUNSTATS, QUIESCE, MODIFY, RECOVER etc.
• Created and maintained SQL, Cobol and Java DB2 Stored procedures.
• Performed SQL Fine tuning on application programs using BMC Apptune.
• Done data backups, reorg and recovering of databases.
• Used IBM Data studio to deploy and test Sql\Java stored procedures.
• Used Explain, Runstats for analyzing index and query optimization.
• Loading and unloading DB2 tables for creating test environment.
• Setting up of test environments.
• Maintenance of Rexx scripts.

Confidential, Chicago, IL

DB2 DBA\Developer

Environment: Mainframes, DB2, JCL, VSAM, SQL, TSO, ISPF, Spufi, Syncsort, CA Log Analyzer, CA RC Query CA RC Update, CA RC Migrator, CA Detector, IBM Datastudio, Toad, DB2 connect, Data Q replication.

Responsibilities:

• Created DB2 tablespaces, tables and indexes using scripts generated by Peoplesoft upgradation process. These DB2 databases are hosted on Mainframes.
• Altered existing DB2 tables to add new columns and modified existing column attributes.
• Worked on CA Detector tool.
• Done backups of both DDL and Table data.
• Configured and setup DB2 Connect to connect to mainframe databases.
• Used utilities like LOAD, UNLOAD, COPY, REORG, RUNSTATS, QUIESCE,MODIFY, RECOVER etc.
• Created and maintained SQL, Cobol and Java DB2 Stored procedures.
• Used IBM Data studio to develop and test db2 stored procedures.
• Used Explain, Runstats for analyzing index and query optimization.
• Loading and unloading DB2 tables for creating test environment.
• Used Syncsort extensively for day to day activities.
• Setting up of test environments.
• Maintenance of Rexx scripts.

Confidential, Richmond, VA

Sr Technical Consultant\DB2 DBA

Environment: Mainframes, COBOL, DB2, JCL, VSAM, SQL, Eztrieve, CICS, TSO, ISPF, Optim for DB2, Visual Explain, Syncsort, CA Log Analyzer, BMC Catalog manager, BMC Change manager, App tune, SQL Explorer, BMC Mainview, File Aid, Endeavor, QMF, Smarttest, Abend-aid, MQ Series, MoveIT, Rexx, CLIST.

Responsibilities:

• Involved in Development/Coding, maintenance of application programs and DB2 DBA tasks.
• Developed new programs using COBOL, DB2 SQL, CICS, VSAM, JCL and SORT as per DMAS requirements.
• Prepared Technical Design Document for multiple releases.
• Developed COBOL DB2 programs generating adhoc reports.
• Developed new CICS screens/programs using GTB tool and helped integrate those screens with HATS web screens.
• Modified both batch and online programs as per change requests.
• Created, developed and tested native SQL and Cobol DB2 Stored procedures proving SOA components.
• Created and tested DB2 Native Stored procs using IBM Data studio.
• Used Explain, Runstats for analyzing index and query optimization.
• Investigated data manipulation by using CA Log analyzer.
• Performed SQL Tuning on application programs.
• Used Optim tool for data movement between prod and test regions.
• Used Optim tool for archiving and restore data as per business requirements.
• Loading and unloading DB2 tables for creating test environment using BMC utilities.
• Used Syncsort extensively for day-to-day activities.
• Generated adhoc reports using data unloaded from DB2 tables.
• Developed Eztrieve programs for adhoc process.
• Performed both manual and automated testing.
• Performed System integration testing with front-end HATS Web screens.
• Debugged both batch and online programs using SMARTTEST tool.
• Created DB2 tablespaces, tables and indexes using BMC Catalog manager.
• Altered existing DB2 tables to add new columns and modified existing column attributes using BMC change manager.
• Worked on BMC Mainview tool.
• Upgraded DB2 Connect on SAS application server to connect to mainframe databases.
• Used utilities like LOAD, UNLOAD, REORG, RUNSTATS, QUIESCE,

Confidential, Pittsburgh, PA

Sr Technical Consultant

Environment: Mainframes (Z/OS), COBOL, DB2, JCL, VSAM, SQL, TSO, ISPF, QMF for DB2, Windows Query Man for DB2, Visual Explain, DBArtisan, File Aid, XML, EAI tool, MQ series, Endevor, Sync SORT, SAR, SPUFI, Expeditor, CA 7 Scheduler, Abend-aid, Easytrieve, CLIST, FTP, NDM (Connect:Direct), Unix.

Responsibilities:

• Prepared technical design and Mapping documents for the newly developed Secure vault payment process.
• Developed CICS program to capture the secure vault payment transactions created by front end Java/.Net application. This program captures XML data sent by front end program using EAI integration tool (MQ Series).
• Developed Batch process to back up the SVP transactions and process them and build ACH transactions.
• Developed new programs using COBOL, DB2 SQL, VSAM, JCL, CICS and SORT as per business requirements.
• Developed program to generate OLB origination report based on the ACH records built.
• Performed unit and integration testing for the newly developed batch and online process for SVP project.
• Done System integration testing for newly developed online programs with front-end applications.
• Cloned JCLs, PROCs and COBOL, CICS Programs for the new test environments meant for merge & acquisition testing.
• Loading and unloading DB2 tables for creating test environment.
• Developed Unload process for Flag star conversions.
• Used Intertest tool for debugging COBOL CICS programs.
• Performed SQL Tuning on application programs.

Confidential, Jersey City, NJ

Sr Developer

Environment: Microfocus COBOL, DB2, JCL, VSAM, SQL, NET Express, MFEEE, MFA Drag & Drop, Microfocus Revolve, Perforce, Mainframes (Z/OS), TSO, ISPF, QMF for DB2, Windows Query Man for DB2, Visual Explain, DBArtisan, File Aid, XML, Endeavor, DFSORT, SAR, QMF, SPUFI, Expeditor, CA 7 Scheduler, Autosys, Abend-aid, HPSC, Easytrieve, FTP, NDM (Connect:Direct), Unix.

Responsibilities:

• Prepared technical design and Mapping documents for the newly developed process.
• Migrated WMR application from Mainframes to Microfocus which include both batch and online programs.
• Created projects in NET Express, added programs and compiled them successfully.
• Developed new programs using COBOL, DB2 SQL, VSAM, JCL, CICS and SORT as per business requirements in Microfocus using NET Express tool.
• Cloned JCLs, PROCs and COBOL Programs for WMR application.
• Converted Eztrieve programs into COBOL programs for running them on Microfocus.
• Developed and uploaded JIL to schedule jobs in Autosys.
• Configured Microfocus Admin server for development and UAT regions.
• Used DBArtisan tool for adhoc querying DB2 database.
• Loading and unloading DB2 tables for creating test environment.
• Done manual and automated testing on COBOL/COBOL DB2 programs using Net Express tool.
• Used Dynamic debugging feature in NET Express to debug programs in automation mode.
• Setting up of test environment which includes activities like data migration to test regions, setting up of JCLs, procs, programs etc
• Performed Unit testing and system Integrated testing on newly developed code.
• Improved the performance of the existing COBOL DB2 programs by performance tuning SQL statements in Microfocus.
• Used MFA Drag & Drop tool to bring the elements from Mainframes to Microfocus and vice versa.
• Used Microfocus Data Editor feature to browse/edit datasets on windows environment.
• Developed JCLs to delete and define the key VSAM files with key master data.
• Created change controls in HPSC change management system to implement the changes and new programs.

Confidential, Bentonville, AR

Sr Developer

Environment: COBOL, DB2, JCL, VSAM, SQL, SAS, CICS, IMS DB, Teradata, Platinum for DB2, Windows Query Man for DB2, File Aid, Librarian, DFSORT, SAR, Expeditor, CA 7 Scheduler, Abend-aid, NDM (Connect Direct), Remedy, Easytrieve, FTP, Unix.

Responsibilities:

• Interacting with business analysts to collect functional requirements.
• Prepared technical design (TDD) and Mapping documents for the new developed process.
• Developed new programs using COBOL, DB2 SQL, VSAM, CICS, JCL, Eztrieve and SORT as per business requirements.
• Developed COBOL table handling programs using Subscripts and Indexes.
• Converted SAS programs into COBOL, DB2, SORT programs as per business requirements.
• Cloned JCLs, PROCs and COBOL Programs for the new Confidential operations in other countries.
• Used Visual EXPLAIN and RUNSTATS for analyzing index and query optimization.
• Performed SQL Tuning on application programs.
• Loading and unloading DB2 tables for creating test environment.
• Generated reports using data unloaded from DB2 tables.
• Performed Unit testing and System Integration testing on newly developed code.
• Improved the performance of the existing COBOL DB2 programs by performance tuning SQL statements.
• Done manual and automated testing on COBOL DB2 programs.
• Expedited newly developed batch and online programs using Xpeditor tool.
• Modified Cobol IMS DB programs as per business requirements.
• Developed COBOL Stored procedures.
• Modified COBOL MQ Series programs.
• Worked on JCLs to unload journals from DB2 tables in order to load Teradata Data warehouse.
• Used Teradata utilities like BTEQ, Fastload, fastexport etc.
• Developed JCLs to delete and define the key VSAM files with key master data.
• Developed Eztrieve programs to process Journal data and generate reports.
• Created change controls in the Remedy case management system to implement the changes and new programs.
• Developed JCLs to send auto E-mail notifications to the team, when the data being processed is bad.
• FTP’ed the Journal data to UNIX based systems.

Confidential, Charlotte, NC

Technical Consultant

Environment: COBOL, DB2, JCL, VSAM, SQL, IMS DB, File Aid for DB2, File Aid for MVS, Serena Changeman, MQ series, Sync sort, Mobius, Xpeditor, CA 7 Scheduler, Abend-aid, Documentum, NDM (Connect Direct), PICCT, APS, MFEEE, Easytrieve, Quality Center (Mercury), MS Project.

Responsibilities:

• Designed new batch and online application interfaces for commercial exposure system.
• Prepared technical requirements (TRD), technical design (TDD) and Mapping documents for new interfaces.
• Developed new interfaces using COBOL, APS, DB2, VSAM, CICS, MQ Series and JCL as per business requirements.
• Prepared test scripts and test environments for unit testing, integrated testing.
• Modified Cobol IMS DB programs as per business requirements.
• Used Quality center for tracking test results and defects.
• Loading and unloading DB2 tables for creating test environment.
• Performed Unit testing and Integrated testing on newly developed code.
• Used Intertest tool to test the batch programs.
• Modified Microfocus COBOL using MFEEE tool.
• Involved in the UAT, being a part of the onsite team.
• Done enhancements which come in the form of PICCT change requests.
• Used scheduler Control-M to view the job schedules and analyzed jobs accordingly.
• Worked out with business analysts to come up with new solutions.
• Involved in modifying COBOL CICS programs.
• Developed Eztrieve programs to generate reports.
• Involved in 24x7production support, which involves the activities like analyzing and debugging of the program abends with in the service level agreements.
• Proposed new approach for jobs which are currently running in order to increase the performance of the system.
• Pulled financial data from other UNIX based application.
• Translated APS Cobol programs into native COBOL programs.
• Estimating time and efforts for the enhancements.
• As being a part of a Global Team interacted with offshore team which is located in India.

Confidential

Technical Consultant

Environment: COBOL, DB2, JCL, CICS, VSAM, SQL, Gentran, Endevor, File Manager, Platinum, Panvalet, Abend-Aid, QMF, SAR, USD, SAS, Intertest, Smart test, MQ Series, XCOM, TCP/IP.

Responsibilities:

• Prepared the project write ups for most of the enhancements, the project write up contains information such as project name, its complexity, the programs getting impacted, and the sample approach to the enhancement.
• Directly interacting with the client
• Prepared Design and mapping documents based on business requirements.
• Involvement in building test cases and executing.
• Done modifications to the 810, 856 outbound mapping documents.
• Performed an intermediately role between the business users and technical team.
• Involved in coding activities based on design documents.
• Developed inbound and outbound maps using ANSI X12 standards using Gentran tool.
• Built maps for Purchase orders, Shipment notices, Payment Advice and Invoices.
• Developed new COBOL DB2 batch programs.
• Prepared and executed test plans for the Unit testing.
• Involved in the enhancement activities, which includes modifying the COBOL DB2 programs.
• Participated in the weekly status meetings with the business analysts.
• Handling service requests, which come in the form of USD tickets.
• Involved in the 24x7 production support, which involves the activities like analyzing and debugging of the programs.

Confidential

Programmer Analyst

Environment: COBOL, JCL, CICS, DB2, VSAM, Expeditor, File Aid.

Responsibilities:

• Handling requests from the developers, which comes in the form of service requests for migration.
• Migration of the COBOL from the development region to the production region.
• Preparing UAT Plan document.
• E2E testing of the code in the midrange environment.
• Raising a ticket, if a bug was found, while testing the code.