ABHISHEK PANDEY

Experience

• 

  M Soft Corporation

  Mar 2015 - Apr 2016

  Software Engineer and Industrial Programmer

  Responsible for Development of User interface and business logic for front end standalone applications and Web applications.

• 

  Tata Consultancy Services

  May 2016 - Dec 2022

  System Software Engineer

  Worked as a ETL Development and support on a Retail and Life Sciences Domain.• Play a part in direct communication with Clients and Vendors.• Performed optimisation on Oracle database and ODImappings to suit customer requirements.• Performed Data warehouse and Business Intelligence projects.• Worked on Packaged Oracle BI application.• Debug PL/SQL Procedures.• Developed and implemented SCD Type 2, CDC, HierarchyFlattering, KM Customisation Aggregation, File, DB and XML transformations, Topology setup Show less

• 

  IBM

  Dec 2022 - Dec 2023

  ODI Package Specialist

  • Developed and implemented ODI packages to automate data integration processes, resulting in a 50% reduction in manual effort and a 30% increase in data accuracy.• Collaborated with cross-functional teams to analyse business requirements and design ODI solutions, successfully delivering projects on time and within budget.• Optimised ODI workflows and data mappings, leading to a 40% improvement in data processing speed and enhancing overall system performance.• Conducted regular performance tuning and troubleshooting of ODI packages, ensuring smooth data flow and minimising downtime for critical business applications.• Customisation and adding column to existing fact and dimension table.• Customisation and adding addition fact and dimension table and design SDE, SIL and PLP• Customisation stored lookups and adding indexes to resolve dimension keys.• Play a part in direct communication with Clients and Vendors. Show less

• 

  Capgemini

  Dec 2023 - now

  Manager

  • Knowledge Module Customization in ODI to optimize and streamline ETL processes for enhanced performance and flexibility.• Customization of Batch Control Tables to improve load management, data reconciliation, and error handling.• Expertise in OBIA (Oracle Business Intelligence Applications) customization, including extending and modifying out-of-the-box functionality to meet specific business requirements.• Designing and developing new Fact and Dimension tables, ensuring alignment with the star schema and data warehouse architecture.• Resolving dimensional keys to facts, ensuring data integrity and accurate reporting across the analytics platform.• Performance optimization of ETL loads, identifying bottlenecks, and implementing strategies to enhance efficiency and reduce processing time.• Serving as a Manager and Tech Lead, leading a team of 6 ODI developers, ensuring seamless project delivery and adherence to timelines.• Managing and providing technical oversight for 6 cross-functional squads, while actively contributing as a core member of 1 dedicated squad.• Monitoring team performance, providing continuous feedback, and implementing strategies to enhance productivity and efficiency.• Maintaining transparent communication with senior management, ensuring alignment on project progress, risks, and deliverables.• Mentoring and training team members, promoting skill development, best practices, and knowledge sharing.• Ensuring high customer satisfaction by proactively addressing issues, delivering quality solutions, and maintaining strong client relationships.• Acting as the primary point of contact for stakeholders, ensuring clear communication and alignment with business goals and expectations.• Driving continuous improvement initiatives to enhance project outcomes, team performance, and client value delivery. Show less