SUMMARY

• Over 16 years of diverse experience including 4.5 years in Big data technologies.
• Extensive experience with analysis, design, development, customizations, and implementation of software applications.
• Proficient in analyzing and translating business requirements into technical requirements.
• Excellent knowledge on Hadoop ecosystem such as Hadoop, HDFS, Apache Spark, Hive & Sqoop.
• Proficient in the languages such as COBOL, JCL in IBM Mainframe Environment.
• Experience in manipulating/analyzing large datasets and finding patterns and insights within structured and unstructured data.
• Experience in migrating data using Sqoop from Relational Database system to HDFS and vice - versa.
• Gained a vast exposure of knowledge and work experience in Databases DB2 and Online Transaction processing using CICS.
• Experience in leading and managing big teams. Handled multiple roles - Software Architect, Business Analyst, Technical Team lead and application developer.
• Have good knowledge on AWS Analytical Services.

TECHNICAL SKILLS

Programming Language: COBOL, JCL, SAS, php, HTML, Python

Big Data Ecosystems: Hadoop, HDFS, Hive, Sqoop, Spark

Databases: DB2, IMS, IDMS, MySQL

Processes: IBM’s QMS (Quality Management System), OAPL (On demand Process Asset library), CMMI, JIRA, ClearCase, ServiceNow

OLTP: CICS, ADSO, ISPF

Tools: /Utilities: ENDEVOR, PANVALET, MOBIUS, EASYTRIVE, JCLPLUS, Q-editor, IBM Debug Tool, File-Manager, MainView, IBM Fault Analyzer, IBM APA, IBM DB2 Admin tool, SPUFI, QMF. MQ, $avers, Teradata SQL Assistance, CA-7, bitbucket, git, Control-M

Domain: Healthcare, Manufacturing, Insurance

PROFESSIONAL EXPERIENCE

Confidential, CT

Technical Lead/Senior Data Engineer

Responsibilities:

• Worked on requirement gathering, analysis, design, development, testing and implementation of new functionalities in Hadoop cluster using different tools like Sqoop, Hive, Spark, pyspark and python.
• Provided ad-hoc reports to business by running complex SQL queries on Hive to support traditional migration from ACES to WGS system.
• Worked on creating data pipelines from Mainframe and Teradata to Hadoop using Sqoop for different applications and load the data into Hive tables.
• Used Hive and pyspark for data analysis and transformation for downstream applications consumption.
• Designed accum process to send accumulators from ACES Mainframe to ODS and worked on forward and backward sync process.
• Responsible for managing scope, planning, tracking, change control aspects of the project.
• Worked with Business Analyst in translating business requirements into Functional and non-functional requirements and track the requirements in Jira.
• Worked on multiple POC to achieve better performance and cost saving like Data center migration, Cloud migration, CoCA application implementation using Hadoop etc.
• Collaborate with benefit builders and clients for prioritizing, planning and estimating project requirements based on team capacity.
• Support Blue Exchange application by monitoring application health using MQ and SOA status.
• Worked as release manager to enable smooth release on monthly basis for different applications.
• Worked on decommissioning activity of major applications and successfully completed it.
• Made extensive use of Git, BitBucket, ClearCase, Endevor etc tools to manage and build and deploy tasks.

Environment: Hadoop, Spark, Sqoop, pyspark, hive, COBOL, JCL, DB2, IMS, git, BitBucket

Confidential

Technical Lead

Responsibilities:

• Understand high level requirements and create low-level design document.
• Assign the work to team members and track the development work till closure.
• Implemented multiple optimization process to improve Blue Exchange 270/271 response time to 2 sec.
• Coordinate and lead production support activities for Benefit & Blue Exchange application ( Confidential CT).
• Analyze system issues and design a fix to correct the issue.
• Coordinate development and implementation of production fixes.
• Designed and developed ODS process to send benefit details to Online Data Store.
• Provide Corrective and Emergency Maintenance to enable applications meets
• Review changes going in production environment and provide sign off as team lead.
• Coordinate User acceptance testing, e.g., gain user involvement, establish and define acceptance criteria, setting high-level test objectives, establish high level test scenarios.

Environment: IBM S390, MVS, COBOL, JCL, DB2, VSAM, CICS, IMS

Confidential

Application Developer

Responsibilities:

• Developed multiple screens and online programs using COBOL CICS to access DB2.
• Provided production support for HR/Payroll and MMS system.
• Implemented bar-code project using FORMs to generate bar code report for warehouses.
• Work with customer for Magnum integration (generated huge number of on-demand reports using SAS to support this integration)
• Gather and analyze the requirement given by customer.
• Perform integration testing for the new requirements.
• Provide daily input for specific HR/Payroll jobs to US Operations team.
• Attending the Process reviews and Quality audits reviews as part of the Quality management activity.
• Adhering to IBM Quality process.

Environment: IBM S390, MVS, COBOL, JCL, DB2, VSAM, CICS, IDMS

Confidential

Associate/Senior Developer

Responsibilities:

• Developed and tested new COBOL DB2 programs to merge and display WID details on online screens.
• Converted IDMS COBOL programs to COBOL DB2 programs.
• Involved in different level testing of new requirements.
• Involved in review process.
• Mentoring the new project members.

Environment: COBOL, JCL, IDMS, ADSO, VSAM, ENDEVOR, SAS

Confidential

Software Engineer/Developer

Responsibilities:

• Optimize the code to reduce the maintenance cost.
• Development of footprint wide reports and tools by analyzing existing SAS programs.
• Involved in different level testing of new requirements.
• Involved in review process.
• Involved in preparing the Unit test Plan, Functional specifications documents.

Environment: COBOL, JCL, CICS, VSAM, SAS