SUMMARY

• Oracle Applications Technical Consultant with 15+ years of IT experience in Software Design and Development using Oracle tools & technologies (Oracle Forms 10g/6i/4.5, Oracle Reports 10g/6i/2.5, Oracle BI, Workflow, XML publisher/BI Publisher).
• Extensive experience in Oracle Applications (11.5.9/11.5.10 and R12) E - business suite modules which include HCM/HRMS, Payroll, Project Accounting, General Ledger (GL),Account Receivables (AR), Purchasing (PO), Account Payables (AP), Order Management (OM), Inventory (INV) and other modules.
• Expertise in developing interfaces in Oracle Purchasing (PO), Inventory (INV), Order Management (OM), General Ledger (GL) and Account Receivable (AR).
• Diversified Project Profile in Oracle Applications Including Implementations, Upgrades / Migrations, Production Support and Custom Solutions.
• Self-starter, fast learner, highly organized and dedicated with positive attitude.
• Excellent analytical skills in gathering business requirements from end users and providing optimal solution. Experience design preparing documents, good exposure to Application Implementation Methodology (AIM).
• Experience in performance tuning of SQL and PL/SQL applications.
• Proficient in creating validation scripts to support and monitor teh deliverables in different phases.
• Competent in understanding teh functionality of core Oracle Modules (HR,GL,AR,PO,OM,PA,INV,AP) and their interplay in teh overall structure of an organization.
• Involved in four full cycle implementations with experience in requirements gathering, functional gap analysis, application design, configuration, conversions and test script generation.
• Expertise in performance tuning, preparing cutover plan and creating validation scripts.
• Experience in Technical Design, Development and Unit Testing of Oracle Financials Modules, Reports and Customization cycles.
• Excellent programming experience in creating Functions, Procedures, Packages, Triggers and other database objects using SQL and PL/SQL.
• Strong experience with Onsite/Offshore Model.
• Experience in maintaining documents and improve processes to comply with teh CMM level 5 standards.
• Ability to design, develop and deliver on time while in high pressure environments takes proactive initiation and contributes towards optimal solution.
• Well experienced in Reports, Interfaces, Conversion, Extensions and Workflows (RICEW), Implementation and Support of various Oracle Application modules.
• Business Intelligence Applications including-analysis, design, development, configuration, Customization, validation and deployment.
• More than 5 years of experience in Oracle Business Intelligence Dashboard, BI Publisher, answers and repository building.
• Extensive experience in OBIA and OBIEE Administration Tool, OBIEE Answers, OBIEE Dashboards, BI Publisher (xml publisher), Delivers (iBots), BI Office component with OBIEE.
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables including Physical, Logical data modeling in teh OBIEE Administration tool.
• Project Manager/Leader for few of teh Projects worked on, Have PMP (project Management Professional) credentials and have attended various other Oracle Courses/Certifications.

TECHNICAL SKILLS

Applications: Oracle Applications 11i, R12 (HCM/HRMS, Payroll, Project Accounting, General Ledger, Account Payables, Account Receivables, Oracle Purchasing, Order Management, Inventory, System Admin tasks, Oracle Alerts and Workflow Administrator), Oracle BI (OBIEE)/OBIA 10g & 11g

Oracle-E-Business Suite: Oracle Financials-Accounting & Billing (GL, AR, AP, FA),PA,HRMS/HCM, Payroll, OTL, OE/OM, PO, i-Procurement, i-Expenses, INV, BOM, WIP, AOL Modules

Operating Systems: Windows, UNIX/LINUX, Windows Server 2003-2013

Languages: SQL, PL/SQL, JAVA, CQL

Databases: Oracle 9i,10g,11g and Access, Oracle 11g/10g/9.x/8.x/7.x, MySQL, MS- SQL Server

Tool: Developer 2000(Forms 6i, Reports 6i), Workflow, XML Publisher/BI Publisher, DISCOVERER 4i/10g and APEX,T.O.A.D., SQL, PL/SQL, Oracle Forms, Reports 2.X, 5.0, 6.x, 9.x, 10g,SQL* Loader, Discoverer, Workflow Builder and XML/BI Publisher, Oracle APEX, Developer, BPEL/ ADF, J2EE, C, Pro*C, Informatica 9.x/8.x/7.x/, Cognos (Reporting, Query), RPD, Dashboards, Delivers, (iBots), MS SQL Server Reporting services (SSIS, SSRS), VMWare, SOA, Web services, SOAP, JDBC. Serena PVCS- version control, Waterfalls and Scrum ( Agile framework) methodologies

Application Servers: Weblogic Server, Tomcat, Java, J2EE, Jrun, Perl.

Portal Servers: Weblogic Portal 10g, Java Portal, SharePoint Server.

Other: AWS ( S3, IAM,EC2,VPC,RDS) Big Data, NoSQL Database, Apache Cassandra, CQL, DataStax - DevCenter, OpsCenter, Cassandra Data Modeling, Cassandra Cluster management, nodetool

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Techno-Functional Consultant

Responsibilities:

• Identify list of customizations which are impacted due to R12 upgrade
• Leverage standard R12 functionality by utilizing teh application and standard functionality
• First Level Support for Business and Management Users on Oracle E-Business suite issues.
• Responsible for Design, coding, unit testing, delivery and support of HR, Payroll, OTL, Oracle Projects, Financials (GL, AR, AP, and Fixed Assets) and other modules.
• Project and Resource Management of employees and contractors on 3 Business Applications - Oracle, SharePoint and Travel system (ComBTAS).
• SharePoint Admin, Coordination and Support roles, Travel System (ComBTAS) owner.
• Design and Developed OBIEE Reports, Created OBIEE Intelligent Dashboards, & Answers
• Involved in Design, development and implementation of complex OBIEE user interface objects (e.g. reports, analytics, ad-hoc queries, dashboards, etc.)
• Analyze production support tickets and provide appropriate solution
• Provide support during different development life cycles and in production
• Analyze root cause of teh issues and providing resolution for bugs
• Implement other ad-hoc change requests and collaborating with business Users to get their requirements fulfilled using various Oracle tools as per teh need
• Ensure timely and quality deliverables in adherence to agreed processes
• Participating in teh business process re-engineering
• Review business requirements and functional specifications for enhancements
• Responsible for leading both Confidential / Confidential support, developmentand enhancement teams in Israel
• Creation of technical design documents for enhancements
• Monitor development and assist offshore team in development of enhancements if required

Environment: Oracle E-Business suite R12,11i, Oracle Database 11g/10g/9i, SQL, PL/SQL, SharePoint server and Applications 2013-2007, UNIX, BI/XML Publisher, Oracle APEX, Oracle Discoverer, OAF (Oracle Application Framework), OBIA, Oracle Business Intelligence (OBIEE) 11g/ 10g, Hyperion.

Confidential, Dallas, TX

Technical Consultant

Responsibilities:

• Provided development, testing, troubleshooting and Production support of Oracle Application modules HR, Payroll, Self Service, Labor Distribution, GL,AP,AR,PO,FA and few other modules.
• Design, Development and support of RMTS (Random Moment Time Study) Project for teh Medicaid Billing department using teh Oracle APEX (Application Express) tool.
• Interaction with management and business users in complete end to end solution on RMTS (Random Moment Time Study) Project. Also provided backup support on few of critical DBA tasks.
• Designed and developed business process custom reports using Oracle Reports and APEX tools.
• Created and customized reports using XML Publisher in HR,AR, AP.
• Developed XML Reports using XML Publisher.
• Involved in creating RICEW Functional and Technical objects like BRD, MD, TST documentation.
• Provided Technical support activities resolving internal SRs. Responsible for SR creations & escalation process and resolving functional & technical issues by coordinating with oracle corp.
• Worked on code modifications and project enhancements based on client requests.
• Testing applications including unit testing and pre-integration testing.
• Developed custom Reports using Oracle reporting & Discoverer tool, PL/SQL Packages and APIs.
• Coordinated instance strategy and served as liaison between functional and technical teams.

Environment: Oracle applications R12/11i/(HR, Payroll, OM, PO, INV, AP, AR, GL and AOL), PL/SQL, Unix,Reports 10g, 6i, Forms 10g/6i, BI/XML Publisher, Workflow, TOAD, UNIX, Discoverer 10g, OA Framework.

Confidential, Woodland, CA

Technical Analyst / System/DB Admin

Responsibilities:

• Developed a conversion program to load teh master items into Oracle Inventory (INV) using teh plsql and interface tables.
• Oracle Database Administrator tasks include Instance creation, Maintenance, Performance Tuning, Reporting.
• Owner and complete responsibility of teh CalWIN- Eligibility and Employment Services case management system of Confidential .
• Co-owner & Teir1 Support for teh MEDS-Medi-Cal Eligibility Data System, tracks eligibility (which is displayed by an assigned aid code) and is used not only by teh county eligibility staff but also providers who check patient eligibility against teh system.
• Used Performance Tuning to minimize teh cost.
• Involved in design, development & implementation of Oracle Application modules AR, PO, AP, GL, HR and AOL modules.
• Involved in gathering teh functional requirements from Management and Business for preparing Technical documentation and objects for approval.
• Developed various custom reports and customized standard Oracle reports in Financials, HR using reports developer and BI/XML Publisher.
• Designed and developed an interface program to load project forecast budgets into Oracle Projects using web ADI and PL/SQL package.
• Worked on teh customizations on teh HR new Hire and Termination approval workflow.

Environment: Oracle applications 11.5.10.2 (HR, General Ledger, Purchase Orders, Project Accounting, Account Receivables, Alert Manager), PL/SQL, Reports 6i, XML Publisher, Workflow, TOAD, OA Framework, UNIX, Discoverer 10g, Mercury Quality Center (Test director) and Clear case

Confidential, Omaha, NE

Technical Consultant / Jr DBA

Responsibilities:

• Served as overall Technical resource for Oracle Applications (11.5.10) implementation.
• Involved in design, development & implementation of Oracle Application modules AP, AR, PO, GL, INV and HR.
• DBA Role includes Installation, Setup and Configuration of teh Oracle Applications R12 on Linux and Windows environment for Internal Employer Use.
• Interacting with teh Business Users, Management Team, Functional and Technical teams and Provide solution for teh Oracle Financials System.
• Developed various custom reports and customized standard Oracle reports as per teh business requirements in AP, AR, PO, GL, INV and HR.
• Written Various Interface Programs both Inbound and Outbound Interfaces like Bank Reconciliation, Bank Check Printing.
• Developed various MD50, MD70, CV60 using AIM methodology for various objects like for conversions, interfaces and reports etc.
• Extensively used FNDLOAD to download and upload ldt files between different environments.
• Developed a custom report using BI/XML Publisher. Created Reporting layout formats using XML Publisher.
• Coordinated with business and functional architects for mapping teh legacy data to teh Oracle tables.
• Designed and developed custom reports in different formats for different customers.
• Developed custom form to view and correct data from stage and interface tables.
• Modified CUSTOM.pll to implement Ship-To customer functionality in Cash Mass Apply form.
• Preparing Technical Design, Coding, Unit Testing, Integration Testing and delivery.
• Responsible for reviewing Technical design and code delivered by peers to ensure teh quality standards maintained at all stages.

Environment: Oracle Applications Rel12, Oracle Applications (11.5.10), Oracle Database 9i, SQL, PL/SQL, Reports 6i, Forms 6i, UNIX, TOAD, XML Publisher, BPEL.

Confidential, Sacramento, CA

Technical Consultant

Responsibilities:

• Design & development of Vendor Conversion.
• Imported Receivables Invoices using Auto Invoice program.
• Complete Hands on in design, development & implementation of Custom Forms, Reports & Package Code in AR, AP, PO, PA, HR, Payroll, OTL, and GL modules.
• Developed various custom forms and customized standard Oracle forms as per business requirements from TEMPLATE.fmb and used CUSTOM.pll
• Conducted detailed requirements analysis and identified potential areas for improvement for various custom Code including Reports, Forms, APIs, and other processes.
• Identify and tune long running custom programs to run in optimal time.
• Analyze and maintain baseline performance reports during different phases of SDLC.
• Responsible for preparation maintain code delivery documents.
• Developed shell scripts for migration of teh custom objects.
• Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions.
• Applying patches using AD utilities, Tuning poorly running Queries, Monitoring Database and Applications Performance.
• Oracle Printer Setup/Installations, Registering Responsibilities, Forms, Functions, Menu in Applications. User Creations, Custom Concurrent Manager Creation.

Environment: Oracle Applications 11i, Oracle Database 10g, 9i, SQL, PL/SQL, Developer Suite 10g (Reports, Forms), Forms 6i and Reports 6i, UNIX, and TOAD.

Confidential

Technical Consultant / Programmer Analyst.

Responsibilities:

• Design and development of various Custom Forms and Reports using Oracle tools as per teh client business requirements.
• Developed various Oracle Objects (Stored Procedures, Functions, Triggers, Packages, APIs and other Objects bases on Business / Management Need.
• Analyzed existing database and prepare requirements to generate reports.
• Interacted with teh business users to prepare report requirements.
• Supported end user training and production issues.