MANISH KUMAR

DATA ARCHITECT

CONTACT PROFILE
Dynamic Senior Data Engineer with over 13 years of experience in business
+91-8880989709
intelligence, software development, and big data engineering across the
transportation and telecommunications domains. Proven expertise in designing
[email protected] scalable data architectures, optimizing pipelines, and implementing large-scale data
solutions to drive operational improvements and enhance customer experience.
linkedin.com/in/manish-k-vishwakarma/ Proficient in Big Data, AWS Cloud, Data Warehousing, and Data Modeling, with a
strong track record of strategic planning and problem-solving. Aspiring to transition
Bengaluru, Karnataka, India into a Data Architect role to further elevate data-driven decision-making and
contribute to organizational success.

SKILLS WORK EXPERIENCE

Language Python, Java Senior Data Engineer / Data Architect

Database Oracle, MySQL, PostgreSQL Wabtec Corporation Oct 2019 - Present

NoSQL MongoDB, DocumentDB Technologies: Pyspark, Dataiku DSS, AWS Services (S3, EC2, RDS, Redshift, Glue,
Athena, Cloudwatch) ElasticSearch, Terraform, Jenkins, MongoDB, DataLake, Data
Hadoop, MapReduce, HDFS, Spark,
Big Data Ware House, PowerBI, Sqoop, Airflow, Oracle, Postgres, SQL, python, Snowflake
Hive, Sqoop, Airflow, Data Lake
DWH Oracle, Redshift, Snowflake Optimized key business processes in Dataiku by cleaning up old partitions,
Visualization PowerBi, Tableau, Qlikview reclaiming 20+ GB of storage, and saving 9.3 hours of processing time daily,
significantly improving pipeline efficiency and reducing operational costs.
Orchestratio Airflow, Luigi, AWS Step Functions Driven organizational security initiatives by implementing Data Flow Diagrams
Data Dimensional Modeling, Star (DFD), Data Protection Plans, and a Disaster Recovery Plan. Successfully identified
Modeling Schema, Snowflake Schema and remediated SAST and Open Source Analysis (OSA)vulnerabilities, improving
GitLab, Jenkins, Bamboo, Docker, data security and compliance.
DevOps Delivered complex data integrations using PySpark, SharePoint, APIs, AWS Glue,
Kubernetes, Terraform, Ansible
and EMR, creating streamlined data pipelines and enhancing overall data
Micro Spring Boot, RESTful APIs, processing efficiency.
Services Zookeeper Led the migration of the entire data platform for key business processes as part of
Domain the TSA exit, resulting in a seamless transition and saving the organization $4M
Telecom, Transportation
Expertise annually in operational budget.
Architected and developed a comprehensive data model for the GPOC call log
solution, which was migrated from Salesforce, leading to $45K annual savings and
ensuring high availability and performance for locomotive fleet management.
EDUCATION Designed and implemented a multitenant architecture on top of the existing data
model to secure customer data and enable system scalability and flexibility across
different clients.
Master's In Data Science
Implemented a data archival process for RDBMS databases, leading to a 38%
improvement in system performance and a 70% improvement in housekeeping and
LJMU, UK
maintenance activities.
Jan 2023 - Jan 2024 Led the data migration of the Ellie Mobile application onto the Torq platform hosted
on EKS Clusters, ensuring a smooth transition with zero data loss and improved
Graduated with Merit (68%) system performance.

Executive PG Program In Data Science Data Engineer

GE Transportation Oct 2017 - Sep 2019
IIIT, Bangalore
Technologies: Pyspark, AWS Services (S3, EC2, RDS, Redshift, Glue, Athena,
Mar 2021 - Aug 2022 Cloudwatch) ElasticSearch, Terraform, Jenkins, MongoDB, DataLake, Data Ware House,
Sqoop, Airflow, Oracle, Postgres, SQL, python, PowerBI
Specialization in Data Generalist
CGPA : 3.38 / 4.0 Led the successful rollout of an automated database change management process
using Liquibase (Datical) across multiple enterprise-level projects. This initiative
Master of Computer Applications streamlined database updates, reduced manual intervention, resulting in a more
efficient and reliable data management process for large-scale data platforms.
KIIT University, Bhubaneswar Implemented a stringent governance model for database access across business
functionalities, enhancing data security and compliance.
Aug 2008 - Jun 2011
Led the migration of legacy data (20+ TB) from on-premise databases to AWS. This
CGPA : 7.74 / 10.0 migration resulted in a 30% reduction in data processing times, improved
scalability.
CERTIFICATIONS Design and develop robust ETL pipelines to process and analyze large volumes of
data from various locomotive systems using Pyspark, EMR, Glue, S3
Conducted code refactoring and data modeling changes to support migration,
AWS Certified Developer – Associate
resulting in system optimization and a significant cost saving of $0.6 million YoY.
Developed a data validation framework to ensure data integrity during data migration.
Jun 2020 - Jun 2023 Successfully identified and rectified issues in several key tables where only partial
data had been migrated during the cutover,
AWS Certified Solution Architect – Associate Optimized data storage and processing workflows, reducing cloud infrastructure
costs by 25% without compromising performance or data availability.
Sep 2020 - Sep 2023 Automated the deployment of data pipelines by integrating Terraform for
infrastructure-as-code and Jenkins for CI/CD, enabling end-to-end orchestration of
Certified ScrumMaster (CSM) data ingestion and processing workflows.
Collaborated with cross-functional teams (data science, operations, IT) to understand
Dec 2019 - Dec 2021 business requirements and translated them into technical data solutions.

Data Analytics by IIM Rohatak

System Analyst
GE Transportation Aug 2015 - Sep 2017
May 2018 - No Expiry Technologies: Java, Springboot, Oracle, PLSQL, Solr, Toad, git, Jenkins, Jira

Led the development and modernization of key features for the work order and
materials management system, transitioning the monolithic application to a
RECOGNITIONS
microservices-based architecture using Java, Spring Boot, and RESTful services,
significantly enhancing system modularity, scalability, and fault tolerance.
Wabtec Accolade Award Collaborated with cross-functional teams to analyze and understand complex Oracle
PL/SQL business processes, effectively translating them into Java-based
Awarded the "Going Extra Miles" accolade microservices, improving system efficiency and aligning with modern software
in 2021in recognition of exceptional architecture standards.
dedication and commitment to exceeding led the integration of Apache Solr to enhance search capabilities within the materials
expectations. management system, leading to a 40% improvement in search speed and an
enhanced user experience by making data retrieval more efficient.
WITEC Technology Excellence Award Optimized system performance by refining and optimizing data models, database
structures, and SQL queries, resulting in a 50% reduction in query execution times,
Recipient of the WITEC Technology boosting system responsiveness, and enhancing data retrieval processes.
Excellence Award in the "GET IT DONE" Played a key role in the data migration strategy, successfully overseeing the migration
category in Mar 2020, acknowledging the of large datasets from legacy systems to the new microservices-based platform,
successful delivery of customer ensuring data integrity, consistency.
requirements at Wabtec.
Senior Software Engineer
Above and Beyond award Aricent Technologies Holding Ltd Jan 2014 - Aug 2015
Technologies: Oracle, PLSQL, Java, Spring, Struts, Hibernate, Shell Scripting, Toad, git
Honored with the "Above and Beyond"
award from GE Transportation in Q2 2017, Led a team of 3 software engineers in the full development lifecycle including
and Q3 2018, reflecting outstanding requirements gathering, design, development, testing, and deployment, ensuring the
performance and contribution. delivery of high-quality software solutions.
Redesigned and optimized core applications using Java, J2EE, PL/SQL, Oracle, and
JSP, resulting in a 30% performance improvement, faster processing times, and
enhanced system scalability to support growing user demands.
LEADERSHIP Driven comprehensive User Acceptance Testing (UAT) in collaboration with cross-
functional teams and clients, ensuring all specifications, performance requirements,
Global IT purpose and regulatory compliance were met, reducing post-release defects by 20%.
Optimized PL/SQL queries and Oracle database structures, reducing query execution
Led a global team to strengthen times by 40%, improving overall system performance.
purpose-driven values within Global Ensured adherence to industry standards and security protocols, conducting code
IT, conducting a comprehensive reviews and implementing best practices for software development, including data
employee sentiment survey. protection, encryption, and access control measures.
Analyzed findings and presented
strategic recommendations to Software Engineer
improve key business functions. Aricent Technologies Holding Ltd Jul 2011 - Jan 2014
Technologies: Oracle, PLSQL, Java, OBIEE, Shell Scripting, Toad
FFE Mentor
Significantly improved system performance by modernizing a legacy data ingestion
Serving as a mentor with Foundation utility using Java and PL-SQL.
for Excellence (FFE) for the past two Effectively engaged with business users to understand their requirements, translating
years. these insights into detailed design documents.
Guiding underprivileged 3rd-year Enhanced user experience by supporting business customers with OBIEE reports,
engineering scholars to develop optimizing mapping, and improving inline SQL query performance.
essential soft skills, helping them Demonstrated extensive expertise in utilizing flat files and RDBMS for data loading,
build a strong foundation for a transformation, and extraction.
successful career.