Pranay Somyajula Email & Phone Number

Profile Enterprise data architect with 22 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals like Financial Securities, Retail Banking, Channel and Trade Management (CRM), Order Management, Supply Chain Management (SCM) and Insurance. Strengths in Oracle & DB2 Database, Data Modeling, Application Architecture Design & Integration, Database Programming and Database Optimization. IBM and IASA (International Association of Software Architect) Certified ArchitectJob Responsibilities Data architecture and design for Staging (Landing), Transactional (OLTP), Decision Support (OLAP) and Data Analytics Conceptual, Logical and Physical data modeling for transactional and data warehouse Data model synchronization & optimization Data governance strategy Data life cycle management Data security strategy Database performance and scalability strategy Scripting of DDL, DML for database objects creation Data integration with ETL and analytics as a service Design workflow pattern for frameworks Common framework to fulfill dynamic reporting requirements Solution design for architectural challenges of sourcing multiple data sources Design and development of system architecture and implementation UI application prototyping in HTML5 and CSS3 for stakeholder engagement Risk and mitigation planning of architecture and design implementation Solution designing of complex modules and interfaces Performance evaluation each prototype iteration