Giri k
Email-id: [Link]@[Link]
Contact no: +91-9175451069
Objective
Looking forward for a career in Database Development and Support where I can exercise my
expertise and knowledge that fosters quality, creativity and continuous learning
Professional summary
Having 4+years of professional experience in IT as a PL/SQL Developer providing
extensive support in Design, Development, Enhancement, Testing, Implementation and
Production Support.
Extensive experience in creating/modification Tables, Views, Indexes, Sequences,
Synonym, Triggers, Procedures, functions and Packages.
Handling pre-defined and user-defined Exceptions.
Experience in writing Cursors, Ref Cursors and PL/SQL Collections.
Having experience on writing SQL queries
Experience in loading data from different Flat files into database tables using SQL*Loader
and UTL_FILE Packages.
Good sound knowledge in Pragma Autonomous Transaction, BULK Collect and Bulk
Bind for processing better performance of the operations.
Having experience on UNIX and Shell Scripting.
Having knowledge on Informatica.
Good in understanding of Business logic and ability to work well as a part of a team.
Certified AZ-900 Azure Fundamentals.
Certified Scaled Agile (Safe for Team Course (5.0)).
Work Experience
Currently associating with “Accenture Solutions Pvt Ltd” as a Application Development
Senior Analyst from Oct 2018 to Jun 2021.
Worked in “IBM India Pvt Ltd” as a Application Developer from Jan 2017 to Sep 2018.
EDUCATION
MCA from JNTU (Jawaharlal Nehru Technological University), Anantapur.
[Link] from S V University, Tirupati.
SKILLS
Operating System : Windows ,Linux
Languages : SQL,PLSQL,Informatica and Unix Shell scripting
Tools : SQL*Plus , SQL Developer
Database : Oracle 9i,10g,11g and 12c.
CC Tools : Bitbucket,HP-DMA
Other tools : JIRA,SNOW,BMC Remedy and Contol-M
Project Profile
Project #1:
Client : AT & T
Technology : SQL,PLSQL and Unix
Role : PLSQL Developer
Duration : Mar 20 to FEB 21
Team Size :5
Domain : Telecom
Description:
Embedded Software project is to develop a tax efficient procurement strategy that enables
collaborating with the company’s vendors in order to remit the correct amount of tax on software
traditionally embedded in the cost of hardware. The intent is to calculate weighted average percentage
of software at MIC, FRC level
Responsibilities:
Understanding the Requirements and Functional Specifications of the application
Written the Queries Using Joins, Set Operators and Sub Queries to access the Data.
Designing and coding of the Database Objects.
Developed procedures, functions, packages, views and complex views for much functionality
in project.
Involved in PL/SQL Store Procedures, Functions, Triggers and Package for project.
Worked on PL/SQL Object types Ref Cursors, PL/SQL Tables and PL/SQL Records.
Project #2:
Client : Barclays
Technology : SQL, PLSQL and Unix Shell Scripting
Role : PLSQL developer
Duration : Oct 18 to Feb 20
Team size : 12
Domain : Banking
Description:
ZEUS is Cordiant Application, which is providing the corporate loan to the customers. It is
sanctioning the loans based on the requirements and post-sanction the loan’s based on the customer
acceptance. ZEUS contains the different modules like BAU, SCM, SRP and SCORPIO.
Responsibilities:
Writing new and modifying existing codes in PL/SQL Packages,stored procedures,functions
and views to meet business requirements.
Involving in creating tables, index,constraints,sequence and synonym.
Loading data from flat files into database using SQL * Loader.
Involving in enhancing of various existing procedures, functions and packages.
Gathering the functional requirement and implementation of business logic.
Project #3:
Client : MOO(Mutual of Omaha)
Technology : SQL,PLSQL, Forms and Unix Shell Scripting
Role : PLSQL Developer
Duration : Jan 17 to Oct 18
Team Size : 11
Domain : Insurance
Description:
A participant recordkeeping and plan administration solution for the insurance industry, COMPASS
supports a range of plan types, including group pension, group and life disability, individual pension
and annuity, and corporate profit sharing. Organizations employ COMPASS as a single solution to
serve participants from plan enrolment through termination.
Responsibilities:
Understanding the Requirements and Functional Specifications of the application
Involved in analysis and design discussions
Designing and coding of the Database Objects.
Developed procedures, functions, packages, views and complex views for much functionality
in project.
Working with the team in resolving the reported issues on time and bug fixing
Involved in developing various procedures to send the remainder mails for various
functionalities using SMTP package.