We provide IT Staff Augmentation Services!

Senior Techno Functional Consultant Resume

4.00/5 (Submit Your Rating)

Tampa, FL

SUMMARY

  • 17 + years of extensive experience in the full lifecycle development of large Oracle based Applications. Responsible for systems analysis, database design, database development, software testing and implementation as well as technical support.
  • Extensive experience in Oracle Applications (11i and R12). As a Techno - Functional consultant extensively involved in interfacing with users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, leading developers, scheduling, producing documentation, and providing production support
  • Extensive Experience in E-Business Suite 11i, R12 including Oracle Financials (GL, AP, AR, FA, CM), INV, BOM, PA, OM, Install Base, WMS, WIP, MRP, PO and HRMS (HR, Payroll, Advanced Benefits, OLM) modules
  • Extensively involved in Forms Customizations using Custom library, Report generation using Oracle Reports and Discoverer, Creating extensions/ Interfaces with Oracle E-Business suite 11i/R12
  • Very Strong in data loading using Interfaces, APIs and Data Pumps
  • Solid experience in creation of numerous custom applications, reports, programs and scripts to extend missing or required functionality, from Release 10.7SC, 11i and R12
  • Thorough understanding for Oracle’s open interface tables and related data conversions for Inventory/Items/ Onhand, OM, Routing, BOM, Installed Base,WIP, Costing, PO, G/L,AR, AP, PA,HRMS
  • Solid experience in creating Data Models including Logical & Physical design using ERWIN, Designer & ER-Studio.
  • Strong experience in creating Technical specifications, developing code, User acceptance testing, Implementation and GAP analysis
  • Very Strong in Gathering business requirements, GAP analysis and propose changes for customizations using Oracle Forms/ Reports/ Custom Library, Form personalization and Workflow changes
  • Very strong in creating functional specification document MD 50 and converting it into technical specification document MD 70 using AIM methodology
  • Proficient in applying business logic using SQL Scripts, PL/SQL packages, stored procedures, functions and triggers.
  • Highly proficient in GUI based software development using tools such as Developer/2000, Developer 6i, Developer 9i/10g Forms & Reports, Discoverer, OBIEE, BI Answers, SQL Navigator and TOAD.
  • Providing 24x7 on call Technical Support to Rogers Users on Technical and Functional Issues

TECHNICAL SKILLS

Operating System: HP-Unix, Solaris, Linux, Windows XP Pro, Windows 2000/NT, AIX & MS DOS

Databases: Oracle 7/8/8i/9i/10g, MS SQL Server 7/2000, MS Access

Languages: SQL, PL/SQL, Pro *C, C, Java, Shell scripting, HTML, JavaScript

Tools: Oracle Designer 6/6i/9i/10g, Erwin, ER-Studio, Optima, Visio, Oracle Forms and Reports (9i/10g/6i/ 6/5/4.5/3.0/2.5 ), SQL*plus, SQL *Loader, PRO *C, OWB, Oracle Discoverer, Concurrent Manager, Oracle InterMedia, Microsoft Project, Workflow Builder, Jdeveloper

DBA Tools: Oracle Enterprise Manager (OEM), RMAN, DBA Studio, SQL*Loader, Stats pack, TOAD, SQL Navigator, PL/SQL Developer

BI Tools: OBIEE, BI Answers, BI Lawyers, Dimensional Modeling, Data Warehouse Design

Enterprise Applications: Oracle E-Business Suite 11i/R12 Oracle Financials (GL, AP, AR, FA), Oracle Purchasing, (Supply Chain, Service, OM, INV, BOM, PA, HR, Payroll)

Web Servers: Oracle 9i/ 10g Application Server, Apache

Networking: SQL*Net, TCP/IP, Listeners, Database Links

Hardware: HP Servers, Compaq, Sun Ultra 60, Sun Sparc 20, Ethernet Hubs, Fast Ethernet Switches

PROFESSIONAL EXPERIENCE

Senior Techno Functional Consultant

Confidential

Responsibilities:

  • Currently working in Confidential enhancement project related to OM, WIP and MFG
  • Extensively involved with O2C cycle design and implementation
  • Extensively involved with Importing ISO using WIP Completion. Involved with WIP partial, overfill and under shipment using Oracle Interfaces/ APIs
  • Involved with Oracle EBS integration with Servitrax and Pargon. Integration involved from Procurement to Shipment.
  • Involved with writing different OM, PO, WIP Interfaces
  • Responsible for creation/ updation of all RICEW components for major modules like AP, OM, WIP, GL, AR, FA, PO, CM (Reports, Interfaces, Customizations and Extensions)
  • Designed and deployed many reports using Oracle BI publisher and Oracle report builder
  • Designed and developed many inbound/ outbound interfaces using XML publisher and SOA gateway repository
  • Reviewing and approving functional specifications (MD050) for data migrations, reporting & analyses, systems integrations, and customizations to standard packaged software and verifying that they provide the required clarity and explanation of the solutions to requirements
  • Working with the data migration team to ensure that AP, Payment Processing, HR, OM, INV, AR and Billing data was appropriately validated and migrated for Go Live
  • Post Go Live Support

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP Quality Centre, Oracle 10g, LINUXWindows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow Builder, Alerts, OBIEEXML Gateway, SOA Gateway Repository

Senior Techno Functional Consultant

Confidential

Responsibilities:

  • Involved with writing up Technical specifications (MD 70) for reports/alerts/workflow/ customizations/inbound outbound interfaces and creating detailed-level technical design documents
  • Extensively involved in writing functional specifications for reports/alerts/customizations (including working with users on requirements) and creating high-level technical design documents, Components designed and tested include e.g.: (i) Sales order conversion into OM (ii) Customer conversion into TCA; (iii) Invoice conversion into AR (iv) Item and routing conversion (v) PO and BOM Conversion
  • Extensively involved with analysis, design and development of inbound/outbound interfaces with other applications like CURAM and other legacy systems
  • Extensively involved with creating Logical and Physical design for RICEW components and Inbound/ Outbound Interfaces with Other applications like CURAM and legacy applications.
  • Designed real time inbound/ outbound interfaces using XML Gateway/ SOA gateway repository
  • Worked with stakeholders/ client for adding new operating units and integration with CURAM applications.
  • Extensively involved in integrating CURAM applications with Oracle R12 payments
  • Extensively in designing solutions for vendor invoices and sending it to IBM printing applications; Service Centre check printing using R12 payments
  • Designed and Developed technical requirement documents for inbound/ outbound interfaces using XML Gateways and Oracle EBS SOA Gateways
  • Liaising directly with stakeholders across a diverse range of business and technology functions
  • Reviewing and approving detailed Solution Design Documents, and verifying that they provide the required clarity and explanation of the solutions to requirements
  • Created MD50 and MD70 for Supplier and Payment Interfaces
  • Developed eText and RTF templates for Canada Checks (AP Checks) and for EFT programs using BI Publisher in R12
  • Responsible for creation/ updation of all RICEW components for major modules like AP, OM, WIP, GL, AR, FA, PO, CM (Reports, Interfaces, Customizations and Extensions)
  • Extensively involved with Supplier creation/ conversion from legacy applications into Oracle AP using APIs
  • Designed and deployed many reports using Oracle BI publisher and Oracle report builder
  • Designed and developed many inbound/ outbound interfaces using XML publisher and SOA gateway repository
  • Reviewing and approving functional specifications (MD050) for data migrations, reporting & analyses, systems integrations, and customizations to standard packaged software and verifying that they provide the required clarity and explanation of the solutions to requirements
  • Working with the data migration team to ensure that AP, Payment Processing, HR, OM, INV, AR and Billing data was appropriately validated and migrated for Go Live
  • Post Go Live Support

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP Quality Centre, Oracle 10g, LINUXWindows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow Builder, Alerts, OBIEEXML Gateway, SOA Gateway Repository

Senior Technical Consultant

Confidential, Tampa FL

Responsibilities:

  • Involved with Global rollout of Oracle Financials, SCM and MFG modules
  • Extensively involved with data conversion of major modules like OM, AR, PO, INV, BOM and Routing
  • Extensively involved with analysis, solution design and deployment of HRMS new interface
  • Extensively involved in writing MD 50, MD 70 for data conversion for major modules like INV, AR. Also wrote complex PL/SQL packages for data conversion of above modules.
  • Extensively involved in writing outbound/ inbound interfaces between Oracle and PeopleSoft/ MacPac
  • Extensively involved in writing functional specifications for reports/alerts/customizations (including working with users on requirements) and creating high-level technical design documents.
  • Involved in creating, modifying and repairing various custom reports using Report 6i/10g, Discoverer, XML Publisher and OBIEE
  • Designed new Forms and Reports using Oracle Forms 6i/10g, Report 6i/10g that interface with Oracle Applications 11i/R12
  • Responsible for creation of concurrent programs, value sets, parameters for the generated reports

Environment: Forms 6i/10g, Reports 6i//10g, Discoverer 9i/10g, HP Service Desk, Oracle 10g, UNIXWindows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow Builder, Alerts, OBIEE, PVCS

Senior Technical Consultant

Confidential, Chicago

Responsibilities:

  • Currently involved as a Senior Techno-Functional consultant for upgradation project from 11i to R12
  • Extensively involved with Oracle Corporation in analysis, design and development of inbound/ outbound interfaces using standard interfaces and APIs. Example of interfaces include Oracle Projects to Concur Outbound interface, Conversion of Item master, Conversion of customers, Vendors, Customer Invoices, Payable invoices
  • Extensively involved as a Techno-Functional Consultant solving day to day problems of users around the globe
  • Worked on modifying the burdened cost using Burden Cost Accounting Extension
  • Identified standard system functionality, analyzed GAP document and designed solutions for GL,AP, AR, FA, PA depending on Business requirement.
  • Involved in end user training and user acceptance testing, preparation on test scripts (TE 040) and integration testing.
  • Responsible for upgradation of all RICE components (Reports, Interfaces, Customizations and Extensions)
  • Extensively involved in writing functional specifications for reports/alerts/customizations (including working with users on requirements) and creating high-level technical design documents. Components designed and tested include e.g.: (i) Sales Order conversion into OM, BOM and Routing Conversion and Customer conversion into TCA; (ii) Invoice conversion into AR; (iii) Invoice and Supplier conversion into AP (iv) Item master conversion into Inventory (v) various reports
  • Extensively involved in writing MD 70 for data conversion for major modules like GL, AR, AP, OM, INV, PO, BOM, Routing. Also wrote complex PL/SQL packages for data conversion of above modules
  • Extensively involved in modifying/ updating 11i PL/SQL packages to be used in R12
  • Created/ Modified workflows and Alerts using Workflow Builder/ Alerts
  • Extensively used Custom.pll and Forms personalization for Forms customization for AR and AP modules
  • Involved in creating, modifying and repairing various custom reports using Report 6i/10g, Discoverer, XML Publisher and OBIEE
  • Designed real time inbound/ outbound interfaces using XML Gateway/ SOA gateway repository
  • Designed new Forms and Reports using Oracle Forms 6i/10g, Report 6i/10g that interface with Oracle Applications 11i/R12
  • Created various shell script to move the files to required TOPs and registered them as HOST concurrent program
  • Responsible for creation of concurrent programs, value sets, parameters for the generated reports
  • Involved in creating, enhancing and optimizing simple to complex reports using Oracle Discoverer reporting tool. Granted access privileges to specific users and granted security access to use related business areas using Oracle Discoverer
  • Labeled information in a business area to help end users identify the information they will want to access
  • Improved the association between folders by creating the necessary joins between folders in the business area

Environment: Forms 6i/10g, Reports 6i//10g, Discoverer 9i/10g, HP Service Desk, Oracle 10g, UNIXWindows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow Builder, Alerts, OBIEE, PVCS, XML Gateway

Senior Technical Consultant

Confidential, Houston Tx

Responsibilities:

  • Extensively involved with analysis, design and development of inbound/outbound interfaces with other applications like PeopleSoft, SAP, Siebel and legacy systems
  • Created standard utility package for HRMS using PL/SQL
  • Extensively involved in modifying/ updating 11i PL/SQL packages, reports, Discoverer reports, OBIEE reports to be used in R12
  • Designed and developed various Discoverer/ XML publisher reports for PA modules
  • Designed and developed inbound/ outbound interfaces for PA module
  • Extensively involved in writing functional specifications for reports/alerts/customizations (including working with users on requirements) and creating high-level technical design documents, (c) generating test scripts, (d) performing quality assurance tests (prior to user testing), and (e) producing training materials, etc.. Components designed and tested include e.g.: (i) Sales order conversion into OM (ii) Customer conversion into TCA; (ii) Invoice conversion into AR; (iii) Invoice and Supplier conversion into AP (iv) various reports
  • Wrote generic routine for promoting the objects from one environment to another (DEV to PROD)
  • Extensively involved as a techno-functional consultant, solving day to day problems of users around the GLOBLE (US, Canada, Asia)
  • Created/ Modified workflows and Alerts using Workflow Builder/ Alerts
  • Worked as performance analysts to improve the slow running jobs and improved the performance of various reports
  • Designed real time inbound/ outbound interfaces using XML Gateway/ SOA gateway repository
  • Wrote various complex reports using Oracle Reports, Discoverer and OBIEE
  • Extensively used Custom.pll and Forms personalization for Forms customization for AR and AP modules
  • Involved in creating, modifying and repairing various custom reports using Report 6i/10g, Discoverer, XML Publisher and OBIEE
  • Designed new Forms and Reports using Oracle Forms 6i/10g, Report 6i/10g that interface with Oracle Applications 11i/R12
  • Created various shell script to move the files to required TOPs and registered them as HOST concurrent program
  • Responsible for creation of concurrent programs, value sets, parameters for the generated reports
  • Involved in creating, enhancing and optimizing simple to complex reports using Oracle Discoverer reporting tool. Granted access privileges to specific users and granted security access to use related business areas using Oracle Discoverer
  • Labeled information in a business area to help end users identify the information they will want to access
  • Improved the association between folders by creating the necessary joins between folders in the business area

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP Service Desk, Oracle 10g, UNIXWindows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow Builder, Alerts, OBIEE, PVCSXML Gateway

Senior Techno Functional Consultant

Confidential

Responsibilities:

  • Extensively involved with Oracle Corporation in analysis, design and development of inbound/ outbound interfaces using standard interfaces and APIs. Example of interfaces include Oracle Projects to Concur Outbound interface, VIP Employee interface, Time and attendance system to Oracle projects etc
  • Extensively involved in writing MD 70 for data conversion for major modules like MRP, INV, AR, AP, PA, Routing and BOM. Also wrote complex PL/SQL packages for data conversion of above modules
  • Extensively involved in modifying/ updating 11i PL/SQL packages to be used in R12
  • Extensively involved as a techno-functional consultant, solving day to day problems of users around the GLOBLE (US, Canada, Asia)
  • Created/ Modified workflows and Alerts using Workflow Builder/ Alerts
  • Wrote generic routine in 11i for uploading customers/ suppliers from one operating unit to another
  • Wrote generic routine in R12 to facilitate users for attaching any file with any module
  • Extensively used Custom.pll and Forms personalization for Forms customization for AR and AP modules
  • Involved in creating, modifying and repairing various custom reports using Report 6i/10g, Discoverer, XML Publisher and OBIEE
  • Designed new Forms and Reports using Oracle Forms 6i/10g, Report 6i/10g that interface with Oracle Applications 11i/R12
  • Extensively involved in Creating XML messages using XML Gateway/ Business Events to synchronize OM, INV, GL, AP data from Oracle to Peoplesoft/ Siebel Applications and vice versa
  • Created various shell script to move the files to required TOPs and registered them as HOST concurrent program
  • Responsible for creation of concurrent programs, value sets, parameters for the generated reports
  • Involved in creating, enhancing and optimizing simple to complex reports using Oracle Discoverer reporting tool. Granted access privileges to specific users and granted security access to use related business areas using Oracle Discoverer
  • Labeled information in a business area to help end users identify the information they will want to access
  • Improved the association between folders by creating the necessary joins between folders in the business area

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP Service Desk, Oracle 10g, LINUXWindows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow Builder, Alerts, OBIEE, XM

Senior IS Analyst

Confidential, FL

Responsibilities:

  • Currently working on E-Business Suite R12 integration project with Siebel and PeopleSoft
  • Extensively involved as a techno-functional consultant, solving day to day problems of users around the GLOBLE (US, Canada, Europe, Australia, Asia)
  • Extensively involved in Creating XML messages using XML Gateway/ Business Events to synchronize OM, INV, GL, AP data from Oracle to Peoplesoft/ Siebel Applications and vice versa
  • Extensively involved in implementing product accounting using Oracle Client Extension (Standard Costing using Workflow); Order Line Workflow, PO Account Generator and PO Requisition Account Generator
  • Customize the GL Cogs Account generator using Workflow as per the client requirements
  • Perform Gap Analysis between Peoplesoft Customer data model and Oracle Customer Registry (TCA).
  • Load Peoplesoft Customers into Oracle customers registry(TCA). Create parties, Accounts and Customer profiles.
  • Loaded Peoplesoft Addresses into Oracle Locations and Sites.
  • Loaded Peoplesoft Contacts and Telephones into Oracle contacts and Contact points.
  • Loaded Peoplesoft Account associations into Oracle Account relationships.
  • Creating and Monitoring TARs to resolve customer high priority issues
  • Extensively involved in preparing MD50, MD 70 and MD 120 using AIM methodology
  • Wrote the PL/SQL Packages for initiating the business events, which then calls the XML Gateway maps/ Oracle Workflow to send messages (Outbound Interfaces) to Siebel/ PeopleSoft
  • Involved with creating real time Inbound Interface for orders coming through WEB and Siebel using Oracle Adapters
  • Responsible for Design, Development and Support of Oracle Financial and Supply Chain interfaces between Oracle Apps and various other order vectors
  • Sales Orders, Discounts
  • Item, Item Categories, Item Catalog, Item ON-Hand
  • Customer and Supplier Details
  • Created/ Modified workflows and Alerts using Workflow Builder/ Alerts
  • Extensively used Custom.pll and Forms personalization for Forms customization
  • Involved in creating, modifying and repairing various custom reports using Report 6i/10g, Noetix Views and XML Publisher
  • Designed new Forms and Reports using Oracle Forms 6i/10g, Report 6i/10g that interface with eCommerce
  • Created various shell script to move the files to required TOPs and registered them as concurrent program
  • Responsible for creating extensive documentation because of the SOX compliance
  • Responsible for creation of concurrent programs, value sets, parameters for the generated reports
  • Involved in creating, enhancing and optimizing simple to complex reports using Oracle Discoverer reporting tool. Granted access privileges to specific users and granted security access to use related business areas using Oracle Discoverer
  • Labeled information in a business area to help end users identify the information they will want to access
  • Improved the association between folders by creating the necessary joins between folders in the business area

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP Service Desk, Oracle 10g, LINUXWindows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Business Events, XML GatewayWorkflow Builder, Alerts, Biztalk, Oracle AQ/ DQ

Senior Systems Analyst

Confidential

Responsibilities:

  • Currently working on NRFS customized application integrated with OM, INV, WMS, PO, Oracle Financials and Oracle HRMS
  • Extensively involved as a techno-functional consultant, solving day to day problems of users
  • Extensively involved as team lead in notifying senior project leads/ management whenever scope of the project changes and extra man-months/ efforts required completing the tasks, documenting and executing changes as per the new requirement
  • Creating and Monitoring TARs to resolve customer high priority issues
  • Extensively involved in preparing FRD (Functional Requirement Document) and DDD (Detailed Design Documents) using AIM methodology
  • Working with the functional lead and stakeholders to evaluate and identify functional gaps between the application and business requirements and identify potential solutions.
  • Wrote the PL/SQL Package for loading the data from various other systems including LHO, DOAT, TOE, Rogers.com, PeopleSoft HRMS etc.
  • Responsible for Design, Development and Support of Oracle Financial and Supply Chain interfaces between Oracle Apps and various other order vectors
  • Sales Orders, Discounts
  • SKU, SKU Category and ON-Hand details
  • Customer and Supplier Details
  • Created/ Modified workflows and Alerts using Workflow Builder/ Alerts
  • Extensively used Custom.pll and Forms personalization for Forms customization
  • Involved in creating, modifying and repairing various custom reports using Report 6i/10g, Noetix Views and XML Publisher
  • Designed new Forms and Reports using Oracle Forms 6i/10g, Report 6i/10g that interface with NRIS
  • Responsible for creation of concurrent programs, value sets, parameters for the generated reports
  • Created various shell script to move the files to required TOPs and registered them as concurrent program
  • Responsible for creating extensive documentation because of the SOX compliance
  • Responsible for creation of concurrent programs, value sets, parameters for the generated reports
  • Involved in creating, enhancing and optimizing simple to complex reports using Oracle Discoverer reporting tool. Granted access privileges to specific users and granted security access to use related business areas using Oracle Discoverer
  • Labeled information in a business area to help end users identify the information they will want to access
  • Improved the association between folders by creating the necessary joins between folders in the business area

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP Service Desk, Oracle 10g, LINUX, Windows XP, SQL*Plus, PL/SQL, TOAD, Noetix Views, XML Publisher, Workflow Builder, Alerts, ALSB, WLI and XML

Senior Software Developer

Confidential, Mississauga ON

Responsibilities:

  • Worked on Omnivision customized application integrated with Supply Chain (Service, Install Base, OM, INV, BOM, AR, PO, GL, FA and AP)
  • As senior software developer/ team lead, created project plan using MS project, allocated tasks among different team members, track and document software changes, coordinated with PM for extra effort required to complete critical tasks and updated Giant Chart accordingly
  • Extensively involved in preparing MD 50 and MD 70 using Oracle AIM and preparing detailed design
  • Extensively involved as a techno-functional consultant, creating Flexfields, Custom reports, Modification of invoices, creating new forms and PL/SQL Packages. Worked closely with Stakeholders, Business users and functional lead to identify the requirements, preparing technical design specifications using Oracle AIM and preparing GAP analysis document in collaboration with functional lead.
  • Wrote the PL/SQL Package for loading the data from ALPHA computer into customized tables and later on loading the Orders, discounts into Staging tables and Interfaces, this PL/SQL package loads millions of records daily from ALPHA computers and later on loads into Interfaces and then Import the orders into transaction tables.
  • Involved in creating, modifying and repairing custom reports including invoices like Monthly Invoice, Messaging Invoice, RMA Invoice, Driver Invoice etc using Oracle Reports 6i
  • Responsible for creating extensive documentation because of the SOX compliance
  • Responsible for creation of concurrent programs, value sets, parameters for the generated reports
  • Extensively used Custom.pll for Forms customization
  • Designed new Forms and Reports using Oracle Forms 6i that interface with Supply chain, Oracle Financials, Oracle HR and Purchasing modules
  • Involved in providing 3rd tier support to users of Supply Chain, Financials, HR and other customized application including RTC, CCSA etc
  • Registered Forms, reports, parameters and concurrent programs in Oracle Application
  • Responsible for development, Support, Troubleshooting and deployment of Forms as well as reports using Forms /Reports 6i/9i/10g and 9iAS
  • Wrote various PL/SQL Packages, functions, procedures and stored procedures to implement the Business rules uncovered in the Database design
  • Involved in creating, enhancing and optimizing simple to complex reports using Oracle Discoverer reporting tool. Granted access privileges to specific users and granted security access to use related business areas using Oracle Discoverer
  • Labeled information in a business area to help end users identify the information they will want to access
  • Improved the association between folders by creating the necessary joins between folders in the business area
  • Set up items in a hierarchy to enable end users to drill up and down the hierarchy to view related information

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, Mercury Test Director, HP Service Desk, Visual Source Safe, Oracle 9i, HP-Unix, Windows 2000/XP, SQL*Plus, PL/SQL, PL/SQL Developer, TOAD

Technical Analyst

Confidential

Responsibilities:

  • Achieved a best performance award
  • Involved in implementation of various modules of Oracle HRMS and played an important role in system study, gap analysis, Organizational Setup in HR, Flexfields creation, defining positions, grades, grade steps, progression points, jobs, recruitment activities and competencies etc as per the requirements.
  • Involved in creating, modifying and repairing custom reports using Oracle Reports 6i
  • Responsible for creation of concurrent programs, value sets, parameters for the generated reports
  • Participated in creation of EUL in Oracle Discoverer involves creation of Business Areas and its respective folders
  • Extensively used Custom.pll for Forms customization
  • Designed new Forms and Reports using Oracle Forms 6i that interface with Oracle HRMS
  • Registered Forms, reports, parameters and concurrent programs in Oracle Application
  • Involved in Data conversion activities using APIs, Interfaces
  • Responsible for Bug fixing in interfaces and Report generation related to Oracle Financials and HRMS
  • Responsible for development, Support, Troubleshooting and deployment of Forms as well as reports using Developer 9i/10g and 9iAS
  • Created various forms and reports based on stored procedures
  • Developed Object Libraries and PL/SQL Libraries
  • Wrote various PL/SQL Packages, functions, procedures and stored procedures to implement the Business rules uncovered in the Database design
  • Responsible for development, Support, Troubleshooting and deployment of Forms as well as reports using Developer 9i/10g and 9iAS
  • Created various forms and reports based on stored procedures
  • Responsible for Forms/Reports upgradation to Forms/Reports 10g
  • Responsible for end user Support, Troubleshooting and Bug fixing of existing applications
  • Created parameterized report using reports 9i/10g, which are able to query data according to business area
  • Developed Object Libraries and PL/SQL Libraries
  • Developed and Implement different reusable modules that are consistent throughout the applications
  • Wrote various PL/SQL Packages, functions, procedures and stored procedures to implement the Business rules uncovered in the Database design.

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, JDeveloper, Discoverer 10g, Oracle 9i, HP-Unix, Windows 2000/XP, SQL*Plus, PL/SQL, PL/SQL Developer, TOAD

We'd love your feedback!