Process Oracle
Resume:
ASHA SARA VARGHESE
E-mail abhtbt@r.postjobfree.com
Cell No 215-***-****
Res. Ph. No 215-***-****
Address ****, ******* *****, ************ - ** -19115
Status Green Card Holder
Summary
. MCA professional degree with around 4 Years of experience in Analysis,
Designing, Coding, Testing using Developer 2000, PL/SQL, TOAD, SQL
Loader and Oracle 9i, Unix, Oracle Forms and Reports and Microsoft
Axapta Forms and Reports 3.0.
. Experience with Software Development Life Cycle adhering to well
defined Quality processes and methods.
. Proficient in Oracle PL/SQL programming, writing Stored Procedures,
Functions, Database Triggers, Views etc.
. Good knowledge of C, C++, JAVA, JAVA library tools like applets,
Abstract Window Toolkit (AWT), Java beans, swings.
. Good logical understanding and problem resolving skills.
. Self-motivated, organized team player with strong problem solving and
analytical skills and total commitment to the organizational goals.
Professional Experience
. Working as Application Development Specialist with CIGNA International
Expatriate Benefits, Delaware from 24th May, 2010 till Present.
o Responsible for the daily check of the batch processes and jobs
that are run after business hours on scheduled basis.
o Responsible for the ETL process that runs on daily basis.
o Responsible for the US load process from one data base to the
other database, which would help display of data to the CIGNA
website.
o Analysis and resolution of the error logs related to the batch
jobs that are run on daily basis in case of failure.
o Handle Production support cases on a large level.
o Work on developing Pl/SQL Ad hoc blocks to run the bulk updates
as per client and business request.
o Involved in developing reports as per client/business request.
Involved in creating new Unix scripts as well as enhancement to
existing Unix scripts.
o Day to day activities also include Data fixing, Bug fixing and
unit testing.
o Involved with enhancements to the current system which involves
with gathering requirements, development, testing, and
discussions with business, deployment of the code through the
release management process.
o Involved in enhancements and development of new Unix scripts.
. Worked with Strategic Staffing Solutions, Fort Washington for client
CIGNA International Expatriate Benefits, Delaware as Application
Development Specialist from 22nd February 2010 to 23rd May 2010
o Involved in understanding the systems and applications.
Attending conferences and seminars related to the current
applications and system processes.
o Write ad hoc block for running DML for bulk update of data into
the system.
o Understand the ETL (Extract, Transfer and Load). Prepare
documentation related to the ETL process, which involved
intensive interaction with developers and business in
understanding the complete process.
o Understand the web extract process. Prepare documentation
related to the Web Extract process, which involved intensive
interaction with developers in understanding the complete
process.
. Worked as Software Developer with IL & FS Technologies Ltd, India from
1st October, 2007 to 29th May, 2009.
o Involved with the daily interaction, development and maintenance
of 6 group companies (ILFS, IFIN, CDI, IETS, ITCL, IPMSL) and
their respective branches within India.
o Modify, maintain and develop the SQL codes and to develop new
enhancements.
o Develop and maintain the documentation to support the new
changes.
o Responsible for the fixation of the errors in data by utilizing
the GUI interface of application and SQL scripting
o Daily check of the Data discrepancy using views and procedures.
o Day to day activities also include Data fixing, Bug fixing and
unit testing.
o Develop Reports that can transfer data to PDF format and excel
sheets through Oracle Reports.
o Handling User requests and taking daily requirements from users.
o Involved in Unit testing, Integration testing and Load testing
of the interfaces.
o Support and maintenance of existing system and packages.
o Discussions and review periodic changes with the HR (For Leave
Module) or clients(CAS module).
o Make a detailed study of new requirements.
. Worked as Internship Trainee Programmer with Investors Services of
India Limited (ISIL-IDBI), India from 12th June, 2006 to 15th Sept,
2007.
o Involved in collection of data, User requirements, detailed
study of the database and the existing system.
o Analyzed, developed and maintained Oracle Forms and Reports
o Designed coding specification and documentation
o Taking requirements from users and discussions with team leader
on periodic basis.
o Development of documentation and workflow
Qualification
2004-2007 Master in Computer Application from Mumbai University
2000-2004 Bachelor Degree (Mathematics) Mumbai University (India)
1999-2000 H.S.C. from Mumbai University (India)
1997-1998 S.S.C. from Mumbai University (India)
Technical Skills
. Operating System: DOS, Windows 98/2x
. Database used: Oracle 8i/9i
. Programming Language: C, C++, Java, JavaScript, JSP, ASP, HTML
and Visual Basic, Oracle, PL/SQL
. Front End Tools: Oracle Forms 6i, Oracle Reports 6i, TOAD, DBA
Package For Oracle, Microsoft Axapta Forms and Reports 3.0, C,
C++, JAVA, Flash, MS Office, PhotoShop, Paint Shop Pro, Corel
Draw and PageMaker
Projects at CIGNA International Expatriate Benefits, Delaware
Title : Worldcare Diamond/Addon Application
Company : CIGNA International
Period : 22nd February 2010 to till date
Role : Application Development Specialist
Team Name : Application Production Support
Team Size : 6
Front End : Power Builder, J2EE Architecture, Websphere 3.5.7
Back End : Oracle 9i
. Worldcare Application has 2 components: Diamond 950 and Add-on.
. Diamond 950 is the core application used by CIEB for storage and
retrieval of claims, benefits, eligibility, premium billing, provider
information, etc.
. CIEB has created an additional application to support dynamic business
need, referenced as Add-On.
. Diamond application and Add On represent a complete set of data that
North America uses for its reports, billing, cash receipts, claim
payments etc.
Responsibilities
. Database Maintenance:
o There are many processes that run on the backend stored
procedures. Any changes in the business logic to these backend
stored procedures would considered as an enhancement.
o Conduct meeting with business to understand the detailed study
of the requirements.
o Involved in the analysis, development and testing of the test
case that was evolved during the meetings in the lower
environments.
o Involved in explaining the business the new changes and how
would it affect the business. On this basis, involved in getting
business approvals for the new changes and deployment into
production database after undergoing a process of release and
change management process.
o Working on production support tickets which involve reports,
data fixes, code fixes, current status of the claims and
benefits.
o Taken initiative in identifying and tuning existing stored
procedures which are either bad queries or takes time to
execute.
. ETL process:
o Involved in daily check of the ETL process. This process is
developed as per the business logic for reporting purpose.
o Involved in fixing the issue if the process fails.
o Working on tuning the existing ETL procedure and discussions
with business on new requirements.
o Check the error logs and find solution to the error.
. Extract process:
o The extract process creates DAT files, involved in the transfer
of files through SQL server to 4 different database to display
the details on the respective websites.
o Involved in daily check of the Extract process.
o Involved in fixing the issue if the process fails.
o Working on tuning the existing Extract procedure and discussions
with business on new requirements.
o Enhancements to the existing procedures as per the business
requirement of as per the analysis basis on the tickets created
by the customers.
o Check the error logs and find solution to the error.
Projects at IL&FS Technologies Ltd., India
Title : Corporate Accounting System (CAS)
Client : IL&FS and 5 Group Companies (IFIN, CDI,
IETS, ITCL, IPMSL)
Period : October 2007 to May 2009
Role : Software Developer
Team Size : 4
Environment : Developer 2000, Oracle 9i
Description
. CAS - Corporate Accounting System is a project developed for taking
care of Financial Transactions and MIS Reports for 6 Group Companies
(IFIN, CDI, IETS, ITCL, IPMSL) and their respective branches within
India.
. It includes various Voucher Entries, Depreciations Process,
Amortization Process, Bank Book, GL, Sub Ledgers, and Year end
process, Bank Reconciliation, Financial Reports like Trial Balance,
Profit & Loss Account, Balance Sheet, and Schedule IV.
. It can gather data from other Product Packages and dump vouchers in.
Responsibilities
. Designing the Database as per requirements
o Develop tables, views, stored procedures, functions, triggers,
indexes, cursors, defaults and user-defined data types
o Taking logical backups using export at object and schema level.
o Worked on tuning the SQL queries and stored procedures
o Used various forms of control structures including IF-THEN-ELSE,
FOR loops, WHILE loops while developing procedures.
o Granting privileges on schema objects for other users to be able
to share content.
o Used EXPORT/IMPORT to do table level and full database de-
fragmentation.
o Developed back-end packages, procedure and functions for complex
Reports.
o Generated SQL and PL/SQL scripts to create and drop database
objects including: tables, views, primary keys, indexes, table
level triggers, constraints, packages, sequences and synonyms.
o Modified Stored Procedures and Stored Packaged Procedures
o Utilizing Built in Oracle Packages like (UTL_FILE, DBMS_OUTPUT)
for better debugging and worked on user-defined and system
defined exceptions to handle different types of Errors.
o Extensively used TOAD for database access and PL/SQL Development
. Developed and maintained oracle forms as per requirements.
o Involved in customization of Oracle Forms.
o Developed PL/SQL packages, functions and procedures for the back
end processing of the proposed data base design.
o Developed complex Oracle forms providing extensive GUI features
(multi-selects drag and drop, graphical charts, automated system
alerts and notifications etc).
o Developed LOV's, Triggers, cursors and Programmatically Record
Group handling for different data blocks.
o Multiple Form, Menu development and MDI applications
o Almost all important Form triggers and Built-in packages.
o Developed forms Using Tab-canvas, Stacked, Content and
Horizontal toolbar canvas.
. Developed and maintained oracle Reports as per requirements.
o Developed reports using complex queries as per client
requirement as a part of production support
o Worked on matrix reports.
o Developed reports using complex queries as per client request as
a part of production support.
o Developed report for transfer of data to excel sheet or PDF
format through oracle reports.
o Used Report Triggers and called backend procedures and functions
through reports.
. Regular User interaction and maintenance until final implementation
o Daily Interaction with users of 6 group companies.
o Production and support of existing system
o Discussions on daily queries, new requirements and new
enhancements in the current system.
Title : Leave Module
Client : IL&FS and 4 Group Companies(ITCL, IIML,
IFIN, IETS)
Period : October 2008 to May 2009
Role : Software Developer
Team Size : 4
Environment : Microsoft Axapta Forms and Reports
Description
. Leave Module was developed for 5 group companies.
. Analysis, designing and enhancements of forms and reports.
. Leave Module consist of advance and arrear credit of leave as per the
company requirement.
. The basis forms developed for the process were Leave registration,
Leave approval, Leave cancellation, Leave Encashment.
. Developed Reports as per HR requirements like
o Monthly leave record of each employee.
o Periodic range (Quarterly or yearly) of records as per the
department.
Responsibilities
. Data Collection and User Requirements
o Details study and meetings with the HR of each company.
o Involved in daily interaction with users and HR.
o Develop tables, views, stored procedures, functions, triggers,
indexes, cursors, defaults and user-defined data types.
o Extensively used TOAD for database access and PL/SQL
Development.
o Training User about the existing software.
. Maintenance of the Microsoft Axapta Forms developed.
o Detailed analysis and study of the existing form.
o Keep track of the Leave routing for approval and cancellation.
o Coding and testing of the new forms.
. Maintenance of the Microsoft Axapta Reports developed.
o As per HR requirements, Reports were developed on yearly or
quarterly basis.
Projects at Investors Service of India Ltd., India
Title : Register and Transfer System
Client : Investors Service of India Ltd. (ISIL)
Period : June 2006 to Sept 2007
Role : Trainee Programmer
Team Size : 3
Environment : Front End - Developer2000 Back End - Oracle 9i
Project
. ISIL wanted to transfer their current system from PowerBuilder to
Oracle Forms and Reports.
. Investor invests in the organization in the form of shares and
certificates. At any point of time, the investor can transfer the
shares and certificates to some other person. This transfer of
certificates has to go through a process, which involves various
stages and checks.
Responsibilities
. Involved in collection of data, User requirements, Study of the table
structures and the existing system.
. Developed a complete module - Transfer of Certificates
The forms developed are
Transfer Entry(Objection, Buyer detail, New folio creation),
Process,
Register Generation.
Query forms like Lodger query, Folio query, Inward query,
Certificate query.
Enhancement work on reports for conversion of data to .TXT
format.
. Involved in Unit testing, Integration testing and Load testing of the
interfaces.
. Involved in documenting the modifications and intended functionalities
of the interfaces
. Worked on transfer of data from forms to .txt format.
. Weekly interaction, review and discussions with user.
. Prepared Data Flow Diagrams.
Contact this candidate