Kavitha Mohan

Mobile : 571-***-****

ad3xb8@r.postjobfree.com

SUMMARY

7+ years of experience in SQL, PL SQL, QIK Scripting and VB Scripting.

Good working knowledge in SQL Server Database design, maintenance and developing T-SQL queries and stored procedures.

Strong functional domain experience includes Retail and Airlines.

Strong communication skills, excellent analytical and logical skills with the ability to perform in challenging work environments.

Actively participated in process improvement meetings and contributed effectively on defect preventive measures.

TECHNOLOGY COMPETENCIES

Technologies : SQL, PL/SQL, Excel Macros

Data Reporting : Power BI

Scripting Languages : VB Script, QIK Scripting

RDBMS : SQL Server, Oracle 9i

Version Control : Visual SourceSafe

CERTIFICATIONS & KEY ACHEIVEMENTS

Oracle Certified Programmer (OCP)

Received Client Appreciation Award for Best Performance in QANTAS Airways.

Received STAR OF THE QUARTER Award in TATA CONSULTANCY SERVICES Ltd for Best Team Lead.

Brain bench Certification on Project Management – E0 Level

EDUCATION

Bachelor of Technology in Electronics and Communication, VIT University, India

KEY ENGAGEMENTS

Project Name : QIK Reservation

Client Name : QANTAS Airways

Company Name : TATA Consultancy Services Ltd.

Duration : Nov 2007 – Apr-2013

Role : Technical Lead

Platform : QIK Scripting, SQL Server

QANTAS is one of the leading long-distance airlines in the world and one of the strongest

brands in Australia. This project deals with the modules like reservation including

loyalty, ticketing, flight operations, catering, crew management and customer enablement

AQIRE is the front-end application that interfaces to the Amadeus Reservations System. It

allows complex host transactions to be performed using a simple and intuitive Graphical

User Interface (GUI) using QIK 2.0. QIK formats and sends entries to Amadeus and displays

the Amadeus response in one of the AQIRE windows. AQIRE requests information from the

consultant via input fields in popups and strings popups together in sequence to provide

work flows. This is used by QANTAS Travel centers' consultants. This provides various

workflows to facilitate consultants to make bookings, exchange and refund bookings.

Main Responsibilities

Involved in creating new reservation modules to the existing booking flow. Any Seat Redemption workflow and introduction of Premium Economy class workflow are the key projects to mention.

Involved in POC to combine the online and offline booking systems by consuming the data from a webservice instead of individual databases.

Involved in accessing the webservice using SAOP UI and consuming the XML to process the booking.

Involved in creating database to store QIK Keypad information to validate the workflow.

Involved in understanding the reservation business and providing time/cost efficient solutions to the agents using the application.

Actively involved in the change management procedures and deploying the code using VSS.

Involved in handling the team at offshore and coordinating with the onsite team and client.

Involved in interacting with client and understanding the requirements and preparing Functional and Design documents.

Project Name : STAR Services

Client Name : Best Buy

Company Name : Tata Consultancy Services Ltd

Duration : Aug 2006 – Nov 2007

Role : Team Member

Platform : VB Script, SQL Server

STAR is the services application used by BEST BUY for the products that are being serviced. Once a product is brought in for service, the details are entered in the STAR application by the service agent. The Service manager assigns the Service ticket to agent and all the updates happening with respect to the service are being tracked through this application. The application also provides options to place vendor order in case the parts is not available for repair. Geek Squad team was introduced exclusively for laptop repairs and changes were made to the STAR application to cater the new service team.

Main Responsibilities

Involved in new changes/enhancements in the STAR application.

Involved in making changes for the Geek Squad laptop service.

Involved in Onsite-Offshore Coordination, creating test plans and change management procedures.

Involved in handling Sev1/2/3 tickets pertaining to the application.

Project Name : MQ

Client Name : Best Buy

Company Name : Tata Consultancy Services Ltd

Duration : Aug 2005 – Aug 2006

Role : Team Member

Platform : IBM WebSphere MQ

Best BUY uses IBM WebSphere MQ for the integration of the applications Messages are placed on queues, so that applications can run independently of each other, without having a direct connection between them. All the pricing details and rebates information are processed through the queuing system.

Main Responsibilities

Involved in creating Message Brokers for integrating the applications.

Involved in monitoring the message queuing jobs and handling the errors.

Personal Information

Name : Kavitha Mohan

Communication Address : 1138 Kingston Grove Dr

Cary, NC- 27519

Contact this candidate