Summary:

• Total IT: Over 10 years of IT Experience including analysis, design, support and maintenance of Oracle Database systems on both UNIX and NT platforms and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS .
• Oracle: Solid database experience on Oracle 11g/10g/9i, PL/SQL, SQL Loader, Physical database design, Logical database design, Gap Analysis, Data Exports Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Oracle Tuning Optimization.
• PLSQL/SQL: Back-end programming experience using PL/SQL, SQL, T SQL, Stored Procedures, Functions, Cursors, Constraints, Triggers, Indexes B-tree Index, Bitmap Index , Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL.
• Databases: Oracle 11g/10g/9i/8i, MS SQL Server, DB2, MS Access 7.0/12.0/14.0/15.0, MySQL, PostgreSQL, Azure, Teradata EDW , Big Data, Amazon Cloud.
• Data Cleansing: Strong experience using PL/SQL, SQL Coding, UNIX Shell Scripting, PERL, VB Scripting.
• Highly involved in all phases of Software Development Life Cycle SDLC from Analysis, Design, Development, Test, Implementation, Documentation and Support.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques includes virtually every flavor of Entity-Relationship ER modeling, Physical and Logical data modeling.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL PLUS, TOAD and SQL LOADER.
• Strong exposure in writing simple and complex SQL, PL/SQL Functions and Procedures, Packages, Triggers, Materialized views etc.
• Actively participated in creating database objects such as Tables, Views, Synonyms, Indexes, Sequences and Database Links as well as Custom Packages tailored to business requirements.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Experience in the development of PL/SQL Stored Procedures, Functions, Triggers and Packages to implement business logic.
• Extensive experience in Performance Tuning and Query Optimization using Explain Plan and re-designing of poorly designed process flow of data.
• Experience in Data Migration processing including data loading from flat files to the database tables using SQL Loader.
• Experience in Data Extraction, Transformation and Loading ETL processes, Business Intelligence Tools like Business Objects.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake Schema Modeling.
• Experience in Dimensional Data Modeling using Erwin and participated in designing the Logical and Physical Data Model.
• Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• Experience in Database Design and Implementation of Discover Operational Data Store ODS and Enterprise Data Warehouse EDW and Data Marts DM .
• Extensively worked on Teradata Analyst Pack such as Teradata Visual Explain, Teradata Index Wizard and Teradata Statistics Wizard.
• Expertise in Oracle BI Server, Oracle BI Analytics, BI Scheduler, Oracle BI Interactive Dashboard and BI Publisher.
• Extensive experience in OBIEE repository Physical, Business Model and Mapping and Presentation layers .
• Expertise in Security configuration at object and data level using Users/Groups, Web Catalog configuration and LDAP authentication.
• Experience in working with Java developers to coordinate Web-based functionalities with Oracle Database. Knowledge in XML, HTML and JavaScript.
• Involved in jobs scheduling, monitoring and Production Support in a 24/7 environment.

Skill Set:

Professional Experience:

Confidential

Sr.Oracle/PLSQL/ETL/Informatica Lead Engineer

Confidential is a global nutrition company that has helped people pursue a healthy, active life since . Herbalife nutrition, weight-management and personal care products are available exclusively through dedicated independent Distributors in more than 80 countries.

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Implementation Project Planning and scheduling the various phases of the project with appropriate timelines, coordination, resource scheduling, work allocation and reporting.
• Involved in the in-house ERP scheduling project which consisted of compilation of data and streamlining of scheduled concurrent programs for the client facing documents in order to achieve an optimum number of such concurrent programs running into the system.
• Involved in issues like order lines not getting pick released or interfaced, Lines showing incorrect cycle status, Invoice not getting generated for shipped lines, demand still showing for the items after shipping is done.
• Creating new categories into the system and handled various issues like mass changing of buyer names for existing items, updating item attributes and item revisions, cleaning up of stuck up pending transactions, processing of transactions in interface tables, removing duplicated demand records for the sales orders, sub inventory transfer issues, serial number and lot number issues.
• Coordination with the client team for review and approval of the business process understanding documents, business process test scripts, list of custom components and delivery schedule.
• Worked on making Test scripts and performed testing procedures for various oracle apps modules like: Inventory Order Management .
• Provided functional impact analysis as a part of Change Management Process for the proposed changes by the business with existing configuration.
• Exceptional ability in coordinating the onsite and off-shore resources, while achieving milestones and deliverables within the project time limits.
• Experience in organizing status meetings including co-ordination with the business team, preparing and presenting project status reports.
• Define and specify the implementation of standards, industry best practices, methods and procedures for inspecting, testing and evaluating application development.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Developed business models conforming to functional mapping, defined logical and complex joins for the dimension tables.
• Develop batch processes for financial reporting applications and modules using shell scripts on Oracle database, with partitions and sub-partitions.
• Involved in Customer Relationship Management CRM as well as Vendor Selection and Management Process.
• Performed ETL operations involving data validation, cleansing, mapping and transformation using PL/SQL stored procedures.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables.
• Involved in developing UNIX Shell and PERL scripts to web server logs and print out the number of time each URL presents.
• Worked on Unix Server for file transfers and created Shell Scripts to hand the multiple jobs and kick off the jobs.
• Extensively wrote UNIX Shell scripts to automate the data load from SQL Loader to staging table.
• Involved in creating Teradata Objects like users, databases and Tables and enterprise level Performance Tuning, Workload Management and Capacity Planning.
• Implemented TASM Teradata Active System Management across the enterprise for performance and load balancing.
• Responsible for the design and implementation of the entire DW Dimensional Model architecture using Join Indexes and Partitioned Primary Indexes to achieve and exceed the desired performance.
• Experience in preparing complete end to end testing strategy for all types of testing's including Smoke test, flow testing, Performance Testing, Load Testing, Regression testing and SIT System Integration Testing and document the issue tracker with proposed solutions including open items, if any.

Environment: Oracle 10g/11g/9i, OBIEE, PL/SQL, My SQL, SQL Plus, SQL Loader, Oracle 6i, Reports 6i/10g, Forms 6i/10g, SQL Developer, Informatica, Linux, TOAD, Unix, Tableau Software, Teradata EDW , BI/ETL SSIS , MS Access, MS Office 2013, VBA Macros, Teradata V13/V14, Oracle, Golden Gate, BTEQ, Teradata SQL Assistant, Mainframes DB2 JCL, UNIX Scripts, DOS Scripts, IBM CNTRL-M, HPALM 11.5.

Confidential

Sr.Oracle/PLSQL/DW/ETL Data Architect

Confidential is a workers' compensation insurer that was created as a public enterprise fund by the Confidential of Confidential , and today has partial autonomy from the rest of the state government.

Responsibilities:

• Created data-related documentation e.g., file descriptions and definitions, entity relationships and attributes .
• Involved in working with various types of life insurance products like Permanent 'Plus' Whole Life , Level II 'Plus' Term Insurance ages 50 , Flex Term Term Insurance for under age 50 , Express Term 'Plus' no medical exam insurance .
• Involved working with various types of annuities like Single Premium Deferred annuities, Flexible Premium Retirement Annuity and Single Premium Immediate Annuity.
• Worked with ALIP Annuity Life insurance Policy administration system for various types of contracts like Active, Base Paid-Up, Lapse, Matured, withdrawn and Government Allotment Contracts.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Involved in debugging and Tuning the PL/SQL code, tuning queries and optimization of the Oracle database.
• Created external tables to transfer .csv files to tables and from tables to .csv using the standard package UTL FILE.
• Modified some of the existing reports and dashboards, and fixing some of the issues related to performance, data quality etc., during production support.
• Designed and developed the OBIEE Analytics Metadata Repository .Rpd using OBI Analytics Server Admin tool by importing the required objects Dimensions, Facts Aggregates with Referential Integrity constraints.
• Analyzing requirement of client, generating and designing reports using Reports 6i/9i as well as generating ADHOC reports with Oracle Discoverer.
• Developed ADHOC reports, created business area, new custom folders, complex folders, summary folder, hierarchies and list of values using Discoverer.
• Set up the Teradata Workload Manager with the proper partitions and workloads based on Service Levels. Set up Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc.
• Monitored the production and development systems on a daily basis to catch trouble queries, monitor access violations, and provide capacity planning.
• Modification of views on Databases, Performance Tuning and Workload Management. Maintenance of Access Rights and Role Rights, Priority Scheduling, Dynamic Workload Manager, Database Query Log, Database Administrator, Partitioned Primary Index PPI , Multi-Value Compression Analysis, Usage Collections and Reporting of Res Usage, Amp Usage, Security Administration Setup etc. and leading a team of developers for workaround with different users for different, complicated and technical issues.

Environment: Oracle 10g/11g/9i, OBIEE, PL/SQL, My SQL, SQL Plus, SQL Loader, Oracle 6i, Reports 6i/10g, Forms 6i/10g, MS Access, MS Office 2010, VBA Macros, SQL Developer, Informatica, Linux, TOAD, Unix, Tableau Software, BI/ETL SSIS , Teradata V13/V14, Oracle, MVS, XML, SAS 9.1, DB2, VBA Macros, Ab Initio, BTEQ, MLOAD, FLOAD, UNIX AIX, Business Objects XIR2, Trillium, ERWIN, Mega 2009/Service Pack 5, ER Studio Data Architect 9.5, Visio 2010, RSA UML Modeling .

Confidential

Sr.Oracle/PLSQL/ETL/DW-Data Engineer

Confidential is a collection of remote computing services that together make up a cloud computing platform, offered over the Internet by Amazon.com. The most central and well-known of these services are Amazon EC2 and Amazon S3. All services are billed based on usage, but how usage is measured for billing varies from service to service. The project scope is to design and test Data models and Data Mart for decision support for Claims, Recipient, Provider and Financial

Responsibilities:

• Possess wide range of programming, data mining and testing skills to discover actionable insights and data anomalies.
• Wrote complex PLSQL packages for Customer Interfaces, Payment Interfaces and Broker Commissions for Oracle Applications.
• Worked with Business unit to create scorecard, metrics reports using complex PLSQL queries, data mining and dimensional modeling skills.
• Modified PL/SQL statements to increase the overall performance as a part of performance tuning.
• Created indexes as a part of tuning. Merged data from one database to another database.
• Work within Infrastructure Automation team to ensure timely and effective provisioning of servers through various software development tasks.
• Extensively worked in Red Hat Enterprise Linux RHEL and Novell SUSE Environment.
• Involved in Creating and Administering the Physical Layer, Business Model Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Developed Role-Based Dashboards for Managers and Business Heads to review the Forecasts vs. Revenues and Campaign Relationship Management CRM to analyze the financial service center statistics for different campaigns, Customized pre-built dashboards.
• Implemented Object Level Security for the objects like Dashboards, Reports and Data Level Security for Region and Product dimensions using Session Variables.
• Analyze, design and develop a complex Sales Commission system for AWS Sales team with great accuracy and traceability to support constant changing environment.
• Generated Reports for the day-to-day as well as weekly and monthly purposes by using Macros.
• Extensively worked and Generated Monthly Billed Revenue Reports for IBM, Oracle, VC Venture Capital .
• Documented every phase like Technical specifications, source to target mappings, data models, UAT tests cases and results and release notes.
• Data Model Design and Documentation Facts and Dimensions, Business Users Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts
• Worked on Oracle applications Supply Chain Management R12 to deal with Orders, Inventory and sold goods data.
• Strong modeling skills including excellent knowledge of Access, advanced proficiency in Microsoft Excel macros, pivots, lookups .
• Involved in developing processes using ETL tools Data Integrator and PL/SQL to support business reporting requirements.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Involved in generating Daily/Weekly Sales Finance trending reports using Tableau a fast analytics and rapid Business Intelligence tool by identifying the dimensions, measures, measure values level of details for Business Analytics.
• Design, Development and Deployment of the financial analysis and Ad-hoc reporting using Oracle Reports and Discoverer.
• Involved in developing UNIX Shell and PERL scripts to web server logs and print out the number of time each URL presents.
• Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility.

Environment: Oracle 10g/11g, PL/SQL, My SQL, OBIEE 10g/11g, SQL Developer, Informatica, Netezza 5.0, Dimensional Modeling, Web Analytics, Core metrics Cogon's 8.4, Report Studio, Framework Manager, Transformer Tableau, Tableau Software, Excel Pivot table, VBA Macros, MS Access, MS Office 2010, Linux Red Hat , Data stage, SAS, Crystal Report X, Teradata-V12, MAINFRAMES MVS, TSO/ISPF/JCL, CA-7, BTEQ/BTEQWin, Fast Load, Visual Explain, Teradata Manager, SQL Assistant, BI/ETL SSIS .

Confidential

Sr. Oracle PLSQL/ETL/DW Developer

Confidential publicly owned investment firm headquartered in Confidential. The company's asset-management disciplines include growth, core and international, value, mathematical, alternative and fixed-income. These products are sold through advisors and financial intermediaries, to institutional investors and directly to retail investors.

Responsibilities:

• Documentation: Documenting Technical Design Documents, Business Requirements, Use Cases, Functional Test Plans.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tables pace.
• Migrated data from Oracle 8.x to 10g by creating Database links, SQL Loader and stored procedures.
• Extensively worked with mining the data with respect to the migration for achieving the consistency of data.
• Design and develop ETL processes, data flows and Data Marts based on business requirement specifications.
• Included Report Design and Coding for Standard Tabular type reports, including Drill Down and Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing the reports.
• Created the PL/SQL packages, procedures, functions applying the business logic to update the patients' database.
• Optimized SQL and PL/SQL performance using Oracle utilities like Explain Plan, SQL-Trace Analysis and TK-Prof.
• Used Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes.
• Configured the Workflow Manager to work on tasks like Assignment, Command, Control, Event, Timer and Decision tasks.
• Worked with Memory management for the better throughput of sessions containing Lookup, Joiner, Sorter and Aggregator transformations and involved in pipeline partitioning.
• Applied Informatica Performance and Tuning Logic and tuned the SQL statements by passing Optimizer Hints.
• Creating data mappings to extract data from different source Databases, transform the data using ETL Informatica Transformations then load to Oracle data warehouse.
• Prepared control data as per the business requirement, Analyzing of the specifications provided by the clients, Coding using Java and Hibernate for Algorithms, Maintenance Objects, Change Handlers, using Scripts for Enrollment Lifecycle handling.
• Forward recommends examination to our professional review department when the dental opinion is to modify and deny the procedure.
• Process claims with eligibility edits by researching history information with the client services division.
• Participated in Designing databases schemas to ensure that the relationship between data is guided by tightly bound Key constraints.

Environment: Oracle 10g/9i, SQL Plus, SQL Loader, PLSQL Developer, SQL 8.0.1, Clear Case 7.1.1, Informatica 8.1.1, Power center 9.1.0, Sybase Power Designer 12.0, TOAD, Windows XP, Oracle Enterprise Manager Database Control, NT, Red Hat Enterprise Linux, UNIX, Perl, BI/ETL SSIS .

Confidential

Sr.Oracle PLSQL/ETL/DW Developer

The scope of the Project is to implement the Treasury functionality, Confidential in various countries i.e. in various branches of Confidential. This application provides the entire processing of Treasury in bank. This provides end-to-end features such as Supports Front, Middle Back office Centralizing Risk management Money Market, Foreign Exchange, IR Swaps, FX Swaps and Fixed Income Securities.

Responsibilities:

• Involved in all the stages of Software Development Lifecycle SDLC design, development, analysis, testing and deployment of timesheet application.
• Gathered the Requirement from the business use and prepared the program specification and design document for the development of the Timesheet Application.
• Created the PL/SQL packages, procedures, functions applying the business logic to update the database with employees' timesheet and to calculate payroll.
• Created database objects like tables, synonyms, sequences, triggers and views and edited procedures and functions for improved business requirements.
• Tuned PL/SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Designed interface for front end users using Forms 6i/9i and performed modifications on already existing forms invoice, vendor details .
• Created Relational database design using Erwin tool, Create Logical data base design and then created physical database design.
• Created Pivot Tables and used narrative views and used dashboard prompts for creating intelligent dynamic dashboards.
• Performance Tuning of Dashboards/Reports and made required changes to repository Aggregate Navigation .
• Created custom mappings to accommodate customized fields. Utilized Intelligent Dashboards for reporting requirements.
• Developed custom reports/Ad-hoc queries using and assigned them to application specific dashboards.
• Collaborated with business area representatives for requirement analysis and to define business and functional specifications.
• Created/Modified Metadata repository .Rpd by using BI Admin tool: Physical Layer, Business Model and Mapping, and Presentation Layers.
• Designed and Configured Dashboards in Analytics for different groups of users to view figures across regions, products with the facility to drill down to individual customer relationship manager.
• Developed and debugged Dashboards/ reports visibility with respect to user's responsibility and web groups in an integrated environment.
• Coordinated the Analytics RPD and Web Catalog objects migration from Development environment to QA environment.
• Have used Administration Tool to configure Multiuser Development Environment MUDE for multiple users for the development environment.

Environment: Oracle 8i/10g, Toad 9.0/10.0, PL/SQL, SQL, UNIX, SQL Plus 9.2.0.0, Sun Solaris 5.8, Putty Beta 0.60, VI Editor, MS SQL 2005, HTML, Mercury Win Runner 7.8, Oracle 1og, Linux, SQL Server 2005, Oracle Business Intelligence suite OBIEE 11.1.1.3 , MS Visio 2007 professional, Windows XP, BI/ETL SSIS .

Confidential

Oracle PL/SQL/ETL/DW Developer

Confidential application was developed for MetLife Insurance Company. The application helps the field agents of the company to enter prospective customer's data. The application also calculates the amount of premium required, cash value and benefit amount for the years in consideration.

Responsibilities:

• Designed, developed and implemented a process to analyze orders received and store an audit log of average receipt to confirmation latency.
• Responsible for collecting requirements from the business users and developing technical specifications from it.
• Involved into writing/updating stored procedures for various admin systems using Oracle PL/SQL packages, functions, triggers, portioning tables and cursors based on the change requests.
• Creation of database objects like tables, materialized views, procedures, packages using Oracle tools like PL/SQL, SQL Plus, SQL Loader.
• Involved in handling errors and transaction processing in the procedures and Applying constraints, writing triggers to apply the business rules.
• Creation of database objects like tables, views, synonyms, materialized views, procedures, packages using oracle tools like SQL plus.
• Created Stored Procedures, Functions to transform the data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Extensively utilized PL/SQL Cursors, REF Cursors, Collections features to perform ETL load from multiple-feeds of source data.
• Extensively used UTL FILE an oracle built in function to transfer data from the source system to flat files to conversion staging area.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code PL/SQL program asynchronously.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.
• Designed and developed triggers, functions and procedures to work in support of the Java applications to reduce the dependency of the applications on the underlying structure.
• Performed query analysis using Explain Plan and TKProf. Analyzed the impact on the existing systems of switching the databases from rule-based to cost-based optimization, developed a plan and implemented the change.

Environment: Oracle 9i, PL/SQL, MS SQL Server, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL Loader, NT, Red Hat Enterprise Linux, ASM. Business Objects XI R2, Erwin, PVCS, Informatica Power Center 9.1, Informatica B2B, MFT, Teradata, DB2, Active batch, cogon's, UNIX HP/ Linux, Windows XP, BI/ETL SSIS .

Confidential

Oracle/PLSQL/ETL Developer

Confidential is one of the leading Telecom service providers in Ireland and a wholly owned subsidiary of BT Ignite - BT's broadband and Internet Protocol IP data and solutions business.

Responsibilities:

• Analyzed user requirements, created and normalized the database according to company's business rules.
• Implemented Communication layer which was invoked by data collector to open communication sessions to Telecom devices.
• Designed and implemented Map Reduce jobs to collect Configuration data and Historical data from huge number of Telecom devices - Network Elements NEs .
• Created and modified Client-Server modules utilizing Oracle 8i, SQL and PL/SQL for a BT Company Dispatch System. Features covered tracking and maintenance of BT Company's daily tasks including: order entry and billing clients.
• Developed credit card processing/authorization module in PL/SQL to extract new orders and transfer credit-card details from the Solaris DB server to NT and receive back authorized transactions, responsible for the ensuring correct operation of this process daily.
• Designed logical and physical Dimensional Data model Star Schema - Fact and Dimension for Analytics product.
• Designed and implemented huge Data collection Data warehousing application, which collects Multi Terabytes of data from Network element, useful for billing, capacity usage/planning and trend analysis.
• Designed, developed and implemented Virtual Private Database VPD for various telecom customers to implement high level of security recommended by other Government Security Agencies.
• Designed and developed customs forms like Contract Valuation, Subcontractor Timesheet entry and Certificate of Payment forms.
• Developed interfaces programs to interface the data from the custom forms into AR, AP and CR modules.
• Participated in a number of cross-functional teams and provided design, implementation and maintenance for custom reports.
• Participated in business meetings to discuss product development roadmap, analyze existing issues and provide suggestions for future releases Intelligent Network Management - Network Management Systems NMS .
• Architected and developed Multi-Processor Data Collector Manager DCM to collect and process high volume of data from huge number of Network Elements.
• DCM processors were deployed on the same and different machines so the application can be scaled vertically and horizontally.
• Designed and implemented many framework components such as persistent factory, lock mechanism, thread pool, etc.
• Architected and developed multi-phase Java application for Network Discovery to avoid resource contention due to too many threads running the same jobs at the same time.
• Developed the presentation layer and GUI framework that are written using JSP and client-side validations were done using JavaScript.

Environment: Oracle 7.3/8i, Oracle Forms 4.5/6i, Oracle Reports 2.5/6i, PLSQL Developer, SQL Navigator, Spotlight Database Monitor, Explain Plan, TKProf Oracle Forms and Oracle Reports, Windows 2000, Microsoft Vision, and MS Office 2000/05, BI/ETL.