We provide IT Staff Augmentation Services!

Peoplesoft Sr. Technical Consultant Resume

4.00/5 (Submit Your Rating)

Basking Ridge, NJ

SUMMARY

  • 12+ Years of experience as a PeopleSoft Technical and Functional consultant in SCM /Financials versions 9.1, 8+ (8.9/8.8/8.4)
  • Overall 16+ years of experience in Information technology.
  • Solutions - driven professional, who excels at implementing projects, collaborating with project teams, interfacing with clients, and deploying technology to build successful solutions.
  • Experience in PeopleSoft Full life-cycle implementation includes analysis, upgrade, Interface design and development, customizations, reporting, data conversion, configuration, testing, debugging, troubleshooting and production support.
  • Extensive experience with SCM/Financials Modules: Order Management, Inventory, Billing, Accounts Receivables, Account Payables, General Ledger, Asset Management, Purchasing, eProcurement, Pricing Contracts, Project Costing, and also HR-Modules like HR, Payroll and Benefits.
  • Experience with configurations and processing of EDI Implementation and Multicurrency.
  • Proficient with using People Tools 8.53 including SQR, People Code, Application Engine, Crystal Reports 8.5/9.0, nVision, Visio, Component Interfaces, Integration broker, Data Mover, File layout, PS Security and XML Publisher with Oracle9i/10g/11g and SQL Server 2000/2005/2008 , 2012 Databases.
  • Experience in setup and implementing third party integrations like Ariba, Carrier point, INMAR and Carixa.
  • Experience with Work Flow Approval configuration, setting up route control profiles, analyzing and giving security permissions and roles.
  • Experience with complete Business processes like Order-to-Cash and Procure-to-Pay processes.
  • Ability to translate business needs and requirements to functional/technical processes.
  • Results-oriented team player who is able to multi-task to strive to achieve the ultimate business objective.
  • Expertise in the creation of complex reports using SQR, Crystal Reports and PS/Query by translating client business requirements into technical specifications. Hands-on experience using template-based reporting tool XML Publisher.
  • Performed extensive fit/gap analysis and process discovery for several financial applications, and identified problems and resolutions for implementing the respective PeopleSoft systems.
  • Profound noledge of SDLC and Testing life cycle.
  • Worked through complete cycle of defect management.

PROFESSIONAL EXPERIENCE

Confidential - Basking ridge, NJ

PeopleSoft Sr. Technical Consultant

Responsibilities:

  • Working as a Technical developer as part of conversion team in converting PeopleSoft 8.4 modules to PeopleSoft 9.1.
  • Conversion includes, Chart of Accounts, Journals, Ledgers, Trees and many interfaces.
  • Converting Chart Fields using Component Interface and App Engines.
  • Converting Journals and Ledger Balances and validating the data.
  • Developing conversion programs using App Engines, Component Interfaces, File Layouts, App Messaging.
  • Modifying and upgrading various GL, AP and AM Reports using App Engine and SQR’s and Crystal Reports.
  • Configured GL Combination Chartfield templates and linked to proper ledger templates and Identified/created combination edit rules and edit groups. Tree structures and hierarchies are created for query security and rollup groups.
  • Uploading Journals by Excel Templates and modifying Journal Templates.
  • Creating and modifying PS Queries.
  • Designing various programs for Integrating between various systems Including HR to new PS 9.1 Financials.
  • Configuring Chart of Accounts and Running Combo Edits.
  • Creating and converting nVision, Scopes, Report Books, Scope values.
  • Modifying and converting Trees and Tree manager.

Confidential, Bridgewater, NJ

PeopleSoft Sr. Techno-Functional Analyst

Responsibilities:

  • Business process owner for configurations for SCM and Financials Modules.
  • Actively participated in Canada and Ireland conversion configurations of the OM, IN, Billing and AR Modules.
  • Team member in configuring the new acquisitions of Precision, Solta, ECR and Akron.
  • Setting up AR Distribution codes and Distribution sets for new Business Affiliates of Canada and Ireland Implementation Projects.
  • Worked on setting up, creating and loading new Price Lists.
  • Configuration and setting up and loading new Vendors and Customers from the acquired companies
  • Setting up Bank Accounts, loading the AR Item balances.
  • Functional Analyst and Technical lead for implementing the new Integrations.
  • Working with App Engine programs for receiving the EDI180 for RMA Returns and sending EDI812 for Credit memos to the INMAR, which processes major returns.
  • Project lead for integrating the PeopleSoft AR system to the third party AR Management Tool - Carixa by designing the process and working with SQR’s and App Engine programs and eGate Transactions.
  • Working on processes Payment Loader, Payment Predictor, Lock Box Files.
  • Designed to load AR Payment data using Component Interface and App Engine from Carixa.
  • Reconciliation of AR Lockbox files, and payments through Cyber source, working on issue with deposits, payments and deductions.
  • Fixing Journal Integrity errors, working on Project Costing Processor Issues, troubleshooting AM Issues.
  • Running calculating Depreciation process and Depreciation reports.
  • Defining and modifying the Transaction Account Rules for new affiliates.
  • Working on enhancements and customizations in day to day requests from business.

Confidential - Wayne, NJ

Sr. PeopleSoft Techno Functional Consultant

Responsibilities:

  • Involved in all functional and technical development activities for PeopleSoft implementation, upgrade, enhancements and Production support including requirements gathering, developing BRD, FRD, Technical Design, Development and conducting QA and UAT testing for OM, Billing, Pricing, EDI, Inventory, e-procurement, Purchasing, AP, AR, T&E and GL Modules.
  • Involved in Strategy, Planning for PeopleSoft Financials upgrade and created technical project plan and cutover plan for upgrade process and also created technical design document for various customizations and retro fit.
  • Involved in providing day-to-day Application Support for PeopleSoft Financialsand troubleshoot the issues.
  • Automation and emailing of the AR Customer statements customizations.
  • Worked on various interfaces used for Carrier point integration.
  • Configuration and Implementation of Right Fax Server.
  • Configuring EDI Manager to setup and run EDI processes such as EDI 855 Order Acnoledgement, EDI810 sending and receiving EDI Invoices, EDI850 Sales orders receiving, EDI852 Point of Sales processing.
  • Setup EDI820 and processing and loading AR Payments.
  • Third party Integration with Carrier Point Logistics, Aspen and Maximo AP Interfaces, Integration with JDA supply planning applications.
  • Automation of Drop Ship orders processing from sales orders to purchase order, Voucher Processing and to Billing.
  • Developing OM analytics reports for customer care management to track the orders based on different parameters.
  • Worked on Purchasing Web portal to Ariba to enable two way communications with all the suppliers and end-to-end-tracking of GAF-Supplier interaction. The portal would enable real time / close to real time with Purchase Orders, Order Acnoledgements, ASN, Vendor / Supplier Invoicing
  • EDI Processing with Gentran, and FTP file transfers with different Banks.
  • Billing Invoices Auto Emailing.
  • Completed design and development of ExceltoCI Component Interface to facilitate loading Billing Data.
  • Implemented Lock box files for various Banks and involved in processing them through payment Loader and configuring payment predictor.
  • Completed design and development of custom Component Interfaces and App Engine programs to load Supply Chain data for PeopleSoft Manufacturing, Inventory, and Order Management
  • Working on enhancements and customizations in day to day requests from business.
  • Modifying store procedures which are used in specially designed sales incentive system.
  • Functional and technical design and implementing the drop ship order and voucher processing through EDI Manager. EDI Inbound mapping done to voucher staging Tables.
  • Voucher Build process issues and bugs fixed, applied patches to successfully build the vouchers.
  • Designed customized SQR process to apply header level charges as freight and misc. charges and processed them through Voucher Build.
  • Processing the P-card journal entry Process to load directly into PeopleSoft.
  • Customization of payment terms for billing invoices.
  • Designing and developing JDA Supply planning interfaces.
  • Warranty claims approval workflow process setup.
  • Created template and reports by using XML Publisher.
  • Implemented EFT and ACH Processing for AP Payments for various Vendor Banks.
  • Modifying crystal checks for logos and address modifications.
  • Working on B-to-B data exchange for BOA positive pay files.
  • Customizations of GL Accrual reports
  • Data cap fax conversion project- which is used for fax orders to load them into PeopleSoft through EDI.
  • Using Serena Business for tracking the change requests and BMS Service desk Express tool for production work orders.
  • Working with PS Queries and crystal Reports

Confidential, Ocean Port, NJ

Techno-Functional Consultant

Responsibilities:

  • Responsible for production support fore-Procurement, which includes Inventory and Purchasing and also AP and GL Modules.
  • Developing SQR Program to Process Positive pay Files in AP. This will has all the Bank Accounts Information in one file, instead of Crystal report, which shows each file for one account.
  • Developed Custom SQR program to Load Vouchers from different type of vendors with different file formats for different vendors
  • Developed Vendor Outstanding balances, payments made and Outstanding Balance Age Calculations Report based on specific formula.
  • Developed SQRs for Loading Data for 1099 Withholding and other Reports like Weekly Voucher Volume Reports, Monthly Voucher amount and Paid Amount Reports by Business Unit.
  • Fixing reports like AP Accruals and Automating with schedule jobs and also Created Month End Jobs Which Opens Periods for next Month for AP.
  • Modifying and customizing voucher inquiry pages according to user convenience.
  • Designed new Reports for Project Annual Budgets and Related PO’s, Vouchers, Journals Used for different date ranges and also prints summary and detail reports.
  • Created Invoice Amounts Total sum and Payments made based on vendors search
  • Working with GL Reports like GL Activity Reports, Monthly GL Dept Expenses, GL Interfaces like GL Upload Actuals/Budget, Journal Uploads,
  • Modifying, Debugging and Managing Requisitions using Material Stock Requests, Running Various jobs like Create Par Replenishment, Reserve Materials, Pick-Plan, Picking Confirmation and Depletion Processes
  • Testing Item Loading Using Component Interfaces, and Loading Master Items them Using Excel to CI and Updating the Item Price Lists, Item Loader and Price Updates
  • Modified the Transformation interface, used to convert the Flat File to .UPL File, which is used as input file to Load Count File process INV CART UPL App Engine Process.
  • Supporting the Processing of Batch jobs like, AUTO SOURCING, PO CALC, PO CREATE and PO DISPATCH, debugging the App Engines
  • Designed Program to Clean up Month-End Inventory data.
  • In e-Procurement setting up and Defining Approval Workflow, by using SQL Definition criteria, Role Actions, Role Users and User Lists
  • Using Quest STAT5.3 to Migrate Projects by creating CSR’s.
  • Developing Interfaces E-Profile, which is an online integration between HR7.5 and Financials 8.8
  • Working with PS Queries and Crystal Reports

Environment: PeopleSoft Financials/SCM 8.8 & 9.1, SQR, People Tools8.46, People Code, PS-Query, Visio, Workflow, Quest STAT 5.3, Crystal Reports 9.0, Oracle 9i, Toad9.2, Windows NT and UNIX

Confidential - Bethesda, MD

Technical Consultant

Responsibilities:

  • Developed Component Interfaces to Load Contrast Header and Line info into Tables using SOAPXML to CI
  • Fixing Errors by Configuring the Pricing for Projects
  • Created New Component Interfaces to load Billing Data into Interface tables.
  • Also Loading data using Excel to CI
  • Developed some customizations in PO module.

Confidential, Ewing, NJ

Technical Consultant

Responsibilities:

  • The interfaces between CBSR and PeopleSoft and are developed using SQR Programming are listed as: Product and Product prices; Vertex and Geo Code; VAT Calculations; Customers, Order Billing, Payments, Adjustments/Refunds Loading, AR History, Currency, Reporting/Reconciliation.
  • GET ID Program is developed using SOAP Message and Integration Broker to send and receive Customer ID, Invoice ID, Payment Group ID and Interface ID.
  • Developed detailed functional design documents and technical design documents for developing gap solutions in building the program logic for customizations, reports and interfaces.
  • Configured new Billing and AR configuration data like bill types, entry types, bill source, AR distribution codes, Revenue distributions codes, etc.
  • Created approved customizations for AR & Billing. This includes creating and modifying records and pages; modifying People Code at the record, page, and component level
  • Setup new products and Items in OM and Inventory. Created Price sets and Price break information to setup variable pricing for products based on Volume, Country Code, etc.
  • For PeopleSoft's NGT, created and executed a conversion of full production data into modified data appropriate for a large-scale user acceptance test.
  • As a technical consultant responsible for the design and customization of several GL, BILLING, AND AR reports/processes using SQR, Crystal and P/S Query.
  • Created numerous SQL queries and SQR reports to aid the users in Reconciliation.
  • Customized the Aging reports according to ETS specific customizations.
  • Load Customer Data from MP system into PeopleSoft using a SOAP Message (Integration Broker). Once the SOAP message was received the SOAPTOCI was invoked to call the custom Customer Component Interface. Created a Component Interface with the required customer tables for this purpose. Configured the nodes, transactions and gateway to accomplish this messaging.
  • Involved in Design, Document and Development of custom process for AR small balance Write-Offs, instead of using worksheet and write-off each item.
  • Document & Resolve Critical Production Support Issues
  • Provided production support to existing PeopleSoft financials system. Responsibilities included fixing issues and working on new enhancements.

Confidential, New York, NY

Technical-Functional Consultant

Responsibilities:

  • Implementing Contracts module
  • Fixing the bugs and issued raised during the Contracts data conversion
  • Fixing the bugs related to entering and amending the contract.
  • Written a custom program to insert the Contact details for the customers.
  • Creating contracts, Enter accounting distribution, assign Bill Plans
  • Amending Contracts for changes in Grant Amount.
  • Running and debugging issues related to CA/Billing interface CA BI INTFC
  • Run UN Load GL Interface (UNBILDGL).
  • Revaluation of payment schedules due to exchange rate change.

Environment: PeopleSoft Financials 8.4, SQR, People Tools8.44, People Code Oracle 9i

Confidential, Herndon, VA

Technical Consultant

Responsibilities:

  • AR and Billing Production Support.
  • Automatic Bank Reconciliation set up, which involves conversion of BAI2 Flat file to PSBD1 Flat File and Importing to Bank statement Tables and Setting the Reconciliation with Lockbox Payments.
  • Setting up the Audit Logs for Main AR Tables. Created AUDIT CONTROL Records and Triggers to turn on the Database Level Auditing for these Tables.
  • Working on PS Security to Clean the Roles and Permission Lists in Production.
  • Developed Customized Billing Archiving Programs with Application Engines to Archive the Billing Transactional Data, Year wise separately. The Programs also include the Restore Processes.
  • Working on Archive Restore Performance.
  • Modifications of Lockbox SQR - AR25001.sqr
  • Customization of AR Dunning and Age Receivable Reports.
  • Setting Up Bank Statement Reconciliation for Payments and Drafts.
  • Working on Worksheet Related Issues, Like Write Of credits, Offset amounts etc.
  • Auditing Billing and AR Tables.
  • Debugging AR UPDATE, Pending Items, Payments and Deposits
  • Setting up the Payment Predictor and Auto-Maintenance Algorithms and methods.
  • Modified several Crystal Reports and SQR’s

Environment: PeopleSoft Financials 8.8, SQR, People Tools8.44, PeopleCode, PSQueryCrystal Reports 9.0, Oracle 9i, Vertex, Windows NT and UNIX

Confidential, Ewing, NJ

Technical Consultant

Responsibilities:

  • Designing the Technical and Functional Documents for the Shipment Confirmation Interface.
  • Designing the File Layout and Data Mappings between Enterprise One and PeopleSoft Tables.
  • Developed various Inbound and Out Bound Interfaces, such as Item Masters, Conversions, vendor Conversion, Sending and Receiving PO’s and Requisitions, Sending Sales Orders, Item Balances Update and Shipment Confirmation Process using SQR.
  • Sales Order /Demand Feed Interface - Sends information for order created through OM, demand feeds from 3rd party systems to E1 system.
  • Shipment Confirmation Interface - Load Shipped lines information from E1 into PS SHIP INF INV and creates new demand lines in DEMAND INF INV and deletes old demand lines from DEMAND INF INV.
  • Developed and tested different Business cases such as Back Order Creations for Partial Shipments, Cancel Orders, Change Orders and Partial Schedules.
  • Back Order Notification Report - Prints a report identifying materials with quantities not available at the ETS Warehouse for shipment between the selected date ranges.
  • Customized OMBILL according to client’s requirements
  • Unit testing and Integration Testing is Done between Enterprise One and PeopleSoft.

Environment: PeopleSoft Financials and SCM8.8, SQR, PeopleTools8.44, PeopleCodePS Query, Crystal Reports9.0, Oracle 9i, Vertex, Windows NT, UNIX

Confidential, Bay Shore, NY

Techno-Functional Consultant

Responsibilities:

  • Performed Production support since Sep’2004 GO-LIVE to April’2005.
  • Implemented Complete SCM8.4 and Financils8.4 modules.
  • Supporting and implementing the Customizations for the SCM and Financials 8.8 Upgrade.
  • Working on all Business Processes involved in the Order-to-Cash Data Model, like Creating Sales Orders, Quotes, Buying Agreements, defining Items, customers, fulfilling, shipping, invoicing, Replenishments, RMA, Receiving, Put away, Picking, Billing and Creating AR Pending Items Etc.,
  • Conversion and Loading of Items, Products and AR Balances and Customers Info from the Existing MAPIX System.
  • Defining BOM’s and converting and Loading BOM’s and Routings, Operations and Timings from Old system to People soft Tables.
  • Created customized Programs to Sync BOM’s with Product Kit Components.
  • Complete Configuration OM, Inventory, Production Control, Cost Accounting, AR and Billing Modules.
  • Designing the Configuration and Training Documents
  • Customizing Order Management and Redesigning the Sales Order and Invoice Format.
  • Set Up Processes For Inventory Cycle Counting.
  • Redesigned the Replenishment Report as per the requested Customization to include Soft Reservations, PID and Purchase Orders.
  • Setting Up Production Control Like Routings, Tasks, Work Centers, Sub Contracting etc.
  • Cost Accounting Set Up and Cost Roll Up, Solving Issues related to Accounting Line Creation.
  • Customization of Many Reports and Processes in OM, Inventory and Billing and AP.
  • Configuration of both Online and Batch Credit Card Processing to work with Third Party Credit card Processing - Cyber source.
  • Designed Integration with Third Party UPS System for Shipping and Calculating the Freight Charges with the help of APP Engines and File Layouts.
  • Setting up and Stream lining different Process in the OM, Inventory and Billing Modules.
  • Worked and Solved Issues Related to PICK PLAN, PUTAWAY and Replenishments
  • Formatting the Packing Slips, order Acnoledgments, Invoices and Purchase Orders etc.
  • Setting Up AP Matching Rules, Printing Checks, and Running PO Loaders.
  • Solved AR Issues Like Group Control Pending Items, Deposit Control Deposits, and GL Trail Balance Issues.
  • Applied SP1 Fixes and Bundles for many functional related Bugs.
  • Working with All the Issues related to Implementing the SCM and Financials
  • Configuring the RMA’s and Back Order’s, RTV’s, Shipping/Issues etc.
  • Working with Application Engine Programs, File Layout, PeopleCode, SQR, SQL, and People Tools Security etc.

Environment: PeopleSoft Financials and SCM8.4, 8.8 SQR, PeopleTools8.44, PeopleCode, PS Query, Crystal Reports9.0, MS SQL Server2000, Vertex, Tuxedo and Windows NT

Confidential, Foxboro, MA

Technical Consultant

Responsibilities:

  • Customization of SQR Report’s Like GLS7002, GLS0012, GLS0027, APVOST Etc.
  • AP Detail Reports, AP Voucher Line Posting, Voucher Register, Payments, Invoices Generation, Invoice Performa and Formatting Etc.
  • Data Conversion from Earlier Version of 7.5 to 8.4.
  • Customer Contract Reports like Public Service Contracts, Prepaid Revenue Billing Management.
  • Working with Transfers, Balance Adjustments, Disbursements, Remittance Processing.
  • Checking for Budget and Commitments for Allotted Projects and Contracts.
  • To develop the Interfaces for the new and customized process. The Processes involved are Time and Expense Interfaces. Generating and working with Expense Reports as Charge back Process, Expense Adjustments Reports, Time Adjustments and Expenses Claimed.
  • Developed Payroll Export Interfaces for US and Canada Payroll and Integrated through Integration Broker
  • Working on Asset Management Reports like Cost and Depreciation, Asset Net Book Value, Asset Reclassification Report, Cost and Depreciation Activity, and Assets by Category.
  • Working with Application Engine Programs, PeopleCode and Meta SQL.
  • Extensively working with SQR, Report Generation and Trouble Shooting debugging the Reports.
  • Created on-line Pages, Menus and Components for the Processes to accept Run Control Records and Pages and working with Translate and Prompt Tables and setup SQR programs to run through Process Scheduler.
  • Developing and Debugging the App Engine Programs and PeopleCode, Working with Meta SQL Tree Manager, Component Interfaces, Application Messaging and File Layouts etc.
  • Interacted with client in the Design Document confirmation activities.
  • Used PS Query to create Queries and using the queries in Crystal Reports and Trees used PS/nVision to create and run multiple layouts and reports.
  • Unit testing and Integration Testing the Interfaces and Processes and created the Test Scripts.

Environment: PeopleSoft FINANCIALS 8.4, SQR, PeopleTools8.42, PeopleCode, PS Query, PS/n Vision and Crystal Reports8.5, Oracle 9i, PVCS, Control-M, UNIX and Windows NT

Confidential, Bridge Water, NJ

Techno-Functional Consultant

Responsibilities:

  • Responsible for preparing Technical design specifications, Preparing Data Mappings, developing and testing interfaces in GL, AP, AR and Billing modules.
  • Designing the Customized Interfaces, this will send the files to third party tools for reconciliation purposes.
  • Generating Invoices and Accounting Entries and Loading the Pending Items and updating the customer balances.
  • Processing Journals, Open Item Accounting, Financial Consolidations, Entry Events, and Journal Entry Approvals etc.
  • Working with Transfers, Balance Adjustments, Disbursements, Remittance Processing.
  • Developing and testing the process like Check Writing, Pending Item Loader, Suspense Balances, Deficiency Processing, Fund and Loan Balancing, Cash Feed Back.
  • Successfully designed and coded Several SQR’s for extracting and importing data from Legacy financials applications
  • Extensively used People Code to create objects in Application Designer for several customizations
  • Created on-line Pages, Menus and Components for the Processes to accept runtime parameters and setup SQR programs to run through Process Scheduler.
  • Created Customized Payment Panels along with People Code and done Different Validations for Prompt Table and Translate Values.
  • Worked with App Engine Programs and the Component Interface Programs.
  • Interacted with client in the Design Document confirmation activities.
  • Used PS Query to create and save queries and Trees, used PS/nVision to create and run multiple layouts and reports.
  • Unit testing and Integration Testing the Interfaces and Processes and crated the Test Scripts.

Environment: PeopleSoft FINANCIALS 7.53, SQR, PeopleTools, PeopleCode, PS Query PS/n Vision and Crystal Reports, Oracle 8.1.7, Windows NT and UNIX

Confidential, Richmond, VA

Technical Consultant

Responsibilities:

  • Responsible for upgrading doing requirement analysis, preparing design specifications, developing and testing reports and interfaces in HR, Payroll and Benefits modules
  • Responsible for the design, development and testing of all HR, Payroll and Time & Labor modules.
  • Responsibilities included data conversion, implementation of all business practices and business logic, providing technical assistance to the implementation process.
  • Involved in customization and implementation of PeopleSoft Payroll and Time & Labor module.
  • Coded SQR reports for Ad Hoc, Weekly and Annual Leave Accruals according to the company procedure.
  • Wrote People Code programs for online validations and for functional processing.
  • Created new SQRs by cloning the existing and modified them to generate the SQR’s.
  • Designed and developed customized overtime calculation report for the employees with shift and more than 40-hour workweek calculation.
  • Involved in design and development of conversion programs using SQR for transferring of data from legacy system to PeopleSoft HRMS.
  • Involved in Data conversion, Data migration and Integration solutions using SQR and Data Mover.
  • Develop/maintain mission-critical PeopleSoft HRMS applications and modules.
  • Assist Payroll, Benefits and HR users with troubleshooting and issue resolution involving W-2 printing, leave accrual adjustments and annual Benefits Open Enrollment.

Environment: PeopleSoft HRMS 8.3 - People Tools, People Code, SQR, App Engine, PS-Query, Crystal Reports, DB2, JCL, SQL and Unix Shell scripts, OS/390

Confidential, Dedham, MA

Programmer Analyst

Responsibilities:

  • Acquired business requirements, preparing technical design documents
  • Involved in writing Packages, Stored Procedures, Functions and Triggers using Oracle PL/SQL
  • Writing the Procedures and functions as required by the XML files, in which the data is to be maintained in presented in different hierarchy level.
  • Working with JSPs, XML files and HTML Forms
  • Used Both SAX and DOM Parsers.
  • Written incoming interfaces and outgoing interfaces using Oracle UTL FILE package. Also SQL scripts for reference data creation and SQL data validation scripts.
  • Tuned business processes and stored procedures for the best response time.
  • Converted reference data of SQL Server 7.0 to Oracle 8 database using Microsoft tool DTS. (Data Transformation Services.)
  • Working with Data warehouse tools like Cognos Impromptu5.1 and Powerplay6.0
  • Involved in Unit, Integrity and Regression testing and Production support.
  • Developed automated test scripts, which involves Data Driven tests, Batch tests and Exception Handling using TSL in Win Runner and executing the scripts in testing environment.
  • Developing the Simulator files in the UNIX environment by developing and executing the shell scripts.
  • Performed extensive Data Integrity testing by executing SQL statements

Environment: Java, JSP, Oracle 8.1.6, PL/ SQL, XML, HTML, UNIX, shell scripts, Sun Solaris, Cognos Impromptu and Power Play 6.0, Windows NT, Apache, Web Logic Server6.0 and SQL Server.

Confidential

Software Engineer

Responsibilities:

  • Involved in design and implementation of the client side and server side programming by using Java1.2, JFC-Swing, Java Beans, Networking Socket programming and Multithreading.
  • JDBC is used to access information from Oracle database.
  • Working with SQL and PL/SQL by involving in Writing Store Procedures and Functions, Creating Tables, Views, indexes and Joints.
  • Developing Servlets, Component Classes and Validation Classes.
  • Working With HTML, DHTML and JavaScript.
  • Developed various test cases and performed manual Testing for unit testing and Integration testing of different modules

Environment: Java1.2, TCP/IP, Networking, JFC-Swing, and JDBC, HTML, JavaScript, SQL, PL/SQL, Visual Café, and Oracle7.3 on UNIX.

We'd love your feedback!