My CV
My CV
Information Management Consultant at Tata Consultancy Services with full software development lifecycle experience gained in large financial, telecommunications, manufacturing and government organisations. Strong expertise in MDM (products and consulting), development and testing. Good mentoring skills of onshore and offshore resources. A self-motivated, hardworking individual with the ability to learn and apply new technologies very quickly. A strong team player with excellent communication skills.
English (fluent), German (native), Hindi (native), Punjabi (native)
As an Information Management Consultant I work on Information Management related projects such as MDM, Data Quality, Data Governance, Data Integration etc. It is a very client facing role with stakeholder management at various levels. I am also challenged to find new opportunities to either grow the IM practice at the company or the client account I am engaged with. Overall, the role involves a mix of strong technical and consulting skills.
On this engagement I was working as an Application Support Specialist on the MDM implementation for Product Information Management (PIM) using Oracle APC/PIM 12.1.3. The client had several data source systems with various types of data issues. The aim was to build a single data hub to serve as a "single version of the truth" about product data. I was responsible for providing tier 2 and 3 application support for the Oracle PIM 12.1.3 based PIM application. I consulted the client on best approaches and solutions on technical issues. I monitored and solved requests from the client and other vendors. I created by myself and shared with other team members several knowledge articles about Oracle PIM and mentored team members. The client and other vendors noticed how quickly I had been able to learn about Oracle PIM, therefore I had established myself as one of the primary contacts for any critical issues or when quick resolutions were required. One of the major achievements on this project was that I fixed a critical data import issue which none of the other 15 team members from Accenture, LogicaCMG, Nokia, Sogeti and Oracle could fix, although it was Oracle's product. The issue had been outstanding for over two months and impacted major milestones of the project. My contribution was much appreciated by the client and the other vendors. As the client had some concerns about the capabilities of the team and company, I significantly grew the client's confidence levels in both aspects successfully to a very large extent by myself.
In my previous position I have been working with TIBCO CIM, GI, Gems, BE, BW, Designer and Spotfire Miner to implement MDM and complex events processing solutions. After I joined the company I helped configure CIM – TIBCO's MDM software – for a client in Switzerland. Afterwards I have worked on two CIM and GI projects for Vodafone. GI is a difficult IDE to implement applications in and therefore only a few people in the company are competent using it. I have been able to learn GI within about 3 weeks. It allows users to build SOA applications very quickly using (Object-oriented) JavaScript, XML, Xpath, XSLT, SOAP and WSDL.
This was an existing, large GI application developed for Vodafone to manage orders which was going to be used for a PoC as part of the pre-sales. I learnt about GI in a very short period of time and resolved several, complex defects within a very tight deadline. After a few weeks, another consultant joined the project. As he did not know about GI, I taught him everything he needed to know in order to be able to resolve the defects. During the project I used (Object-oriented) JavaScript, XML, XSLT, XPath, SOAP and WSDL for programming and GI, CIM, BW, BE (Business Engine) and iPC (iProcess Controller) as the applications.
Vodafone had a MS Access database storing data about its products, channels, managers etc. However, they did not understand their data and hence decided for a MDM solution using CIM. CIM out of the box did not fully meet the client's requirements, hence it was my task to design (front-end and back-end), build and integrate a GI application with CIM to meet their requirements such as mass updates on catalogue data and inbox data, mass approvals by data managers, searching and sorting data etc. I also had to configure CIM to handle workflows, validations and build the meta data model. I used JavaScript, XML, XSLT, XPath, SOAP, WSDL and a two APIs – GI's API and a custom application's GI – so that the GI application could communicate with CIM through web service calls. In addition, I designed and developed both the front-end and back-end of the application. I created the entire user interface myself without any guidelines or draft designs from the client and when it was shown to the client for the first time they were very pleased with it. I felt very good, as it had been my first project and knew almost nothing about how to create interfaces in GI. During the development I had numerous requirements-related questions which meant that I uncovered over 90% of requirements that the Senior Consultant missed out. Some weeks later, a contractor from the Czech Republic joined the project. He was working remotely and it was my responsibility to lead him by allocating tasks to him, tracking progress, providing guidance, answer any questions, code reviews and corrections etc. As I have lead and worked with people remotely in the past, this proved no obstacle to me and we were making steady progress.
I received an introduction to TIBCO BE, BW and Designer to build a fraud detection system to be used by Telco organisations. The application created user profiles and based on events coming into the system, fraud was detected in real-time based on certain criteria which alerted the user.
As a Senior IT Consultant for Initiate Systems I participated in the architecture and design, data and requirements analysis, data transformation, software configuration, testing and production rollout phases of MDM solutions for financial, government and healthcare clients throughout the EMEA region.
As a Functional Tester I tested for defects the Local Child Hub used as part of the Child Protection system. I produced test documents, wrote test cases, executed these and established a methodical way of communicating defects and tracking progress which impressed the project manager. To verify test results I used SQL to query the MS SQL Server database. I also took an active part in the defects management by communicating defects to the developer and tracking progress. I also configured and deployed the production MDM system for the Linux/Oracle and Windows/SQL Server platform which was used by the development team and the client. I also created a Shell Script to manage the complex installation of the application on the Linux platform. The project manager and other senior team members were looking for a solution to speed up testing, but they were unsuccessful. I found a solution and implemented a small Java application which saved approximately 1.5 hours each day. I also extended and amended technical documents which were later passed on to the client. Occasionally, I represented the company by working on client site by myself and supporting the client with anything they were unsure about. Before rolling off the project I gave knowledge transfers to the client and developers about configuring, installing, using and testing the system. My role on this project improved the quality of the application considerably by discovering a large number of defects and my contribution was highly valued by the project manager.
As a MDM Consultant I configured and developed the sandpit MDM system for the Merseyside Police using a PoC document from the pre-sales. The solution helped to link data and match this to a certain person who may be using different identities to commit fraud or crime. As part of this project I built the meta data model, liaised with the client, built data algorithms and standardised data using the CloverETL framework, XML, XPath and Java. I also developed a Java-based solution using CloverETL to handle Delta updates. This implementation option was never attempted by anyone in the company before including experienced team members senior than me. This impressed all team members and they learnt from me a new implementation technique. As part of the data algorithms refinement, I analysed how well the data was extracted from the data sources, how it was stored in the database hub and ran various SQL queries on the MS SQL Server database.
I configured and developed the sandpit MDM system for the investment bank StanLib using a PoC document from the pre-sales. The prime aim was to be able to identify and create relationships between brokers, investors, organisations and holdings. I created an automated test cases generator using Java, JDOM, XPath and XML. This utility produced dummy test data in XML format for all entities and the data was saved into a XML file and loaded into the hub using CloverETL. The project manager liked my automated test cases generator so much that he suggested to use my application for future projects across the whole organisation. The benefit is that Initiate would get a head start before the "real" implementation starts, sandpits can be developed quicker and data algorithms will be more accurate in less iterations saving project cost and time which could potentially make the company more competitive during tendering stages.
In my spare time I have taught a number of students online and face-to-face about databases; SQL; Java; website requirements analysis, design, development (HTML/XHTML, CSS, XML, XPath, XSL-FO, XSLT, XSL) and testing; MS Office (Word, Excel, Access). I always received very positive feedback from students and some even commented that my teaching style makes it very easy to understand things. I also offered website and database development to SMEs. I developed websites using HTML/XHTML, CSS and XML. Based on the quality of my work, clients also came back to me for further work and passed on my details to others.
My first role with Accenture was to work as a Java developer for BT's internal systems integration. In this role I provided application development support to senior developers by designing, developing and testing Java components with Hibernate and Spring which were then integrated into the system. I used JUnit for the Test-Driven Development approach of the project as I was developing several components.
As a Functional Designer for Lloyds TSB's home insurance application I produced detailed Page Design Documents as part of the functional requirements gathering process and used MS Visio to create screen designs. After the completion of the functional design, I moved on to the technical design stage. I produced extensive technical design documents with UML diagrams (sequence, class, page transition etc diagrams and Java pseudocode). I used IBM Rational Rose to produce all the UML diagrams. Both phases of the development followed a RUP approach. During the project I also mentored technical designers from onshore and offshore on several aspects such as how to document the functional and technical requirements and how to produce UML diagrams using IBM Rational Rose. As some of the technical designers were from India, I sometimes explained concepts to them in Hindi which made it easier for them to understand them.
I worked as an Application Developer and Tester (unit and component testing) at Visa on their Clearing and Settlement system. Initially, I was responsible for component testing nearly 15,000 Fees and Charges business rules of all European countries using JRules and the test data was stored in spreadsheets. I was given 3 months to complete the task, but completed all tests in less than 7 weeks. I was given 6 weeks to learn about JRules and the business process. However, I was able to do this in just 3 weeks which pleased the team leader. I established myself as an asset to the team very quickly, therefore I was moved into the Business Rules Defects Fixing team after I had completed the component testing and gave knowledge transfers about component testing to the client. As part of the project, I wrote some Bash Shell Scripts on the Linux platform to automate repetitive tasks. After a few months whilst fixing defects related to fees and charges using Java, Struts and JRules in Eclipse, I got a better understanding about Struts, JRules such as creating and modifying business rules, the Clearing and Settlement process etc. During the defects fixing process I worked with the Testing, Business Analyst and Development team. I used JUnit for the Test-Driven Development approach in order to test new and amended rules. This role provided me with useful experience about OOD, Payments, Clearing, Settlement, the defects fixing process and allowed me to experience the Agile development methodology.
My last project was with the HMRC as a Functional Test Analyst to carry out integration and system testing on the CAW (Corporate Audit Warehouse) application. I prepared and executed test scripts for CAW, raised and followed up defects using ClearQuest, carried out test planning, managed the test environment, wrote test documentation, tracked testing progress and liaised with different teams and the client on a daily basis. I also used Unix to configure CAW using the latest builds and to interact with remote systems. I also enhanced the existing Bash Shell Script for getting the latest builds. This automated some of the repetitive input required during the process. Using SQL I queried and modified data in the Sybase database as part of my test cases. I also developed a Java tool in Eclipse which read data from test files, modified test cases and provided automated test progress information. This helped the project to save about 2 hours every day. My attention to detail helped to discover around 150 defects which had been overlooked by around 30 system testers and 40 developers. I was taken on this project to do only integration testing. However, because of the defects overlooked by the system testers I was asked to carry out system testing for all the components. Working hard and working additional hours helped me to achieve the best possible pass rate before my roll-off date. In this role I established myself as an expert on CAW within a few weeks and was responsible for mentoring several people from different teams about CAW, testing strategy and planning, Unix and SQL. As part of the project, I also learnt about the basics of Selenium but did not use it because of feasibility issues.
Having worked for Accenture has provided me with great experience in dealing with people of different cultures, levels and types such as offshore teams, management, contractors and clients. Furthermore, I gained experience about large, global IT systems and a wide range of technologies.
I improved and added new functionality to the financial application used by mortgage providers and retail banks such as GE Money. I analysed the requirements, designed, coded and tested programs within the system to agreed standards, provided specifications and general assistance within the department. I made suggestions on how the system could be improved to enhance usability and avoid poor coding. The programmers, manager and directors found my recommendations very useful. My suggestions were implemented after a couple of days, therefore improved the system's usability.
I taught Java and OOD to 12 first–year Computer Science students. During vivas with the students I marked their exercises and provided feedback. I also marked the module's exams. I taught relevant material outside the syllabus which the students found helpful in completing their weekly coursework. In a second module for the same degree and year of study, I was a project manager leading 5 groups each consisting of 5 students. Each group was developing a multimedia project. I was responsible to ensure that the students were making constant progress and to provide them with feedback. I reported progress information and attendance levels to the lecturer during meetings. Out of 12 other groups, one of my groups received the highest project marks.
Result: Merit
Result: 2:1
During my summer placement at the university, I developed a document conversion tool for the coursework submission system. The tool converted XML files into PDFs using Apache FOP, XSL-FO, XSL and XML. I was given 5 weeks to complete the work, but I completed it within two weeks.
Consulting Fundamentals
TIBCO BusinessEvents Integration
Administration of TIBCO BusinessEvents Solutions
Essentials of Master Data Management with TIBCO Collaborative Information Manager 7.x
Initiate MDM software including CloverETL
Sun Web Component Development with Servlets, JSP Technologies and Struts
Core Spring Intensive course provided by a developer of the Spring framework
Application Components – Detailed Design, Software Testing
You can also find me on LinkedIn. Click on the badge below to be redirected to my profile.
