Data Project

Phani Saripalli, **********@*****.***, 919-***-****

PROFESSIONAL PROFILE

Performance oriented professional with 15 years of extensive experience in Oracle Database systems. Expertise is in broad

scope include Oracle Relational Data Modeling, Data Warehousing, Dimensional Modeling, Architecture, Extraction,

Transformation and Load (ETL) Analysis, Design, load performance, e Business technical and functional support, optimization,

full life cycle applications of development and mission critical production support; possesses high level of technical aptitude,

demonstrated proven ability to design, develop, lead, validate, deploy and support all phases of project life cycles in client server

architecture. Detail oriented and committed to deliver superior quality work.

EDUCATION

M.S. University of Florida, Gainesville, FL

TRAINING

• Oracle 11g, 10g, Advanced Oracle 9i, Advanced PL/SQL development and Performance Tuning.

• Microsoft .NET framework, SDLC, Agile Modeling, eXtreme Programming. UML

• Maestro job scheduling, Advanced UNIX Tools –Awk, Korn shell scripting, and Perl.

• Business Objects Enterprise, Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Analytics.

• Dimensional modeling, Informatica, OLAP, ETL design, tools and load performance.

• Clinical Trial Data Management, CFR 21 – FDA, CDISC and ECG standards, Good Clinical Data Transmission

Practices.

EXPERIENCE SUMMARY

• 15 years of extensive experience in Oracle databases (RDMS) and complete Software Development Life Cycle (SDLC).

• 13 years of extensive SQL utilities, PL/SQL Development, Performance and Tuning Experience.

• 13 years experience in Business Analysis, Design –high level, conceptual modeling, logical and physical database,

master –child detail data Referential Integrity, security and Entity Relationship Modeling (ERD). Enterprise Data

Warehousing, ETL architecture, Data mapping, Metadata, Conversion and Migration of data from OLTP to OLAP

applications. Kimball and Bill Inmon architectures for multi terabyte data warehouses, Dimensional modeling –star

schema, fact, dimensions, multidimensional Databases (MDDBs), Data Integrity and Quality.

• Expert in Decision Support Systems (DSS), OLAP Analytics, Business Intelligence, ETL tools, development and

support.

• 13 years of UNIX, korn shell scripting, cron, awk utilities, scheduling, batch support.

• Expert in Database Application support, performance tuning, RAC, Architecture, design, Parallel and multi terabyte

database batch processing.

• 6 years Customer Billing Service support in HP UNIX, MQ–Series (IBM).

• 4 years experience in Agile Modeling, eXtreme Programming, XML Database, Rational Unified Process (RUP) with UML

modeling.

• One year Techno Functional experience in Oracle Applications HRMS 11i (5.9,5.7)/ 11.03 iOracle HR, Oracle

Advanced Benefits (OAB) and Payroll API's, full life cycle HR core and Pay roll implementation.

TECHNICAL SKILLS

• Databases: Oracle 11g exadata, 11i (5.9, 5.7), 10g/9i/8i/8.x/7.x/6.0, NCR Teradata 5.0, BTEQ

• Operating Systems: Win 2K, IBM PC, HP UX, Sun Solaris, and Compaq Tru64 UNIX, Linux, IBM MQ series and OAQ

and Maestro job scheduling.

• Languages: SQL, SQL Plus, SQL Loader, PL/SQL, Pro*C, UNIX, Korn Shell Script

Phani Saripalli 1

• ETL OLAP Tools: ETL tools Informatica 6.0, 7.1 PowerCenter, PowerMart, SQL Loader, SQLNavigator 4.0, Toad 7.3,

PL/SQL Developer.

• Data Modeling Tools: Oracle CASE Designer, Microsoft Visio, AllFusion ERwin.

• Source control tools: Rational PCVS–ClearCase, MicroSoft Visual SourceSafe.

• Job Scheduling: Control M, Tivoli Workload Scheduler (Maestro), UNIX Cron, Korn Shell Scripting, Hummingbird.

• Miscellaneous: RemoteWare, FTP, Telnet, PGP (Pretty Good Privacy), Syncsort, Mercury Quality Center, Electronic

Records and Signatures, CFR 21, part 11 FDA compliance, GCP, GAMP,SOX, EDI, XML, Tuxedo.

•Methodologies, Architecture: SDLC, Waterfall, Agile modeling, eXtreme Programming, Test Driven Designs, Objected

Oriented Programming (OOP), Rational Unified Approach(RUP), Service Oriented Architecture (SOA), Service Oriented

Frameworks and Business Intelligence tools, Clinical Trial methodologies and practices.

INDUSTRY EXPERIENCE

• Credit Suisse Investment Bank: Global HR IT, Financial – Structured products, Mortgage Based Securities, Brokerage

Product control –Global Trading Transactions

• Fidelity Investments: HRMS Payrolls for internal clients.

• Glaxo Smith Kline, Eli Lilly, Quintiles: Clinical, Pharmaceutical Data warehouses.

• Detroit Edison: Utilities –Energy and Gas customer invoicing and billing.

• Applied Benefits Research: Health Insurance Carriers.

PROFESSIONAL EXPERIENCE

Data Architect/Lead Software Programmer

Quintiles, Morrisiville, NC

Project: Clinical Trials Management, ODS/DF Aug’10 – current

• Responsible for the data analysis, design, architecture and implementation of operational data stores (ODS),

data factory, subject data marts for the clinical trial, clinical studies and clinical project management data (Bill Inmon –

data factory and Kimball’s EB architecture)

• Delivered key initiative Oracle Siebel Clinical Trial Management System integration project, contributed to

Operational data factory integration for 60 key entities, subject areas of Protocol, study, site, investigator, visit and

clinical visit, patient document areas.

• Designed Clinical ECG patient data integration to ODS. Standardized proprietary ECG trial visit patient data

with CDISC, SDTM, Metata data and Clinical Oracle Data Factory. Provisioned to integrate for internal and external data

vendors of various formats data eXML, eData Capture, eScribe and industry standard ECG Waveform data. Developed

transformation process, computation and ETL Logic for ECG Waveform, Accession, ECG patient Test and ECG patient

Test Results data.

• Designed partitioned strategies for reporting performance leveraging oracle 11g Exadata server.

• Extensively documented the functional, technical specs, process flows, ERDs, metadata and mapping

documents required for data warehousing, in compliance with FDA – CFR 21 part11, CDISC, SDTM and SLC, ELVIS

documentation standards, SOPs and Clinical Regulations.

• Led the design, ETL and offshore development teams to design and develop ECG integration. Designed CDC

process to capture incremental loads. Organized and engaged PM’s, project stake holders and Business Analysts for

delivery of the project. Developed aggregation, transformation procedures, functions and packages.

• Performed critical role leading the logical and physical conversion of design, developed metadata, mapping

documents, resolved potential data issues, optimized the design, validated the mappings for clinical data.

Environment: Oracle 11g – Exadata, PL/SQL, stored procedures, packages, functions, Oracle Siebel –CTMS, Oracle clinical,

Master Data Management, Oracle CDC, Metadata, Erwin 7.3, Toad10.2, Unix,Visual Studio 2005, Mercury Quality Center, Agile

Scrum Development, Elvis document repository, FDA –CFR 21, Clinical GDP, CDISC, SDTM.

2

Principal Data Warehousing Architect/Consultant

Credit Suisse, Research Triangle Park, NC July’08 –Aug’10

Project: Financial Product Control, Structured products, Mortgage Based Securities, Global Pricing, Fair value,

Brokerage, Complex Bank Financial Investments Data Warehousing

• Instrumental in Architecture, designing Financial Structured Product Control Data Warehouse crucial for the OLAP

Decision Support Systems – Web, adhoc and Excel reporting. Architecture of Dimensional model, Oracle 10g RAC

batch design, middle layer, presentation and automation of ETL batch process controlM auto scheduler jobs (ER

Logical and Dimensional Physical modeling, Kimball’s method, Partitioning, Indexing and Parallel Processing on RAC).

• Contributed and designed data ware housing batch jobs coding standards, created metadata standards, field mapping,

control M set up of batch process jobs, batch xml for global Bank regions America, Europe, Asia.

• Developed ETL batch programs for PC Results store using xETL framework on Linux, critical Financial Reference Data

for the data warehouse. Developed PL/SQL packages, procedures, functions for Trading P&L reconciliation. Prepared

and standardized the record layouts, inbound, outbound, upstream and downstream feed specifications to meet

customer requirements and SLAs. Extensively analyzed, documented user requirements for various financial product

control data marts.

• Extended and supported 24x7, the Data marts of Structured products, Mortgage Based Securities and various product

lines of client for P&L Trading, Accounting, Books, Deals, Risk and Control Break reports, Product Price Testing, trade

value, Oracle Business Intelligence – adhoc reports, building DW objects including dimensions, hierarchies, fact tables,

and aggregates, querying, Analytical reports (OBIEE) and key Corporate metrics for dashboards. Involved real time

support of reports and user issues, functional data fixes and performance issues. Developed and supported intraday

Messaging real time PC adjustments process.

• Optimized the complex queries of various ETL batch programs for faster generation of reports web and Excel Add in

reports. Generated TK profs, SQL traces and explained the queries. Indexed, hinted, de normalized and pre aggregated

for OLAP datamart performance. Enhanced and maintained in parallel, user testing Databases. Involved various batch

jobs scheduling, maintenance and support for global financial regions.

• Developed strategies for Oracle 10g RAC parallel processing, partitioning of data, Fact tables, Look up tables, partition

pruning and maintenance, gathering stats of Fact, Dimension, Indexing, de fragmentation, advance partition creation.

Created pre aggregated materialized views, rank based views, ETL procedures and packages. QA and functional user

Validation supported for system, integration and UAT phases.

• Oracle Business Analytics Warehouse for the financial products – design of Slowly Changing Dimensions (SCDs),

Type1, Type2 dimensions, conformed dimensions, mapping and design of Operational Source Systems to standardized

Fact loads. Developed back end procedures and packages.

• Maintained support documentation for various feeds of sources (200), over 1600 jobs of multi TB ODS, ETL time lines,

SLAs, resolved user Data issues in real time, 24x7 supported batch ETL for financial Data marts for global regions,

created and maintained visio diagrams of process flows, Job flows, Job group flows, XML job flows auto scheduler for

global regions.

Environment: Oracle 10g (10.2.0.4), RAC, Linux, xETL frame work, dot NET framework for advanced BI reporting, OLAP

Dimensional Modeling, ETL Parallel processing, partitioning, Sybase, MS Server, DB Artisan 8.0, PL/SQL, procedures,

packages, ERWIN DataModeler4, Business Objects, OBIEE, Oracle Business Intelligence, Oracle Business Analytics, XML spy

2006, UNIX, FTP, Korn shell scripts, Cron jobs, XML, XSLT, Java, web services, web logic server, IBM Rational clear case,

Microsoft VSS, Mercury Quality Center, SQL loader, Control M scheduler, SDLC, SOX compliance & Financial Securities

regulations.

Principal Software Engineer Developer/Lead Analyst

Fidelity Investments, Research Triangle Park, NC May’07 – June’08

Project: Oracle 11i HRMS and Payroll – implementation, customization and support

Phani Saripalli 3

• Extensively analyzed, participated and gathered internal client requirements for HRMS –functional areas of recruitment

New Hires, Terminations, Benefits –Earnings, Deductions, Employee Accruals and Payrolls.

• Involved in the setup steps, for defining key flex fields and descriptive flex fields. Created various lookups and value

sets. Worked with configuration and other Business users. Created elements, element links, balances and dimensions

for various information elements. Created plan information such as plan types, options, plans and programs to

appropriate compensation objects to streamline implementation process in OAB. Created set up scripts for payroll and

accrual elements.

• Provided functional and technical support in the areas of new hires, terminations, severance process, accruals, earnings

–SOEs, w2 process, garnishments and payroll deductions. Customized and enhanced HR and Payroll forms for the

clients based on the requirements given in Business cases and SLAs.

• Developed and enhanced Fast Formulas for new hires and accruals. Fixed the custom fast formulas for functional

issues. Designed and enhanced core HR and Pay roll modules, custom modules of check writer, deposit advice. Fixed

and enhanced custom costing process for the clients. Enhanced, tuned and managed data masking of secure employee

data in non prod databases, critical for development.

• Gathered functional and business requirements for small track enhancement projects, estimated LOE’s and

documented the requirements for approvals. Supported up gradation validated databases, applications and HRMS e

suite for the internal clients on multiple instances.

• Tuned for performance of batch modules for all clients in the HR core batch modules balance adjustments, account

balances, Tax scrubbing, SUI, SQWL, State, Federal and W2 processing packages. Created indexes, added hints

explained the complex queries and traced the pl/sql, optimized the modules for performance issues.

• Prepared test cases, user cases, involved in integration, system, customer QA, user acceptance phases, production

deployment and post validation.

Environment: Oracle Apps 11i/11.03 HRMS Core HR, Payroll, Benefits, Oracle Applications Implementation Methodology

(AIM),OAF, Korn shell scripts, Lotus notes, FESCO’s EDMS, PL/SQL, procedures, packages, functions, Oracle 10g/9i,

Developer 6i, Sun Solaris, UNIX, Hummingbird, SQL Navigator 4.5, PL/SQL developer, Problem tracker Kintana tool, IBM’s

clear case, FSDM FESCO Software Development Methodology, Secure Applications Development and Agile

Methodologies.

Principal Database Programmer/Assistant Vice President

Credit Suisse, Research Triangle Park, NC May’05 May’07

Project: Global HR IT applications merging, development, real time support

• Analyzed and responsible for the transition and support of HR IT portfolio applications of Employee People finder,

personnel data, HR Titles, key dates, organizational structure data. Designed, developed an intranet Jobs application for

Global employees.

• Maintained and supported global HR datamarts synching of data for HR IT applications and HRMS, daily batch jobs,

materialized views refresh, ETL data feeds import, export, sql loads and denormailized complex query tables for

performance.

• Instrumental in merger of two investment banks HRMS GL, PeopleSoft data sync up, data analysis, integration,

analysis, support of one common bank HRIT applications.

• Enhancements of Time and Leave Tracker, leave, OT rules, design, development and support, pay roll feeds regular

time, over time for US, Asia, Europe. Lead the development team, peer reviewed code, managed the resources,

coordinated and validation QA cycles, documented and trained user base.

• Global MIS reports head counts of employees, various reports key metrics reports for top management, merger of cost

centers, head counts of employees, consultants, product control and organizational rollup data. Designed, developed

and supported new Taleo jobs interface for internal jobs. Encryption and Decryption of HR data, jobs, synch up of data,

user recruiter and provided admin support.

4

• Enhanced over Time rules for pay regions of Australia, Japan and Asia pacific regions. Extensively supported and

enhanced HRIT applications eProcurement, IT answerbase, Performance management, e HR, Jobs Taleo, People

search, TREC reporting system for data quality, data issues, optimized the batch process and improved the

performance. Provided 24x7 batch support for HRIT datamarts.

• Project management involved contingent worker recruitment, utilization, pooling, logging of support issues, data quality,

pre merge and post merge data analysis, security issues, data integration, optimization, training, documentation, batch

deployment and support, source code organization of schemas, technical and infrastructure documentation, design,

development standards and procedures (SOPs) creation, compliance to firm’s regulations and rules.

Environment: Oracle 9.0.2.0.4, Oracle 10g 10.2, TOAD, PL/SQL, procedures, packages, functions, PL/SQL developer,

Hummingbird Exceed 8.2, HP UNIX, Control M batch jobs, Korn shell scripting, FTP, PGP encryption and decryption, Erwin,

Embarcadero’s DB Artisan, Clearcase, Microsoft VSS, Mercury Quality Center, SQL loader, .NET frame work, ASP, XML, XSLT,

Windows 2K, XP, NT and SQL servers

Senior Data warehousing Architect/Lead Database Programmer

GlaxoSmithKline, Research Triangle Park, NC Jan’05 – May’05

Project: Non Retail Pharmaceutical Markets and CDC Data warehouse

Development of Unix/Oracle business integrated platform for Aggregation and Alignment of non retail sales data into an

Operational Data Mart required for multiple business units.

• Analyzed, designed and developed non retail data mart (NRDM) for account based and non account based sales data.

Designed fact and dimension tables, star schema dimensional model. Created source to target data mapping, look ups,

error handling routines for data extraction, developed aggregation data integrity procedures, alignment of market data,

loading and aggregation into multiple star schemas.

• Tuned – performance of ETL transactions, loading and data retrieval queries using Explain Plans, SQL trace and

TKPROF. Created bitmap indexes, index organized tables, aggregates, materialized views, denormailized fact tables

and optimized star queries.

• Designed ETLoad batch process, created korn shell scripts to launch Oracle ETL jobs, Informatica workflows and log

status of jobs. Project management involved logging of potential data integrity issues, Data Quality Assurance – Data

integration, Granular reporting, monitoring, co ordination with QA, production deployment, verification and user manual

documentation.

Environment: Maestro Composer, Conman, Web based Tivoli Workload Scheduler, AllFusion ErWin4.1, Informatica 7.1

PowerCenter, and PowerMart, SQL Navigator 4.3, Hummingbird Exceed, VSS, Unix, PL/SQL, and SQL*Loader.

Senior Data warehousing Programmer

Quintiles Transnational Inc, Research Triangle Park, NC Nov’04 Dec’04

Project: Clinical Database Systems, Operational Data Store

Worked as a Database Programmer –Architect in analyzing the existing Operational Data Store of Clinical Database Systems

(CDS) for its data integrity potential issues, performance, ad hoc reporting, development, enhancements and support in

compliance with FDA regulations Electronic Records and Signatures (ERES), CFR 21 under part 11.

• Developed key metric reporting procedures for the ODS. Data Quality Assurance achieved for all the developed

procedures, functions and materialized views. Validated data in ODS schemas. Quality assured for reporting granularity

site, study, subject, region levels. Extensively documented the Analysis, Design, Code changes, proposals in

compliance with Electronic Records and Signatures, CFR 21, part 11.

Environment: Win2k, Oracle 9.02, PL/SQL, SQL plua, TOAD 7.4,Microsoft Visual Source Safe –source control tool and Lotus

Notes.

Data warehouse Analyst/Lead Application Programmer

Eli Lilly Pharmaceuticals, Research Triangle Park, NC Aug’04 Nov’04

Project: Pharma Chemical Library Management and Distribution System.

• Analyzed, collected, designed and proposed the changes needed to strengthen the existing LMDS application.

Designed physical changes to database tables and views.

Phani Saripalli 5

• Forte object framework is re designed and engineered under COTS project for the enhancements of Advanced

Queuing, web driven ordering content data capture. LMDSi –web intranet application enabled various global users to

access, process and utilize the ordering sampling application. Developed LMDSi –web intranet using Oracle 9i, XML

Database (XMLDB) for receiving and sending the Global Orders. Created global order datamart, facts, dimensions and

look up tables. Quality Assurance involved various stages of unit testing, system, integration, user acceptance and

Production.

Environment: Win2k, HP UNIX, Oracle 9 iAS internet Application Server, AllFusion Erwin 4.1, Oracle 9.02, PL/SQL, procedures,

packages, functions, SQL plus, Korn shell, SQL Loader, TOAD 7.0, Oracle XDK, XMLDB, Oracle AQ, XMLAQ, AQ Propagation,

FTP, LotusNotes, Microsoft Visio.

Data warehouse Analyst/Senior Database Programmer

GlaxoSmithKline, Research Triangle Park, NC, Jan’04 –Aug’04

Project: Sales Force Solutions Delivery Host and Laptop databases

• Enhanced and developed the Customer Management Support System by standardizing the physicians’ information

entered by the field representatives by matching them with the information supplied by Verispan, a provider of

healthcare.

• Enhanced and maintained the DataManager process, a vital Batch Processing Task that receives and transmits

transaction files between the GSK host database and the field representative laptop databases, synching master and

field data. Created new Maestro schedules, job streams and jobs. Provided real time support for batch processing jobs.

• Designed, developed, maintained and supported a new Automated Purging Process for cleansing the old data of SFSD

–Host data bases.

• GSK Market and Pharma Product Datamarts Data warehousing support involved enhancements, debugging of sql

scripts, indexing, denormalization of fact tables, creation of PL/SQL procedures and development of shell scripts.

Project management – Code Change and Version control involved logging of Change Requests, Development, Quality

Assurance (Unit, System, Regression and Production levels) and post deployment monitoring. Forecasting of changes

in GSK sales territories and communication of new creation of Sales Force teams, Data seeding and Data customer

support for territory levels – training, representative, divisional and regional levels.

Environment: Win2k, Compaq Tru64 UNIX, Oracle 9.02, PL/SQL, SQL plus, Sybase SQL Anywhere 8, Pro*C,

PL/Sqlprocedures, functions, Korn shell, SQL Loader, FastUnload, SQL Navigator, Tivoli Workload Scheduler Maestro, FTP,

RemoteWare, Telnet, SyncSort, PGP, Mercury TestDirector, Lotus notes, Microsoft Visio and Microsoft Visual SourceSafe.

Senior Data warehouse Specialist/Senior Programmer

Harford Insurance, CT Oct’03 Jan’04

Project – Insurance Data Warehousing, Auto insurance Data Marts

• Analyzed the customer requirements for creating Automobile Customer Insurance and Property Assessment Datamarts.

Designed table structures, materialized views and external tables for Customer and Property Assessment Datamarts.

Materialized views of daily, weekly, bi weekly and monthly refresh option are designed for loading snapshot, roll up

aggregate data.

• Designed Data Mapping, Maplets and ETL Transformations using Informatica PowerMart and PowerCenter for Loading,

Transforming, Processing and Cleansing of Data from external sources. Data Integration and Data Quality involved

preparation of test cases and validation against test and production Datamarts. Production support involved monitoring

of Daily Loading of data, periodical incremental Transformations and Informatica Batch ETL processing.

Environment: Win2k, Sun Solaris, Oracle 9.01, NCR Teradata 5.0, Basic TEradata Query (BTEQ) DDL, DML scripts, PL/SQL,

procedures, packages, functions, Export, Import, Fastload, Mulitload, Informatica 6.0, UNIX, SQL Navigator 4.0, SQL Loader,

Korn shell scripts, MicroSoft Visio.

Senior Database Programmer, Designer, Analyst

Detroit Edison, Detroit, MI May’98 – Oct’03

Project: Customer Service and Billing

6

DTE Energy is the main provider of Electric and Gas utilities in the Michigan State.

• Designed –high level, conceptual model, logical and physical database, master –child detail data Referential Integrity

and Entity Relationship modeling. Developed Entity Relationship Diagrams for OLTP –invoicing, billing and payment

modules.

• Designed and developed Interface Applications for Outage Analysis (OAS), Electronic Data Interchange (EDI),

Customer Vendoring and Conservation (CVC) with Michigan state, Customer Refunds and Write Offs for Electric

customers; Heating Assistance Program (HAP) for Gas FIA Vendoring customers. Designed and assisted in

architecture for IBM MQ AQ, advanced queuing of data records to enable real time processing of cross interface

applications with Legacy and Oracle databases.

• Maintained and supported enhancements for applications Work Management System (WMS), Field Service Automation

(FSA), Meter Reads (MRS), IVR Voice Response Unit (VRU) Telephonic Enrollment of Electric customers, Billing and

Payment Query and Financial Management System (FMS), OAS, EDI, CVC and Payment applications for electric

customers. Enhanced and supported electronic bill –payment application for data security encryption and decryption

using PGP. Production support 24x 7, tasks involved monitoring of batch processing, quick fix of problems, development

of Unix Shell scripts, job control files and maestro schedules.

• Data warehousing for residential customers involved process of migration and conversion of large volume of Legacy

data to Oracle Database using Extract, Transformation and Loading ETL tools. Involved in the Analysis, Mapping of

source and target database data, table structures, design of data file layouts, process flows, creation of stored

procedures, shell scripts, control files and creation of tables and materialized views. Designed Operational datamarts

(ODS) for services, products, and revenues for Energy customers. Created aggregates, look up tables, roll ups, OLAP

analytical reports for users. Developed pre aggregation, roll up procedures, views and snapshots for users.

Environment: Windows 95, NT4.0, Telnet –Hummingbird, UNIX, Korn Shell scripts, Tuxedo, IBM MQ series,Oracle 9i/8i/8.x,

SQL, PL/Sql 8.x, Pro*C, ETL, CASE Designer, Oracle Forms 4/5/6i, Reports 2.5, Microsoft Visio, PCVS ClearCase, RTS tools.

Senior Database Programmer Analyst

Applied Benefits Research, Palm Harbor, FL Oct’97–Mar’98

Project: Health Insurance plans and Billing.

Client is an Application Software provider for various Health Insurance Plans.

• Developed and enhanced of GUI application for different health insurance plans. Tested, debugged codes, and tuned

the application to enable real time processing of user query requests. Developed procedures, triggers and periodical

reports.

Environment: Oracle 7.3, PL/SQL, Oracle Forms 4.5 and Reports 2.5 Designer 1.2.

Database Programmer/Analyst

Regional Transport Corporation, Visakhapatnam, India. Aug’91 July’95

• Designed logic for migration and conversion of DB2 data to Oracle Database. Developed Entity Relationship (ER)

model, assisted in design of logical and physical database design. Developed stored procedures, functions and

database triggers for batch processing applications Inventory system, Cash Management System and Personal

Information Systems.

Environment: Windows 95, UNIX, SqlPlus, PL/Sql, Oracle Designer and, SQL Forms 3.0.

Phani Saripalli 7

Contact this candidate