Database

Air King Tours and Travels Ltd., Forex Division, Madras, India, December 1997 to February 1999

Developed Foreign Currency Exchange Software using Visual Basic 5.0 and Oracle 7.3. Implemented the software in various branches of the company.

Install and configure system software and third-party software; and analyze and resolve complex performance user/system problems and outages.

Tools and technologies: Visual Basic 5.0, Crystal Reports 6.0,PL/Sql,,Oracle 7.3

Sowdeswari Amman Spinners Ltd., Coimbatore, India, September 1994 to November 1997

Production development/support of in-house applications. Developing application and program specifications for emergency maintenance and/or Service requests from users.

Manage and prioritize work. Provide status and meet with both IT and Business for daily operational issues. Performed analysis and coding of the software. Developed and maintained all the projects documentation.

Tools and technologies: PL/Sql, Forms 4.5, Reports 2.5 and Oracle 7.3.

 

 

Regional Hospital System – Maximo Inventory and Asset Management Implementation

Served as the Project Manager for the implementation.

Project Highlights:

Implemented Maximo Inventory and Asset Management modules for healthcare supply replenishment.

Authored fit/gap analysis for all Inventory and Asset Management.

Converted all Inventory and Asset Management data from legacy system.

Authored test scripts and managed end-to-end system testing.

Managed and authored SOP changes.

 

VARIOUS organization POSITIONS, U.S. & India                                                                                       2002-2012

Regional Hospital System – Warehouse Management System (WMS) Selection

Served as the Project Manager for the WMS selection process.

Project Highlights:

Process mapped all business processes from the setting of inventory levels based upon historical usage, through all automated material flow, all the way to clinical Point-of-Use (POS).

Evaluated PeopleSoft, Oracle WMS, Tecsys, and HighJump.

Authored fit/gap analysis for all business processes against all evaluated software.

NaviSite India Pvt. LTD. / Hcl India. / TCIL Bellsouth Limited. /TCS Chandigarh and System Engineers Delhi.

Stepped into complex client situations to assess and provide state-of-the-art Oracle different version and PeopleSoft solutions for Finance, Business Intelligence, and CRM, Human Resource, retail, health care, Manufacturing and telecom Sectors. Analyzed and documented business needs/risks; conducted fit-gap analysis of business requirements and enhancement requests; and maintained compliance with industry regulations. Provided to ongoing business, data, and systems analyses to build productive relationships with clients, colleagues, and managers and coordinated local and offshore teams.

 Hand on experience in installation and database creation through DBCA and Manually of various oracle software 8i, 9i, 10g, 11g and 12c on various operating platform which include Red Hat Enterprise Linux, UNIX (HP-UX), Sun Solaris as well Windows servers.

Hand on experience in installation and database creation of 4 nodes RAC on ASM and OCFS Device on 10g, 11g and support as well which include all CRS admin activity to take the backup of OCR and Voting Disk, Recover and health check.

Good expertise in installing and configuring PeopleSoft HRMS and FSCM Application (Tool Version 8.4x and above Application Version 8.8x  and above) on Windows Server 2008,Solaris and Linux, and configuring Application Server/PSNT and PSUNIX and Webserver as well as configuration, support  of Apache, Web logic, Tomcat, Tuxedo tools. Good expertise in PeopleSoft Tool/Application upgrades from 8.49 to 8.52.06 and 8.52.06 to 8.53 and 54 and Application (HRMS and FSCM) from 8.9 to9 and 9 to 9.1 and 9.1 to 9.2 versions on Solaris operating system and also having great expertise to setup Patch Update Manager (PUM).

Hand on experience in Tax-updates, patches, Bundles and Maintenance Packs of PeopleSoft, Project migration. PeopleSoft Change Assistant (CA),Agent Manage, Cobol compilation, SQR Migration, SAS-70 Execution, Project Migration, Compare Report, SYSAUDIT & DDAUDIT, Application Designer, Data mover, Search Server, Integration Broker, Report Node, Application Server Manage as well Process Scheduler Manage.

Expertise Backup and recovery of Oracle Database of different utility, Rman Backup as well as Rman catalog backup server (Incremental & Cumulative Backups). As per Client need also performed hot backup and Cold backup. Hand on experience in Logical Backup (Exp/imp and Expdp Impdp)

Performed Yearly and half year Disaster recovery test for of Oracle Database.

Monitor database utilization and capacity to meet application demands. Completed minimized the space related errors in Oracle Databases by conducting month review with Senior Management and addresses the space issues proactively. Performed server Database reorg activity to reduce drastic change on database spaces utilization.

Conducted Performance Review of Oracle Database for business to generated Explain Plan, AWR, ADDM, ASH, Trace, Hints reports, Stats from Oracle 8i,9i,10g,11g and 12c  databases and analyzed the reports for Oracle wait events, time consuming SQL queries, Tablespace growth, database growth. Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.

Intensive exposure active Data Guard and Manual Standby database and support as well. Handled multiple projects for zero downtime migrations and multi master replications using Streams and Golden gate solutions.

Hand on experience PSU Patches, Securities Patches, Patches

Hand on experience security administration management activities, such as enrolling users. Granting privileges to users. Controlling and monitoring of user access to the database including, Granting and revoking of privileges and roles and table space quotas also having expertise  to implementing on Auditing, TDE, Splunk,

 

HiTech Network Inc, Toronto                                                                                        January 2001 – June 2001

MS SQL Database Admin, Database Design, Visual Basic Application Development

 

Xincon Computer Institute, Toronto                                                                            January 2001 – June 2001

MS SQL Server Database Administration & Database Design

 

Silverline Technologies Limited, Mumbai, India                                                            September 1999 – Oct 2000

Client: HTA Limited, Project: COSMOS (COmprehensive System for Media Operations and Services)

Implemented Contracts, Work Orders, AP, Invoice & Payment Modules for Advertising & Media System

Managed Business Processes for Advertising & Media Agency for various mediums like Billboard, TV, Cinema, Print etc.

 

Sheth Developers Limited, India                                                                                  September 1997 – September 1999

Project: Construction Monitoring & Planning, Contracts, Procurement, Inventory and Payables Financial Systems

Implement  / SDLC for Building, Construction, Labor Contracts, PO, Procurement; Build Consensus & Implement Solutions

Requirement Gathering, BRD, Traceability Matrix, Functional / Tech Solutions for Business Problems, Presented Solutions

Environment: ERP, AP, PO, Inventory, Item Master, Supplier Setup, Service Contracts, Supply Chain & Construction Planning

Bapna Computers, Mumbai                                                                                         June 1997 – Sept 1997

Environment: PowerBuilder, Visual Basic, Oracle Database

 

 

Client: Canadian National Railway, Montreal                                                                              June 2001 – Dec 2001

Railway & Railroad Management System. Efficient Tracking & Analysis Systems using Client/Server Systems & RDBMS

Managed Railroad Repair Tracking System; Railway Engine/Coaches Repair Tracking Systems, Railway Business Process