Oracle Developer

Balaji Ravindran

Email-id: ******.******@*****.*** Phone: 757-***-****

EXPERIENCE SUMMARY

Around 6 years of experience in the Analysis, Design, development, Testing, Production support, Implementation and management of the Data Warehousing applications and developed ETL jobs for the Data Warehousing.

Proficient Experience in Oracle 10g/11g, SQL, PL/SQL, UNIX Shell Script and expertise in utilizing tools including Toad, SQL*Plus, PL/SQL Developer.

Worked extensively and having 2+ years of experience in Informatica 9.5 for Extraction, Transformation and Loading the data, and Maintenance.

Proficient experience in Telecom and Banking domains, working closely with Team and DBAs in designing and developing DB objects like PL/SQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors, Collections and Exception Handling.

Extensive experience in using Collections, materialized views, Bulk Techniques, Optimizer Hints and also have experience on troubleshooting and identifying performance bottlenecks in the applications and fine tuning the SQL codes.

Possess good knowledge in Software Development Life Cycle (SDLC) that includes requirements gathering, functional and technical specifications, design, development, testing and production support.

Involved in developing batch programs by using PL/SQL, shell scripts, CRON Scheduler, Autosys and SQL*Loader for loading data from flat files into Oracle tables.

Have Experience working on the Agile Methodology.

Having Experience working on the Microsoft Visio creating database models, flowcharts and Application Designs. Also have knowledge on Excel Macro’s to automate day to day reporting’s.

Extensive experience as a Senior Developer and Lead including requirements gathering, study and analysis of project requirements through customer interaction, preparation of Functional Specifications and design documents.

Proven ability to interact successfully and professionally with cross-functional, remote teams and clients to work productively within a team environment and independently.

Have excellent communication and inter-personal skills.

EDUCATION

Bachelor of Technology with specialization in Information Technology at Sri Manakula Vinayagar Engineering College (Pondicherry University) Puducherry, India, May 2008.

TECHNICAL SKILLS

Database : Oracle 11g

Programming Languages : Oracle PL/SQL

Scripting : Shell Scripting

Database Tool : SQL Developer, Toad

ETL Tool : Informatica 8.1/9.5

Operating Systems : Windows, UNIX

CERTIFICATIONS

Introduction to Oracle 9i: SQL

SCWCD 5.0 (Sun Certified Developer for Web Component)

SCJP 5.0 (Sun Certified Developer for Java 5.0)

PROJECTS

Employer: TATA CONSULTANCY SERVICES LIMITED June 2014 – Present

Client: BANK OF AMERICA

Location: Norfolk, VA, USA

Role: Oracle Developer

CORE CREDIT CARD PLATFORM MODERNIZATION (C3PM)

This Project is a large scale project that kicked off in 2012 to support the conversion of the US Consumer Credit Card Portfolio from the current card platform to the new card platform.

CROSS SELL MID TIER (CSMT)

Cross Sell Middle Tier (CSMT) is middle tier application in Bank of America. The CSMT is a flexible platform that will support the automated sale and fulfillment of Consumer and Small Business Card products to our customers. This Application will integrate with existing product ordering processes and systems to recommend credit card products tailored for each customer when card and other Bank products are being requested. Its primary purpose is to service banking centers within Bank of America to sell various credit card products to customers. Besides banking centers, CSMT also serves several other channels that includes dotcom channel (www.bankofamerica.com/creditcards), third party vendors such as UPromise, Apply Online (AOLN), and Affinity Partners like BassPro that are installed with Affinity Partner Tool Kit. CSMT is a stateless and pass-through system. The system is activated by receiving requests from upstream systems via either web service request or MQ request. All requests and responses to and from CSMT are in XML format. CSMT also receives few requests in the form of text files which are processed as batch. Most of the Customer information is received from upstream systems and very little of it is stored within the CSMT database. Customer related information when required is retrieved from WCC and Offer information is stored, and retrieved from OFR.

RESOURCE MANAGEMENT TOOL (RMT)

Project aims at analyzing and development of the functionalities to provide solutions for the challenges faced by the Resource Managers to allocate and to manage the resources of the organization. The Tools helps the Resource Managers to handle the revenue of the project and also helps in assigning/mapping/un assigning the employees to the projects. The Tool uses the Java language for the front end and the Oracle 11g as the backend.

Responsibilities:

Analyze and design the business requirement.

Involved in development of Oracle PL/SQL components.

Identify bugs in the system and fix them through enhancements in the Scripts.

Performed Data Loading.

Trouble shooting implementation / post implementation issues.

Provide weekly status report to managers describing the status of work and progress.

Coordination with UI designer to develop the front end components.

Worked with DBA for DB specific changes

Unit Testing, Integration Testing and System Testing

Worked with Defect team to resolve testing issues

Involved in production deployments and postproduction support.

Onsite-Offshore Coordination

Environment:

Oracle 11g

Client: Motorola Mobility Inc. Oct 2009 – Apr 2014

Location: Chennai, India

Role: ETL Developer & Technical Lead

REPAIR DATA WAREHOUSE (RDW)

The Project aims at collecting and reporting the repair products on all Home and Network Mobility – Connected Homes products repaired by Internal Motorola or 3rd Party Repair Canters. RDW as a Reporting Repository Platform for repair related information will include the following objectives.

Extract and Load: to collect data from different Systems/Businesses and load data into the RDW System.

RDW Repository: to hold Repair related summarized data for analysis to improve quality of the product, operation and reporting.

Reporting: to present data from the RDW repository to internal groups for Internal Analysis and Improvements.

The Reporting environment is used to provide reporting over the RDW Repository. The Main Consumers of these Reports are Repair Operations, Finance, Business and Quality Directors, Customers, Customer Advocacy. The application is grouped into 3 technical streams – Oracle Database, PL/SQL Scripts, Cognos 8.0/OBIEE.

Responsibilities:

Analyze and design the data warehouse components.

Managing the Repair Protocol Programs.

Actively participated in performing the Major / Small / Emergency projects which comes as an enhancements or project request

Identify the bugs in the system and fixed those bugs by enhancing the Scripts.

Trouble shooting implementation / post implementation issues

Handling trouble Service requests/concerns raised by users

Monitor the whole Reporting and Information Management System and ensure that the reports are distributed on time

Identified Performance bottlenecks in the application and performed fine tuning to the SQL codes to improve the performance.

Maintaining Data Integrity by Analyzing or identifying Data Issues If any be it related to PL/SQL and fix the same

Frequent communication with the customers to ensure the data integrity.

Writing Unit and System Test Plan / Test Cases as per the requirements from the client.

Provided the critical data to users which were not converted in the application.

Onsite-Offshore Coordination.

Integrated new requirements whenever there was an organizational change.

Environment:

Oracle 11g, UNIX Shell Script

Special Software:

Toad, SQL Developer, Putty

Client: Motorola Mobility Inc. Oct 2010 – Dec 2012

Location: Chennai, India

Role: Oracle Developer

PRODUCT QUALITY LIFE CYCLE (PQL)

The Project is aimed at building an Integrated Application to create a single source of truth by bringing in all the existing Warranty Applications which provides common warranty solution across the customer organization that will allow individual businesses to proactively monitor and analyze Warranty Claims data, identify emerging issues and analyze known issues.

Responsibilities:

Conducted in-depth research on the system requirements and technically evaluated the feasibility of the requirements by interacting with the client.

Estimated the effort to put to develop the designed component

Primarily involved in development of:

oInformatica ETL Mappings

oOracle Stored Procedures.

Client liaison activities involves providing the weekly status of the project in the calls and communicating the project plan and timelines.

Actively involved in the test phase. Resolved and kept track of defects identified during the implementation and ensured that timelines were met.

Provided post implementation support of the Project for a specific time period.

Construction of various business rules, decision tables and functions.

Monitoring and troubleshooting Informatica Jobs.

Preparing Analysis and Design documents, Unit Test plan and Design documents.

Involved in production deployments and postproduction support.

Identify process bottlenecks, constraints, and improvements to enhance the design of the process and continue value cycle

Onsite-Offshore Coordination

Involved in Major / Small / Emergency projects which comes as an enhancements or project request.

Environment:

Oracle 11g, UNIX

Special Software:

Toad, SQL Developer, Putty, Informatica 9.5

Client: Motorola Mobility Inc. Oct 2009 – Dec 2012

Location: Chennai, India

Role: Oracle Developer

WARRANTY DATA ANALYSIS

This project is aimed at building a Warranty tracking system that will keep track of the In-Warranty and Out-Warranty products and provides a common Warranty solution across the customer organization that will allow individual business to proactively monitor and analyze warranty claims data, identify emerging issues and analyze know issues.

Responsibilities:

Involved in Major / Small / Emergency projects which comes as an enhancements or project request.

Prepared the customer requirements and functional requirements.

Identify bugs in the system and fix them through enhancements to the Scripts.

Trouble shooting implementation / post implementation issues.

Handling Service and incident requests reported by users.

Frequent communication with the customers to ensure the data integrity.

Writing Unit and System Test Plan / Test Cases as per the requirements from the client and also adhering TCS internal Quality assurance policies

Provide weekly status report to managers describing the status of work and progress.

Construction of various business rules, decision tables and functions.

Monitoring and troubleshooting Informatica Jobs.

Unit Testing, Integration Testing and System Testing

Analyzing and providing solutions for critical issues

Worked with DBA for DB specific changes

Knowledge transition about the existing systems to the new joiners

Worked with QA team to resolve testing issues

Involved in production deployments and postproduction support.

Identify process bottlenecks, constraints, and improvements to enhance the design of the process and continue value cycle

Onsite-Offshore Coordination

Environment:

Oracle 11g, UNIX Shell Scripts, Informatica 9.5

Special Software:

Toad, SQL Developer, Putty, Informatica 9.5

Competencies

Versatile team player

Individual contributor with strong analytical and problem solving skills

Good communication and inter personal skills.

Committed to deadlines and schedules.

PERSONAL DETAILS

Date of Birth : 20-February-1986

Sex : Male

Nationality : Indian

Marital Status : Married

Number of children : 1

Current Location : Norfolk, Virginia, USA.

VISA

Petition Type : H1 B

Petition Duration : 18-Dec-2014 to 16-Oct-2017

Contact this candidate