Ram Chand Mahto Email & Phone Number

United States

Washington D.C. Metro Area

• Troubleshoot ETL failures and implement appropriate data transforms.
• Create on-boarding documents and serve as one of the cross-team trainers responsible for on-boarding colleagues on the various nuances of the data extraction processes.
• Develop and modify shell, batch and python scripts to extract and automate high-quality data delivery.
• Collaborate with project sponsors, and technical leads at the Institutions throughout the post-implementation period.
• Manage the end to end process to maintain seamless data updates, define requirements, troubleshoot technical issues and implement business logic changes to ensure data integrity throughout the process.

Washington D.C. Metro Area

• Extract and analyze data from various Student Information Systems like Banner, PeopleSoft and Colleague to provide effective data solutions to the clients.
• Optimize SQL scripts thereby making the script more efficient and decreasing the performance overhead by 10%.
• Develop and implement ETL jobs to transform data according to business requirements.
• Perform initial data validation and unit as well as integration testing to ensure data quality.

Washington D.C. Metro Area

• Develop batch and shell scripts to automate the processes for 40+ client universities reducing the down time of the application by 80%.
• Collaborate with internal and external stakeholders to ensure timely delivery of implementation.
• Analyze student, course, faculty, finance and human resources data to create academic, cost, and capacity metrics for the client universities.

Boston, Massachusetts

• Volunteered to assist Professor Chaiyaporn Mutsalklisana in conducting workshops on various database concepts and tools in a class consisting of 60 students.
• Mentored students and assisted them with assignments, project development and evaluated exams, provided solutions and presented them.

Ahmedabad Area, India

• Analyze, design and perform unit testing of all ETL related jobs.
• Develop ETL pipelines and monitor their performance in sequential as well as parallel layout.
• Improve the ETL performance by using Lookups, In-Memory Joins and parallelism techniques.
• Utilize continuous flow process for real time extraction and transformation of data.
• Prepare/Review low level design documents and data validation sheets reflecting the new changes.
• Work on all phases of data warehouse development life cycle, from gathering requirements to implementation, testing and support.

Master Of Information Systems, Advances In Data Science, Data Warehouse Business Intelligence

Bachelor'S Degree, Computer Engineering

Bachelor's Degree Computer Engineering with courses like Advanced Databases, Database Management System and Data Structures.