 Management of Requirements (Business as well as System requirements), requirement

analysis along with the creation of Use Case Scenarios and Diagrams, complete
modeling of the business and application using Power Designer, Rational Unified
Processing (RUP) and Unified Modeling Language (UML).
 Skilled in eliciting user demands and translating, classifying them to functional, non-
functional, data and other requirements.
 Documenting the objectives, constraints and scope of the system.
 In depth understanding of Software Development Life Cycle (SDLC) methodologies
 Excellent Knowledge of Data Modeling using Power Designer and ERWIN tool.

 Experience working with industry models like IAA and IIW.

 Worked on Data migration using ETL.

 Proficiency in Manual Testing and Automated Testing and experienced in Analyzing,

designing, executing and reviewing new and old Test plans, Test cases, developing and
maintaining Test scripts, analyzing bugs.
 Experience in Unit Testing, White Box Testing, Smoke Testing, Functional Testing,
Batch Testing, Integration Testing, Regression Testing, End-to-End Testing and
System Testing on Client Server and Web based application.
 Able to communicate effectively with multifunctional teams, programmers and technical
staff at all levels. Strong customer service orientation.
 Experienced in consulting with users, resolving problems and meeting specific technical
and business needs.
 Committed team player, with excellent communication skills and self-starter, capable of
working independently.
 Excellent business understanding and effective at working across multiple teams within
an organization.

The EDW team is implementing the GuideWire reporting solution DataHub and
InfoCenter to meet the downstream reporting requirements.
Responsibilities:
 Gather, analyze and interpret complex sets of data, developing data workflows
and mapping for quantitative analysis on claims, Policies, financial, quality, and
performance data.
 Identify data trends and patterns; facilitate root cause analysis; communicate
observations and recommend solution alternatives to management.
 Present reporting and observations effectively through the preparation of charts,
graphs, and other visual elements.
 Support data requests to determine how available data may fulfill the information
need in question.
 Develop advanced spreadsheets for claims metrics that reduce redundancies,
provide consistency, and maximize efficiency in reporting.
 Participate in management meetings to communicate and report observations and
collaborate in identifying solutions.
 Prepare and review executive review package, including operational metrics and
financial analysis.
 Develop and update data mining capabilities and reporting methodology.
 Create and maintain all US and backlog items using Azure Devops.
 Complete the data mapping for various reporting elements with guidewire source
systems such as PC, BC and CC.
  Design and Implement reporting solution for downstream statistics and reporting.
 Develop and Maintain internal processes and procedures to monitor KPI's, data
integrity and work with development teams on quality control procedures
 Collaborate across multiple teams (UW Desktop developers, integration) to un-
derstand complex data and determine reporting requirements.
 Collaborate with programmers, engineers, and organizational leaders to identify
opportunities for process improvements, recommend system modifications, and
develop policies for data governance.
 Prepare reports for executive leadership that effectively communicate trends, pat-
terns, and predictions using relevant data.
 Improve and streamline existing reports to work with new database structures and
cloud environments.
 Create scheduled reports, daily, weekly, monthly, and annually.
 Use statistical tools to interpret data sets, paying particular attention to trends and
patterns that could be valuable for diagnostic and predictive analytics efforts.
 Analyze and develops algorithms using SSRS, RDL, MSSQL, Cognos, SAS and
MS Excel; Prepare reports, graphs, and charts based on research and analysis.
 Extend the out of the box DataHub and InfoCenter entities by writing new code
for Extract,transform and ODS data flows and work flows using SAP BODS.
 Modify out of the box ETL code to accommodate additional reporting require-
ments
 Complete the data mapping for various reporting elements with guidewire source
systems such as PC, BC and CC.
 Update the data specifications for DataHub and Infocenter.
 Write stored procedures for claim loss transactions.
 Update the data model for datahub and infocenter and create DDLs for deploy-
ment using PowerDesigner data modeler.
 Design new facts and dimensions for reporting solutions such as accounts receiv-
able, premium aging, quote, etc.
 Integrate new workflows into jobs and deploy the new ETL code to different en-
vironments,
 Create monthly and quarterly reports for Stat and Bureau.

ENVIRONMENT: Guidewire, SQL Server, SSMS, SAP BODS, PowerDesigner, Microsoft

Office suite, DataHub, InfoCenter, SSIS, Cognos

Project Description:
The EDW team is working on Data migration project and implementing the GuideWire
reporting solution DataHub and InfoCenter to meet the downstream reporting
requirements.
Responsibilities:
  Analyze data-related business and technical needs, elicit and document
requirements related to data integration from source systems to target data
warehouse, data marts, data analytic tools, and information delivery solutions.
 Help Business understand the Guidewire Products
 Develop hands-on experience with Clients systems to understand policy, claims
and billing life cycles and information collected to operate our business.
 Develop a thorough understanding of our insurance business and business
processes and how these are represented in our data within the systems and the
data warehouse.

 Complete the data mapping for various reporting elements with guidewire source
systems such as PC, BC and CC.
 Update the data specifications for DataHub and Infocenter.
 Write stored procedures for claim loss transactions.
 Update the data model for datahub and infocenter and create DDLs for deploy-
ment using PowerDesigner.
 Design/enhance datahub ods and data marts in edw for workers comp data report-
ing requirements
 Write SQL Queries for extracting data from gwpc, gwcc and gwbc to ods and data
marts

ENVIRONMENT: Guidewire, SQL Server, SSMS, SAP BODS, Toad, Microsoft Office
suite, DataHub, InfoCenter, Data Migration

Erie Insurance Group, Erie, PA Sept 2014 – DEC 2015

Data Architect/Business Data Analyst for Claims Refresh

Project Description:
The Claims Refresh Program is transformation of Erie Insurance’s business and
technology capabilities and enabling it to continue delivering exceptional personal and
caring claims service by implementing Guidewire ClaimCenter.
Responsibilities:
 Attend Integration, configuration and conversion requirements workshops
 Design data loading strategies from legacy claims to landing zone and
DataHub in Claims Consolidated Data Store (CCDS)
 Mapped claims data from legacy source systems into GW Claimcenter.
 Enhance DataHub as per integration, configuration and conversion requirements
and create Logical and Physical Data Models using Erwin
 Export Logical and Physical Data Models into BusinessObject Universe to cre-
ate Business Object Reports
 Prepare Data Naming Standards for Logical and Physical Data Models, Data
Admin Procedures and Oracle SQL and PL SQL Standards and Guidelines
 Create Business Object Universe and Reports using InfoCenter
  Deliver end to end mapping (screen level and data) from source (Guidewire ap-
plication) to target (CCDS)
 Deliver end to end data mapping for report attributes
 Provide ETL logic to pull the data from Guidewire application database to ODS
layer and into data marts
 Create Stored Procedures for various integration points such as Policy Search
and Retrieve (PSAR), Physician Panels, and other third parties vendors
 Review SSIS Packages, Stored Procedures, DDLs and DMLs prior to deploy-
ment
 Provide test cases to QA team for CCDS reports testing
 Publish the data models and web data dictionary reports using Erwin
 Conduct JAD sessions with Product Owners, Developers, Integration Team and
Guidewire support team.
 Administer scrum meetings and create user stories during sprints as scrum master
 Create data flow diagrams
ENVIRONMENT: Guidewire 8.0, Oracle, SAP BusinessObjects, Erwin, Microsoft Office
suite, Rally, SSIS, DataHub, InfoCenter, IIW, IAA

Citizens Property Insurance Corp, Tallahassee, FL Jan 2012 -Dec 2014

Data Warehouse Architect/Data Analyst for Core Insurance Solution Implementation

Project Description:
The Core Program consists of a number of projects and initiatives intended to achieve
Citizens’ goal of providing services in an efficient and effective manner by managing its
book of business on a single insurance platform. Projects include implementation of the
Guidewire suite of insurance applications, implementation of a new rating engine, and
implementation of a new document production application, development or modification
of interfaces to supporting systems, and development or modification of business
processes to support industry best practices in insurance operations.
Responsibilities:
 Design Citizens Data Warehouse (CDW) architecture for Guidewire integration
 Design the SQL Server Replication process to bring data from Guidewire appli-
cation Database into CDW
 Design the loading strategy for Operation Data Store (ODS) layer
 Prepare Conversion Data Flow Diagrams and strategy documents
 Deliver end to end mapping from source (Guidewire application) to target
(CDW) and legacy systems coverages to Landing Zone and to Guidewire Report-
ing Pack
 Enhance the out of box Guidewire PolicyCenter, BillingCenter and ClaimCen-
ter data marts as per clients requirement
 Deliver logical and physical data models for dimensions and facts to support
CDW reports using PowerDesigner
 Deliver end to end data mapping for report attributes
  Provide ETL logic to pull the data from Guidewire application database to ODS
layer and into Guidewire data marts and CDW
 Provide test cases to QA team for CDW reports testing
 Provide Screen and data mapping from legacy systems to Guidewire
 Facilitate the design of Cognos frame work manager to support the reports
 Publish the data models and web data dictionary reports using PowerDesigner
 Deliver hybrid solution for Guidewire virtual fields using SIT and SQL Server
Replication process
 Conducted JAD sessions with Product Owners, Developers, Integration Team and
Guidewire support team.
 Administer scrum meetings and create user stories during sprints as scrum master
 Deliver Data Management processes and procedures to insure the creation and
documentation of a database design that both answers all information
requirements and satisfies a minimum set of data management standards
 Create data flow diagrams
ENVIRONMENT: Guidewire 7.0, MS SQL Server, Cognos, PowerDesigner 16, Microsoft
Office suite, Rally, SSIS, Guidewire Reporting Pack

American Family Insurance, Madison, WI May 2011 – Dec

2011

Sr. Data Analyst for Advance

Project Description:
American Family is executing a major corporate initiative, the Advance Program, which will, in
part, replace core policy administration and billing systems in phases. In conjunction with the
Advance Program, American Family is expanding and transforming its multi-generational, legacy
Business Analytics (BA) environment in order to better enable current and future business
analytics needs.

Responsibilities:
 Review all Data Requirements with the Functional Developer during Design phase of each
Sprint
 Review proposed data model changes with GuideWire Functional Developers
 Analyze big picture impact of the proposed schema changes and identify any discrepancies
or conflicts with existing data structures
 Identify, analyze and communicate down-stream implications of data model changes with
external systems/integration points
 Document data model changes as appropriate
 Generate PDF Entity Relationship Diagrams (ERD’s) and Dictionary reports for portal pub-
lishing
 Identified and documented business requirements from clients while translating them into
system specifications.
 Gathered Analytical and Functional reporting requirements for BI and created reports using
Business Objects.
 Documented workflows and created functional specs for development
 Used UML methodology to break down the user requirements into detailed design docu-
ments and system requirements.
 Analyzed and segregated business requirements into high level and low level Use Cases,
using MS Visio.
 Conducted JAD sessions for communicating with the all Project directors and stakeholders.
 Coordinated meetings with business clients and various IT teams including developers and
testers to develop Test Strategy and Plan.
 Worked as a project coordinator to coordinate between QA Testers and users.
 Involved in training the users once the application is ready to be implemented.
 Interacted continuously with developers and QA team to maintain schedules for release, bug
fixes and other issues related to the application.
 Worked with the development team to ensure testing issues were resolved.
 Participated in User Acceptance Testing

Environment: Guidewire, Oracle, SQL, Microsoft Office suite, Business Objects, SharePoint

Great American Insurance, Cincinnati, OH Jan 2008 – March 2011

Enterprise Data Analyst/Data Warehouse Specialist

Project Description:
GAIC is one of the few insurance groups with a division dedicated to underwriting Property and
Inland Marine business. They write policies in all 50 states and have more than 2,000
independent agents offering their coverages to different customers.
As an Enterprise Data Architect, I worked on Claims (Guidewire), GuideWire Billing Center
and Policy Management System called Underwriter Desktop used to write policies for
following Business Units:
 Commercial Property & Inland Marine
o Select Business Policy
 Building
 Personal Property
 Newly Acquired Locations
 Debris Removal
 Business Income
 Extra Expense
 Building Ordinance and Law
o Schools
o Builder’s Risk Plus
o Contractor’s Equipment
o Motor Truck Cargo
o General Commercial Building Contractors
 Equine Mortality,
 Commercial Auto,
 Fidelity & Crime,
 Alternative Markets
 Commercial General Liability.

Responsibilities:
 Gather initial business requirements from Underwriters.
 Collaborate with representatives from various business units (i.e., Financial Reporting,
Reinsurance, Claims, Stat Compliance, Rating Engine and Billing).
 Collaborate with UD BA to gather business requirements from representatives from
various business units (i.e., Financial Reporting, Reinsurance, Claims, Stat
Compliance, and Billing) for UD and Claims Guidewire.
 Prepare Use Case Models based on Business Requirement documentation gathered
through interaction with users.
 Document data and functional requirements.
o PSAR (policy search and retrieval)
 Work with UD data modelers to identify presentation/conceptual model.
 Collaborate with UD BA to identify data elements that need to be presented to Data
Stewardship Working Group.
 Identify Meta data about data elements - default values, constraints, type, type, length,
format, names.
 Create Product Hierarchy Models to define risks and data elements and coverages
attached to them.
 Create Coverage Matrices to define coverages provided by company against risks for
different commercial lines of businesses.
 Deliver logical data model.
 Deliver physical data model.
 Work with xml modelers to define canonical xml model.
 Document data elements in EDW Data Dictionary
 Create Wireframes for web pages used by UD to communicate with Enterprise
Application Middleware.
 Collaborate with UD BA to prepare the DART form, containing "project/line of business"
data elements requiring DSWG review.
 Attend Data Stewardship Working Group meeting to present and answer questions
regarding "project/line of business" data elements.
 Prepare minutes for the meeting, documenting decisions reached.
 Document DSWG in Gold List, as needed and EDW Data Dictionary to record
approvals, provisional approvals and rejections.
 Link Gold List elements to EDW Data Dictionary elements.
 Initiate the data mapping spreadsheet for EDW data elements
 Complete data mapping agreement from UD database to CANONICAL XML
 Complete data mapping agreement from CANONICAL XML to EDW
 Document Business Rules necessary to transform the canonical xml to EDW.
 Link data elements and business rules between CANONICAL XML Data Dictionary and
EDW Data Dictionary.
 Link Business Rules to EDW Data Dictionary.
 Create and saves view for data mapping agreement between CANONICAL XML and
EDW.
 Coordinate reference data with Source Application BA
 Review UD requested reference data, as presented by DBA
o Determine whether EDW requires values and whether synchronization is
required.
o Approve UD data for load to development, when synchronization is required
 Prepare EDW Ref List, EDW Ref, Factory Party, Factory Place spreadsheets as
needed for new data values.
o Submit for load,
o verify load,
o Monitor deployment to various environments.
 Prepare Create New EBI spreadsheets as needed
o Submit for load,
o verify load,
o Monitor deployment to various environments.
 Prepare New EBI Association spreadsheets, creating associations for all interested
applications
o Submit for load,
o verify load,
o Monitor deployment to various environments.
 Provide assistance to ETL developers as needed - answering questions, updating ref
values, confirming default values, etc.
 Define testing requirements from EDW perspective.
  Coordinate construction of test plan with Source BA
 Document expected results for test plan
 Coordinate development of Source to EDW comparison test tool
o UD UI to UD DB
o UD DB to EDW DB
 Coordinate development of EDW test queries
 Provide development test data for unit testing
o Enter policies in UD Dev
o Create sample xml messages, as needed
 Review tests and document test results
o Test objects include xml messages, Detail Staging parsing, EDW records,
Error messages
o Document defects in Quality Center
o Research source of problem in defect, working back through ETL, CANONICAL
XML , UD DBXML, UD DB, UD UI.

Environment: Guidewire ,Canonical Model, Oracle, SQL, Microsoft Office suite, DOORS,
Microsoft Visio, Load runner, Rational Unified Process (RUP), UML, TOAD, Java, XML, QC,
QTP, Crystal Reports, Business Objects, SharePoint, .Net