PROFESSIONAL SUMMARY:

• Senior data architect experienced in Data Modeling (conceptual, Logical and physical), Proficient in development of OLTP, Data Warehouse and Dimensional Data models (star schema for Data marts) using iterative Agile development methodology; Data source analysis. Data Modeling for AWS MPP columnar data warehouse: Redshift.
• A team player with strong technical, analytical and problem solving skills.
• Experienced in interfacing with business and IT stakeholders to gather, document and clarify data requirements and translate them into logical data model.
• Owned and managed all changes to the data models. Created data models, developed Logical attribute naming standards, and data architecture documentation for complex information systems.
• Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.
• Worked with project and application teams to ensure that they understand and fully comply with data quality standards, data architecture guidelines and designs.

WORK EXPERIENCE:

Confidential

Data Architect Consultant

Responsibilities:

• Review BRDs, conduct user interviews to gather data requirements.
• Transform requirements into logical and physical data models, normalized and Dimensional.
• Generate DDL and create database objects in all environments: DEV/SIT/UAT/PTE/PROD.
• Modify/Extend existing data models to accommodate additional data requirements.
• Prepare Meta data dictionaries using metadata stored in Erwin models.
• Create and maintain logical and physical data model naming standards.
• Perform disk space requirement analysis based on data volumes.
• Query performance improvement; review generate and review explain plans and suggest and implement performance improvements by creating new indexes to eliminate full table scans; partitioning tables, use of hints etc.Major s:

Technology Environment 2: Oracle, Erwin, Hadoop, AWS RedshiftUBS Financial Services - Wealth Management Division - Assistant Vice President

Information Architect

Confidential

Responsibilities:

• Designed the data model for Legal & compliance (L&C) data warehouse and EDW- Enterprise Data Warehouse . Integrated L&C data warehouse into Enterprise Data Warehouse. EDW is the main source of data for BI reports for Branch managers and FAs and other compliance and regulatory reports.
• Developed the data model for UBS Banking Products data mart. It is used for profitability analysis of banking products (brokerage accounts, credit cards, securities backed loans- SBL), etc. Data mart integrated banking products data from various productions systems and saved many days of manual data integration efforts. It empowered users to perform analysis and generate reports in minutes that used to take days.
• Designed a dimensional data model for a data warehouse for Investment Consulting Services (ICS) division. ICS data warehouse supports investment managers, monitors the client assets growth and performance of financial advisors. It is also used to perform analysis of established Managed Account Programs and new initiatives.
• Designed the data model for Customer Information System (CIS) data mart. This data mart is the source of data for BI reports used by Database Marketing Group and by Financial Advisors (FA) for cross selling and up selling.
• Participated in design and development of UBS Wealth Management’s Enterprise Logical Data Model. Subject areas in EDM are used as starting point for most new project data models, thus saving significant efforts and time in creating new Logical data models for specific projects.
• Designed the data model for UBS Banking Products data mart. It is used for profitability analysis of banking products (brokerage accounts, credit cards, securities backed Lending (SBL), etc. Data mart integrated banking products data from various productions systems and saved many days of manual data integrations efforts. It empowered business users to perform analysis and run reports in minutes that formerly took days to generate.
• Led the development and rollout of the Business Intelligence reporting system to over 100 UBS Wealth Management branches. It consisted of over 100 reports used by UBS Financial Advisors and branch managers for cross-selling and up-selling. On-line BI reports resulted in great time savings by eliminating paper-based reports. Data source for the reports is Oracle data warehouse and Essbase cubes.

Confidential, New York, NY

Senior Technical Specialist

Responsibilities:

• Led a team of developers to redesign and to migrate the Performance evaluation reporting system from mainframe to the Oracle platform. Reports are used by PCEC (Principal Candidate Evaluation Committee) to evaluate the performance of Senior Engagement Managers and promote them to junior partners (Principals). The new system reduced maintenance costs by almost 90%.
• Led the design, development and implementation of a Firm-wide database “FPIS” (Firm Practice information system). This database contains history of all Confidential Client Engagements and is used as a knowledge management and research tool by Confidential ’s consulting staff to efficiently serve new and existing clients.