Resume

Sign in

Data Architect

Location:
San Jose, California, United States
Posted:
September 22, 2019

Contact this candidate

Resume:

…Continued…

Hari Ramamurthy

San Jose, California

408-***-**** • adae25@r.postjobfree.com

https://www.linkedin.com/in/hari-ramamurthy-6743a68/ Senior Data Architect & Engineer

Multifaceted career with an extensive record of database architecture to solve business challenges Technically experienced and quality-driven Senior Database Architect/Engineer with a solid history of the global server management of large relational database management systems. Broad expertise in data modeling, database design and development, administration, performance tuning, data migration and archival across various industries and domain. Skilled at optimizing solutions in PostgreSQL, Oracle, MS SQL Server, and DB2 UDB database technologies and developing products using Java. Adept at designing solutions delivery, organizational leadership, and issue resolution experience and direction for the creation of new products and applications.

Database Architecture & Development / Data Modeling / Data Migration, Consolidation & Archival ETL Processes & Schema Upgrades / Business Ops Enablement / Performance Tuning & Optimization Client Relationships & Technical Guidance / Solutions Delivery / Framework & Script Creation TECHNICAL PROFICIENCIES

Database Tech: PostgreSQL, ORACLE, MS SQL Server, DB2 UDB, JDBC, ODBC Languages: JAVA, Python, Transact SQL, Oracle PL/SQL, DB2 SQL-PL Operating Systems: UNIX, Microsoft WINDOWS, and Linux Data Modeling:

ETL Tools:

ERWIN, Sybase Power Designer

SSIS, SyncSort (DMExpress)

Cloud Architecture: Amazon AWS, Microsoft Azure

Big Data Tools: Spark, Hadoop

Other: NoSQL: Cassandra, Frameworks: Hibernate, Spring, Data Visualization Tool: Tableau

PROFESSIONAL EXPERIENCE

Staff Database Engineer (10/2017 – 07/2019)

Synopsys Inc., San Francisco, CA

Technical Scope: Java, Hibernate, Spring Framework, PostgreSQL Presided over the architecture, delivery, and technical support of database solutions deftly guiding development from designing, development, staging, testing, and to release efforts. Guaranteed data security, and optimal performance of applications with robust data model, database design, efficient SQL queries, JDBC calls, and SQL Tuning/Optimization. Thought leadership to sales team, product development, support teams, and customers. Steered a variety of architecture areas including constructing the data access layer, Database Schema Upgrades, ETL implementations, and reporting and analytics layers.

Key Achievements:

Boosted database performance by 10X of background jobs, and ETL operations by querying tuning for SQL, PostgreSQL, and JDBC call optimization,

Reduced database size by 40% and improved response time by 50% with various normalization and vertical partitioning techniques.

Hari Ramamurthy

Page Two

Designed, developed, and implemented custom Data Migration utility to migrate subset of the data across the databases of different product instances. Staff Database Engineer (07/2015– 09/2017)

BlackBerry Limited (AtHoc), San Mateo, CA

Technical Scope: MS SQL Server, T-SQL, SSMS, SSIS, SQL Profiler Headed the creation of the data access layers for core products including data modeling, database architecture, performance tuning, and DB support functions. Designed, developed and implemented key product features to fulfill request and meet business challenges. Key Achievements:

Lowered performance regression incidents by 30% with the implementation of a variety of new features and database design techniques.

Improved user interface performance and scalability with the implementation of database level caching boosting search functionality.

Chief Data Architect, (02/2006– 06/2015)

Cognizant Technology Solutions, Chennai, India

Technical Scope: MS SQL Server, T-SQL, Oracle, PL/SQL,DB2 UDB, ERWIN, Sybase Power Designer, SSIS, SyncSort (DMExpress), AWS, Azure, Hadoop, Spark, Cassandra Led a team of more than 100 data architects, DBAs, and developers in database design and architecture, administration, performance tuning, script creation, data consolidation and monitoring activities. Migrated over 3K customer databases to Private Cloud with multi-tenant data modeling. Managed several technical projects including the building of new database platform features, IP creation, accelerator and framework construction, and the automation of schema change rollouts across database servers. Functioned as Data Architect in several client projects providing end-to-end Data Architecture solutions, leadership, and technical guidance to clients. Key Projects:

On-line Brokerage Company, California - Cloud SaaS Application Development: Architected multitenant data modeling, Oracle database development, and data migration and security. Steered Sand-Box strategy, DB schema automation, performance tuning, and data versioning.

Large Retailer Company, US - Application & Data Migration from IBM z/OS to Linux: Furnished strategy for migrating schema and data from IBM Main Frame to DB2 UDB on Linux.

Global Diversified Financial Services Company, US: Application & Data Migration from Oracle to DB2 UDB. Steered the schema and data migration from Oracle to DB2 UDB.

Leading Financial Institution, California - Application consolidation from legacy CRM to SAP CRM: Orchestrated the data consolidation from the client’s legacy CRM databases to an SAP CRM database.

Lead Software Engineer, Siebel Systems, San Mateo, CA (10/2004 – 01/2006) Technical Scope: Oracle, MS SQL Server, DB2 UDB

Performance Tuning Siebel Application Databases.

Additional Experience

Senior Database Engineer Callidus Software, San Jose, CA Senior Database Engineer eGain Communications, Sunnyvale, CA Product Developer Senior Software Engineer Compuware Corporation, Campbell, CA EDUCATION

Programmer Trainee Indian Institute of Science, Bangalore, India Master of Science in Physics University of Madras, Chennai, India



Contact this candidate