Sql Oracle
Resume:
RAJESH MAKTALA
**********@*****.***, **********@*****.***
SUMMARY:
Over ten years of IT experience in the areas of Design, Data Modeling, Development, Administration and
Implementation of Relational Databases (Oracle), Graphical User Interfaces (Oracle Forms 10g/9i/6i, Oracle
Reports 9i/6i, Power Builder 9.x, Batch Processing jobs and Object Oriented Techniques, in UNIX and MS
Windows environments. Experienced on all aspects of the Project Development Life Cycle. Strong
programming skills in C, SQL, PL/SQL, Informatica, ETL and Power Script. Efficient in meeting deadlines and
work independently or as a team member. Have excellent analytical, inter personal and communication skills.
TECHNICAL SKILLS:
Languages
C, SQL, PL/SQL, Pro*C, PowerScript
Databases & Tools
Oracle 9.x/8.x/6.x, Informatica 7.0 MS Access, FoxPro 2.6, SQL Server
Case
Designer 2000, ER Win, Turbo Analyst
Client Server Tools
Forms10g/9i/6i, Reports10g/9i/6i, Power Builder 9.0/5.0/4.0
Web Tools
HTML, XML, JavaScript, CGI/PERL, Java
Operating Systems
Unix, Windows NT 4.0, Windows 95, Netware 3.11
EXPERIENCE:
Avmed Health Plans, Miami, FL
Aug’08 – till date
Chief Application Analyst
AvMed Health Plans is Florida's largest not for profit health plan, improving access to health care for members
for more than 30 years, while serving Florida communities in the major metropolitan areas of the state.
Through an extensive broker network, AvMed offers health care coverage on a fully insured and self funded
basis for employer groups in Florida. Additionally, AvMed offers health care product to Medicare beneficiaries
in South Florida.
Major Responsibilities
Developed UNIX Shell Scripts and PLSQL procedures to extract and load data for weekend batch
•
processing.
Involved in creation and updates of several SQL packages and Procedures.
•
Created SQL scripts and written Procedures using PL/SQL to load data from CSV flat files into new
•
tables (using both UTL and SQL Loader – for different cases).
Created custom forms using forms 6i to capture customer related data and Reports using reports 6i.
•
Used UTL file package scripts to extract data from database based on business requirement.
•
Tuned SQL Query for optimization in Oracle stored packages using Explain plan and Auto trace.
•
Used TKPROF (SQL * Trace) tool to analyze and fix multiple time consuming SQL statements which
•
were available in stored packages.
Analysis of new projects, estimation, programming and testing of programs.
•
Involved in gathering user requirements and preparing functional and technical documents.
•
Work with tools like Appworx (enterprise scheduler) used for scheduling jobs.
•
Environment: HP Unix, Oracle 10g, PL/SQL, AppWorx, Citrix
Marriott Vacation Club,
April 2007 to July 2008
Marriot vacation club has various data warehouse projects to process timeshare hotel information. Summit is
one among them; Summit database imports data from another database called prophecy. Summit eventually
processes the data to generate reports which are useful for Business intelligence & corporate performance
management software for better business decisions. Developed PL/SQL ref cursor reports like WAMI
(Weighted Average Mix Index), PIR (Project Inventory Report ), Score Cards, Price Plan and Owner Usage.
Major Responsibilities
Developed SQL scripts to fulfill DML, DDL and DCL operations.
•
Involved in Data Extract Transform Loading using Informatica, generating pl/sql procedures,
•
packages for OLAP reports are prime responsibilities.
Developed reports for business users, reports like project details/inventory, point of sales voucher
•
summary detail reports, hotel listing and reservation arrival status reports.
Clear Case, PVCS are used for version control. Interacting with business users to get form, reports,
•
package, procedure and function requirements.
Environment: Oracle 10g/9i, PL/SQL, Unix, Korn Shell, Toad (PL/SQL tool), SQL Navigator,
SQL*Loader, Informatica,
Blue Cross Blue Shield., Florida, USA .
Analyst
07/2006 to 03/2007, Senior Programmer
BCBS offer an array of choices designed to meet the diverse and ever changing needs of Florida employers
as well as individuals purchasing health care coverage. BCBS health plan choices include HMO plans, broad
network PPO plans and Supplementary health coverage for Medicare recipients and traditional indemnity
products. Through BCBS family of subsidiaries, BCBS also offer prescription drug coverage, dental plans, life
insurance, long term care, workers compensation, Away From Home Care and many other products.
Major Responsibilities
Involved in Design, development of Diamond application.
•
Enhancements like NDC validation (PL/SQL) on Institutional Claims, Developed packages,
•
procedures, triggers, functions for various application needs.
Performance Tuning on existing SQL Queries, Using Hints, Explain Plans, Analyze methods to
•
optimize the SQL queries.
Clear Case, PVCS are used for version control.
•
Used PL/SQL packages like DBMS.SQL for generating dynamic SQL, DBMS.JOB for batch
•
processing, process scheduling and UTL_FILE (Handling data, creating data into flat file) for various
application needs.
Environment: Oracle 10g/9i, PL/SQL, Unix, Korn Shell, Toad (PL/SQL tool), SQL Navigator,
SQL*Loader
Publix Super Markets Inc., Florida, USA
12/2005 to 06/2006, Intellect Systems, Senior Programmer Analyst
Founded in 1930, Publix Super Markets is the largest and fastest growing employee owned supermarket chain
in the United States. They are having Supply Chain Marketing system on Oracle Applications. Developed
PL/SQL packages, procedures from Oracle Applicatoins to SCW (Supply Chain Workbench Ware house
database. Developed Item, Item Store, Supplier, Store transfer, Item Forecast (Item Planning) transfer
procedures. Configure, test and implement features, modules or applications in support of Oracle supply chain
modules.
Major Responsibilities
Responsible for performance tuning of existing applications for volumes from 8 stores up to 800
•
stores.
Using Toads Explain Plan features found the weak SQL queries.
•
Incorporated parallelism, hints to tune the packages, procedures.
•
Environment: Oracle 9i/10g, PL/SQL, Unix, Korn Shell, Toad (PL/SQL tool).
West Gate Resorts, CFI Florida, USA
8/2004 to 11/2005
Oracle Applications Developer
West Gate Resort uses an application SAM (Sales and Marketing) developed in Oracle Forms 9i, Reports 9i.
This application is used to sell the time share, arrange tour on time share for customers. Tour attended
customer can get attraction tickets (e.g., Disney, Sea World) hotel or rental car discounts. Each tour will be in
different scheduled time. Sales representative will explain about the time share, terms and conditions to buy a
vacation package. The time share can be sold by telemarketing people, owner referral, on property customer
or dialer system.
Analyzed, Designed and developed the customized forms for vacation package tour, tour allotment,
•
employee, inter company manager setup forms in SAM module.
Broker sales report, hotel listing, inventory adjustment, inventory on hand, credit card report are some
•
other the reports developed in SAM's application.
Developed reports for business users, reports like vacpac details/inventory, point of sales voucher
•
summary detail reports, hotel listing, and reservation arrival status reports.
Harvest is used for version control. Interacting with business users taking forms, reports requirements
•
and building the forms, reports for the application.
Environment: Oracle 9i, PL/SQL, Unix, Shell Scripting, Forms 9i, Reports 9i, HTML, Microsoft Visual
Sorucesafe 6.0.
Priority Health Care Florida, USA
02/2003 to 7/2004
Oracle Applications Developer
CRM, ERP 11i (CRM, Order Management, Inventory)
Priority Health Care uses Oracle Applications as the major software application to run their medical distribution
and pharmacy business. Priority has their own pharmacies in all different states to supply drugs to the patients;
specific drugs are for fertility, hepatitis. Custom Pharmacy application is linked to Oracle Applications 11i,
which supports pharmacists to provide drugs to patients and adjudicate the medical bill.
Major Responsibilities
Involved in migration/conversion of the application. All the drug (items), payer (party)data from
•
legacy systems with RPG files has been converted to Oracle Applications 11i database.
Developed PL/SQL packages for converting legacy data into 11i database data.
•
Designed, created and maintained Web enabled Oracle Forms & Reports.
Designed and Developed HTML, C, Shell Script, Java JSP programs to call Oracle Forms and
•
Reports from Web as Apps 10.7 was not web based.
Developed a data load using PL/SQL and SQL*Loader; and cron jobs calling Unix scripts to
•
download and manipulate files.
Environment:
Oracle Applications 11i, Oracle 9i, PL/SQL, Unix, Shell Scripting, Forms 6i, Reports 6i, HTML,
Merck New Jersey, USA
05/2001 to 01/2003
Senior Programmer/Analyst
Project: Automated Expense Reporting (AER) System
Writing API interfaces to Financial Application. Writing Shell script batch jobs to migrate, massage/convert data
from JD Edwards database (RPG format files) to Ez Expense (Oracle Database)
Used SQL*Loader, C, Pro*C to extract, transform, import, export data from Oracle tables to flat files,
developed reports using C programming.
Forms 6i, Java, JSP, Oracle Reports 6i, are used to develop Web screens, Web validation, Connecting Oracle
from JSP, Java Programs.
Used PL/SQL standard packages (DBMS_SQL, UTL_FILE), procedures and triggers for various application
needs.
Environment:
Oracle 8.i, PL/SQL, Unix, Shell Scripting, SQL*Loader, C, Pro*C, XML, Forms 6i, Java, JSP, Oracle
Forms 6i, Reports 6i.
Bristol Myers Squibb New Jersey, USA
05/1999 to 04/2001
Programmer/Analyst
Project: BRIQTone Application
Developed Interface programs to transfer data from Clinical Application to IVR application by Quintile vendor.
Highly involved on extraction, migration of the databases.
Developed Web based Screens and Reports in HTML, Java Script, and Oracle Reports. Developed reports for
Randomized Co Coordinators.
Used PL/SQL standard packages, procedures and triggers for various applications needs
Created triggers, batch jobs for background processes
Worked extensively on Pro*C in developing various reports of the system and batch processing programs
which helps to update data weekly and monthly.
Worked on Oracle DBA tasks, compiling schemas, query tuning, userid/password creations, creating indexes,
schemas.
Environment:
Oracle 8.0, PL/SQL, PL/SQL Cartridges, Pro*C, HTML, XML, JAVA, Visual Studio, SQL*Loader,
Reports 6
Unix, Shell Scripting, OAS Oracle Application Server
National Exchange Carrier Association Inc. New Jersey, USA
03/98 to 04/99
Programmer/Analyst
Project: TARIFF
The front end GUI screens were developed using Developer 2000
Worked on Template forms to lay the foundation for the application. Controls like Tabs, Drop down list box, list
of values and Spin control were used. Made extensive use of Procedures, Function and Cursors
Responsible for application tuning and testing on different environments
Also involved in unit testing of the system
Environment:
Oracle Forms 4.5, Reports 3.0, Designer 2000, Oracle 7.3, PL/SQL, SQL Navigator, Windows NT 4.0,
Unix AIX, Shell Scripting
EDUCATION:
Bachelors in Computer Science Engineering
Contact this candidate