PROFESSIONAL SUMMARY:

• 13 years of U.S experience in I.T with expertise in Product Development,Data Warehousing, Reports Development, RPD Development & Dashboards.
• 15 years of Experience in SQL/PLSQL, SQL Loader using Tools like SQL*Plus and TOAD.
• 15 years of Experience as Reporting Analyst / Developer with various Industries (Modules).
• 15 years of experience with Oracle Database and Architecture.
• 9 years of Experience in Order Management, Inventory and Financial Industries
• 7 years of experience in creating Dashboards, Meta Data, MIS Reports, Analytics / Metrics using Oracle Database and Tools such as OBIEE, Focal Point, Oracle Forms/Reports, SQL/PLSQL.
• 2 Years of Experience as SCRUM Master with Agile Methodology.
• 7 years as Team Lead for the Product Development Team, developing Oracle Reports/OBIEEAnswers, Dashboards, Delivers & BI Publisher Reports etc. QA Testing, Production Roll outand Product Support.
• Experienced in Liaison with Stake Holders and Development Team.
• Ability to handle multiple tasks and work independently.
• Willing to learn and adapt to new challenges.

TECHNICAL SKILLS:

Oracle Reporting Tools: OBIEE 12c/ 11g, BI Publisher, Tableau,Oracle Reports.

Data Warehouse /ETL Tools: Informatica, FPETL, OSIS

Query Build Tools: Toad, SQL Developer, SQL Plus.

Database: Oracle 12g,11g, Teradata.

Operating Systems: Windows, UNIX, DOS

Office Applications: MS - Office, MS-Excel, Power Point, MS-Visio

Industries: Finance, Inventory, Property Management, Sales, Purchase, Power Utilities

ALM Tools: JIRA

PROFESSIONAL EXPERIENCE:

OBIEE - Subject Matter Expert

Confidential, Atlanta

Environment: OBIEE, 12c, OBIEE, Oracle, Teradata, SQL Developer.

Responsibilities:

• Converting Discover Reports to OBIEE Analysis / Dashboards.
• Creating Metadata (RPD) during conversion of Discover Reports.
• Creating DDR (Direct Database Requests) for less sensitive Reports.
• Liaison with Data Admins and ETL Team for exposing missing data Elements.
• Production Deployment and Support.
• End Users and Assisting Jr. Developers in achieving their Goals.
• Accounting Tasks and Time Management through JIRA.

Sr. OBIEE Developer

Confidential, Chicago

Environment: Amazon Redshift Database, OBIEE, 12c, BI Publisher, ODI, SQL Developer.

Responsibilities:

• Worked with Amazon Redshift Database using the new Connection Features in 12c.
• Creating Analysis, Dashboards, Subpages with Graph, Percentile and Tabular Reports in 12c.
• Assisted Executives in creating Ad Hoc Reports using Data Visualization features.
• Rpd Modification based on the Business Requirements.
• Replicating Dashboards and Analysis in OBIEE to match with the Legacy Systems.
• Interacting with Data Modelers and ETL Team, during planning meetings.
• Creating Alerts/ Schedule Jobs. In OBIEE.
• Created Reports using BI Publisher (from Data Model & Subject Areas)
• Made use of Report Bursting with BI Publisher in generating letters for Suppliers.
• Executives on OBIEE Functionalities.
• Responsible for Catalog Migration across Dev, QA and Prod.
• Responsible for RPD Deployments.
• Debugging and Resolving Issues in the UAT Environment.

Sr. OBIEE Developer / Tech Lead / SCRUM Master

Confidential, Washington D.C

Responsibilities:

• Analyze the data and develop Logical Star Schema model with consultation from Data
• Develop new Subject Areas and Hierarchies in the RPD.
• Implemented Data Security using Data Filters and Application Roles.
• Design and develop various Interactive Dashboards and Reports with drill downs, guided
• Configured BI Scheduler and Oracle BI Delivers - Agents/iBots to deliver alerts and publish
• Prepared deployment files from Test to Stage and Production, using 3 Way Merge.
• Configured and implemented MUDe (Multi User Development Environment) to allow formultiple scrum teams to work on the same RPD/Subject Areas.
• Investigate & Resolve Production Data Issues.
• Act as a liaison between business users and BI team to facilitate understanding of businessrequirements.
• Developed Health Check Dashboard for 52 Subject Areas, categorized by Databases used.
• BI Admin for Development and Test Environments.
• Address bugs in the existing reports, as part of the O&M (Production Support).
• Support ETL staff in defining BI structures.
• Scheduling Usage Tracking Reports for Directors.
• Work with the Product Owners to prioritize the backlog tasks.
• Participant in Backlog Grooming sessions with the Product Owner.
• Write Test Plans for QA Testers.
• Performed the Role of Scrum Master on backfill Positions.
• Conducted OBIEE Forum Developers to engage the team members in knowledge sharing ontheir respective Subject Areas, and other BI best practices.
• Assist PM by conducting Project Meetings in his absence and maintaining minutes of

Sr. Software Engineer / Data Warehousing Business Consultant

Confidential, Atlanta

Environment: Oracle Database 10g, 11g, PL/SQL, Focal Point, OBIEE, TOAD, SQL DEVELOPER Project Description: Implementation of custom made software for Power Utility Companies Nation-wide.

Responsibilities:

• Developed procedures and functions (back-end) for Scana Energy, Georgia Power,
• Lead Technical Consultant in Upgrading Work Management System and Field Force
• Management System from 6.0.6 to 6.6.5 ver. for Central Hudson Gas and Electric, NY.
• Built Credit & Collections Module Dashboards for Central Gas & Electric, NY.
• Responsible for building Executive Summary Dashboard for Detroit Electric Company.
• Responsible for implementing data as well as Object Level Security.
• Introduced KPI / KPI Watch List for Central Hudson.
• Upgraded OBIEE 10g RPD, Users and Groups, Web Catalog, Delivers to OBIEE 11.1.1.5
• Applied ODBC function in Post SQLProcess of ETL to Purge Cache.
• Applied Seeding to make Caches’ available for increasing the performance of Daily Reportsthrough Schedule (Oracle Delivers).
• Responsible for Gathering Business Requirements and Documenting.
• Resolved Code related Issues registered in Mantis System.
• Creating Packages, Procedures and Functions for New Requirements.
• Prepared technical documentation.
• End User & Online Technical Support.

Oracle Reports - Team Lead

Confidential, WI

Environment: Oracle Reports Builder 10g, SQL DEVELOPER, Oracle Database 10g, SQLLDR. Project Description: Wisconsin State Government Implementing IPAS (Integrated Property Assessment System)

Responsibilities:

• Liaison with Sr. Business Analysts in Translating Business Requirements.
• Prepared Financial & Tax related reports for different Authorities such as District,Municipalities, Counties etc.
• Generation of M.I.S Reports for the IPAS Project using Oracle Reports Builder 10g.
• Data porting from Mainframe IBM DB2 to Oracle Database using SQL Loader.
• Prepared technical documentation.
• End User & Online Technical Support.

Sr. Oracle Report Developer

Confidential, Atlanta

Environment: Oracle Reports Builder 10g, OBIEE, Oracle Database 10g, PVCS, Windows 2003. Project Description: IHG is a leading group in the Hotel Industry with approximately 3400 hotels worldwide. The Goal of this Project was to promote the Business to the Next Level based on the Analytics from the Historical Data using Oracle BI and Oracle Reports.

Responsibilities:

• Gathered Business Requirements from Directors, VP, Managers and Executives.
• Performed Gap Analysis and feasibility study for the given requirements.
• Responsible for Creating MIS Reports using Oracle Reports Builder for Opera Systems(PMS).
• Created reports in Oracle Reports Builder 10g with multiple groups / queries, LexicalParameters, Report Triggers Functions & procedures.
• Generation of Statistical Reports for the Corporate Management using Oracle DeveloperReports 10g.
• Assisted with user testing of systems, developed and maintained quality procedures andensured that appropriate documentation was in place.
• Identified slow-running Queries using Explain Plan and Reports using Trace File.
• Liaison with QA Testers by providing SQL Scripts, Test Cases and resolving any issues
• Created dashboards with combined views in tables as well as Pie Chart, To Display Hotel
• Reservations with Drill Down feature from State to the Lowest Level Zip Codes, which gives clear indication to Management the areas to Focus Promotional Activities to Boost Business.
• Created Dashboard for Customer Stay Pattern Statistics using Column Selectors on Type ofProperty.
• Created Dashboard named ‘Revenue Segments’ using View Selector which indicates sourcesand its share of revenue on Total Revenue for the Management.Created Dashboard for Management Displaying Resort Wise Revenue Statistics using filtersn ‘Checked Out’ Transactions.
• Created Dashboard for a Statistical Report on Reservations vs Cancellations featuringColumn Selectors as well as Hierarchy on Type of Property.
• Provided User on Dash Boards Illustrating various analytical features such asdrilling down to the lowest level, View Selectors etc.RPD & Security
• Create connection pools, imported physical tables and defined joins in the physical layer ofthe repository
• Customize BI Repository (Physical, BMM, and Presentation layers).
• Modified Presentation Layer to add presentation tables and columns to meet the business userneeds.
• Security Management for users, groups and web-groups using the various authentication

Sr. Oracle Reports Developer

Confidential

Environment: Oracle Database 10g, Optio Reporting Software, Oracle Discoverer 9.0.4, Oracle E-Business 11.5.3 (Sales Contract), Oracle Reports Builder 10g, OBIEE, Unix, Pvcs

Responsibilities:

• Responsible for designing, developing & modifying reports using Oracle Reports Builder 10g
• Enhanced Oracle Reports in the Contracts module in Oracle E-Business Suite to enhanceclarity and easy maintenance.
• Used Optio Reporting Software to Produce Quality Output for precise layouts and easymaintenance.
• Created Concurrent Programs with Oracle Applications to use the Modified Reports.

Oracle Report Developer

Confidential, Global Payments, Atlanta

Environment: Oracle Reports Builder 6i, Oracle Database 10g, Oracle Discoverer 4.1, Test Director, Unix, Pvcs.

Responsibilities:

• Continuously interacted with the client and the developers to come to a common conclusionfor the processes and documentation to fulfill the requirement.
• Created Reports in Oracle Reports Builder 10g with multiple groups / queries, LexicalParameters, Functions & procedures.
• Generation of Statistical Reports for the Corporate Management using Oracle DeveloperReports 10g.
• Assisted with user testing of systems, developed and maintained quality procedures andensured that appropriate documentation was in place.
• Identified slow-running Queries using Explain Plan and Reports using Trace File.
• Created Test cases and Test Plans for QA Testing.
• Initiated User Acceptance Testing and rectifying errors in coordination with end Users.

Project Manager

Confidential

Environment: Oracle 8i, Oracle Reports 3.0, Forms 4.5,Windows NT.

Responsibilities:

• Oversaw the development and successful implementation of high-end systems forAutomobile Industry using Oracle Tools.
• Identified, documented & Developed User Requirements and Modifications required.
• Developed MIS Reports using Reports Builder 6i for the Corporate Management.
• Budgeted the Project and Documenting the Terms, s and Price.
• Involved in Scheduling the Project and Allocation of Software professionals.
• Involved in the Implementation and of the Package at the Client site.