CHANDINI PATERSON

 

 

EXPERIENCE SUMMARY

 

12 years experience in IT.  Involved in all phases of Software Development Life Cycle including requirements gathering, analysis and design, development, testing and support. Extensive experience in technical/business analysis, writing technical specifications and stakeholder documents, team leading and core development. Expertise in Oracle (7x, 8x, 9i, 10g), SQL, PL/SQL, Forms (4.5, 6i, 9i, 10g), Reports (2.5, 6i, 9i, 10g), UNIX shell scripting, Java and related technologies, Oracle Applications 11I (AP/GL/AR modules), Oracle CRM, Oracle Workflow.

 

EDUCATION

 

Master  in Computer Application (MCA) from Osmania University with 86% - 1996.

Bachelor of Science (BSC) with Mathematics, Physics and Chemistry from Osmania University with 83% - 1993.

 

CERTIFICATIONS

• PMI Certified PMP
• Oracle Certified PLSQL Developer Associate (OCA).  
• SUN Certified Programmer for the Java 2 Platform.

 

MEMBERSHIPS

PMI

 

SKILLS

Operating            

Systems                 MS DOS

                                Unix

                                Windows 95/97/NT/2000/XP                                                                                          

 

Software               Oracle (7x, 8x, 9i, 10g)

                                PL/ SQL

                                SQL

                                SQL Plus                                                                                               

                                Oracle Forms (4x, 6i, 9i, 10g)                                                                                           

                                Oracle Reports (2x, 6i, 9i, 10g)                                                                                         

                                PRO*C

                              Oracle Apps 11i (AP/AR/GL modules)

                            Java (core Java, JSP/Servlets, JavaBeans, Junit, Swing etc)

                            Oracle Workflow 2.6

                            Oracle CRM 11i

                                SQL*Loader                                                                                        

                                PowerBuilder 4.0                                                                

                                PERL

                                VBA

                                SQL Navigator/Toad

                             Eclipse

                             CVS/PVCS

                                UNIX shell scripting

 

Exposure to:        Oracle Database Administration

C/C++

Oracle*Financials 10.7

PowerBuilder 5.0

Visual Basic

 

TRAINING ATTENDED

 

*PMP Certification Course

*Oracle 9iAS Administration with Oracle Corp.

*Certificate course in Oracle 8I DBA.  Modules included Database Architecture, Backup and Recovery, Tuning and Network Administration – August 2001

*Certificate course in Oracle 7.1 with Developer 2000 from SQL Star People International Ltd., authorized training centre in Hyderabad. - 1995.

*C ++ from VJ Infosystems International Ltd. - 1996.

 

 

PROFESSIONAL EXPERIENCE

 

May 2007 – April 2008                      (MCPS-PRS Alliance Ltd)

 

Project                                  Distribution & Maintenance (D&M)

Client                                     MCPS-PRS (Mechanical Copyright Protection Society – Performing Rights

                                                Society) Alliance

Software                               Oracle 9i/10g, SQL, PLSQL, Forms 9i, Reports 9i, TOAD

Operating System              Windows

 

Brief Project Profile: The MCPS-PRS Alliance is the UK’s not-for-profit royalty collecting society. It exists to collect and pay royalties to its members when their music is recorded and made available to the public (MCPS) and when their music is performed, broadcast or otherwise made publicly available (PRS).

Their members include writers, composers and publishers.

The Distribution and Membership (D&M) system holds details of all Performing Rights members and distributes the monies that the society collects on their behalf.  The system is mainly financial with a high level of accuracy.

The Alliance recently signed the Pan-European License (PEL) to represent members for online and mobile licensing across Europe.  This has meant enhancements to the D&M system so it can process digital royalties in addition to the non-digital royalties. 

 

Role: Senior Analyst/Developer – Contractor

• Involved in the analysis, design, development and testing of the PEL extensions to D&M, particularly in the area of invoice deductions and distributions.
• Involved in data mapping, data modeling, writing up technical specifications and testing documents.
• Enhancements to the Distribution History screen which forms the backbone of the D&M system
• Creation of new screens and reports as well as enhancements/updates to the existing screens/reports for PEL
• Responsible for the design and refactoring of the underlying forms of the D&M system to conform to best practices.

 

 

November 2005 – May 2007            (Exchange Systems Technology)

 

Project                                  Eclipse and Eclipse Metals

Client                                     In-house development

Software                               Oracle 8i/9i/10g, SQL, PL/SQL, UNIX Shell scripts, Forms (4.5/6i/9i),

Reports (6i/9i), PRO*C, C, SCCS

Operating System              UNIX

 

Brief Project Profile:

Eclipse is a back-office clearing and settlements system, which can be used to provide accounting and administrative control for a wide variety of different product types traded in today's global marketplace. Current clients using Eclipse include SEB, Banca Caboto, Insinger, Schneider, Calyon etc.

Eclipse Metals is a complete front to back metals clearing and settlement system already in use by Category One and Category Two members of the London Metal Exchange.

 

Role: Senior Technical Consultant

·         Work on the Eclipse Metals application.  This is a new application that EST has created for the London Metals Exchange (LME) clients.  Within this project, I was tasked with creating the various screens and reports specifically for the currently clients TTM, writing up technical specifications, technical analysis of requirements, mentoring/managing junior developers etc. 

·         Working on change requests from existing clients, including SEB and Calyon.

·         In-charge of the new development for client Banca Caboto.  Developed all client-specific forms/reports.

·         Upgrading the eclipse application from character-based to GUI.  Changes to the screens and reports (written in Pro*C)

·         Re-wrote the TimeSheet Application for use within EST to capture employee time. This was written using Oracle Forms 9i for the data entry screen, Reports 9i for the various reports and an Oracle database.

 

Mid-December 2004 – October 2005 – Maternity Leave

 

August 2002 – December 2004     (Morse Business Applications)

 

Project                                  SLAB A & A (Advice and Assistance) System

Client                                     Scottish Legal Aid Board

Software                               Oracle 8i, SQL, PL/SQL, UNIX Shell scripts, Oracle Workflow, Oracle

Applications 11i, Oracle Portal, Oracle CRM, Java, J2EE, JSP/Servlets,

CVS

Operating System              UNIX, Windows 2000/NT

 

Brief Project profile:

The A&A system provides a solicitor with a single point of application online, wherein they can submit an application for legal aid.  There are three parts to the A&A system – Applications, Increases and Accounts.  The registration process for advice and assistance that a solicitor first makes to SLAB is called an Application.  If the initial approved limit on an application is insufficient, then a solicitor can submit one or more Increases, to ask for additional money for work done.  The actual payment to the solicitor is done through Accounts.  The A&A system was written in Java with an Oracle database as the backend.  In addition, there also exist interactions between the Java application and Oracle Workflow as well as the Java application and Oracle CRM.

 

Role: Senior Technical Consultant

I was involved from the beginning right through to completion of this project.  This project had a two-month requirements gathering phase which I did as part of a two-person team.  I then joined the Java team in Derby to work on the front-end portal application. I was also involved in the data analysis and creation of CRUD matrix for the team. I then moved on to the Oracle side of things, where I was given the task of creating the Oracle Workflow diagrams which form the backbone of this project, along with the underlying PL/SQL stored procedures.  And also, creating the various interactions needed between Java and Workflow and Workflow and Oracle CRM. I was also the principal liaison between the Derby (Java) and Edinburgh (Oracle) teams.

 

 

March 2002 to April 2002               (Morse Business Applications)

 

Project                                  OASSIS 11I Upgrade

Client                                     Alliance & Leicester

Software                               Oracle Applications 11I, Oracle 8I, SQL, Forms 6I, Reports 6I, PL/SQL

Operating System              UNIX, Windows NT

 

Brief Project profile:

The aim of the OASSIS 11I Upgrade project is to migrate the OASSIS (Oracle Applications Shared Services Integrated System) software from the current release (10.7) to 11i. This entails upgrading the Oracle database software to Release 8I, and the Oracle Applications software to 11i.

 

Role: - Technical Consultant

I was involved with the upgrade of the GL and AR modules.  This involved upgrading the forms and reports to version 6i.  Recompiling all packages and other stored procedures in version 8I of the database.  Ensuring that all code referring to database objects that were dropped in version 11I, were suitably altered to use the new objects created.  Creating test plans, change documents and other required documentation. Unit testing all changes made to forms and reports.  

 

 

 

January 2001 to February 2002    (Morse Business Applications)

& May 2002 to July 2002               

 

·         Worked on a proof of concept – demo application for the CQD (Central Qualifications Database) project.  Using Java technologies, Oracle 8I and Reports 6i.

·         Helping out the Morse Derby Team upgrade the INFORM application for Co-op from an ASP/Access application to one using Oracle 8I, Java and Reports 6i.  Involved in skill transfer.  Teaching the team how to use Reports 6i.  Also, involved in the creation of the reports and several materialized views to form the basis of the reports.  And a lot of SQL tuning.

·         Work done for clients Cox Insurance Services Ltd.  Helping them add new functionality to the Polaris application.  This work done in Oracle 8I, Forms 6I, SQL, and PL/SQL.

·         Work for clients Kongsberg Simrad, Aberdeen.  Helping with the upgrade of their existing Hiremaster application from Forms 4.5 and Reports 2.5 to the Forms/Reports 6I version.  Also, help with re-writing some of the application code for functionality that was missing/required.

·         Responsible for Morse internal databases.  Ensuring databases are up and running, back ups are running fine, space utilization etc. Also, database backup and recovery, storage maintenance, database refreshes, tuning etc.

·         Helping with support work for existing clients

·         Taking internal training courses for consultants in MBA

 

 

November 2000 to December 2000               (Morse Business Applications)

 

Project                                  SolusCard

Client                                     Internet Securities

Software                               Oracle 8I, Forms 6I, Reports 6I, Oracle CRM 11I, Oracle XML

Operating System              UNIX, Windows 2000

 

Brief Project profile:

Internet Security is about to launch a revolutionary product for customers of e-Businesses. This product, SolusCard, will enable secure transactions over the Internet, thus addressing one of the major issues of the growing eCommerce sector. 

One of the key business support areas will be the management of the customer base at all stages of the consumer lifecycle from application, through registration, card initialisation, issuance and ongoing contact management, to termination.

A further business support area is that of inventory.

The scope of the project includes the following

·         A customer relationship management system which allows agent scripting

·         An Inventory system which allows receipt and issue of a single stock item

·         Customisation of Oracle forms

·         Integration between Oracle Telesales and Scripting module and Oracle Sales Order module.

·         Integration with Oracle Sales Order module and bar code readers.

·         Integration between Oracle Telesales and Data Vault system for solus card activation.

·         Integration between Oracle Sales Orders and Data vault system for solus card authentication

 

Role: - Technical Consultant

Within the project, I was involved in the CRM part of things.  This was implemented using Oracle CRM 11i. I was involved in the initial analysis and design of the system, as well as in the creation of a prototype CRM system using Forms 6I and Reports 6I as the front-end and Oracle 8I as the back-end.  And in the customization of the forms used within the CRM module.

 

 

 

   

June 2000 to November 2000         (CMG UK Ltd.)

 

Project                                  ASG - Design Authority (Calanais)

Client                                     Scottish Power

Software                               Oracle 7.3, SQL, PL/SQL, Developer/2000, Forms 4.5, Reports 2.5, TOAD,

                                                PERL, VBA, Reflection Basic, UNIX shell scripts,  FTP etc

Operating System              Windows 95, Sun Solaris 2.5.1

 

Brief Project profile:

     The Design Authority provides a central source of information on the Change 1998 systems and provides a support function of industry knowledge for help with decision making or resolution to any issues which ScottishPower business may have. The Design Authority represents ScottishPower at a number of Industry forums which ensures ScottishPower's views are heard and is an active participant in the decisions made which will impact the industry.

 

Role: Business Consultant

Within the ASG - DA team, I was involved as a technical analyst.  My major tasks were MDD (Market Domain Data) maintenance, distribution of Change Management Circulars to various systems and collating their responses back to the POOL (or ELEXON), working on the ACS (ASG Change System) tool to extend its capabilities, automating various tasks involved in Market Domain Data publication, point of contact within the DA for all queries relating to MDD etc. 

In addition, working closely with the other Business Analysts on Impact Assessments for the AMS system and helping them gain a better understanding of the working of AMS, working on compliance matrix, validating change requests etc.

 

 

June 1999 to mid-June 2000           (CMG UK Ltd.)

 

Project                                  AMS (Agent Management System)

Client                                     Scottish Power

Software                               Oracle 7.3, SQL, PL/SQL, Developer/2000, Forms 4.5, Reports 2.5, TOAD,

                                                PVCS

Operating System              Windows 95, Sun Solaris 2.5.1

 

Brief Project Profile:

    The Agent Management System is a bespoke application developed for Scottish Power by CMG UK Ltd. The business requirement for this application has resulted from the 1998 market de-regulation enabling the use of independent external agents for registration activities such as meter reading, data aggregation, data collection etc. The Agent Management System processes incoming and outgoing data flows providing interfaces between external agents and internal Scottish Power business systems.

   AMS provides registration information to various internal Scottish Power systems via eight separate interfaces.  All of the interfaces involve the transference of DTC-compliant flat files with the exception of SIM and Billing, which in addition, include customized bundling of data.   After the data files have been processed, they are picked up by Information Exchange and moved to the same data entry area as non-pre-processed data files.  A UNIX batch process runs on a fixed time interval to pick up new data files from the data file entry area.  These files are processed, AMS database updated and output flows are scheduled/transmitted as appropriate.   Interface into AMS is achieved via the Business Support Interface that provides a variety of Forms and Reports for various user business functions.

 

Role: - Consultant

Involved in the Development as well as Support of existing system.  The role involved a lot of
Technical Analysis, Live Coordination and high priority, mission critical Development activities.  The major development work was done in SQL and PL/SQL (including procedures, functions and packages), UNIX and Developer/2000 (Forms 4.5).  This was in addition to support work on the existing system, including on-call support.  Further also involved in Impact assessments and Technical Analysis of change requests. I was promoted as the Assistant DBA on the project. 

In addition, I was also involved with other activities at CMG.  Including Chairing Staff meetings, Publishing articles on the company Intranet, giving presentations at team meetings etc.

 

 

February 1998~January 1999       (Alberg Ltd.)

 

Project                                  PuMA (Purchasing, Maintenance  & Accounting)

Client                                     BP OIL Group, UK

Software                               Oracle 7.3, SQL, SQL*Loader, PL/SQL, SQL Navigator, SQL*PLUS,

                                                MAXIMO, Oracle Financials 10.6

Operating System              Windows’95, UNIX

 

 

Brief Project Profile:

    The PuMA project has been conceived to encompass large-scale purchasing and materials management capabilities as well as planning and scheduling. PuMA has 2 major components - MAXIMO and ISPA.

    Maximo is an off-the-shelf product developed by PSDI, particularly for the Oil and Gas industries. It has been the ideal choice for the integrated piece of software required by the BP OIL UK Limited, since it offers the ability to customize, not just screens, but entire applications to your specific needs. It is an asset maintenance system that is easy to use, direct and non-intimidating to the novice, yet robust enough to satisfy the demands of experienced users. Additionally, it can interface easily with established and sophisticated financial systems to provide accurate, current information immediately throughout the system. It has an additional facility to provide documentation to meet current regulatory requirements and anticipate future mandates. The Maximo application is comprised of 8 Modules. Purchasing and Location & Equipment are the major modules.

   ISPA is a customized version of Oracle*Financials created by BP.  It includes 2 modules of Oracle*Financials, General Ledger and Application Payables. Though Maximo is a complex product, it does take care of the financial aspect of things such as creating cheques, payments, value depreciation etc.  These activities are taken care of by ISPA.  Information needed by ISPA with respect to General Ledgers and Application Payables are sent in from Maximo at regular intervals.

 

Role       : Analyst/Programmer

On the Maximo side of things, I was involved in the integration of several individual databases that were initially used, into a single database - MAXIMO- on the Oracle RDBMS. Moving data from the existing legacy system into the current Information System based on Oracle. Data Analysis, Data Mapping, Data Migration, Creation of stored procedures, database triggers, SQL scripts.  In addition, use of SQL *Loader to support the load.

On the ISPA side, I was the sole technical member and was responsible for the data migration into Financials. This included creating scripts that would generate the flat files containing data needed by ISPA from MAXIMO in a pre-defined format.  In addition, UNIX shell scripts that would automate the tasks and FTP the information across servers was also written as well as Loader scripts that would load the flat files into the corresponding Interface tables in ISPA.  Also, writing a lot of PL/SQL code including triggers, procedures/functions and packages etc.

 

 

December 1995 – January 1998                   

 

Company Name                                 Alberg Ltd., India

Position in Company                         Analyst/Programmer

Work Description                             

- Joined the company as a programmer and moved on to an Analyst/programmer role.
- Worked on various projects for clients uusing predominantly Oracle, SQL Plus, SQL, PLSQL, Developer 2000, Forms 4.5, Reports 2.5
- Also involved in training activities