Quantcast

Oracle Ebs Architect Team Lead Resume He...
Resumes | Register

Candidate Information
Name Available: Register for Free
Title Oracle EBS Architect/Team Lead
Target Location US-VA-Herndon
20,000+ Fresh Resumes Monthly
    View Phone Numbers
    Receive Resume E-mail Alerts
    Post Jobs Free
    Link your Free Jobs Page
    ... and much more

Register on Jobvertise Free

Search 2 million Resumes
Keywords:
City or Zip:
Related Resumes

Data Architect Oracle Dba Germantown, MD

Oracle Administrator Laurel, MD

Database Administrator Oracle Germantown, MD

Project Oracle Herndon, VA

Business Development Cloud Architect Washington, DC

Information Technology Cloud Architect Ashburn, VA

Oracle Database Administration Baltimore, MD

Click here or scroll down to respond to this candidate
SummaryI am an ERP solutions consultant with Oracle  and  Oracle  E-Business  Suiteexperience. I am capable of  objectively  assessing  options,  understandingbusiness processes and  analyzing  gaps  to  structure  leading-edge  Oraclesolutions. I have intellect, initiative and strong work ethics. I can  be  aschedule   driven   and   customer-focused   employee   with   emphasis   onuncompromising quality.I have been implementing Oracle E-Business Suite applications  for  over  20years. I have more than nine years of experience as a Technical Lead on  EBSand Fusion Applications projects of  up  to  $20+  million  in  revenue.  Myexperience includes managing teams ranging  in  size  from  4-25  developersmade up from US based consultants, offshore consultants and client staff.  Ihave completed full lifecycle implementations  of  Oracle  E-Business  Suiteand Fusion Applications. I am a  talented  individual  with  a  passion  fordelivering high quality and high performing solutions.Skill Highlights . Oracle Applications Rel.12.x,  11.x,  10.x,  9.x  (GL,  AP,  CE  AR,  FA,   HRMS/Payroll, Configurator, OAB, PO, TCA, PA, OTL,  OM,  INV,  BOM,  WIP,   WMS, Telesales, CRM, OIC) . iStore, iSupplier, iExpenses, EB Tax, AGIS, Vertex . Project Billing, Project Costing, Resource Management, Project Management . iProcurement, Sourcing, Contracts . SLA, Advanced Collections, Advanced Pricing, Shipping, Advanced Benefits,   MOAC . Sales Force, VM Ware, Open Air, Ceridian, Team Viewer, Cisco VPN . AIM, Change Management, Risk Management, Designer 2000,  Developer  2000,   Discoverer, WorkFlow; JDeveloper 2.0/10g,  Forms 10g, 6i, 5.0, 4.5,  4.0,   3.x, 2.x; Reports 10g, 6i, 2.5, 2.0,  1.x;  Graphics  2.5;  AOL;  PL/SQL;   SQL*Plus; SQR, XML Gateway, EDI/e-Commerce  Gateway,  BI  Publisher,  XML   Publisher, UPK, APEX, Web ADI, OBIEE,  SOA,  OAF/ADF,  RICE/CEMLI,  TOAD,   ARTISAN, SQL Lab, DB  General,  CITRIX,  VISIO,  Power  Point,  Microsoft   Projects, Chain Link, Frame Maker, SCCS, SVN, Ad Hawk, HTML,  JAVA,  JSP,   WSDL, Hibernate, Struts, SOAP, AXIS, JBOSS, XML, XSL, XPATH,  XSD,  Perl,   SQL*Loader; CASE 5.1, HPQC, ALMOracle RDBMS 11g, 10G, 9iAS, 8i, 8, 7, 6   Hardware & Operating Systems      SUN/HP UNIX, Linux, Windows- XP, 2000, NT, 98/95, 3.x, MS-DOSProfessional ExperienceM+W Group                                                 July2013 - CurrentInvolved in 12.1.3 Upgrade and Production Support/Development/FunctionalSupport for the following modules/Project ManagementProject Management, iProcurement, iExpenses, HRMS, OTL, ResourceManagement, Project Billing, Project Costing, Payables, Purchasing,Receivables, Sourcing, Contracts, Assets, General Ledger, Cash Managementand TCA    . Designed and Developed Documentation using UPK on different modules      mainly Oracle Projects    . Practice Collaborative way of working    . Lead four Oracle E-Business Suite ERP R12 implementations for core and      acquired legal entities within aggressive schedules and budgets using      traditional software development lifecycle    . Lead full Oracle ERP R12.1.3 upgrade of 16 modules for four companies      in only three months due to streamlined system implementation with      minimal customizations    .  Designed and implemented real-time Oracle APEX desktop and mobile      dashboards for executives, providing drilldown visibility into      operational and market segment performance results, overhead, cash      flow, and human capital utilization    .  Trained operational staff on functional and business processes      related to Projects, Assets, Payables and Procurement modules    . Lead Production support for 8 legal entities    .  Evaluation of BI Software (from different vendors including OBIEE)      for replacement oracle discoverer and provide executive committee with      different options    . Various OAF Customizations/personalizations and calls to other      applications like APEX and etc.SmartDog Services   Team Lead Solution Center / Sr. Applications Technical Architect            May2012 - July2013    . Helping Multiple clients Resolve the Service Tickets    . Technical Estimates for SOW, Development Tickets, Projects and      Services Requests and etc.    . Working on Multiple Projects for Multiple Clients    . Involved in Full Cycle Upgrades for Multiple Clients    . Interview for new hires    . Helping Customer with generating reports for IRS Audit.    . Extensive use of AIM Documents (MD050, MD070, TE040, BR100 and etc..)    . Functional People training on Web ADI with PDH    . Developer Support if they are stuck with Development    . BI Publisher Training and Mentoring Customers Developers and      Functional People    . Development with Forms, Reports, Discoverer, BI Publisher, XML      Publisher, Workflow, JDeveloper, OAF, JAVA, HTML, JSP, UNIX, SQL and      PL/SQL    . Designed and automated system  to create requisitions in PO for Drop      Ship without Invoice from the Quote in Order Management    . Designed and Developed various Alerts    . Worked with Invoice Inbound (ED 810) format programs to fix bugs.    . Design Develop iStore for multiple Stores and Improve messaging,      Setting profiles for customer defaulting to Ship Methods,      Localizations and Develop Tracking links    . Attended Training on APEX    . Developed APEX Interactive Reports and Forms Applications    . Training and Documentation using UPKMethodex:                                January 2003 - December 2011    Multiple Projects (Project Manager, Team Lead and Delivery Manager,Managing offshore team and office)    . Helping multiple clients Lead in full life Cycle Implementations,      Production Support, training, Conversion of Requirements in to      Technical specs    . Development Support    . Technical Estimates for SOW/Projects    . Interview for new hires    . Involved in Implementations and support of Oracle Manufacturing and      Financial Applications    . Development with Forms, Reports, Discoverer, BI Publisher, XML      Publisher, Workflow, JDeveloper, OAF, JAVA, HTML, JSP, UNIX, SQL and      PL/SQL    . Extensive use of AIM Documents (MD050, MD070, TE040, BR100 and etc..)    . SOX Compliance Practice    . Developed POI Interface for POs inbound (850-ASC X12) through EDI this      includes setting up trading partners, conversion codes and Flat      file/data formatting and using system translators    . Develop Fast Formula For PTO Accrual Plans, LTD and modify custom      reports    . Involved in Multiple Full Cycle Implementations    . Involved Multiple Upgrade Cycles    . Designed best-in-class ERP project status reporting that enables      executives and project teams real-time access to project budget,      forecast, cash, cost, commitment, and change management details    . Designed and developed various custom programs and systems design for      Order to Cash on multiple projects    . Designed/Developed/Setup for EDI (810) Payments in bound and Payables      Open Interface for whole cycle.    . Working extensively with offshore Developers    . Negotiated supplier contracts with software companies, implementation      consultants, DBA services, and contingent workers to reduce costs,      control risk, and incentivize performance    . Architected best practice Procure to Pay, Order to Cash, and month-end      closing business processes which resulted in shorter closes, tighter      controls, and greater reporting transparency    . Worked on multiple projects with Oracle Configurator    . Customizations to iStore Order Entry Pages    . Helping and building Reports for Audits    . Designed/Developed/Setup for EDI (850) PO outbound for whole Cycle.    . Developed JAVA APIs for file system operations    . Full cycle implementations of Procure to Pay and worked on Various      interfaces    . Extensive support for Advanced Pricing issues    . Developed Various Interfaces to and from OIC/HRMS    . Developed Ceridian/HRMS Interface    . Worked with fixing the bugs in workflow notifications for Order      incoming through EDI    . Worked on multiple projects for Payment formats including Reports,      Setups for different Payment types EFT/EDI, Positive Pay and  Check    . Design Develop iProcurement personalization      pages/Customizations/Catalog/Punch-out Customizations    . Worked on Various bug fixing for iStore    . Designed and Developed various programs for automation for FTP/SFTP      files for Remittance advice (EDI 820) UNIX Scripting    . Developed various HRMS Reports for various elementsKeyspan Energy:                                    June 2001 - January 2003 . PA: Lead the team and involved in converting and migration of  data  from   legacy in to Oracle Project Accounting. Involved in Business  Requirement   gathering. Involved in Functional  requirements  gathering.  Involved  in   full  GAP  analysis  using  oracle  documents.  Implemented  Burden  Cost   Accounting in Project Accounting. Customized  existing  reports  as  well   developed new reports in Project Accounting and Oracle  Projects  as  per   client requirement. Developed and tested legacy  date  using  UNIX  shell   scripts. . PO: Designed and developed  Purchase  Orders  conversions  program  using   PL/SQL, shell scripts. Purchase Orders  includes  Standard  POs,  Blanket   Purchase Agreements, and Contract Purchase Agreements.  Blanket  Releases   were converted as Standard  POs.  Developed  Vendors  conversion  program   using SQL*Loader and a custom Package to populate data into Vendors  base   tables in Oracle Purchasing.  Developed  different  packages  to  convert   Master Items, Organization Items, Stock Locators,  Hazard  Classes,  Item   Quantities, Unit of Measures, and  Item  Long  Descriptions  from  legacy   system  (AMPS)  to  Oracle  in  Inventory  module.   Developed   Invoices   conversion program using PL/SQL and SQL*Loader, which will  populate  the   data into Invoice History tables in  Oracle  Payables  module.  Developed   various custom reports like ERS Vendors Payment Details  Report,  Payment   Distributions Details report, Invoice  on  Hold  report  etc.,  developed   various custom reports  like  Cancel  Sales  Orders  with  open  Internal   Requisitions Report, Booked Sales Orders with Closed/Cancelled lines with   open Internal Requisitions Report etc., in  Order  Management.  Developed   various  custom  reports   like   Inventory   Stock   Report,   Inventory   Transactions posted to projects Report, Blankets Status Report,  Contract   POs Status Report, GL Code Combinations by Cost Centers Report,  GL  Code   Combinations by Cost Center, Activity and Job Number Report in  Inventory   and Oracle Purchasing modules. Involved  in  customizing  existing  forms   using Forms 6i and Forms 4.5 in Oracle Purchasing and Payables.  Prepared   Functional and Technical design Documents  for  implementation  and  used   Application Implementation Methodology. Provided End  user  Training  and   Production Support for INV, PO, AP modules and developed  various  custom   reports for different analysis.Involved in the Functional  Setup  Process  iProcurement  according  to  theclient requirements. Defining the approval hierarchy of  Requisition,  Setupfor the charge Account Segments for the organization, for the  defining  theProfile options for Billing and Delivery info and  defining  the  Setup  forInternal and External  Catalog Loading  and Scheduling  the  catalog  loader,Involved  in  the  customization  loading  process  ,Which  Eliminates  theinventory items from catalog loading process according  to  client  request.Did the  Technical  setups  for  Purchasing  News  page  (PORNEWS.html)  andPurchasing PoliciesPage (PORPOLICY.js). Involved in  complete  lifecycle  ofOracle's integrated e-commerce Procure_to_Pay  process  which  involves  allmajor components such as  Oracle  Purchasing,  Oracle  iProcurement,  OracleiSupplier Portal, Supplier Scheduling and  Oracle  Purchasing  Intelligence,Oracle AP/GL, Oracle E-Commerce Gateway, and Oracle Workflow.  Customizationof Iprocurement Home Page. Involved in the process of adding  custom  fieldswith dynamic LOV (List of Values)  for  the  Requisition  creation  process,Involved in the developing default values  and  validating  the  data  usingPO_CUSTOM_PKG. Developed a Concurrent program which  transfer  these  customfields from the Requisitions tables to PO Tables. Involved in  updating  andcustomization of Different XML Templates  like  PORBLNSR.xml,  PORBLNMR.xml,PORBLNED.xml, PORBLNED.xml. Involved in  defining  custom  LOV  Regions  forthis  Custom  fields  on  iProcurement   page.   Involved   extensively   incustomization of iProcurement web pages using  JAVA,  JDBC,  Servlets,  JSP,JavaScript and HTML. Involved in the Customization Catalog loading  process,i.e. customized the Existing packages  that  it  loads  all  the  categoriesexcept Inventory Items. Customization of  Supplier  Services  (Full  Access)Involved in developing  custom  web  pages  based  on  client  requirements.Involved in developing The Custom View Inventory Items  Search,  where  usercan  search  inventory  items   with   a   search   Criteria   as   item_id,item_description or Organization_code. Developed  complete  web  flow  whichIncludes pages, different page relationships, Region, region_items  of  thatregion and finally the object, object  attributes  of  that  flow  using  AKDeveloper. Involved in the developing  Custom  View  Invoices  Screen  whichgives details like Invoice number,  Date,  PO  Number,  Payment  Number  andSupplier Name. This Custom page has got page relationship with  other  pageslike  'PAYMENTS'  ...etc.  Involved  in  Developing  Custom  View   SupplierAgreements screen  which  gives  supplier  agreement  details  for  all  theblanket and contract agreements like PO Number, Revision,  Currency,  AmountAgreed, Amount Ordered To_Date, Effective From........etc.GL: Was involved in the Implementation of Oracle Manufacturing  Release  11iwith Integration of existing legacy systems with  Implementation  of  OracleApplications Rel. 11i (V 11.5.3) with Oracle 8.1.6 Server as  backend.  DataMigrations from existing legacy  Platinum  system  to  General  Ledger  (GL)module. Customization development and client extensions  of  new  Forms  andReports for the said modules.Coordinated in designing of  Conversion/Interface  project's  ImplementationStrategy for Order Management and General Ledger (GL) Modules.Also Implemented Mass Allocation formulae.Explained and showed the process to use ADI Tools to upload various data.Written lot of excel Macros (VB) to populate various Oracle Screens to  loadmassive date sequentially.Based on above Conversion program I developed Updated Rates  Reports,  Whichwill give the details of the inventory items which are to  be  updated  .TheSecond Report will generate the records which Will show the items which  arenot available on Master table but there in Source Flat fileInvolved a Datawarehouse using Discoverer for data Analysis  for  Accountingfrom Oracle ERP.Coordinating  with  Clients  IT  Team  and  user  groups  to  meet  get  theFunctional  Specifications  approved  for  each  task.   Developed   GenericPackages using PL/SQL to build flat files  to  manage  transmissions  acrossLegacy and Oracle Systems.Migration of the data from two Legacy  systems  into  Oracle  Projects  thisincludes the Work Order Conversions.Trained Users on Burden Schedules, Expenditure Transfers, Closing  Scheduleslike Burden Processing and Distribute Usage Costs.Involved in Various Month Closing Procedures.User Training on Setting up Templates in Projects.Developed Statutory Reports in Projects like Cost of Gas and  AdministrativeCost Details by Resource Type Including the Measuring of UOM at Task Level.Designed and Setup of Income Statements, Balance Sheets  by  PTD,  QTD,  YTDand Last 12 Months for Internal and Regulatory. In this Last  Twelve  MonthsFSG has to be developed in Reports.Designed and Developed General Ledger Reports which  gives  Balances  for  agiven Company and Period by Account and Activity by Cost  Type  like  Labor,materials, Purchasing Services. This Report  also  gives  Balances  by  CostType and Account for Balance Forward, MTD, YTD, QTD and Last  Twelve  Monthswhich is  used  to  compare  with  Trail  Balance  Report  which  is  OracleStandard.Developed a Report that treasury can use to check how much amount  is  goingto hit the accounts.Involved in document attachment loading for Items at Org level.Involved in Blanket and Standard PO Conversions.Involved in the System to Create Stock locators as part of Migration of  thedata from Legacy as  part  of  this  it  creates  Stock  Locators  under  anOrganization and restricts an item to  particular  Sub  inventory  and  thenrestricts to Particular Stock Locator.AJC:                                                    July 2000 - June 2001First of all this position involved extensive working all the  manufacturingapplications in additions to financials  applications.  This  also  involvedseveral meetings with Departmental interfaces, Users, Stakeholders  and  theExecutive Committee. Goal is to Study the ROI with Upgrading to New  versionwith additional modules and deliver the application with in required  budgetand time frame for a better  management  productivity  and  visibility  intoinformation across divisions.Gave the company users who are involved in the Project a  training  as  wellas demo of what applications can do and the main features of  Release  11.03which included GL, AP, AR, PO.Involved in Gathering the Business Requirements worldwide  and  finding  outthe Job Description of each employee and their  difficulties  in  performingtheir duties and how to improve performing their Job better.  This  involvedstudying of their output and what tools they are using and etc...Performed the GAP analysis and finalized the GAPS for this Trading  as  wellas Distribution business.Discussions with Departmental interfaces finalizing COA and  Multi  Org  andsome other third party bolting  like  Ever  Green  for  check  Printing  andautomatic signing and some documentation in  Operations.  These  discussionsinclude lot of enlightenment to Organization about  the  different  featuresand functionality of Oracle applications especially releases 11.03.Researched the Third parties like  Vastera,  i2  Technologies,  Manugistics,Blinco, Neomodal and etc. that can fit  these  GAPS  for  Documentation  andActivity based costing to track actuals.Involved in the educational class  for  Oracle  Cost  Management  module  toeducate the users about what average and Actual costing  can  do  in  OracleApplications.Involved in the Upgradation from 10.7 to 11.0.3.ROI Study and Analysis to  the  Departmental  Leads  and  to  the  ExecutiveCommittee all the Feature involved in Oracle Order Management like  AdvancedPricing and Shipping and etc. in Release 11iTrained High level  features  in  Cost  Management  and  Sales  Compensationmodule in 11.03.Explained High level features in Procurement in 11i.Explained the Supplier  Scheduling  which  Includes  (Auto  Scheduling,  CUMManagement)Educated the Project team about the features  and  enhancements  in  release11i from 11.03Finally recommended the executive committee with the Options they  have  forgoing forward. . Involved in the Business Requirements gathering,  FIT  GAP  Analysis  and   matching them to brainstorm what Chart of Accounts are required  for  the   company. Involved actively and worked with and interviewed more than  200   end users in Hongkong, Netherlands and other US Locations and interviewed   the upper Management for deciding 3C's. Invited lot other bolt on vendors   Manugistics, i2 and etc.. and had discussion with them how their Software   can fit in to business needs. Gave suggestion to AJC (GL, AP, AR, OM,  PO   and INV).CISCO:                                                 April 2000 - July 2000 . Involved in the Implementation of EMA and GAAP  Analysis  which  includes   Setting up books for different countries, setting up currencies,  Helping   Depreciation   running,   InterCompany   between   databases    and    GL   Consolidation. There are six countries involved. Joined in the middle  of   the implementation going  on  in  six  European  countries  and  actively   involved in FA, AP and GL Setups  mainly  multi-currency.  This  involves   working with end  users  in  Europe  and  getting  the  requirements  and   generate Functional specs. Minor bug fixes and excessive documentation.Southern:                                       December 1999 - April 2000 . Most work here represents Support  and  development  for  AP.GL  and  AR.   Designed, developed and implemented an application  replicating  existing   application (replication and interfaces between that databases and AP and   AR). Designed, developed and implemented a system that get the flat  file   data in EBCDIC format from the main  frame  and  load  it  Oracle  custom   application and interface in to AP/AR. Worked on some Data migration  and   some Interface coding and testing. Converted Custom SQL Forms  to  Oracle   Forms to fit NCA GUI Standards. This  also  Involved  BR  and  Functional   Requirements gathering,Trism:                                    January 1999 - December 1999 . Worked with stakeholders on the scope, budget and breakdown structures of   the project. Designed and developed a business  model  for  Trucking  and   transportation Industry. This  involved  developing  relational  database   from scratch and  defining  the  tables  according  business  model.  The   following are the modules involved in the design:  Expediting,  Shipping,   Invoicing, Call History, Payables, utilities, Hazardous  Waste,  Billing,   Projects, Carrier Contracts, Carrier Quotes. Migrated data from Dbase  to   Oracle. Designed and developed and implemented repositories  diagram  for   the database and created a  database  from  the  same.  Maintained  three   different databases. Worked with and gathered BR from the end  users  and   managers across various facilities in US. Developed a RDBMS model with ER   diagram to design, write and develop a custom database for the  logistics   for the trucking industry mainly for the TRISM. This includes  Developing   Forms, Reports and PL/SQL Programs.JYC:                                              July 1997 - January 1999 .  Worked  with  end  users  and  Stakeholders  for  Business  Requirements   gathering GAP analysis. Worked on Bug fixes with Developers. Worked  with   Developers to develop various UNIX shell scripts for  automation.  Worked   with Oracle fixing the bugs in Avalon Software.  Worked  with  Developers   for well documenting the forms, Reports and  Programs  developed  (Avalon   Financials and Avalon Manufacturing). Converted  from  Sybase  to  Oracle   financials  and  Implementing  Avalon.   Designed   and   developed   and   Implemented  Internal  and  Remote  Security   for   Avalon   financials.   Conversion of Sybase database to Oracle Financials (Avalon). Designed and   developed and Implemented  Cycle  Counting  for  Physical  Inventory  for   Physical and manual tickets. Designed and developed a program  for  check   printing. Designed and developed a program to convert customer no to D& B   (Dun & Bradstreet) number and  automated.  Physical  layout  and  Logical   Layout for this conversion and maintained three  databases  of  each  Six   Gigabytes each. Responsible  for  database  tuning  and  taking  backups.   Tuning of this database while loading and testing, Taking  cold  backups.   Designed and developed and Customized Screens for Avalon financials.OHM:                                          February 1997 - July 1997 .        Developed and  Customized  Reports  and  Forms.  Developed  PL/SQL   programs for the interfaces from the legacy data. Tuning of the Reports.Motorola: Worked at Motorola multiple times from 1995 to 2002 and was doingdifferent roles each time.Involved in the Implementation of Project Accounting  for  Oracle  Projects-Capital. This Project involved from the Initial Creation of a SAR -  CapitalProject to the point when the  Capital  Project  begins  depreciating.  Thisalso involved bringing the legacy data  from  Hyperion  System  into  OracleProjects.Implemented web-based expense  reimbursement  application  used  by  40,000+employees globally.  Utilized Oracle Applications modules  AP,  GL,  HR,  CMand Self-Service Web Applications. Reduced average reimbursement  time  from14 to 3 days.  Completed phased implementation according to plan  with  veryaggressive schedule.Designed and wrote software to load new  and  updated  airline  travel  datafrom external source.  Employees  select  personalized  air  travel  detailsusing list-of-values for  inclusion  in  expense  reports.   Information  islater reconciled against centralized credit card bill.   Software  consistedof Pro*C, PL/SQL,  Oracle  Forms,  self-service  web  forms  and  SQL*Loaderscripts.Wrote Java software to facilitate system load simulations.  Used results  toverify system could handle expected load and for system tuning.Created Pro*C programs to query data maintained in other systems,  and  thenautomatically synchronize on local system.   Over  10  tables  large  tableswere synchronized daily.Designed and wrote PL/SQL programs, Oracle forms, reports and  workflows  tocreate and later scan barcodes.  Over 1,000 barcodes are  scanned  each  dayto track and report on the progress of expense receipts.Customized  Oracle  provided  workflow  to  simplify   electronic   approvalprocess.  Software handled cross-department approval as well as cross-org  &cross-currency approvals.Designed and developed PL/SQL software, Oracle workflow,  Oracle  forms  andreports to force audit of some  expense  reports  while  allowing  low  riskreports to be paid without audit.  Audit parameters were configurable  basedon current workload.Created database triggers to enforce complex data validation  rules  and  tosynchronize data with other tables.Implemented PL/SQL software to validate information  during  data  entry  ofexpense reports.Wrote HTML & Javascript software to provide employee with filtered  list  ofreimbursement  currencies  based  on  those  supported  by  the  region  andcurrencies the employee has bank accounts in.Created Javascript & HTML software to establish  a  default  expense  reporttemplate depending on country employee works in.Implemented PL/SQL validation  software  to  verify  credit  card  and  banknumber checksums.Designed and wrote PL/SQL programs to  load  and  maintain  employee  creditcard credit card info.Wrote PL/SQL packages to hold common procedures and  functions  utilized  byother software.Customized several  Oracle  Application  source  modules  to  meet  businessrequirements.   Used  JavaScript,  HTML,   PL/SQL   and   Oracle   Workflow.Customizations included Oracle provided screens and reports as well as back-end software.Created configurable web home page  to  display  contents  specific  to  thecountry the user resides in.Designed  and  implemented  software  to  automatically  create  an   OracleApplications account  with  proper  region-based  responsibilities  when  anemployee requested an account  via  online  form.   Using  Oracle  Workflow,password was emailed to employee.  If  an  employee  moved  to  a  differentcountry,  software  would  automatically  enable  appropriate   Applicationsresponsibilities for new region. Programs were written in JavaScript,  HTML,PL/SQL and Oracle Forms.Wrote "C" program called as an Oracle external procedure to use native  UNIXemail facilities.Designed and implemented Pro*C program to send payment  notification  emailsto employees.  Over 1,000 emails sent each day.Designed and  implemented  PL/SQL  software  and  Oracle  Forms  to  monitordatabase locks and send email to specific users when the lock  was  blockingother activities.Worked with Oracle's  product  development  team  to  review  proposals  forupcoming enhancements as well  as  to  resolve  technically  complex  issuesencountered with software provided by Oracle.Wrote Pro*C and PL/SQL programs to build external payment files for  variouscountries.  Some files sent to EDI server and some ftp'ed directly to  bank. Payment methods included direct deposit, direct to credit  card  companies,paper check printing and outsourced check printing.Wrote Pro*C program  to  automatically  ftp  payment  and  other  files.   Aconfiguration table was created to specify destination details.  As new  ftprequirements were implemented the configuration table  was  updated  but  noprogram changes were required.  Created Oracle form to maintain table.Migrated several Oracle Forms 2.3 character forms to GUI version 4.5.Created Oracle forms and reports  to  display  fixed  asset  information  asrequested by customers.Wrote Pro*C and PL/SQL software as well as SQL*Loader  scripts  to  populateOracle Open Interface tables for Payables, Purchasing and General Ledger.Wrote Unix Make files used to compile Pro*C programs.Migrated and tested for financials SQL*reports to Oracle reports.Developed a system to send e-mail to E-Money recipients.Tuned some Procedures which resulted in the optimization  of  large  amountsof time in running and populating tables.Developed a system  to  FTP  the  completed  concurrent  request  output  todifferent hosts with an IP Address.Developed  and  implemented  a  system  for  updating  standard  item  costs(Usually done once a year for reformulation of item costs).Developed and tested a program for printing mailing labels for internal  andexternal vendors. (Using Pro*C not using reports)Developed and tested a program for automatic scheduling the  programs  usingconcurrent manager for month end close (which is not periodic).Developed and tested  a  program  that  creates  imports  and  approves  theinvoices for both the pay from receipts and internal payment methods.Developed and  tested  a  program  that  creates  invoices  for  items  thatinternal vendors have drop Shipped to a customer.Developed and tested a program  that  creates  new  invoices  to  reflect  achange in price on already Paid items.Phillip Morris:                                    January 1995 - August 1995Involved in Developing some Forms and Reports and wrote  some  SQL  queries.Worked with end user to train them how to navigate and functionality of  theforms. Documentation on forms developed.Chemiloids:                                            August 1990 - July 1994Involved in generating reports using  SQL*Plus  as  for  user  and  customerrequirement.Developed UNIX scripts for various purposesDeveloped PL/SQL Programs.Developed C ProgramsCorporations worked for . Sunnen Products . Hitachi Computer Products . Horizon Coach Lines . AmerCable . Toshiba International Corporation (Houston and Milwaukee) . Weaver Popcorn . Wind Energy Transmission of Texas - Austin, TX . Geo Global - FL . CompuCom - Dallas, TX . Southern Mississippi Electric Power Association (SMEPA) . Centric Group - St. Louis, Missouri . The Wood Group - Houston, TX . Stream Energy - Dallas, TX . Zappos - Las Vegas, NV . Stoller USA - Houston, TX . AZZ Incorporated - Ft Worth, TX . Eagle Rock Energy - Houston, TX . Broadway Across America - Houston , TX . Walsworth Publishing Co Inc - Kansas City, MO . Genesis Energy - Houston, TX . Smiths Medical - Dublin, OH . US Concrete - Houston, TX . Pellerin Milnor Corporation - Duet, LA . Glasfloss Industries - Dallas, TX . GoodMan Networks - Plano, TX . Womack Machine Supply - Farmers Branch, TX . Angelica Textile - Alpharetta, GA . Keyspan Energy - Brooklyn, NY . AJC International - Atlanta, GA and at Multiple office in Asia, Europe   and USA . Cisco Systems - RTP, NC . Southern Company - Atlanta, GA . Trism Logistics - Kennesaw, GA . Johnson Yokogawa - Newnan, GA . OHM Corporation - Alpharetta, GA . Motorola - Boynton Beach, FL (Worked Multiple times and projects)   Philip Morris- Miami, FL . Chemiloids - IndiaEducationMasters in Computer Science UAH (Incomplete) . B Tech in Engineering Andhra University, Visakhapatnam, India.Personal . Excellent Communication Skills . Green Card Holder (Since 1995)

Respond to this candidate
Your Email «
Your Message
Please type the code shown in the image:
Register for Free on Jobvertise