Ramesh Gummadavelli

aceqbt@r.postjobfree.com

**** **** ****** **** #***, Austin, TX – 78717

• Database professional with extensive experience in PL/SQL development using Oracle 11g/10g/9i/8i/XE.

• Expertise in writing stored procedures, packages, BULK collections and analytical functions in PL/SQL.

• Experience in data warehouse development and ETL routines.

• Experience with big data tools such as Hadoop, HDFS, Sqoop, Pig, Hive and Impala.

• Several years of functional and technical expertise in the field of smart meter data management system

(MDMS) at an electric utility company.

• Serving as Subject Matter Expert (SME) of MDMS with in the company.

• Experience in architecture and design of interfaces and batch programs that are currently processing large

data sets of smart meter readings.

• As a core member of a small team I played an instrumental role in design, development and deployment

of our MDMS that is currently supporting PGE’s AMI consisting of 830,000+ smart meters.

• Our team is embedded in business group for faster and better requirement-gathering and development.

Skill Set:

RDBMS Oracle 11g / 10g / 9i / 8i, XE; SQL and PL/SQL

O/S Unix (AIX, HP-UX), Windows

Tools SQL Plus, TOAD, Subversion, TortoiseSVN, Cruise Control (automated unit testing

and code deployment), DataStage 8.5, Version One, AppWorx

Methodologies Waterfall, Agile (SCRUM, Kanban), Software Development Life Cycle (SDLC)

Big Data Hadoop (Cloudera distribution), HDFS, Sqoop, Pig, Hive and Impala

Education: Master’s degree in Mechanical and Aerospace Engineering, University of Missouri

Training: Cloudera Data Analyst Training - Pig, Hive and Impala, Cloudera Essentials for Apache Hadoop

Professional Experience:

Senior Developer Analyst, Portland General Electric (PGE), Portland, OR 05/2001 – Current

Designed and developed PL/SQL based ‘Interval’ and ‘Register Reading’ meter data analysis engine (a.k.a VEE)

that analyzes and flags incoming meter data (about 100 million records per month).

Designed and developed PL/SQL based Time of Use (TOU) calculation engine that processes high-volume smart

meter data for billing, demand response program (a.k.a. Critical Peak Price) etc.

Participated in ‘Outage Analytics’ application development using open source big data tools. Sqoop was used for

migrating data in to and out of Hadoop. Created Hive tables on smart meter interval data files and ran Hive

queries on data for analysis. Basic data filtering was done using Apache Pig.

Ramesh Gummadavelli

aceqbt@r.postjobfree.com

9400 West Parmer Lane #537, Austin, TX – 78717

Designed and developed smart meter interval data warehouse that is currently processing about 1 billion interval

data records per month for data quality analysis, load research, Green Button initiative etc.

Developed ETL (Extract Transform Load) routines, using PL/SQL, to migrate data from MDMS (OLTP) to smart

meter interval data warehouse on a daily basis. Also wrote database programs to process large data files (csv files)

into the warehouse on a daily basis.

Developed meter communication percentage reports, data quality reports etc. from smart meter interval data

warehouse.

Designed and developed data interfaces between MDMS and various internal and external systems (such as CIS,

Load Research etc.).

Used various features of Oracle and PL/SQL (such as BULK collections, analytical queries, and associative

arrays) in developing efficient processes to enable operations team meet their SLAs.

Worked on performance tuning of SQL statements and Pl/Sql programs by identifying bottlenecks and addressing

them with various measures such as table partitions, sub-partitions, index hints, parallel processing etc.

Used DataStage Designer 8.5 to load data from production to various test and development databases.

Created Oracle Advanced Queues (AQs) for transfer of messages between MDMS and Web Sphere gateway.

Created database routines for exchanging transactions between MDMS and Sensus RNI (Regional Network

Interface). Sensus RNI is the network that maintains, communicates and collects data from all the smart meters in

the field.

Our home-grown MDMS won the following awards:

In 2009, Metering America award for 'most innovative implementation of meter data management

systems in North American utilities'.

In 2008, 'Chartwell Best Practices Award for Advanced Metering and Data Management'.

Senior Consultant, Syntel Inc. 09/1999 –

04/2001

Client: Tektronix, Inc., Beaverton, OR

Involved in development and maintenance of Oracle Applications 10.7 and 11i. Development included

implementing Option Keys enhancements for Order Entry (OE) module of Apps. As part of this development,

created database objects, value sets, descriptive flexfields etc.

Involved in conversion of existing Oracle Apps 10.7 custom programs to Oracle Apps 11i version (Order

Management).

Ramesh Gummadavelli

aceqbt@r.postjobfree.com

9400 West Parmer Lane #537, Austin, TX – 78717

Involved in a data warehouse project integrating different database applications at Tektronix. As part of the

project, developed ETL (Extract Transform Load) interfaces from various marketing databases to a marketing

data warehouse. Used Informatica PowerMart 4.7 and Oracle PL/SQL in building the programs for extraction,

transformation, and loading of data into data warehouse.

Involved in developing stored procedures, functions and packages in Oracle as part of implementing B2B

initiatives at Tektronix.

Client: Teldata Solutions, Portland, OR

The project involves implementing Electronic Data Interchange ( EDI ) solutions at Teldata Solutions as part of

their e-commerce strategy. Teldata Solutions is a Meter Data Management Agent (MDMA) facilitating automatic

transfer of meter reading data between consumers and Utility Distribution Companies and Energy Service

Providers (EDI 867).

Involved in development of packages, procedures and functions, which facilitated EDI transfer. The development

involved writing re-usable code, which could be configured, for various EDI implementations with fewer

modifications. Developed several procedures for 'Data Archiving' the data from database.

Staff Consultant, Oracle Corporation 10/1998 –

08/1999

Worked on several in-house projects involving application development using various Oracle development tools.

Extensively used PL/SQL for development of form triggers, database triggers, and stored program modules.

Oracle’s development methodology, Custom Development Methodology (CDM) 2.0, has been followed during

this development process.

Worked on projects involving implementation of various modules of Oracle Financials 11.0 with NCA

architecture. Involved in tasks like customizing the screens and reports, defining descriptive and key flex fields,

value sets, etc. creating and registering the concurrent programs, system administration functions involving

defining responsibilities, users, data groups, etc.

Consultant, Syntel Inc. 09/1996 –

09/1998

Client: Carlson Marketing Group, Minneapolis, MN

The project was to modify the existing applications and develop new applications as required. Carlson Marketing

Group's business is supported by numerous software applications. These applications have been analyzed for new

business requirements. During this project modifications were performed on various applications that were

identified.

Involved mostly in back-end programming like PL/SQL conversion and developing interface programs using

PL/SQL and SQL Loader.

Ramesh Gummadavelli

aceqbt@r.postjobfree.com

9400 West Parmer Lane #537, Austin, TX – 78717

Client: K-mart Information Systems, Troy, MI

The project involved implementing EDI methodology in K-mart International headquarters. EDI methodology has

been added to their existing application called 'Import 2000'. This is a retail application system developed with

Oracle as back-end. New programs were developed and added to the system so as to incorporate policy changes

and new functional requirements. Several SQL scripts have been studied, analyzed, and modified in order to

maintain proper functioning of the Import 2000 system.

Worked on Pro C programs, which were used to generate EDI files for invoice generation (EDI 810) etc. Some of

the programs were analyzed and modified to rectify the errors.

Client: Bureau of Employment Programs, Charleston, WV

Involved in developing and deploying various features for Risk Management System (RMS). RMS is a part of

'Worker's Compensation Insurance System (WCIS)' of State Government of West Virginia. WCIS is an insurance

application system used for determining policies, assessing premiums, and keeping track of business information

of all employees in the State of West Virginia.

During the project various sub-modules of RMS have been designed and developed in Oracle environment using

Designer 2000 and Developer 2000.

Used Designer 2000 to generate various database objects like tables and PL/SQL program units.

Used ‘Entity Relationship Diagrammer’ and ‘Data Diagrammer’ to create database tables and ‘Module Logic

navigator’ to create PL/SQL program units.

Participated in conversion of GUI of WCIS from Forms 4.0 to Forms 4.5.

Contact this candidate