EXPERIENCE SUMMARY: 

• Senior Project Manager/Archiect with extensive insurance industry domain expertise. Executed many projects for major insurance carriers including CONFIDENTIAL, ACE, Prudential, Fairfax, Selective, GEICO, Cigna, etc.
• Expert with project management methodologies, tools and techniques. Extensive knowledge on Project Plan preparation, Risk management, Project Execution and Control and Project Closure.
• Technical skills include application and data architecture, business Intelligence, data warehousing, logical and physical data modeling, high-level business analysis, design using Microsoft, Java and Mainframe technologies.
• Responsibilities include relationship management, strategy planning, and implementing large projects using state of the art technologies as well as managing and leading large development teams.
• Expert at managing projects in the onshore/offshore model.

PROFESSIONAL EXPERIENCE:

Business Software Solutions February, 1996 to present

Client: Confidential

Developed and managed Confidential’s business intelligence tool – Answergen. The product is a web based analytics tool use by several industry areas including insurance, distribution, health care, and franchise operations. The product includes and ETL process that takes data from any source and creates a SQL Server data warehouse and cubes. It is a web based application that allows the User to manage their own Dashboards, Analytics and Detail reports.

Client: Confidential

Claims Reinsurance (SCI) application

Responsible for leading a team of over 30 developers charged with developing the CONFIDENTIAL Claims Reinsurance (SCI) application. To maximize component-based build strategy, the total system was divided across multiple layers. Netegrity’s SiteMinder was used for centrally managing authentication and security for the application. The SCI application implemented role-based security using iPlanet’s LDAP Server as a central repository for storing and managing identity profiles, access privileges, application and network resource information. The SCI application also implemented programmatic security as well to control data access to Users. The Presentation layer was divided into static components such as HTML and Cascading Style Sheets (CSS) and dynamic components such as Java Server Pages (JSP), Java Servlets, XML Server Side and Client side rendering. To achieve scalable, distributed, and reliable solution, J2EE standard components e.g., Servlets, Enterprise JavaBeans (EJB), JMS and JAXP were used. Enterprise Application Integration and Distributed Messaging was achieved using EJBs and Messaging. Stateless session beans are developed where required.

The application was deployed using IBM WebSphere Application Server (running on an HP-UX box) accessing a DB2 relational database on the mainframe. Stored Procedures executing via DB2 Connect were used to manipulate and retrieve data from the mainframe. Rational Rose was used to design and document Use Case diagrams, class diagrams, sequence diagrams, collaboration diagrams, activity diagrams, component diagrams and deployment diagrams. The ERWin data modeling tool was used to design the logical and physical database. IBM’s WebSphere Application Developer was used as the integrated development environment (IDE).

CONFIDENTIAL

Responsible for leading a team of 3 project managers and over 25 developers charged with reengineering the CONFIDENTIAL Reinsurance Accounting (RDPS) application. Managed Client relationship, Business requirements gathering, Application re engineering. Reported to the Steering committee consisting of senior CONFIDENTIAL Business and IT executives

The application was deployed using IBM WebSphere Application Server (running on an HP-UX box) accessing a DB2 relational database on the mainframe. Stored Procedures executing via DB2 Connect were used to manipulate and retrieve data from the mainframe. Rational Rose was used to design and document Use Case diagrams, class diagrams, sequence diagrams, collaboration diagrams, activity diagrams, component diagrams and deployment diagrams. The ERWin data modeling tool was used to design the logical and physical database. IBM’s WebSphere Application Developer was used as the integrated development environment (IDE).

CONFIDENTIAL

Responsible for leading a team made of project manager, Project leads and 15 developers charged with developing the application for Claims processed by CONFIDENTIAL TPAs. Managed Client relationship, Business requirements gathering, Application reengineering. Reported to the Steering committee consisting of senior CONFIDENTIAL Business and IT executives

The application was deployed using IBM WebSphere Application Server (running on an HP-UX box) accessing a DB2 relational database on the mainframe. Stored Procedures executing via DB2 Connect were used to manipulate and retrieve data from the mainframe. Rational Rose was used to design and document Use Case diagrams, class diagrams, sequence diagrams, collaboration diagrams, activity diagrams, component diagrams and deployment diagrams. The ERWin data modeling tool was used to design the logical and physical database. IBM’s WebSphere Application Developer was used as the integrated development environment (IDE).

Client: Confidential

Project Manager/Architect

Personal Auto Claims application for CONFIDENTIAL - The application included modules to register, assign, administer, adjudicate, manage reserve, schedule payments, initiate recovery procedures and forms & letters. The application modeled n-tier architecture and used Java applets/Swing classes for GUI presentation. The middle tier used IIS Web Server, Java Application Server and JDBC. An Oracle 8.0 transactional model served as the database. PL/SQL stored procedures were developed to retrieve and update the time sliced database. Java Mail APIs and FTP were used to build Interfaces to Automobile Insurance Bureau, Bottom Line Check printing and Documerge document archiving software.

Worked for CONFIDENTIAL as a senior manager in the IT department developing the Policy, Claims and Reporting applications using the Corporate Reporting System (CRS), Integrated Premium & Loss (IP&L) databases for CONFIDENTIAL’s Domestic Brokerage Group. These systems were built using Visual Basic, ODBC, MDI Gateway, CICS, DB2, Application System (4GL) and FOCUS. At CONFIDENTIAL he managed 3 or 4 teams of development and support personnel totaling 25+.

Client: Confidential- Philadelphia, PA

Responsible for leading multiple teams that includes project managers and over 20 developers charged with replacing Confidential Claim legacy applications, develop Claim Loss Data Repository for Multinational Clients and applications to produce Clinical Trial Insurance certificates for Multinational Clients. Managing client relationship, business requirements gathering, application reengineering. Reporting to senior ACE-INA Business and IT executives.

Multinational Loss Data Repository

The Multinational Loss Data Repository is a comprehensive data store of claim data for Multinational Clients for data registered using domestic and global registrations systems such as the Claims Data Warehouse and Premium Data Warehouse. The system also allows for claims activity to be registered by Third Party Administrators, Non-affiliates and Out of Territory representatives. Code sets used are approved through the ACE Data Governance process. Multi-Currency processing is an important feature. Processed Claims are then fed to the Multinational Claims Management portal which Global Risk Advantage (CRIS/GRA). The repository will utilize the latest state-of-the-art technology structures and tools in order to maximize its maintainability, flexibility and availability.
The application was deployed using Internet Information Server, ASP, MVP design pattern, .NET framework accessing a MS SQL Server relational Database. SQL Server Stored Procedures executing ADO.NET were used to manipulate and retrieve data. MS VISIO was used to design and document Use Case diagrams, class diagrams, sequence diagrams. The ERWin data modeling tool was used to design the logical and physical database. Visual Studio was used as the integrated development environment (IDE).

Multinational Clinical Trials Insurance Certificates

The solution developed using ASP.NET and MS Office Word helps the customer generator Clinical Trial Insurance Certificates for their Multinational Client. Extensive search, data upload and printing capabilities over the internet from remote global locations makes this application very user friendly. Responsible for leading offshore development team and technical design.

Multinational Accounts Receivables

The solution developed using ASP.NET and MS SQL Server provides the customer with a complete suite of accounts receivable functions. The application provides detail and summary accounts receivable information due from Multinational Customers. Multi-Currency is widely used and important feature of this product. Responsible for leading offshore development team and technical design.

The Legacy Systems Replacement Phase 1

ACE current US systems environment includes various registration systems by line of business, dependent on inefficient, file-based legacy edit systems to supplement and validate the data. Various sets of midstream edit and transform programs with independent rules and code lists have led to data inconsistencies throughout the system flow. These legacy systems limit frequency to weekly/monthly file-based batch processing and contribute to overall processing inefficiencies.

The Legacy Systems Replacement Phase 1 initiative proposes to upgrade the current ACE USA/Westchester insurance application platform by eliminating the dependency on the legacy applications and associated batch processes.

Total Cost of Claim

The Total Cost of Claim a Business Intelligence initiative automates the claim cost calculation, using the most accurate, timely and detailed data available. Provide Senior Claims Management, Team Leaders, Divisional Financial Officers and analysts with the ability to:

• Analyze trends that impact staffing and geographic locations
• Track performance at the unit and individual level
• Improve planning and budgetary decisions

Global Risk Advantage - Reengineering

The Global Risk Advantage tool provides flexible, formatted and custom reports with drill-down capability. Real-time access to claim notes, claim diaries and functions such as email, proactive monitoring of critical claims and claim payments are a few of the rich features of the application.

The application developed using Visual Basic is being reengineered in .Net architecture using SQL 2005 database. The requirements phase currently in progress includes extracting business rules and existing functionality from application code and adding additional new requirements.

Client: Confidential, Morristown, NJ

Software Development Manager
Developing a multi-line claims application for FITS. To maximize component-based build strategy, the total system has been divided into applications spanning across multiple layers. A function driven layer interacts with other layers using industry-standard protocol such Java Messaging Service (JMS), and XML compatibility to interact with other systems. 

Presentation layer is divided into HTML, Cascading Style Sheets (CSS), Java Server Pages (JSP) and Java Servlets. The Presentation layer delegates business requests to process layer. To evaluate and execute the client requests a ‘Process Layer’ provides business methods. The Process Layer also acts as the repository of business rules. The Process Layer interacts with a ‘Service Layer’ for data retrieval and manipulation. To achieve scalable, distributed, and reliable solution, J2EE standard components e.g., JSP/Servlets, Enterprise JavaBeans (EJB), JMS and JAXP are used. The application is being deployed using IBM WebSphere application server accessing an Oracle database.

Client: Confidential

Reinsurance application

Reinsurance application for AEGIS Insurance Service, Inc. using Visual Basic (6.0), SQL Server 7, Crystal Reports 8 and ER-Win. Was involved in the complete life cycle of the project focusing primarily on data modeling, physical database definition and project management. The system allows AEGIS Underwriting and Claims departments register reinsurance treaty and facultative agreements, maintain policies ceded by AEGIS alliances and administer claims for ceded policies. The application features various reports that help the Accounting department at AEGIS analyze written, earned and unearned premiums, loss ratios and commission loss ratios.

Commercial Property System study for AEGIS Insurance Service Inc. - The study encompassed gathering and documenting business requirements for the underwriting, claims, accounting and actuarial divisions which required conducting interviews with the respective division representatives and senior management. Existing databases and data marts were analyzed to produce GAP analysis reports for executive management to evaluate the impact and scope of changes required to migrate to a new application. The documentation produced as part of this study included detailed timeline, costs, resources, skills, hardware and software required to implement different options available.

Client: Confidential

Claims Data Warehouse

Claims data warehouse for the Property & Casualty division of Cigna - The project included analyzing and converting data from eight IMS based legacy systems and develop a process to extract data from the legacy systems to feed the data warehouse on a daily basis. The data warehouse consisted of 50 relational tables and currently stores about a billion rows. The data warehouse developed on an IBM mainframe used IMS, DB2, COBOL, CICS, EasyTrieve and JCL. It is now the single source information provider to claim administrative, financial and statutory departments and supports twenty or more applications.

Decision Support/BI Project

Decision Support/OLAP tools for Workman’s Compensation and APL departments - The project included interviewing senior CIGNA management to gather and document requirements, analyzing and converting data from the enterprise data warehouse on a monthly basis. The DSS applications modeled using 3-Tier architecture to provide user-friendly screens to summarize and group information on business critical parameters. It also provided the users the capability to drill-down to claim and transaction detail. The MIS data mart developed on an IBM mainframe used Power Builder as the presentation layer. Direct Connect Gateway and MDI Gateway with ODBC were used on the middle tier to communicate with the IBM mainframe. CICS/COBOL Remote Stored Procedures were developed to retrieve and update a DB2 database.

Client: Confidential

Enterprise Premium and Loss Data Warehouse

The project included developing the extract, transform and load process for 30 relational tables from 10 legacy policy and claims applications. The data warehouse implemented on an IBM mainframe used DB2\'s relational database. ER-Win was used as the data-modeling tool. COBOL, Syncsort, File Aid and Platinum database utilities were used to develop the extract, transform and load process. The data warehouse was developed to store 30 years of history with a peak capacity of 2 billion rows.

Client: Confidential

Internet Architecture

Documented the essential components needed to implement an Internet Application development environment and technical architecture for the Southern Farm Bureau, a financial and insurance services company is based in Arkansas. The Internet infrastructure at Southern Farm Bureau calls for using technologies like Java, Servlets, Java Server Pages, 3rd party Internet Application Servers, IIS Web Server, JDBC, DB2 Connect, Universal Database and DB2.

Web enabled Boat Owners Insurance

Transitioned a web browser based Boat-Owners underwriting application to a team from the Southern Farm Bureau. The Boat-Owners project is currently in production.

Client: Confidential - Philadelphia, PA
Sr. Project Manager

Responsible for leading a team of Microsoft SharePoint developers to develop an intranet based Global Training Scheduling web application using MOSS 2007, MS Exchange 2010, MS Outlook 2010 and MS SQL Server 2008. Also implemented the migration of a very large SharePoint Content Database to individual application based content databases. Managing client relationship, business requirements gathering, application reengineering. Reported to the CTO and other senior Business, IT executives at Richardson.