• Responsible for identifying database summaries, developed Data Model, NZSQL procedures for the Extract -Transform-Load (ETL) process, data mapping and business intelligence reports that were used by the end users for planning and developing annual budgets• Developed NZSQL procedures, created business object universes and reports • Developed business process models that provided clarity on business operations and roles and responsibilities in order to facilitate rapid team member onboarding. • Responsible for application review and data processing to ensure that approved data review policies and fair billing practices are programmed accurately to avoid any litigation.• Applied Unified Modelling Language (UML) for Object Oriented Analysis & Design methodologies.• Responsible for the performance and fine tuning of the databases and applications resulting in significant improvement in data processing time and reduced wait times. • Managed data migrations from the SQL server and MS Access to the Oracle database • Analyzed Secure Global Desktop application on the SUN platform in order to consolidate multiple servers and to web enable desktop applications.• Developed Cognos reports for the SharePoint dashboard for program Management team. The dashboard features include contract administration, cost control, scheduling, funds administration and management. The technologies involved are Proliance, SharePoint server, SQL server, Cognos reporting and Primavera.• Provided overall system architecture design, database management, data model design, development services for Risk Mitigation and Project Prioritization System. • Developed queries to perform Data Validation and Data Integrity testing. Identified the data quality issues and developed data cleansing strategies to provide business intelligence solutions for comprehensive reporting requests

Provided database administrator, PL/SQL developer and reporting support for environment related applications development: • Analyzed various data collection systems, gathered requirements and developed a database model using Visio and created and maintained the database, developed PL/SQL code to support web interface.• Developed Java code to support web application development and created reports for the end user using Crystal Reports.