Rubiya Manavalan

Pl/sql Developer Software Engineering Analyst

Rubiya Manavalan Email: acxs69@r.postjobfree.com

****, ******* **** ** ***#1516, Dallas, Texas 75206 Phone: 469-***-****

Summary

Around 5 years of experience in IT industry. Successfully designed/led/developed enterprise projects covering various aspects of software development, processes and methodology using Oracle, SQL, PL/SQL technologies. Extensive experience in understanding business requirement and worked across the SDLC phases such as SD, design, development/Fix, test and implementation.

Involved in performance tuning, code review and data validation.

Expertise in oracle query, PL/SQL, procedures, functions, packages, Triggers, collections, index.

Excellent exposure in database designing and table creation.

Good knowledge at UNIX environment, SQL LOADER and UNIX shell scripting.

Ability to see, suggest, model and deliver viable technical solutions for real world business problems.

Well experience in writing complex query logics, sub query and joint query.

Strong technical skills with clear communication.

Comfortable in large team environment with multiple vendors and 10+ engineers.

Experienced in coordinating with various teams like web development team, testing team, onsite team, Deployment team to speed up the processes.

Expertise in debugging any complex query / procedure, bug fixing.

Quick learner, constantly updating emerging trends in industry.

Around 2 yrs of experience in CMT (Communications, Media & Technology) .Having Knowledge on Siebel (Functional).

Education

Anna University, St Joseph’s college of Engineering, Chennai, India May 2011

Bachelor of Engineering, Aggregate 76%

Skills

Programming: Oracle Sql, PL/SQL, Procedure, Packages, Functions

Databases Software: Oracle 9i,10g, Siebel 8.1

DB Tools: PL/SQL Developer, TOAD, Putty, WinScp, EDM Converter, Seibel Tool, Hp Quality Center

Database skills: SQL, PL/SQL, Views, Optimization, Database tuning, Solution Design.

Microsoft Office Suite: Word, Excel, PowerPoint, Microsoft Visio, MS Project

Operating Systems: Windows XP, Windows NT, Windows 2000, UNIX

Work Experience

Software Engineering Analyst - Accenture Services Pvt ltd Sep 2014 – June 2016

Senior Software Engineer – IGATE Global Solutions Jan 2012 -Oct 2014

Accenture - Chennai, India (Senior Software Engineer) October 2014–June 2016

Title : Telstra CRM – Data Conversion

Client : Telstra

Duration : Oct-2014 to June-2016

Role : Senior Developer

Description

Telstra is the largest Telecom Company in Australia. The CC&B project (Customer Care and Billing) is a transformation project, which builds an entire new system and migrate the customers to the new system.

I have been working for the Data Conversion Team and playing vital role in handling Customer Data, development, Testing and production support.

Data conversion is about making changes to the customer data based on business requirements & production defects raised for massive customers. These customer changes will be handled through the SQL, PL/SQL script, Unix shell scripting and EDM Converter.

Roles & Responsibilities:

Involved in assessing the customer impacts due to recent code changes deployed in production by other modules like Products, Siebel and Kenan.

Requirement Analysis with Client, Designing the High level and Technical solution document.

Build SQL, PL/SQL script to fetch the impacted customer’s data from the Database using shell scripting, Developing EDM Profiles Using Siebel Tools, and Scripts for massive data conversions.

Testing and deploying the same in the lower environments (AT, CAT, SVT) and Production.

Running the conversion scripts in production using Unix Shell Scripting by batch process.

Preparing conversion documents (Functional/ Technical design document) for deployment of these changes to higher environments. This design document contains detail steps of deployment, which involves scripts and EDM tool execution.

Closely Monitoring production deployments, reporting the conversion results and analyze the pre & post conversion results.

Writing Scripts to provide the Customer Data report based on the Client Requirement.

Written automated shell script to run certain extract based on scheduled time.

Resources Used:

BUSINESS LOGIC : PL/SQL, Procedure, Packages, Functions, Shell script, Sql Loader

DATABASE : Oracle10g, Siebel 8.1

DEVELOPMENT TOOL : TOAD, Putty, UNIX, Win SCP, EDM Converter, Siebel

Tools, HP QC

PRESENTATION : Seibel tool

IGATE, Chennai, India (Senior Software Engineer) January 2012 – Sep 2014

PROJECT #1

Title : TPO My Fleet

Client : General Electricals

Duration : may-2012 to nov-2012

Role : Developer

Description:

My Fleet™ is a web-based application enabling GE PGS customers to stay connected to their fleet performance. Application provides real-time data from GE plant, glance at fleet efficiency, compare to the industry average which enables industry wide benchmarking, so that the customers can look at the performance of other GE fleets, comparing where you’re strong, where you’re weak, and how you can better compete.

Roles & Responsibilities:

Involved in analysis, design, development, defect fixing and implementation of whole project at oracle end.

Documented Analysis, Design, and development changes.

Debugged procedures for effective output.

Generated the traceability matrix.

Involved in performance tuning.

Involved in data validation.

Exporting database scripts for QA and PROD deployment.

Resources Used

BUSINESS LOGIC : PL/SQL, Procedure, Packages, Functions,

DATABASE : ORACLE 10g,

DEVELOPMENT TOOL : PL/SQL Developer,

MIDDLE TIRE : JAVA

PRESENTATION : JSP

WEB SERVER : Jboss 5.1

PROJECT #2

Title : Configurator

Client : General Electricals

Duration : Nov-2012 to May-2014

Role : Senior Developer

Description:

Configurator is a world-class sales engineering tool developed for GE-PGS (Power Generation Services). The main objective of this tool is to equip GE-PGS sales team to magnify the profit margin for GE, and suggest an optimized solution to the GE's clients to maximize the power output from each turbines.GE PGS manufacturing turbines and installing it in client’s places. After installing the turbines GE keeps on monitoring the performance of turbines and the data’s being collected. Also GE do some research invent a new technology to increase the performance of turbines and minimize the fuel consumed by turbines. The newly invented technologies to be marketed by the sales team to its customers. For marketing purpose, sales team requires the following.

1) Actual data of turbines (unit data)

2) Market Data

3) Customer input (Voice of customer) by computing all these data, the tool suggests a optimal solution to be implemented to maximize the power outcome.

End Users: Sales managers, Area managers, Sales executives of GE- PGS from various regions.

Roles & Responsibilities:

Requirement gathering from business team.

Involved in analysis, database design, table creation, development, defect fixing and implementation of my modules at oracle end.

Done unit testing.

Documented Analysis, Design, and development changes.

Generated the traceability matrix.

Involved in query optimization.

Debugged procedures for effective output.

Involved in code review.

Enhanced the existing modules.

Exporting database scripts for QA and PROD deployment.

Resources Used:

BUSINESS LOGIC : PL/SQL, Procedure, Packages, Functions,

DATABASE : ORACLE 10g,

DEVELOPMENT TOOL : PL/SQL Developer,

MIDDLE TIRE : JAVA

PRESENTATION : JSP

WEB SERVER : Jboss 5.1

PROJECT #3

Title : PGS PORTAL

Client : General Electricals

Duration : June-2014 to Sep-2014

Role : Senior Developer

Description:

PGS Portal is portlet for all different applications. There are multiple processes and system across PGS business which is used to plan, track and facilitate outage execution. It is a common portal available for CPM, SM and OPs Manager to view or track outages. Application used as one view of outage data, deliverable tracking capability, linkage and integration to be available. It creates system scalability for various outage and contract types, customers, and unit view. Application provides deliverable tracking capability across fleet to assess progress at site, unit, and event levels.

Roles & Responsibilities:

Involved in analysis, design, development, defect fixing and implementation of whole project at oracle end.

Documented Analysis, Design, and development changes.

Generated the traceability matrix.

Debugged procedures for effective output.

Involved in performance tuning.

Involved in code review.

Enhanced the existing modules.

Exporting database scripts for QA and PROD deployment.

Resources Used:

BUSINESS LOGIC : PL/SQL, Procedure, Packages, Functions

DATABASE : ORACLE 10g

DEVELOPMENT TOOL : PL/SQL Developer

MIDDLE TIRE : JAVA

PRESENTATION : Ajax, JQuery n Html

WEB SERVER : Jboss 5.1

Experience split up:

PL/SQL : 2.5 years

SQL : 4 Years

UNIX : 1 Years

Contact this candidate