[var] => cut_url
<pre>Array ( [var] => cut_url ) </pre> Resume for Vijay S. for Consultant / Computer Software in Chantilly, Virginia. Search More Resumes for Consultant on #IQ5GAIKI3

Search Resumes

Post Jobs

Job Seekers:
Post Your Resume


Resume for Vijay S. for Consultant / Computer Software in Chantilly, Virginia

Occupation: Consultant Industry: Computer Software
Country: United States City: Chantilly
State: Virginia ZIP: 20151

View Complete Resume   Download Resume [
    [name] => cut_url
Share Share

< Back to search results Preview: For the complete resume and contact info please download it.

    [var] => content
    [type] => preview
    [var] => cut_url



Experience Summary

  • Over years of effective experience in Complete Software development Life cycle SDLC which includes Business Requirements Gathering, System Analysis & Design, Data Modeling, Development, Testing and Implementation of Data warehouse and Business Intelligence Applications.
  • Implemented BI solutions in various domains such as Oracle Financial, Sales, Human Resources and Health Care and worked on end to end implementation of BI APPS which include OBIEE, INFORMATICA and DAC.
  • Good experience in installing, configuring of OBIEE/Siebel Analytics, Informatica, Oracle g and DAC.
  • Implemented Oracle PreBuilts implementation BI Apps for various modules like Sales, Finance, Order Management and HR analytics in with integrating the ERP Systems like Oracle EBS, PeopleSoft and Siebel.
  • Extensive experience in building business models & analytical repository RPD configuring Metadata, Answers, Delivers / iBots, developing dynamic & Interactive Dashboards with drilldown & drillacross capabilities, Security Setup, and Web Catalog Objects using Oracle Business Intelligence.
  • Strong understanding of data warehousing concepts, dimensional modeling, designing Star and Snowflake schemas.
  • Implemented different Caching techniques to improve the performance of BI server and performance tuning were done at Database level, Repository level and Dashboard level to improve the efficiency of the system.
  • Developed and scheduled I Bots using BI delivers to deliver Analytics content based on schedule, automated IBot queries to obtain daily and weekly reports.
  • Configured and installed BI Publisher and integrated with OBIEE server and created Smart View Report Templates.
  • Implemented and extensively worked in Multi User Development MUDE and performed some Administration tasks such as Creating users, groups, Projects and provide required authentication as needed.
  • Expertise in Oracle SQL and database Performance Tuning by implementing Parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding indexes.
  • Implemented Security by creating roles & web groups using LDAP Authentication
  • Experience in ETL methodology for supporting Data Extraction, Loading and Transformation processing using prestaging, staging approach in Informatica Power Center and Power Mart.
  • Experienced in Data warehouse Administration Console DAC to Configure, Monitor and Schedule ETL routines of Full and Incremental ETL loads of the Oracle Business Analytics Warehouse.
  • Good experience in UNIX and writing shell scripts for execution of the work flows and scheduling the tasks.
  • Great communicator and diligent team member with strong technical background and good interpersonal skills.


    Bachelors: Electricals and Computer Engineering. 


    BI Tools OBIEE ...x, Siebel Analytics ././ ,Oracle BI Apps ..x.
    ETL Informatica Power Center ..x/..x/.x.
    Scheduling tools Data Ware Administration Console DAC
    Operating Skills  UNIX scripting, Linux, Windows.
    Tools Toad, SQL Developer.
    Web Tools HTML, DHTML, ASP, JSP, XML, Web Portals.
    Databases Oracle g, g/i, Oracle EBS, PeopleSoft.
    Dimensional Data Modeling Star Schema Modeling, SnowFlake Schema Modeling

    Professional Experience 

    Sony Ericsson, NC                                                                   Mar’Till Date

    Sr. OBIEE Consultant

    Sony Ericsson Mobile Communications is one of the leading cellular companies.  The project provides Oracle Financial and Sales Analytics solution implemented with BI Apps. It helped the company to enhance decision making process regarding the GSM products and customers. The system will allow users to perform data analysis and track customers and their details through reports developed from OBIEE. 


  • Used the OBIEE ...x, OBIEE Administration tool to develop and enhance metadata.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
  • Configured and Created repository using OBIEE Admin tool.
  • Worked extensively with Physical Layer, Business Layer and Presentation Layer.
  • Created numerous executive level reports. ‘Dashboards’ were generated to provide insight into the sales/marketing/financial data.
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
  • Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
  • Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
  • Created business reports using BI Answers as per requirements.
  • Monitoring Incremental & Full load through DAC.
  • Maintaining the Full and Incremental loads through DAC on different environments like Development and Test environment.
  • Generated various Analytics Reports like Formulary Report and Direct Sales Report using global and local filters.
  • Involved in modifications of physical, business and presentation layers of metadata repository using OBIEE Administration Tool.
  • Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
  • Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
  • Developed custom reports/Adhoc queries using OBIEE Answers and assigned them to application specific dashboards.
  • Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
  • Created proactive agents IBots and interactive Dashboards to alert the Marketing team about business changes.
  • Managed daytoday Rpd, Scheduler & IBots.
  • Managed security privileges for each subject area and dashboards according to user requirements.
  • Setting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository
  • Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
  • Involved in developing the Incremental ETL process by Informatica Mappings & Mapplets using various Transformations.

    Environment: OBIEE ..., Oracle BI Applications ..Finance Analytics, Sales Analytics, Informatica, DAC, Oracle g,g, PeopleSoft ,Siebel CRM, SQL Developer, SQL*Plus, Toad, WindowsXP. 

    J.P Morgan Chase, NY                                                    Jan ‘ –Feb’

    OBIEE Consultant                                                  

    The Finance department categorizes customers based on a significant set of portfolio services that includes checking accounts, savings accounts, and personal loans. The project was aimed at building an Investment Data Warehouse, which provides Financial Statement, Capital Gain Analysis, Performance, Measurement analysis.



  • Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.
  • Identified & Created Facts, Dimensions, and Hierarchies of the business model.
  • Developed Segment Value Detail, Work Order Detail and OGA Repositories RPD by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
  • Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
  • Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Adhoc report according to the client needs.
  • Configured Interactive Dashboard with drilldown capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
  • Applied Cascading Prompts and Multi Level Prompts on Dashboards.
  • Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
  • Developed different kinds of reports pivots, charts, tabular using global and local Filters.
  • Wrote Custom SQL Codes for the reports.
  • Applied Optimization Techniques for the better performance of the reports.
  • Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.
  • Used external tables to Transform and Load data from Flat files into target tables.
  • Used Debugger to validate Mappings by creating break points to analyze and monitor       Data flow.
  • Involved in troubleshooting the load failure cases, including database problems.
  • Implemented Security by authenticating against the LDAP and external table.
  • Trained End Users and Pilot Users about OBIEE Tools.
  • Responsible for developing, support and maintenance of the ETL Extract, Transform and Load processes using Informatica Power Center.

    Environment: OBIEE .../..., Oracle BI Applications .. Financial analytics, HR analytics, Informatica.., DAC, Oracle g, Oracle EBS, SQL Developer, SQL*Plus, WindowsXP. 

    Hindustan Medical Devices, India                                              Jan’Dec’

    Siebel Developer

    Hindustan Medical Devices is the largest Pharmaceutical products company in India. The Administrative system deals with the overall functions of the accounts department right from the initial input of the transaction to the final presentation of the financial statements. The system was built to transport data from these source systems into one integrated data warehouse, which would allow for storage and reporting. 


    Not Enough Credits
    Sorry, but you don't have enough credits to download this resume.

    Purchase more credits
    Not Available
    Sorry but this resume is not available for download. Please choose another!

    Confirm Download

    Would you like to download  for 1 credit?

    You have  credits left.

    Yes No 

    Don't ask me again
    Confirm View Complete Resume

    Would you like to view  for 1 credit?

    You have  credits left.

    Yes No 

    Don't ask me again