Data Analyst

Uttam Malhotra

** ********* *****, **** *********, NJ 08816

1-732-***-**** • *****.********@*****.*** • WWW.LINKEDIN.COM/IN/UTTAMMALHOTRA

PROFILE Over 18 years IT experience as Sr. Analyst in the area of business, system, program & data analysis, design and development of business applications for Property and Casualty Insurance, Mortgage and Service Industry having experience in different phases of Software Development Life Cycle with waterfall & Agile approach. Understand the project scope; prioritize the business requirements, client expectations, dependencies, implementation, testing etc. Experienced working independently and/or with multiple teams ranging from business & IT across multiple streams, I have excellent communication and interpersonal skills and I am dedicated, fast in decision-making and can handle multiple tasks with possess strong analytical and problem-solving skills with competent planning. Ability to adapt to changing environments and accustomed to working in various capacities, Experienced working on implementation and maintenance of Policy system, Billing system, Reinsurance and Claim system, ISO reporting within Property & Casualty and Commercial and Specialty insurance.

EXPERIENCE

11.15 – Present Sr. System/Programmer Analyst Commercial & Specialty Insurance

Liberty Mutual Insurance

Genius AS400, I Series, Cobol, Rating, VBA, Java, Java Script, MS Access, MS Excel, SQL, RPA, Blue Prism, JSON, SharePoint

Analyzed, Designed & Build interactive and batch query report from DB2/400 tables of Genius AS400.

Configuration and setup Fireflash rating engine in AWS

Analyzed, Designed & Build automated (RPA) modules to integrate applications with each other’s by minimal user intervention.

Build and configure Rating module in Unqork platform

Involved in Rater Projects for underwriters and program administrators, to analyze requirements, design layout and structure development for products such as Professional Liability for Accountants and Lawyers, Management Liability of Directors and Officers, Insurance Agents and Brokers, Medical Professionals, Private Equity, REITs, Architects and Engineers for E/O. Supported end-to-end testing by all stake holders such as compliance, legal and underwriting users to meet their user’s expectations..

Involved in robotics automation project under Blue Prism, VBA, JSON to reduce redundant, duplicate task for gaining more efficiency in day to day activities at various levels of business management.

Analyzed, designed, implemented and managed Modular workup and rating solution for private advantage, Crime & KRE products where all data feeds were setup to send and receive information automatically and integrated with policy system.

Lancer claim files synchronized under windows file structure to merge in a pdf file based on claim number, document type with total number of pages.

Analyzed, Designed & Build User Request Form template in MS Excel for new PAS system as PQM(Product & Quote Manager)

An Adobe PDF application integrated with MS Excel and Access to read data from A&E - DDI application form and save data to access thru spreadsheet and vice versa to fill same application form on renewal.

Responsible for projects to migration and maintain of existing company’s website ae-libertyiu.com and LIURisk.com into SP’13.

Responsible solely in projects to analyze requirements from ISO, design and build rater application for Crime and Fidelity product. Also integrate this rater application with various subsystems to sync in batch process to populate data and other tools such as Quote Letter, Policy binder along with letters and forms.

Analyzed, designed, implemented and managed rating solution for specialty product where all data feeds were setup to send and receive information automatically and integrated with policy system.

03.07 – 10.15 System/Programmer Analyst Property / Casualty Insurance Consultant AIG Private Client Group Business Technology ePCG-WINS Insurance on AS400/Cobol/RPG/SQL/Java, I Series, OpenL, VB

Involved in rating projects for Canada Homeowner, Excess Liability, Collections products in Premier project to analyze requirement from actuarial, construction of user interface, endorsement forms mapping, print coverage letters and data mapping with business stake holders to get complete preparation of business requirement documents, functional requirements, design document and approve test plans before development to get the project accomplished.

Involved in to get the requirement, user stories, and use cases for new user interface, rating algorithm, data migration for Collections or Personal Inland Marine (PIM) product from legacy system WINS to HNW (High Net Worth) consumer insurance platform with on-site / off-shore business partner development team.

Involved to analyze data management and mapping from Legacy mainframe system to Guide wire. A complete process to gather information, analyze data and contents needs to be used in the documents generation, the actual format and layout using under xPressions for products as Homeowner, Dwelling, Umbrella and Workers Comp. DMD mapping process placed in Doors which used to populate data in XML format from various sources of Guide wire Policy Admin System (PAS), Claim system.

Using application such as Rationale rose, publishing tools and Doors of IBM, the complete Document management requirement processed to develop by Vendor, performed unit testing to meet the end user’s criteria.

Perform GAP analysis, identify use cases and create UI mockups on required Policy Center functionality.

Investigate & troubleshoot production issues and defects to enable issue resolution.

Work with development to propose solutions on issues, production defects and enhancements.

Analyze Policy Center to ESB and ESB to xPression XMLs to investigate existing issues.

Work with business users & product owners to elicit business requirements & analyze requirements.

Review Policy Center user story requirements with development & QA and provide on-going support.

Conduct application demos and user-stories acceptance meetings with business for sign-off/acceptance.

Use JIRA to provide estimates on tasks, burn down hours and create new tasks as required.

Attend daily scrum to provide daily status, highlight blockers and communicate overall progress to team.

Produced SRS requirements documents and created letter requirement templates for Documents stream.

Develop data transformation & data translation rules as part of mapping task from (PC to ESB integration).

Implement approved enhancement requests as required by the business from Product backlog.

Work with system architects to validate future state data system design to support business requirements.

Support business users from inception to post-production on system issues encountered.

Authored test cases and performed end-to- end testing of Policy Center on Workers Comp and Personal Home and Auto.

Working on various process policy workflows ranging from Policy Issue/New Submission, Policy Change,

Renewal, Cancellation, Reinstatement, Re-write. Support Underwriting, Engineering & Premium Audit groups.

Responsible for meeting with business stake holders and understanding the new requirements, preparing business requirement documents and working with the vendor to get the project accomplished.

Extensive enhancements completed in WINS to adopt new features in Policy, Claim and Billing modules.

Modified existing structure of file management system in WINS application to cover up new tables required to incorporate in DB2/UDB.

Extensive use of embedded SQL in new or existing COBOL modules of WINS application.

As analyst worked for migration project of property and casualty line of businesses with vendor company Cognizant in respect of Rating templates, User Stories for User Interface, Integrate Endorsement Forms, Print documents for Dec. pages.

Involved as analyst for One Claim system of AIG to integrate with WINS legacy Claim / Stat reporting system.

Analyzed business requirements, prepared functional and technical specifications and coordinated with user requirements under BRD (Business Requirement Documents) of corresponding SER (Service External Requests) and SIR (Service Internal Requests).

Analyzed production bugs or internal bugs from HP Quality Control Defects management system to complete projects on-time.

Analyzed Designed Developed GLM (Generalized Linear Module) Rating projects involved with on-site and off shore team for ePCG-WINS and PCS-Premier of CLP (Consumer Line Platform).

Analyzed, Managed and implemented compliance with insurance regulatory agencies for both US States and Canada provinces for Statistical and Bureau reports

Involved in the implementation of the Texas Reporting Modifications TICO and also be able to report to the state of Texas. Development and maintenance of the above mentioned changes.

Extensive work performed as writing new modules, modified existing modules in WINS application for coverage enhancements of personal and consumer line products to comply with State, ISO and internal requirements.

Analyzed, Developed and implemented mapping and updates of External Losses from Clue report to WINS External Loss File.

Analyzed, Designed, Developed and implemented Auto-Tiering process for rating purpose of US Homeowner (HOP), Canadian Homeowner (CHO) / US Personal Auto (PAP) in WINS Policy Modules under RBP 1.0, RBP 2.0(Risk Based Pricing).

Analyzed, Design to setup process for FTP upload download of daily batch renewal reports.

Analyzed Design and implement Automatic Premium Modification policy module with Batch Renewal Processing. (A list of dollar amount of each policy provided by Actuarial processed in WINS with appropriate Reason / Retention codes).

Studied business requirements, prepared use cases, designed functional and technical specifications, and prepared test cases for various WINS application modules.

As an analyst worked with team of members to design develop Personal Earthquake (PEQ) product integrated with Homeowner product for state of California.

Analyzed Design, Developed, Implemented, Enhanced and Maintain WINS application of Property and Casualty businesses for products of Homeowners and Personal Auto, Personal Excess Liability, Watercraft and Collections lines of business, Excess Flood, Personal Inland Marine, Flood and Personal Earthquake related to Policy module, Ratings modules, ISO Stat reporting, Coverage Endorsements Forms setup for Print and Declaration papers.

Analyzed, designed the integration of automatic fixed % commission for non-FL brokers to write business in FL based on wind / non-wind risks and or multi location policy with policy underwriting system to billing system.

Designed and developed the integration of automatic rating with policy underwriting system.

Analyzed, designed, implemented and managed a solution where all data feeds for Yacht product were setup to send and receive information automatically and integrated with WINS policy system.

Involved to design, develop WINS modules to feed claim information from CLUE/Choice Point to WINS, DB2 database. The rating application and Predictive modelling further dependent to analyze this information.

Involved with WINS Claim system maintenance to design develop further enhancements for Claims Processing, Reserve amounts, Adjuster, Loss and Expenses.

09.06 – 03.07 Programmer Analyst Loan Management

Wachovia aka American Mortgage Network (Am Net)

Loan Management System (LMS) on Cobol/400 & ILE and CICS, Mainframe

American Mortgage Network (Am Net) is a wholesale nationwide mortgage bank and a wholly owned subsidiary of Wachovia Bank, N.A. (NYSE: WB). The Company is headquartered in San Diego, California. This Company is using their own in-house developed LMS System.

This system runs under I5/OS of AS400 with CICS/400 environment using IBM databases on transaction basis as it works under CICS (Customer Information Control System) of Mainframe. Various Loan Origination Systems like DU, Calyx etc. access this LMS to generate records for Residential Mortgage Loans. I involved with 6 members of team to migrate the source and objects with data files of LMS system from Am Net environment to Wachovia environment. Developed further new enhancement for modules which required on the web-interface for AUS (Automated Underwriting System) collaborated with third party vendor’s software i.e. Mind Box and maintenance of existing source codes as per user requirement for different products running for the business. Developed transformational roadmap to guide the Loan Management technology team to execute on the defined requirements.

Defined testing strategy and managed User Acceptance Testing (UAT) for future state operational processes consistent with restructuring various Agents on network into a limited purpose. Developed and executed test cases, test scenarios and scripts, created user stories, use cases and data sets, while maintaining Business Management responsibilities for the test process throughout the project life cycle. Interacted with business, operations and technology stakeholders, including third party institutions and vendors that will assume outstanding banking balances and service firm’s clients. Provided comprehensive assessment of test results, issues and defects management and stakeholder buy-in for defining mitigation strategies.

02.06 – 08.06 Programmer Analyst Property/Casualty/Commercial Insurance

Hartford Financial Products (HFP)

Genius Insurance System with Web Interface ViSion on Cobol/ILE, I Series, VBA

Involved as System-Analyst and Programmer in building web-based interface between Java based front-end application and WINS Policy/Claim systems using Data Q to exchange data & information.

On-Line PDF Application for Brokers to submit information of policyholders an initial stage from a web interface using dynamic SQL embedded with COBOL programs.

Involved as system analyst for development of application support of Genius Policy Admin system on AS/400.

Involved for development of batch FTP process & Interface to receive and send data/files to and from the AS/400.

Involved as analyst to design and build various reports on Claim and Reinsurance files from WINS system.

01.04–01.06 Programmer Analyst Property / Casualty Insurance

Capitol Indemnity Corp Information Technology

WINS Insurance application on AS400/Cobol

Involved as System-Analyst and Programmer for analyzing and fixing problems faced by users on legacy system WINS of Insurance Business. Prepared program specifications and allocated modules to developers, co-ordinate with the users and development team.

Designed, devolved and maintained daily DCPR report (Daily Comparative Premium Report) from Stat Master file based on earned and unearned premiums.

Involved in below under accomplished projects: –

E-Portal – A web-based interface used by Agents to get information from AS400. A process was created to send & retrieve information from WINS database based on the request send to AS/400 Data Queues.

Cold-Import – Build a process to create PDF files for Agency reports from spool files generated by different reports in WINS. The individual PDF’s were then transmitted thru FTP process to assigned Agency folders.

Dean-Loomis Interface – Build an interface to load Policy & Claim records from a CSV file into WINS. The CSV files from Deans & Associates would come periodically, the front-end process sends a trigger file with a header record, and interface program on AS/400 is invoked from a trigger program assigned to the file.

Image Right – Process to create individual report of a policy as declaration page in PDF formats to be sent into drawers managed by third party application.

Designed and developed a diary system that would help the client’s setup claim teams and monitor their progress.

CAS Elimination WINS 2 SBS – Client has two-sub application running parallel to WINS – CAS (Collateral Application System) & SBS (Surety Bond System) Migration of CAS & SBS Subsystem data to WINS and maintain bond claims of SBS in WINS.

Collateral Sub-System – Designed a new Collateral application to work with WINS system. SBS – Build an interface to bring Bond data to WINS on a daily basis to process claims in WINS after the CAS Elimination.

10.01– 12.03 Programmer Analyst Property/Casualty Insurance

Fairfax IT Services - Crum and Forster

Wheatley Insurance System (WINS) on Cobol/400, AS400

Designed and developed the integration of automated rating with the policy underwriting system.

Streamline month end processes and automate aging report for the accounts receivable department.

Crime 2000 updates to the WINS system with form dependent reference table used for Crime 2000 class verification.

Void and revised audit processing changes made to the WINS system where a void audit can be processed after a final audit. The program will generate the offsets and create a void. Changes made to all the policy inquiry programs to reflect the current status of the policy.

Reinstatement of flat cancellation–Allow the user to reinstate a flat cancelled policy based on a flag in the Cancel/Non-renew table that will allow or not allow the user to do so.

Booking report – A daily extract generated for all the policies booked every day.

Excess Property – Added a new module to the Excess Liability product (ELP) in WINS for Property written in excess limit.

Involved in implementation of 3rd party tools - ROBOT from Help/Systems.

Designed and developed the Homeowner product with automated rating.

Designed and developed programs to restrict the users based on user type such as Employee, Agent and Sub Producer. Users will be allowed or denied access to different sections in WINS Such as Policy, Claim, and Quote etc. depending on the rights setup in the system. The system can also restrict the users to a maximum coverage limit for each policy form.

10.99 – 09.01 Programmer Analyst Information Management

First American Registry

Portfolio Management System on RPG/400 & RPG-ILE, AS400

Worked as part of a three-member team to develop, implement and maintain the system to monitor the securities of the company delivered on account of Sundry Debtors, Inter Corporate Deposit, Leasing and Hire Purchase Activities.

The module also dealt with the purchase and sale of the company’s own portfolio consisting of Shares/Bonds/Debentures. The package included monitoring the dividends, interest, commission due and payable, and shortfall of securities against financial transactions and the delivery and receipt of securities.

03.99 – 09.99 Programmer Analyst Property / Casualty Insurance

American International Technology Enterprises (AITE)

Wheatley Insurance System (WINS) on Cobol/400, AS400

Involved in the in-force conversion of policy from the legacy system to the WINS system for AIG’s client Robert Plan Insurance.

EDUCATION

Bachelor Degree (Honors)• Calcutta University

Member with P/C Insurers Assoc. of America pciaa.net

TECHNICAL

SKILLS

MS Office (Excel, Word, PowerPoint, Access) • Agile/SCRUM • Confluence • MS Project • Visio • SQL • HP Quality Center • Open L • Jira • ROBOT • MQ Series • Data Q • Hawkeye • DB2 • MSSQL • Oracle • Eclipse • IntelliJ • XML Spy • Cobol400 • RPG400 • CL400 • Full SDLC Life Cycle • Java • Java Script • C++ • Query • VB Macros • QM Query • JCL, CICS, DB2, UDB, Many other applications within Insurance / Financial Services domain, Doors and Rationale Publishing of IBM, Excel VBA, Implementer, Turnover, Share Point, RPA, JSON, MySQL., ESEND, MangoDB, Fireflash, AWS, Salesforce, Python..

REFERENCES

Available upon request

Contact this candidate