CONTACT DETAILS

• NAME: Balamurugan Kalimuthu

• EMAIL: acrobo@r.postjobfree.com • MOBILE: +91 – 988-***-****

• CURRENT ADDRESS: Flat No: S1, • PERMANENT ADDRESS: 207, Perumaruthur,

Second floor,No 5B, Manamelkudi (tk),

Srvs colony,Srvs main road, Pudukkottai-614618

Keelkadalai,

Chennai -600117

PROFILE

PL/SQL DEVELOPER, with 5+ Years of experience in the area of Oracle 10g & 11g.

KEY SKILLS

Expertise in developing Stored Procedures, Functions, Packages and Views in Oracle.

Actively involved in performance Tuning.

Involved in modifying various existing packages, procedures and functions according to new business needs.

Involved in Oracle UTL Packages for generating reports.

Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.

Involved in writing complex SQL Queries.

Analysis and investigate data in database to deliver a most efficient queries.

Involved in data migration process.

Exposure in Tools like SQL Developer and PL/SQL Developer.

Involved and fixed live issues in client side.

Involved in data loading using SQLLDR.

Involved in automated process using unix shell scripting.

TRAINING

OBE(Oracle Back End) Course in SQL STAR International,Nungambakkam,Chennai-34

CERTIFICATION

Oracle Certified Associate (OCA) in Oracle 9i.

Oracle Certified Proffessional (OCP) in Oracle 11G.

EDUCATION

2005 – 2009 M.KUMARASAMY COLLEGE OF ENGG - ANNA UNIVERSITY – B. TECH. (Information Technology) – 74%

WORK HISTORY

Polaris Financial Technology, Chennai, July 2010 – Aug 2014 as a PL/SQL Developer.

Tata consultancy Service, Chennai, Aug 2014 – Apr2015.

Wipro technology,Chennai,Apr2015 - till

PROJECTS & RESPONSIBILITIES

Project #1 (BCBS & FDSF- RISK REPROTING)

Client Name: Scope International - Standard Chartered Bank

Role: PL/SQL Developer & Data Analyst

Data Base: Oracle 11G

Operating System: Windows Xp,Unix

Tools Used: SQL Developer and PL/SQL Developer.

Description:

The BCBS 239 standard introduces a global, overarching risk-data aggregation and risk-data reporting framework,Banks risk data aggregation capabilities and internal risk reporting practices (the Principles). In turn, effective implementation of the Principles is expected to enhance risk management and decision-making processes at banks. enhance the infrastructure for reporting key information, particularly that used by the board and senior management to identify, monitor and manage risks; enhance the management of information across legal entities, while facilitating a comprehensive assessment of risk exposures at the global consolidated level; reduce the probability and severity of losses resulting from risk-management weaknesses; improve the speed at which information is available and hence decisions can be made; and Improve the organization's quality of strategic planning and the ability to manage the risk of new products and services.

The Bank is embarking on a sizable program of work to comply with a "Basle Committee on Banking Supervision" edict (BCBS239). Incorporated into the program is PRA - FDSF (Prudential Regulation Authority - Firm Data Submission framework) compliance.

The program is divided into multiple streams to cover all Risk Types and Finance. It requires the streams to analyse and implement their change requirements in order to comply with the BCBS239 principles by the stipulated deadline.

The FDSF Business Analyst will support the FDSF ALM & Liquidity Lead in driving the requirements for the FDSF Reporting. The person will also support the working towards the overall BCBS239 requirements.

Responsibilities:

Analyzing the business need and gather/understand the business requirements in risk reporting.

Involved in identifying data lineage of attributes from various database source.

Experience in writing Complex SQL Queries using joins, sub queries.

Identifying RDM source and solution for lineage data attributes.

Performed codes walk through to check the stability of the programs.

Extensively involved in SQL Tuning to enhance the performance of complex queries for Reports and other business logic.

Used Pl/Sql tables, array structures as a part of oracle collections.

Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.

Project #2 (Apple Care)

Client Name: Apple

Role: PL/SQL Developer,Teradata developer.

Data Base: Oracle 11G,Teradata

Operating System: Windows Xp,Unix

Tools Used: SQL Developer and PL/SQL Developer,Informatica.

Description:

AppleCare is the name for Apple's technical support division and AppleCare Protection Plan is the name of the service and support plan for Apple products. The term "AppleCare" is mistakenly used interchangeably. The AppleCare Protection Plan is available for all newly purchased Apple products (iPhone, iPad, Apple Watch, iPod, Macs, and Apple Displays). Though all serialized products come with a limited one-year warranty and 90-days of telephone technical support, The AppleCare Protection Plan can be purchased within the first year of ownership for Macs, and within 60 days for iOS devices, extending and expanding that coverage. For Macs,AppleCare Protection Plan offers two additional years of coverage; for iPhones, iPads and Apple Watches, the support is extended by one year and also includes accidental damage coverage.Service is provided through a variety of options, including on site-repairs at the Genius Bar located in retail Apple Stores or Apple Authorized Service Providers (excluding Apple Watch). Alternatively, after speaking to an AppleCare representative on the phone or Apple website, devices may be mailed to an Apple repair center or Apple Authorized Service Provider for service. Products that cannot be repaired are replaced with new or refurbished products.

Responsibilities:

Analyzing the business need and gather/understand the business requirements.

Involved in developing various database object such as stored procedures, functions and packages.

Experience in writing Complex SQL Queries using joins, sub queries.

Compare and test the generated reports with existing report.

Performed codes walk through to check the stability of the programs.

Extensively involved in SQL Tuning to enhance the performance of complex queries for Reports and other business logic.

Used Pl/Sql tables, array structures as a part of oracle collections.

Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables both Database.

Project #3(Core Banking Solution)

Client Name: Andhara Pradesh Co-operative Bank [APCOB]

Role: PL/SQL Developer

Data Base: Oracle 11G

Operating System: Windows Xp, Unix.

Tools Used: SQL Developer and Pl Sql Developer,Informatica.

Description:

Andhra Pradesh State Co-operative Bank Limited (APCOB) to implement core banking solution (CBS) in all its 22 district central co-operative banks (DCCB) across the State. The proposed implementation will be executed through a unique multi-entity CBS rebranded as Intellect TM core banking solution, with centralised deployment at Hyderabad being used by 577 branches and 22 head offices of the DCCBs. APCOB wanted a core banking solution on a multi-entity concept so that it could centralise its systems and at the same time let all the DCCBs work as independent units. Using the multi-entity concept, Intellect TM CBS will deploy the application software at just one location with different entities/banks accessing it independently.

Responsibilities:

Developing Stored Procedures, Functions, Packages and Views.

Experience in creating SQL loader scripts to load data from flat files.

Involved in fixing issues during Live and UAT.

Involved in Client Interaction.

Playing major role in Oracle back end development for Data Migration.

Converts the data and application without any changes in business logic.

STRENGTHS & SKILLS

Achieve perfection in my entire task.

Enthusiastic and self-motivated.

Ability to learn quickly.

Good Team Player.

PERSONAL DETAILS

Date of Birth: 04 Feb 1985

Marital Status: Marrie

Languages: English & Tamil.

DECLARATION

I assure that the above mentioned information is true to my knowledge.

Place: Chennai yours sincerely,

Date:

(BALAMURUGAN.K)

Contact this candidate