Input your fixed/hourly price in this field.
Freelancers
freelancer
Srujan G
0.0/5 (0 Feedback)
Member since March 24, 2021

1

  • $1.00 / hr
  • NC
  • Save

About 8 years of software professional experience using various programming languages, development tools, application packages on various platforms and in various fields like Data Modeling, Data Analysis, Database Applications, Implementation of Datawarehousing and Business Intelligence in providing solutions for Decision Support Systems(DSS) and OLAP application development in Windows and UNIX platforms. Successfully implemented several OBIEE Stand alone projects at several clients. Extensive experience in installation and configuration of OBIEE Application and Web Serves on the Servers. Extensive experience in configuring Single-Sign-On (SSO), OBIEE Clustered Environment, OBIEE Delivers (iBots), Multi User Development environment (MUD), Upgrading OBIEE 10g to OBIEE 11g. Experience in Siebel Analytics Server, Siebel Analytics Web, Siebel Answers, Siebel Delivers (iBots), Business Intelligence Dashboards and Reports. Experience in OBIEE Analytics Server, OBIEE Analytics Web, OBIEE Answers, OBIEE Delivers (iBots), OBIEE Dashboards and Reports. Implemented the Data Level Security and Dashboard Level Security for the all users depending on their access level. Extensive experience in creating Connection Pools, Alias Tables, Physical Foreign Keys, Logical Table Sources, Aggregators, Fragmentation content, Logical Joins, Complex Joins, several Logical Columns, Hierarchies, Preferred Hierarchies, set up Keys for hierarchical Drill-Down, Repository Variables, Session Variables in the Repository and developed the metadata at three layers namely Physical, Business Modeling and Mapping Layer (Logical Layer) and Presentation Layer. Expertise in designing the Data models for Analytical platforms using OBIEE Presentation, Business Logical and Physical Modeling Layers. Extensive experience in Query Caching/Purging, Write-Back capability, Guided Navigation, Drill Down, Dimensional Hierarchies. Expertise in Dimensional Data Modeling using Star Schema and Snow Flake Schema. Configured OBIEE presentation layer with reporting capabilities like Visual Analysis, Drill-down, Ad-hoc, Multi-Dimensional, Slice & Dice, Alerts, Graphs and Guided Analytics. Extensive experience in creating various reports using the Table, Pivot Table, Chart, Pie-Chart, Line Chart, Line-Bar Combo Chart, Horizontal and Vertical Bar charts, Dial, Bar and Bulb Gauge reports, View Selector, Column Selector, Legend, Narrative, Static text, No Results views. Created several Dashboards prompts to constraint on the columns and to use the Repository variables and static text. Implemented the Dashboard levels security and used the guided navigation feature to restrict the access to the Dashboard reports based on the user credentials. Experience in Informatica (Data warehousing ETL experience using Informatica PowerCenter 8.1/8.5/8.6, Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Designer, Warehouse Designer, Repository Manager and Server Manager). Having extensive experience in deploying huge Datawarehouses with Terabytes of data. Worked extensively on Oracle Client/Server Application tools and RDBMS. Excellent in Supporting Business Application in Production Environment. Expertise in working with Databases like Oracle11g, Oracle 10g, Oracle9i, MS SQL Server 7.0. Sound knowledge in DML (Data Manipulation Language), SQL, PL/SQL Stored Procedures/Functions, Triggers and Packages. Proficient in using TOAD for testing and validation of data before reporting to end-users. Extensive knowledge of Datawarehousing methodologies, Data Extraction, Transformation and Loading. Well experienced in Database Development like developing/creating Stored Procedures, Packages, Functions, Table creation scripts & Database Triggers, Synonyms, Indexes, Views, Materialized Views. Experienced in application fine-tuning & Database fine-tuning using Explain Plan and analysis tools, Monitor performance and identify bottlenecks and System Tuning. Implement Type I, II changes in slowly changing dimension tables. Expertise in setting up UNIX cron jobs using crontab in UNIX. Proven experience with reading and writing Shell Scripts (ksh). Ability to navigate, edit/find files, check disk space and transfer files. Knowledge of performance monitoring tools in the UNIX environment. SKILL SET OS: UNIX/LINUX, Windows 95/98/XP/2000/2003, MS/DOS, NT Hardware: IBM PC and Compatibles, NetWare based Work Stations. Database: Oracle Exadata/11g/10g/9i, MS-Access 97/2000. Languages: SQL, Oracle PL/SQL. ETL Tools: Informatica (Power Center 6.2/7.1/8.1/8.5/9.1), Oracle Warehouse Builder 10g Release 2 (OWB). Reporting: OBIEE 11.1.1.7/10.1.3.4.2, Siebel 7.x Analytics Business Objects. Toolkit: SQL Loader, SQL Navigator, Toad, Telegence, PLSQL Developer, Jdev. Front-end: Developer 2000 (Forms 9i, Reports 9i), CSS, JavaScript’s, Power Builder. Internet: HTML, Java Scripts. Others: TOAD, MS Project Manager, CARS Chargebacks, PlanView, MS Visio2000, MS- VSS, WinCVS, Rational Rose, Clear Quest, Requisite Pro, STORMS, iScheduler.

0

Ongoing projects

0

Completed projects

0

Cancelled projects

3

Ongoing services

0

Completed services

0

Cancelled services

$0.00

Total earnings

* Click the button to send an offer

Send offer