Software Engineer Senior

Gopal Reddy

Email: ***********@*****.*** Mobile: 848-***-****

Summary:

• Over 13+ years of Professional Experience in Planning, Analysis, Design, Development, Testing, Implementation and Deployment of applications using Mainframe technologies.

• Hands-on experience in programming with extensive knowledge of application development and support in COBOL, CICS, TSO, JCL, VSAM, DB2 and IBM Utilities.

• Strong business understanding of domains like Insurance, Brokerage, and Investment Banking.

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

• Involved in Release management activities and Disaster recovery process. Areas of Expertise

Mainframes: Z/OS, Cobol, JCL, DB2, CICS, VSAM, TSO, MQ, SDSF, CA-7, CA-ESP, FTP/sFTP, File-Aid, Endevor, Changeman, QMF, SPUFI, IBM tools/Utilities, SAS Reports, Sort Utilities, Easytrieve, Xpeditor.

Databases & Tools: DB2, IMS-DB, MSSQL Database & Server, SQL, Oracle, Stored Procedures, DBVisualizer, Dbeaver, TOAD, IBM Data Studio. Power BI Reporting tool. Business Domains: Life & General Insurance, Health Care, Banking. Others: Agile Framework

Working Knowledge: Trained on Cloud Technologies Informatica IICS, Informatica PowerExchange 10.4, Java, Assembler, Python, Working experience in GitHub & Stonebranch and Distributed Technologies. MS Office, Agile Framework

Professional Experience:

Reinsurance Pro, DXC, Liberty Mutual July 2023 to Till to Date Senior Software Engineer

• Created several jobs and Cobol programs for Journal data conversion and aggregation to eliminates data redundancy and improve the batch and online application efficiency.

• Developed new batch and online programs for reinsurance using Cobol, VSAM, DB2 and CICS.

• Prepared technical specifications of existing Reinsurance Mainframe application for new developments in Informatica migration project.

• Design and creation of the SQL database in both test and production environments.

• Execution of vendor scripts to convert database object from DB2 to SQL database as part of migration.

• Worked on SLIM Integration – setup of SBI SLIM integrations for all external/internal Interface files to AWS S3 buckets.

• Developed ETL process for DB2 to SQL database restoration process.

• Prepared and scheduled several Unix based jobs in ESP for job executions with file triggers.

• Worked on creating the database connections for Informatica and Power BI and SQL Server. Claims Project, BCBSMS, MS Sept 2022 to July 2023

Software Engineer

• Responsible for designing the framework for automation of existing manual process of GoAnywhere monitoring system.

• Analyse the existing Claims and MDI systems intake process and prepare the design document for development working with business owners.

• Develop new COBOL programs, New Jobs with setting up the schedules, Design and Creation of new DB2 tables.

• Developed CICS new programs for claims process.

• Experience with EDI transaction sets and processing, especially with EDI 837 and handled daily health-checks and follow up on MQ infrastructure issues.

• Worked on COBOL stored procedures to improve the performance and fine tuning the SQL queries working with DBA groups and Java front teams.

• Worked on product version upgrades and performed the impact assessment and modified the existing mainframe components and tested for deployments.

• Handling the Enhancements Providers Data Quality project in phases by writing new or modifying the existing COBOL Stored procedures.

• Regular maintenance of manual claims release for overnight process for adjudication team.

• Handling the incidents raised by the subsystems and business users. WMA, UBS, NJ May 2022 to Sept 2022

Senior Software Engineer

• Responsible writing new/modifying the existing CICS programs for distributed applications. Code review and testing.

• Write Native and Cobol Stored Procedures and Test them working along with Java frontend API services. Convert the exiting Cobol stored procedures to Native stored procedures.

• Work with BAs to get requirements for new Product analysis and design based on existing legacy application retiring soon. Perform impact assessment and build new components.

• Responsible in handling support activities of multiple applications with regular database updates/corrections of FAIDs, auto balancing and querying the database for report generations.

• Responsible in handling enhancements to existing functionalities for downstream systems.

• Production support to multiple applications working with the external teams working on wide range of technologies.

Reinsurance Application Development, Liberty Mutual, NH July 2013 to May2022 Mainframe/Informatica, Senior Software Engineer

• Responsible in gathering initial requirements from business groups and convert them into technical specifications and prepared workflow diagrams.

• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.

• Design and Update/develop new mappings/mapplets/worklets in Informatica and create new Cobol programs to handle the new entity code project and reclass process for schedule F process.

• Create new conversion DB2 tables and process the initial load using DBVisualizer.

• Developed COBOL DB2 Programs and JCLs to process the staged file from Informatica process. Update/create the Unix parameter files for Informatica workflows, setting up connection configurations.

• Performed the multiple test cycles recording the test results and worked with downstream systems to ensure the data consistency.

• Responsible for production implementation and support on the first run. GRAD, HFM Interface development & implementations, IBNR Process migration.

• Responsible for gathering initial requirements from Business, feasibility analysis/Design/Development for implementing Interface feed with Ironshore, CI and LIU feed and HFM feeds into Reinsurance applications.

• Responsible for design and prepare technical specification documents with estimations.

• Programmed several components in Cobol, JCL, VSAM, DB2 & SORT Utilities.

• Design, Coding and testing of new DB2 Stored Procedures for CRCS front-end application for business use.

• Developed and Tested COBOL and CICS programs with DB2 to allow business users to manual claims.

• Prepared/Reviewed the Unit test cases and validation of test results. Coordinated with Business users for UA testing.

• Responsible to performing a study the existing mainframe process of IBNR Prior & Current year and come with Informatica flow diagrams and solutions to implement in Informatica as part of application consolidation program.

• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union transformations.

• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.

• Responsible for design and creating several DB2 tables to support the Informatica process.

• Queries the existing database for extracting the data and performed the initial extracts and loads to support IBNR process.

• Responsible for creating the new connection, Write Unix script for workflow executions.

• Unit test cases, validations, and reviews on offshore code and for Production implementation.

• 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.

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

• Created and introduced several new jobs that generates SAS reports post Teradata updates in batch process that generates reports financial balancing reports.

• 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 Senior Software Engineer

• 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.

• Handled the client specific development activities involving developing new Cobol programs and jobs for 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.

• Written several Wang Cobol programs for batch process for the enterprise application with VB frontend and Oracle as database.

• 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.

AQS/ Mecca – Policy Management System, Liberty Mutual,IN Apr 2005 to Apr 2009 Software Engineer/Onsite Coordinator

• 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.

• Coded several new Cobol DB2 programs for automatic renewal process.

• Several jobs are written to load and unload data and create reports for business.

• Worked on design & development of new COBOL/CICS programs and modifications of existing applications

• Developed new/modified CICS screen for business users to feed the AQS Mecca screens to capture the renewal data and process against DB2 tables.

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

• 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 SQL Query & Report generations for business.

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

• Handled Release activities, Defect management and reporting to the Release management.

• Involved in Disaster Recovery process occurs in every six months. Academic Profile:

2001 – Post Graduation in Management Information Systems & Computer Applications from Osmania University.

1995 – Graduation in Applied Chemistry from Andhra University.

Contact this candidate