SUMMARY:

I have been working as a Confidential associate since 7 years. Currently working with the designation of Assistant Consultant. Within this time, I have achieved technical excellence in the field of Java/J2EE, JavaScript, PL/SQL. Mainly I have worked in the production Support of PLCS Claim systems also involved in enhancement, development and up - gradation of running production environment.

AREAS/APPLICATIONS:

• Java, PL/SQL, Unix, Mainframe
• Windows XP, Windows 7 UNIX
• JAVA 1.5, J2EE, SQL, PL/SQL, UNIX Shell Script, Pro*C, Micro Focus COBOL
• Eclipse, Rational Application Developer 7.0-8.5 as development IDE, Web Services, Oracle 10g (RDBMS), PL/SQL Developer, Putty,Serena-Dimension, Visual Source Safe(VSS), Incident Test Service Management (ITSM) system, Quality Control (QC) system, Attachment Reflection, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential

Assistant Consultant

Responsibilities:

• Review data profiling reports with Farmers SME to devise data cleansing rules
• Create scripts for data cleansing to be done in Source Staging Database
• Testing support and defect fixing for legacy data extraction, reconciliation, data profiling and source staging cleansing during Build and Stabilization
• Attend meetings for the new business requirements.
• Create the draft documents of the SRS based on the Business Requirement Document (BRD).
• Do a technical feasibility study coordinating with off-shore team.
• Co-ordinate with business team for finalizing the requirements.
• Develop detailed Integration Sprint Plan - Detailing the Integration Sprint Plan to activity level
• Conduct and support workshops and coordination activities for design artifact data collection, review and approval process
• Design Artifact Creation (IDD, Mapping Excel, WSDL and Schema) for Middleware Integrations.
• Coordinate with offshore development team(s) to identify priorities and update scope and delivery schedule
• Develop Middleware integration code and perform Unit testing
• Develop LOB Mapping
• Develop Unit to Exposure Mapping
• Development and unit testing of Legacy Data Decryption routine for encrypted fields in HEART and NWCS database
• Analysis of legacy entities to identify Data Profiling Rules
• Design Data Profiling Scripts and Execute data profiling scripts and create profiling reports to support physical data mapping
• Review data profiling reports with Farmers SME to devise data cleansing rules
• Create scripts for data cleansing to be done in Source Staging Database
• Defect fixing for legacy data extraction, reconciliation and Stabilization Pilot implementation support.
• Environment setup
• VDI provisioning
• GitHub and Repository management
• Resolving access issues

Hardware: Windows 7 based PC

Operating System: Windows 7

Languages: Java, J2EE

Database: Oracle

Confidential

IT Analyst

Responsibilities:

• Monitor application health and detect anomalies in performance. Analyse user requested change requests and reported incidents.
• Perform initial root cause analysis, troubleshoot and locate the source of problem and provide a solution, fix and workaround for the same as appropriate.
• Organize triage call with all relevant teams and stakeholders.
• Co-ordinate with offshore counterparts track and report progress on ticket closure and send periodic updates to all. Update the known error database and close ticket with all details.
• Support ad hoc requests from business and internal users. Publish SLA Adherence reports to Confidential and client management.
• Propose the new enhancements and implementing the same over the existing business functionalities.

Hardware: IBM System z 2097-408IBM

Operating System: Windows 7, IBM z/OS 1.11

Languages: IBM Enterprise COBOL for z/OS 4.2.0, JCL, EasyTrieve, Java

Database: DB2

Special Software: TSO/ISPF, Endeavor,Tivoli, Tealeaf, RAD

Confidential

Systems Engineer

Responsibilities:

• Analysis of the current mainframe system.
• Extraction of rules from the existing legacy system.
• Moulding of extraction rules into pseudo codes for the implementation of revamped forms generation system.

Hardware: Windows 7 based PC

Operating System: Windows 7

Languages: Java, SQL

Database: DB2

Special Software: Rational Application Developer 8.5 as development IDE

Confidential

Systems Engineer

Responsibilities:

• Preparing the Software Specification Documents.
• Preparing the High Level Design (HLD) document as per standard 21st Century Insurance and Financial Services - Confidential HLD Template.
• Preparing the low level design documents (LLD) as per standard 21st Century Insurance and Financial Services - Confidential LLD Template.
• Developing and testing Java and PL/SQL code for PLCS components and interfaces using Rational Application Developer and PL/SQL Developer.
• Mapping and code development, writing Pro*C batches and UNIX shellscripts for the batches.
• Designing the Process flow for surcharging of APS policy in DRC Policy system.
• Checking 21st Century Insurance and Financial Services - Confidential standards using the JavaScript, PL/SQL, Java Coding standards.
• Managing the configuration and controlling the versions using Serena.
• Developing stored procedures using the PL/SQL Developer tool.
• Preparing the System Test Plan (STP) as per standard 21st Century Insurance and Financial Services - Confidential STP Template.
• Monitoring Defects
• Closing defects as per the 21st Century Insurance and Financial Services IV&V standards.
• Monitored daily and monthly batch jobs by checking logs and Autosys status
• Performed daily requests from Onsite person
• Monitoring and supporting of Web service interface, Statistical reports, Index feeds generation, Surcharge reports and regular batch feed generation, etc.
• Provided data fix when ever required
• Resolved daily defect tickets
• Performed extra cycle job run whenever required

Hardware: Windows XP based PC.

Operating System: Windows XP,Unix

Languages: Java,PL/SQL, Shell Script/Unix,COBOL

Special Software: Rational Application Developer 7.0 as development IDE, PL/SQL Developer, Attachment Reflection, Putty, Microfocus Cobol Compiler

Confidential

Trainee

Responsibilities:

• Gathering requirements.
• Analyzing requirements.
• Use case designing.
• Preparing the High Level Design (HLD) document as per standard Confidential HLD Template.
• Preparing the low level design documents (LLD) as per standard Confidential LLD Template.
• Developing code according to use case.
• Integration with main module.
• Testing the developed code.
• Documentation of the implementation.
• Requirement analysis of the project.
• Requirement documentation i.e. preparation of HLD and LLD.
• Developing the code according to the requirement.
• Integrating modules.
• Documentation of code.
• Testing code according to UTP.

Hardware: Windows 7 based PC.

Operating System: Windows 7

Languages: Java, SQL

Special Software: Eclipse, PL/SQL Developer, Oracle 9i