Janakiraman M
Kattankulathur,TN
Summary
Over 8 years of experience in designing, developing, implementing and testing database applications and solutions as Oracle PL/SQL Developer.
Thorough SQL Developer with expert grasp of SQL code generation, analytics, reporting and business intelligence. Diverse knowledge of complex T-SQL coding instances. Conversant in up-to-date and legacy programming languages, standards and tools. Adept in leading all stages of software development and troubleshooting.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Oracle PL/SQL Developer
G6 Technology
07.2020 - Current
- Involved in understanding the technical direction of the programming staff from a back end database design and development perspective.
- Developed Linux Shell/SQL Scripts for data extraction, transformation and to load on staging tables.
- Developed PL/SQL Procedures/Functions/Packages to load data into Dimension and Fact tables.
- Improved data warehouse's performance by implementing advanced Oracle Data Warehousing features: Materialized Views, Partitioning, External Tables, Dimensions, Parallel Execution.
- Worked with Production Support team to immediately resolve failures in production data processing. Collaborated with business users on
resolving data inconsistency and reporting issues.
- Used SQL*Loader and created the External Tables in order to load data from flat files into oracle tables.
- Extensively used Bulk Collect and FORALL statements for manipulating the large amount of data and enhance performance.
- Wrote complex SQL queries using joins and sub queries to retrieve data from the database. Also made use of set operators like Union, Union all, Intersect and minus.
- Responsible for performance tuning using Explain plan, TKPROF and oracle Hints. Used Table Partitioning in huge Table to increase database performance.
- Responsible for Import and Export of database objects as per requirement. Also used DB LINKS for accessing data across different databases.
- Used 'SQL Navigator' IDE for developing and managing Pl/SQL
scripts.
- Used Bitmap, B-Tree Index and functional based Index to enhance
performance to retrieval Data from database table.
- Handled errors using system defined exceptions and user defined exceptions.
- Optimized and enhanced the existing procedures and SQL statements for the better performance.
- Attended walk through, Code review and Status meeting to discuss the status of the project.
Oracle PL/SQL Developer
Novac Technology Solution
02.2019 - 06.2020
- Involved in understanding the technical direction of the programming staff from a back end database design and development perspective.
- Developed procedures, functions and packages to implements the business Requirement using PL/SQL.
- Created Dynamic SQL script in PL/SQL to build SQL statements dynamically at runtime.
- Used SQL*Loader and created the External Tables in order to load data from flat files into oracle tables.
- Extensively used Bulk Binding and Collections for manipulating the large amount of data and enhance performance.
- Wrote complex SQL queries using joins and sub queries to retrieve data from the database. Also made use of set operators like Union, Union all, Intersect and minus.
Oracle PL/SQL Developer
Wondersoft Private
01.2016 - 12.2018
- Analyzed the business requirements of the project by studying the Business Requirement Specification document.
- Installed and upgraded oracle database server.
- Migrated database from DB2 and MS Access to Oracle Database.
- Created/Modified tables, views, queries for new enhancement in the application using TOAD.
- Created/Modified database objects like packages, procedures, functions, and triggers and handled errors using Exceptions.
- Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client.
- Created indexes on the tables for faster retrieval of the data to enhance database performance.
- Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
- Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL*Loader.
- Used PL/SQL Wrap Utility to encrypt PL/SQL source code and to make the code portable to any platform.
- Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
- Created and modified several UNIX shell scripts/ Dos Batch files according to the changing needs of the project and client requirements.
Education
Master of Science - Computer Engineering
University of Bridgeport
Bridgeport, CT (USA)2010
Post Graduate Diploma in Computer Application - Computer Application
Guru Nanak Dev University
Punjab, India2005
Bachelor of Science - Computer Application
Guru Nanak Dev University
Punjab, India2004
Skills
- Oracle PL/SQL specialist
- Experience in using SQL Navigator, TOAD for Oracle, SQL Developer, and Eclipse developing tools
- Experience with working on Harvest(CA Software Change Manager), PVCS VM, and Git Version Controls
- Advanced knowledge of various databases such as Oracle, MS Access, and Teradata
- Working knowledge with DB Tools/Utilities like OM,SQL*ELoader,Explain Plan, TKPROF, Import/Export, and EXPDP/IMPDP
- Advanced knowledge of Linux Shell Scripting
- Data Warehouse ETL design knowledge
- Advanced problem solving skills
- Troubleshooting and debugging
- Performance and scalability optimization
Certification
- Oracle Advanced PL/SQL Developer Certified Professional
(1Z0-051,1Z0-147,1Z0-146) - Oracle Certified Associate, Oracle Solaris 10 Operating System (1Z0-876)
Timeline
Oracle PL/SQL Developer
G6 Technology
07.2020 - Current
Oracle PL/SQL Developer
Novac Technology Solution
02.2019 - 06.2020
Oracle PL/SQL Developer
Wondersoft Private
01.2016 - 12.2018
Master of Science - Computer Engineering
University of Bridgeport
Post Graduate Diploma in Computer Application - Computer Application
Guru Nanak Dev University
Bachelor of Science - Computer Application
Guru Nanak Dev University
Similar Profiles
Chikere SayersChikere Sayers
G6 Information Technology Support at Army Cybersecurity G6G6 Information Technology Support at Army Cybersecurity G6
Adreann MarshAdreann Marsh
HelpDesk Tier II Support at AvMC, G6 ServicesHelpDesk Tier II Support at AvMC, G6 Services
Larry Joe WoodsLarry Joe Woods
Shared Services Representative at G6 Hospitality LLCShared Services Representative at G6 Hospitality LLC