RAM JASTI

** ****** ***

Monmouth Junction, NJ **852

732-***-****(C) abmq1e@r.postjobfree.com

INFORMATION TECHNOLOGY PROFESSIONAL

Extensive experience in relational database design, development and

implementation. In-depth knowledge and expertise in data architecture,

database development (PL/SQL, Pro*C), database administration, data

warehousing, ETL(Informatica), PERL, shell scripting and performance

tuning. Excellent project management and leadership skills with proven

ability to manage on-shore and off-shore database development teams.

TECHNOLOGY

Operating Systems SUN OS Solaris 5.8, UNIX, WINDOWS NT, RedHat Linux

4.3

Languages PL/SQL, C, PRO*C, PERL, UNIX, Shell Scripting, JAVA,

JavaScript, XML, XSL, XSLT, Visual Basic and Active Server

Pages

Databases ORACLE 9i/10g RAC /11g RAC/ASM, SQL Server 2000, SYBASE

Tools Microsoft Project, ERWin, VISIO, SQL Navigator, Documentum 4.2,

Informatica Power Center 6.5/8.1,Data Pump /exp/imp

ERP Systems JD Edwards One World, Oracle Applications

PROFESSIONAL EXPERIENCE

MARSH, Hoboken, NJ 2006 - 2010

Data Architect/Development Lead

Responsible for designing, developing database solutions for several

applications.

. Extensive experience in conceptual/logical and physical modeling.

. Worked in both 3NF and Dimensional modeling approach.

. Member of architectural review board, responsible for ensuring that

project teams adhered to architectural guidelines.

. Extensive experience in data modeling, analysis, and design activities

for key business projects.

. Created and maintained enterprise data documentation, including data

dictionaries, E/R diagrams, and data flow diagrams.

. Designed and developed a logical and physical data model using ERWin to

store account and opportunity data for opportunity management system.

. Extensive experience in designing data models in data warehouse and data

marts.

. Conducted data model design review meetings to make sure data model meets

application requirements.

. Designed and developed a database schema to store Marsh Names and

Inventory information. Created batch jobs to process data feeds from Dun

and Bradstreet on a monthly basis.

. Recruited and coached on-shore and offshore SQL developers.

. Responsible for providing resource estimates and resource assignments

based on project priorities.

. Created sql development standards and best practices documents for SQL

development team.

. Designed and developed data loading programs using PERL and PL/SQL

Packages. Oracle Procedures were executed from PERL scripts using DBI/DBD

modules.

. Extensive experience using oracle data pump, export/import and SQL loader

utilities.

RAM JASTI

Page 2

MARSH, Hoboken, NJ Data Architect/Lead Developer (continued)

. Developed complex stored procedures, database triggers, and data

conversion programs necessary for Opportunity Management System. Improved

performance of search queries.

. Extensive use of oracle collections and bulk operations to improve

performance of data migration projects.

. Designed several ETL mappings to automate loading opportunity data from

different countries on a daily basis into opportunity management system.

. Designed and developed data warehouse for opportunity management system.

Designed and developed several ETL mappings to load transactional data

from OLTP databases in to data warehouse database.

. Extensive experience creating oracle partitions, materialized views and

external tables.

. Oracle Database Tuning and Performance - usage of statspack, AWR, ADDM,

ASH and UNIX native commands

. Streamlined database change process and decreased application deployment

timelines by 30%.

. Streamlined the database refresh process to reduce application down time

for non-production environments by 50%.

. Planned and managed database implementation tasks for complex application

releases and worked with several project teams to finalize the release

play book.

Ethicon, a Johnson and Johnson Company, Somerville, NJ 2004 - 2006

Senior Consultant

Designed and developed oracle extract programs that extracted data from JD

Edwards ERP system and loaded the data in to a Common Advance Planning

system (APS) database using PL/SQL.

. Developed database Triggers, Stored Procedures, Packages, Sequences and

grants scripts. Performed performance tuning by running explain plan and

Tkprof utilities on all the major queries in these data extracts.

. Developed 30 extracts and worked as single point of contact for oracle

extracts and integration testing. Designed and developed a process for

resubmitting error records to be processed by web methods integration.

. Designed and developed a purge process to clean up processed data from

staging tables based on the retention requirement for each web method

integration.

. Developed implementation plans and coordinated deployment of this project

to QA and Production Environment. Actively involved in Integration and

Load Testing.

. Assisted project team to document issues and resolutions for the entire

project.

JPMorgan Chase, Wilmington, DE 2002 - 2004

Data Architect Application Development Lead

Designed and developed database schemas and database objects necessary for

several applications. Worked on design, development and implementation of

Enterprise Data Warehousing processes and Data Marts.

. Created logical and physical data model necessary for corporate employee

repository.

. Involved in the design, development and Implementation of the Enterprise

Data warehousing process and Data Mart. Used Informatica Power Center 6.2

for migrating data from various OLTP databases to the data mart. The Data

Migration Included identifying various databases where information/data

lay scattered, understanding the complex business rules that need to be

RAM JASTI

Page 3

JPMorgan Chase, Wilmington, DE, Application Development Lead (continued)

implemented and planning data transformation methodology. Relational

sources and flat files to populate the data mart. Translated the business

process in to informatica mapping for building the data mart. Created

complex informatica mappings to load the data mart and monitored them. The

mapping involved extensive use of transformations like Aggregator, Filter,

Router, Expression, Joiner, Sequence generator.

. Designed and developed applications using Oracle Tools such as PL/SQL and

PRO*C. Extensive experience with all the features available in PL/SQL

like dynamic SQL and XML SQL Utility (XSU).

. Implemented Enterprise Content Management system using Documentum

software. Responsible for setting up batch jobs that calls JAVA programs.

Developed several Java classes using docunentum Foundation Classes to

extract and manage content in the docbase. Extensive use of XML/XSL and

XSLT to generate marketing material dynamically.

Bank One, Wilmington, DE 1998 - 2002

Database Consultant

Designed and developed data loads and data conversion programs in human

resources department.

. Implemented oracle HR module using ORACLE Applications. Worked

extensively with Oracle HR APIs. Developed several stored procedures and

loading scripts to convert data from legacy system into Oracle HRMS

application.

. Designed and developed conversion programs to convert data from Oracle HR

application to Peoplesoft HR application to integrate FirtUSA Bank

employee data to Bank One HRMS application.

Bluestone Consulting, Mount Holly, NJ 1996 - 1998

Sapphire/Web and Oracle Consultant

Worked as Oracle database developer and implemented Sapphire/Web software

for below clients.

. Merck & Co., Inc., Whitehouse Station, NJ

. Bell Atlantic Directory Graphics, Valley Forge, PA

Burlington Coat Factory, Burlington, NJ 1994 - 1996

Programmer Analyst

Maintained and upgraded existing screens and reports for the sku system

using Oracle Tools like SQL*Forms 3.0/4.5, SQL*Report writer 1.1/2.5, PRO*C

1.1.

EDUCATION

M.S., Computer Science, Villanova University, Villanova, PA

B.S., Mechanical Engineering, Shivaji University, India

Professional Certifications

Project Management Professional (PMP) - Project Management Institute (PMI)

- 2005

Contact this candidate