We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Etl Developer  Resume

NY

EXPERIENCE SUMMARY:
Total around fifteen plus years of experience in Software Development in Complete Life Cycles of SDLC method, agile, Scrum and RUP method for different Business Applications. I Worked as Data Modeler, Sr. Oracle Application Developer.Ten Years’ experience in Sr. Oracle Developer as SQL, PL/SQL Forms, Reports, Oracle Batch Processing, DataStage7.5.2, COGNOS 8.1, Discoverer, Oracle 6.0/7.0/8.0/8 i/9i/10g/11g and OPUS (Open Product Underwriting System)

Technical Summary:

Operating Systems MVS/ESA, UNIX, Windows 2000/XP/NT, Windows 7 and MS - DOS
DBMS Oracle 11g/10g/9i/8i/8/7.3, IMS/DB (Hierarchal DB), DB2 (Relational DB), TOTAL (Networking DB)
Languages SQL, PL/SQL, COBOL, FORTRAN, PASCAL, C, C++, JCL, UNIX, Shell Programming
ETL Tool Data Stage 8.0.1/7.5.3
Reporting Tool Cognos 8.1, Oracle Reports 6.0, 8i, 9i, 10g
Tools Oracle Configurator Developer (11.5.8), Lotus Notes and Domino Editor 6.5.1, Erwin 3.5.2, Visio 2003
Domain Automobile, Financial Services Practice, Healthcare, Insurance, Product Development and Utilities domain knowledge
Client Server Tools Developer/2000(FORMS 3.0/4.5/5.0/6.0/6 i/9i, 5/3.0/6.0/6i/9i), HTML, MS-FRONT PAGE, REPORTS 2.0/2. 5,
Open Product Underwriting System (OPUS)
Case Tools TOAD Data Modeler 4.1, ER Studio and Designer 2000
DBA Tools TOAD, SQL*Loader, Import & Export
Application Servers Oracle 9iAS
Other Tools GITs, Clear Case, Clear Quest, VSS, WINCVS, CHANGEMAN, XPEDITER and ADPAC
Web Tools APEX 3.1.2, Java, HTML, Web Logic 6.x

Confidential, NY
Role: Senior Program Analyst
Confidential project provides the data for current flight's schedule time, any delay on the flights, arrival time. This system maintains the FAA employee personnel information.I work on multiple applications such as EIS (Employee information system), TCIP of business area. TCIP operates the towers and Tycoons in the airport itself thought out the country
Environment: Working in the Data services, Business Objects and oracle environment.
Responsibilities:

  • Involve the business requirement stage to understand the business process.
  • Design the dimensional modeling as of business requirement.
  • Prepare the program spec
  • Developed the code in Pl/SQL and do unit test.
  • Responsible for New Development, enhancement and bug fixing on Oracle11g for writing SQL and PL/SQL e.g. Packages, Procedure, Functions, DB Triggers., Objects, Types, Views
  • Optimizing SQL statements using hints, Indexes, Explain Plan
  • Used TKPROF, Hints for SQL tuning
  • ETL Tool Business Objects Data Services
Designation: ORACLE Developer with modeler
Confidential
Role: Sr. Oracle PL/SQL ETL Developer

Confidential refers to the management of natural resources such as land, water, soil, plants and animals, with a particular focus on how management affects the quality of life for both present and future generations.Natural resource management deals with managing the way in which people and natural landscapes interact. It brings together land use planning, water management, biodiversity conservation, and the future sustainability of industries like agriculture, mining, tourism, fisheries and forestry. It recognizes that people and their livelihoods rely on the health and productivity of our landscapes, and their actions as stewards of the land play a critical role in maintaining this health and productivity. I was responsible for couple of business area i.e Range, Minerals, CPAIS applications.
Environment: Working in the Java and oracle environment
Responsibilities:
  • Involve the business requirement stage to understand the business process.
  • Prepare the design documents as of business requirement
  • Prepare the program spec
  • Developed the code in Pl/SQL, forms and reports and Jasper reports.
  • Responsible for New Development, enhancement and bug fixing on Oracle11g for writing SQL and PL/SQL e.g. Packages, Procedure, Functions, DB Triggers., Objects, Types, Views
  • Optimizing SQL statements using hints, Indexes, Explain Plan
  • Used TKPROF, Hints for SQL tuning
Designation: ORACLE Developer with modeler
Platform: Oracle 10g, TOAD, ER studio
Confidential
Role: Sr. Oracle Pl/SQL ETL Developer with Data Model
Confidential facilitates the applicant to apply the job in federal government. This system provides the position classification, recruitment request, case tracking, vacancy announcement, store certificates and on board the employees. This system helps the HR Manager and Hiring Managers to hire right people in right position. Right now, there are few agencies are using this system to hire people. There is certain oracle batch jobs scheduled in this project to update the status of applicant’s whether this person is qualified or not for the job applied for.
Environment: Working in the Java oracle environment.
Responsibilities:
  • Design the system by understanding the business requirements.
  • Design the Process flow and ER diagram
  • Prepare the program spec
  • Developed the PL/SQL Package
  • Responsible for New Development, enhancement and bug fixing on Oracle11g for writing SQL and PL/SQL e.g. Packages, Procedure, Functions, DB Triggers., Objects, Types, Views
  • Optimizing SQL statements using hints, Indexes, Explain Plan
  • Used TKPROF, Hints for SQL tuning
Designation: ORACLE Developer with modeler
Platform: Oracle 10g, TOAD, ER studio
Confidential , Washington State
Role: Sr. Oracle PL/SQL ETL Developer
Confidential The Washington MEDICAID system (WAMMIS) facilitates the claims processing of the all the members and produces the checks for the service providers for Washington State in Olympia. The ETL data warehouse system consists of three parts i.e. (I) Extraction, (ii) Transformation and (iii) Load. There are total around nine subsystems (Claims, client, common, pa, tpl, reference, drb and provider) data comes from OLTP system and extracted to flat files and reads those flat files by ETL jobs and got loaded to target tables.Process Flow: There are around four hundred and seventy tables are generated in the extraction process(By using PL/SQL Package)and ftp to target location and ELT jobs start reading those files and got loaded in target tables based on some transformation rules in the mapping documents.
Responsibilities:
  • Co-ordination with Modeling team and business analysts for requirement study and system analysis
  • Developed the PL/SQL Package to generate all the source flat files from OLTP system
  • FTP to all the source flat files to target location through shell scripts
  • Developed some other PL/SQL packages for interface system
  • Responsible for New Development, enhancement and bug fixing on Oracle10g for writing SQL and PL/SQL e.g Packages, Procedure, Functions, DB Triggers
  • Optimizing SQL statements using hints, Indexes, Explain Plan
  • Developed ETL Jobs in DATASTAGE v 7.5.3/8.1
  • The ETL jobs are developed based all types/
  • Extensively used CDC stage, Remove Duplicates Stage, Sequential file, Datasets, Oracle EE stage, Transformer, funnel, Lookup, join.
  • Worked on the mapping documents for ETL transformations.
  • Developed Cross tab, tabular reports in COGNOS 8.1.4
  • Worked on Frame Work Manager of COGNOS to publish all the Database objects like Views, tables
  • Scheduled Jobs in COGNOS
  • Used TKPROF, Hints for SQL tuning
  • To write UNIX shell script to run some CRON jobs

Designation: ETL/ORACLE Developer
Platform: Oracle 10g, TOAD, UNIX Shell Scripts, Data Stage
Confidential
Role: Senior Oracle Developer
Single Order Filter application is part of Order Fulfillment (OMS/SOB+SOE+SOF). SOF application supports all the various Counts (PTD, MYTD, Daily, and Weekly) along with Close of Business (COB) counts of Orders. SOF process runs every day after the COB and adjusts the counts up to that day. There are various reports such as Control Query, Fixed reports, Miscellaneous reports to generate for the business.
Responsibilities:
  • Co-ordination with client and business analysts for requirement study and system analysis
  • Co-ordinate to Offshore resources and provide technical and Business guidance regarding project
    and manage project issues in new Development phase.
  • Responsible for New Development on Oracle9i for writing SQL and PL/SQL e.g. Packages, Procedure, Functions, DB Triggers
  • Optimizing SQL statements using hints, Indexes, Explain Plan
  • Performed exports, imports with the help of DBA
  • Used TKPROF for SQL tuning at the beginning and
  • Coding, Unit Testing, Issue Resolution, Integration and System Testing manually
  • To arrange meeting with PM, Business Analyst to update progress, Issues, Clarifications
  • To Maintain all tickets thru eRoom System
  • To write UNIX shell script to run some CRON jobs
Designation: System Design Analyst (SDA)
Platform: Oracle 9i, TOAD, UNIX, Java, XML, CSS, XML-FO, XSLT

Confidential
Role: Senior Oracle Developer
To support N*4 (B2C), OWB (B2B) and GSWB (B2B) Applications as per the customer’s requirement. The data entered by Data Agencies (Gray Matter) through Oracle Configurator Developer (OCD) then publish those Projects in OCD and based on the API Process (PL/SQL Packages) the data pulls to GVC GME database where GVC team supports this data part. If everything is fine as per the Entered data in OCD and in the GVC GME Database then N*4 Application or OWB can talk to the database to pulls the data to the consumer’s side where consumer can view the different models of the car models.
Responsibilities:
  • Installations Oracle 8i Enterprise Edition on Windows Professional 2000
  • Coordinating with client and business analysts for requirement study and system analysis
  • Mentor to Offshore resources and provide technical guidance regarding project
    and architectural standards and manage project issues
  • Creation of Database, Schema, users granted and revoked resources and other various kinds
  • f DB objects
  • Analyzing the existing system to understand the process workflow
  • Responsible for Development on Oracle8i for Responsible for writing SQL, PL/SQL, Packages, Procedure, Functions, DB Triggers, Web Logic
  • Up Gradations, Patch depends on the requirements
  • Optimizing SQL statements using hints, Indexes
  • Performed exports, imports
  • Used TKPROF for SQL tuning at the beginning and then installed Oracle Enterprise Manager and SQL Lab to analyze the SQL statements that took most of the CPU. Analyzed SQL results from Lab and helped to tune those queries
  • Coding, Unit Testing, Issue Resolution, Integration and System Testing manually
  • To attend SWAT CALL of Severity – 1, Escalated Severity – 2 Issue
  • To Maintain all tickets thru TEAM TRACK and later it is migrated to EARS System
  • To work on Oracle Configurator Developer (OCD 11.5.8)
  • To maintain and develop UNIX shell script to run some CRON jobs
  • To attend SWAT CALL of Severity – 1, Escalated Severity – 2 Issue
  • To maintain all tickets thru TEAM TRACK and later it is migrated to EARS System
  • To create users by using Oracle Apps Concurrent Manager 11i
  • To Register the concurrent jobs and schedule in the PRODDUCTION environment by using concurrent manager and monitor the jobs.
Designation: Developer
Platform: Oracle Forms 6i, Oracle 8i databases, Oracle Apps 11i

Confidential
Role: Senior Oracle Developer
The existing 'Confidential' system at Confidential is an Oracle Forms product deployed on Windows NT architecture and has Oracle 8i database as the backend. The Oracle databases have been deployed on UNIX systems using HP-UX platform. This product is an integrated Loan Origination and Maintenance System wherein HDFS can accept loan applications that may/may not use any special promotions, accept/reject those applications, fund accounts for accepted applications, activate the accounts to receive payments and eventually payoff those accounts. Special processing for linquency, bankruptcy and repossessions is also available in the system.
Responsibilities:
  • Analyzing the existing system to understand the process workflo
  • Created Packages, Procedure, Functions, Triggers
  • Optimizing SQL statements using hints, Set Trace on and TKPROF Utilities
  • Copying Data one schema to another schema by Using DB links
  • Created Couple of Procedure and function to validate the data in LOS (Loan Origination System)
  • Created some customized new forms and reports as of business requirements
  • Created some SQL and PL/SQL scripts to build the Patch
  • To develop UNIX shell script to run some batch jobs
Designation: Developer
Platform: Oracle Forms 10g, Oracle Reports 10g and Oracle 10g databases, UNIX, Shell Script

Confidential
Role: Senior Oracle Developer
This system facilitates for tracking and managing candidates in different skill set areas like oracle, java, .Net, ERP etc. By the help of this system, the companies can evaluate the skill Sets of their candidates in different level of capacities. The evaluation is self-adaptive based on the nature of the test. It has extensive tracking and managing capabilities.
Responsibilities:
  • Installations Oracle 9.2.0 Enterprise Edition on Windows Professional 2000
  • Creation of Database, Schema, users granted and revoked resources and other various kinds
  • f DB objects
  • Responsible for Development on Oracle9i for Responsible for writing SQL, PL/SQL
  • Packages, Procedure, Functions, Triggers
  • Up Gradations, Patch depends on the requirements
  • Optimizing SQL statements using hints
  • Performed exports, imports
  • Used TKPROF for SQL tuning at the beginning and then installed Oracle Enterprise Manager and SQL Lab to analyze the SQL statements that took most of the CPU. Analyzed SQL results from Lab and helped to tune those queries
  • Generated reports in Discoverer
  • Worked on VB scripts
Confidential
Role: Senior Oracle Developer
Confidential is a prestigious general insurance project, which caters for all three Operation Entities (OEs) of Allianz Singapore, Hong Kong and P.R. China. This main objective of this system is to standardize for all three OEs business requirements with common database objects, Forms, Reports and libraries. The project supports Corporate and personnel & Communication (P&C) sectors of all three OEs. There are the common three modules i.e. Policy (PME), Claims (CME) and Accounting (AME) of all the six products like Property, Marine, Engineering, Motor, Monoline and Liabilities.
Responsibilities:
  • Analysis, detailed design, coding and testing of custom-built Applications
  • Integrated Claims module with the Accounting and Policy modules
  • Responsible for writing SQL, PL/SQL
  • Responsible for Development on Oracle9i, Forms 9i and Reports 9i.
  • Involving in Documentation like preparing program specifications, Test Plan, Functional Specification
  • Involved in Software Development Life Cycle of new system i.e. System Design, Coding, Code Review, Testing, and Implementation. At the same time working on Enhancement of existing system in Oracle 9i, Forms 9i and Reports 9i.
  • Involved in Development of Motor Claim Management System (CME), some part of Policy management system, some part of Accounting system and developing some accounting, policy and claims Reports.
Environment: Oracle9i, Dev / 2000 (FORMS 9i, REPORT 9i), Insurance functionalities support tool OPUS (Open Product Underwriting System)
Confidential
Role: Oracle Developer

Confidential is a Client–server Health Insurance application that caters to the fast changing trends and Practices of the Health Insurance Business. The main Objective of this Project was to replace the legacy system by a Flexible and a robust system built around the OPUS Framework. It supports both indemnity and Integrated Care types of Products with a flexible Plan/Product set-up. Confidential is one of the prestigious health insurance .projects of Confidentia It’s a purely health insurance project which supports to Customer partner, Policy, Claims, Accounting, Plan, classes, benefits set up, Code maintenance set up, providers, panel maintenance, card printing & agency information. It provides the facilities to take care of health to our customers who is insured by the company. The customers are provided by health insurance card by which they could visit any doctor or any panel of doctors in Singapore for his/her health checkup.
Responsibilities:
  • Responsible for Development as well as Maintenance on Developer 2000. On developing Reports and Forms using ORACLE 8.1.7, Forms 6i and Reports 6i , SQL and PL/SQL
  • Involving in Documentation like preparing program specifications, Test Plan, Functional Specification
  • Involved in Software Development Life Cycle of new system i.e. System Design, Coding, Code Review, Testing, and Implementation. At the same time working on Maintenance & Enhancement of existing system in Oracle / D2K.
  • Worked on SCO-UNIX script to create jobs to run in mid-night.
Environment: Oracle 8.1.7, Developer/2000 (FORMS 6i, REPORT 6i), Designer 2000, SQL, PL/SQL, OPUS (Open Product Underwriting System)
Confidential
Role: Oracle Developer
Confidential Project is one of the prestigious projects in Singapore in which NIIT is currently handling. The project has planned for some couple of years. LTA has planned to shift all modules, which has already developed in different platforms to web sites. This project consists of around sixty-four Applications handled by NIIT team. Oracle, Developer/2000, Lotus Notes, Oracle Applications, VB, ASP, Silver Stream (Application Server), Java and Java Scripts are used in this project. I am one of the consultants from NIIT team looking after some of the core Applications. I am fully involved in the Implementation and Testing with different modules like Leave Benefit System (LBS), Staff suggestion system (SSS), Leave Chart system (LEVC), LTA Registry system, Travel Pass System (TPS) along with back up of some more system like Man Power Budget system (MPB), Safety Information system (SIS) and Mediclaim System (MCS). I am giving active support to all of the systems.
Responsibilities:
  • Responsible for Development as well as Maintenance on Developer 2000. On developing Reports and Forms using ORACLE 7.3 / 8.0, Forms 4.5 and Reports 2.5
  • Integrated HR modules with the Payroll modules
  • Responsible for writing SQL, PL/SQL.
  • Involving in Documentation like Preparing program specifications, Test Plan, Functional Specification, User Guide, ER-Diagram, system flow
  • Involved in Software Development Life Cycle of new system i.e. Requirement Analysis, System Design, Coding, Code Review, Testing, and Implementation. At the same time working on Maintenance & Enhancement of existing system in Oracle / D2K.
Environment: Oracle 7.3, Dev / 2000 (FORMS 4.5, REPORT 2.5), Oracle Discoverer 3.1, Access

Confidential
Role: Oracle Developer
This system mainly consists of five sub-modules i.e. Cross Control System (CCS), Time Office Management System (TOM), Payroll System (PAY), Human Resources Management System (HRMS), Contractor’s PF modules. The security of HRPR is highly secured from front end through Cross Control System. The system is based on Menu trees. All modules can be opened from menu trees and give rights to each Form from this menu tree only. This is a very good feature of this system, because every thing can be controlled from Front End.
  • The Time Office Management System manages the time of all employees of CFCL, Gadepan. This module describes about the leave status of all employees, OT (For Non- mgmt) / OPE (Out of Pocket Expenses for mgmt), daily attendance, irregularities, absenteeism, exceptions, Early goings and Late arrivals and all types of approvals, freezing, Unfreezing of Time Office Data.
  • It also gives the very good features of Distributed Attendance System (DAS) for all CFCL employees, which can access by all employees to enter their own leave request Form, OT/OPE entry for approval, Tour Entry for approval through this module.
  • Payroll processed the salary based on the monthly attendance. Before processing the salary all the data should be freezed of Time Office as well of Payroll data. This system processes the IT calculations, medical reimbursement, Provident Fund, Super Anuation Fund, Variable DA, Journal Voucher (JV), Salary process and salary reversal process. The salary reconciliation statements give us the exact tallied figure of amount debited and credited.
  • The Contractor’s PF System processes the wages of Contractor’s employees, maintaining the employee’s details as well as contractor’s details. The system is tracking the attendance details of all employees on which the wages are given the salary to each individual.
  • Special features:
  • Mailing Facility is provided
  • Export or Import the data from XL-Sheet to Forms and Forms to XL-Sheet.
  • Upload the data from Dbase file (DBF File) to Oracle and Vice versa by using ODBC.
  • Responsibilities:
  • As A Team Leader, I was involved myself the full life cycles of this system.
  • Was responsible for Feasibility Study, System Requirement Study. On developing Reports and Forms using ORACLE 8.0 Forms 6.0 and Report 6.0.
  • Was involved in Design, Prototyping, Preparing program specifications, Coding, Testing, Review the programs and Implementation.
  • Was responsible for data migration from Unify system to Oracle through SQL Loader. Worked on also Export and Import.
  • Worked on Microsoft Tool i.e. Visual Source Safe (VSS), used to put all Forms, Reports, Data Base scripts, Procedures, Functions with highly secured of all versions if any changes made.
Environment: Oracle 8.0, Dev / 2000 (FORMS 6.0, REPORTS 6.0)

Confidential
Role: Software Engineer
Confidential Transportation is one of the transportation units of Confidential based at Jacksonville, Florida, USA. Confidential operates the largest railroad in the US in terms of Track miles. As a team member I was involved in the Analysis and Review of COBOL programs, Code conversion of impacted fields in the programs as per guidelines, testing of the program using XPEDITOR and in preparation of test plans.
  • Participate in Peer Reviews, develop documentation required for testing, develop test plan and test cases, coordinate upload of test data and setting up of the system environment (including system clock), investigate tools for data preparation, prepare test data, ensure quality of test data and conduct test and review. Coordinate for database inventory and save area information with CSX. Coordinate for database downloads (Information Management System (IMS) / Database 2 (DB2) / Variable Sequential Access Method (VSAM), etc.) with CSX Y2K Management. Transfer data to SYSK.
  • Analysis, Review, Coding and Testing
Environment: IBM-3090 COBOL, CICS, DB2, IMS, JCL, VSAM, MVS/ESA CHANGEMAN, XPEDITER, FTP and ADPAC

Hire Now