We provide IT Staff Augmentation Services!

Manager - Data Architecture Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • I am a Senior Business Analyst & Functional Data Architect having 18 years of experience in Life and domain with deep expertise in US, Indian and APAC insurance markets.
  • I have green field implementation experience in large scale insurance policy admin transformation programs and data warehousing projects whereby requirement elicitation, functional data architecture, data modeling, requirement scope management are key responsibilities.
  • I have intense exposure to data warehousing / data conversion domain.
  • Conceptual data modeling, logical data modelling on SAS LDM 5.5, mapping transformations, reports design/rationalization & deriving KPIs are some of the core strengths.
  • I have led multiple projects as lead BA & SME, contributing from RFP stage to final delivery.
  • I have worked on life / non - life policy admin, agency management and group insurance systems across numerous business processes as Principal Business Analyst responsible for estimations, quality, subject matter support, functional congruence, data architecture and lineage at a strategy level as well as operational level.
  • Data warehousing Functional Data Architect
  • Principal functional and data architect for data modeling using Custom Models and SAS LDM as well as in house data models across various projects.
  • Led system consolidation and transformation exercises and drove overall strategy for the program.
  • Developed design strategies for numerous analytical and operations reports and key member in discussions for KPIs
  • Worked on Confidential proprietary analytical models devising various dimensions and measures across functions.
  • Estimation and strategy for data modeling for complex systems across various functions in client workspace.
  • Accountability for Change and Release Management process for Data warehouse from functional side.
  • Designed functional strategy for data migration. Organized and led workshops for data migration.
  • Requirement Management (Policy Administration / Group Insurance / Agency Management)
  • Managed requirement definition, analysis and documentation for multiple life insurance strategic, mission critical application such as policy admin systems, agency management systems,
  • Gap study, analysis and functional design for complex functionalities in life insurance and agency management.
  • Led multiple conference room piloting workshops for requirement elicitation for policy admin, agency management and data warehousing
  • Lead SME for the entire value chain in SDLC driving the scope, requirements,
  • Led Report Rationalization workshops, KPI Design workshops, Data-mart design workshops
  • Played key roles in user requirement testing, system stability testing, integration and interface testing.
  • Hands on experience on all facets of SDLC that includes key areas like Release Management, Feature Backlog Management and Prioritization,, Risk Management,, Resource Management, Vendor Management, Change Management, Customer Relationship Management and Governance.
  • Responsible POC for various insurance and transformations related RFPs from functional support, primary estimation, validation of efforts and transformation strategy
  • Handled various client demos, capability discussions with external stakeholders.
  • Imparted various trainings on subject matter of life insurance domain, data warehousing functional aspects, business analysis school. Recipient of best trainer award for various trainings in domain and BA skills.
  • Motivated and approachable leader with strong people management with goal oriented mentoring skills.
  • Strong customer facing skills with ability to influence key stakeholders in customer organizations

PROFESSIONAL EXPERIENCE:

Confidential

Manager - Data Architecture

Tools: Proprietary frameworks for data modeling, Cobol, ERWin, Informatica, Business Objects

Responsibilities:

  • Lead a team of data modelers for various modeling exercise on existing data warehouse platform.
  • Suggest critical inputs towards the augmentation of existing model.
  • Derive KPI with client BA and testing for their effectiveness with sales and marketing team.
  • Assist the client team in evaluating the dimensions and KPI, chalking out path for future BI and analytics.
  • Report designing and data mart creation for certain power users.
  • Functional architecture and strategic planning for the whole stream
  • Data profiling and study of key areas
  • Business Rules and incipient data modeling
  • Test strategy and key defect management along with release planning

Confidential

Principal Data Architect

Tools: Custom data model, ERWin, IBM Data Stage, Business Objects

Responsibilities:

  • The key expectation of this challenging role is to coordinate the various data modeler’s output and drive the program for the most accurate data congruence required for downstream KPIs and reports.
  • There are various client teams working on consolidation of the claims, reinsurance, agency data that needs careful and experience handling for the merge into enterprise data warehouse.
  • I am responsible for the data consolidation planning, data quality and execution.
  • I am involved in conceptual design of data marts I will be involved in test strategy planning, coordination and defect triaging in the future.

Confidential

Manager - Insurance Practice

Tools: and Technologies: SAS LDM 5.4 and 5.5, Informatica, Business Objects, ERWIn Team Size: 30

Responsibilities:

  • I was lead data modeler and SME for the project. I lead a team of 6 BAs which included BA from other contractors.
  • Creating the functional blueprint for the mapping methodology. Driving the meetings with client key biz SME for conceptual data models provided Assist the team in mapping SAS LDM 5.4 and 5.5 version Draw functional architecture for the entire data warehouse from mapping point of view Driving the standardization, customization and unification exercise which are integral part of DW project.
  • I was stationed at client location from day one and closely involved in all the key meetings with end users and client IT team.
  • In a span of 1.5 years we were able to study 34 critical systems and narrow down to 15 systems finally for DW.
  • I was a responsible in Liasoning with SAS SMEs as well for the data model discussions.
  • Customizations for data model were carried out under my guidance. Project received Confidential Global Award in tech and client satisfaction.
  • I have played role for key business SME for Confidential product development team.
  • Worked for large American Insurance company s policy admin transformation program.
  • SME for the application - Functional Design specifications, Authoring the specs Insurance Analytics,
  • Reports development and anticipating the business need intelligently. Functional testing planning and driving the execution - Insurance Capability development
  • I was responsible for overall excellence in product management as well as other areas which touch the application.
  • Domain trainings, extending functional support to other projects, RFP responses were some other areas where significant contributions were made by me.
  • Client applications sphere study - Scoping of the functional architecture of the policy admin system
  • Requirement elicitation with client BAs.
  • Ensuring functional congruence across various modules and streams of work.
  • Integration framework study and functional discussions on interfaces to decide the To-Be architecture for them.
  • Test planning and strategizing on the optimization of efforts.

Confidential

Associate Business Consultant

Tools: J2EE, Oracle Team Size: 80

Responsibilities:

  • Was involved in requirement gathering and preparation of business requirement document and functional specification.
  • Preparation of integration test plans and functional testing.
  • Static data migration for the application and user training for migration data collection activity.
  • Requirement study for channel management through conference room piloting approach.
  • Preparation of business requirement document and functional specifications.
  • Understanding the reporting and interface requirements with documenting.
  • Preparation of test plans.
  • Requirement gathering process for all the process areas was completed before time which led to customer appreciation.

Confidential

Senior Manager - Business Analyst

Tools: J2EE, Oracle Team Size: 15 including external consultants

Responsibilities:

  • Business analysis of customer service and distribution systems.
  • Planning for business needs through system development and enhancement
  • Scoping, Estimation and Project Management
  • Business intelligence report framework and conceptual development of productivity reports
  • Functional designing, Techno-Functional Specifications, Monitoring testing (System, Integration, Volume)

Confidential

Manager- Group Insurance and Superannuation

Tools: ASP, Oracle Team Size: 10 including external consultants

Responsibilities:

  • Release of Gratuity system which is major release of Group Insurance System was executed in record time of 150 days.
  • Process for Software Configuration Management and Version Control was led down which included development of methodologies and templates for Change Request Form, Requirement Traceability Matrix, Test plans, Server Upload Log, Delivery Note etc.

We'd love your feedback!