Balachandar Marimuthu Email & Phone Number

New York, Ny, Us

As Senior Cloud Database engineer oversee- Data objects migration from Teradata to Snowflake using their proprietary Cloud data fabric- Set up to migrate data from On-Prem to AWS S3 and then to Snowflake- Performance analysis/tuning- Teradata vs Snowflake environment- Set up a Python/Spark ETL(PySpark) process to load semantic layer tables.

April 2013 - Mar 2020Teradata Consultant for one of the largest data warehouses systemPerformance architect - Performance analysis, tuning, design implementationsLoad analysis, Usage Analysis,SQL tuningBAR - Backup and Restore supportApplication DBA/Operations DBATeradata upgrade/migration projects

Teaneck, New Jersey, Us

Datawarehouse Migration lead for the EDW transformation to Integrated Customer Data Warehouse System(ICDW). Core responsibilities:A. DB2 Performance monitoring and tuning of the FI's 300 + Terabyte size Enterprise Data warehouse system.B. Data Management and Usage Analysis for the EDW migration from DB2 to Teradata platform.C. Designing an ETL based mechanism to parse SQL queries and identify unique queries, top running queries and critical forecast data.D. Facilitating migration to Teradata based ICDW system by means ofo Analyzing Primary Index structure on the Teradata tables;o Providing data for release planningo Identifying long running queries in Teradata environment, determine tuning scope and provide recommendations for performance improvement; o Develop metrics for tracking migration progress and initiate remediation to migrate users left behind; o Developed Informatica based tool to process Teradata logs and build usage analysis data on the business queries, tables and attributes.

Teaneck, New Jersey, Us

A. UDB Stored procedure conversion to access data mart and dimension tables in lieu of the existing star schema - fact/dimension tables.B. Evaluate performance and provide tuning recommendations – replaced global temp tables with CTEs, evaluated indexes, MDCs and MQTs performances.C. Data compare and validations of the converted data mart data.D. Validate Informatica ETL migration scripts and make changes as necessary to ensure data integrity between source data and transformed data.E. Getting overall understanding of the IBM Smart Analytics System environment (ISAS) and ensuring process did not adversely impact green screen output

As Database Technology lead, responsible for execution of the data conversion project to implement a consolidated calibration system platform. Responsibilities includeF. Data conversion approach to merge the existing two calibration applications into the new 3rd party calibration systemG. Drive data mapping efforts between the source and destination systemsH. Determine technology and staging area needs for implementing the mergerI. Interfaces - Plan the utility development and subsequent migration of data to the new systemJ. Determine implementation approach – validate different approaches: Lab by lab, consolidated labs or big bang implementation in all labsK. Determine size requirements, backup systems needs

Coral Gables, Florida, Us

. Executed the following projects as the main database lead cum architect:A. PRM IBM Enhancement project – Successfully executed IBM Enablement of the ACI Worldwide’s Risk Management product PRM. The project work involved designing the architecture, evaluating DB2 compatibility, porting the entire product to IBM's z/OS and converting the existing oracle database based product to work on IBM's DB2 database. This is one of the key project that entrusted the confidence in cognizant to win more projects from ACI Worldwide.B. PRM I18N internationalization project – had technical ownership of the database aspects, proposed the internationalization solution design, developed the database components and managed the other aspects - database, middleware and GUI side and ensure successful completion of the project.C. PRM Level 3 Support - Critical Responsibilities - Database issues resolution on DB2, Oracle and SQL Server platforms, evaluate system performance and ensure the product response is up to the customers satisfaction in all databases, contribute to product enhancementsD. PRM 8.0 Development - As database architect , provide architectural guidance, high level designs, maintain data model and own creation of detailed designs and provide estimation

Teaneck, New Jersey, Us

Mumbai, Maharashtra, In

Master Of Business Administration (Mba)

Bachelor Of Engineering - Be

Education record

Education record

Education record