SUMMARY:

• Extensive experience in Accounts & Finance Domain
• Experienced with Full Life Cycle implementations Modules (General Ledger (GL), Accounts Payable (AP), Fixed Assets (FA), Accounts Receivables (AR), Cash Management (CE), Sub ledger Accounting (SLA, E - business tax (EB-Tax), Internet expenses (I-exp),
• 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
• 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.
• Extensive experience in OBIEE repository (Physical, Business Model and Mapping and Presentation layers) for both Stand-Alone and Integrated OBIEE implementations.
• 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.
• Expertise in using Alias and Dim tables so that the hierarchy and time series modeling would meet business requirements.

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

PROFESSIONAL EXPERIENCE:

Oracle EBS Financial Analyst

Confidential

Responsibilities:

• Responsible for developing new reports, interfaces, workflows and forms in various application modules including GL, AP, AR, FA, OM, INV and PO.
• Registered Reports, SQL*Loader Scripts and PL/SQL Packages as Concurrent Programs using System Administrator Responsibility.
• Developed a GL interface module using SQL LOADER for data loading for preprocessing of data used PL/SQL and for integration withOracleApplications developed UNIX shell scripts to import Journal entries from external source.
• Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• Created control programs of SQL*Loader and PL/SQL validation procedures to execute along with Customer Interface (AR) and Developed packages specifications & packages body, Stored Procedures, views and cursors using PL/SQL.
• 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 usingOracleApplications Framework.
• Developed and customized various complex reports usingOraclereports 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 intoOracleReceivables.
• 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 customizedOracleseeded 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 forOracleApplications.
• 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.

Environment: - OracleApplications 11.5.10.2/R12.2.4 (EBS) (GL, AR, AP, OM, INV, FE, PO),Oracle Database 10g, SQL*Loader, PL/SQL, Forms Builder 10g and Reports Builder 10g, XML /BI publisher

Oracle Functional Financials Analyst

Confidential

Responsibilities:

• Worked for Procure to Pay Process (P2P) and Order to Cash (O2C) Processes and integrates with Financial and SCM modules like AR, AP, OM, GL, INV, PO and CE.
• Customized the components, upgraded shell scripts, which calls reports, control files and SQL files which are in the production and migrated objects intoOracleEBS12.1.2
• Developed the SQL*Loader script to load the data to staging tables and then to interface tables for Order Import program to import orders and wrote packages, validate and interface tables.
• Setup Advance Pricing to define Price Breaks, Modifiers, Qualifiers, Setup Price lists for different currencies, worked on defining attributes to be used in Pricing, defined automatic discounts, surcharges in Advance Pricing module.
• 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 intoOracleApplications.
• Worked on generating XML Publisher reports in the modules OM, INV and AR and created
• Hands-on experience in Application Implementation Methodology (AIM),OracleUnified Methodology (OUM) and Application Object Library (AOL).
• Developed interface program to import sales orders received through EDI from retail customers like BestBuy, Staples, Navarre etc.
• 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.
• Customized the Purchase Header level and Line Level Workflow processes to add the activities.
• 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.
• Involved in performance tuning of various packages and reports and done code fixes to improve the performance in OM and AR modules using Explain Plan, TKPROF, Hints and TOAD.
• Participating in CRP sessions and all testing phases including user acceptance testing and system integration testing.

Environment: OracleApps R12.1.2, Order-2-Cash, INV, OM, PO, AR, AP, GL, QP, Database 10g, Forms 6i, Reports 6i, SQL, PL/SQL, TOAD, SQL*

Oracle Functional Analyst

Confidential

Responsibilities:

• Demonstrate expertise as Functional Analyst inOracleEBSenvironment, working and supporting P2P stream of business.
• Troubleshoot and diagnose incidents inOracleEBSP2P (AP, PO, iExpense, INV) as they escalate from internal support team.
• Functional Design confirmation of Concur (expense system that was used )integration withOracleR12 during WONERP project.
• Functional point of contact for solution confirmation, CRP/UAT sessions of Concur integration withOracleR12.
• Leading various P2P functional efforts inOracleIntegrations with Company acquired by Client.
• Troubleshooting bugs, configuring roles, profiles, group web inbox feature to route invoices related to Markview.
• Working and delivering as anOracleEBSBusiness 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 variousOracleEBSfunctionalities, 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

OBIEE Business Intelligence Developer

Confidential

Responsibilities:

• Knowledge in converting legacy reports (originally written in Cognos) to BI Publisher.
• Ensured BI reports met Section 508 (ADA) Compliance Requirements.
• 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.
• Worked with business community in understanding the functional requirements on how to create OQR/IQR reports.
• 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.

Oracle Business Intelligence Developer

Confidential

Responsibilities:

• Provide support in the development ofOBIEEcomponents and solutions
• Understand project requirements and work towards design and development of the plan
• Develop and deploy dashboards, analytics and reports properly
• Design and develop data modeling concepts using various data modeling tools like star

  Design and place data in layers varying to physical, business and presentation

• Work with administrators, users and analysts to maintain exchange of reporting

  Use the best practices of business intelligence to meet project and company objective.

• Prepare monthly reports and present it to the management
• Develop, implement and deploy data warehousing and business analytical solutions
• Install, upgrade and configure database solutions throughOBIEEtools
• Develop data access queries through Oracle BI tools
• 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 usingOBIEEtools.
• Identify critical issues and processing faults to optimize BI dashboards and reports
• 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
• Install and configureOBIEEtools across multiple tools and versions
• Develop data across layers - physical, business models and mapping
• Develop and design data modeling concepts usingOBIEEtools

Business Analyst

Confidential

Responsibilities:

• Responsible for creating and reviewingbusinessrequirements, 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 ofbusinessrules,businessand 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.
• Authoredbusinessrequirements documents with thebusinessusers. Extracted, discussed, and refinedbusinessrequirements frombusinessusers and team members.
• Coordinated activities betweenbusinessunit and technical staff, developed new methods, policies, and procedures to meet thebusinessneeds, as well as acted as primary trainer in educating thebusinessunits, related tobusinessapplications.
• Performed UAT onbusinessrequirements, technical specifications and product knowledge. Involved in documentation during various phases of development life cycle.

Environment: C#, Microsoft Project, Oracle, UNIX, MS Excel, MS Office Suite (Word, PowerPoint, Excel, Outlook), Visio.

Business Analyst

Confidential

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 maintainedbusinessrequirements, functional requirements, and technical specifications
• Defined and documentedbusinessrequirements 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 differentbusinessgroups 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.