Overall Summary

Eleven years experience in the IT industry. Strong database programming skills using Oracle PL/SQL, SQL, Forms and Reports with Oracle database as the backend. Have exposure to Project Management, System Analysis, and Application Software Development. Currently managing product development, and testing projects. Well versed with the full life cycle of Development of software products from requirement analysis to system study, designing, coding, testing & documentation. Excellent communications and interpersonal skills with demonstrated abilities in training & team building activities.

Onsite work exposure of about four years, of which three years in Leeds (UK) and Liverpool (UK) and short business trips to New Jersey and Philadelphia. Three months short term assignment in US (NJ). Currently possess business visa for US (10 years) and possess H1B visa

Key Technical skills

• Certification Completed OCA (developer track) with 96%
• Databases Oracle 7.3, Oracle 8.0/8i, Oracle 9i and 10g, Oracle Web Applications
• Front-ends Developer 2000 (Forms 4.5, Forms 6i , Forms 9i & Reports 4.5), Forms 10g, Cognos Impromptu and Powerplay (less experience), Uniface 7.1.2, Pro*C

• 4GL’s SQL*PLUS, PL/SQL
• Platforms Dos, Unix, Windows
• Tools TOAD, PL/SQL Developer
• Config. Management Visual Source Safe, PVCS, Starteam, MKS
• Working knowledge C, Java, C++, VC++, Power Builder 5.0, Visual Basic 5.0, ASP, HTML

Key Soft skills

• Experience of Client facing role on all the projects.
• Undertaken Client training and mentoring responsibilities.
• Responsible for deployment at Indian client locations.
• Good interpersonal and communication skills.

Awards Received

• Sapphire Award (2008): This is one of GEM awards given out for outstanding performance by SUNGARD.
• Best Performer (2006): Impelsys has awarded me the Best Performer award for the year as recognition for my efforts for meeting the project deadlines and various factors that contributed to the huge success of the project.
• Letter Of Appreciation: Lynx Financial Systems (Leeds, UK). This was awarded to me for my Initiative efforts that considerably reduced the overheads and improved the overall performance, which made the project a huge success.
• Flock Of Geese (2004): Mastek India Ltd. (For best performance in year 2004). This was awarded in recognition of my innovative efforts due to which this project was successfully implemented with minimal defects and for maintaining an outstanding performance throughout the year.

Education

• MBA (Information Technology)
• Diploma in Advanced Computing
• Diploma in Computer Programming
• B.Sc.

PROJECTS

Project: Banner Unified Digital Campus Duration: Nov 2006 till date
Company: Confidential Role: Team Lead
Technologies: Oracle 11g, Developer 2000 Forms 10g, Reports 10g and Pro*C/Unix
Banner® Unified Digital Campus is the world’s most widely used collegiate administrative suite of student, financial aid, finance, human resources, and advancement systems. It is a tightly integrated suite of proven, scalable, enterprise-wide applications on a single database, designed to support institutions of all sizes and types. Banner runs on the Oracle RDBMS.
Banner UDC works seamlessly with portal, content management, performance reporting and analytics, and other solutions to enable you to build your institution’s unique vision of a unified digital campus. More than 900 institutions worldwide rely on the Banner Unified Digital Campus to help them achieve measurable improvements in performance.
Responsibilities :

• Leading Banner General, BDMS and Banner FinAid technical team of 13 people.
• Communicate with the US teams, allocation of work and status reporting within the offshore teams.
• Ensuring the quality of all deliverables
• One point of contact for the US teams.
• Worked extensively on fixing defects and SR’s on Banner General code base.
• Worked on Banner-Luminis bridging defects (i.e. Banner Channels).
• Point of contact for the Luminis team whenever they face issues regarding Banner General-Luminis integration.
• Acting as an individual contributor in one of the 3 teams executing coding / reviews / testing / analysis.
• Scrum Master of the team- followingAgile software development methodologies

Project: Pearson Production Manager System Duration: Jan 2005 to Nov 2006
Company: ConfidentialRole: Project Manager
Technologies: Oracle 9i, Developer 2000 Forms 9i and Reports 9i
Production Manager is a part of the Author2reader suite developed by Vista, a UK based company specializing in application software for Publishing industry. Production Manager provides consistent, web-accessible and highly personalized interface for managing publishing projects. Author2reader is a unique applications framework from VISTA that is designed to accommodate a comprehensive set of publishing solutions and the associated information required to provide publishers with continued competitive advantage in the 21st century.

Responsibilities:

• System study, Analysis, Database and screen changes,
• Implementation
• Project status reporting to PM and Client,
• Handle deliveries and client Interactions.

Project involved developing the product from scratch for one of the Vista’s client – Pearson, based in USA. The product provides features like product definition, cost calculation, product milestones and schedules, Purchase, Inventory as well as Forecasting functions. The product is also interfaced to the existing SAP application at Pearson.

Project: Confidential ERP Implementation Duration May 2004 to Jan 2005
Company: Confidential Role : Technical Associate
Technologies: Oracle 8i, Developer 2000 Forms 6i and Reports 6i
Responsibilities:

• System study,
• Analysis,
• Database and screen changes,
• Implementation,
• Project status reporting to PM and Client.

Confidential has two divisions i.e. Chemical and Engineering. This package was developed about 2 years ago for the chemical division. They wanted to implement the same system with some changes at the engineering division. There are 10 modules to be implemented. I am part of the 3 member team to study the existing system at the chemical plant, interact with the engineering users to know their existing workflow, analyze to find out the changes required in the old system, completed screen and database changes and implemented the system.
One point of contact for the team and was reporting on weekly basis to the client and project manager about any issues.

Project: CIGNA Duration: Mar’04 to Apr’04
Company:Confidential Role: Programmer Analyst
Technologies: Oracle 8i, Cognos Impromptu

Confidential, International Expatriate Benefits (CIEB) is part of the CIGNA group. CIEB is a leading provider of benefits to employees who work outside their home countries and offices in eight U.S. locations. Built a set of COGNOS reports from the Diamond 950 database (Client database). These reports are built to fulfill the requirements of various functions of the CIEB business viz., Finance & Accounting, Premium Eligibility, Customer Service, Underwriting and Account Management.

Responsibilities:

• Developing complex code
• Program specifications,
• Code reviews,
• Prepare Unit test plan and reviews, specification reviews.

Project: Scottish Prison Services Duration: May’03 to Feb’04
Company: Confidential Role: Programmer Analyst
Technologies: Oracle 9i, Forms 6i, Reports 6i

The system was being developed for the Scottish Prison Service. The Prison Service keeps in safe custody all those who are required by Scottish law to be kept in prison. This system automates the Data capturing during admitting a prisoner and the processing and updating of this data for the duration of his stay in the prison. Records are also maintained for inmates who are on temporary absence or have been released.

System also caters for the following:
Activities: This is used to assign and organize activities across locations. Data is maintained about the prisoner as to which activity is assigned to him and also how well he fares in these activities.

Intelligence: Intelligence groups across locations were maintained to monitor any happenings in the prisons. Information passed is maintained in the system and linked to incidents or searches happened across locations.

Incidents: Data about incidents that have happened across locations is maintained in the system. These incidents could be fights amongst prisoners or some search done and weapons are found.

Medical Records: Medical record is a module wherein prisoners who are believed to be at the risk of harming themselves are monitored. For instance, a prisoner with a history of making threats to injure himself by jumping may be placed in a ground-floor cell. Similarly, the system will record which items a prisoner may not be permitted to have, such as belts, shoelaces or razors, as they may harm themselves with these items.

Finance: This module deals with the finance aspect of the prisoners.
Sources of finance for prisoners include:
Cheques/Cash from the prisoner on admission to prison.
Cashable cheques that prisoners receive from relatives of other third parties while they are in prison.
Wages earned by prisoners, while in prison by participating in a variety of activities (e.g. carpentry, etc.). Newly admitted prisoners with no access to money may be provided with an advance to allow them to purchase goods such as telephone cards and cigarettes.
Responsibilities:
Accountable for functional specification preparation, technical specification preparation, code and code reviews and unit testing.

Project: Criminal Records Bureau Duration Jan’02 to Apr’03
Company: Confidential Role: Software Engineer
Technologies: Oracle 8i, Oracle Web Applications

The CRB system (CRB-Capita Business Services (UK)) was developed for Criminal Records Bureau, an executive agency of Home office, UK. Mastek was one of the several suppliers involved in the project, other suppliers being Oracle Corp., eLoyalty, Logica, I3IT, Cable & Wireless, etc.
The CRB system is a set of business processes designed to provide a Disclosure Certificate to an individual applying for a job in an organisation. This Certificate provides the prospective employer relevant information about the eligibility (as in the applicant has no criminal records) of the applicant to the job applied for. The system is designed and developed with Oracle CRM at its core. The system has secure interfaces with Police National Computer (PNC), Department for Education and Skills (DfES) and Department of Health (DoH). Along with the programmer/analyst role, responsibility included making software releases at client locations.
This was a critical project to Mastek since it dealt with more of secure data and the firm had to compete with other service providers. The time frames set for the releases were strict and penalties were set if delivery dates were not met.

Responsibilities:
Managing impact analysis of CR’s, development of complex code, program specifications, preparation of release scripts and release notes.

Project: Repository Duration: Feb’01 to Nov’01
Company: MASTEK Role: Software Engineer
Technologies: Oracle 8.0, Forms 6.0, D2K

This project for HDFC Ltd., Mumbai, India involved conversion of existing system with character-based forms to a GUI based system. The task dealt with converting old character based forms which used to run batch jobs from within the forms. This module gave the user options to view, mail or print the output files, log files and to view the job commands. The other service providers were TCS, Akshay Software, Princeton and Kumaran Systems.

Responsibilities:
Developing complex code, program specifications, code reviews, unit test plan preparations, UTP and TSPEC reviews.
Working at the client premises and interacting with client for detailed requirements.

Project Consolidation Duration: Dec’00 to Feb’01
Company:Confidential Role: Software Engineer
Technologies: Oracle 8.0, Developer 2000 Forms 6.0

This project for HDFC Ltd., Mumbai, India involved consolidating the data from two different databases into a third one after doing necessary data cleansing. The work also included writing of generic scripts (dynamic SQL) to identify duplicate column values across different databases and reporting them in the form of an SQL plus report, finally to update it to a new value and storing the old value for further usage. The corrected data from the two databases were then copied into the third database.

Responsibilities:
Developing complex code, program specifications, code reviews, unit test plan preparations, UTP and Tspec reviews.

Project: Portfolio Duration: Mar’99 to Oct’00
Company: Confidential Role: Software Engineer
Technologies: Uniface V7.2.5, Oracle 8.0

This project was developed for client Lynx Financial Systems, Leeds (UK). An existing system at Lynx Financial Systems in which new modules was added as part of releases. Role involved being part of the development team and also had support work responsibilities after the system went live. The client for LFS was BMW cars (Germany). The system included modules for stock, credit, and banking. For instance, the Stock module deals with the stock of cars BMW showrooms have in possession.

Responsibilities :
Developing complex code, program specifications, code reviews, unit test plan preparations, UTP and Tspec reviews.
Overseeing the development of CreditFolio, which deals the credit aspect of the system; involving the crediting aspect of a deal i.e. if any loans are given to the customer at the time the customer is buying a car and Banking deals with the managing the money transactions between the dealer, the customer and BMW.

Project: Hospital Management System Duration: Mar’97 to Sep’97
Company: Confidential Role Software Engineer
Technologies Oracle 7.3, Forms 4.5
The package deals with the patient aspect of hospital management and the services rendered to the patient during his stay in the hospital. The package is designed to take care of the admission details of the patient, his prescription and doctor details. It also has the facility to collect and store the pathology details, CT scanner / X-ray details. This package also entertains inquiries by the visitors regarding their patients, the doctors & the services offered by the hospital. Report facility is provided to display the doctor’s fee over a period, ward wise income over a period, income of the lab and OT over a period. Report facility is provided to monitor the patient’s condition during his stay in the hospital.
Responsibilities:
Developing the code, Program Specifications, Unit test plan preparations.

Project: Library Management System Duration: Nov’96 to Mar’97
Company Confidential Role: Software Engineer
Technologies: Oracle 7.3, Forms 4.5

This project was developed for Suvidhya Library, Pune. The features of this system included a menu driven application with subject-wise listing of book names, view-ability of copy details of books, password protection facility.
The system only allows the librarian to insert or update records in the database. It also keeps track of members who break the rules of the library and lists them in a particular table, which helps in collecting damage charges from them. The report facilities of the system include giving a list of issues which have exceeded their due date along with member names and the due charges.
Responsibilities :
Handling the development of code, Program Specifications, Unit test plan preparations.

Project: Hotel Management System Duration: Aug’96 to Nov’96
Company: Confidential Role: Software Engineer
Technologies: Oracle 7.3, Forms 4.5

This system was developed to fully atomize the manual work of the hotel. It also maintained a database of the guest details, for better service and future usage. This system comprised of 3 modules: Room Reservation module, Payroll module, Expenses module. The Room Reservation module dealt with the procedures and the formalities a hotel undergoes when customer makes a room reservation. The reporting facilities of the module included listing of rates of different classes of rooms, the room’s reservation list and the waiting list. The Payroll module dealt with managing the payroll activities of the employees working the hotel. The expenses module dealt with keeping track of the expenditures incurred to the hotel.

Responsibilities :
Accountable for the development of code, program specifications and unit test plan preparations.