SUMMARY:

• Senior backend developer with total 9.3 years for IT experience. 2+ years of experience in big data technologies specially Mongo DB and ETL - Talend.Proven ability to portray different roles which include Sr. Developer and Business Analyst. Extensive experience in working through all phases of SDLC life cycle. Sound knowledge of Insurance domain especially Claims and Financials backed by excellent communication skills.
• Overall 9.3 Years of IT experience working on various platforms and database and its integration.
• Demonstrated ability to work in different roles like Sr. Developer and Business Analyst.
• 2+ years of experience in big data technologies specially Mongo DB and Talend.
• 2 years of experience in Ab-initio.
• Involved in prototyping of big data application with various technologies.
• Implemented complete migration of IMS-DB to Mongo DB.
• Proficient in Mainframe technology
• Proficient in COBOL, JCL, VSAM.
• Extensively worked on IMS-DB and proficient in coding COBOL-IMS Programs
• Extensively worked on DB2 and proficient in coding COBOL-DB2 Programs and SQL
• Sound knowledge of designing user interfaces using CICS and FEPI programming and use of MQ Series queues.
• Extensive experience in core development activities which includes Analysis and Design, Unit Test Plan preparation, Coding and Unit Testing.
• Extensive experience in QC testing which include creating Test Plan Strategy, Functional and Regression Test Plan, Environment Set-up, Executing Test Scripts and Capturing Results.
• Experience in all facets of Software Development Life Cycle (SDLC), including requirements gathering, designing, coding, testing, and implementation
• Sound knowledge of Insurance Domain especially in Claims and Financials.
• Worked closely with the users in Requirement Gathering and formulated Business Requirement Documents and Functional Requirements.
• Demonstrated ability in mentoring individuals to maximize productivity and forming cohesive team environment.

TECHNICAL SKILLS:

• Talend Data Integration
• Talend Big Data Integration
• Mongo DB
• Ab-Initio
• DB2
• CICS, FEPI, MQ
• VSAM
• COBOL
• UNIX, MVS and Z/OS
• DB2
• CICS, FEPI, MQ
• IMS-DB
• JCL, DFS SORT, SYNCSORT
• Analysis and Design
• Requirement Gathering
• Unit/System/User Acceptance testing
• Coding/Development
• Production Support
• Implementation
• Oracle/MySQL
• Java

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Developer

Technology: Mongo DB, Talend, IMS-DB

• Migrated Encompass Claims data from IMS-DB into Mongo DB document based system.
• Extracted required data of CLUE from Mongo DB to send to VeRisk & CLUE.
• Created Talend jobs to extract data from MongoDB.
• Created Talend job to format the error data in Talend using lookup files.
• Created a Talend job to send a reports to user in excel format for corrected data.
• Analyzed the requirements and prepared detailed design documents.
• Involved in core development activities like coding, Unit testing, System testing and UAT.
• Project management activities like project tracking, status reporting, risk control, change control and maintaining artifacts for SOX Audits.
• Production Support activities like application checkout, batch cycle monitoring and resolving User Queries.
• Expected to conduct system analysis and development, with limited support from professional staff, to keep our systems current with changing technologies.
• Working closely with upper management.
• Responding promptly and professionally to bug reports.
• Document code consistently throughout the development process by listing a description of the program, special
• Instructions, and any changes made in database tables on procedural, modular and database level.
• Responsible for planning, processing and performing all jobs in an efficient manner with no assistance from the supervisor.
• Writes, edits, and debugs new computer programs for assigned projects, including necessary records and desired utput.
• Tests new programs to ensure that logic and syntax are correct, and that program results are accurate; assists programmers with programming assignments.
• Document code consistently throughout the development process by listing a description of the program, special instructions, and any changes made in database tables on procedural, modular and database level.

Confidential

Sr. Developer

Technology: Mongo DB, Talend, Hadoop

• Extracted application user data from Mongo DB.
• Transformed data using lookup file in Talend.
• Build a Talend job to Sort data on Active user and skipped the inactive users.A Text file output is created to report user data to ISO.
• Analyzed the requirements and prepared detailed design documents.
• Involved in core development activities like coding, Unit testing, System testing and UAT.
• Project management activities like project tracking, status reporting, risk control, change control and maintaining artifacts for SOX Audits.
• Production Support activities like application checkout, batch cycle monitoring and resolving User Queries.
• Expected to conduct system analysis and development, with limited support from professional staff, to keep our systems current with changing technologies.
• Working closely with upper management.
• Responding promptly and professionally to bug reports.

Confidential

Sr. Ab Initio Developer, Tech Lead

Technology: Oracle 10g, Ab Initio GDE 3.0.1, CO>OP 3.0.1. UNIX

• Implemented Ab-initio as an ETL tool to pull data from source systems, cleanses, transform and load data into databases and to respective files.
• Performed complex queries involving large data volumes.
• Replicated operational tables, Transformed and loaded data into Operational Data Store using Ab-initio
• Informed manager on a weekly basis regarding development activities, issues the team is facing, work/milestones planned for the team. Strived to keep manger informed and have consensus on approach. Ability to provide written software development lifecycle documentation.
• Provided suggestions/Best Practices to team on code/logic/design, presented proof of concept for complex designs, Strived for Continuous Improvement
• Responsible for Development of complicated graphs with various Ab-Initio components.
• Implemented complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed into the Data Warehouse
• Used the following components of Ab-Initio in creating graphs. Dataset components (Input file, output file, lookup file, and intermediate file), Database components (Input table, output table, RunSql, Truncated Table), Transform Components (Aggregate, Dedup Sorted, Filter by Expression, Join, Normalize, Reformat, Rollup and Scan Components), Partitioning
• Deployed and test run Ab-initio graphs as executable UNIX Shell scripts.
• Modified the Ab-initio component parameters, utilized data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Identify/debug, troubleshoot, modify, document, test and fix production issues.
• Used the Tivoli to schedule the jobs and used the UNIX wrapper scripts for linear scalability

Confidential

Developer, Onsite Coordinator

Technology: MVS, Z/OS, COBOL, JCL, VSAM, DB2, IMS-DB, CICS, FEPI, JAVA, UNIX, Other tools and utilities

• Understand the application and its functionalities.
• Analyzed requirements and prepared detailed design documents
• Developed and Tested new functionalities
• Coded COBOL IMS-DB, COBOL-DB2, COBOL-CICS programs.
• Developed and tested new programs and change to the existing ones as part of enhancements.
• Prepared SYSTEM/UAT/QC test Plan strategy and test plans and executed Test Scripts.
• Project management activities like project tracking, status reporting, risk control, change control and maintaining artifacts for gating and SOX Audits.
• Production Support activities
• Worked on Production Support activities like daily application checkout, batch cycle monitoring, ABEND resolution and resolving user queries and issues.

Confidential

Developer

Technology: MVS, Z/OS, COBOL, JCL, VSAM, DB2, IMS-DB, CICS

• Analyzed requirements and prepared detailed design documents.
• Created a subroutine code to compress 7 digit cat code to 5 digit cat code.
• Updated Claims, Payment history database through routine.
• Created one time database update jobs.
• Done CICS Screen changes to accommodate 7 digit cat field on screen.
• Created unit test plan and System test plan.
• Done unit testing and System testing.