Project Sql

GAUTAMI PINGALI

EMAIL: ***************@*****.***

972-***-****(H)/972-***-****(M)

PROFESSIONAL SUMMARY

Database Developer/ Software Engineer with strong IT background, primarily

in Oracle PL/SQL development for about 6 years and other areas of

expertise including:

. Design, development and testing of High Availability Distributed

Database System.

. Proficient in Oracle 10g/9i, PL/SQL Development with T.O.A.D and

PL/SQL Developer, Perl (DBI), UNIX, Korn Shell Scripting.

. Strong Experience in data warehouse Maintenance and Support on ORACLE

10G/9i databases using SQL, PL/SQL, SQL* Loader, PERL Scripts, Shell

Scripts, Business Objects, Oracle Express on Microsoft Windows and

Unix platforms

. Extensively used PL/SQL, built-in Oracle Packages, stored procedures,

functions, triggers, cursors and views for processing data, enforcing

referential integrity and needed business rules.

. Involved in Data modeling, designing for normalization and de-

normalization as per business requirements and also in performance

tuning.

. Good Knowledge in Oracle 10g/9i DBA concepts.

. Worked in challenging environments for companies like ETCC,

Blockbuster Inc, RIA Services Inc., (An affiliate of Nationwide),

Johnson & Johnson, GE, & Cisco Systems.

. Excellent analytical and problem solving skills and can work

independently.

. Excellent Communication skills and responsible team player.

. Quick learner with an ability master new concepts and applications.

TECHNICAL SKILLS

Operating Systems Windows NT/2000/2003, Solaris 10, HP-UX 10/11,

Linux

Programming C, C++, Visual Basic 6.0, Java, J2EE-struts, PL/SQL

languages programming

Web Technologies HTML, JSP

Script Languages JavaScript, Perl, Shell scripting

Tools XRunner, Toad, PL/SQL Developer

Database Oracle 10G/9i/8i/8, MS Access 2000, Sybase

Others Object Oriented Designing Methodology, UML, RDBMS

Concepts,

Certifications and other Credentials:

. Recipient of National Merit Scholarship (India)

. Initial Training Program (ITP) conducted by Tata Consutancy Services

(TCS) for all the emplyees.

. Got through Oracle Certified Associate (OCA) exam 1ZO-031:Introduction

to Oracle 9i:SQL

WORK EXPERIENCE

Electronic Transaction Consultants Richardson, TX

Aug 2009 - Till Date

Project: The Audit and Reconciliation Host - MDX (Miami Dade Expressway) -

Description: The Audit and Reconciliation Host serves as central

repository and system of record for all vehicle transaction and equipment

messages generated from the tolling zones. It also interfaces and/or

reconciles with each of the following

. Zone Controller Subsystem via the Toll Zone Host System

. Toll Zone Host System

. Violation Enforcement System (VES)

. Toll Enforcement System (TES)

. Customer Service Center System (CSC)

. Interoperability System (IOP)

. Digital Video Audit System (DVAS)

. Maintenance Online Management System (MOMS)

Once the vehicle passes through a lane all the transactions are

enqued, parsed and then the rules are applied to process those

transactions.

Responsibilities:

. Wrote stored procedures in pl/sql to enqueue and dequeue the

transaction messages

. Implemented the rules that include bucketing rules and other rules

to parse the transaction messages.

. Implemented the identification of duplicate transactions and

exceptioned transactions and applying special events processing.

Environment: Oracle 10G, PL/SQL, SQL*PLUS, PL/SQL Developer, Oracle Reports

Builder, Java.

Blockbuster Inc. Dallas, TX

Aug 2007- May 2009

Project: Allocation Redesign

Description: Worked on Allocation Redesign project that focuses on

increasing the customer satisfaction. According to the new design

allocations will be done at the local DCs. The logic will now be

distributed instead of centralized on one server. A server in each DC will

create the allocation plan needed to fulfill the demand for its home DC

customers.

Responsibilities:

. Involved in the data analysis.

. Involved with the Analysis and Design team to arrive at proof of

concepts

. Involved in the Database Design for the new tables.

. Worked on Advanced Queing for messaging from sql server to oracle

. Involved in fixing the production issues

. Designed and developed PL/SQL packages, procedures and functions,

triggers to implement this new logic

. Have written SQL statements for the reports

. Analyzed the current reports and modified the SQL statements for the

changes in reports

Environment: Oracle 10G, PL/SQL, SQL*PLUS, PL/SQL Developer, shell script,

dot net, sql server, UNIX, putty.

Blockbuster Inc. Dallas, TX

May 2007- July 2007

Project: Subscriber Ranking

Description: Worked on implementing the new logic to rank the subscribers

and also involved in the performance tuning. The ranking depends on the

following factors:

. Subscriber's duration with block buster online

. Number of gifts that the subscriber purchased

. Number of dvd issues reported by the subscriber

. Number of store exchanges

Responsibilities:

. Developed PL/SQL packages, procedures and functions to implement

ranking.

. Involved in the Database design for the creation of new tables.

. Worked on performance tuning as the subscribers are growing.

. Production support

. Fixing the issues then and there

. Maintain the code for any new changes

. Changed the SQL statements behind the crystal reports

Environment: Oracle 9I, PL/SQL, SQL*PLUS, PL/SQL Developer, TOAD,shell

script, unix

RIA Services Inc, (An affiliate of Nationwide Financial), Dallas, TX

Sept 2006-April 2007

Project: TMS - Daily Fee Calculation

Team Size: 1(Designation: Team member)

Description: Registered Investment Advisor (RIA) offers professional money

management services directly to plan participants based on individual

situations, goals and risk profile.

The project allows generating fee transactions as and when needed, based on

the daily balance. Instead of charging the fee for the whole quarter based

on quarter-end balance; this will provide more flexibility which means no

loss of revenue due to Plan terminations, or Participant terminations. The

fee collected from participants is distributed among 4 entities: 1. Money

Manager, Solicitor, PPA, and RIA Services. The project maintains various

profiles, plans, mgrs, solicitors, PPA, reps details. The plans, profiles,

mgrs, solicitor, PPA, rep information are imported daily from flat files.

The project allows activation and termination of the current participants

and plans. When the participant is terminated, the fee is calculated based

on how many days the participant was with that plan and the status is set

to 'Inactive'. The fee file and status file for participants is generated

daily.

Responsibilities:

. Designed and developed PL/SQL packages, procedures and functions,

triggers to implement business logic.

. Used External tables to read the data from flat files.

. Created many complex queries for providing the solution.

. Created a knowledge base of support cases for future references.

. Used Reports builder for verifying the already developed reports with

the new data set.

Environment: Windows XP professional, UNIX, PL/SQL, Oracle 10G, SQL*PLUS,

PL/SQL, PL/SQL Developer, putty, Reports Builder.

GE Lighting, Cleveland (Tata Consultancy Services Consultant)

Feb 2001- May 2002

Project: Digital Cockpit

Team Size: 3 (Designation: Team member)

Description: The Digital Cockpit has a JAVA front end where in the costs

incurred by GE Lighting in various Components can be seen. The actuals,

plans and estimates can be seen. The leaf level components are rolled up to

get the cost incurred for the top level components. Also the variance in

the plans and actuals can be seen. The employee data as well as the Payroll

data can also be viewed. The data in the Oracle database is got from the

extract from the ORACLE Financial Analyzer written in express language. The

loading of the data to the Database is done using PERL scripts.

Responsibilities:

. Developed Digital Cockpit System (extract programs in Oracle Express

language to extract data from OFA)

. Developed extract programs in PERL to get data from UNIX servers, Load

it in Oracle

database which is used by the JAVA front end) and

implementation of the same in Production.

. Generating PL/SQL stored procedures and functions, to analyze the

data, and identify format and value discrepancies, as part of a team

of two.

. Responsible for execution and monitoring of shell scripts.

Environment: Windows 2000, NT 4.0, UNIX, PERL DBI, UNIX shell scripts,

JAVA, SQL* PLUS,

PL/SQL, SQL*LOADER, Oracle Express Language, Oracle Express Administrator,

OFA, TOAD.

GE Lighting, Cleveland (Tata Consultancy Services Consultant)

Nov 2000- Jan 2002

Project: SPAN reporting - SMART Data warehouse

Team Size: 4 (Designation: Team member)

Description: SMART is Sales and Marketing Analysis and Reporting Tool.

There are 3 base modules in the project 1. EXTRACT 2. LOAD 3.Reporting.

EXTRACT module extracts data from LEGACY systems using COBOL and JCL and

store the data in flat files. The LOAD module loads the data present in

these flat files into Oracle database using PERL scripts and SQL * Loader.

Depending on the business requirements, various PL/SQL scripts are used to

further process the loaded data in the history database. Reporting module

takes the data from history database and prepares various reports using

Business Objects.

Responsibilities:

. Developed SPAN Reporting System (data extract programs in PERL to get

data from Oracle database.)

. Generating PL/SQL stored procedures and functions, to analyze the

data, and identify format and value discrepancies, as part of a team

of two.

. Running and monitoring shell scripts.

. Feature Enhancement and Production Support(24X7)

. Maintenance and performance tuning in the LOAD module

Environment: Windows 2000 professional, UNIX, PL/SQL, Oracle 9i, SQL*PLUS,

PL/SQL, TOAD, SQL * Loader, PERL, Business Objects, COBOL,

JCL.

Sibar Software Services (India) Ltd

July 2000 - Oct 2000

Project: Material Requirement Plan (MRP) for a Pharmaceutical company

Team Size: 3 (Designation: Team Member)

Description: The main function of this product involves reorder level

identification and purchase order management of the materials required for

the manufacturing of a drug.

Responsibilities:

Requirements gathering and Data base design,Development of design document,

Coding and Unit testing and Integration Testing,Have written Stored

Procedures in PL/SQL and Developed GUI using VB 6.0

Environment: Windows 2000, NT 4.0, Oracle 8, SQL *Plus 3.3, PL/SQL, Visual

Basic 6.0.

Sibar Software Services (India) Ltd

Mar 2000 - June 2000

Project: Online Resume Management

Team Size: 2 (Designation: Team Member)

Description:. The main aim of this Project is to maintain a ready to access

database of skilled people in various areas for an easy conduct of the

recruitment process It was posted in the web site www.sibar.com.

Responsibilities:

Analysis of the System and Design of the database, Identifying different

modules and their interdependency and coding.

Environment: Windows 2000, NT 4.0, Java, Servlets, JavaScript, MSFrontPage,

Oracle 8.

Research Center Imarat (RCI)

april 1999 - Dec 1999

Project: Characterization of a slot in a rectangular waveguide

Description: Characterization of a slot in a waveguide occupies a crucial

position in the design of Plannar Array Antennas.

Responsibilities:

. Analysis, Design and Testing of the system

Environment: Windows 98, Borland C.

Educational Qualifications

Master of Computer Applications (MCA)

Osmania University, Hyderabad, India

Bachelor of Science

Osmania University, Hyderabad, India[pic]

Contact this candidate