Summary of qualifications

Proven leader and manager of projects and personnel coupled with over 10 years of experience as database and System Administrator Applications . Regarded as a positive, energetic, decisive team player that finds satisfaction in the development of people, projects and corporations. Received Special Administrative Achievement award at HRT for extraordinary contribution.

Certifications and training

• Oracle Certified Analyst OCA
• Oracle Certified Professional OCP
• Oracle RAC installation training
• Peoplesoft Server Administration training
• Peoplesoft Upgrade and Data management tools training

Computer Skills

• Programming Languages: C, C , SQL, PL/SQL, Java, JavaScript, HTML, Shell
• Databases/Applications: Oracle 10g, Oracle 9i, Forms 6i, Reports 6i, Crystal Reports, Discoverer
• ERP Applications: Peoplesoft Financials HRMS, Spear Inventory Mgmt System Infor
• Transit Applications: Init CAD/AVL System, Giro Scheduling Planning System, Trapeze Para transit Application
• Web Application Servers: Oracle Application Server, Oracle Forms Server, Apache Server, Tomcat, Weblogic, IIS

Employment

Confidential

Database / Application Architect

Working as Database / Application Architect providing technical support t Information technology officer, members of the Application Services, IT staff, and the users of HRT's Oracle databases and related applications. Manage infrastructure / storage/deployment/upgrade needs for all production system. Come with solutions t support 24x7 applications by designing failover system and determine MTTR and MTBF from database and application point of view. Design standby systems and failover systems. Provide help in creating RFP's, and evaluation for new applications agency wide. Als worked as project manager on several projects at HRT.

Confidential

Database Administrator / Developer Consultant

Worked as Consultant at Computer Science Corporation for Worldwide Port System WPS project at Military Traffic Management Command. Main objective of the project was t convert existing version 6.0 of WPS systems on Unix terminals t work on Windows Carry away system. Used Cygwin as Unix emulator for backhand Unix script, Oracle Forms Reports6i as front end and Oracle 8i as database.

Confidential

Research Assistant

Worked as research assistant with Systems Group at Old Dominion University. Assisted faculty in designing coursework and labs for Oracle Technology Initiative Classes and Solaris System Administration classes.

kEY RESPONSIBILITIES

Oracle Database Management Infrastructure Design and Implementation

• Created centralized repository of databases. Before each database had t be managed individually.
• Arranged all the databases in groups based on application
• Created jobs to analyze the database rebuild indexes reorganizations of tablespaces etc
• Created events t monitor CPU activity, alert logs, database and server activity etc .
• Managed patches and upgrades of all the databases
• Rebuild all the servers s that uniform installation standard is adopted across the board.

Design and Implementation of Disaster Recovery procedures and processes

• Documented the need of various kind of backups, restore and recovery procedures
• Wrote scripts to handle various kind of disaster recovery works
• Designed various kind of backup jobs for different databases at HRT
• Automated the jobs Created Event Job management and notification methods
• Created a repository in OEM server to document all database mgmt work
• Created a repository in recovery catalog which tracks all hot backups and archive log cleanups so that disk space in managed properly

Application management and support

• Technical evaluation of software's and applications
• Providing expertise in architectural design and solutions
• Key support in implementation, installation and management of applications
• Provide support in various capacity:
• Functional support
• Technical support
• Helping in documentation and analysis
• Helping in gathering requirements
• Helping in designing solutions
• Providing support to resolve functional, organizational, analytical, logistical and technical problems
• Help in improvising various performance parameters such as availability, accessibility, response time , restore and recovery time
• Help in designing disaster recovery scenarios for applications factors such as failover and load balancing are given high importance

User Management and support

• User Training Conducting training sessions for users and making them aware of functionalities and uses of system. This improves efficiency of departments using computer based systems.
• Requirement Gathering Sit with users and compile requirements t enhance existing processes or build new ones based on the needs of different user communities. Key process while discovering the needs business, operational or strategic ones for making good decisions.
• Vendor Customer interface Facilitate meetings between vendors and key users s that new technologies can be demonstrated and associated benefits can be realized.
• Helpdesk Support Users can call helpdesk at anytime and report problems they are facing. Most of the problems related t applications come t Application Services team. Troubleshoot the problems and recommend solutions t the problems. Work orders are created and problems are documented.

Development Design

• Gathered requirements for new projects and enhancements to current applications
• Created new application design
• Created E-R, Process Flow, and Functional Hierarchy and Data flow Diagrams for all supported applications.
• Provided solutions to fix problems to the interface between various applications
• Created Procedures t d total Re-org of databases based on procedure of creating new tablespace and moving all the data t new tablespace, dropping old tablespace and renaming new tablespace as old one t reshape the high water marks and make data more compact.

Managing Peoplesoft Development environment

• Procedure of documenting all the work and process assigned
• Procedures to properly document user requirements and approval on them
• Creating projects t identify the new needs for the given requirement. As a good practice create a new project for every major task owned by developer.
• Proper discipline to be managed while doing development work in Dev environment before it is shipped to QA for testing as completed task
• High emphasis on documentation and unit testing
• Each project should be associated with identified needs as per Process flow, E-R, Data Flow and Functional hierarchy diagrams with all changed definitions identified such as new fields, records, pages, PeopleCode etc.

PeopleSoft Server Maintenance

• Design disaster recovery strategy for Peoplesoft HRMS and Finance this included:
• Tape backup and database backup job creation and validation
• Recovery of system from backups taken documentation of all procedures
• Installation procedures and cataloging of all software's, patches, templates from the vendor. Complete change management system procedure for group.
• Creation of fail over and standby servers for media or hardware failures on key servers
• Creation of standby databases for production databases
• Creation of baselines on database levels and application level on timely basis. Creation of special projects in application designer t capture any change.
• Creating procedures of applying patches on Peoplesoft system and migrating them t production.
• Creating testing scenarios t test changes applied t the system.
• Running SysAudit, DDDAudits and Alter Audits on timely fashion to find errors in system and keep it healthy
• Creating new indexes and changing sql codes on big jobs t improvise performance of system. Good results with payroll processes.

Media Failure procedures:

• Documenting all steps while creating new Peoplesoft environment either for upgrade or current version as disaster recovery or schedule server upgrade hardware change
• Installing People Tools
• Installing BEA Tuxedo Weblogic
• Installing Oracle Client software
• Creating shares, reports directory and key services for auto start and shutdown of processes
• Creating application servers
• Creating process schedulers
• Creating Demo instances in case of new releases or upgrades
• Documenting steps if recovering from tape backups.

Upgrade Procedures:

• Installing new release on Server
• Creating Demo instance for new release
• Downloading all the templates for upgrades Tools and Apps
• Configure and install Upgrade Assistant
• Manage multiple environments old release and new release via Upgrade assistant to create steps for upgrade
• Load templates and execute steps to go through all the steps of upgrade
• Create your own steps and procedures for your own environment t validate progress and backup the development t capture all the effort and work.
• As a general practice upgrade tools first and the app next. Provides user t get accustomed with the new tools set and environment and easy t make other move.
• Users are separated in different test and configuration groups t manage modules of application.
• Validate all records, fields, PeopleCode and basic functions of applications
• Provide users Business process flows t test system. Make sure security is not compromised and all critical functions are working as desired. Validate all steps at each stage.
• Identify Customization and determine if they are needed and identify steps t move them t next release.
• Once development, QA and testing is done refine project and migrate them to production
• Create a project with all the steps identified above, prepare risk analysis, simulate production upgrade couple of times t refine all the steps.
• Upgrade production move data using data mover and test the application
• As a general practice it is recommended to get Independent verification and validation from 3rd party of your upgrade. Verify upgrade

Project Management

• Managed several key projects at HRT and elsewhere
• Currently managing Project to capture Light Rail Transit Assets in Spear Application
• As project manager create project schedules and task lists
• As project manager manage scope of work , manage milestones, deadlines and budget
• Provide Status Reports and progress to Upper Management
• Provide solutions when users need help
• Keep work manageable and on schedule
• Keep tight control on budgets and deadlines
• Keep proper co-ordination between different members of team

Confidential

Review of different Technologies for Dashboards and other Business Intelligence solutions

Reviewing different technologies, which can be used for creating Dashboards t display key KPI s Key Performance Indicators t upper management. This includes gathering requirements, project plan for in-house development of dashboards or procuring over the shelf software t d the job.

Implementation of Ticket Vending Machine for Light Rail System at HRT

Worked as project manager t see implementation of new Fare implementation policy for Light Rail. As project manager for this project main responsibility was install Ticket Vending machines on Light Rail Stations, manage vendor Key Stake holders at HRT, design sales screen on TVM, handling of credit card transactions on TVM using Metvante as service provider, provide training t users and deploy application for management of TVMs, bring system int production with disaster management plan. Project successfully completed in record 3 months.

Fluid Management System Review and Implementation

Currently HRT manages distribution of gas and Fluids t its vehicles manually. The new project is t find a solution which can manage inventory and distribution of gas / fluids and take readings from the vehicles and other assets which is very essential for managing these assets. Evaluated various solutions provided by vendors, assisted in creating RFP for bidding process. Selected Fleetwatch as preferred vendor. The current project is t manage vendors, key Stake holders at HRT, create interface between Fleetwatch and Spear t bring in the readings collected by equipment on vehicle, design and installation of Fleetwatch equipment, provide training t users, deploy application for management, bring system int production with appropriate disaster recovery management plan. Project part of new 18th Street Bus maintenance Facility. Project successfully completed.

Configuration of Spear Asset Management System for Light Rail Transit

HRT uses Spear t manage its high-value moving assets such as rail rolling stock, buses, and support fleets, as well as fixed and linear transportation assets such as support equipment, passenger terminals, track right of way, buildings and other infrastructure assets. Light rail is new addition as a service t the region. T effectively and efficiently manage assets Spear needs t be properly configured with information such as Facilities, Warehouses, Bins, Equipments, Parts, Vendors, Manufactures, Account codes, Users, Procedures etc. Design of new LRT migration system complete, configuration and testing is currently being done before bringing all the information in production. Project successfully completed after research and development over a year. Worked in capacity of project technical lead. Main responsibility included, creating infrastructure, configuring spear application t add different lines of business, data collection, data mapping and loading. Als creating procedures t move all the development efforts from development t testing and production. Creating testing procedures and move t production procedures and environment. Assisted key stakeholders going through acceptance process.

Upgrade / Data Cleanup of Spear Management System from release 2.7 to 4.2.0.4

Upgraded production system by tw major releases and several upgrade patches. It involved creating new infrastructure for new web based tools such as Equipment readings Dashboard Work Request Wheel Readings and help server. Als configured the system tables with new change data and applications, created test plans and documented steps for upgrading production system. Other major steps include introducing key stake holders with benefits of upgrades, training for users, refreshing functional users with critical components of applications and interfaces with other applications and creation of test and upgrade system.

Time Table Publisher Project

HRT currently uses printed timetables t inform users about Routes the buses would be traveling. Primary task was t inform user community and HRT upper management on what are Timetables and how they are currently created. It is completely manual process which is labor intensive and costly. The new solution was t use Time Table Publisher tool which is an open source tool completely free available from Google projects. Created dem using Google Feed Trip Planner data and created various kind of timetables in web format, pdf format. Advantages of using tool cost savings, reduced time t get timetables and generation of dynamic timetables for websites.

Map Upgrade for Hastus Management System

Hastus application was using Thomas brothers map, new maps supported were that of Tele Atlas. Provided test environment and place t plan the change in maps. Tested critical components of applications after the change. Took backup of existing system and upgraded the system with all the changes. Major task as maps are very difficult t manage in system. Test procedures and Stake holder involvement critical in managing the planned change t a 24x7 system. The whole upgrade was successfully handled. This change was critical t interface information with ACS system, which uses Tele Atlas data.

Hastus Scheduling System Failover System Design and Reconfiguration of Application

Hastus is scheduling system used by HRT t plan bus routes, schedules and services. It is used t capture hrs of bus operators and their schedules. This system is als used by dispatch t help the bus operators in case if there is change in route. It is used t record events during route. A new radi system ACS is used t record radi communication on routes. Understanding the critical nature of this application, basic infrastructure and design of application was changed. Used aliases t identify application critical parameters, changed code in ini files t manage server mapping, used URLs instead of direct mappings. Created new standby sites and applications t which the application can be moved t without doing major code changes t application infrastructure. Standby databases were created at standby sites. Tw parallel systems created which offers failover capacity and als infrastructure, which is handy for parallel use when doing major upgrade t production system. The new failover system was greatly appreciated and was critical component for this applications 24x7 nature.

Peoplesoft Upgrade Planning and Overview

Created environment t study Peoplesoft HRMS and Financials upgrade. Installed and created Dem database and instance of App server, process Scheduler and Web sever for release 8.9 Created migration database with HRT's data in it and using the template provided by Peoplesoft upgraded the system from release 8.4 t 9.0 for Peoplesoft Finance and from release 8.3 t 9.0 for Peoplesoft HRMS. Currently HRT is evaluating and testing new releases some new modules have t be configured and users have t be trained in new release. Once acceptance plan is ready all the changes will be moved t production.

Design and Configuration of New Peoplesoft Server Farm and Servers Disaster Mitigation

Created new disaster recovery model for Peoplesoft production system by creating standby application / web servers standby databases and documenting complete process of installing and recovering the production system in event of failure. These documents were very handy during couple of disasters that happened which resulted because of media failures and user errors.

Review of Operational Implementation of Handi-Ride Paratransit Program at HRT

Handi Ride is the curb-to-curb paratransit service operated by HRT that meets the requirements for complementary paratransit service from the Americans with Disabilities Act ADA of 1990. The goal of this evaluation was t develop information and data t evaluate service delivery process of Handi-Ride Para transit program by HRT that complies with the ADA. The project document included model design of the program determining the evaluability of the program identify data and analysis of data choose a research model t d the evaluation create project timelines and budget.

Recommendation of Software requirements for COTS software or development plan for Money room management

Money Room is department in Finance, which oversees collection of fares and monies from Fareboxes on bus and sales of tickets. The whole operation is manual and accounting is done on excel before the readings are put int Peoplesoft. Did analysis of work at the department and developed prototype software, which could be used t manage all the activities in that department. The model was used t evaluate over the shelf software t meet needs als presented the cost t develop system in house. Provided them process flows data flows Functional Hierarchy E-R model of system along with prototype with front end design of the system.