Developer Resume

SUMMARY

To seek a responsible position as Oracle Developer
Over Five Years of e xtensive experience as Developer in Oracle PL/SQL design, development and implementation of Banking, Telecom and Insurance Applications.
Having sound knowledge in Data Warehouse concepts, ETL, Table Partitioning Performance Tuning and MS Office applications
Having Significant knowledge in JAVA/ J2EE technologies.
Experience with Data flow diagrams, Data dictionary, Database Normalization.
Highly focused on customer requirements in all the deliverables, QA activities and Value additions in Banking, Insurance and Telecom domain.
Experienced in automation & data management, manipulation involving efficiency and large volume of data
An excellent communicator with exceptional Interpersonal Skills, ability to interact effectively with clients and have Valid EAD

TECHNICAL SKILLS

Database: Oracle 10g and 11g, TOAD, SQL Developer, SQL Plus

Java Tools and Technologies: Core Java, J2EE(Servlets and JSP), JDBC, Eclipse

Operating Systems: Microsoft Windows and UNIX.

Build Tool and source Control: Ant and SVN

Microsoft Tools: Skillful in MS Excel data management, proficient in MS Word, MS Access and PowerPoint applications

BI Tools: Tableau.

PROFESSIONAL EXPERIENCE

Confidential

Developer

Responsibilities:

Worked on data modeling and Created Tables, Views, Constraints, Index and other oracle objects based on the given requirement
Performance tuning is done to improve the DB Performance by created hints to direct the optimizer to choose an optimum query execution plan, indexes are also created to avoid full table scan
Worked on Partitioning for maintenance of history tables and other large tables.
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views when required.
Created Production scripts for DB Objects.
Analyzed Production issues to determine root cause and provided fix ASAP.
Implemented business process, database retrievals, access of information and User Interface using Struts framework.

Confidential

Module Lead

Responsibilities:

Development of CRM OD extractions using the extraction framework. Involved in extraction of opportunity, event, account plan, NBC objects from multiple instances of CRM OD to single DB Instance
Worked on data modeling and Created Tables, Views, Constraints, Index and other oracle objects based on the given requirement
Development of PL/SQL packages to sync the daily extracted data from stage tables to the XT tables.
Worked on SQL*Loader to load data from flat files to oracle tables.
Data validation of data for use in presentations, metrics, and reporting of information.
Worked on table partitioning and fine tuning to improve the performance and maintenance of the table

Confidential

Developer

Responsibilities:

Worked on data modeling and Created Tables, Views, Constraints, Index and other oracle objects based on the given requirement
Created oracle procedures and packages to get the group level and project level Escalation details.
Created GTT, Partitions, indexes, triggers, hints to improve DB performance.
Created UNIX shell Scripts according to the needs of the project.

Confidential

Developer

Responsibilities:

Customer data is gathered from other modules through complex queries and PL/SQL packages to get the status of the customers.
Imported and exported data from text files, CSV files, or databases to Excel for data manipulation and analysis.
Created pivot tables and charts using worksheet data and external resources
Extensive data validation and analysis using pivot tables, formulas (v - lookup and others) and conditional formatting.
Fine-tuned procedures/SQL queries for maximum efficiency

Confidential

Developer

Responsibilities:

Involved in Design of PNR Module
Developed java Batch Jobs for PNR Reports(Claim and payment Reports).
Worked on continuous enhancements and fixing of production problems for PNR reports