SUMMARY:

• Over 7 years of experience in IT which includes experiencein Business Requirement Gatherings, Analysis, Design, Development, Testing and Implementation of Data warehouse/Business Intelligence using OBIEE 10.1.3.4.1 , OBIEE 11.1.1.5, OBIEE 11.1.1.7, Qlik Sense 3.1, Oracle 8i/9i/10g. SQL Server 2008, Redshift, Understanding of Software Development Life Cycle (SDLC) metho dology, BI Mobile apps (OBIEE BI MAD).
• Experience in Creating Sheets, Application, Data Model (ETL) in Qlik Sense.
• Experience to use Extensions to implement some out of the box functionality in Qlik Sense.
• Experience to use Widget in Qlik Sense.
• Experience in creating Mashups in Qlik Sense to achieve some of the complex requirement.
• Experience in handling complex security implementation in Qlik Sense, such as share application with user with read only mode and edit mode where apps are not published.
• Experience in creating Dynamic Skins for different users in a single application using External table in OBIEE 11.1.1.7.1 .
• Experience in creating Multi - Language Reports, Dashboard, and Dashboard Pages etc. in OBIEE 11.1.1.7.1 .
• Good experience in OBIEE (configuring repository (.rpd), creating Intelligent Dashboards / reports, Answers).
• Good Experience in Metadata Modelling at all three layers (Physical, Business Model and Presentation) using the Oracle BI Administration.
• Strong Experience in configuring Interactive Dashboards with drill-down capabilities using global & local Filters, Contextual Navigation, Guided Analytics, Security Setup (groups, access privileges), Metadata Objects & Web Catalog Objects (Dashboard, Folders, and Reports).
• Experience in creating Parent - Child Hierarchy.
• Experience in BI Publisher (XMLPServer).
• Experience in OBIEE Mobile APPs (worked on mobile apps after applying patch on OBIEE 11.1.1.7.1 ).
• Experienced in Data Modelling using Dimensional Data Modelling, Star Schema Modelling, Fact and Dimensions tables and Physical and Logical data modelling in the OBI Administration Tool.
• Hands on experience in customizing reports, filters and charts, maps in Oracle Answer.
• Experience in installation and configuration of Oracle BI EE 10.1.3.4.1 and OBIEE 11.1.1.5, OBIEE 11.1.1.7.1 .
• Experience in applying patches given by Oracle to solve issues raised.
• Experience in upgrading OBIEE version both in-place and out-place (From OBIEE 11.1.1.5.1 to 11.1.1.7.1 ).
• Experience in installing two OBIEE 11.1.1.5 in a same server (Windows Server 2008 R2).
• Experience in installation and configuration of OBIEE 11.1.1.5 Clustering for High Availability and Failover.
• Experience in installation and configuration of webserver (Apache) for load balancer in Oracle BI EE 11.1.1.5.
• Expertise in debugging and optimizing the Oracle BI Dashboards/ Reports.
• Experience in using OBIEE Administration Tool and Interactive Dashboards.
• Experience in providing end-to-end business intelligence solution by configuring metadata and building OBIEE Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer).
• Participated in the design, development, deployment and production support of reporting solutions that meet requirements of business users. This includes documenting the processes to ensure standards and compliance.
• Experienced in creating Intelligence Dashboards and reports based on the business requirements.
• Basic knowledge in Multi-Dimensional Database (Hyperion Essbase).
• Knowledge in Data warehousing development using ETL tools such as Informatica Power Centre 9.x and developed Informatica Mappings and Workflows using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Basic knowledge on SSIS.
• Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.
• Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS:

Familiar Languages: C, C++, JAVA, SQL

Reporting Tools: OBIEE 10.1.3.4.1, OBIEE 11.1.1.5, OBIEE 11.1.1.6, OBIEE 11.1.1.7, OBIEE 11.1.1.7.1 BI Mad, Qlik Sense 3.1.

ETL Tool: Informatica Power Center 9.x, Informatica Metadata Manager, SSISTalend

Databases: MYSQL, MS Access, ORACLE 10g/9i, SQL Server 2008, Redshift

Platforms: WINDOWS/Linux

Web Technology: HTML

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Georgia

Environment: Qlik Sense 3.1, Talend, SQL Server 2008, Redshift, Windows Server 2008 R2.

Technical Consultant

Responsibilities:

• Primary responsibilities include requirements analysis, designing the functional and technical specifications.
• Gathering requirement from Client and provide it to my team members and make them understand the requirement.
• Creating High Level Design Document, creating architecture document for the project.
• Review Low-level Design Document, Release note, Unit test case, Integration test cases, Unit test results, Integration test results.
• Resolving the issues during development phase.
• Resolving the technical issues arises during any phase of the project.
• Creating Qlik DataModel, creating ETL from Qlik Sense.
• Developing application, sheets etc.
• Implementing security using custom property and security rule.
• Implementing Share application capability without publishing apps.
• Implementing security rules based on read only and edit mode (To access an share app which is not publish).
• Creating Widgets to provide better look & feel.
• Use extensions to achieve some of the complex functionality.
• Use Mashup to achieve Out of the box requirement.
• Migrate code from Development to QA.
• Created User Training and Help document for ad hoc reporters.
• Meet with Client managers to understand their requirement and provide best solution.

Confidential

Environment: OBIEE 11.1.1.7.1, SSIS, SQL Server 2008, Windows Server 2008 R2.

Oracle Technical Consultant

Responsibilities:

• Primary responsibilities include requirements analysis, designing the functional and technical specifications.
• Gathering requirement from Client and provide it to my team members and make them understand the requirement.
• Creating High Level Design Document, creating architecture document for the project.
• Review Low-level Design Document, Release note, Unit test case, Integration test cases, Unit test results, Integration test results.
• Resolving the issues during development phase.
• Resolving the technical issues arises during any phase of the project.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin Tool.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Applied Prompts on Dashboards.
• Review Reports, Pages, Prompts etc. created by team members.
• Managed security privileges for the dashboards according to user requirements.
• Manage Security privileges for the ad-hoc analysis, in columns level, table level, and subject area wise.
• Manage Security Privileges using External Table Authentication.
• Implemented Parent - Child Hierarchy for Organization.
• Migrate code from Development to QA.
• Created groups and assigned users to the groups and granted privileges.
• Applied Optimization Techniques by interpreting Explain plan for the better performance of the reports.
• Applied Optimization Techniques by creating indexes in SQL SERVER.
• Enable application link as SSL Enabled.
• Enable application SSO Enabled (Custom SSO using JAVA).
• Use JavaScript to create different special reports like Donut Pie Charts, Organization Hierarchy etc.
• Created User Training and Help document for ad hoc reporters.
• Meet with Client managers to understand their requirement and provide best solution.

Confidential

Environment: OBIEE 11.1.1.7.1, SSIS, SQL Server 2008, Windows Server 2008 R2.

Oracle Technical Consultant

Responsibilities:

• Primary responsibilities include requirements analysis, designing the functional and technical specifications.
• Gathering requirement from Client and provide it to my team members and make them understand the requirement.
• Creating High Level Design Document, creating architecture document for the project.
• Review Low-level Design Document, Release note, Unit test case, Integration test cases, Unit test results, Integration test results.
• Resolving the issues.
• Resolving the technical issues arises during any phase of the project.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin Tool.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Applied Prompts on Dashboards.
• Review Reports, Pages, Prompts etc. created by team members.
• Manage Security Privileges using External Table Authentication.
• Implemented Parent - Child Hierarchy for Organization.
• Migrate code from Development to QA to Prod.
• Created groups and assigned users to the groups and granted privileges.
• Applied Optimization Techniques by interpreting Explain plan for the better performance of the reports.
• Applied Optimization Techniques by creating indexes in SQL SERVER.
• Created User Training and Help document for ad hoc reporters.
• Meet with Client managers to understand their requirement and provide best solution.

Confidential

Environment: OBIEE 11.1.1.7.1, SSIS, SQL Server 2008, Windows Server 2008 R2.

Oracle Technical Consultant

Responsibilities:

• Primary responsibilities include requirements analysis, designing the functional and technical specifications.
• Gathering requirement from Client and provide it to my team members and make them understand the requirement.
• Creating High Level Design Document, creating architecture document for the project.
• Review Low-level Design Document, Release note, Unit test case, Integration test cases, Unit test results, Integration test results.
• Resolving the issues during development phase.
• Resolving the technical issues arises during any phase of the project.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin Tool.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Applied Prompts on Dashboards.
• Review Reports, Pages, Prompts etc. created by team members.
• Managed security privileges for the dashboards according to user requirements.
• Manage Security privileges for the ad-hoc analysis, in columns level, table level, and subject area wise.
• Manage Security Privileges using External Table Authentication.
• Implemented Parent - Child Hierarchy for Organization.
• Migrate code from Development to QA.
• Created groups and assigned users to the groups and granted privileges.
• Applied Optimization Techniques by interpreting Explain plan for the better performance of the reports.
• Applied Optimization Techniques by creating indexes in SQL SERVER.
• Enable application link as SSL Enabled.
• Enable application SSO Enabled (Custom SSO using JAVA).
• Use JavaScript to create different special reports like Donut Pie Charts, Organization Hierarchy etc.
• Created User Training and Help document for ad hoc reporters.
• Meet with Client managers to understand their requirement and provide best solution.

Currently working on a POC in Parallel which includes Enhancement on OBIEE 11.1.1.7.1 with Multi-Language (French). Some of the users want to see their reports in French language. Eg. Promotion analysis etc. should come in French including report titles, Report Name etc.

Confidential

Environment: OBIEE 11.1.1.5, OBIEE 11.1.1.7.1, SSIS, SQL Server 2008, Windows Server 2008 R2.

Oracle Technical Consultant

Responsibilities:

• Primary responsibilities include requirements analysis, designing the functional and technical specifications.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin Tool.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Upgrade from OBIEE 11.1.1.5.1 to OBIEE 11.1.1.7.1 .
• Apply patch to show reports in internet explorer 11 and issues regarding excel import.
• Provide L2 (Technical) Support.
• Resolved tickets raised by customer.
• Resolved issues raised by customer.
• Providing usage reports to internal managers as well as customer managers.
• Migrate code from Development to QA to Production after enhancements.
• Performed Validation of the data.
• Applied Optimization Techniques by interpreting Explain plan for the better performance of the reports.
• Applied Optimization Techniques by creating indexes in SQL SERVER.
• Created User Training and Help document for ad hoc reporters.
• Provide Power User Training to the client.

Confidential

Environment: OBIEE 11.1.1.5, SSIS, SQL Server 2008, Windows Server 2008 R2.

Oracle Technical Consultant

Responsibilities:

• Primary responsibilities include requirements analysis, designing the functional and technical specifications.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin Tool.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Applied Prompts on Dashboards.
• Managed security privileges for the dashboards according to user requirements.
• Implemented Parent - Child Hierarchy for Organization.
• Migrate code from Development to QA.
• Created Batch files to take back up of production RPD and WEBCAT every day before business hours starts.
• Created Batch Files to take back up of DR RPD and WEBCAT (in DR server), copy WEBCAT from production to DR every 4 hours.
• Created groups and assigned users to the groups and granted privileges.
• Performed Unit Testing and Validation of the data.
• Applied Optimization Techniques by interpreting Explain plan for the better performance of the reports.
• Applied Optimization Techniques by creating indexes in SQL SERVER.
• Created User Training and Help document for ad hoc reporters.
• Provide Power User Training to the client (Team of 8 members).

Confidential

Environment: OBIEE 11.1.1.5, SSIS, SQL Server 2008, Windows Server 2008 R2.

Oracle Technical Consultant

Responsibilities:

• Primary responsibilities include requirements analysis, designing the functional and technical specifications.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin Tool.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Applied Prompts on Dashboards.
• Managed security privileges for the dashboards according to user requirements.
• Implemented Parent - Child Hierarchy for Organization.
• Implemented First time Password change when login for the first time.
• Implemented Write Back Feature.
• Implemented Usage Tracking.
• Coordinate with Oracle team two get the support for OBIEE 11.1.1.5.
• Installing OBIEE 11.1.1.5 in Development, QA, Production (with cluster installation in secondary server) and DR server.
• Installing two separate installation of OBIEE 11.1.1.5 in same server for business requirement.
• Installing Apache, for load balancer for High-Availability and Failover.
• Implemented custom SSO (Single Sign On only) without using any third party tool.
• Created groups and assigned users to the groups and granted privileges.
• Implemented Event Polling Table to purge cache with every update or insertion of a table in database.
• Performed Unit Testing and Validation of the data.
• Implemented Usage Metrics table in the database to capture the queries executed by users in Production environment which helped in better analysis of queries.
• Applied Optimization Techniques by interpreting Explain plan for the better performance of the reports.
• Applied Optimization Techniques by creating indexes in SQL SERVER.
• Created User Training and Help Document, upload it in the application as a link with specific access.
• Provide Power User Training to the client (Team of 8 members).

Confidential

Environment: OBIEE 11.1.1.5, Informatica 9.x, Oracle 10g, Linux.

Sr. Software

Responsibilities:

• Primary responsibilities include requirements analysis, designing the functional and technical specifications.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin Tool.
• Created Session Variables using Init Blocks and assigned date which can be use to fetch last three years EOPY data.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Applied Prompts on Dashboards.
• Managed security privileges for the dashboards according to user requirements.
• Created groups in the repository and assigned users to the groups and granted privileges.
• Performed Unit Testing and Validation of the data.
• Implemented Usage Metrics table in the database to capture the queries executed by users in Production environment which helped in better analysis of queries.
• Implemented Usage Metrics reports as per the users’ requirement (those reports and dashboard page name which are taking more than 30 seconds to fetch).
• Involved in creation of Click Streams and monitored Application Performance Testing (APC) for the OBIEE Application.
• Applied Optimization Techniques by interpreting Explain plan for the better performance of the reports.

Confidential

Environment: OBIEE 11.1.1.5, Informatica 9.x, Oracle 10g, Linux.

Sr. Software Developer

Responsibilities:

• Migration of the OBIEE reports from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.5.
• Enhancement based on the new requirements.
• Identified & Created Facts, Dimensions, and Hierarchies of the business model.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin Tool
• Created Maps which is a new feature in OBIEE 11g which allowed the end users to view the headcount data in different geographical regions.
• Created JavaScript Code to Integrate OBIEE with Outlook where it allowed the users to send mail to the people who have not completed the courses assigned to them.
• Created Reports based on conditional Navigation.
• Developed different kinds of Reports (pivots, charts, tabular, master-detail reports) using global and local Filters.
• Applied Prompts on Dashboards.
• Applied Optimization Techniques by interpreting Explain plan for the better performance of the reports
• Performed Unit & Integration Testing.
• Complete Documentation after migration.

Confidential

Environment: OBIEE 10.1.3.4.1, Informatica 8.x, Oracle 10g, Linux.

Software Developer

Responsibilities:

• Primary responsibilities include requirements analysis, designing the functional and technical specifications.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin Tool
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures in BMM layer.
• Created Session Variables using Init Blocks and assigned partition number based on roles.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Applied Multi Level Prompts on Dashboards.
• Managed security privileges for the dashboards according to user requirements.
• Created groups in the repository and assigned users to the groups and granted privileges.
• Performed Unit Testing and Validation of the data.
• Involved in Database Design of creating partition tables.
• Developed mappings to load data from multiple sources to data warehouse.