Data Architect Resume Profile

PROFILE

Sixteen years of IT experience, ten years of which in deploying business intelligence, data warehousing and data integration solutions.
Domain expertise in Finance, Healthcare, Pharma, and Retail.
Expertise in designing BI solutions utilizing the right mix of technology, data models, data flows, and semantic models for data presentation.
Good understanding of data profiling and statistics to explore data relations and create metrics relevant to business.
Managed projects in leadership roles to define scope, budget, and deliver results iteratively for enterprise scale projects.
Produt management experience creating data products.
Certified: CFA Claritas, PMP, Six Sigma

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

The client is implementing various BI initiatives, as part of the accountable care model, and population health initiatives. To support these, the Confidential has to be designed to be scalable, integrating data from clinical and financial systems, patient and claims data from payers, and patient surveys. Key challenges involve data integration, and the ability to explore data across domains. In addition to supporting the accountable care base metrics defined by Confidential, the Confidential supports detailed performance monitoring with drill downs, drill across, trending, and identifying outliers.
As a data architect, my responsibilities include
Gather requirements, and profile data to expand the metric list, and improve the data integrity and quality.
Create data models and user models for self-service BI.
Responsible for the overall data design to support the Accountable Care model, enabling exploratory analysis of data across the clinical spectrum.
Statistical analysis to identify the drivers of costly hospital readmissions.
Create ETL and SQL dataflows emphasizing scalability and reusability.
Design MDM to create an integrated version of providers and patients. Data is supplied from internal and external sources, including payers, EHR, and public domain data.
Create design standards, review with team members, and mentor them.
Create canned reports for users as a reference template for adhoc reporting.
Create task breakdowns and cost estimates.

Confidential

Data Architect

Legal and compliance data warehouse was created for Confidential, integrating data from several sources, including Litigations, Patents and Trademarks, Confidential, and Finance to create an integrated view of legal operations. The warehouse supports performance reporting related to Law Firms and Attorneys, Budgeting vs. Spending, Intellectual Property cycle time, and resource allocation. I was responsible for
Proposing and defining the metrics to support the department goals.
Data modeling, and data flow designs. The model supported what-if analysis with different budget versions, and point-in-time data analysis.
Create canned reports, to be used as templates for end user access to data.
Creating scope, budgets, and schedules.

Confidential

Data Architect

Confidential This data warehouse hosted claims by providers, services, and networks, for multiple payers. This enterprise view supported analysis of cycle time, product utilization, and automated and negotiated savings. My responsibilities:
Create an iterative roadmap to incrementally implement the warehouse by business processes.
Work with stakeholders to conform claims from multiple payor systems.
Create data model to analyze claims by snapshots, and settlement progress cycle time
Design Confidential for provider data with proper lineage.

Confidential

ETL Architect

Confidential a data warehouse, for use by analytical applications for market share and financial forecasting Confidential . My responsibilities:
Profile and map data from various sources.
Create the ETL architecture to create baseline history
Design real-time forecasting utilizing parallel processing features of Ab Initio. 'Re-Model' and prepare warehouse data to reduce workload during forecasting.

Confidential

Data Integration and Warehousing Manager

Confidential data warehouse houses the domains of premium, claims, CRM, and product operations, in addition to specialized areas like fraud detection, risk management, etc. These subject areas support analysis of product performance, claims cycle time, coverage distribution, loss reserves, and customer retention. My responsibilities:
Analyze the source systems to create efficient data flows.
Retire legacy batch interfaces, moving them to an integrated ETL tool based architecture.
Data quality and data cleansing utilizing Six Sigma methodologies and historical error patterns in claims coding.
Create dimensional models for selected data marts.
Budgeting and project management.
Set up an offshore delivery model to transition support.