Professional Summary

• Over 13+ years of IT experience in technical leadership, system analysis, design, development, testing, implementation, user training and support of Client Server applications.
• Sybase Certified Professional (CSP).
• Microsoft Certified Solution Developer (MCSD).
• Excellent interpersonal skills with demonstrated successes as Senior Member Technical Staff, Programmer and Consultant with hands-on Technical Leadership.
• Experienced using Object Oriented Features like Inheritance, encapsulation and polymorphism.
• Extensive experience in developing complex reports using DataWindows.
• Strong event-driven programming skills in user friendly Graphical User Interface Development on PowerBuilder.
• Designed and developed System Interface using PowerBuilder objects, both Visual and non-visual: Windows, Tree-views, User Object, DataWindow, DropDown DataWindow, datastore, etc.
• Expertise in developing applications in PowerBuilder 4.0/5.x/6.x/8.x/11.x using Oracle 9i/8i/8.0/7.x, Microsoft SQL Server 2000/7.0/6.5, Sybase, PL/SQL, MS-Access on Windows platforms.
• Experienced in developing PB applications using Powerbuilder Foundation Class (PFC).
• Having significant experience in Stored Procedures, Functions, Triggers and Packages using Oracle, Sybase and SQL Server.
• Good experience in Data modeling using ERWIN/ER Studio.
• Good experience in various diversified sectors including Entertainment Industry, Sales & Telemarketing, Warehouse Management, Mutual Funds Industry, Accounting, Banking, Civil Construction Management, Homeo Medicine Management and Order management.

Technical Summary

Technical Training

• Technical training in PowerBuilder & Sybase System 10 at SSI Limited Chennai, India.
• Computer Business Application of Small Industries Service Institute. Govt. Of India, Chennai, India.
• Technical training in Informatica 7.1.3, Business Objects Xi and Teradata V2R5.
• SAP (Human Resource) training at SRG America, Santa Clara, CA

Professional Certification

• Microsoft Certified Solution Developer.
• Certified Sybase PowerBuilder Developer Professional
• Certified Teradata Professional/Application Developer in Teradata V2R5.

Technical Expertise

Operating System : Windows ’95, Windows NT and Windows Vista
UNIX (SCO UNIX), HP-Unix
RDBMS : Oracle 7.x/8i/9i/10g, SQL Server 6.5/7/2000,Sybase,
MS-Access, Informix
GUI : PowerBuilder 5/6.5/7.x/8.x/9/10.x/11.x, Microsoft Visual Basic 6.0
Web Design/Development : Dreamweaver, Adobe Flex 3
Reporting Tool : Business Objects Xi
ETL Tool : Informatica 7.1.3
VLDB : Teradata V2R5
Languages : C, PASCAL, COBOL, FORTRAN 77
LAN Environment : Novell NetWare 3.12
Office Automation Packages : Microsoft Office

Education

• Masters of Computer Applications .

Professional Experience

Confidential,CA Jul 07 – Till Date
Role : Senior Consultant

Domestic Theatrical System (4Star)

Project: The 4Star is the domestic theatrical distribution system. Mainly used to book the theatres for the WB Releases and maintain the grosses earned by the bookings. 4Star maintain both Telephone and Box office grosses. It has the ability to interface with SAP to send financial information (gross). Apart from this it has Market Model Plan, Print Control, Accessories, Sales and Booking, Playdate Chart, E.I.S, Grosses, Billing and Box Office, Cash and Account Status, Statements and Analysis.

Responsibilities

• Understanding the Customer Requirement
• Technical Analysis for the requirement.
• Responsibilities include Table & Screen Design, Development.
• Develop or fix Backend Functions, Procedures, Triggers, Views and Package
• Test user creation for the end user testing.
• Executed file Generation and deliver the application.
• Involved in Unix Shell Script creation.
• Support the Interface’s to various vendors.
• Deployment & Implementation.

Environment : PowerBuilder 11.2 with PFC, Oracle 10g, Toad9.0, Windows XP, HP-Unix

Confidential,CA Jul 07 – Mar 09
Role : Senior Consultant

Movie Marketing System (MMS)

Project: This system used to maintain Movie release, marketing and gross details of Warner and competitors releases. Help of media and other sources the users will capture competitors gross and reviews into the system. Reviews are categories by the reviewer outlet and rating. Gross can accommodate even the pre-release of the movie. To do the market analysis and project the movie gross for current & future year information in this system will be used. With the help of this system marketing team will make decision for movie release.

Responsibilities

• Understanding the Customer Requirement
• Technical Analysis for the requirement.
• Responsibilities include Table & Screen Design, Development.
• Understand the existing based code
• Responsible for Backend Functions, Procedures, Triggers, Views and Package
• Test user creation for the end user testing.
• Executed file Generation and deliver the application.
• Deployment & Implementation.

Environment : PowerBuilder 11.2 with PFC, Oracle 10g, Toad9.0, Windows XP, HP-Unix

Confidential,, TX Mar 06 – Jun’07
Role : Programmer Analyst

Tele-Order Tracking System (TOTS)

Project: This project is their part global order tacking system. The application will be activated once the tele-sales person receives a call for any orders. Application activation down by a Visual Basic Application, which receives a call and activate the system. Customer, Order, Product, Sales Person Maintenance are done by this application. Department level order tracking done at this system, so at any point of the time we can able to know the current status of the order. TOTS as an active link with WMS (Warehouse Maintenance System). This link provides the stack information about the product which customer seeking and which warehouse has that product. This system has extensive reports to the representatives on order status.

Responsibilities

• Responsible for interacting with Users for the new enhancement raised by them.
• Understanding the Customer Requirement
• Technical Analysis for the requirement.
• Responsibilities include Table & Screen Design, Development.
• Responsible for Base code development
• Responsible for Backend Functions, Procedures, Triggers, Views and Package
• Test user creation for the end user testing.
• Support for the user manual development.
• Executed file Generation and deliver the application.
• Involved in Unix Shell Script creation.
• Unix Cron job maintenance.
• Data Backup for development & Testing server.
• End User training.
• Deployment & Implementation.

Environment : Powerbuilder 10.5, Oracle 9i, Toad8.6, Windows XP, HP-Unix

Confidential, TX Apr’05 – Feb’06
Role : Programmer Analyst

Warehouse Management System (WMS) Using PFC

Project: This project deals with various warehouses which HP has in different locations. Product, Stock Holders, Stock Level of various products, Location, Damaged Goods and other information related warehouse has been maintained by this system. When any particular product goes low to they margin lock level it will indicate to the respective stock holder person.

Responsibilities

• Requirement gathering with the users for feasibility study and Gap Analysis.
• Responsibilities include Screen Design and Development.
• Involved in Base code alteration.
• Created Procedures, Triggers for some of their new functionality.
• Executed file Generation and deliver the application.
• Creating the test plan and implementation plan.
• Data Backup.
• Deployment & Implementation.
• Worked on implementing report generation
• User training/support after the implementation.

Environment : Powerbuilder 9.0 with PFC, Sybase ASE 12.5, Toad8.6, Windows XP, HP-Unix

Confidential, Dec’02 – Mar’05
Role : Computer Consultant

Safe Deposit Box System (SDB)

Project: This SDB is used to maintain the Customer, Rental and Visit information of Safe Deposit Box. It also generates Reminder, Debit Advise and Advance Notice to Customer through monthly jobs. This system has communication with Banks Core retail system for GIRO Deduction. In addition to that it also sends data to GDW (Global Data Warehouse) for VBM (Value Based Management) System.

Responsibilities

• Interface with Business users for requirement gathering.
• Responsibilities include Screen Design and Development.
• Preparing the documentation on requirement of users.
• Preparing documentation on technical specification.
• Involved in unit testing of modifications and enhancements made to ensure system integrity.
• Created SQL Functions for their new functionality.
• Executed file Generation and deliver the application.
• Unit Testing and User Acceptance Test.
• Implementation plan and deployment.
• User training.
• Support for the production system.
• Debugging and resolving the production problems.

Environment : Powerbuilder 8.0, SQL Server 2005, Windows Server 2000, Windows XP

Confidential Jan’02 – Oct’02
Role : Application Specialist

Business and Company Filing System (eBizFile)

Project: This system is Developed using psi (Public Service Infrastructure) tool, which Owned and maintained by IDA of Singapore Government. This development tool is only allowed to use by the government agency only. Through this system the public can apply for Local/Foreign Company/Business Name Application and Incorporation and other applications, which is related to the publics business, and Company.
This system involved with another two major systems like Workflow and DMS (Document Management System). This Workflow engine will route the applicants request to the appropriate approving officers vetting. While submitting the application the public needs to attach their supporting documents. Those attached documents are maintained through the DMS. The progress the application will be informed through the email to the applicant. Some of the notifications to the officers are done through the SMS.

Responsibilities

• Responsibilities as Development using psi tool.
• Created stored procedures
• Unit Testing
• Creation of User training material for the module which I involved.

Environment : pSi(Public Service Infrastructure), Oracle 8.x, JSP, iPlanet 6.0 on Sun Solaris 8

Confidential Aug’01 – Dec’01
Role : Application Specialist

Food Licensing System (FLS)

Project: This project has two parts one is online part which is developed for online users (Public) using psi tool. This tool, which Owned and maintained by IDA of Singapore Government. This development tool is allowed to use by the government agency only. The second part is application processing done by Powerbuilder Application. Through this system the public can apply for the License to run a Food Stall, Food Center and Food Factory. This information regarding the Stall or Center will be fetched from their mainframe database, which is owned, by the ministry of Environment. Through this system the licensed stall holder can gives his stall for rental to some other applicants. The Applications needs the both sides request i.e. the applicant who need stall and the person who is going the give his stall for rent.

Responsibilities

• Responsibilities include Screen Design and Development.
• Created Procedures, Triggers for some of their new functionality.
• Executed file Generation and deliver the application.
• Deployment & Implementation.
• User training/support after the implementation.

Environment : PowerBuilder 6.5, Sybase ASE 12.5, pSi(Public Service Infrastructure) For online application, Windows NT 4.0, iPlanet 6.0 on Sun Solaris 8.

Confidential,Singapore Apr’01 – Jul’01
Role : Application Specialist

Training Management System (TMS)

Project: TMS is a Client Server Architecture windows based, user-friendly Training management system. TMS is designed and developed for SCDF (SINGAPORE CIVIL DEFENCE FORCE) and CDA (CIVIL DEFENCE ACADAMY). TMS is used to enter the details of Course Administrator, Course Instructor, Course Trainee, Course, Course Schedule and Training Instruments, which can be used on time of training. Once have all details in the database. We can build the timetable for the Course Instructor and Trainee. The important point in this system is the trainees can attend the online test through this.

Responsibilities

• Involved in the Screen Design and Development.
• Created oracle procedures, functions and procedures.
• Unit Testing & UAT.
• Generation of executable files
• Deployment & Implementation.
• User training.

Environment : PowerBuilder 6.5, Oracle 8.x, Windows Server 2K, Sun Solaris 8.

Confidential,Chennai, India Nov’99 – Apr’01
Role : Senior Member Technical Staff

Mutual Fund Investor Service for Distributors (MFISC/D)

Project: MFISC/D is a Client Server Architecture windows based, user-friendly Broker-Fund management system. Any brokers of Open Ended Mutual Fund Account System, Fixed Deposits, Corporate Deposits, etc can use MFISC/D, MFISC/D is used to enter transaction like Purchase, Redemption, Switches (Only for Mutual Funds) and non-financial Transaction like Change of Address, Change of Bank Mandate and Complaints Module. MFISC/D is having important features like Balance Inquiry, Portfolio Statement, front-end Commission Re-Calculation, Trailer Fee Re-Calculation, Consolidated portfolio Statement.

Responsibilities

• Responsible for interacting with Users for the feasibility study and Gap Analysis.
• Understanding the Customer Requirement
• Preparing the requirement/functional document.
• Responsible for Backend Functions, Procedures, Triggers, Views.
• Developing the screen for the core functionality.
• Executed file Generation and deliver the application.
• Implementation planning.
• User training/support after the implementation.
• Support after the implementation

Environment : PowerBuilder 7.x, Oracle 8.x, Windows NT 4.0

Confidential,India May’99 – Nov’99
Role : Senior Member Technical Staff

Investrak

Project: This System received all trades by the Investor Service Centers before the cut off time will be valued at the NAV of the current day while all trades received after the cut off time will be valued at theNAV of the next day. Record the NAV for the preceding business day. Import trades from the Investor Service Centers. Verify the imported trades through Trade Entry. Perform an Integrity check to compute the fund\'s closing balance, the closing balances of all unit holders, and the total trades received. Physical requests are cross-verified with day\'s trade registers. Signatures on the physical requests are verified with a pre-scanned signature to confirm the identity of the unit holder. Generate account statements for all valid trades. Generate redemption warrants for all valid redemptions requests.

Responsibilities

• Performed analysis, design and development.
• Worked on integration process with other systems.
• Involved in creating Procedures, Triggers and functions on Oracle.
• Executed file Generation and deliver the application.
• Maintained the Data feed load from other third parties.
• User acceptance Test

Environment : PowerBuilder 7.0, Oracle 8.x/ Sybase ASE 11.5, Windows NT 4.0