SRIRAM GUDURU

Over nine years of experience in Oracle PL/SQL with full project life cycle experience including

analysis, design, and development of Object Oriented solutions in complex heterogeneous environment.

Have good knowledge in Pro*C. Extensive Data warehousing ETL experience on Star Schema using

Informatica PowerMart, Power Center 6.x/7.x/8.x. Played leadership roles involving development,

coordination, problem resolution and status reporting. Have good interpersonal, analytical and

communication skills.

SKILLS:

Languages: SQL, PL/SQL, C, C++, Pro*C, Shell Scripts

RDBMS: Oracle 7.x/8i/9i/10g, Sybase, DB2, MS-Access, and SQL Server

Others: Informatica 6.x/7.x/8.x, Business Objects 6.x/5.x/4.x, SAP-ABAP

Tools: SQL*Plus 9.2.0.1.0, SQL* Loader, Toad, DBArtisian, Crystal Reports, Control – M

(Scheduler), Tidal (Scheduler).

GUI: Visual Basic

Op. Systems: UNIX AIX/HP/Solaris, Windows XP/2000/NT/95/98 and Novel NetWare

Education: MS Computer Science (Madurai-Kamaraj University)

EXPERIENCE:

Sedgwick CMS, Memphis, TN May 09 - Present

PL/SQL Developer

Responsibilities:

• Validating the Mappings, Generating & Loading the Data.

• Worked in Performance Tuning of Informatica Mappings.

• Worked on various transformations like Source Qualifier, Joiner, Filter, Router, Look-up, Aggregation.

• Creating the Dimensions, Facts, Mappings & Transformations

• Extensive use of Star Schema method in the data warehouse.

• Deployment of Informatica Objects.

• Developed stored procedures and complex packages extensively using PL/SQL.

• Developed packages, procedures and functions using PL/SQL.

• Assist end users by defining and resolving reporting problems with the aid of existing applications or

reports.

Environment: Oracle 10g/11i, Toad 9.5, XML and UNIX.

Transplace Inc, Frisco, TX Nov 08 – Apr 09

ETL Developer

Responsibilities:

• Performance tuning of Query reports.

• Developed triggers, packages, procedures and functions using PL/SQL.

• Extensive use of Collections like VARRAY, Nested Tables and Indexed-by-tables in PL/SQL.

• Responsible for developing and enhancing robust Crystal reports.

• Assist end users by defining and resolving reporting problems with the aid of existing applications or

reports.

• Build new crystal report templates that meet those objectives

Environment: Oracle 10g/11i, PL/SQL Developer, Crystal Reports.

Litton Loan Servicing LP, Houston, TX Apr 08 – Oct 08

(Affiliated to Goldman Sachs)

Page 1 of 4

E-Mail: abnsuo@r.postjobfree.com Cell: 713-***-**** Home: 713-***-****

SRIRAM GUDURU

Developer

Responsibilities:

• Validating the Mappings, Generating & Loading the Data.

• Worked in Performance Tuning of Informatica Mappings.

• Deployment of Informatica Objects.

• Extensive use of Transformations in Mappings.

• Performance tuning of PL/SQL Scripts.

• Handling of data related to Collection Department, Loan Department.

Environment: Informatica, 6.2/7.1.4/8.1.1, Oracle 8/10g, 11i, PL/SQL, TOAD 9.5, SQL Navigator

5.5, Shell Scripts, UNIX – HP-UX, Windows XP/2000, Clear Case

Hewlett-Packard Inc., Houston, TX Apr 07 – Mar 08

Developer

Responsibilities:

• Validating the Mappings, Generating & Loading the Data.

• Worked on various transformations like Source Qualifier, Joiner, Filter, Router, Look-up, Aggregation.

• Creating the Dimensions, Facts, Mappings & Transformations

• Worked in Performance Tuning of Informatica Mappings and Sessions.

• Deployment of Informatica Objects.

• Extensive use of Transformations in Mappings.

• Extensive use of Star Schema method in the data warehouse.

• Building package in Unix for migration.

• Interacting with SAP through Informatica

• Implementation of Secure FTP (SFTP) in Shell Scripts.

• Extensive use of Shell Scripts.

• Executing PL/SQL Scripts from Unix Scripts.

• Performance tuning of PL/SQL Scripts.

Environment: Oracle 9i/10g/11i, PL/SQL, TOAD, Informatica 6.2/7.1.4/8.1.1, SAP, Shell Scripts,

UNIX – HP-UX B.11.23, Tidal Scheduler, Attachmate Reflection 14.0.1, Clear Case

Devon, Oklahoma City, OK Dec 06 – Mar 07

Developer

Responsibilities:

• Informatica Designer tools were used to design the source definition, target definition and

transformations to build mappings

• Developed programming using Power Center Client tools.

• Creating the Mappings & Transformations

• Deployment of Informatica Objects.

• Worked under Star Schema environment.

Environment: Oracle 9i, PL/SQL, TOAD 8.0, Informatica 7.1.2/7.1.4., Star Schema, Visual Source

Safe.

J.P. Morgan Chase, Houston, TX Apr 06 – Nov 06

Developer

Responsibilities:

• Developed triggers, packages, procedures and functions using PL/SQL

• Shell scripts creation for automatic backup and file recoveries.

Page 2 of 4

E-Mail: abnsuo@r.postjobfree.com Cell: 713-***-**** Home: 713-***-****

SRIRAM GUDURU

• Informatica Designer tools were used to design the source definition, target definition and

transformations to build mappings

• Worked in Performance Tuning of Informatica Mappings and Sessions.

• Deployment of Informatica Objects.

• Extensive use of Autosys Scheduling application.

Environment: Oracle 9i/10g, PL/SQL, TOAD/DBArtisian, Informatica 7.1.2/7.1.4, Autosys 4.5,

Shell Scripts and UNIX – Sun Solaris 5.10.

CVS/Pharmacy, Woonsocket, RI Aug 05 – Mar 06

Programmer

Responsibilities:

• Developed stored procedures and complex packages extensively using PL/SQL and complex shell

programs for the enhancements of an application level data warehouse.

• Extracting and Cleaning up the high volume of data by using PRO*C.

• Shell scripts creation for automatic backup and file recoveries.

• Creating shell scripts for utilizing UNIX utilities in users applications, file conversions & migrations

• Extensive use of Star Schema method in the data warehouse.

• Informatica Designer tools were used to design the source definition, target definition and

transformations to build mappings

• Creating the Dimensions, Facts, Mappings & Transformations

• Worked in Performance Tuning of Informatica Mappings and Sessions.

• Interacting with Microstrategy through Informatica

• Extensive use of Control – M Scheduling application.

• Document data flow and application flow.

Environment: C/C++, Oracle 9i, PL/SQL, TOAD, Pro*C, Informatica 7.1.2, MicroStrategy,

Control - M, Shell Scripts and UNIX, PVCS

Honeywell Inc, Morristown, NJ. May 03 – Jul 05

Programmer/Analyst

Responsibilities:

• Developed triggers, packages, procedures and functions using PL/SQL.

• Massaging of data by embedding SQL in Pro*C

• Creating shell scripts for utilizing UNIX utilities in users applications, file conversions & migrations.

• Informatica Designer tools were used to design the source definition, target definition and

transformations to build mappings

• Developed programming using Power Center Client tools.

• Validating the Mappings, Generating & Loading the Data

Environment: C/C++, Oracle 9i/8i, PL/SQL, PRO*C, Shell Scripts, PERL, Informatica and UNIX,

Visual Source Safe

Goldman Sachs Mar 02 – May 03

Oracle Developer

Compensation Accounting System (CAPS)

Responsibilities:

• Production Support

• Query Optimization

• Creation of Stored Procedures using PL/SQL

• Coding Shell scripts for batch jobs

Page 3 of 4

E-Mail: abnsuo@r.postjobfree.com Cell: 713-***-**** Home: 713-***-****

SRIRAM GUDURU

Environment: C/C++, UNIX, Oracle, PERL and Windows NT 4

Rapidsoft Networks Ltd., Hyd., India Sep 99 – Mar 02

Programmer

Intra Mall Application

Responsibilities:

• Developed Pro*C programs for loading data with updates.

• Developed database procedures, functions and triggers using PL/SQL.

Environment: Oracle, PL/SQL, UNIX, Shell Scripts, Pro *C.

Page 4 of 4

E-Mail: abnsuo@r.postjobfree.com Cell: 713-***-**** Home: 713-***-****

Contact this candidate