Oracle Sql
Resume:
RAM YAGANTI
PH # 630-***-****(M)
EMAIL: ********@*****.***
PROFESSIONAL SUMMARY:
Around 15+ years of professional experience in design, development and deployment
•
of large software products in both Client/Server and Web Server Environment using
Oracle 9i, Oracle 8i / 8, Oracle 7.0/7.3, Oracle Web Forms 6i, Oracle Web Reports 6i,
Developer 2000, Designer 2000/6i, Discoverer 2000, Forms 4.5, Reports 2.5, Pro * C,
Sql * Forms 3.0, SQL PLUS and PL/SQL. Import and Export under UNIX, and
Windows NT environment that involves system study and analysis, design, coding,
preparation of user manual, testing and debugging of software, implementation and
training for users.
Designed and developed various applications using oracle products/tools for process
•
automations software into database server using pro*c, Unix shell scripts, pl/sql
packages, procedures and database triggers based on client/server and multi-tier
technologies.
Experience in designing and developing application systems using oracle extensive
•
suite during all phases of system development life cycle as well as data modeling
(UML), design and maintenance.
Experience working with Oracle application server and Oracle Internet Application
•
Server 9i. Proficient in backend programming using PL/SQL. Experience writing
interfaces, triggers, stored procedures and pl/sql packages to provide database
access and manipulation functionality. Created pl/sql procedures, packages,
functions, database triggers and other database objects to generate back-end and
front-end reports.
Solid understanding and proficient in PL/SQL coding.
•
Solid experience developing Oracle web applications using PL/SQL Web toolkit and
•
PL/SQL Server Pages.
Proficient in Query tuning and Optimization.
•
Experience in Data Warehouse/Data Mart Architectures and ETL process.
•
Experience in Dimensional Modeling and Star Schemas.
•
Experience with UNIX Shell Scripts and Perl scripts.
•
Collaborate in the planning, design, development, and deployment of new
•
applications, and enhancements to existing applications.
Meet with decision makers, systems owners, and end users to define business, and
•
operations requirements and systems goals, and identify and resolve systems issues.
Formulate and define system scope and objectives.
Understanding of how to analyze and solve business problems.
•
Thorough understanding of and ability to apply system development methodologies.
•
EDUCATION:
BS in Engineering, Nagarjuna University, INDIA.
•
Post Graduate Diploma in Computer Applications.
•
CERTIFICATIONS:
Oracle Certified Professional for developing Forms and Reports.
•
Microsoft Certified Professional.
•
Sun certified Java programmer.
•
TRANING:
Successfully completed Oracle 9i training in Backup and Recovery.
•
Successfully completed Oracle 9i training in Performance Tuning.
•
Successfully completed Oracle training in Oracle 9i Database Administration.
•
SUMMARY OF TECHNICAL SKILLS:
Hardware & OS*: Intel X86 Systems, HP 9000 Systems, Digital Systems, SUN SPARC, IBM/
MVS. UNIX (HP-UX, AIX and SUN SOLARIS), WINDOWS NT4 & NT 2000, WINDOWS 95,
SUNOS, LINUX, MS-DOS.
Software*: ORACLE version 6.0/7.0/7.1/7.2/7.3/8.0/8.1.7/8i Lite/9i/10g, SQL Net version 1 &
2, ORACLE Developer 2000/6i/9iDS, ORACLE Discoverer, ORACLE JDeveloper
2.0/3.1/9.0.2, ORACLE Designer 2000/6i/9i, SQL*Plus, Oracle Forms
3.0/4.5/5.0/6i/Web/Forms Server, Oracle Reports 2.5/3.0/6i/Web/Reports Server, Oracle Web
Server, Oracle 9iAS Application Server/Portal, LAWSON ERP V8, Oracle APEX, Yardi
Housing Software, Sales Force, Crystal Reports.
Languages*: C, Java 2.0, J2EE, EJB, PL/SQL, SQL, XML, DHTML, HTML, JavaScript, Perl,
CGI, Visual Basic 5.0,PRO*C, PRO*COBOL, Oracle PSP, UNIX Shell Scripting.
Tools*: ODBC, SQL*Plus, TOAD, SQL*Loader, Import & Export Utility, SQL*DBA,
Oracle Enterprise Manager (OEM), TKPROF, SVRMGR, Rational Clear Case (RUP & UML),
ETL, ERWIN, Visio, Sales Force Loader, Blue Wolf DRE, Oracle Data Guard.
PROFESSIONAL EXPERIENCE:
Discover Financial Services Oct’08 – To Date
Senior Lead Oracle DB Developer
Discover Financial Services (DFS) is a Fortune 500 financial services company based in the
US. DFS is principally engaged in issuing credit cards and offers electronic payment services.
The company offers credit and prepaid cards and other financial products and services to
customers based in the US and world-wide. Additionally, DFS also offers payment processing
and related services to merchants and financial institutions in the US.
The DCI application is comprised of five (5) Oracle databases: IPSE, GVDW, OLS, GLB and
SPO. The IPSE database is the file repository for the Information Products Data Feed (IP Data
Feed) files received from the Diners Club Franchises. All the 185 Diners Club Franchises
world-wide are required to provide the IP Data Feed for their Multinational Corporate Card
Accounts (MNCC) in addition to their local corporations on a daily basis.
The OLS database is the repository for the DCI Online Statements data feeds. There are
three different file feeds submitted by the non-DCNA franchises. These files are received on a
daily basis and loaded to the OLS database. The file contains both posted and billed
transactions to allow cardholders to view account activity since their last billing period.
Responsibilities:
Extensively used Unix Korn (ksh88) shell scripts, PL/SQL packages and procedures
•
for the ETL processes of both IPSE and OLS databases. These involved extracting
the data from the incoming data feeds, applying complex business logic and rules,
and finally loading the validated data into the master tables.
Developed Server side PL/SQL (Stored Procedures, Functions & Packages) for
•
implementing complex business logic and for validating the business rules in the data
load process. Extensively used PL/SQL collection objects to improve the loading
times.
W rote multithreaded SQL Loader code using Java for the OLS data load process.
•
This Java based data load process is used to load data feeds from Malaysia, New
Zealand and Singapore franchises. The multithreaded feature effectively improved the
data loading process times.
W rote UNIX shell scripts to spawn the SQL Loader job and to start multiple SQLPLUS
•
coprocessors for the daily load of IPSE data. The IPSE ETL process also creates
output files on a daily basis for onward submission to the DCI franchises. This output
file creation is accomplished by a set of SQL and PL/SQL scripts.
Used NAWK and PERL along with the shell scripts to create data scrambling routines.
•
These routines are used to mask the sensitive data (personally identifiable
information) during the data load process.
Used ANALYZE, DBMS_STATS, EXPLAIN PLAN, SQL TRACE and TKPROF to tune
•
the SQL queries.
Extensively used DBMS_PROFILER to identify and resolve performance bottlenecks
•
in PL/SQL ETL packages and procedures.
Extensively used UTL_FILE package to create output files, log the ETL process and
•
to load the data from external files that is exported from IPSE Server.
Used Unix Cron Job feature to schedule the ETL processes.
•
Used UNIX mailx feature to send emails on the ETL process and process logs to both
•
internal and external parties.
Provide enhancements and maintain the ETL processes.
•
Environment: Oracle 10g, AIX 5.3, UNIX Shell Scripts (Korn), PL/SQL, Java, XMLDB,
XML/XSD, SQL Loader, PERL, AWK, ANT, SQL*PLUS, Toad 9.6, Rational ClearCase,
TDCompress, Tivoli Maestro (work load scheduler) and Crystal reports.
RELOCATION MANAGEMENT TRACKING SYSTEM (RMTS)
Chicago Housing Authority, Chicago Mar’03 – Sept’08
Sr. Oracle Developer
Responsibilities:
• Provide enhancements & maintain the application.
• Customized generated forms and report through PL/SQL Web Toolkit, implemented
business rules by Head Start case tools, and managed all Designer tools.
• Developing web reports using PL/SQL Web Toolkit.
• Creating drill down reports using PL/SQL Web Toolkit.
• Designed ‘4+1’ view model of software architecture using RUP and illustrated use
cases.
• Using the PL/SQL web toolkit packages to dynamically publish database information
to the client browser.
• Developed PL/SQL (API) packages & stored procedures to retrieve & update the
database information.
• Developed a generic search utility using XML, JAVA & PL/SQL to query the database
& return the result set as per the search criteria. Implemented stateless paging to limit
the result set per page.
• Defined data structures to communicate the information retrieved from the database
so that the front-end package can reference the information.
• Created Shell scripts and Agents for automating day-to-day DBA activities like hot
backups etc…
• W orked with DBA to setup the database disaster recovery site at FIC. The recovery
site is setup as a physical standby (Data Guard configuration).
• Provide database support to the Oracle Database Administrator including:
maintenance, create user accounts, legacy data conversion, integration
with non-Oracle applications, database tuning, backups, data refresh and
disaster recovery.
• Creating database triggers and procedures to use DLLs as external procedures.
• Extensively used Oracle Materialized views to increase the speed of queries that
access large number of records.
• Used Perl string manipulation for processing URL text to extract various parameter
values and prepare data file to be used with sql loader for loading data into data base
tables.
Used Regular expressions in Perl to match patterns in URL text.
•
Used Perl’s file handling features to retrieve data and to generate the modified data
•
file.
Develop and execute quality assurance test plans for unit, system, and regression
•
testing.
W ork on tables with typically millions of records & access data across multiple tables
•
using complex joins.
Created UNIX shell scripts & PL/SQL procedures for the daily data refresh process.
•
Provide Technical support for all other applications (OBM, MPA, BIS, Agentis and
•
BOC) in CHA.
As a database developer, designed and developed generic schema for the client’s
•
data refresh process. Developed PL/SQL stored procedures, packages, and triggers
for data load and transformation, and data extraction (ETL). Optimized SQL queries
for efficient data load for backend database. Provided interface queries and
procedures for the front-end Java application.
Maintain the Sales Force application. Instrumental in optimizing the Sales Force
•
Refresh process and resolving bugs.
Hands-on experience in using Blue Wolf DRE tool and Sales Force SLOADER.
•
Hands-on experience on Yardi Housing Software. Created custom one-to-many tables
•
and custom interfaces in Yardi.
Developed and maintain the Yardi data refresh process. This ETL process is created
•
using PL/SQL stored procedures and packages. Extensively used collections and
materialized views to improve response times.
Created interface and data input screens for integration of accounts and properties in
•
Yardi-Lawson application.
Created ADA Survey Oracle database.
•
Fined tuned procedures and views in HOP application.
•
Trained both CHA and CHAC developers on SQL tuning methodologies.
•
Optimized poorly written queries in Yardi and other CHA applications by tuning Views,
•
SQL queries and PL/SQL routines.
Developed and maintain the ECS-Yardi data refresh process and the interface using
•
PL/SQL packages. Used PL/SQL profiler to identify performance bottlenecks in the
PL/SQL packages and tuned.
ETL architecture and design of data integration from different sources – legacy,
•
relational and flat files.
Identified performance issues in Yardi housing software application and help refactor
•
the code for optimal performance. The symptoms being observed and one or more
root causes identified were thoroughly documented and a knowledge base created for
future reference.
Collaborated in the planning, design, development, and deployment of new
•
applications, and enhancements to existing applications.
Mentored co-workers and other team members on both SQL and PL/SQL tuning and
•
optimization processes.
Provided database support to the LAWSON ERP application. Also developed adhoc
•
reports/queries to retrieve information from the ERP application.
Developed IVR (Interactive voice response) System for the CHA database. This
•
system enables the users and the residents in the HUD public and section 8 housing
units to call in and get the necessary information. It is a 24x7 system with response
times of the order of micro seconds. Extensively used method-R query optimization
process to improve the response times.
Support the operation and interaction of Lawson ERP application across its full suite
•
including Time and Attendance, Payroll, Human Resources, General Ledger,
Accounts Payable, AR and AC.
Created a nightly batch process (interface) to extract and load financial information
•
and Lawson to a target Oracle database. This is used for enterprise-wide reporting.
Involved in the conversion GL, AP and AC modules to accommodate new accounting
•
structure and accounting levels.
Involved in the data conversion and extraction of Vendor disclosure information that
•
loads data on a nightly basis to City of Chicago server. This process was created with
Oracle PL/SQL API packages.
Environment: Oracle 9i/10g, 9iAS/10, Oracle OEM, Oracle Developer 9i, Designer 9i, SQL *
PLUS, PL/SQL, Toad 9.6,Oracle Discoverer, Rational Rose(RUP & UML),PL/SQL Web
toolkit, PSP, JavaScript, HTML, XML XSLT, JDeveloper, ERWIN,Sun Solaris, Windows
2000/NT,CSS, CVS version control, Unix Shell Scripts, SQL Loader, PERL and Export/Import,
Lawson ERP V8 and Crystal reporting.
TIME INFORMATION MANAGEMENT SYSTEM (TIMS)
New York State, OMRDD Oct ’02 – Feb’03
Sr. Oracle Developer
Responsibilities Included:
• Involved actively in full life cycle of the project which includes analysis, design,
Modeling, table design, preparation of user manual, preparation of test plans and
development of the program using Developer 2000, Designer 6i & Discoverer
which is to be used throughout New York State OMRDD.
• Developed ERD, FHD using Designer 6i.
• Interaction with Development Team in fine Tuning the SQL and PL/SQL 8.0 Codes.
• Involved in migration of the data to Oracle 8i.
• Developed forms using Forms 6i.
• Involved in Migration of Forms to Forms 9iAS.
• Developing Test Plans and Test cases for coding.
• Coded Database Triggers in Toad 7.1 to manipulate the data in Oracle 8i.
• Involved in developing html pages to be deployed in Oracle Portal.
• Developed reports using Reports 6i.
• Effective use of Oracle Designer 6i, Developer 6i for generating
PDF Reports according to the client’s requirements.
• Developed Test Plans and test cases for coding.
• Provided User Training and dealt with customers of various degrees of computer
knowledge.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database
triggers including standard packages like DBMS_SQL, DBMS_PIPE, DBMS_JOBS,
UTIL_FILE, DBMS_OUTPUT.
• Developed SQL Reports using SQL*PLUS.
Environment: Oracle 8i, 9iAS, Forms 6i, Reports 6i, Designer 6i, Sql * Plus, PL
SQL. Oracle Web Forms 6i, Oracle Discoverer, Oracle Portal, Toad 7.1, AIX, Windows 98/NT.
FIRMS
Aztec Technologies, IN Mar ‘02 - Sept ‘02
Sr. Programmer Analyst
FIRMS, Food Inspection Requirement Management System is an application, which enables
the Food Inspectors and Sanitary officers to ensure safe food without any contamination. The
application has been developed to update the existing legacy system. Emphasis was on user
interface with the latest technology and to enhance the system so that the users can keep
better track of the information. I worked primarily with a number of screens and reports in
creating a customized oracle application. This included utilizing Oracle suite of application
design and development tools.
Responsibilities Included:
• Upgrade existing custom applications from Oracle Forms v4.5 to v6i.
• Migrating and upgrading the existing database from Oracle 7.3 to Oracle 8i
environment.
• Converted the inherited pro*Cobol reports to reports 6i.
• Upgrading existing Oracle Reports v2.5 to v6i.
Analysis of new application requirements, design and application development.
•
Provide ongoing support of existing applications.
• Performance tuning the screens in order to reduce the wait time on critical screens.
• Developing packages, procedures, functions, triggers, forms and reports for the
application.
• Developed java stored procedures to enhance data manipulation functionality.
• Developing new packages and procedures at backend as per new enhancements.
• Performance upgrade of Oracle processes to use array processing.
• Recompiling the forms in Linux environment and making necessary changes to suit
the new environment.
Environment: Oracle 8i, Forms 6i, Reports 6i, Designer 6i, PRO*C, PRO*COBOL, Linux,
Windows NT, Oracle 9IAS, PVCS version control.
E-Portal
Alcoa Inc, Pittsburgh PA Oct ‘01 – Feb ‘02
Sr. Programmer Analyst
The project intended to create a web portal for employee stock options. The portal is a tool for
the employees to log on to the web and manage their stock options. The portal is developed
on Forms 6i and Oracle 8i and deployed on an Oracle 9i application server. The client is
deployed on the browser and the server on a Linux system. The user database in Oracle 7.3
was migrated and upgraded to Oracle 8i database. The Screens originally developed using
Forms 4.5 were converted to Forms 6i.The Environment used is Oracle8i as backend,
Developer6i as front end and Oracle Internet application server9i as Internet tool.
Responsibilities Included:
• Development and coding standards of forms objects and database objects.
• Understanding the requirements of the client and mapping it to the oracle tool.
• Development of database objects to support the user requirements i.e. the new forms
and reports.
• Interaction with users for screen design approval and user friendliness.
• Developed Entity-Relationship and Server model using Designer 6i.
• Using the new features of the Forms 6i like calling outlook email, client web sites,
hierarchical trees etc for web deployment.
• Conversion of 40 Screens from Forms 4.5 to 6i.
• Development of web reports using Reports 6i.
• Creating drill down reports using Reports 6i.
• Developed pl/sql packages & stored procedures to retrieve & update the database
information.
• Defined data structures to communicate the information retrieved from the database
so that the front-end package can reference the information.
• Creating database triggers and procedures to use DLLs as external procedures.
• Using sql loader to upload the data to database tables.
• Creating stored procedures to call html pages from websites like yahoo.com
• Performing validation on the developed screens.
• Extensively worked on bean areas in web forms.
• Compiled java code using java compiler and used the java classes in web forms.
• Migrating and upgrading the existing database from Oracle 7.3 to Oracle 8i
environment.
• Logical data modeling using rational rose.
• W riting UNIX shell scripts to run batch reports in test environment.
• In the process of up gradation of the database, studying the older code and making
changes to suit the newer 8i environment.
• Test counting the database objects and data before and after migration.
• Recompiling the forms in Linux environment and making necessary changes to suit
the new environment.
• Performed data analysis and drill down reports using discoverer 3i
• Testing the forms and reports using the migrated client data.
• Documentation of the code changes and various processes as per the company
Format.
Environment: Oracle 8i, Forms 6i, Reports 6i, Discoverer 3i, Designer 6i, Rational rose,
Suse Linux, Windows NT, Oracle 9IAS, PVCS version control.
MORSE system
Logica Inc, Boston MA Feb ‘01- Oct’01
Programmer Analyst
Logica Inc is a worldwide software developer and support specialist based mainly in Great
Britain. The product is an electrical base system developed and used for interacting the
electrical service providers with the distribution providers and registered agents. It is a
messaging system with heavy functionality.
Responsibilities Included:
• Understanding the requirements using functional documents and client specified
documents.
• Interacting with the clients to understand the requirements and writing functional
specifications.
• W riting technical documents using the functional specifications.
• Modifying the existing technical specifications to be adjusted to the new user
requirements.
• W riting PL/SQL code using the technical and functional specifications.
• Creating oracle objects like tables, procedures and functions.
• Modifying existing code to use the enhanced features of Oracle 8i.
• Designing the forms and reports using Developer 6i as per the technical specification.
• Accepting and modifying forms to reflect customer changes.
• Optimizing existing reports.
• Conversion of Forms 4.5 to 6i.
• Customizing the Forms with regard to web enhancement Using OIAS9i.
• Developed customized logon screen to avoid invalid entry to the application on
OIAS9i.
• Adding new validation to existing forms as per the new customer requirements.
• Designed and Developed reports in Business Objects for internal use.
• Performed data analysis using Discoverer.
• W riting test cases for the new user requirements.
• Using UNIX environment for performing the testing.
• W riting UNIX shell scripting reports to run batch reports.
• Performing the tests on the newly coded procedures and documenting the same.
• Performing the coding of Pl/sql objects using the coding standards.
• Managing the SQL files into the PVCS manager.
• Keeping track of the user cases using PVCS tracker.
Environment: Oracle 8i, Forms 6i, Reports 6i, Discoverer 3i, Designer 6i, SQL Net, PVCS
Manager, TOAD, Windows 2000, Solaris 2.6, Oracle 9IAS.
Webnology Solutions.
Sales Cycle Management Jul'00 - Oct'00
Programmer Analyst
Sales Cycle Management (SCM) is a web-based sales cycle & workflow management solution
for businesses requiring enterprise-wide coordination of sales generation & fulfillment efforts
through shared information and centralized process control. At the core of SCM are
customers, contacts, products and business processes. SCM functionality includes
customer, product and process management, sales tracking through the enterprise business
processes, performance & process reporting, automated letter printing, letter template design
and integrated email system. SCM is designed as a flexible solution that can be mapped onto
organizations' unique and specific business process models resulting in improved process
flow and higher productivity. SCM is developed using Java(TM) 2, Enterprise Edition,
JavaServer Pages(TM) / Servlets and runs in any standard web browser.
Contribution:
Gathering information about the business process, planning and development of the
business model. Server side Scripting using Java Servlets is written to gather the information
of the customers/contacts. Responsible for testing the server side codes written in Java
Servlets. Developing code for database connection using JDBC for insert, delete and update
of database.
Features: Search customers using standard list page. Create, update, delete and find
customers at customer management area. Customer management area provides links to
other functional areas
Integrated Financial Services System Mar'00 - Jun'00
Fidelity Finance Limited, India
Software Engineer
Integrated Financial Services System is an ERP developed for financial service institutions. It
has been designed with Oracle 7.3 as RDBMS and Developer 2000 (Forms 4.5, Reports 2.5)
as front-end tool. It consists of following modules: Marketing, Credit Appraisal, Credit
Administration and Legal, Hire Purchase, Lease, Deposits, Fixed Assets, Pay Roll, Financial
Accounting, Inter-Corporate Deposits and Administration.
Responsibilities Included:
• Database and Screen design as per customer requirements.
• Generation of Reports to suit the functionality.
• PL/SQL coding at the database level for the new objects.
• Documentation and creation of test cases.
• Testing as per the test cases.
• Performing quality control check on the newly created screens.
• Creating complex reports using Business objects.
Environment: Developer 2000 (Forms 4.5, Reports 2.5), PL/SQL, Business Objects 4.0,
Oracle 8.0 and Windows NT.
Webnology Solutions.
Sales, Management & Production System Feb'99 – Mar’00
Programmer Analyst
This system was developed for M/s Sevian Hatcheries LTD. The company is in the business
of poultry & other related activities. The system was developed using Oracle/Developer 2000
to automate & to integrate entire activities of the company.
Contribution: Involved in study of existing system and new requirements. The system study
required extensive interviewing employees and managers to arrive at the business data flows
and Rules. I was involved in the design, development & testing of the material management
& production modules. Extensively used packages & record groups to incorporate
object-oriented concepts to write reusable code. Created separate packages for back-end
validations & for error handling. Designed and created tables with checks and constraints.
Designed user interfaces using Forms 4.5 for data capture, editing and inquiry based on
shed/store number or name. Developed several triggers using PL/SQL to reduce data entry,
reusing data from existing records, LOVs etc. Developed numerous reports using Reports 2.5
for periodic appraisals.
Environment: Oracle 7.3, Developer2000 (Forms 4.5, Reports 2.5) and PL/SQL.
Order Processing System Dec'97 - May'98
Programmer Analyst
Description: This system was devised to automate the process of power system
improvement in APSEB for the projects funded by OECF. It involves identifying the areas
requiring augmentation of the existing system, finalization of bids received under International
Competitive bidding from eligible source countries of OECF, Quality Control & billing and
generation of reports. This system was developed using oracle 7. x as the backend. Oracle
forms were used as the GUI Tool for designing screens & data entry and oracle reports to
generate the reports.
Contribution: Analysis of existing manual system and Data. Preparing of technical
specifications, Design and development of Database using Oracle 7.x. The Application was
developed using Oracle forms 4.5, Reports 2.5.Tasks included Analysis, Application Design,
preparing Technical Specifications, data validation, design of tables with necessary business
rules at database level, back-end/server side PL/SQL procedures, database triggers,
development of user interface, reports and preparation of user Manual.
Environment: SOLARIS 2.5, Oracle 7.3, Developer2000, and PL/SQL.
CTI Management System Feb '97 - Aug '97
Programmer Analyst
This system was developed to automate the function of APSEB Corporate Training Institute.
The main activities of this institute are broadly classified into recruiter, test, and personnel
document, training and report modules.
Contribution: Design an Information system to automate the earlier manual system for time
management, counseling, incentive schemes, rewards, training and skill enhancements
for the employees. Other features include maintaining question bank, test schedule &
intimation, generate questions, evaluate & generate scores.
Environment: SOLARIS 2.5.1, Oracle 7.3.2, Developer 2000, PL/SQL 2.0, SQL*PLUS.
Energy Accounting System Jul' 96 to Dec'96
CEAS (Consolidated Energy Accounting System).
Programmer Analyst
CEAS is an Oracle database running under client server based environment. It is responsible
for maintaining the Energy, Transmission sales accounting and statistical data for Billing
purposes. This is an on-line system as well as a decision support system of 30 GB in size
distributed over two servers. On-line is through leased lines of Telecom Dept. This system is
being utilized to process the bills of over 1 million electricity consumers of A.P State.
Contribution: I was involved in the analysis, design and coding of the system. Different
options like alerts, Lovs and micro help were used for user-friendliness. Usage of record
groups and object groups helped me incorporate the object-oriented concepts.
Environment: SUN SS-20, SOLARIS 2.5, Oracle 7.1, Developer 2000, PL/SQL 2.0,
SQL*PLUS.
Human Resource Information System Oct '95 - Apr '96
Programmer Analyst
Description: Design, development, implementation of Human Resource Information System
for maintaining employee data, addition of new entrants, handling separations/retirements,
promotions, transfers etc. This is a MIS package for providing management with complete
profile of an employee and to assist in organizational decision-making process. Data of about
70,000 employees is being maintained by this system.
Contribution: Designed and created tables with checks and constraints. Designed user
interfaces using Forms 4.5 for data capture, editing and inquiry based on employee number
or name. Developed several triggers using Pl/SQL to reduce data entry, reusing data from
existing records, LOVs etc. Developed forms for promotions, transfers, appraisals,
deputations, awards etc. Developed numerous reports using Reports 2.5 for periodic
appraisals, promotions, retirements, transfer. Coded database triggers for maintaining
history files in case of deletion of data. Provided facility to reload data from history files. Also
provided facility to trace users who modified/deleted data.
Environment: SUN SS-20, SOLARIS 2.5, Oracle 7.1, Developer 2000, PL/SQL 2.0,
SQL*PLUS.
Inventory Management System Nov '94 - May '95
Programmer Analyst
Description: This package computerized the entire stores & purchase activities of the
centralized material procurement wing of A.P State Electricity Board. It supports user-friendly:
GUI based accounting facility to maintain the inventory & issue of materials to various sub-
stores with in the organization. It also involves purchase order processing, vendor analysis
and generation of reports with on-line information.
Contribution: Developed screens for data entry at stores, purchase department for
maintaining current status of inventory, automatic generation of indents based on stock level,
enquiry for information related to availability of stock, update of database and batch mode,
printing of MIS reports and periodical reports.
Environment: SUN SS-20, SOLARIS 2.5, Oracle 7.1, Developer 2000, PL/SQL 2.0,
SQL*PLUS
Contact this candidate