Prashant Chopra (Canadian Citizen) - DATA ARCHITECT/SPARK

Working as Techno-functional consultant within Oracle Projects.

• Model and Object creation and performance tuning. • Change Request Development and troubleshooting user request. • Data transformations, conversion and interface, data loading • De-normalizing the tables to get obligor view as per project requirements • Developed back-end logic for business applications, e.g. views, procedures/functions, triggers. • Usages of External Tables / Partitioned Tables / Materialized views. • User Creation and privilege management. Self service DBA. • Code migration.

• Review of functional specifications. • Balancing stakeholder needs and requirements. • Coordinating with front end and testing team. • Installation of Oracle Database on Windows. • Converted data from legacy system to Oracle using SQL*Loader and PL/SQL programs. • Data transformations, conversion and interface, data loading, database modeling. • Oracle Back-end PL/SQL Development i.e. Packages, Stored Procedures, Functions & Triggers. • Ongoing maintenance & support.

• Complete ownership of the project. • Getting the documentation of the application prepared. • Planning, work allocation, tracking. • Development using SQL, PL/SQL, HTML, Oracle Application Express, Oracle Discoverer. • Created SQL*Loader scripts to load data from external system to oracle. • Developed PL/SQL (Stored Procedures & Packages) for implementing complex business logic. • Patching process across servers.

•Understanding the system requirement to formulate database design. •Design & program the GUI for all the Forms. •Programming all necessary validation checks.

•Developing course competencies and outlines. •Hiring and evaluating adjunct and contract faculty. •Teaching a wide range of technical courses. •Teaching co-faculties under Faculty Professional Upgradation programme. •Creating and Conducting programme certification exams. •Head of CA foundation mandatory Computer training.