Now you can Instantly Chat with Dharmaraj!
About Me
Seeking a position to utilize my skills and abilities that offers professional growth while being resourceful, innovative and flexible. To work in a challenging environment that provides me very good opportunities for growth and development....
Show MoreSkills
Portfolio Projects
Description
• Involved in understanding the technical direction from backend database design and development perspective.
• Developed UNIX/SQL Scripting.
• Developed PLSQL Procedures/Functions/Packages to achieve business requirements.
• Handled errors using system defined and user defined exceptions.
• Worked in PLSQL Collections and records.
• Used SQL*Loader and External Tables in order to load the data from flat files and enhance performance.
• Extensively used BULKCOLLECT and FORALL statement for manipulating the large amount of data to enhance the performance.
• Responsible for performance tuning using explain plan, TKPROF, Oracle Profiler and Oracle Hints. Used table partitions for huge tables to increase the performance of database.
• Used Bitmap, Btree, Function based Index to enhance the performance of data retrieval.
• Used Bitmap, Btree, Function based Index to enhance the performance of data retrieval.
• Wrote SQL queries using JOINS and SUB Queries to retrieve data from database also used Set Operators like UNION, UNIONALL, and Intersect and minus.
• Created UI using Oracle Forms and Reports.
• Worked with production support team to immediately resolve failures in production data processing. Collaborated with business users to resolve the data inconsistency and reporting issues.
• Optimized and enhanced the existing procedures and SQL statements for better performance.
• Attended code walkthrough, Code review and status meeting to discuss the project status.
Description
Currently Working as Associate in Cognizant, Chennai, India. My role involved in Debugging and resolving business critical Issues and database performance issues, my responsibilities also requires continuous interaction with business team to gather gathering the requirements, creating design document preparing unit test case document, creating traceability matrix, bug tracking, working towards deliverables.
Show More Show LessDescription
• Involved in understanding the technical direction from backend database design and development perspective.
• Developed UNIX/SQL Scripting.
• Developed PLSQL Procedures/Functions/Packages to achieve business requirements.
• Handled errors using system defined and user defined exceptions.
• Worked in PLSQL Collections and records.
• Used SQL*Loader and External Tables in order to load the data from flat files and enhance performance.
• Extensively used BULKCOLLECT and FORALL statement for manipulating the large amount of data to enhance the performance.
• Responsible for performance tuning using explain plan, TKPROF, Oracle Profiler and Oracle Hints. Used table partitions for huge tables to increase the performance of database.
• Used Bitmap, Btree, Function based Index to enhance the performance of data retrieval.
• Used Bitmap, Btree, Function based Index to enhance the performance of data retrieval.
• Wrote SQL queries using JOINS and SUB Queries to retrieve data from database also used Set Operators like UNION, UNIONALL, and Intersect and minus.
• Created UI using Oracle Forms and Reports.
• Worked with production support team to immediately resolve failures in production data processing. Collaborated with business users to resolve the data inconsistency and reporting issues.
• Optimized and enhanced the existing procedures and SQL statements for better performance.
• Attended code walkthrough, Code review and status meeting to discuss the project status.
Description
Involved in understanding the technical direction from backend database design and development perspective.
• Developed UNIX/SQL Scripting.
• Developed PLSQL Procedures/Functions/Packages to achieve business requirements.
• Handled errors using system defined and user defined exceptions.
• Worked in PLSQL Collections and records.
• Used SQL*Loader and External Tables in order to load the data from flat files and enhance performance.
• Extensively used BULKCOLLECT and FORALL statement for manipulating the large amount of data to enhance the performance.
• Responsible for performance tuning using explain plan, TKPROF, Oracle Profiler and Oracle Hints. Used table partitions for huge tables to increase the performance of database.
• Used Bitmap, Btree, Function based Index to enhance the performance of data retrieval.
• Used Bitmap, Btree, Function based Index to enhance the performance of data retrieval.
• Wrote SQL queries using JOINS and SUB Queries to retrieve data from database also used Set Operators like UNION, UNIONALL, and Intersect and minus.
• Created UI using Oracle Forms and Reports.
• Worked with production support team to immediately resolve failures in production data processing. Collaborated with business users to resolve the data inconsistency and reporting issues.
• Optimized and enhanced the existing procedures and SQL statements for better performance.
• Attended code walkthrough, Code review and status meeting to discuss the project status.