Joseph Arul Prakash Gnanaprakasam

Support Oracle databases through multiple product lifecycle environments, from development to mission-critical production systems, for applications with data warehouse and OLTP components. Configure and maintain data servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

Support Oracle databases through multiple product lifecycle environments, from development to mission-critical production systems, for applications with data warehouse and OLTP components. Configure and maintain data servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

Gain an in-depth knowledge and understanding of client’s data sources, business model and analysis objectives. Implement Adobe SiteCatalyst and make sure the tracking requirements are met. Implementation of AEM-SiteCatalyst Integration, Tag management concepts Involve in design, development and testing of databases. Involve in SQL, PL/SQL programs development. Work on the development of PERL/ JavaScript scripting and automation.

Analysis, design, development, integration and deployment of ETL workflows. Involved in data modeling, database designing of the data warehouse to meet the business requirements. Development, Unit testing and deployment of database programs (SQL, PL/SQL). Data cleansing, Data scrubbing, Data Quality analysis and providing fixes for issues.

Involved in design, development, testing and documentation of data model, PL SQL programs, SQL programming in Oracle database. Unit testing, debugging and correcting the errors in the database programs and SQL queries so that the programs follow high quality standards and meet the requirement specifications. Performed tuning and optimization of PL SQL programs and SQL queries in Oracle 11g database.

Design, development, testing and implementation of ETL workflows using ETL tools such as SQL Server Integration Services (SSIS), Informatica 8.x to load data from different data sources into the data warehouse without any data quality issues. Designing, development and unit testing of database programs (SQL, PL SQL) in SQL Server 2005, Oracle databases with high quality of coding standards to meet the requirement specifications provided in the functional design documents.