www.soltius.com technology partners Bangalore, Hyderabad : HR Analytics, ORacle BI-Informatica, OBIEE

[Admin]

soltius technology partners ( soltius.com )
http://www.soltius.com

Keywords: Oracle Bi Informatica OBIEE HR Analytics

Company Profile
Soltius Was founded and incorporated in 1995 in Indonesia and now has registered offices and operations in 12 countries, including the US. Soltius Technology Partners is a US based Limited Liability Company providing Outsourcing, Consulting and Workforce Augmentation Services. Soltius provides technology solutions in the areas of ERP End to End Solutions like SAP, Oracle, People Soft and Testing areas.
Soltius has 1440 Employees; 93 Dedicated QA Resources and in-depth experience and expertise in SAP (with 400+ employees engaged in SAP projects), and can leverage this to deliver efficient and effective solutions
Soltius has development centers in India and Indonesia.

Dvelopment Lead-HR Analytics, ORacle BI-Informatica,OBIEE, HR analytic
Experience:
5 - 10 Years
Location:
Bengaluru/Bangalore, Hyderabad / Secunderabad
Compensation:
Rupees 8,00,000 - 17,00,000
Education:
UG - Any Graduate - Any Specialization;Graduation Not Required

PG - Any PG Course - Any Specialization;Post Graduation Not Required
Industry Type:
IT-Software/ Software Services
Functional Area:
ERP, CRM
Posted Date:
19 Sep


Desired Candidate Profile
We are looking for candidtes whao re having min of 4 years and max. of 8 years into Oracle BI-Informatica, OBIEE(Seibel Analytics) and HR analytics.
Development Lead, HR Analytics
Responsibilities
-- Develop data integration architecture
-- Design and build data marts from information and data models
-- Design and build Reports from BRD
-- Design and build data interfaces from BRD
-- Design, develop, test Oracle BI & Informatica DW applications, including star schema data structures and extraction, transformation and load (ETL) processes
-- Analyze data accuracy/integrity and identify necessary actions to enhance accuracy/integrity of data
-- Develop metadata repository development, including development and implementation of a Global Business Metadata Repository, to ensure consistency and standards in data naming conventions, definitions, and corporate standards for formulas, calculations, and formats.
-- Develop and institutionalize standards for development and testing of HR Analytics solution.
-- Manage modification of canned reports to meet customer needs
-- Mentor/lead Developers/Tester thru implementation efforts
Proficiency
-- Strong understanding of dimensional and 3rd normal form data models SQL and PL/SQL programming skills
-- Ability to gather or review requirements and translate the requirements into effective management or operational reports/dashboards.
-- Strong understanding of BI/data warehousing concepts, methodologies and best practices.
-- Experience in OBIEE application design, build, test, experience including requirements gathering, ownership of metadata and dashboards/reports
-- Need good and strong BI Developer experience (hands-on)
-- Must have solid exposure working with BI tools.
-- Practical Experience in large RDMS
-- Practical Experience in Informatica
-- Strong spoken and written communications

Total Exp: 5-10 years
Rlevant Exp: 5-8 years.
JOinig Location:Hyderabad

Executive Name:
Sandeep.T

Address:
soltius technology partners
road no 3, banjara hills
Hyderabad,A.P.,INDIA 500034

Email Address:
Sandeep.T@us-soltius.net

Telephone:
91-040-23541923

[Guest]

RESUME
SAZID AHAMAD ARAB
E-mail id : sazid.arab AT gmail.com .
OBJECTIVE :
- Looking for a challenging career in Oracle Database as Oracle DBA and to work in an esteemed organization which would enhance my services and give value to the company and to get involved in challenging projects.

EDUCATIONAL QUALIFICATIONS
QUALIFICATION YEAR OF PASSING COLLEGE/SCHOOL UNIVERSITY/BOARD PERCENTAGE

B.E.(C.S) July,2009 B.L.D.E Engg college, Bijapur.
VTU Belgaum.
55.00

PUC 2004 SECAB College,
Bijapur. K.P.U.B
Bagalore.
62.66

S.S.L.C 2001 PDJ College, Bijapur. K.S.E.E.B
Bangalore.

73.12

COMPUTER SKILLS :

Programming Languages : C, C++, Java, Dot net.
Operating Systems : Windows - 98/2000/XP, LINUX.
Installations : VM Ware workstation, Daemon software.
Database : Oracle 9i/10G New Features, DBMS, MySql.

KEY SKILLS :
Knowledge of oracle database administration on windows platform.
Managing and creating Oracle database.
Knowledge of SQL & SQL*PLUS.
Knowledge of ER-diagram.



Responsibilities :

Managing and creating Oracle database.
Managing oracle storage structure.
Manual creation of database using oracle 9i/10g software on windows/Linux.
Creation of database using oracle universal installer (OUI), database configuration assistance (DBCA) and oracle managed files (OMF).
Creation of database using vmware work station on win/Linux using oracle 9i/10g software.
Creating recovery catalog database.
Creating or Configuring pfile or instance.
Changing parameters if required.
Performing Sql & Sql*Plus operations.
Managing user Accounts
Creating users and giving roles, privileges and disabling users.
Creating or altering tables, constraints, indexes, views and synonyms.
Performing insert/update/delete/drop/truncate operations on table.
Creating or altering tablespaces, data files and redo log files.
Regular checking of alert log file.
Knowledge of export & import, RMAN backup & recovery and user managed backup & recovery operations.
Multiplexing concept.
Putting database or instance in restricted session mode and killing user sessions.

COURSE & CERTIFICATION :
- Oracle DBA Course ( 7 months Training from Oracle DBA Expert & At System Domain).
- OCA Certified.
- OCP Certified.

PROJECT DETAILS :
- Project 1 : Pre-paid Energy Meter.
Semester : 8.
Team size : 3.

Description : "The aim of this project is to design a prepaid energy meter to monitor the consumption of electricity in domestic needs. The standard business model of electricity retailing involves the electricity company billing the customer for the amount of energy used in the previous month or quarter. In some countries, if the retailer believes that the customer may not pay the bill for what ever reason a prepayment meter may be installed. This requires the customer to make advance payment before using the electricity. If the available credit is exhausted then the supply of electricity is automatically cut off by a relay".
Language : VB .NET (Visual Studio 2005) and Oracle
Hardware required : Energy Meter.

ABOUT MYSELF :
1 I am Positive and Straight Forward Attitude.
2 I believe in honesty.
3 Languages known are English, Hindi, Kannada, and Urdu.
4 My hobbies include playing Football, Chess, Volleyball, Cricket, and Watching Movies.
DECLARATION :

I hereby declare that the above information given is correct and true to best of my knowledge.
Date :
Place : Bangalore Sazid Ahamad Arab.

[Guest]

BHAVYA.P
E-MAIL : bhavya.pooju03 AT gmail.com
A decisive and task oriented professional with over all 2.2 years of experience in OBIEE, Data Warehouse concepts like OLTP, OLAP, Star and Snowflake Schema. Good analytical, interpersonal skills and excellent work ethics. Have hands on experience on OBIEE Admin tool, Catalog manager, Answers and has strong urge to learn new tools/technologies (DW/BI tools/best practices), work on different industry verticals, to have an edge in this competitive world of IT.
Professional Summary
- 2.2 Years experience in OBIEE 10.1.3.4.
- Currently working as an Associate Consultant at Millennium TechnoSoft Ltd.
Summary
- In depth hands on knowledge of Oracle Business Intelligence Enterprise edition.
- Have a thorough understanding of Oracle Business Intelligence Enterprise Edition (OBIEE) Architecture and the role played by different OBIEE components like analytic server, web server, rpd, web cats, security, Dashboards, Reports, IBots and Scheduler.
- Expertise in designing OBIEE Analytics Repository with Aggregate Navigation, Dimension Hierarchies, and level based measures.
- Worked in OBIEE Delivers to create iBots for scheduling reports and also to pre seed cache.
- Expertise in designing and development of Dashboards, reports, Prompts in OBIEE.
- Worked in most of the Views available in OBIEE Answers for report development.
- Implemented Event polling to automatically purge cache.
- Expertise in implementing Data security using GROUP and UI security using WEBGROUPS in OBIEE.
Educational Qualification
- B.Tech from JNTU, Ananthapur with 67%.
Technical Skills
- Business Intelligence : Oracle Business Intelligence 10.1.3.4
- ETL Tool : Informatica
- RDBMS : Oracle 9i/10g
- Operating Systems : Windows98,NT,2000,XP
Professional Qualifications

- Attended Training in PL/SQL, Data Warehousing Concepts & OBIEE.
- Well versed with the Database and Data Warehouse concepts like OLTP, OLAP, Star and Snowflake Schemas, RDBMS, Multidimensional Modeling and ETL.
Project Profile :
#1 Project Title : Customer Relation Roster Reports
Client Skura Corporation
Role OBIEE Developer
Duration May 2010 to till date
Team Size 8
Environment & Technologies
( skill versions) Database
Related : OBIEE 10.1.3.4, Oracle 9i, PL/SQL
Operating
System : Windows 2000
Description :
Skura Corporation is a leading CRM and Analytics solutions provider for the Life Sciences Industry. We deliver and support professional consulting services and complimentary software products used by life sciences & medical departments. Skura is a global partner of life science & health with significant presence in the US, Canada, and across Europe and has an enviable reputation for maintaining a highly satisfied customer roster.
Responsibilities :
- Installation of all components of OBIEE including Oracle Presentation Services, Oracle BI Server etc.
- Modified Physical, Business Model and Presentation Layers of Repository with lot of custom logical calculated measures based on the requirement.
- Created Dimension Hierarchies in the BMM layer for Time.
- Implemented Initialization blocks to populate Session and repository variables which were used to default the reports for current year, current quarter, Current Month etc.
- Verified Data level security using GROUP and Web level security using WEBGROUPS
- Created Daily Revenue Dashboards with Prompts and Reports having multiple views like Table, Pivot Table, and Charts.
- Implemented a complex scenario to display the monthly values by between dates and MTD calculation in between date’s scenario.
- Implemented Time Series Function to Show MTD, QTD and YTD values in Report.
- Worked on IBOTS and Delivers to send alerts to the Managers.
- Enables Caching for want of better performance and implemented Event Pooling for Automatic Purging of Stale data.
#2 Project Title : Wireless Services Reports
Client TELUS
Role OBIEE Developer
Duration july 2009 to april 2010
Team Size 7
Environment & Technologies
( skill versions) Database
Related : OBIEE 10.1.3.3.2, Oracle 9i, PL/SQL
Operating
System : Windows 2000
Description :
TELUS is a leading national telecommunications company in Canada, with $9.7 billion of annual revenue and 12.1 million customer connections including 6.9 million wireless subscribers, 3.8 million wireline network access lines and 1.2 million Internet subscribers and 266,000 TELUS TV customers. TELUS provides a wide range of communications products and services including data, Internet protocol (IP), voice, entertainment and video. TELUS makes it clear and simple to upgrade to the latest greatest wireless device. TELUS Mobility is the wireless business unit of TELUS Corporation.
Responsibilities :
- Involved in Data Modeling of the Data warehouse using Star Schema based on the requirements.
- Developed Fact, Dimension tables. Also created aggregate tables for want of better performance.
- Created Physical, Business Model and Presentation Layers of Repository with lot of custom logical calculated measures based on the requirement.
- Created Dimension Hierarchies in the BMM layer for Time, product, Geography and Customer Dimension.
- Enabled Aggregate navigation in the Business model layer
- Implemented Initialization blocks to populate Session variables for creation of dynamic filters in the reports.
- Most of the Dashboards were built with Prompts and Reports having multiple views like Table, Pivot Table, Chart and Narrative based on requirement.
Strengths
- Quick adaptability to circumstances.
- Ability to motivate and blend in a team.
- Positive attitude.