Sign in

Data Insurance

Bloomington, Illinois, United States
August 16, 2018

Contact this candidate



Enterprise Solution/Data Architect


Profile Summary

Enterprise Solution/Data Architect with over 15 years’ experience in Information Technology industry with domain expertise in Insurance, Pharmaceutical, Telecommunications, Manufacturing and Retail. Also includes Technology skills in Big Data, Hadoop, Data Warehousing and Business Intelligence practice. Has international experience in working as part of the Business Intelligence, Big Data and Data warehousing technologies for major transformation projects in North America, Europe and Asia.

As an Enterprise Solution Architect/Data Architect, has been responsible for complete and overall solution architecture, design and implementation of the solution.

Professional Experience

Technical Skills

Functional Skills


Architecture Framework



Oracle, Greenplum, Netezza, DB2, SQL Server

Hadoop/Big Data

Hive, HDFS, Spark, Sqoop, Python, AWS S3, EMR, Glue Catalog. RDS, Aurora.

Transformation & Replication

Informatica Power Center, Data Stage, Attunity.

Master Data management

Informatica MDM, Orchestra


Business Objects, Tableau

Analytics, Qlikview

Denodo, SAS


Enterprise Architect, ER Studio, MS Visio

Version Control

Clear Case

Guidewire Policy Admin system

Insurance Agency Strategy Operations

Claims Actuary Fraud and Subrogation models.

Life Insurance underwriting predictive models

P&C, Life, Brokerage Insurance Policy Quote, Underwriting and Policy systems

P&C Insurance Campaign System

P&C Insurance agent compensation system

Physician Data restriction program for Pharma.

Incentive Compensation Goals and Crediting for Pharma

Chargebacks and Rebates for Pharma

Demographics and Territory for Prescribers alignment

Informatica Administrator


Job Experience

Client: Pekin Insurance, IL USA

Duration: April 2018 – till date

Role: Enterprise/Data Architect.


Pekin Insurance is specialized in Auto, Homeowners and Life Insurance products. They operate in 6 states. Recently, Pekin went go-live with Guidewire product for their Policy center, Claim Center and Billing center in 2 states.

Role Description:

Create architecture patterns for data acquisition and data ingestion in Hadoop and AWS tool stack.

Conceptualize functional and Information architecture adhering enterprise architecture framework.

Perform proof of concepts for new tools and processes.

Effective coordination with various business stakeholders and cross technology teams to layout architecture for various Information related use cases.

Conceptualize predictive models for Claims Actuary in Hadoop using Apache Spark, R, Zeppelin, Hive.

Design predictive models for Claims Fraud Investigation and Subrogation for Claims Actuary.

Define data security standards and procedures in Hadoop using Apache Ranger and Knox.

Participate in various architecture COE initiatives.

Participate in defining Enterprise architecture strategy and roadmap.

Communicate and Coordinate with External data providers Pitney Bowes, Lexis Nexis etc. to acquire customer base line data.

Architect and design Master Data management solution using Orchestra networks.

Client: American Family Insurance, WI USA

Duration: Feb 2015 - Feb 2018

Role: Enterprise Solution/Data Architect


American Family Insurance is one of the top mutual insurance companies in Mid-West region for Auto, Homeowners, Commercial and Farm Ranch, Life, Health, Brokerage and Alliance as major lines of business.

Role Description:

Planning and executing a variety of methodologies as part of the concept stage in the overall project development of information/business analytics architecture.

Planning and executing Information and Business Analytics architecture at the conceptual, logical and physical levels, applying the concepts of Master Data Management for reference data, data virtualization using Denodo and data replication using Attunity.

Creating architecture patterns, roadmaps, strategies using TOGAF Framework.

Creating conceptual, logical data models and prototypes using MS Visio and Enterprise Architect UML Tool.

Create source to target mapping documentation and high level design documentation for Business Intelligence operational and analytical solutions.

Coordinate linking Metadata tools to BI and Operational databases.

Architect solutions using Data Lake ELT strategies to support business driven customer life value models.

Architect data ingestion and transformation from multiple data sources in Hadoop using Sqoop, SPARK, HDFS, Hive, Pig scripting.

Architect solutions using Lambda architecture and framework in Hadoop.

Design and define Data ingestion patterns with Aurora and Informatica Cloud in AWS EC2.

Evaluating various emerging tools like Hadoop (Horton works), Microsoft Azure and AWS cloud based tools and documenting candidate architectures with SWOT analysis.

Evaluate various emerging Bigdata (Hortonworks) and Cloud technologies (AWS) for the BI / Analytical solutions. Architected Cloud & Hybrid BI solutions using Amazon Web Service (AWS) platform for deployment.

Performing POC for Business Intelligence financial reporting using Microsoft Azure platform and tools.

Define architecture guidelines and standards on data ingestion and security (PII).

Delivered real time replication solutions using tools like Attunity.

Reverse engineered application specific name-value pair database into a query friendly normalized data model to support reporting in Hadoop.

Engineered implementation of Denodo for Data Virtualization by collecting data from disparate sources to support analytics.

Engineered implementation of Informatica Master Data management (MDM) for Reference data.

Organization: Accenture

Client: Sentry Insurance WI USA, Astellas Pharma IL USA, Cox Comm. GA USA, Nokia Siemens Germany/Finland

Duration: December 2009 - Jan 2015

Role: Solution/Data Architect/Delivery Manager


Sentry Insurance is one of the top Insurance companies in Mid-West area for Business Insurance. Project is aimed at building data marts for Auto and Cycle lines for analytical purposes.

Astellas Pharma is one of the top Pharmaceutical R&D companies in Mid-west area that includes Oncology, Urology, Dermatology, and Immunology. Astellas Pharma Business Intelligence management is a data warehouse system that caters reports to the Astellas business units in Retail, Non Retail, Finance and Legal. Their core products include Xtandi, Tarceva for Oncology, Vesicare, Myrbetriq, Prograf, Astagraf for OAB. On the technical side, the data mapping is done through Reps to Territory to Prescriber alignment. The entire system is JSOX compliant and the sources systems are FDA validated.

Cox Communications introduces new home security products and services to high speed internet subscribers in the Cox network to achieve revenue and OFCF growth from adjacent markets. The Strategy and Development organization requested the development of an advanced and centralized reporting solution that will provide the desired functionality to manage various aspects of the business across the enterprise.

Role Description:

Designed and implemented solutions pertaining to various BI reporting and analytics requirements.

Built out strategic architecture roadmaps by taking into account of emerging tools and technologies.

Managed, designed and enhanced ODS, enterprise wide data warehouse, data marts & data modeling for reporting (Business Objects) and analytical solutions.

Designed and developed several data warehouse processes and data models (Logical and Physical) along with guiding other teams that includes prototyping, analysis, design, documentation, development, testing, metadata management, security and governance and reporting.

Demonstrated strong knowledge of cross-functional business processes including; marketing, sales, service, finance, supply chain and manufacturing.

Developed and managed working relationships with different stakeholders at the client site and within the organization.

Accomplished the strategic execution of projects to ensure the processes align to the customer's plans and technology road maps architecting OLAP data model schemas for cube development allowing analytical reports to render at maximum performance.

Engineered BI solutions by deploying scorecard reports for provider productivity, care costs, and payment reimbursement imbalances through clinical claims integration by collecting data from disparate sources to giving physician providers’ 15-20% increase in negotiations with private insurance companies.

Developed SOX compliance procedures for data cleanup, removal and encrypting as well as comprehensive data security and privacy protocols.

Created ER Diagram for databases and demonstrated business process modeling and requirements definition into it.

Accomplished Oracle Exadata implementation upgrade.

Engaged in technical presales, proposal, client presentations, solution architecture definitions & program estimations.

Organization: Electronic Data Systems (EDS)

Client: Department for works & pension, United Kingdom.

Duration: November 2006 - March 2008

Role: Application Lead


Department for works and pension is branch of the UK government, focused on managing child support agencies.

Role Description

Perform System analysis and define the user requirement / software requirement specifications (SRS). Reverse engineering & analysis of existing applications for the application enhancement.

Developed and managed working relationships with different stakeholders at the client site and within the organization.

Developed a strong understanding of the operational systems' underlying data relationships, and translated business data requirements and business rules into preliminary data screening and profiling requirements.

Managed the onsite team for multiple programs / deliveries with the help of geographically dispersed teams across India and UK.

Define technology architecture for application considering the optimal design principals and technology constraints.

Engaged in technical presales, proposal, client presentations, solution architecture definitions & program estimations.

Design and document High level design (HLD), detail design (LLD) & Data models (E R/ Dimensional) for the solutions.

Designed universes and developed various reports using Business Objects.

Organization: IGate

Client: Motorola Inc Texas, USA, Metlife Inc, NJ USA.

Duration: July 2005 - October 2006

Role: Senior Software Engineer


MetLife, Inc. operates through its affiliates and subsidiaries as a provider of insurance and other financial services to individual and institutional customers. The Company offers life insurance, annuities, automobile and property insurance and mutual funds to individuals. The main objective of the project is to build a Disability Process Automation Data Warehouse and Data mart to improve the overall disability claims processing by allowing the managers to understand and manage the productivity of disability staff.

Motorola Inc’s GTSS DW is a functionally critical data warehouse for Networks CSI sector. Early Signal Processing (ESP) application acts as a Global GTSS repository for the capture of Shipment, Returns and Repair data. This is required to provide an environment from which Key Performance indicating metrics can be derived, trend analysis be performed and to eliminate the disparate solutions implemented across the GTSS Quality, engineering, manufacturing and returns management organizations.

Role Description

Define technology architecture for application considering the optimal design principals and technology constraints.

Design and document High level design (HLD), detail design (LLD) & Data models (E R/ Dimensional) for the solutions.

Audit and review of the implementation of software quality process within projects. Key contributor in fulfilling organization dream of getting SEI CMM level 3 & Level 5 assessments.

Participated in data requirements sessions and performed data profiling for the identified KPI’s.

Designed and developed ETL data flows using Informatica Powercenter.

Developed appropriate documentation like source to target mapping documentation, design documents and support manuals.

Participated in testing and UAT from an implementation standpoint.

Educational Background

1.Masters in Computer Application - University of Madras, India.

2.Bachelors in Commerce – University of Madras, India.

Contact this candidate