Synopsis: Over 20 years of IT experience in the designing, coding, testing and implementing various business applications using different tools.

QUALIFICATION

Bachelor of Commerce

CERTIFICATION

System Analysis & Design

Chartered Accountants of India

Factory Planner Implementor

I2 Technologies, USA

Impromptu Administrator

Cognos

MS Office 97 new features

Executrain

Holos Developer course

Seagate

R5 Domino Designer

Drake International

Power Builder 6.5

Sybase Corporation

PROJECT EXPERIENCE

Client Name: Confidential, Owings Mills, MD

Role: Application Support Specialist

Duration: Mar 2010 to Till Date

Support:

• Support & maintain SMARTSTREAM/TLM Reconciliation systems for the affiliates of Legg Mason.
• Migration work to Fiserv NXG
• Transition work from Legg Mason to affiliates
• Sybase database support & maintenance acitivities.
• Solving day-to-day issues to the recon users
• Maintaining / monitoring/production support for various AUTOSYS jobs for the recon applications.

Role: Lead Engineer (Global Recon Specialist)

Duration: Mar 2003to Feb 2010

Support:

• Support & maintain SMARTSTREAM/TLM Reconciliation systems for worldwide branches.
• Migration work to new version SSR 7631/TLM 2.6
• Involved in various development work for writing reformatters for different SWIFT message types.
• Oracle database support & maintenance activities.
• Writing and debugging PL/SQL stored procedures, packages, PERL scripts & Shell scripts.
• Providing technical support and day-to-day issues to the worldwide users in the above tool.

Generic Reformatter:

• Smartstream/TLM is a vendor product supplied by the Smartstream Technologies Corporation (STL), which runs on IBM H70 and F50 Unix servers, using an Oracle database.
• The Swift_server Generic Reformatter is a programming tool used to convert a flat file related to cash, security positions, or security transactions into a fully compliant SWIFT file ready for input into Smartstream.
• The control file is used to load the data files into the feeds tables. The process is loaded via SQL.
• Stored procedures are used to load data into the swift_server table. The stored procedure does not solely transfer the data from the feeds table to the swift_server table. Any feed specific data manipulation is performed by the stored procedure.

Client Name: Confidential

Duration: Aug 1998 to Feb 2003

Roles and Responsibilities:

• Developed & implemented power builder applications using Oracle database.
• Developed & implemented various Lotus Notes applications like help desk systems, software request database, Electronic requisition system, time sheet databases, End-of-day Systems for IT operations, Leave Management Systems & Customer Management systems.
• Implemented customer FACT sheet database for Hong Kong and Labuan under globalization projects.
• Involved various data extractions from the Mainframe to the above Lotus Notes applications.
• Solved Cognos Impromptu queries for the various department users.
• Maintained & involved in trouble shooting COBOL-based banking applications.
• Supported Wall Street systems and various dealing room applications.

Duration: Feb 1997 to Aug 1998

Roles and Responsibilities:

• Setting up a new business division called Asia Pacific Fulfillment Centre (APFC) under the VMS based MAXCIM applications.
• Production support for various mainframe manufacturing applications in the factory.
• Involved in the implementation of factory planner implementor called RHYTHM under I2 Technologies.

Client Name: Confidential

Duration: Feb 1993 to Feb 1997

Roles and Responsibilities:

• Various development projects for Student Information Systems, Personnel statistical systems and budget forecasting systems under VAX/VMS using Henco INFO application software development tool.
• Also developed and updated user and system documentations for various applications.
• Also involved in helping & solving Students programming problems during their practical sessions.

Client Name: Confidential

Duration: Apr 1992 to Oct 1992

Roles and Responsibilities:

• MANMAN (Manufacturing Management) is an online and integrated multi-currency multi-company management information system specially designed for manufacturing industry.
• Package has been developed under FORTRAN on the VAX/VMS.
• Record structures used where put under Common Dictionary using CDD+ data dictionary utility.
• Maintenance and entry program where maintained using DECFORMS utility.

Client Name: Confidential

Duration: Jan 1987 to Mar 1992

Roles and Responsibilities:

• Coded, tested & implemented many applications using different tools to satisfy the customer needs.
• Some of them are Payroll, Management Information System, General purpose Reporting programs. CPU usage systems, Performance Evaluation & Productivity Systems (PEPS), Incentive Payment Systems for Hindustan Lever factory, General purpose Extraction utility from the RMS text files, General purpose Data Entry, Personnel Information Systems, New Issue of Shares System for the brokerage firm, Invoicing system for the Pharmaceutical company, Fixed Deposit Accounting and Marketing Analysis.