Ashok Kumar

Overall 8 years of professional experience in IT industry. 5 years of experience in Oracle SQL/PLSQL developer. Involved in SDLC (Software Development Life Cycle) from analysis, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Expertise in using DDL, DML, DCL, TCL Statements of Oracle SQL.

Design, develop and maintain oracle database objects such as tables, views, synonyms, sequences and indexes. Strong knowledge in writing complex queries which includes Joins, sub query, Group functions, set operators and analytical function. Extensive experience in SQL*LOADER and batch processing.

Developed

Complex database objects like Stored Procedures, Functions, Packages and Triggers using PL/SQL. Extensively used Cursor to fetch multiple records from table inside the pl/sql block and Exceptions to handle error.

Experience in application development using various advanced features of Oracle like Collections, Autonomous Transactions and Exception handling. Having knowledge in Bulk Collections (FORALL, LIMIT, Bulk Exceptional handling) for better Performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines. Performed PL/SQL Performance Tuning (Explain Plan, Index, Hints and Table Partition).

Extensively used Jasper Report for generate GRN, DN, IN reports designing retrieve data from the database. Having knowledge in Materialized view, Ref_Cursors, Dynamic SQL and Global Temporary Table.

Having

Experience in Debugging by using Error Log.

Senior Software Engineer at Wipro Technologies (2022-10 – Present)

• Working as a PLSQL Lead Database Developer for database layer in enterprise commissioning project
• Responsible for sole database layer which interacts with various upstream and calculates commission for dealers in postpaid domain
• Leading a team of 16 people and responsible for High level design, Low Level Design, AID walkthrough, Feature delivery, technical and functional support, Client UAT Demo and usual business operations for database layer
• Involved INCA API configuration and debugging java code
• Playing a pivotal role in ensuring automated database deployment process for all features/defects and business deliveries

PL/SQL Developer at Wipro Technologies (2022-10 – 2024-03)

• Analysed the business requirements of the project by studying the Business Requirement Specification document
• Design the ETL process, which involves mapping the data flows, transformations, and loads between the source and the target
• Define the data models, schemas, and metadata for the target system, as well as the data validation and error handling rules
• Develop the ETL code, which involves writing the scripts, queries, or programs that execute the ETL process
• Test the ETL solution, which involves verifying that the ETL code works as expected, that the data is transformed and loaded correctly, and that the performance and quality metrics are met
• Perform various types of testing, such as unit testing, integration testing, and user acceptance testing
• Deploy the ETL solution, which involves moving the ETL code and related files from the development environment to the production environment
• Maintain the ETL solution, which involves tracking the performance, quality, and reliability of the ETL process, as well as resolving any issues or incidents that may arise

Process Associate at Accenture Solutions Pvt Ltd (2014-07 – 2018-07)

PL/SQL Developer at Canon (2017-03 – 2018-07)

• Analysed the business requirements of the project by studying the Business Requirement Specification document
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package
• Wrote complex SQL queries including sub queries for faster data retrieval from multiple tables
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Extensively used Jasper Report for generate GRN, DN, IN reports designing retrieve data from the database
• Having Experience in Debugging by using Error Log

Bachelor of Computer Application in Computer Application (2014)