Aashna R. Krishnan Email and Phone Number

• Solution database designs and use data modeling tools such as Erwin Data Modeler to create conceptual, logical, and physical ERDs (entity relationship diagrams).• Design OLAP (online analytical processing) and OLTP (online transaction processing) solutions. Design dimensional models. • Certified in using the Data Vault methodology to solution big data designs. • Work on stored procedures and code packages to generate build compatible DDL scripts (in SQL, PL-SQL, and HiveQL). These include create table scripts, alter table scripts, sequence code, and materialized view scripts. • Deploy build DDL scripts to development environments for various databases including Hive and Oracle.• Perform unit testing of database solutions. Strong at performing data analysis to identify performance tuning requirements i.e., partitioning, setting unique constraints or performance indexes. • Work cross functionally with teams across the enterprise. Gather requirements from business teams. Collaborate and communicate well with information design and enterprise architects, development staff, and testers to design and deliver solutions.• Define metadata specifications and share as basis for creating source to target mappings. Have created source to target mappings.• Participate in business case opportunities to create and present high level architecture diagrams (DA200s). • Define and document standards relative to data architecture practices. Present these at enterprise-wide architecture review boards.• Publish corporate wide communications on behalf of the Data Architecture team including an article about our standards and on behalf of the AERG. Have presented on team accomplishments to town hall forums with more than 100 people and with senior leadership in attendance.