IT Analyst Resume

PROFESSIONAL SUMMARY:

To seek a responsible position as a Programmer Analyst
Over Five Years of e xtensive experience as Developer/Data Analyst in Oracle PL/SQL and JAVA/J2EE design, development and implementation of Banking, Telecom and Insurance Applications.
Having sound knowledge in Data Warehouse concepts, ETL, Performance Tuning and MS Office applications
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
Developed java/J2EE application using Struts and Hibernate framework.
An excellent communicator with exceptional Interpersonal Skills, ability to interact effectively with clients and have Valid EAD (no sponsorship required).

TECHNICAL SKILLS:

Java Tools and Technologies: Core Java, J2EE(Servlets and JSP), JDBC, Struts1.3 and Hibernate, Eclipse

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

Operating Systems: Microsoft Windows and UNIX.

Build Tool and source Control: Ant and SVN

PROFESSIONAL EXPERIENCE:

Confidential

IT Analyst

Responsibilities:

Customer data is gathered from other modules through complex queries and PL/SQL packages to get the status of the customers.
Used Bulk Collections and PL/SQL tables for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
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

Confidential

Production support

Responsibilities:

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.
Worked extensively on Ref Cursor, External Tables and Collections
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views when required.

Confidential

Module Lead

Responsibilities:

Development of CRM OD extractions using the extraction framework.
Involved in extraction of opportunity, event, account plan, Confidential 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.
Worked on table partitioning and fine tuning to improve the performance and maintenance of the table

Confidential

Front-Line Manager

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.