SUMMARY

• 18+ years of IT experience with 8+ years’ experience in Oracle E - Business Suite 11, 12.1.3 up to 12.2.7
• Extensive experience in Oracle Applications Framework (OAF) right from scratch development, OAF Extension, OAF Customization, Personalization which forms the base for all Self-Service Web Applications (SSWA) in Oracle Applications e-Business suite with Oracle Workflow, Interface Design Development, Oracle Forms Development, Oracle Reports Development, XML Publisher, SLQ and Data Loader and Data Conversions.
• Extensively worked in Oracle Projects, Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Oracle Purchasing (PO), Trading Community Architecture (TCA), Oracle Customer Online (OCO), i-Supplier, i-Procurement, i-Expense, Oracle Inventory (INV), Oracle Time and Labor, Supply Chain Management (SCM) in support and development projects.
• Done Customization from scratch and Extension using OAF and JDeveloper in R12. And provided solution architect to clients.
• Worked on OAF UIX Pages, ADF Business Components (BC4J), and Partial Page Rendering (PPR), SPEL, and Business logic coded in JAVA.
• Technically strong in SQL, PL/SQL, Procedures, Packages, Functions, Triggers, Form Personalization, Oracle Workflow, Reports 10g, XML Publisher, BI Reports, Sql*loader, Interfaces.
• Used Dell STAT Tool for code migration.
• Knowledge of Oracle Fusion Middleware and SOA.
• Experience in Procure to Pay life cycles.
• Prepared Technical Specification (MD70) documents based on the (MD50) documents provided by the functional team.
• Used SQL*Loader and UTL FILE for uploading flat file data into Staging Tables.
• Used FNDLOAD utility to migrate concurrent programs, request sets, value sets etc.
• Worked on Outbound and Inbound Interfaces using API'S and Staging table concepts.
• Responsible for migration of packages and procedures, shell scripts and SQL*Loader files.
• Used various Oracle API’s and Interfaces to convert data from an existing system to Oracle Apps.
• Expertise in Oracle Forms personalization, Customization, Interfaces, conversions & Performance Tuning.
• Expertise in Oracle RICE technologies.
• Very strong in full suite of Oracle Tools including Forms 10.1/9.0/6i, Reports 10.1/9.0/6i, OA Framework, PL/SQL, SQL Loader, FNDLOAD.
• Experience in System Administrator and Application Developer responsibilities.
• Excellent communication and presentation skills.
• Skilled in Designing Business Process and Notification mailers using Workflow Builder 2.6.
• Ability to identify root causes of problems and consider both long and short-term impact of proposed solutions and develop workable solutions along with excellent communication and interpersonal skills.

TECHNICAL SKILLS

ERP: Oracle Applications E-Business Suite (EBS) versions 12.2.6, 12.2.5, 12.2.4, 12.1.2, 12.1.3, 11.5.9, 11.5.10

RDBMS: Oracle 8i / 9i / 10g / 11g

Languages: SQL, PL/SQL, Unix shell scripts,Java, XML

Apps Modules: Oracle Purchasing (PO), Oracle iProcurement, HRMS, iSupplier, Accounts Payables (AP), Accounts Receivables, OM, iExpense, Procure-to-Pay (P2P) cycle, Workflow, General Ledger (GL), Knowledge on SLA, Approval Management Engine (AME), Billing / Costing, Fixed Assets (FA), Oracle Applications Framework (OAF), ADF Business Components, XML/BI Publisher, Inventory (INV), Application Object Libraries (AOL), PIM, Oracle Alerts, Oracle User / System Administration

Methods: Applications Implementation Methodology (AIM), Rapid Application Development Methodology, Software Development Life Cycle (SDLC), Sarbanes-Oxley compliance (SOX), Gap Analysis

Tools: TOAD, SQL*Plus, Workflow Builder 2.6.4, Forms 10g Builder, Reports 10g Builder, XML/BI Publisher, Jdeveloper 10.1.3.3.0 , Perforce PVCS (code version controller), Unix-Box, Unix shell scripting VI Editor, More4Apps, FileZilla, AR System’s Remedy Support Tool, Dell STAT Tool

PROFESSIONAL EXPERIENCE

Confidential, Glendale, AZ

Oracle EBS Techno-Functional Sr. Developer

Responsibilities:

• As an Oracle EBS Techno-Functional Lead Developer below responsibilities were carried out by me in addition to onsite site offshore coordinator.
• Offshore activities include daily status meeting, technical issue discussion and giving solutions on them.
• Ensure functional and technical documents are followed and reviewing them.
• Co-ordination with business user and onsite as well as offshore team.
• Co-ordination with DBA team for patching work and business users for testing.
• Working with third parties like banks and credit card issuers for interfacings work with Oracle EBS.
• Apart from management I was responsible for onsite work to convert Oracle Application Framework (OAF) pages from Oracle EBS 12.1.3 to 12.2.7 for this upgrade project. There are around 5 big custom modules (PAF, OBARS, BCB, BOIR, CARDS) where I am working on apart from standard modules (AP, AR, GL, HR, Projects, Localizations)
• While doing this upgrade we also needed to do the changes to Oracle objects schema names as per Oracle EBS 12.2.7 requirements.
• Apart from Finance also working on major project (Digital Supply Chain Project) DSCP.
• Worked on customized Oracle Application Framework (OAF) application Confidential Expediter to create many OAF pages and modified existing to resolve issues.
• Worked on customized Oracle Application Framework (OAF) application Material Allocation Planning (MAP) to create many OAF pages and modified existing to resolve issues.
• Worked on customized Oracle Application Framework (OAF) application Labor Adjustments
• Modified Purchase Order, Blanket Agreement and Contract Agreement report as per Confidential requirements which are very complex.
• Create many PL/SQL packages which are utilized by SOA.
• Modified Job Collector Oracle Form to add 6 new fields to capture workload. This is custom Oracle form.
• Trigger email to specific email address when a PO is updated and approved with an associated open invoice using Oracle Workflow
• Remove Personal Expense (do not reimburse me) expense types from OBARS Extract Interface
• PAF Assignment LOV for Address Field Job Specific
• Fix Oracle to Vertex Data as one of the Vertex Rules is Failing
• OIR-Update Contra Business Rule
• BGMC OBARS Extract not correctly pulling FAR coding for GOVCOM jobs
• Work on Project - LatAm - Format 3.5 Account Balance Detail Report, and many reports on Oracle Reports, XML Publisher and Excel reports.
• THB currency Check Fix the issue by removing the extra “Baht” word from the check report program
• Apart from this I am also doing production support related development.
• Worked on around 100+ production, enhancements, bug fixes ticket’s in various technology and modules like Oracle Application Framework (OAF), Oracle Forms, Oracle Reports, XML Publisher (PDF, Excel), PLSQL, Oracle Workflow

Environment: Oracle Applications (EBS) R12.1.3 to 12.2.7, Oracle Projects, Purchasing, Payables, General Ledger, Oracle Confidential Accounts Receivables (OBARS), Confidential Client Billing (BCB), Confidential Open Item Reconciliation (BOIR), CARDS TCA, PL/SQL, SQL*Plus, Oracle Applications Framework (OAF), Jdeveloper 10.1.3.3, Oracle Forms, Oracle Reports, Oracle Workflow, XML Publisher, TOAD, SQL*Developer, UNIX, Windows 7, Java

Confidential, Columbus, OH

Oracle EBS Techno-Functional Lead

Responsibilities:

• As an Oracle EBS Techno-Functional Lead below responsibilities were carried out by me in addition to onsite site offshore coordinator.
• Successfully designed, developed and implemented Bank Statement interface to Oracle Cash Management.
• OTL Timecard customization. Customized Timecard to add new field called Work Location in both Oracle form and self-service web page with LOV.
• Suppliers were created using supplier API’s as per Trading Community Architecture (TCA).
• Supplier cleanup.
• Responsible and actively involved in chart of account conversion using Eprentise tool to convert existing COA to Federal Energy Regulatory Commission (FERC) COA.
• I was responsible modify all the existing custom workflows and programs to map to new FERC COA.
• Developed Outbound Interfaces to Banks to send Financial Transactions from Oracle via EDI
• I built oracle PL/SQL program module and UNIX Shell scripts to work with Oracle EDI Gateway to transmit Inbound and Outbound Invoices using standard EDI 810 Inbound and Outbound mapping.
• Analyzed and Designed New Financial Statement Generator (FSG)report according to FERC COA.
• Done right from scratch AR Receipts development in Oracle Application Framework (OAF) using JDeveloper and PL/SQL.
• This development made the receipts process much easier than standard oracle receipts. Main benefit of this process is everything can be on one single form i.e. Standard and Miscellaneous receipts can be created and applied to any transaction and customer and assign any receipt method which gives ability to apply multiple customer’s and entities invoices in single receipt.
• Done new AR Invoice import interface in Oracle Application Framework (OAF) using JDeveloper and PL/SQL.
• This development copies the csv file to server imports records to AR interface tables and submits automatically Auto invoice program to create the Accounts Receivables invoices.
• Analyzed, designed and developed new ADP to GL interface in Oracle Application Framework (OAF) using JDeveloper and PL/SQL. This development uploads the ADP csv file to Confidential server and import records to GL interface tables.
• Analyzed, designed and developed new Oracle OTL to ADP interface in Oracle Application Framework (OAF) using JDeveloper and PL/SQL.
• This development downloads the OTL data in csv file and can be saved on local machine.
• Responsible for American Express AMEX interface design, development and implementation. Single handedly successfully implemented AMEX process.
• For this customized Confidential American Express Global Feed Transaction Loader and Validation Program which is JAVA concurrent program as per Confidential requirements.
• Customized Program Establishes connection to AMEX servers, Downloads the latest AMEX Transactions file to Confidential Server in encrypted form, then decrypts the file on Confidential server and Uploads all the credit card transaction in that file to Oracle, once transactions are uploaded program sends out email notification to AMEX card administrator.
• Also trained user and AMEX administrator how to use AMEX transactions in their Expense report in Oracle iExpense module and prepared DO 70 User Guide document for users and administrator.
• Actively involved in Oracle Projects redesign where I created new Projects and Tasks setup.
• Redesign and created new Projects Auto Accounting rules for Labor, Burden and Supplier to create code combinations.
• Designed and developed All Approvals workflow notification in which I have created one single email notification of all pending approvals like PO, Time card, Expense reports, GL Journal entry.
• Customized Confidential Forestry Approval workflow to reroute all forestry expense reports to different manager i.e. other HR manager.
• Customized GL Journal approval workflow to automatically route to GL Manager for his approval for journals above $400000 and automatically post it upon approval.
• Customized iExpense workflow so that once president’s expense report is submitted by the delegate, it will be routed to president to review and approve it. If submitted by president, then it’s directly approved and ready for payment.
• Customized iExpense workflow for 7 Day notification - Currently the system will pull back the approval after 7 days. We will re-send the approval notification back to the approver. The notification on the work list will let the approver know that this has been re-sent to them as a second notice for approval
• Customized PO Account Generator, Requisition Account Generator, and Expense Report Account Generator and Supplier Invoice Account Generator workflow to map Confidential segments with combination of Oracle Projects module and create code combination accordingly.
• Up gradation from Windows to Linux and from 12 to 12.1.3. My role was to check and verify customization for the functions / reports which are not working. Provide additional functionality with extension / customization to Oracle Projects, Financial Modules, HRMS and P2P Module.
• Designed and developed new AR Invoice report to print invoices.
• Designed new AP Check template.
• Developed search record, Lov, delete, update, create new record pages OAF Pages.
• Created extensions / customizations of ADF business components i.e. View Objects (VO) and Application Module (AM) in OAF page.
• Done extensions of Controllers to achieve business events.
• Created Partial Page Rendering (PPR) events.
• Written Business logic in JAVA in ADF Business Components (BC4J) i.e. Application Module (AM)
• Development done using Model View Controller (MVC) Architecture
• Developed custom OAF pages using Jdeveloper right from scratch. Used SPEL and PPR.
• Developed XML Publisher reports.
• Developed validation rules based on business requirements.
• Created custom tables and maps them with Oracle tables to capture additional customize data.
• Created MD50, MD60, MD70, MD120, DO70 Documents.

Environment: Oracle Applications (EBS) R12.1.3, Oracle Projects, iProcurement, iExpense, iSupplier, HRMS, Purchasing, Receivables, Payables, General Ledger, TCA, PL/SQL, SQL*Plus, Oracle Applications Framework (OAF) Ver. 12.1.3, Jdeveloper 10.1.3.3, Oracle Forms, Oracle Reports, Oracle Workflow, XML Publisher, TOAD, SQL*Developer, UNIX, Windows 7, Java

Confidential, Columbus, OH

Oracle EBS Techno-Functional Lead

Responsibilities:

• As an Oracle EBS Techno-Functional Lead below responsibilities were carried out by me in addition to onsite site offshore coordinator.
• Was working for TCS and managing team of 15 people offshore.
• Offshore activities include daily status meeting, technical issue discussion and giving solutions on them.
• Assigning new tickets to the team members and follow-up on the old ones.
• Ensure functional and technical documents are followed and reviewing them.
• Co-ordination with business user and onsite as well as offshore team.
• Co-ordination with DBA team for patching work and business users for testing.
• Working with third parties like banks and credit card issuers for interfacings work with Oracle EBS.
• Done extension in OAF. This is to add new field i.e.
• FormK was the new field added by DFF and extension was done in Oracle Application Framework (OAF).
• Created extension of controller to make FormK field required based on certain category.
• New PO Report. This was new development of report. New XML publisher report was developed using Oracle Reports 10g and XML Publisher.
• Mechanism for granting roles. This was Oracle Application Framework (OAF) development from scratch.
• This was to request roles and responsibilities thru OAF pages with approval and upon approval roles and responsibilities were assigned to the request user.
• HRMS Fidelity Deferred Compensation enrollment. This was right from scratch development in Oracle Application Framework (OAF).
• Done analysis design and development. This was to develop functionality to maintain the employees who are enrolled for Deferred Compensation.
• HRMS Fidelity Deferred Compensation interface. This was developed to generate outbound delta file. To generate there was 17 events and 13 records. One of the very complex projects.
• HRMS Virgin Health Miles Interface. This was an interface to generate outbound file in VHM file format.
• Development was done in PL/SQL. Lookups created to add flexibility for defining path and file name.
• Internal Zip in iProcurement. This is a DFF field which was added to checkout page.
• I did extension of controller to achieve change of this internal zip based on change of Requestor using PPR.
• Was part of AME implementation team.
• Customized AME. Created new Attributes, Conditions and Rules to customize AME as per requirement.
• Created MD50, MD60, MD70 and MD120 Documents.
• Done customization of pages in Oracle Application Framework (OAF) using JDeveloper in Oracle Application.
• Developed search record, Lov, delete, update, create new record pages OAF Pages.
• Created extensions / customizations of ADF business components i.e. View Objects (VO) and Application Module (AM) in OAF page.
• Done extensions of Controllers to achieve business events.
• Used JDeveloper for additional functionality and GUI enhancement in Oracle Application Framework (OAF) to implement adding business processes.
• Created Partial Page Rendering (PPR) events.
• Written Business logic in JAVA in ADF Business Components (BC4J) i.e. Application Module (AM) validation rules based on business requirements.
• Development done using Model View Controller (MVC) Architecture
• Developed custom OAF pages using Jdeveloper right from scratch. Used SPEL and PPR.
• Developed XML Publisher reports.
• Created custom tables and maps them with Oracle tables to capture additional customize data.

Environment: Oracle Applications R12.1.3, iProcurement, HRMS, TCA, PL/SQL, SQL*Plus, Oracle Applications Framework (OAF) Ver. 12.1.3, Jdeveloper 10.1.3.3, SQL*Developer, UNIX, Windows 7, Java

Confidential, Northfield IL

Sr. Oracle EBS Technical Lead

Responsibilities:

• Gathered business requirements for Oracle Customer Online customization OCO module.
• Up gradation and conversion of Customers to Trading Community Architecture TCA
• Customization done to avoid duplicate Person Credentials on OCO profile page for main Party Person.
• Created extension of controller for Stack layout for this requirement using personalization. Duplicate entries tracked using PPR.
• Customization done for Business purpose effective dating where Effective start and end date was customized fields added using personalization.
• Using Controller Extension PPR events were tracked of Remove and Add Purposes.
• Changes of Business purposes were tracked and showed in History which again was a customization. Created customized stack layout to show history.
• Making available relationship organization’s address while creating account sites for this LOV VO extension was done.
• List Organization sites on main party person this requirement was achieved by VO extension.
• Not to remove site of main party person or organization if site removed from account. This was achieved by Application Module AM extension and Controller extension.
• Done customization of OCO pages in Oracle Application Framework (OAF) using JDeveloper in Oracle Application.
• Developed search record, Lov, delete, update, create new record and submit record of OAF Pages.
• Created extensions / customizations of ADF business components i.e. View Objects (VO) and Application Module (AM) in OAF page.
• Created SOA composites for publishing and subscribing events.
• Done extensions of Controllers to achieve business events.
• Used JDeveloper for additional functionality and GUI enhancement in Oracle Application Framework (OAF) to implement adding business processes.
• Created Partial Page Rendering (PPR) events.
• Written Business logic in JAVA in ADF Business Components (BC4J) i.e. Application Module (AM)
• Integration testing with AR.
• Development done using Model View Controller (MVC) Architecture
• Developed custom OAF pages using Jdeveloper right from scratch. Used SPEL and PPR.
• Developed XML Publisher reports.
• Developed validation rules based on business requirements.
• Created custom tables and maps them with Oracle tables to capture additional customize data.
• Designed and developed HR applicant in OAF from scratch.
• Modified seeded HR reports like payroll, Offer letters etc.

Environment: Oracle Applications R12.1.3, Oracle Customer Online (OCO), TCA, PL/SQL, SQL*Plus, Oracle Applications Framework (OAF) Ver. 12.1.3, Jdeveloper 10.1.3.3, SQL*Developer, UNIX, Windows 7, Java

Confidential, Erie, PA

Sr. Oracle EBS Technical Developer

Responsibilities:

• Successfully completed the challenge to work under enormous pressures against a steep deadline
• Played multiple roles in the project including that of a business analyst, a technology and database consultant, a workflow and apps developer, a team lead, owner of the workflow change and release management
• Hands on participation in each and every phase of the project starting with requirement gathering, feasibility study, database designing, application designing, design reviews, actual development, application testing, documentation, end user training and finally ongoing application support
• Used the skill in identifying and analyzing business requirements and providing wide range support which included process mapping, gap analysis, setups, data conversion and validation, report customization, user acceptance, end user training and implementation in a multi org environment
• Developed right from scratch OAF Pages for Supplier Details, Supplier Bank Accounts Details, Supplier Financial Details, Business Activities, list of Mandatory documents attachments in OAF using JDeveloper 10.1.3.3
• Developed Supplier Registration Web pages in Oracle Application Framework (OAF) using JDeveloper
• Developed search record, Lov, delete, update, create new record and submit record OAF Pages.
• Created ADF business components i.e. Entity Object (EO), View Objects (VO) and Application Module (AM) in OAF page.
• Used JDeveloper for additional functionality and GUI enhancement in Oracle Application Framework (OAF) to implement adding business processes.
• Created Partial Page Rendering PPR events.
• Written Business logic in JAVA in ADF Business Components I.e. Application Module (AM)
• Developed 9 PLSQL packages having thousands of lines of SQL code to implement the custom Oracle workflows
• Worked on designing the custom application interface to send data to Oracle interface using standard APIs
• Modified the POXPOPDF - Print Purchase Order Report with custom PDF template to display Confidential info on the PO using XML Publisher responsibility. Also, modified the PO approval workflow which generated this report
• Wrote custom PLSQL procedure to validate and then interface the data from supplier on boarding application to Oracle Payables and Oracle Purchasing using the standard Oracle interface tables AP SUPPLIERS INT and AP SUPPLIER SITES INT and standard interface programs Supplier Open Interface and Supplier Sites Open Interface Import concurrent programs
• Overcame the challenge of sending workflow notifications to multiple roles by introducing the concept of role creation in workflow by using Oracle Standard APIs WF DIRECTORY.CreateAdhocRole, WF DIRECTORY.AddUsersToAdHocRole and WF DIRECTORY.RemoveUsersFromAdHocRole
• Designed and developed the custom functionality for creating Oracle workflow roles and adding people to it which is used across global Confidential Oracle Applications instance
• Created a concurrent program to create or disable an Oracle workflow role on adhoc basis by inputting parameters like role name and description
• Created a concurrent program to add or remove people from the Oracle workflow roles on adhoc basis by inputting parameters like user name and role name
• Created the backend PLSQL procedures to put the parameter validations in above concurrent programs
• Developed a BI Publisher report to show the supplier and site details along with the relationship between contacts and Confidential contacts
• Used WFLOAD UNIX command to load the workflows into the database and preserve customizations
• Customized PO approval workflow to send a custom supplier collaboration report as an attachment with the PO approval notification to be sent out to the suppliers
• Prepared SQL seed data script to fulfill the Confidential hierarchy requirements of multi-level approval rules based on business unit and commodity combinations
• Created database objects using SQL, PLSQL like tables, views, sequences, indexes, triggers, cursors etc.
• Performed the DML SQL query data cleansing on the existing Confidential supplier data by removing duplicate and old records and invalidating end-dated suppliers
• Designed and created approval notifications displaying the key supplier data fields to be shown to the internal Confidential approvers and separate notifications to be shown to external suppliers containing supplier on boarding application URL in it
• Resolved the issue of data security by adding the logic in design to send a unique URL to the external suppliers so that the email notification and the application link is accessible only to the intended supplier
• Performed the business unit mapping of the on boarding application with the operating units in Oracle
• Created and managed the AIM based documentations like MD 50 for functional specifications and the MD 70 for the technical mapping of the MD 50
• Used the migration and version management tools like Kintana and VSS to migrate the PLSQL code from development instance to staging instance and then finally to Production instance in a planned fashion and by sticking to associated timelines
• Part of the effort involving ITIL processes and integrated service delivery
• Owner of the workflow implementation involving configuration management, change management, incident management, release management and problem management at Confidential
• Performed Application Object Library (AOL) setups for FND Lookups, creating profiles, creating or excluding menus, creating responsibilities, value sets etc
• Developed the Oracle interface error handling process for sourcing users to show interface error details on screen, giving option to retry the failed lines from the interface or do a manual entry instead
• Developed a supplier master file BI publisher report and associated RTF template to show data corresponding to one supplier’s header, site, commodity, questionnaire and banks. Used DBMS XMLGEN PL/SQL package to extract data in XML format directly from PLSQL
• Performed the BI publisher setups using the XML Publisher Administrator responsibility
• Customized PO Create Document workflow to accommodate the business requirement to notify requisition preparer if the information entered is not enough to auto-create a PO from the requisition. Made changes in PO AUTOCREATE DOC procedure and created preparer notification in the workflow using Oracle Workflow Builder 2.6.3.5
• Did Oracle Application Framework (OAF) personalization to hide few fields from the custom form
• Developed the supplier collaboration supplier on-boarding application based on Agile scrum methodology with rapid changes in business requirements and processes

Environment: Oracle Applications R12, AR, AP, PO, OM, GL, INV, iSupplier, OAF, TCA, PL/SQL, SQL*Plus, Reports 10g, XML/BI Publisher, Workflow, SQL*Developer, VSS, UNIX, Windows NT, Java, JDeveloper, TOAD.

Confidential, Miami, Florida

Programmer Analysts

Responsibilities:

• Worked on Financials, Billing, Sales order, and Purchasing and Machine Routing operation system.
• Customization and Enhancement in Sales order system.
• Customization and Enhancement in Machine routing system.
• Developed Parts tracking system for small parts routing system.
• Auto email notification system when sales orders are created or modified.
• Tracking of leased parts and sending email notifications.
• Created various reports for Financials, Billing, Sales orders and Machine Routing system.
• Developed OAF Pages for HR Policy documents attachments in OAF using JDeveloper 10.1.3.3
• Developed OAF pages for Quick Applicant.
• Converted Invoices from Legacy System into Oracle Receivables using Auto Invoice Import program.
• Created and configured staging tables to receive and process files sent by EDI for Order-To-Cash implementation (Invoices, Sales Order).
• Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• Created a process for order import using standard API for validating data and update the base tables.
• Run Journal Import in General Ledger (GL) to load the data into Oracle application tables.
• Prepared the TDD (Technical Design Document) based on the FDD (Functional Design Document).
• Developed BI Publisher reports.
• Developed XML templates according to customer’s requirements and required format based on Oracle.
• Developed RICE components.
• Involved in creating parameters in data template file according to the requirement.
• Developed several custom workflows.
• Primary point of contact with the client for technical issues.
• Analyzing the change requests whether the scenario is feasible and helping the team in incorporating the Change Requests.
• Responsible for fixing of various Day-to-Day as well as Development/ Enhancement Issues.
• Responsible for developing and reviewing the issue resolution documents.

Environment: Oracle Database 10g, Oracle Applications 11.5.10, AR, AP, GL, OM, INV and PO, SQL, PL/SQL, SQL*Plus, SQL*Loader, Forms 10g, Reports 10g, XML/BI Publisher, XML Publisher, TOAD, UNIX, Windows XP.

Confidential, Shelton, Connecticut

Technical Lead

Responsibilities:

• As a Project Leader performed the system requirement gathering, Requirement Analysis, Technical Review, Designing, Programming, Presentation, Testing and documentations.
• Designed and developed dynamic XML based web pages for Web Sampling project.
• This unique project was designed to login into application for three different databases: Oracle, SQL Server 2005 and Access.
• Wrote extensive business logic using C# Coding, SQL Server 2005 Database and T-SQL.
• Extensively used ASP.NET for developing web pages for WSL Project.
• This project was to develop report engine tool for Chromatography machines.
• Gave IT support to gas and liquid chromatography machines to perform the testing of gas and liquids in forensic department labs and pass the data to computer.
• Developed various kinds of reports for the business users to give detailed analytical and graphical representation based on the above generated data.
• Created reports using Visual studio with Crystal Reports.

Environment: Windows Server 2003, Microsoft SQL Server 2005, Visual Studio 2005, .NET Framework 2.0, ASP.NET, C#, ADO.NET, XML, JavaScript, CSS, Oracle9i, Access, Crystal Reports.

Confidential

Technical Lead

Responsibilities:

• As a Project Leader performed the system requirement gathering, Requirement Analysis, Technical Review, Designing, Programming, Presentation, Testing and documentations.
• Designed and developed dynamic XML based web pages for Web Sampling project.
• This unique project was designed to login into application for three different databases: Oracle, SQL Server 2005 and Access.
• Wrote extensive business logic using C# Coding, SQL Server 2005 Database and T-SQL.
• Extensively used ASP.NET for developing web pages for WSL Project.
• This project was to develop report engine tool for Chromatography machines.
• Gave IT support to gas and liquid chromatography machines to perform the testing of gas and liquids in forensic department labs and pass the data to computer.
• Developed various kinds of reports for the business users to give detailed analytical and graphical representation based on the above generated data.
• Created reports using Visual studio with Crystal Reports.

Environment: Windows Server 2003, Microsoft SQL Server 2005, Visual Studio 2005, .NET Framework 2.0, ASP.NET, C#, ADO.NET, XML, JavaScript, CSS, Oracle9i, Access, Crystal Reports.

Confidential

Product Manager

Responsibilities:

• Involved in Coding using Magic 5.7, Magic 8.3, Magic 9.4,
• Involved in implementation and Support of Cheqmate TBC and Core Banking Solution
• Involved in Oracle 9i SQL and PL/SQL development wrote procedures for various reports.
• Deploying product on client side and giving technical support.
• I am also involved in giving Technical as well as functional training to members who work with me.
• Testing of the project.
• Implementation on the client side Giving Support after implementation
• Wrote programs for data migration using Magic 5.7 Magic 8.3.
• Developed conversion utilities for all third parties banking software.
• Involved in actual data Migration & Confidential ; Conversion activity for migrating all third party software data to CheqMate data,
• Cross verifying the data to ensure all the data has been converted.
• Wrote programs for reporting purpose to verify and validating of data and tallying the General Ledgers data.
• Testing of the Cheqmate on migrated data
• Implementation on the client side
• Giving Support after implementation.

Environment: Operating Systems Windows Novel Netware 4.20, HP UNIX, SCO UNIX 5.60, Windows, Front End Magic Version 8.3, Magic Version 5.7 Back End Btrieve, CISAM, Oracle 7.3, Oracle 9i, J2EE, JAVA