Ezhilarasan Balasubramaniam, SQL & PL/SQL Developer

ac6qjp@r.postjobfree.com Mobile: +91-979*******

Summary:

Over 3+ years of experience in IT Software Industry and having experience in various phases of the Software Development Life Cycle, with focus on Software Development.

Work experience in Oracle 11g, MSSQL 2005, MSSQL 2008

Extensive database experience in creating Packages, Functions, Exception Handling, Constraints, Cursor, Index, View, Materialized View, Sequence, Synonym.

Extensive working knowledge in Data Migration, Data Extraction, Data Transformation, Data Loading, Migration Testing.

Experience in minimizing the impacts of data migration, data integrity issues, data quality issues, issues in post migration data.

Experience in developing complex queries for ad-hoc requests to generate reports as per business inputs.

Employment Summary:

TM-Information Management in HDFC Bank.Ltd, Chennai from August 2018 to till date.

Senior System Analyst in Standard Chartered Global Business Services Pvt.Ltd, Chennai from July 2016 to July 2018.

SMTP Engineer in Genxlead, Chennai from July 2014 to Nov 2015.

Educational Qualification:

BE Computer Science, Sengunthar Engineering College, Trichengode; 65%, April 2014

Diploma, Pavai Varam Polytechnic College, Namakkal; 77%, May 2009

SSLC, Vidhya Parthi Hr.sec School, Dindigul; 61%, April 2007

Technical Skills:

Operating Systems : Windows,Linux

Languages : Oracle SQL, PL/SQL,SQL Server

DBMS : Oracle 11g, SQL Server 2008

Tool utilities : SQL Developer, PL/SQL Developer, TOAD,Putty

Professional Experience:

Client 1 : Scope International - Standard Chartered

Project1 : Private Banking – Private Banking eCredit(PBeCR)

PBeCR application is a web based system developed to facilitate the private banking high net worth individual customer to interact with the bank with their relevant credit applications.The CSO’s and the RM will be credit the application by interacting two major application like T24 and Cupid for transactions and customer details.

Role : Developer

Environment : PL/SQL Developer, SQL Server Management Studio

Database : SQL Server 2008, Oracle 11G

Domain : Banking

Time Span : July 2016 to July 2018

Responsibilities:

Designing database, staging tables and extraction tables.

Generating extraction criteria by applying business rules,field mappings, format Files to load extraction table.

Developing stored procedure for the given extraction criteria.

Done data patch’s for the System which is mismatching from the source system.

Involved in writing ad-hoc query for data extraction.

Fixing data quality issues in staging area.

Adaptive to working environment.

Client 2: Genxlead

Genxlead is the most preferred online marketing partner. Being capable of materializing customer expectations into reality by being innovative and committed through all possible channels.

Project 2:Data Extraction - Data Management and Movement

Developed several innovative ways to collect and analyze data generated by email campaigns.

Assisted in maintaining database of marketing contacts who had opted-in to receiving marketing emails.

Assisted in analyzing marketing data and altering email marketing plans as they were in progress.

Role : SMTP Engineer

Environment : Oracle 11g, PL/SQL Developer,Putty, SQL Developer

Domain : Online Marketing

Time Span : July 2014 to Dec 2015

Responsibilities:

Interacting directly with the customer for requirements gathering and experience in translating business requirements into creation of database Tables, Procedures, Packages, Indexes, Constraints, Functions, Cursor and View.

Provided code fixes on migration data issues across problematic areas concerned with the business.

Involved in writing ad-hoc query for data extraction.

Plan and supervise the daily activities of the migration.

Database query tuning and Implementation support during migration run in production.

Involved in resolving production problems for the Pre and Post migration data.

Performed gap analysis when the requirements are flowed in.

Participated in technical and functional discussions within the team.

Documented Data migration requirement of business, software and tools.

Data elements are mapped from source to target.

Fixing data quality issues in staging area.

Developed Test Plan and involved in post migration testing.

Appreciations/Achievements:

Received Certificate of Appreciation for Excellent Work Commitment.

Appreciated by client for my extended support to fix the issues in migration parallel run.

Personal Strength:

Effective Team Player and Adaptable.

Hardworking

Ability to work cooperatively in group with good communication skills

A fast learner, possessing the right blend of Analysis and technology skills.

Good people skills ability to communicate effectively and build long lasting/ mutually beneficial relationships.

Personal Details:

Date of Birth : 13-July-93

Gender : Male

Marital Status : Single

Nationality : Indian

Location : Chennai, Tamil Nadu

Languages : English, Tamil, Telugu

Nativity : Dindigul

Declaration:

I hereby declare that the above written particulars are true to the best of my knowledge and belief.

Place: Chennai

Date: (Ezhilarasan B)

Contact this candidate