Data Architect Resume Profile, NC - Hire IT People

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

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.

Data Architect

Confidential

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.

Data Architec

Confidential

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 MDM for provider data with proper lineage.

Implemented initial iterations of data warehouses for Cotteweb Campaign management and Associated Supply Chain .

ETL Architect

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.

Data Integration and Warehousing Manager

Confidential

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.

SKILLS

Data driven requirements and metric definition, utilizing domain knowledge, study of data relationships, and stakeholder interviews.
Data architecture, Data modeling, ETL, Data Quality
Master Data Management.
Big data processing: Hadoop and MPP.
Statistical analysis and modelling: R, Python
Project management
ETL Tools: Informatica, Ab Initio, Microsoft SSIS, SAP BO Data Services.
Reporting: SAP Business Objects, Qlikview, Microsoft BI.
Oracle, DB2, SQL Server, Teradata databases.
Java, Python, J2EE.
UNIX, Mainframes.