Download PDF

Vinoth K

Interest

Listening to songs, Surfing internet

Objective

To obtain challenging roles and responsibilities in software industry to achieve horizontal and vertical growth.

Skills

Other Tools
SQL Developer, PlSQL Developer
Operating system
Data Warehousing Tools
Oracle Warehouse Builder
Programming Languages
 Oracle 9i\10g\11g SQL, PLSQL.

Work experience

Birlasoft India limited
Aug 2012Present

Software engineer

EIPP (Enterprise invoice payment and presentment) - Associate software engineer

Duration          : 6 Months (Aug 2012 – Feb 2013).

Technology      : Oracle 11g, SQL, PLSQL

Platform          : UNIX

Role                : Oracle PL\SQL Developer\Support.

Description     : Oracle PL\SQL Developer\Shell script developer\Support for Xerox Corporation                                      (USA).

Responsibilities: 

  •        Supporting and maintaining database components of application.
  •        Developing and modifying tables, views, stored procedures, functions, triggers for enhancements.
  •        Unit testing the new development and enhancements.
  •        Writing shell scripts to load data from flat files received from customers/schedule oracle processes.
  •        Solving customer queries and handling production issues within response time and resolution time SLA with high quality of service.
  •        Analyzing performance of scheduled jobs and its execution plan over time.

XPRO (Xerox Professional Reporting Online) - Software engineer

Duration          : 1 Year (Mar 2013 – Feb 2014).

Technology      : Oracle 11g, SQL, PLSQL.

Platform          : UNIX

Role                : OWB & Oracle PL\SQL Developer\Support.

Description     : OWB, Oracle PL\SQL & Shell script Developer\Support for Xerox Corporation (USA).

Responsibilities: 

  •         Designed the ETL Specification for Source System to STAGING and STAGING to DW.
  •        Implemented the ETL processes using OWB 11gr2 to load data from sources system (Flat Files) into the staging.
  •        Developed mappings using OWB for data loading.
  •        Created Process flow.
  •        Report Development using Oracle BI Answers / Dashboards.
  •        Responsible for understanding the requirements, designing the solutions, communicating well with both clients and other team members the projects articulating the requirements and issues to get the job done.
  •        Receives requests for SQL\PLSQL activities such as Create, Modify and Drop of Table, Views, Procedures, Functions and Materialized Views.

iSRVE (Integrated service reporting environment) - Software engineer

Duration          : 8 months (Worked simultaneously while working in other projects based on need)

Technology      : Oracle 11g, SQL, PLSQL, Oracle Warehouse builder

Platform          : UNIX

Role                : DWBI tester

Description     : Responsible for writing database test scenarios, test cases and test query for data validation and report validation.

Responsibilities: 

  •         Understanding Data-warehouse /Data mart  designs and architecture for Full SDLC projects, enhancement projects, and corrective and production issue fixes.
  •        Preparing test scenario, test cases, test queries to  for validation of data from various source system to target system and handing over to other team members for execution.
  •        Responsible for ensuring the data integrity, performance of data loads, consistency and durability of the code.
  •        Analyzing the execution plan to achieve better performance and coordinating with other vendors to have fix.
  •        Writing shell scripts and queries to automate complex data flow validations.

Education

Coimbatore Institute of Engineering and Technology
Aug 2007Apr 2011

Bachelor of Engineering

St.Michael's higher secondary school
Jul 2001Apr 2007