Working on the data modelling use cases for a major global investment banking client

At IBM India Pvt. Ltd, I played an integral role in the "Project Focus" initiative for our esteemed client, Mercedes-Benz. The project's objective was to facilitate the spin-off of assets, including dealers, distributors, and their loan/lease contracts, into separate entities for Commercial Vehicles and Passenger Cars. This strategic move by Mercedes-Benz's parent company aimed to enhance operational focus and financial clarity.Responsibilities:• Extracting financial KPIs and vehicle loan, contracts and lease details from the main database that is hosted in Head-Quarter office of the client (Mercedes-Benz Financial Services), resulting in a 20% increase in efficiency in preparing Accounts Receivables and Accounts Payables records that is used to create dashboard reports for both Commercial Vehicles and Passenger Cars.• Effectively splitting accounting journal entries between Commercial Vehicle assets and Passenger Car assets, averaging approximately 50 entries per week.• Developing and executing reconciliation test cases with a success rate of 95%, meeting or exceeding end-users' acceptance criteria.• Actively participating in an average of 3 client requirement gathering calls, Daily Scrum stand-up meetings, and 2 Sprint meetings with Scrum-master and Product-Owner per week.• Contributing to the finalization and preparation of product backlog items, including managing an average of 5 Change Requests, Data Quality fixes, and enhancement requests per Sprint.• Co-ordinating with the IT Vendors from different geographic regions and acting as a liaison between the IT teams and the Regional Office teams from Japan, South Africa, Germany and Australia.Key Achievements:• Received "Champion Learner Silver – 2023" appreciation for investing in my skills development.• Earned "IBM Agile Explorer" digital credential for completing course on Agile principles.

My tenure at RBS India Pvt. Ltd was marked by my pivotal involvement in the "Commercial & Private Banking Data Sign-Off Project." This initiative centered around ensuring the precision and accuracy of customer data and credit applications data in databases and downstream systems for the Commercial & Private Banking business. This entailed meticulous checks, adjustments, and data management to maintain the integrity of crucial financial information.Roles and Responsibilities: Held accountable for verifying credit applications and upholding data accuracy within the Relationship Manager Platform (RMP) Management Information System (MIS) system. Conducted comprehensive hierarchy checks, identifying and rectifying inaccuracies in the hierarchy levels of Credit Officers, Portfolio Managers, and related roles. This was especially crucial due to movements across demographic regions and potential errors at the source. Drove analysis of Problem Portfolios, facilitating data sign-off on Problem Management Transfers from performing to non-performing portfolios and vice versa. This intricate process involved astute decision-making and data-driven insights.Tools & Languages:TOAD, Oracle SQL, Microsoft Excel, RMP MIS Data Warehouse, OBIEE (Oracle Business Intelligence Enterprise Edition), OBIEE Automatic Dashboard Report Generation through OBIEE Agents.Through this experience, I leveraged my expertise in data analysis, data management, and financial processes to ensure the accuracy of critical banking data. My contribution ensured the alignment of data with business objectives, regulatory compliance, and improved decision-making processes.

My role at Capgemini India Pvt. Ltd centered around the "Optima Retail Risk Data Warehouse Design" project, a critical initiative involving the creation of a specialized data warehouse. The warehouse was dedicated to housing the consumer risk attributes of retail customers at Citigroup. As part of the Capgemini Financial Services Global Business Unit, I undertook the responsibility of the data warehouse design and technical consultation, collaborating with Citigroup's data architects.Roles and Responsibilities: Pioneered the conceptualization of a logical data model tailor-made for the specific use-case of retail customers' risk attributes. Leveraged tools such as SQL Data Modeler, TOAD, and SQL Developer to meticulously draw Entity-Relationship diagrams in Visio. These visualizations formed the foundation for discussions and fine-tuning with Citigroup's data architects. Played a pivotal role in the execution phase by translating the approved logical model into a robust physical data model, seamlessly integrating it into Citigroup's infrastructure.Tools & Languages:SQL Data Modeler, TOAD, SQL Developer, Visio.This experience allowed me to showcase my prowess in data warehouse design, visualization, and implementation. Working in close collaboration with both technical and business stakeholders, I navigated complex requirements to deliver a data infrastructure that empowered Citigroup's risk assessment strategies for retail customers.

At Alcatel-Lucent, I played a pivotal role in the quality assurance of the MiView TV IPTV product, specializing in the INFOPUSH database testing for set-top boxes. MiView TV, our cutting-edge IPTV solution, required meticulous installation, configuration, and database preparation within set-top boxes to facilitate robust User Acceptance Testing.Roles and Responsibilities: Orchestrated the installation of INFOPUSH databases across a range of testing set-top boxes, ensuring seamless integration and data accuracy. Led the installation of operating systems, primarily Unix and Linux, occasionally Microsoft Windows, to establish a reliable testing environment for MiView TV. Spearheaded the creation of user guides, comprehensively detailing the step-by-step installation and configuration processes. These guides became essential resources for support engineers and field executives in their daily operational activities.Tools & Languages:Oracle Database, Unix/Linux/Windows Operating System Installation, Microsoft WordIn this role, I leveraged my expertise in database testing and operating system installation to contribute to the flawless functioning of MiView TV's set-top boxes. The project not only sharpened my technical acumen but also enabled me to contribute to enhancing the end-user experience of a cutting-edge IPTV product.

I had the privilege of working on the BARTS (Business And Roll Tracking System) project during my tenure at Wipro. BARTS is a sophisticated software solution developed using Oracle Forms/Reports. The system's primary purpose was to efficiently track and manage the orders and inventory of large paper rolls produced at Weyerhaeuser paper mills in Longview, LA, USA.Roles and Responsibilities: Provided essential software support to the dedicated shift workers at the paper mills, ensuring seamless operations and minimal disruptions. Undertook the responsibility of enhancing and maintaining the software solution in alignment with customer requirements, ensuring it met evolving business needs. Offered 24/7 on-call support to address and resolve any technical glitches promptly, contributing to the system's reliability and uptime.Tools & Languages:Oracle Forms/Reports, Oracle DatabasesThis experience demonstrates my hands-on expertise in software support, system enhancement, and round-the-clock technical assistance. It allowed me to collaborate effectively with a cross-functional team, hone my problem-solving skills, and deliver consistent solutions in a dynamic operational environment.