SUMMARY:

• ORACLE knowledge/analytics CONSULTANT
• Expert Analyst in Oracle Knowledge/Analytics Strategies
• Knowledge specialist whose qualifications include a degree in computer science; expert knowledge of Oracle Knowledge Management/ Analytics; OCP and Brainbench designations; and detailed knowledge of ETL tools like Informatica, Ab - Initio, Oracle Data Integrator and Datastage, Reporting tools like Business Objects, OBIEE, BI Publisher and Cognos, PL/SQL and data warehousing best practices

KEY SKILLS:

• Oracle Knowledge Management
• Content management
• Taxonomies
• Answer Flow
• Search Tuning
• Information Manager/ Information Console
• Event Routers
• Staging/Reporting Layer ofAnalytics

TECHNICAL SKILLS:

Data Warehousing Technologies: SQL Loader, Oracle Data Pump, PL/SQL, Informatica, Ab-initio, Datastage, Business Objects, OBIEE, Cognos

Systems: Unix-Based Systems (Solaris, Linux, BSD); Windows (all)

Networking: LANs, WANs, VPNs, Routers, Firewalls, TCP/IP

Software: MS Office (Word, Excel, Outlook, Access, PowerPoint)

Databases: Oracle(8i/9i,10g,11g), SQL Server (2000,2005), DB2

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Oracle Knowledge Analyst

Responsibilities:

• Actively involved in requirements gathering, design, development, testing and post go-live support for Oracle knowledge management.
• Set up different channels in Information Manager (IM) for crawling content like alerts, concept, contacts, FAQ, glossary, letters, marketing, procedure, reference and tools.
• Defined task sets/jobs for crawling IM data at periodic intervals and created schedules for the jobs as needed - IM- Crawl (Daily, Weekly, Full, Incremental, Manual), Mark and Sync, and Classification.
• Scheduled full index scans and incremental index scans to make sure all documents and changes have been captured.
• Created shared library for overcoming issues due to version difference of some jars used in Oracle Knowledge code and those present in WebSphere installation and linked the library to Search.
• Worked with all IM repository elements like channels, users, roles, content creation templates, meta-tags, workflows and locale configurations, etc.
• Worked on content workflow and alert workflow to ensure content accuracy and continuity after the content is ready to be published.
• Created processes, sub-processes, service calls(web service calls) using AnswerFlow Editor and worked with deployment operations of AnswerFlow like submit, compile and promote objects.
• Understood the client requirements and designed/developed processes in AnswerFlow based on different conditions that varied on factors such as account status, location, or specific product or model.
• Worked with OKM Dictionary Tool to provide Navigation structures, Search filter categories, enterprise-wide categories, Synonym rings and Search strategies.
• Work with team to develop multilingual approach for taxonomy development, content architecture, and search tuning activities.
• Created and managed concepts, clusters, intent responses, rules, and relationships using Oracle Knowledge Management - InQuira (OKM) software.
• Tuned the use of NLP (Natural Language Processing) capabilities to optimize search and worked with advanced search engine configuration and ranking strategies.
• Conducted end-user focus groups for the purposes of gaining user insight into search relevancy, search preferences, and mental models
• Monitored the execution of ODI Agent and stopped/started the ODI Agent as needed.
• Manually executed the Oracle Reprocess and Oracle Knowledge Main packages in ODI for processing the data warehouse load from staging tables.
• Worked with DW STAGE, DW REPORTING, IM schemas and wrote several SQL queries on the database to analyze data and any issues with data.
• Created ODI interface and package to capture and load User level information associated with questions being asked in Info Manager.
• Used OOTB Oracle Knowledge Analytics RPD in OBIEE as well as customized the RPD to meet the reporting needs with new reporting requests.
• Performed changes in OBIEE RPD as needed and deployed the RPD for ad-hoc reporting.
• Worked with fact and dimension tables related to Questions, Case, Content, Recommendations, Users and Workflow.
• Created several reports using OOTB/Customized OBIEE RPD like Advanced Question Analysis, Advanced Question Answer Analysis, etc.

Confidential, Suwanee, GA

Oracle Knowledge Consultant

Responsibilities:

• Interacted constantly with developers, managers, functional consultants, users and gathered requirements for the Oracle Knowledge implementation that needed to be done.
• Worked with the Oracle Knowledge Analytics OBIEE RPD and created new reports /dashboards / metrics for meeting reporting needs.
• Monitored and troubleshooted issues with ODI Agent and the data load from staging to data warehouse.
• Worked with different ODI knowledge modules like RKM, LKM, JKM, IKM, CKM and SKM and used them to created models/business rules/interfaces /procedures/packages as needed.
• Created new interfaces and packages in ODI that pull data from DW STG DATA in DW STAGE schema and load data into custom facts in DW REPORTING schema, created to meet specific client requirements.
• Set up email notifications for data loads processed using ODI to receive automatic email alerts to the specified email list using the SMTP configured email.
• Queried the ANALYTICS PROPERTIES table to analyze the existing batch date, batch size, and other parameters related to the data load.
• Analyzed the data volume to be processed in terms of events per day by querying staging data using datekey.
• Recommended the best practices and changes to the physical layer, Business Model and Mapping Layer and Presentation Layer in an OBIEE Repository as per the classification of data needed.
• Worked with delivered or OOTB fact tables - FACT QUESTNS, FACT CONTENT, FACT RESPONSE, FACT WORKFLOW FACT RECOMMENDATIONS, etc and dimension tables - DIM CHANNEL, DIM QUESTN, DIM USR, DIM USR GROUP, etc and created metrics/measures in OBIEE RPD using these tables.
• Administered security in OBIEE and setup groups, roles, access privileges and direct database request privileges.

Confidential, Atlanta, GA

Sr. OBIEE/ETL Developer

Responsibilities:

• Interacted with stakeholders and executive team to gather business requirements for their reporting needs and translated them into functional requirements documents and took the tasks to completion driving the technical team.
• Worked with the OBIA Financial Analytics Suite using OBIEE 11.1.1.6.2 and customized the dashboards and metrics for reporting.
• Conducted data investigations and assisted the business partners with complex data analysis and ad-hoc queries
• Designed, documented and tested logical and physical data models optimized for operational and analytical reporting
• Created Income Statements and Balance Sheet reports from GL, Top 10 supplier and Invoice reports from AP, Aging Reports from AR.
• Created reports like Advanced Knowledge Analysis, Advanced Question Analysis Summary, Article Aging, Article Ratings Detail/Summary, Recommendation Detail/Summary, Popular Answers, Popular Questions in Oracle Knowledge management Analytics using OBIEE.
• Proposed long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders
• Used BI Publisher and created complex pivot table reports and cross tabular reports using connected queries of data models with parameters passed from data model as well as parameters.
• Performed the changes to the physical layer, Business Model and Mapping Layer and Presentation Layer in an OBIEE Repository for all new objects that needed to be added.
• Started/Stopped BI and Weblogic Servers using OPMNCTL commands and also start/stop shell script.
• Performed security administration for the entire organization, mapping Peoplesoft roles and LDAP configuration and Weblogic roles.
• Used various templates in BI Publisher to publish the reports as per user requirements.
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Performed tuning on OBI Apps system by creating materialized views and using partitioning, compression and aggregation techniques with a combination of bitmap indexes and gathering statistics.
• Customized the Oracle stored procedures to aggregate the data into different metrics based on Business Unit using PL/SQL.
• Extensive expertise in using both connected and unconnected Lookup Transformations in Informatica.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 11g in accordance with requirements and specifications using Informatica ETL.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Worked with DAC and customized execution plans to load new fact tables/dimensions or change existing order of load for loading custom data from third-party systems.
• Presented demo sessions of the BI tool in many offsite locations of the client and won appreciation from the executive teams.
• Reconciled the data in the reports to tie numbers back to PeopleSoft which was the system of record.
• Conducted thorough Unit Testing, System Integration testing, UAT, MTP and Production Support Co-ordination effectively.
• Possess in-depth understanding of Data Warehouse Concepts, ETL Tools, Reporting Tools, Job Scheduling Tools and Operating Systems.
• Effectively communicated and collaborated with cross-functional business partners and made them love the flexibility the OBIEE tool has to offer.

Confidential, New York, NY

Data Warehouse Reports Developer

Responsibilities:

• Worked in the role of a reporting analyst helping the business and technology team perform the implementation
• Actively involved in Data Warehouse modeling which included fact table re-design, dimension table re-design changes based on the reporting requirements
• Involved in requirements gathering, designing functional and technical specifications to create reports.
• Reverse engineered Jd Edwards Financials reports and re-engineered them in OBIEE/BI Publisher.
• Interacted with Systems Engineering team to design - Facts & Dimensions for Repository.
• Extensively worked with OBIEE to build Physical Model, Business Model and presentation layer and established relationships.
• Created and administered the physical layer, Business Model and Mapping Layer and Presentation Layer in an OBIEE Repository using OBIEE Administration tool.
• Included Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges.
• Implemented Level based dimensional hierarchies and also handled ragged hierarchies.
• Used various templates in BI Publisher to publish the reports as per user requirements.
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Extensively used page prompts and dashboard prompts and laid best practices for using common prompts instead of creating new ones all the time.
• Created Agents to generate alerts and delivered it to target users.
• Conducted thorough Unit Testing, System Integration testing, UAT, MTP and Production Support Co-ordination effectively.
• Analyzed the performance bottlenecks in the systems using explain plans and created bitmap indexes and partitions to allow for better performance.
• Possess in-depth understanding of Data Warehouse Concepts, ETL Tools, Reporting Tools, Job Scheduling Tools and Operating Systems.
• Managed effective co-ordination between the onsite and offshore teams ensuring a proper handshake between them.
• Worked on the OBIEE latest version of 11.1.1.6 and experimented a lot of new features within the tool.

Confidential, New York, NY

Data Warehouse Analyst

Responsibilities:

• Acted as an analyst for gathering the business requirements and ensuring quality of the deliverables along with deadlines for them.
• Worked with third party systems and resolved data quality issues from third party systems into PeopleSoft Financials/EPM Data Warehouse.
• Upgraded RPD, Web Catalogs (Answers, Dashboards) from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.5 using upgrade assistant utility (Oracle Fusion Middleware Upgrade Wizard).
• Created a multi-User development environment (MUDE) utilizing projects.
• Developed Use Cases, test cases, test plan documents as needed and updated them frequently as changes were needed and coordinated with the technology team ensuring that requirements were clearly met.
• Worked in Agile Methodology performing tasks via an iterative approach with a sprint length of 4 weeks.
• Laid out specs for reports like Profitability Analysis Reports by segment, operating units, reginal areas, Voucher Matching Exceptions, Ledger Balances, to be developed from GL & Profitability, Accounts Payable and Accounts Receivables Data Marts.
• Worked on drilldown and rollup reports using OBIEE Dashboards and Answers.
• Involved in acquiring continuous feedback from all teams and helped in system study, analysis, design, coding, testing and debugging of software, UAT and Quality Assurance tasks and assisted in the training for users.

Confidential, New York, NY

OBIEE Reporting Analyst

Responsibilities:

• Involved in system study, analysis, design, coding, testing and debugging of software, UAT and Quality Assurance tasks, implementation and training for users.
• Worked on upgrading OBIEE 10 g to 11g.
• Created custom Reports in Usage tracking reports like User Acceleration.
• Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations.
• Worked closely with Oracle in resolving the bugs related to product.
• Worked extensively in Oracle BI Security, Web Object Security and Data Level Security.
• Effectively managed migration of RPD and presentation catalog changes across environments through catalog manager
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, Supply Chain and Order Management Analytics for the reports.
• Made security grids to enable/disable user access to certain reports, report folders and designed row-level security for the data as needed
• Ensured restricted, confidential and sensitive access to data with the design of a solid security architecture
• Designed logical reporting data model to be used for developing the RPD, which acted as the base for further development of canned and on-demand reports using OBIEE Answers
• Worked under High Pressure situations and got things done way below the deadlines.

Confidential, New York, NY

Senior OBIEE Developer

Responsibilities:

• Captured the business requirements from Finance and HR users from different countries and detailed the functional and technical specifications for handling the Initiative.
• Designed specs to modify ETL maps as necessary to extract GL, AP, AR, Billing and Project Costing data from FMS & Workforce Profile, Benefits, Compensation and Payroll data from HCM
• Conducted discussions with reporting team and designed specs for OBIEE dashboards and reports to help evaluate costs per vehicle, analyze profit/loss by segment/area/quarter/year and check leave accrual history/FMLA balances.
• Developed and coded a number of DB objects: Stored Procedures, Triggers, Functions, Materialized Views, DB Links, Bitmap indexes and Partitioning strategies.
• Made use of BI Publisher to re-design report layouts in MS-Word. Created Data Model, Parameters and LOV in the templates. Uploaded and used templates on dashboard reports.
• Defined the hierarchical reporting relationships using the tree manager and tree flattening processes.
• Prepared security matrices, designed security architecture and implemented row-level security at OBIEE and Peoplesoft level
• Ensured restricted, confidential and sensitive access to data with the design of a solid security architecture
• Designed reporting data model also called as RPD, which acted as the base for developing canned as well as ad-hoc reports using OBIEE Answers

Confidential, Tampa, FL

Data Warehouse Application Developer

Responsibilities:

• Captured the business requirements from Finance, HR and Equity users from different countries and detailed the functional and technical specifications for handling the Equity Compensation Strategic Initiative, that dealt with the employee-related compensation of stocks and its derivatives as a part of the ESPP.
• Involved in system study, analysis, design, coding, testing and debugging of software, implementation and training for users.
• Designed & developed proof-of-concept solutions addressing business requirements.
• Designed and developed several ETL processes using Workflows, tasks, mapplets and worklets.
• Developed Stored Procedures & Functions and Packages, Complex Joins, Analytic & Aggregate functions and efficient Exception Handling techniques.
• Implemented various Tuning methods like Analyzing the tables, using hints, DBMS Profiler, SQL Trace, Explain Plan and used Bulk Collect feature, FORALL statements, Oracle Partitioning, Materialized Views to improve performance in insert and update statements, etc to improve the performance of the application.
• Developed an Enterprise Security Model for different HR, Finance and Equity coordinators that provides row-level security to sensitive and confidential information and restricts access accordingly.
• Defined the logical data model/ universe for Business Objects by defining the classes under which each business object/data element has to fall under and following the naming conventions set forth by the business.
• Built complex dashboards and reporting solutions using BO Web Intelligence and forwarded the reports to the users’ inboxes for their initial review/testing.
• Translated the business requirements into functional requirements with the support of other team members and documented them as per the traceability matrix guidelines.
• Created an XML Publisher Report that generated a Citi Standard Services Agreement document for which the data is populated from user input into a pre-defined template.
• Designed a standard outbound feed to all the target systems to ensure Citi Best in Class standards are followed.
• Structured the physical and logical data models for OBIEE, assisted in the definition of RPD and worked with OBIEE Dimensional and Repository Modeling
• Developed custom reports for service providers, customers, corporate tax and KPMG using OBIEE tools like BI Answers, Presentation Services and BI Publisher
• Used XML/BI Publisher for Multi language reporting purpose.
• Laid out technical specification documents for Abinitio graphs, Peoplesoft programs and OBIEE reports
• Worked on dimensional hierarchies to enable drill down capabilities.
• Developed trends dashboard to show booking trends like Current Quarter allocations Vs previous year Current Quarter allocations.
• Extensive implementation work on BI Answers to create the reports as per the client requirements. Used session and repository variables to control access and data, filters to restrict data.
• Made use of BI Publisher to re-design report layouts in MS-Word. Created Data Model, Parameters and LOV in the templates. Uploaded and used templates on dashboard reports.
• Performed OBIEE performance tuning like use index hints to tune the SQL statements.
• Involved in the full life cycle implementation of Invoices Tracking Analytics Application used by Accounting Team to monitor the invoices made to Point-of-Sale (POS) customers, Commercial / Business customers and third-parties.
• Interacted with Billing and Account Receivables Subject Matter Experts (SME), Stake Holders, Business Analysts and Key Business Users in gathering the Analytics / Reports Requirements.
• Participated in the installation and configuration of Oracle BI EE 10.x in the windows as well as the Linux environment.
• Attended meetings with ETL Team for enhancement to Facts / Dimensions in developing the Initial and Incremental ETL process.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.
• Created Dashboards / Reports using different Views (Pivot Table, Chart and Column Selector), with drill-down and drill across capabilities, guided navigation and dashboard and page prompts.
• Performance Tuning using optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes.

Confidential, Columbus, OH

Siebel Analytics Developer

Responsibilities:

• Worked with the Physical layer to create joins between tables to build star schema. Created aliases for tables in the physical layer for analytics requirements.
• Worked extensively with BMM layer to develop various business models.
• Created dimensional hierarchies and assigned levels and custom aggregation rules for each level.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Created various aggregate tables to improve the query performance.
• Created dashboards using analytics requests and assign Permissions to dashboards depending on their user group.
• Used the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges and logging levels.
• Configured iBots using Siebel delivers to alert the management and sales teams regarding data consistency issues.
• Converted the business requirements into technical specifications for ETL process populating the fact and dimension tables of data warehouse.