Oracle Developer/Software Developer Resume
|Desired Industry: Computer Software/Programming
|Desired Job Location: Wood Dale, Illinois
||Date Posted: 11/16/2009
|Type of Position: Contractor
||Availability Date: Immediately
||U.S. Work Authorization: Yes
|Job Level: Experienced with over 2 years experience
||Willing to Travel: Yes, Less Than 25%
|Highest Degree Attained: Bachelors
||Willing to Relocate: Yes
Oracle Developer / Software Developer
June 2009 - Aug. 2009
Oracle Development Software Developer /Programmer Walgreens
Worked for Walgreens on major enhancements for their third party claim billing systems on Unix platform using Oracle 10g, PL/SQL, SQL and Pro*C.
The projects were focused on retrieving patient primary and other insurance coverage data from central and local databases to provide data to central and local servers.
The work responsibility included design, coding, unit and integration testing.
May 2007 April 2009 Software Developer /Programmer Verizon
Worked for Verizon Net Conferencing Billing System to develop new billing modules and maintain
existing systems. The work was done in a full software development life cycle, which included
receiving and understanding business requirements to write high level and detailed design documentations, coding, unit testing (wrote unit testing plans, execute unit testings, and document unit testing results), system testings, and UAT testings. The technologies that are used are Oracle 10g/9i, PL/SQL packages, procedures, functions, triggers, SQL queries, Pro*C, and Unix shell scripts.
The major accomplishments includes:
Design and implemented new billing modules:
o Net Conferencing Storage usages
o Net conferencing credit adjustment for storage usages
o Invoice feed for International financial data
These billing modules were written in PL/SQL packages, procedures and functions on Oracle 10g/9i platforms. These processes were called through Unix shell scripts, and some of them was interfaced with Pro*C programs. Other works include writing data conversion scripts and triggers to assit installationof the new billing modules.
Design and implemented bug fixes on existing systems using PL/SQL packages, procedures and functions
Did some data analysis using SQL queries
Documentations on all above
o High level and detail designs
o Unit and system testing plans and results
o Data analysis
o Problem investigations
Jan. 2004 Dec.2006 Software Developer /Programmer Schering Plough Corporation
Working on Schering Plough Drug Safety applications, to provide Adverse Events Reporting and Analysis (Periodic Safety Update Report, Supplemental Analysis, Annual Safety Report, Signaling Reports, etc.) to FDA, EMEA and other upper health officials on Schering Plough Clinical and Post Marketing products, and also provide data management solutions to the Adverse Event database. The job responsibilities included design, development, unit testing and execution of implemented processes. The technologies used are Oracle 9i, SQL queries, PL/SQL packages, procedures and functions, SAS 8 & 9.
The major accomplishments include:
Designed and implemented PSUR Supplemental Analysis Reports using PL/SQL package (by drug and time range) and SAS program
Designed and implemented SQL queries to create Adverse event data errors reports (in 35 data categories) to support the Daily and Summary Cleansing tasks for Adverse Event Database
Design and implemented Caviar System performance analysis using PL/SQL package. The process will give high and low peak of Caviar users using the system by a given time frame.
Designed and implemented Clinical Signaling Non-Adverse Events Reports using SQL queries and SAS program
Designed and implemented Special Patient Population Reports (14 patients categories) using SQL queries and SAS program
Design and implemented Ad-Hoc requests using SQL queries and SAS programs
Aug. 2003 Dec. 2003 Software Developer /Programmer AT&T
Oracle Data Warehouse Development
Worked for AT&T International Data Warehouse (IDW) project, and the work was done on Solaris 8, Oracle 9i platform, and used Unix Shell Scripts, Awk, Unix Syncsort, SQL, PL/SQL procedures and functions, SQL-LOADER, etc..
The major accomplishments include:
Design and implement a new subsystem to provide allocation data feed to reporting process. The process calls SQL queries to retrieve data, then calls Unix, Awk and Syncsort scripts to transform and format data for output.
Design and implemented PL/SQL procedures and functions to support IDW data validation process.
June 2003 Aug. 2003 Software Developer /Programmer Novartis
Oracle Data Warehouse Development
Working on Sales Data Warehouse project to design, implement data extraction, validation, transformation, and data loading processes using Ascential DataStage 5.02, Oracle 9i, SQL, SQL-Loader, Unix Shell scripts, Unix Syncsort on AIX Unix system. My responsibility included coding, testing, documentation.
Worked on Clinical Data Warehouse project to implement data extraction, transformation and data loading processes using Informatica, Oracle 9i, SQL. The major tasks are to create Informatica mappings, sessions and batches for data loading, unit testing and documentations.
Aug. 2002 May 2003 Software Developer /Programmer Schering Plough Corporation
Worked in a data warehouse environment to build database schemas for Sales Force applications in a full software development life cycle environment. The major tasks were to write shell scripts and programs to load data staging tables, dimension tables, and do data aggregations to populate summary tables using Oracle 8i, SQL queries, PL/SQL, packages, procedures, functions, triggers, Pro*C, Unix shell scripts, Sql-loader, and HPUNIX.
The accomplishments included:
Design and implement RAPIDS system, which is a report schema to provides BI solution to the home office. The RAPIDS system gives recommendation of number of calls to prescribers (doctors and other medical professionals) for prescribed drugs. The major works include:
o Use Unix scripts and SQL Loader to load staging tables and dimension tables
o Use PL/SQL package to load summary tables. The PL/SQL package contains DML queries to do data aggregations.
o Use PL/SQL procedures and functions to process and load alignment dimension tables.
o Use Unix scripts to control the loading process
o Use Unix scripts to maintain in and out feeds
o Unit testing
o Document design, functional specifications and system descriptions
Used database triggers to backup DML operations to history tables
Support existing systems
EDUCATION B.S. Computer Sciences and Mathematics
Rutgers University, Dec. 1989
Oracle 10g/9i/8i, SQL, PL/SQL, Packages, Procedures,
Functions, Triggers, Oracle Sql-Loader, Pro*C, C/C++,
Unix Shell Scripts, Awk, Sed, Unix Syncsort, Cron job,
SAS 8 & 9 (Base SAS, SAS Macros, SAS SQL),
Sybase, DB-Lib, Stored Procedures, Funcations and Triggers,
Sqlplus and TOAD.
UNIX Systems (System V, Sun Solaris, Sun Os, HP, AIX),
Windows NT, 2000, XP and 95/98,
SUN Work Stations, HP Work Stations, NCR Systems,
PC Work Stations, Microsoft Office, and FrameMaker.
Oracle Developer 2000 (6i) /Forms/Reports,
ETL Tools: Ascential DataStage 6.01, Informatica,
May 2000 Aug. 2001 Software Developer /Programmer CSC
Worked for a large telecom company on a realtime telemarketing system, which takes and processes customer service orders. The system interfaces a number of technologies together using a client-server platform with Tuxedo Transaction Processing software to provide services and retrieve information through a Gateway that communicates with external systems.
My responsibilities included process design, documentation, coding, implementing unit testing plans (cases), unit testing, and code delivery in a full software development life cycle. The major tasks included new development, system enhancement, maintenance, reports, trouble shooting and fixing system problems using Oracle, C++, Pro*C, SQL, PL/SQL, Procedures, Functions, Triggers, BEA Tuxedo, IPCs, Shell scripts, Perl, Rogue Wave Libraries, Awk/Sed, and Cron jobs in Unix environment.
Design and implement new client/server processes.
Design and implement system enhancements and modification requests.
Writing scripts for Error Correction Server weekly and monthly reports.
Writing tools to monitor, investigate and fix existing server problems.
Investigate history data on Error Correction database, and perform a complete database clean up to improve system performance.
Investigate, analyze current server configurations and applying changes and adjustment to it.
Perform ad-hoc query requests.
Investigate data related problems using trigger.
Oct. 1997 Feb. 2000 Software Developer /Programmer AT&T
a). The Allocation Load Processor (FALCON)
Worked as a developer in a large data warehouse environment and responsible for a full software development life cycle, which included process design, documentaion, coding, writing testing cases, performing unit testing, string testing, and code delivery using Oracle, Shell Scripts, Unix Syncsort, Pro*C, C++, C, SQL, PL/SQL, Oracle Sql-Loader, Awk, Sed, Autosys in Unix environment.
Design and implement Description Code process.
Perform major system enhancement.
Perform data conversion on MRAL database for each new release.
Writing tools to monitor daily loading process and validate data conversion correctness.
b). The Budget System (TBS)
TBS is a client/server system to provide functionality for user to create, design, view budgets. I was responsible for a full software development life cycle, which included process design, documentation, coding, writing testing cases, performing unit testing, code delivery using Shell scripts, Sybase (11) Open Client/Open Server products, DB-Lib, SQL, Oracle, C, Pro*C, and Cron in UNIX environment.
c). EC-PIC Gateway
An electronic communication gateway is being implemented to allow AT&T to exchange orders and inquiries with the local exchange companies (access providers) in real time. I was responsible for a full software development life cycle, which included design, coding, unit testing on system enhancement, modification requests, maintenance and system support using Oracle, C++. Pro*C, SQL, BEA Tuxedo, Shell scripts, IPCs, Rogue Wave Libraries, Unix, and Connect-Direct on Sun workstations.
Mar. 1997 - Aug. 1997 Software Developer /Programmer Bellcore
Service Access Manager
A gateway system to provide interfaces between clients and many legacy systems for Ameritechs business needs. I was responsible for a full software development life cycle, which included design, coding, unit testing on system enhancement, bug fixing, maintenance using Oracle, C++, Pro*C, SQL, BEA Tuxedo, Rogue Wave Libraries, HP-Unix, and HP work stations.
June 1993 - Feb. 1997 Software Developer /Programmer AT&T, Lucent Technologies
Custom Profile Management Application:
A client/server system that handles account management cross all the provisioning platforms, and it delivers business solutions for all custom profiles to establish a central data store. I was responsible for a full software development life cycle, which included system enhancement, maintenance, bug fixing and system support using C, Oracle, Pro*C, SQL, shell scripts and BEA Tuxedo in UNIX environment.
Worked on several ledger based client/server systems, which run on a customized client-server environment, using Sybase Open-client/Open-server technology to provide a dynamic and distributed environment.
I was responsible for a full software development life cycle, which included process design, coding, writing testing cases, unit testing, code delivery using Sybase, DB-Lib, SQL, Stored procedures, C, C++, Shell scripts and Cron jobs in Unix environment.
My accomplishments included:
Designed and developed a ledger sub-system (feeder), which receives and processes transaction feeds and posts to the ledger database for other accounting and ledger activities. The process is controlled by system event and scheduler.
Designed and developed a ledger sub-system (reversal) that releases reversal transactions in monthly bases. The process is controlled by system event and scheduler.
Developed and maintained a ledger sub-system (DCL) that distributes costs and hours for work performed. The process is controlled by user-defined event and scheduler.
Designed and developed several batch modules that process and transform feeders to other business platforms to support accounting activities and maintenance needs.
Jan. 1992 - June 1993 Software Developer /Programmer Bell Atlantic
Worked on an on-line engineering management system to support engineering design, construction, inventory tracking, maintenance of outside plant telephone equipment. I was responsible to design and implement GUI user-interfaces and other back-end processes in X/OSF Motif, C, Sybase, SQL, Shell scripts, Unix on SUN Sparc stations.
Designed and implemented subsystems that defined signal connections between digital loop carrier equipment. The systems provided user with graphical and textual interfaces for data processing.
Designed and implemented supplemental drawing subsystem. The system provided drawing manipulation functionalities for generating engineering work packages.
Implemented engineering reports.
June 1989 - Aug. 1991 Software Developer /Programmer Computer Ed Inc., Bethlehem, PA
Designed and implemented an order entry and bill of material system for a greenhouse manufacture in Eiffel(OOP).
Participated in developing a 3D apparel design project in Unix, Eiffel(OOP), C, X window/OSF Motif and participated the user interface development, Eiffel & Motif Interface Library development.
Designed and implemented a nurses education information system in Paradox.
Feb. 1989 - June 1989 Programmer Sedgewick Printout Systems, New Jersey
Implemented a petroleum software directory information system in Clipper/dBase III Plus under MSDOS, Novel LAN.
Oct. 1987 - Feb. 1989 Programmer (Part-time) Rutgers University, New Jersey
Implemented various environmental health and safety practice database systems in Clipper/dBase III Plus under MSDOS, Novel LAN.
Available upon request.
Candidate Contact Information:
|JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.