Talent's Information
-
Location
Bengaluru, India
-
Rate
$10.0 per Hour
-
Experience
3.2 Year
-
Languages Known
English,Hindi
Available for
About M.Kiran
Having good experience in SQL and PLSQL development using ORACLE 10g, ORACLE 11g and ORACLE 12c.
Experience in Creating Tables, Views, Constraints, Sequences and Synonyms.
Good experience in creating complex database objects like stored procedure, Functions, Packages, and Collections.
Good in PL/SQL programming Database Triggers, Cursors, user defined exception, Pragma Autonomous Transaction, Bulk Collect and for all, Explain Plan, Sys refcursor.
Knowledge in SQL Query tuning.
Good in the Concept of Exception handling mechanism in various scope and visibility.
Experience in Agile/Scrum development methodology.
Good communicational and interpersonal skills, involved in client interactions for scoping, effort estimates and status reporting.
Having Good Knowledge in Client-Server application development using Oracle 11g/10g/12c, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
Tech Stack Expertise
-
Microsoft SQL Server
SQL
0 Years -
Oracle
Oracle 12C
0 Years
Work Experience
Software Developer
- January 2019 - December 2022 - 4 Year
- India
Projects
UTI Bank, Hyderabad, India Client
- January 2020 - October 2020 - 10 Months
-
This system keeps track of day-to-day bank operations like deposits, withdrawals, demand drafts, different types of loans (mortgage business) for the customers as well as the employees.
- Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
- Designed logical and physical data models for star and snowflake schemas using Erwin.
- Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
- Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
- Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
- Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
- Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
Roles &Responsibilities:
TBC Corporation.
- March 2021 - January 2022 - 11 Months
-
TBC Corporation (TBC) is one of North America’s largest marketers of automotive replacement tires through a multi-channel strategy. TBC serves wholesale customers in the United States, Canada and Mexico through TBC Brands, NTW, TBC International, and TBC de Mexico. Additionally, TBC responds to the needs of consumers in search of total car care at more than 3,200 franchised and company-operated tire and automotive service centers under the brands NTB, Tire Kingdom, Merchant’s Tire, Big O Tires and Midas.
- Creating Indexes for performance issues to search the data quickly.
- Creating Triggers for enhanced validation and business logic management.
- Creating Functions, Procedure and sequences whenever used.
- Writing Queries, Sub-queries, Joins.
- Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
- Monitoring the jobs in UC4 Tool.
- Checking log files in the WINSCP Tool.
- Creating HPSM Tickets for failed jobs.
Roles & Responsibilities:
WINS (Watson Inventory System)
- January 2019 - November 2019 - 11 Months
-
A S Watsons Group is a Retail business. It is one of the world's largest international health and beauty. Watsons has high presence in southeast, china and Europe
- Monitor job aborts (Alerts received from RMJ , RF Scheduler)
- Attend For Topdesk tickets raised by users and resolve within SLA
- System and server Maintenance activities – hold jobs before & after release after maintenance
- Involved in FTP(File transfer Protocal) connection issues and finding logs
- Involved some support for RMS ( Retek management system) and OSB ( Oracle service bus).
- Daily cross check Wins applications and RF servers as per schedule
- Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
Roles &Responsibilities :
Soft Skills
Industry Expertise
Education
in Diploma In Engineering
Krnataka University- June 2016 - June 2019
