RDBMS - 18 Years Experience
Oracle
PL/SQL
Pro*C
Pro*Cobol
Application Development of
E-Governance Platform for
California State Govt Welfare System.
Worked for Deloitte Consulting; developed World’s Largest E-Governance suite of applications for automating California State Government Welfare System; built on 5-tier Client/Server architecture with RDBMS Oracle as 5th tier back-end datastore.
Product Development and Maintenance (PDM) of ERP/SCM WEB Platform
Delivered multi-tier Client/Server ERP (Enterprise Resource Planning) and Web based SCM (Supply Chain Management) products suite of JDA Software (now Blue Yonder; earlier Manugistics); used Oracle as back-end data store. Developed this products suite for ERP/SCM functions “Contract Manufacturing”, “Sequencing” and “Optimized Supply Chain Planning” for Global Manufacturing and Retail industries.
Sybase T-SQL
Application Development and Management (ADM) of
Trading Platform of JPMC
Delivered Application Development and Management (ADM) program, of Accenture, of Derivatives Trading Platform for Investment Banker JP Morgan Chase (JPMC). This Trading Platform was built on Process Driven, Peer-To-Peer, Publish / Subscribe, Event-Broker and one way up-stream / down-stream architectures. Sybase was used as data store as well as for implementing Publish / Subscribe and Event-Broker architectures.
Microsoft
SQL Server
Application Development of
CORE/Retail Banking Platform for
Bank of Ireland (BOI).
Delivered Application Development (AD) program, of Perot System (now NTT Data), of Enterprise CORE / Retail Banking applications suite for Bank Of Ireland (BOI), built on 6-tier Client/Server architecture. Developed branch office application server on 3-tier Client/Server architecture, PowerBuilder and Microsoft Technologies with Microsoft SQL Server as 3rd tier database server. Central application server was built on 2-tier Client/Server architecture on IBM Mainframe Technologies. Each branch office application server was connected to central application server through IBM MQ Series.
Product Development and Maintenance (PDM) of Cloud Platform for US Healthcare
Delivered Cloud based SaaS products suite of Edifecs Technologies for USA Healthcare industry; built on 5-tier Client/Server architecture with Microsoft SQL Server as 5th tier back-end database server. Developed this products suite for USA healthcare transaction test management that was critical for healthcare insurance policy design decision mechanism.
MySQL
RedShift
BigQuery
Re-engineering of MarTech / Digital Marketing Cloud Platform
Product Development and Maintenance (PDM) of EduTech Cloud Platform
Delivered Cloud based SaaS / DaaS products suite of True Influence for Global Digital Marketing industry; built on 4-tier Client/Server architecture with MySQL and Amazon RedShift as back-end database server and Google BigQuery as database server for Data Science / Analytics. Developed this products suite for Market Intelligence, Account Based Marketing (ABM) and Content Syndicated Marketing Lead Management.
Delivered Cloud based SaaS product of Serosoft for Global EduTech industry; built on 4-tier Client/Server architecture with MySQL as back-end database server. Developed this product for Student Information System management for schools, colleges and universities across the globe.
IBM DB2
Application Development of
CORE/Retail Banking Platform for
Bank of Ireland (BOI).
Delivered Application Development (AD) program, of Perot System (now Dell Services), of Enterprise CORE / Retail Banking applications suite for Bank Of Ireland (BOI), built on 6-tier Client/Server architecture. Developed branch office application server on 3-tier Client/Server architecture using PowerBuilder and Microsoft Technologies. Central applications server was built on 2-tier IBM Mainframe (MVS, Cobol) / DB2 technologies. All branch office application servers were connected to central application server through IBM Middleware MQ Series.