Friday, 3 February 2017

MSBI RESUME CONTENT-PROFESSIONAL SUMMARY & PROJECT RESPONSIBILITIES

PROFESSIONAL SUMMARY

=========================================================================

--  FOR MORE AND LATEST PLEASE CONTACT VINAY SIR ---------------- 

1.    Analyze and discuss the adaptations (client requirement) prepared by the functional team. Clarifications and conclusions follow.

2.      Work on various Business and Technical documents (Business Map, Business Change , Unit Testcase ,High level etc...)     

3    Focused on Truncate & Load ,Incremental (includes SCD) and Change Data Capture Loading by using various Packages.

4.      Experienced in creating simple, medium and complex packages by using normal and Fast load options

5.      Working with Loop containers to continually repeat operations,Seqence container for transactional operations.

6.      Extensively worked on Data Flow task various sources,transforms(Derived,Lookup,Conditional Split,Sort,Merge ectc...) and destinations.

6.      Used Execute SQL task,Script task and Execute Package task when required.

7.      Implementing error handling ,branching,check point operation ,configurations and parameterization.

8.      Created simple ,Medium and complex reports based on Business Report Design documents.

9.      Using variables,parameters and various expressions to implement business logics.

10.     Using various visualizations such as Table,Matrix,Chart,List ,Indicator etc...

11.     Creating Drill Down , Drill through and Parameterized reports

8.      Participated in the bottlenecks elimination of various packages ,reports and implemented tuning standards.

6.     Experienced in writing queries by using SQL commands, keywords, functions, Sub Queries and  joins ,procedures etc...

9.      Reviewed & Tested packages and reports (Unit test ,Report test and Reconciliation).

11.      Maintained versioning in Version Tools such as  TFS ,Sharepoint Server etc...

12.      Acquired good knowledge on Data Warehousing and Data Model Fundamentals. 

13.      Attended trainings on MSBI2014 version. 

INDIVIDUAL PROJECT RESPONSIBILITIES

=======================================================================

--FOR MORE AND LATEST PLEASE CONTACT VINAY SIR-----
       •    As an Associate I involved in getting documents, understanding, analysing documents, creating packages and queries according to those.
•    In case of changes we follow CR document procedure of the client 
•    Different types of Data Loading (Direct, Incremental, SCD Type2  et...) implemented using packages and used configuration files.
•    Handled, reported errors in error tables and files.
        Using lookup ,derived, sort ,merge ,oledb command etc... transforms , various containers and tasks at control flow level.
•    Written SQL queries and delivered results as per the client requirement
•    Writing various queries (duplications, tops, aggregate operations etc...) as part of reconciliation and business logics Validation.
10.     Used Sql commands and queries to monitor ,reconciliate and manage packages.
•    Performance tuning of packages when necessary.
•    Adhoc and Unit testing for packages.

Sunday, 13 March 2016

BEST MSBI RESUME CONTENT & MSBI RESUME PREPARATION PROCESS




 
====================================================================
RESUME PREPERATION PROCESS                                                                                     
====================================================================
1. READ AND USE THE ABOVE CONTENT FORMAT
2. OBSERVE THE BELOW PROFESSIONAL SUMMARY
AND INDIVIDUAL PROJECT RESPONSIBILITIES
3. REFER TO THE RESUMES GIVEN AS SOFT COPY
DOCUMENTS AT THE INSTITUTION
(HOW MUCH YOU OBSERVE THAT MUCH YOU WILL GAIN)
4. PLACE ALL THE IMPORTANT POINTS AND INTERESTING
POINTS  IN THE RESUME FORMAT GIVEN ABOVE.
5. GET THAT MONITORED BY THE MENTOR
 

Friday, 22 January 2016

MSBI-MDX CLASS ROOM QUERIES

SELECT FROM [cb_Adventure Works DW2012]
---
SELECT [Measures].[Fact Internet Sales Count] ON COLUMNS
FROM [cb_Adventure Works DW2012]
---
SELECT
{
[Measures].[Sales Amount],
[Measures].[Tax Amt]
}
 ON 0
FROM [cb_Adventure Works DW2012]
----
WITH
MEMBER DIFF AS [Measures].[Sales Amount]-[Measures].[Tax Amt]
MEMBER CONTVAL AS 100
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt],DIFF,CONTVAL} ON 0
FROM [cb_Adventure Works DW2012]
----
WITH
MEMBER DIFF AS [Measures].[Sales Amount]-[Measures].[Tax Amt]
MEMBER CONTVAL AS 100
MEMBER PHONE_CNT AS COUNT([Dim Customer].[Email Address].CHILDREN)
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt],DIFF,CONTVAL,PHONE_CNT} ON 0
FROM [cb_Adventure Works DW2012]
---
/*
WITH
MEMBER DIFF AS [Measures].[Sales Amount]-[Measures].[Tax Amt]
MEMBER CONTVAL AS 100
MEMBER PHONE_CNT AS COUNT([Dim Customer].[Email Address].CHILDREN)
*/
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
[Dim Product].[Product Key] ON 1
FROM [cb_Adventure Works DW2012]
----

SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
[Dim Product].[Product Key].CHILDREN ON 1
FROM [cb_Adventure Works DW2012]
---

SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
NONEMPTY([Dim Product].[Product Key].CHILDREN) ON 1
FROM [cb_Adventure Works DW2012]
---

SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
NONEMPTY([Dim Product].[Product Key].MEMBERS) ON 1
FROM [cb_Adventure Works DW2012]
--

SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
ORDER(NONEMPTY([Dim Product].[Product Key].CHILDREN),
 [Measures].[Sales Amount],DESC)ON 1
FROM [cb_Adventure Works DW2012]
---
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
TOPCOUNT(ORDER(NONEMPTY([Dim Product].[Product Key].CHILDREN),
 [Measures].[Sales Amount],DESC),5)  ON 1
FROM [cb_Adventure Works DW2012]
----
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
HEAD(ORDER(NONEMPTY([Dim Product].[Product Key].CHILDREN),
 [Measures].[Sales Amount],DESC),5)  ON 1
FROM [cb_Adventure Works DW2012]
--
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
BOTTOMCOUNT(ORDER(NONEMPTY([Dim Product].[Product Key].CHILDREN),
 [Measures].[Sales Amount],DESC),5)  ON 1
FROM [cb_Adventure Works DW2012]
--
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
TAIL(ORDER(NONEMPTY([Dim Product].[Product Key].CHILDREN),
 [Measures].[Sales Amount],DESC),5)  ON 1
FROM [cb_Adventure Works DW2012]
--

SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
(
[Dim Product].[Product Key].CHILDREN,
[Dim Customer].[First Name].CHILDREN
)
 ON 1
FROM [cb_Adventure Works DW2012]
--
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
CROSSJOIN(
[Dim Product].[Product Key].CHILDREN,
[Dim Customer].[First Name].CHILDREN
)
 ON 1
FROM [cb_Adventure Works DW2012]
--
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
([Dim Product].[Product Key].CHILDREN) * ([Dim Customer].[First Name].CHILDREN)
)
 ON 1
FROM [cb_Adventure Works DW2012]
---

SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,
(
[Product].[Product Name].children,
[Date].[Calendar Year].children
)
 ON 1
FROM [Analysis Services Tutorial]
---
SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,
(
[Product].[Product Name].children,
[Date].[Calendar Year].&[2005]
)
 ON 1
FROM [Analysis Services Tutorial]
--
SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,
(
[Product].[Product Name].children,
{[Date].[Calendar Year].&[2005],[Date].[Calendar Year].&[2008]}
)
 ON 1
FROM [Analysis Services Tutorial]
---

SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,
(
[Product].[Product Name].children,
[Date].[Calendar Date].[Calendar Year].[2005]:[2008]
)
 ON 1
FROM [Analysis Services Tutorial]
---

SELECT
[Measures].[Internet Sales-Sales Amount] ON 0

FROM [Analysis Services Tutorial]
where (
[Product].[Product Name].children,
[Date].[Calendar Date].[Calendar Year].[2005]:[2008]
)
--

SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,

[Date].[Calendar Date].[Calendar Year].&[2005] on 1

FROM [Analysis Services Tutorial]
where [Date].[Calendar Date].[Calendar Year].&[2005]

--failed query
---------------------------------
SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,
[Product].[Product Name].firstchild on 1

FROM [Analysis Services Tutorial]

---
SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,
[Product].[Product Name].lastchild on 1

FROM [Analysis Services Tutorial]
---
SELECT [Measures].[Internet Sales-Sales Amount] ON 0,
FILTER([Product].[Model Name].MEMBERS,
VBA!INSTR(1,[Product].[Model Name].CURRENTmember.NAME,'Gloves')>0) ON 1
from [Analysis Services Tutorial]
---
SELECT [Measures].[Internet Sales-Sales Amount] ON 0,
 filter([Product].[Product Name].children,
 [Measures].[Internet Sales-Sales Amount]>90000) ON 1
from [Analysis Services Tutorial]
--