Bimlesh Kumar Pandey

About Bimlesh Kumar Pandey

Highly accomplished IT professional with around 7 years\' experience spanning software development, database management, cloud technologies, and software testing. Expertise includes cloud deployment, migration, and monitoring on AWS and Oracle Cloud. Proficient in query languages like Hadoop and SQL, extracting valuable insights from complex datasets. Skilled in constructing robust data pipelines aligning with organizational data strategy, enabling actionable insight extraction. Proficient in database management, including schema development, enhancing performance, and maintaining data integrity. Experienced in product information management (PIM) with Oracle Master Data Management (MDM). Utilize Tableau and Qlik for data analysis, visualization, and ETL processes, ensuring seamless operation and resolving integration challenges. Specialize in complex data mapping, system design, upgrades, and maintenance. Expertise in developing integration strategies facilitating connectivity between on-premises systems and cloud services using APIs and middleware tools. Dedicated to driving technological excellence and delivering results in software development, database management, cloud technologies, and software testing. In summary, my multifaceted experience and expertise in software development, database management, cloud technologies, and software testing, coupled with a strong focus on data management and integration, position me as a valuable asset in the dynamic landscape of IT. I am committed to delivering tangible results and driving technological innovation for the organizations I collaborate with.

Experience

1. Senior Consultant

   Capgemini

   Sep 2024 — Present · Noida, IN

   Developed scalable, high-performance data processing solutions using Scala.• Integrated Scala with ETL pipelines for both batch and real-time data processing.• Designed algorithms for complex data transformations and aggregations in Scala.• Developed and optimized ETL processes for ingesting and transforming large datasets from various sources.• Automated ETL workflows using cloud-based solutions like AWS Glue and Azure Data Factory.• Ensured data accuracy and integrity across all ETL processes.• Performed data mapping, transformation, and validation using Informatica.• Used Informatica MDM to cleanse and consolidate master data, ensuring consistency across the enterprise.• Led MDM initiatives, managing critical master data domains such as customers, products, and vendors.• Collaborated with business teams to define and enforce master data governance policies.• Installed and configured MongoDB instances on-premises and in cloud environments (AWS, Azure).• Implemented high-availability setups using MongoDB replica sets and sharded clusters.• Optimized MongoDB queries, indexes, and configurations to improve performance.• Monitored database performance with MongoDB Ops Manager, identifying and resolving bottlenecks.• Enforced MongoDB security, including user authentication, RBAC, and SSL/TLS encryption.• Conducted capacity planning and dynamically scaled MongoDB clusters to handle high traffic.• Set up monitoring systems using Prometheus, Grafana, and the ELK stack for tracking metrics.• Managed MongoDB replica sets to ensure redundancy and failover capabilities.• Provided L2/L3 support for MongoDB databases, troubleshooting performance and connectivity issues.• Planned and executed MongoDB upgrades, applying security patches.• Collaborated with development teams to design and optimize data models and queries.• Automated database maintenance tasks using Bash and Python scripts for efficient operations.

Education

• Goethe University Frankfurt

  Certificate In German Language, German Language

  2011 — 2012

• Maharshi Dayanand University

  Master's Degree, Computer Science

  2012 — 2015

• Bundelkhand University Alumni

  Bachelor's Degree, Computer Science

  2008 — 2011

• Meerut

  Senior Secondary School, Science

  1996 — 2007

Skills

• Software Quality Assurance
• C
• Html
• Java
• Mysql
• Selenium Testing
• Oracle
• Vb.net
• C++
• Business Analysis
• Visual Basic .net (Vb.net)
• Windows Server
• Javascript
• Css
• C#
• .net
• Windows
• Eclipse
• Sql
• Linux
• Asp.net
• Xml
• Software Testing
• Php
• Microsoft Sql Server
• Team Management