Oracle Project
Resume:
MITA PANDA
STATUS – US CITIZEN
PHONE – 941-***-****
Email - *********@*****.***
PROFESSIONAL SUMMARY
More than ten years of software development experience in the area of ORACLE
Client/Server application development, Oracle application (HRMS) and database design.
Possess strong analytical skill and strong working knowledge in all phases of the system
development life cycle with good communication and interpersonal skills.
ECHNICAL SUMMARY
T
DATABASES: Oracle (versions: 7.x, 8.0, 8.i, 9i,10g)
ORACLE TOOLS:
•Oracle Applications (versions: 11.03,11i) ( Oracle HRMS application )
Oracle XML Publisher
•Server Manager, TOAD, SQL Navigator, Text Pad, Ultraedit
•Developer 2000 (Forms 4.5, 5.0, 6i and Reports 2.5,3.0,6i)
Procedure Builder
Discoverer Administration/User Edition (3.1,4i)
SQL*Plus
SQL*Loader, Export/Import
Packages, Stored Procedures and Database Triggers
Explain Plan, SQL*Trace and TKProf.
SQL, PL/SQL, Dynamic SQL,XML
UTL SMTP
SUBVERSION & VSS
PROGRAMMING LANGUAGES: PL/SQL, UNIX Shell Programming,
JAVA
OPERATING SYSTEMS: HP UX 11.x, Solaris 2.7 / 2, 8, WINDOWS Xp/NT,
WINDOWS 95/98/2000
XPERIENCE
E
Gevity HR Aug 2006 to July2009
Programmer Analyst II
Oracle HRMS Application11i
DLP Project (Data Loss Prevention)
The project was designed to hide all the personal information (like SSN, address, etc) in
all the outgoing reports. this process all the reports were converted to BI Publisher
reports.
• Converted several reports to XML publisher reports( Detail Check Register
report, Check Register, Worksheet reports etc).
Created the Concurrent Program to generate the report in pdf and excel format.
Created rtf templates using XML Publisher desktop utility.
Did unit testing.
Tools used – Oracle reports6i, XML Publisher Desktop Utility (to create the RTF),
Concurrent program, XML Administrator.
Transamerica Rate Change Automation
The system was designed to get the file from Transamerica ftp site and read rate change
in CSV file and upload data into oracle (Element Entries table) after a lot of 401K rule
validation. At the end of the process it also generates a Confirmation report which has all
the information like records which are not loaded into oracle with a reason for not
loading and the records which are loaded with an effective date of loading. This report
can be viewed from View Download in the concurrent program.
The process is a Concurrent request which is schedule to run every Monday at 6 AM and
after completion of the process it notifies 401K department by email with status of
completion. This automation reduces the cost of data entry for the 401K dept.
• Design the temporary table.
Created the Technical Design document.
Created the Concurrent Request.
Created the shell script to get the file from TA ftp site.
Created the interface to load the data into temp table and then load data into
Element entries table and generate a confirmation report.
Tools used – SQL/PLSQL, Concurrent Program, Shell script.
Danka-KMDI Conversion
The interface sends all employee detail information (like name, address, hire date etc) for
the employees who are currently enrolled in the 401K plans with their contribution and
ER match as well as 401K loan if any at the beginning of the benefit year (January 1,
2009) and every pay period thereafter to Prudential. This is a biweekly outbound process
to Prudential. If any error occurs between the process it sends mail to the 401K dept with
reason for failure.
• Created the interface.
Created the Concurrent Request.
Created the shell script to send the file to prudential ftp site, if error it sends mail.
Created the technical design document.
Did unit testing.
The interface was designed to get the 401K file from the Prudential ftp site and load into
Oracle database after a lot of 401K data validation. This was a weekly process which was
schedule to run each week. The process also sent mail to 401K dept if it is not successful
to get the file from ftp site. The process also generated an error report for those records
not loaded in to the system.
• Created the interface.
Created the Concurrent Request.
Created the shell script to get the file from prudential ftp site, if error it sends mail.
Created the technical design document.
Tools Used – SQL/PLSQL, Concurrent Program, Shell script.
Created several new reports from scratch as needed by business.
Texas Franchise Tax report( XML Publisher).
401k Contribution report( Report 6i) etc.
Modified several benefits packages, procedures, functions, reports, forms and fast formulas
as required by the business.
Involved in data conversion project from one oracle instance to another instance.
Involved in 11.03 -> 11i HRMS conversion project.
Involved in regular release activities (3 releases in a Year) for the changing business
needs. Involved in day to day production support work.
Land Works Inc, CO Jan 2004 to Feb2006
Database Developer
Forest Extraction
The system was designed to extract data from one Oracle system to another oracle
system (Land Property Management). Interface was created to extract the data. The
interface was schedule in DBMS job to run every night. The system also generated a
report with number of record processed, number of record successfully loaded and
number of records error out.
• Design the interface tables.
Created the necessary data mapping between the two systems.
Created necessary indexes on temp tables.
Created the pl/sql package to load the data in to LPM.
Tools used – Oracle 9i, DBMS_JOB
Mustang Conversion
System was designed to extract data from a database other than oracle (ACCESS) and
load into Oracle database (LPM). The system use DTS package to load the data from
access database to oracle temp Tables. A pl/sql package massage the data and make it
ready to load into LPM system. The interface was schedule in cron to run every night and
write any error to the error log. The system also generate a report with number of record
processed, number of record successfully loaded and number of record error out.
• Design the interface tables.
Created the necessary data mapping between the two systems.
Created the interface.
Created the interface.
• Wrote unix shell script to submit the job in cron.
Tools used – DTS package, pl/sql, Unix
Whiting Conversion
System was designed to extract data from flat files load into Oracle database (LPM). The
system use DTS package to load the data from access database to oracle temp Tables. A
pl/sql package massage the data and make it ready to load into LPM system. The
interface was schedule in cron to run every night and write any error to the error log.
• Created the TRD .
Created the necessary data mapping between the two systems.
Design the interface tables and created the interface.
Tools used – DTS package, pl/sql, UNIX
Change Tracking System
The project was designed to capture all the changes made to the system for
Auditing purposes and able to generate reports depending on user requirements.
The user interface was created in Power Builder and the reports were created in
Crystal reports.
• Designed the tracking system and created 30 triggers on the tables to
Capture all the changes.
Tools used: - SQL, PL/SQL
Operating System – Window xp, UNIX
Database – Oracle 9i
Created new procedures, functions, views and Materialized View and enhance the
existing procedures and functions depending on the business requirement.
Tools Used: - SQL, PL/SQL, TSQL
Involved in tuning of interface, views, reports and queries. Created several SQL reports
and standard report using report 6i required by the business. Involved in day to day
production support work.
Tools used: - SQL, PL/SQL, DEVELOPER 6i
Echostar Communication Corp Dec 1999 to March, 2003
Englewood, CO
Senior System Analyst
IEX Interface
The project involved extraction of employee data (new hires and changes to existing
employees ) for all call centers scheduling dept from Oracle database and generate XML
file for IEX import process. The system also keeps track of all error out record during the
import process for reprocess.
• Design and develop PL/SQL package which includes several procedures
and functions to generate XML files in apps server.
• Schedule the interface in concurrent manager to run every day.
Write UNIX script to ftp the data file to IEX box and run the import.
Write several other UNIX script to automate the entire interface process.
Design and develop the technical documentation for the project.
Created several staging table and indexes.
Database – Oracle 8i
Discoverer Admistration/User Edition
• Responsible for creating and maintaining Discoverer views for HR dept.
• Responsible for creating users and maintain their privileges.
Responsible for migrating EUL from 3.0 to 3.1.
Created several complex reports in user edition.
Migrated oracle data to excel spread sheet and to access database.
Vision Interface and Dental Interface
The project involved extracting vision benefit data and dental benefits data from oracle
HR and send data to Insurance provider. The project also kept track of all termed benefits
and future benefits.
• Design and develop and automate the interface to send benefits data
to the insurance provider every week.
• Schedule the interface in concurrent manager to run once in a week.
Write several UNIX script complete the process.
Created several tables, indexes and sequences for this project.
Database – Oracle 8i
Self Service Enhancement
Self Service HR is a web application to enroll and display benefits data for employees.
• Modified several oracle standard packages which include
(Web PL/SQL and java) to meet company benefits needs
like waive benefits life multiplier, flex pay.
Spoe Interface
The system was designed to extract data (any changes to employee record and any new
employee) from oracle HR system to another employee system. The extraction was
schedule to rum nightly in dbms job. Created procedure using UTL SMTP package to
send mail to users incase of interface failure. The procedure is submitted in oracle dbms
job.
Salary History
During conversion from Peoplesoft to Oracle HR, salary history information was not
brought In to Oracle.
• Design and develop the interface to extract data from Peoplesoft.
Created temp table to load the data, created constraints for reporting purposes.
Created form to display all the salary history information and attached
to standard oracle forms.
DP to RA
The project is for service dept to keep track of all returned receivers.
• Created several complex views to for service department to meet their
needs.
HR Reports
Develop several 28/30 reports (3.0 and 6i) and sql reports like Headcount report (for
company, for dept, for call centers)Termination report, benefits eligibility report, New
Hire, rehire, life audit from scratch for Oracle HR applications.
Also did modifications to several interface and procedures and functions to meet business
needs.
Econnect
The project keeps track of all work order information entered in the web.
• Design and develop database Stored Procedure to read the flat file and
load and update the tables Mentis system.
Write shell script to automate the process.
Waiver System
The system is design for the customers who requested for network change.
Production Support and Involved in Enhancement of the project.
• Developed several Stored Procedure and functions to load data into Oracle
database (oracle 8i) reading the flat file and created stored procedures to
generate flat file at the ftp server using UTL package.
• Created several tables to load the data.
• Created several UNIX script to complete the process
Q2 Promotion
Developed 19 oracle reports (3.0, 6i) required for different promotions plan for marketing
department.
Created front end GUI form to run reports.
Kronos application (Call Center)
This was a backend data load application using Stored Procedure and Shell scripts. Did
Production support and necessary enhancement for Kronos application.
Created several views, did enhancements to lot of stored procedures and functions and
Packages as required by Business. Did conversion of lot of forms from 4.5 to 6i.
Created tables, indexes, views and sequences as required by business. Loaded data in
several production tables using SQL Loader.
Computer Associates. 07/98 to 12/99
Systems Consultant
Englewood, CO
Function as a team member for a migration effort from Oracle forms (4.0) to forms (5.0)
for a major Educational Institution. Development environment included WindowsNT,
Oracle Database 8.0 and Developer 2000 (2.1). The system consists of 26 forms. As a
team member involved in design and implementation of the package and responsible for
developing forms from the scratch and developing template form.
Functioned as a team member for an Oracle migration effort for a major healthcare
provider. Responsible for analysis and documentation and maintenance of three existing
“As Is” Oracle forms (3.0) applications in preparation for migration to SQL Server using
Visual Basic as a user interface. Analysis included determining business rules across
multiple forms as the legacy database was Version 6.0 Oracle and no integrity was
enforced at the database level.
Modified several packages, procedures and functions as required by the business.
Involved in regular releases activities (3 releases in a Year) for the changing business
needs.
EDUCATION
Master Degree in Physics
Sambalpur University, Orissa, India
TRAINNING
Oracle Developer 2000
Oracle HR Application ( Oracle Corp)
Advanced PL/SQL(Oracle 8i) (Oracle Corp)
Java Programming( MetropolitanCollege, Denver)
Discoverer ( Administration and User Edition ) ( Oracle corp )
Introduction to C# Programming and .NET
XML Publisher training
Oracle HR/Payroll Training
Reference will be provided upon request.
Contact this candidate