SUMMARY

• A Leader in Enterprise architecture with 18 years of extensive experience building Data strategies, design, development and Implementation of Enterprise - wide systems (ie ERP, CRM,MDM etc), data warehouse, Business Intelligence solutions across different clients.
• Consult, Guide, Advise clients in Business process transformation, Technology Strategy, Digital Transformation.
• Build strategy around Enterprise data assets, Data quality, Data Integration and leading Digital Transformation for clients.
• Played various Leadership roles in Reporting & Analytics involving Data Architecture, Datawarehouse, Business Intelligence & Master Data Management initiatives.
• Strong program management experience (using Agile), stakeholder management, cost estimates and budgeting.
• Worked with business stakeholders and CTO organization on strategic initiatives. Managed a Global team of 4 to 25 with onsite and offshore and 3rd Party resources.
• Strong functional knowledge in Banking, Telecommunication, Pharmaceuticals, Manufacturing, Insurance, Retail.
• Worked extensively in data modeling, logical and physical design of relational, multidimensional and Bigdata databases,
• Currently member of DAMA and TDWI Organizations.

TECHNICAL SKILLS

Architecture Framework: TOGAF, Zachman, EA

Languages: C, C++, Perl, PRO*C, MS-COBOL,R,Python

CASE: ERWIN Designer 2000, SSAD, ER Studio

Database: ORACLE 10g/9i/8i/8.x/7.x, DB2, IDMS, Sql Server, Sybase, LDAP Teradata 13.11, Aster 4.5, Nosql, Mongo DB, AWS Redshift

ETL Tools: Informatica, Data stage, BO Data Integrator, Snaplogic, Alteryx, Pentaho

BI Tools: Cognos,TM1, SAP Business Objects, Tableau, Crystal reports, Qlickview, OBIEE

Scheduling Tools: Crontab, CA-Unicenter, Informatica, Autosys

CRM Tools: SalesForce, Informatica Cloud MDM, Siebel 7.0

Internet: Java, Javascript, HTML, Oracle Web Application Server, WEBDB, XML,Web services

OS: UNIX,Sun Solaris, HP-Unix, Novell Netware, Windows 95, Win NT, Uwin-NT, Mainframe

Other Tools: MS-Project,Visio, Syncsort, Frictionless, Documentum, Toad, SQL Navigator, Kalido

PROFESSIONAL EXPERIENCE

Confidential

Enterprise Data Architect

Responsibilities:

• Involved in guiding Digital transformation for Confidential clients.
• Work closely with Stakeholders to build vision, strategy and roadmap for digital transformation for clients.
• Leading implementation to deliver digital transformation using Cloud, Non-Cloud, Hybrid architecture
• Evaluate current state architecture and build strategies, roadmaps, solution architecture for future state architecture for products.
• Oversee and guide selection of Hardware and software Products
• Advise, Consult, Guide Digital teams on IT Integration, M &A, Architecture principles and strategy.
• Leading the implementation of Data warehouse, Data Lake (AWS,Azure) for the Confidential internal clients and come up with strategy to build self-service BI capabilities.
• Advising on setting up solution architecture on Machine learning and Artificial Intelligence.
• I am also part of Confidential Enterprise Architecture leadership Guild.

Confidential

Enterprise Data Architect

Responsibilities:

• Leading the Data Architecture, Vision, Strategy Roadmap for implementing EDW
• Designed Customer and Product master data management for the enterprise using custom toolset
• Involved in building Party master (Provider, Customer, beneficiary, Annuitant, Agents etc) for the enterprise
• Involved in requirement gathering for divisional and enterprise level reporting
• Designed Star Schema for different areas like Policy, Claims, Payments, Providers, Parties, and Agents.
• Involved in the analysis of sources(Insurance admin systems) for various business units
• Created MDM implementation strategy and matching rules for all business units
• Designed specs to implement with Onsite and Offshore resources
• Involved in building Customer analytics
• Involved in Requirement gathering for Anti-Money Laundering for Individual Life business
• Designed Integration process and specs for EDW to FCRM system

Environment: Oracle 12, Informatica 9, Tableau, Business Objects, Pivotal (Hadoop), FCRM

Confidential

Sr MDM Architect

Responsibilities:

• Involved in Data Architecture vision, Strategy, Roadmap, integration of cloud Architecture with Enterprise Architecture
• Involved in requirement gathering with business users and stakeholders
• Involved in tools selection, resource planning, project planning
• Developed data design and integration architecture for integrating salesforce,Siebel systems from AP,North America,EMEA
• Designed and developed strategy for Cloud Customer master data management Initiative
• Involved in developing Data Governance Initiatives for Cloud Customer MDM
• Designed and developed integration with reporting tool (Salesforce Insights)
• Designed Executive reporting dashboard and integrating with Salesforce and EdgeMart

Environment: Salesforce, Salesforce Insights, Cloud MDM, Linux, Informatica Cloud 9

Confidential

Lead Data Architect

Responsibilities:

• Involved in tools selection, resource planning, Project(Agile) & sprint planning
• Involved in Requirement gathering with business user and Stake holders to define DW strategy, Vision, Road map for building MPP data warehouse.
• Developed the overall architecture for BI and Integration to Local Merck systems and 3 rd party Data providers.
• Designed star schema for all subject areas like Sales, Inventory, Trade Management, Sales Force, Field Activity, Consumer Market data.
• Designed a generic integration layer to load raw data from different external, Internal Data provider and other local Merck systems using Informatica and Teradata utilities
• Involved in developing Data Governance Initiatives and built MDM for Customer and Product.
• Review Database design and make optimization/performance improvement in Reporting using Cognos and Spotfire
• Review Data Quality issues; Perform root because analyses, recommend and remediate Data quality issues.
• Designed Global Dashboard for Executive reporting, Dashboard for country level reporting using Cognos and Spotfire
• Designed and developed BI Reporting layer for Adhoc reporting for Power users.

Environment: Teradata 13, Informatica 9, TIBCO MDM, Unix, Spotfire 13, Cognos 10, Erwin 8