SUMMARY

• Over 8.5 years of overall experience as a Software developer working in all phases of SDLC including application design, development, production support & maintenance projects in IBM Mainframes.
• Over 1.5 years of extensive experience as Hadoop Developer and Big Data Analyst. Currently working on a Hadoop cluster with current size of 36 Nodes and 96 Terabytes of capacity.
• In depth understanding/knowledge of Hadoop Architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and MapReduce concepts and experience in working with MapReduce programs using Apache Hadoop for working with Big Data to analyze large data sets efficiently.
• Have re - engineered 2 Mainframe applications into Hadoop using MapReduce API to reduce mainframe MIPS and storage cost.
• Experience in importing and exporting Tera bytes of data between HDFS and Relational Database Systems using Sqoop.
• Have good experience in extracting and generating statistical analysis using Business Intelligence tool Qlikview for better analysis of data.
• Knowledge of job workflow scheduling and monitoring tools like Oozie and Ganglia, NoSQL databases such as HBase, Cassandra, Big Table, administrative tasks such as installing Hadoop, Commissioning and decommissioning, and its ecosystem components such as Flume, Oozie, Hive and Pig.
• Experience in tuning and designing DB2 database tables with use of STROBE tool.
• Experience in Ispirer tool for analyzing the DB2 data in SQL server environment.
• Expert in supporting technical upgrade activities such as DB2, IMS, z/OS and ACF2 (security).
• Experience in Change Management Tool Maximo, SCCD & Service Now.
• Experience in design and coordinating of middle layer services such as BizTalk, Direct Connect, NDM services etc.
• Experience in Pre-sales, proposal and RPF.

TECHNICAL SKILLS

Big Data Ecosystem: HDFS, PIG, MapReduce, Hive, Sqoop, Flume, HBase, Kafka.

Operating System: UNIX, Linux, Windows XP, IBM z/OS

Business Tools and Database: SQL, DB2, IMS DB, MySQL, SQL Server

Languages: Core Java, PIG Latin, SQL, HiveQL, Shell Scripting.

Mainframe Skills: COBOL, JCL, VSAM, CICS, STROBE (for performance analysis), Ispirer, CONTROL-M, ENDEVOR, Panvalet, CA-7, ZEKE, File -Aid, ABEND Aid.

PROFESSIONAL EXPERIENCE

Hadoop Developer

Confidential

Responsibilities:

• The mainframe Causal file process re-engineered in Hadoop system using MapReduce API.
• The promotional data that required for this application off loaded from Mainframe DB2 to HDFS using Sqoop.
• Involved in Requirement Analysis, Design, and Development.
• Work closely with the business and analytics team in gathering the system requirements
• Data ingestion into HDFS from various Mainframe Db2 table using Sqoop.
• Create interface to convert mainframe data (EBCDIC) into ASCII.
• Developed workflows using custom MapReduce
• Loading data into HBase tables using Java MapReduce
• Developed suit of Unit Test Cases for Mapper, Reducer and Driver classes using MR Testing library

Environment: Cloudera Hadoop Distribution, HDFS, Kafka, Core Java, Pig, Hive, MapReduce, Sqoop, Shell scripting, LINUX

Hadoop Developer

Confidential

Responsibilities:

• Have written various scripts to load data from internal/external channel to HDFS/Hive.
• Have written various MapReduce job to read the data and using business logic find out various alert
• Have written scoop Export jobs to export report to MySQL for business and analytics
• Have written Various script/Query to generate regulatory report for downstream
• Housekeeping activities
• Have involved various performance issues.
• Automation activities
• Support activities.

Environment: Cloudera Hadoop Distribution, HDFS, Core Java, Pig, Hive, MapReduce, Sqoop, Shell scripting, HBase.

DB2 Developer

Confidential

Responsibilities:

• Creating similar test environments as production baseline for testing JCLs, which included Subroutines and source code of VS- COBOL II program transfers in the test region.
• Performing module, system integration, date rollup, parallel, and user acceptance testing for the conversion change

Environment: Subroutines, ISPF/TSO, MQ Series, File-AID, Sync Sort, Easytrieve, IMS, DB2 Stored Procedures, CICS, and MVS/ESA

SME cum Developer

Confidential

Responsibilities:

• Developed revised design model to overcome the performance bottlenecks.
• Worked as a programmer to develop the system where 30M data got loaded in 5 mins.
• DB2 unique Exchange command has been used to exchange the data between clone and base tables.

Environment: DB2 Database, JCL, SQL Server, SSIS Package, FTP

Lead Developer

Confidential

Responsibilities:

• To measure, analyze and improve the current WCS batch where there is a performance bottleneck, both on functionality and logical flow.
• To lower the CPU consumption & DB2 usage which eventually reduce the batch elapsed time both in online run and in nightly run.
• Minimizing DB2 usage based on following approach -
• Removing un-necessary and redundant SQL(s) based on STROBE Report.
• Improving efficiency of SQL(s) by using best DB2 practices.
• Removing DISPLAY wherever applicable.
• Decommission obsolete conditions and validations.

Environment: DB2 Database, COBOL, DB2, JCL

Lead Developer

Confidential

Responsibilities:

• Given the idea to business and presented the proposal.
• Working as Lead developer and SME to guide the project and implement successfully.

Environment: COBOL, DB2, JCL, SQL Server, .NET CA-7, Strobe, Panvalet

Lead Developer

Confidential

Responsibilities:

• To measure, analyze and improve the current WCS batch where there is a performance bottleneck, both on functionality and logical flow.
• To lower the CPU consumption & DB2 usage which eventually reduce the batch elapsed time both in online run and in nightly run.
• Minimizing DB2 usage based on following approach -
• Removing un-necessary and redundant SQL(s) based on STROBE Report.
• Improving efficiency of SQL(s) by using best DB2 practices.
• Removing DISPLAY wherever applicable.
• Decommission obsolete conditions and validations.

Environment: DB2 Database, COBOL, Sync Sort, Easytrieve, JCL, Omegamon, ZEKE.

Lead Developer

Confidential

Responsibilities:

• Involves as SME of WCS application to migrate the project from Mainframe to .Net and BizTalk.
• Also acts as a co-coordinator between the team involves different layer of technology such as Mainframe, .Net, BizTalk.
• Coding (involves developing codes for form specific sub-modules based on the work request).
• Unit and Integration Testing.

Environment: DB2 & IMS Database, COBOL, JCL, VSAM, BizTalk, SYNCSORT, Ispirer

Programmer/Analyst

Confidential

Responsibilities:

• Main objective is to generate forms for a particular policy based on work request logged in Bug-tracker.
• We run the nightly policy print batch cycle to generate the extract file.
• Coding (involves developing codes for form specific sub-modules based on the work request).
• Unit and Integration Testing.
• Enhance Functionality
• Develop new reporting systems for State regulatory bodies
• Add new reports to be reported to Federal and state regulatory bodies
• Build the basis for future extension of the solution (e.g. automation of updating dates etc.)
• Application Maintenance
• Marinating the existing application which includes maintain the codes, databases and files
• Improve efficiency
• Automate manual date verification before triggering jobs etc. where possible