Informatica Cobol

Professional Summary:

An accomplished Informatica & Mainframe Technical Lead specializing in Informatica and Mainframe application design and analysis with extensive experience in the full life cycle of the software design process of Informatica and Mainframe applications.

Over19 years of extensive Software design and development experience with delivering high quality and an assortment of System Integration in Mainframes applications.

Around 5yrs of onsite experience at clients place in handling special projects including the feasibility analysis, requirement gathering, estimating C1 & C2 and executing the project plans.

Strong Data Warehousing ETL experience of using Informatica 10.4/9.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.

Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.

Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

Involved in Release management activities and Disaster recovery process.

Proven technical leadership skills and the ability to lead the team to successful completion of projects. Responsible for offshoring the project and Knowledge transition from onshore.

Good at analytical skills and always strive for working out an efficient product. Excellent as a team player and can also work at individual level.

Areas of Expertise

Informatica 10.4 * PowerExchange 10.4 * Z/OS * Cobol * JCL * JES2 * TSO * SDSF * CA-7 * ESP * FTP * Problem Solving * Monitoring * Excellent Communication Skills Written and Verbal * Life Insurance Software * Auto Insurance * Agile Framework * DB2 * SQL * IBM tools * VSAM * Xpeditor * DBVisualizer * SPUFI

Professional Experience:

Reinsurance Application Development, Liberty Mutual, NH July 2013 to Till Date

Informatica & Mainframe Application Technical Lead

Long Term Projects:

New Entity code project:

As part of compliance with Revised property and Casualty Reinsurance, URS systems are updated to accurately record assumed reinsurance on the originating contractual entity to support the year-end STAT reporting. This project involved in enhancing and adding new components in both Informatica and Mainframes.

Roles &Responsibilities:

•Responsible for Business Analysis and Requirements Collection.

•Parsed high-level design specification to simple ETL coding and mapping standards.

•Worked on Informatica PowerCenter tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

•Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

•Created mapping documents to outline data flow from sources to targets.

•Design and Update/developed new mapplets using several widely used transformations.

•Work with Unix server team to create the new folders and updated the parameter files.

•Create new conversion tables and process the initial load.

•Create new Cobol programs to handle the new entity codes and reclass process for schedule F process.

•Update/create the parameter files, connection configurations.

•Run the multiple test cycles.

•Responsible for production implementation and support on the first run.

Ceded Loss Process – Duplicate ID-Claim

Duplicate ID_Claims an issue triggered when split project went wrong at upstream system resulting in Reinsurance overriding commercial Insurance data with Personal Insurance data causing huge financial variances and missing claims.

Roles &Responsibilities:

•Responsible for performing analysis of Duplicate ID-Claim issue having major financial variances due to upstream systems mishandling with split project and come up with solutions.

•Responsible for proposal, leading analysis & design and developing a solution by writing new Cobol programs and JCLs with procs and jobsysins, creating multiple conversion tables.

•Responsible for creating new production jobs as part of pre-CLP process.

•Coordinated with upstream system in getting the test file and run the multiple test cycles to test the code and validate the results.

•Responsible for production implementation.

IBNR (Incurred but not reported) process migration.

This is part of Migration project from Mainframes to Informatica.

Roles &Responsibilities

•Responsible with study the existing mainframe process and come with flow diagrams and solutions to prepare technical specification for implementing in Informatica.

•Responsible for preparing project scope, Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.

•Code to Build Informatica mappings and workflows to develop IBNR prior and current year process in Informatica and stage the file for mainframe process. Create multiple supporting tables to process IBNR feed.

Responsible for working with Data service group to create the new connection profiles for IBNR.

•Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs in ESP along with parameter files.

•Unit testing and Test runs.

•Responsible for Production implementation.

Ceded Loss process for SAFCO feed

Post merging with SAFCO, SAFCO decided to report its claims to Commercial Reinsurance via Loss data warehouse that feeds Ceded Loss Process (CLP) for Reinsurance business users.

Roles &Responsibilities

•Responsible for performing impact assessment with SAFCO feed process in Reinsurance Ceded loss process.

•Prepare design document, developing the code to incorporate the new feed process in existing process.

•Responsible for testing and implementation.

GRAD, HFM Interface implementations

Corporate IT has a new Database (GRAD – Global Reinsurance Accounting Database) to store the CI,

LIU and Ironshore data. The GRAD Database sends the Ceded Premium, Paids, Reserves, and Miscellaneous amounts to CM URS in the 215 file format at the pre-determined scheduled timeframe for the month. Corporate Reinsurance Financial was in need to create three separate interfaces to use the Database as the primary source for Bordereau Reporting.

Roles &Responsibilities

•Responsible for feasibility analysis for implementing GRAD feed with Ironshore, CI and LIU feed and HFM feeds and come with C1 and C2 estimations.

•Responsible for design and prepare technical specification documents for each interface.

•Be part of developing the new programs and JCL, Procs and jobsysins.

•Responsible for scheduling the job with file triggering events in ESP.

•Testing to receiving business sign-offs and production implementation.

Improvements & Support

•Responsible for identifying and building Cobol Code, JCL, proc, and various jobsysins library definitions/rules in order to maintain and support online and batch processing in multiple non-production environments.

•Responsible for stream lining the various restore processes to ease the developers tasks.

•Worked on conversion of FTP to SFTP for all impacted JCLs and Procs.

•Support/running batch cycles, building calendars, scheduling, building balancing jobs for ftp/mainframe data moves and reports, incident tracking and implementing permanent solutions for abends, cycle status reporting.

•Created and introduced several new report jobs in batch process that generates reports financial balancing reports.

Handled requirement gathering from business and estimating the effort, business calls for clarifications, technical design document preparations, code construction, Unit/Business testing, Implementation.

•Ensuring the knowledge transitions of Functional and technical aspects of the various enhancements to support team.

•Coordinate with offshore team in delivering the assignments. Reviews and Quality verifications.

•Involved in trouble shooting the incidents reported in production and liaison with team for permanent fixes.

Brokasure Desktop & Enterprise, Xchanging Solutions, UK Aug 2009 to July 2013 Project Technical Lead

Roles &Responsibilities

•Performed the feasibility analysis on the system by studying the business objects & technical complexity and provided the extracted inferential statistical information to the Project management to initiate the project at off-shore.

•Was part of recruiting and build the team and transition for application support activities from offshore.

•Handled the client specific development activities that involve in creating a new business in existing Brokasure system by importing the xml formatted Risk information logged in third party application.

•Worked in gathering the requirements for enhancements in billing and invoicing modules and involved in design and constructions.

•Involved in trouble shooting the issues in production and written several bug fixing and programmed business split between the clients business.

•Handled the knowledge transitions of Business and technical aspects of the Brokasure system with SMEs.

•Proposed and designed several enhancements/improvements to the existing system by automating the batch scheduling process as a value-added service to the clients which is known as pride in the product.

Mecca - Automatic Renewal System, Liberty Mutual, IN Aug 2008 to Apr 2009 Team Lead

Roles &Responsibilities

•Served as a point of contact for development team and part of designing the architecture by obtain the requirements from the BA group/System Analysts and prepared the detailed design documentation for development phase.

•Worked closely with QA and UA teams to obtain the signoffs on all the test cases designed.

•Handled responsibilities of migration of all the components developed via Endeavor for installation into production.

•Lead and coordinated the offshore team; maintained a goal-oriented environment to meet the deadlines of this project.

•Achieved a perfect integration with Application Quote system that deals with policy rating and issuing the policies for further process with the help of Application Quote system team.

Was part of project planning and drawing the delivery time lines for the project.

AQS/Mecca – Policy Management System, Liberty Mutual, IN Apr 2005 to Apr 2009

Team Lead/Onsite Coordinator

Roles &Responsibilities

•Handled On-call activities for Production Batch cycles and Daily QA & UA cycles.

•Implemented several Batch & Online applications and worked as a point of contact for the projects that deal with department of motor vehicles (DMV) for several states in USA. Written several jobs that run as part of the daily production cycles to report to the State DMVs through B2B solutions.

•Efficiently handled activities of bug fixing and implementation of new or amended business requirements within the existing system.

•Handled ad hock requests involve in Query & Report generations.

•Gathering the technical and functional specifications of various Projects at Onsite from the Business analysts for implementation at offshore and transferred knowledge to the offshore resources. Mentor team and ensure the timely deliverables. Manage time effectively to meet defined timelines and keep Project Manager updated.

•Worked on interface process between policy system to Billing system.

•Being a release Coordinator, Handled Release activities which take place at every second week of the month. Defect management and reporting to the Release management. Involved in Disaster Recovery process occurs in every six months.

Policy Management System, National Life Group, Hyderabad, IN May 2002 to Mar 2005

Software Engineer

Roles &Responsibilities

•Executing work requests that involve analysis, coding, testing, implementation and documentation.

•Support batch production cycles and monitoring.

•Involved in Bug fixing.

•Impact analysis and preparing the technical design documents and test cases.

•Modifying existing programs according to the requirements.

•Involved in code changes and code reviews. Ensuring timely deliveries of work requests.

•Coordinating with team members.

Contact this candidate