EXPERIENCE SUMMARY

• 20 years of experience in Information Technology consulting cutting across Banking and Financial services, Insurance, Healthcare, Automotive and Retail
• 15 years of experience in the architecture and implementation of Business Intelligence BI and Data warehousing DW solutions
• Experience in conceptualization, architecture and productizing Data quality and domain solutions
• 13 years of experience as a Data architect that includes experience in Data governance, Data modeling, ETL architecture and OLAP architecture
• Full lifecycle experience in BI projects including project experience in Data Quality Management and Master Data Management
• 7 years of international experience across North America and Australia
• Experience in undertaking several high-visibility consulting assignments for multi-national clients
• Leading the Database Architecture group for all Intellect Products at Polaris Financial Technology
• Experience is Banking, Capital Market, Insurance, Healthcare, Manufacturing and Retail domain

RECENT PROJECTS UNDERTAKEN

Confidential

Roles and Responsibilities

As a Lead Data Architect

• Responsible for re-designing the existing Intellect ARX Database to incorporate product enhancements
• Establish Data Modeling standards and best practices
• Defined processes for Product DB installation, Product DB Version upgrades and Product DB enhancement rollout
• Conducted Data Architecture DA Audit for ARX Product Database and identified critical database issues that affected the performance, integrity and scalability of the application
• Created data dictionary and the logical data model for the ARX database
• Helped the Product engineering Team in prioritizing the application enhancements necessitated based on the finding from DA audit
• Lead the Enterprise Data Architecture Team that owns all Intellect Product Databases

Confidential

Roles and Responsibilities

As a Data Modeler

• Discuss with Business stakeholder, Provider Contract negotiating Team and Wellpoint Architect Team to understand the functional and non-functional business requirements
• Understand the data requirement for Claim pricing
• Create conceptual, logical and physical data models for the Modeler application
• Create Data dictionary for the Data Model
• Review the Data Model with Wellpoint Data Architect Team and obtain Data Model signoff
• Perform capacity planning and handover the Physical Data Model to the Wellpoint DBA Team to create the Physical Database
• Conduct knowledge sharing session with the Development Team

Confidential

Roles and Responsibilities

As a DW Architect

• Involved in Custody-client report rationalization exercise
• Analyzed the rationalized Custody-client reports and created the Fact-Dimension matrix
• Created the Logical and Physical Data model for the Custody-client datamart
• Review the Data Model with RBC Data Architect Team and obtain Data Model signoff
• Involved in designing the ETL architecture that loads the Custody-client Datamart

Confidential

Roles and Responsibilities

As the Inventor and Architect of SmartData

• Conceptualize and ideate the need for a in-house Data Quality tool
• Perform cost-benefit analysis and market research on existing DQ tools
• Come-up with the detailed functional requirements and the Product roadmap
• Create the technical architecture and the detailed design of the tool
• Create deployment/ installation manuals, User manuals and sales brochures for the tool
• Perform client demos and road shows

Confidential

Roles and Responsibilities

As a MDM Architect

• Designed the Data Model for Customer Master Data Repository
• Review the Customer Master Data Model with GE Money Architect Team and obtain Data Model signoff
• Worked with Acxiom Team to design the input and output data structures for the Acxiom process
• Designed the overall Data Architecture for the Source Data Extraction Change Data Capture CDC
• Designed the ETL Architecture for the Customer Master Data Repository load

OTHER KEY PROJECTS UNDERTAKEN

• Fund Management Reporting System for Allstate Financials
• PAM Reportal A reporting solution built on the PAM a fund accounting product by Princeton Financial System
• Security Pricing System for AIG Investments
• SimpleRecon Syntel's data reconciliation tool that is capable of performing inter-system data reconciliation
• SynEx Syntel's data acquisition tool for Capital Market clients that acts as a feed adapter for exchange feeds
• Business Data reengineering project for infoUSA
• Warranty Analytics project for Daimler Chrysler
• Vision Plus Reporting System for GE Consumer Finance
• VCAMS project for General Motors
• Convergence project for GMAC Insurance
• Global Software Acquisition and Tracking GSAT project for GE Aircraft Engines
• Revenue Evaluation and Decision Support READS for Kentucky Revenue Cabinet
• Grainger DW project for W. W. Grainger Inc

SKILL SUMMARY Key skills

Data Modeling, Solution Architecture, DW Architecture, Master Data Management, Data Quality Management, ETL Architecture and OLAP Architecture

Databases

Oracle, UDB/ DB2, SQL Server, MySQL, ADABAS and IMS/DB.

Tools and Utilities

• Data Modeling Tool ERwin Data Modeler, Enterprise Architect, Oracle Designer
• ETL Tools - Datastage, InformaticaPowercenter, Talend
• Reporting Tools Business Object, Cognos, JaspersoftiReport