Looking for a job

John A

@johna1

Senior ERP implementation consultant at Independent IT Consulting, delivering enterprise ERP systems and a centralized billing platform across 80+ branches.

India

Message

At Independent IT Consulting / Enterprise Solutions, I direct ERP implementations and modernization projects, translating business requirements into enterprise systems. For a manufacturing and construction client, I guide the rollout of a modular ERP spanning engineering, procurement, production, finance, and HR.

I designed and executed a centralized ERP and billing infrastructure for Uttaradi Math across 80+ branches, including inter-branch fund transfers and consolidated financial reporting. I also architected ReachMyMovie, a digital contracting platform for box-office collections and distribution agreements.

At International Integration Incorporated (I3), I served as Database Architect and Lead DBA for the US Navy Allotment Accrual Accounting System. I handled database architecture through testing and user acceptance, and trained client engineering teams in database optimization and SQL tuning.

Earlier, I delivered financial and manufacturing modules at Logica Systems and implemented an HRIS at The Vysya Bank Ltd. I also authored the 'SQL in 6 Days' learning platform, with a textbook, video lectures, and an interactive practice lab.

Experience

Work history, roles, and key accomplishments

Current

Solution Architect & Senior ERP Implementation Consultant

Current

Independent IT Consulting / Enterprise Solutions

Jun 2000 - Present (26 years 4 months)

Lead enterprise-wide IT modernization, ERP implementations, application architecture, and business process re-engineering for commercial corporations, financial institutions, media firms, public limited companies, and non-profit/religious organizations. Oversee project teams across full software lifecycle, ensuring stringent governance, requirement compliance, and high availability.

ERP Implementation Oracle APEX SQL Pl SQL Database Architecture SDLC Agile Waterfall Business Requirements Gathering Solutions Architect Data Migration ETL Change Management Stakeholder Management Risk Assessment Quality Assurance

Senior Database Architect & Consultant

International Integration Incorporated (I3)

Nov 1997 - May 2000 (2 years 6 months)

Served as Database Architect and Lead DBA for the US Navy Allotment Accrual Accounting System (PX02/04 Project), managing mission-critical financial accounting databases. Executed complete lifecycle database architecture, from logical and physical data modeling to data administration, system testing, and final User Acceptance Testing (UAT).

Database Architecture Data Modeling SQL Pl SQL DBA UAT Query Tuning Transaction Integrity

Senior Database Consultant

Constellation Inc.

Feb 1997 - Oct 1997 (8 months)

Directed database administration and architecture for enterprise systems; engineered data schemas to support high-throughput transaction processing. Assisted application development groups with advanced PL/SQL programming, stored procedure optimization, and database performance tuning during design and UAT phases.

Database Administration Pl SQL SQL Performance Optimization Stored Procedures Data Modeling

Project Leader & Systems Analyst

Logica Systems

Jan 1996 - Jan 1997 (1 year)

Led engineering teams across complete design, development, and deployment phases for core financial and manufacturing control modules. Designed and delivered key modules including Trial Balance Reporting, Job Order Planning, General Ledger (GL) printing, job scheduling priority engines, and Subcontracting controls.

Project Management Financial Systems Manufacturing Control General Ledger Accountant job scheduling Subcontracting

Oracle Database Consultant

Constellation Inc.

Sep 1995 - Dec 1995 (3 months)

Debugged, optimized, and modified legacy Pro*C applications and PL/SQL scripts to ensure peak performance. Engineered custom DBA maintenance scripts for table defragmentation, index rebuilding, and storage optimization.

Oracle Pro*C Pl SQL Database scripting Performance Optimization Database Maintenance

Systems Analyst & Software Engineer

The Vysya Bank Ltd.

Jul 1992 - Sep 1995 (3 years 2 months)

Architected and implemented a comprehensive Human Resources Information System (HRIS) automating bank-wide employee record management. Automated critical modules including personnel appointments, transfers, performance evaluations, annual travel/halting allowance (TA/HA), and leave fare concession (LFC) comparative reporting.

HRIS System Architecture Automation Employee Records Reporting

Faculty Leader & Software Developer

NIIT Ltd.

Jul 1989 - May 1992 (2 years 10 months)

Developed automated course scheduling systems for NIIT training centers; led a faculty team of IT instructors. Engineered Procurement Analysis System and Telephone Information System for Oil and Natural Gas Corporation (ONGC).

Scheduling Team Leadership Procurement Analysis System Development