SUMMARY:

• Highly motivated Functional Analyst / IT Consultant with practical experience and sound knowledge in Project Management, Business Analysis, Systems Analysis, Change Management, Oracle Apps Functional Consultant, System and Software Testing.
• Adept at understanding business processes and implementations.
• Committed to suggesting performance improvements and filling gaps in client's knowledge.
• Specialize in the configuration maintenance management and setup of Oracle applications.

TECHNICAL SKILLS:

• Identity and Access Management
• IT Audit
• Enterprise Analysis
• Risk Management
• SDLC
• Business Process Modeling & Re - engineering
• Requirements Elicitation & Management
• Testing
• System Integration
• Quality Assurance
• Oracle EBS
• Oracle OBIEE
• SQL
• MS Office Suite
• MS Visio
• MS Project
• MS SharePoint
• USB Devices
• Flash Memory
• Root Cause Analysis
• SWOT Analysis
• GAP Analysis

Confidential

Oracle Financials Functional Consultant

Responsibilities:

• Extensive experience in Accounts & Finance Domain

• Testing Oracle financial business flows, worked on financial modules: AP, AR, GL, CM, FA in Oracle e-Business Suite
• Experienced with Full Life Cycle implementations Modules (General Ledger (GL), Accounts Payable (AP), Fixed Assets (FA), Accounts Receivables (AR), Cash Management, E-BUSINESS TAX, Sub ledger Accounting (SLA), Internet expenses (I-exp), Pre-Pays
• Technical testing of customer interface to loads customers into TCA Module from external customer database
• Approval Management Engine (AME), Financial Accounting Hub (FAH) in 11i and R12 in Requirement gathering, Analysis, Solution Design, Development, Implementation, Trouble Shooting (Root cause analysis) and Production Support.
• Define accounting calendar; set up currencies and conversion rate
• Documentation of Present state and Future state business (BP-80), present business requirements (RD-20), conversion (CV-40), and Function extension design document (MD-50), Business as is Document (BR150), Profile options and Users Setup document (BR110), Test scripts (TE-20, TE-30, TE-40) and System Set up Document (BR-100) as per AIM Methodology.
• Closely worked and coordinated with the technical teams to deliver the solutions as per the functional designs and customizations
• Gathering business requirements, analyzing the existing system and providing optimum solutions.
• Documented the current process flows, business requirements and fit/gap analysis for R12 General Ledger, Accounts Payable, and Accounts Receivable.
• Worked with business users for creating AIM Methodology Functional documents
• Study of Current Business Processes, Future Business Flow and identification of GAP/Workaround
• Business Requirements Mapping for GL and AP
• Expertise in executing Conference Room Pilots (CRP) and User Acceptance Test (UAT).
• Analyzes user needs, conferring with users to improve procedures and identifying and solving problems

Confidential

Oracle Business Intelligence

Responsibilities:

• Experience in OBIEE 10.1.3.4, OBIEE 11.1.1.6.0, and OBIEE 11.1.1.7.0 providing end-to-end business intelligence solutions by dimensional modeling design, building business models, configuring metadata, creating reports and using dashboards.

• Expertise in Oracle BI Server, Oracle BI Answers, BI Scheduler, Oracle BI Interactive Dashboard and BI Publisher.
• Experienced in interacting with Business users conducting interviews to gather, analyze and document user needs, business processes, identifying reports/KPIs and other requirements then rolling out deliverables.
• Expertise in using dimensional hierarchy modeling and time series modeling in the Business Model and Mapping layer to meet business requirements.
• Proficient in implementing comprehensive Security functionality - created users & web groups, external table security using session variables, tested and validated the model using OBIEE Admin tool and associating Catalog objects & Web modules with the created users / groups to data and object level security
• Building star and snowflake schemas in the repository as well as using the Foreign key link in the physical layer and the New complex joint key in the Business Model and Mapping layer.

Confidential

Oracle EBS Functional Financial Analyst

Responsibilities:

• Responsible for developing new reports, interfaces, workflows and forms in various application modules including GL, AP, AR, P2P, FA, E-BUSINESS TAX and I-Expense.

• Registered Reports, SQL Loader Scripts as Concurrent Programs using System Administrator Responsibility.
• Conducted pilot testing, integration with other financial testing modules
• Tested the financials and payables modules
• Experience of setup and configuration of PO, OM, AR & AME Modules
• Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• Developed Payables Open Interface Import Program to load invoices from multiple sources like legacy invoices into AP in a periodic basis and designed a report using XML/BI Publisher.
• Worked on personalization and extensions of standard pages using Oracle Applications Framework.
• Developed and customized various complex reports using Oracle reports and XML/BI publisher
• Used SQL*Loader to import receipts data into AR Payments Interface table after defining Lockbox, and running Lockbox interface form transferred data into Oracle Receivables.
• Worked with Application Object Library (Defined executable, programs, linked with responsibilities, defined DFF and value sets).
• Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation.
• Developed and customized Oracle seeded reports in Order Management and Shipping. Reports were generated for Pick Slip, Pack Slip, Purchase Order and Shipping Label.
• Responsible for designing, developing, unit testing, implementing and maintaining the custom extensions for Oracle Applications.
• Involved in troubleshooting issues including creation of oracle service requests and conducted quality reviews of code developed by other development staff.
• Actively involved in all phases of the Software Testing like Analyzing System Requirements, Test Strategy, Test Planning, Test Case Design and System Testing.

Confidential

Oracle Functional Financials Analyst

Responsibilities:

• Worked for Procure to Pay Process (P2P) and Order to Cash (O2C) Processes and integrates with financial modules like AR, AP, E-BUSINESS TAX, FA, GL, CM and I-EXPENSE.

• Customized the components, upgraded shell scripts, which calls reports, control files and SQL files which are in the production and migrated objects into Oracle EBS 12.1.2
• Designed and developed staging tables, conversion routines, Custom PL/SQL API's for converting Suppliers, Supplier Sites, Supplier Contacts, and Customers using TCA, Open AP Invoices, and Open AR Invoices from legacy system into Oracle Applications.
• Worked on generating XML Publisher reports in the modules OM, INV and AR and created
• Configured AME (Approval Management Engine) to the requirements.
• Hands-on experience in Application Implementation Methodology (AIM) and Oracle Unified Methodology (OUM)
• Configured system to be able to prepare monthly accruals and reconciliations for multiple expenses; prepaids and market data, Core Competencies accounts reconciliations as assigned (i.e., A/P, Prepaid Accounts)
• Developed the PL/SQL Scripts to translate the old Asset Category to new Asset category values that are been setup in the R12 Fixed Assets.
• Worked extensively on the customization of Auditor Reports using BI/XML Publisher and resolved open issues with the existing custom reports and developed in new ones.
• Experience in Implementation of Auto lockbox to automate the receipt creation in O2C process
• Created new business areas, workbooks according to user requirements and also involved in creating reports using Discoverer 10g.
• Participating in CRP sessions and all testing phases including user acceptance testing and system integration testing.

Confidential

Oracle EBS Functional Analyst

Responsibilities:

• Demonstrate expertise as Functional Analyst in Oracle EBS environment, working and supporting P2P stream of business.

• Troubleshoot and diagnose incidents in Oracle EBS P2P (AP, PO, iExpense, INV) as they escalate from internal support team.
• Functional Design confirmation of Concur (expense system that was used) integration with Oracle R12
• Functional point of contact for solution confirmation, CRP/UAT sessions of Concur integration with Oracle R12.
• Leading various P2P functional efforts in Oracle Integrations with Company acquired by Client.
• Troubleshooting bugs, configuring roles, profiles, group web inbox feature to route invoices related to Markview.
• Working and delivering as an Oracle EBS Business Analyst alongside Client Integration team during cutover period.
• Taking over responsibilities and performing under various cross-functional roles that span over SCM (OM, INV, WIP, and BOM) and financial streams (AP, AR, GL, CE) when team is engaged in SIT/CRP/UAT activities.
• Providing functional view and process improvement to various (AP, AR, GL, PO, INV, iProc, iExpense) related incidents, tasks raised by stakeholders, users and cross-functional teams.
• Successful in documenting and demonstrating various Oracle EBS functionalities, capabilities to stakeholders to improve business processes.
• Analytical ability to identify, diagnose various bugs/defects/incidents raised and provide analysis on same.
• Developed rapport and gained acceptance on different Integration & Support activities with various teams, cross functional, technical, stakeholders and end users

Confidential

Wingspan Portfolio Advisor

Responsibilities:

• Knowledge in converting legacy reports to BI Publisher.

• Build report using BI Publisher 11.1.1.9.
• Created Catalogs and report templates for clinical applications.
• Created Oracle BI Data Models using Oracle SQL queries and Parameters.
• Created on creating oracle BI reports using MS word BI Plug-In that included sub-templates.
• Provide a means for users to use the system while supporting the highest level of security and privacy.
• Provide users with accurate data from which they can make decisions.
• Provide users with dashboard that is easy to use.
• Attending and participate in daily stand-up meetings.

Confidential

Oracle Business Intelligence Developer

Responsibilities:

• Provide support in the development of OBIEE components and solutions

• Understand project requirements and work towards design and development of the plan layout
• Develop and deploy dashboards, analytics and reports properly
• Design and develop data modeling concepts using various data modeling tools like star schema and dimensional modeling
• Work with administrators, users and analysts to maintain exchange of reporting requirements
• Use the best practices of business intelligence to meet project and company objective.
• Prepare monthly reports and present it to the management
• Develop and design dashboards, reports, ad hoc queries and analysis
• Work in collaboration with data analysts, business analysts, other technical teams and business teams.
• Prepare documentation and give project performance feedback to the clients and the senior management.
• Develop and design data modeling concepts using OBIEE tools.
• Perform testing sessions for reports and dashboards and resolve process issues
• Interact with the client and end user to collect the list of requirements
• Prepare project layout and provide technical guidance to the development team

Confidential

Business Analyst

Responsibilities:

• Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans related to commercial lending

• Worked extensively with SMEs in understanding and documenting their requirements. -Worked with all levels of client staff in the process of solution definition
• Assisted with product evaluation, product customization and system integration. -Conducted GAP analysis around the identification of business rules, business and system process flows, user administration, requirements and assumptions
• Supported testing, Test Cases in HP Quality center that would test various Test scenarios. Designed and developed Use Cases, Use Case Diagrams and Activity Diagrams using UML.
• Authored business requirements documents with the business users. Extracted, discussed, and refined business requirements from business users and team members.
• Coordinated activities between business unit and technical staff, developed new methods, policies, and procedures to meet the business needs, as well as acted as primary trainer in educating the business units, related to business applications.
• Performed UAT on business requirements, technical specifications and product knowledge. Involved in documentation during various phases of development life cycle.

Confidential

Business Analyst

Responsibilities:

• Projects were implemented on the traditional Waterfall framework.

• Created waterfall framework artifacts such as BRD, FRD, use case and use case diagrams and UML diagrams.
• Analyzed, documented and maintained business requirements, functional requirements, and technical specifications
• Defined and documented business requirements with sufficient detail to enable customer sign-off
• Collaborated closely with the technical team for solution development.
• Worked collaboratively with Development Team to identify data requirements and mapping.
• Established practical and efficient design and testing approaches
• Interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Reviewed test strategy and test plans to ensure, test cases reflected functional, user interface, performance, usability and security requirements
• Worked extensively on MS Office tools like Excel, PowerPoint, Word, etc. for documentation and presentation purposes, used MS SharePoint for document storage/sharing, and used MS Outlook extensively for communication and meetings on the project.