We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

San Jose, CA

Summary:

  • I am working as a BI Consultant at Confidential Technologies. I have 7+ years of IT experience in Business Intelligence and Data Warehousing for industry sectors like healthcare, Telecom and Finance. Across several functional areas like Financial, Sales and Human Resources. My core skills include Business analysis, BI solution development, analytical and reporting solution development and implementation, Enhancements, and maintenance with a range of technical skills like dashboard and reporting solution development with OBIEE and Tableau.
  • Building, Publishing Customized interactive reports and dashboards, report scheduling using Tableau.
  • Created parameters, action filter and calculated set for preparing dashboard and worksheet in Tableau.
  • Implementation of row level security to restrict the data for different user.
  • Developed tableau workbook for multiple data source using data blending.
  • Administration of tableau server including installation and configuration.
  • Upgrading Tableau server 8.x to 9.x
  • Create backup primary, Use back up primary
  • User management in Tableau.
  • Daily maintenance activity of Tableau like Cleanup, Back up, restore etc.
  • Strong knowledge of SQL package
  • Developed IT Wiz analytics Product in Tableau and Confidential .
  • OBIEE platform design and implementation with multiple cluster
  • Finalize Architecture of OBIEE high availability environment.
  • Upgradation OBIEE 11.1.1.7 to OBIEE 12.2.1.0.0
  • Installation and configuration of OBIEE (11g and 12c)
  • Strong experience in OBIEE administration (Using WebLogic, EM, Unix / Linux Script)
  • Load plan monitoring and Troubleshooting through ODI operator.
  • Expertise in developing and Customizing all 3 layers of the Analytics Repository (Physical Layer, Business Mapping and Modeling Layer & Presentation Layer).
  • Experienced in configuring OBIEE Reports & Dashboards, OBIEE Delivers, Narrative views.
  • Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
  • Experienced in full life cycle system development: comprised of Data Requirement Analysis, Design, Development, Testing, Implementation and Documentation of Business Applications.
  • Well versed with SDLC lifecycle processes.
  • Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series and Cache Management.
  • Configuring Analytics Security and creating User’s Groups and setting Privileges.
  • Implementation and review of BI Publisher Reports
  • Dimensional modelling for new DataMart.
  • Implementation of data level and object level security.
  • Implementation of writeback, usage tracking in OBIEE reports.
  • Ability to translate functional specifications into detailed technical design specification.
  • Implemented RPD Level Security, Object Level Security and Data Level Security in OBIEE.
  • Involved in Performance Tuning at RPD Level & Database Level.
  • Created the Reports in different view likes Table, Pivot, Graphs, Charts, Filter, Title, View selector and Prompts.
  • Strong experience in client interaction and understanding business application, data flow and data relations.
  • Proven analytic, critical thinking and problem solving skills.
  • Experience on data warehousing concepts, ELT tool ODI.
  • Good in Business communication to understand the business requirement.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Pl/SQL Developer

Responsibilities:

  • Working with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
  • Involved in the Environment Architecture design.
  • Designing Architecture for Tableau environment.
  • Installation of Tableau server.
  • Administration of Tableau server.
  • Created backup primary, Used back up primary
  • Create group, Sync group with AD.
  • Assigning site role for user.
  • Migration of OBIEE Confidential application to Tableau.
  • Developed IT wiz Product in tableau which source data from Service now.
  • Building, Publishing Interactive reports and dashboards, report scheduling using Tableau
  • Scheduling extracts and monitoring scheduled extract
  • Security implementation in Tableau.
  • Implementation of Confidential Reports
  • Development of RPD and reports in OBIEE 12c.
  • ODI Data mapping and loading
  • Involve in the data modeling
  • Incorporated best development and Design Practice
  • Review of the deliverables (OBIEE and Confidential ) and Data validation
  • Involved in OBIEE Training to other team members.

Confidential, San Jose, CA

Pl/SQL Developer

Responsibilities:

  • Played BI technical lead role
  • Designing Architecture for Tableau environment.
  • Installation of Tableau server.
  • Administration of Tableau server.
  • Created backup primary, Used back up primary
  • Create group, Sync group with AD.
  • Assigning site role for user.
  • Building, Publishing Interactive reports and dashboards, report scheduling using Tableau
  • Scheduling extracts and monitoring scheduled extract
  • Security implementation in Tableau.
  • Involve in the data modeling
  • Incorporated best development and Design Practice
  • Upgradation OBIEE 11.1.1.7 to OBIEE 12.2.1.0.0
  • Admin Activities in OBIEE 11g and 12c.
  • Installation of OBIEE 12 c and ODI.
  • Development of Physical, BMM, and presentation layer of RPD.
  • Developed complex RPD model using multiple LTS, Fragmentation and content mapping
  • Implementation of Data level and object level security for OBIEE 12c.
  • Set up event pooling to automate cache purge process.
  • Solved critical issue for OBIEE 12c server instability.
  • Smart export and import of ODI scenario
  • Solved issue like un mapping of Physical Architecture, Logical Architecture, after migration

Confidential

Reports & Dashbpards |OBIEE 11.1.1.5 | RPD| SQL|ODI|SQL |Tableau Desktop | Tableau Server

Responsibilities:

  • Played BI technical lead role from Offshore.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Created parameters, action filter and calculated set for preparing dashboard and worksheet in Tableau.
  • Implementation of row level security to restrict the data for different user.
  • Developed tableau workbook for multiple data source using data blending
  • Have Implemented Custom data mart for service contracts to ensure service levels while preventing contract leakage by creating a single model of entitlement information that can be shared across the service organization.
  • Created Pending contract detail report which help to inform customers and/or agents of pending contract expirations.
  • Created discount analysis report to check which service contract or usage has been applied top 10 discount.
  • Developed OBIEE agent which will provide alert /sent mail to the customer before service contract expiry.
  • Involved in analysis of reports.
  • Maintenance of OBIEE server
  • Migration of RPD and Presentation catalogue
  • Involved in development of custom subject area RPD.
  • Involved in investigation of all production issues in OBI reports.
  • Creating new reports and dashboard.
  • Have Implemented data level security and object level security.
  • Data model design.

Confidential

OBIEE 11.1.1.5 | RPD| SQL|BI Publisher |Reports and Dashboard | SQL Developer

Responsibilities:

  • Worked as a BI consultant to decide the data modelling
  • Involved in analysis of reports.
  • Created Risk detailed report by operating unit risk reason, account type and region.
  • Developed risk analytics as a custom component.
  • Involved in OBIEE upgradation
  • Involved in preparing mappings of all the required OBI elements starting from the Physical to the Presentation level.
  • Involved in investigation of all production issues in OBI reports.
  • Creating new reports and dashboard.
  • Development of RPD.
  • Have Implemented data level security and object level security. Created Security settings in OBIEE Admin Tool to setup groups, access privileges.
  • Data model design.
  • Created Proactive agents (I Bots) and configured Interactive dashboards.

Confidential

OBIEE | RPD| SQL|BI Publisher |Reports and Dashboard |OBIEE Developer

Responsibilities:

  • Created/Modified Metadata repository (.rpd) by using Administration Tool Physical, Business Model and Mapping and Presentation Layers.
  • Developed custom dashboards and reports using Answers.
  • Implemented Out - of-the-box Analytics Reporting Functionality of Datamart Reporting.
  • Created connection pools, imported physical tables and then created Alias tables, defined joins and implemented authorizations in the physical layer of the repository.
  • Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics on metrics.
  • Developed Calculated Measures and Dimension Hierarchies and Time Series Functions in the BMM Layer.
  • Created logical joins between fact and dimension tables in business model and mapping layer.
  • Extensively used different performance tuning methods.
  • Developed reports and configured the Intelligent Dashboards.
  • Extensively used Dashboard Pages, Prompts, Sections, Dashboard Prompts including View Selector, Column Selector, Pivot Tables, Charts, etc.,
  • Involved in Unit Testing

Confidential

Siebel Analytics | Pl/SQL Developer

Responsibilities:

  • Worked here as a lead OBI Developer.
  • Review the performance of reports.
  • Involved in data analysis and Functional Design
  • Created Order Summary report which shows Order count by category and region.
  • Created Order detailed report which enables user to drill down from summary and shows details.
  • Advance Excel Techniques & Data Management (Pivot Tables, Data Validations, Sorting, Filtering What-if-Analysis, subtotaling, Grouping, Solver, Functions like sumifs, countifs, Lookup, SQL, VBA Macros and automation, preparation of MIS.
  • Created Failed order detail which shows the reason for the order has been failed
  • Development of OBI reports and dashboard

Hire Now