Data Health Insurance

Kabilan Dhanasekharan

KABILAN DHANASEKHARAN Mobile: 480-***-****

Gilbert, AZ Email: *********@*****.***

Data Architect/ BI Solution Architect with experience in data architecture, solution architecture and BI/DW

enterprise architecture

Experience in translating business strategy and enterprise information needs to data architecture/enterprise

architecture solutions

Experience in database design, data modeling (conceptual/logical/physical).

Business domain experience of 7 years in Healthcare, 7 years in Finance and 2 years in Customer

Relationship Management (CRM)

Expertise in data management solutions for online transaction processing (OLTP), data warehouses,

operational data stores (ODS), master data management (MDM) for service oriented architectures (SOA),

canonical data models and globalized information systems.

Experience in data integration and business intelligence solutions using Informatica, Oracle, DB2, MS SQL

Server, Exadata and Netezza

Immigration Status: US Citizen

TECHNOLOGY EXPERIENCE

Databases • Oracle, DB2, Exadata, Microsoft SQL Server and Netezza

• Database conceptual, logical and physical modeling

• Database performance tuning and indexing

Data Integration • Informatica, MS SSIS, IBM Datasage

• Oracle Stored Procedures using PL/SQL, SQL

• Microsoft SQL Server Stored Procedures

• UNIX and Linux Scripting: BASH and Python

• XML, XML Schema design

Business Intelligence • Actuate e.Report

• Eclipse BIRT Reporting Solution

• Cognos, Microstrategy

Web Applications • JSP, J2EE

• ASP.NET, JQuery, CSS, AJAX

Data Modeling Tool • Sybase Power Designer, Embarcadero ER/Studio

• XML Schema Designers

Packaged Software • Siebel CRM, Oracle Financials

Languages • Java, C#

Platforms • Windows, UNIX, LINUX

METHODOLOGY EXPERIENCE:

• E.F.Codd’s Relational Data Modeling and Normalization.

Page 1 of 6

Kabilan Dhanasekharan

Kabilan Dhanasekharan

• Ralph Kimball’s Dimensional Modeling and Denormalization.

• Bill Inmon’s Data Warehouse 2.0. Methodology

• TOGAF Enterprise Architecture Methodology

Team Development Methodology:

• Scrum and Agile Methodology

• Waterfall Methodology

• Geographically dispersed, global teams delivery model

CAREER DETAILS

Employer: Infosys

May 2011 – Mar 2014

Client: Bank of America, Chandler, AZ

Feb 2012 – Mar 2014

Bank of America Identity Access Management Portfolio is responsible for managing (reviews and revocation

of) the entire bank’s login accounts, roles based access to the entire bank’s IT applications, servers and

databases.

As the Data Architect/BI Solution Architect, I was responsible for the following:

• Defined the holistic solution, data architecture and data integration architecture in order to enable the

holistic review and revocation of the entire bank’s identities/access

• Designed a normalized (3NF) ODS (operational data store) and a reusable data integration framework

that sourced data from multiple source systems of record

• Solution involved Oracle Exadata database machine, Informatica and a home grown rules engine

Bank of America Control Tower Report Migration platform is a solution for mortgage loan modification

management.

As the BI Architect, I was responsible for the following:

• Developed enterprise best practices for data warehouse change management for different types of

change scenarios for a Kimball methodology based data warehouse

• Performed business and data analysis of the mortgage loan modification process for a rules engine

based solution

• Solution involved IBM DataStage, Microsoft SSIS, Oracle, MS SQL Server and ILog Rules Engine

Client: American Express, Phoenix, AZ

Nov 2012 – Jan 2013

Amex CIRP Portfolio Issue Detection Platform proactively detects multiple application production related

regulatory issues before the customers/ card members or external agencies find these issues.

As the Solution Architect, I was responsible for the following:

• Collaborated with stakeholders and the portfolio architect and designed the solution architecture

• Captured the business architecture in business process flow diagrams and business capability maps

Page 2 of 6

Kabilan Dhanasekharan

Kabilan Dhanasekharan

• Solution consisted of components for data integration, rules for decision management, workflow

management and reporting.

• Designed the data architecture, data conformance standards and on boarding process.

• Adhered to AEXP SDLC 2.0 process and reference architectures

• Platform consisted of IBM Db2, Informatica and Microstrategy

Client: AETNA, Tempe, AZ

Apr 2012 – Oct 2012

AETNA’s State Reporting IODS (Integrated operational data store) is a strategic solution for complex

regulatory reporting for states by integrating the entire AETNA book of business

As the BI Architect, I was responsible for the following:

• Performed requirements analysis, data analysis for data files/mainframe extracts, data derivations and

reports.

• Solution consisted of data integration using IBM DataStage and Netezza

Client: American Express, Phoenix, AZ

May 2011 – Mar 2012

AMEX Technology Transformation Portfolio applications provide technology business and project

management capabilities.

As the BI Architect, I was responsible for the following:

• Collaborated with key stakeholders, business users and conducted a strategic review of all the

capabilities to define a holistic IT and data strategy for the enterprise

• Documented the architecture requirements (functional and non functional)

• Documented the entire portfolio as is architecture, enterprise data model (EDM) and enterprise data flow.

• Defined the holistic architecture, strategy and roadmap

• Adhered to AMEX reference architecture, standards and processes

• Portfolio consisted of Clarity application, data warehouse, master data management for enterprise

hierarchy, technology invoice & financial charge out and other project management applications.

Employer: Mercer, Phoenix, AZ

Aug 2004 – Jan 2011

Mercer Health & Benefits portfolio provided global solutions for health insurance benefits insurance

brokerage, strategy, benchmarking, insurance product design, pricing, vendor management, renewal and

health insurance plan administration.

As the Data Architect, I was responsible for the following:

• Analysis, design, and implementation of several databases for online transaction processing (OLTP),

master data management (MDM), operational data stores (ODS), data warehouses and data staging

area.

• Conceptual/logical/physical data modeling for a global health insurance and employee benefits products

and procurement database. The database was normalized to the third normal form (3NF). Data for

Page 3 of 6

Kabilan Dhanasekharan

Kabilan Dhanasekharan

products, rates, commissions, team members, vendors, contract renewal process is managed in this

database. It has more than 120 tables.

• Solution architecture for a Product Taxonomy and Metadata Management Application for standardizing

product attributes, product design, product information integration between disparate systems,

incorporated with data lineage for data flow logic.

• Solution architecture for a hub and spoke, MDM coexistence architecture style with data services layer

for a service oriented exchange of information. Developed canonical models for data in motion. XML

schema design. Leveraged the master and semantic data from the MDM database to be used as

payload for data in motion.

• Conceptual/logical/physical data modeling of a master data management (MDM) database to maintain a

system of record of core global data entities such as clients, carriers, products, finance codes and users .

• Dimensional data modeling of data warehouse for claims, health insurance plans rates, service area,

enrollment and demographics analysis. Designed and implemented star schema data marts, slow

changing dimensions (SCD1, 2) based on Kimball’s dimensional modeling.

• Designed and developed data integration solutions using Informatica Powercenter and Oracle PL/SQL

stored procedures.

• Developed Informatica mappings/ sessions/ workflows. The mappings used transformations like

unconnected and connected lookups, routers, filters, expressions, aggregators, joiners, update strategy

etc.

• Developed data load processes based on the insert/ update data deltas and CDC’s.

• Profiled, reverse engineered several data sources, source systems and data silos and developed data

integration strategies to merge data into one global database.

• Performed data stewarding, data quality audit, strategized, designed and implemented data healing

solutions. Articulated principles, best practices and governance policies.

• Designed and developed business intelligence web reports using Cognos, Actuate, Eclipse BIRT.

Employer: BNY Mellon, Everett, MA (formerly Russell Mellon)

Sep 2002 – Aug 2004

BNY Mellon Analytical Services provides Performance & Risk Analytics tools for asset owners, managers

and consultants. As a leader, in the performance measurement industry, provided investment information

solutions to more than 1,500 institutional investors in 37 countries and is responsible for $8.9 trillion in assets

under measurement. The breadth and depth of the data, in combination with the clarity of reporting, helped

clients to compare, analyze and understand their investment strategies.

As the BI Software Engineer, I was responsible for the following:

• Αlign data with business vision and strategy

• Data architecture and data modeling for finance investment data warehouse.

Designed, developed an Actuate Web Report Infrastructure for Windows and Unix

•

Developed complex financial analysis reports using Actuate e.Report

•

Developed Oracle SQL, PL/SQL procedures, functions.

•

Developed DB2 SQL, stored procedures, functions.

•

Developed UNIX Scripts for data loads and manipulation.

•

Developed JAVA classes for XML Processing using SAX and DOM java libraries

•

Page 4 of 6

Kabilan Dhanasekharan

Kabilan Dhanasekharan

Key Projects:

• Fund Market Value Reconciliation Analytics

• Equity Profile – Country Allocation Analytics

• Fund Performance vs. Benchmarks or Index Detail Reports

Employer: Powersolv, Fairfax, VA

May 1998 – June 2002

Powersolv is a leading Systems Integrator located in the Washington DC Metro region.

As a Consultant, I worked on the following consulting engagements

Client: Bank of Montreal, Toronto, Canada

Bank of Montreal’s Small Business Banking and Retail Customers Relationships are managed by Siebel

CRM Finance Application.

As the Data Integration Developer/Siebel Configurator, I was responsible for the following:

• Developed data warehouses, datamarts and performed ETL (extraction, transformation and loading)

from Siebel Application.

• Customized Siebel Sales Team Assignment using Siebel VB. Designed and developed business

services. Developed views, applets. Involved in establishing Assignment Manager rules for Service

Requests.

• Configured Siebel business objects, components, views and applets using Siebel tools.

• Developed Oracle SQL, PL/SQL procedures, functions and SQL / TSQL for MS Sql Server

• Developed reports with mutiple datasources i.e Oracle and MS SQL Server

Client: Ricoh, West Caldwell, New Jersey

Ricoh is a leading provider of digital office equipment Copiers, Printers and Cameras. Solution consisted of

Siebel Sales Application and Actuate for enterprise reporting

As a Siebel Developer/Configurator, I was responsible for the following:

• Configuring Siebel for the products quotation process

Client: Marriott, Bethesda, Maryland

Marriott Sales Force Automation Application assists in the sales of Marriott properties and hospitality

services to their clients. The properties include Marriott, Renaissance and Ritz Carlton facilities such as

rooms and conference halls.

Client: Coventry Health Care

Coventry Health Care provides health insurance services to subscribers in various states in the US.

Page 5 of 6

Kabilan Dhanasekharan

Kabilan Dhanasekharan

As a Programmer/ Analyst, I was responsible for the following:

Design and development of a client server application that assists the marketing and underwriting personnel

to quote group health insurance coverage information to prospective clients. This included renewal,

expiration and special request quotes.

EDUCATIONAL QUALIFICATION

Master of Science, University of Texas, 1993

Bachelor of Science, University of Gauhati, India, 1989

Page 6 of 6

Kabilan Dhanasekharan

Contact this candidate