PROFESSIONAL BRIEF

• Senior DW/BI/MDM/Data/TechnologyArchitect with over twenty plus years of experience in helping IT organizations to fulfill the strategic data and BI needs, guide integration of data assets, and align data investments with overall business strategy.
• Partner with management to identify business goals and matching them to proven architecture strategies and propagate the data quality and governance vision across the enterprise that includes but not limited to setting data policies, data naming standard, data quality standard, enterprise meta data repository, data domains.
• Implemented data and BI strategy for property and casualty insurance company and completed implementation of several end to end Data warehouse, Business Intelligence, and MDM projects for major organization.
• Innovative, visionary backed by sound knowledge of open systems and legacy technologies, excellent communication, and people skills.

CORE COMPETENCIES:

• Business intelligence
• Data Warehouse
• Data Modeling
• Data Integration
• Data Governance
• Master Data Management
• Application Architecture
• Project management (both Agile and Plan based)

TECHNICAL SKILLS:

Database: Oracle, DB2 Z/OS, and LUW, SQL Server, IDMS

ETL: Informatia, IBM DataStage, Oracle Data Integrator

Data Profiler: IBM Information Analyzer

Business Intelligence: OBIEE (former Siebel Analytic), MS Analysis services.

Pre - Built Analytics: OBIA (PA, FA, RA, HR)

Industry Data Model: IBM IIA, IIW, HPDM

Master Data management: IBM (previously Initiate’s) Master Data management

DA and DBA Tools: Erwin, ER Studio, and DB Artisan, Rational data architect, BMC Data administration tools

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect

Responsibilities:

• Following are the tasks accomplished so far:
• Did a current state, future state, and gap analysis
• Assess BI readiness of the organization and identify related gaps and issues
• Took actionable and baby steps like implementing a financial analytics based on general ledger transaction first
• Developed data naming standards, data quality standards, data mapping, requirement gathering templates
• Selected BI product stack
• Selected and sized the server needed for hosting the Data warehouse database and other BI tools
• Procured and implemented ERStudio, data modeling tool to build data models and enterprise data dictionary
• Gathered business requirements (Metrics, KPIs, and reports) by interviewing business users and created a dimensional data model for financial analytics with two facts and seven dimensions.

Confidential

Data Warehouse Architect

Responsibilities:

• Automated key monitoring metrics for over 1500 clinical Confidential analysts to perform their jobs more efficiently.
• Implemented data naming standards and best practices for Data Warehouse.
• Defined Roadmap, Priority Metrics, Risks for various BI projects
• Designed data integration architecture for data acquisition from source systems (EBS, PeopleSoft etc.) to DW using SOA.
• Designed new data models and augmented several models in different subject areas of Oracle pre-built analytics (OBIA)
• Architected, designed and lead a team in developing Informatica and ODI ETL mappings.
• Designed the OBIEE repository for specific subject areas.
• Implemented Project Analytic and Resource Analytic Business Intelligence Solution.
• Reduced the ETL batch window considerably by doing extensive performance tuning on Informatica ETL jobs.

Confidential

Health System Data Architect

Responsibilities:

• Designed data models and ETL processes for patient’s hospital encounter data mart.
• Designed architecture for data integration between Vanderbilt and National cardiac registries.

Confidential

Enterprise Data Architect

Responsibilities:

• Implemented data architecture strategy by forming a data architecture center of excellence committee by selecting cross-functional team members that includes but not limited to data naming standards, data quality standards, blueprint for Enterprise Data Warehouse, Operational Data Store, data marts, ETL standards and best practices.
• Designed a Conceptual, Logical and Physical data models for data warehouse that comprises of subject areas like policy, claim, clients, and Underwriting.
• Designed an Operational Data Store for operational reporting.
• Designed several data marts (dimensional) and OLAP cubes for analytical reporting.
• Created an enterprise data dictionary and metadata of legacy applications to serve as business glossary.
• Managed Data Warehouse and ETL implementation by leading a team from DA, DBA, and ETL area.

Confidential

Data Modeller

Responsibilities:

• Designed part of policy administration OLTP database (Conceptual, logical, and physical).
• Design Loss Ratio Data mart.
• Implemented ER studio by replacing ERWIN that includes a new Meta data repository.
• Provided insights for creating Data Governance and Stewardship team.

Confidential

Senior Data Architect (Consultant)

Responsibilities:

• Delivered multi-dimensional data models around the global new accounts application.
• Designed extension to existing data models for balance transfer functionalities that eliminate duplicate data storage and processing.
• Developed a data model for Customer Relationship Capabilities application that will drive charge volume of untapped market of over $1.3 T.
• Worked on data archaeology, metadata management by clearly defining data elements used in risk management decision making.

Confidential

Architect/IT Project Lead

Responsibilities:

• Realized significant ROI by implementing master data management tool in the provider area to deliver trusted master data to downstream systems that include ODS, data warehouse etc. Confidential is benefited from litigation and other customer relation issues.
• Organized existing data models, data flows and data dictionaries into an enterprise Metadata Repository.
• Designed relational databases to support several of the company’s core database system
• Designed and implemented much of the current corporate data warehouse
• Improve data analytics throughputs by redesigning OLAP cubes and fine-tuning the queries that results significant cost saving in terms of highest level of data accuracy of external financial reporting, less numbers job failure, freeing up server resources, production support and audit resources.
• Designed an underwriting tool based on predictive modeling theory that determines the correct mix of employee contribution ratios to fulfill Confidential ’s strategic intent of increasing commercial business revenues through both new business and renewals.
• Designed a provider disruption tool that measures, analysis and communication of “disruptions” that occur to member/provider relationships that would result when employers or groups change provider networks. The new tool drastically reduced the lead time and measures the amount of disruption more efficiently and accurately by producing complex reports that allow Sales staff and potential clients to make informed decisions on new sales and renewal process.
• Approximate 5.8 million dollar premium increase in five years by providing benefits such as improve the accuracy (and capacity) of sales disruption analyses-leading to better results and fewer post-sale issues.
• Improve the efficiency/accuracy of provider lookups related to provider contract loading--reducing loading errors and related downstream claims adjudication issues.
• Enhance the accuracy of network competitive posture reporting--improving Human’s sales prospecting capabilities and growth opportunities in the LG/Nat Acct/ASO segments. Enhance the accuracy of Network data mart provider level reporting (claims analysis by provider, by geography, by network/membership, etc.), enabling the development of more efficient provider fee schedules over time (reduce trend).