RE: SQL Server Analysis (SSAS) – OLAP Cubes.

2015-03-06 Thread Jack
*send resumes to sk...@otsi-usa.com *

*SQL Server Analysis (SSAS) – OLAP Cubes.*

*Lees Summit, MO.*

*12 months contract +*


*GC & Citizens Preferred *

*Duties and Responsibilities:*

·   Design, develop, and scheduled deployment of mid-size to large
cubes

·   Provide production support and OLAP maintenance (optimize
performance, data integrity, capacity, reliability)

·   Review MDX from a logical and performance perspective and
rewrite from scratch, if necessary

·   Ability to meet deadlines in a fast paced environment required

·   Works independently and as a part of a team

·   Delivery of client focused products (data, reporting and
analytics). This includes working with the rest of the technology team to
plan product functionality and product releases and product support

·   Analyze business requirements and translates those into
scalable SSAS solutions

·   Interfaces with end-users who are utilizing PowerPivot,
PowerView, PerformancePoint, ReportBuilder, Visual Studio to generate
actionable data through dashboards, canned or ad-hoc reports and data
mining/analysis.

·   Installs/upgrades/configures SSAS servers, security, cube
refresh schedules, solution deployment, backing up and restoring SSAS
databases/cubes.

·   Works with management team to ensure data security and develop
automated, dynamic security implementation routines

·   Adheres to change management process to resolve application
defects or to implement development enhancements and deployments.

·   Meets with decision makers, subject matter experts,
developers/architects and end users to define business requirements and BI
goals.



*Experience*

·   Requires a Bachelor’s degree in Computer Systems or related
field, additional years of qualifying work experience or relevant technical
certification may be considered in lieu of education.

·   Requires five years of work experience in database
administration or systems development, that includes 3 years of MSAS
design, development, and deployment experience working with mid-size to
large cubes

·   Hands-on experience with OLAP tuning and partitioning

·   Must have experience with physical implementation of moderately
complex logical OLAP designs.

·   Excellent understanding of OLAP best practices

·   Strong analytical skills

·   Advanced MDX and DAX

·   Familiarity with fundamental data warehousing concepts





*Kind Regards*



*Soumya Kota*

|Object Technology Solutions, Inc. (OTSI) | 6363 College Blvd., Suite 230 |
Overland Park, Kansas 66211

Office: 913-345-9080 Ext 317 | Fax: 913-273-0012 | | sk...@otsi-usa.com

-- 
You received this message because you are subscribed to the Google Groups 
"oraapps" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to oraapps+unsubscr...@googlegroups.com.
To post to this group, send email to oraapps@googlegroups.com.
Visit this group at http://groups.google.com/group/oraapps.
For more options, visit https://groups.google.com/d/optout.


RE: SQL Server Analysis (SSAS) – OLAP Cubes.

2015-03-09 Thread Jack
*send resumes to sk...@otsi-usa.com *

*ONLY GC & Citizens*



*SQL Server Analysis (SSAS) – OLAP Cubes.*

*Location: Lees Summit, MO.*

*Duration: 12 months +*



*Duties and Responsibilities:*

·   Design, develop, and scheduled deployment of mid-size to large
cubes

·   Provide production support and OLAP maintenance (optimize
performance, data integrity, capacity, reliability)

·   Review MDX from a logical and performance perspective and
rewrite from scratch, if necessary

·   Ability to meet deadlines in a fast paced environment required

·   Works independently and as a part of a team

·   Delivery of client focused products (data, reporting and
analytics). This includes working with the rest of the technology team to
plan product functionality and product releases and product support

·   Analyze business requirements and translates those into
scalable SSAS solutions

·   Interfaces with end-users who are utilizing PowerPivot,
PowerView, PerformancePoint, ReportBuilder, Visual Studio to generate
actionable data through dashboards, canned or ad-hoc reports and data
mining/analysis.

·   Installs/upgrades/configures SSAS servers, security, cube
refresh schedules, solution deployment, backing up and restoring SSAS
databases/cubes.

·   Works with management team to ensure data security and develop
automated, dynamic security implementation routines

·   Adheres to change management process to resolve application
defects or to implement development enhancements and deployments.

·   Meets with decision makers, subject matter experts,
developers/architects and end users to define business requirements and BI
goals.



*Experience*

·   Requires a Bachelor’s degree in Computer Systems or related
field, additional years of qualifying work experience or relevant technical
certification may be considered in lieu of education.

·   Requires five years of work experience in database
administration or systems development, that includes 3 years of MSAS
design, development, and deployment experience working with mid-size to
large cubes

·   Hands-on experience with OLAP tuning and partitioning

·   Must have experience with physical implementation of moderately
complex logical OLAP designs.

·   Excellent understanding of OLAP best practices

·   Strong analytical skills

·   Advanced MDX and DAX

·   Familiarity with fundamental data warehousing concepts





*Kind Regards*



*Soumya Kota*

|Object Technology Solutions, Inc. (OTSI) | 6363 College Blvd., Suite 230 |
Overland Park, Kansas 66211

Office: 913-345-9080 Ext 317 | Fax: 913-273-0012 | | sk...@otsi-usa.com

-- 
You received this message because you are subscribed to the Google Groups 
"oraapps" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to oraapps+unsubscr...@googlegroups.com.
To post to this group, send email to oraapps@googlegroups.com.
Visit this group at http://groups.google.com/group/oraapps.
For more options, visit https://groups.google.com/d/optout.