EXECUTIVE SUMMARY

An accomplished IT professional worked within world class organizations including Oracle, Microsoft, Washington Mutual and Kellogg’s. More than two decades of IT experience with comprehensive hands-on expertise in Data architecture, Enterprise Data Modeling including logical and physical data modeling, Enterprise Data Warehouse Design, Database Design, Technical Project Management and Solutions Delivery. For over fifteen years, career focus has been centered on Data architecture, EDW design and development.

The application of extensive experience across multiple domains has provided a strong aptitude for dimensional database design coupled with robust operational architecture. Repeatedly demonstrates talent for analyzing business problems and applying technical skills to deliver innovative enterprise solutions.

Leverages managerial and interpersonal skills to motivate, direct and inspire project teams. Strong team builder and facilitator with proven leadership to manage onshore and offshore resources, create manageable work plans leading to successful delivery of tactical and strategic business solutions.

• Data Architecture
• Data Modeling (ER and dimensional)
• EDW & BI Architecture
• Database Application Development
• Technical Project Management
• HealthCare Analytics
• Solutions Delivery
• Online Media Advertising Analytics
• Analysis of Business Problems
• Performance Optimization (Exadata)

TECHNICAL EXPERTISE

• Databases: Oracle 11gR2 (on Exadata), 10g, 9i, 8i, 7.x, MS SQL Server
• OS : Windows (XP/2000/NT), UNIX, DEC VAX/VMS
• S/W : Languages: PL/SQL, SQL, Pro*C, C++
• Tools: Oracle SQL Developer, Data Modeler, Oracle OBIEE, OWB, OLAP & AWM, Discoverer,

Oracle Applications 11i,
Limited exposure in Microsoft SSIS & AS, Informatica, Business Objects

PROFESSIONAL EXPERIENCE

• Confidential,Redwood Shores CA 2009-present
• Applications Architect – Health Sciences Global Business Unit (HSGBU)
• Lead architect for Enterprise HealthCare Analytics (EHA), Data Modeling, DW Architecture, Produce Research Whitepapers to recommend technology solutions for HSGBU, Exadata
• Led design and development of various subject areas within HealthCare Data Warehouse (HDW). A comprehensive data warehouse feeding various analytic applications and Healthcare Data Marts.
• Developed data modeling patterns and architectural standards which are followed across various subject areas to ensure consistency and successful integration of all subject areas within HDW.
• Led JAD sessions with product management and strategy groups to gather and understand business and functional requirements for HDW.
• Resolved showstopper performance issues for Genomics Data Model (GDM) on Exadata to meet aggressive timelines enabling timely release giving significant edge over competitors in TRC applications space.
• GDM deals with massive genomic data and performance tuning involved leveraging various Exadata optimizations including smart scans, storage indexes, HCC compression, smart flash cache
• Designed and delivered data model for Cohort Data Mart – a leading product in Oracle TRC apps suite
• Produced comprehensive research whitepaper on Metadata Management recommending complete Metadata Management Strategy for HSGBU. Analyzed various external and internal metadata management solutions.

Confidential,

• San Francisco CA 2007-2009

Data Warehouse Architect
Provide technical leadership for architecting and designing end to end Data Warehousing solutions to deploy suite of on-line media advertising yield management products for Microsoft clients.

• Designed and implemented Software-as-a-Service (SaaS) data warehouse solutions for feeding analytical applications driving on-line media advertising revenue uplift through price optimization, inventory forecasting, and metric based business intelligence applications.
• Led implementation of Microsoft online advertising yield management products (Price Director and Business Advisor) at various clients including My Space FIM (Fox Interactive Media) and Reuters.
• Reduced data load time and operational expenses by implementing smart data health checks at the beginning of ETL process to ensure source data integrity and identify source data inconsistencies at much earlier point in ETL process resulting in significant reduction in ETL process failures.
• Reduced deployment time and issues by formalizing deployment strategy and establishing well defined deployment process to streamline handshake between development and operations group
• Led team of highly skilled internal and external resources to deliver DW solutions for Microsoft clients.
• Confidential,Pleasanton CA 2006-2007
• Technical Delivery Manager
• Deliver quality DW solutions within budget from outsourced vendors in timely manner.
• Improved customer satisfaction and minimized legal risks by designing and implementing credit card reconciliation process to identify missing credit card applications enabling responding to customer in timely manner and satisfy legal obligations.
• Improved availability of business critical data and SLA for several business data marts by reducing the processing time of most critical business process by means of performance tuning.
• Led numerous projects in capacity of technical project manager and delivered quality solutions on time and within budget including Oracle OLAP proof of concept project, Customer Service Data Warehouse, GL Data mart etc.
• Built re-usable data warehouse framework for ETL process control, monitoring and tracking to reduce ETL development time significantly for new projects
• Confidential,Redwood Shores CA 1999-2005
• Applications Architect/Project leader - EDW
• Lead architect and developer for EDW - a module within Oracle E-BI suite of Oracle Applications.
• Led design and development of EDW including dimensional modeling, slowly changing dimensions, star and snowflake schemas incorporating partial snow-flaking to successfully deliver EDW as a packaged data warehouse solution under Oracle Applications.
• Resolved critical EDW performance issues at Oracle IT by developing innovative indexing strategy based on bit map indexes to get star query transformations to achieve dramatic performance improvements.
• Reduced development time significantly and enabled faster time to market by designing and developing generic EDW security solution based on Oracle 8i feature VPD and Row level Security.
• Enhanced performance and usability of EDW by exploration and uptake of several Oracle DW features including materialized views, query rewrite, bit map indexing and VPD.
• Created development and architectural standards for other EDW product teams to ensure consistency and successful integration of multiple modules within EDW.

EDUCATION AND PROFESSIONAL TRAINING

• Bachelor of Engineering (BE) - Electronics & Telecom, 1st Class, Confidential, Pune, India
• Ralph Kimball - Data Warehousing and Dimensional Modeling, ETL architecture in depth
• Numerous trainings from Oracle University including Data Modeling, Data Warehousing, OBIEE etc.
• Fast Start in Project Management – Systemation