Sr Consultant

Summary

Hari has more than 24 years of work experience in information technology encompassing operations systems designs and integration users support training programming and project management. Award-winning MAXIMO 7 and 6-Certified Professional with extensive CMMS MAXIMO data modeling data migration and systems analysis skills in their implementation and support including development and maintenance of complex software applications and interfaces using MAXIMO Enterprise Adapter.

Hari is a proven team builder and a trainer with excellent people skills. Strong project management communication and collaboration skills. Effective liaison with user groups and customers.

Work Experience

Confidential

Functional Lead Work Management Amtrak

Responsible for requirement gathering design and implementation of Maximo 7 as part of Strategic Asset Management System Project at Amtrak. Further responsibilities included guidance to and supervision of team members and providing valuable input to cross teams from the stand point of Project s overall implementation goal including materials Management Finance and Resources.

Additionally designed reviewed and helped execute test scripts in the various stages of testing and deployment.

Principal Investigator Confidential

As a principal Consultant and Investigator conducted a Maximo upgrade feasibility study for Scotia Gas Networks in UK to upgrade its existing version of Maimo to version 7.1 with Linear Asset module and recommended an optimum upgrade strategy.

Trainer Actuate Report Writing Confidential

Trained a group of seven in-house Maximo Engineers in Confidential

on report writing using Actuate version 8.

MAXIMO Upgrade and Migration Project

Upgraded MAXIMO systems from prior versions 3.x and 4.x to MAXIMO 5.2 for BP sites. Created technical specification design strategy and planning for the conversion and upgrade of projects. Developed and standardized scripts for MAXIMO upgrade projects. Other activities included data gathering formatting conversion and merging MAXIMO systems at different sites with one central MAXIMO system.

Project Manager/Trainer MAXIMO Practice Building Project Confidential

Set up a Center of Excellence for MAXIMO operation in Bangalore India. Identified screened hired and trained eight participants some new college graduates with little or no industry experience on MAXIMO 6.2 during a 4-month period. During this time taught classes in classroom setting and remotely over the Internet. At the end of the program after 4 months of training all eight candidates were IBM-certified scoring 89 percent or higher.

MAXIMO Implementation and Production Support Project Confidential

Energy Provided expertise in implementation of MAXIMO projects in technical specification design strategy and planning. Provided expertise in issue resolution and production support during post-go-live support initiative. Supported ongoing MAXIMO production support.

MAXIMO Upgrade and Migration Project

Upgraded MAXIMO systems from prior versions 3.x and 4.x to MAXIMO 5.2 for BP sites. Created technical specification design strategy and planning for the conversion and upgrade of projects. Developed and standardized scripts for MAXIMO upgrade projects. Other activities included data gathering formatting conversion and merging MAXIMO systems at different sites with one central MAXIMO system.

Confidential

Senior Consultant

Data Migration Project

Worked on a data conversion and migration project for Analysts Inc. to merge BP s oil sample s lab test data with that of Analysts Inc. Guided Analysts Inc. throughout the data migration process.

Developed and executed data migration scripts and validated migrated data. Performed DBA s duties and responsibilities including export and import backup and recovery of Oracle database and installation and maintenance of Oracle 10g database in Linux version of UNIX Fedora 4.x .

SAP-BW/SAP R/3 Project

Defined designed developed and maintained reports queries and workbooks using BW-reporting variables and navigational attributes calculated and restricted key figures and conditions for the queries to meet business requirements.

Defined and developed Logistic Cockpit and generic data extraction processes for loading transaction and master data from SAP R/3 and legacy system.

Designed enhanced maintained and implemented standard and customized infocubes ODS objects infosources infoobjects infopackages transfer and update rules and loaded data into infocubes and ODS for other applications and reporting for FICO and SD modules.

Other tasks included datasource enhancements Logistics Cockpit configuration and customization data load management event processing and reporting optimization GL postings verification account posting and reversal through SAP front end and scheduling SAP batch jobs.

Confidential

Consultant

MAXIMO Implementation Project Confidential

Data collection manipulation conversion upload and implementation of an inventory and asset management system using MRO s MAXIMO EAM application.

Responsible for developing scripts for building and uploading necessary data elements for locations chart of accounts storeroom item catalog inventory asset currency ship to vendors and other master data required for implementing the project.

Migrated open POs and requisitions from legacy procurement system to MAXIMO. Developed and implemented an interface between legacy procurement systems and MAXIMO. Designed database structure and a detailed data model both logical and physical necessary for the interface. Developed test cases and tested interfaces and functionality around the MAXIMO project implementation. Performed troubleshooting analyzed and resolved end-user issues in functional and technical areas. Extracted and uploaded master data to MAXIMO System from SAP R/3 systems on a regular basis.

Procurement System Migration Project Confidential

• Received an Outstanding Performance award.
• Upgraded and migrated KBR s procurement system from its Advantage Server-based legacy system to the SQL Server enterprise-based system.
• Built various interfaces using Visual Basic Microsoft Access PL/SQL in Oracle environment and TSQL in SQL Server environments.
• Gathered functional and technical requirements built specifications and implemented a corporate database automation tool as a central data warehouse. Extracted most of the data feed from SAP R/3 4.6 and 4.7 systems which were then consumed by other applications.
• Provided application production support including DBA-related support work which included database backup and refresh and recovery creating databases schemas and users and granting and revoking user permissions.

Procurement System Support.

Provided technical and functional support to end users MCS Buyer in procurement process from requisitioning to receiving.

Collected master data from SAP R3 and SRM systems and transformed and uploaded to procurement system.

Verified and validated master data e.g. WBS elements header activity GL accounts vendor ship-to addresses bill-to addresses UOM item catalog and currency in SAP R3 systems before setting them up in the procurement system.

Confidential

Technical Team Lead

• Led the design of structural changes maintenance and support data conversion migration and upgrade of Lawson ERP and interface applications in Oracle/UNIX environment. Involved in the design of the overall structure of the system and defined member structure necessary for data storage and reporting on a Hyperion s Essbase Data Warehouse project.
• Installed and upgraded database systems defined and configured instances and tablespaces and linked servers created tables indexes constraints triggers and stored procedures designed and implemented database roles and security and access privileges DBMS and SQL tuning database backup and restore data repair and problem analysis using DBA tools migrated database to new platforms and imported and exported databases.
• Prepared application design documents and specifications AFE Expenditure Notification System and Workflow Completion Report Systems including preparing logical and physical model and creating databases.
• Carried out extensive requirements gathering designed database schema and normalized tables. Developed enhanced and maintained applications at corporate level and provided nationwide user support to system-critical applications including Lawson ERP System. Major applications developed and/or enhanced and supported included Activity Workflow System and Notification System.
• Developed Shell scripts for Lawson system management database management export import and backup and running and scheduling batch jobs automatically through Crontab and Sysadmiral schedulers. Developed interfaces and applications to interface with Lawson Financial s activity and GL/SL modules using COM and OCX components on both UNIX and Windows platforms using Shell scripts and VB6.
• Worked on a data conversion and Lawson upgrade project from previous version to Lawson 8.0.3 in UNIX environment using SQL loader and UNIX scripting extensively. Worked on Oracle-to-SQL server conversion project. Provided user support to Activity Management and GL/SL modules of Lawson application.
• Guided other team members in developing and maintaining Activity Management reports using Crystal reports on both Oracle and Microsoft and SQL Server environment. Assisted other team members in training knowledge transfer troubleshooting with Microsoft and SQL Oracle Visual Basic UNIX Shell scripting and reports.

Confidential

Sr. Consultant

Oracle DBA/Developer Retail Rent Calculation System Project Shell Services International

• Developed a database application Retail Rent Calculation System in a client/server environment to determine rents for lessee dealers using full life-cycle model from requirement analysis to deployment using Oracle developer forms reports Shell scripts Pro C C on UNIX and Windows platforms
• Responsible for maintaining enhancing and providing user support to Automated Rental Management System ARMS ..
• Generated ER-Diagram and Data Dictionary using ERwin.
• Performed duties of UNIX system administrator and Oracle DBA in close association with senior UNIX administrator and Oracle DBA. Configured instances and table spaces and defined schemas and tables clusters and indexes.
• Other tasks included determining storage requirement implementing constraints and triggers analyzing tables and indexes at regular intervals tuning and implementing user security through roles and privileges automating daily processes using Appworx UNIX Scheduler documenting installing and upgrading migrating and performing maintenance and troubleshooting.
• Developed Shell scripts for processing data files creating data backups managing system resources and running batch jobs. Converted from 3.0 to version to 4.5 and 5.0 GUI-based versions in a MDI environment. Created interfaces using Shell and SQL scripts to feed rental transactions to SAP for processing. Created user and technical manuals.

Confidential

System Manager

Responsible for managing and directing ATSER s Systems Division and day-to-day operation. Responsible for writing proposals conducting technical presentations soliciting projects from clients evaluating clients existing systems and developing software. Worked as a project lead on a database application developed to automate the construction project management process for the Street and Bridge Division City of Houston. Used Visual Basic PowerBuilder and Access. Developed Dispatch-IT application designed to automate task assignments personnel dispatch and invoicing for in house using VB and Access. Supervised and coordinated coding among four programmers and assigned duties and responsibilities.

Confidential

Consultant

Developer Billing System.

Designed developed and deployed billing system application in an n-tier client/server environment including writing complex billing reports using complex stored procedures packages and triggers.

Developer Invoice and Inventory System.

Designed and developed an invoicing and inventory system to keep track of transactions quantities in stock shipments and client information using UNIX C Oracle Pro C and Shell scripting.

Confidential

Research Assistant

Worked on a GIS project using ArcInfo and ArcView to develop a GIS database of coal combusted in Midwestern United States power plants.

Confidential

Consultant

Application Developer and Programmer

Developed an accounting and invoicing application for Media South Asia Nepal using dBase III and C. Taught courses in C programming to groups of engineers and other professionals.

Confidential

Mines Manager Responsible for planning and managing day-to-day mining operations of an underground lead-zinc mine located at 14 500 ft above sea level. Supervised more than 300 mine workers comprising assistant engineers foremen and other crew members.

Site Engineer and Database Developer Developed an inventory system using dBase III for maintaining inventory of mining equipment and parts. Designed and implemented laying of underground track/locomotive system for the removal of underground debris.

Key Skills

• Proficient in Maximo EAM system from its upgrade to implementation and support from versions 4.x to 7.1
• Experienced with many functional aspects of SAP including MM PM Purchase Sales and distribution and FICO/General ledger.
• Proficient in Lawson Financial Software and SAP/BW
• Strong knowledge of software and application development life cycle.
• Thorough knowledge of data analysis data modeling RDBMS system architecture data warehousing and business warehousing and ETL processes.
• Proficient in Oracle SQL Server/Sybase development as well as database administration of both Oracle and SQL Server including backups recovery imports exports migrations performance tuning and upgrades
• Experienced in design development implementation and maintenance of database applications and databases on UNIX and client/server environment.
• Experienced in UNIX Shell scripting programming in C Fortran Java Script VB ASP and Java.
• Platforms Various versions of Windows Unix and Linux