PROFILE SUMMARY

A solutions strategist and leader wh partners with cross organization teams delivering exceptional products and services in diverse technologies

• 1. Over 19 years of progressive experience in Enterprise Information Management
• 2. Architected many Transactional and Analytical enterprise applications and COTS products
• 3. Project Domains: Custom Business Applications, Domain Products, Solution re-engineering, EAI, Architecture migration Legacy-CS-Web-SOA and Data Migration
• 4. Architect with program management experience transactional and analytical tools and trends in the areas of SOA, MDA, MDM, Federated data
• 5. Executed projects on Model Driven Architecture MDA and developed Requirements Model, Business Object Model, Enterprise Data Model, Analytical Models
• 6. EAI on ESB with SOA in .net and J2EE. Experience in IBM SOA Stack - Data Power, WID and WPS
• 7. Designed and implemented Data Hub, ODS, MDM, Data Warehouse, Data Marts
• 8. Designed Meta Data, Master Data and Data Quality Management and Governance solutions
• 9. Strong in Canonical, Relational and Dimensional data modeling
• 10. Developed many enterprise Conceptual, Logical and Physical data models for various business domains
• 11. Well versed with COTS information frameworks and models: IBM IAA IIW, AL3, ACORD XML, Silverston
• 12. Implemented ESB based on MDA and IBM IAA IDM
• 13. Implemented EDW using IBM IIW
• 14. Strong in abstract data and SOA Services modeling
• 15. Developed SOA services Request and Response XML message models
• 16. Implemented large P C Insurance, Reinsurance and Banking solutions for major markets
• 1. Insurance Reinsurance Underwriting, Billing, Commission and Claims
• 2. Architected a COTS Reinsurance product
• 3. Banking Retail Banking, ATM, Documentary Credits, Treasury, GL and SWIFT

Current assignment

Confidential

Sr. Consultant

Various Projects

Working for a leading IT services, consulting and business solutions company serving global clients with revenue over 10B. Role is Enterprise Architect in a specialized division called Confidential. The EA role enables individual accounts t put together new solutions, architect, design, review and audit information management initiatives. The primary domain is Insurance with P C, Life and Annuity and Health care.

Confidential

Environment: IBM IAA Product Mode, IDM RSA, Erwin, JSP, J2EE, Web Sphere, DB2 UDB

Confidential is a leading provider of group and individual life, disability and critical illness insurance. The project is migration of mainframe policy administration application t more modular, flexible application using J2EE technologies. IBM IAA is used as reference information model. The tw initial roll-outs are eProduct and eSetup applications. These applications are developed using IBM IAA Product Model, Interface Design Model IDM and Information Models. eProduct is based on Product Model and for eSetup customized the IDM Party, Financial Services Agreement and Financial Transaction packages. My role involves selecting the right IDM packages, services and customizing the services as per business requirements.

Confidential

Environment: IBM IAA IDM XML Services, RSA, J2EE, Web Sphere

• The project is developing commercial policy interfaces for Claims system using IBM IAA IDM. The exercise involves mapping of Claims required policy elements t source systems using IBM IAA IDM policy services.
• As part of pre-sale activity lead in solution designing for IBM IAA and IIW based RFPs Some of the initiatives worked are Chartis global Core Data EDM, Chartis Portfoli Management GWL IIW based data warehouse solution.

Confidential

Enterprise Data Architect

Claims Reporting Project - Data Warehouse

Confidential is a P C insurance provider with interests in Personal Commercial Property lines of business. The Claims Reporting Project is consolidation of legacy reports around 2200 and implementing through new Global Warehouse based on IBM IAA/ IIW

Environment: IBM IIW, IBM MMM, Erwin, Oracle MDM, Oracle11g, DB2, MS SQL2008, SSIS, SSRS, CMS Claims Management system ADABAS, Trillium Profiling Suite

.Responsibilities:

• 1. Design enterprise warehouse solution based on IBM IAA/IIW framework
• 2. Analyze CMS Claims Reports and help in consolidation of reports with business groups
• 3. Develop Claims Conceptual Data Model and review with Business users for approval
• 4. Customize IBM IIW model for Erie claim structure: Customize Requirement and Business data Models: Party, Product, Agreement, Claim, Activity, Money Provision, Communication etc
• 5. Map CMS Ad Hoc source t IBM IIW based Atomic Data warehouse model and document ETL rules
• 6. Develop Claims Enterprise Logical and Physical Data Model
• 7. Integrate with Oracle MDM for Party, Agreement and Claim subject areas
• 8. Develop ODS data model

Confidential

Warehouse Quality Management Lead

Global Data Warehouse Project

Confidential is a P C insurance provider with interests in Commercial Property and Liability lines of business in Bermuda, US and UK. Ironshore is implementing a Global Warehouse based on P C COTS Insurance Analytics FrameWork IAF for global offices situated in US, Bemuda and UK

Environment: MS SQL Server, SSIS, SSRS, Various Policy and Claims processing systems MFX, Open Co, Open Box

.Responsibilities:

• 9. Review data Element Definition, source systems mappings, Architecture, Cube design
• 10. Support developing Data Governance and MDM strategy, design and Implementation
• 11. Support developing Data Cleansing strategy, design and Implementation
• 12. Support source systems transaction processes analysis and data analysis
• 13. Design Warehouse Testing strategy for all phases Pre-QA, QA and UAT
• 14. Plan Warehouse Testing automation: Develop automation data model, program specifications, Lead automation development effort
• 15. Manage Warehouse QA effort
• 1. Document and manage QA Plan and schedule
• 2. Environment strategy for Functional and Reconciliation testing
• 3. Design Testing for Aggregations, As of Date, Month end, GAAP accounting etc
• 4. Test data design and preparation
• 5. Analyze defects and work with analysis and development teams for resolution
• 6. Manage onsite and offshore teams

Confidential

Enterprise Data Architect

Various Projects

Confidential is a P C insurance provider with interests in Personal and Commercial lines of business. Hanover is -in the process of materializing the SOA implementation on IBM SOA Stack

Environment: ERWin, XML Spy, ACORD AL3, ACORD XML, IBM Data Power, WebSphere Process Server WPS and WebSphere Transformation Extender WTX , Hyperion, PEGA, Informatica, DB2, MS SQL, Oracle, PMS Mainframe , Agency Port, Agency Management System AMS , CAAMS, POS, HP QC Center

.Responsibilities:

• 1. Solution design for RealTime Rating and JAD with business and technology groups
• 2. Document existing systems functionality with help of old BRDs, FSDs, SOA Services WSDL, Java and VB
• 3. Review, analyze and map AL3 layouts for Commercial lines of business t ACORD XML
• 4. Develop Business requirements document, Functional Specifications
• 5. Slice ACORD model for Agency Management System for BOP, Commercial Package Policy, General Liability, Commercial Auto, Workers Compensation etc lines of business
• 6. Define SOA services and BPEL Processes in WID
• 7. Design XML message schemas for Book Profile, Book Extraction and Real Time Rating
• 8. Develop relational repository, transactional and reference data models
• 9. Data mapping from ACORD t Enterprise canonical model t Policy Administration System/PMS
• 10. Troubleshoot ACORD message integration issues for Data Power, WTX, WPS, WSRR
• 11. Design and Develop Meta models and reports using Hyperion Interactive Reporting

Confidential

Lead Data Architect

IDEA Enterprise Data Platform

• The IDEA project is building enterprise data platform on federated data architecture for all of AXIS data - Structured, Semi-Structured and Unstructured. AXIS Capital Insurance and Reinsurance global US, Europe Bermuda systems are scoped for the initiative.
• Designed and implemented a federated Data HUB with model driven architecture. The new architecture has primary components of iMDM data model , Data HUB, IQM, ODS, EDW Dimensional Model

Environment: ER/Studio, XML Spy, MS SQL 2005, TIBCO, .Net, SSIS, SSAS, Silverston P C Model, IBM IAA IIW, ACORD, Visio, MS Office, RMS, RWS Re , UWS Underwriting System , MGA System, CWS

Responsibilities:

• 1. Prepared Master Plan for the Enterprise Data Architecture road map
• 2. Developed enterprise Conceptual, Logical and Physical model
• 3. Evaluated ACORD model for Reinsurance
• 4. Extended Silverston P C Insurance Model for AXIS needs
• 5. Evaluate IBM IAA for Party, Agreement, Money, Claim, Activity etc generic constructs and incorporated principles int the core enterprise model
• 6. Developed an enterprise data model of 1000 logical entities with 3600 unique attributes
• 7. Design strategy for Metadata and Data Quality. Developed models for both
• 8. Design Data Hub and ODS data model
• 9. Source systems analysis: Data profiling, Data flow diagrams, POP Spec, ETL and Data Quality rules
• 10. Developed xref rules for business objects for Party, Policy and Claim
• 11. Designed various data marts: ASLOB Reporting, Policy Performance, Risk Pricing, Receivables Aging
• 12. Supported development of SOA services with XML message models

Confidential

Solution / Product Architect

Reinsurance Administration Solution

Confidential is a P C insurance company based at Long Island, NY primarily int Homeowner and Aut personal lines. The reinsurance solution covers the functionality of Contract Management, Ceding Process and Accounting. Managed SDLC involving onsite and offshore teams

Environment: Java J2EE, Struts1.3, Weblogic, Oracle 10g, Erwin, Visio, MS Office

Responsibilities:

• 1. Architect and develop Reinsurance Administration product
• 2. Business process review and modeling
• 3. Requirements gathering- Proto-typing, Walk-through t business groups and gap analysis
• 4. Use case, design class, sequence diagrams. User Interface design
• 5. Data Modeling logical and physical models
• 6. Integration and interfaces Policy, Claims, General Ledger, Check printing systems
• 7. Managed application development with a team size of 12
• 8. Quality Assurance Test Cases and Testing

Confidential

Sr. Project Manager / Project Lead / Solution Architect - Delivery and Customer Service

• STG is an enterprise solutions provider for P C Insurance industry with a flagship COTS product, 'RENAISSANCE' R3 . R3 is an integrated Policy, Billing, Claims and Reinsurance automation solution based on Oracle and J2EE technologies.
• As Senior Project Manager, implemented R3 at various client sites and played multi-faceted roles: Account Manager, Project Manager, Sr. Business Analyst, Lead Data Analyst etc with effective cost, quality and time management skills.
• Key responsibilities include Pre-sale support, Solution Architecture, Program Management, Requirements Analysis, Product mapping, Resource Planning, Development and QA management.

Key Responsibilities -

• 1. Design and develop solutions for P C Insurance companies
• 2. Planning, designing, and managing / executing large engagements
• 3. Defining implementation roadmap and project governance
• 4. Reviewing and evaluating project plans and objectives
• 5. Leading, planning, and managing project teams including assigned technical resources
• 6. Tracking and delivering the project with respect t time and budget
• 7. Managing multi-location teams
• 8. Providing leadership, oversight, and expert guidance t resolve complex, technical, organizational, and strategic issues on projects
• 9. Establishing PM processes
• 10. Responsible for Account Management, Payment planning and realization
• 11. Coordinating with Steering Committee and Executive Management for resolving issues

Key P C Lines of Business Personal and Commercial Auto, Assigned Risk, Home Owners, Commercial Property, Surety, General Liability, Work Comp, Inland Marine

Projects at STG

Confidential

Enterprise Data Warehouse P C Insurance and Reinsurance

Confidential is t create an enterprise data warehouse sourcing data from a total of 17 Premium, Claims and Reinsurance systems.

Environment: WINS on AS/400, ERWin, Informatica, Oracle 10g, MS SQL, Paradox, WINS, Main frame

Responsibilities:

1. Analysis of Corporate Data Model CDM , legacy system data models and interface specs

2. Develop analytical model for Commercial Property, Auto, Surety, Worker's Compensation and General Liability lines of business

3. Design master data structures for common and reference data and data cleansing

4. Data profiling, analysis and transformation rules for 12 different applications

5. Data analysis of Enterprise Data Warehouse EDW , ERP source system

6. Develop star schema for Premium performance, ASLOB reporting, Underwriting Performance etc

7. Design enterprise data warehouse architecture

8. Developed data profiling utility for analyzing the Oracle, MS SQL and legacy data

9. Designed data analysis tool which can be integrated with ETL process

10. Data mapping of Source systems t CDM

11. Reviewing Data warehouse for Record counts, Transformations stats, Data quality issues

Confidential

Reinsurance Administration System

The project is automation of reinsurance process for Guardian which writes P C lines such as Auto, Property, Surety, Marine, General Liabilit in the USVI and in the British Virgin Islands BVI .

Environment: Oracle 10g, HTML, XML, Erwin, Java, Servlets, WebLogic, MS Office

Responsibilities:

1. Remote requirements analysis for automation of reinsurance contracts:

2. Treaty Admin for Property Quota Share, Liability and CAT Excess of Loss XOL ,

3. FAC Admin - Excess of Loss XOL

4. Ultimate Net Loss, ECO, XPL, Ceding and Contingent commission rules

5. Interfaces Policy Admin, Claims Admin, and Data warehouse systems

6. Business process review and modeling

7. Develop Functional Requirements Specification FRS

8. Data modeling and ER diagrams

Confidential

Sr. Business Analyst

Assigned Risk Commission System

Commission system is a fully automated premium commission processing t handle agent commission for P C Assigned Risk Auto. The engagement is analysis, design and development of commission system and migrating 15 yrs of commission data from multiple third party systems.

Environment: Oracle 9i, HTML, XML, D2k,VB, Java, Servlets, WebSphere, MSOffice and Cobol

1. Defined Scope of Work, Project Plan and Schedule

2. Analyzed AIPS manuals for premium commission rules for 40 states.

3. Verbal threshold, Deposit and Additional premium rules

4. Coverage related Fee and Surcharge rules

5. Return and Unearned Commission rules

6. Gap analysis and estimation development

7. Document and manage Business Requirements Document BRD

8. Review copy books for Policy Admin, Premium Billing, Check Printing and SAP systems.

9. Identify and map data elements for Data Conversion

10. Write System and Integration test cases. Train QA team on business requirements

11. Coordinate with vendor on performance requirements and standards adherence

12. Manage deliverable schedule, user Sign-off

Confidential

Billing Collection Implementation

Confidential is a leading niche insurance carrier with about 750M in gross written premium. RLI elected t use Renaissance Billing System RBS t improve business performance and provide competitive positioning

Environment: Oracle 9i, HTML, XML, Java, Servlets, WebLogic, Rational Requisite Pro, MSOffice

Responsibilities

1. Develop contract collateral, Engagement Roadmap and Implementation Plan

2. Develop Project approach options, Delivery strategy, Work Breakdown Schedule WBS

3. Track project delivery commitments and ensure the adherence t schedule

4. Establish and maintain project communications with onshore and offshore divisions

5. Develop testing and quality control strategy

6. Track and maintain project expenses against budget

Confidential

Reinsurance system analysis and design

Confidential is a dominant player in P C segment offering in Commercial and Personal lines, across 42 states. eMPOWER is the program t replace current PMS system with STG's COTS RENAISSANCE suite of products.

Environment: WINS on AS/400, Oracle 9i, Rational Rose, Requisite Pro, HTML, Java, MSOffice

Responsibilities:

1. Architect of the reinsurance solution

2. Develop Project plan, execution strategy and Work Breakdown schedule WBS

3. Gap and Requirements Analysis: Business user meetings, operations review, legacy system data parameters collection, work flow definition, interface specifications

4. UI Design - Develop wire-frames, model envisioned solution, Modeling the screen layouts

5. Define fully automated processes and JAD sessions with business users

6. Develop business requirements document BRD and Use Case UC

7. Data Modeling, Database Low and high level design and Integration

8. Map ACORD data element mappings

9. Validate the solution design with Reinsurance industry experts

10. Develop effort and cost estimates

Confidential

ACE Claims Project

Confidential chooses Renaissance Wholesale System RWS , a COTS product for Aut Wholesale LOB, t support the claims operations of The American Road Insurance Company TARIC . Approximately 100 users use the new application. Managed teams stationed at multiple geographical locations

Environment: Oracle9i, Java, Servlets, WebLogic, Load Runner, Requisite Pro, MS Project

Responsibilities:

1. Develop Project plan, QA Plan, WBS, Schedule

2. Remote gap analysis, develop effort estimates, review gap deliverables and obtain sign-off

3. Customize Claims COTS product and perform impact analysis

4. Plan and Implement QA strategy

5. Developed User Manual and Installation Manual

6. Coordinate weekly all hands meeting with onsite and offshore teams

7. Maintained high incident reporting and high defect turnaround

8. Enforcing change control and monitor cost and time estimates

9. Invoice tracking

Confidential

TRIP Trucking Insurance Project

Environment: Oracle 9iAS, JSP, Servlets, JScript, Sun Solaris, Rational Requisite Pro, Mercury QTP, Load Runner, AS/400, WINS, MS Project

Responsibilities:

1. Restructuring of project organization Setup Steering Committee and PMO

2. Project processes implementation for Offshore and Onshore

3. Project planning scheduling for rebase lined scope

4. Oracle TAR Management for issues resolutions

5. Oversee project estimations, staffing and project expense

6. Set project quality and performance standards. Draft and implement QA strategy

7. Design clean up and enhancements for Policy and Billing forms for 48 states

8. Release and Defect Management

9. Established PM controls by developing integrated project plans for onsite and offshore

Confidential

WAS / I-90 Replacement Project

Environment: Oracle 8i, HTML, JSP, Servlets, Jscript, iPlanet, WebLogic, Load Runner, MS Project

Responsibilities:

1. Define development scope of work and project planning

2. Design and Program specifications for Claim Setup, Salvage, Subrogation and Forms

3. Customize Claims COTS product and provide impact analysis and architectural guidance

4. Resource management, Risk Management, Release Management

5. Claims development activities and project reporting

6. Coordinating with QA for testing

Confidential

Project Lead, Banker80-Conversion Project

Confidential is one of the leading nationalized bank in UAE. Bank80 Conversion project is re-engineering the existing solutions in Cobol t Client / Server.

Environment: Oracle 9i, D2K, VB, Digital VAX, Cobol, MSOffice, MS Project

Lead the bank effort t migrate the Cobol based legacy systems t Oracle based Client / Server technologies. Demonstrated abilities t handle multiple streams parallel

1. Successfully designed, managed and implemented this program having 8 major modules with complete SDLC in 19 months with audit compliance.

2. Led the solution design, data modeling, development and implementation efforts for Foreign Currency Management System FCMS , SWIFT Library MT700, 707, 703, MT400, 410, 412 , Teller and ATM cash management, Check Management, Direct Transaction Posting, Standing Orders, Control Panel and Oracle Financials GL Systems

3. Organized and managed Branch, Audit and Management demos

Confidential

Sr. Consultant

Projects are automation of retail operations like supermarkets, beverage outlets and warehouse with Vision2000 V2K , an ERP solution based on Oracle technologies.

Environment: IBM EPOS 4694 , Symbol RF and Barcode readers printers, Vision2000, D2K, Clipper, FoxBASE

Confidential

Asst. Manager

Application Database Tuning: Tuning and reorganizing a 1.5GB Oracle7 production database

Confidential

Systems Analyst / Analyst Programmer

The projects are of Oracle 6.o, Forms3.0 for Visakha Port Trust.

TECHNOLOGY

SW Tools:

• Analysis and Design methodologies - RUP, UML, Rational Rose, Proficient in UML
• Database Oracle 6,7, 8, 9i and 10g, MS SQL Server, DB2, Paradox
• Development D2K, VB, J2EE, HTML, XML, Dream Weaver, Flash
• BI Tools Oracle Discover, Informatica, Custom Data Profiling utilities
• BA, DA, PM QA Tools Rational Software Architect, ER Win, Embarcader ER/Studio, Visio, Rational Requisite pro, Caliber RM, Paradox Viewer, SQL Analyzer, TOAD, MS Project, Mercury QTP, Load Runner
• Payment Messaging - SWIFT
• P C Products: RENAISSANCE, Commercial Intellysis, WINS, CAAMS, PMS, Agency Port
• Firmware: Palm, IBM Point of Sale POS , Symbol RF PDA terminals
• ERP/COTS SAP FI/CO, Oracle Financials and Vision 2000, RENAISSANCE
• Data Models IBM IAA, IIW, Silverston, ACORD AL3, ACORD XML