Sql Oracle
Resume:
RAMESH RANGARAJAN
Gaithersburg MD 20878
abjea2@r.postjobfree.com
SUMMARY:
. Over 12 years of IT experience in software development life cycle (SDLC)
and Oracle 10g.
. Strong SQL, Oracle, PL/SQL and development sills
. Knowledge of UNIX Shell and Korn Scripts
. Over 7 years of production support (24x7) of a large live database and
Programming and application development using Oracle PL/SQL
. Involved in gathering and analysis of data by user interaction and flat
file data conversions
. Responsible for database design layout and system design.
. Developed and deployed Adhoc Reports using SQL queries and PL/SQL scripts
and Oracle Reports.
. Coding and production support maintenance of Data warehouse for Maine
Medicare and Medicaid System by ETL (extract, transform and load) scripts
coded in PL/SQL. Used Staging and then target tables to populate the
normalized table data so that various reports could be generated easily
by the end users.
. Managed MMIS and data warehouse projects simultaneously and stabilized
and improved the operations.
. Production Support mainly involves maintaining a large database
application through patches, Nightly Recycles (NRCs) and Adhoc Reports
(AARs) which are PL/SQL scripts.
. Handled Change Requests (CRs) such as DCR (Data Change Requests) and SCR
(Structure Change Requests for tables)
. Handled Creating, updating and dropping of Oracle Tables, indexes,
constraints, views, synonyms, granting privileges, etc.,
. Experienced in developing/debugging Stored Procedures (bulk collect),
Functions, Packages, Triggers, and Views for oracle server and forms.
. Experience in maintaining and debugging UNIX Shell scripts mainly for
scheduling jobs, email notifications, interface loading and file
transfers (FTP)
. Worked in tuning SQL queries using Indexes, Table Partitions, etc.,
. Handled footprint tickets through helpdesk triage and based on the
priority of issues, developing quick fixes per SLA and testing the
scripts in lower environment including regression testing before
releasing to production environment.
. Experienced in developing client-server applications and providing
maintenance support using Oracle Forms/Reports 6i as front end and Oracle
database server as backend.
. Involved in technical documentation and suggestions for improvements of
the system in terms of both hardware and software tech details.
. Worked on unit testing, documenting test cases and handled releases in
lower and production environments.
. Familiarity with web development using Cold fusion, HTML and JavaScript.
. Support for Oracle applications remotely and at client's place.
. Good analytical skills with written and verbal communication abilities
and a good team player.
. Documented code checked in script into VSS for version control. Involved
in training.
TECHNICAL SKILLS:
LANGUAGES: SQL, PL/SQL, C
Platforms: Windows NT/2000, UNIX
Databases: Oracle 9i, Oracle 10g, SQL Server 2000, MS-Access
Software/Tools: Developer 2000 (Forms/Reports 6i), Toad, SQL*Plus
Scripting: HTML, CFML, JavaScript, UNIX Shell Script
Others: MS-Office (Word, Excel, PowerPoint, Access), MS-
Project, Business Objects 6.0, Crystal Reports
PROFESSIONAL EXPERIENCE:
CNSI, MD 11/05 - Present
CNSI is a corporate house specializing in health care industry in the DC
metro area catering to Medicare and Medicaid systems for many states. CNSI
has developed in house MMIS application (Medicare Management Information
System) and extends front end and backend support to the State of Maine
where the system is in production since 2005..
This system handles all the medicare and Medicaid claims for the State,
adjudicate them fund allocate and generate remittance advice. Maine
Medicaid Decision Support System (MMDSS) is part a data warehouse
application that is a de normalized system that helps the State to do
analysis on archival data for effective decision support activities.
Responsibilities
. The main responsibility is to provide programming and support for
claims processing and data warehouse to all the sub systems
(REFERENCE, MASTER, PROVIDER, MEMBER, PHARMACY CLAIMS and PRIOR
AUTHORIZATION) for the application.PL/SQL scripts were used for
patches, Nightly Recycles (NRCs) and Reports (AARs) to provide overall
production support to the application 24x7.
. Involved in the system analysis, design and development, testing and
production support of many modules of the data warehouse system.
. Experienced in live support of a large production database and adhoc
report generation.
. Writing scripts for quick fixes as per the company stipulated SLAs
based on the urgency of the issues. Testing and regression testing at
lower environments before taking to production.
. Handled PL/SQL stored procedures for Claims Processing and ETL. BULK
COLLECT was used in STAGING areas and then moved to the DSS system or
MERGEd (UPSERT) directly.
. New functionalities were added to the existing code and support
extended to modify changes based on changes in business rules/database
structure and fixing of errors.
. Used tools like TOAD, VSS, ERWIN.
. Loading process is undertaken mainly through the unix box by logging
on to sqlplus through telnet sessions with nohup option. Long ops
monitored and transaction logs checked.
. Cron jobs to be written to automate and refresh the scripts to run in
specific periods. This is mainly being done with the help of UNIX
Shell programming, which makes the job easier as the set of commands
and the logic written like High Level Language syntax are stored in a
text file and called like a DOS batch file and thus the running
process is automated.
. Interface loading and file transfers were also maintained with Shell
scripts.
. Documentation for the complete source to target mapping of each table
column was made for the ETLs. Used ERWIN to show the data modeling
used.
. Unit Test Cases and Testing documentations were also prepared and the
system was taken to production after user acceptance.
. Involved in technical documentation and suggestions for improvements
to the system in terms of hardware and software technical details.
. Participated in meetings both with internal teams and with end users.
. Good experience with Help Desk Triage System and Footprint Tracking
for issues.
Achievement: Was Awarded "Employee of the Month" and received Hi-5s on many
occasions.
Environment: Oracle 9i, SQL*PLUS, PL/SQL, TOAD, Windows 2000 and UNIX with
Shell Programming
State of Kuwait, Kuwait 09/03 - 10/05
PAAFR
The Public Authority for Agriculture Affairs and Fish Resources (PAAFR) is
a department under the Ministry of Agriculture in the state of Kuwait. It
has many activities catering to agriculture, marine Biology & fishing, boat
licensing, Veterinary Science and Beautification. Each Sector has offices
scattered at geographically different locations within the country. They
have more than 300+ computers connected to the central servers in the I.T
department of the Head Office. The main job of the I.T department is to
provide I.T support to all these sectors.
Projects Developed:
An automated License Issue Software for an International Certificate for
the Import Trade of Endangered Species of Flora and Fauna (CITES) for the
Animal (zoo) and Horticulture sectors
> A data warehouse application for the I.T department to gather reports and
statistics
> A boat license issue application for the Fish Sector
> A package to monitor the Plant Disease Control for the agriculture sector
> Marketing Application for the Agriculture Marketing Department
> Providing continuous Maintenance Support for the existing 24 applications
in oracle
> Apart from oracle projects also involved in web site maintenance, GIS
project, Creating Universe and reports for management using Business
Objects
Responsibilities
. Provided application development and on-call support both remotely and
at client's place.
. Applications were developed using Oracle Forms 6i for the front end
interface and Oracle PL/SQL at the backend and Oracle Reports 6i and
Crystal Reports for generating reports.
. A data warehouse application developed using Oracle Forms/PL/SQL and
Reports for the I.T department to gather reports and statistics
. System Study and analysis by interacting with the end-users to study
the constraints in the existing system.
. Design and development of the new system after getting user
acceptance.
. Development using SQL and PL/SQL coding to implement business rules
. Developing and modifying triggers for oracle forms.
. Developing and modifying database views, triggers, cursors,
procedures, functions and packages to meet business requirements.
. Created PL/SQL Packages for easier application design and
improved Performance.
. Performed performance tuning of applications to run fast.
. Managed the Warehouse application well as it is the key to
provide details and statistics to the management in a
timely fashion.
. Migrated data from Flat Files to Oracle database using SQL*Loader.
. Wrote Oracle PL/SQL programs for backend processing.
. Created PL/SQL stored procedures for database and application
validations
. Created PL/SQL program units to include DML, DDL statements using
Dynamic SQL.
. Created and managed primary data base objects such as Tables, Views,
Indexes, Sequences, and Synonyms.
. Responsible for developing technical specifications from business
requirements
. Involved in trouble-shooting application problems and report problems.
. Developed user documentation for all the application modules. Also
responsible for writing test plan documents and unit testing for the
application modules.
. Communication was a key factor both within the software team and
externally with the users. Won the appreciation of the users and the
management for steering in balance and fulfilling the expectations.
Environment: Developer 2000 (Forms 6i, Reports 6i), Oracle PL/SQL, Crystal
Reports, SQL*Loader, SQL*Plus, TOAD, UNIX,, Windows XP/2000
CMDA (Chennai Metro Development Authority), India 10/01 - 08/03
Projects and 02/95 - 03/00
> Planning Permission System
> Spot Analysis of PP
The aim of the Planning Permission System is to scrutinize the papers
submitted by property owners who apply for one-time exemption for
deviations permissible under the revised Development Control Rules (DCR) by
paying the penalty amount. The standard set of rules for the planning
permission system is stored in the database. The details submitted by the
public are keyed in and checked. If there are any discrepancies, they are
summarized in the hard copy given to the public so that the shortcomings
can be corrected and the forms resubmitted. This drastically reduces the
time period involved in the routine manual checking process, increasing the
reliability. This software is loaded in the Authority's network so that the
concerned officials can operate the same. The Administrator takes care of
the security aspects.
Spot Analysis of Planning Permission (PP) compares the applications
submitted for approval with a standard set of rules from the database and
prints out of the applications can be accepted or not. If not, then the
weak areas are pointed out by printing out a list to be checked by the
applicant for re submitting the application.
Responsibilities
. Coding and production Support of various oracle applications
. Interacted with users to understand issues and documented
. Developing solutions for issues and testing and supporting the team
. Prototype development
. Helping programmers in coding SQL and program logic
. Communication to higher management verbally and by written
documentations about issues and solutions.
Environment: Oracle 8i, PL/SQL, Windows 2000, UNIX, VB/SQL Server 2000
Zerowait Computers Inc., MI 04/00 - 09/01
Projects
> Matter Space for Work Products
> [www.cosential.com]
> eMarketAEC
> [www.mdanderson.org]
> [www.dgbco.com]
Responsibilities
. Created PL/SQL stored procedures and triggers
. Static HTML templates made dynamic CFML templates by writing SQL
coding to interact with the database
Environment: Oracle 8i, PL/SQL, CFML, Cold Fusion Server 5.0, HTML,
JavaScript, ColdFusion, Studio, MS-SQL Server 7.0, CSS, IIS and Windows
NT.
CMDA, India 02/95 - 03/00
Projects
> Security Deposit System
> Land records Maintenance System
> Payroll System for HR
> [www.cmdachennai.com]
> Accounting Application for Finance Department
Responsibilities
. Requirement Analysis and Design by interacting with the users
. Database Design
. Identification and Design of processes
. Prototype development and user acceptance
. Preparation Of Program Specification
. Periodic Report Generation catering to the needs of the top management
. Tested, Installed, Documented and provided Support for the
Applications.
Environment: Windows/VB/SQL Server/ASP/HTML
EDUCATION:
Master's in Computer Applications
VISA STATUS
Having GREEN CARD
Contact this candidate