SUMMARY:

• Having 12 years of experience with 3 years in BIG DATA technologies with the skill set as APACHE HADOOP, HQL, PIG, MapReduce, HDFS, HBASE, ELASTIC SEARCH, Scala, Kafka, SQL, PL/SQL and 9 years in MAINFRAME technologies with the skill set as MVS, OS/390, COBOL, JCL, CICS, DB2, VSAM, NATURAL/ADABAS, EASYTRIEVE, XGEN 4GL, REXX, RACF.
• Worked extensively in Onsite - Offshore model, working closely with client IT and business partners, coordinating onshore and offshore teams, analyzing the business requirements, solutioning, providing estimates, design, coding, testing, delivering projects with in postulated timelines and budget with high customer satisfaction index.
• Good experience in development and maintenance of huge databases on Big Data platform using Apache Hadoop Framework, MapReduce, HDFS, HBASE, Elastic Search etc.
• Good experience in developing Data Analytics and Business Analytics applications using HIVE Query Language, PIG, Elastic Search indexes, SQL, PL/SQL and Oracle RMB (Revenue Management and Billing) technologies.
• Good experience in development and maintenance of Mainframe Applications using CICS as front end, DB2, ADABAS, VSAM Files as back end and JCL, COBOL, NATURAL, XGEN 4GL as programming languages.
• Rich expertise in various Mainframe technologies such as COBOL, JCL, CICS, DB2, VSAM, NATURAL, ADABAS, ADASQL, XGEN 4GL, EZTRIEVE, REXX, MVS, OS/390, TIVOLI OUTPUT MANAGER, ZEKE SCHEDULER, RACF.
• Very good expertise and hands on experience on Tools for Application Development such as IBM Data Studio, Teradata SQL assistant, Toad for Oracle, IBM Requisitepro, Mainframe File-aid, Xpeditor, Endevor, Strobe, Intertest, Hiperstation, Insync, Trace master.
• Good experience in analysis, development and maintenance of Healthcare Insurance and Non-life Insurance proprietary systems. Worked on different kinds of projects in insurance systems such as Building New Products, Dealing with Government Compliance issues, Adapting the system to changed or new Government Healthcare policies, Enhancement of existing applications, Analyzing and fixing production batch and online program abends, Mainframe jobs Production support and Application performance tuning.
• Experience in implementing the projects using Waterfall SDLC (Software Development Life Cycle) & Agile Project Methodologies. Excellent experience in Agile project methodology and its implementation.
• Excellent experience in using the tools such as HP ALM - Application Lifecycle Management, QC - Quality Center, HPSM - Hewlett Packard Service Manager, Share point workspaces, Work Product Repositories which are used in various phases of software development.
• Currently working for the client Confidential from Cognizant Technology Solutions US Corporation.
• In the current role, working as cross application Big Data Consultant with responsibilities including interaction with client IT and business partners to understand the business requirements, formulate solutions, preparation of project design and project development.
• As a Systems Analyst, my job duties are to work on requirement gathering and analysis including analytical techniques, interview and data gathering techniques to address the requirements, current system flow documentation, business modeling methods, business process rules and logic, development of implementation plans, Solution design meetings, JAD (Joint Application Design) sessions, IRAAD (Issues Risks Actions and Decisions document) sessions.
• As a Developer, my job duties are to develop and maintain large databases on Big Data platform using Apache Hadoop eco system, develop data and business analytics applications using various query languages, perform unit testing of the queries, validating and obtaining sign-off for the test results from business groups, migration of code to system test environment and providing support to QA teams and deployment of code to production environment.

DOMAIN SKILLS:

• Non - Life Insurance or General Insurance insuring Dwellings, Homes, Fire damage, Wind/Hail damage, Commercial property, restaurant, retail service, real estate, wholesalers, manufacturing, institutions, business owner products, Commercial and Personal auto, automobile services with transactions of issuing a new insurance policy, renewal, changes in policy, cancellation, reinstatement, rewrite, audit of the policy etc. Worked on regulatory reporting such as unit statistical reports, Policy health and status reports, Billing and accounts receivables, documerge, policy forms and print services.
• Healthcare Insurance dealing with Physician & Hospital Providers, Payer, Members, subscribers, Dependents, Billing and Enrollment, Member ID cards, Claim Entry, Claim Adjudication and calculation, Check write, Manual and EDI claims, Big Data platforms, Business and Data analytic solutions, Data Reporting and BI tools.
• Software Development Life Cycle and Agile Project Methodologies.
• Analysis and understanding of Insurance proprietary systems.
• Requirements analysis, functional specifications and gap analysis.
• Implementing projects, end to end from requirements analysis phase to production deployment.
• Participated in System Testing and UAT Testing.

MANAGEMENT SKILLS:

• Thorough understanding of Software Development Life Cycle and AGILE methodologies, involved in various phases of project such as Business requirements analysis, converting to technical requirements, preparation of solution design, development, testing, QA testing support, production deployment and deployment support.
• Successfully managed complex projects with rapidly evolving requirements conducting requirement analysis and solutioning sessions with client IT and business teams, mentoring the team, submitting the schedule and effort estimates to client, successfully getting the coding and unit testing completed, supporting the QA testing and production deployment of the project.
• Excellent verbal and written communication skills and having a good record for coordination between teams those are located across the globe such as teams in North America, India, Philippines locations.
• Successful and timely delivery of the projects under stringent timelines and high pressure with good customer satisfaction index.
• Conducted budget planning of the projects through walkthrough meetings and project planning meetings involving development, QA, technical support team leads.
• Acted as liaison between higher management, development and QA teams; onsite and offshore teams; client and cognizant teams.
• Implemented CMM Methodologies, risk mitigation, contingency, disaster recovery, business continuity procedures, quality and knowledge database maintenance and attended quality audits & procedures across the organization.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Apache HQL (Hive Query Language), Apache PIG, COBOL, JCL, CICS, NATURAL/ADABAS, ADASQL, EASYTRIEVE, XGEN 4GL, DB2 Stored Procedures, REXX, RACF.

Databases: BIG DATA, HDFS, HBASE, ELASTIC SEARCH, ORACLE, RDBMS, DB2, VSAM, NATURAL/ADABAS.

Technology Frameworks: Apache Hadoop, MapReduce.

Database Packages: IBM Data Studio, Teradata SQL Assistant, Toad for Oracle, Aqua Data Studio.

Operating systems: Mainframe Z/OS, MVS, OS/390, Windows, Unix.

System Analysis Tools: IBM Rational Requisitepro, Toad for Oracle, Teradata SQL assistant, Share point workspaces.

Development Tools and Utilities: Mainframe Xpeditor, Endevor, Intertest, File - aid, Insync, Hiperstation, SPUFI, SDF-II, Strobe, Tivoli, Zeke scheduler, IBM Data Studio, Teradata SQL assistant, Toad for Oracle.

Testing Tools: Hewlett Packard Quality Center, Application Lifecycle Management (ALM), Hewlett Packard Service Manager (HPSM).

IDE Tools: Teradata SQL Assistant, IBM Data Studio, Toad for Oracle, XGEN 4GL XIDE, IBM Requisitepro, Fiddler Debugger.

Training Knowledge: C, C++, Core Java, Apache Spark and Scala, Apache Kafka, Python, ZooKeeper.

PROFESSIONAL EXPERIENCE:

Big Data Systems Analyst and Mainframe Tech Lead

Confidential

Responsibilities:

• I will be working closely with Confidential Business and IT teams. I will receive Project Requirements Document (PRD) which contains the requirements from the client. I have analyzed the requirements and prepared the cross application Solution Summary Document (SSD) for all the impacted applications EPS, Confidential & FISL in this project, which outlines respective solution for each of the applications for the requirements. I will be preparing the Systems Requirements Inventory (SRI), Requirements Traceability Matrix (RTM) and High Level Design (HLD).
• I will be closely working with the Confidential IT team. I worked on preparation of mapping spreadsheets that maps the oracle RMB data into the columns of the new extracts that are developed in BRMS Data Store application.
• I worked on mapping spreadsheets for the Reinstatements, Unclaimed funds, Paid in advance, Adjustments, Aging extracts.
• I will be closely working with the Confidential Business and IT teams. I will receive Project Requirements Document (PRD) which contains the requirements from the client. I will be analyzing the requirements and will be preparing the Functional Summary Document, Systems Requirements Inventory (SRI), Requirements Traceability Matrix (RTM) and SA Functional Requirement Specification (Also called SA Functional Design).
• I will be working on requirement gathering and analysis including analytical techniques, interview and data gathering techniques to address the requirements, current system flow documentation, business modeling methods, business process rules and logic, development of implementation plans, development of requirements, Solution design meetings, JAD (Joint Application Design) sessions, IRAAD (Issues Risks Actions and Decisions document) sessions and analytical troubleshooting.
• I will pass on the specification to the offshore team, assign the development tasks to the team members and coordinate their work. I will review their deliverables and assist them in timely completion of the tasks.
• For the analysis of requirements, I will be making use of the Confidential various tools and repositories like IBM Rational Requisitepro which maintains all the specification documents with Requirement IDs, Share point work space, COSMOS Project folders, Application Development Repository (ADR), Quality Center, Application Lifecycle Management (ALM), Hewlett Packard Service Manager (HPSM).
• As a technical lead in COSMOS team, I will write the design and identify changes to code components. Then I will be distributing the code components to the team members, mentoring them to do code changes, review their deliverables and unit test results and move the code to UAT, SIT regions. I will be a single point of contact for QA team in case any defects were found in code, get the defects fixed and migrate the code to testing region again. Once QA testing is complete, migrate the code to production in a deployment cycle and provide deployment support.

Technologies: Hadoop Framework, HDFS, MapReduce, HIVE Query Language, PIG, HBASEELASTIC SEARCH, SQL, Toad for Oracle, Teradata SQL Assistant, IBM Rational RequisiteProApplication Lifecycle Management (ALM), Share point work spaces, Agile methodology, MVSOS/390, COBOL, JCL, CICS, DB2, VSAM, XGEN 4GL, Strobe, Endevor, Xpeditor, File-aid, Spufi.

Senior Mainframe Programmer

Confidential

Responsibilities:

• As an onsite coordinator in CLS and Accounts team, I will be closely working with the Confidential Business and IT teams. I will receive Project System Requirements Document (PSD) which contains the requirements of the project from the client. I will be analyzing the requirements, facilitating requirement gathering and analysis sessions. I will be preparing the Systems Requirements Inventory (SRI), Requirements Traceability Matrix (RTM), Detail Design (DD) and pass them onto development team for coding.
• Working on defects which involve analysis, estimates, test case preparation, coding, testing, deployment and documentation.
• Working on anomalies and warranties, which are defects identified in QA testing and in production environment.
• Providing support to Dev, QA teams and providing production deployment support when the project is getting implemented to Production.
• Work on Adhoc Requests and other modules as and when required.

Technologies: Mainframe Z/OS, MVS, OS/390, COBOL, JCL, CICS, VSAM, EZTRIEVE, REXX, RACF, ENDEVOR, XPEDITOR, FILE-AID, SPUFI, SDF-II, Intertest, Hiperstation, HP Quality Center (QC), Zurich Work Product Repository (WPR), WSM (World Sourcing Manager), Lotus Notes, SDLC Methodologies.

Mainframe Programmer

Confidential

Responsibilities:

• Executing Work requests, which involve analysis, test case preparation, coding, testing, implementation, and quality records' documentation.
• Being On-Call Support, Solving Production Abends meeting the terms as per Service Level Agreement, ensure there is a smooth execution of the batch cycle.
• Solving Problem Maintenance Tickets.
• Work on Adhoc Requests as and when required.
• Getting involved in other modules and work when needed.

Technologies: Mainframe Z/OS, MVS, OS/390, COBOL, JCL, CICS, VSAM, NATURAL-ADABAS, ADASQL, Endevor, Xpeditor, File-aid, Insync, Trace Master, Zeke scheduler, HP Quality Center (QC), Share point work space, SDLC Methodologies.