Vijay B.

Vijay B.

MSBI DEVELOPER (SSRS/SSIS)& SQL Server 7 Years.....

, India

Experience: 7 Years

Vijay

MSBI DEVELOPER (SSRS/SSIS)& SQL Server 7 Years.....

102857 USD / Year

  • Immediate: Available

7 Years

Now you can Instantly Chat with Vijay!

About Me

·        Working in Agile methodologies and conducting standup meetings and collate deliverables.

·        Experience in Business Intelligence, Banking, Sales & Marketing,

·        Strong knowledge on SSIS/S...

·        Strong knowledge on SSIS/SSRS

·        Involved in Preparing POC in Power Bi.

·        Extensive knowledge on Tableau installation, maintenance of Tableau Servers on distributed environments.

·        Worked on different phases of data visualization development lifecycle, from gathering requirements to testing and implementation

·        Creating Workbooks by Importing data, Defining Relationships.

·        Created List, Cross Tab Reports with Quick Filters, Summarized Filters.

·        Created Bar Charts, water fall charts, Heat Maps, And Geographical Maps.

·        Strong knowledge on software development life cycle (SDLC).

·        Strong Experience OLAP and Reporting like Tableau.

·        Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.

·        Created Derived Columns to fulfil the User Requirements.

·        Created Parameters to reports be more User friendly to End Users.

·        Created Dynamic, Static Dashboards with Global Filters, Context Filters, Action Links.

·        Added Base lines, Trend Lines, Quick &Table Calculations, and Annotation’s.

·        Connecting multiple data source with Data Blending technique.

·        Formatting the Data by using Legends, Marks, Colours, Sizes, and Shapes.

·        Providing the Security while Publishing to the Tableau Server.

·        Involved in design phase of BI projects.

·        Strong business and application analysis skills with excellent communication and professional skills.

·        Experience in analysis of source systems, defining underlying data sources and

transformation requirements, design suitable data model

·        Experience in interacting and requirement gathering from IT division on client side.

·        Experience in conducting knowledge sharing sessions within company environment.

·        Involved in design phase of BI projects.

·        Creating the Dashboards in Tableau for the data representation in the form of dashboards for stake holders.

·        Scheduling the data refresh in the Tableau server  once the data source systems are populated with the data.

Show More

Portfolio Projects

DATABASE & ETL & DASHBOARD DEVELOPER

Contribute

Only one for entire Technology working whole for ETL & DASHBOARD DEVELOPMENT

Description

· Working in Agile methodologies and conducting standup meetings and collate deliverables.

· Experience in Business Intelligence, Banking, Sales & Marketing,

· Strong knowledge on SSIS/SSRS

· Involved in Preparing POC in Power Bi.

· Extensive knowledge on Tableau installation, maintenance of Tableau Servers on distributed environments.

· Worked on different phases of data visualization development lifecycle, from gathering requirements to testing and implementation

· Creating Workbooks by Importing data, Defining Relationships.

· Created List, Cross Tab Reports with Quick Filters, Summarized Filters.

· Created Bar Charts, water fall charts, Heat Maps, And Geographical Maps.

· Strong knowledge on software development life cycle (SDLC).

· Strong Experience OLAP and Reporting like Tableau.

· Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.

· Created Derived Columns to fulfil the User Requirements.

· Created Parameters to reports be more User friendly to End Users.

· Created Dynamic, Static Dashboards with Global Filters, Context Filters, Action Links.

· Added Base lines, Trend Lines, Quick &Table Calculations, and Annotation’s.

· Connecting multiple data source with Data Blending technique.

· Formatting the Data by using Legends, Marks, Colours, Sizes, and Shapes.

· Providing the Security while Publishing to the Tableau Server.

· Involved in design phase of BI projects.

· Strong business and application analysis skills with excellent communication and professional skills.

· Experience in analysis of source systems, defining underlying data sources and

transformation requirements, design suitable data model

· Experience in interacting and requirement gathering from IT division on client side.

· Experience in conducting knowledge sharing sessions within company environment.

· Involved in design phase of BI projects.

· Creating the Dashboards in Tableau for the data representation in the form of dashboards for stake holders.

· Scheduling the data refresh in the Tableau server once the data source systems are populated with the data.

Show More Show Less

PETRONAS, short for Petroliam Nasional Berhad (National Petroleum, Limited)

Contribute

 Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS  Solution design and implementation  Working on Data Analytics  Creation of ETL jobs  Testing of ETL jobs

Description

Ø Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS

Ø Solution design and implementation

Ø Working on Data Analytics

Ø Creation of ETL jobs

Ø Testing of ETL jobs

Ø Working on and creating ETL packages to load the data

Ø Designing and implementing of ETL Transformations with SSIS.

Ø Review test scenarios for UT, SIT,UAT and Production and Support team on defect analysis and resolution.

Ø Integration and Analysis of data.

Ø Designed SSIS ETL Packages for extracting data from heterogeneous source systems, transform and finally load into the Target Tables.

Ø The packages created included a variety of transformations, for Execute SQL Task, Lookup, Aggregate, Derived Column, Conditional Split and Data Conversion.

Ø Expertise in providing Logging, Error handling by using Event Handler, for SSIS packages.

Ø Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS

Ø Solution design and implementation

Ø Working on Data Analytics

Ø Creation of ETL jobs

Ø Testing of ETL jobs

Ø Working on and creating ETL packages to load the data

Ø Designing and implementing of ETL Transformations with SSIS.

Ø Review test scenarios for UT, SIT,UAT and Production and Support team on defect analysis and resolution.

Ø Integration and Analysis of data.

Ø Designed SSIS ETL Packages for extracting data from heterogeneous source systems, transform and finally load into the Target Tables.

Ø The packages created included a variety of transformations, for Execute SQL Task, Lookup, Aggregate, Derived Column, Conditional Split and Data Conversion.

Ø Expertise in providing Logging, Error handling by using Event Handler, for SSIS packages.

Show More Show Less

 Building, publishing customized interactive reports and dashboards, report sch

Description

Ø Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Ø Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Ø Created action filters, parameters and calculated sets for preparing dashboards and Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Ø Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Ø Integration and Analysis of data.

Ø Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.

Show More Show Less