Nimesh Kumar Email & Phone Number

India

• Lead a team of engineers to build a common framework to migrate legacy pieces into GCP• Identify the key stakeholders, bring everyone on same platform and Project Kick-off.• Responsible for working with 11 Fleet external Vendors on project alignment & key exchanges for GECHub mailbox setup for file transfer to GCS Buckets• Setting up of GCP Infrastructure which includes GCP Project, Service account & Buckets creation• Setting up of Astronomer, Tekton pipeline and integration of astronomer with GCP infrastructure • Establish Agile principles for design and development of Fleet file processing in GCP and load to PostGre• Establish WebFocus/QlickSense connectivity with PostgreSQL and compare dashboard performance • Responsible for fetching large volume (~25TB) of Teradata tables into GCS Buckets• Ingest Data from Hadoop to Big Query & establish connectivity with WebFocus • Responsible for running Proof of Concepts and spikes identified in the product

India

4 years of experience on Big Data development on Hadoop Ecosystems which includes Map-Reduce, Spark, Hive, Apache KUDU, Druid, Sqoop, HBase, Oozie scheduler, hue with diverse proof of concepts• Responsible for fetching large volume (~25TB) of Teradata records into HDFS • Worked on Creating Hive, HBase, Druid, KUDU tables on top of the HDFS location• Work with Cloudera, EA & WebFocus IBI team to find out the right Jars & drivers for Adapter creation• Establish WebFocus connectivity with Hive, HBase, Druid, KUDU tables and compare dashboard performance• Ingest Data from Hadoop to Big Query & establish connectivity with WebFocus • Responsible for running Proof of Concepts and spikes identified in the product• Lead a team of engineers to build a common framework to migrate legacy pieces into Hadoop• Develop PySpark codes during read, transformations and writes• Use Sqoop action in Oozie along with Fork and join to perform parallel processing• Schedule and monitor job using oozie yarn & monitor in Hue• Sqoop Export final data to SQL Server for dashboard reporting• Responsible for migration of 150+ impacted Components for Hadoop Cloudera migration • Working with HPC team for resolution of challenging issues like replacement of HWC & LLAP – CTAS

Gurgaon, India

- Designed the logical and physical data models for Sql Server applications like FDSP(Ford Diagnostic Service Platform), GTAC (Global Technical Assistance Center) and Big Data Projects like GDIA (Global DataInsight & Analytics).- Designed LDM and PDM for Smart Mobility Projects (using MS SQL Server db offering on Azure -Off Prem). Designed database tables for the experimental Ford Assured (U First) mobile platform for used Live vehicle bidding.- Worked with business owners, system developers and at various levels of management. Expertise in gathering systems requirements and designing data models.- Good at data and metadata analysis and also in management, understanding complex user requirements and resolving technical and functional issues.- Solid experience translating business requirements into conceptual, logical, and physical data models.- Implemented best practices and methodologies in data analysis, design and modeling.- Very much experienced in data modelling in most of DB technology like HIVE, HBASE, Teradata, SQL Server, DB2 and Oracle.- Experience in data modelling for both analytical and transactional applications.- Strong expertise in working with Global and Agile Projects.- Implemented Design standards for using normalized data structures, de-normalized structures, and dimensional structures.- Extensive hands on experience on Oracle, Sql Server, Sybase Power Designer and Data Quality tools.- Implemented database models, data flow diagrams, database schemas, db scripts, DTD schemas, structures and data standards to support a robust data management infrastructure.

Chennai Area, India

-Manage and support the 30+ Oracle databases. -Create or clone the Oracle Instance and Databases on ASM. Perform database cloning and re-location activities. -Maintaining data integrity also managing profiles, resources and password security. -Upgrading the 10g databases to 11g including data guard. -Upgrading the Database from lower version to higher version. -Tune SQL statement against database and its objects. -Write script to monitor the database with shell and PL, SQL code or SQL PL, SQL code such as procedure, function, and package.-Physical Database Backup and recovery (Hot and Cold Backups) and Logical Backup. -Database Links, Creating and Managing Tablespaces and Datafiles, Creating and Rebuilding Indexes, Managing Database Security.-Creating Database users and granting roles.-Request Center and Service Desk Ticketing Tool.-Tivoli(Tivoli Storage Manager)-Performance information and monitoring/interpreting alert log and trace files.-Troubleshooting and maintenance of Oracle Database.-Handling Import/Export like schema, table, full database etc.-Handling space issues.-Attend daily change requests for production database.-Diagnosis of the Alert and Notification.-Oracle 11g installation on windows.-Oracle 10g installation on Solaris10.

Bachelor Of Technology (Btech), Electrical, Electronics And Communications Engineering, 8.6

Activities and Societies: -Member of Technical core committee in IEEE student branch in VIT University. -Active Member of IEEE, ISTE, IE.

Higher Secondary

Education record