SUMMARY:

• Over 12 .6 years’ of experience in full life cycle development gathering requirements, documentation, developing, designing, testing, implementing, and deployingBI Solutions and has professional experience with various industries such as Retails, Manufacturing, Pharmaceuticals, Mortgage & Finance, and Telecom.
• Worked extensively in Implementation of OBIEE and OBIEE Admin end to end.
• 9.6 Years of experience working with Oracle Business Intelligence (OBIEE), OBIEE Admin, Analytics, EM, Web logic Console
• About 3 years of experience working with Micro strategy tools like Micro Strategy Desktop, Web, Intelligence Server, OLAP Services, Report Services, Command Manager, and Administration
• Working with Tableau Desktop and Tableau Servers and Admin
• Very good Knowledge in Oracle BI Apps like Financials, Procurement & Spend, Supply Chain, Oracle Process Manufacturing
• Experience in Oracle BI Metadata Repository (RPD) and Web Catalog deployment activities
• Ability to restart the services from putty as well as from web logic console and EM.
• Experience in creating users and giving privileges and adding custom skins to the landing pages.
• Strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill - down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and expertise in implementing the Security in OBIEE
• Expertise in using Micro Strategy 9/8.x/7i/7.x product suites including MicroStrategy Desktop, Web, Architect, OLAP Services, Administrator, Intelligence Server, Narrowcast Server.
• Expertise in Creating Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
• Expertise in Developing Application Objects (filters, prompts, metrics, Custom Groups, Consolidations, DrillMaps, Templates, Searches) to develop Documents and reports.
• Expertise in creating Hyper Links in Documents and Drill Reports.
• Expertise in using Administration tools like Object Manager and Command Manager.

TECHNICAL SKILLS:

Business Intelligence: OBIEE 11.1.1.9.0, Micro Strategy 9/8.1. (Micro Strategy Desktop, Web, IntelligenceServer, OLAP Services, Report Services, Command Manager, Administration), Business Objects XIR2/6.5, Tableau Cognos, Hyperion

ETL: Informatica Power Center Designer 7.x/ 6.x, Workflow manager and Apex Data loader, ODI, Data Stage, Pentaho, OBIApps 10G/11G, DAC

Languages: SQL, PL/SQL, C, ASP.Net, JSP.Net, SDK, XML. Basic Java

Development Tools: Oracle Developer 2000 (Forms 6i & Reports), SQL*Plus, Erwin, SQL*Loader, TOAD

O/S: Windows XP/2000/NT/98, UNIX, Linux, MS-DOS

Database: Oracle 11.2, 10G, MS SQL Server 2000/2005, Netezza 5.0, DB2, Teradata, Essbase, Hadoop, Salesforce, SAP HANA

PROFESSIONAL EXPERIENCE:

Confidential, MD

OBIEE Architect / Developer

Responsibilities:

• Directly coordinating with user to gather the requirements.
• Developed RPD creation by including all the functional requirements and Working extensively in Answers and Dashboards.
• Created hierarchies in business model and Designed different views view Selector, Legend, and MAP viewer
• Developed different brand level reports, filters, and prompts by using web.
• Develop and implement strategies, policies and standards for OBIEE administration solutions in the enterprise
• Perform testing sessions for reports and dashboards and resolve process issues (if any)
• Evaluate and set strategies to implement infrastructure and application changes in OBIEE system and processes
• Prepare documentation and communicate the status of the project to the management
• Creating Users, Groups and assigning roles as per security requirements.
• ODI Designer is used for reverse engineering tables from database to develop projects, and release scenarios.
• Created ODI (Sunopsis) interfaces for loading the data from Source System to DW and from DW to different Data mart.
• Deploying RPD and Web Catalog and Supports monthly schedule activities for moving the code from Dev to stage and Production.
• Inserting new Users and modifying the existing Users access by using the LDAP authentication.
• Creating hierarchies in business model and Worked extensively in Answers and Dashboards.
• Created the requests and view the results in different views like table, compound layout, chart and pivot table.

Environment: OBIEE11.1.1.7, Oracle11.2, EM, Web logic Console, Windows NT,ODI, Control-M Changes

Confidential, NJ

OBIEE Architect

Responsibilities:

• Directly coordinating with user to gather the requirements.
• OBIEE report and dashboards are generated by using sales force as the data source system
• Request business intelligence information via the Oracle BI user interfaces.
• Creating Users, Groups and assigning roles as per security requirements.
• Raising and tracking Service Requests with Confidential on OBIEE issues.
• Deploying RPD and Web Catalog.
• Created Hyperion Business Rules (HBR), Calc Scripts, Report Scripts, Security for HBR’s—Global Security Filters and Web forms. Salary script based on Headcounts and Rundown unit’s calculation, cost of sales were few of HBR’s.
• Developed the reporting framework using for wide range of users as per the requirements using Excel Add-In Templates, Hyperion Reports and Hyperion Performance.
• Created ODI (Sunopsis) interfaces for loading the data from Source System to DW and from DW to different Datamart.
• Developed and tuned customized complex PL/SQL procedures based on client requirement. Tuned procedures to improve overall system performance and Wrote complex SQL queries and PL/SQL code to implement business logic and Created database schema, tables, Views and triggers
• ODI Designer is used for reverse engineering tables from database to develop projects, and release scenarios.
• Analyze Design, Development and Testing of Data warehousing applications using ETL and Reporting tools and generated Tableau Dashboards Implementing Quick/Context filters, Parameters
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in tableau and Administered user, user groups, and scheduled instances for reports in Tableau.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
• ODI Interfaces successfully created and deployed to DW and ODI designer used to create refresh variables to use in ODI packages and ODI designer used to create refresh variables to use in ODI packages.
• Loaded metadata and data from Oracle to Hyperion essbase using ODI interfaces. And Unit testing Hyperion data using Excel add ins.
• Inserting new Users and modifying the existing Users access by using the LDAP authentication.
• Worked on Fragmentation at RPD level and Complex SQL and PL/SQL with strong performance tuning capability
• Provide support in the implementation of OBIEE components and Install, upgrade and configure all components of OBIEE
• Assist and administer the deployment process of UNIX, OBIEE and repository codes and Train the administration team on new OBIEE and ETL tools

Environment: OBIEE 12c EM, Web logic Console, ODI12c, Windows NT, Hyperion, PLSQL, Tableau desktop 8 Oracle BI Publisher

Confidential, NC

Technical Lead /Admin

Responsibilities:

• Creating Users, Groups and assigning roles as per security requirements.
• Raising and tracking Service Requests with Confidential on OBIEE issues.
• Created rules files to load new currencies, built currency dimension, created calculation scripts for data export from one cube to another
• Created highly complex financial reports using multiple grids and conditional formatting using financial reporting studio
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through trigger and Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance
• Deploying RPD and Web Catalog and Integrating a single sign-on (SSO) solution enables a user to log on (sign-on) and be authenticated once
• Analyzing the specifications provided by the Business user and Understanding Business Data.
• ODI Designer is used for reverse engineering tables from database to develop projects, and release scenarios. And Assisting in Developing of Dimensions and Facts for the Data Warehouse.
• Coordinate ETL team for the Production data issue and mapping failures.
• Developed RPD creation by including all the functional requirements and Working extensively in Answers and Dashboards.
• Created the requests and view the results in different views like table, compound layout, chart and pivot table and Developing different brand level reports, filters, and prompts by using web.
• Provide support in the implementation of OBIEE components and Install, upgrade and configure all components of OBIEE
• Assess production faults and critical issues followed by identification of the root cause and Provide remedial measures to the production issues or process failure

Environment: OBIEE 12c, Oracle Essbase, EM, Web logic Console, ODI12c, DAC, Windows NT, SingleSignOn Authentication, Hyperion Financial Reporting 11,PL SQL. Oracle BI publisher

Confidential, NY

Sr. OBIEE Lead Developer/ Admin

Responsibilities:

• OBIEE repository created based on Sales force data
• Use the Salesforce.com odbc Driver to connect Oracle Business Intelligence Enterprise Edition (OBIEE) to Salesforce.com
• Created ODI (Data Integration) design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages
• Installed and configured ODI for full loads and Incremental loads daily.
• Experience in Failure analysis for ODI loads using Operator logs and Used Oracle Data Integration ODI for Extraction, Loading and Transformation
• Developed Unix Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Extensively used SQL & PL/SQL in reports and Cardinalities and Joins were used and Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables
• Creating Users, Groups and assigning roles as per security requirements and Raising and tracking Service Requests with Confidential on OBIEE issues and Deploying RPD and Web Catalog.
• Supports monthly schedule activities for moving the code from Dev to stage and Production.
• Responsible for source system analysis, data transformation, data loading and data validation from source systems to Data warehouse Applications.
• Involved in Control-M Changes for the job insertion and monitor the workflows.
• Developed RPD creation by including all the functional requirements.
• Inserting new Users and modifying the existing Users access by using the LDAP authentication and creating hierarchies in business model and Designed different views view Selector, Legend, and MAP viewer. Working extensively in Answers and Dashboards.
• Complex SQL and PL/SQL with strong performance tuning capability
• Provide support in the implementation of OBIEE components and Assist the teams in generating dashboards and reports properly
• Designs and develops Teradata data structures based on reporting requirements.
• Utilizes presentation layer mock-up software to effectively visualize and demonstrate proposed user interface dashboard and scorecard solutions in order to gain buy-in on requirements.
• Actively participates in and influences discussions around reporting requirements, infrastructure needs, and design with matrix partners.

Environment: OBIEE 12c, Oracle Essbase, EM, Web logic Console, ODI 12c, DAC, Windows NT, SingleSignOn Authentication, PL SQL

Confidential

Sr. Developer/ Admin

Responsibilities:

• Directly coordinating with user to gather the requirements.
• Develop and implement strategies, policies and standards for OBIEE administration solutions in the enterprise
• Ensure that designing, recovery and implementation of an OBIEE suite is carried out effectively
• Perform testing sessions for reports and dashboards and resolve process issues (if any)
• Evaluate and set strategies to implement infrastructure and application changes in OBIEE system and processes
• Research and remain abreast with latest technologies and techniques to recommend new changes or up gradations
• Evaluated existing MDM standards against industry practices
• Worked with Informatica ETL team members for getting data into Landing table and configure the Informatica MDM Hub to support staging, loading, cleansing, matching, merging, and publication of MDM data
• Prepare documentation and communicate the status of the project to the management
• Perform other administrative duties related to OBIEE as and when assigned
• Creating Users, Groups and assigning roles as per security requirements.
• Deploying RPD and Web Catalog and Supports monthly schedule activities for moving the code from Dev to stage and Production.
• Developed RPD creation by including all the functional requirements.
• Inserting new Users and modifying the existing Users access by using the LDAP authentication.
• Creating hierarchies in business model and Worked extensively in Answers and Dashboards.
• Created the requests and view the results in different views like table, compound layout, chart and pivot table.
• Developing different brand level reports, filters, and prompts by using web.
• Performing the Unit and UAT testing.

Environment: OBIEE11.1.1.7, Teradata, Oracle11.2, EM, Web logic Console, Windows NT, Informatica MDM Control-M Changes, Customer 360 data

Confidential, OH

Sr OBIEE Developer and Admin

Responsibilities:

• Deployed Custom images help links, View.css files and common.css files.
• Supports monthly schedule activities for moving the code from dev to stage and production.
• Configured usage tracking which would help to track the applications usage.
• Inserting new Users and modifying the existing user’s access by using the External table authentication and creating hierarchies in business model.
• Developed workflows to data domains for performing data extraction, data validation, data cleansing, data match, data load, exception handling and required data related activities to support Customer's MDM requirements
• Working extensively in Answers and Dashboards.
• Closely worked with Data Steward Team for designing, documenting, training and configuring Informatica Data Director for supporting management of MDM data
• Created the requests and view the results in different views like table, compound layout, chart and pivot table and Developing different brand level reports, filters, and prompts by using web.
• Performing the Unit and Integration testing and Created Init Blocks and variables to implement Security at RPD level.
• Worked on 24/7 support during the quarter close and Worked on Fragmentation at RPD level.

Environment: OBIEE11.1.1.6, Oracle10G, EM, Web logic Console, Windows XP, Informatica MDM, Customer 360 data

Confidential, New Jersey

Sr. Microstrategy Developer

Responsibilities:

• Worked with client to gather requirements and prepared technical specifications Documents.
• Involved in design of proto type of reports based on requirements.
• Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis
• Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports..
• Involved in Creating Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the micro strategy objects necessary for the deliverable.
• Involved in Defining Logical Views to get data through queries from self-joined tables.
• Created Relation Ship tables to avoid Many-Many relationship between parent and child attributes.
• Involved in creation Aggregate tables to improve performance of reports
• Involved in moving the objects between two projects and two different environments by using Object Manager and merging the projects by using Project Merge Wizard.
• Involved in Developing Reports by using Free Form SQL Queries in micro Strategy Desktop.
• Create a test plan, perform unit test and send the test plan along with the files generated for QA.
• Training the users how to use micro strategy for their business analysis.

Environment: Microstrategy 8.1.1, Desktop Reports, Web Intelligence Reports, Oracle 10g, Windows 2000

Confidential, New Jersey

Microstrategy Developer

Responsibilities:

• Worked with client to gather requirements and prepared technical specifications Documents
• Involved in design of proto type of reports based on requirements.
• Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis
• Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports.
• Creating Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, reports) needed to create the Micro strategy objects necessary for the deliverable.
• Architected the projects and created all the necessary schema, application and configuration objects.
• Created transformational metrics (Sales, Sales Target, Market Share, and Growth) to compare monthly, quarterly and annual sales.
• Involved in creating Security filters to end users to access data Based on their privileges..
• Involved in Developing Reports by using Freeform SQL Queries in Micro Strategy Desktop
• Involved in migration of Schema Objects (facts, attributes, hierarchies, Transformations), Application Objects (filters, prompts, metrics, consolidation, custom groups), user groups from 8.0.2 to 8.1.1.
• Involved in optimization of code and tuning queries for performance.
• Provided post production support to end-users.

Environment: Micro strategy 8.0.2/8.1.1, Desktop Reports, Web Intelligence Reports, UNIX, Toad, Excel, Oracle 10g, Windows 2000.