SUMMARY

• Around 7+ years of Industry experience as a Sr. Business Analyst with solid understanding with Manufacturing, Retail Supply chain management, banking experience, Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Extensive experience in implementation, upgrade and customization of Oracle e - Business Suite Applications.
• This includes system study, design, Analysis, post implementation maintenance and support of Oracle EBS. (R12.1.3).
• Worked as a senior Oracle R12 EBS Functional Consultant with expertise implementing, upgrading and supporting OAB (Advanced Benefits).
• Experience in all phases of implementation of Oracle Fusion HCM using offerings like Workforce Deployment (Global HR, Payroll), Workforce Development (Talent Management, Performance Management, Goal Management) and Compensation Management (Compensation and Benefits) in version R8, R11 and R12.
• Experience in implementing HCM/Benefits SaaS applications.
• Experience on entire technical processes involved in Oracle Application implementations - Conversions using API's, Inbound and Outbound Interfaces, Reports, Forms customizations and Payroll,PTO& OTL Fast Formulas.
• Expertise in Gathering and preparing requirements to develop COGNOS Reports by reviewing/extracting data via Oracle Noetix Model (various Tables/Views), Manufacturing Model (various Tables/Views) and Supply Chain Model (various Tables/Views).
• Excellent exposure to various Microsoft Suites: Word; Excel; PowerPoint; Access; Outlook
• Domain understanding of Workflow Management-Scheduling/Starting/Aborting/Recover, Session and Workflow logs along with hands-on work in customizing Oracle Workflow
• I have strong knowledge in finance MI reporting and good understanding of GL and finance reporting processes and metrics along with creating Discoverer reports using Noetix views
• Complete understanding of Oracle Apps Implementation in R12 and 11i and Upgrade Projects from 11i to R12. Performed several end-to-end implementations, upgrades as well as conducting
• Expertise in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), and System Requirement Specification (SRS).
• Exclusive experience with Fusion HCM - Workforce lifecycle, Talent management - End to end Goal management and Performance Management life cycle and Fusion Benefits.
• Used Total Compensation Statement to communicate rewards and benefits to employees.
• Thorough knowledge in UML Modeling, including Activity Diagram, Sequence Diagram, Use Cases, State Chart Diagram, Deployment Diagram, Class Diagram, and Component Diagram.
• I have strong knowledge of the following business processes Order-to-Cash, Procure-to-pay, Inventory, Finance and accounting, Projects, Service Contracts and Depot Repair.
• Procure to Pay support for Go to Live group and Oracle EBS End Users.
• Sound understanding of core Business Intelligence and data warehousing concepts and skilled in development and execution of custom built BI tools, data integration and database architectures.
• Good knowledge of the Oracle EBS R12 data model for the modules OE, AR, AP, PO, GL, OKS, MTL, FND, CS.
• Participated in overall functional design & governance design for the Oracle Knowledge system.
• Involved in Enhancement of custom objects to meet the business requirements and integrate them with Oracle Application.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Experience in using the different methods of Extraction, Transformation and Loading of data into the warehouse (ETL) from various databases like Oracle, DB2 and MS Access.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members
• Expert in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2005.
• Experience in writing automated scripts, designing Test procedures, Manual Test cases
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Knowledge in the ETL (Extract, Transform and Load) of data into a data warehouse/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

TECHNICAL SKILLS

Operating System: Windows 7/XP/2000, UNIX, Linux, Suse Linux, Red Hat Linux, Sun Solaris

RDBMS: Oracle 8i, 9iR2, 10gR1 & R2, 11gR1 & R2, 12c

Application Server: Oracle Application/Report Server 10g (9.0.4), 10.1.3, 10.1.2.0.2, 11g, 12c, Web sphere, Web logic

Tuning Tool: TKPROF, EXPLAIN PLAN, AWR, ADD M

Backup Tool: Cold, Hot backup, RMAN, Import/Export

Tools: SQL Plus, Oracle Enterprise Manager (OEM), SQL * Loader, TOAD, FILEZILLA, Putty, FTP, MS Office, MS Excel

Virtual Machine: VM Ware server 2.0 to 2.2, Oracle VM Virtual box 4.0

Languages: SQL, PL/SQL, Java, JSP & J2EE

GUI Tool's: OBIEE, Oracle Forms/Reports, BI Publisher & Discoverer

ERP: Oracle Applications 11i/r12 AP, GL, FA, CM, PO, iExpenses & iProcurement

Web Technologies: JSP, JDBC, Servlets, XML, HTML & Java Script

Application Servers: Oracle Application Server, Web logic

Utilities: FNDLOAD, SQL*Loader, TOAD, SQL Navigator, SQL Developer

Frameworks: OA Framework, Fusion & Struts (MVC Design Pattern)

PROFESSIONAL EXPERIENCE

Confidential, Dublin, California

Sr. Oracle EBS Business Analyst

Responsibilities:

• Worked with Benefits & Compensation team to streamline the process. Data Loading/Conversions using HCM Data loader (HDL) to load Job, Grade, Worker data, Work relationships data, Salary info.
• Developed customerbenefits integration (this information is maintained in customer relationships)from Oracle to Salesforce and also from Salesforce to Oracle. Requirement gathering, mapping, developing and unit testing.
• As a Oracle Cloud HCM and Benefits Consultant provided Oracle HCM and Benefits Cloud product and implementation expertise to engagements. configured the Oracle Cloud HCM and Benefits solution and develop “workarounds” as necessary
• Involved the functional implementation of Oracle Core HCM, Benefits, Compensation, Absence Management, Payroll, Performance Management and Goals, for an HCM implementation.
• Gathered and prepared requirements to develop a Purchasing Weekly Metrics via Oracle Noetix Model (Purchase Order Tables/Views) for Purchasing and Planning Managers.
• Involved in migrating to the latest version of Oracle EBS suite - R12.1.3 from 11.5.10.2
• Involved in configuration of Oracle EBS R12 Financial Modules on CRP2, SIT, UAT Instances & Production Instance.
• Provided Oracle Application Support in the following modules: HRMS, Self Service,PTO, Performance management, Compensation workbench, Oracle Time and labor, Payroll.
• Developed many new reports like Customer Order Status Report, Backlog Detail Report, Backlog Summary Report, Backlog by Item Report, Cycle Status Report, Open Work Order Report, Sales Rep Commission Report, Customer Profiles Report using xml reports.
• Responsible for delivery of integrations with EBS, Fusion HCM, Service Cloud Right Now, OTM and EDI transactions with trading partners
• Developed HCM Extracts for Global HR, Benefits and Payroll Interface, Managed Enterprise HCM information and Legal Entity HCM information
• Interacted with client to gather the requirements to design and estimate the project duration.
• Collaborate with business users in the design, development, and deployment of new or improved business processes using Oracle E-business suite.
• Lead and perform analysis and reconciliation of payroll related data and responsible for the monitoring, preparing and distribution of required reports, also lead configuration workshops for the Oracle HCM and Benefits Cloud solution.
• Created new custom Self-service pages using Oracle Application Framework (OAF) in Oracle Applications R12, PL/SQL.
• Defined testing methodologies, designed test plans and test cases, verified and validated the system and documentation based on standards for software development and effective QA implementationin all phases of Software Development Life Cycle (SDLC).
• Replace existing suite of reporting tools with Oracle Business Intelligence (OBI) solutions
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat files to SQL Server using SSIS
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Wrote conversion document (CV60) to convert data from legacy system into Oracle EBS 11i system.
• Involved in preparation of Test Cases, Test Scripts for the Core HR, Benefits, Talent and Global Compensation.
• Used documented previous developer's designs for intuitive understanding and reference for analysis and reporting with OBIEE 11g.
• Worked on Implementing and Testing Oracle Fusion applications Procurement, SCM and Supply Chain Financial Orchestration modules on Premise and on Cloud.
• Develop Missing Mailer Expense Report based on combination of Cost center, Cost center description, UPN, Employee name, Email address, Expense Report Number, Submit Date, and Expense Amount using Oracle XML Publisher/OBIEE.
• Extensively worked in Oracle SQL, PL/SQL, SQL Plus, SQL Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Configured Fusion Financials (General Ledger, Payables, Tax, Receivables, Assets, Payments and AGIS) using in-house Fusion Applications Install.

Confidential - Issaquah, Washington

Oracle functional Analyst

Responsibilities:

• Involved in Comcast’s Oracle EBS Implementations and its Initiatives and cutomizations for General Ledger, Payables, I-Procurement, Accounts Payable, Receivables, Fixed Assets, PTP, Inventory, IExpense, Procure-to-Pay, Order-to-Cash Project Costing and Billing, Cash Management.
• Lead Oracle Apps DBA supporting Phase II implementation of HRMS suite, which included Payroll and Advanced Benefits.
• Responsible for application support of AR, Shipping, WMS, INV, OM and Costing for Oracle 12.1.3 and 11.5.10.2
• Create claim switchboards to monitor key indicators and provide monthly metrics for upper management using Access and Excel.
• Created interfaces to default benefits plans for employees. Worked on Oracle toSun life Employee Benefitsinterface.
• Worked on generating Mappings fromOracleto ADP Global View Payrollusing Interfaces.
• Managed diverse benefits plan and programs ranging from the simple to the complex.
• Provided ongoing customer and functional support for all HR/Payroll/Benefits/Compensation applications.
• Worked on both BOM and ATO/PTOModels Flow in Order Management (OM).
• Worked on Data Loading/Conversions using HCM Data loader (HDL) and spreadsheet loaders, developed HCM Extracts/BI Reports for Global HR, Payroll Interface.
• Prepared reusable test scripts for Fusion - Benefits, Goal, and Performance and Core HR modules.
• Assisted the integration consulting team in helping to build, configure and test integrations between HCM / Benefits and other systems.
• Incorporated an effective supply chain management to include inventory procurement, and sales forecasting, especially on items involving short life cycle and high demand volatility by integrating Oracle EBS Procure-to-Pay module.
• Works closely with external vendors and internal users in support of system applications including coordinating and providing end-user training on all HRIS/Payroll applications.
• Successfully implemented Core HR, Advanced Benefits (OAB), Talent Management, Oracle Time & Labor and Oracle Payroll modules for the client
• Designed non EBS extensions using Oracle ADF and EBS extensions using OA Framework.
• Directed and led the Region in implementing Oracle Financials, executing all aspects of implementation for iProcurement, Purchasing, Payables, Assets and Fixed Assets (documenting business requirements, data conversion, testing and post-implementation support).
• Performed meeting within Business stack holders, Developers, DBAs, Quality Assurances and End users of Business high level requirements and its updates.
• Registering Reports, PL/SQL Procedures, and Packages and creating executables, Developed integration flow of Oracle CRM.
• Worked on data Conversion for Oracle Apps 11i and R12 using standard API's or open interface programs to Interface Data into Oracle Applications.
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• Developed Oracle reports, Shell Scripts and SQL-PLSQL scripts.
• Developed XML templates according to customer's requirements and required format based on Oracle. Unit testing and supporting business testing
• Recommended best solutions and methods per requirements and functionalities of Oracle EBS.
• Diagrams and Activity diagrams using MS Visio according to UML methodology
• Leveraged the use of Oracle BI Presentation ad hoc and MS Excel to create organizational graphs and chart views that enabled a better understanding of data reports and analysis.
• Migrated SQL Server databases onto Oracle 12g databases using SQL Loader both on production and test environments.
• Performed Oracle EBS Functionality Testing of business requirements for Quality Assurances.
• Used QTP and Quality Center to manage QA testing and regression testings and defects and its reports. Ran automated tests.
• Assisted to Business users for new implementations and Initiatives for testing and Designed, Created Use cases, Test Cases, Test Scripts, Test Plans and uploaded to the Quality Center and ran manual testing for Implementation on each release.
• Generated Standard Receipts, Express Receipts through receiving against purchase orders, processed returns to suppliers.

Confidential - NY

Oracle Financial Analyst

Responsibilities:

• Customized standard Oracle Applications (EBS) reports and developed custom reports on financials (AR, AP, GL, FA) modules.
• Defined and managed compensation and benefits packages in Oracle HCM.
• Developed New Reports and Customizations in XML Based reports using BI/XML Publisher.
• Worked in Form Personalization's in Financial and manufacturing Modules.
• Leveraged the Oracle BI Presentation Services to build and customize Analysis and Reports for better understanding of the end users.
• Resolved summary GL/Payroll flat files errors in production instance and advising users of actions to take to fix errors.
• Involved in the Design, Development, Customization and Implementation of business applications using EBS Oracle Applications using Oracle SQL/PLSQL, SQL Loader, Oracle Developer Suite (Forms and Reports), Oracle XML BI Publisher and Oracle Workflow.
• DevelopedHR benefit extract programthat send all benefits information of enrolled employees and their dependents to Confidential.
• Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL
• Integrate Custom warehouse table with the OBI Apps tables for extending the business analysis capabilities.
• Involved in migration of GL and AP custom interfaces and reports, during oracle financials upgrade project.
• Responsible for writing of SQL queries as procedures/functions at the back end which are called from front end form
• Designed customized reports with different analytical views i.e. Excel, Flat Tables, Pivot Tables, Graphs, Gauges, etc. with the use of filters to concentrate data.
• Developed an interface to upload the journal data into the Oracle Application's General Ledger, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validation.
• Developed several PL/SQL packages, procedures, functions, triggers from GUI events or database triggers, to implement complex business logic.
• Strong knowledge of Application Object Library (AOL) implementation standards and Procure to Pay Life Cycle (P2P).

Confidential - Burbank, CA

Business Analyst

Responsibilities:

• Involved extensively during interactions withCustomers/End usersfor performing RequirementsAnalysisand frontend development teams forFunctional/Technical Specifications, UnderstandArchitecture, DevelopmentandTestingphases of project.
• Involved in daily standup meetings with Clients and Business to evaluate the project status and discuss specific updates during the current Iteration.
• Configured Bills of Materials (PTOModel) to come up with creative packages.
• Developed Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Extensively involved in providing Evaluations of Requirements andEstimating time and effortrequired for HR and ResolvedService Requestsraised by users.
• Created outbound interface to send employee data such as Employee personal information, dependents information, Employment data, and Benefits information to client.
• Worked as a Team Lead to delegate tasks and deliverables to the developers and coordinated oncritical issuesreported by End Users.
• DevelopedPL/SQL-Packages, Procedures, Functions, and SQL Scripts to populate the historic data in the tables by applying business logic.
• Worked with objects secured with Multi-Org Access Control (MOAC).
• Worked on multipleAuto lockboxesfor multiple banks like Wachovia, SunTrust, and BOA.
• Worked with reports likeAccount Analysis, Account Payables Trial Balance (APTB),and AgingReports etc.
• Created multiple interface forARandAPmodules like customer interface, supplier interface, Item Master etc.
• Involved in brainstorming sessions to understand complexity, buildDesign Documentsand suggest possibility of reusing stored procedures, functions and packages by updating the code accordingly.
• Maintained and developed numerous reports usingOracle D2K,Oracle Discoverer,and XML Publisherfor various business requirements.
• Involved in Documentation and Data Extraction to enable Oracle to Workday migration.
• Created Database Objects and wrote complex SQL, PL-SQL queries to improve Performance.
• Creating new components using Oracle APIs and writing new interface.
• Worked as primary contact for migration of projects toSIT, UAT and Production Environments.