• Home
• Staffing Services
  • Overview
  • Technical Consultants
  • Technical Recruiters
  • Contract Staffing
  • Job Requirements
  • Recruiting
• Jobs
  • Our Jobs
  • Other California Jobs
• Career Center
  • The Interview
  • Interview Questions
  • Thank You Letter
  • Professional References
  • How To Write A Resume
  • Resume Cover Letter
  • Two Weeks Notice
  • News & Articles
• About us
  • Biography
  • Why Techreq?
  • Partnerships
• Contact us
  • Employment Docs
  • Send In Resume

Eighteen years of post-graduate experience in Information Technology focusing on Technical Infrastructure, Business Process Reengineering, Database Administration, Data Modelling, Management Consultancy and Training. Technical Project Management experience in areas of systems/data analysis, application/infrastructure design, development, setup, conversion, customisation, implementation & support of business /data warehousing applications on various platforms. Special expertise in ERP implementation and Data Warehousing & Data Migration using Oracle & DB2. Excellent Project design & management capabilities with sound communication, interpersonal & team skills. Experienced in Database Administration, logical & physical Database design, interface development for data migration from mainframe to client/server and legacy to ERP applications. Highly proficient in areas of client/server configuration, capacity planning, hardware sizing, software/hardware installation & configuration, technical support and implementation of various RDBMS on both IBM mainframe and Client Server environment.

·          Oracle Financials Application Administration (System & Database Adm.)- GL, AP, FA, PO, AR, SSI, iProc.

·          Installation, Upgrade & Migration of Oracle DB from 8i to 9i & Oracle Applications from 11.5.8 to 11.5.10

·          Installation, Upgrade & Migration of Oracle Financials Application from Prod 16 (SC) to 11.5.10(11i)

·          Project Management - develop all Project Scope, Analysis & Plan - Task identification and estimations

·          Establish full project life cycle (ERP/Application) plans and budgeting/planning for future resource needs.

·          Large scale Data Migration – Legacy to Client/Server (DB2 to Oracle/Sybase)

·          Establish client communication, organize business strategy & status meetings, design and implement SLA.

·          Requirement gathering - Issue identification, tracking and escalation of Reporting/Data Warehouse System.

·          Integration of Imaging tools/sw (Markview 170) with Oracle Applications implemented across multi-platforms.

·          Oracle Financials Business Process study – GAP analysis, re-evaluate customization & new features

·          Oracle Financials Reporting – Study reporting requirements, set up reporting server environment.

·          Monitoring & Performance tuning of Oracle Database (associated to Application) – Patches/Upgrades

·          Capacity Planning – Archival and Purge of GL, AP, FA & OM data using eBusiness application tools.

·          Research & recommend new technologies – identify how technologies can be applied to business needs

·          Software/Application Development & Package Implementation lifecycle methodology (SMM- SD/ERP)

·          Capacity planning, Bench Marking, selection & configuration of Hardware/Servers

·          Facilitate Internal/External annual Auditing (IS) of Standard Operating Procedures (SOP)

·          Designing & establishing full proof Change Control Procedure & Disaster Recovery Planning

Technical Skills

RDBMS:                                    Oracle 7/8/8i/9i with SQL*PLUS, Sybase Sys10, DB2 2.2 & XDB 3, Access

Operating systems:                 MVS/ESA, SOLARIS 2.6/2.7, UNIX SVR 4.2, MSWindows 2000/98/95, Windows NT 4.0, MS-DOS, OS/2

Languages:                             Visual Basic 5.0, Visual C++, HTML, C, MF COBOL 3.2, VS COBOL II 1.3.2, Fortran, Pascal, PL/I, Assembly(IBM360/370),JCL

Hardware:                               Mainframe : IBM ES9221/150, IBM 3090

                                                Midrange : Alpha-DEC-3000, SUN Ultra Enterprise 450/4500/5000 /6500

                                                Mini : HP 9000 (Risc CPU), HCL-METEOR II, Pentium servers

Other Tools/Software:             Lotus-123, Developer 2000, Forms 4.5/5.0, Reports 2.5/3.0, Designer 2000, DSS Microstrategy, MS Project, Precise Interpoint, OEM 2.1, Reflection X, BMC

Education

SUN SOALRIS 2.5 - Essentials, 40 hours, Gateway Computers

SUN SOALRIS 2.5 - Advanced System Administration, 40 hours, Gateway Computers

Introduction to ORACLE: SQL & PL/SQL using Procedure Builder

Oracle Database Administration

Oracle Financial Application - System Administration

Oracle Financial Technical Foundation

Project Experience:

As one of the Senior Oracle Application Database Administrator of the Global Information System, I am responsible for managing & supporting Global P2P, Self Service, EDW & Imaging (Markview 170)System, which caters to its corporate offices throughout the world. This involves24X7 (weekend and night shifts) support & maintenance of the two Production and over 25 Development & Test environments across 12 – 15 SUN Solaris Servers. Responsible for defining and planning architecture, support & maintenance procedures and weekly new builds & cloning of instances. Basic environment – Rel 11i (11.5.6, 8) on 8.1.7.4 & (11.5.10) on 9.2.0.5 & 10g – (JDK 1.5.1, Portal, Java, Apache) with AP, GL, FA, SSI (portal), WebAdi. Change control/management tools – Kintana – for both Patch & Object migration; PVCS – for version controlling of stage. Also includes regular troubleshooting of database/system performance related issues across all the geographic locations.

Following are some of the major tasks/accomplishments during the last four and a half years in this project:-

·          Migrate existing RDBMS from 8i to 9.2.0.8 and then 10.2.0. along with Portal upgrade

·          Upgrade eBusiness suite using rapidwiz and adclone to 11.5.9 and then finally to 11.5.10

·          Archived and Purged Journal/Balances for 3 a/c periods & Asset s for 2 fiscal years saving up to 200GB

·          Install/configure 11.5.9 Oracle Applications Manager and Oracle Enterprise Manager 10.2.0.2

·          Setup up OMS server on Sun Solaris and clients across a multitude of Solaris/AIX/Wintel platforms.

·          Plan and implement the entire infrastructure for Image processing for AP/TNE using Markview 170 System

·          Plan and Upgrade the entire Imaging system (170 systems) from 3.7 to 5.0 with major infrastructural changes.

·          Set up cron scripts with UNIX shell and SQL scripting to monitor/administer the 170 system ver 3.7

·          Coordinate Developer and User group testing for the implementation and usage of Kintana/ITG migration tool.

·          Incorporate security features / password maintenance policies across all the Oracle Application instances.

·          Worked on downsizing of post-cloned 11i instances using Applimation tool followed by Datamasking scripts

As the Technical Lead for all Database/ERP environment my responsibilities are not only limited to providing expertise in the areas of Oracle Database & Unix System Administration but also involved in the planning of the Technology infrastructure across the 6 different locations across the United states. Daily responsibilities include coordination with the CIO, and CFO of the organization and plan upgrade/install/restructuring projects with various local technical managers stationed in NY and Virginia to complete a smooth migration of the entire IT operations from the New York office to the new corporate centre in Sarasota, FL.

Following are some of the major tasks/accomplishments:-

·          Implemented OEM9i to monitor the 8i Oracle database instance spread across 4 servers in various locations.

·          Implement standardized Oracle structures/procedures to migrate databases from NY to servers in Sarasota.

·          Upgraded existing Financial database from 8.1.6 to 8.1.7.3 on Development /Production servers.

As the Financials Application Database Administrator of the TIS group of Tulane University, I was responsible for managing the Oracle Financials Application (customised as TAMS- Tulane Accounting Management System), a Release 10.7SC (Prod 16.1) version of the product implemented over a 3-tier architecture. The Oracle RDBMS ran on IBM OS/390, followed with the application/Technology stack installed on a middle-tier RS6000 server running on IBM-AIX. The Smart Client(Fat Client) was installed across multiple Citrix servers providing shared access to the application front-end. Responsible for planning, design, implementation & upgrade of the RDBMS from 7.3.3 to 8.1.7 followed with the upgrade to Oracle Financials Applications from 10.7SC to 11/11i for AP, GL, AR, PA, Grants & PO modules.

As the Financials Application Administration Manager of the Database Services group, I was responsible for managing a team of 6-7 Application/System Administration members. Actively involved in the planning, design & implementation of Oracle Financials Applications(all the way from Prod 15 to 11/11i) for AP, GL, FA, AR, PA & PO modules & Portal for 11i; along with interfaces to Data Warehousing & PeopleSoft-HR/Payroll systems.

Specific Roles & Responsibilities as the Project/Application Administration Manager:

·          Develop and implement a comprehensive project plan with detail workplan for individual tasks.

·          Negotiated archival strategy with business group and executed archive/purge all data beyond 3 fiscal years.

·          Design, develop and implement the Security for Reporting Server – based on discussions with Finance.

·          Develop the architecture for Reporting Server based on changing requirements of the Data Warehouse System

·          Coordinate Project management, M&R, Operations, Server Admin and other support group resources

·          Set up and configure Maestro scheduler with finally tested refresh scripts.

·          Migrate existing Year End application instance over to the reporting server – swapping of servers.

·          Analyze, design and manage data conversion/migration procedures and Enterprise application interfaces from legacy to Oracle based systems that included Oracle Financials & PeopleSoft HR applications.

Specific Roles & Responsibilities as the Project/Application Administration Manager:

·          Migrate existing RDBMS to 8.1.7.2 and Set up Server partition for Application Server binaries remaining on 7.3.6

·          Upgrade and implement the existing Test environment from 10.7 NCA to 11.0.3 – took about 6 x 2 days

·          Apply necessary interoperability patches followed by two mega-patches for the AP & the FA modules

·          Use Rapid install to install Application Release 11.5.4 (with 11i portal) on a single node server

·          Review and discuss new features & areas of improvement (gaps) in the business process with the business group.

Specific Roles & Responsibilities as the Project/Application Administration Manager:

·          Prepare the technical architecture with the proposed option of migrating ADI fat client to a WTS env,

·          Set up dev/test env. with Citrix metaframe and ADI 5.4 for proof of concept & presentation to business

·          Install ADI 7.0 on Citrix metaframe - Deploy Citrix ICA client to all user PC (after removing fat client)

·          Upgrade existing development environment to ADI 7.0 and set up a separate IS server for Help Document

Tech Platform: SUN E6500/4500/450; Solaris 2.6, Veritas, BMC, Oracle 7.x/8i, OWS, Forms/D2K Server, JDK, IE

Specific Roles & Responsibilities as the Project/Application Administration Manager:

·          Migrate existing production (Apps/DB) server to a high end SunE6500 box – anticipating growth

·          Install Solaris 2.6/OWS 3.0/Dev2K Web Server1.6.1/10.7 NCA on new application server

·          Configure multiple Web listeners, Forms listeners, WRB’s & forms cartridges via Web Admin.

·          Convinced Finance on the removal of four (out of 11) unnecessary accounting segments defined in GL

·          Set up Multi-Org on the existing production environment(Smart Client) and implement & configure FA.

·          Create detailed Help Desk documentation and train the Solution center staff for on-going support.

Specific Roles & Responsibilities as the Project/Application Administration Manager:

·          Provided technical infrastructural input to PWC Mexico to plan the implementation of Oracle Apps

·          Create individual appl_tops (forms binaries) for 2 development & a separate production instances

·          Developed detailed implementation plan and a full proof test plan for post implementation review.

·          Train key users for GL Super User/Administration – Define Flexfields, Enter Code combinations.

Specific Roles & Responsibilities as the Project/Application Administration Manager:

·          Plan proper migration strategy for implementing AP, AR & PA on existing production (GL) environment

·          Involved in a full cycle performance monitoring and capacity planning exercise – considering additional modules

·          Upgrade from Prod16 to Prod 16.1 on the live environment across 350+ users (client upgrade)

·          Customize Check Printing and EDI xfer procedures – set up check printers using Evergreen cartridges.

·          Prepare detail implementation plan for the Project Accounting module.

Specific Roles & Responsibilities as the Project/Application Administration Manager:

·          Carried out detail sizing exercise & benchmarking to choose appropriate hardware & vendor

·          Install & configure application (Prod 16/10.7 SC) on Sun Solaris 2.5.2, Oracle 7.3.2

·          Define multiple concurrent managers and workshifts based on responsibilities and request type

·          Create multiple application instances with individual appl_tops - Apply patches hierarchically across all instances

·          Install & configure GLDI for data interfacing – also run SQL scripts to import legacy data

·          Analysis, design and management of Enterprise Application Interfaces jointly with the business group.

·          Select & Evaluate (Benchmark and POC) Data Warehousing tools – DSS Microstrategy

·          Manage deployment of patches and enhancements via automated scripts to 350+ users.

As a management consultant with PriceWaterhouse MCS (Old Co.), I was responsible and involved in the successful implementation and execution of several large to mid-size projects for various clients in US, India and Nepal.

for SAP R/3, Construction Manager, July 96 to October 96

·          Developing the project plan for the Construction phase in co-ordination with the Analysis team

·          Prepare, update & distribute individual task plan for the construction teams in India & US

·          Liaison with the senior project managers at both ends to track progress & ensure flow of work.

Developing and implementing an Integrated Business System, consisting of Accounting, Costing and Inventory systems for Himal Cement Company Limited, one of the major cement manufacturing organisation of Nepal. 

·          Meet with user groups & identify the integration problems among the various modules of IBX.

·          Produced a Requirement Definition Analysis (RDA), which was input to the Design phase.

·          Prepare a complete set of System Administration & User Guides for all the modules of IBX.

·          Obtain final acceptance of the IBX system ensuring proper functioning of FAS, PAS & MIS.

PW had been engaged to design & implement a Fixed Assets System. I was responsible for :

·          Establishing proper terms & conditions with the EDP manager and liaison with new users.

·          Planning a proper acceptance-testing schedule, which suits the user department.

·          Co-ordinate the preparation of User Guide & System Manual with data dictionary, triggers & procedures.

PW, USA had been engaged to reengineer the existing mainframe system and analyse, design, develop & implement a new integrated system known as CIS, covering all the aspects of Billing, Finance & Service Orders. I was responsible for:

·          Planning & implementing the Software/Hardware environment & designing coding standard.

·          Leading the team in developing, testing & documenting all Extract/Report programs from the ODS.

·          Maintain SMM guidelines & monitor via project management tools like GEM.

(Public Utility Group), - Service 2000 - Online Billing, Team Member, May 94 - July 94 / Tech. Platform: IBM PC, Windows, UNITRAC, MS-Access & Sybase(DB Eng.)

As an analyst, was involved in this project right from the stage of studying the existing system and designing forms & reports based on the LDM and the functionality of the proposed marketing system

Customer Information System (CIS II), Team Member – Data Conversion, April 93 - April 94 / Tech. Platform: VS COBOL II 1.3.2, CICS 1.7, DB2 2.2, Endeavour, Platinum, Xpeditor, Intertest on IBM 3090 platform (MVS/ESA)

Responsible for modifying all on-line screens related to the Service Orders, Landlord - Tenant management & Billing subsystems. Handled conversion of all Service Order related data to ensure successful implementation of CIS II.

Direct Response Mrkt. System, Team Member, Jan 92 – Jan 93 /Tech. Platform: PL/I, VSCOBOLII, CICS, ISPF Panels & VSAM & DB2 on IBM ES9221/150 (MVS/ESA)

Responsible for team scheduling and also actively participated in design & development of the system which also included self study of various advanced applications of PL/I Language.