SUMMARY

• Around Nine years of experience in IT industry involving requirement analysis, design, development and implementation, reporting tools, RDBMS and Client Server applications under different environments
• In which seven years of experience in OBIEE 11.1.1.7 - 10.1.3.4 , Oracle BI Analytics 11g, Oracle BI Applications 7.9.4, Siebel Analytics 7.7,7.8.5 which include building and configuring repository, creating and managing Oracle/Siebel Intelligent Dashboards, Oracle/Siebel Answers, Oracle/Siebel Delivers and Oracle/Siebel iBots (ETL-Informatica and OWB, Reporting-Siebel Analytics, Scheduling- DAC)
• Experience in Oracle Business Intelligence e-business suite with AS400, Gemini, Active directory, SWL Server and Online systems Oracle EBS as source system along with OBIA Financials, HR Analytics Modules.
• 4+ years of Data warehouse and ETL design, build, and test experience
• Worked on OBIA Modules configuration, customizations and reporting.
• Implemented BI solutions for Confidential /BFS, Confidential, Confidential Fund services, Confidential, Confidential, Confidential Logistics, Public Service of New Mexico and other sectors for their various business processes i.e. Financial, Medicare, Marketing, Sales, Services and Customer Care, Energy etc
• Responsibility includes gathering business requirements, analysis, design, data modeling, development, Client Interaction, and Compiling Specifications from client, Modification and Testing along with Agile Methodologies
• Experience with repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports, Alerts, Briefing Books). Added Metadata changes to the OBI and deployments using Catalog Manager.
• Worked on Analytics features (i.e. SSO, Clustering, Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, MUDE, Variables/Initialization Blocks configuration etc.)
• Extracted data from various source systems like AS400, Gemini, SIEBEL CRM, Oracle EBS, PeopleSoft, Global, Seed and Aexeo Client Databases along with expertise in data warehouse concepts and data models included physical, logical and conceptual to implement data marts
• Hands on experience in ETL process using Oracle Warehouse Builder and Informatica Power Center for various transactions and loading data from disparate data sources
• Hands on Experience on integration, conversion and maintenance Support, Domain as well as Security Changes to support enterprise users
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all the ETL’s and reports that are generated from Informatica and OBI/Siebel Analytics
• Extensive experience in Oracle 8i/9i/10g SQL Server 2000, design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL
• Experience in writing UNIX shell scripts, SQL*Loader, Performance Tuning of Database
• Working Knowledge in Tableau, COGNOS and SQL SERVER
• Excellent problem solving skills with strong technical background and good inter-personal skills.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure

TECHNICAL SKILLS

Reporting/Data warehouse Tools: OBIEE Analytics 12C,11g, 10g,OWB10gR1&2 Informatica Power Center/Power Mart 10x, 9.0.1, 6.2/7.x, 8.1, SQL*Loader

Business Intelligence: OBIEE 11g, OBIEE 10.1.3.4, Siebel Analytics 7.5, 7.8

Oracle Applications: Oracle Financials E-Business suite R12/11i

Relational Databases: Oracle 8i/9i/10g/11g, SQL Server 2000/2005, MS Access

Database Languages: SQL, SQL*Plus, PL/SQL, UNIX shell scripts

Web Technologies: JSP, JDBC, Java Script.

Programming Languages: C, C++, Java, VB 6.0, PL/SQL

Operating Systems: Windows XP/2000/NT, UNIX, Linux

Scheduling Tools: DAC (Data warehouse Access Control)

Data Modeling Tools: Erwin, Power Designer, ODI

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Senior OBIA LEAD CONSULTANT

Responsibilities:

• Configuration of HR Analytics in OBIEE 11.1.1.6.8 , DAC, OBI Apps 7.9.6.3 and Informatica 9.0.1
• Designed and Developed HR Dashboards like Workforce Profile, Retention, and Compensation.
• Worked along with the business users to gather the information needed, communicated what can be provided and documented all the change requests in the Functional and Technical Documents.
• Modified Fact HR Operations (Workforce), Fact HR Event Information, Fact HR Payroll to capture monthly snapshots at various levels of dims like Employee, Employment, Organization Hierarchy, Job, Workforce Event, Pay Grade from ADP Source Database.
• Worked on Dashboard pages like Overview, Retention Hotspots, Turnover Trends and Turnover Analysis in Retention Dashboard along with Dashboard pages like Organizational Growth, Headcount analysis, Employee Trends in Workforce Profile Dashboard as well as Compensation analysis, Pay per Performance and overall compensations in Compensation Dashboard
• Designed and developed custom Dashboard Pages as well as Custom Measures like dissatisfied termination ratio, promotion ratio and Voluntary and Involuntary Terms as per business rules.
• Created custom reports to show headcounts by various dimensions like Job family, Regions, Departments and locations along with Employee detail information.
• Customized OBIA Prebuilt reports to have YTD measures like Turnover rates, Regular Terms at different levels of organization
• Tested all the data as well as the data security from end to end starting from ADP database to Reports and deliverables.
• Deployments from Stage to Prod Include Updates to RPD and Catalog along with Security Using Catalog Manager and Windows Server.
• Update S ETL DAY table to support Usage Tracking till 2020.
• Set up New Environment for OBI 11.1.1.7.0 and Upgrade existing OBIEE 11.1.1.6.8 to 11.1.1.7.0 , applying patches as well configuration and validating WebLogic Security Configuration
• Establish a trusted relationship between OHS and WebLogic servers
• Configure the OID Authentication Provider and the OSSO Identity Assertion Provider
• OBIEE Security Configuration included Configure: OBIEE System account (Replace BISystemUser),Configure: OBIEE BIAdministrator and BISystem application role membership (add service account)
• Install, Upgrade OHS 11.1.1.2.0 to 11.1.1.5.0 , redeploy and configuration of Oracle HTTP Server and WebLogic plug-in for OHS along with Checking requests being forwarded by OHS to the WebLogic server
• Configure/Register OBIEE as a Partner Application On Oracle SSO Server, and Confirm authentication into OBIEE/login to the WebLogic Console using SSO.
• Replace OID with AD Authentication and remove SSO configuration along with Updates to Catalog Objects.
• Decommission of OBI Environment/Users for Conversion to Online systems
• User Access reports are generated and reviewed for user access, role statuses along with their system access using BIP along with Dashboards are converted to SQL based reports due to Analytics Decomm.
• Analytics Downstream Impacts Due to ProEdge Oracle E-Business Suite changes include Hierarchy updates on Lochub, User Responsibilities and Conversions.
• Changes to ProEdge Field Mappings to support Ceridian Dayforce for data types, filed lengths and Identify ADP Fields to support OBI Reporting.
• Domain Changes from Confidential to BFS include AD Authentication, Folder and Access Changes.
• Providing Data Feeds both summary and transactional to Hackett Group for Customer to Cash Assessment from the legacy systems in order to support future data analysis.
• Support Enterprise Users for Future OBIA financial reporting - convert adhoc reports to query based analysis, security changes to user folders to support new domain.

Environment: OBIEE 11.1.1.6.8 , 11.1.1.7.0 , Oracle 11g, Oracle EBS, PL/SQL Developer, Windows Vista, Informatica, HPQC, Putty, Citrix, FileZilla, OBIA/BI APPS 7.9.6.3, DAC 10.1.3.4.1 , Informatica Power center 9.0.1,WebLogic 10.3.5.0, SQL Server 2005, Dayforce HCM.

Confidential, St Louis, MO

Senior OBIEE CONSULTANT

Responsibilities:

• Worked on OBIEE 10/11g version upgrades and modifying the reports for different teams: Clinical Key Reporting, Info button and CK Analytics.
• Updated Logo/ Styles as per the new Clinical Services Business Intelligence name change from Shared Services Business Intelligence in the all the Environments.
• Set up MUD and Usage Tracking along with implementing caching based on Subject Area using ODBC Functions.
• Supported their Security based on External Table Authentication, LDAP authentications for their Account based Users along with Data and object levels Security.
• Migration of RPD, Web catalog from different environments using Clear Case on Monthly Basis.
• Worked on Loading REX Source files into Amazon Web Services using Public/Private Key Authentication.
• Worked on OBIEE 11g for creating the repository and generating reports for entire Retired Expert Consult Team, which supports Inkling Vendor.
• Also developed OBIEE metadata repository using Admin Tool from physical layer to presentation along with setting up the security for the specific users of this Project.
• Created Time Period based Reports like Chapter, Ancillary, Bundle History Keywords, Visit breakdown, Activations, along with the new functionalities of OBIEE 11g mockups using MS Visio, as well as MS Office.
• Worked on Aggregate tables as well as created time series functions to registrations data for both Expert Consult/Student reporting.
• Coordinated all along the Project Working with DBA’s, Java Developers, QA and the entire team throughout the project and sort out some developmental and administrative tasks.
• Worked on OBIEE 11g for entire Customer Analytics reporting which includes hospitals and network info for entire clinical key area end to end implementation.
• Many to Many relationships were taken care with help of Opaque views and table views to report different Provider information.
• Variables for the last closed dates as per the specifications has been created and used in reporting.
• Have documented all Business as well as Technical aspects including testing all the functionality until deployed.
• Configuration of Financial Analytics in OBIEE 11.1.1.5.0 , DAC, OBI Apps 7.9.6.3 and Informatica 9.0.1
• Worked with business users to gather business requirements and provided reports in EBS Financials and Supply Chain modules.
• Designed and Developed OBIA Financial Dashboards like General Ledger, Payables, Receivables.
• Created, customized the mappings using different transformations in Informatica Power Center and ran Sessions & Workflows using Informatica Workflow manager to load the data into the Data warehouse.
• Monitored both Incremental and Full load of DAC and Informatica Workflow Monitor.
• Created AD hoc reports in Account Payables, GL and receivables and developed Dashboard pages like Finance Structure, Cash Flow and Asset Usage in General Ledger Dashboard, Trail balance, Monthly and Quarterly Balance Sheet
• Worked on Dashboard pages like Effectiveness, Invoice Details and Payment Performance in Receivables Dashboard along with Dashboard pages like Overview, Payments Due, Effectiveness and All AP Transactions in Payables Dashboard.
• Designed and developed custom Dashboards and also designed and developed Customer Interface, Auto Lockbox Interface.
• Modified Shipping INBOUND/OUTBOUND interface programs to accommodate changes in business process.
• Customized Supplier Payment History Report in Account Payables to meet client requirements.
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG’s.

Environment: OBIEE 11.1.1.7.14/11.1.1.6.12/10 g, Linux, PL/SQL Developer, Windows Vista, Informatica, Oracle EBS HPQC, Putty, AWS, clear case, FileZilla, Oracle Applications R12- General Ledger, Account Payables, Accounts Receivable, Inventory, OBIEE 11.1.1.3.0/ 11.1.1.5.0 , OBIA/BI APPS 7.9.6.3, DAC 10.1.3.4.1 , Informatica Power center 9.0.1,WebLogic 10.3.5.0.

Confidential, Jersey City, NJ

Senior OBIEE CONSULTANT

Responsibilities:

• Worked on OBIEE 10.1.3.4.1 version for creating the repository and generating reports for different Aexeo Development Warehouse and Risk Development Warehouse.
• Also developed and fine tuned OBIEE metadata repository using Admin Tool.
• Worked on the Baskets Functionality for Equities, options related Instruments at Client Vendor Broker and Fund Levels as per time series related report dates.
• Installations included Oracle Client, Oracle BI Enterprise Suite 10.3.4.1 on Windows Vista.
• Worked on Limits Functionality which would help users to see the trends for different Entities and their Gross Exposures, Soft Limit Values and Hard Limit Values along with references amounts and Result sets.
• Worked on end to end Development in RPD with Dimensional Hierarchies for Publishers, Instruments and other attributes, Variables (both session and repository) and also Logical Table Sources from different facts.
• Worked on Portfolio and Accounting Subject Area, Created users and Groups(Risk) and managed security at both RPD and Presentation Server Level.
• Used Partitioning and Fragmentation to model Fact based Partition and also used Expression Builder and Calculation Wizard to create calculation Measures like Positions related, Trading Related and Fund level Measures.
• Renamed and remapped tables/Views depending on the user for better performances in RPD.
• Designed and developed single Prompt set dashboard Pages including all the formatting and report changes as per the standards.
• Debugged issues for different business users from front to back end to identify both data and design related.
• Created Metadata dictionaries to support Users for Business needs related to Front, Middle Back Offices.
• Performed Design feasibilities to use variables and Oracle Functions in Write back Functionality to enable users to populate filter criteria by insert, update and delete Global Temp tables.
• Worked on session variables to populate the connections scripts to execute the queries depending on changes
• Participated in all Business User Meetings to discuss the requirements and design the data warehouse objects to further accomplish BI Solutions focused on Oracle BI Suite.
• Created master & work repositories and configured ODI connections for source and target systems in topology
• Monitoring the execution logs in operator along with working on Load Plans.
• Assisted in Migrating Reports and RPD From Local to Development Box and then to QA.

Environment: OBIEE10g, Oracle11g with RAC, Linux, PL/SQL Developer, Windows Vista, ODI11g, Aexeo Client Db, Jira

Confidential, Columbia, MD

Senior OBIEE CONSULTANT

Responsibilities:

• Worked on OBIEE 11.1.1.5 version for creating BI Publisher Reports for Fiscal Year 2014 under the Program End-Stage Renal Disease(ESRD).
• Worked on the Performance Score Summary and Performance Score Certification Reports for CMS in English and Spanish Languages.
• Installing Oracle BI Publisher Template Builder for Word and configuring the data model with multiple data sets along with the parameters settings for each report.
• Created Data models for the reports including the RTF Templates, defining table styles, Paragraph styles and defining Header and Footers.
• Also Adding Translations to the style templates to support Spanish translated RTF, which involved XLIFF (.xlf) files for Style Templates.
• Worked with Inserting Data fields, charts and performed calculations on fields within the template along with conditional formatting.
• Worked in both connected and disconnected modes.
• Loading Data from the sample XML files and also uploading the Layout template file to the BI Publisher Catalog.
• Used Field Browser to edit, review and update to refresh the form fields added or modified.
• Configured Report General Properties including Caching, formatting, Font mapping and Currency Formats.

Environment: OBIEE 11g., Oracle 10g, PL/SQL Developer, Windows Vista, MS Word 2007, JDK 1.5,Oracle Application Server 10.1.3.1, Explorer 7.0

Confidential, Rosemont, IL

Senior OBIEE CONSULTANT

Responsibilities:

• Worked on OBIEE 10.1.3.4.1 version for Merlin Reporting to Executives, Regional and Divisional Presidents for the Company and BI Analytics 11g for Cash GP
• Worked on three different projects involving different teams and different areas of company’s rebranding and data from different sources
• Created Dashboards, reports, offline Briefing Books and Scheduled ibots in Delivers for Executive Summary Reporting
• Worked with the feasibilities and different approaches related to GO URL’s, Guided Navigations, Aggregate Tables, Bins and Evaluate Functions based on different Time Frames
• Involved in Repository Configuration, Troubleshooting and Migrations to from all the environments (LOCAL to DEV to QA to PROD) and all three layers of RPD.
• Have done Business requirement gathering, understanding business objectives and analysis between Functionalities and feasibilities with the tool
• Involved in One on One meeting with SME to understand the business scenario and process flow.
• Used Filters (Global ) and provided customized prompts to avoid excessive data showing up in the reports
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Server Administration Tool by considering the Standards of the company
• Designed the Star Schema for all the different subject areas and build hierarchies, level-based measures, Aggregate level, Alias tables, Implicit Facts
• Used constrained filters, column filter prompts and various views such as Table View, Pivot tables, View Selector, Column selector, Chart, Narrative view
• Worked on Aggregate Tables created for different subject Areas of Pyramid Segmentation and Corp Regional Reporting ( Executive Summary)
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository and TIMESTAMP Functions in the Answers
• Worked on data from different sources and data at different levels of granularity to build the required functionality
• Performed Data Validation including both unit and regression testing of data in the reports and dashboards including the functionality based on requirements.
• Shared Knowledge in ETL processes using Informatica Power Center, PL/SQL for various transactions and loading data from various legacy data sources
• Configuring the Informatica Mappings and DAC accordingly for controlling the data set for the out-of -the box reports
• Worked with Other Teams of Reporting, Data warehouse Developers and DBA’s along with the Business Analysts and BRM’s for requirement Gatherings and Feasibilities, Standards and Trouble shooting with the Issues along with QA Teams in Agile Methodology.

Environment: OBIEE 10.1.3.4., Oracle BI Analytics 11g,Oracle 10g/11g, TOAD, SQL Developer, Windows XP, Linux.

Confidential, High Point, NC

Senior OBIEE CONSULTANT

Responsibilities:

• Installed and configured complete suite of OBIEE 10.1.3.4 on both Windows (DEV) and Linux (QA and PROD) environments.
• Designed the star schema in the data model (Physical, Business and Presentation) in the repository for Lost and Stolen Project in OLTP System by setting the Staging Tables for Reporting.
• Worked on RPD for the VZW as per the requirement changes and also with BI Answers for Reporting and Dashboards.
• Created, Copied and Moved Dashboards along with the Pages, Reports, Filters, Prompts using Catalog Manager.
• Created reports using the Pivot Tables, View Selectors, Column selectors, Guided Navigations, In-place drills in the reports, Embedding HTML links in the report columns for Dashboards.
• Worked in Creating Variables, global filters, charts, tables, global prompts. Created glossaries as a book-mark link in the reports along with combined similar requests.
• Also worked on color gauge reports on a different dashboard that helped the users to easily analyze the reports.
• Created, Edited and Scheduled BI Publisher reports as required for the Lost/Stolen Project as well as for VZW.
• Created the hierarchies, drills and level-based measures on different dimensions in the repository.
• Worked efficiently in creating the session variables and also the assigning the security groups and users. Also, worked on the data-level security to restrict the data to certain groups of users.
• Worked closely in migrating the Security Groups, Id’s, Users at the time of migration along with catalog.
• Also applied the different OBI Patches both on the Windows and Linux boxes.
• Involved in migrations of the development from DEV to QA and finally to PROD environments on both Windows and Linux boxes using the version control tool called SVN.
• Worked on performance tuning on dashboard and BI Publisher reports working closely with the database developers on indexes and tuning the data in the tables with the appropriate facts and dimension measure in the tables along with the Java Bean Based Data Extraction and validations.
• Performed Unit and Regression testing on all the reports developed to maintain consistency and efficiency to meet the user’s requirement.
• Involved in all the meetings and worked closely with the business analysts from both the client and end client (Verizon).
• Documented all the Technical Specification Documents for VZW and Lost /Stolen Projects as well as worked with analysts for the Functional Design Documentations as well.
• Used TOAD and SQL Navigator for the database queries to resolve any data issues along with the data model changes.
• Efficiently co-ordinate with the offshore team in taking the requirements between the client and team efficiently and meeting the deadlines and the deliverables on time.

Environment: OBIEE 10.1.3.4. Oracle BI Publisher, Oracle 10g, TOAD, SQL Navigator, Windows XP, Linux.

Confidential, Albuquerque, NM

OBIEE Developer

Responsibilities:

• Installed and configured OBIEE on Linux and Windows
• Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas
• Added Aggregate measures using Aggregate Persistence Wizard
• Enabled Usage Tracking Table and Dashboards
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and ToDate functions
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Siebel Application level
• Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching
• Designed Interactive Dashboards and created dashboard prompts with multiple selections
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment
• Creating new measures as well as modifying the existing measures at RPD levels
• Involved in creating dimensional hierarchies to support drill downs
• Designed and Implemented the Pre Staging and Staging approach, for cleansing using Informatica ETL and Oracle Warehouse Builder 11g
• Design and developed process for Initial loads and Ongoing loads(Incremental Aggregation with Extract Date concept)
• Developed and implemented the ETL approach from staging to target which is common irrespective of source system using Oracle warehouse Builder

Environment: Oracle Business Intelligence 10.1.3.4, Oracle 10g, Oracle Warehouse Builder 10g R2, Informatica Power center 8.1, Microsoft Windows Server 2003, SQL, PL/SQL, Linux, UNIX