My Work
Over the past 12 years, I have worked on various kinds of projects and products - ranging from reporting systems to enterprise intranet applications and desktop tools to database re-engineering involving ETL to ODS systems; And across multiple domains - ranging from banking to HR to equity mutual funds to location surveillance and now telecom billing. A summarized view of the work I have done till date -
- Developed regulatory reporting module for a banking product using Oracle Forms and Reports and Oracle 8i and later Oracle 9i. The module had close to 150+ odd reports of varying degree of complexities.
- Designed and developed a payroll system in ASP 3.0 and Oracle 9i for a US based manpower consultancy firm.
- Created a site scrapping tool in C# 2.0.
- Developed a careers website in sHTML/Javascript/Flash and Actionscript 3.0. Also integrated Mapquest API.
- Designed and developed a leadership succession planning application using ASP.NET, C# 2.0, Oracle 10G.
- Re-engineered a Sybase database into Oracle Database 11G. This project involved creating completely new data models in Oracle database, data analysis of the Sybase data models, creating mapping between source and target systems using INFORMATICA and then PLSQL to massage and cleanup the data. The code conversion was also done manually using the latest features of Oracle keeping in mind the performance requirements of the application. The database size ran into multiple terabytes.
- Architectured, designed and developed the database for a Location Based Surveillance product using Oracle 11G. Designed and implemented data archival and backup strategy, implemented data encryption.
- Architectured, designed and developed the database for another Location Based Surveillance product using MYSQL 5.0.
- Currently handling a telecom interconnect billing platform that uses Oracle Apex 4.1 and Oracle Database 11G.
