SUMMARY:

• Sixteen years of IT experience, twelve years of which in deploying business intelligence, data warehousing and data integration solutions.
• Domain experience in Financial Services, Healthcare, Pharma, and Retail.
• Consulting experience interacting at different levels within client organizations, to understand business processes, propose BI solutions, for implementation and user acceptance.
• Solution architecture focused on program alignment and reusability, cost - benefit analysis, future state technology road map.
• Data architecture focusing on modeling, data flow and data layer design.
• Data profiling and exploration using traditional and statistical methods, analyzing data quality, and patterns to define metrics.
• Managed projects in leadership roles, responsible to define scope, budget, and resources to implement enterprise scale projects.

TECHNICAL SKILLS:

Project management: business analysis.

Architectural models: Cost-benefit analysis, use cases, domain, data flow design patterns.

Data architecture: modeling, ETL, reporting and dashboards.

Statistical analysis and modeling: SAS, R, Python, Master data management.

Big data processing: Hadoop, Hive, NoSQL, AWS.

ETL Tools: Informatica, Ab Initio, Microsoft SSIS, SAP Data Services.

Modeling: ERWin

Reporting: Business Objects, Qlikview, Tableau, Oracle, DB2, SQL Server, Teradata, Greenplum, Java, Python, Swift (Apple) and Windows development (XAML/C#)

PROFESSIONAL EXPERIENCE:

Enterprise Data Solutions Architect

Confidential

Responsibilities:

• Primary responsibility for customer-360 initiative where multiple systems and data stores are utilized to create customer focused data marts. The goal of this initiative to understand customer life time value, improve customer satisfaction and retention, and optimize marketing campaigns.
• Participate in program/project initiation to provide architectural perspective including feasibility, impact, high level solution direction.
• Solution alignment with all enterprise programs.
• Locate appropriate sources, work with data owners, analyze the datawarehouse and business intelligence applications landscape for solution design.
• Create candidate architecture with cost benefit analysis and recommended options.
• Vendor capability evaluation.
• Create system architecture highlighting scope, use cases, domain models, data views, and data flow design patterns.
• Work with the delivery teams to implement detail designs including data models, ETL, reporting, dashboards, security.
• Create best practices and frameworks for analytical solutions.

Data Architect

Confidential

Responsibilities:

• Create functional requirements and technical specifications to analyze market share and contract performance of payers.
• Profile data to understand data relations, standardize reference data, and create specifications for ETL.
• Create data models for Market share (Health plan enrollment and Provider share) and Pricing analysis. Create snapshots of claims(encounters) to analyze payer performance.
• Design data flow and ETL architecture. Work with vendors of market data to integrate with in-house data.
• Create estimates and delivery schedules.
• Mentor Trinity team on design standards and best practices.

Data Architect

Confidential

Responsibilities:

• Create data warehouse architecture, data models, BI solution by use case.
• Create functional requirements for accountable care model and population health initiatives, working with clinicians to understand clinical specs and CMS guidelines.
• Identify the data sources that support the functional requirements and profile the data to create technical specs.
• Create dimensional data marts, reports and dashboards for hospital readmissions, patient satisfaction, preventive care compliance, and patient risk analysis.
• Statistical analysis and modeling to identify the primary drivers of hospital readmissions.
• Create data architecture with design standards for data flows, models, and governance processes.
• Implement master data management solutions resolving data conflicts and matching entities (patients, providers, and patient encounters) from internal and external data sources.
• Create scope, cost estimates, schedule.

Data Architect

Confidential

Responsibilities:

• Create the performance metrics to support the departmental goals.
• Create the solution architecture highlighting the use cases for the BI tools.
• Dimensional data modeling and data flow designs. The model supported what-if and point-in-time financial analysis.
• Create canned reports as templates for end users.
• Create and monitor project budget and schedules.

Data Architect

Confidential

Responsibilities:

• Create an iterative roadmap to implement the warehouse in multiple phases by business processes, starting with current claims snapshot.
• Modeled conformed dimensions for Product, Network, Provider, and Payer.
• Profile claims passing thru multiple networks to create matching rules and create a unified claims view.
• Create Provider MDM.

ETL Architect

Confidential

Responsibilities:

• Build prototypes in database/SQL for faster validation of forecasting model.
• Profile data to create data quality rules not accounted for in the functional specs, like unit price variations in inventory.
• Create the ETL architecture to create baseline warehouse.
• Flatten the forecast assumptions for faster iterative forecasting.
• Design real-time forecasting application, utilizing parallel processing features of Ab Initio, and database partitioning.

Data Integration and Warehousing Manager

Confidential

Responsibilities:

• Integrate disparate premium and claims data sources.
• Profile data, and create technical specs from business requirements.
• Create data models, data flows and ETL design.
• Create customer segmentation dashboards to analyze product performance.
• Data quality. Utilized Six Sigma methodologies to analyze historical error patterns in claims coding, and create rules to auto-correct them.
• Budgeting and project management.
• Create and manage project portfolios.
• Set up an offshore delivery model to transition support.