Summary:
Over 13 years of IT experience and about 4 years of OBIEE and Oracle Apps EBS experience ingathering Business Requirements, developing Business Intelligence Program strategies, Testing/Functional ,designing and implementing BI information & analytical solutions using OBIEE,Informatica,Oracle Apps EBS and BI Discoverer on Windows platforms

• Strong knowledge of Software Development Life Cycle (SDLC).
• Experience in providing end-to-end business intelligence solution by configuring metadata &building Analytics Repository, dimensional modeling design,generating reports, testing and creating Inter-active Business Intelligence Dashboards using OBIEE.
• Experience in Data Warehousing development using ETL tools such as Informatica Power Center/ and DAC.
• Experience in Production Support projects handling OBIEE dashboard, rpd, ibots, data-related issues, change requests, enhancements etc.
• Strong experience in developing Test Plans and Test cases using requirements and design documents.
• Functional knowledge of Oracle financial EBS modules like AP,GL,FA, PO.Worked on various interfaces to load the monthly feeds from legacy systems to the Oracle Apps by using the interface programs and sql loader and data loader.
• Worked extensively on BI Discoverer10g and created various browses for the user needs.
• Experience in testing Oracle Apps EBS Financials, Web-based and Client-Server applications on different environments.
• Ability to write test plans, test cases, Interface specification documents from Requirements and Use Cases.
• Excellent communication and presentation skills, self starter, quick learner, team player.

Technical Summary:

OBIEE: Siebel Analytics 7.8.4, OBIEE 10.1.3.3, Informatica 8.x/7.x/6.x, Discoverer 4i, 10g, DAC
Oracle Applications E-Business Suite: Financials (GL, AP, AR, CM, FA, PO, iProcurement)
Databases: Oracle 11i/9i/8i/8.x/7.x/6.x, SQL Plus, TOAD
Configuration Tools: PVCS, Rational Clear Quest, Microsoft VSS
Tools: HP Quality Center, DataLoad, SQL Loader

Education: M.Tech
Training: R12.x Oracle Financials Functional Foundation

Professional Experience

Confidential,Harrisburg, PA Aug’08-Till Date
Oracle Apps OBIEE Analyst
Source Interlink Companies, Inc. is a leading integrated media, publishing, merchandising and distribution company. Source not only delivers directly to consumers the very best in magazine, Internet and home entertainment content, they distribute content from other publishers and producers as well. By putting the world\'s leading distribution network for print and home entertainment materials to work in the service of its retailing partners, Source provides consumers access to their favorite reading, viewing and listening materials quickly and conveniently.
Responsibilities:

• Created and designed Subject Area in Analytics Repository (RPD).
• Created custom and packaged Interactive Dashboards with Drill Down, Dynamic, Criteria Filters, Security, Pivot Table, Chart, Aggregation, Logical Columns and Filters.
• Created security privileges for each Dash Boards and Subject Areas as per the user requirements.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Study of Current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company
• Worked in developments of analytics Reports using OBIEE Answers and assign them to specific Dashboards with Oracle Financials EBS as source of data from the modules like AP,GL and FA
• Financial Reports related to AP vendors, vendor sites, Invoices and distribution lines in AP, FA Locations, GL Journals, balance sheets and statements etc from Oracle Financials as Source.
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle Metalink and Oracle Applications Patch Management
• Supported production environments and users on a daily basis by responding to emergency request.
• Modified Dynamic Session Variables used for data visibility, Configured Security at Repository Level and Catalog Level.
• Involved in ETL Mappings/Mapplets and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator)
• Worked with ETL team in using Informatica Transformations to load the right data from the source.
• Knowledge of DAC and out of the box prebuilt BI Apps.
• Created Subject Areas, Tasks, Execution plans in DAC and monitored and scheduled the ETL routines.
• Worked as a functional support as well in Oracle EBS financials AP, GL, PO, FA modules and worked on Discoverer 10g reports and solved user issues.
• Worked on the setups in oracle financial modules AP and PO. Set up of Bill-to, Ship-to and Remit-to Address for various customers and tested the P2P cycle.
• Tested the 2 way and 3 way matching process in PO,AP and AR
• Created and Tested Oracle Alerts (ALR) to inform internal users of certain events, or to notify customers of account status and to the managers if new orders, vendors, payments are created.
• Set up the banks, accounts and payable documents in AP.
• Set up of vendors, vendor sites, banks in AP.
• Created payment terms with discounts in AP.
• Defined the Approval Hierarchy for PO and Requisition Approvals.
• Loaded and tested Data Migration from Legacy systems and Open Interfaces to oracle.
• Created and Tested the DFF’s for the file attachment functionality in Invoice payment batch level.
• Involved in testing the check printing process.
• Tested the front end apps when the updates or loads are happened in the back end oracle.
• Created the folders on AP_TOP and GL_TOP for vendor loads, invoice payments for the FTP purpose according to the concurrent programs.
• Worked on Upgrade of Discoverer 4 to Discoverer10g reporting tool and prepared user documentation.
• Documented the servers and instance management flow document.
• Prepared the report spread sheets of the current users and user responsibilities every month by writing the SQL scripts.
• Prepared QA test document TE 70 for Oracle EBS

Environment: OBIEE 10.1.3.x, DAC 10g,Oracle Apps EBS 11.5.10.2, RDBMS: 11.2.0.1.0,
OBI Discoverer10g,BI Apps, TOAD, Informatica 8.x

Confidential, Monterey, CA Aug-‘00 to – July’08 Role: Sr Oracle QA Analyst
McGraw- Hill is the leading publisher of standardized achievement tests for children, adults and also a publisher of various books and magazines like Business Week, Aviation Week. McGraw-Hill assist thousands of school districts across the nation and score more than 30 million test documents each year. McGraw-Hill provides standardized testing services to schools and other professional organizations across the nation.

Responsibilities:

• Involved in Functional, Regression, Unit, Integration and UAT testing.
• Participated in the meetings and worked closely with the Business, legacy and Development team members
• Worked on Oracle financial application modules like AP, PO, FA and GL.
• Tested the cross validation rules in GL for accounting segments.
• Created and tested the suppliers, invoices and POs as part of testing
• Tested the Payable to GL transfers, GL journal imports, period open and close process.
• Verified the OBIEE Dash boards,reports,sort,filters,pivot tables.
• Wrote Test plans and the Test cases according to the business requirements for each release by using the Quality Center.
• Coordinated in the integration testing with the other legacy team resources
• Managed and maintained the defects among the QA, DEV and the Business team. Tracking the issues and issues of the day can be communicated and or resolved, and overdue or urgent problems can be reviewed using the Quality Center
• Automated the manual test cases using the QTP for the Monarch application
• Created data driven tests and checked to make sure that the tests would run smoothly for the various sets of data.
• Verified the other application’s data on the staging-interface tables using the PL/SQL Developer
• Communicated and reviewed progress of the testing with all relevant members of the test team during the Daily Test Team Meetings.
• Published all the QA documents on the share point and the portal including the Test cases, Test planes, Daily status.
• Implemented the Change Request process and coordinating test environment setup with Configuration Management Team
• Created training documents and templates to assist the new QA team members
• As a super user, created and assigned Roles to the QA team
• Coordinated the Major releases with the technology and CM team
• Prepared the matrix and the daily status reports for the project Management team.

Environment: Java, XML, Oracle, PL/SQL, QTP, Financial Apps,OBIEE, Mercury Quality Center, Web logic, Mainframe, Windows XP, Rational Clear Qwest2.0, 5000I image scanner, Bubble scanner NCS 9101,Main frame

Confidential,Mountain View, CA March\'00 – Aug’00
E-stamp.com is an internet browser based product called E-Stamp online. With EON you can print postage and addresses onto envelopes and labels in one easy step right from the PC. E-Stamp Internet postage has everything you need to print directly to your printer without connecting to the Internet. Purchase and print postage, whenever you need it, 24 hours a day, seven days a week.
Responsibilities:

• Worked as a QA Analyst and involved in writing Test cases for the applications
• Involved in Unit and Regression testing.
• Documented the defects using PVCS Tracker
• Interacted with the developers for enhancements and development releases
• Participated in Alpha testing.
• Tested different kinds of Printers for the printing on the envelopes.
• Participated at the time of Alpha Testing
• Performed cross-browsing testing to verify that the application displays correctly in a variety of environments.
• Involved in testing the back end data using SQL
• Tested all the functional features like Buy Postage, Print Postage, Address management,Reports,Shipipping

Confidential,Columbus, OH March ‘98 – Apr ’99
Vocational Education/School Finance:

The main function of the vocational education systems is to track and allocate funds to school districts and other institutions in the state of Ohio. School Finance systems is to calculate funding payments for different school services, and to generate the disbursement request files and perform a wide variety of basic functions for the Department of Education, including payroll/personnel, general Accounting and specific school tracking functions.

Responsibilities:

• Involved in development of test plan for GUI based VB application.
• Prepared and documented the test cases for various screens of the application.
• Performed a major role in the execution of test cases.
• Maintained a test log and reported defects, also monitored the resolution of defects using SIR System.
• Involved in Unit testing & Integration testing.

Year 2000 Conversion

• Involved in making LEGACY, VOCED systems Y2K compliant free
• Involved in testing baseline, renovation and date warping.
• Involved in EXPANDING and AGING the data files.
• Involved in testing the programs by AGING and with specific dates.

Environment: Visual Basic 5.0, Crystal Reports, Oracle 7.1, SQL, PL/SQL,Windows95,Unix,VAX/VMS,COBOL, DCL,IBM Mainframe, PIERCOM2000