Kallaar Kathir

Mobile: +646-***-****

admwmo@r.postjobfree.com

EXPERIENCE SUMMARY

13+ years of total experience in Analysis, design, development, and testing of various business applications using Oracle SQL and PL/SQL.

Worked extensively on various RDBMS like Oracle 11g/10g/9i/8i.

Extensive working experience in writing various modules likes functions, stored procedures, cursors (Implicit, Explicit, Ref), packages, triggers and creating tables, views and materialized views using Oracle SQL and PL/SQL.

Experience in application development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.

Proficient in Oracle tools and utilities such as PL/SQL Developer, SQL Developer, SQL Navigator.

Experience in Data Warehouse design, Data Modelling and Schema Design.

Strong understanding of data warehouse design methodologies, data structures, data modelling and RDBMS concepts.

Extensive experience in performance monitoring and tuning in Oracle.

Experience in optimization of SQL statements using SQL Trace and Explain Plan.

Experience in performance Tuning using various types of Hints, Partitioning and Indexes.

Deep understanding of Software Development Cycle (SDLC) and implemented various models like Spiral, Agile (XP, SCRUM) and Iterative models.

Proficient in transforming data from various sources (flat files, mainframe, Oracle) to Data warehouse using SQL*LOADER and External table.

Adept Knowledge in various Oracle Utilities like UTL_FILE, DBMS_SQL, SQL*LOADER, DBMS_JOB/DBMS_SCHEDULER, etc.

Implemented various Error/Exception handling methods using system defined exceptions and user defined exceptions.

Experience in Microsoft SQL Server Reporting Services (MS SSRS).

Experience in UNIX shell scripting.

Experience in No SQL (Hive SQL) and MongoDB.

Good experience in SQL Developer, PLSQL Developer, Aqua Studio.

Basic knowledge in Python scripting.

Interacted with Clients/Business partners, Project Managers to gather the Business Requirements and developed the technical specification document.

Created simple and medium complex reports in MS SSRS and oracle data base stored procedures to pull data for reports.

Excellent experience in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents.

Experience in production support, fixing production bugs and handled continuous enhancements requested from business users.

Extensive experience in integration and configuration.

Strong Trouble-shooting, Problem solving, Analytical & Design Skills.

Experience in creating Batch jobs, daily jobs, one time jobs

Excellent team player, self-motivated, will create excellent work environment around.

Good communication, Analytical and presentation skills. Ability to provide timely solutions and work within specific time frames.

TECHNICAL SKILLS

Reporting Tools : Looker, SQL Developer, SQL * Loader, SQL navigator, Aqua studio.

Database : Oracle 11g, 12C, MongoDB, Aster.

DB Utilities : SQL*Loader, Export/Import, DBMS_SQL, UTL_FILE, DBMS Package.

Languages : SQL, PL/SQL, XML, C, C++, VB Script, Java script, Python scripting

Operating Systems : UNIX, Windows NT/2000/XP

Version Control Tools : SVN, GIT Hub

Job Scheduler : Automic UC4.

PROJECT DETAILS

CLIENT: AIG Valic, TX- USA Jun 2018 – Till date

EMPLOYER: Cognizant Technology

Tech Lead – Data warehouse

Technical Responsibilities

Supporting the production environments 24/7, fixing the defects and high priority bugs.

Implementing permanent solutions for repeated issues.

Designed and Developed and maintained the complex oracle scheduler chains for the load process.

Involved in source data analysis and creating ETL design document along with the enterprise architects.

Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.

Analysed the data needs for the customized reports, identified the Mapping and generated transmitted the reports by creating various Stored Procedures, Functions and Packages.

Project Responsibilities

Worked closely with team members to share the work and helping them to resolve the issues.

Involved in Analysis, design, development, implementation and support of the enterprise data warehouse.

Responsible for preparing initial design document, effort analysis and signing off design.

Interacted with Business stakeholders, subject matter experts and Business Analyst to gather the Requirements and Business logics and mappings on scheduled basis.

Involved in documentation of User requirements and Testing of developed modules.

Created the production release and migration scripts/documents, worked closely with Data Base Administrators on production deployments.

Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.

Played an important key role in decision-making and provided valuable ideas and inputs for the success of the project.

Environment: Oracle 12c R2, EXACC, SQL Navigator, UNIX, Windows 7. MS Visio, SQL Loader, EXPLAIN PLAN.

CLIENT: HBC Digital, NYC - USA May 2016 – Jun 2018

Database Developer

Technical Responsibilities

Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and grant privileges to them.

Created stored procedures, Functions to facilitate the functionality for various complex modules.

Optimized and fine-tuned the SQL queries by using Explain plan.

Analysed the data needs for the customized reports, identified the Mapping and generated transmitted the reports by creating various Stored Procedures, Functions and Packages.

Designed and Developed and maintained the complex oracle scheduler chains for the load process.

Involved in source data analysis and creating ETL design document along with the enterprise architects.

Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.

Providing on-call support for data warehouse applications.

Involved in source data analysis and creating ETL design document along with the enterprise architects.

Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.

Performed unit testing, integration and regression testing for various applications developed in data warehouse.

Involved in helping the application teams to rewrite and fine-tuned the existing applications.

Responsible for performing code reviews and code fixing after identifying the Defects.

Creating data mapping for BI reporting and maintain data dictionaries for BI database.

Creating end user reports using Looker reporting.

Project Responsibilities

Worked closely with team members to share the work and helping them to resolve the issues.

Involved in Analysis, design, development, implementation and support of the enterprise data warehouse.

Responsible for preparing initial design document, effort analysis and signing off design.

Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.

Attend project meetings with business and status calls.

Participate in scrum calls.

Environment: Oracle 11g R2, SQL Developer, UNIX, SQL Loader, MongoDB, Python scripting, Looker.

CLIENT: CITI Bank, NYC- USA Sep 2015 – May 2016

EMPLOYER: L&T INFOTECH

Sr. Oracle Consultant

Technical Responsibilities

Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and grant privileges to them.

Created stored procedures, Functions to facilitate the functionality for various complex modules.

Optimized and fine-tuned the SQL queries by using Explain plan.

Analysed the data needs for the customized reports, identified the Mapping and generated transmitted the reports by creating various Stored Procedures, Functions and Packages.

Designed and Developed and maintained the complex oracle scheduler chains for the load process.

Involved in source data analysis and creating ETL design document along with the enterprise architects.

Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.

Involved in source data analysis and creating ETL design document along with the enterprise architects.

Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.

Performed unit testing, integration and regression testing for various applications developed in data warehouse.

Involved in helping the application teams to rewrite and fine-tuned the existing applications.

Responsible for performing code reviews and code fixing after identifying the Defects.

Project Responsibilities

Worked closely with team members to share the work and helping them to resolve the issues.

Involved in Analysis, design, development, implementation and support of the enterprise data warehouse.

Responsible for preparing initial design document, effort analysis and signing off design.

Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.

Participate in scrum calls.

Environment: Oracle 11g R2, SQL Navigator, UNIX, Windows 7. MS Visio, SQL Loader, EXPLAIN PLAN.

CLIENT: AIG Valic, TX- USA Apr 2011 – Sep 2015

EMPLOYER: MPHASIS CORP

Sr. Oracle PL/SQL Developer

Technical Responsibilities

Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and grant privileges to them.

Created stored procedures, Functions to facilitate the functionality for various complex modules.

Optimized and fine-tuned the SQL queries by using Explain plan.

Analysed the data needs for the customized reports, identified the Mapping and generated transmitted the reports by creating various Stored Procedures, Functions and Packages.

Designed and Developed and maintained the complex oracle scheduler chains for the load process.

Involved in source data analysis and creating ETL design document along with the enterprise architects.

Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.

Performed unit testing, integration and regression testing for various applications developed in data warehouse.

Involved in helping the application teams to rewrite and fine-tuned the existing applications.

Supporting the production environments 24/7, fixing the defects and high priority bugs.

Responsible for performing code reviews and code fixing after identifying the Defects.

Project Responsibilities

Worked closely with team members to share the work and helping them to resolve the issues.

Involved in Analysis, design, development, implementation and support of the enterprise data warehouse.

Responsible for preparing initial design document, effort analysis and signing off design.

Interacted with Business stakeholders, subject matter experts and Business Analyst to gather the Requirements and Business logics and mappings on scheduled basis.

Involved in documentation of User requirements and Testing of developed modules.

Created the production release and migration scripts/documents, worked closely with Data Base Administrators on production deployments.

Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.

Played an important key role in decision-making and provided valuable ideas and inputs for the success of the project.

Environment: Oracle 11g R2, SQL Navigator, UNIX, Windows 7. MS Visio, SQL Loader, EXPLAIN PLAN.

CLIENT: Astra Zeneca – Sweden Sep 10 – Mar11

EMPLOYER: INFOSYS TECHNOLOGIES LTD

Oracle PL/SQL Developer/Analyst

Technical Responsibilities:

Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.

Created Data Structures including Tables and Views, and applied referential integrity.

Participated in designing of data conversion/interface with the use of SQL*Loader.

Created Form level objects i.e. Libraries, property classes.

Created Triggers, Stored Procedures, Packages and SQL Scripts.

Worked in the Production Support team and fixed high priority bugs.

Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and granted privileges to them.

Performed unit testing and integration testing for various development applications in ORACLE 10g.

Project Responsibilities:

Involved in documentation of User requirements and Testing of developed modules.

Environment: Oracle 10g, PL/SQL, SQL Developer, Windows XP, UNIX shell scripting.

CLIENT: FimBank p.l.c, Malta Sept 08 – Aug 10

EMPLOYER: ORACLE FINANCIAL SERVICES

Oracle PL/SQL Developer

Technical Responsibilities:

Developed PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.

Designed and created all the required tables, indexes, sequences and views using SQL*Plus and Toad.

Involved in developing Object data types and collections.

Developed various Complex Queries, Views for Generating Reports.

Used Hints to Achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports.

Written SQL scripts for implementation.

Developed and Tested applications for loading inventory data into database tables.

Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.

Involved in Unit testing PL/ SQL Stored Procedures and Functions.

Extensively used PL/SQL Procedures and Functions to transform data before the loading process.

Optimizing database objects and streamlining applications.

Project Responsibilities:

Responsible for Study, Analysis, Design, Development/Customization and Testing/debugging of the reports.

Involved in day to day interaction with end user in understanding the requirements.

Perform analysis of key requirements and transfer knowledge accordingly to the end users

Involved in quality assurance of data, automation of processes, programming for data manipulation validation of programming, and presentation of results.

Created detailed user manual for handing over the module to business.

Environment: RAD, Oracle 10g, Oracle Application Server 10g(10.3.1.3),IBM Web Sphere, Altova XML Spy, Microsoft Visual Studio6.0, Java and Java Scripts.

CLIENT: NexAge Enterprises, Malaysia Jun 06 - Sep 08

EMPLOYER: ARIZON TECHNOLOGY SOLUTIONS

Oracle PL/SQL Developer

Technical Responsibilities:

Developed and modified database triggers, cursors, procedures, functions and packages to meet business requirements.

Developed back-end PL/SQL code to implement business rules through triggers, procedures, functions, and packages using SQL Developer.

Optimized and tuned PL/SQL to reduce the loading process - Utilized SQL*Loader to perform bulk data loads into database tables from external data files.

Created and maintained development environment, resolved Production and validated Environment problems.

Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer

Developed and deployed the Reports using Oracle Reports.

Detected and Corrected bugs during system integration and user acceptance testing.

Mapped the source and target databases by studying the specifications and analysed the required transforms.

Technical Responsibilities:

Involved in direct discussion with the Functional/End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.

Involved in Planning, Implementation, Testing, and Documentation.

Responsible for the development and maintenance of end-user documentation.

Environment: Oracle 9i/10g, Oracle Reports & Forms 6i/9i/10g, PL/SQL, EXPLAIN PLAN

Contact this candidate