VENKAT.T

PROFESSIONAL SUMMARY:

Over all 10 years of experience primarily Oracle, SQL, PL/SQL, Development and Production Support. Expertise in handling multiple projects simultaneously and development of client/server and multi tired applications.

·  Extensively used PL/SQL to built Oracle Packages, stored procedures, functions, triggers, views,

Cursors and Materialized view for processing data.

·  Worked on advanced PL/SQL constructs like Oracle supplied packages, Records, and Types.

·  24/7 Production Application Support & Maintenance.

·  Experience in maintaining and creating database objects like tables, views, indexes,

·  sequences, synonyms etc.

·  Experienced in performance tuning and optimization of SQL Statements using explain plan also

developed indexes.

·  Experience in Exceptional handling, records, arrays.

·  Experienced in SQL Optimization, Performance tuning, Data warehousing ETL process and data

conversions.

·  Experience in Partitioning of tables, Bulk Collects

·  Very good experience in creating stored procedures, function’s, triggers and packages and other

·  Good experience in handling huge volume of the data and geospatial data (Sdo_Geometry) and

worked on advanced geospatial functions like sdo_relate,sdo_intersect and handled points and

polygons.

·  Good experience on performance tuning and Troubleshooted performance issues and bugs.

·  Good experience on UNIX Shell scripting.

·  Good experience on oracle retail merchandising system.

·  Good experience on transfers, allocation, po applications.

·  Experience on various ETL tools like Ab-initio.proficiency in loading the data from one source to

another.

·  Experience on database design and data modeling.

·  Experience in RALLY and agile methodologies.

·  Experience in Develop and Design ETL test cases, scenarios, and scripts to ensure quality Data

warehouse and BI applications.

·  Execute detailed ETL related functional, performance, integration and regression test cases, and

documentation.

·  Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life

Cycle (STLC).

·  Used Quality Center for creating and documenting Test Plans and Test Cases and register the

·  expected results. Using HP Quality Center for storing, maintaining the test repository, bug

·  tracking andreporting Experienced in retest the existing test cases with the different kind of

·  source systems for different periods of data.

·  Very Good knowledge in ab-initio and one year work experience on abinitio for current project.

·  Experience on System analyst Role (Business insurance Applications).

·  Experience on Teradata

·  Good experience on SQL server.

·  Excellent team player, very good trouble shooting and problem solving skills. Can swiftly grasp new tools & Technologies

Education:

Master of computer applications from Bangalore University, India.

SOFTWARE KNOWLEDGE:

ETL Tools / Abintio
Teradata Interfaces: / BTEQ, Fast Load, MultiLoad, TPump, API, Utility
Databases / Teradata, OraclePLSQL, SQL Server
Other tools / UNIX, Korn Shell, Autosys (Job Scheduling Console), informatica, VSS
Programming Languages / Shell scripting, SQL, PL/SQL,C,C++
Operating System / Sun Solaris, UNIX, Windows XP/Vista/Win7
Testing Tools / Manual testing, ETL testing, ALM

Client: Citi Group, Tampa FL OCT 2016 – TILL DATE

Project Name: Clems

Role: Oracle Database Lead

Responsibilities:

·  Understanding theBusiness requirements based on Functional specification to designthe ETL

methodology in technical specifications.

·  Involved in requirement analysis, ETL designand developmentfor extracting data from the

heterogeneous source systems likeSQL Server, Oracle, Teradata, flat files,and loading into Staging

and Data Warehouse Star Schema.

·  Involved in massive data cleansing prior to data staging.

·  Prepared HLD, LLD and mapping specification.

·  Written stored procedures, packages and triggers using PL/SQL

·  Developed SQL queries to obtain specific information as per requirements

·  Developed complex package for geo spatial matching.

·  Written stored procedure to profiling the property addresses

·  Developed SQL queries to obtain specific information as per requirements

·  Developed shell scripts and scheduled jobs in crontab on UNIX.

·  Implemented bacth for loading the data from source db to destination db.

·  Professional experience in Integration, Functional, Regression, System Testing, Load Testing, UAT

Testing, Black Box and GUI testing.

·  Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.

·  Responsible for preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test

Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality

deliverables.

·  Experience in working with Software Development team in resolving Defects, presenting the Defect

Status reports, resolving requirement, and observed design inconsistencies.

·  Compared the expected results with the actual outcome and recorded the results.

·  Working with the Development team for process improvement and release planning Analyzed

application data using the SQL to identify the ETL processes

·  Performing backend testing of the DB by writing PL/SQL subprograms to test the integrity of the

application and Oracle database.

·  Used Quality Center for creating and documenting Test Plans and Test Cases and register the

expected results. Using HP Quality Center for storing, maintaining the test repository, bug tracking

and reporting Experienced in retest the existing test cases with the different kind of source systems

for different periods of data.

·  Responsible for preparing documentation for some of the recurring defects and resolutions and

business comments for those defects.

·  Created the shell scripts for archiving the processed files and backup the files.

·  Created the shell scripts for cleaning the log files on daily basis.

·  Created the shell scripts checking the disk space for every user who are working on the clp

application area.

·  Created the shell script for monitoring the alert logs.

Environment:Abintio, Teradata, Oracle, MS SQL Server 2008, SQL, UNIX, Windows XP, Autosys.

Client: TRAVELERS, Hartford, CT August 2014 –OCT 2016

Role: Database lead

Responsibilities:

·  Involved in gathering business requirements, Technical requirements and Design documents.

·  Coding of Business rules through backend Triggers, Stored procedures and Packages

·  Writing packages an implementing and customizing retail merchandising system.

·  Creating a batch to purging the unwanted data in purchase order application.

·  Customizing the forms as per client request.

·  Preparing database table structures and creating database objects

·  Validation and Testing of forms

·  Written stored procedures, packages and triggers using PL/SQL

·  Developed GUI screens using Forms 10g

·  Developed SQL queries to obtain specific information as per requirements

·  Developed shell scripts and scheduled jobs in crontab on UNIX.

·  Interacted with client

·  Tuning the packages using explain plan and TKPROF.

·  Implementing package to automatic month end automation process for Paying premium and calculating premium by using batch job.

Environment:Abintio, Teradata, Oracle, SQL, UNIX, Windows XP, Autosys.

Client: Abercrombie &fitch Retail merchandising system. Boston, MA July 2011 – Aug 2014

Role: Senior Oracle developer

Responsibilities:

·  Responsible for the development and integration of graphs.

·  Involved in the Design Document Preparation

·  Understanding the client requirements and Functionalities

·  Coding of Business rules through backend Triggers, Stored procedures and Packages.

·  Preparing database table structures and creating database objects

·  Validation and Testing of forms

·  Written stored procedures, packages and triggers using PL/SQL

·  Developed SQL queries to obtain specific information as per requirements

·  Developed GUI screens using Forms 10g

·  Customizing the forms as per client request

·  Tuning the packages using explain plan and TKPROF.

·  Developed shell scripts and scheduled jobs in crontab on UNIX.

·  Test cases preparation and Implementation plan preparation.

·  Interacted with client during CRP and UAT.

·  Responsible for developing testing the system by following the software testing lifecycle

·  Handle the tasks of documenting test case and scenarios by coordinating with software developers

·  Perform responsibilities of test Scripts to perform functional testing.

·  Handle the tasks of testing results that has been conducted by following performance and regression testing standards

·  Responsible for providing technical support to end-user as well as to teams in configuration.

Environment:Abintio, Teradata, Oracle, SQL, UNIX, Windows XP, Autosys.

Client: HDFC STANDARD LIFE July 2009 – April 2011

Role: Oracle Developer

Responsibilities:

·  Coding program units (procedures, functions, and packages) for establishment and works sections

·  Resolving of queries in different applications.

·  Coded and implemented PL/SQL packages to perform and batch job scheduling

·  Scheduling the jobs daily basis and submitting the jobs as per client request

·  Resolving the database issues as per client request

·  Monitoring the ETL uploads and daily upload the csv files data to applications schema

·  Customizing the forms as per client request.

Environment: SUN Solaris Korn shell, Oracle 11g, Oracle SQL Developer, Windows 7

State Bank of Hyderabad (SBH), Hyderabad, India Sep2008 – Jun2009

Jr.PL/SQL Developer

Responsibilities:

·  Handling the request according to the User Specifications.

·  Created Grants of roles and privileges to the user.

·  Resolved application problems to maintain high level of customer satisfaction.

·  Created varioustables, indexes, constraints, views sequences, synonyms and stored program units.

·  DevelopedSQL* Loader scripts for data extraction and transformation.

·  Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.

·  Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.

·  Developed database triggers required for the Integrity constraints.

·  Analyzed current procedures, recommended and implemented improvements as needed.

·  Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.

·  Written PL/SQL cursors for transaction processing.

·  Written Queries for the management in the form of stored procedures and packages.

·  Involved in writing complex queries to generate reports as per client request as a part of production support.

·  Created partitions on the tables to improve the performance.

·  Extracted data from Flat files, Oracle and SQL server sources.

·  Designed and generated reports using Crystal Reports.

Environment: Oracle 9i, PL/SQL Developer, Solaris 5.9, SQL Developer 1.1, Serena PVCS, OracleEnterprise Manager, Windows 2000, Crystal reports.